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_MO_UI_PKG dependencies on BSC_METADATA_OPTIMIZER_PKG

Line 44: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN

40: l_error varchar2(1000);
41: l_start_time date := sysdate;
42:
43: BEGIN
44: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
45: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
46: END IF;
47: numNewTables := 0;
48:

Line 45: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;

41: l_start_time date := sysdate;
42:
43: BEGIN
44: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
45: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
46: END IF;
47: numNewTables := 0;
48:
49: g_recursion_ctr := g_recursion_ctr +1 ;

Line 53: l_stmt := ' INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v)

49: g_recursion_ctr := g_recursion_ctr +1 ;
50:
51: If numTables > 0 Then
52: --insert the children
53: l_stmt := ' INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v)
54: SELECT distinct userenv(''SESSIONID''), 0, TABLE_NAME
55: FROM BSC_DB_TABLES_RELS rels
56: where source_table_name IN
57: (SELECT /*+ index(tmp bsc_tmp_big_in_cond_n1)*/

Line 70: l_stmt := 'INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v)

66: numNewTables := sql%ROWCOUNT;
67: l_start_Time := sysdate;
68:
69: --insert the parents
70: l_stmt := 'INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v)
71: SELECT distinct userenv(''SESSIONID''), 0, SOURCE_TABLE_NAME
72: FROM BSC_DB_TABLES_RELS
73: WHERE table_name IN
74: (SELECT /*+ index(cond bsc_tmp_big_in_cond_n1)*/ value_v

Line 85: l_stmt := 'INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v)

81: numNewTables := numNewTables + sql%ROWCOUNT;
82: l_start_Time := sysdate;
83:
84: If numNewTables > 0 Then
85: l_stmt := 'INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v)
86: SELECT/*+ ordered */
87: distinct userenv(''SESSIONID''), 0, datab.TABLE_NAME
88: FROM
89: BSC_TMP_BIG_IN_COND tmp,

Line 106: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

102: InsertRelatedTables (numNewTables);
103: End If;
104: End If;
105:
106: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
107: bsc_mo_helper_pkg.writeTmp( 'Compl. InsertRelatedTables');
108: END IF;
109:
110: EXCEPTION WHEN OTHERS THEN

Line 130: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

126: l_error VARCHAR2(400);
127: l_start_time date := sysdate;
128:
129: BEGIN
130: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
131: bsc_mo_helper_pkg.writeTmp('Inside MarkIndicsAndTables');
132: END IF;
133: --Initialize the array garrTables the tables used by the indicators in the array garrIndics()
134: --EDW Integration note:

Line 139: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;

135: --In BSC_KPI_DATA_TABLES, Metadata Optimizer is storing the name of the view (Example: BSC_3001_0_0_5_V)
136: --and the name of the S table for BSC Kpis (Example: BSC_3002_0_0_5)
137: --In this procedure we need to get tables names from a view BSC_KPI_DATA_TABLES_V.
138:
139: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
140: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
141:
142: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics = 0 THEN
143: return;

Line 140: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;

136: --and the name of the S table for BSC Kpis (Example: BSC_3002_0_0_5)
137: --In this procedure we need to get tables names from a view BSC_KPI_DATA_TABLES_V.
138:
139: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
140: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
141:
142: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics = 0 THEN
143: return;
144: END IF;

Line 142: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics = 0 THEN

138:
139: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
140: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
141:
142: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics = 0 THEN
143: return;
144: END IF;
145:
146: l_stmt := 'delete '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND where session_id = userenv(''SESSIONID'') and variable_id = 0';

Line 146: l_stmt := 'delete '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND where session_id = userenv(''SESSIONID'') and variable_id = 0';

142: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics = 0 THEN
143: return;
144: END IF;
145:
146: l_stmt := 'delete '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND where session_id = userenv(''SESSIONID'') and variable_id = 0';
147: execute immediate l_stmt;
148:
149: strWhereInIndics := ' INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = '||TO_CHAR(pProcessId)||')';
150: strWhereNotInIndics := 'NOT ('|| strWhereInIndics ||')';

Line 152: l_stmt := 'INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v )

148:
149: strWhereInIndics := ' INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = '||TO_CHAR(pProcessId)||')';
150: strWhereNotInIndics := 'NOT ('|| strWhereInIndics ||')';
151:
152: l_stmt := 'INSERT INTO '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.BSC_TMP_BIG_IN_COND (session_id, variable_id, value_v )
153: SELECT DISTINCT userenv(''SESSIONID''), 0, TABLE_NAME FROM BSC_TMP_OPT_KPI_DATA DATA, BSC_TMP_OPT_UI_KPIS TMP
154: WHERE TMP.INDICATOR = DATA.INDICATOR AND TMP.PROCESS_ID = :1';
155: execute immediate l_stmt using pProcessId;
156:

Line 157: BSC_METADATA_OPTIMIZER_PKG.gnumTables := sql%rowcount;

153: SELECT DISTINCT userenv(''SESSIONID''), 0, TABLE_NAME FROM BSC_TMP_OPT_KPI_DATA DATA, BSC_TMP_OPT_UI_KPIS TMP
154: WHERE TMP.INDICATOR = DATA.INDICATOR AND TMP.PROCESS_ID = :1';
155: execute immediate l_stmt using pProcessId;
156:
157: BSC_METADATA_OPTIMIZER_PKG.gnumTables := sql%rowcount;
158:
159: IF BSC_METADATA_OPTIMIZER_PKG.gnumTables > 0 THEN
160: --Insert in the array garrTables() all the tables in the current
161: --graph that have any relation with them

Line 159: IF BSC_METADATA_OPTIMIZER_PKG.gnumTables > 0 THEN

155: execute immediate l_stmt using pProcessId;
156:
157: BSC_METADATA_OPTIMIZER_PKG.gnumTables := sql%rowcount;
158:
159: IF BSC_METADATA_OPTIMIZER_PKG.gnumTables > 0 THEN
160: --Insert in the array garrTables() all the tables in the current
161: --graph that have any relation with them
162: InsertRelatedTables(BSC_METADATA_OPTIMIZER_PKG.gnumTables);
163: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 162: InsertRelatedTables(BSC_METADATA_OPTIMIZER_PKG.gnumTables);

158:
159: IF BSC_METADATA_OPTIMIZER_PKG.gnumTables > 0 THEN
160: --Insert in the array garrTables() all the tables in the current
161: --graph that have any relation with them
162: InsertRelatedTables(BSC_METADATA_OPTIMIZER_PKG.gnumTables);
163: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
164: bsc_mo_helper_pkg.writeTmp('Done with InsertRelatedTables');
165: END IF;
166:

Line 163: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

159: IF BSC_METADATA_OPTIMIZER_PKG.gnumTables > 0 THEN
160: --Insert in the array garrTables() all the tables in the current
161: --graph that have any relation with them
162: InsertRelatedTables(BSC_METADATA_OPTIMIZER_PKG.gnumTables);
163: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
164: bsc_mo_helper_pkg.writeTmp('Done with InsertRelatedTables');
165: END IF;
166:
167: l_stmt := 'INSERT INTO BSC_TMP_OPT_UI_KPIS (INDICATOR, PROTOTYPE_FLAG, PROCESS_ID)

Line 174: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := BSC_METADATA_OPTIMIZER_PKG.gnumIndics + sql%ROWCOUNT;

170: (SELECT /*+ index(cond bsc_tmp_big_in_cond_n1)*/VALUE_V FROM BSC_TMP_BIG_IN_COND cond WHERE SESSION_ID = :2 )
171: AND INDICATOR NOT IN
172: (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = :3)';
173: execute immediate l_stmt using pProcessId, USERENV('SESSIONID'), pProcessId;
174: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := BSC_METADATA_OPTIMIZER_PKG.gnumIndics + sql%ROWCOUNT;
175: END IF;
176:
177: EXCEPTION WHEN OTHERS THEN
178: l_error := sqlerrm;

Line 218: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 <= 0 THEN

214: l_error varchar2(400);
215: l_stack VARCHAR2(32000);
216:
217: BEGIN
218: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 <= 0 THEN
219: return;
220: END IF;
221: --Init and array with the measures used by the indicators flagged for
222: --non-structural changes

Line 228: EXIT WHEN i=BSC_METADATA_OPTIMIZER_PKG.gnumIndics4;

224: numMeasures := 0;
225: strWhereInIndics := bsc_mo_helper_pkg.Get_New_Big_In_Cond_Number(9, 'I.INDICATOR');
226: i:= 0;
227: LOOP
228: EXIT WHEN i=BSC_METADATA_OPTIMIZER_PKG.gnumIndics4;
229: bsc_mo_helper_pkg.Add_Value_Big_In_Cond_Number( 9, BSC_METADATA_OPTIMIZER_PKG.garrIndics4(i));
230: i:=i+1;
231: END LOOP;
232:

Line 229: bsc_mo_helper_pkg.Add_Value_Big_In_Cond_Number( 9, BSC_METADATA_OPTIMIZER_PKG.garrIndics4(i));

225: strWhereInIndics := bsc_mo_helper_pkg.Get_New_Big_In_Cond_Number(9, 'I.INDICATOR');
226: i:= 0;
227: LOOP
228: EXIT WHEN i=BSC_METADATA_OPTIMIZER_PKG.gnumIndics4;
229: bsc_mo_helper_pkg.Add_Value_Big_In_Cond_Number( 9, BSC_METADATA_OPTIMIZER_PKG.garrIndics4(i));
230: i:=i+1;
231: END LOOP;
232:
233: --PMF-BSC Integration: Filter out PMF measures

Line 300: IF Not bsc_mo_helper_pkg.SearchNumberExists(BSC_METADATA_OPTIMIZER_PKG.garrIndics4, BSC_METADATA_OPTIMIZER_PKG.gnumIndics4, l_measureCol) THEN

296: open cv for L_stmt;
297: LOOP
298: fetch cv into l_measureCol;
299: EXIT WHEN cv%NOTFOUND;
300: IF Not bsc_mo_helper_pkg.SearchNumberExists(BSC_METADATA_OPTIMIZER_PKG.garrIndics4, BSC_METADATA_OPTIMIZER_PKG.gnumIndics4, l_measureCol) THEN
301: BSC_METADATA_OPTIMIZER_PKG.garrIndics4(BSC_METADATA_OPTIMIZER_PKG.gnumIndics4) := l_measureCol;
302: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 + 1;
303: END IF;
304: END Loop;

Line 301: BSC_METADATA_OPTIMIZER_PKG.garrIndics4(BSC_METADATA_OPTIMIZER_PKG.gnumIndics4) := l_measureCol;

297: LOOP
298: fetch cv into l_measureCol;
299: EXIT WHEN cv%NOTFOUND;
300: IF Not bsc_mo_helper_pkg.SearchNumberExists(BSC_METADATA_OPTIMIZER_PKG.garrIndics4, BSC_METADATA_OPTIMIZER_PKG.gnumIndics4, l_measureCol) THEN
301: BSC_METADATA_OPTIMIZER_PKG.garrIndics4(BSC_METADATA_OPTIMIZER_PKG.gnumIndics4) := l_measureCol;
302: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 + 1;
303: END IF;
304: END Loop;
305: close cv;

Line 302: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 + 1;

298: fetch cv into l_measureCol;
299: EXIT WHEN cv%NOTFOUND;
300: IF Not bsc_mo_helper_pkg.SearchNumberExists(BSC_METADATA_OPTIMIZER_PKG.garrIndics4, BSC_METADATA_OPTIMIZER_PKG.gnumIndics4, l_measureCol) THEN
301: BSC_METADATA_OPTIMIZER_PKG.garrIndics4(BSC_METADATA_OPTIMIZER_PKG.gnumIndics4) := l_measureCol;
302: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 + 1;
303: END IF;
304: END Loop;
305: close cv;
306: l_stack := l_stack ||' Check 5 ';

Line 309: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

305: close cv;
306: l_stack := l_stack ||' Check 5 ';
307: END IF;
308:
309: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
310: bsc_mo_helper_pkg.writeTmp('Completed MarkIndicsForNonStrucChanges', FND_LOG.LEVEL_PROCEDURE);
311: END IF;
312:
313: EXCEPTION WHEN OTHERS THEN

Line 347: dbms_stats.gather_table_stats(BSC_METADATA_OPTIMIZER_PKG.gBSCSchema, 'BSC_TMP_OPT_KPI_DATA');

343: l_stmt := 'CREATE GLOBAL TEMPORARY TABLE BSC_TMP_OPT_KPI_DATA (INDICATOR NUMBER, TABLE_NAME VARCHAR2(100)) ON COMMIT PRESERVE ROWS';
344: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_table, 'BSC_TMP_OPT_KPI_DATA');
345: l_stmt := 'create unique index bsc_tmp_opt_kpi_data_u1 on bsc_tmp_opt_kpi_data(indicator, table_name)';
346: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_index, 'BSC_TMP_OPT_KPI_DATA_U1');
347: dbms_stats.gather_table_stats(BSC_METADATA_OPTIMIZER_PKG.gBSCSchema, 'BSC_TMP_OPT_KPI_DATA');
348: dbms_stats.gather_index_stats(BSC_METADATA_OPTIMIZER_PKG.gBSCSchema, 'BSC_TMP_OPT_KPI_DATA_U1');
349: END IF;
350: -- table may not exist after upgrade, so have to make it dynamic
351: execute immediate 'DELETE BSC_TMP_OPT_KPI_DATA';

