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 1102: -- pa_resource_assignments table.

1098:
1099: -- If multiple requirements are created, only the first requirement will be
1100: -- linked to the task assignments.
1101: -- Call planning_transaction_utils api to update project_assignment_id in
1102: -- pa_resource_assignments table.
1103: pa_assignments_pvt.Update_Task_Assignments(
1104: p_mode => 'CREATE'
1105: ,p_task_assignment_id_tbl => l_task_assignment_id_tbl
1106: ,p_task_version_id_tbl => l_task_version_id_tbl

Line 1335: FROM PA_RESOURCE_ASSIGNMENTS ra

1331: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
1332: FROM
1333: (
1334: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1335: FROM PA_RESOURCE_ASSIGNMENTS ra
1336: ,PA_BUDGET_VERSIONS bv
1337: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1338: WHERE ra.project_id = bv.project_id
1339: AND bv.project_id = evs.project_id

Line 1348: FROM PA_RESOURCE_ASSIGNMENTS ra

1344: AND ra.project_assignment_id = -1
1345: AND evs.status_code = 'STRUCTURE_WORKING')
1346: UNION ALL
1347: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1348: FROM PA_RESOURCE_ASSIGNMENTS ra
1349: ,PA_BUDGET_VERSIONS bv
1350: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1351: ,PA_PROJ_WORKPLAN_ATTR pwa
1352: WHERE pwa.wp_enable_Version_flag = 'N'

Line 1370: FROM PA_RESOURCE_ASSIGNMENTS ra

1366: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
1367: FROM
1368: (
1369: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1370: FROM PA_RESOURCE_ASSIGNMENTS ra
1371: ,PA_BUDGET_VERSIONS bv
1372: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1373: WHERE ra.project_id = bv.project_id
1374: AND bv.project_id = evs.project_id

Line 1382: FROM PA_RESOURCE_ASSIGNMENTS ra

1378: AND ra.project_assignment_id = l_assignment_rec.assignment_id
1379: AND evs.status_code = 'STRUCTURE_WORKING')
1380: UNION ALL
1381: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1382: FROM PA_RESOURCE_ASSIGNMENTS ra
1383: ,PA_BUDGET_VERSIONS bv
1384: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1385: ,PA_PROJ_WORKPLAN_ATTR pwa
1386: WHERE pwa.wp_enable_Version_flag = 'N'

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

1687: END IF;
1688:
1689: IF l_assignment_rec.resource_list_member_id IS NOT NULL THEN
1690:
1691: -- 1. change the resource list member in pa_resource_assignments
1692: -- on the linked task assignments in all working versions.
1693:
1694: -- if original resource list member on the team role <>
1695: -- the rlm returned from the derive API above