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_REPORTS_PKG dependencies on XMLTYPE

Line 192: -- Return: XMLTYPE

188: -- P_Gt_Inv_Num_From Golden Tax Invoice Number from
189: -- P_Gt_Inv_Num_To Golden Tax Invoice Number to
190: -- Out:
191: --
192: -- Return: XMLTYPE
193: --
194: --
195: -- DESIGN REFERENCES:
196: -- GTA_REPORTS_TD.doc

Line 216: RETURN XMLTYPE

212: , P_Gt_Inv_Date_To IN DATE
213: , P_Gt_Inv_Num_From IN VARCHAR2
214: , P_Gt_Inv_Num_To IN VARCHAR2
215: )
216: RETURN XMLTYPE
217: IS
218: l_procedure_name VARCHAR2(40):='Get_Ar_Trx';
219: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
220: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 222: l_ret_xmlelement Xmltype;

218: l_procedure_name VARCHAR2(40):='Get_Ar_Trx';
219: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
220: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
221:
222: l_ret_xmlelement Xmltype;
223: BEGIN
224: --logging for debug
225: IF (l_proc_level>=l_dbg_level)
226: THEN

Line 395: -- Return: XMLTYPE

391: -- P_Gt_Inv_Num_To Golden Tax Invoice Number to
392: --
393: -- Out:
394: --
395: -- Return: XMLTYPE
396: --
397: --
398: -- DESIGN REFERENCES:
399: -- GTA_REPORTS_TD.doc

Line 416: RETURN Xmltype

412: , P_Gt_Inv_Date_To IN DATE
413: , P_Gt_Inv_Num_From IN VARCHAR2
414: , P_Gt_Inv_Num_To IN VARCHAR2
415: )
416: RETURN Xmltype
417: IS
418: l_procedure_name VARCHAR2(40):='Get_Gt_Trxs';
419: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
420: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 422: l_Ret_Xmlelement Xmltype;

418: l_procedure_name VARCHAR2(40):='Get_Gt_Trxs';
419: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
420: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
421:
422: l_Ret_Xmlelement Xmltype;
423: l_count NUMBER;
424: BEGIN
425: --logging for debug
426: IF (l_proc_level>=l_dbg_level)

Line 547: l_Parameter Xmltype;

543: IS
544: l_procedure_name VARCHAR2(40):='Generate_Mapping_Rep';
545: l_no_data_message VARCHAR2(500);
546: l_Ar_Trx_Id AR_Gta_Trx_Headers.Ra_Trx_Id%TYPE;
547: l_Parameter Xmltype;
548: l_Summary Xmltype;
549: L_gt_currency Xmltype;
550: l_Ar_Trx Xmltype;
551: l_Gt_Invoices Xmltype;

Line 548: l_Summary Xmltype;

544: l_procedure_name VARCHAR2(40):='Generate_Mapping_Rep';
545: l_no_data_message VARCHAR2(500);
546: l_Ar_Trx_Id AR_Gta_Trx_Headers.Ra_Trx_Id%TYPE;
547: l_Parameter Xmltype;
548: l_Summary Xmltype;
549: L_gt_currency Xmltype;
550: l_Ar_Trx Xmltype;
551: l_Gt_Invoices Xmltype;
552: l_ar_trxs xmltype;

Line 549: L_gt_currency Xmltype;

545: l_no_data_message VARCHAR2(500);
546: l_Ar_Trx_Id AR_Gta_Trx_Headers.Ra_Trx_Id%TYPE;
547: l_Parameter Xmltype;
548: l_Summary Xmltype;
549: L_gt_currency Xmltype;
550: l_Ar_Trx Xmltype;
551: l_Gt_Invoices Xmltype;
552: l_ar_trxs xmltype;
553: l_Report Xmltype;

Line 550: l_Ar_Trx Xmltype;

