Tuesday, May 31, 2011
API to End Date an Internal Bank in R12 - CE_BANK_PUB.SET_BANK_END_DATE
Below script helps you to end date an Internal Bank in Oracle Apps R12.
Test Instance: R12.1.1
API: CE_BANK_PUB.SET_BANK_END_DATE
Script:
SET SERVEROUTPUT ON;
DECLARE
p_init_msg_list VARCHAR2 (200);
p_bank_id NUMBER;
p_end_date DATE;
p_object_version_number NUMBER;
x_return_status VARCHAR2 (200);
x_msg_count NUMBER;
x_msg_data VARCHAR2 (200);
BEGIN
p_init_msg_list := fnd_api.g_true;
p_bank_id := 119147;
p_end_date := SYSDATE + 360;
p_object_version_number := 1;
CE_BANK_PUB.SET_BANK_END_DATE
(p_init_msg_list => p_init_msg_list,
p_bank_id => p_bank_id,
p_end_date => p_end_date,
p_object_version_number => p_object_version_number,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
DBMS_OUTPUT.put_line ( 'P_OBJECT_VERSION_NUMBER = '
|| p_object_version_number
);
DBMS_OUTPUT.put_line ('X_RETURN_STATUS = ' || x_return_status);
DBMS_OUTPUT.put_line ('X_MSG_COUNT = ' || x_msg_count);
DBMS_OUTPUT.put_line ('X_MSG_DATA = ' || x_msg_data);
END;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
Disclaimer
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.
0 Responses to “API to End Date an Internal Bank in R12 - CE_BANK_PUB.SET_BANK_END_DATE”
Post a Comment