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

Line 571: -- pa_budget_lines,pa_resource_assignments

567: -- End of changes for bug 2729191
568:
569: -- Calling an api to delete the existing records of target_version in
570: -- pa_proj_periods_denorm, p_fin_plan_adj_lines, pa_fp_adj_elements,
571: -- pa_budget_lines,pa_resource_assignments
572:
573: IF P_PA_DEBUG_MODE = 'Y' THEN
574: pa_debug.g_err_stage:='Calling the delete version api';
575: pa_debug.write('Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);

Line 2049: FROM pa_resource_assignments

2045: FOR i IN p_src_ra_id_tbl.first..p_src_ra_id_tbl.last LOOP
2046:
2047: SELECT wbs_element_version_id
2048: INTO l_src_elem_ver_id
2049: FROM pa_resource_assignments
2050: WHERE resource_assignment_id=p_src_ra_id_tbl(i);
2051:
2052: l_temp := TO_CHAR(l_src_elem_ver_id);
2053: IF l_src_elem_targ_elem_map_tbl.EXISTS(l_temp) THEN

Line 2104: ,pa_resource_assignments_s.nextval

2100: ,schedule_end_date
2101: ,system_reference4 -- Bug 3615617
2102: )
2103: SELECT pra.resource_assignment_id
2104: ,pa_resource_assignments_s.nextval
2105: ,pra.task_id
2106: ,pra.task_id
2107: ,NULL
2108: ,NULL

Line 2115: FROM pa_resource_assignments pra

2111: ,p_planning_end_date_tbl(i)
2112: ,l_schedule_start_date_tbl(i)
2113: ,l_schedule_end_date_tbl(i)
2114: ,p_targ_rlm_id_tbl(i) -- Bug 3615617
2115: FROM pa_resource_assignments pra
2116: WHERE pra.resource_assignment_id = p_src_ra_id_tbl(i);
2117: ELSE
2118:
2119: --Bug 4187294: Removed the calls to get_mapped_id.Used the pl/sql tbl l_targ_elem_ver_id_tbl

Line 2137: ,pa_resource_assignments_s.nextval

2133: ,schedule_end_date
2134: ,system_reference4 -- Bug 3615617
2135: )
2136: SELECT pra.resource_assignment_id
2137: ,pa_resource_assignments_s.nextval
2138: ,pra.task_id
2139: ,pelm.proj_element_id
2140: ,pra.wbs_element_version_id
2141: ,l_targ_elem_ver_id_tbl(i)

Line 2148: FROM pa_resource_assignments pra

2144: ,p_planning_end_date_tbl(i)
2145: ,l_schedule_start_date_tbl(i)
2146: ,l_schedule_end_date_tbl(i)
2147: ,p_targ_rlm_id_tbl(i) -- Bug 3615617
2148: FROM pa_resource_assignments pra
2149: ,pa_proj_element_versions pelm
2150: WHERE pra.resource_assignment_id = p_src_ra_id_tbl(i)
2151: AND pelm.element_version_id=l_targ_elem_ver_id_tbl(i);
2152: END IF; -- p_context

Line 2366: --Inserting records into pa_resource_assignments using pa_fp_ra_map_tmp

2362: pa_debug.g_err_stage:='l_target_project_id ='||l_target_project_id;
2363: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2364: END IF;
2365: */
2366: --Inserting records into pa_resource_assignments using pa_fp_ra_map_tmp
2367:
2368: IF P_PA_DEBUG_MODE = 'Y' THEN
2369: pa_debug.g_err_stage:='Copying the source version records as target version records';
2370: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);

Line 2388: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

2384: pa_debug.g_err_stage:='Using the First RA Insert';
2385: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2386: END IF;
2387:
2388: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
2389: resource_assignment_id
2390: ,budget_version_id
2391: ,project_id
2392: ,task_id

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

2505: ,named_role
2506: ,txn_accum_header_id
2507: ,scheduled_delay --For Bug 3948128
2508: )
2509: SELECT /*+ ORDERED USE_NL(PFRMT,PRA) INDEX(PRA PA_RESOURCE_ASSIGNMENTS_U1)*/ pfrmt.target_res_assignment_id --Bug 2814165
2510: ,p_target_plan_version_id
2511: ,l_target_project_id
2512: ,pfrmt.target_task_id
2513: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id

