[Home] [Help]
814: set start_date= v_project_start_date,
815: end_date = v_project_completion_date
816: where resource_assignment_id in
817: (select resource_assignment_id
818: from pa_resource_assignments
819: where budget_version_id = x_dest_version_id)
820: and ((start_date <> v_project_start_date) OR (end_date <> v_project_completion_date));
821:
822: -- fix 876456: Added check that rows should be updated only if the project start or end
833:
834: for bl_rec in (select start_date,
835: completion_date ,
836: resource_assignment_id
837: from pa_tasks t ,pa_resource_assignments r
838: where t.task_id = r.task_id
839: and r.budget_version_id = x_dest_version_id) loop
840: bl_rec.start_date := nvl(bl_rec.start_date,v_project_start_date);
841: bl_rec.completion_date := nvl(bl_rec.completion_date
1308: and s.closing_status in ('C','P'));
1309: end if;
1310:
1311: x_err_stage := 'About to create new resource assignments in dest';
1312: INSERT INTO pa_resource_assignments
1313: (resource_assignment_id,
1314: budget_version_id,
1315: project_id,
1316: task_id,
1324: track_as_labor_flag,
1325: project_assignment_id,
1326: RESOURCE_ASSIGNMENT_TYPE
1327: )
1328: SELECT pa_resource_assignments_s.nextval,
1329: l_dest_version_id,
1330: sa.project_id,
1331: sa.task_id,
1332: sa.resource_list_member_id,
1339: sa.track_as_labor_flag,
1340: -1,
1341: sa.RESOURCE_ASSIGNMENT_TYPE
1342: FROM
1343: pa_resource_assignments sa,
1344: pa_resource_assignments da
1345: WHERE sa.budget_version_id = p_src_version_id
1346: AND da.budget_version_id(+) = l_dest_version_id
1347: AND sa.project_assignment_id=-1
1340: -1,
1341: sa.RESOURCE_ASSIGNMENT_TYPE
1342: FROM
1343: pa_resource_assignments sa,
1344: pa_resource_assignments da
1345: WHERE sa.budget_version_id = p_src_version_id
1346: AND da.budget_version_id(+) = l_dest_version_id
1347: AND sa.project_assignment_id=-1
1348: AND da.project_assignment_id(+)=-1
1439: pbl.projfunc_currency_code,
1440: pbl.project_currency_code,
1441: pbl.txn_currency_code
1442: from pa_budget_lines pbl,
1443: pa_resource_assignments sra,
1444: pa_resource_assignments dra
1445: where dra.budget_version_id = l_dest_version_id
1446: and sra.budget_version_id = p_src_version_id
1447: and pbl.budget_version_id = p_src_version_id
1440: pbl.project_currency_code,
1441: pbl.txn_currency_code
1442: from pa_budget_lines pbl,
1443: pa_resource_assignments sra,
1444: pa_resource_assignments dra
1445: where dra.budget_version_id = l_dest_version_id
1446: and sra.budget_version_id = p_src_version_id
1447: and pbl.budget_version_id = p_src_version_id
1448: and sra.resource_assignment_id=pbl.resource_assignment_id
1454: where s.application_id = pa_period_process_pkg.application_id
1455: and i.set_of_books_id = s.set_of_books_id
1456: and s.closing_status in ('C','P'));
1457: x_err_stage := 'About to delete unused resource assignments from dest';
1458: delete from pa_resource_assignments
1459: where budget_version_id = l_dest_version_id
1460: and resource_assignment_id not in
1461: (select distinct resource_assignment_id
1462: from pa_budget_lines
1963: --
1964: -- History
1965: -- 27-JUN-2002 jwhite Bug 1877119
1966: -- For the Copy_Lines procedure, add new column
1967: -- for insert into pa_resource_assignments:
1968: -- project_assignment_id, default -1.
1969: --
1970: -- - MOdified to support the new FP model:
1971: -- a. added NVL(a.RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED'
2113: || '>' ;
2114:
2115: IF (x_entry_level_code <> 'P') THEN
2116:
2117: INSERT INTO pa_resource_assignments
2118: (resource_assignment_id,
2119: budget_version_id,
2120: project_id,
2121: task_id,
2129: track_as_labor_flag,
2130: project_assignment_id,
2131: RESOURCE_ASSIGNMENT_TYPE
2132: )
2133: SELECT pa_resource_assignments_s.nextval,
2134: x_dest_version_id,
2135: dt.project_id,
2136: dt.task_id,
2137: sa.resource_list_member_id,
2144: sa.track_as_labor_flag,
2145: -1,
2146: sa.RESOURCE_ASSIGNMENT_TYPE
2147: FROM
2148: pa_resource_assignments sa,
2149: pa_tasks st,
2150: pa_tasks dt,
2151: pa_budget_versions dv
2152: WHERE sa.budget_version_id = x_src_version_id
2158: AND NVL(sa.RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED';
2159:
2160: ELSE
2161:
2162: INSERT INTO pa_resource_assignments
2163: (resource_assignment_id,
2164: budget_version_id,
2165: project_id,
2166: task_id,
2174: track_as_labor_flag,
2175: project_assignment_id,
2176: RESOURCE_ASSIGNMENT_TYPE
2177: )
2178: SELECT pa_resource_assignments_s.nextval,
2179: x_dest_version_id,
2180: dv.project_id,
2181: 0,
2182: sa.resource_list_member_id,
2189: sa.track_as_labor_flag,
2190: -1,
2191: sa.RESOURCE_ASSIGNMENT_TYPE
2192: FROM
2193: pa_resource_assignments sa,
2194: pa_budget_versions dv
2195: WHERE sa.budget_version_id = x_src_version_id
2196: AND sa.task_id = 0
2197: AND dv.budget_version_id = x_dest_version_id
2270:
2271: for budget_line_row in
2272: (select l.resource_assignment_id, l.start_date, l.end_date,a.task_id, l.period_name
2273: from pa_budget_lines l,
2274: pa_resource_assignments a
2275: where a.budget_version_id = x_src_version_id
2276: and a.resource_assignment_id = l.resource_assignment_id
2277: and NVL(a.RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED'
2278: ) loop
2443: l.projfunc_currency_code,
2444: l.project_currency_code,
2445: l.txn_currency_code
2446: from pa_budget_lines l,
2447: pa_resource_assignments sa,
2448: pa_tasks st,
2449: pa_tasks dt,
2450: pa_resource_assignments da,
2451: pa_fp_bl_map_tmp bmt /* FPB2
2446: from pa_budget_lines l,
2447: pa_resource_assignments sa,
2448: pa_tasks st,
2449: pa_tasks dt,
2450: pa_resource_assignments da,
2451: pa_fp_bl_map_tmp bmt /* FPB2
2452: where l.resource_assignment_id =
2453: budget_line_row.resource_assignment_id
2454: and l.start_date = budget_line_row.start_date
2553: l.projfunc_currency_code,
2554: l.project_currency_code,
2555: l.txn_currency_code
2556: from pa_budget_lines l,
2557: pa_resource_assignments sa,
2558: pa_resource_assignments da,
2559: pa_fp_bl_map_tmp bmt /* FPB2
2560: where l.resource_assignment_id =
2561: budget_line_row.resource_assignment_id
2554: l.project_currency_code,
2555: l.txn_currency_code
2556: from pa_budget_lines l,
2557: pa_resource_assignments sa,
2558: pa_resource_assignments da,
2559: pa_fp_bl_map_tmp bmt /* FPB2
2560: where l.resource_assignment_id =
2561: budget_line_row.resource_assignment_id
2562: and l.start_date = budget_line_row.start_date
2664: l_projfunc_currency_code_tbl,
2665: l_project_currency_code_tbl,
2666: l_txn_currency_code_tbl
2667: from pa_budget_lines l,
2668: pa_resource_assignments sa,
2669: pa_tasks st,
2670: pa_tasks dt,
2671: pa_resource_assignments da,
2672: pa_fp_bl_map_tmp bmt /* FPB2 */
2667: from pa_budget_lines l,
2668: pa_resource_assignments sa,
2669: pa_tasks st,
2670: pa_tasks dt,
2671: pa_resource_assignments da,
2672: pa_fp_bl_map_tmp bmt /* FPB2 */
2673: where l.budget_version_id = x_src_version_id
2674: and l.resource_assignment_id = sa.resource_assignment_id
2675: and sa.budget_version_id = x_src_version_id
2769: l_projfunc_currency_code_tbl,
2770: l_project_currency_code_tbl,
2771: l_txn_currency_code_tbl
2772: from pa_budget_lines l,
2773: pa_resource_assignments sa,
2774: pa_resource_assignments da,
2775: pa_fp_bl_map_tmp bmt /* FPB2 */
2776: where l.budget_version_id = x_src_version_id
2777: and l.resource_assignment_id = sa.resource_assignment_id
2770: l_project_currency_code_tbl,
2771: l_txn_currency_code_tbl
2772: from pa_budget_lines l,
2773: pa_resource_assignments sa,
2774: pa_resource_assignments da,
2775: pa_fp_bl_map_tmp bmt /* FPB2 */
2776: where l.budget_version_id = x_src_version_id
2777: and l.resource_assignment_id = sa.resource_assignment_id
2778: and sa.budget_version_id = x_src_version_id
2871: l_projfunc_currency_code_tbl,
2872: l_project_currency_code_tbl,
2873: l_txn_currency_code_tbl
2874: from pa_budget_lines l,
2875: pa_resource_assignments sa,
2876: pa_tasks st,
2877: pa_tasks dt,
2878: pa_resource_assignments da,
2879: pa_fp_bl_map_tmp bmt, /* FPB2 */
2874: from pa_budget_lines l,
2875: pa_resource_assignments sa,
2876: pa_tasks st,
2877: pa_tasks dt,
2878: pa_resource_assignments da,
2879: pa_fp_bl_map_tmp bmt, /* FPB2 */
2880: PA_FP_CPY_PERIODS_TMP pptmp
2881: where l.budget_version_id = x_src_version_id
2882: and l.resource_assignment_id = sa.resource_assignment_id
2980: l_projfunc_currency_code_tbl,
2981: l_project_currency_code_tbl,
2982: l_txn_currency_code_tbl
2983: from pa_budget_lines l,
2984: pa_resource_assignments sa,
2985: pa_resource_assignments da,
2986: pa_fp_bl_map_tmp bmt, /* FPB2 */
2987: PA_FP_CPY_PERIODS_TMP pptmp
2988: where l.budget_version_id = x_src_version_id
2981: l_project_currency_code_tbl,
2982: l_txn_currency_code_tbl
2983: from pa_budget_lines l,
2984: pa_resource_assignments sa,
2985: pa_resource_assignments da,
2986: pa_fp_bl_map_tmp bmt, /* FPB2 */
2987: PA_FP_CPY_PERIODS_TMP pptmp
2988: where l.budget_version_id = x_src_version_id
2989: and l.resource_assignment_id = sa.resource_assignment_id
3086: l_projfunc_currency_code_tbl,
3087: l_project_currency_code_tbl,
3088: l_txn_currency_code_tbl
3089: from pa_budget_lines l,
3090: pa_resource_assignments sa,
3091: pa_tasks st,
3092: pa_tasks dt,
3093: pa_resource_assignments da,
3094: pa_fp_bl_map_tmp bmt /* FPB2 */
3089: from pa_budget_lines l,
3090: pa_resource_assignments sa,
3091: pa_tasks st,
3092: pa_tasks dt,
3093: pa_resource_assignments da,
3094: pa_fp_bl_map_tmp bmt /* FPB2 */
3095: where l.budget_version_id = x_src_version_id
3096: and l.resource_assignment_id = sa.resource_assignment_id
3097: and sa.budget_version_id = x_src_version_id
3192: l_projfunc_currency_code_tbl,
3193: l_project_currency_code_tbl,
3194: l_txn_currency_code_tbl
3195: from pa_budget_lines l,
3196: pa_resource_assignments sa,
3197: pa_resource_assignments da,
3198: pa_fp_bl_map_tmp bmt /* FPB2 */
3199: where l.budget_version_id = x_src_version_id
3200: and l.resource_assignment_id = sa.resource_assignment_id
3193: l_project_currency_code_tbl,
3194: l_txn_currency_code_tbl
3195: from pa_budget_lines l,
3196: pa_resource_assignments sa,
3197: pa_resource_assignments da,
3198: pa_fp_bl_map_tmp bmt /* FPB2 */
3199: where l.budget_version_id = x_src_version_id
3200: and l.resource_assignment_id = sa.resource_assignment_id
3201: and sa.budget_version_id = x_src_version_id