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.FND_DIAG_REQUEST_ANALYZER dependencies on JTF_VARCHAR2_TABLE_4000

Line 131: form_keys jtf_varchar2_table_4000;

127: -- header to be displayed in a report
128: header1 jtf_diag_header;
129: --form view component
130: form_view jtf_diag_form;
131: form_keys jtf_varchar2_table_4000;
132: form_values jtf_varchar2_table_4000;
133: str_query VARCHAR2(2000);
134: str VARCHAR2(2000);
135: -- CP Request Analyser

Line 132: form_values jtf_varchar2_table_4000;

128: header1 jtf_diag_header;
129: --form view component
130: form_view jtf_diag_form;
131: form_keys jtf_varchar2_table_4000;
132: form_values jtf_varchar2_table_4000;
133: str_query VARCHAR2(2000);
134: str VARCHAR2(2000);
135: -- CP Request Analyser
136: p_req_id NUMBER;

Line 271: form_keys := jtf_varchar2_table_4000('Program', 'Application', 'Executable type', 'Executable file name or procedure',

267: FROM fnd_executables
268: WHERE application_id = proginfo.executable_application_id
269: AND executable_id = proginfo.executable_id;
270:
271: form_keys := jtf_varchar2_table_4000('Program', 'Application', 'Executable type', 'Executable file name or procedure',
272: 'Run alone flag', 'SRS flag', 'NLS compliant', 'Output file type');
273: form_values := jtf_varchar2_table_4000(proginfo.user_concurrent_program_name || ' (' || proginfo.concurrent_program_name || ')', conc_app_name,
274: m_buf || ' (' || proginfo.execution_method_code || ')', exe_file_name, proginfo.run_alone_flag, proginfo.srs_flag, proginfo.nls_compliant, proginfo.output_file_type);
275:

Line 273: form_values := jtf_varchar2_table_4000(proginfo.user_concurrent_program_name || ' (' || proginfo.concurrent_program_name || ')', conc_app_name,

269: AND executable_id = proginfo.executable_id;
270:
271: form_keys := jtf_varchar2_table_4000('Program', 'Application', 'Executable type', 'Executable file name or procedure',
272: 'Run alone flag', 'SRS flag', 'NLS compliant', 'Output file type');
273: form_values := jtf_varchar2_table_4000(proginfo.user_concurrent_program_name || ' (' || proginfo.concurrent_program_name || ')', conc_app_name,
274: m_buf || ' (' || proginfo.execution_method_code || ')', exe_file_name, proginfo.run_alone_flag, proginfo.srs_flag, proginfo.nls_compliant, proginfo.output_file_type);
275:
276: IF proginfo.concurrent_class_id IS NOT NULL THEN
277: SELECT request_class_name

Line 334: form_keys := jtf_varchar2_table_4000('It was submitted by user', 'Using responsibility', 'It was submitted on', 'It was requested to start on', 'Parent request id', 'Language', 'Territory', 'Priority', 'Arguments');

330: FROM fnd_responsibility_vl
331: WHERE responsibility_id = reqinfo.responsibility_id
332: AND application_id = reqinfo.responsibility_application_id;
333:
334: form_keys := jtf_varchar2_table_4000('It was submitted by user', 'Using responsibility', 'It was submitted on', 'It was requested to start on', 'Parent request id', 'Language', 'Territory', 'Priority', 'Arguments');
335: form_values := jtf_varchar2_table_4000(c_user, resp_name, to_char(reqinfo.request_date, 'DD-MON-RR HH24:MI:SS'), to_char(reqinfo.requested_start_date, 'DD-MON-RR HH24:MI:SS'),
336: reqinfo.parent_request_id, reqinfo.nls_language, reqinfo.nls_territory, to_char(reqinfo.priority), '(' || reqinfo.number_of_arguments || '): ' || reqinfo.argument_text);
337: form_view := jtf_diag_report_factory.create_form('Submission information', form_keys, form_values, reportcontext);
338: SECTION.add_form(form_view);

Line 335: form_values := jtf_varchar2_table_4000(c_user, resp_name, to_char(reqinfo.request_date, 'DD-MON-RR HH24:MI:SS'), to_char(reqinfo.requested_start_date, 'DD-MON-RR HH24:MI:SS'),

331: WHERE responsibility_id = reqinfo.responsibility_id
332: AND application_id = reqinfo.responsibility_application_id;
333:
334: form_keys := jtf_varchar2_table_4000('It was submitted by user', 'Using responsibility', 'It was submitted on', 'It was requested to start on', 'Parent request id', 'Language', 'Territory', 'Priority', 'Arguments');
335: form_values := jtf_varchar2_table_4000(c_user, resp_name, to_char(reqinfo.request_date, 'DD-MON-RR HH24:MI:SS'), to_char(reqinfo.requested_start_date, 'DD-MON-RR HH24:MI:SS'),
336: reqinfo.parent_request_id, reqinfo.nls_language, reqinfo.nls_territory, to_char(reqinfo.priority), '(' || reqinfo.number_of_arguments || '): ' || reqinfo.argument_text);
337: form_view := jtf_diag_report_factory.create_form('Submission information', form_keys, form_values, reportcontext);
338: SECTION.add_form(form_view);
339: