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

Line 171: -- Return: XMLTYPE

167: -- P_Gt_Inv_Num_From Golden Tax Invoice Number from
168: -- P_Gt_Inv_Num_To Golden Tax Invoice Number to
169: -- Out:
170: --
171: -- Return: XMLTYPE
172: --
173: --
174: -- DESIGN REFERENCES:
175: -- GTA_REPORTS_TD.doc

Line 194: RETURN XMLTYPE

190: , P_Gt_Inv_Date_To IN DATE
191: , P_Gt_Inv_Num_From IN VARCHAR2
192: , P_Gt_Inv_Num_To IN VARCHAR2
193: )
194: RETURN XMLTYPE
195: IS
196: l_procedure_name VARCHAR2(40):='Get_Ar_Trx';
197: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
198: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 200: l_ret_xmlelement Xmltype;

196: l_procedure_name VARCHAR2(40):='Get_Ar_Trx';
197: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
198: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
199:
200: l_ret_xmlelement Xmltype;
201: BEGIN
202: --logging for debug
203: IF (l_proc_level>=l_dbg_level)
204: THEN

Line 331: -- Return: XMLTYPE

327: -- P_Gt_Inv_Num_To Golden Tax Invoice Number to
328: --
329: -- Out:
330: --
331: -- Return: XMLTYPE
332: --
333: --
334: -- DESIGN REFERENCES:
335: -- GTA_REPORTS_TD.doc

Line 352: RETURN Xmltype

348: , P_Gt_Inv_Date_To IN DATE
349: , P_Gt_Inv_Num_From IN VARCHAR2
350: , P_Gt_Inv_Num_To IN VARCHAR2
351: )
352: RETURN Xmltype
353: IS
354: l_procedure_name VARCHAR2(40):='Get_Gt_Trxs';
355: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
356: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 358: l_Ret_Xmlelement Xmltype;

354: l_procedure_name VARCHAR2(40):='Get_Gt_Trxs';
355: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
356: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
357:
358: l_Ret_Xmlelement Xmltype;
359: l_count NUMBER;
360: BEGIN
361: --logging for debug
362: IF (l_proc_level>=l_dbg_level)

Line 483: l_Parameter Xmltype;

479: IS
480: l_procedure_name VARCHAR2(40):='Generate_Mapping_Rep';
481: l_no_data_message VARCHAR2(500);
482: l_Ar_Trx_Id Jmf_Gta_Trx_Headers.Ra_Trx_Id%TYPE;
483: l_Parameter Xmltype;
484: l_Summary Xmltype;
485: L_gt_currency Xmltype;
486: l_Ar_Trx Xmltype;
487: l_Gt_Invoices Xmltype;

Line 484: l_Summary Xmltype;

480: l_procedure_name VARCHAR2(40):='Generate_Mapping_Rep';
481: l_no_data_message VARCHAR2(500);
482: l_Ar_Trx_Id Jmf_Gta_Trx_Headers.Ra_Trx_Id%TYPE;
483: l_Parameter Xmltype;
484: l_Summary Xmltype;
485: L_gt_currency Xmltype;
486: l_Ar_Trx Xmltype;
487: l_Gt_Invoices Xmltype;
488: l_ar_trxs xmltype;

Line 485: L_gt_currency Xmltype;

481: l_no_data_message VARCHAR2(500);
482: l_Ar_Trx_Id Jmf_Gta_Trx_Headers.Ra_Trx_Id%TYPE;
483: l_Parameter Xmltype;
484: l_Summary Xmltype;
485: L_gt_currency Xmltype;
486: l_Ar_Trx Xmltype;
487: l_Gt_Invoices Xmltype;
488: l_ar_trxs xmltype;
489: l_Report Xmltype;

Line 486: l_Ar_Trx Xmltype;

482: l_Ar_Trx_Id Jmf_Gta_Trx_Headers.Ra_Trx_Id%TYPE;
483: l_Parameter Xmltype;
484: l_Summary Xmltype;
485: L_gt_currency Xmltype;
486: l_Ar_Trx Xmltype;
487: l_Gt_Invoices Xmltype;
488: l_ar_trxs xmltype;
489: l_Report Xmltype;
490: l_Ar_Rows NUMBER;

Line 487: l_Gt_Invoices Xmltype;

483: l_Parameter Xmltype;
484: l_Summary Xmltype;
485: L_gt_currency Xmltype;
486: l_Ar_Trx Xmltype;
487: l_Gt_Invoices Xmltype;
488: l_ar_trxs xmltype;
489: l_Report Xmltype;
490: l_Ar_Rows NUMBER;
491: I NUMBER;

Line 488: l_ar_trxs xmltype;

484: l_Summary Xmltype;
485: L_gt_currency Xmltype;
486: l_Ar_Trx Xmltype;
487: l_Gt_Invoices Xmltype;
488: l_ar_trxs xmltype;
489: l_Report Xmltype;
490: l_Ar_Rows NUMBER;
491: I NUMBER;
492: l_Gt_Rows NUMBER;

Line 489: l_Report Xmltype;

