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 229: l_own_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

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

Line 230: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

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

Line 231: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;

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

Line 291: ,pa_resource_assignments ra

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

Line 3285: UPDATE pa_resource_assignments

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

Line 3730: UPDATE pa_resource_assignments

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

Line 4290: ,pa_resource_assignments_s.nextval

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

Line 4304: FROM pa_resource_assignments

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

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

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

Line 4320: ,pa_resource_assignments_s.NEXTVAL

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

Line 4334: FROM pa_resource_assignments pra

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

Line 4347: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID

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

Line 4361: FROM pa_resource_assignments pra

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

Line 4388: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID

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

Line 4404: FROM pa_resource_assignments pra

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

Line 5042: --Inserting records into pa_resource_assignments using pa_fp_ra_map_tmp

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

Line 5059: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

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

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

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

Line 5302: ,PA_RESOURCE_ASSIGNMENTS pra

5298: ,pra.named_role
5299: ,pra.txn_accum_header_id
5300: ,scheduled_delay --For Bug 3948128
5301: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
5302: ,PA_RESOURCE_ASSIGNMENTS pra
5303: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
5304: AND pra.budget_version_id = p_source_plan_version_id ;
5305:
5306: --For Bug 3974569. Take rbs_element_id and txn_accum_header_id from pa_rbs_plans_out_tmp

Line 5327: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

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

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

5443: ,named_role
5444: ,txn_accum_header_id
5445: ,scheduled_delay --For Bug 3948128
5446: )
5447: SELECT /*+ ORDERED USE_NL(PFRMT,PRA,RMAP) INDEX(PRA PA_RESOURCE_ASSIGNMENTS_U1)*/ pfrmt.target_res_assignment_id --Bug 2814165
5448: ,p_target_plan_version_id
5449: ,l_target_project_id
5450: ,pfrmt.target_task_id
5451: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id

Line 5570: ,PA_RESOURCE_ASSIGNMENTS pra

5566: ,pra.named_role
5567: ,rmap.txn_accum_header_id
5568: ,scheduled_delay --For Bug 3948128
5569: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
5570: ,PA_RESOURCE_ASSIGNMENTS pra
5571: ,pa_rbs_plans_out_tmp rmap
5572: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
5573: AND pra.budget_version_id = p_source_plan_version_id
5574: AND rmap.source_id = pra.resource_assignment_id;