eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
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
20: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895

Line 99: FROM PA_RESOURCE_ASSIGNMENTS ra

95:
96: -- Bottom Up Flow
97: CURSOR get_bu_resource_assignments IS
98: SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
99: FROM PA_RESOURCE_ASSIGNMENTS ra
100: ,PA_BUDGET_VERSIONS bv
101: ,PA_PROJ_ELEM_VER_STRUCTURE evs
102: WHERE ra.project_id = bv.project_id
103: AND bv.project_id = evs.project_id

Line 120: FROM PA_RESOURCE_ASSIGNMENTS ra

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

Line 134: FROM PA_RESOURCE_ASSIGNMENTS ra

130: AND ra.project_assignment_id = -1
131: AND evs.status_code = 'STRUCTURE_WORKING')
132: UNION ALL
133: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
134: FROM PA_RESOURCE_ASSIGNMENTS ra
135: ,PA_BUDGET_VERSIONS bv
136: ,PA_PROJ_ELEM_VER_STRUCTURE evs
137: ,PA_PROJ_WORKPLAN_ATTR pwa
138: WHERE pwa.wp_enable_Version_flag = 'N'

Line 1133: -- pa_resource_assignments table.

1129:
1130: -- If multiple requirements are created, only the first requirement will be
1131: -- linked to the task assignments.
1132: -- Call planning_transaction_utils api to update project_assignment_id in
1133: -- pa_resource_assignments table.
1134: pa_assignments_pvt.Update_Task_Assignments(
1135: p_mode => 'CREATE'
1136: ,p_task_assignment_id_tbl => l_task_assignment_id_tbl
1137: ,p_task_version_id_tbl => l_task_version_id_tbl

Line 1366: FROM PA_RESOURCE_ASSIGNMENTS ra

1362: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
1363: FROM
1364: (
1365: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1366: FROM PA_RESOURCE_ASSIGNMENTS ra
1367: ,PA_BUDGET_VERSIONS bv
1368: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1369: WHERE ra.project_id = bv.project_id
1370: AND bv.project_id = evs.project_id

Line 1379: FROM PA_RESOURCE_ASSIGNMENTS ra

1375: AND ra.project_assignment_id = -1
1376: AND evs.status_code = 'STRUCTURE_WORKING')
1377: UNION ALL
1378: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1379: FROM PA_RESOURCE_ASSIGNMENTS ra
1380: ,PA_BUDGET_VERSIONS bv
1381: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1382: ,PA_PROJ_WORKPLAN_ATTR pwa
1383: WHERE pwa.wp_enable_Version_flag = 'N'

Line 1401: FROM PA_RESOURCE_ASSIGNMENTS ra

1397: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
1398: FROM
1399: (
1400: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1401: FROM PA_RESOURCE_ASSIGNMENTS ra
1402: ,PA_BUDGET_VERSIONS bv
1403: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1404: WHERE ra.project_id = bv.project_id
1405: AND bv.project_id = evs.project_id

Line 1413: FROM PA_RESOURCE_ASSIGNMENTS ra

1409: AND ra.project_assignment_id = l_assignment_rec.assignment_id
1410: AND evs.status_code = 'STRUCTURE_WORKING')
1411: UNION ALL
1412: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1413: FROM PA_RESOURCE_ASSIGNMENTS ra
1414: ,PA_BUDGET_VERSIONS bv
1415: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1416: ,PA_PROJ_WORKPLAN_ATTR pwa
1417: WHERE pwa.wp_enable_Version_flag = 'N'

Line 1722: -- 1. change the resource list member in pa_resource_assignments

1718: END IF;
1719:
1720: IF l_assignment_rec.resource_list_member_id IS NOT NULL THEN
1721:
1722: -- 1. change the resource list member in pa_resource_assignments
1723: -- on the linked task assignments in all working versions.
1724:
1725: -- if original resource list member on the team role <>
1726: -- the rlm returned from the derive API above