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 345: iby_pay_instructions_all ins

341: CURSOR l_ece_csr(p_payment_instruction_id IN NUMBER) IS
342: SELECT electronic_processing_channel
343: FROM
344: iby_payment_profiles ppp,
345: iby_pay_instructions_all ins
346: WHERE
347: ins.payment_instruction_id = p_payment_instruction_id
348: AND ins.payment_profile_id = ppp.payment_profile_id;
349:

Line 536: iby_pay_instructions_all ins

532: CURSOR l_pospay_appp_csr (p_to_date IN VARCHAR2) IS
533: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))
534: FROM
535: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,
536: iby_pay_instructions_all ins
537: WHERE xml_pmt_lvl.payment_instruction_id = ins.payment_instruction_id
538: AND ins.payment_profile_id = p_payment_profile_id
539: AND xml_pmt_lvl.payment_date >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), xml_pmt_lvl.payment_date)
540: AND xml_pmt_lvl.payment_date <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), SYSDATE)

Line 582: UPDATE iby_pay_instructions_all

578:
579: /*LKQ POS PAY - PAVAN */
580: -- payment instruction level attribute setting
581:
582: UPDATE iby_pay_instructions_all
583: SET positive_pay_file_created_flag= 'Y'
584: WHERE payment_instruction_id = p_payment_instruction_id;
585:
586: ELSE

Line 604: iby_pay_instructions_all ins

600:
601: SELECT pmt.payment_id,pmt.payment_instruction_id
602: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
603: FROM iby_xml_fd_pmt_1_0_v pmt,
604: iby_pay_instructions_all ins
605: WHERE pmt.payment_instruction_id = ins.payment_instruction_id
606: AND ins.payment_profile_id = p_payment_profile_id
607: AND pmt.payment_date >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), pmt.payment_date)
608: AND pmt.payment_date <= nvl(to_date(l_to_date, 'YYYY/MM/DD HH24:MI:SS'), SYSDATE)

Line 641: UPDATE iby_pay_instructions_all ins

