[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
599: AND ra.project_assignment_id = p_assignment_id
600: AND evs.status_code = 'STRUCTURE_WORKING')
601: UNION ALL
602: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
603: FROM PA_RESOURCE_ASSIGNMENTS ra
604: ,PA_BUDGET_VERSIONS bv
605: ,PA_PROJ_ELEM_VER_STRUCTURE evs
606: ,PA_PROJ_WORKPLAN_ATTR pwa
607: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
1162: l_update_count := 0;
1163:
1164: SELECT project_id
1165: INTO l_project_id
1166: FROM pa_resource_assignments
1167: WHERE resource_assignment_id = l_task_assignment_id_tbl(1);
1168:
1169: FOR j IN l_task_assignment_id_tbl.FIRST .. l_task_assignment_id_tbl.LAST + 1 LOOP
1170: