eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_TRXN_EXTENSIONS_V

Line 887: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

883: l_instr_type iby_fndcpt_payer_assgn_instr_v.instrument_type%TYPE;
884: l_instr_id iby_fndcpt_payer_assgn_instr_v.instrument_id%TYPE;
885: l_info_only iby_fndcpt_payer_assgn_instr_v.card_info_only_flag%TYPE;
886: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
887: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
888:
889: CURSOR c_instr_assigns
890: (ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
891: ci_payer_level IN VARCHAR2,

Line 915: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,

911: cust_account_id,acct_site_use_id) = 'T')
912: );
913:
914: CURSOR c_instr_extensions
915: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
916: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE
917: )
918: IS
919: SELECT NVL(authorized_flag,'N')

Line 916: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE

912: );
913:
914: CURSOR c_instr_extensions
915: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
916: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE
917: )
918: IS
919: SELECT NVL(authorized_flag,'N')
920: FROM iby_trxn_extensions_v

Line 920: FROM iby_trxn_extensions_v

916: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE
917: )
918: IS
919: SELECT NVL(authorized_flag,'N')
920: FROM iby_trxn_extensions_v
921: WHERE (instrument_id = ci_instr_id)
922: AND (instrument_type = ci_instr_type);
923:
924: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Payer_InstrAssignment_Valid';

Line 995: FROM iby_trxn_extensions_v

991: CURSOR c_operation
992: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
993: IS
994: SELECT count(1)
995: FROM iby_trxn_extensions_v
996: WHERE (trxn_extension_id = ci_extension_id)
997: AND (authorization_status IN ( 'AUTH_SUCCESS', 'AUTH_PENDING' ));
998:
999: BEGIN

Line 2808: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

2804: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
2805: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2806:
2807: l_copy_count NUMBER;
2808: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2809: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2810: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
2811:
2812: l_ecapp_id NUMBER;

Line 2809: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

2805: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2806:
2807: l_copy_count NUMBER;
2808: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2809: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2810: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
2811:
2812: l_ecapp_id NUMBER;
2813: l_app_short_name fnd_application.application_short_name%TYPE;

Line 2879: FROM iby_trxn_extensions_v

2875: /*CURSOR c_auth
2876: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
2877: IS
2878: SELECT authorized_flag
2879: FROM iby_trxn_extensions_v
2880: WHERE (trxn_extension_id = ci_extension_id); */
2881:
2882: --Bug# 16353469
2883: --Changed the cursor query to get the auth status from the base tables.

Line 2910: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,

2906: AND (a.trxntypeid IN (2,3,20))
2907: ORDER BY a.trxnmid desc;
2908:
2909: CURSOR c_instr_extensions
2910: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
2911: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE,
2912: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE
2913: )
2914: IS

Line 2911: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE,

2907: ORDER BY a.trxnmid desc;
2908:
2909: CURSOR c_instr_extensions
2910: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
2911: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE,
2912: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE
2913: )
2914: IS
2915: SELECT NVL(authorized_flag,'N')

Line 2912: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE

2908:
2909: CURSOR c_instr_extensions
2910: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
2911: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE,
2912: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE
2913: )
2914: IS
2915: SELECT NVL(authorized_flag,'N')
2916: FROM iby_trxn_extensions_v

Line 2916: FROM iby_trxn_extensions_v

2912: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE
2913: )
2914: IS
2915: SELECT NVL(authorized_flag,'N')
2916: FROM iby_trxn_extensions_v
2917: WHERE (instrument_id = ci_instr_id)
2918: AND (instrument_type = ci_instr_type)
2919: AND (trxn_extension_id <> ci_trxn_x_id);
2920:

Line 5657: FROM iby_trxn_extensions_v x,

5653: x.instrument_type, x.instrument_id,
5654: x.origin_application_id, a.application_short_name,
5655: x.order_id, x.trxn_ref_number1, x.trxn_ref_number2,
5656: x.payment_channel_code
5657: FROM iby_trxn_extensions_v x,
5658: iby_fndcpt_tx_extensions xt,
5659: -- iby_pmt_instr_uses_all i,
5660: iby_external_payers_all p,
5661: fnd_application a