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_ASSIGNMENTS_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

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

80: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
81: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
82: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM
83: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
84: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
85: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
86: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
87: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
88: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

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

874: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
875: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
876: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
877: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
878: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
879: ,p_number_of_requirements IN NUMBER := 1
880: ,p_api_version IN NUMBER := 1.0
881: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
882: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 2138: FROM PA_RESOURCE_ASSIGNMENTS ra

2134: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
2135: FROM
2136: (
2137: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2138: FROM PA_RESOURCE_ASSIGNMENTS ra
2139: ,PA_BUDGET_VERSIONS bv
2140: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2141: WHERE ra.project_id = bv.project_id
2142: AND bv.project_id = evs.project_id

Line 2150: FROM PA_RESOURCE_ASSIGNMENTS ra

2146: AND ra.project_assignment_id = l_assignment_rec.source_assignment_id
2147: AND evs.status_code = 'STRUCTURE_WORKING')
2148: UNION ALL
2149: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2150: FROM PA_RESOURCE_ASSIGNMENTS ra
2151: ,PA_BUDGET_VERSIONS bv
2152: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2153: ,PA_PROJ_WORKPLAN_ATTR pwa
2154: WHERE pwa.wp_enable_Version_flag = 'N'

Line 2171: FROM PA_RESOURCE_ASSIGNMENTS ra

2167: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id, task_id
2168: FROM
2169: (
2170: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2171: FROM PA_RESOURCE_ASSIGNMENTS ra
2172: ,PA_BUDGET_VERSIONS bv
2173: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2174: WHERE ra.project_id = bv.project_id
2175: AND bv.project_id = evs.project_id

Line 2183: FROM PA_RESOURCE_ASSIGNMENTS ra

2179: AND ra.project_assignment_id = l_assignment_rec.source_assignment_id
2180: AND evs.status_code = 'STRUCTURE_WORKING')
2181: UNION ALL
2182: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2183: FROM PA_RESOURCE_ASSIGNMENTS ra
2184: ,PA_BUDGET_VERSIONS bv
2185: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2186: ,PA_PROJ_WORKPLAN_ATTR pwa
2187: WHERE pwa.wp_enable_Version_flag = 'N'

Line 2200: FROM pa_resource_assignments ra

2196: ) linked_res_asgmts
2197: WHERE NOT EXISTS
2198: (
2199: SELECT *
2200: FROM pa_resource_assignments ra
2201: WHERE ra.budget_version_id = linked_res_asgmts.budget_version_id
2202: AND ra.resource_list_member_id = p_new_resource_list_member_id
2203: AND ra.task_id = linked_res_asgmts.task_id
2204: AND ra.resource_assignment_id <> linked_res_asgmts.resource_assignment_id

Line 2213: FROM PA_RESOURCE_ASSIGNMENTS ra

2209: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id, task_id
2210: FROM
2211: (
2212: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2213: FROM PA_RESOURCE_ASSIGNMENTS ra
2214: ,PA_BUDGET_VERSIONS bv
2215: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2216: WHERE ra.project_id = bv.project_id
2217: AND bv.project_id = evs.project_id

Line 2225: FROM PA_RESOURCE_ASSIGNMENTS ra

2221: AND ra.project_assignment_id = l_assignment_rec.source_assignment_id
2222: AND evs.status_code = 'STRUCTURE_WORKING')
2223: UNION ALL
2224: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2225: FROM PA_RESOURCE_ASSIGNMENTS ra
2226: ,PA_BUDGET_VERSIONS bv
2227: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2228: ,PA_PROJ_WORKPLAN_ATTR pwa
2229: WHERE pwa.wp_enable_Version_flag = 'N'

Line 2242: FROM pa_resource_assignments ra

2238: ) linked_res_asgmts
2239: WHERE EXISTS
2240: (
2241: SELECT *
2242: FROM pa_resource_assignments ra
2243: WHERE ra.budget_version_id = linked_res_asgmts.budget_version_id
2244: AND ra.resource_list_member_id = p_new_resource_list_member_id
2245: AND ra.task_id = linked_res_asgmts.task_id
2246: AND ra.resource_assignment_id <> linked_res_asgmts.resource_assignment_id