HZ_PARTY_V2PUB.UPDATE_ORGANIZATION

DECLARE

l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
l_profile_id NUMBER;
l_return_status VARCHAR2(10);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2400);
l_party_obj_version NUMBER := 2;

BEGIN

  fnd_global.apps_initialize (1318,50559,222);  — user ID, responsibility ID, application ID
 
  mo_global.set_policy_context(‘S’, 204); — Vision Operations (USA)
 
  mo_global.init (‘AR’);

l_party_rec.party_id := 1000;

l_organization_rec.organization_name := ‘World of Business INC’;
l_organization_rec.known_as := null;
l_organization_rec.organization_name_phonetic := null;
l_organization_rec.party_rec := l_party_rec;
HZ_PARTY_V2PUB.update_organization (p_init_msg_list => FND_API.G_FALSE,
p_organization_rec => l_organization_rec,
p_party_object_version_number => l_party_obj_version,
x_profile_id => l_profile_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
DBMS_OUTPUT.put_line(‘Status of the api call’||l_return_status);

COMMIT;

EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(‘Error ‘||SQLERRM);
ROLLBACK;
END;
/