485: L_gt_currency Xmltype;
486: l_Ar_Trx Xmltype;
487: l_Gt_Invoices Xmltype;
488: l_ar_trxs xmltype;
489: l_Report Xmltype;
490: l_Ar_Rows NUMBER;
491: I NUMBER;
492: l_Gt_Rows NUMBER;
493: l_no_data_flag VARCHAR2(1):='N';

Line 3651: , x_output OUT NOCOPY XMLTYPE

3647: , p_primary_sales IN NUMBER
3648: , p_validated_lines_total IN NUMBER
3649: , p_ar_matching_lines_total IN NUMBER
3650: , p_ar_partially_import_total IN NUMBER
3651: , x_output OUT NOCOPY XMLTYPE
3652: )
3653: IS
3654: l_operating_unit hr_operating_units.name%TYPE;
3655: l_customer_name hz_parties.party_name%TYPE;

Line 3702: l_parameter_xml XMLTYPE;

3698: l_ar_partially_import_total NUMBER
3699: :=p_ar_partially_import_total;
3700: l_ar_line_notmatching_total NUMBER;
3701: l_ar_missingtrx_total NUMBER;
3702: l_parameter_xml XMLTYPE;
3703: l_summary_xml XMLTYPE;
3704: l_report_xml XMLTYPE;
3705: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3706: l_gta_header_xml_tmp XMLTYPE;

Line 3703: l_summary_xml XMLTYPE;

3699: :=p_ar_partially_import_total;
3700: l_ar_line_notmatching_total NUMBER;
3701: l_ar_missingtrx_total NUMBER;
3702: l_parameter_xml XMLTYPE;
3703: l_summary_xml XMLTYPE;
3704: l_report_xml XMLTYPE;
3705: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3706: l_gta_header_xml_tmp XMLTYPE;
3707: l_gta_header_xml XMLTYPE;

Line 3704: l_report_xml XMLTYPE;

3700: l_ar_line_notmatching_total NUMBER;
3701: l_ar_missingtrx_total NUMBER;
3702: l_parameter_xml XMLTYPE;
3703: l_summary_xml XMLTYPE;
3704: l_report_xml XMLTYPE;
3705: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3706: l_gta_header_xml_tmp XMLTYPE;
3707: l_gta_header_xml XMLTYPE;
3708: l_gta_line_xml_tmp XMLTYPE;

Line 3706: l_gta_header_xml_tmp XMLTYPE;

3702: l_parameter_xml XMLTYPE;
3703: l_summary_xml XMLTYPE;
3704: l_report_xml XMLTYPE;
3705: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3706: l_gta_header_xml_tmp XMLTYPE;
3707: l_gta_header_xml XMLTYPE;
3708: l_gta_line_xml_tmp XMLTYPE;
3709: l_gta_line_xml XMLTYPE;
3710: l_missing_line_xml_tmp XMLTYPE;

Line 3707: l_gta_header_xml XMLTYPE;

3703: l_summary_xml XMLTYPE;
3704: l_report_xml XMLTYPE;
3705: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3706: l_gta_header_xml_tmp XMLTYPE;
3707: l_gta_header_xml XMLTYPE;
3708: l_gta_line_xml_tmp XMLTYPE;
3709: l_gta_line_xml XMLTYPE;
3710: l_missing_line_xml_tmp XMLTYPE;
3711: l_missing_line_xml XMLTYPE;

Line 3708: l_gta_line_xml_tmp XMLTYPE;

3704: l_report_xml XMLTYPE;
3705: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3706: l_gta_header_xml_tmp XMLTYPE;
3707: l_gta_header_xml XMLTYPE;
3708: l_gta_line_xml_tmp XMLTYPE;
3709: l_gta_line_xml XMLTYPE;
3710: l_missing_line_xml_tmp XMLTYPE;
3711: l_missing_line_xml XMLTYPE;
3712: l_unmatched_line_xml_tmp XMLTYPE;

Line 3709: l_gta_line_xml XMLTYPE;

3705: l_ar_trx_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3706: l_gta_header_xml_tmp XMLTYPE;
3707: l_gta_header_xml XMLTYPE;
3708: l_gta_line_xml_tmp XMLTYPE;
3709: l_gta_line_xml XMLTYPE;
3710: l_missing_line_xml_tmp XMLTYPE;
3711: l_missing_line_xml XMLTYPE;
3712: l_unmatched_line_xml_tmp XMLTYPE;
3713: l_unmatched_line_xml XMLTYPE;

Line 3710: l_missing_line_xml_tmp XMLTYPE;

3706: l_gta_header_xml_tmp XMLTYPE;
3707: l_gta_header_xml XMLTYPE;
3708: l_gta_line_xml_tmp XMLTYPE;
3709: l_gta_line_xml XMLTYPE;
3710: l_missing_line_xml_tmp XMLTYPE;
3711: l_missing_line_xml XMLTYPE;
3712: l_unmatched_line_xml_tmp XMLTYPE;
3713: l_unmatched_line_xml XMLTYPE;
3714: l_xml_null XMLTYPE;

