DBA Data[Home] [Help]

APPS.PA_PROJ_STAT_ACTSET dependencies on PA_PROJECT_DATES_UTILS

Line 287: l_start_date := PA_PROJECT_DATES_UTILS.get_project_start_date(p_project_id);

283: l_sysdate DATE := TRUNC(sysdate);
284: l_start_date DATE := NULL;
285: l_end_date DATE := NULL;
286: BEGIN
287: l_start_date := PA_PROJECT_DATES_UTILS.get_project_start_date(p_project_id);
288: l_end_date := PA_PROJECT_DATES_UTILS.get_project_finish_date(p_project_id);
289: if (l_start_date is null or TRUNC(l_start_date) > l_sysdate) then
290: return 'N'; --do not process this one, project not started
291: end if;

Line 288: l_end_date := PA_PROJECT_DATES_UTILS.get_project_finish_date(p_project_id);

284: l_start_date DATE := NULL;
285: l_end_date DATE := NULL;
286: BEGIN
287: l_start_date := PA_PROJECT_DATES_UTILS.get_project_start_date(p_project_id);
288: l_end_date := PA_PROJECT_DATES_UTILS.get_project_finish_date(p_project_id);
289: if (l_start_date is null or TRUNC(l_start_date) > l_sysdate) then
290: return 'N'; --do not process this one, project not started
291: end if;
292: if (l_end_date is not null and TRUNC(l_end_date) <= l_sysdate) then