DBA Data[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_PMT_MTHD_ATTRIB_APPL

Line 600: RETURN iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE

596: END Payer_Channel_Valid;
597:
598: FUNCTION Channel_InstrAssignment_Appl
599: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
600: RETURN iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE
601: IS
602: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
603:
604: CURSOR c_pmt_instr

Line 602: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;

598: FUNCTION Channel_InstrAssignment_Appl
599: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
600: RETURN iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE
601: IS
602: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
603:
604: CURSOR c_pmt_instr
605: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
606: IS

Line 608: FROM iby_pmt_mthd_attrib_appl

604: CURSOR c_pmt_instr
605: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
606: IS
607: SELECT attribute_applicability
608: FROM iby_pmt_mthd_attrib_appl
609: WHERE (payment_flow = 'FUNDS_CAPTURE')
610: AND (payment_method_code = ci_pmt_channel)
611: AND (attribute_code = 'PAYMENT_INSTRUMENT');
612: BEGIN

Line 633: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;

629: )
630: RETURN BOOLEAN
631: IS
632: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
633: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
634:
635: -- cursor def changes for bug 5117954
636: CURSOR c_channel_assign
637: (ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,

Line 686: l_instr_req iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;

682: )
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;