546: l_Ar_Trx_Id AR_Gta_Trx_Headers.Ra_Trx_Id%TYPE;
547: l_Parameter Xmltype;
548: l_Summary Xmltype;
549: L_gt_currency Xmltype;
550: l_Ar_Trx Xmltype;
551: l_Gt_Invoices Xmltype;
552: l_ar_trxs xmltype;
553: l_Report Xmltype;
554: l_Ar_Rows NUMBER;

Line 551: l_Gt_Invoices Xmltype;

547: l_Parameter Xmltype;
548: l_Summary Xmltype;
549: L_gt_currency Xmltype;
550: l_Ar_Trx Xmltype;
551: l_Gt_Invoices Xmltype;
552: l_ar_trxs xmltype;
553: l_Report Xmltype;
554: l_Ar_Rows NUMBER;
555: I NUMBER;

Line 552: l_ar_trxs xmltype;

548: l_Summary Xmltype;
549: L_gt_currency Xmltype;
550: l_Ar_Trx Xmltype;
551: l_Gt_Invoices Xmltype;
552: l_ar_trxs xmltype;
553: l_Report Xmltype;
554: l_Ar_Rows NUMBER;
555: I NUMBER;
556: l_Gt_Rows NUMBER;

Line 553: l_Report Xmltype;

549: L_gt_currency Xmltype;
550: l_Ar_Trx Xmltype;
551: l_Gt_Invoices Xmltype;
552: l_ar_trxs xmltype;
553: l_Report Xmltype;
554: l_Ar_Rows NUMBER;
555: I NUMBER;
556: l_Gt_Rows NUMBER;
557: l_no_data_flag VARCHAR2(1):='N';

Line 3830: , x_output OUT NOCOPY XMLTYPE

3826: , p_primary_sales IN NUMBER
3827: , p_validated_lines_total IN NUMBER
3828: , p_ar_matching_lines_total IN NUMBER
3829: , p_ar_partially_import_total IN NUMBER
3830: , x_output OUT NOCOPY XMLTYPE
3831: )
3832: IS
3833: l_operating_unit hr_operating_units.name%TYPE;
3834: l_customer_name hz_parties.party_name%TYPE;

Line 3881: l_parameter_xml XMLTYPE;

3877: l_ar_partially_import_total NUMBER
3878: :=p_ar_partially_import_total;
3879: l_ar_line_notmatching_total NUMBER;
3880: l_ar_missingtrx_total NUMBER;
3881: l_parameter_xml XMLTYPE;
3882: l_summary_xml XMLTYPE;
3883: l_report_xml XMLTYPE;
3884: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3885: l_gta_header_xml_tmp XMLTYPE;

Line 3882: l_summary_xml XMLTYPE;

3878: :=p_ar_partially_import_total;
3879: l_ar_line_notmatching_total NUMBER;
3880: l_ar_missingtrx_total NUMBER;
3881: l_parameter_xml XMLTYPE;
3882: l_summary_xml XMLTYPE;
3883: l_report_xml XMLTYPE;
3884: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3885: l_gta_header_xml_tmp XMLTYPE;
3886: l_gta_header_xml XMLTYPE;

Line 3883: l_report_xml XMLTYPE;

3879: l_ar_line_notmatching_total NUMBER;
3880: l_ar_missingtrx_total NUMBER;
3881: l_parameter_xml XMLTYPE;
3882: l_summary_xml XMLTYPE;
3883: l_report_xml XMLTYPE;
3884: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3885: l_gta_header_xml_tmp XMLTYPE;
3886: l_gta_header_xml XMLTYPE;
3887: l_gta_line_xml_tmp XMLTYPE;

Line 3885: l_gta_header_xml_tmp XMLTYPE;

3881: l_parameter_xml XMLTYPE;
3882: l_summary_xml XMLTYPE;
3883: l_report_xml XMLTYPE;
3884: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3885: l_gta_header_xml_tmp XMLTYPE;
3886: l_gta_header_xml XMLTYPE;
3887: l_gta_line_xml_tmp XMLTYPE;
3888: l_gta_line_xml XMLTYPE;
3889: l_missing_line_xml_tmp XMLTYPE;

