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 159: (p_instr_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

155: --
156: -- Use: Determines cause of the instrument assignments view returning no
157: -- data
158: FUNCTION Get_Payer_Instr_Assgn_Fail
159: (p_instr_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
160: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type
161: )
162: RETURN VARCHAR2
163: IS

Line 165: l_payer_id iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE;

161: )
162: RETURN VARCHAR2
163: IS
164: l_msg VARCHAR2(100);
165: l_payer_id iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE;
166: l_party_id iby_external_payers_all.party_id%TYPE;
167:
168: l_count NUMBER;
169:

Line 190: FROM iby_pmt_instr_uses_all

186: BEGIN
187:
188: SELECT ext_pmt_party_id
189: INTO l_payer_id
190: FROM iby_pmt_instr_uses_all
191: WHERE (instrument_payment_use_id = p_instr_assign_id);
192:
193: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
194: iby_debug_pub.add('payer id:=' || l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

Line 244: l_instr_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;

240: )
241: RETURN VARCHAR2
242: IS
243: l_msg VARCHAR2(100);
244: l_instr_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;
245: l_ext_payer_id iby_fndcpt_tx_extensions.ext_payer_id%TYPE;
246:
247: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Extension_Auth_Fail';
248: BEGIN

Line 814: p_assign IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

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

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

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

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

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

Line 881: l_assign_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;

877: p_new_extension IN BOOLEAN
878: )
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;

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

Line 2002: iby_pmt_instr_uses_all i

1998: )
1999: IS
2000: SELECT x.trxn_extension_id
2001: FROM iby_fndcpt_tx_extensions x, iby_external_payers_all p,
2002: iby_pmt_instr_uses_all i
2003: WHERE (x.trxn_extension_id = ci_extension_id)
2004: AND (x.instr_assignment_id = i.instrument_payment_use_id(+))
2005: AND (NVL(x.ext_payer_id,i.ext_pmt_party_id) = p.ext_payer_id)
2006: AND (p.party_id = ci_payer.Party_Id)

Line 2219: iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE

2215: ci_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,
2216: ci_payer_level IN VARCHAR2,
2217: ci_payer_equiv IN VARCHAR2,
2218: ci_copy_instr_assign_id IN
2219: iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE
2220: )
2221: IS
2222: SELECT x.payment_channel_code, x.instr_assignment_id,
2223: x.instrument_security_code, x.instr_sec_code_length,

Line 2227: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,

2223: x.instrument_security_code, x.instr_sec_code_length,
2224: x.voice_authorization_flag, x.voice_authorization_code,
2225: x.voice_authorization_date, x.encrypted, x.instr_code_sec_segment_id,
2226: x.payment_system_order_number
2227: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
2228: iby_pmt_instr_uses_all cpi, iby_external_payers_all p
2229: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
2230: -- bug 11675835 - kept an outer join for instrument details
2231: -- can assume this assignment is for funds capture

Line 2228: iby_pmt_instr_uses_all cpi, iby_external_payers_all p

2224: x.voice_authorization_flag, x.voice_authorization_code,
2225: x.voice_authorization_date, x.encrypted, x.instr_code_sec_segment_id,
2226: x.payment_system_order_number
2227: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
2228: iby_pmt_instr_uses_all cpi, iby_external_payers_all p
2229: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
2230: -- bug 11675835 - kept an outer join for instrument details
2231: -- can assume this assignment is for funds capture
2232: -- bug 7017004 - use the payer information on the trxn extension

Line 2425: SELECT COUNT(*) INTO l_count FROM iby_pmt_instr_uses_all

2421: --l_instr_assign_id := p_trxn_attribs.Copy_Instr_Assign_Id;
2422: --l_val_instr := FALSE;
2423: iby_debug_pub.add('Check for valid instr assignment:', G_LEVEL_STATEMENT,l_dbg_mod);
2424:
2425: SELECT COUNT(*) INTO l_count FROM iby_pmt_instr_uses_all
2426: WHERE instrument_payment_use_id = l_instr_assign_id AND
2427: NVL(end_date, sysdate + 10) > sysdate;
2428:
2429: iby_debug_pub.add('Count of Instr Assignmentid:'|| l_count, G_LEVEL_STATEMENT,l_dbg_mod);

Line 3824: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,

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

Line 5659: -- iby_pmt_instr_uses_all i,

5655: x.order_id, x.trxn_ref_number1, x.trxn_ref_number2,
5656: x.payment_channel_code
5657: FROM iby_trxn_extensions_v x,
5658: iby_fndcpt_tx_extensions xt,
5659: -- iby_pmt_instr_uses_all i,
5660: iby_external_payers_all p,
5661: fnd_application a
5662: -- [lmallick] - Validate the payer context against the payer
5663: -- stamped on the extension. Not the assignment.