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_MO_HELPER_PKG

Source


1 Package BSC_MO_HELPER_PKG AS
2 /* $Header: BSCMOHPS.pls 120.9.12000000.2 2007/04/24 05:32:27 amitgupt ship $ */
3 
4 g_stack dbms_sql.varchar2_table;
5 g_stack_index number :=0;
6 g_stack_length number :=0;
7 
8 
9 TYPE CurTyp IS REF CURSOR;
10 FUNCTION getSourceTable(p_table IN VARCHAR2) return VARCHAR2 ;
11 FUNCTION getPeriodicityForTable(p_table_name IN VARCHAR2) return NUMBER;
12 PROCEDURE checkError(apiName IN VARCHAR2);
13 PROCEDURE InitTablespaceNames ;
14 FUNCTION getTablespaceClauseTbl RETURN VARCHAR2 ;
15 FUNCTION getTablespaceClauseIdx RETURN VARCHAR2 ;
16 FUNCTION getStorageClause RETURN VARCHAR2 ;
17 
18 PROCEDURE MarkIndicsForNonStrucChanges;
19 --Procedure MarkIndicsAndTables;
20 Function GetFieldExpression(FieldExpresion IN OUT NOCOPY dbms_sql.varchar2_table, Expresion IN VARCHAR2)
21 return NUMBER;
22 FUNCTION get_time RETURN VARCHAR2;
23 
24 PROCEDURE addStack(pStack IN OUT NOCOPY VARCHAR2, pMsg IN VARCHAR2);
25 PROCEDURE InitializePeriodicities;
26 PROCEDURE InitializeCalendars;
27 procEDURE InitArrReservedWords;
28 PROCEDURE InitializeMasterTables ;
29 
30 PROCEDURE DropTable(p_table_name in VARCHAR2) ;
31 PROCEDURE DropView(p_view_name in VARCHAR2) ;
32 PROCEDURE Do_DDL(
33 	x_statement IN VARCHAR2,
34         x_statement_type IN INTEGER := 0,
35         x_object_name IN VARCHAR2
36 	) ;
37 
38 FUNCTION getAppsSchema return VARCHAR2;
39 FUNCTION getBSCSchema return VARCHAR2;
40 FUNCTION getApplsysSchema return VARCHAR2;
41 
42 PROCEDURE CreateCopyTable(TableName IN VARCHAR2, CopyTableName IN VARCHAR2, TbsName IN VARCHAR2, p_where_clause IN VARCHAR2 default null);
43 PROCEDURE CreateCopyIndexes(TableName IN VARCHAR2, CopyTableName IN VARCHAR2, TbsName IN VARCHAR2 DEFAULT NULL);
44 
45 PROCEDURE CreateLastTables;
46 
47 PROCEDURE InitInfoOldSystem;
48 
49 
50 Function searchStringExists(arrStr dbms_sql.varchar2_table, Num number, str varchar2) return boolean;
51 PROCEDURE deletePreviousRunTables;
52 Function DBObjectExists(ObjectName IN VARCHAR2)return boolean ;
53 
54 Procedure CheckAllIndicsHaveSystem;
55 Procedure CheckAllSharedIndicsSync;
56 PROCEDURE CheckAllEDWIndicsFullyMapped;
57 Procedure InitIndicators;
58 
59 
60 FUNCTION IsNumber (str IN VARCHAR2) RETURN BOOLEAN ;
61 
62 Function FindIndexVARCHAR2(arrStr IN dbms_sql.varchar2_table, str IN VARCHAR2) return NUMBER;
63 Function FindIndex(arrNum IN dbms_sql.NUMBER_TABLE, num IN NUMBER) RETURN NUMBER;
64 Function FindIndex(arrstr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,  findThis in varchar2) return NUMBER ;
65 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, findThis in varchar2) return NUMBER;
66 Function FindKeyIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, keyName in varchar2) return NUMBER;
67 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable, findThis in varchar2) return NUMBER;
68 
69 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable, findThis in varchar2) return NUMBER;
70 
71 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, findThis in number) return NUMBER ;
72 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField, findThis in VARCHAR2, p_source IN VARCHAR2, p_impl_type IN NUMBER ) return NUMBER ;
73 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField, findThis in NUMBER) return NUMBER ;
74 --BSC Autogen
75 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV, findThis in VARCHAR2, p_source IN VARCHAR2, pIgnoreCase In Boolean default false) return NUMBER ;
76 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity, findThis in NUMBER) return NUMBER ;
77 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar, findThis in NUMBER) return NUMBER ;
78 Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,  findThis in varchar2) return NUMBER ;
79 
80 
81 FUNCTION getInitColumn(p_column IN VARCHAR2) return VARCHAR2 ;
82 FUNCTION get_lookup_value(p_lookup_type IN VARCHAR2, p_lookup_code  IN VARCHAR2) return VARCHAR2;
83 
84 Function TableExists(Table_Name IN VARCHAR2) return Boolean;
85 --Procedure CreateBackupBaseTables;
86 Procedure backup_b_table(p_table IN VARCHAR2);
87 --PROCEDURE InitReservedFunctions;
88 PROCEDURE InitLOV ;
89 
90 FUNCTION decomposeString(p_string IN VARCHAR2, p_separator IN VARCHAR2, p_return_array OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)
91 return NUMBER ;
92 FUNCTION decomposeStringtoNumber(p_string IN VARCHAR2, p_separator IN VARCHAR2) return DBMS_SQL.NUMBER_TABLE;
93 Function searchNumberExists(arrStr dbms_sql.number_table, Num number, l_findThis NUMBER)
94 return Boolean;
95 
96 Function table_column_exists(p_table IN VARCHAR2, p_Column IN VARCHAR2) RETURN boolean;
97 PROCEDURE InitializeYear ;
98 PROCEDURE CleanDatabase;
99 
100 PROCEDURE AddIndicator(collIndicadores IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator, p_Code NUMBER,
101 			p_Name varchar2, p_indicatorType NUMBER, p_configType NUMBER,
102 			p_per_inter NUMBER, p_optMode NUMBER, p_action_flag NUMBER,
103 			p_share_flag NUMBER, p_src_ind NUMBER, p_edw_flag NUMBER, p_impl_type NUMBER) ;
104 Function getKPIPropertyValue(Indic IN NUMBER, Variable IN VARCHAR2,
105 	def IN NUMBER) return NUMBER ;
106 
107 PROCEDURE writeTmp(msg IN VARCHAR2, pSeverity IN NUMBER DEFAULT NULL, pForce IN boolean default false);
108 PROCEDURE UpdateFlags;
109 
110 PROCEDURE SaveOptimizationMode;
111 --PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2);
112 PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,
113             pKeyFields IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
114             pData       IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
115         proc IN VARCHAR2);
116 
117 
118 FUNCTION boolean_decode (pVal IN BOOLEAN) RETURN VARCHAR2;
119 
120 
121 
122 PROCEDURE write_this (pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsConfigKpiMV ,
123 pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);
124 PROCEDURE write_this (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsConfigKpiMV ,
125 pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);
126 
127 PROCEDURE write_this (pTable IN DBMS_SQL.VARCHAR2_TABLE,
128   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
129   pForce IN boolean default false);
130 PROCEDURE write_this (pTable IN DBMS_SQL.NUMBER_TABLE,
131   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
132   pForce IN boolean default false);
133 --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsAuxillaryField,  ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
134 --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsAuxillaryField, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
135 --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsParent,  ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
136 --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsParent, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
137 PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMasterTable,
138   ind IN NUMBER default null,
139   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
140   pForce IN boolean default false);
141 PROCEDURE write_this(
142   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable,
143   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
144   pForce IN boolean default false);
145 PROCEDURE write_this(
146   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsRelationMN,
147   ind IN NUMBER default null,
148   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
149   pForce IN boolean default false);
150 PROCEDURE write_this(
151   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsRelationMN,
152   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
153   pForce IN boolean default false);
154 PROCEDURE write_this(
155   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsIndicator,
156   ind IN NUMBER default null,
157   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
158   pForce IN boolean default false);
159 PROCEDURE write_this(
160   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicator,
161   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
162   pForce IN boolean default false);
163 PROCEDURE write_this(
164   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity,
165   ind IN NUMBER default null,
166   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
167   pForce IN boolean default false);
168 PROCEDURE write_this(
169   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsPeriodicity ,
170   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
171   pForce IN boolean default false);
172 PROCEDURE write_this(
173   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsIndicPeriodicity,
174   ind IN NUMBER default null,
175   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
176   pForce IN boolean default false);
177 PROCEDURE write_this(
178   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsIndicPeriodicity ,
179   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
180   pForce IN boolean default false);
181 PROCEDURE write_this(
182   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsCalendar,
183   ind IN NUMBER default null,
184   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
185   pForce IN boolean default false);
186 PROCEDURE write_this(
187   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsCalendar,
188   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
189   pForce IN boolean default false);
190 PROCEDURE write_this(
191   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOldBTables,
192   ind IN NUMBER default null,
193   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
194   pForce IN boolean default false);
195 PROCEDURE write_this(
196   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOldBTables,
197   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
198   pForce IN boolean default false);
199 PROCEDURE write_this(
200   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV,
201   ind IN NUMBER default null,
202   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
203   pForce IN boolean default false);
204 PROCEDURE write_this(
205   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMeasureLOV,
206   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
207   pForce IN boolean default false);
208 PROCEDURE write_this(
209   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsLevels,
210   ind IN NUMBER default null,
211   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
212   pForce IN boolean default false);
213 PROCEDURE write_this(
214   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,
215   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
216   pForce IN boolean default false);
217 PROCEDURE write_this(
218   pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels,
219   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
220   pForce IN boolean default false);
221 PROCEDURE write_this(
222   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
223   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
224   pForce IN boolean default false);
225 PROCEDURE write_this(
226   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations,
227   ind IN NUMBER default null,
228   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
229   pForce IN boolean default false);
230 PROCEDURE write_this(
231   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,
232   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
233   pForce IN boolean default false);
234 PROCEDURE write_this(
235   pTable IN BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevelCombinations,
236   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
237   pForce IN boolean default false);
238 PROCEDURE write_this(
239   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,
240   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
241   pForce IN boolean default false);
242 PROCEDURE write_this(
243   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField,
244   ind IN NUMBER default null,
245   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
246   pForce IN boolean default false);
247 PROCEDURE write_this(
248   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
249   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
250   pForce IN boolean default false);
251 PROCEDURE write_this(
252   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDataField,
253   ind IN NUMBER default null,
254   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
255   pForce IN boolean default false);
256 PROCEDURE write_this(
257   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField,
258   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
259   pForce IN boolean default false);
260 PROCEDURE write_this(
261   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,
262   ind IN NUMBER default null,
263   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
264   pForce IN boolean default false);
265 PROCEDURE write_this(
266   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable,
267   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
268   pForce IN boolean default false);
269 PROCEDURE write_this(
270   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_string,
271   ind IN NUMBER default null,
272   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
273   pForce IN boolean default false);
274 PROCEDURE write_this(
275   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_string,
276   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
277   pForce IN boolean default false);
278 --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.number_table,  ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);MBER DEFAULT FND_LOG.LEVEL_STATEMENT);
279 --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.TwoDNumberTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);_STATEMENT);
280 --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsOriginTable,  ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
281 --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsOriginTable, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);VEL_STATEMENT);
282 PROCEDURE write_this(
283   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable,
284   ind IN NUMBER default null,
285   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
286   pForce IN boolean default false);
287 PROCEDURE write_this(
288   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable,
289   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
290   pForce IN boolean default false,
291   pIgonoreProduction IN boolean default false);
292 PROCEDURE write_this(
293   pTableName IN VARCHAR2, pFieldName IN VARCHAR2,
294   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField,
295   ind IN NUMBER default null,
296   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
297   pForce IN boolean default false);
298 PROCEDURE write_this(
299   pTableName IN VARCHAR2,
300   pFieldName IN VARCHAR2,
301   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField,
302   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
303   pForce IN boolean default false);
304 PROCEDURE write_this(
305   pTableName IN VARCHAR2,
306   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsUniqueField,
307   ind IN NUMBER default null,
308   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
309   pForce IN boolean default false);
310 PROCEDURE write_this(
311   pTableName IN VARCHAR2,
312   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField,
313   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
314   pForce IN boolean default false);
315 PROCEDURE write_this(
316   pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDBColumn,
317   ind IN NUMBER default null,
318   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
319   pForce IN boolean default false);
320 PROCEDURE write_this(
321   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDBColumn,
322   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
323   pForce IN boolean default false);
324 PROCEDURE write_this(
325   pTable IN BSC_METADATA_OPTIMIZER_PKG.TNewITables,
326   ind IN NUMBER default null,
327   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
328   pForce IN boolean default false);
329 PROCEDURE write_this(
330   pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_TNewITables,
331   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
332   pForce IN boolean default false);
333 
334 FUNCTION new_clsUniqueField return BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;
335 FUNCTION new_clsTable return BSC_METADATA_OPTIMIZER_PKG.clsTable;
336 FUNCTION new_clsDataField return BSC_METADATA_OPTIMIZER_PKG.clsDataField;
337 FUNCTION new_clsDisAggField return BSC_METADATA_OPTIMIZER_PKG.clsDisAggField;
338 FUNCTION new_clsKeyField return BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
339 FUNCTION new_clsOriginTable return BSC_METADATA_OPTIMIZER_PKG.clsOriginTable;
340 FUNCTION new_clsDBColumn return BSC_METADATA_OPTIMIZER_PKG.clsDBColumn;
341 FUNCTION new_clsMeasureLOV return BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
342 FUNCTION new_clsPeriodicity return BSC_METADATA_OPTIMIZER_PKG.clsPeriodicity;
343 FUNCTION new_clsCalendar return BSC_METADATA_OPTIMIZER_PKG.clsCalendar;
344 FUNCTION new_clsMasterTable return BSC_METADATA_OPTIMIZER_PKG.clsMasterTable;
345 FUNCTION new_clsLevels return BSC_METADATA_OPTIMIZER_PKG.clsLevels;
346 
347 FUNCTION new_tabrec_clsLevels return BSC_METADATA_OPTIMIZER_PKG.tabrec_clsLevels;
348 FUNCTION new_clsBasicTable return BSC_METADATA_OPTIMIZER_PKG.clsBasicTable ;
349 FUNCTION new_clsLevelCombinations return BSC_METADATA_OPTIMIZER_PKG.clsLevelCombinations;
350 FUNCTION new_TNewITables return BSC_METADATA_OPTIMIZER_PKG.TNewITables;
351 
352 /*FUNCTION new_ return BSC_METADATA_OPTIMIZER_PKG.;
353 FUNCTION new_ return ;*/
354 
355 
356 FUNCTION get_tab_clsLevels (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
357 FUNCTION get_tab_clsLevelCombinations (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
358 
359 FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;
360 FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;
361 
362 
363 /*PROCEDURE insertBasicTable( pTable BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,
364                             pKeys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
365                             pData BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
366 */
367 
368 FUNCTION consolidateString (pTable IN DBMS_SQL.VARCHAR2_TABLE, pSeparator IN VARCHAR2) RETURN VARCHAR2;
369 
370 FUNCTION getDecomposedString(p_string IN VARCHAR2, p_separator IN VARCHAR2) RETURN
371 DBMS_SQL.VARCHAR2_TABLE ;
372 
373 PROCEDURE add_tabrec_clsLevels(
374     pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
375     pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,
376     l_group_id IN NUMBER) ;
377 PROCEDURE add_tabrec_clsLevelComb(
378     pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations,
379     pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations,
380     l_group_id IN NUMBER) ;
381 
382 
383 --PROCEDURE insertKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
384 --PROCEDURE updateKeys(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
385 --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
386 --PROCEDURE insertData(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
387 
388 --FUNCTION getAllKeyFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
389 --FUNCTION getOneKeyField(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
390 
391 --FUNCTION getAllDataFields(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
392 --FUNCTION getOneDataField(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;
393 
394 
395 /* new */
396 /*
397 PROCEDURE insertKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField);
398 PROCEDURE updateKeys_pls(pTableName IN VARCHAR2, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField) ;
399 PROCEDURE insertData_pls(pTableName IN VARCHAR2, pDataFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
400 PROCEDURE insertData_pls(pTableName IN VARCHAR2, pData IN BSC_METADATA_OPTIMIZER_PKG.clsDataField) ;
401 PROCEDURE insertSingleKey_pls(pTableName IN VARCHAR2, pKeyField IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField) ;
402 
403 FUNCTION getAllKeyFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
404 FUNCTION getOneKeyField_pls(table_name IN VARCHAR2, key_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
405 
406 FUNCTION getAllDataFields_pls(pTableName IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
407 FUNCTION getOneDataField_pls(table_name IN VARCHAR2, field_name IN VARCHAR2) RETURN BSC_METADATA_OPTIMIZER_PKG.clsDataField;
408 */
409 
410 
411 /* Field disaggs*/
412 --FUNCTION getDisaggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisaggField;
413 --PROCEDURE insertDisAggs(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAggs IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, pFieldType IN NUMBER default 1) ;
414 --PROCEDURE insertOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1) ;
415 --PROCEDURE updateOneDisAgg(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pDisAgg IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField, pFieldType IN NUMBER default 1);
416 
417 /* Field disagg keys*/
418 --FUNCTION getDisaggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pFieldType IN NUMBER default 1) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
419 --PROCEDURE insertDisAggKeys(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKeyFields IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, pFieldType IN NUMBER default 1) ;
420 --PROCEDURE insertOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
421 --PROCEDURE updateOneDisAggKey(pTableName IN VARCHAR2, pFieldName IN VARCHAR2, pCode IN NUMBER, pKey IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField, pFieldType IN NUMBER default 1);
422 
423 
424 PROCEDURE addTable (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsTable, proc IN VARCHAR2) ;
425 
426 
427 PROCEDURE terminateWithError(pErrorShortName IN VARCHAR2, pAPI in varchar2 default null);
428 PROCEDURE terminateWithMsg(pMessage IN VARCHAR2, pAPI in varchar2 default null);
429 
430 
431 PROCEDURE WriteInfoMatrix(Indic IN NUMBER, Variable IN VARCHAR2, Valor IN NUMBER) ;
432 
433 PROCEDURE writeKeysTest;
434 
435 Function Get_New_Big_In_Cond_Varchar2( x_variable_id in number, x_column_name in varchar2) return VARCHAR2 ;
436 Function Get_New_Big_In_Cond_Number( x_variable_id IN NUMBER, x_column_name IN VARCHAR2) return VARCHAR2 ;
437 PROCEDURE Add_Value_Big_In_Cond_Varchar2(x_variable_id IN NUMBER, x_value IN VARCHAR2) ;
438 PROCEDURE Add_Value_Big_In_Cond_Number(x_variable_id IN NUMBER, x_value IN NUMBER);
439 PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.VARCHAR2_TABLE) ;
440 PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.NUMBER_TABLE);
441 
442 PROCEDURE InsertRelatedTables(arrTables in dbms_Sql.varchar2_table, numTables in number) ;
443 
444 
445 PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField,  ind IN NUMBER default null,
446   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false) ;
447 PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsDisAggField,  ind IN NUMBER default null,
448   pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false) ;
449 
450 FUNCTION find_objectives_for_table(p_table IN VARCHAR2) return BSC_METADATA_OPTIMIZER_PKG.tab_clsKPIDimSet;
451 PROCEDURE CreateKPIDataTableTmp ;
452 PROCEDURE CreateDBMeasureByDimSetTmp ;
453 FUNCTION filters_exist(p_kpi_number IN NUMBER, p_dim_set_id IN NUMBER, p_column_name IN VARCHAR2, p_filter_view OUT NOCOPY VARCHAR2) return boolean;
454 PROCEDURE dump_stack;
455 PROCEDURE write_to_stack(msg IN VARCHAR2);
456 
457 PROCEDURE drop_unused_columns(p_drop_tables_sql IN VARCHAR2);
458 
459 PROCEDURE load_reporting_calendars ;
460 PROCEDURE implement_aws(p_objectives in dbms_Sql.varchar2_table) ;
461 
462 
463 FUNCTION validate_dimension_views return BOOLEAN;
464 FUNCTION generate_index_name(p_table_name IN VARCHAR2,
465                       p_table_type IN VARCHAR2,p_index_type IN VARCHAR2) RETURN VARCHAR2;
466 END BSC_MO_HELPER_PKG;