Line 348: dbms_stats.gather_index_stats(BSC_METADATA_OPTIMIZER_PKG.gBSCSchema, 'BSC_TMP_OPT_KPI_DATA_U1');

344: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_table, 'BSC_TMP_OPT_KPI_DATA');
345: l_stmt := 'create unique index bsc_tmp_opt_kpi_data_u1 on bsc_tmp_opt_kpi_data(indicator, table_name)';
346: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_index, 'BSC_TMP_OPT_KPI_DATA_U1');
347: dbms_stats.gather_table_stats(BSC_METADATA_OPTIMIZER_PKG.gBSCSchema, 'BSC_TMP_OPT_KPI_DATA');
348: dbms_stats.gather_index_stats(BSC_METADATA_OPTIMIZER_PKG.gBSCSchema, 'BSC_TMP_OPT_KPI_DATA_U1');
349: END IF;
350: -- table may not exist after upgrade, so have to make it dynamic
351: execute immediate 'DELETE BSC_TMP_OPT_KPI_DATA';
352: --l_stmt := 'INSERT INTO BSC_TMP_OPT_KPI_DATA

Line 427: BSC_METADATA_OPTIMIZER_PKG.g_log := false;

423: l_total_kpis NUMBER := 0;
424:
425: BEGIN
426: bsc_apps.init_bsc_apps;
427: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
428: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
429: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
430: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
431: END IF;

