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_PMT_INSTR_USES_ALL

Line 141: (p_instr_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

137: --
138: -- Use: Determines cause of the instrument assignments view returning no
139: -- data
140: FUNCTION Get_Payer_Instr_Assgn_Fail
141: (p_instr_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
142: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type
143: )
144: RETURN VARCHAR2
145: IS

Line 147: l_payer_id iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE;

143: )
144: RETURN VARCHAR2
145: IS
146: l_msg VARCHAR2(100);
147: l_payer_id iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE;
148: l_party_id iby_external_payers_all.party_id%TYPE;
149:
150: l_count NUMBER;
151:

Line 166: FROM iby_pmt_instr_uses_all

162: BEGIN
163:
164: SELECT ext_pmt_party_id
165: INTO l_payer_id
166: FROM iby_pmt_instr_uses_all
167: WHERE (instrument_payment_use_id = p_instr_assign_id);
168:
169: iby_debug_pub.add('payer id:=' || l_payer_id,
170: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 212: l_instr_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;

208: )
209: RETURN VARCHAR2
210: IS
211: l_msg VARCHAR2(100);
212: l_instr_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
213: l_ext_payer_id iby_fndcpt_tx_extensions.ext_payer_id%TYPE;
214:
215: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Extension_Auth_Fail';
216: BEGIN

Line 627: p_assign IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

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
631: IS

Line 632: l_assign_id 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;
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

Line 638: ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%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
642: FROM iby_fndcpt_pmt_chnnls_b c, iby_pmt_instr_uses_all u

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 680: p_instr_assign IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

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
684: IS

Line 685: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;

681: p_new_extension IN BOOLEAN
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;

Line 1117: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_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;
1121: l_app_id iby_fndcpt_tx_extensions.origin_application_id%TYPE;

Line 1617: iby_pmt_instr_uses_all i

1613: )
1614: IS
1615: SELECT x.trxn_extension_id
1616: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p,
1617: iby_pmt_instr_uses_all i
1618: WHERE (x.trxn_extension_id = ci_extension_id)
1619: AND (x.instr_assignment_id = i.instrument_payment_use_id(+))
1620: AND (NVL(x.ext_payer_id,i.ext_pmt_party_id) = p.ext_payer_id)
1621: AND (p.party_id = ci_payer.Party_Id)

Line 1803: iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE

1799: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
1800: ci_payer_level IN VARCHAR2,
1801: ci_payer_equiv IN VARCHAR2,
1802: ci_copy_instr_assign_id IN
1803: iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE
1804: )
1805: IS
1806: SELECT x.payment_channel_code, x.instr_assignment_id,
1807: x.instrument_security_code, x.instr_sec_code_length,

Line 1810: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,

1806: SELECT x.payment_channel_code, x.instr_assignment_id,
1807: x.instrument_security_code, x.instr_sec_code_length,
1808: x.voice_authorization_flag, x.voice_authorization_code,
1809: x.voice_authorization_date, x.encrypted, x.instr_code_sec_segment_id
1810: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
1811: iby_pmt_instr_uses_all cpi, iby_external_payers_all p
1812: WHERE (x.instr_assignment_id = i.instrument_payment_use_id)
1813: -- can assume this assignment is for funds capture
1814: -- bug 7017004 - use the payer information on the trxn extension

Line 1811: iby_pmt_instr_uses_all cpi, iby_external_payers_all p

1807: x.instrument_security_code, x.instr_sec_code_length,
1808: x.voice_authorization_flag, x.voice_authorization_code,
1809: x.voice_authorization_date, x.encrypted, x.instr_code_sec_segment_id
1810: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
1811: iby_pmt_instr_uses_all cpi, iby_external_payers_all p
1812: WHERE (x.instr_assignment_id = i.instrument_payment_use_id)
1813: -- can assume this assignment is for funds capture
1814: -- bug 7017004 - use the payer information on the trxn extension
1815: --AND (i.ext_pmt_party_id = p.ext_payer_id)

Line 3073: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,

3069: x.instrument_security_code, x.instr_code_sec_segment_id, x.encrypted,
3070: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
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)

Line 4578: FROM iby_trxn_extensions_v x, iby_pmt_instr_uses_all i,

4574: x.instrument_type, x.instrument_id,
4575: x.origin_application_id, a.application_short_name,
4576: x.order_id, x.trxn_ref_number1, x.trxn_ref_number2,
4577: x.payment_channel_code
4578: FROM iby_trxn_extensions_v x, iby_pmt_instr_uses_all i,
4579: iby_external_payers_all p, fnd_application a
4580: WHERE (x.instr_assignment_id = i.instrument_payment_use_id)
4581: -- can assume this assignment is for funds capture
4582: AND (x.origin_application_id = a.application_id)