1 PACKAGE PA_PROCESS_ACCUM_BUDGETS_RES AS
2 /* $Header: PABURESS.pls 120.1 2005/08/19 16:17:14 mwasowic noship $ */
3
4 -- Modified on 10/29/98 by S Sanckar to include a new procedure
5 -- Process_all_res_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 TYPE task_id_tabtype IS TABLE OF PA_TASKS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
11 -- This package contains the following procedures
12
13 -- Process_all_res_bud - Processes ITD,YTD,PP and PTD amounts in the
14 -- PA_PROJECT_ACCUM_BUDGETS table. For the
15 -- given Project-Task-Resource combination,records are
16 -- created/updated and rolled up to all the
17 -- higher level tasks. The Project-Resource records
18 -- are also created/updated.
19
20 -- This package contains the following procedures
21
22 -- Process_it_yt_pt_res_bud - Processes ITD,YTD and PTD amounts in the
23 -- PA_PROJECT_ACCUM_BUDGETS table. For the
24 -- given Project-Task-Resource combination,records are
25 -- created/updated and rolled up to all the
26 -- higher level tasks. The Project-Resource records
27 -- are also created/updated.
28
29 -- Process_it_yt_pp_res_bud - Processes ITD,YTD and PP amounts in the
30 -- PA_PROJECT_ACCUM_BUDGETS table. For the
31 -- given Project-Task-Resource combination,records are
32 -- created/updated and rolled up to all the
33 -- higher level tasks. The Project-Resource records
34 -- are also created/updated.
35
36 -- Process_it_pp_res_bud - Processes ITD and PP amounts in the
37 -- PA_PROJECT_ACCUM_BUDGETS table. For the
38 -- given Project-Task-Resource combination,records are
39 -- created/updated and rolled up to all the
40 -- higher level tasks. The Project-Resource records
41 -- are also created/updated.
42
43 -- Process_it_yt_res_bud - Processes ITD and YTD amounts in the
44 -- PA_PROJECT_ACCUM_BUDGETS table. For the
45 -- given Project-Task-Resource combination,records are
46 -- created/updated and rolled up to all the
47 -- higher level tasks. The Project-Resource records
48 -- are also created/updated.
49
50 -- Process_it_res_bud - Processes ITD amounts in the
51 -- PA_PROJECT_ACCUM_BUDGETS table. For the
52 -- given Project-Task-Resource combination,records are
53 -- created/updated and rolled up to all the
54 -- higher level tasks. The Project-Resource records
55 -- are also created/updated.
56
57 Procedure Process_all_res_bud
58 (x_project_id In Number,
59 x_task_id In Number,
60 x_resource_list_id In Number,
61 x_resource_list_Member_id In Number,
62 x_resource_id In Number,
63 x_resource_list_assignment_id In Number,
64 x_rollup_qty_flag In Varchar2,
65 x_budget_type_code In Varchar2,
66 X_Base_Raw_Cost_ptd In Number,
67 X_Base_Burdened_Cost_ptd In Number,
68 X_Base_Revenue_ptd In Number,
69 X_Base_Quantity_ptd In Number,
70 X_Base_Labor_Hours_ptd In Number,
71 X_Base_Raw_Cost_pp In Number,
72 X_Base_Burdened_Cost_pp In Number,
73 X_Base_Revenue_pp In Number,
74 X_Base_Quantity_pp In Number,
75 X_Base_Labor_Hours_pp In Number,
76 X_Base_Raw_Cost_ytd In Number,
77 X_Base_Burdened_Cost_ytd In Number,
78 X_Base_Revenue_ytd In Number,
79 X_Base_Quantity_ytd In Number,
80 X_Base_Labor_Hours_ytd In Number,
81 X_Base_Raw_Cost_itd In Number,
82 X_Base_Burdened_Cost_itd In Number,
83 X_Base_Revenue_itd In Number,
84 X_Base_Quantity_itd In Number,
85 X_Base_Labor_Hours_itd In Number,
86 X_Base_Unit_Of_Measure In Varchar2,
87 X_Orig_Raw_Cost_ptd In Number,
88 X_Orig_Burdened_Cost_ptd In Number,
89 X_Orig_Revenue_ptd In Number,
90 X_Orig_Quantity_ptd In Number,
91 X_Orig_Labor_Hours_ptd In Number,
92 X_Orig_Raw_Cost_pp In Number,
93 X_Orig_Burdened_Cost_pp In Number,
94 X_Orig_Revenue_pp In Number,
95 X_Orig_Quantity_pp In Number,
96 X_Orig_Labor_Hours_pp In Number,
97 X_Orig_Raw_Cost_ytd In Number,
98 X_Orig_Burdened_Cost_ytd In Number,
99 X_Orig_Revenue_ytd In Number,
100 X_Orig_Quantity_ytd In Number,
101 X_Orig_Labor_Hours_ytd In Number,
102 X_Orig_Raw_Cost_itd In Number,
103 X_Orig_Burdened_Cost_itd In Number,
104 X_Orig_Revenue_itd In Number,
105 X_Orig_Quantity_itd In Number,
106 X_Orig_Labor_Hours_itd In Number,
107 X_Orig_Unit_Of_Measure In Varchar2,
108 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
109 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
110 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
111 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
112
113 Procedure Process_it_yt_pt_res_bud
114 (x_project_id In Number,
115 x_task_id In Number,
116 x_resource_list_id in Number,
117 x_resource_list_Member_id in Number,
118 x_resource_id in Number,
119 x_resource_list_assignment_id in Number,
120 x_rollup_qty_flag In Varchar2,
121 x_budget_type_code In Varchar2,
122 x_current_period In Varchar2,
123 X_Base_Revenue In Number,
124 X_Base_Raw_Cost In Number,
125 X_Base_Burdened_Cost In Number,
126 X_Base_Labor_Hours In Number,
127 X_Base_Quantity In Number,
128 X_Base_Unit_Of_Measure In Varchar2,
129 X_Orig_Revenue In Number,
130 X_Orig_Raw_Cost In Number,
131 X_Orig_Burdened_Cost In Number,
132 X_Orig_Labor_Hours In Number,
133 X_Orig_Quantity In Number,
134 X_Orig_Unit_Of_Measure In Varchar2,
135 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
136 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
137 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
138 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
139
140
141 Procedure Process_it_yt_pp_res_bud
142 (x_project_id In Number,
143 x_task_id In Number,
144 x_resource_list_id in Number,
145 x_resource_list_Member_id in Number,
146 x_resource_id in Number,
147 x_resource_list_assignment_id in Number,
148 x_rollup_qty_flag In Varchar2,
149 x_budget_type_code In Varchar2,
150 x_current_period In Varchar2,
151 X_Base_Revenue In Number,
152 X_Base_Raw_Cost In Number,
153 X_Base_Burdened_Cost In Number,
154 X_Base_Labor_Hours In Number,
155 X_Base_Quantity In Number,
156 X_Base_Unit_Of_Measure In Varchar2,
157 X_Orig_Revenue In Number,
158 X_Orig_Raw_Cost In Number,
159 X_Orig_Burdened_Cost In Number,
160 X_Orig_Labor_Hours In Number,
161 X_Orig_Quantity In Number,
162 X_Orig_Unit_Of_Measure In Varchar2,
163 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
164 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
165 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
166 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
167
168
169 Procedure Process_it_pp_res_bud
170 (x_project_id In Number,
171 x_task_id In Number,
172 x_resource_list_id in Number,
173 x_resource_list_Member_id in Number,
174 x_resource_id in Number,
175 x_resource_list_assignment_id in Number,
176 x_rollup_qty_flag In Varchar2,
177 x_budget_type_code In Varchar2,
178 x_current_period In Varchar2,
179 X_Base_Revenue In Number,
180 X_Base_Raw_Cost In Number,
181 X_Base_Burdened_Cost In Number,
182 X_Base_Labor_Hours In Number,
183 X_Base_Quantity In Number,
184 X_Base_Unit_Of_Measure In Varchar2,
185 X_Orig_Revenue In Number,
186 X_Orig_Raw_Cost In Number,
187 X_Orig_Burdened_Cost In Number,
188 X_Orig_Labor_Hours In Number,
189 X_Orig_Quantity In Number,
190 X_Orig_Unit_Of_Measure In Varchar2,
191 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
192 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
193 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
194 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
195
196
197 Procedure Process_it_yt_res_bud
198 (x_project_id In Number,
199 x_task_id In Number,
200 x_resource_list_id in Number,
201 x_resource_list_Member_id in Number,
202 x_resource_id in Number,
203 x_resource_list_assignment_id in Number,
204 x_rollup_qty_flag In Varchar2,
205 x_budget_type_code In Varchar2,
206 x_current_period In Varchar2,
207 X_Base_Revenue In Number,
208 X_Base_Raw_Cost In Number,
209 X_Base_Burdened_Cost In Number,
210 X_Base_Labor_Hours In Number,
211 X_Base_Quantity In Number,
212 X_Base_Unit_Of_Measure In Varchar2,
213 X_Orig_Revenue In Number,
214 X_Orig_Raw_Cost In Number,
215 X_Orig_Burdened_Cost In Number,
216 X_Orig_Labor_Hours In Number,
217 X_Orig_Quantity In Number,
218 X_Orig_Unit_Of_Measure In Varchar2,
219 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
220 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
221 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
222 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
223
224
225 Procedure Process_it_res_bud
226 (x_project_id In Number,
227 x_task_id In Number,
228 x_resource_list_id in Number,
229 x_resource_list_Member_id in Number,
230 x_resource_id in Number,
231 x_resource_list_assignment_id in Number,
232 x_rollup_qty_flag In Varchar2,
233 x_budget_type_code In Varchar2,
234 x_current_period In Varchar2,
235 X_Base_Revenue In Number,
236 X_Base_Raw_Cost In Number,
237 X_Base_Burdened_Cost In Number,
238 X_Base_Labor_Hours In Number,
239 X_Base_Quantity In Number,
240 X_Base_Unit_Of_Measure In Varchar2,
241 X_Orig_Revenue In Number,
242 X_Orig_Raw_Cost In Number,
243 X_Orig_Burdened_Cost In Number,
244 X_Orig_Labor_Hours In Number,
245 X_Orig_Quantity In Number,
246 X_Orig_Unit_Of_Measure In Varchar2,
247 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
248 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
249 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
250 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
251
252
253 END;