Line 3711: l_missing_line_xml XMLTYPE;

3707: l_gta_header_xml XMLTYPE;
3708: l_gta_line_xml_tmp XMLTYPE;
3709: l_gta_line_xml XMLTYPE;
3710: l_missing_line_xml_tmp XMLTYPE;
3711: l_missing_line_xml XMLTYPE;
3712: l_unmatched_line_xml_tmp XMLTYPE;
3713: l_unmatched_line_xml XMLTYPE;
3714: l_xml_null XMLTYPE;
3715: l_ar_invoice_xml XMLTYPE;

Line 3712: l_unmatched_line_xml_tmp XMLTYPE;

3708: l_gta_line_xml_tmp XMLTYPE;
3709: l_gta_line_xml XMLTYPE;
3710: l_missing_line_xml_tmp XMLTYPE;
3711: l_missing_line_xml XMLTYPE;
3712: l_unmatched_line_xml_tmp XMLTYPE;
3713: l_unmatched_line_xml XMLTYPE;
3714: l_xml_null XMLTYPE;
3715: l_ar_invoice_xml XMLTYPE;
3716: l_ar_invoice_xml_tmp XMLTYPE;

Line 3713: l_unmatched_line_xml XMLTYPE;

3709: l_gta_line_xml XMLTYPE;
3710: l_missing_line_xml_tmp XMLTYPE;
3711: l_missing_line_xml XMLTYPE;
3712: l_unmatched_line_xml_tmp XMLTYPE;
3713: l_unmatched_line_xml XMLTYPE;
3714: l_xml_null XMLTYPE;
3715: l_ar_invoice_xml XMLTYPE;
3716: l_ar_invoice_xml_tmp XMLTYPE;
3717: l_missing_artrx_xml_tmp XMLTYPE;

Line 3714: l_xml_null XMLTYPE;

3710: l_missing_line_xml_tmp XMLTYPE;
3711: l_missing_line_xml XMLTYPE;
3712: l_unmatched_line_xml_tmp XMLTYPE;
3713: l_unmatched_line_xml XMLTYPE;
3714: l_xml_null XMLTYPE;
3715: l_ar_invoice_xml XMLTYPE;
3716: l_ar_invoice_xml_tmp XMLTYPE;
3717: l_missing_artrx_xml_tmp XMLTYPE;
3718: l_missing_artrx_xml XMLTYPE;

Line 3715: l_ar_invoice_xml XMLTYPE;

3711: l_missing_line_xml XMLTYPE;
3712: l_unmatched_line_xml_tmp XMLTYPE;
3713: l_unmatched_line_xml XMLTYPE;
3714: l_xml_null XMLTYPE;
3715: l_ar_invoice_xml XMLTYPE;
3716: l_ar_invoice_xml_tmp XMLTYPE;
3717: l_missing_artrx_xml_tmp XMLTYPE;
3718: l_missing_artrx_xml XMLTYPE;
3719: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;

Line 3716: l_ar_invoice_xml_tmp XMLTYPE;

3712: l_unmatched_line_xml_tmp XMLTYPE;
3713: l_unmatched_line_xml XMLTYPE;
3714: l_xml_null XMLTYPE;
3715: l_ar_invoice_xml XMLTYPE;
3716: l_ar_invoice_xml_tmp XMLTYPE;
3717: l_missing_artrx_xml_tmp XMLTYPE;
3718: l_missing_artrx_xml XMLTYPE;
3719: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;
3720:

Line 3717: l_missing_artrx_xml_tmp XMLTYPE;

3713: l_unmatched_line_xml XMLTYPE;
3714: l_xml_null XMLTYPE;
3715: l_ar_invoice_xml XMLTYPE;
3716: l_ar_invoice_xml_tmp XMLTYPE;
3717: l_missing_artrx_xml_tmp XMLTYPE;
3718: l_missing_artrx_xml XMLTYPE;
3719: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;
3720:
3721: l_api_name VARCHAR2(50)

Line 3718: l_missing_artrx_xml XMLTYPE;

3714: l_xml_null XMLTYPE;
3715: l_ar_invoice_xml XMLTYPE;
3716: l_ar_invoice_xml_tmp XMLTYPE;
3717: l_missing_artrx_xml_tmp XMLTYPE;
3718: l_missing_artrx_xml XMLTYPE;
3719: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;
3720:
3721: l_api_name VARCHAR2(50)
3722: :='Generate_Discrepancy_Xml';

Line 4479: l_xml_output XMLTYPE;

4475: l_ar_trx_header_id NUMBER;
4476: l_header_difference BOOLEAN;
4477: l_line_difference BOOLEAN;
4478: l_has_unmatched BOOLEAN;
4479: l_xml_output XMLTYPE;
4480: l_ar_trx_number ra_customer_trx_all.trx_number%TYPE;
4481: l_ar_trx_date ra_customer_trx_all.trx_date%TYPE;
4482: l_ar_customer_name hz_parties.party_name%TYPE;
4483: l_ar_currency_code ra_customer_trx_all.invoice_currency_code%TYPE;