Line 2635: ,PA_RESOURCE_ASSIGNMENTS pra

2631: ,pra.named_role
2632: ,pra.txn_accum_header_id
2633: ,scheduled_delay --For Bug 3948128
2634: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
2635: ,PA_RESOURCE_ASSIGNMENTS pra
2636: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
2637: AND pra.budget_version_id = p_source_plan_version_id ;
2638:
2639:

Line 2666: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

2662: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2663:
2664: END IF;
2665:
2666: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
2667: resource_assignment_id
2668: ,budget_version_id
2669: ,project_id
2670: ,task_id

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

2783: ,named_role
2784: ,txn_accum_header_id
2785: ,scheduled_delay --For Bug 3948128
2786: )
2787: SELECT /*+ ORDERED USE_NL(PFRMT,PRA,RMAP) INDEX(PRA PA_RESOURCE_ASSIGNMENTS_U1)*/ pfrmt.target_res_assignment_id --Bug 2814165
2788: ,p_target_plan_version_id
2789: ,l_target_project_id
2790: ,pfrmt.target_task_id
2791: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id

Line 2913: ,PA_RESOURCE_ASSIGNMENTS pra

2909: ,pra.named_role
2910: ,rmap.txn_accum_header_id
2911: ,scheduled_delay --For Bug 3948128
2912: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
2913: ,PA_RESOURCE_ASSIGNMENTS pra
2914: ,pa_rbs_plans_out_tmp rmap
2915: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
2916: AND pra.budget_version_id = p_source_plan_version_id
2917: AND rmap.source_id = pra.resource_assignment_id;

Line 2931: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

2927: pa_debug.g_err_stage:='Using the Third RA Insert';
2928: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
2929: END IF;
2930:
2931: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
2932: resource_assignment_id
2933: ,budget_version_id
2934: ,project_id
2935: ,task_id

Line 3053: pa_resource_assignments_s.nextval

3049: ,txn_accum_header_id
3050: ,scheduled_delay --For Bug 3948128
3051: )
3052: SELECT
3053: pa_resource_assignments_s.nextval
3054: ,p_target_plan_version_id
3055: ,l_target_project_id
3056: ,pra.task_id
3057: ,pra.resource_list_member_id

Line 3174: FROM PA_RESOURCE_ASSIGNMENTS pra

3170: ,pra.resource_class_flag
3171: ,pra.named_role
3172: ,pra.txn_accum_header_id
3173: ,scheduled_delay --For Bug 3948128
3174: FROM PA_RESOURCE_ASSIGNMENTS pra
3175: WHERE pra.budget_version_id = p_source_plan_version_id
3176: AND pra.project_id = l_source_project_id ; -- Bug 4493425
3177:
3178: --API is called for copying resource assignments between plan versions that dont belong to the same project

Line 3191: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

3187: pa_debug.g_err_stage:='Using the Fourth RA Insert';
3188: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
3189: END IF;
3190:
3191: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
3192: resource_assignment_id
3193: ,budget_version_id
3194: ,project_id
3195: ,task_id

Line 3313: pa_resource_assignments_s.nextval

3309: ,txn_accum_header_id
3310: ,scheduled_delay --For Bug 3948128
3311: )
3312: SELECT
3313: pa_resource_assignments_s.nextval
3314: ,p_target_plan_version_id
3315: ,l_target_project_id
3316: ,pra.task_id
3317: ,prlmt.resource_list_member_id

Line 3434: FROM PA_RESOURCE_ASSIGNMENTS pra,

3430: ,pra.resource_class_flag
3431: ,pra.named_role
3432: ,pra.txn_accum_header_id
3433: ,scheduled_delay --For Bug 3948128
3434: FROM PA_RESOURCE_ASSIGNMENTS pra,
3435: pa_resource_list_members prlms,
3436: pa_resource_list_members prlmt
3437: WHERE pra.budget_version_id = p_source_plan_version_id
3438: AND prlms.resource_list_member_id=pra.resource_list_member_id

Line 3459: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

