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 913: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

909: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
910: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
911: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
912: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
913: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
914: ,p_number_of_requirements IN NUMBER := 1
915: ,p_api_version IN NUMBER := 1.0
916: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
917: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 2201: FROM PA_RESOURCE_ASSIGNMENTS ra

2197: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
2198: FROM
2199: (
2200: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2201: FROM PA_RESOURCE_ASSIGNMENTS ra
2202: ,PA_BUDGET_VERSIONS bv
2203: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2204: WHERE ra.project_id = bv.project_id
2205: AND bv.project_id = evs.project_id

Line 2213: FROM PA_RESOURCE_ASSIGNMENTS ra

2209: AND ra.project_assignment_id = l_assignment_rec.source_assignment_id
2210: AND evs.status_code = 'STRUCTURE_WORKING')
2211: UNION ALL
2212: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2213: FROM PA_RESOURCE_ASSIGNMENTS ra
2214: ,PA_BUDGET_VERSIONS bv
2215: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2216: ,PA_PROJ_WORKPLAN_ATTR pwa
2217: WHERE pwa.wp_enable_Version_flag = 'N'

Line 2234: FROM PA_RESOURCE_ASSIGNMENTS ra

2230: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id, task_id
2231: FROM
2232: (
2233: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2234: FROM PA_RESOURCE_ASSIGNMENTS ra
2235: ,PA_BUDGET_VERSIONS bv
2236: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2237: WHERE ra.project_id = bv.project_id
2238: AND bv.project_id = evs.project_id

Line 2246: FROM PA_RESOURCE_ASSIGNMENTS ra

2242: AND ra.project_assignment_id = l_assignment_rec.source_assignment_id
2243: AND evs.status_code = 'STRUCTURE_WORKING')
2244: UNION ALL
2245: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2246: FROM PA_RESOURCE_ASSIGNMENTS ra
2247: ,PA_BUDGET_VERSIONS bv
2248: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2249: ,PA_PROJ_WORKPLAN_ATTR pwa
2250: WHERE pwa.wp_enable_Version_flag = 'N'

Line 2263: FROM pa_resource_assignments ra

2259: ) linked_res_asgmts
2260: WHERE NOT EXISTS
2261: (
2262: SELECT *
2263: FROM pa_resource_assignments ra
2264: WHERE ra.budget_version_id = linked_res_asgmts.budget_version_id
2265: AND ra.resource_list_member_id = p_new_resource_list_member_id
2266: AND ra.task_id = linked_res_asgmts.task_id
2267: AND ra.resource_assignment_id <> linked_res_asgmts.resource_assignment_id

Line 2276: FROM PA_RESOURCE_ASSIGNMENTS ra

2272: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id, task_id
2273: FROM
2274: (
2275: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2276: FROM PA_RESOURCE_ASSIGNMENTS ra
2277: ,PA_BUDGET_VERSIONS bv
2278: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2279: WHERE ra.project_id = bv.project_id
2280: AND bv.project_id = evs.project_id

Line 2288: FROM PA_RESOURCE_ASSIGNMENTS ra

2284: AND ra.project_assignment_id = l_assignment_rec.source_assignment_id
2285: AND evs.status_code = 'STRUCTURE_WORKING')
2286: UNION ALL
2287: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2288: FROM PA_RESOURCE_ASSIGNMENTS ra
2289: ,PA_BUDGET_VERSIONS bv
2290: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2291: ,PA_PROJ_WORKPLAN_ATTR pwa
2292: WHERE pwa.wp_enable_Version_flag = 'N'

Line 2305: FROM pa_resource_assignments ra

2301: ) linked_res_asgmts
2302: WHERE EXISTS
2303: (
2304: SELECT *
2305: FROM pa_resource_assignments ra
2306: WHERE ra.budget_version_id = linked_res_asgmts.budget_version_id
2307: AND ra.resource_list_member_id = p_new_resource_list_member_id
2308: AND ra.task_id = linked_res_asgmts.task_id
2309: AND ra.resource_assignment_id <> linked_res_asgmts.resource_assignment_id