Line 3886: l_gta_header_xml XMLTYPE;

3882: l_summary_xml XMLTYPE;
3883: l_report_xml XMLTYPE;
3884: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3885: l_gta_header_xml_tmp XMLTYPE;
3886: l_gta_header_xml XMLTYPE;
3887: l_gta_line_xml_tmp XMLTYPE;
3888: l_gta_line_xml XMLTYPE;
3889: l_missing_line_xml_tmp XMLTYPE;
3890: l_missing_line_xml XMLTYPE;

Line 3887: l_gta_line_xml_tmp XMLTYPE;

3883: l_report_xml XMLTYPE;
3884: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3885: l_gta_header_xml_tmp XMLTYPE;
3886: l_gta_header_xml XMLTYPE;
3887: l_gta_line_xml_tmp XMLTYPE;
3888: l_gta_line_xml XMLTYPE;
3889: l_missing_line_xml_tmp XMLTYPE;
3890: l_missing_line_xml XMLTYPE;
3891: l_unmatched_line_xml_tmp XMLTYPE;

Line 3888: l_gta_line_xml XMLTYPE;

3884: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3885: l_gta_header_xml_tmp XMLTYPE;
3886: l_gta_header_xml XMLTYPE;
3887: l_gta_line_xml_tmp XMLTYPE;
3888: l_gta_line_xml XMLTYPE;
3889: l_missing_line_xml_tmp XMLTYPE;
3890: l_missing_line_xml XMLTYPE;
3891: l_unmatched_line_xml_tmp XMLTYPE;
3892: l_unmatched_line_xml XMLTYPE;

Line 3889: l_missing_line_xml_tmp XMLTYPE;

3885: l_gta_header_xml_tmp XMLTYPE;
3886: l_gta_header_xml XMLTYPE;
3887: l_gta_line_xml_tmp XMLTYPE;
3888: l_gta_line_xml XMLTYPE;
3889: l_missing_line_xml_tmp XMLTYPE;
3890: l_missing_line_xml XMLTYPE;
3891: l_unmatched_line_xml_tmp XMLTYPE;
3892: l_unmatched_line_xml XMLTYPE;
3893: l_xml_null XMLTYPE;

Line 3890: l_missing_line_xml XMLTYPE;

3886: l_gta_header_xml XMLTYPE;
3887: l_gta_line_xml_tmp XMLTYPE;
3888: l_gta_line_xml XMLTYPE;
3889: l_missing_line_xml_tmp XMLTYPE;
3890: l_missing_line_xml XMLTYPE;
3891: l_unmatched_line_xml_tmp XMLTYPE;
3892: l_unmatched_line_xml XMLTYPE;
3893: l_xml_null XMLTYPE;
3894: l_ar_invoice_xml XMLTYPE;

Line 3891: l_unmatched_line_xml_tmp XMLTYPE;

3887: l_gta_line_xml_tmp XMLTYPE;
3888: l_gta_line_xml XMLTYPE;
3889: l_missing_line_xml_tmp XMLTYPE;
3890: l_missing_line_xml XMLTYPE;
3891: l_unmatched_line_xml_tmp XMLTYPE;
3892: l_unmatched_line_xml XMLTYPE;
3893: l_xml_null XMLTYPE;
3894: l_ar_invoice_xml XMLTYPE;
3895: l_ar_invoice_xml_tmp XMLTYPE;

Line 3892: l_unmatched_line_xml XMLTYPE;

3888: l_gta_line_xml XMLTYPE;
3889: l_missing_line_xml_tmp XMLTYPE;
3890: l_missing_line_xml XMLTYPE;
3891: l_unmatched_line_xml_tmp XMLTYPE;
3892: l_unmatched_line_xml XMLTYPE;
3893: l_xml_null XMLTYPE;
3894: l_ar_invoice_xml XMLTYPE;
3895: l_ar_invoice_xml_tmp XMLTYPE;
3896: l_missing_artrx_xml_tmp XMLTYPE;

