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.

APPS.BSC_METADATA_OPTIMIZER_PKG dependencies on BSC_METADATA_OPTIMIZER_PKG

Line 1: Package Body BSC_METADATA_OPTIMIZER_PKG AS

1: Package Body BSC_METADATA_OPTIMIZER_PKG AS
2: /* $Header: BSCMOPTB.pls 120.25 2006/03/27 12:47:07 arsantha noship $ */
3:
4:
5: g_doc_file utl_file.file_type;

Line 20: l_stmt := 'create table '||l_table_name ||' TABLESPACE '||BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName||' '|| BSC_METADATA_OPTIMIZER_PKG.gStorageClause||

16: exception when others then
17: null;
18: --BSC_MO_HELPER_PKG.writeTmp(l_table_name ||' does not exist... ignoring error while trying to drop');
19: end;
20: l_stmt := 'create table '||l_table_name ||' TABLESPACE '||BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName||' '|| BSC_METADATA_OPTIMIZER_PKG.gStorageClause||
21: ' as
22: SELECT distinct k.indicator, k.dim_set_id, k.level_pk_col, k.level_view_name
23: FROM BSC_KPI_DIM_LEVELS_B K, BSC_SYS_DIM_LEVELS_B S, bsc_kpis_b kpi
24: WHERE

Line 35: l_stmt := l_stmt ||' TABLESPACE '|| BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName||' '|| BSC_METADATA_OPTIMIZER_PKG.gStorageClause;

31: AND K.STATUS = 2 ';
32: BSC_MO_HELPER_PKG.writeTmp('Going to create '||l_table_name , FND_LOG.LEVEL_STATEMENT, false);
33: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_table, l_table_name);
34: l_stmt := 'create unique index '||l_table_name||'_u1 on '||l_table_name ||'(indicator, dim_set_id, level_pk_col)';
35: l_stmt := l_stmt ||' TABLESPACE '|| BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName||' '|| BSC_METADATA_OPTIMIZER_PKG.gStorageClause;
36: BSC_MO_HELPER_PKG.writeTmp('Going to create '||l_table_name ||'_u1', FND_LOG.LEVEL_STATEMENT, false);
37: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_index, l_table_name ||'_u1');
38:
39: END;

Line 183: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

179: SELECT DISTINCT LANGUAGE_CODE, NLS_LANGUAGE FROM FND_LANGUAGES
180: WHERE INSTALLED_FLAG IN ('I', 'B');
181:
182: BEGIN
183: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
184: bsc_mo_helper_pkg.writeTmp('Inside InitLanguages', FND_LOG.LEVEL_PROCEDURE);
185: END IF;
186: gNumInstalled_Languages := 0;
187: OPEN c1;

Line 201: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

197: gLangCode := l_lang_code;
198: End If ;
199: END LOOP;
200: close cLangs;
201: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
202: bsc_mo_helper_pkg.writeTmp('Compl InitLanguages', FND_LOG.LEVEL_PROCEDURE);
203: bsc_mo_helper_pkg.writeTmp('gInstalled_Languages IS', FND_LOG.LEVEL_STATEMENT);
204: bsc_mo_helper_pkg.write_this(gInstalled_Languages, FND_LOG.LEVEL_STATEMENT);
205: END IF;

Line 222: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

218: -- return if already initialized
219: IF (gNumReservedFunctions >0 and gNumReservedOperators >0) THEN
220: return;
221: END IF;
222: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
223: bsc_mo_helper_pkg.writeTmp('Inside InitReservedFunctions', FND_LOG.LEVEL_PROCEDURE);
224: END IF;
225: l_stmt := 'SELECT WORD FROM BSC_DB_RESERVED_WORDS WHERE WORD IS NOT NULL AND TYPE = 1';
226: gNumReservedFunctions := 0;

Line 251: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

247: END IF;
248:
249: END LOOP;
250: CLOSE CV;
251: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
252: bsc_mo_helper_pkg.writeTmp('Compl InitReservedFunctions', FND_LOG.LEVEL_PROCEDURE);--commit;
253: bsc_mo_helper_pkg.writeTmp( 'gReservedOperators are', FND_LOG.LEVEL_STATEMENT);
254: bsc_mo_helper_pkg.write_this(gReservedOperators, FND_LOG.LEVEL_STATEMENT);
255: END IF;

Line 397: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

393: BSC_MO_INDICATOR_PKG.IndicatorTables;
394: logProgress('INDICATORS', 'Completed IndicatorTables');
395: bsc_mo_helper_pkg.writeTmp('Done with Indicator tables, system time is '||
396: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
397: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
398: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
399: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT);
400: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT);
401: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);

Line 400: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT);

