[Home] [Help]
3119: pa_debug.g_err_stage:= 'Delete records if any from the rollup tmp';
3120: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,3);
3121: END IF;
3122:
3123: delete from pa_fp_rollup_tmp; /* Included after UT */
3124:
3125: /* 2727304: Getting the Proj and Proj Func Currencies of the Fin Plan version's project.
3126: These will be used to populate the Proj and Projfunc currency codes in the
3127: pa_fp_rollup_tmp table in case they are not being passed to this API. */
3123: delete from pa_fp_rollup_tmp; /* Included after UT */
3124:
3125: /* 2727304: Getting the Proj and Proj Func Currencies of the Fin Plan version's project.
3126: These will be used to populate the Proj and Projfunc currency codes in the
3127: pa_fp_rollup_tmp table in case they are not being passed to this API. */
3128:
3129: IF P_PA_DEBUG_MODE = 'Y' THEN
3130: pa_debug.g_err_stage:= 'Getting the proj and projfunc currency codes';
3131: pa_debug.write('CREATE_FINPLAN_LINES: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3142:
3143: --Bulk insert into the rollup tmp table.
3144: IF nvl(p_budget_lines_tab.last,0) > 0 THEN
3145: FORALL i in p_budget_lines_tab.first..p_budget_lines_tab.last
3146: Insert into pa_fp_rollup_tmp
3147: (
3148: system_reference1 --task_id
3149: ,system_reference2 --rlmid
3150: ,System_reference3 -- CBS_ELEMENT_ID 16598322
3496: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3497: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE
3498: ,PM_PRODUCT_CODE -- , l_pm_product_code changed to pm_product_code for bug 3833724
3499: ,PM_BUDGET_LINE_REFERENCE -- Added for bug 3833724
3500: FROM pa_fp_rollup_tmp tmp
3501: WHERE tmp.budget_line_id IS NULL
3502: AND (tmp.txn_raw_cost IS NOT NULL
3503: or tmp.txn_burdened_cost IS NOT NULL
3504: or tmp.quantity IS NOT NULL
3632: PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE,NULL,
3633: PROJECT_REV_RATE_DATE)--Bug 4133468. PROJECT_REV_RATE_DATE
3634: ,PM_PRODUCT_CODE -- , l_pm_product_code changed to pm_product_code for bug 3833724
3635: ,PM_BUDGET_LINE_REFERENCE -- Added for bug 3833724
3636: FROM pa_fp_rollup_tmp tmp
3637: WHERE tmp.budget_line_id IS NULL); /*Changed for bug 4224464. When a budget line is passed for which amounts and quantity
3638: were not passed i.e these values were miss_xxx values then these lines wont get selected here
3639: but in this case our intent should be to not update these columns for these lines and update
3640: the rest of the coulmns*/
4537: ,l_resource_assignment_tab
4538: ,l_delete_budget_lines_tab
4539: ,l_spread_amts_flag_tab
4540: ,l_number_null_tab -- bug 3825873
4541: FROM pa_fp_rollup_tmp;
4542:
4543: -- Change of Code for Bug 3732414 Ends Here
4544:
4545: IF l_debug_mode = 'Y' THEN