1 PACKAGE Pji_Rep_Measure_Util AS
2 /* $Header: PJIRX15S.pls 120.4 2006/03/02 12:28:20 appldev noship $ */
3
4 PROCEDURE Compute_Proj_Perf_Exceptions
5 (
6 p_commit_flag IN VARCHAR2
7 , x_msg_count OUT NOCOPY NUMBER
8 , x_msg_data OUT NOCOPY VARCHAR2
9 , x_return_status OUT NOCOPY VARCHAR2
10 );
11
12 PROCEDURE Get_Measure_Labels
13 (
14 p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
15 , p_measure_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
16 , x_return_status OUT NOCOPY VARCHAR2
17 , x_msg_count OUT NOCOPY NUMBER
18 , x_msg_data OUT NOCOPY VARCHAR2
19 );
20
21 PROCEDURE Get_Measure_Attributes
22 (
23 p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
24 , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
25 , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
26 , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
27 , x_return_status OUT NOCOPY VARCHAR2
28 , x_msg_count OUT NOCOPY NUMBER
29 , x_msg_data OUT NOCOPY VARCHAR2 -- not used
30 );
31
32 PROCEDURE Get_Financial_Measures
33 (
34 p_project_id NUMBER
35 , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
36 , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
37 , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
38 , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
39 , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
40 , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
41 --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- remove
42 , x_return_status OUT NOCOPY VARCHAR2
43 , x_msg_count OUT NOCOPY NUMBER
44 , x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE Get_Activity_Measures
48 (
49 p_project_id NUMBER
50 , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
51 , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
52 , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
53 , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
54 , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
55 , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
56 -- , x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- remove
57 , x_return_status OUT NOCOPY VARCHAR2
58 , x_msg_count OUT NOCOPY NUMBER
59 , x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62
63 g_ptd_record_type NUMBER := 256; --Record type for Period to Date
64 g_qtd_record_type NUMBER := 288; --Record type for Quarter to Date
65 g_ytd_record_type NUMBER := 352; --Record type for Year to Date
66 g_itd_record_type NUMBER := 1376; --Record type for Inception to Date
67
68 TYPE prf_over_time_amounts_rec IS RECORD(
69 ptd NUMBER
70 ,qtd NUMBER
71 ,ytd NUMBER
72 ,itd NUMBER
73 ,ac NUMBER
74 ,prp NUMBER
75 );
76
77
78 TYPE pji_ac_proj_f_rec IS RECORD (
79 ptd_active_backlog NUMBER
80 , ptd_additional_funding_amount NUMBER
81 , ptd_ar_cash_applied_amount NUMBER
82 , ptd_ar_credit_memo_amount NUMBER
83 , ptd_ar_invoice_amount NUMBER
84 , ptd_ar_invoice_writeoff_amount NUMBER
85 , ptd_ar_invoice_count NUMBER
86 , ptd_ar_amount_due NUMBER
87 , ptd_ar_amount_overdue NUMBER
88 , ptd_cancelled_funding_amount NUMBER
89 , ptd_dormant_backlog_inactiv NUMBER
90 , ptd_dormant_backlog_start NUMBER
91 , ptd_funding_adjustment_amount NUMBER
92 , ptd_initial_funding_amount NUMBER
93 , ptd_lost_backlog NUMBER
94 , ptd_revenue NUMBER
95 , ptd_revenue_at_risk NUMBER
96 , ptd_revenue_writeoff NUMBER
97 , ptd_unbilled_receivables NUMBER
98 , ptd_unearned_revenue NUMBER
99 , qtd_active_backlog NUMBER
100 , qtd_additional_funding_amount NUMBER
101 , qtd_ar_cash_applied_amount NUMBER
102 , qtd_ar_credit_memo_amount NUMBER
103 , qtd_ar_invoice_amount NUMBER
104 , qtd_ar_invoice_writeoff_amount NUMBER
105 , qtd_ar_invoice_count NUMBER
106 , qtd_ar_amount_due NUMBER
107 , qtd_ar_amount_overdue NUMBER
108 , qtd_cancelled_funding_amount NUMBER
109 , qtd_dormant_backlog_inactiv NUMBER
110 , qtd_dormant_backlog_start NUMBER
111 , qtd_funding_adjustment_amount NUMBER
112 , qtd_initial_funding_amount NUMBER
113 , qtd_lost_backlog NUMBER
114 , qtd_revenue NUMBER
115 , qtd_revenue_at_risk NUMBER
116 , qtd_revenue_writeoff NUMBER
117 , qtd_unbilled_receivables NUMBER
118 , qtd_unearned_revenue NUMBER
119 , ytd_active_backlog NUMBER
120 , ytd_additional_funding_amount NUMBER
121 , ytd_ar_cash_applied_amount NUMBER
122 , ytd_ar_credit_memo_amount NUMBER
123 , ytd_ar_invoice_amount NUMBER
124 , ytd_ar_invoice_writeoff_amount NUMBER
125 , ytd_ar_invoice_count NUMBER
126 , ytd_ar_amount_due NUMBER
127 , ytd_ar_amount_overdue NUMBER
128 , ytd_cancelled_funding_amount NUMBER
129 , ytd_dormant_backlog_inactiv NUMBER
130 , ytd_dormant_backlog_start NUMBER
131 , ytd_funding_adjustment_amount NUMBER
132 , ytd_initial_funding_amount NUMBER
133 , ytd_lost_backlog NUMBER
134 , ytd_revenue NUMBER
135 , ytd_revenue_at_risk NUMBER
136 , ytd_revenue_writeoff NUMBER
137 , ytd_unbilled_receivables NUMBER
138 , ytd_unearned_revenue NUMBER
139 , itd_active_backlog NUMBER
140 , itd_additional_funding_amount NUMBER
141 , itd_ar_cash_applied_amount NUMBER
142 , itd_ar_credit_memo_amount NUMBER
143 , itd_ar_invoice_amount NUMBER
144 , itd_ar_invoice_writeoff_amount NUMBER
145 , itd_ar_invoice_count NUMBER
146 , itd_ar_amount_due NUMBER
147 , itd_ar_amount_overdue NUMBER
148 , itd_cancelled_funding_amount NUMBER
149 , itd_dormant_backlog_inactiv NUMBER
150 , itd_dormant_backlog_start NUMBER
151 , itd_funding_adjustment_amount NUMBER
152 , itd_initial_funding_amount NUMBER
153 , itd_lost_backlog NUMBER
154 , itd_revenue NUMBER
155 , itd_revenue_at_risk NUMBER
156 , itd_revenue_writeoff NUMBER
157 , itd_unbilled_receivables NUMBER
158 , itd_unearned_revenue NUMBER
159 , ac_active_backlog NUMBER
160 , ac_additional_funding_amount NUMBER
161 , ac_ar_cash_applied_amount NUMBER
162 , ac_ar_credit_memo_amount NUMBER
163 , ac_ar_invoice_amount NUMBER
164 , ac_ar_invoice_writeoff_amount NUMBER
165 , ac_ar_invoice_count NUMBER
166 , ac_ar_amount_due NUMBER
167 , ac_ar_amount_overdue NUMBER
168 , ac_cancelled_funding_amount NUMBER
169 , ac_dormant_backlog_inactiv NUMBER
170 , ac_dormant_backlog_start NUMBER
171 , ac_funding_adjustment_amount NUMBER
172 , ac_initial_funding_amount NUMBER
173 , ac_lost_backlog NUMBER
174 , ac_revenue NUMBER
175 , ac_revenue_at_risk NUMBER
176 , ac_revenue_writeoff NUMBER
177 , ac_unbilled_receivables NUMBER
178 , ac_unearned_revenue NUMBER
179 , prp_active_backlog NUMBER
180 , prp_additional_funding_amount NUMBER
181 , prp_ar_cash_applied_amount NUMBER
182 , prp_ar_credit_memo_amount NUMBER
183 , prp_ar_invoice_amount NUMBER
184 , prp_ar_invoice_writeoff_amount NUMBER
185 , prp_ar_invoice_count NUMBER
186 , prp_ar_amount_due NUMBER
187 , prp_ar_amount_overdue NUMBER
188 , prp_cancelled_funding_amount NUMBER
189 , prp_dormant_backlog_inactiv NUMBER
190 , prp_dormant_backlog_start NUMBER
191 , prp_funding_adjustment_amount NUMBER
192 , prp_initial_funding_amount NUMBER
193 , prp_lost_backlog NUMBER
194 , prp_revenue NUMBER
195 , prp_revenue_at_risk NUMBER
196 , prp_revenue_writeoff NUMBER
197 , prp_unbilled_receivables NUMBER
198 , prp_unearned_revenue NUMBER
199 , ptd_custom_1 NUMBER
200 , ptd_custom_2 NUMBER
201 , ptd_custom_3 NUMBER
202 , ptd_custom_4 NUMBER
203 , ptd_custom_5 NUMBER
204 , ptd_custom_6 NUMBER
205 , ptd_custom_7 NUMBER
206 , ptd_custom_8 NUMBER
207 , ptd_custom_9 NUMBER
208 , ptd_custom_10 NUMBER
209 , ptd_custom_11 NUMBER
210 , ptd_custom_12 NUMBER
211 , ptd_custom_13 NUMBER
212 , ptd_custom_14 NUMBER
213 , ptd_custom_15 NUMBER
214 , ptd_custom_16 NUMBER
215 , ptd_custom_17 NUMBER
216 , ptd_custom_18 NUMBER
217 , ptd_custom_19 NUMBER
218 , ptd_custom_20 NUMBER
219 , ptd_custom_21 NUMBER
220 , ptd_custom_22 NUMBER
221 , ptd_custom_23 NUMBER
222 , ptd_custom_24 NUMBER
223 , ptd_custom_25 NUMBER
224 , ptd_custom_26 NUMBER
225 , ptd_custom_27 NUMBER
226 , ptd_custom_28 NUMBER
227 , ptd_custom_29 NUMBER
228 , ptd_custom_30 NUMBER
229 , qtd_custom_1 NUMBER
230 , qtd_custom_2 NUMBER
231 , qtd_custom_3 NUMBER
232 , qtd_custom_4 NUMBER
233 , qtd_custom_5 NUMBER
234 , qtd_custom_6 NUMBER
235 , qtd_custom_7 NUMBER
236 , qtd_custom_8 NUMBER
237 , qtd_custom_9 NUMBER
238 , qtd_custom_10 NUMBER
239 , qtd_custom_11 NUMBER
240 , qtd_custom_12 NUMBER
241 , qtd_custom_13 NUMBER
242 , qtd_custom_14 NUMBER
243 , qtd_custom_15 NUMBER
244 , qtd_custom_16 NUMBER
245 , qtd_custom_17 NUMBER
246 , qtd_custom_18 NUMBER
247 , qtd_custom_19 NUMBER
248 , qtd_custom_20 NUMBER
249 , qtd_custom_21 NUMBER
250 , qtd_custom_22 NUMBER
251 , qtd_custom_23 NUMBER
252 , qtd_custom_24 NUMBER
253 , qtd_custom_25 NUMBER
254 , qtd_custom_26 NUMBER
255 , qtd_custom_27 NUMBER
256 , qtd_custom_28 NUMBER
257 , qtd_custom_29 NUMBER
258 , qtd_custom_30 NUMBER
259 , ytd_custom_1 NUMBER
260 , ytd_custom_2 NUMBER
261 , ytd_custom_3 NUMBER
262 , ytd_custom_4 NUMBER
263 , ytd_custom_5 NUMBER
264 , ytd_custom_6 NUMBER
265 , ytd_custom_7 NUMBER
266 , ytd_custom_8 NUMBER
267 , ytd_custom_9 NUMBER
268 , ytd_custom_10 NUMBER
269 , ytd_custom_11 NUMBER
270 , ytd_custom_12 NUMBER
271 , ytd_custom_13 NUMBER
272 , ytd_custom_14 NUMBER
273 , ytd_custom_15 NUMBER
274 , ytd_custom_16 NUMBER
275 , ytd_custom_17 NUMBER
276 , ytd_custom_18 NUMBER
277 , ytd_custom_19 NUMBER
278 , ytd_custom_20 NUMBER
279 , ytd_custom_21 NUMBER
280 , ytd_custom_22 NUMBER
281 , ytd_custom_23 NUMBER
282 , ytd_custom_24 NUMBER
283 , ytd_custom_25 NUMBER
284 , ytd_custom_26 NUMBER
285 , ytd_custom_27 NUMBER
286 , ytd_custom_28 NUMBER
287 , ytd_custom_29 NUMBER
288 , ytd_custom_30 NUMBER
289 , itd_custom_1 NUMBER
290 , itd_custom_2 NUMBER
291 , itd_custom_3 NUMBER
292 , itd_custom_4 NUMBER
293 , itd_custom_5 NUMBER
294 , itd_custom_6 NUMBER
295 , itd_custom_7 NUMBER
296 , itd_custom_8 NUMBER
297 , itd_custom_9 NUMBER
298 , itd_custom_10 NUMBER
299 , itd_custom_11 NUMBER
300 , itd_custom_12 NUMBER
301 , itd_custom_13 NUMBER
302 , itd_custom_14 NUMBER
303 , itd_custom_15 NUMBER
304 , itd_custom_16 NUMBER
305 , itd_custom_17 NUMBER
306 , itd_custom_18 NUMBER
307 , itd_custom_19 NUMBER
308 , itd_custom_20 NUMBER
309 , itd_custom_21 NUMBER
310 , itd_custom_22 NUMBER
311 , itd_custom_23 NUMBER
312 , itd_custom_24 NUMBER
313 , itd_custom_25 NUMBER
314 , itd_custom_26 NUMBER
315 , itd_custom_27 NUMBER
316 , itd_custom_28 NUMBER
317 , itd_custom_29 NUMBER
318 , itd_custom_30 NUMBER
319 , ac_custom_1 NUMBER
320 , ac_custom_2 NUMBER
321 , ac_custom_3 NUMBER
322 , ac_custom_4 NUMBER
323 , ac_custom_5 NUMBER
324 , ac_custom_6 NUMBER
325 , ac_custom_7 NUMBER
326 , ac_custom_8 NUMBER
327 , ac_custom_9 NUMBER
328 , ac_custom_10 NUMBER
329 , ac_custom_11 NUMBER
330 , ac_custom_12 NUMBER
331 , ac_custom_13 NUMBER
332 , ac_custom_14 NUMBER
333 , ac_custom_15 NUMBER
334 , ac_custom_16 NUMBER
335 , ac_custom_17 NUMBER
336 , ac_custom_18 NUMBER
337 , ac_custom_19 NUMBER
338 , ac_custom_20 NUMBER
339 , ac_custom_21 NUMBER
340 , ac_custom_22 NUMBER
341 , ac_custom_23 NUMBER
342 , ac_custom_24 NUMBER
343 , ac_custom_25 NUMBER
344 , ac_custom_26 NUMBER
345 , ac_custom_27 NUMBER
346 , ac_custom_28 NUMBER
347 , ac_custom_29 NUMBER
348 , ac_custom_30 NUMBER
349 , prp_custom_1 NUMBER
350 , prp_custom_2 NUMBER
351 , prp_custom_3 NUMBER
352 , prp_custom_4 NUMBER
353 , prp_custom_5 NUMBER
354 , prp_custom_6 NUMBER
355 , prp_custom_7 NUMBER
356 , prp_custom_8 NUMBER
357 , prp_custom_9 NUMBER
358 , prp_custom_10 NUMBER
359 , prp_custom_11 NUMBER
360 , prp_custom_12 NUMBER
361 , prp_custom_13 NUMBER
362 , prp_custom_14 NUMBER
363 , prp_custom_15 NUMBER
364 , prp_custom_16 NUMBER
365 , prp_custom_17 NUMBER
366 , prp_custom_18 NUMBER
367 , prp_custom_19 NUMBER
368 , prp_custom_20 NUMBER
369 , prp_custom_21 NUMBER
370 , prp_custom_22 NUMBER
371 , prp_custom_23 NUMBER
372 , prp_custom_24 NUMBER
373 , prp_custom_25 NUMBER
374 , prp_custom_26 NUMBER
375 , prp_custom_27 NUMBER
376 , prp_custom_28 NUMBER
377 , prp_custom_29 NUMBER
378 , prp_custom_30 NUMBER
379 );
380
381 /**
382 ** For a given Project_id and a set of Currenct plan versions,
383 ** this API extracts their relative
384 ** Original baseline plan versions IDs,
385 ** Current baseline plan types IDs,
386 ** and Original baseline plan types IDs.
387 **
388 ** History
389 ** 21-APR-2004 EPASQUIN Created
390 **/
391 PROCEDURE get_plan_type_info
392 (
393 p_project_id NUMBER
394 , pActualVersionId NUMBER
395 , pCstForecastVersionId NUMBER
396 , pCstBudgetVersionId NUMBER
397 , pCstBudget2VersionId NUMBER
398 , pRevForecastVersionId NUMBER
399 , pRevBudgetVersionId NUMBER
400 , pRevBudget2VersionId NUMBER
401 , xOrigCstForecastVersionId OUT NOCOPY NUMBER
402 , xOrigCstBudgetVersionId OUT NOCOPY NUMBER
403 , xOrigCstBudget2VersionId OUT NOCOPY NUMBER
404 , xOrigRevForecastVersionId OUT NOCOPY NUMBER
405 , xOrigRevBudgetVersionId OUT NOCOPY NUMBER
406 , xOrigRevBudget2VersionId OUT NOCOPY NUMBER
407 , xActualPlanTypeId OUT NOCOPY NUMBER
408 , xCstForecastPlanTypeId OUT NOCOPY NUMBER
409 , xCstBudgetPlanTypeId OUT NOCOPY NUMBER
410 , xCstBudget2PlanTypeId OUT NOCOPY NUMBER
411 , xRevForecastPlanTypeId OUT NOCOPY NUMBER
412 , xRevBudgetPlanTypeId OUT NOCOPY NUMBER
413 , xRevBudget2PlanTypeId OUT NOCOPY NUMBER
414 , x_return_status OUT NOCOPY VARCHAR2
415 , x_msg_count OUT NOCOPY NUMBER
416 , x_msg_data OUT NOCOPY VARCHAR2
417 );
418
419
420 /**
421 ** This API prepares, calculates and retrieves the measures to be used by
422 ** Overview Page and breakdown pages.
423 **
424 ** History
425 ** 16-MAR-2004 EPASQUIN Created
426 ** 21-APR-2004 EPASQUIN Introduced Plan_types parameters
427 **
428 **/
429 PROCEDURE prepareData
430 (
431 pProjectId NUMBER
432 , pWBSVersionId NUMBER
433 , pWBSElementId NUMBER
434 , pRBSVersionId NUMBER
435 , pRBSElementId NUMBER
436 , pCalendarId NUMBER
437 , pCalendarType VARCHAR2
438 , pPeriodDateJulian NUMBER
439 , pActualVersionId NUMBER
440 , pCstForecastVersionId NUMBER
441 , pCstBudgetVersionId NUMBER
442 , pCstBudget2VersionId NUMBER
443 , pRevForecastVersionId NUMBER
444 , pRevBudgetVersionId NUMBER
445 , pRevBudget2VersionId NUMBER
446 , pOrigCstForecastVersionId NUMBER
447 , pOrigCstBudgetVersionId NUMBER
448 , pOrigCstBudget2VersionId NUMBER
449 , pOrigRevForecastVersionId NUMBER
450 , pOrigRevBudgetVersionId NUMBER
451 , pOrigRevBudget2VersionId NUMBER
452 , pPriorCstForecastVersionId NUMBER
453 , pPriorRevForecastVersionId NUMBER
454 , pActualPlanTypeId NUMBER
455 , pCstForecastPlanTypeId NUMBER
456 , pCstBudgetPlanTypeId NUMBER
457 , pCstBudget2PlanTypeId NUMBER
458 , pRevForecastPlanTypeId NUMBER
459 , pRevBudgetPlanTypeId NUMBER
460 , pRevBudget2PlanTypeId NUMBER
461 , pCurrencyRecordType NUMBER
462 , pCurrencyCode VARCHAR2
463 , pFactorBy NUMBER -- to be applied to every CURRENCY measure
464 , pEffortUOM NUMBER -- to be applied to every HOURS measure
465 , pCurrencyType VARCHAR2
466 , pTimeSlice NUMBER
467 , pPrgRollup VARCHAR2
468 , pReportType VARCHAR2
469 , pWBSRollupFlag VARCHAR2 DEFAULT 'Y'
470 , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
471 , pPeriodName VARCHAR2
472 , xDaysSinceITD OUT NOCOPY NUMBER
473 , xDaysInPeriod OUT NOCOPY NUMBER
474 , x_return_status OUT NOCOPY VARCHAR2
475 , x_msg_count OUT NOCOPY NUMBER
476 , x_msg_data OUT NOCOPY VARCHAR2
477 );
478
479
480 /**
481 ** Given a list of wanted measures, this API retrieves them in arrays
482 ** executing all necessary calculations.
483 **
484 ** History
485 ** 16-MAR-2004 EPASQUIN Created
486 ** 21-APR-2004 EPASQUIN Introduced Plan_types parameters
487 **
488 **/
489 PROCEDURE retrieveData
490 (
491 pProjectId NUMBER
492 , pWBSVersionId NUMBER
493 , pWBSElementId NUMBER
494 , pRBSVersionId NUMBER
495 , pRBSElementId NUMBER
496 , pCalendarId NUMBER
497 , pCalendarType VARCHAR2
498 , pPeriodDateJulian NUMBER
499 , pActualVersionId NUMBER
500 , pCstForecastVersionId NUMBER
501 , pCstBudgetVersionId NUMBER
502 , pCstBudget2VersionId NUMBER
503 , pRevForecastVersionId NUMBER
504 , pRevBudgetVersionId NUMBER
505 , pRevBudget2VersionId NUMBER
506 , pOrigCstForecastVersionId NUMBER
507 , pOrigCstBudgetVersionId NUMBER
508 , pOrigCstBudget2VersionId NUMBER
509 , pOrigRevForecastVersionId NUMBER
510 , pOrigRevBudgetVersionId NUMBER
511 , pOrigRevBudget2VersionId NUMBER
512 , pPriorCstForecastVersionId NUMBER
513 , pPriorRevForecastVersionId NUMBER
514 , pActualPlanTypeId NUMBER
515 , pCstForecastPlanTypeId NUMBER
516 , pCstBudgetPlanTypeId NUMBER
517 , pCstBudget2PlanTypeId NUMBER
518 , pRevForecastPlanTypeId NUMBER
519 , pRevBudgetPlanTypeId NUMBER
520 , pRevBudget2PlanTypeId NUMBER
521 , pCurrencyRecordType NUMBER
522 , pCurrencyCode VARCHAR2
523 , pFactorBy NUMBER -- to be applied to every CURRENCY measure
524 , pEffortUOM NUMBER -- to be applied to every HOURS measure
525 , pCurrencyType VARCHAR2
526 , pTimeSlice NUMBER
527 , pPrgRollup VARCHAR2
528 , pReportType VARCHAR2
529 , pPeriodName VARCHAR2
530 , p_measure_set_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
531 , p_raw_text_flag VARCHAR2 DEFAULT 'Y'
532 , pWBSRollupFlag VARCHAR2 DEFAULT 'Y'
533 , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
534 , pCallingType VARCHAR2
535 , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
536 , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
537 , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
538 , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
539 , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
540 , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
541 , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
542 , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
543 , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
544 , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
545 , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
546 , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
547 , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
548 , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
549 , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
550 , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
551 , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
552 , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
553 , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
554 , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
555 , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
556 , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
557 , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
558 , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
559 , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
560 , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
561 , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
562 , xDaysSinceITD OUT NOCOPY NUMBER
563 , xDaysInPeriod OUT NOCOPY NUMBER
564 , x_return_status IN OUT NOCOPY VARCHAR2
565 , x_msg_count IN OUT NOCOPY NUMBER
566 , x_msg_data IN OUT NOCOPY VARCHAR2
567 );
568
569
570 PROCEDURE Merge_Overview_Type
571 (
572 p_source_index IN NUMBER
573 ,p_source_table IN pji_rep_overview_type_tbl
574 ,p_target_index IN NUMBER
575 ,p_target_table IN OUT NOCOPY pji_rep_overview_type_tbl
576 );
577
578
579 END Pji_Rep_Measure_Util;