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

Line 230: l_own_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

226: l_prob_percent pa_probability_members.probability_percentage%TYPE;
227: l_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
228: l_pfi_assignment_id pa_forecast_items.assignment_id%TYPE;
229: l_pfi_resource_id pa_forecast_items.resource_id%TYPE;
230: l_own_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
231: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
232: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
233: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;
234: l_utl_hours pa_budget_lines.utilization_hours%TYPE;

Line 231: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

227: l_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
228: l_pfi_assignment_id pa_forecast_items.assignment_id%TYPE;
229: l_pfi_resource_id pa_forecast_items.resource_id%TYPE;
230: l_own_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
231: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
232: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
233: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;
234: l_utl_hours pa_budget_lines.utilization_hours%TYPE;
235: l_utl_capacity pa_budget_lines.capacity%TYPE;

Line 232: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;

228: l_pfi_assignment_id pa_forecast_items.assignment_id%TYPE;
229: l_pfi_resource_id pa_forecast_items.resource_id%TYPE;
230: l_own_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
231: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
232: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
233: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;
234: l_utl_hours pa_budget_lines.utilization_hours%TYPE;
235: l_utl_capacity pa_budget_lines.capacity%TYPE;
236: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;

Line 292: ,pa_resource_assignments ra

288: ,nvl(sum(bl.utilization_hours),0)
289: ,nvl(sum(bl.capacity),0)
290: ,nvl(sum(bl.head_count),0)
291: FROM pa_budget_lines bl
292: ,pa_resource_assignments ra
293: WHERE bl.resource_assignment_id = ra.resource_assignment_id
294: AND bl.budget_version_id = ra.budget_version_id
295: AND ra.budget_version_id = l_budget_version_id
296: AND ra.task_id <> 0

Line 3286: UPDATE pa_resource_assignments

3282: IF P_PA_DEBUG_MODE = 'Y' THEN
3283: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3284: END IF;
3285:
3286: UPDATE pa_resource_assignments
3287: SET
3288: last_update_date = sysdate
3289: ,last_updated_by = fnd_global.user_id
3290: ,last_update_login = fnd_global.login_id

Line 3731: UPDATE pa_resource_assignments

3727: pa_debug.g_err_stage := l_stage||': Update Resource Assignments for Project Task';
3728: IF P_PA_DEBUG_MODE = 'Y' THEN
3729: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3730: END IF;
3731: UPDATE pa_resource_assignments
3732: SET
3733: last_update_date = sysdate
3734: ,last_updated_by = fnd_global.user_id
3735: ,last_update_login = fnd_global.login_id

Line 4291: ,pa_resource_assignments_s.nextval

4287: -- cursor same_projects_cur is going to be used when the source and target projects are same
4288:
4289: CURSOR same_projects_cur IS
4290: SELECT resource_assignment_id
4291: ,pa_resource_assignments_s.nextval
4292: ,parent_assignment_id
4293: ,task_id
4294: ,task_id
4295: --Start of Changes for bug 3354518

Line 4305: FROM pa_resource_assignments

4301: ,schedule_start_date
4302: ,schedule_end_date
4303: --End of Changes for bug 3354518
4304: ,resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4305: FROM pa_resource_assignments
4306: WHERE budget_version_id = p_source_plan_version_id;
4307:
4308:
4309: /* Bug 2920954 - This cursor is used for FINPLAN when copy mode is B.

Line 4312: during copying. In pa_resource_assignments, the amount columns

4308:
4309: /* Bug 2920954 - This cursor is used for FINPLAN when copy mode is B.
4310: In this case, we copy only the ras with amounts. Since this cursor
4311: is used only for baselie case, we dont have to check adj percentage
4312: during copying. In pa_resource_assignments, the amount columns
4313: would be Null if no budget lines "ever" existed. */
4314:
4315: /* 06-Jul-2004 Bug 3729657 Raja FP M Dev changes
4316: Resource assignments with no amounts also should be copied

Line 4321: ,pa_resource_assignments_s.NEXTVAL

4317: */
4318:
4319: CURSOR baseline_budgt_res_cur IS
4320: SELECT pra.resource_assignment_id
4321: ,pa_resource_assignments_s.NEXTVAL
4322: ,pra.parent_assignment_id
4323: ,pra.task_id
4324: ,pra.task_id
4325: --Start of Changes for bug 3354518

Line 4335: FROM pa_resource_assignments pra

4331: ,pra.schedule_start_date
4332: ,pra.schedule_end_date
4333: --End of Changes for bug 3354518
4334: ,resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4335: FROM pa_resource_assignments pra
4336: WHERE pra.budget_version_id = p_source_plan_version_id;
4337: /*** Bug 3729657
4338: AND (pra.total_plan_quantity IS NOT NULL
4339: OR pra.total_plan_raw_cost IS NOT NULL

Line 4348: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID

4344: -- Reference to pa_tasks is changed to pa_struct_task_wbs_v (bug 3354518)
4345:
4346: CURSOR different_projects_task_cur IS
4347: SELECT pra.resource_assignment_id -- SOURCE_RES_ASSIGNMENT_ID
4348: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID
4349: ,pra.parent_assignment_id -- PARENT_ASSIGNMENT_ID
4350: ,pra.task_id -- SOURCE_TASK_ID
4351: ,target_tasks.task_id -- TARGET_TASK_ID
4352: ,NULL -- SOURCE ELEMENT_VERSION_ID

Line 4362: FROM pa_resource_assignments pra

4358: So, the schedule dates are stamped as planning start dates itself */
4359: ,pra.planning_start_date + l_shift_days -- SCHEDULE_START_DATE
4360: ,pra.planning_end_date + l_shift_days -- SCHEDULE_END_DATE
4361: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4362: FROM pa_resource_assignments pra
4363: ,pa_tasks source_tasks
4364: ,pa_tasks target_tasks
4365: ,pa_resource_list_members source_rlm -- bug 3615617
4366: ,pa_resource_list_members target_rlm -- bug 3615617

