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_TMP_OPT_UI_KPIS

Line 149: strWhereInIndics := ' INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = '||TO_CHAR(pProcessId)||')';

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 ||')';
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

Line 153: SELECT DISTINCT userenv(''SESSIONID''), 0, TABLE_NAME FROM BSC_TMP_OPT_KPI_DATA DATA, BSC_TMP_OPT_UI_KPIS TMP

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:
157: BSC_METADATA_OPTIMIZER_PKG.gnumTables := sql%rowcount;

Line 167: l_stmt := 'INSERT INTO BSC_TMP_OPT_UI_KPIS (INDICATOR, PROTOTYPE_FLAG, PROCESS_ID)

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)
168: SELECT DISTINCT INDICATOR, 3, :1 FROM BSC_TMP_OPT_KPI_DATA
169: WHERE TABLE_NAME IN
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

Line 172: (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = :3)';

168: SELECT DISTINCT INDICATOR, 3, :1 FROM BSC_TMP_OPT_KPI_DATA
169: WHERE TABLE_NAME IN
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:

Line 322: l_stmt varchar2(1000) := 'CREATE /GLOBAL TEMPORARY / TABLE BSC_TMP_OPT_UI_KPIS(

318: End;
319:
320:
321: PROCEDURE create_ui_kpi_table IS
322: l_stmt varchar2(1000) := 'CREATE /*GLOBAL TEMPORARY */ TABLE BSC_TMP_OPT_UI_KPIS(
323: INDICATOR NUMBER, PROTOTYPE_FLAG NUMBER, PROCESS_ID NUMBER) ';
324:
325: --PRAGMA AUTONOMOUS_TRANSACTION;
326: BEGIN

Line 327: --bsc_mo_helper_pkg.dropTable('BSC_TMP_OPT_UI_KPIS');

323: INDICATOR NUMBER, PROTOTYPE_FLAG NUMBER, PROCESS_ID NUMBER) ';
324:
325: --PRAGMA AUTONOMOUS_TRANSACTION;
326: BEGIN
327: --bsc_mo_helper_pkg.dropTable('BSC_TMP_OPT_UI_KPIS');
328: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_table, 'BSC_TMP_OPT_UI_KPIS');
329: --commit;
330: END;
331:

Line 328: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_table, 'BSC_TMP_OPT_UI_KPIS');

324:
325: --PRAGMA AUTONOMOUS_TRANSACTION;
326: BEGIN
327: --bsc_mo_helper_pkg.dropTable('BSC_TMP_OPT_UI_KPIS');
328: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.create_table, 'BSC_TMP_OPT_UI_KPIS');
329: --commit;
330: END;
331:
332: --Procedure added for bug 3911548

Line 439: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_KPIS')) THEN

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;
442:
443: --EXECUTE IMMEDIATE 'delete BSC_TMP_OPT_UI_KPIS where process_Id = -200 or process_Id = 0 or process_Id is null';

Line 443: --EXECUTE IMMEDIATE 'delete BSC_TMP_OPT_UI_KPIS where process_Id = -200 or process_Id = 0 or process_Id is null';

439: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_KPIS')) THEN
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;

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 445: l_stmt := 'DELETE BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = :1 ';

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:
449: -- Default list for Selected Objectives

Line 451: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)

447: COMMIT;
448:
449: -- Default list for Selected Objectives
450: if (pMode = 'SELECTED' OR pMode = 'SELECTED_REPORTS' OR pMode = 'SELECTED_SIMULATIONS') then
451: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
452: SELECT INDICATOR, prototype_flag, :1
453: FROM BSC_KPIS_VL
454: WHERE PROTOTYPE_FLAG NOT IN (1,2,3,4)';
455: execute immediate l_stmt USING pProcessId;

Line 466: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)

462:
463: create_tmp_opt_kpi_data;
464:
465: if (pMode = 'ALL') THEN
466: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
467: SELECT INDICATOR, prototype_flag, :1
468: FROM BSC_KPIS_VL
469: WHERE BSC_DBGEN_UTILS.GET_OBJECTIVE_TYPE(SHORT_NAME) = :2 ';
470: execute immediate l_stmt USING pProcessId, 'OBJECTIVE';

