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 691: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

687: l_instr_type iby_fndcpt_payer_assgn_instr_v.instrument_type%TYPE;
688: l_instr_id iby_fndcpt_payer_assgn_instr_v.instrument_id%TYPE;
689: l_info_only iby_fndcpt_payer_assgn_instr_v.card_info_only_flag%TYPE;
690: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
691: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
692:
693: CURSOR c_instr_assigns
694: (ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
695: ci_payer_level IN VARCHAR2,

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

715: cust_account_id,acct_site_use_id) = 'T')
716: );
717:
718: CURSOR c_instr_extensions
719: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
720: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE
721: )
722: IS
723: SELECT NVL(authorized_flag,'N')

Line 720: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE

716: );
717:
718: CURSOR c_instr_extensions
719: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
720: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE
721: )
722: IS
723: SELECT NVL(authorized_flag,'N')
724: FROM iby_trxn_extensions_v

Line 724: FROM iby_trxn_extensions_v

720: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE
721: )
722: IS
723: SELECT NVL(authorized_flag,'N')
724: FROM iby_trxn_extensions_v
725: WHERE (instrument_id = ci_instr_id)
726: AND (instrument_type = ci_instr_type);
727:
728: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Payer_InstrAssignment_Valid';

Line 787: FROM iby_trxn_extensions_v

783: CURSOR c_operation
784: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
785: IS
786: SELECT count(1)
787: FROM iby_trxn_extensions_v
788: WHERE (trxn_extension_id = ci_extension_id)
789: AND (authorization_status IN ( 'AUTH_SUCCESS', 'AUTH_PENDING' ));
790: BEGIN
791: IF (c_operation%ISOPEN) THEN CLOSE c_operation; END IF;

Line 2301: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

2297: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
2298: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2299:
2300: l_copy_count NUMBER;
2301: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2302: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2303: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
2304:
2305: l_ecapp_id NUMBER;

Line 2302: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

2298: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2299:
2300: l_copy_count NUMBER;
2301: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2302: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2303: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
2304:
2305: l_ecapp_id NUMBER;
2306: l_app_short_name fnd_application.application_short_name%TYPE;

Line 2364: FROM iby_trxn_extensions_v

2360: CURSOR c_auth
2361: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
2362: IS
2363: SELECT authorized_flag
2364: FROM iby_trxn_extensions_v
2365: WHERE (trxn_extension_id = ci_extension_id);
2366:
2367: CURSOR c_instr_extensions
2368: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,

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

2364: FROM iby_trxn_extensions_v
2365: WHERE (trxn_extension_id = ci_extension_id);
2366:
2367: CURSOR c_instr_extensions
2368: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
2369: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE,
2370: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE
2371: )
2372: IS

Line 2369: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE,

2365: WHERE (trxn_extension_id = ci_extension_id);
2366:
2367: CURSOR c_instr_extensions
2368: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
2369: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE,
2370: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE
2371: )
2372: IS
2373: SELECT NVL(authorized_flag,'N')

Line 2370: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE

2366:
2367: CURSOR c_instr_extensions
2368: (ci_instr_type IN iby_trxn_extensions_v.instrument_type%TYPE,
2369: ci_instr_id IN iby_trxn_extensions_v.instrument_id%TYPE,
2370: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE
2371: )
2372: IS
2373: SELECT NVL(authorized_flag,'N')
2374: FROM iby_trxn_extensions_v

Line 2374: FROM iby_trxn_extensions_v

2370: ci_trxn_x_id IN iby_trxn_extensions_v.trxn_extension_id%TYPE
2371: )
2372: IS
2373: SELECT NVL(authorized_flag,'N')
2374: FROM iby_trxn_extensions_v
2375: WHERE (instrument_id = ci_instr_id)
2376: AND (instrument_type = ci_instr_type)
2377: AND (trxn_extension_id <> ci_trxn_x_id);
2378:

Line 4578: FROM iby_trxn_extensions_v x, iby_pmt_instr_uses_all i,

4574: x.instrument_type, x.instrument_id,
4575: x.origin_application_id, a.application_short_name,
4576: x.order_id, x.trxn_ref_number1, x.trxn_ref_number2,
4577: x.payment_channel_code
4578: FROM iby_trxn_extensions_v x, iby_pmt_instr_uses_all i,
4579: iby_external_payers_all p, fnd_application a
4580: WHERE (x.instr_assignment_id = i.instrument_payment_use_id)
4581: -- can assume this assignment is for funds capture
4582: AND (x.origin_application_id = a.application_id)