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

Line 280: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,

276: c.ELEMENT_TYPE_ID ELEMENT_TYPE_ID,
277: d.SCHEDULE_LINE_ID SCHEDULE_LINE_ID,
278: d.SCHEDULE_BEGIN_DATE SCHEDULE_BEGIN_DATE,
279: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
280: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
281: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
282: from PER_ASSIGNMENTS_F a,
283: PSP_SCHEDULES b,
284: PSP_SCHEDULE_HIERARCHY c,

Line 281: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE

277: d.SCHEDULE_LINE_ID SCHEDULE_LINE_ID,
278: d.SCHEDULE_BEGIN_DATE SCHEDULE_BEGIN_DATE,
279: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
280: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
281: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
282: from PER_ASSIGNMENTS_F a,
283: PSP_SCHEDULES b,
284: PSP_SCHEDULE_HIERARCHY c,
285: PSP_SCHEDULE_LINES d,

Line 463: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,

459: f.ELEMENT_TYPE_ID ELEMENT_TYPE_ID,
460: d.SCHEDULE_LINE_ID SCHEDULE_LINE_ID,
461: d.SCHEDULE_BEGIN_DATE SCHEDULE_BEGIN_DATE,
462: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
463: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
464: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
465: from PER_ASSIGNMENTS_F a,
466: PSP_SCHEDULES b,
467: PSP_SCHEDULE_HIERARCHY c,

Line 464: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE

460: d.SCHEDULE_LINE_ID SCHEDULE_LINE_ID,
461: d.SCHEDULE_BEGIN_DATE SCHEDULE_BEGIN_DATE,
462: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
463: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
464: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
465: from PER_ASSIGNMENTS_F a,
466: PSP_SCHEDULES b,
467: PSP_SCHEDULE_HIERARCHY c,
468: PSP_SCHEDULE_LINES d,

Line 732: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,

728: c.ELEMENT_TYPE_ID ELEMENT_TYPE_ID,
729: d.SCHEDULE_LINE_ID SCHEDULE_LINE_ID,
730: d.SCHEDULE_BEGIN_DATE SCHEDULE_BEGIN_DATE,
731: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
732: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
733: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
734: from PER_ASSIGNMENTS_F a,
735: PSP_SCHEDULES b,
736: PSP_SCHEDULE_HIERARCHY c,

Line 733: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE

729: d.SCHEDULE_LINE_ID SCHEDULE_LINE_ID,
730: d.SCHEDULE_BEGIN_DATE SCHEDULE_BEGIN_DATE,
731: d.SCHEDULE_END_DATE SCHEDULE_END_DATE,
732: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_start_date) ||''') TIME_PERIOD_START_DATE,
733: fnd_date.canonical_to_date('''|| fnd_date.date_to_canonical(p_end_date) ||''') TIME_PERIOD_END_DATE
734: from PER_ASSIGNMENTS_F a,
735: PSP_SCHEDULES b,
736: PSP_SCHEDULE_HIERARCHY c,
737: PSP_SCHEDULE_LINES d,