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

Line 532: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR

528: FETCH project_dates_csr into l_proj_start_date, l_proj_end_date ;
529: CLOSE project_dates_csr;
530:
531: IF (p_start_date_active NOT BETWEEN l_proj_start_date AND
532: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
533: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_proj_start_date AND
534: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
535:
536: fnd_message.set_name('PSP','PSP_PROJECT_NOT_ACTIVE');

Line 533: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_proj_start_date AND

529: CLOSE project_dates_csr;
530:
531: IF (p_start_date_active NOT BETWEEN l_proj_start_date AND
532: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
533: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_proj_start_date AND
534: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
535:
536: fnd_message.set_name('PSP','PSP_PROJECT_NOT_ACTIVE');
537: fnd_message.raise_error;

Line 534: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN

530:
531: IF (p_start_date_active NOT BETWEEN l_proj_start_date AND
532: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
533: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_proj_start_date AND
534: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
535:
536: fnd_message.set_name('PSP','PSP_PROJECT_NOT_ACTIVE');
537: fnd_message.raise_error;
538: END IF;

Line 546: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR

542: CLOSE task_dates_csr;
543:
544: IF p_task_id is not null AND
545: (p_start_date_active NOT BETWEEN l_task_start_date AND
546: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
547: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_task_start_date AND
548: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
549:
550: fnd_message.set_name('PSP','PSP_TASK_NOT_ACTIVE');

Line 547: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_task_start_date AND

543:
544: IF p_task_id is not null AND
545: (p_start_date_active NOT BETWEEN l_task_start_date AND
546: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
547: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_task_start_date AND
548: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
549:
550: fnd_message.set_name('PSP','PSP_TASK_NOT_ACTIVE');
551: fnd_message.raise_error;

Line 548: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN

544: IF p_task_id is not null AND
545: (p_start_date_active NOT BETWEEN l_task_start_date AND
546: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
547: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_task_start_date AND
548: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
549:
550: fnd_message.set_name('PSP','PSP_TASK_NOT_ACTIVE');
551: fnd_message.raise_error;
552: END IF;