1 PACKAGE PA_DELETE_ACCUM_RECS AS
2 /* $Header: PAACDELS.pls 120.1 2005/08/19 16:14:01 mwasowic noship $ */
3
4 -- -- Package Internal Globals (bug 2633920) -------------------------------------
5
6 G_Prj_Lvl_project_id pa_projects_all.project_id%TYPE := NULL;
7 G_Prj_Lvl_Accum_Id pa_project_accum_headers.project_accum_id%TYPE := NULL;
8
9
10 -- This package contains the following procedures ----------------------------------
11
12 -- Delete_Project_Commitments - This deletes the records from
13 -- PA_PROJECT_ACCUM_COMMITMENTS for the
14 -- given project.This procedure will be
15 -- called everytime commitments are accumulated
16
17 -- Delete_Project_Budgets - This deletes the records from
18 -- PA_PROJECT_ACCUM_BUDGETS for the
19 -- given project and Budget type. This procedure
20 -- will be called every time Budgets are accumulated
21
22 -- Delete_Project_Actuals - This deletes the records from
23 -- PA_PROJECT_ACCUM_ACTUALS for the
24 -- given project. This procedure would be called
25 -- every time Actuals are refreshed
26
27 -- Delete_Res_List_Actuals - This deletes the records from
28 -- PA_PROJECT_ACCUM_ACTUALS for the
29 -- given project and Resource list .
30 -- This procedure would be called
31 -- every time Actuals are refreshed for a Resource list
32
33 -- Delete_Res_List_Commitments - This deletes the records from
34 -- PA_PROJECT_ACCUM_COMMITMENTS for the
35 -- given project and Resource list .
36 -- This procedure would be called
37 -- every time commitments are refreshed for a
38 -- Resource list
39
40 -- Delete_Project_Accum_Headers - This checks for any records in
41 -- PA_PROJECT_ACCUM_HEADERS which does not
42 -- have any corresponding Actuals,Budgets and
43 -- commitments and deletes such records
44 -- This procedure would be called after
45 -- a Project is refreshed
46
47 -- Bug 2633920
48 -- Get_Proj_Lvl_Accum_Id - This procedure populates the package globals
49 -- used for processing by the following procedures:
50 -- - Delete_Project_Commitments
51 -- - Delete_Project_Budgets
52 -- - Delete_Project_Actuals
53
54
55 Procedure Delete_Project_Commitments (x_project_Id In Number,
56 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
57 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
58 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
59
60 Procedure Delete_Project_Budgets (x_project_Id In Number,
61 x_budget_Type_Code In Varchar2,
62 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
63 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
64 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
65
66 Procedure Delete_Project_Actuals (x_project_Id In Number,
67 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
68 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
69 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
70
71 Procedure Delete_Res_List_Actuals (x_project_id In Number,
72 x_Resource_list_id In Number,
73 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
74 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
75 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
76
77 Procedure Delete_Res_List_Commitments (x_project_id In Number,
78 x_Resource_list_id In Number,
79 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
80 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
81 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
82
83 Procedure Delete_Project_Accum_Headers (x_project_id In Number,
84 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
85 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
86 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
87 -- bug 2633920
88 PROCEDURE Get_Prj_Lvl_Accum_Id (p_project_id IN NUMBER
89 , x_Prj_Lvl_Accum_Id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
90 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
91 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
92 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
93 );
94
95
96
97
98 End ;