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 727: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

723:
724: CURSOR l_pospay_ins_csr IS
725: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))
726: FROM
727: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
728: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
729: AND xml_pmt_lvl.payment_status = 'ISSUED'
730: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL);
731:

Line 735: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

731:
732: CURSOR l_pospay_appp_csr (p_to_date IN VARCHAR2) IS
733: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))
734: FROM
735: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
736: WHERE xml_pmt_lvl.payment_profile_id = p_payment_profile_id
737: AND xml_pmt_lvl.payment_date >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), xml_pmt_lvl.payment_date)
738: AND xml_pmt_lvl.payment_date <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), SYSDATE)
739: AND xml_pmt_lvl.payment_status = 'ISSUED'

Line 805: FROM iby_xml_fd_pmt_1_0_v pmt

801: CLOSE l_pospay_appp_csr;
802:
803: SELECT pmt.payment_id,pmt.payment_instruction_id
804: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
805: FROM iby_xml_fd_pmt_1_0_v pmt
806: WHERE pmt.payment_profile_id = p_payment_profile_id
807: AND pmt.payment_date >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), pmt.payment_date)
808: AND pmt.payment_date <= nvl(to_date(l_to_date, 'YYYY/MM/DD HH24:MI:SS'), SYSDATE)
809: AND pmt.payment_status = 'ISSUED'

Line 907: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

903:
904: --cursor for - pmt instr id supplied,negotiable payments, reselect - no
905: CURSOR l_pospay_ins_csr_1_1 IS
906: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
907: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
908: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
909: AND xml_pmt_lvl.payment_status IN ('ISSUED','PAID')
910: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)
911: ;

Line 916: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

912:
913: --cursor for - pmt instr id supplied,negotiable payments, reselect - yes
914: CURSOR l_pospay_ins_csr_1_2 IS
915: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
916: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
917: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
918: AND xml_pmt_lvl.payment_status IN ('ISSUED','PAID')
919: ;
920:

Line 924: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

920:
921: --cursor for - pmt instr id supplied,voided payments, reselect - no
922: CURSOR l_pospay_ins_csr_2_1 IS
923: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
924: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
925: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
926: AND xml_pmt_lvl.payment_status IN('VOID')
927: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)
928: ;

Line 933: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

929:
930: --cursor for - pmt instr id supplied,voided payments, reselect - yes
931: CURSOR l_pospay_ins_csr_2_2 IS
932: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
933: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
934: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
935: AND xml_pmt_lvl.payment_status IN('VOID')
936: ;
937:

Line 941: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

937:
938: --cursor for - pmt instr id supplied,negotiable and voided payments, reselect - no
939: CURSOR l_pospay_ins_csr_3_1 IS
940: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
941: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
942: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
943: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
944: AND (xml_pmt_lvl.positive_pay_file_created_flag='N' or xml_pmt_lvl.positive_pay_file_created_flag is NULL)
945: ;

Line 950: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl

946:
947: --cursor for - pmt instr id supplied,negotiable and voided payments, reselect - yes
948: CURSOR l_pospay_ins_csr_3_2 IS
949: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
950: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl
951: WHERE xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
952: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
953: ;
954:

Line 960: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

