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.

[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_FNDCPT_PMT_CHNNLS_B

Line 542: p_pmt_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE

538: FUNCTION Payer_Channel_Valid
539: (p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
540: p_payer_level IN VARCHAR2,
541: p_payer_equiv IN VARCHAR2,
542: p_pmt_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE
543: )
544: RETURN BOOLEAN
545: IS
546: l_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

Line 546: l_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

542: p_pmt_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE
543: )
544: RETURN BOOLEAN
545: IS
546: l_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;
547:
548: CURSOR c_trxn_channel
549: (ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
550: ci_payer_level IN VARCHAR2,

Line 552: ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)

548: CURSOR c_trxn_channel
549: (ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
550: ci_payer_level IN VARCHAR2,
551: ci_payer_equiv IN VARCHAR2,
552: ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
553: IS
554: SELECT c.instrument_type
555: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c
556: WHERE (c.payment_channel_code = ci_channel_code)

Line 555: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c

551: ci_payer_equiv IN VARCHAR2,
552: ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
553: IS
554: SELECT c.instrument_type
555: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c
556: WHERE (c.payment_channel_code = ci_channel_code)
557: AND (pm.payment_method_code = c.payment_channel_code)
558: AND (NVL(pm.inactive_date,SYSDATE-10) 559: AND (NVL(c.inactive_date,SYSDATE-10)

Line 599: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)

595: END IF;
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:

Line 605: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%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
607: SELECT attribute_applicability
608: FROM iby_pmt_mthd_attrib_appl
609: WHERE (payment_flow = 'FUNDS_CAPTURE')

Line 626: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,

622: -- Verifies that the channel is correct for the given
623: -- instrument assignment
624: --
625: FUNCTION InstrAssignment_Channel_Valid
626: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,
627: p_assign IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
628: x_channel_instr OUT NOCOPY iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE
629: )
630: RETURN BOOLEAN

Line 628: x_channel_instr OUT NOCOPY iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE

624: --
625: FUNCTION InstrAssignment_Channel_Valid
626: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,
627: p_assign IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
628: x_channel_instr OUT NOCOPY iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE
629: )
630: RETURN BOOLEAN
631: IS
632: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;

Line 637: (ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%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,
638: ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE
639: )
640: IS
641: SELECT c.instrument_type, u.instrument_payment_use_id

Line 642: FROM iby_fndcpt_pmt_chnnls_b c, iby_pmt_instr_uses_all u

638: ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE
639: )
640: IS
641: SELECT c.instrument_type, u.instrument_payment_use_id
642: FROM iby_fndcpt_pmt_chnnls_b c, iby_pmt_instr_uses_all u
643: WHERE (payment_channel_code = ci_channel_code)
644: AND (u.instrument_payment_use_id (+) = ci_assign_id)
645: AND (c.instrument_type = u.instrument_type(+))
646: AND (NVL(payment_flow,IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)

Line 679: p_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,

675: FUNCTION Payer_InstrAssignment_Valid
676: (p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
677: p_payer_level IN VARCHAR2,
678: p_payer_equiv IN VARCHAR2,
679: p_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,
680: p_instr_assign IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
681: p_new_extension IN BOOLEAN
682: )
683: RETURN BOOLEAN

Line 837: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

833: l_sec_code VARCHAR2(10);
834: l_encrypted VARCHAR2(1) := 'N';
835: l_segment_id NUMBER;
836:
837: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;
838:
839: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
840:
841: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;

Line 1116: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;

1112: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1113: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1114:
1115: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;
1116: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;
1117: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
1118: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
1119: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
1120: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;

Line 1124: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

1120: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
1121: l_app_id iby_fndcpt_tx_extensions.origin_application_id%TYPE;
1122: -- l_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1123:
1124: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;
1125:
1126: l_msg_count NUMBER;
1127: l_msg_data VARCHAR2(300);
1128: l_return_status VARCHAR2(1);

Line 2346: iby_fndcpt_pmt_chnnls_b pc

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)
2349: AND (x.origin_application_id = a.application_id)
2350: -- can assume this assignment is for funds capture

Line 3075: iby_fndcpt_pmt_chnnls_b pc

3071: x.voice_authorization_date, NVL(x.instr_assignment_id,0),
3072: x.payment_channel_code
3073: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
3074: iby_external_payers_all p, fnd_application a,
3075: iby_fndcpt_pmt_chnnls_b pc
3076: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
3077: AND (x.payment_channel_code = pc.payment_channel_code)
3078: -- can assume this assignment is for funds capture
3079: AND (x.ext_payer_id = p.ext_payer_id)