APPS.PA_DELETE_ACCUM_RECS dependencies on PA_PROJECT_ACCUM_BUDGETS

Line 125: -- This procedure deletes records from PA_PROJECT_ACCUM_BUDGETS after

121: x_err_code := SQLCODE;
122: RAISE;
123: End Delete_Project_Commitments;
124:
125: -- This procedure deletes records from PA_PROJECT_ACCUM_BUDGETS after
126: -- ensuring that the current Budget version has not been accumulated.
127: --
128: --
129: --Note:

Line 191: -- Unlike the summarization pa_project_accum_budgets INSERT logic, this cursor logic does NOT need

187: --
188: -- 3) A-L-L r11.5.7 Budget and FP Model budget records
189: --
190: -- Please Note:
191: -- Unlike the summarization pa_project_accum_budgets INSERT logic, this cursor logic does NOT need
192: -- to consider as many cases for the FP Model for the following reasons:
193: --
194: -- 1) This logic simply deletes records. It is not concerned with double-counting amounts.
195: --

Line 275: x_err_stage := 'deleteing pa_project_accum_budgets';

271: V_Old_Stack := x_err_stack;
272: x_err_stack :=
273: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Budgets';
274: x_err_code := 0;
275: x_err_stage := 'deleteing pa_project_accum_budgets';
276:
277: pa_debug.debug(x_err_stack);
278:
279:

Line 304: Delete From PA_PROJECT_ACCUM_BUDGETS

300: -- Except for the AC and AR Project-Level records, Purge ALL Other Records
301: -- because specified tasks/resources may have changed
302: -- since last baseline.
303:
304: Delete From PA_PROJECT_ACCUM_BUDGETS
305: Where Budget_Type_Code = Budget_ver_rec.budget_type_code
306: and Project_Accum_id IN
307: (Select Project_Accum_id
308: from PA_PROJECT_ACCUM_HEADERS PAH

Line 315: UPDATE pa_project_accum_budgets SET

311: );
312:
313: -- INIT AC/AR Project-Level Budget Record to Zeros/NULLs ----------
314:
315: UPDATE pa_project_accum_budgets SET
316: BASE_RAW_COST_ITD = 0
317: ,BASE_RAW_COST_YTD = 0
318: ,BASE_RAW_COST_PP = 0
319: ,BASE_RAW_COST_PTD = 0

Line 380: Delete From PA_PROJECT_ACCUM_BUDGETS

376: ELSE
377:
378: -- Purge ALL r11.5.7 Budget and/or FP Budget Records
379:
380: Delete From PA_PROJECT_ACCUM_BUDGETS
381: Where Budget_Type_Code = Budget_ver_rec.budget_type_code
382: and Project_Accum_id IN
383: (Select Project_Accum_id
384: from PA_PROJECT_ACCUM_HEADERS PAH

Line 746: (Select 'Yes' from PA_PROJECT_ACCUM_BUDGETS PAB

742: AND Not Exists
743: (Select 'Yes' from PA_PROJECT_ACCUM_COMMITMENTS PAC
744: Where PAH.PROJECT_ACCUM_ID = PAC.PROJECT_ACCUM_ID)
745: AND Not Exists
746: (Select 'Yes' from PA_PROJECT_ACCUM_BUDGETS PAB
747: Where PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID)
748: and rownum <= pa_proj_accum_main.x_commit_size;
749:
750: