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 2510: SELECT /+ ORDERED USE_NL(PFRMT,PRA) INDEX(PRA PA_RESOURCE_ASSIGNMENTS_U1)/ pfrmt.target_res_assignment_id --Bug 2814165

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

Line 2637: ,PA_RESOURCE_ASSIGNMENTS pra

2633: ,pra.txn_accum_header_id
2634: ,scheduled_delay --For Bug 3948128
2635: ,pra.CBS_ELEMENT_ID -- bug#16200605
2636: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
2637: ,PA_RESOURCE_ASSIGNMENTS pra
2638: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
2639: AND pra.budget_version_id = p_source_plan_version_id ;
2640:
2641:

Line 2668: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

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

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

2786: ,txn_accum_header_id
2787: ,scheduled_delay --For Bug 3948128
2788: ,CBS_ELEMENT_ID -- bug#16200605
2789: )
2790: SELECT /*+ ORDERED USE_NL(PFRMT,PRA,RMAP) INDEX(PRA PA_RESOURCE_ASSIGNMENTS_U1)*/ pfrmt.target_res_assignment_id --Bug 2814165
2791: ,p_target_plan_version_id
2792: ,l_target_project_id
2793: ,pfrmt.target_task_id
2794: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id

Line 2917: ,PA_RESOURCE_ASSIGNMENTS pra

2913: ,rmap.txn_accum_header_id
2914: ,scheduled_delay --For Bug 3948128,
2915: ,pra.CBS_ELEMENT_ID -- bug#16200605
2916: FROM PA_FP_RA_MAP_TMP pfrmt --Bug 2814165
2917: ,PA_RESOURCE_ASSIGNMENTS pra
2918: ,pa_rbs_plans_out_tmp rmap
2919: WHERE pra.resource_assignment_id = pfrmt.source_res_assignment_id
2920: AND pra.budget_version_id = p_source_plan_version_id
2921: AND rmap.source_id = pra.resource_assignment_id;

Line 2935: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

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

Line 3058: pa_resource_assignments_s.nextval

3054: ,scheduled_delay --For Bug 3948128
3055: ,CBS_ELEMENT_ID -- bug#16200605
3056: )
3057: SELECT
3058: pa_resource_assignments_s.nextval
3059: ,p_target_plan_version_id
3060: ,l_target_project_id
3061: ,pra.task_id
3062: ,pra.resource_list_member_id

Line 3180: FROM PA_RESOURCE_ASSIGNMENTS pra

3176: ,pra.named_role
3177: ,pra.txn_accum_header_id
3178: ,scheduled_delay --For Bug 3948128
3179: ,pra.CBS_ELEMENT_ID -- bug#16200605
3180: FROM PA_RESOURCE_ASSIGNMENTS pra
3181: WHERE pra.budget_version_id = p_source_plan_version_id
3182: AND pra.project_id = l_source_project_id ; -- Bug 4493425
3183:
3184: --API is called for copying resource assignments between plan versions that dont belong to the same project

Line 3197: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

3193: pa_debug.g_err_stage:='Using the Fourth RA Insert';
3194: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
3195: END IF;
3196:
3197: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
3198: resource_assignment_id
3199: ,budget_version_id
3200: ,project_id
3201: ,task_id

Line 3320: pa_resource_assignments_s.nextval

3316: ,scheduled_delay --For Bug 3948128
3317: ,CBS_ELEMENT_ID -- bug#16200605
3318: )
3319: SELECT
3320: pa_resource_assignments_s.nextval
3321: ,p_target_plan_version_id
3322: ,l_target_project_id
3323: ,pra.task_id
3324: ,prlmt.resource_list_member_id

Line 3442: FROM PA_RESOURCE_ASSIGNMENTS pra,

3438: ,pra.named_role
3439: ,pra.txn_accum_header_id
3440: ,scheduled_delay --For Bug 3948128
3441: ,pra.CBS_ELEMENT_ID -- bug#16200605
3442: FROM PA_RESOURCE_ASSIGNMENTS pra,
3443: pa_resource_list_members prlms,
3444: pa_resource_list_members prlmt
3445: WHERE pra.budget_version_id = p_source_plan_version_id
3446: AND prlms.resource_list_member_id=pra.resource_list_member_id

Line 3467: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

3463: pa_debug.g_err_stage:='Using the FIFTH RA Insert';
3464: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
3465: END IF;
3466:
3467: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
3468: resource_assignment_id
3469: ,budget_version_id
3470: ,project_id
3471: ,task_id

Line 3590: pa_resource_assignments_s.nextval

3586: ,scheduled_delay --For Bug 3948128
3587: ,CBS_ELEMENT_ID -- bug#16200605
3588: )
3589: SELECT
3590: pa_resource_assignments_s.nextval
3591: ,p_target_plan_version_id
3592: ,l_target_project_id
3593: ,pelm.target_task_id
3594: ,prlmt.resource_list_member_id

Line 3712: FROM PA_RESOURCE_ASSIGNMENTS pra,

3708: ,pra.named_role
3709: ,pra.txn_accum_header_id
3710: ,scheduled_delay --For Bug 3948128
3711: ,pra.CBS_ELEMENT_ID -- bug#16200605
3712: FROM PA_RESOURCE_ASSIGNMENTS pra,
3713: (SELECT TO_NUMBER(attribute15) source_task_id,
3714: proj_element_id target_task_id
3715: FROM pa_proj_elements
3716: WHERE project_id = l_target_project_id

Line 3742: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

3738: pa_debug.g_err_stage:='Using the Sixth RA Insert';
3739: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
3740: END IF;
3741:
3742: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
3743: resource_assignment_id
3744: ,budget_version_id
3745: ,project_id
3746: ,task_id

Line 3865: pa_resource_assignments_s.nextval

3861: ,scheduled_delay --For Bug 3948128
3862: ,CBS_ELEMENT_ID -- bug#16200605
3863: )
3864: SELECT
3865: pa_resource_assignments_s.nextval
3866: ,p_target_plan_version_id
3867: ,l_target_project_id
3868: ,pelm.target_task_id
3869: ,pra.resource_list_member_id

Line 3987: FROM PA_RESOURCE_ASSIGNMENTS pra,