Line 3893: l_xml_null XMLTYPE;

3889: l_missing_line_xml_tmp XMLTYPE;
3890: l_missing_line_xml XMLTYPE;
3891: l_unmatched_line_xml_tmp XMLTYPE;
3892: l_unmatched_line_xml XMLTYPE;
3893: l_xml_null XMLTYPE;
3894: l_ar_invoice_xml XMLTYPE;
3895: l_ar_invoice_xml_tmp XMLTYPE;
3896: l_missing_artrx_xml_tmp XMLTYPE;
3897: l_missing_artrx_xml XMLTYPE;

Line 3894: l_ar_invoice_xml XMLTYPE;

3890: l_missing_line_xml XMLTYPE;
3891: l_unmatched_line_xml_tmp XMLTYPE;
3892: l_unmatched_line_xml XMLTYPE;
3893: l_xml_null XMLTYPE;
3894: l_ar_invoice_xml XMLTYPE;
3895: l_ar_invoice_xml_tmp XMLTYPE;
3896: l_missing_artrx_xml_tmp XMLTYPE;
3897: l_missing_artrx_xml XMLTYPE;
3898: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;

Line 3895: l_ar_invoice_xml_tmp XMLTYPE;

3891: l_unmatched_line_xml_tmp XMLTYPE;
3892: l_unmatched_line_xml XMLTYPE;
3893: l_xml_null XMLTYPE;
3894: l_ar_invoice_xml XMLTYPE;
3895: l_ar_invoice_xml_tmp XMLTYPE;
3896: l_missing_artrx_xml_tmp XMLTYPE;
3897: l_missing_artrx_xml XMLTYPE;
3898: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;
3899:

Line 3896: l_missing_artrx_xml_tmp XMLTYPE;

3892: l_unmatched_line_xml XMLTYPE;
3893: l_xml_null XMLTYPE;
3894: l_ar_invoice_xml XMLTYPE;
3895: l_ar_invoice_xml_tmp XMLTYPE;
3896: l_missing_artrx_xml_tmp XMLTYPE;
3897: l_missing_artrx_xml XMLTYPE;
3898: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;
3899:
3900: l_api_name VARCHAR2(50)

Line 3897: l_missing_artrx_xml XMLTYPE;

3893: l_xml_null XMLTYPE;
3894: l_ar_invoice_xml XMLTYPE;
3895: l_ar_invoice_xml_tmp XMLTYPE;
3896: l_missing_artrx_xml_tmp XMLTYPE;
3897: l_missing_artrx_xml XMLTYPE;
3898: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;
3899:
3900: l_api_name VARCHAR2(50)
3901: :='Generate_Discrepancy_Xml';

Line 4683: l_xml_output XMLTYPE;

4679: l_ar_trx_header_id NUMBER;
4680: l_header_difference BOOLEAN;
4681: l_line_difference BOOLEAN;
4682: l_has_unmatched BOOLEAN;
4683: l_xml_output XMLTYPE;
4684: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4685: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4686: l_ar_customer_name hz_parties.party_name%TYPE;
4687: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;

Line 5276: l_Parameter Xmltype;

5272: */
5273: l_procedure_name VARCHAR2(40):='Generate_Consol_Mapping_Rep';
5274: l_no_data_message VARCHAR2(500);
5275: l_consolidation_trx_id AR_Gta_Trx_Headers.GTA_TRX_HEADER_ID%TYPE;
5276: l_Parameter Xmltype;
5277: l_consolidation_trx Xmltype;
5278: l_consolidated_trxs Xmltype;
5279: l_consolidation_trxs Xmltype;
5280: l_report Xmltype;

Line 5277: l_consolidation_trx Xmltype;

