Tuesday, May 31, 2011
Below script helps you to check existence of an Internal Bank branch Oracle Apps R12.
Test Instance: R12.1.1
SET SERVEROUTPUT ON;
p_branch_name VARCHAR2 (200);
p_branch_number VARCHAR2 (200);
p_bank_id := 1245;
p_branch_name := 'Test Branch';
p_branch_number := '1452789';
(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);
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.