3455: pa_debug.g_err_stage:='Using the FIFTH RA Insert';
3456: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
3457: END IF;
3458:
3459: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
3460: resource_assignment_id
3461: ,budget_version_id
3462: ,project_id
3463: ,task_id

Line 3581: pa_resource_assignments_s.nextval

3577: ,txn_accum_header_id
3578: ,scheduled_delay --For Bug 3948128
3579: )
3580: SELECT
3581: pa_resource_assignments_s.nextval
3582: ,p_target_plan_version_id
3583: ,l_target_project_id
3584: ,pelm.target_task_id
3585: ,prlmt.resource_list_member_id

Line 3702: FROM PA_RESOURCE_ASSIGNMENTS pra,

3698: ,pra.resource_class_flag
3699: ,pra.named_role
3700: ,pra.txn_accum_header_id
3701: ,scheduled_delay --For Bug 3948128
3702: FROM PA_RESOURCE_ASSIGNMENTS pra,
3703: (SELECT TO_NUMBER(attribute15) source_task_id,
3704: proj_element_id target_task_id
3705: FROM pa_proj_elements
3706: WHERE project_id = l_target_project_id

Line 3732: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

3728: pa_debug.g_err_stage:='Using the Sixth RA Insert';
3729: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
3730: END IF;
3731:
3732: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
3733: resource_assignment_id
3734: ,budget_version_id
3735: ,project_id
3736: ,task_id

Line 3854: pa_resource_assignments_s.nextval

3850: ,txn_accum_header_id
3851: ,scheduled_delay --For Bug 3948128
3852: )
3853: SELECT
3854: pa_resource_assignments_s.nextval
3855: ,p_target_plan_version_id
3856: ,l_target_project_id
3857: ,pelm.target_task_id
3858: ,pra.resource_list_member_id

Line 3975: FROM PA_RESOURCE_ASSIGNMENTS pra,

