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 1716: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_2)) start_date,

1712: CURSOR template_name_cur IS
1713: SELECT template_name,
1714: preview_effort_report_flag,
1715: notification_reminder_in_days,
1716: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_2)) start_date,
1717: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_3)) end_date
1718: FROM psp_report_templates_h prth
1719: WHERE prth.request_id = p_request_id;
1720:

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

1713: SELECT template_name,
1714: preview_effort_report_flag,
1715: notification_reminder_in_days,
1716: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_2)) start_date,
1717: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_3)) end_date
1718: FROM psp_report_templates_h prth
1719: WHERE prth.request_id = p_request_id;
1720:
1721: l_param_string VARCHAR2(2000);

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

1728: WHERE request_id = p_request_id;
1729:
1730: CURSOR get_param_strings IS
1731: SELECT prt.template_name,
1732: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), l_icx_date_format) start_date,
1733: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), l_icx_date_format) end_date,
1734: -- xtt.template_name report_layout,
1735: flv1.meaning sort_option1,
1736: flv2.meaning order_by1,

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

1729:
1730: CURSOR get_param_strings IS
1731: SELECT prt.template_name,
1732: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), l_icx_date_format) start_date,
1733: TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), l_icx_date_format) end_date,
1734: -- xtt.template_name report_layout,
1735: flv1.meaning sort_option1,
1736: flv2.meaning order_by1,
1737: flv3.meaning sort_option2,