[Home] [Help]
909: set start_date= v_project_start_date,
910: end_date = v_project_completion_date
911: where resource_assignment_id in
912: (select resource_assignment_id
913: from pa_resource_assignments
914: where budget_version_id = l_target_version_id)
915: and ((start_date <> v_project_start_date) OR (end_date <> v_project_completion_date));
916:
917: -- Check that rows should be updated only if the project start or end
927:
928: for bl_rec in (select start_date,
929: completion_date ,
930: resource_assignment_id
931: from pa_tasks t ,pa_resource_assignments r
932: where t.task_id = r.task_id and
933: r.budget_version_id = l_target_version_id)
934: loop
935: bl_rec.start_date := nvl(bl_rec.start_date,v_project_start_date);
2176: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
2177: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2178: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2179:
2180: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
2181: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
2182: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
2183:
2184: l_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab; /* Included for bug 2672654 */
2178: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2179:
2180: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
2181: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
2182: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
2183:
2184: l_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab; /* Included for bug 2672654 */
2185:
2186: -- Bug Fix: 4569365. Removed MRC code.
2731:
2732: DECLARE
2733: l_dummy_res_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
2734: l_dummy_row_id ROWID;
2735: l_dummy_ra_id PA_RESOURCE_ASSIGNMENTS.resource_assignment_id%TYPE;
2736: BEGIN
2737:
2738: PA_FIN_PLAN_UTILS.Get_Uncat_Resource_List_Info
2739: (x_resource_list_id => l_dummy_res_list_id
2767: x_msg_count => x_msg_count,
2768: x_msg_data => x_msg_data);
2769:
2770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2771: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
2772: IF P_PA_DEBUG_MODE = 'Y' THEN
2773: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2774: END IF;
2775: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2904: END CREATE_DRAFT;
2905:
2906: /*
2907: This procedure would use the input budget_line_tbl to insert records into
2908: pa_resource_assignments, pa_budget_lines, pa_mc_budget_lines and also takes
2909: care of rolling up the resource assignments and maintaining the denorm table.
2910: */
2911: PROCEDURE CREATE_FINPLAN_LINES
2912: ( -- Bug Fix: 4569365. Removed MRC code.
3651: IF(p_calling_context = PA_FP_CONSTANTS_PKG.G_AMG_API) THEN
3652: -- For scenario if actuals exist then planning start date for resource assignment
3653: -- should be least of the value presnt in pa_fp_spread_calc_tmp1 and pa_budget_lines
3654: -- else it should be least of value present in pa_fp_spread_calc_tmp1.
3655: update pa_resource_assignments pra
3656: set (planning_start_date, planning_end_date)
3657: = (select decode(min(pbl.start_date),NULL,
3658: nvl(min(tmp.start_date), planning_start_date),
3659: least(nvl(min(tmp.start_date), planning_start_date),
3663: where tmp.resource_assignment_id = pra.resource_assignment_id
3664: and pbl.resource_assignment_id (+)= tmp.resource_assignment_id)
3665: where pra.budget_version_id = p_fin_plan_version_id;
3666: ELSE
3667: update pa_resource_assignments pra
3668: set (planning_start_date, planning_end_date)
3669: = (select nvl(min(start_date), planning_start_date),
3670: nvl(max(end_date), planning_end_date)
3671: from pa_fp_spread_calc_tmp1 tmp /* Bug 4221590 */