Line 480: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)

476: end if;
477:
478: -- Only Modified mode, now, all other Modes would have returned.
479: SELECT count(1) INTO l_total_kpis FROM BSC_KPIS_B;
480: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
481: SELECT INDICATOR, prototype_flag, :1
482: FROM BSC_KPIS_VL
483: WHERE (PROTOTYPE_FLAG = 2 OR PROTOTYPE_FLAG = 3) ';
484: execute immediate l_stmt USING pProcessId;

Line 510: SELECT INDICATOR FROM BSC_TMP_OPT_ui_kpis WHERE process_id = :1

506: --Init an array with the Kpis in prototype 4 (changes in loader configuration)
507:
508: l_stmt := 'SELECT INDICATOR FROM BSC_KPIS_B WHERE PROTOTYPE_FLAG = 4
509: MINUS
510: SELECT INDICATOR FROM BSC_TMP_OPT_ui_kpis WHERE process_id = :1
511: ORDER BY INDICATOR';
512: open cv for l_stmt USING pProcessId;
513:
514: LOOP

Line 538: l_stmt := 'INSERT INTO BSC_TMP_OPT_UI_KPIS( INDICATOR, PROTOTYPE_FLAG, process_id)

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)
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 ';

Line 542: l_stmt := l_stmt || ' minus select indicator, 4, :2 from BSC_TMP_OPT_ui_kpis WHERE process_id = :3 ';

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;
546: END IF;

Line 551: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)

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)';
554: execute immediate l_stmt USING pProcessId, pProcessId;
555:

Line 553: WHERE NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS b WHERE process_id = :2 and a.indicator = b.indicator)';

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)';
554: execute immediate l_stmt USING pProcessId, pProcessId;
555:
556: END IF;
557:

Line 559: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)

555:
556: END IF;
557:
558: -- take care of shared kpis, which are NOT marked by the builder, just in case
559: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
560: SELECT child.INDICATOR, parent.prototype_flag, :1
561: FROM BSC_KPIS_VL parent,
562: BSC_KPIS_VL child,
563: BSC_TMP_OPT_UI_KPIS uitmp

Line 563: BSC_TMP_OPT_UI_KPIS uitmp

559: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
560: SELECT child.INDICATOR, parent.prototype_flag, :1
561: FROM BSC_KPIS_VL parent,
562: BSC_KPIS_VL child,
563: BSC_TMP_OPT_UI_KPIS uitmp
564: where uitmp.indicator = parent.indicator
565: and uitmp.process_id = :2
566: and parent.share_flag = 1
567: and child.share_flag = 2

Line 569: AND NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS c WHERE process_id = :3 and c.indicator = child.indicator)';

565: and uitmp.process_id = :2
566: and parent.share_flag = 1
567: and child.share_flag = 2
568: and parent.indicator = child.source_indicator
569: AND NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS c WHERE process_id = :3 and c.indicator = child.indicator)';
570: execute immediate l_stmt USING pProcessId, pProcessId, pProcessId;
571:
572: -- insert remaining KPIS finally, UI wants it
573: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)

Line 573: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)

569: AND NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS c WHERE process_id = :3 and c.indicator = child.indicator)';
570: execute immediate l_stmt USING pProcessId, pProcessId, pProcessId;
571:
572: -- insert remaining KPIS finally, UI wants it
573: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
574: SELECT INDICATOR, prototype_flag, :1 FROM BSC_KPIS_VL a
575: WHERE NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS b WHERE process_id = :2 and a.indicator = b.indicator)';
576: execute immediate l_stmt USING pProcessId, pProcessId;
577:

Line 575: WHERE NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS b WHERE process_id = :2 and a.indicator = b.indicator)';

