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_XML_FD_PMT_1_0_V

Line 527: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

523:
524: CURSOR l_pospay_ins_csr IS
525: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))
526: FROM
527: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
528: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
529: AND xml_pmt_lvl.payment_status = 'ISSUED'
530: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL);
531:

Line 535: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,

531:
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)

Line 603: FROM iby_xml_fd_pmt_1_0_v pmt,

599: CLOSE l_pospay_appp_csr;
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)

Line 700: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

696:
697: --cursor for - pmt instr id supplied,negotiable payments, reselect - no
698: CURSOR l_pospay_ins_csr_1_1 IS
699: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
700: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
701: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
702: AND xml_pmt_lvl.payment_status IN ('ISSUED','PAID')
703: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)
704: ;

Line 709: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

705:
706: --cursor for - pmt instr id supplied,negotiable payments, reselect - yes
707: CURSOR l_pospay_ins_csr_1_2 IS
708: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
709: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
710: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
711: AND xml_pmt_lvl.payment_status IN ('ISSUED','PAID')
712: ;
713:

Line 717: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

713:
714: --cursor for - pmt instr id supplied,voided payments, reselect - no
715: CURSOR l_pospay_ins_csr_2_1 IS
716: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
717: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
718: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
719: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
720: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)
721: ;

Line 726: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

722:
723: --cursor for - pmt instr id supplied,voided payments, reselect - yes
724: CURSOR l_pospay_ins_csr_2_2 IS
725: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
726: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
727: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
728: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
729: ;
730:

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 1023: FROM iby_xml_fd_pmt_1_0_v pmt,

1019: CLOSE l_pospay_appp_csr_1_1;
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

Line 1049: FROM iby_xml_fd_pmt_1_0_v pmt,

1045: CLOSE l_pospay_appp_csr_1_2;
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

Line 1079: FROM iby_xml_fd_pmt_1_0_v pmt,

1075: CLOSE l_pospay_appp_csr_2_1;
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

Line 1105: FROM iby_xml_fd_pmt_1_0_v pmt,

1101: CLOSE l_pospay_appp_csr_2_2;
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

Line 2066: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,

2062: -- for payment format: normal and reprint entire instruction
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

Line 2079: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,

2075: -- for payment format: reprint individual and ranges
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

Line 2093: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

2089: -- we are extract payments in all statuses
2090: CURSOR l_payerinstr_rpt_csr (p_payment_instruction_id IN NUMBER) IS
2091: SELECT XMLAgg(xml_pmt_lvl.payment)
2092: FROM
2093: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
2094: WHERE
2095: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id;
2096:
2097: -- for other auxiliary formats

Line 2101: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

2097: -- for other auxiliary formats
2098: CURSOR l_payerinstr_aux_csr (p_payment_instruction_id IN NUMBER) IS
2099: SELECT XMLAgg(xml_pmt_lvl.payment)
2100: FROM
2101: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
2102: WHERE
2103: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2104: AND xml_pmt_lvl.payment_status in ('INSTRUCTION_CREATED', 'READY_TO_REPRINT',
2105: 'SUBMITTED_FOR_PRINTING', 'FORMATTED', 'TRANSMITTED', 'ISSUED', 'PAID');

Line 2111: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

2107: -- for separate remittance advice electronic delivery: email and fax
2108: CURSOR l_payerinstr_sra_ele_csr (p_payment_instruction_id IN NUMBER) IS
2109: SELECT XMLAgg(xml_pmt_lvl.payment)
2110: FROM
2111: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
2112: WHERE
2113: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2114: AND xml_pmt_lvl.payment_id = G_Extract_Run_Payment_id;
2115: -- note the status qualification is done in Java CP main driver cursor

Line 2121: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

2117: -- for separate remittance advice print delivery
2118: CURSOR l_payerinstr_sra_prt_csr (p_payment_instruction_id IN NUMBER) IS
2119: SELECT XMLAgg(xml_pmt_lvl.payment)
2120: FROM
2121: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
2122: WHERE
2123: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2124: AND (Get_SRA_Attribute(xml_pmt_lvl.payment_id, G_SRA_REQ_FLAG_ATTR) = 'Y' OR xml_pmt_lvl.payment_status ='VOID_BY_OVERFLOW')
2125: AND Get_SRA_Attribute(xml_pmt_lvl.payment_id, G_SRA_DELIVERY_METHOD_ATTR) = G_SRA_DELIVERY_METHOD_PRINTED

Line 3459: FROM iby_xml_fd_pmt_1_0_v

3455: l_ppr_pmt_agg XMLTYPE;
3456:
3457: CURSOR l_ppr_pmt_csr (p_payment_service_request_id IN NUMBER) IS
3458: SELECT XMLAgg(payment)
3459: FROM iby_xml_fd_pmt_1_0_v
3460: WHERE payment_service_request_id = p_payment_service_request_id;
3461:
3462: BEGIN
3463:

Line 3479: FROM iby_xml_fd_pmt_1_0_v

3475: l_ppr_pmt_count NUMBER;
3476:
3477: CURSOR l_ppr_pmt_count_csr (p_payment_service_request_id IN NUMBER) IS
3478: SELECT count(payment_id)
3479: FROM iby_xml_fd_pmt_1_0_v
3480: WHERE payment_service_request_id = p_payment_service_request_id;
3481:
3482: BEGIN
3483: