APPS.PA_DELETE_ACCUM_RECS dependencies on PA_PROJECT_ACCUM_ACTUALS

Line 409: -- This procedure deletes records from PA_PROJECT_ACCUM_ACTUALS

405: x_err_code := SQLCODE;
406: RAISE;
407: End Delete_Project_Budgets;
408:
409: -- This procedure deletes records from PA_PROJECT_ACCUM_ACTUALS
410: --
411: --
412: --Note:
413: --

Line 451: x_err_stage := 'deleting PA_PROJECT_ACCUM_ACTUALS';

447: V_Old_Stack := x_err_stack;
448: x_err_stack :=
449: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Actuals';
450: x_err_code := 0;
451: x_err_stage := 'deleting PA_PROJECT_ACCUM_ACTUALS';
452: tot_recs_processed := 0;
453:
454: pa_debug.debug(x_err_stack);
455:

Line 473: Delete From PA_PROJECT_ACCUM_ACTUALS PAA

469: LOOP
470:
471: -- Except for Project-Level Record, Purge ALL Other Commitment Records --------------
472:
473: Delete From PA_PROJECT_ACCUM_ACTUALS PAA
474: Where PAA.Project_Accum_id IN
475: (Select Project_Accum_id
476: from PA_PROJECT_ACCUM_HEADERS PAH
477: Where PAH.Project_Id = x_project_id

Line 497: UPDATE pa_project_accum_actuals SET

493:
494:
495: -- Initialize the Project-Level Commitments Records to Zeros/NULLs -----------
496:
497: UPDATE pa_project_accum_actuals SET
498: RAW_COST_ITD = 0
499: ,RAW_COST_YTD = 0
500: ,RAW_COST_PP = 0
501: ,RAW_COST_PTD = 0

Line 555: -- This procedure deletes records from the PA_PROJECT_ACCUM_ACTUALS table

551: RAISE;
552:
553: End Delete_Project_Actuals;
554:
555: -- This procedure deletes records from the PA_PROJECT_ACCUM_ACTUALS table
556: -- for the given Resource List
557: --
558: -- Note: This procedure does not require modification for Project List
559: -- functionality.

Line 576: x_err_stage := 'deleteing PA_PROJECT_ACCUM_ACTUALS';

572: V_Old_Stack := x_err_stack;
573: x_err_stack :=
574: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Res_List_Actuals';
575: x_err_code := 0;
576: x_err_stage := 'deleteing PA_PROJECT_ACCUM_ACTUALS';
577: tot_recs_processed := 0;
578: pa_debug.debug(x_err_stack);
579:
580: Loop

Line 582: Delete From PA_PROJECT_ACCUM_ACTUALS PAA

578: pa_debug.debug(x_err_stack);
579:
580: Loop
581:
582: Delete From PA_PROJECT_ACCUM_ACTUALS PAA
583: Where Project_Accum_id IN
584: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
585: PAH.Project_Id = x_project_id and
586: PAH.resource_list_member_id <> 0 and

Line 740: (Select 'Yes' from PA_PROJECT_ACCUM_ACTUALS PAA

736: Delete From PA_PROJECT_ACCUM_HEADERS PAH Where
737: PAH.Project_Id = x_project_id
738: AND PAH.project_accum_id <> l_Prj_Lvl_Accum_Id -- Don't delete project-level row details.
739: AND Not Exists
740: (Select 'Yes' from PA_PROJECT_ACCUM_ACTUALS PAA
741: Where PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID)
742: AND Not Exists
743: (Select 'Yes' from PA_PROJECT_ACCUM_COMMITMENTS PAC
744: Where PAH.PROJECT_ACCUM_ID = PAC.PROJECT_ACCUM_ID)