Tuesday, May 31, 2011
CE_BANK_PUB.CHECK_BRANCH_EXISTS - API to check existence of an Internal Bank Branch in R12
Below script helps you to check existence of an Internal Bank branch Oracle Apps R12.
Test Instance: R12.1.1
Script:
SET SERVEROUTPUT ON;
DECLARE
p_bank_id NUMBER;
p_branch_name VARCHAR2 (200);
p_branch_number VARCHAR2 (200);
x_branch_id NUMBER;
x_end_date DATE;
BEGIN
p_bank_id := 1245;
p_branch_name := 'Test Branch';
p_branch_number := '1452789';
CE_BANK_PUB.CHECK_BRANCH_EXIST
(p_bank_id => p_bank_id,
p_branch_name => p_branch_name,
p_branch_number => p_branch_number,
x_branch_id => x_branch_id,
x_end_date => x_end_date
);
DBMS_OUTPUT.put_line ('X_BRANCH_ID = ' || x_branch_id);
DBMS_OUTPUT.put_line ('X_END_DATE = ' || x_end_date);
END;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “CE_BANK_PUB.CHECK_BRANCH_EXISTS - API to check existence of an Internal Bank Branch in R12”
Post a Comment