571:
572: -- insert remaining KPIS finally, UI wants it
573: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
574: SELECT INDICATOR, prototype_flag, :1 FROM BSC_KPIS_VL a
575: WHERE NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS b WHERE process_id = :2 and a.indicator = b.indicator)';
576: execute immediate l_stmt USING pProcessId, pProcessId;
577:
578: -- Get rid of the autogen. report generated objectives for ALL and MODIFIED modes
579: IF (pMode='MODIFIED') THEN

Line 580: l_stmt := 'delete from BSC_TMP_OPT_UI_KPIS tmp

576: execute immediate l_stmt USING pProcessId, pProcessId;
577:
578: -- Get rid of the autogen. report generated objectives for ALL and MODIFIED modes
579: IF (pMode='MODIFIED') THEN
580: l_stmt := 'delete from BSC_TMP_OPT_UI_KPIS tmp
581: where process_id = :1
582: and indicator in
583: (select indicator from bsc_kpis_vl kpis
584: where kpis.short_name is not null

Line 1213: IF (NOT BSC_MO_HELPER_PKG.tableExists('BSC_TMP_OPT_UI_KPIS')) THEN

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;
1215: END IF;
1216: create_tmp_opt_kpi_data;
1217:

Line 1218: --EXECUTE IMMEDIATE 'DELETE BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = -200 OR PROCESS_ID = 0 OR PROCESS_ID IS NULL';

1214: create_ui_kpi_table;
1215: END IF;
1216: create_tmp_opt_kpi_data;
1217:
1218: --EXECUTE IMMEDIATE 'DELETE BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = -200 OR PROCESS_ID = 0 OR PROCESS_ID IS NULL';
1219: l_stmt := 'DELETE BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = :1 ';
1220: EXECUTE IMMEDIATE l_stmt USING pProcessId;
1221: COMMIT;
1222:

Line 1219: l_stmt := 'DELETE BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = :1 ';

1215: END IF;
1216: create_tmp_opt_kpi_data;
1217:
1218: --EXECUTE IMMEDIATE 'DELETE BSC_TMP_OPT_UI_KPIS WHERE PROCESS_ID = -200 OR PROCESS_ID = 0 OR PROCESS_ID IS NULL';
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;

Line 1243: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)

1239: l_cur_kpi := SUBSTR(pKPIList, l_old_pos, l_cur_pos-l_old_pos);
1240: END IF;
1241: --DBMS_OUTPUT.PUT_LINE(TO_CHAR(l_selected_kpis)||' '||l_cur_kpi);
1242: IF LENGTH(l_cur_kpi) > 0 THEN
1243: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
1244: SELECT INDICATOR, PROTOTYPE_FLAG, :1
1245: FROM BSC_KPIS_B
1246: WHERE INDICATOR = :2 ';
1247: EXECUTE IMMEDIATE l_stmt using pProcessId, l_cur_kpi;

Line 1268: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)

1264:
1265: MarkIndicsAndTables(pProcessId);
1266:
1267: -- take care of shared kpis
1268: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
1269: SELECT k.INDICATOR, k.PROTOTYPE_FLAG, :1
1270: FROM BSC_KPIS_VL k,
1271: BSC_TMP_OPT_UI_KPIS t
1272: WHERE ((k.SHARE_FLAG = 2 AND k.SOURCE_INDICATOR = t.INDICATOR)

Line 1271: BSC_TMP_OPT_UI_KPIS t

1267: -- take care of shared kpis
1268: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
1269: SELECT k.INDICATOR, k.PROTOTYPE_FLAG, :1
1270: FROM BSC_KPIS_VL k,
1271: BSC_TMP_OPT_UI_KPIS t
1272: WHERE ((k.SHARE_FLAG = 2 AND k.SOURCE_INDICATOR = t.INDICATOR)
1273: OR (k.SHARE_FLAG = 2 AND k.SOURCE_INDICATOR IN
1274: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR))
1275: OR (k.SHARE_FLAG = 1 AND k.INDICATOR IN

Line 1278: AND NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS c WHERE c.indicator = k.indicator AND c.PROCESS_ID = :3)';

1274: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR))
1275: OR (k.SHARE_FLAG = 1 AND k.INDICATOR IN
1276: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR)))
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');