Line 428: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;

424:
425: BEGIN
426: bsc_apps.init_bsc_apps;
427: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
428: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
429: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
430: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
431: END IF;
432: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;

Line 429: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN

425: BEGIN
426: bsc_apps.init_bsc_apps;
427: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
428: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
429: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
430: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
431: END IF;
432: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
433: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;

Line 430: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;

426: bsc_apps.init_bsc_apps;
427: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
428: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
429: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
430: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
431: END IF;
432: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
433: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
434: BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;

Line 432: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;

428: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
429: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
430: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
431: END IF;
432: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
433: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
434: BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
435: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
436: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;

Line 433: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;

429: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
430: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
431: END IF;
432: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
433: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
434: BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
435: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
436: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
437: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;

Line 434: BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;

430: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
431: END IF;
432: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
433: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
434: BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
435: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
436: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
437: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
438:

Line 435: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;

431: END IF;
432: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
433: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
434: BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
435: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
436: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
437: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
438:
439: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_KPIS')) THEN

Line 436: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;

432: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
433: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
434: BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
435: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
436: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
437: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
438:
439: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_KPIS')) THEN
440: create_ui_kpi_table;

Line 437: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;

433: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
434: BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
435: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
436: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
437: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
438:
439: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_KPIS')) THEN
440: create_ui_kpi_table;
441: END IF;

Line 444: --truncateTable('BSC_TMP_OPT_UI_KPIS', BSC_METADATA_OPTIMIZER_PKG.gBSCSchema);

440: create_ui_kpi_table;
441: END IF;
442:
443: --EXECUTE IMMEDIATE 'delete BSC_TMP_OPT_UI_KPIS where process_Id = -200 or process_Id = 0 or process_Id is null';
444: --truncateTable('BSC_TMP_OPT_UI_KPIS', BSC_METADATA_OPTIMIZER_PKG.gBSCSchema);
445: l_stmt := 'DELETE BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = :1 ';
446: EXECUTE IMMEDIATE l_stmt USING pProcessId;
447: COMMIT;
448:

Line 457: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

453: FROM BSC_KPIS_VL
454: WHERE PROTOTYPE_FLAG NOT IN (1,2,3,4)';
455: execute immediate l_stmt USING pProcessId;
456: commit;
457: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
458: BSC_MO_HELPER_PKG.writeTmp( 'Completed updateRelatedIndicators');
459: END IF;
460: return;
461: end if;

Line 472: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

468: FROM BSC_KPIS_VL
469: WHERE BSC_DBGEN_UTILS.GET_OBJECTIVE_TYPE(SHORT_NAME) = :2 ';
470: execute immediate l_stmt USING pProcessId, 'OBJECTIVE';
471: commit;
472: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
473: BSC_MO_HELPER_PKG.writeTmp( 'Completed updateRelatedIndicators');
474: END IF;
475: return;
476: end if;

Line 488: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

484: execute immediate l_stmt USING pProcessId;
485:
486: IF (SQL%ROWCOUNT = l_total_kpis) THEN
487: commit;
488: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
489: BSC_MO_HELPER_PKG.writeTmp( 'Completed updateRelatedIndicators');
490: END IF;
491: return;
492: END If;

Line 494: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := SQL%ROWCOUNT;

490: END IF;
491: return;
492: END If;
493:
494: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := SQL%ROWCOUNT;
495: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
496: BSC_MO_HELPER_PKG.writeTmp('# of Indics = '||BSC_METADATA_OPTIMIZER_PKG.gnumIndics);
497: END IF;
498:

Line 495: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

491: return;
492: END If;
493:
494: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := SQL%ROWCOUNT;
495: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
496: BSC_MO_HELPER_PKG.writeTmp('# of Indics = '||BSC_METADATA_OPTIMIZER_PKG.gnumIndics);
497: END IF;
498:
499: MarkIndicsAndTables(pProcessId);

Line 496: BSC_MO_HELPER_PKG.writeTmp('# of Indics = '||BSC_METADATA_OPTIMIZER_PKG.gnumIndics);

492: END If;
493:
494: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := SQL%ROWCOUNT;
495: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
496: BSC_MO_HELPER_PKG.writeTmp('# of Indics = '||BSC_METADATA_OPTIMIZER_PKG.gnumIndics);
497: END IF;
498:
499: MarkIndicsAndTables(pProcessId);
500:

Line 501: BSC_METADATA_OPTIMIZER_PKG.gThereisStructureChange := False;

