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 XMLAGG

Line 525: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))

521: l_to_date VARCHAR2(255);
522: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Create_Pos_Pay_Extract_1_0';
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'

Line 533: SELECT XMLType.getClobVal(XMLElement("PositivePayDataExtract", XMLAgg(xml_pmt_lvl.payment)))

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

Line 699: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

695: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Create_Pos_Pay_Extract_2_0';
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)

Line 708: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

704: ;
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: ;

Line 716: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

712: ;
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)

Line 725: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

721: ;
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: ;

Line 734: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

730:
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

Line 754: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

750: ;
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

Line 773: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

769: ;
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

Line 793: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))

789: ;
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

Line 2010: SELECT XMLAgg(

2006: l_fv_treasury_symbol_agg XMLTYPE;
2007: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_FVFieldsAgg';
2008:
2009: CURSOR l_fv_treasury_symbol_csr (p_payment_instruction_id IN NUMBER) IS
2010: SELECT XMLAgg(
2011: XMLElement("TreasurySymbol",
2012: XMLElement("Name", fv.treasury_symbol),
2013: XMLElement("Amount",
2014: XMLElement("Value", fv.amount),

Line 2064: SELECT XMLAgg(xml_pmt_lvl.payment)

2060:
2061:
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

Line 2077: SELECT XMLAgg(xml_pmt_lvl.payment)

2073: ins.process_type = 'IMMEDIATE');
2074:
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

Line 2091: SELECT XMLAgg(xml_pmt_lvl.payment)

2087:
2088: -- for payment instruction register
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;

Line 2099: SELECT XMLAgg(xml_pmt_lvl.payment)

2095: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id;
2096:
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

Line 2109: SELECT XMLAgg(xml_pmt_lvl.payment)

2105: 'SUBMITTED_FOR_PRINTING', 'FORMATTED', 'TRANSMITTED', 'ISSUED', 'PAID');
2106:
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

Line 2119: SELECT XMLAgg(xml_pmt_lvl.payment)

2115: -- note the status qualification is done in Java CP main driver cursor
2116:
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

Line 2553: SELECT XMLAgg(account_setting)

2549: IS
2550: l_acctsettings_agg XMLTYPE;
2551:
2552: CURSOR l_acctsettings_csr (p_bep_account_id IN NUMBER) IS
2553: SELECT XMLAgg(account_setting)
2554: FROM iby_xml_fd_acct_settings_1_0_v
2555: WHERE bep_account_id = p_bep_account_id;
2556:
2557: BEGIN

Line 2576: SELECT XMLAgg(doc_payable)

2572: l_docpayable_agg XMLTYPE;
2573: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_DocPayableAgg';
2574:
2575: CURSOR l_docpayable_csr (p_payment_id IN NUMBER) IS
2576: SELECT XMLAgg(doc_payable)
2577: FROM iby_xml_fd_doc_1_0_v
2578: WHERE formatting_payment_id = p_payment_id --bug 7006504
2579: AND document_status <> 'REMOVED';
2580:

Line 2583: SELECT XMLAgg(doc_payable)

2579: AND document_status <> 'REMOVED';
2580:
2581: -- for ppr report we need to filter the docs by MOAC accessibility check
2582: CURSOR l_docpayable_ppr_rpt_csr (p_payment_id IN NUMBER) IS
2583: SELECT XMLAgg(doc_payable)
2584: FROM iby_xml_fd_doc_1_0_v xml_doc, iby_docs_payable_all doc, ce_security_profiles_v ce_sp
2585: WHERE xml_doc.payment_id = p_payment_id --bug 7459662
2586: AND xml_doc.document_payable_id = doc.document_payable_id
2587: AND ce_sp.organization_type = doc.org_type

Line 2979: SELECT XMLAgg(

2975: -- Bug 6321384 Added nvl to check for NULL values
2976: CURSOR l_docline_csr (p_document_payable_id IN NUMBER,
2977: p_conc_invalid_chars IN VARCHAR2,
2978: p_conc_replacement_chars IN VARCHAR2) IS
2979: SELECT XMLAgg(
2980: XMLElement("DocumentPayableLine",
2981: XMLElement("LineNumber", apdl.line_number),
2982: XMLElement("PONumber", apdl.po_number),
2983: XMLElement("LineType",

Line 3458: SELECT XMLAgg(payment)

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

Line 3499: SELECT XMLAgg(doc_payable)

3495: IS
3496: l_docpayable_agg XMLTYPE;
3497:
3498: CURSOR l_baddoc_csr (p_payment_service_request_id IN NUMBER) IS
3499: SELECT XMLAgg(doc_payable)
3500: FROM iby_xml_fd_doc_1_0_v
3501: WHERE payment_service_request_id = p_payment_service_request_id
3502: AND payment_id is null;
3503: -- AND document_status in ('REJECTED', 'FAILED_VALIDATION');

Line 3544: SELECT XMLAgg(payment_error)

3540: IS
3541: l_pmterr_agg XMLTYPE;
3542: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_PmtErrAgg';
3543: CURSOR l_pmterr_csr (p_payment_id IN NUMBER) IS
3544: SELECT XMLAgg(payment_error)
3545: FROM iby_xml_fd_pmt_err_1_0_v
3546: WHERE payment_id = p_payment_id;
3547:
3548: BEGIN

Line 3573: SELECT XMLAgg(doc_payable_error)

3569: IS
3570: l_docerr_agg XMLTYPE;
3571:
3572: CURSOR l_docerr_csr (p_document_payable_id IN NUMBER) IS
3573: SELECT XMLAgg(doc_payable_error)
3574: FROM iby_xml_fd_doc_err_1_0_v
3575: WHERE document_payable_id = p_document_payable_id;
3576:
3577: BEGIN