APPS.IBY_AR_UTILS dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 708: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

704:
705: END get_line_tax_rate;
706:
707: FUNCTION get_trxn_ref_number2
708: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
709: RETURN VARCHAR2
710: IS
711: l_trxn_ref_number2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
712: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_trxn_ref_number2';

Line 711: l_trxn_ref_number2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;

707: FUNCTION get_trxn_ref_number2
708: (p_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
709: RETURN VARCHAR2
710: IS
711: l_trxn_ref_number2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
712: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_trxn_ref_number2';
713:
714: CURSOR c_trxn_ref_number2
715: (ci_trxn_ext_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

Line 715: (ci_trxn_ext_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

711: l_trxn_ref_number2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
712: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_trxn_ref_number2';
713:
714: CURSOR c_trxn_ref_number2
715: (ci_trxn_ext_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
716: IS
717: SELECT tx.trxn_ref_number2
718: FROM iby_fndcpt_tx_extensions tx
719: WHERE

Line 718: FROM iby_fndcpt_tx_extensions tx

714: CURSOR c_trxn_ref_number2
715: (ci_trxn_ext_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
716: IS
717: SELECT tx.trxn_ref_number2
718: FROM iby_fndcpt_tx_extensions tx
719: WHERE
720: tx.trxn_extension_id = ci_trxn_ext_id
721: AND tx.trxn_ref_number1 = 'RECEIPT';
722: BEGIN

Line 753: CURSOR c_auth_status(c_extension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)

749: x_auth_flag OUT NOCOPY VARCHAR2)
750: IS
751: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_authorization_status';
752:
753: CURSOR c_auth_status(c_extension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
754: IS
755: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
756: FROM iby_trxn_summaries_all summ
757: , iby_fndcpt_tx_operations op