497: END IF;
498:
499: MarkIndicsAndTables(pProcessId);
500:
501: BSC_METADATA_OPTIMIZER_PKG.gThereisStructureChange := False;
502:
503: --Add indicators with flag = 4 (reconfigure update)
504: --in the collection gIndicadores
505: --Of course if the indicator is already in gIndicadores (Structural changes) we do not change it.

Line 517: BSC_METADATA_OPTIMIZER_PKG.garrIndics4(BSC_METADATA_OPTIMIZER_PKG.gnumIndics4) := l_indicator4;

513:
514: LOOP
515: fetch cv into l_indicator4;
516: exit when cv%NOTFOUND;
517: BSC_METADATA_OPTIMIZER_PKG.garrIndics4(BSC_METADATA_OPTIMIZER_PKG.gnumIndics4) := l_indicator4;
518: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 + 1;
519: END Loop;
520: close cv;
521:

Line 518: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 + 1;

514: LOOP
515: fetch cv into l_indicator4;
516: exit when cv%NOTFOUND;
517: BSC_METADATA_OPTIMIZER_PKG.garrIndics4(BSC_METADATA_OPTIMIZER_PKG.gnumIndics4) := l_indicator4;
518: BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 + 1;
519: END Loop;
520: close cv;
521:
522: --We need to add the related indicators. Designer is only flagging the indicators

Line 526: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 > 0 THEN

522: --We need to add the related indicators. Designer is only flagging the indicators
523: --that are using the measure direclty. We need to flag other indicators
524: --using the same measures alone or as part of a formula.
525:
526: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 > 0 THEN
527: CreateDBMeasureByKpiView;
528: MarkIndicsForNonStrucChanges;
529: --Add the indicators from garrIndics4() to gIndicadores
530: strWhereInIndics4 := BSC_MO_HELPER_PKG.Get_New_Big_In_Cond_Number( 2, 'INDICATOR');

Line 533: exit when i = BSC_METADATA_OPTIMIZER_PKG.gnumIndics4;

529: --Add the indicators from garrIndics4() to gIndicadores
530: strWhereInIndics4 := BSC_MO_HELPER_PKG.Get_New_Big_In_Cond_Number( 2, 'INDICATOR');
531: i:= 0;
532: LOOP
533: exit when i = BSC_METADATA_OPTIMIZER_PKG.gnumIndics4;
534: BSC_MO_HELPER_PKG.Add_Value_Big_In_Cond_Number( 2, BSC_METADATA_OPTIMIZER_PKG.garrIndics4(i));
535: i:= i+1;
536: END LOOP;
537: strWhereNotInIndics4 := 'NOT (' || strWhereInIndics4 || ')';

Line 534: BSC_MO_HELPER_PKG.Add_Value_Big_In_Cond_Number( 2, BSC_METADATA_OPTIMIZER_PKG.garrIndics4(i));

530: strWhereInIndics4 := BSC_MO_HELPER_PKG.Get_New_Big_In_Cond_Number( 2, 'INDICATOR');
531: i:= 0;
532: LOOP
533: exit when i = BSC_METADATA_OPTIMIZER_PKG.gnumIndics4;
534: BSC_MO_HELPER_PKG.Add_Value_Big_In_Cond_Number( 2, BSC_METADATA_OPTIMIZER_PKG.garrIndics4(i));
535: i:= i+1;
536: END LOOP;
537: strWhereNotInIndics4 := 'NOT (' || strWhereInIndics4 || ')';
538: l_stmt := 'INSERT INTO BSC_TMP_OPT_UI_KPIS( INDICATOR, PROTOTYPE_FLAG, process_id)

Line 541: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics > 0 THEN

537: strWhereNotInIndics4 := 'NOT (' || strWhereInIndics4 || ')';
538: l_stmt := 'INSERT INTO BSC_TMP_OPT_UI_KPIS( INDICATOR, PROTOTYPE_FLAG, process_id)
539: SELECT DISTINCT INDICATOR, 4, :1
540: FROM BSC_KPIS_VL WHERE (' || strWhereInIndics4 || ')';
541: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics > 0 THEN
542: l_stmt := l_stmt || ' minus select indicator, 4, :2 from BSC_TMP_OPT_ui_kpis WHERE process_id = :3 ';
543: execute immediate l_stmt USING pProcessId, pProcessId, pProcessId;
544: ELSE
545: execute immediate l_stmt USING pProcessId;

Line 549: IF BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change <> 0 THEN

545: execute immediate l_stmt USING pProcessId;
546: END IF;
547: END IF;
548:
549: IF BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change <> 0 THEN
550: -- summarization change, add production indicators to the list.
551: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
552: SELECT INDICATOR, prototype_flag, :1 FROM BSC_KPIS_VL a
553: WHERE NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS b WHERE process_id = :2 and a.indicator = b.indicator)';

Line 590: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

586: execute immediate l_stmt USING pProcessId;
587: END IF;
588: commit;
589:
590: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
591: BSC_MO_HELPER_PKG.writeTmp( 'Completed updateRelatedIndicators');
592: END IF;
593:
594: EXCEPTION WHEN OTHERS THEN

Line 618: BSC_METADATA_OPTIMIZER_PKG.g_log := false;

614: END IF;
615:
616: bsc_apps.init_bsc_apps;
617:
618: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
619: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
620:
621: pStatus := 'N';
622: pMessage := null;

Line 619: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;

615:
616: bsc_apps.init_bsc_apps;
617:
618: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
619: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
620:
621: pStatus := 'N';
622: pMessage := null;
623:

Line 626: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN

622: pMessage := null;
623:
624: -- Bug 3830308 : Added owner clause because of new GSCC validation added on aug 9, 2004
625: --------------
626: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
627: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
628: END IF;
629:
630: IF BSC_METADATA_OPTIMIZER_PKG.gAppsSchema IS NULL THEN

Line 627: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;

623:
624: -- Bug 3830308 : Added owner clause because of new GSCC validation added on aug 9, 2004
625: --------------
626: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
627: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
628: END IF;
629:
630: IF BSC_METADATA_OPTIMIZER_PKG.gAppsSchema IS NULL THEN
631: BSC_METADATA_OPTIMIZER_PKG.gAppsSchema := BSC_MO_HELPER_PKG.getAppsSchema;

Line 630: IF BSC_METADATA_OPTIMIZER_PKG.gAppsSchema IS NULL THEN

626: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
627: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
628: END IF;
629:
630: IF BSC_METADATA_OPTIMIZER_PKG.gAppsSchema IS NULL THEN
631: BSC_METADATA_OPTIMIZER_PKG.gAppsSchema := BSC_MO_HELPER_PKG.getAppsSchema;
632: END IF;
633: --------------
634: -- Check if table already exists

Line 631: BSC_METADATA_OPTIMIZER_PKG.gAppsSchema := BSC_MO_HELPER_PKG.getAppsSchema;

627: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
628: END IF;
629:
630: IF BSC_METADATA_OPTIMIZER_PKG.gAppsSchema IS NULL THEN
631: BSC_METADATA_OPTIMIZER_PKG.gAppsSchema := BSC_MO_HELPER_PKG.getAppsSchema;
632: END IF;
633: --------------
634: -- Check if table already exists
635: -- Bug 3830308 : Added owner clause because of new GSCC validation added on aug 9, 2004

Line 638: and owner IN (BSC_METADATA_OPTIMIZER_PKG.gBSCSchema, BSC_METADATA_OPTIMIZER_PKG.gAppsSchema);

634: -- Check if table already exists
635: -- Bug 3830308 : Added owner clause because of new GSCC validation added on aug 9, 2004
636: select count(1) INTO l_count
637: from all_objects where object_name = pNew
638: and owner IN (BSC_METADATA_OPTIMIZER_PKG.gBSCSchema, BSC_METADATA_OPTIMIZER_PKG.gAppsSchema);
639:
640: IF (l_count > 0) THEN
641: fnd_message.set_name('BSC', 'BSC_DUPLICATED_TABLENAME');
642: pMessage := fnd_message.get;

Line 657: execute immediate 'alter table '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||pOld||' rename to '||pNew;

653: --BSC_DB_TABLES_RELS
654: UPDATE BSC_DB_TABLES_RELS set source_table_name = pNew where source_table_name = pOld;
655:
656: -- Need not update BSC_DB_CALCULATIONS as it wont have anything for Input tables
657: execute immediate 'alter table '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||pOld||' rename to '||pNew;
658: begin
659: execute immediate 'drop synonym '||pOld;
660: exception when others then
661: null;

Line 663: execute immediate 'create synonym '||pNew||' for '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||pNew;

659: execute immediate 'drop synonym '||pOld;
660: exception when others then
661: null;
662: end;
663: execute immediate 'create synonym '||pNew||' for '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||pNew;
664: --BSC_MO_HELPER_PKG.createCopyTable(pOld, pNew, BSC_APPS.get_tablespace_name(BSC_APPS.input_table_tbs_type));
665: --BSC_MO_HELPER_PKG.CreateCopyIndexes (pOld, pNew, BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type));
666: --BSC_MO_HELPER_PKG.dropTable(pOld);
667: pStatus := 'Y';

Line 704: IF (BSC_METADATA_OPTIMIZER_PKG.gUIAPI) THEN

700: INDICATOR = pIndicator;
701: cIndAPI cAPI%ROWTYPE;
702:
703: BEGIN
704: IF (BSC_METADATA_OPTIMIZER_PKG.gUIAPI) THEN
705: -- need to initialize gIndicators with this Ind
706: OPEN cAPI;
707: FETCH cAPI INTO cIndAPI;
708: BSC_MO_HELPER_PKG.AddIndicator( BSC_METADATA_OPTIMIZER_PKG.gIndicators, cIndAPI.Indicator, cIndAPI.name,

Line 708: BSC_MO_HELPER_PKG.AddIndicator( BSC_METADATA_OPTIMIZER_PKG.gIndicators, cIndAPI.Indicator, cIndAPI.name,

704: IF (BSC_METADATA_OPTIMIZER_PKG.gUIAPI) THEN
705: -- need to initialize gIndicators with this Ind
706: OPEN cAPI;
707: FETCH cAPI INTO cIndAPI;
708: BSC_MO_HELPER_PKG.AddIndicator( BSC_METADATA_OPTIMIZER_PKG.gIndicators, cIndAPI.Indicator, cIndAPI.name,
709: cIndAPI.indicator_type, cIndAPI.Config_Type,
710: cIndAPI.periodicity_id, 1, cIndAPI.prototype_flag, cIndAPI.share_flag,
711: cIndAPI.source_indicator, cIndAPI.edw_flag, 1);
712: END IF;

Line 733: p_levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels ) IS

729:
730:
731: PROCEDURE insert_dimension_set (--pReturnArray IN OUT tab_clsIndicatorLevels,
732: pIndicator IN NUMBER, p_set IN NUMBER,
733: p_levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels ) IS
734: l_groupids DBMS_SQL.NUMBER_TABLE;
735: l_dim_index NUMBER;
736:
737: l_level_index NUMBER :=0 ;

Line 740: DimensionLevels BSC_METADATA_OPTIMIZER_PKG.Tab_clsLevels;

736:
737: l_level_index NUMBER :=0 ;
738: l_stmt VARCHAR2(300) := ' INSERT INTO BSC_TMP_OPT_UI_LEVELS (INDICATOR, DIM_SET_ID, DIM_DISPLAY_ORDER, LEVEL_DISPLAY_ORDER, LEVEL_TABLE_NAME, LEVEL_DISPLAY_NAME) '||
739: ' values (:1, :2, :3, :4, :5, :6)';
740: DimensionLevels BSC_METADATA_OPTIMIZER_PKG.Tab_clsLevels;
741:
742: --l_indLevel clsIndicatorLevels;
743:
744: BEGIN

Line 772: l_levels BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels ;

768:
769: PROCEDURE GetLevelsForIndicator(pIndicator IN NUMBER) IS -- RETURN tab_clsIndicatorLevels IS
770: l_stmt VARCHAR2(1000);
771: l_count NUMBER;
772: l_levels BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels ;
773: colConfigurations DBMS_SQL.NUMBER_TABLE;
774: l_config_index NUMBER;
775: l_insert_count NUMBER := 0;
776: cv CurTyp;

Line 778: BSC_METADATA_OPTIMIZER_PKG.g_log := false;

774: l_config_index NUMBER;
775: l_insert_count NUMBER := 0;
776: cv CurTyp;
777: BEGIN
778: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
779: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
780: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
781: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
782: END IF;

Line 779: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;

775: l_insert_count NUMBER := 0;
776: cv CurTyp;
777: BEGIN
778: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
779: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
780: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
781: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
782: END IF;
783: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_LEVELS')) THEN

Line 780: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN

776: cv CurTyp;
777: BEGIN
778: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
779: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
780: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
781: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
782: END IF;
783: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_LEVELS')) THEN
784: create_ui_table;

Line 781: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;

777: BEGIN
778: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
779: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
780: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
781: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
782: END IF;
783: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_LEVELS')) THEN
784: create_ui_table;
785: ELSE

Line 869: BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV := False;

865: BEGIN
866: l_table_name := pTableName;
867:
868: If fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL') IS NULL Then
869: BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV := False;
870: Else
871: BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV := True;
872: End If;
873:

Line 871: BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV := True;

867:
868: If fnd_profile.value('BSC_ADVANCED_SUMMARIZATION_LEVEL') IS NULL Then
869: BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV := False;
870: Else
871: BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV := True;
872: End If;
873:
874: If BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV Then
875:

Line 874: If BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV Then

870: Else
871: BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV := True;
872: End If;
873:
874: If BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV Then
875:
876: select count(1) into l_test from bsc_db_tables tab, bsc_db_tables_rels rels
877: where rels.table_name = l_table_name
878: and rels.source_table_name = tab.table_name

Line 942: If (BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV And (cRow1.Table_Type = 0 Or isBaseTable)) Or (Not BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV) Then

938: l_description := BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_BACKEND', 'TYPE1_PLAN');
939: END IF;
940: ElsIf UPPER(pColumnName) = UPPER(NomCampoPeriod) Then
941:
942: If (BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV And (cRow1.Table_Type = 0 Or isBaseTable)) Or (Not BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV) Then
943:
944: If Yearly_Flag = 1 Then
945: l_description := l_description || '0'; --bug#3980028
946: Else

Line 1207: BSC_METADATA_OPTIMIZER_PKG.g_log := false;

1203: IF LENGTH(pKPIList) <= 0 THEN
1204: RETURN;
1205: END IF;
1206:
1207: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
1208: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
1209: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
1210: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
1211: END IF;

Line 1208: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;

1204: RETURN;
1205: END IF;
1206:
1207: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
1208: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
1209: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
1210: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
1211: END IF;
1212:

Line 1209: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN

1205: END IF;
1206:
1207: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
1208: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
1209: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
1210: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
1211: END IF;
1212:
1213: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_KPIS')) THEN

Line 1210: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;

1206:
1207: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
1208: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
1209: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
1210: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
1211: END IF;
1212:
1213: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_KPIS')) THEN
1214: create_ui_kpi_table;

Line 1223: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;

1219: l_stmt := 'DELETE BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = :1 ';
1220: EXECUTE IMMEDIATE l_stmt USING pProcessId;
1221: COMMIT;
1222:
1223: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
1224: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
1225: --BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
1226: --BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
1227: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;

Line 1224: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;

1220: EXECUTE IMMEDIATE l_stmt USING pProcessId;
1221: COMMIT;
1222:
1223: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
1224: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
1225: --BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
1226: --BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
1227: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
1228: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;

Line 1225: --BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;

1221: COMMIT;
1222:
1223: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
1224: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
1225: --BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
1226: --BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
1227: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
1228: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
1229:

Line 1226: --BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;

1222:
1223: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
1224: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
1225: --BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
1226: --BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
1227: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
1228: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
1229:
1230: l_cur_pos := 1;

Line 1227: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;

1223: BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;
1224: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
1225: --BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
1226: --BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
1227: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
1228: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
1229:
1230: l_cur_pos := 1;
1231: l_old_pos := 1;

Line 1228: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;

1224: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := 0;
1225: --BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;
1226: --BSC_METADATA_OPTIMIZER_PKG.gnumIndics4 := 0;
1227: BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;
1228: BSC_METADATA_OPTIMIZER_PKG.gnumTables := 0;
1229:
1230: l_cur_pos := 1;
1231: l_old_pos := 1;
1232: l_selected_kpis := 0;

Line 1260: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := l_selected_kpis;

1256: IF (l_selected_kpis = l_total_kpis) THEN
1257: COMMIT;
1258: RETURN;
1259: END IF;
1260: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := l_selected_kpis;
1261: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1262: BSC_MO_HELPER_PKG.writeTmp('# of Indics = '||BSC_METADATA_OPTIMIZER_PKG.gnumIndics);
1263: END IF;
1264:

Line 1261: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

1257: COMMIT;
1258: RETURN;
1259: END IF;
1260: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := l_selected_kpis;
1261: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1262: BSC_MO_HELPER_PKG.writeTmp('# of Indics = '||BSC_METADATA_OPTIMIZER_PKG.gnumIndics);
1263: END IF;
1264:
1265: MarkIndicsAndTables(pProcessId);

Line 1262: BSC_MO_HELPER_PKG.writeTmp('# of Indics = '||BSC_METADATA_OPTIMIZER_PKG.gnumIndics);

1258: RETURN;
1259: END IF;
1260: BSC_METADATA_OPTIMIZER_PKG.gnumIndics := l_selected_kpis;
1261: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1262: BSC_MO_HELPER_PKG.writeTmp('# of Indics = '||BSC_METADATA_OPTIMIZER_PKG.gnumIndics);
1263: END IF;
1264:
1265: MarkIndicsAndTables(pProcessId);
1266:

Line 1281: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

1277: AND t.PROCESS_ID = :2
1278: AND NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS c WHERE c.indicator = k.indicator AND c.PROCESS_ID = :3)';
1279: EXECUTE IMMEDIATE l_stmt using pProcessId, pProcessId, pProcessId;
1280:
1281: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1282: BSC_MO_HELPER_PKG.writeTmp( 'Completed getRelatedIndicators');
1283: END IF;
1284: COMMIT;
1285:

Line 1302: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

1298: -- Remove entries in BSC_TMP_OPT_UI_KPIS
1299: PROCEDURE cleanUITempTable IS
1300: l_del_stmt varchar2(2000);
1301: BEGIN
1302: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1303: BSC_MO_HELPER_PKG.writeTmp( 'Started cleanUITempTable');
1304: END IF;
1305:
1306: -- Removed entries for concurrent requests that were finished

Line 1330: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

1326: FROM ICX_SESSIONS
1327: WHERE (FND_SESSION_MANAGEMENT.CHECK_SESSION(SESSION_ID,NULL,NULL,'N') = 'VALID'));
1328: COMMIT;
1329:
1330: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1331: BSC_MO_HELPER_PKG.writeTmp( 'Completed cleanUITempTable');
1332: END IF;
1333:
1334: EXCEPTION WHEN OTHERS THEN