637: iby_debug_pub.add(debug_msg => 'Payment Instr Count : '|| l_paymentinstrid_arr.COUNT,debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
638: IF ( l_paymentinstrid_arr.COUNT <> 0) THEN
639: FOR i IN l_paymentinstrid_arr.FIRST .. l_paymentinstrid_arr.LAST LOOP
640: IF (l_paymentinstrid_arr(i) IS NOT NULL ) THEN
641: UPDATE iby_pay_instructions_all ins
642: SET ins.positive_pay_file_created_flag = 'Y'
643: WHERE not exists (SELECT 'N'
644: FROM iby_payments_all pmt
645: WHERE nvl(pmt.positive_pay_file_created_flag,'N') = 'N'

Line 735: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp

731:
732: --cursor for - pmt instr id not supplied,negotiable payments, reselect - no
733: CURSOR l_pospay_appp_csr_1_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
734: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
735: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
736: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
737: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
738: AND ppp.positive_pay_format_code IN
739: (SELECT ppfformat.format_code

Line 755: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp

751:
752: --cursor for - pmt instr id not supplied,negotiable payments, reselect - yes
753: CURSOR l_pospay_appp_csr_1_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
754: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
755: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
756: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
757: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
758: AND ppp.positive_pay_format_code IN
759: (SELECT ppfformat.format_code

Line 774: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp

770:
771: --cursor for - pmt instr id not supplied,voided payments, reselect - no
772: CURSOR l_pospay_appp_csr_2_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
773: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
774: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
775: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
776: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
777: AND ppp.positive_pay_format_code IN
778: (SELECT ppfformat.format_code

Line 794: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp

790:
791: --cursor for - pmt instr id not supplied,voided payments, reselect - yes
792: CURSOR l_pospay_appp_csr_2_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
793: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
794: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
795: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
796: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
797: AND ppp.positive_pay_format_code IN
798: (SELECT ppfformat.format_code

Line 1024: iby_pay_instructions_all pmtinstr,

1020:
1021: SELECT pmt.payment_id,pmt.payment_instruction_id
1022: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1023: FROM iby_xml_fd_pmt_1_0_v pmt,
1024: iby_pay_instructions_all pmtinstr,
1025: iby_payment_profiles ppp,
1026: iby_formats_vl ppfformat,
1027: ce_bank_accounts ba
1028: WHERE pmt.payment_instruction_id = pmtinstr.payment_instruction_id

Line 1050: iby_pay_instructions_all pmtinstr,

1046:
1047: SELECT pmt.payment_id,pmt.payment_instruction_id
1048: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1049: FROM iby_xml_fd_pmt_1_0_v pmt,
1050: iby_pay_instructions_all pmtinstr,
1051: iby_payment_profiles ppp,
1052: iby_formats_vl ppfformat,
1053: ce_bank_accounts ba
1054: WHERE pmt.payment_instruction_id = pmtinstr.payment_instruction_id

Line 1080: iby_pay_instructions_all pmtinstr,

1076:
1077: SELECT pmt.payment_id,pmt.payment_instruction_id
1078: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1079: FROM iby_xml_fd_pmt_1_0_v pmt,
1080: iby_pay_instructions_all pmtinstr,
1081: iby_payment_profiles ppp,
1082: iby_formats_vl ppfformat,
1083: ce_bank_accounts ba
1084: WHERE pmt.payment_instruction_id = pmtinstr.payment_instruction_id

Line 1106: iby_pay_instructions_all pmtinstr,

1102:
1103: SELECT pmt.payment_id,pmt.payment_instruction_id
1104: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1105: FROM iby_xml_fd_pmt_1_0_v pmt,
1106: iby_pay_instructions_all pmtinstr,
1107: iby_payment_profiles ppp,
1108: iby_formats_vl ppfformat,
1109: ce_bank_accounts ba
1110: WHERE pmt.payment_instruction_id = pmtinstr.payment_instruction_id

Line 1152: UPDATE iby_pay_instructions_all

1148: --if payment instruction is supplied
1149: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1150: 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);
1151: END IF;
1152: UPDATE iby_pay_instructions_all
1153: SET positive_pay_file_created_flag='Y'
1154: WHERE payment_instruction_id = p_payment_instruction_id;
1155:
1156: ELSE

Line 1167: UPDATE iby_pay_instructions_all ins

1163: iby_debug_pub.add(debug_msg => 'Payment Instr Count : '|| l_paymentinstrid_arr.COUNT,debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
1164: IF ( l_paymentinstrid_arr.COUNT <> 0) THEN
1165: FOR i IN l_paymentinstrid_arr.FIRST .. l_paymentinstrid_arr.LAST LOOP
1166: IF (l_paymentinstrid_arr(i) IS NOT NULL ) THEN
1167: UPDATE iby_pay_instructions_all ins
1168: SET ins.positive_pay_file_created_flag = 'Y'
1169: WHERE not exists (SELECT 'N'
1170: FROM iby_payments_all pmt
1171: WHERE nvl(pmt.positive_pay_file_created_flag,'N') = 'N'

Line 2019: FROM fv_tp_ts_amt_data fv, iby_pay_instructions_all iby

2015: XMLElement("Currency", XMLElement("Code", iby.payment_currency_code))
2016: )
2017: )
2018: )
2019: FROM fv_tp_ts_amt_data fv, iby_pay_instructions_all iby
2020: WHERE iby.payment_instruction_id = fv.payment_instruction_id
2021: AND iby.payment_instruction_id = p_payment_instruction_id;
2022:
2023: CURSOR l_fv_summary_csr (p_payment_instruction_id IN NUMBER,

Line 2067: IBY_PAY_INSTRUCTIONS_ALL ins

2063: CURSOR l_payerinstr_csr (p_payment_instruction_id IN NUMBER) IS
2064: SELECT XMLAgg(xml_pmt_lvl.payment)
2065: FROM
2066: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,
2067: IBY_PAY_INSTRUCTIONS_ALL ins
2068: WHERE
2069: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2070: AND ins.payment_instruction_id = xml_pmt_lvl.payment_instruction_id
2071: AND ((xml_pmt_lvl.payment_status in ('INSTRUCTION_CREATED',

Line 2080: IBY_PAY_INSTRUCTIONS_ALL ins

2076: CURSOR l_payerinstr_reprt_csr (p_payment_instruction_id IN NUMBER) IS
2077: SELECT XMLAgg(xml_pmt_lvl.payment)
2078: FROM
2079: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,
2080: IBY_PAY_INSTRUCTIONS_ALL ins
2081: WHERE
2082: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2083: AND ins.payment_instruction_id = xml_pmt_lvl.payment_instruction_id
2084: AND ((xml_pmt_lvl.payment_status in ('READY_TO_REPRINT',

Line 2134: IBY_PAY_INSTRUCTIONS_ALL ins

2130: CURSOR l_rep_debug_pmt_csr (p_payment_instruction_id IN NUMBER) IS
2131: SELECT ext_pmt_v.payment_id, ext_pmt_v.paper_document_number, ext_pmt_v.payment_status
2132: FROM
2133: IBY_EXT_FD_PMT_1_0_V ext_pmt_v,
2134: IBY_PAY_INSTRUCTIONS_ALL ins
2135: WHERE
2136: ext_pmt_v.payment_instruction_id = p_payment_instruction_id
2137: AND ins.payment_instruction_id = ext_pmt_v.payment_instruction_id;
2138:

Line 2142: IBY_PAY_INSTRUCTIONS_ALL ins

2138:
2139: CURSOR l_rep_debug_ins_csr (p_payment_instruction_id IN NUMBER) IS
2140: SELECT ins.payment_instruction_status
2141: FROM
2142: IBY_PAY_INSTRUCTIONS_ALL ins
2143: WHERE
2144: ins.payment_instruction_id = p_payment_instruction_id;
2145:
2146:

Line 3059: FROM iby_payments_all pmt, iby_pay_instructions_all ins,

3055: l_ps_territory VARCHAR2(60);
3056:
3057: CURSOR l_sra_setup_csr (p_payment_id IN NUMBER) IS
3058: SELECT sra_setup.sra_override_payee_flag, sra_setup.remit_advice_delivery_method
3059: FROM iby_payments_all pmt, iby_pay_instructions_all ins,
3060: iby_payment_profiles pp, iby_remit_advice_setup sra_setup
3061: WHERE pmt.payment_id = p_payment_id
3062: AND pmt.payment_instruction_id = ins.payment_instruction_id
3063: AND pp.payment_profile_id = ins.payment_profile_id