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.1.1.

API USED: CE_BANK_PUB.CHECK_BRANCH_EXISTS

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;