Friday, May 27, 2011
Below script helps you to check existence of an Internal Bank in Oracle Apps R12.
Test Instance: R12.1.1
SET SERVEROUTPUT ON;
p_country_code VARCHAR2 (200);
p_bank_name VARCHAR2 (200);
p_bank_number VARCHAR2 (200);
p_country_code := 'US';
p_bank_name := 'Test Bank';
p_bank_number := 14258;
ce_bank_pub.check_bank_exist (p_country_code => p_country_code,
p_bank_name => p_bank_name,
p_bank_number => p_bank_number,
x_bank_id => x_bank_id,
x_end_date => x_end_date
DBMS_OUTPUT.put_line ( 'BANK_ID/PARTY_ID = '
|| NVL (TO_CHAR (x_bank_id), 'NOT EXISTS')
DBMS_OUTPUT.put_line ( 'END_DATE = '
|| NVL (TO_CHAR (x_end_date), 'NOT EXISTS')
API to Create a Internal Bank Account:
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.