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

Line 287: l_report xmltype;

283: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
284: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
285: l_output_msg VARCHAR2(2000);
286: l_no_data_flag VARCHAR2(1) := 'N';
287: l_report xmltype;
288: l_summary xmltype;
289: l_parameter xmltype;
290: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
291: l_ar_gta_gta_not_enabled VARCHAR2(500);

Line 288: l_summary xmltype;

284: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
285: l_output_msg VARCHAR2(2000);
286: l_no_data_flag VARCHAR2(1) := 'N';
287: l_report xmltype;
288: l_summary xmltype;
289: l_parameter xmltype;
290: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
291: l_ar_gta_gta_not_enabled VARCHAR2(500);
292: l_no_data_message VARCHAR2(500);

Line 289: l_parameter xmltype;

285: l_output_msg VARCHAR2(2000);
286: l_no_data_flag VARCHAR2(1) := 'N';
287: l_report xmltype;
288: l_summary xmltype;
289: l_parameter xmltype;
290: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
291: l_ar_gta_gta_not_enabled VARCHAR2(500);
292: l_no_data_message VARCHAR2(500);
293: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

Line 521: l_report xmltype;

517: l_ar_inv_date_from DATE;
518: l_ar_inv_date_to DATE;
519: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
520: l_ar_gta_gta_not_enabled VARCHAR2(500);
521: l_report xmltype;
522: l_parameter xmltype;
523: l_dbg_msg VARCHAR2(500);
524: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
525: l_proc_level NUMBER := fnd_log.level_procedure;

Line 522: l_parameter xmltype;

518: l_ar_inv_date_to DATE;
519: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
520: l_ar_gta_gta_not_enabled VARCHAR2(500);
521: l_report xmltype;
522: l_parameter xmltype;
523: l_dbg_msg VARCHAR2(500);
524: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
525: l_proc_level NUMBER := fnd_log.level_procedure;
526: l_org_id NUMBER := mo_global.get_current_org_id;

Line 1040: l_report_xml XMLTYPE;

1036: IS
1037: l_ar_gta_enabled VARCHAR2(10);
1038: l_dbg_msg VARCHAR2(500);
1039: l_ar_gta_not_enabled_msg VARCHAR2(1000);
1040: l_report_xml XMLTYPE;
1041: l_procedure_name VARCHAR2(50);
1042: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1043: l_proc_level NUMBER := fnd_log.level_procedure;
1044: l_org_id hr_all_organization_units.organization_id%TYPE;

Line 1646: l_report xmltype;

1642: IS
1643: l_procedure_name VARCHAR2(30) := 'Run_Consolidation_Mapping';
1644: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
1645: l_ar_gta_gta_not_enabled VARCHAR2(500);
1646: l_report xmltype;
1647: l_parameter xmltype;
1648: l_dbg_msg VARCHAR2(500);
1649: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1650: l_proc_level NUMBER := fnd_log.level_procedure;

Line 1647: l_parameter xmltype;

1643: l_procedure_name VARCHAR2(30) := 'Run_Consolidation_Mapping';
1644: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
1645: l_ar_gta_gta_not_enabled VARCHAR2(500);
1646: l_report xmltype;
1647: l_parameter xmltype;
1648: l_dbg_msg VARCHAR2(500);
1649: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1650: l_proc_level NUMBER := fnd_log.level_procedure;
1651: l_org_id NUMBER := mo_global.get_current_org_id;