Line 4389: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID

4385: --is PROJECT and source and target project id is different.
4386:
4387: CURSOR proj_plan_lev_diff_proj_cur IS
4388: SELECT resource_assignment_id -- SOURCE_RES_ASSIGNMENT_ID
4389: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID
4390: ,NULL -- PARENT_ASSIGNMENT_ID
4391: ,0 -- SOURCE_TASK_ID
4392: ,0 -- TARGET_TASK_ID
4393: --Start of Changes for bug 3354518

Line 4405: FROM pa_resource_assignments pra

4401: ,planning_start_date + l_shift_days -- SCHEDULE_START_DATE
4402: ,planning_end_date + l_shift_days -- SCHEDULE_END_DATE
4403: --End of Changes for bug 3354518
4404: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4405: FROM pa_resource_assignments pra
4406: ,pa_resource_list_members source_rlm -- bug 3615617
4407: ,pa_resource_list_members target_rlm -- bug 3615617
4408: WHERE pra.budget_version_id = p_source_plan_version_id
4409: AND pra.task_id = 0

Line 5043: --Inserting records into pa_resource_assignments using pa_fp_ra_map_tmp

5039: pa_debug.g_err_stage:='l_target_project_id ='||l_target_project_id;
5040: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5041: END IF;
5042: */
5043: --Inserting records into pa_resource_assignments using pa_fp_ra_map_tmp
5044:
5045: IF P_PA_DEBUG_MODE = 'Y' THEN
5046: pa_debug.g_err_stage:='Copying the source version records as target version records';
5047: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);

Line 5060: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

5056: END IF;
5057:
5058: IF p_rbs_map_diff_flag ='N' THEN
5059:
5060: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
5061: resource_assignment_id
5062: ,budget_version_id
5063: ,project_id
5064: ,task_id

Line 5181: SELECT /+ ORDERED USE_NL(PFRMT,PRA) INDEX(PRA PA_RESOURCE_ASSIGNMENTS_U1)/ pfrmt.target_res_assignment_id --Bug 2814165

5177: ,txn_accum_header_id
5178: ,scheduled_delay --For Bug 3948128
5179: ,CBS_ELEMENT_ID -- bug#16200605
5180: )
5181: SELECT /*+ ORDERED USE_NL(PFRMT,PRA) INDEX(PRA PA_RESOURCE_ASSIGNMENTS_U1)*/ pfrmt.target_res_assignment_id --Bug 2814165
5182: ,p_target_plan_version_id
5183: ,l_target_project_id
5184: ,pfrmt.target_task_id
5185: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id

Line 5305: ,PA_RESOURCE_ASSIGNMENTS pra

5301: ,pra.txn_accum_header_id
5302: ,scheduled_delay --For Bug 3948128
5303: ,pra.CBS_ELEMENT_ID -- bug#16200605
5304: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
5305: ,PA_RESOURCE_ASSIGNMENTS pra
5306: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
5307: AND pra.budget_version_id = p_source_plan_version_id ;
5308:
5309: --For Bug 3974569. Take rbs_element_id and txn_accum_header_id from pa_rbs_plans_out_tmp

Line 5330: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

5326: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5327:
5328: END IF;
5329:
5330: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
5331: resource_assignment_id
5332: ,budget_version_id
5333: ,project_id
5334: ,task_id

Line 5451: SELECT /+ ORDERED USE_NL(PFRMT,PRA,RMAP) INDEX(PRA PA_RESOURCE_ASSIGNMENTS_U1)/ pfrmt.target_res_assignment_id --Bug 2814165

5447: ,txn_accum_header_id
5448: ,scheduled_delay --For Bug 3948128
5449: ,CBS_ELEMENT_ID -- bug#16200605
5450: )
5451: SELECT /*+ ORDERED USE_NL(PFRMT,PRA,RMAP) INDEX(PRA PA_RESOURCE_ASSIGNMENTS_U1)*/ pfrmt.target_res_assignment_id --Bug 2814165
5452: ,p_target_plan_version_id
5453: ,l_target_project_id
5454: ,pfrmt.target_task_id
5455: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id

Line 5575: ,PA_RESOURCE_ASSIGNMENTS pra

5571: ,rmap.txn_accum_header_id
5572: ,scheduled_delay --For Bug 3948128
5573: ,pra.CBS_ELEMENT_ID -- bug#16200605
5574: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
5575: ,PA_RESOURCE_ASSIGNMENTS pra
5576: ,pa_rbs_plans_out_tmp rmap
5577: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
5578: AND pra.budget_version_id = p_source_plan_version_id
5579: AND rmap.source_id = pra.resource_assignment_id;