5273: l_procedure_name VARCHAR2(40):='Generate_Consol_Mapping_Rep';
5274: l_no_data_message VARCHAR2(500);
5275: l_consolidation_trx_id AR_Gta_Trx_Headers.GTA_TRX_HEADER_ID%TYPE;
5276: l_Parameter Xmltype;
5277: l_consolidation_trx Xmltype;
5278: l_consolidated_trxs Xmltype;
5279: l_consolidation_trxs Xmltype;
5280: l_report Xmltype;
5281: l_consolidation_rows NUMBER;

Line 5278: l_consolidated_trxs Xmltype;

5274: l_no_data_message VARCHAR2(500);
5275: l_consolidation_trx_id AR_Gta_Trx_Headers.GTA_TRX_HEADER_ID%TYPE;
5276: l_Parameter Xmltype;
5277: l_consolidation_trx Xmltype;
5278: l_consolidated_trxs Xmltype;
5279: l_consolidation_trxs Xmltype;
5280: l_report Xmltype;
5281: l_consolidation_rows NUMBER;
5282: i NUMBER;

Line 5279: l_consolidation_trxs Xmltype;

5275: l_consolidation_trx_id AR_Gta_Trx_Headers.GTA_TRX_HEADER_ID%TYPE;
5276: l_Parameter Xmltype;
5277: l_consolidation_trx Xmltype;
5278: l_consolidated_trxs Xmltype;
5279: l_consolidation_trxs Xmltype;
5280: l_report Xmltype;
5281: l_consolidation_rows NUMBER;
5282: i NUMBER;
5283: l_consolidated_rows NUMBER;

Line 5280: l_report Xmltype;

5276: l_Parameter Xmltype;
5277: l_consolidation_trx Xmltype;
5278: l_consolidated_trxs Xmltype;
5279: l_consolidation_trxs Xmltype;
5280: l_report Xmltype;
5281: l_consolidation_rows NUMBER;
5282: i NUMBER;
5283: l_consolidated_rows NUMBER;
5284: l_no_data_flag VARCHAR2(1):='N';

Line 5527: RETURN XMLTYPE

5523: -- 25-Aug-2009 Allen Yang Modified for bug 8809860
5524: -- 02-Sep-2009 Allen Yang Modified for bug 8848696
5525: --==========================================================================
5526: FUNCTION Get_Consolidation_Trx(p_trx_header_id IN NUMBER)
5527: RETURN XMLTYPE
5528: IS
5529: /* Note: Due to FD change, the meaning of words 'consolidation' and 'consolidated'
5530: has been reversed in code.
5531: consolidated -- invoice which consists of several consolidation invoices

Line 5537: l_ret_xmlelement Xmltype;

5533: */
5534: l_procedure_name VARCHAR2(40):='Get_Consolidation_Trx';
5535: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5536: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5537: l_ret_xmlelement Xmltype;
5538:
5539: BEGIN
5540: --logging for debug
5541: IF (l_proc_level>=l_dbg_level)

Line 5639: RETURN XMLTYPE

5635: -- 25-Jul-2009 Allen Yang Created.
5636: -- 25-Aug-2009 Allen Yang Modified for bug 8809860
5637: --==========================================================================
5638: FUNCTION Get_Consolidated_Trxs(p_trx_header_id IN NUMBER)
5639: RETURN XMLTYPE
5640: IS
5641: /* Note: Due to FD change, the meaning of words 'consolidation' and 'consolidated'
5642: has been reversed in code.
5643: consolidated -- invoice which consists of several consolidation invoices

Line 5649: l_ret_xmlelement Xmltype;

5645: */
5646: l_procedure_name VARCHAR2(40):='Get_Consolidated_Trxs';
5647: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5648: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5649: l_ret_xmlelement Xmltype;
5650:
5651: BEGIN
5652: --logging for debug
5653: IF (l_proc_level>=l_dbg_level)