Friday, May 27, 2011
API to Check Existence of an Internal Bank R12 (CE_BANK_PUB.CHECK_BANK_EXIST)
Below script helps you to check existence of an Internal Bank in Oracle Apps R12.
Test Instance: R12.1.1
Script:
SET SERVEROUTPUT ON;
DECLARE
p_country_code VARCHAR2 (200);
p_bank_name VARCHAR2 (200);
p_bank_number VARCHAR2 (200);
x_bank_id NUMBER;
x_end_date DATE;
BEGIN
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')
);
END;
API to Create a Internal Bank Account:
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “API to Check Existence of an Internal Bank R12 (CE_BANK_PUB.CHECK_BANK_EXIST)”
Post a Comment