APPS.PA_DELETE_ACCUM_RECS dependencies on PA_PROJECT_ACCUM_COMMITMENTS

Line 5: -- This procedure deletes records from PA_PROJECT_ACCUM_COMMITMENTS

1: PACKAGE BODY PA_DELETE_ACCUM_RECS AS
2: /* $Header: PAACDELB.pls 120.2 2005/09/26 15:12:32 jwhite noship $ */
3:
4:
5: -- This procedure deletes records from PA_PROJECT_ACCUM_COMMITMENTS
6: --
7: --
8: --Note:
9: --

Line 49: x_err_stage := 'Deleting PA_PROJECT_ACCUM_COMMITMENTS';

45: V_Old_Stack := x_err_stack;
46: x_err_stack :=
47: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Commitments';
48: x_err_code := 0;
49: x_err_stage := 'Deleting PA_PROJECT_ACCUM_COMMITMENTS';
50: tot_recs_processed := 0;
51:
52: pa_debug.debug(x_err_stack);
53:

Line 68: Delete From PA_PROJECT_ACCUM_COMMITMENTS PAC

64: Loop
65:
66: -- Except for the Project-Level Record, Purge ALL Other Commitment Records --------------
67:
68: Delete From PA_PROJECT_ACCUM_COMMITMENTS PAC
69: Where PAC.Project_Accum_id IN
70: (Select Project_Accum_id
71: from PA_PROJECT_ACCUM_HEADERS PAH
72: Where PAH.Project_Id = x_project_id

Line 91: UPDATE pa_project_accum_commitments SET

87:
88:
89: -- Initialize the Project-Level Commitments Records to Zeros/NULLs -----------
90:
91: UPDATE pa_project_accum_commitments SET
92: CMT_RAW_COST_ITD = 0
93: ,CMT_RAW_COST_YTD = 0
94: ,CMT_RAW_COST_PP = 0
95: ,CMT_RAW_COST_PTD = 0

Line 614: -- This procedure deletes records from PA_PROJECT_ACCUM_COMMITMENTS for the

610: RAISE;
611:
612: End Delete_Res_List_Actuals;
613:
614: -- This procedure deletes records from PA_PROJECT_ACCUM_COMMITMENTS for the
615: -- given Resource List
616: --
617: -- Note: This procedure does not require modification for Project List
618: -- functionality.

Line 635: x_err_stage := 'deleting PA_PROJECT_ACCUM_COMMITMENTS';

631: V_Old_Stack := x_err_stack;
632: x_err_stack :=
633: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Res_List_Commitments';
634: x_err_code := 0;
635: x_err_stage := 'deleting PA_PROJECT_ACCUM_COMMITMENTS';
636: tot_recs_processed := 0;
637:
638: pa_debug.debug(x_err_stack);
639:

Line 642: Delete From PA_PROJECT_ACCUM_COMMITMENTS PAC

638: pa_debug.debug(x_err_stack);
639:
640: Loop
641:
642: Delete From PA_PROJECT_ACCUM_COMMITMENTS PAC
643: Where Project_Accum_id IN
644: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
645: PAH.Project_Id = x_project_id and
646: PAH.resource_list_member_id <> 0 and

Line 743: (Select 'Yes' from PA_PROJECT_ACCUM_COMMITMENTS PAC

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)
745: AND Not Exists
746: (Select 'Yes' from PA_PROJECT_ACCUM_BUDGETS PAB
747: Where PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID)