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_FNDCPT_PAYER_ASSGN_INSTR_V

Line 687: l_instr_type iby_fndcpt_payer_assgn_instr_v.instrument_type%TYPE;

683: RETURN BOOLEAN
684: IS
685: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
686: l_instr_req iby_pmt_mthd_attrib_appl.attribute_applicability%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;

Line 688: l_instr_id iby_fndcpt_payer_assgn_instr_v.instrument_id%TYPE;

684: IS
685: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
686: l_instr_req iby_pmt_mthd_attrib_appl.attribute_applicability%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:

Line 689: l_info_only iby_fndcpt_payer_assgn_instr_v.card_info_only_flag%TYPE;

685: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
686: l_instr_req iby_pmt_mthd_attrib_appl.attribute_applicability%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

Line 690: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;

686: l_instr_req iby_pmt_mthd_attrib_appl.attribute_applicability%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,

Line 697: ci_instr_assign IN iby_fndcpt_payer_assgn_instr_v.instr_assignment_id%TYPE

693: CURSOR c_instr_assigns
694: (ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
695: ci_payer_level IN VARCHAR2,
696: ci_payer_equiv IN VARCHAR2,
697: ci_instr_assign IN iby_fndcpt_payer_assgn_instr_v.instr_assignment_id%TYPE
698: )
699: IS
700: SELECT instr_assignment_id, instrument_type, instrument_id,
701: NVL(card_info_only_flag,'N'), NVL(card_single_use_flag,'N')

Line 702: FROM iby_fndcpt_payer_assgn_instr_v

698: )
699: IS
700: SELECT instr_assignment_id, instrument_type, instrument_id,
701: NVL(card_info_only_flag,'N'), NVL(card_single_use_flag,'N')
702: FROM iby_fndcpt_payer_assgn_instr_v
703: WHERE
704: (instr_assignment_id = ci_instr_assign)
705: AND ext_payer_id IN
706: (

Line 2303: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%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;
2307: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;

Line 2344: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,

2340: x.instrument_security_code, x.instr_code_sec_segment_id, x.encrypted,
2341: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
2342: x.voice_authorization_date, i.card_single_use_flag,
2343: NVL(x.instr_assignment_id,0), x.payment_channel_code
2344: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,
2345: iby_external_payers_all p, fnd_application a,
2346: iby_fndcpt_pmt_chnnls_b pc
2347: WHERE (x.instr_assignment_id = i.instr_assignment_id(+))
2348: AND (x.payment_channel_code = pc.payment_channel_code)

Line 3053: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;

3049: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;
3050: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;
3051: l_pmt_trxn IBY_PAYMENT_ADAPTER_PUB.PmtReqTrxn_rec_type;
3052: l_reqresp IBY_PAYMENT_ADAPTER_PUB.ReqResp_rec_type;
3053: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
3054:
3055: l_op_count NUMBER;
3056:
3057: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;