[Home] [Help]
PACKAGE: APPS.PA_ACCUM_SRW
Source
1 PACKAGE PA_ACCUM_SRW AS
2 /* $Header: PAACSRWS.pls 120.1 2005/08/19 16:14:30 mwasowic noship $ */
3
4 -- Standard who
5 x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6 x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
7 x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8 x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9 x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10 x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
11 x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
12
13 TYPE numbertabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
14 TYPE periodtabtype IS TABLE OF pa_project_accum_headers.accum_period%TYPE
15 INDEX BY BINARY_INTEGER;
16 TYPE budgettypetabtype IS TABLE OF pa_project_accum_budgets.budget_type_code%TYPE
17 INDEX BY BINARY_INTEGER;
18
19 number_of_projects BINARY_INTEGER :=0;
20
21 FUNCTION get_number_of_projects RETURN NUMBER;
22
23 -- define a PL/SQL table for each project to report for
24
25 PROJECT_ID numbertabtype;
26
27 -- Define a PL/SQL table for Each Number you want to report
28 -- variables to hold the numbers before the processing is done
29
30 ACCUM_PERIOD_PRE periodtabtype;
31
32 RAW_COST_ITD_PRE numbertabtype;
33 RAW_COST_YTD_PRE numbertabtype;
34 RAW_COST_PP_PRE numbertabtype;
35 RAW_COST_PTD_PRE numbertabtype;
36 BILLABLE_RAW_COST_ITD_PRE numbertabtype;
37 BILLABLE_RAW_COST_YTD_PRE numbertabtype;
38 BILLABLE_RAW_COST_PP_PRE numbertabtype;
39 BILLABLE_RAW_COST_PTD_PRE numbertabtype;
40 BURDENED_COST_ITD_PRE numbertabtype;
41 BURDENED_COST_YTD_PRE numbertabtype;
42 BURDENED_COST_PP_PRE numbertabtype;
43 BURDENED_COST_PTD_PRE numbertabtype;
44 BILLABLE_BURDENED_COST_ITD_PRE numbertabtype;
45 BILLABLE_BURDENED_COST_YTD_PRE numbertabtype;
46 BILLABLE_BURDENED_COST_PP_PRE numbertabtype;
47 BILLABLE_BURDENED_COST_PTD_PRE numbertabtype;
48 QUANTITY_ITD_PRE numbertabtype;
49 QUANTITY_YTD_PRE numbertabtype;
50 QUANTITY_PP_PRE numbertabtype;
51 QUANTITY_PTD_PRE numbertabtype;
52 LABOR_HOURS_ITD_PRE numbertabtype;
53 LABOR_HOURS_YTD_PRE numbertabtype;
54 LABOR_HOURS_PP_PRE numbertabtype;
55 LABOR_HOURS_PTD_PRE numbertabtype;
56 BILLABLE_QUANTITY_ITD_PRE numbertabtype;
57 BILLABLE_QUANTITY_YTD_PRE numbertabtype;
58 BILLABLE_QUANTITY_PP_PRE numbertabtype;
59 BILLABLE_QUANTITY_PTD_PRE numbertabtype;
60 BILLABLE_LABOR_HOURS_ITD_PRE numbertabtype;
61 BILLABLE_LABOR_HOURS_YTD_PRE numbertabtype;
62 BILLABLE_LABOR_HOURS_PP_PRE numbertabtype;
63 BILLABLE_LABOR_HOURS_PTD_PRE numbertabtype;
64 REVENUE_ITD_PRE numbertabtype;
65 REVENUE_YTD_PRE numbertabtype;
66 REVENUE_PP_PRE numbertabtype;
67 REVENUE_PTD_PRE numbertabtype;
68
69 -- Commitment figures
70
71 CMT_RAW_COST_ITD_PRE numbertabtype;
72 CMT_RAW_COST_YTD_PRE numbertabtype;
73 CMT_RAW_COST_PP_PRE numbertabtype;
74 CMT_RAW_COST_PTD_PRE numbertabtype;
75 CMT_BURDENED_COST_ITD_PRE numbertabtype;
76 CMT_BURDENED_COST_YTD_PRE numbertabtype;
77 CMT_BURDENED_COST_PP_PRE numbertabtype;
78 CMT_BURDENED_COST_PTD_PRE numbertabtype;
79 CMT_QUANTITY_ITD_PRE numbertabtype;
80 CMT_QUANTITY_YTD_PRE numbertabtype;
81 CMT_QUANTITY_PP_PRE numbertabtype;
82 CMT_QUANTITY_PTD_PRE numbertabtype;
83
84 -- Post processing figures
85
86 ACCUM_PERIOD_PST periodtabtype;
87
88 RAW_COST_ITD_PST numbertabtype;
89 RAW_COST_YTD_PST numbertabtype;
90 RAW_COST_PP_PST numbertabtype;
91 RAW_COST_PTD_PST numbertabtype;
92 BILLABLE_RAW_COST_ITD_PST numbertabtype;
93 BILLABLE_RAW_COST_YTD_PST numbertabtype;
94 BILLABLE_RAW_COST_PP_PST numbertabtype;
95 BILLABLE_RAW_COST_PTD_PST numbertabtype;
96 BURDENED_COST_ITD_PST numbertabtype;
97 BURDENED_COST_YTD_PST numbertabtype;
98 BURDENED_COST_PP_PST numbertabtype;
99 BURDENED_COST_PTD_PST numbertabtype;
100 BILLABLE_BURDENED_COST_ITD_PST numbertabtype;
101 BILLABLE_BURDENED_COST_YTD_PST numbertabtype;
102 BILLABLE_BURDENED_COST_PP_PST numbertabtype;
103 BILLABLE_BURDENED_COST_PTD_PST numbertabtype;
104 QUANTITY_ITD_PST numbertabtype;
105 QUANTITY_YTD_PST numbertabtype;
106 QUANTITY_PP_PST numbertabtype;
107 QUANTITY_PTD_PST numbertabtype;
108 LABOR_HOURS_ITD_PST numbertabtype;
109 LABOR_HOURS_YTD_PST numbertabtype;
110 LABOR_HOURS_PP_PST numbertabtype;
111 LABOR_HOURS_PTD_PST numbertabtype;
112 BILLABLE_QUANTITY_ITD_PST numbertabtype;
113 BILLABLE_QUANTITY_YTD_PST numbertabtype;
114 BILLABLE_QUANTITY_PP_PST numbertabtype;
115 BILLABLE_QUANTITY_PTD_PST numbertabtype;
116 BILLABLE_LABOR_HOURS_ITD_PST numbertabtype;
117 BILLABLE_LABOR_HOURS_YTD_PST numbertabtype;
118 BILLABLE_LABOR_HOURS_PP_PST numbertabtype;
119 BILLABLE_LABOR_HOURS_PTD_PST numbertabtype;
120 REVENUE_ITD_PST numbertabtype;
121 REVENUE_YTD_PST numbertabtype;
122 REVENUE_PP_PST numbertabtype;
123 REVENUE_PTD_PST numbertabtype;
124
125 -- Commitment figures
126
127 CMT_RAW_COST_ITD_PST numbertabtype;
128 CMT_RAW_COST_YTD_PST numbertabtype;
129 CMT_RAW_COST_PP_PST numbertabtype;
130 CMT_RAW_COST_PTD_PST numbertabtype;
131 CMT_BURDENED_COST_ITD_PST numbertabtype;
132 CMT_BURDENED_COST_YTD_PST numbertabtype;
133 CMT_BURDENED_COST_PP_PST numbertabtype;
134 CMT_BURDENED_COST_PTD_PST numbertabtype;
135 CMT_QUANTITY_ITD_PST numbertabtype;
136 CMT_QUANTITY_YTD_PST numbertabtype;
137 CMT_QUANTITY_PP_PST numbertabtype;
138 CMT_QUANTITY_PTD_PST numbertabtype;
139
140 -- Budgets figure. Please note that there may be more
141 -- than one budget for each project
142
143 -- figures before processing
144
145 number_of_budgets_pre BINARY_INTEGER := 0; -- Number of budgets found before accumlation
146 FUNCTION get_number_of_budgets_pre RETURN NUMBER; -- Number of budgets accumulated before processing
147
148 PROJECT_ID_PRE numbertabtype;
149 BUDGET_TYPE_CODE_PRE budgettypetabtype;
150
151 BASE_RAW_COST_ITD_PRE numbertabtype;
152 BASE_RAW_COST_YTD_PRE numbertabtype;
153 BASE_RAW_COST_PP_PRE numbertabtype;
154 BASE_RAW_COST_PTD_PRE numbertabtype;
155 BASE_BURDENED_COST_ITD_PRE numbertabtype;
156 BASE_BURDENED_COST_YTD_PRE numbertabtype;
157 BASE_BURDENED_COST_PP_PRE numbertabtype;
158 BASE_BURDENED_COST_PTD_PRE numbertabtype;
159 ORIG_RAW_COST_ITD_PRE numbertabtype;
160 ORIG_RAW_COST_YTD_PRE numbertabtype;
161 ORIG_RAW_COST_PP_PRE numbertabtype;
162 ORIG_RAW_COST_PTD_PRE numbertabtype;
163 ORIG_BURDENED_COST_ITD_PRE numbertabtype;
164 ORIG_BURDENED_COST_YTD_PRE numbertabtype;
165 ORIG_BURDENED_COST_PP_PRE numbertabtype;
166 ORIG_BURDENED_COST_PTD_PRE numbertabtype;
167 BASE_REVENUE_ITD_PRE numbertabtype;
168 BASE_REVENUE_YTD_PRE numbertabtype;
169 BASE_REVENUE_PP_PRE numbertabtype;
170 BASE_REVENUE_PTD_PRE numbertabtype;
171 ORIG_REVENUE_ITD_PRE numbertabtype;
172 ORIG_REVENUE_YTD_PRE numbertabtype;
173 ORIG_REVENUE_PP_PRE numbertabtype;
174 ORIG_REVENUE_PTD_PRE numbertabtype;
175 ORIG_LABOR_HOURS_ITD_PRE numbertabtype;
176 ORIG_LABOR_HOURS_YTD_PRE numbertabtype;
177 ORIG_LABOR_HOURS_PP_PRE numbertabtype;
178 ORIG_LABOR_HOURS_PTD_PRE numbertabtype;
179 BASE_LABOR_HOURS_ITD_PRE numbertabtype;
180 BASE_LABOR_HOURS_YTD_PRE numbertabtype;
181 BASE_LABOR_HOURS_PP_PRE numbertabtype;
182 BASE_LABOR_HOURS_PTD_PRE numbertabtype;
183 ORIG_QUANTITY_YTD_PRE numbertabtype;
184 ORIG_QUANTITY_ITD_PRE numbertabtype;
185 ORIG_QUANTITY_PP_PRE numbertabtype;
186 ORIG_QUANTITY_PTD_PRE numbertabtype;
187 BASE_QUANTITY_YTD_PRE numbertabtype;
188 BASE_QUANTITY_ITD_PRE numbertabtype;
189 BASE_QUANTITY_PP_PRE numbertabtype;
190 BASE_QUANTITY_PTD_PRE numbertabtype;
191 ORIG_LABOR_HOURS_TOT_PRE numbertabtype;
192 BASE_LABOR_HOURS_TOT_PRE numbertabtype;
193 ORIG_QUANTITY_TOT_PRE numbertabtype;
194 BASE_QUANTITY_TOT_PRE numbertabtype;
195 BASE_RAW_COST_TOT_PRE numbertabtype;
196 BASE_BURDENED_COST_TOT_PRE numbertabtype;
197 ORIG_RAW_COST_TOT_PRE numbertabtype;
198 ORIG_BURDENED_COST_TOT_PRE numbertabtype;
199 BASE_REVENUE_TOT_PRE numbertabtype;
200 ORIG_REVENUE_TOT_PRE numbertabtype;
201
202 --Figures after processing is done
203
204 number_of_budgets_pst BINARY_INTEGER := 0; -- Number of budgets found after accumlation
205 FUNCTION get_number_of_budgets_pst RETURN NUMBER; -- Number of budgets accumulated after processing
206
207 PROJECT_ID_PST numbertabtype;
208 BUDGET_TYPE_CODE_PST budgettypetabtype;
209
210 BASE_RAW_COST_ITD_PST numbertabtype;
211 BASE_RAW_COST_YTD_PST numbertabtype;
212 BASE_RAW_COST_PP_PST numbertabtype;
213 BASE_RAW_COST_PTD_PST numbertabtype;
214 BASE_BURDENED_COST_ITD_PST numbertabtype;
215 BASE_BURDENED_COST_YTD_PST numbertabtype;
216 BASE_BURDENED_COST_PP_PST numbertabtype;
217 BASE_BURDENED_COST_PTD_PST numbertabtype;
218 ORIG_RAW_COST_ITD_PST numbertabtype;
219 ORIG_RAW_COST_YTD_PST numbertabtype;
220 ORIG_RAW_COST_PP_PST numbertabtype;
221 ORIG_RAW_COST_PTD_PST numbertabtype;
222 ORIG_BURDENED_COST_ITD_PST numbertabtype;
223 ORIG_BURDENED_COST_YTD_PST numbertabtype;
224 ORIG_BURDENED_COST_PP_PST numbertabtype;
225 ORIG_BURDENED_COST_PTD_PST numbertabtype;
226 BASE_REVENUE_ITD_PST numbertabtype;
227 BASE_REVENUE_YTD_PST numbertabtype;
228 BASE_REVENUE_PP_PST numbertabtype;
229 BASE_REVENUE_PTD_PST numbertabtype;
230 ORIG_REVENUE_ITD_PST numbertabtype;
231 ORIG_REVENUE_YTD_PST numbertabtype;
232 ORIG_REVENUE_PP_PST numbertabtype;
233 ORIG_REVENUE_PTD_PST numbertabtype;
234 ORIG_LABOR_HOURS_ITD_PST numbertabtype;
235 ORIG_LABOR_HOURS_YTD_PST numbertabtype;
236 ORIG_LABOR_HOURS_PP_PST numbertabtype;
237 ORIG_LABOR_HOURS_PTD_PST numbertabtype;
238 BASE_LABOR_HOURS_ITD_PST numbertabtype;
239 BASE_LABOR_HOURS_YTD_PST numbertabtype;
240 BASE_LABOR_HOURS_PP_PST numbertabtype;
241 BASE_LABOR_HOURS_PTD_PST numbertabtype;
242 ORIG_QUANTITY_YTD_PST numbertabtype;
243 ORIG_QUANTITY_ITD_PST numbertabtype;
244 ORIG_QUANTITY_PP_PST numbertabtype;
245 ORIG_QUANTITY_PTD_PST numbertabtype;
246 BASE_QUANTITY_YTD_PST numbertabtype;
247 BASE_QUANTITY_ITD_PST numbertabtype;
248 BASE_QUANTITY_PP_PST numbertabtype;
249 BASE_QUANTITY_PTD_PST numbertabtype;
250 ORIG_LABOR_HOURS_TOT_PST numbertabtype;
251 BASE_LABOR_HOURS_TOT_PST numbertabtype;
252 ORIG_QUANTITY_TOT_PST numbertabtype;
253 BASE_QUANTITY_TOT_PST numbertabtype;
254 BASE_RAW_COST_TOT_PST numbertabtype;
255 BASE_BURDENED_COST_TOT_PST numbertabtype;
256 ORIG_RAW_COST_TOT_PST numbertabtype;
257 ORIG_BURDENED_COST_TOT_PST numbertabtype;
258 BASE_REVENUE_TOT_PST numbertabtype;
259 ORIG_REVENUE_TOT_PST numbertabtype;
260
261 -- TXNS accumulation number
262
263 -- Pre processing numbers
264
265 TXN_RAW_COST_PRE numbertabtype;
266 TXN_BILLABLE_RAW_COST_PRE numbertabtype;
267 TXN_BURDENED_COST_PRE numbertabtype;
268 TXN_BILLABLE_BURDENED_COST_PRE numbertabtype;
269 TXN_QUANTITY_PRE numbertabtype;
270 TXN_LABOR_HOURS_PRE numbertabtype;
271 TXN_BILLABLE_QUANTITY_PRE numbertabtype;
272 TXN_BILLABLE_LABOR_HOURS_PRE numbertabtype;
273 TXN_REVENUE_PRE numbertabtype;
274
275 -- Post processing numbers
276
277 TXN_RAW_COST_PST numbertabtype;
278 TXN_BILLABLE_RAW_COST_PST numbertabtype;
279 TXN_BURDENED_COST_PST numbertabtype;
280 TXN_BILLABLE_BURDENED_COST_PST numbertabtype;
281 TXN_QUANTITY_PST numbertabtype;
282 TXN_LABOR_HOURS_PST numbertabtype;
283 TXN_BILLABLE_QUANTITY_PST numbertabtype;
284 TXN_BILLABLE_LABOR_HOURS_PST numbertabtype;
285 TXN_REVENUE_PST numbertabtype;
286
287 PROCEDURE get_project_summary_numbers
288 (X_PROJECT_ACCUM_ID IN NUMBER,
289 X_PRE_POST_FLAG IN VARCHAR2,
290 X_TABLE_INDEX IN NUMBER,
291 X_ERR_STACK IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
292 X_ERR_STAGE IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
293 X_ERR_CODE IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
294
295 PROCEDURE report_project_summary_numbers
296 (X_TABLE_INDEX IN NUMBER,
297 X_PROJECT_ID OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
298 X_ACCUM_PERIOD_B OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
299 X_RAW_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
300 X_RAW_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
301 X_RAW_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
302 X_RAW_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
303 X_BILLABLE_RAW_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
304 X_BILLABLE_RAW_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
305 X_BILLABLE_RAW_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
306 X_BILLABLE_RAW_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
307 X_BURDENED_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
308 X_BURDENED_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
309 X_BURDENED_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
310 X_BURDENED_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
311 X_BILLABLE_BURDENED_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
312 X_BILLABLE_BURDENED_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
313 X_BILLABLE_BURDENED_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
314 X_BILLABLE_BURDENED_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
315 X_QUANTITY_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
316 X_QUANTITY_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
317 X_QUANTITY_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
318 X_QUANTITY_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
319 X_LABOR_HOURS_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
320 X_LABOR_HOURS_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
321 X_LABOR_HOURS_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
322 X_LABOR_HOURS_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
326 X_BILLABLE_QUANTITY_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
323 X_BILLABLE_QUANTITY_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
324 X_BILLABLE_QUANTITY_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
325 X_BILLABLE_QUANTITY_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
327 X_BILLABLE_LABOR_HOURS_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
328 X_BILLABLE_LABOR_HOURS_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
329 X_BILLABLE_LABOR_HOURS_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
330 X_BILLABLE_LABOR_HOURS_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
331 X_REVENUE_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
332 X_REVENUE_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
333 X_REVENUE_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
334 X_REVENUE_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
335 X_CMT_RAW_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
336 X_CMT_RAW_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
337 X_CMT_RAW_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
338 X_CMT_RAW_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
339 X_CMT_BURDENED_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
340 X_CMT_BURDENED_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
341 X_CMT_BURDENED_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
342 X_CMT_BURDENED_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
343 X_CMT_QUANTITY_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
344 X_CMT_QUANTITY_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
345 X_CMT_QUANTITY_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
346 X_CMT_QUANTITY_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
347 X_ACCUM_PERIOD_A OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
348 X_RAW_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
349 X_RAW_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
350 X_RAW_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
351 X_RAW_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
352 X_BILLABLE_RAW_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
353 X_BILLABLE_RAW_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
354 X_BILLABLE_RAW_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
355 X_BILLABLE_RAW_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
356 X_BURDENED_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
357 X_BURDENED_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
358 X_BURDENED_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
359 X_BURDENED_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
360 X_BILLABLE_BURDENED_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
361 X_BILLABLE_BURDENED_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
362 X_BILLABLE_BURDENED_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
363 X_BILLABLE_BURDENED_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
364 X_QUANTITY_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
365 X_QUANTITY_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
366 X_QUANTITY_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
367 X_QUANTITY_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
368 X_LABOR_HOURS_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
369 X_LABOR_HOURS_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
370 X_LABOR_HOURS_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
371 X_LABOR_HOURS_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
372 X_BILLABLE_QUANTITY_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
373 X_BILLABLE_QUANTITY_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
374 X_BILLABLE_QUANTITY_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
375 X_BILLABLE_QUANTITY_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
376 X_BILLABLE_LABOR_HOURS_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
377 X_BILLABLE_LABOR_HOURS_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
378 X_BILLABLE_LABOR_HOURS_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
379 X_BILLABLE_LABOR_HOURS_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
380 X_REVENUE_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
381 X_REVENUE_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
382 X_REVENUE_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
383 X_REVENUE_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
384 X_CMT_RAW_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
385 X_CMT_RAW_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
386 X_CMT_RAW_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
390 X_CMT_BURDENED_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
387 X_CMT_RAW_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
388 X_CMT_BURDENED_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
389 X_CMT_BURDENED_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
391 X_CMT_BURDENED_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
392 X_CMT_QUANTITY_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
393 X_CMT_QUANTITY_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
394 X_CMT_QUANTITY_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
395 X_CMT_QUANTITY_PTD_A OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
396
397 PROCEDURE get_project_budget_numbers
398 (X_PROJECT_ACCUM_ID IN NUMBER,
399 X_PRE_POST_FLAG IN VARCHAR2,
400 X_ERR_STACK IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
401 X_ERR_STAGE IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
402 X_ERR_CODE IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
403
404 PROCEDURE report_project_budget_numbers
405 (X_TABLE_INDEX IN NUMBER,
406 X_PROJECT_ID OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
407 X_BUDGET_TYPE_CODE OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
408 X_BASE_RAW_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
409 X_BASE_RAW_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
410 X_BASE_RAW_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
411 X_BASE_RAW_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
412 X_BASE_BURDENED_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
413 X_BASE_BURDENED_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
414 X_BASE_BURDENED_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
415 X_BASE_BURDENED_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
416 X_ORIG_RAW_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
417 X_ORIG_RAW_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
418 X_ORIG_RAW_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
419 X_ORIG_RAW_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
420 X_ORIG_BURDENED_COST_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
421 X_ORIG_BURDENED_COST_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
422 X_ORIG_BURDENED_COST_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
423 X_ORIG_BURDENED_COST_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
424 X_BASE_REVENUE_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
425 X_BASE_REVENUE_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
426 X_BASE_REVENUE_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
427 X_BASE_REVENUE_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
428 X_ORIG_REVENUE_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
432 X_ORIG_LABOR_HOURS_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
429 X_ORIG_REVENUE_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
430 X_ORIG_REVENUE_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
431 X_ORIG_REVENUE_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
433 X_ORIG_LABOR_HOURS_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
434 X_ORIG_LABOR_HOURS_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
435 X_ORIG_LABOR_HOURS_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
436 X_BASE_LABOR_HOURS_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
437 X_BASE_LABOR_HOURS_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
438 X_BASE_LABOR_HOURS_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
439 X_BASE_LABOR_HOURS_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
440 X_ORIG_QUANTITY_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
441 X_ORIG_QUANTITY_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
442 X_ORIG_QUANTITY_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
443 X_ORIG_QUANTITY_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
444 X_BASE_QUANTITY_YTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
445 X_BASE_QUANTITY_ITD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
446 X_BASE_QUANTITY_PP_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
447 X_BASE_QUANTITY_PTD_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
448 X_ORIG_LABOR_HOURS_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
449 X_BASE_LABOR_HOURS_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
450 X_ORIG_QUANTITY_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
451 X_BASE_QUANTITY_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
452 X_BASE_RAW_COST_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
453 X_BASE_BURDENED_COST_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
454 X_ORIG_RAW_COST_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
455 X_ORIG_BURDENED_COST_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
456 X_BASE_REVENUE_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
457 X_ORIG_REVENUE_TOT_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
458 X_BASE_RAW_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
459 X_BASE_RAW_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
460 X_BASE_RAW_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
461 X_BASE_RAW_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
462 X_BASE_BURDENED_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
463 X_BASE_BURDENED_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
464 X_BASE_BURDENED_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
465 X_BASE_BURDENED_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
466 X_ORIG_RAW_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
467 X_ORIG_RAW_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
468 X_ORIG_RAW_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
469 X_ORIG_RAW_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
470 X_ORIG_BURDENED_COST_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
471 X_ORIG_BURDENED_COST_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
472 X_ORIG_BURDENED_COST_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
473 X_ORIG_BURDENED_COST_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
474 X_BASE_REVENUE_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
475 X_BASE_REVENUE_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
476 X_BASE_REVENUE_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
477 X_BASE_REVENUE_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
478 X_ORIG_REVENUE_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
479 X_ORIG_REVENUE_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
480 X_ORIG_REVENUE_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
481 X_ORIG_REVENUE_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
482 X_ORIG_LABOR_HOURS_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
483 X_ORIG_LABOR_HOURS_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
484 X_ORIG_LABOR_HOURS_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
485 X_ORIG_LABOR_HOURS_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
486 X_BASE_LABOR_HOURS_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
487 X_BASE_LABOR_HOURS_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
488 X_BASE_LABOR_HOURS_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
489 X_BASE_LABOR_HOURS_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
490 X_ORIG_QUANTITY_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
491 X_ORIG_QUANTITY_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
492 X_ORIG_QUANTITY_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
493 X_ORIG_QUANTITY_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
494 X_BASE_QUANTITY_YTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
495 X_BASE_QUANTITY_ITD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
496 X_BASE_QUANTITY_PP_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
497 X_BASE_QUANTITY_PTD_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
498 X_ORIG_LABOR_HOURS_TOT_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
499 X_BASE_LABOR_HOURS_TOT_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
500 X_ORIG_QUANTITY_TOT_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
501 X_BASE_QUANTITY_TOT_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
502 X_BASE_RAW_COST_TOT_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
503 X_BASE_BURDENED_COST_TOT_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
504 X_ORIG_RAW_COST_TOT_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
505 X_ORIG_BURDENED_COST_TOT_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
506 X_BASE_REVENUE_TOT_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
507 X_ORIG_REVENUE_TOT_A OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
508 );
509
510 PROCEDURE get_project_txn_numbers
511 (X_PROJECT_ID IN NUMBER,
512 X_PRE_POST_FLAG IN VARCHAR2,
513 X_TABLE_INDEX IN NUMBER,
514 X_ERR_STACK IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
515 X_ERR_STAGE IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
516 X_ERR_CODE IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
517
518 PROCEDURE report_project_txn_numbers
519 (X_TABLE_INDEX IN NUMBER,
520 X_PROJECT_ID OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
521 X_RAW_COST_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
522 X_BILLABLE_RAW_COST_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
523 X_BURDENED_COST_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
524 X_BILLABLE_BURDENED_COST_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
525 X_QUANTITY_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
526 X_LABOR_HOURS_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
527 X_BILLABLE_QUANTITY_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
528 X_BILLABLE_LABOR_HOURS_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
529 X_REVENUE_B OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
530 X_RAW_COST_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
531 X_BILLABLE_RAW_COST_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
532 X_BURDENED_COST_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
533 X_BILLABLE_BURDENED_COST_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
534 X_QUANTITY_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
535 X_LABOR_HOURS_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
536 X_BILLABLE_QUANTITY_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
537 X_BILLABLE_LABOR_HOURS_A OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
538 X_REVENUE_A OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
539
540 END PA_ACCUM_SRW;