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.PSP_XMLGEN dependencies on FND_DATE

Line 53: || 'TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), ''' || l_icx_date_format

49: FETCH user_name_cur INTO l_user_name;
50: CLOSE user_name_cur;
51:
52: query1 := 'select xtt.template_name report_layout, prth.template_name, '
53: || 'TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), ''' || l_icx_date_format
54: || ''') start_date, TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), '''
55: || l_icx_date_format || ''') end_date, SUBSTR(prth.report_template_code, 6, 3) layout_type, flv1.meaning sort_option1, '
56: || 'flv2.meaning order_by1, flv3.meaning sort_option2, flv4.meaning order_by2, '
57: || 'flv5.meaning sort_option3, flv6.meaning order_by3, flv7.meaning sort_option4, flv8.meaning order_by4, '

Line 54: || ''') start_date, TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), '''

50: CLOSE user_name_cur;
51:
52: query1 := 'select xtt.template_name report_layout, prth.template_name, '
53: || 'TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), ''' || l_icx_date_format
54: || ''') start_date, TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), '''
55: || l_icx_date_format || ''') end_date, SUBSTR(prth.report_template_code, 6, 3) layout_type, flv1.meaning sort_option1, '
56: || 'flv2.meaning order_by1, flv3.meaning sort_option2, flv4.meaning order_by2, '
57: || 'flv5.meaning sort_option3, flv6.meaning order_by3, flv7.meaning sort_option4, flv8.meaning order_by4, '
58: || 'DECODE(prth.initiator_person_id, -1, ''' || l_user_name || ''', '

Line 352: query1 := 'SELECT TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), ''' || l_icx_date_format

348: CLOSE get_segment_header_cur;
349:
350: l_report_info := ' ';
351:
352: query1 := 'SELECT TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), ''' || l_icx_date_format
353: || ''') start_date, TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), '''
354: || l_icx_date_format || ''') end_date, ''' || l_display_flag || ''' display_flag, ''' || l_gl_header || ''' gl_header, '
355: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') run_date '
356: || 'FROM psp_report_templates_h prth WHERE prth.request_id = ' || TO_CHAR(l_request_id);

Line 353: || ''') start_date, TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), '''

349:
350: l_report_info := ' ';
351:
352: query1 := 'SELECT TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), ''' || l_icx_date_format
353: || ''') start_date, TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), '''
354: || l_icx_date_format || ''') end_date, ''' || l_display_flag || ''' display_flag, ''' || l_gl_header || ''' gl_header, '
355: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') run_date '
356: || 'FROM psp_report_templates_h prth WHERE prth.request_id = ' || TO_CHAR(l_request_id);
357: qryCtx1 := dbms_xmlgen.newContext(query1);

Line 2163: SELECT fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)) start_date,

2159: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
2160: AND pdf_request_id = g_request_id;
2161:
2162: CURSOR er_dates_cur IS
2163: SELECT fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)) start_date,
2164: fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)) end_date
2165: FROM psp_report_templates_h prth
2166: WHERE prth.request_id = p_request_id;
2167:

Line 2164: fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)) end_date

2160: AND pdf_request_id = g_request_id;
2161:
2162: CURSOR er_dates_cur IS
2163: SELECT fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)) start_date,
2164: fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)) end_date
2165: FROM psp_report_templates_h prth
2166: WHERE prth.request_id = p_request_id;
2167:
2168: l_start_date DATE;