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 350: query1 := 'SELECT TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), ''' || l_icx_date_format

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

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

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

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

2000: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
2001: AND pdf_request_id = g_request_id;
2002:
2003: CURSOR er_dates_cur IS
2004: SELECT fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)) start_date,
2005: fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)) end_date
2006: FROM psp_report_templates_h prth
2007: WHERE prth.request_id = p_request_id;
2008:

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

2001: AND pdf_request_id = g_request_id;
2002:
2003: CURSOR er_dates_cur IS
2004: SELECT fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)) start_date,
2005: fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)) end_date
2006: FROM psp_report_templates_h prth
2007: WHERE prth.request_id = p_request_id;
2008:
2009: l_start_date DATE;