3983: ,pra.named_role
3984: ,pra.txn_accum_header_id
3985: ,scheduled_delay --For Bug 3948128
3986: ,pra.CBS_ELEMENT_ID -- bug#16200605
3987: FROM PA_RESOURCE_ASSIGNMENTS pra,
3988: (SELECT TO_NUMBER(attribute15) source_task_id,
3989: proj_element_id target_task_id
3990: FROM pa_proj_elements
3991: WHERE project_id = l_target_project_id

Line 4028: update pa_resource_assignments

4024: pa_budget_versions pbv
4025: where pbv.budget_version_id = p_target_plan_version_id
4026: and pbv.project_id = ppa.project_id;
4027:
4028: update pa_resource_assignments
4029: set organization_id=l_project_org
4030: where resource_assignment_id in
4031: (select pra.resource_assignment_id
4032: from pa_resource_assignments pra,

Line 4032: from pa_resource_assignments pra,

4028: update pa_resource_assignments
4029: set organization_id=l_project_org
4030: where resource_assignment_id in
4031: (select pra.resource_assignment_id
4032: from pa_resource_assignments pra,
4033: pa_resource_list_members prlm
4034: where pra.budget_version_id=p_target_plan_version_id
4035: and pra.resource_list_member_id=prlm.resource_list_member_id
4036: and pra.job_id = prlm.job_id

Line 4129: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

4125: l_bill_override_rate_tbl SYSTEM.pa_num_tbl_type;
4126: l_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type;
4127: l_bl_rb_flag_chg_tbl SYSTEM.pa_varchar2_1_tbl_type;
4128: l_target_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4129: l_prev_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
4130: l_temp_flag VARCHAR2(1);
4131: l_init_quantity_tbl SYSTEM.pa_num_tbl_type;
4132: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
4133: l_temp NUMBER;

Line 4228: ,pa_resource_assignments ra

4224: ,l_rate_based_flag_tbl
4225: ,l_init_quantity_tbl
4226: ,l_txn_currency_code_tbl
4227: FROM pa_budget_lines bl
4228: ,pa_resource_assignments ra
4229: WHERE bl.resource_assignment_id=ra.resource_assignment_id
4230: AND bl.budget_version_id=p_budget_version_id
4231: AND ra.budget_version_id=p_budget_version_id
4232: ORDER BY bl.resource_assignment_id ,bl.quantity NULLS FIRST;

Line 4437: UPDATE pa_resource_assignments

4433:
4434: --Update the rate based flag to N for the ids in l_non_rb_ra_id_tbl
4435: FORALL kk IN 1..l_non_rb_ra_id_tbl.COUNT
4436:
4437: UPDATE pa_resource_assignments
4438: SET rate_based_flag = 'N'
4439: ,unit_of_measure = 'DOLLARS'
4440: WHERE resource_assignment_id=l_non_rb_ra_id_tbl(kk);
4441:

Line 5127: ,pa_resource_assignments pra

5123: ,cost_ind_compiled_set_id
5124: ,Decode(l_adj_percentage,0,pc_cur_conv_rejection_code,null)
5125: ,Decode(l_adj_percentage,0,pfc_cur_conv_rejection_code,null)
5126: FROM PA_BUDGET_LINES pbl
5127: ,pa_resource_assignments pra
5128: WHERE pbl.resource_assignment_id = pra.parent_assignment_id
5129: AND pbl.budget_version_id = p_source_plan_version_id
5130: AND pra.budget_version_id = p_target_plan_version_id
5131: AND pra.project_id = l_target_project_id; -- Bug 4493425.

Line 5153: pa_resource_assignments prat

5149: SELECT pbls.budget_line_id,
5150: pblt.budget_line_id
5151: FROM pa_budget_lines pblt,
5152: pa_budget_lines pbls,
5153: pa_resource_assignments prat
5154: WHERE pblt.budget_version_id=p_target_plan_version_id
5155: AND prat.budget_version_id=p_target_plan_version_id
5156: AND prat.project_id = l_target_project_id -- Bug 4493425.
5157: AND prat.resource_assignment_id=pblt.resource_assignment_id

Line 6588: pa_resource_assignments pra

6584: rac.txn_burden_cost_rate_override,
6585: rac.txn_bill_rate_override
6586: FROM
6587: pa_resource_asgn_curr rac,
6588: pa_resource_assignments pra
6589: WHERE
6590: pra.budget_version_id = l_target_version_id and
6591: rac.budget_version_id = l_source_version_id and
6592: pra.parent_assignment_id = rac.resource_assignment_id;

Line 7786: ,pa_resource_assignments pra

7782: ,NULL -- pc_cur_conv_rejection_code
7783: ,NULL -- pfc_cur_conv_rejection_code
7784:
7785: FROM PA_BUDGET_LINES pbl
7786: ,pa_resource_assignments pra
7787: WHERE pbl.resource_assignment_id = pra.parent_assignment_id
7788: AND pbl.budget_version_id = p_source_plan_version_id
7789: AND pra.budget_version_id=p_target_plan_version_id;
7790:

Line 7797: UPDATE pa_resource_assignments pra

7793:
7794: IF (l_target_time_phased_code NOT IN(PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,
7795: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P)) THEN
7796: /*
7797: UPDATE pa_resource_assignments pra
7798: SET (pra.planning_start_date , pra.planning_end_date , pra.sp_fixed_date)
7799: = (SELECT least(pra.planning_start_date + l_shift_days,
7800: nvl(min(bl.start_date) , pra.planning_start_date + l_shift_days)),
7801: greatest(pra.planning_end_date + l_shift_days,

Line 7812: update pa_resource_assignments pra

7808: WHERE pra.budget_version_id = p_target_plan_version_id;
7809: */
7810: /* Bug 5846751: Commented the above update and added a new update to derive the Resource Assignment's
7811: dates similar to that of the Budget Lines start and end dates in the above INSERT statement. */
7812: update pa_resource_assignments pra
7813: set (pra.planning_start_date, pra.planning_end_date,pra.sp_fixed_date)
7814: = ( select nvl(min(bl.start_date),nvl(l_target_proj_start_date, pra.planning_start_date + l_shift_days)),
7815: -- skkoppul - bug 7626463 : commented the line below and added decode statement
7816: -- Default end date with start date if start date > end date else leave end date as is

Line 8085: ,pa_resource_assignments pra

8081: ,nvl(burden_cost_rate_override,burden_cost_rate) -- burden_cost_rate_override
8082: ,NULL -- pc_cur_conv_rejection_code
8083: ,NULL -- pfc_cur_conv_rejection_code
8084: FROM PA_BUDGET_LINES pbl
8085: ,pa_resource_assignments pra
8086: ,PA_FP_CPY_PERIODS_TMP pptmp /* Bug# 2634726 */
8087: WHERE pra.parent_assignment_id = pbl.resource_assignment_id
8088: AND decode(l_target_time_phased_code,
8089: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P, pptmp.pa_period_name,

Line 8100: update pa_resource_assignments pra

8096: -- Bug 3841942 this update is required to make sure that planning start/end dates
8097: -- encompass budget line start and end dates after the shift
8098: --Bug 4200168, The logic for deriving sp fixed date is transferred to this previous. Previously
8099: --it was there in copy resource assignments.
8100: update pa_resource_assignments pra
8101: set (pra.planning_start_date, pra.planning_end_date,pra.sp_fixed_date)
8102: = ( select least(pra.planning_start_date+l_shift_days,
8103: nvl(min(bl.start_date),pra.planning_start_date+l_shift_days)),
8104: greatest(pra.planning_end_date+l_shift_days,

Line 8820: FROM pa_resource_assignments pra

8816: AND selv.proj_element_id =spe.proj_element_id
8817: AND selv.parent_structure_version_id=c_src_struct_ver_id
8818: AND telv.parent_structure_version_id=c_targ_struct_ver_id
8819: AND EXISTS (SELECT task_id
8820: FROM pa_resource_assignments pra
8821: WHERE pra.budget_version_id=c_source_plan_version_id
8822: AND pra.task_id=spe.proj_element_id);
8823:
8824: BEGIN

Line 9358: l_rate_based_flag pa_resource_assignments.rate_based_flag%type;

9354: l_debug_mode VARCHAR2(30);
9355:
9356: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
9357: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;
9358: l_rate_based_flag pa_resource_assignments.rate_based_flag%type;
9359:
9360:
9361: l_adj_percentage NUMBER ;
9362:

Line 9414: FROM pa_budget_lines pbl, pa_resource_assignments pra

9410: l_period_nameTab SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
9411:
9412: CURSOR Cur_group_source_budget_lines IS
9413: SELECT distinct pbl.resource_assignment_id resource_assignment_id, pbl.start_date start_date,pra.rate_based_flag
9414: FROM pa_budget_lines pbl, pa_resource_assignments pra
9415: WHERE pbl.budget_version_id = p_source_plan_version_id
9416: AND pra.resource_assignment_id = pbl.resource_assignment_id;
9417:
9418: CURSOR Cur_source_budget_lines(p_resource_assignment_id IN NUMBER, p_start_date IN DATE

Line 9965: FROM pa_resource_assignments pra

9961: ,DECODE(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_burden_cost_rate_override,NULL),NULL) -- burden_cost_rate_override
9962: ,null -- cost_ind_compiled_set_id
9963: ,null -- pc_cur_conv_rejection_code
9964: ,null -- pfc_cur_conv_rejection_code
9965: FROM pa_resource_assignments pra
9966: WHERE rec_group_source_budget_lines.resource_assignment_id = pra.parent_assignment_id
9967: AND pra.budget_version_id=p_target_plan_version_id;
9968:
9969: END IF; -- l_budget_line_idTab.count

Line 10343: UPDATE pa_resource_assignments

10339: || l_people_res_class_rlm_id;
10340: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,3);
10341: END IF;
10342:
10343: UPDATE pa_resource_assignments
10344: SET resource_list_member_id = l_people_res_class_rlm_id
10345: WHERE budget_version_id = p_wp_version_id
10346: AND resource_class_code = 'PEOPLE'
10347: AND resource_class_flag = 'Y';

Line 10407: UPDATE pa_resource_assignments

10403: IF nvl(l_txn_source_id_tbl.last,0) >= 1 THEN
10404:
10405: -- Update resource assignments data for the version
10406: FORALL i IN l_txn_source_id_tbl.first .. l_txn_source_id_tbl.last
10407: UPDATE pa_resource_assignments
10408: SET rbs_element_id = l_rbs_element_id_tbl(i)
10409: ,txn_accum_header_id = l_txn_accum_header_id_tbl(i)
10410: ,record_version_number = record_version_number + 1
10411: ,last_update_date = SYSDATE