Line 1298: -- Remove entries in BSC_TMP_OPT_UI_KPIS

1294: BEGIN
1295: delete bsc_current_sessions where session_id = pSession;
1296: END;
1297:
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

Line 1307: DELETE BSC_TMP_OPT_UI_KPIS

1303: BSC_MO_HELPER_PKG.writeTmp( 'Started cleanUITempTable');
1304: END IF;
1305:
1306: -- Removed entries for concurrent requests that were finished
1307: DELETE BSC_TMP_OPT_UI_KPIS
1308: WHERE PROCESS_ID > 0
1309: AND TO_CHAR(PROCESS_ID) NOT IN (
1310: SELECT /*+ INDEX(R FND_CONCURRENT_REQUESTS_N6)*/ R.ARGUMENT2
1311: FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROGRAMS_VL P, FND_APPLICATION A

Line 1322: DELETE BSC_TMP_OPT_UI_KPIS

1318: AND R.ARGUMENT2 IS NOT NULL);
1319: COMMIT;
1320:
1321: -- Removed entries for invalid ui sessions
1322: DELETE BSC_TMP_OPT_UI_KPIS
1323: WHERE PROCESS_ID < 0
1324: AND PROCESS_ID NOT IN (
1325: SELECT SESSION_ID*-1
1326: FROM ICX_SESSIONS

Line 1341: This procedure loops through the BSC_TMP_OPT_UI_KPIS table and checks

1337: END;
1338:
1339: /*------------------------------------------------------------------------------------------
1340: Procedure checkSystemLock
1341: This procedure loops through the BSC_TMP_OPT_UI_KPIS table and checks
1342: for locks for all the Objectives corresponding to the process_id
1343:
1344: p_all_objectives: 1 = all, 0 = modified or selected
1345: p_program_id: The program ID

Line 1365: FROM BSC_TMP_OPT_UI_KPIS

1361: CURSOR c_get_all_objectives(
1362: c_process_id NUMBER
1363: ) IS
1364: SELECT DISTINCT INDICATOR
1365: FROM BSC_TMP_OPT_UI_KPIS
1366: WHERE PROCESS_ID = c_process_id;
1367:
1368: CURSOR c_get_objectives(
1369: c_process_id NUMBER

Line 1372: FROM BSC_TMP_OPT_UI_KPIS

1368: CURSOR c_get_objectives(
1369: c_process_id NUMBER
1370: ) IS
1371: SELECT DISTINCT INDICATOR
1372: FROM BSC_TMP_OPT_UI_KPIS
1373: WHERE PROCESS_ID = c_process_id
1374: AND PROTOTYPE_FLAG IN (1,2,3,4,-3);
1375:
1376: BEGIN

Line 1454: This procedure loops through the BSC_TMP_OPT_UI_KPIS table

1450: END checkSystemLock;
1451:
1452: /*------------------------------------------------------------------------------------------
1453: Procedure getSystemLock
1454: This procedure loops through the BSC_TMP_OPT_UI_KPIS table
1455: and locks all the Objectives corresponding to the process_id
1456:
1457: p_all_objectives: 1 = all, 0 = modified or selected
1458: p_program_id: The program ID

Line 1480: FROM BSC_TMP_OPT_UI_KPIS

1476: CURSOR c_get_all_objectives(
1477: c_process_id NUMBER
1478: ) IS
1479: SELECT INDICATOR
1480: FROM BSC_TMP_OPT_UI_KPIS
1481: WHERE PROCESS_ID = c_process_id;
1482:
1483: CURSOR c_get_objectives(
1484: c_process_id NUMBER

Line 1487: FROM BSC_TMP_OPT_UI_KPIS

1483: CURSOR c_get_objectives(
1484: c_process_id NUMBER
1485: ) IS
1486: SELECT DISTINCT INDICATOR
1487: FROM BSC_TMP_OPT_UI_KPIS
1488: WHERE PROCESS_ID = c_process_id
1489: AND PROTOTYPE_FLAG IN (1,2,3,4,-3);
1490:
1491: BEGIN