[Home] [Help]
11: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
13: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
14: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
15: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
16: ,p_number_of_requirements IN NUMBER := 1
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
96:
97: -- Bottom Up Flow
98: CURSOR get_bu_resource_assignments IS
99: SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
100: FROM PA_RESOURCE_ASSIGNMENTS ra
101: ,PA_BUDGET_VERSIONS bv
102: ,PA_PROJ_ELEM_VER_STRUCTURE evs
103: WHERE ra.project_id = bv.project_id
104: AND bv.project_id = evs.project_id
117: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
118: FROM
119: (
120: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
121: FROM PA_RESOURCE_ASSIGNMENTS ra
122: ,PA_BUDGET_VERSIONS bv
123: ,PA_PROJ_ELEM_VER_STRUCTURE evs
124: WHERE ra.project_id = bv.project_id
125: AND bv.project_id = evs.project_id
131: AND ra.project_assignment_id = -1
132: AND evs.status_code = 'STRUCTURE_WORKING')
133: UNION ALL
134: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
135: FROM PA_RESOURCE_ASSIGNMENTS ra
136: ,PA_BUDGET_VERSIONS bv
137: ,PA_PROJ_ELEM_VER_STRUCTURE evs
138: ,PA_PROJ_WORKPLAN_ATTR pwa
139: WHERE pwa.wp_enable_Version_flag = 'N'
892:
893: -- If multiple requirements are created, only the first requirement will be
894: -- linked to the task assignments.
895: -- Call planning_transaction_utils api to update project_assignment_id in
896: -- pa_resource_assignments table.
897: pa_assignments_pvt.Update_Task_Assignments(
898: p_mode => 'CREATE'
899: ,p_task_assignment_id_tbl => l_task_assignment_id_tbl
900: ,p_task_version_id_tbl => l_task_version_id_tbl
1232: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
1233: FROM
1234: (
1235: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1236: FROM PA_RESOURCE_ASSIGNMENTS ra
1237: ,PA_BUDGET_VERSIONS bv
1238: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1239: WHERE ra.project_id = bv.project_id
1240: AND bv.project_id = evs.project_id
1245: AND ra.project_assignment_id = -1
1246: AND evs.status_code = 'STRUCTURE_WORKING')
1247: UNION ALL
1248: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1249: FROM PA_RESOURCE_ASSIGNMENTS ra
1250: ,PA_BUDGET_VERSIONS bv
1251: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1252: ,PA_PROJ_WORKPLAN_ATTR pwa
1253: WHERE pwa.wp_enable_Version_flag = 'N'
1267: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
1268: FROM
1269: (
1270: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1271: FROM PA_RESOURCE_ASSIGNMENTS ra
1272: ,PA_BUDGET_VERSIONS bv
1273: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1274: WHERE ra.project_id = bv.project_id
1275: AND bv.project_id = evs.project_id
1279: AND ra.project_assignment_id = l_assignment_rec.assignment_id
1280: AND evs.status_code = 'STRUCTURE_WORKING')
1281: UNION ALL
1282: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1283: FROM PA_RESOURCE_ASSIGNMENTS ra
1284: ,PA_BUDGET_VERSIONS bv
1285: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1286: ,PA_PROJ_WORKPLAN_ATTR pwa
1287: WHERE pwa.wp_enable_Version_flag = 'N'
1453: END IF;
1454:
1455: IF l_assignment_rec.resource_list_member_id IS NOT NULL THEN
1456:
1457: -- 1. change the resource list member in pa_resource_assignments
1458: -- on the linked task assignments in all working versions.
1459:
1460: -- if original resource list member on the team role <>
1461: -- the rlm returned from the derive API above