Wednesday 28 March 2012

Function to get BankName by passing check id as parameter in 11.5.10.2

CREATE OR REPLACE FUNCTION getbank(cheque_id IN NUMBER) RETURN VARCHAR2 IS
m_bank_name VARCHAR2(250);
BEGIN

    SELECT abb.bank_name
      INTO m_bank_name
      FROM ap_checks_all aca, ap_bank_accounts_all abaa, ap_bank_branches abb
     WHERE aca.BANK_ACCOUNT_ID = abaa.BANK_ACCOUNT_ID
       AND abaa.BANK_BRANCH_ID = abb.BANK_BRANCH_ID
       AND aca.check_id = cheque_id;
   
    RETURN m_bank_name;
EXCEPTION
    WHEN others THEN
         RETURN NULL;

END;
/

No comments:

Post a Comment