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.AR_GTA_ARTRX_PROC dependencies on XMLTYPE

Line 387: l_reportFailed xmltype;

383: PROCEDURE Generate_XML_Output(p_org_id IN NUMBER,
384: p_transfer_id IN NUMBER,
385: p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type) IS
386: l_currency VARCHAR2(30);
387: l_reportFailed xmltype;
388: l_FailedWithParameters xmltype;
389: l_parameter XMLType;
390: l_summary XMLType;
391: l_failed XMLType;

Line 388: l_FailedWithParameters xmltype;

384: p_transfer_id IN NUMBER,
385: p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type) IS
386: l_currency VARCHAR2(30);
387: l_reportFailed xmltype;
388: l_FailedWithParameters xmltype;
389: l_parameter XMLType;
390: l_summary XMLType;
391: l_failed XMLType;
392: l_warning xmltype;

Line 389: l_parameter XMLType;

385: p_conc_parameters IN AR_GTA_TRX_UTIL.transferParas_rec_type) IS
386: l_currency VARCHAR2(30);
387: l_reportFailed xmltype;
388: l_FailedWithParameters xmltype;
389: l_parameter XMLType;
390: l_summary XMLType;
391: l_failed XMLType;
392: l_warning xmltype;
393: l_succeeded XMLType;

Line 390: l_summary XMLType;

386: l_currency VARCHAR2(30);
387: l_reportFailed xmltype;
388: l_FailedWithParameters xmltype;
389: l_parameter XMLType;
390: l_summary XMLType;
391: l_failed XMLType;
392: l_warning xmltype;
393: l_succeeded XMLType;
394: l_report_XML XMLType;

Line 391: l_failed XMLType;

387: l_reportFailed xmltype;
388: l_FailedWithParameters xmltype;
389: l_parameter XMLType;
390: l_summary XMLType;
391: l_failed XMLType;
392: l_warning xmltype;
393: l_succeeded XMLType;
394: l_report_XML XMLType;
395:

Line 392: l_warning xmltype;

388: l_FailedWithParameters xmltype;
389: l_parameter XMLType;
390: l_summary XMLType;
391: l_failed XMLType;
392: l_warning xmltype;
393: l_succeeded XMLType;
394: l_report_XML XMLType;
395:
396: --l_date_format VARCHAR2(11):=fnd_profile.VALUE('ICX_DATE_FORMAT_MASK');

Line 393: l_succeeded XMLType;

389: l_parameter XMLType;
390: l_summary XMLType;
391: l_failed XMLType;
392: l_warning xmltype;
393: l_succeeded XMLType;
394: l_report_XML XMLType;
395:
396: --l_date_format VARCHAR2(11):=fnd_profile.VALUE('ICX_DATE_FORMAT_MASK');
397:

Line 394: l_report_XML XMLType;

390: l_summary XMLType;
391: l_failed XMLType;
392: l_warning xmltype;
393: l_succeeded XMLType;
394: l_report_XML XMLType;
395:
396: --l_date_format VARCHAR2(11):=fnd_profile.VALUE('ICX_DATE_FORMAT_MASK');
397:
398: l_succ_rows NUMBER;

Line 657: -- generate the xmltype for failed inv

653: l_warning_amount AS "AmountFail"))
654: INTO l_summary
655: FROM dual;
656:
657: -- generate the xmltype for failed inv
658: SELECT XMLElement("Invoices",
659: xmlagg(xmlelement("Invoice",
660: xmlforest(seq AS "sequence",
661: Transaction_Num AS

Line 674: -- generate the xmltype for warning inv

670: INTO l_failed
671: FROM AR_gta_transfer_temp
672: WHERE SUCCEEDED = 'N';
673:
674: -- generate the xmltype for warning inv
675: SELECT XMLElement("Invoices",
676: xmlagg(xmlelement("Invoice",
677: xmlforest(seq AS "sequence",
678: Transaction_Num AS

Line 691: --generate the xmltype for succ inv

687: INTO l_warning
688: FROM AR_gta_transfer_temp
689: WHERE SUCCEEDED = 'W';
690:
691: --generate the xmltype for succ inv
692: SELECT XMLElement("Invoices",
693: xmlagg(xmlelement("Invoice",
694: xmlforest(SEQ AS "sequence",
695: Transaction_Num AS