APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_TRXN_EXT_AUTHS_V

Line 2270: FROM iby_trxn_ext_auths_v x, iby_fndcpt_sys_eft_pf_b sp,

2266: CURSOR c_auths
2267: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
2268: IS
2269: SELECT NVL(sp.settle_require_vrfy_flag,'Y')
2270: FROM iby_trxn_ext_auths_v x, iby_fndcpt_sys_eft_pf_b sp,
2271: iby_fndcpt_user_eft_pf_b up
2272: WHERE (x.trxn_extension_id = ci_extension_id)
2273: AND (DECODE(x.instrument_type,
2274: IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_BANKACCT,x.process_profile_code,

Line 2829: l_auth_result iby_trxn_ext_auths_v.authorization_result_code%TYPE;

2825: l_riskinfo IBY_PAYMENT_ADAPTER_PUB.RiskInfo_rec_type;
2826: l_reqresp IBY_PAYMENT_ADAPTER_PUB.ReqResp_rec_type;
2827: l_status iby_trxn_summaries_all.status%TYPE;
2828: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;
2829: l_auth_result iby_trxn_ext_auths_v.authorization_result_code%TYPE;
2830: l_pson iby_fndcpt_tx_extensions.payment_system_order_number%TYPE;
2831: l_return_status VARCHAR2(1);
2832: l_msg_count NUMBER;
2833: l_msg_data VARCHAR2(300);

Line 3562: FROM iby_trxn_ext_auths_v

3558: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
3559: IS
3560: SELECT authorization_id, authorization_date, authorization_code,
3561: avs_code, instr_sec_code_check, pmt_sys_err_code, pmt_sys_err_msg
3562: FROM iby_trxn_ext_auths_v
3563: WHERE (trxn_extension_id = ci_extension_id)
3564: ORDER BY
3565: DECODE(authorization_result_code, 'AUTH_SUCCESS',10,
3566: 'AUTH_PENDING',5, 0) DESC;

Line 3844: FROM iby_trxn_ext_auths_v

3840: CURSOR c_auth
3841: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
3842: IS
3843: SELECT authorization_id
3844: FROM iby_trxn_ext_auths_v
3845: WHERE (trxn_extension_id = ci_extension_id)
3846: AND (authorization_status = 0);
3847:
3848: