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 883: l_instr_type iby_fndcpt_payer_assgn_instr_v.instrument_type%TYPE;

879: RETURN BOOLEAN
880: IS
881: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
882: l_instr_req iby_pmt_mthd_attrib_appl.attribute_applicability%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;

Line 884: l_instr_id iby_fndcpt_payer_assgn_instr_v.instrument_id%TYPE;

880: IS
881: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
882: l_instr_req iby_pmt_mthd_attrib_appl.attribute_applicability%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:

Line 885: l_info_only iby_fndcpt_payer_assgn_instr_v.card_info_only_flag%TYPE;

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

Line 886: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;

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

Line 893: ci_instr_assign IN iby_fndcpt_payer_assgn_instr_v.instr_assignment_id%TYPE

889: CURSOR c_instr_assigns
890: (ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
891: ci_payer_level IN VARCHAR2,
892: ci_payer_equiv IN VARCHAR2,
893: ci_instr_assign IN iby_fndcpt_payer_assgn_instr_v.instr_assignment_id%TYPE
894: )
895: IS
896: SELECT instr_assignment_id, instrument_type, instrument_id,
897: NVL(card_info_only_flag,'N'), NVL(card_single_use_flag,'N')

Line 898: FROM iby_fndcpt_payer_assgn_instr_v

894: )
895: IS
896: SELECT instr_assignment_id, instrument_type, instrument_id,
897: NVL(card_info_only_flag,'N'), NVL(card_single_use_flag,'N')
898: FROM iby_fndcpt_payer_assgn_instr_v
899: WHERE
900: (instr_assignment_id = ci_instr_assign)
901: AND ext_payer_id IN
902: (

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

Line 2859: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,

2855: x.instr_sec_code_length, x.encrypted,
2856: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
2857: x.voice_authorization_date, i.card_single_use_flag,
2858: NVL(x.instr_assignment_id,0), x.payment_channel_code
2859: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,
2860: iby_external_payers_all p, fnd_application a,
2861: iby_fndcpt_pmt_chnnls_b pc
2862: WHERE (x.instr_assignment_id = i.instr_assignment_id(+))
2863: AND (x.payment_channel_code = pc.payment_channel_code)

Line 3804: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;

3800: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;
3801: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;
3802: l_pmt_trxn IBY_PAYMENT_ADAPTER_PUB.PmtReqTrxn_rec_type;
3803: l_reqresp IBY_PAYMENT_ADAPTER_PUB.ReqResp_rec_type;
3804: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
3805:
3806: l_op_count NUMBER;
3807:
3808: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;