[Home] [Help]
15: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
16: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
17: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
18: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
19: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
20: ,p_number_of_requirements IN NUMBER := 1
21: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
23: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
583: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
584: FROM
585: (
586: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
587: FROM PA_RESOURCE_ASSIGNMENTS ra
588: ,PA_BUDGET_VERSIONS bv
589: ,PA_PROJ_ELEM_VER_STRUCTURE evs
590: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
591: WHERE ra.project_id = bv.project_id
598: AND ra.project_assignment_id = p_assignment_id
599: AND evs.status_code = 'STRUCTURE_WORKING')
600: UNION ALL
601: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
602: FROM PA_RESOURCE_ASSIGNMENTS ra
603: ,PA_BUDGET_VERSIONS bv
604: ,PA_PROJ_ELEM_VER_STRUCTURE evs
605: ,PA_PROJ_WORKPLAN_ATTR pwa
606: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
1154: l_update_count := 0;
1155:
1156: SELECT project_id
1157: INTO l_project_id
1158: FROM pa_resource_assignments
1159: WHERE resource_assignment_id = l_task_assignment_id_tbl(1);
1160:
1161: FOR j IN l_task_assignment_id_tbl.FIRST .. l_task_assignment_id_tbl.LAST + 1 LOOP
1162: