APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_DATES_UTILS

Line 36: /* Commenting this query and selecting start date from PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE */

32: BEGIN
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: /* Bug 2636791 - changes begin */
36: /* Commenting this query and selecting start date from PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE */
37: /* select start_date, completion_date
38: into x_project_start_date, x_project_end_date
39: from pa_projects_all
40: where project_id = p_project_id; */

Line 42: SELECT PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE(p_project_id), completion_date

38: into x_project_start_date, x_project_end_date
39: from pa_projects_all
40: where project_id = p_project_id; */
41:
42: SELECT PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE(p_project_id), completion_date
43: INTO x_project_start_date, x_project_end_date
44: FROM pa_projects_all
45: WHERE project_id = p_project_id;
46:

Line 855: l_project_finish_date := PA_PROJECT_DATES_UTILS.Get_Project_Finish_Date(p_project_id);

851: BEGIN
852:
853: PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID := null;
854:
855: l_project_finish_date := PA_PROJECT_DATES_UTILS.Get_Project_Finish_Date(p_project_id);
856:
857: -- return project manager as of project finish date for past projects
858: IF l_project_finish_date < sysdate THEN
859: OPEN C1 (l_project_finish_date);

Line 864: l_project_start_date := PA_PROJECT_DATES_UTILS.Get_Project_Start_Date(p_project_id);

860: FETCH C1 INTO l_return_value;
861: CLOSE C1;
862: ELSE
863: -- Bug 4361712
864: l_project_start_date := PA_PROJECT_DATES_UTILS.Get_Project_Start_Date(p_project_id);
865:
866: -- return project manager as of project start date for future projects
867: IF l_project_start_date > sysdate THEN
868: OPEN C1 (l_project_start_date);

Line 935: l_project_finish_date := PA_PROJECT_DATES_UTILS.Get_Project_Finish_Date(p_project_id);

931: l_project_start_date DATE;
932:
933: BEGIN
934:
935: l_project_finish_date := PA_PROJECT_DATES_UTILS.Get_Project_Finish_Date(p_project_id);
936:
937: -- return project manager as of project finish date for past projects
938: IF l_project_finish_date < sysdate THEN
939: OPEN C1 (l_project_finish_date);

Line 945: l_project_start_date := PA_PROJECT_DATES_UTILS.Get_Project_Start_Date(p_project_id);

941: CLOSE C1;
942: ELSE
943:
944: -- 4361712
945: l_project_start_date := PA_PROJECT_DATES_UTILS.Get_Project_Start_Date(p_project_id);
946:
947: -- return project manager as of project start date for future projects
948: IF l_project_start_date > sysdate THEN
949: OPEN C1 (l_project_start_date);