1 PACKAGE BIS_PMF_MIGRATION_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPMIGS.pls 115.7 2002/12/16 10:23:41 rchandra ship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISPMIGS.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Package Spec for Migration of PMF data .
14 REM | Please refer to the datamodel for the changes.
15 REM | |
16 REM | NOTES |
17 REM | |
18 REM | HISTORY |
19 REM | 21-July-2000 amkulkar Creation |
20 REM | |
21 REM +=======================================================================+
22 */
23 --
24 --
25 /*Record type for all the dimension level ids.
26 This record type may already be there but did not have time to dig thru
27 */
28 TYPE target_level_rec IS RECORD(
29 measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
30 ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
31 ,org_levelid BIS_TARGET_LEVELS.ORG_LEVEL_ID%TYPE
32 ,time_levelid BIS_TARGET_LEVELS.TIME_LEVEL_ID%TYPE
33 ,dimension1_levelid BIS_TARGET_LEVELS.DIMENSION1_LEVEL_ID%TYPE
34 ,dimension2_levelid BIS_TARGET_LEVELS.DIMENSION2_LEVEL_ID%TYPE
35 ,dimension3_levelid BIS_TARGET_LEVELS.DIMENSION3_LEVEL_ID%TYPE
36 ,dimension4_levelid BIS_TARGET_LEVELS.DIMENSION4_LEVEL_ID%TYPE
37 ,dimension5_levelid BIS_TARGET_LEVELS.DIMENSION5_LEVEL_ID%TYPE
38 );
39 --
40 TYPE target_rec IS RECORD (
41 measure_id BIS_INDICATORS.INDICATOR_ID%TYPE
42 ,target_level_id BIS_TARGET_LEVELS.TARGET_LEVEL_ID%TYPE
43 ,target_id BIS_TARGET_VALUES.TARGET_ID%TYPE
44 ,org_level_value BIS_TARGET_VALUES.ORG_LEVEL_VALUE%TYPE
45 ,time_level_value BIS_TARGET_VALUES.TIME_LEVEL_VALUE%TYPE
46 ,dimension1_level_value BIS_TARGET_VALUES.DIMENSION1_LEVEL_VALUE%TYPE
47 ,dimension2_level_value BIS_TARGET_VALUES.DIMENSION2_LEVEL_VALUE%TYPE
48 ,dimension3_level_value BIS_TARGET_VALUES.DIMENSION3_LEVEL_VALUE%TYPE
49 ,dimension4_level_value BIS_TARGET_VALUES.DIMENSION4_LEVEL_VALUE%TYPE
50 ,dimension5_level_value BIS_TARGET_VALUES.DIMENSION5_LEVEL_VALUE%TYPE
51 );
52 --
53 TYPE resequenced_dimensions IS RECORD (
54 dim_level_col VARCHAR2(20000)
55 ,dim_level_col_val NUMBER
56 ,dim_id NUMBER
57 ,seq_no NUMBER
58 );
59 --
60 TYPE resequenced_dimensions_array IS TABLE OF
61 BIS_PMF_MIGRATION_PUB.resequenced_dimensions
62 INDEX BY BINARY_INTEGER;
63 --
64 TYPE reseq_target_values IS RECORD (
65 target_level VARCHAR2(20000)
66 ,target_level_value VARCHAR2(2000)
67 );
68 --
69 TYPE reseq_target_values_arr IS TABLE OF
70 BIS_PMF_MIGRATION_PUB.reseq_target_values
71 INDEX BY BINARY_INTEGER;
72 --
73 PROCEDURE MIGRATE_PERFORMANCE_MEASURES
74 (
75 p_measure_short_name IN VARCHAR2 DEFAULT NULL
76 ,x_return_status OUT NOCOPY VARCHAR2
77 )
78 ;
79 --
80 PROCEDURE RESEQUENCE_DIMENSION_LEVELS(
81 p_target_level_rec IN BIS_PMF_MIGRATION_PUB.target_level_rec
82 ,x_resequenced_dimensions OUT NOCOPY BIS_PMF_MIGRATION_PUB.resequenced_dimensions_array
83 ,x_dim_count OUT NOCOPY NUMBER
84 ,x_return_status OUT NOCOPY NUMBER
85 );
86 --
87 PROCEDURE RESEQUENCE_TARGET_LEVEL_VALUES(
88 p_target_rec IN BIS_PMF_MIGRATION_PUB.target_rec
89 ,p_dim_count IN NUMBER
90 ,x_reseq_target_values OUT NOCOPY BIS_PMF_MIGRATION_PUB.reseq_target_values_arr
91 ,x_return_status OUT NOCOPY NUMBER
92 );
93 --
94 FUNCTION GET_DIMENSION_ID
95 (p_dimension_level_id IN NUMBER
96 )
97 RETURN NUMBER;
98 END BIS_PMF_MIGRATION_PUB;
99 -- SHOW ERRORS