API to End Date an Internal Bank in R12

Below script helps you to end date an Internal Bank in Oracle Apps R12.1.1.

API USED: CE_BANK_PUB.SET_BANK_END_DATE

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;
/