1 PACKAGE PA_PROCESS_ACCUM_BUDGETS AUTHID CURRENT_USER AS
2 /* $Header: PABUTSKS.pls 120.1 2005/08/19 16:17:24 mwasowic noship $ */
3
4 -- Modified on 10/29/98 by S Sanckar to include a new procedure
5 -- Process_all_tasks_bud that updates the raw_cost, burdened_cost, quantity,
6 -- labor_quantity and revenue values for baselined and original budgets
7 -- This will update the amount columns for period_to_date and prior_period
8 -- and year_to_date apart from inception_to_date periods.
9
10 -- This package contains the following procedures
11
12 -- Process_all_tasks_bud - Processes ITD,YTD,PTD and PP amounts in the
13 -- PA_PROJECT_ACCUM_BUDGETS table. For the given
14 -- Project_Task combination, records are created/
15 -- updated and rolled up to all the higher tasks.
16
17 -- Process_it_yt_pt_tasks_bud - Processes ITD,YTD and PTD amounts in the
18 -- PA_PROJECT_ACCUM_BUDGETS table. For the
19 -- given Project-Task combination,records are
20 -- created/updated and rolled up to all the
21 -- higher level tasks.
22
23 -- Process_it_yt_pp_tasks_bud - Processes ITD,YTD and PP amounts in the
24 -- PA_PROJECT_ACCUM_BUDGETS table. For the
25 -- given Project-Task combination,records are
26 -- created/updated and rolled up to all the
27 -- higher level tasks.
28
29 -- Process_it_pp_tasks_bud - Processes ITD and PP amounts in the
30 -- PA_PROJECT_ACCUM_BUDGETS table. For the
31 -- given Project-Task combination,records are
32 -- created/updated and rolled up to all the
33 -- higher level tasks.
34
35 -- Process_it_yt_tasks_bud - Processes ITD and YTD amounts in the
36 -- PA_PROJECT_ACCUM_BUDGETS table. For the
37 -- given Project-Task combination,records are
38 -- created/updated and rolled up to all the
39 -- higher level tasks.
40
41 -- Process_it_tasks_bud - Processes ITD amounts in the
42 -- PA_PROJECT_ACCUM_BUDGETS table. For the
43 -- given Project-Task combination,records are
44 -- created/updated and rolled up to all the
45 -- higher level tasks.
46
47 Procedure Process_all_tasks_bud
48 (x_project_id In Number,
49 x_task_id In Number,
50 x_Proj_Accum_Id In Number,
51 x_budget_type_code In Varchar2,
52 X_Base_Raw_Cost_ptd In Number,
53 X_Base_Burdened_Cost_ptd In Number,
54 X_Base_Revenue_ptd In Number,
55 X_Base_Quantity_ptd In Number,
56 X_Base_Labor_Hours_ptd In Number,
57 X_Base_Raw_Cost_pp In Number,
58 X_Base_Burdened_Cost_pp In Number,
59 X_Base_Revenue_pp In Number,
60 X_Base_Quantity_pp In Number,
61 X_Base_Labor_Hours_pp In Number,
62 X_Base_Raw_Cost_ytd In Number,
63 X_Base_Burdened_Cost_ytd In Number,
64 X_Base_Revenue_ytd In Number,
65 X_Base_Quantity_ytd In Number,
66 X_Base_Labor_Hours_ytd In Number,
67 X_Base_Raw_Cost_itd In Number,
68 X_Base_Burdened_Cost_itd In Number,
69 X_Base_Revenue_itd In Number,
70 X_Base_Quantity_itd In Number,
71 X_Base_Labor_Hours_itd In Number,
72 X_Base_Unit_Of_Measure In Varchar2,
73 X_Orig_Raw_Cost_ptd In Number,
74 X_Orig_Burdened_Cost_ptd In Number,
75 X_Orig_Revenue_ptd In Number,
76 X_Orig_Quantity_ptd In Number,
77 X_Orig_Labor_Hours_ptd In Number,
78 X_Orig_Raw_Cost_pp In Number,
79 X_Orig_Burdened_Cost_pp In Number,
80 X_Orig_Revenue_pp In Number,
81 X_Orig_Quantity_pp In Number,
82 X_Orig_Labor_Hours_pp In Number,
83 X_Orig_Raw_Cost_ytd In Number,
84 X_Orig_Burdened_Cost_ytd In Number,
85 X_Orig_Revenue_ytd In Number,
86 X_Orig_Quantity_ytd In Number,
87 X_Orig_Labor_Hours_ytd In Number,
88 X_Orig_Raw_Cost_itd In Number,
89 X_Orig_Burdened_Cost_itd In Number,
90 X_Orig_Revenue_itd In Number,
91 X_Orig_Quantity_itd In Number,
92 X_Orig_Labor_Hours_itd In Number,
93 X_Orig_Unit_Of_Measure In Varchar2,
94 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
95 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
96 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
97 x_err_code In Out NOCOPY Number); --File.Sql.39 bug 4440895
98
99 Procedure Process_it_yt_pt_tasks_bud
100 (x_project_id In Number,
101 x_task_id In Number,
102 x_Proj_Accum_Id In Number,
103 x_budget_type_code In Varchar2,
104 x_current_period In Varchar2,
105 X_Base_Revenue In Number,
106 X_Base_Raw_Cost In Number,
107 X_Base_Burdened_Cost In Number,
108 X_Base_Labor_Hours In Number,
109 X_Base_Quantity In Number,
110 X_Base_Unit_Of_Measure In Varchar2,
111 X_Orig_Revenue In Number,
112 X_Orig_Raw_Cost In Number,
113 X_Orig_Burdened_Cost In Number,
114 X_Orig_Labor_Hours In Number,
115 X_Orig_Quantity In Number,
116 X_Orig_Unit_Of_Measure In Varchar2,
117 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
118 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
119 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
120 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
121
122 Procedure Process_it_yt_pp_tasks_bud
123 (x_project_id In Number,
124 x_task_id In Number,
125 x_Proj_Accum_Id In Number,
126 x_budget_type_code In Varchar2,
127 x_current_period In Varchar2,
128 X_Base_Revenue In Number,
129 X_Base_Raw_Cost In Number,
130 X_Base_Burdened_Cost In Number,
131 X_Base_Labor_Hours In Number,
132 X_Base_Quantity In Number,
133 X_Base_Unit_Of_Measure In Varchar2,
134 X_Orig_Revenue In Number,
135 X_Orig_Raw_Cost In Number,
136 X_Orig_Burdened_Cost In Number,
137 X_Orig_Labor_Hours In Number,
138 X_Orig_Quantity In Number,
139 X_Orig_Unit_Of_Measure In Varchar2,
140 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
141 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
142 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
143 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
144
145
146 Procedure Process_it_pp_tasks_bud
147 (x_project_id In Number,
148 x_task_id In Number,
149 x_Proj_Accum_Id In Number,
150 x_budget_type_code In Varchar2,
151 x_current_period In Varchar2,
152 X_Base_Revenue In Number,
153 X_Base_Raw_Cost In Number,
154 X_Base_Burdened_Cost In Number,
155 X_Base_Labor_Hours In Number,
156 X_Base_Quantity In Number,
157 X_Base_Unit_Of_Measure In Varchar2,
158 X_Orig_Revenue In Number,
159 X_Orig_Raw_Cost In Number,
160 X_Orig_Burdened_Cost In Number,
161 X_Orig_Labor_Hours In Number,
162 X_Orig_Quantity In Number,
163 X_Orig_Unit_Of_Measure In Varchar2,
164 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
165 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
166 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
167 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
168
169
170 Procedure Process_it_yt_tasks_bud
171 (x_project_id In Number,
172 x_task_id In Number,
173 x_Proj_Accum_Id In Number,
174 x_budget_type_code In Varchar2,
175 x_current_period In Varchar2,
176 X_Base_Revenue In Number,
177 X_Base_Raw_Cost In Number,
178 X_Base_Burdened_Cost In Number,
179 X_Base_Labor_Hours In Number,
180 X_Base_Quantity In Number,
181 X_Base_Unit_Of_Measure In Varchar2,
182 X_Orig_Revenue In Number,
183 X_Orig_Raw_Cost In Number,
184 X_Orig_Burdened_Cost In Number,
185 X_Orig_Labor_Hours In Number,
186 X_Orig_Quantity In Number,
187 X_Orig_Unit_Of_Measure In Varchar2,
188 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
189 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
190 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
191 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
192
193 Procedure Process_it_tasks_bud
194 (x_project_id In Number,
195 x_task_id In Number,
196 x_Proj_Accum_Id In Number,
197 x_budget_type_code In Varchar2,
198 x_current_period In Varchar2,
199 X_Base_Revenue In Number,
200 X_Base_Raw_Cost In Number,
201 X_Base_Burdened_Cost In Number,
202 X_Base_Labor_Hours In Number,
203 X_Base_Quantity In Number,
204 X_Base_Unit_Of_Measure In Varchar2,
205 X_Orig_Revenue In Number,
206 X_Orig_Raw_Cost In Number,
207 X_Orig_Burdened_Cost In Number,
208 X_Orig_Labor_Hours In Number,
209 X_Orig_Quantity In Number,
210 X_Orig_Unit_Of_Measure In Varchar2,
211 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
212 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
213 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
214 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
215 END;