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 858: l_project_finish_date := PA_PROJECT_DATES_UTILS.Get_Project_Finish_Date(p_project_id);

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

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

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

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

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

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

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