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

Line 359: l_reportFailed xmltype;

355: PROCEDURE Generate_XML_Output(p_org_id IN NUMBER,
356: p_transfer_id IN NUMBER,
357: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type) IS
358: l_currency VARCHAR2(30);
359: l_reportFailed xmltype;
360: l_FailedWithParameters xmltype;
361: l_parameter XMLType;
362: l_summary XMLType;
363: l_failed XMLType;

Line 360: l_FailedWithParameters xmltype;

356: p_transfer_id IN NUMBER,
357: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type) IS
358: l_currency VARCHAR2(30);
359: l_reportFailed xmltype;
360: l_FailedWithParameters xmltype;
361: l_parameter XMLType;
362: l_summary XMLType;
363: l_failed XMLType;
364: l_warning xmltype;

Line 361: l_parameter XMLType;

357: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type) IS
358: l_currency VARCHAR2(30);
359: l_reportFailed xmltype;
360: l_FailedWithParameters xmltype;
361: l_parameter XMLType;
362: l_summary XMLType;
363: l_failed XMLType;
364: l_warning xmltype;
365: l_succeeded XMLType;

Line 362: l_summary XMLType;

358: l_currency VARCHAR2(30);
359: l_reportFailed xmltype;
360: l_FailedWithParameters xmltype;
361: l_parameter XMLType;
362: l_summary XMLType;
363: l_failed XMLType;
364: l_warning xmltype;
365: l_succeeded XMLType;
366: l_report_XML XMLType;

Line 363: l_failed XMLType;

359: l_reportFailed xmltype;
360: l_FailedWithParameters xmltype;
361: l_parameter XMLType;
362: l_summary XMLType;
363: l_failed XMLType;
364: l_warning xmltype;
365: l_succeeded XMLType;
366: l_report_XML XMLType;
367:

Line 364: l_warning xmltype;

360: l_FailedWithParameters xmltype;
361: l_parameter XMLType;
362: l_summary XMLType;
363: l_failed XMLType;
364: l_warning xmltype;
365: l_succeeded XMLType;
366: l_report_XML XMLType;
367:
368: --l_date_format VARCHAR2(11):=fnd_profile.VALUE('ICX_DATE_FORMAT_MASK');

Line 365: l_succeeded XMLType;

361: l_parameter XMLType;
362: l_summary XMLType;
363: l_failed XMLType;
364: l_warning xmltype;
365: l_succeeded XMLType;
366: l_report_XML XMLType;
367:
368: --l_date_format VARCHAR2(11):=fnd_profile.VALUE('ICX_DATE_FORMAT_MASK');
369:

Line 366: l_report_XML XMLType;

362: l_summary XMLType;
363: l_failed XMLType;
364: l_warning xmltype;
365: l_succeeded XMLType;
366: l_report_XML XMLType;
367:
368: --l_date_format VARCHAR2(11):=fnd_profile.VALUE('ICX_DATE_FORMAT_MASK');
369:
370: l_succ_rows NUMBER;

Line 629: -- generate the xmltype for failed inv

625: l_warning_amount AS "AmountFail"))
626: INTO l_summary
627: FROM dual;
628:
629: -- generate the xmltype for failed inv
630: SELECT XMLElement("Invoices",
631: xmlagg(xmlelement("Invoice",
632: xmlforest(seq AS "sequence",
633: Transaction_Num AS

Line 646: -- generate the xmltype for warning inv

642: INTO l_failed
643: FROM JMF_gta_transfer_temp
644: WHERE SUCCEEDED = 'N';
645:
646: -- generate the xmltype for warning inv
647: SELECT XMLElement("Invoices",
648: xmlagg(xmlelement("Invoice",
649: xmlforest(seq AS "sequence",
650: Transaction_Num AS

Line 663: --generate the xmltype for succ inv

659: INTO l_warning
660: FROM JMF_gta_transfer_temp
661: WHERE SUCCEEDED = 'W';
662:
663: --generate the xmltype for succ inv
664: SELECT XMLElement("Invoices",
665: xmlagg(xmlelement("Invoice",
666: xmlforest(SEQ AS "sequence",
667: Transaction_Num AS