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