956:
957: --cursor for - pmt instr id not supplied,negotiable payments, reselect - no
958: CURSOR l_pospay_appp_csr_1_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
959: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
960: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
961: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
962: AND ppp.positive_pay_format_code IN
963: (SELECT ppfformat.format_code
964: FROM iby_formats_vl ppfformat

Line 979: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

975:
976: --cursor for - pmt instr id not supplied,negotiable payments, reselect - yes
977: CURSOR l_pospay_appp_csr_1_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
978: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
979: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
980: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
981: AND ppp.positive_pay_format_code IN
982: (SELECT ppfformat.format_code
983: FROM iby_formats_vl ppfformat

Line 997: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

993:
994: --cursor for - pmt instr id not supplied,voided payments, reselect - no
995: CURSOR l_pospay_appp_csr_2_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
996: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
997: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
998: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
999: AND ppp.positive_pay_format_code IN
1000: (SELECT ppfformat.format_code
1001: FROM iby_formats_vl ppfformat

Line 1016: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

1012:
1013: --cursor for - pmt instr id not supplied,voided payments, reselect - yes
1014: CURSOR l_pospay_appp_csr_2_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1015: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
1016: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1017: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1018: AND ppp.positive_pay_format_code IN
1019: (SELECT ppfformat.format_code
1020: FROM iby_formats_vl ppfformat

Line 1034: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

1030:
1031: --cursor for - pmt instr id not supplied,negotiable and voided payments, reselect - no
1032: CURSOR l_pospay_appp_csr_3_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1033: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
1034: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1035: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1036: AND ppp.positive_pay_format_code IN
1037: (SELECT ppfformat.format_code
1038: FROM iby_formats_vl ppfformat

Line 1053: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

1049:
1050: --cursor for - pmt instr id not supplied,negotiable and voided payments, reselect - yes
1051: CURSOR l_pospay_appp_csr_3_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1052: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
1053: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1054: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1055: AND ppp.positive_pay_format_code IN
1056: (SELECT ppfformat.format_code
1057: FROM iby_formats_vl ppfformat

Line 1335: FROM iby_xml_fd_pmt_1_0_v pmt,

1331: CLOSE l_pospay_appp_csr_1_1;
1332:
1333: SELECT pmt.payment_id,pmt.payment_instruction_id
1334: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1335: FROM iby_xml_fd_pmt_1_0_v pmt,
1336: iby_payment_profiles ppp,
1337: iby_formats_vl ppfformat,
1338: ce_bank_accounts ba
1339: WHERE pmt.payment_profile_id = ppp.payment_profile_id

Line 1359: FROM iby_xml_fd_pmt_1_0_v pmt,

1355: CLOSE l_pospay_appp_csr_1_2;
1356:
1357: SELECT pmt.payment_id,pmt.payment_instruction_id
1358: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1359: FROM iby_xml_fd_pmt_1_0_v pmt,
1360: iby_payment_profiles ppp,
1361: iby_formats_vl ppfformat,
1362: ce_bank_accounts ba
1363: WHERE pmt.payment_profile_id = ppp.payment_profile_id

Line 1387: FROM iby_xml_fd_pmt_1_0_v pmt,

1383: CLOSE l_pospay_appp_csr_2_1;
1384:
1385: SELECT pmt.payment_id,pmt.payment_instruction_id
1386: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1387: FROM iby_xml_fd_pmt_1_0_v pmt,
1388: iby_payment_profiles ppp,
1389: iby_formats_vl ppfformat,
1390: ce_bank_accounts ba
1391: WHERE pmt.payment_profile_id = ppp.payment_profile_id

Line 1410: FROM iby_xml_fd_pmt_1_0_v pmt,

1406: CLOSE l_pospay_appp_csr_2_2;
1407:
1408: SELECT pmt.payment_id,pmt.payment_instruction_id
1409: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1410: FROM iby_xml_fd_pmt_1_0_v pmt,
1411: iby_payment_profiles ppp,
1412: iby_formats_vl ppfformat,
1413: ce_bank_accounts ba
1414: WHERE pmt.payment_profile_id = ppp.payment_profile_id

Line 1438: FROM iby_xml_fd_pmt_1_0_v pmt,

1434: CLOSE l_pospay_appp_csr_3_1;
1435:
1436: SELECT pmt.payment_id,pmt.payment_instruction_id
1437: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1438: FROM iby_xml_fd_pmt_1_0_v pmt,
1439: iby_payment_profiles ppp,
1440: iby_formats_vl ppfformat,
1441: ce_bank_accounts ba
1442: WHERE pmt.payment_profile_id = ppp.payment_profile_id

Line 1462: FROM iby_xml_fd_pmt_1_0_v pmt,

1458: CLOSE l_pospay_appp_csr_3_2;
1459:
1460: SELECT pmt.payment_id,pmt.payment_instruction_id
1461: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1462: FROM iby_xml_fd_pmt_1_0_v pmt,
1463: iby_payment_profiles ppp,
1464: iby_formats_vl ppfformat,
1465: ce_bank_accounts ba
1466: WHERE pmt.payment_profile_id = ppp.payment_profile_id

Line 2863: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,

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

Line 2876: iby_xml_fd_pmt_1_0_v xml_pmt_lvl,

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

Line 2890: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

2886: -- we are extract payments in all statuses
2887: CURSOR l_payerinstr_rpt_csr (p_payment_instruction_id IN NUMBER) IS
2888: SELECT XMLAgg(xml_pmt_lvl.payment)
2889: FROM
2890: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
2891: WHERE
2892: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id;
2893:
2894:

Line 2909: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

2905: -- for other auxiliary formats
2906: CURSOR l_payerinstr_aux_csr (p_payment_instruction_id IN NUMBER) IS
2907: SELECT XMLAgg(xml_pmt_lvl.payment)
2908: FROM
2909: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
2910: WHERE
2911: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2912: AND xml_pmt_lvl.payment_status in ('INSTRUCTION_CREATED', 'READY_TO_REPRINT',
2913: 'SUBMITTED_FOR_PRINTING', 'FORMATTED', 'TRANSMITTED', 'ISSUED', 'PAID');

Line 2919: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

2915: -- for separate remittance advice electronic delivery: email and fax
2916: CURSOR l_payerinstr_sra_ele_csr (p_payment_instruction_id IN NUMBER) IS
2917: SELECT XMLAgg(xml_pmt_lvl.payment)
2918: FROM
2919: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
2920: WHERE
2921: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2922: AND xml_pmt_lvl.payment_id = G_Extract_Run_Payment_id;
2923: -- note the status qualification is done in Java CP main driver cursor

Line 2929: iby_xml_fd_pmt_1_0_v xml_pmt_lvl

2925: -- for separate remittance advice print delivery
2926: CURSOR l_payerinstr_sra_prt_csr (p_payment_instruction_id IN NUMBER, p_from_pmt_ref IN NUMBER, p_to_pmt_ref IN NUMBER) IS
2927: SELECT XMLAgg(xml_pmt_lvl.payment)
2928: FROM
2929: iby_xml_fd_pmt_1_0_v xml_pmt_lvl
2930: WHERE
2931: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2932: AND xml_pmt_lvl.logical_reference_number between nvl(p_from_pmt_ref,xml_pmt_lvl.logical_reference_number)
2933: and nvl(p_to_pmt_ref,xml_pmt_lvl.logical_reference_number)

Line 4698: FROM iby_xml_fd_pmt_1_0_v

4694: l_ppr_pmt_agg XMLTYPE;
4695:
4696: CURSOR l_ppr_pmt_csr (p_payment_service_request_id IN NUMBER) IS
4697: SELECT XMLAgg(payment)
4698: FROM iby_xml_fd_pmt_1_0_v
4699: WHERE payment_service_request_id = p_payment_service_request_id;
4700:
4701: BEGIN
4702:

Line 4718: FROM iby_xml_fd_pmt_1_0_v

4714: l_ppr_pmt_count NUMBER;
4715:
4716: CURSOR l_ppr_pmt_count_csr (p_payment_service_request_id IN NUMBER) IS
4717: SELECT count(payment_id)
4718: FROM iby_xml_fd_pmt_1_0_v
4719: WHERE payment_service_request_id = p_payment_service_request_id;
4720:
4721: BEGIN
4722: