eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.BSC_DBGEN_STD_METADATA

Source


1 Package BSC_DBGEN_STD_METADATA AS
2 /* $Header: BSCMETAS.pls 120.3 2005/10/13 13:41 arsantha noship $ */
3 newline varchar2(10):='
4 ';
5 metadata_exception EXCEPTION;
6 
7 BSC constant VARCHAR2(10) := 'BSC';
8 AK  constant VARCHAR2(10) := 'AK';
9 BSC_PROPERTY_NOT_FOUND constant varchar2(100) := 'BSC_PROPERTY_NOT_FOUND';
10 
11 --projection method of the field
12                              --0: No Forecast
13                              --1: Moving Averge
14                              --2: Plan-Based (not used any more)
15                              --3: Plan-Based
16                              --4: Custom
17 PROJECTION_ID          constant VARCHAR2(30) := 'PROJECTION_ID';
18 -- Target Level
19 --   0 - NO
20 --   1 -YES
21 TARGET_LEVEL           constant VARCHAR2(30) := 'TARGET_LEVEL';
22 PROTOTYPE_FLAG         constant VARCHAR2(30) := 'PROTOTYPE_FLAG';
23 CONFIG_TYPE            constant VARCHAR2(30) := 'CONFIG_TYPE';
24 PERIODICITY_ID         constant VARCHAR2(30) := 'PERIODICITY_ID';
25 OPTIMIZATION_MODE      constant VARCHAR2(30) := 'OPTIMIZATION_MODE';
26 SHARE_FLAG             constant VARCHAR2(30) := 'SHARE_FLAG';
27 SOURCE_INDICATOR       constant VARCHAR2(30) := 'SOURCE_INDICATOR';
28 AVGL_SINGLE_COLUMN     constant VARCHAR2(30) := 'AVGL_SINGLE_COLUMN';
29 AVGL_TOTAL_COLUMN      constant VARCHAR2(30) := 'AVGL_TOTAL_COLUMN';
30 AVGL_COUNTER_COLUMN    constant VARCHAR2(30) := 'AVGL_COUNTER_COLUMN';
31 AVGL_FLAG              constant VARCHAR2(30) := 'AVGL_FLAG';
32 INTERNAL_COLUMN_TYPE   constant VARCHAR2(30) := 'INTERNAL_COLUMN_TYPE';
33 INTERNAL_COLUMN_SOURCE constant VARCHAR2(30) := 'INTERNAL_COLUMN_SOURCE';
34 MISSING_LEVEL          constant VARCHAR2(30) := 'MISSING_LEVEL'; -- YES/No
35 SOURCE_FORMULA         constant VARCHAR2(30) := 'SOURCE_FORMULA';
36 
37 
38 VERSION VARCHAR2(10) := '5.3';
39 
40 
41 BSC_PARTITION          constant VARCHAR2(20) := 'PARTITIONS';
42 BSC_B_PRJ_TABLE        constant VARCHAR2(20) := 'B_PRJ_TABLE_NAME';
43 BSC_I_ROWID_TABLE      constant VARCHAR2(20) := 'I_ROWID_TABLE_NAME';
44 BSC_ASSIGNMENT         constant VARCHAR2(10) := '=';
45 BSC_PROPERTY_SEPARATOR constant VARCHAR2(10) := '***';
46 
47 --BSC_BATCH_COLUMN_NAME constant VARCHAR2(20) := 'PARTITION_BUCKET_NUM';
48 BSC_BATCH_COLUMN_NAME constant VARCHAR2(20) := 'PARTITION_BUCKET_NUM';
49 
50 TYPE CurTyp IS REF CURSOR;
51 
52 TYPE clsAttribute IS RECORD (
53       attribute_name   VARCHAR2(30),
54       attribute_value  VARCHAR2(240));
55 TYPE tab_clsAttribute IS TABLE OF clsAttribute;
56 
57 TYPE ClsProperties IS RECORD(
58 name      VARCHAR2(240),
59 Value     VARCHAR2(4000));
60 TYPE tab_ClsProperties  IS TABLE OF ClsProperties INDEX BY VARCHAR2(240);
61 
62 
63 TYPE ClsFact IS RECORD(
64 Fact_id NUMBER,-- bsc indicator equivalent
65 Fact_Name VARCHAR2(240),
66 Fact_Type VARCHAR2(30),
67 dimension_set DBMS_SQL.NUMBER_TABLE,
68 Application_short_name VARCHAR2(30),
69 properties tab_ClsProperties);
70 TYPE tab_clsFact IS TABLE OF clsFact INDEX BY PLS_INTEGER;
71 
72 
73 TYPE ClsLevel IS RECORD(
74 --Dimension_Name VARCHAR2(240),
75 Level_Name VARCHAR2(240),
76 Level_Type VARCHAR2(30),
77 Level_index NUMBER,
78 Level_id NUMBER,
79 Level_table_name VARCHAR2(240),
80 Level_PK VARCHAR2(240),
81 Level_PK_Datatype VARCHAR2(100),
82 LEVEL_FK VARCHAR2(240), -- for BSC
83 Parents1N DBMS_SQL.VARCHAR2_TABLE,
84 ParentsMN DBMS_SQL.VARCHAR2_TABLE,
85 properties tab_ClsProperties  );
86 
87 TYPE tab_ClsLevel IS TABLE OF ClsLevel INDEX BY PLS_INTEGER;
88 
89 TYPE ClsLevelRelationship IS RECORD(
90 child_level VARCHAR2(240),
91 child_level_fk   VARCHAR2(240),
92 Parent_Level VARCHAR2(240),
93 Parent_Level_pk VARCHAR2(240),
94 properties tab_ClsProperties);
95 TYPE tab_ClsLevelRelationship  IS TABLE OF ClsLevelRelationship INDEX BY PLS_INTEGER;
96 
97 TYPE ClsHierarchy IS RECORD(
98 Hierarchy_Name VARCHAR2(240),
99 Levels tab_ClsLevel,
100 level_relationships tab_ClsLevelRelationship,
101 properties tab_ClsProperties);
102 TYPE tab_ClsHierarchy  IS TABLE OF ClsHierarchy INDEX BY PLS_INTEGER;
103 
104 TYPE ClsForeignKey IS RECORD(
105 Fact_Name VARCHAR2(240),
106 Foreign_Key VARCHAR2(240),
107 Dimension_Name VARCHAR2(240),
108 Level_Name VARCHAR2(240),
109 Dimension_Set VARCHAR2(240),
110 properties tab_ClsProperties);
111 TYPE tab_ClsForeignKey  IS TABLE OF ClsForeignKey INDEX BY PLS_INTEGER;
112 
113 TYPE ClsDimension IS RECORD(
114 Dimension_Name VARCHAR2(240),
115 Dimension_Type VARCHAR2(30),
116 Application_short_name VARCHAR2(30),
117 Hierarchies tab_clsHierarchy,
118 properties tab_ClsProperties);
119 TYPE tab_ClsDimension  IS TABLE OF ClsDimension INDEX BY PLS_INTEGER;
120 
121 
122 
123 TYPE ClsMeasure IS RECORD(
124 --Fact_Name VARCHAR2(240),
125 Measure_ID NUMBER,
126 Measure_Name VARCHAR2(240),
127 Measure_Type VARCHAR2(240),
128 Measure_Group VARCHAR2(240),
129 measure_source VARCHAR2(30),
130 Description VARCHAR2(240),
131 datatype VARCHAR2(30),
132 aggregation_method VARCHAR2(1000),
133 Properties tab_ClsProperties);
134 TYPE tab_ClsMeasure IS TABLE OF ClsMeasure INDEX BY PLS_INTEGER;
135 
136 
137 TYPE ClsCalendar IS RECORD(
138 Calendar_id NUMBER,
139 Calendar_Name VARCHAR2(240),
140 properties tab_ClsProperties);
141 TYPE tab_ClsCalendar IS TABLE OF ClsCalendar INDEX BY PLS_INTEGER;
142 
143 
144 TYPE ClsPeriodicity IS RECORD(
145 Periodicity_id NUMBER,
146 Periodicity_Name VARCHAR2(240),
147 periodicity_type NUMBER,
148 Calendar_id NUMBER,
149 Parent_periods dbms_sql.varchar2_table,
150 properties tab_ClsProperties);
151 TYPE tab_ClsPeriodicity IS TABLE OF ClsPeriodicity INDEX BY PLS_INTEGER;
152 
153 TYPE clsNUMBERV IS RECORD
154 (value number);
155 TYPE tab_clsNumberV IS TABLE OF clsNumberV INDEX BY VARCHAR2(100);
156 
157 
158 TYPE clsPartitionInfo IS RECORD
159 (partition_name VARCHAR2(100),
160  partition_value VARCHAR2(4000),
161  partition_position number);
162 
163 TYPE tab_clsPartitionInfo IS TABLE OF clsPartitionInfo INDEX BY PLS_INTEGER;
164 
165 TYPE clsTablePartition IS RECORD
166 (table_name VARCHAR2(100),
167  partitioning_type VARCHAR2(100),
168  partition_count NUMBER,
169  partitioning_column VARCHAR2(100),
170  partitioning_column_datatype VARCHAR2(100),
171  partition_info tab_clsPartitionInfo);
172 
173 TYPE clsColumnMaps IS RECORD
174 (column_name VARCHAR2(100),
175  source_column_name VARCHAR2(100));
176 
177 TYPE tab_clsColumnMaps IS TABLE OF clsColumnMaps INDEX BY PLS_INTEGER;
178 
179 END BSC_DBGEN_STD_METADATA;