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

Line 268: l_report xmltype;

264: l_source jmf_gta_trx_headers_all.SOURCE%TYPE;
265: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
266: l_output_msg VARCHAR2(2000);
267: l_no_data_flag VARCHAR2(1) := 'N';
268: l_report xmltype;
269: l_summary xmltype;
270: l_parameter xmltype;
271: l_jmf_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
272: l_jmf_gta_gta_not_enabled VARCHAR2(500);

Line 269: l_summary xmltype;

265: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
266: l_output_msg VARCHAR2(2000);
267: l_no_data_flag VARCHAR2(1) := 'N';
268: l_report xmltype;
269: l_summary xmltype;
270: l_parameter xmltype;
271: l_jmf_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
272: l_jmf_gta_gta_not_enabled VARCHAR2(500);
273: l_no_data_message VARCHAR2(500);

Line 270: l_parameter xmltype;

266: l_output_msg VARCHAR2(2000);
267: l_no_data_flag VARCHAR2(1) := 'N';
268: l_report xmltype;
269: l_summary xmltype;
270: l_parameter xmltype;
271: l_jmf_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
272: l_jmf_gta_gta_not_enabled VARCHAR2(500);
273: l_no_data_message VARCHAR2(500);
274: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

Line 502: l_report xmltype;

498: l_ar_inv_date_from DATE;
499: l_ar_inv_date_to DATE;
500: l_jmf_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
501: l_jmf_gta_gta_not_enabled VARCHAR2(500);
502: l_report xmltype;
503: l_parameter xmltype;
504: l_dbg_msg VARCHAR2(500);
505: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
506: l_proc_level NUMBER := fnd_log.level_procedure;

Line 503: l_parameter xmltype;

499: l_ar_inv_date_to DATE;
500: l_jmf_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
501: l_jmf_gta_gta_not_enabled VARCHAR2(500);
502: l_report xmltype;
503: l_parameter xmltype;
504: l_dbg_msg VARCHAR2(500);
505: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
506: l_proc_level NUMBER := fnd_log.level_procedure;
507: l_org_id NUMBER := mo_global.get_current_org_id;

Line 1016: l_report_xml XMLTYPE;

1012: IS
1013: l_jmf_gta_enabled VARCHAR2(10);
1014: l_dbg_msg VARCHAR2(500);
1015: l_jmf_gta_not_enabled_msg VARCHAR2(1000);
1016: l_report_xml XMLTYPE;
1017: l_procedure_name VARCHAR2(50);
1018: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1019: l_proc_level NUMBER := fnd_log.level_procedure;
1020: l_org_id hr_all_organization_units.organization_id%TYPE;