396: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
397: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
398: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
399: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT);
400: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT);
401: bsc_mo_helper_pkg.writeTmp( newline||newline, FND_LOG.LEVEL_STATEMENT);
402: END IF;
403: ------------------------------------------------------------
404: --Input tables

Line 415: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

411: BSC_MO_INPUT_TABLE_PKG.InputTables;
412: logProgress('INPUT', 'Completed InputTables');
413: bsc_mo_helper_pkg.writeTmp('Done with InputTables in GenerateActualization, system time is '||
414: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
415: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
416: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT, false);
417: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT, false, true);
418: bsc_mo_helper_pkg.writeTmp( ' ');
419: END IF;

Line 417: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT, false, true);

413: bsc_mo_helper_pkg.writeTmp('Done with InputTables in GenerateActualization, system time is '||
414: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE, true);
415: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
416: bsc_mo_helper_pkg.writeTmp( 'gTables is ', FND_LOG.LEVEL_STATEMENT, false);
417: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gTables, FND_LOG.LEVEL_STATEMENT, false, true);
418: bsc_mo_helper_pkg.writeTmp( ' ');
419: END IF;
420: ------------------------------------------------------------
421: --Loader Configuration

Line 440: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

436: i := gIndicators.first;
437: LOOP
438: Indic := gIndicators(i);
439: If Indic.Action_Flag = 4 Then
440: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
441: bsc_mo_helper_pkg.writeTmp( 'Has non structural change, calling ReConfigureUploadFieldsIndic', FND_LOG.LEVEL_STATEMENT);
442: END IF;
443: BSC_MO_LOADER_CONFIG_PKG.ReConfigureUploadFieldsIndic (Indic.Code);
444:

Line 462: IF BSC_METADATA_OPTIMIZER_PKG.gSYSTEM_STAGE = 2 THEN

458: bsc_mo_helper_pkg.writeTmp('Done Loader Configuration, system time is '||
459: bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
460: writeTableCounts;
461: logProgress('MISC', 'Starting drop_unused_columns');
462: IF BSC_METADATA_OPTIMIZER_PKG.gSYSTEM_STAGE = 2 THEN
463: bsc_mo_helper_pkg.writeTmp('Starting drop_unused_columns');
464: bsc_mo_helper_pkg.drop_unused_columns(null);
465: bsc_mo_helper_pkg.writeTmp('Done drop_unused_columns');
466: END IF;

Line 531: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

527: writetableCounts;
528: --For kpis with structural changes or non-structural changes
529: --Also create MVs when summarization level has changed
530: l_count := gIndicators.first;
531: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
532: bsc_mo_helper_pkg.writeTmp('Total indics = '||gIndicators.count, FND_LOG.LEVEL_PROCEDURE);
533: END IF;
534:
535: LOOP

Line 538: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

534:
535: LOOP
536: EXIT WHEN gIndicators.count = 0;
537: indic := gIndicators(l_count);
538: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
539: bsc_mo_helper_pkg.writeTmp('Processing Indic '||l_count);
540: END IF;
541: --totally shared objectives dont need MVs or AW summary objects
542: IF not is_totally_shared_obj(Indic.code) then

Line 655: IF (bsc_metadata_optimizer_pkg.gGAA_RUN_MODE=0) THEN

651: --when it is the first time the system runs in MV architecture.
652:
653: If (g_Current_Adv_Sum_Level IS NULL ) And (g_Adv_Summarization_Level IS NOT NULL) Then
654: --User wants to uptake the new architecture. Show warning messages.
655: IF (bsc_metadata_optimizer_pkg.gGAA_RUN_MODE=0) THEN
656: g_sum_level_change := 0; -- Entire system running for MVs first time, so not an upgrade
657: ELSE
658: g_Sum_Level_Change := 1; --Upgrade to new architecture (null to notnull)
659: END IF;

Line 813: BSC_METADATA_OPTIMIZER_PKG.g_dir:=BSC_METADATA_OPTIMIZER_PKG.getUtlFileDir;

809: ELSE -- IF BIS_PMF_DEBUG is set, then enable logging automatically
810: g_log_level := FND_LOG.g_current_runtime_level;
811: END IF;
812: IF (g_dir is null OR fnd_global.CONC_REQUEST_ID = -1) THEN -- run manually
813: BSC_METADATA_OPTIMIZER_PKG.g_dir:=BSC_METADATA_OPTIMIZER_PKG.getUtlFileDir;
814: g_log := TRUE;
815: g_log_level := FND_LOG.LEVEL_STATEMENT;
816: END IF;
817: g_log_level := FND_LOG.LEVEL_STATEMENT;

Line 1088: END BSC_METADATA_OPTIMIZER_PKG;

1084: bsc_locks_pub.remove_system_lock;
1085: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Documentation : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1086: raise;
1087: END;
1088: END BSC_METADATA_OPTIMIZER_PKG;