API Update payment method<\/p>\n
DECLARE<\/p>\n
x_return_status VARCHAR2 (200) := NULL;<\/p>\n
x_msg_count NUMBER := 0;<\/p>\n
x_msg_data VARCHAR2 (200) := NULL;<\/p>\n
l_payee_upd_status<\/p>\n
p_external_payee_tab_type<\/p>\n
p_ext_payee_id_tab_type<\/p>\n
p_ext_payee_id_rec<\/p>\n
iby_disbursement_setup_pub.ext_payee_update_tab_type;<\/p>\n
iby_disbursement_setup_pub.external_payee_tab_type ;<\/p>\n
iby_disbursement_setup_pub.ext_payee_id_tab_type;<\/p>\n
iby_disbursement_setup_pub.Ext_Payee_ID_Rec_Type;<\/p>\n
l_ext_payee_rec IBY_DISBURSEMENT_SETUP_PUB.External_Payee_Rec_Type ;<\/p>\n
i NUMBER := 0;<\/p>\n
BEGIN<\/p>\n
fnd_global.apps_initialize (1117,50697,200);<\/p>\n
mo_global.set_policy_context (‘S’, 81);<\/p>\n
FOR j IN (SELECT iepa.ext_payee_id<\/p>\n
,iepa.supplier_site_id<\/p>\n
, iepa.payee_party_id<\/p>\n
, apss.party_site_id<\/p>\n
FROM ap_suppliers aps<\/p>\n
,ap_supplier_sites_all apss<\/p>\n
,iby_external_payees_all iepa<\/p>\n
WHERE aps.vendor_id = apss.vendor_id<\/p>\n
AND iepa.supplier_site_id = apss.vendor_site_id<\/p>\n
AND iepa.default_payment_method_code = ‘EFT’<\/p>\n
AND NOT EXISTS ( SELECT 1<\/p>\n
FROM ap_supplier_sites_all assa,<\/p>\n
hz_parties hp,<\/p>\n
iby_ext_bank_accounts ieba,<\/p>\n
iby_external_payees_all iepa,<\/p>\n
iby_pmt_instr_uses_all ipiua,<\/p>\n
hz_parties hp1<\/p>\n
WHERE assa.vendor_site_id = iepa.supplier_site_id<\/p>\n
AND hp.party_id = ieba.bank_id<\/p>\n
AND ipiua.instrument_id = ieba.ext_bank_account_id<\/p>\n
AND ipiua.ext_pmt_party_id = iepa.ext_payee_id<\/p>\n
AND assa.vendor_id = apss.vendor_id<\/p>\n
AND ieba.branch_id = hp1.party_id<\/p>\n
AND ipiua.instrument_type = ‘BANKACCOUNT’<\/p>\n
AND ipiua.payment_flow = ‘DISBURSEMENTS’)<\/p>\n
ORDER BY aps.segment1)<\/p>\n
LOOP<\/p>\n
p_external_payee_tab_type (i).default_pmt_method := ‘CHECK’;<\/p>\n
p_external_payee_tab_type (i).payment_function := ‘PAYABLES_DISB’;<\/p>\n
p_external_payee_tab_type (i).exclusive_pay_flag := ‘N’;<\/p>\n
p_external_payee_tab_type (i).payee_party_id := j.payee_party_id;<\/p>\n
p_external_payee_tab_type (i).payer_org_id := 81;<\/p>\n
p_external_payee_tab_type (i).payer_org_type := ‘OPERATING_UNIT’;<\/p>\n
p_external_payee_tab_type (i).supplier_site_id := j.supplier_site_id;<\/p>\n
p_external_payee_tab_type (i).Payee_Party_Site_Id := j.party_site_id;<\/p>\n
p_ext_payee_id_tab_type (i).ext_payee_id := j.ext_payee_id;<\/p>\n
iby_disbursement_setup_pub.update_external_payee(p_api_version => 1.0,<\/p>\n
p_init_msg_list => ‘T’,<\/p>\n
p_ext_payee_tab => p_external_payee_tab_type,<\/p>\n
p_ext_payee_id_tab => p_ext_payee_id_tab_type,<\/p>\n
x_return_status => x_return_status,<\/p>\n
x_msg_count => x_msg_count,<\/p>\n
x_msg_data => x_msg_data,<\/p>\n
x_ext_payee_status_tab => l_payee_upd_status<\/p>\n
);<\/p>\n
COMMIT;<\/p>\n
DBMS_OUTPUT.PUT_LINE(‘External Payee Update :’||j.ext_payee_id);<\/p>\n
DBMS_OUTPUT.PUT_LINE(‘x_return_status: ‘||x_return_status);<\/p>\n
IF x_return_status = ‘E’ THEN<\/p>\n
FOR k IN l_payee_upd_status.FIRST .. l_payee_upd_status.LAST<\/p>\n
LOOP<\/p>\n
DBMS_OUTPUT.put_line (‘Error Message from table type : ‘|| l_payee_upd_status (k).Payee_update_Msg);<\/p>\n
END LOOP;<\/p>\n
END IF;<\/p>\n
i := 0;<\/p>\n
END LOOP;<\/p>\n
EXCEPTION<\/p>\n
WHEN OTHERS THEN<\/p>\n
DBMS_OUTPUT.PUT_LINE(‘Error ‘ ||SQLERRM);<\/p>\n
END;<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
API Update payment method DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; l_payee_upd_status p_external_payee_tab_type p_ext_payee_id_tab_type p_ext_payee_id_rec iby_disbursement_setup_pub.ext_payee_update_tab_type; iby_disbursement_setup_pub.external_payee_tab_type… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,110,56],"tags":[116,117],"class_list":["post-6845","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-estudo-e-pesquisa","category-oracle","tag-api","tag-oracle-ap"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6845","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=6845"}],"version-history":[{"count":1,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6845\/revisions"}],"predecessor-version":[{"id":6846,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6845\/revisions\/6846"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}