<\/p>\n
DECLARE<\/span> <\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":" DECLAREl_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\u00a0 fnd_global.apps_initialize (1318,50559,222); \u00a0— user ID, responsibility ID, application ID\u00a0\u00a0 mo_global.set_policy_context(‘S’, 204); — Vision Operations (USA)\u00a0\u00a0… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,56],"tags":[],"class_list":["post-6616","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-oracle"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6616"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6616\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;<\/span>
l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;<\/span>
l_profile_id NUMBER;<\/span>
l_return_status VARCHAR2(10);<\/span>
l_msg_count NUMBER;<\/span>
l_msg_data VARCHAR2(2400);<\/span>
l_party_obj_version NUMBER := 2;<\/span>
BEGIN<\/span>
\u00a0 fnd_global.apps_initialize (1318,50559,222); \u00a0— user ID, responsibility ID, application ID<\/span>
\u00a0<\/span>
\u00a0 mo_global.set_policy_context(‘S’, 204); — Vision Operations (USA)<\/span>
\u00a0<\/span>
\u00a0 mo_global.init (‘AR’);<\/span>
l_party_rec.party_id := 1000;<\/span>
l_organization_rec.organization_name := ‘World of Business INC’;<\/span>
l_organization_rec.known_as := null;<\/span>
l_organization_rec.organization_name_phonetic := null;<\/span>
l_organization_rec.party_rec := l_party_rec;<\/span>
HZ_PARTY_V2PUB.update_organization (p_init_msg_list => FND_API.G_FALSE,<\/span>
p_organization_rec => l_organization_rec,<\/span>
p_party_object_version_number => l_party_obj_version,<\/span>
x_profile_id => l_profile_id,<\/span>
x_return_status => l_return_status,<\/span>
x_msg_count => l_msg_count,<\/span>
x_msg_data => l_msg_data);<\/span>
DBMS_OUTPUT.put_line(‘Status of the api call’||l_return_status);<\/span>
COMMIT;<\/span>
EXCEPTION<\/span>
WHEN OTHERS THEN<\/span>
DBMS_OUTPUT.PUT_LINE(‘Error ‘||SQLERRM);<\/span>
ROLLBACK;<\/span>
END;<\/span>
\/<\/span><\/p>\n