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_FD_EXTRACT_GEN_PVT dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 526: iby_pay_instructions_all ins

522: CURSOR l_ece_csr(p_payment_instruction_id IN NUMBER) IS
523: SELECT electronic_processing_channel
524: FROM
525: iby_payment_profiles ppp,
526: iby_pay_instructions_all ins
527: WHERE
528: ins.payment_instruction_id = p_payment_instruction_id
529: AND ins.payment_profile_id = ppp.payment_profile_id;
530:

Line 784: UPDATE iby_pay_instructions_all

780:
781: /*LKQ POS PAY - PAVAN */
782: -- payment instruction level attribute setting
783:
784: UPDATE iby_pay_instructions_all
785: SET positive_pay_file_created_flag= 'Y'
786: WHERE payment_instruction_id = p_payment_instruction_id;
787:
788: ELSE

Line 841: UPDATE iby_pay_instructions_all ins

837: iby_debug_pub.add(debug_msg => 'Payment Instr Count : '|| l_paymentinstrid_arr.COUNT,debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
838: IF ( l_paymentinstrid_arr.COUNT <> 0) THEN
839: FOR i IN l_paymentinstrid_arr.FIRST .. l_paymentinstrid_arr.LAST LOOP
840: IF (l_paymentinstrid_arr(i) IS NOT NULL ) THEN
841: UPDATE iby_pay_instructions_all ins
842: SET ins.positive_pay_file_created_flag = 'Y'
843: WHERE not exists (SELECT 'N'
844: FROM iby_payments_all pmt
845: WHERE nvl(pmt.positive_pay_file_created_flag,'N') = 'N'

Line 1533: UPDATE iby_pay_instructions_all

1529: --if payment instruction is supplied
1530: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1531: iby_debug_pub.add(debug_msg => 'Setting the payment instruction level positive_pay_file_created_flag ', debug_level => G_LEVEL_STATEMENT, module => l_Debug_Module);
1532: END IF;
1533: UPDATE iby_pay_instructions_all
1534: SET positive_pay_file_created_flag='Y'
1535: WHERE payment_instruction_id = p_payment_instruction_id;
1536:
1537: ELSE

Line 1548: UPDATE iby_pay_instructions_all ins

1544: iby_debug_pub.add(debug_msg => 'Payment Instr Count : '|| l_paymentinstrid_arr.COUNT,debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
1545: IF ( l_paymentinstrid_arr.COUNT <> 0) THEN
1546: FOR i IN l_paymentinstrid_arr.FIRST .. l_paymentinstrid_arr.LAST LOOP
1547: IF (l_paymentinstrid_arr(i) IS NOT NULL ) THEN
1548: UPDATE iby_pay_instructions_all ins
1549: SET ins.positive_pay_file_created_flag = 'Y'
1550: WHERE not exists (SELECT 'N'
1551: FROM iby_payments_all pmt
1552: WHERE nvl(pmt.positive_pay_file_created_flag,'N') = 'N'

Line 2816: FROM fv_tp_ts_amt_data fv, iby_pay_instructions_all iby

2812: XMLElement("Currency", XMLElement("Code", iby.payment_currency_code))
2813: )
2814: )
2815: )
2816: FROM fv_tp_ts_amt_data fv, iby_pay_instructions_all iby
2817: WHERE iby.payment_instruction_id = fv.payment_instruction_id
2818: AND iby.payment_instruction_id = p_payment_instruction_id;
2819:
2820: CURSOR l_fv_summary_csr (p_payment_instruction_id IN NUMBER,

Line 2864: IBY_PAY_INSTRUCTIONS_ALL ins

2860: CURSOR l_payerinstr_csr (p_payment_instruction_id IN NUMBER) IS
2861: SELECT XMLAgg(xml_pmt_lvl.payment)
2862: FROM
2863: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,
2864: IBY_PAY_INSTRUCTIONS_ALL ins
2865: WHERE
2866: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2867: AND ins.payment_instruction_id = xml_pmt_lvl.payment_instruction_id
2868: AND ((xml_pmt_lvl.payment_status in ('INSTRUCTION_CREATED',

Line 2877: IBY_PAY_INSTRUCTIONS_ALL ins

2873: CURSOR l_payerinstr_reprt_csr (p_payment_instruction_id IN NUMBER) IS
2874: SELECT XMLAgg(xml_pmt_lvl.payment)
2875: FROM
2876: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,
2877: IBY_PAY_INSTRUCTIONS_ALL ins
2878: WHERE
2879: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2880: AND ins.payment_instruction_id = xml_pmt_lvl.payment_instruction_id
2881: AND ((xml_pmt_lvl.payment_status in ('READY_TO_REPRINT',

Line 2945: IBY_PAY_INSTRUCTIONS_ALL ins

2941: CURSOR l_rep_debug_pmt_csr (p_payment_instruction_id IN NUMBER) IS
2942: SELECT ext_pmt_v.payment_id, ext_pmt_v.paper_document_number, ext_pmt_v.payment_status
2943: FROM
2944: IBY_EXT_FD_PMT_1_0_V ext_pmt_v,
2945: IBY_PAY_INSTRUCTIONS_ALL ins
2946: WHERE
2947: ext_pmt_v.payment_instruction_id = p_payment_instruction_id
2948: AND ins.payment_instruction_id = ext_pmt_v.payment_instruction_id;
2949:

Line 2953: IBY_PAY_INSTRUCTIONS_ALL ins

2949:
2950: CURSOR l_rep_debug_ins_csr (p_payment_instruction_id IN NUMBER) IS
2951: SELECT ins.payment_instruction_status
2952: FROM
2953: IBY_PAY_INSTRUCTIONS_ALL ins
2954: WHERE
2955: ins.payment_instruction_id = p_payment_instruction_id;
2956:
2957:

Line 4268: FROM iby_payments_all pmt, iby_pay_instructions_all ins,

4264: l_email_sub VARCHAR2(2000);
4265:
4266: CURSOR l_sra_setup_csr (p_payment_id IN NUMBER) IS
4267: SELECT sra_setup.sra_override_payee_flag, sra_setup.remit_advice_delivery_method
4268: FROM iby_payments_all pmt, iby_pay_instructions_all ins,
4269: iby_payment_profiles pp, iby_remit_advice_setup sra_setup
4270: WHERE pmt.payment_id = p_payment_id
4271: AND pmt.payment_instruction_id = ins.payment_instruction_id
4272: AND pp.payment_profile_id = ins.payment_profile_id