3971: ,pra.resource_class_flag
3972: ,pra.named_role
3973: ,pra.txn_accum_header_id
3974: ,scheduled_delay --For Bug 3948128
3975: FROM PA_RESOURCE_ASSIGNMENTS pra,
3976: (SELECT TO_NUMBER(attribute15) source_task_id,
3977: proj_element_id target_task_id
3978: FROM pa_proj_elements
3979: WHERE project_id = l_target_project_id

Line 4016: update pa_resource_assignments

4012: pa_budget_versions pbv
4013: where pbv.budget_version_id = p_target_plan_version_id
4014: and pbv.project_id = ppa.project_id;
4015:
4016: update pa_resource_assignments
4017: set organization_id=l_project_org
4018: where resource_assignment_id in
4019: (select pra.resource_assignment_id
4020: from pa_resource_assignments pra,

Line 4020: from pa_resource_assignments pra,

4016: update pa_resource_assignments
4017: set organization_id=l_project_org
4018: where resource_assignment_id in
4019: (select pra.resource_assignment_id
4020: from pa_resource_assignments pra,
4021: pa_resource_list_members prlm
4022: where pra.budget_version_id=p_target_plan_version_id
4023: and pra.resource_list_member_id=prlm.resource_list_member_id
4024: and pra.job_id = prlm.job_id

Line 4117: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

4113: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4114: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4115: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4116: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4117: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
4118: l_temp_flag VARCHAR2(1);
4119: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4120: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4121: l_temp NUMBER;

Line 4216: ,pa_resource_assignments ra

4212: ,l_rate_based_flag_tbl
4213: ,l_init_quantity_tbl
4214: ,l_txn_currency_code_tbl
4215: FROM pa_budget_lines bl
4216: ,pa_resource_assignments ra
4217: WHERE bl.resource_assignment_id=ra.resource_assignment_id
4218: AND bl.budget_version_id=p_budget_version_id
4219: AND ra.budget_version_id=p_budget_version_id
4220: ORDER BY bl.resource_assignment_id ,bl.quantity NULLS FIRST;

Line 4425: UPDATE pa_resource_assignments

4421:
4422: --Update the rate based flag to N for the ids in l_non_rb_ra_id_tbl
4423: FORALL kk IN 1..l_non_rb_ra_id_tbl.COUNT
4424:
4425: UPDATE pa_resource_assignments
4426: SET rate_based_flag = 'N'
4427: ,unit_of_measure = 'DOLLARS'
4428: WHERE resource_assignment_id=l_non_rb_ra_id_tbl(kk);
4429:

Line 5115: ,pa_resource_assignments pra

5111: ,cost_ind_compiled_set_id
5112: ,Decode(l_adj_percentage,0,pc_cur_conv_rejection_code,null)
5113: ,Decode(l_adj_percentage,0,pfc_cur_conv_rejection_code,null)
5114: FROM PA_BUDGET_LINES pbl
5115: ,pa_resource_assignments pra
5116: WHERE pbl.resource_assignment_id = pra.parent_assignment_id
5117: AND pbl.budget_version_id = p_source_plan_version_id
5118: AND pra.budget_version_id = p_target_plan_version_id
5119: AND pra.project_id = l_target_project_id; -- Bug 4493425.

Line 5141: pa_resource_assignments prat

5137: SELECT pbls.budget_line_id,
5138: pblt.budget_line_id
5139: FROM pa_budget_lines pblt,
5140: pa_budget_lines pbls,
5141: pa_resource_assignments prat
5142: WHERE pblt.budget_version_id=p_target_plan_version_id
5143: AND prat.budget_version_id=p_target_plan_version_id
5144: AND prat.project_id = l_target_project_id -- Bug 4493425.
5145: AND prat.resource_assignment_id=pblt.resource_assignment_id

Line 6571: pa_resource_assignments pra

6567: rac.txn_burden_cost_rate_override,
6568: rac.txn_bill_rate_override
6569: FROM
6570: pa_resource_asgn_curr rac,
6571: pa_resource_assignments pra
6572: WHERE
6573: pra.budget_version_id = l_target_version_id and
6574: rac.budget_version_id = l_source_version_id and
6575: pra.parent_assignment_id = rac.resource_assignment_id;

Line 7767: ,pa_resource_assignments pra

7763: ,NULL -- pc_cur_conv_rejection_code
7764: ,NULL -- pfc_cur_conv_rejection_code
7765:
7766: FROM PA_BUDGET_LINES pbl
7767: ,pa_resource_assignments pra
7768: WHERE pbl.resource_assignment_id = pra.parent_assignment_id
7769: AND pbl.budget_version_id = p_source_plan_version_id
7770: AND pra.budget_version_id=p_target_plan_version_id;
7771:

Line 7778: UPDATE pa_resource_assignments pra

7774:
7775: IF (l_target_time_phased_code NOT IN(PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,
7776: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P)) THEN
7777: /*
7778: UPDATE pa_resource_assignments pra
7779: SET (pra.planning_start_date , pra.planning_end_date , pra.sp_fixed_date)
7780: = (SELECT least(pra.planning_start_date + l_shift_days,
7781: nvl(min(bl.start_date) , pra.planning_start_date + l_shift_days)),
7782: greatest(pra.planning_end_date + l_shift_days,

Line 7793: update pa_resource_assignments pra

7789: WHERE pra.budget_version_id = p_target_plan_version_id;
7790: */
7791: /* Bug 5846751: Commented the above update and added a new update to derive the Resource Assignment's
7792: dates similar to that of the Budget Lines start and end dates in the above INSERT statement. */
7793: update pa_resource_assignments pra
7794: set (pra.planning_start_date, pra.planning_end_date,pra.sp_fixed_date)
7795: = ( select nvl(min(bl.start_date),nvl(l_target_proj_start_date, pra.planning_start_date + l_shift_days)),
7796: nvl(min(bl.end_date),nvl(l_target_proj_completion_date, pra.planning_end_date + l_shift_days)),
7797: decode(pra.sp_fixed_date,null,null,nvl(min(bl.start_date),nvl(l_target_proj_start_date, pra.sp_fixed_date + l_shift_days)))

Line 8058: ,pa_resource_assignments pra

8054: ,nvl(burden_cost_rate_override,burden_cost_rate) -- burden_cost_rate_override
8055: ,NULL -- pc_cur_conv_rejection_code
8056: ,NULL -- pfc_cur_conv_rejection_code
8057: FROM PA_BUDGET_LINES pbl
8058: ,pa_resource_assignments pra
8059: ,PA_FP_CPY_PERIODS_TMP pptmp /* Bug# 2634726 */
8060: WHERE pra.parent_assignment_id = pbl.resource_assignment_id
8061: AND decode(l_target_time_phased_code,
8062: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P, pptmp.pa_period_name,

Line 8073: update pa_resource_assignments pra

8069: -- Bug 3841942 this update is required to make sure that planning start/end dates
8070: -- encompass budget line start and end dates after the shift
8071: --Bug 4200168, The logic for deriving sp fixed date is transferred to this previous. Previously
8072: --it was there in copy resource assignments.
8073: update pa_resource_assignments pra
8074: set (pra.planning_start_date, pra.planning_end_date,pra.sp_fixed_date)
8075: = ( select least(pra.planning_start_date+l_shift_days,
8076: nvl(min(bl.start_date),pra.planning_start_date+l_shift_days)),
8077: greatest(pra.planning_end_date+l_shift_days,

Line 8793: FROM pa_resource_assignments pra

8789: AND selv.proj_element_id =spe.proj_element_id
8790: AND selv.parent_structure_version_id=c_src_struct_ver_id
8791: AND telv.parent_structure_version_id=c_targ_struct_ver_id
8792: AND EXISTS (SELECT task_id
8793: FROM pa_resource_assignments pra
8794: WHERE pra.budget_version_id=c_source_plan_version_id
8795: AND pra.task_id=spe.proj_element_id);
8796:
8797: BEGIN

Line 9331: l_rate_based_flag pa_resource_assignments.rate_based_flag%type;

9327: l_debug_mode VARCHAR2(30);
9328:
9329: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
9330: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;
9331: l_rate_based_flag pa_resource_assignments.rate_based_flag%type;
9332:
9333:
9334: l_adj_percentage NUMBER ;
9335:

Line 9387: FROM pa_budget_lines pbl, pa_resource_assignments pra

9383: l_period_nameTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9384:
9385: CURSOR Cur_group_source_budget_lines IS
9386: SELECT distinct pbl.resource_assignment_id resource_assignment_id, pbl.start_date start_date,pra.rate_based_flag
9387: FROM pa_budget_lines pbl, pa_resource_assignments pra
9388: WHERE pbl.budget_version_id = p_source_plan_version_id
9389: AND pra.resource_assignment_id = pbl.resource_assignment_id;
9390:
9391: CURSOR Cur_source_budget_lines(p_resource_assignment_id IN NUMBER, p_start_date IN DATE

Line 9938: FROM pa_resource_assignments pra

9934: ,DECODE(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_burden_cost_rate_override,NULL),NULL) -- burden_cost_rate_override
9935: ,null -- cost_ind_compiled_set_id
9936: ,null -- pc_cur_conv_rejection_code
9937: ,null -- pfc_cur_conv_rejection_code
9938: FROM pa_resource_assignments pra
9939: WHERE rec_group_source_budget_lines.resource_assignment_id = pra.parent_assignment_id
9940: AND pra.budget_version_id=p_target_plan_version_id;
9941:
9942: END IF; -- l_budget_line_idTab.count

Line 10316: UPDATE pa_resource_assignments

10312: || l_people_res_class_rlm_id;
10313: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,3);
10314: END IF;
10315:
10316: UPDATE pa_resource_assignments
10317: SET resource_list_member_id = l_people_res_class_rlm_id
10318: WHERE budget_version_id = p_wp_version_id
10319: AND resource_class_code = 'PEOPLE'
10320: AND resource_class_flag = 'Y';

Line 10380: UPDATE pa_resource_assignments

10376: IF nvl(l_txn_source_id_tbl.last,0) >= 1 THEN
10377:
10378: -- Update resource assignments data for the version
10379: FORALL i IN l_txn_source_id_tbl.first .. l_txn_source_id_tbl.last
10380: UPDATE pa_resource_assignments
10381: SET rbs_element_id = l_rbs_element_id_tbl(i)
10382: ,txn_accum_header_id = l_txn_accum_header_id_tbl(i)
10383: ,record_version_number = record_version_number + 1
10384: ,last_update_date = SYSDATE