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_PMT_CHNNLS_B

Line 709: p_pmt_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE

705: FUNCTION Payer_Channel_Valid
706: (p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
707: p_payer_level IN VARCHAR2,
708: p_payer_equiv IN VARCHAR2,
709: p_pmt_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE
710: )
711: RETURN BOOLEAN
712: IS
713: l_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

Line 713: l_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

709: p_pmt_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE
710: )
711: RETURN BOOLEAN
712: IS
713: l_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;
714:
715: CURSOR c_trxn_channel
716: (ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
717: ci_payer_level IN VARCHAR2,

Line 719: ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)

715: CURSOR c_trxn_channel
716: (ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
717: ci_payer_level IN VARCHAR2,
718: ci_payer_equiv IN VARCHAR2,
719: ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
720: IS
721: SELECT c.instrument_type
722: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c
723: WHERE (c.payment_channel_code = ci_channel_code)

Line 722: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c

718: ci_payer_equiv IN VARCHAR2,
719: ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
720: IS
721: SELECT c.instrument_type
722: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c
723: WHERE (c.payment_channel_code = ci_channel_code)
724: AND (pm.payment_method_code = c.payment_channel_code)
725: AND (NVL(pm.inactive_date,SYSDATE-10) 726: AND (NVL(c.inactive_date,SYSDATE-10)

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

772: END IF;
773: END Payer_Channel_Valid;
774:
775: FUNCTION Channel_InstrAssignment_Appl
776: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
777: RETURN iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE
778: IS
779: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
780:

Line 782: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)

778: IS
779: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
780:
781: CURSOR c_pmt_instr
782: (ci_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE)
783: IS
784: SELECT attribute_applicability
785: FROM iby_pmt_mthd_attrib_appl
786: WHERE (payment_flow = 'FUNDS_CAPTURE')

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

809: -- Verifies that the channel is correct for the given
810: -- instrument assignment
811: --
812: FUNCTION InstrAssignment_Channel_Valid
813: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,
814: p_assign IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
815: x_channel_instr OUT NOCOPY iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE
816: )
817: RETURN BOOLEAN

Line 815: x_channel_instr OUT NOCOPY iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE

811: --
812: FUNCTION InstrAssignment_Channel_Valid
813: (p_channel IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,
814: p_assign IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
815: x_channel_instr OUT NOCOPY iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE
816: )
817: RETURN BOOLEAN
818: IS
819: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;

Line 824: (ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,

820: l_assign_appl iby_pmt_mthd_attrib_appl.attribute_applicability%TYPE;
821:
822: -- cursor def changes for bug 5117954
823: CURSOR c_channel_assign
824: (ci_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,
825: ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE
826: )
827: IS
828: SELECT c.instrument_type, u.instrument_payment_use_id

Line 829: FROM iby_fndcpt_pmt_chnnls_b c, iby_pmt_instr_uses_all u

825: ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE
826: )
827: IS
828: SELECT c.instrument_type, u.instrument_payment_use_id
829: FROM iby_fndcpt_pmt_chnnls_b c, iby_pmt_instr_uses_all u
830: WHERE (payment_channel_code = ci_channel_code)
831: AND (u.instrument_payment_use_id (+) = ci_assign_id)
832: AND (c.instrument_type = u.instrument_type(+))
833: AND (NVL(payment_flow,IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)

Line 875: p_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,

871: FUNCTION Payer_InstrAssignment_Valid
872: (p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
873: p_payer_level IN VARCHAR2,
874: p_payer_equiv IN VARCHAR2,
875: p_channel_code IN iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE,
876: p_instr_assign IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
877: p_new_extension IN BOOLEAN
878: )
879: RETURN BOOLEAN

Line 1054: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

1050: l_sec_code VARCHAR2(10);
1051: l_encrypted VARCHAR2(1) := 'N';
1052: l_segment_id NUMBER;
1053:
1054: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;
1055:
1056: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1057:
1058: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;

Line 1391: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;

1387: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1388: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1389:
1390: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;
1391: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;
1392: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
1393: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
1394: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
1395: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;

Line 1399: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

1395: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
1396: l_app_id iby_fndcpt_tx_extensions.origin_application_id%TYPE;
1397: -- l_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
1398:
1399: lx_channel_instr iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;
1400:
1401: l_msg_count NUMBER;
1402: l_msg_data VARCHAR2(300);
1403: l_return_status VARCHAR2(1);

Line 1409: l_instrumenttype iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;

1405: l_sec_code VARCHAR2(10);
1406: l_encrypted VARCHAR2(1) := 'N';
1407: l_seg_id_old NUMBER;
1408: l_segment_id NUMBER;
1409: l_instrumenttype iby_fndcpt_pmt_chnnls_b.instrument_type%TYPE;
1410:
1411: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || l_module;
1412:
1413: CURSOR c_extension

Line 1513: SELECT instrument_type into l_instrumenttype from iby_fndcpt_pmt_chnnls_b where

1509: --
1510: -- Bug# 9532083
1511: -- Retrieve instrument type for the given payment channel code
1512: --
1513: SELECT instrument_type into l_instrumenttype from iby_fndcpt_pmt_chnnls_b where
1514: payment_channel_code = l_pmt_channel;
1515:
1516: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1517: iby_debug_pub.add('l_pmt_channel: ' || l_pmt_channel,G_LEVEL_STATEMENT,l_dbg_mod);

Line 2861: iby_fndcpt_pmt_chnnls_b pc

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

Line 3826: iby_fndcpt_pmt_chnnls_b pc

3822: x.voice_authorization_date, NVL(x.instr_assignment_id,0),
3823: x.payment_channel_code
3824: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
3825: iby_external_payers_all p, fnd_application a,
3826: iby_fndcpt_pmt_chnnls_b pc
3827: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
3828: AND (x.payment_channel_code = pc.payment_channel_code)
3829: -- can assume this assignment is for funds capture
3830: AND (x.ext_payer_id = p.ext_payer_id)

Line 6062: l_instrtype IBY_FNDCPT_PMT_CHNNLS_B.instrument_type%TYPE;

6058:
6059: l_payer_level VARCHAR2(30);
6060: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
6061: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
6062: l_instrtype IBY_FNDCPT_PMT_CHNNLS_B.instrument_type%TYPE;
6063: l_encrypted VARCHAR2(1);
6064: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
6065: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
6066: l_app_short_name fnd_application.application_short_name%TYPE;

Line 6067: l_pmt_chnl_code IBY_FNDCPT_PMT_CHNNLS_B.payment_channel_code%TYPE;

6063: l_encrypted VARCHAR2(1);
6064: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
6065: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
6066: l_app_short_name fnd_application.application_short_name%TYPE;
6067: l_pmt_chnl_code IBY_FNDCPT_PMT_CHNNLS_B.payment_channel_code%TYPE;
6068: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;
6069: l_auth_status IBY_TRXN_SUMMARIES_ALL.status%TYPE;
6070: l_auth_amt IBY_TRXN_SUMMARIES_ALL.amount%TYPE;
6071: l_auth_curr IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE;

Line 6123: iby_fndcpt_pmt_chnnls_b chnl

6119: xt.instr_code_sec_segment_id, xt.instr_sec_code_length
6120: FROM iby_fndcpt_tx_extensions xt,
6121: iby_external_payers_all p,
6122: fnd_application a,
6123: iby_fndcpt_pmt_chnnls_b chnl
6124: WHERE (xt.origin_application_id = a.application_id)
6125: AND (xt.EXT_PAYER_ID = p.ext_payer_id)
6126: AND (xt.trxn_extension_id = ci_extension_id)
6127: AND (xt.payment_channel_code = chnl.payment_channel_code)