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_ER_WORKFLOW dependencies on FND_DATE

Line 1676: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_2)) start_date,

1672: CURSOR template_name_cur IS
1673: SELECT template_name,
1674: preview_effort_report_flag,
1675: notification_reminder_in_days,
1676: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_2)) start_date,
1677: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_3)) end_date
1678: FROM psp_report_templates_h prth
1679: WHERE prth.request_id = p_request_id;
1680:

Line 1677: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_3)) end_date

1673: SELECT template_name,
1674: preview_effort_report_flag,
1675: notification_reminder_in_days,
1676: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_2)) start_date,
1677: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_3)) end_date
1678: FROM psp_report_templates_h prth
1679: WHERE prth.request_id = p_request_id;
1680:
1681: l_param_string VARCHAR2(2000);

Line 1692: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), l_icx_date_format) start_date,

1688: WHERE request_id = p_request_id;
1689:
1690: CURSOR get_param_strings IS
1691: SELECT prt.template_name,
1692: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), l_icx_date_format) start_date,
1693: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), l_icx_date_format) end_date,
1694: -- xtt.template_name report_layout,
1695: flv1.meaning sort_option1,
1696: flv2.meaning order_by1,

Line 1693: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), l_icx_date_format) end_date,

1689:
1690: CURSOR get_param_strings IS
1691: SELECT prt.template_name,
1692: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), l_icx_date_format) start_date,
1693: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), l_icx_date_format) end_date,
1694: -- xtt.template_name report_layout,
1695: flv1.meaning sort_option1,
1696: flv2.meaning order_by1,
1697: flv3.meaning sort_option2,