[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
116: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
117: FROM
118: (
119: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
120: FROM PA_RESOURCE_ASSIGNMENTS ra
121: ,PA_BUDGET_VERSIONS bv
122: ,PA_PROJ_ELEM_VER_STRUCTURE evs
123: WHERE ra.project_id = bv.project_id
124: AND bv.project_id = evs.project_id
129: AND ra.project_assignment_id = -1
130: AND evs.status_code = 'STRUCTURE_WORKING')
131: UNION ALL
132: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
133: FROM PA_RESOURCE_ASSIGNMENTS ra
134: ,PA_BUDGET_VERSIONS bv
135: ,PA_PROJ_ELEM_VER_STRUCTURE evs
136: ,PA_PROJ_WORKPLAN_ATTR pwa
137: WHERE pwa.wp_enable_Version_flag = 'N'
886:
887: -- If multiple requirements are created, only the first requirement will be
888: -- linked to the task assignments.
889: -- Call planning_transaction_utils api to update project_assignment_id in
890: -- pa_resource_assignments table.
891: pa_assignments_pvt.Update_Task_Assignments(
892: p_mode => 'CREATE'
893: ,p_task_assignment_id_tbl => l_task_assignment_id_tbl
894: ,p_task_version_id_tbl => l_task_version_id_tbl
1226: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
1227: FROM
1228: (
1229: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1230: FROM PA_RESOURCE_ASSIGNMENTS ra
1231: ,PA_BUDGET_VERSIONS bv
1232: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1233: WHERE ra.project_id = bv.project_id
1234: AND bv.project_id = evs.project_id
1239: AND ra.project_assignment_id = -1
1240: AND evs.status_code = 'STRUCTURE_WORKING')
1241: UNION ALL
1242: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1243: FROM PA_RESOURCE_ASSIGNMENTS ra
1244: ,PA_BUDGET_VERSIONS bv
1245: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1246: ,PA_PROJ_WORKPLAN_ATTR pwa
1247: WHERE pwa.wp_enable_Version_flag = 'N'
1261: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
1262: FROM
1263: (
1264: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1265: FROM PA_RESOURCE_ASSIGNMENTS ra
1266: ,PA_BUDGET_VERSIONS bv
1267: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1268: WHERE ra.project_id = bv.project_id
1269: AND bv.project_id = evs.project_id
1273: AND ra.project_assignment_id = l_assignment_rec.assignment_id
1274: AND evs.status_code = 'STRUCTURE_WORKING')
1275: UNION ALL
1276: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1277: FROM PA_RESOURCE_ASSIGNMENTS ra
1278: ,PA_BUDGET_VERSIONS bv
1279: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1280: ,PA_PROJ_WORKPLAN_ATTR pwa
1281: WHERE pwa.wp_enable_Version_flag = 'N'
1447: END IF;
1448:
1449: IF l_assignment_rec.resource_list_member_id IS NOT NULL THEN
1450:
1451: -- 1. change the resource list member in pa_resource_assignments
1452: -- on the linked task assignments in all working versions.
1453:
1454: -- if original resource list member on the team role <>
1455: -- the rlm returned from the derive API above