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_DESIGNER_PVT dependencies on BSC_KPI_DEFAULTS_B

Line 162: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DEFAULTS_B';

158: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
159: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
160:
161: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
162: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DEFAULTS_B';
163: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
164: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
165: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
166: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 552: IF UPPER(p_table_name) = 'BSC_KPI_DEFAULTS_B' Or UPPER(p_table_name) = 'BSC_KPI_DEFAULTS_TL' THEN

548: h_sql:= h_sql || ' WHERE ' || h_condition;
549: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
550: --DBMS_OUTPUT.PUT_LINE(' Insertred into table :-' || p_table_name);
551: --BUG 1224991
552: IF UPPER(p_table_name) = 'BSC_KPI_DEFAULTS_B' Or UPPER(p_table_name) = 'BSC_KPI_DEFAULTS_TL' THEN
553: h_sql:= 'UPDATE ' || p_table_name;
554: h_sql:= h_sql || ' SET TAB_ID = (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR =:1)'; --|| x_Trg_kpi || ')';
555: h_sql:= h_sql || ' WHERE INDICATOR = :2'; --|| x_Trg_kpi;
556: Execute Immediate h_sql USING p_Trg_kpi, p_Trg_kpi;

Line 725: DELETE BSC_KPI_DEFAULTS_B

721: h_indicator NUMBER;
722:
723: BEGIN
724: --Clean invalid record in
725: DELETE BSC_KPI_DEFAULTS_B
726: WHERE (TAB_ID,INDICATOR) IN
727: (SELECT TAB_ID,INDICATOR
728: FROM BSC_KPI_DEFAULTS_B
729: WHERE (TAB_ID,INDICATOR) NOT IN

Line 728: FROM BSC_KPI_DEFAULTS_B

724: --Clean invalid record in
725: DELETE BSC_KPI_DEFAULTS_B
726: WHERE (TAB_ID,INDICATOR) IN
727: (SELECT TAB_ID,INDICATOR
728: FROM BSC_KPI_DEFAULTS_B
729: WHERE (TAB_ID,INDICATOR) NOT IN
730: (SELECT TAB_ID,INDICATOR FROM BSC_TAB_INDICATORS));
731:
732: --Need to initiliaze in order to Do_DDL works fine

Line 848: h_sql :='DELETE BSC_KPI_DEFAULTS_B WHERE INDICATOR= :1'; --|| l_indicator;

844:
845: --h_msg := 'Reset_BscKpiDefaults Tab:' || h_tab_id;
846: --DBMS_OUTPUT.PUT_LINE(h_msg);
847: --Delete Records
848: h_sql :='DELETE BSC_KPI_DEFAULTS_B WHERE INDICATOR= :1'; --|| l_indicator;
849: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
850: Execute Immediate h_sql USING l_indicator;
851: --DBMS_OUTPUT.PUT_LINE(h_sql);
852:

Line 858: -- Insert Defaults BSC_KPI_DEFAULTS_B

854: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300
855: EXECUTE IMMEDIATE h_sql USING l_indicator;
856: --DBMS_OUTPUT.PUT_LINE(h_sql);
857:
858: -- Insert Defaults BSC_KPI_DEFAULTS_B
859: h_sql :='INSERT INTO BSC_KPI_DEFAULTS_B (TAB_ID,INDICATOR,' ||
860: 'LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)' ||
861: 'VALUES ('|| h_tab_id ||',' || l_indicator ||',SYSDATE,' || l_current_user ||',SYSDATE,' || l_current_user || ')';
862: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

Line 859: h_sql :='INSERT INTO BSC_KPI_DEFAULTS_B (TAB_ID,INDICATOR,' ||

855: EXECUTE IMMEDIATE h_sql USING l_indicator;
856: --DBMS_OUTPUT.PUT_LINE(h_sql);
857:
858: -- Insert Defaults BSC_KPI_DEFAULTS_B
859: h_sql :='INSERT INTO BSC_KPI_DEFAULTS_B (TAB_ID,INDICATOR,' ||
860: 'LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)' ||
861: 'VALUES ('|| h_tab_id ||',' || l_indicator ||',SYSDATE,' || l_current_user ||',SYSDATE,' || l_current_user || ')';
862: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
863: --DBMS_OUTPUT.PUT_LINE(h_sql);

Line 1185: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||

1181: --h_msg := 'Upadte FM Initialzie' || l_indicator;
1182: --DBMS_OUTPUT.PUT_LINE(h_msg);
1183:
1184: -- Set To Null-----------------------
1185: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||
1186: ' FORMAT_MASK =NULL,' ||
1187: ' COLOR_METHOD=NULL, ' ||
1188: ' MEASURE_SOURCE = ''BSC''' ||
1189: ' WHERE INDICATOR =:1'; -- || l_indicator;

Line 1216: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||

1212: --FORMAT AND METHOD----------------------------
1213: OPEN c_kpi_tree ;
1214: FETCH c_kpi_tree INTO h_format_mask,h_color_method;
1215: IF c_kpi_tree%FOUND THEN
1216: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||
1217: ' FORMAT_MASK = :1' || --'''' || h_format_mask || '''' ||
1218: ',COLOR_METHOD=:2' || --h_color_method ||
1219: ' WHERE INDICATOR=:3'; --|| l_indicator;
1220: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

Line 1242: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||

1238: ---Get The captions-------------------------
1239: OPEN c_analisys_measure;
1240: FETCH c_analisys_measure INTO h_serie_id,h_format_mask,h_color_method;
1241: IF c_analisys_measure%FOUND THEN
1242: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||
1243: ' FORMAT_MASK = :1' || --'''' || h_format_mask || '''' ||
1244: ',COLOR_METHOD=:2' || --h_color_method ||
1245: ' WHERE INDICATOR=:3'; --|| l_indicator;
1246: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

Line 1291: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||

1287: AND MS.INDICATOR = DF.INDICATOR
1288: AND MS.INDICATOR= x_indicator) B
1289: WHERE A.DATASET_ID = B.DATASET_ID;
1290:
1291: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B SET ' ||
1292: ' MEASURE_SOURCE = :1' || --'''' || h_kpi_measure_source || '''' ||
1293: ' WHERE INDICATOR=:2'; --|| l_indicator;
1294:
1295: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300

Line 1333: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B KD SET ' ||

1329: --DBMS_OUTPUT.PUT_LINE(h_msg);
1330:
1331:
1332: -- Update DIM SET
1333: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B KD SET ' ||
1334: ' DIM_SET_ID = (SELECT DIM_SET_ID ' ||
1335: ' FROM BSC_DB_COLOR_KPI_DEFAULTS_V DB ' ||
1336: ' WHERE KD.INDICATOR = DB.INDICATOR (+)) ' ||
1337: ' WHERE KD.INDICATOR =:1'; --|| l_indicator;

Line 1373: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B KD SET ' ||

1369: --DBMS_OUTPUT.PUT_LINE(h_msg);
1370:
1371: -- Update dimension values
1372:
1373: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B KD SET ' ||
1374: ' DIM_LEVEL1_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||
1375: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||
1376: ' WHERE KDL.DIM_LEVEL_INDEX = 0 ' ||
1377: ' AND KDL.INDICATOR = KD.INDICATOR ' ||

Line 1447: BSC_KPI_DEFAULTS_B DF

1443: h_tmp1 VARCHAR2(270); /* Bug Fix #2691601 changine size from 80 to 255 */
1444: CURSOR c_kpi_dim IS
1445: SELECT VL.DIM_SET_ID,VL.DIM_LEVEL_INDEX, VL.LEVEL_VIEW_NAME,VL.VALUE_ORDER_BY
1446: FROM BSC_KPI_DIM_LEVELS_VL VL,
1447: BSC_KPI_DEFAULTS_B DF
1448: WHERE VL.INDICATOR =l_indicator
1449: AND VL.INDICATOR = DF.INDICATOR
1450: AND VL.DIM_SET_ID = DF.DIM_SET_ID
1451: AND VL.DEFAULT_VALUE='T'

Line 1464: BSC_KPI_DEFAULTS_B DF

1460: DECODE(DEFAULT_VALUE,
1461: 'C',COMP_DISP_NAME,TOTAL_DISP_NAME),NULL) TEXT
1462: FROM BSC_KPI_DIM_LEVELS_B B,
1463: BSC_KPI_DIM_LEVELS_TL TL,
1464: BSC_KPI_DEFAULTS_B DF
1465: WHERE B.INDICATOR = l_indicator AND
1466: B.INDICATOR = TL.INDICATOR AND
1467: B.INDICATOR = DF.INDICATOR AND
1468: B.DIM_SET_ID =DF.DIM_SET_ID AND

Line 1848: IF UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_B' Or UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_TL' THEN

1844: h_sql:= h_sql || ' FROM ' || x_table_name;
1845: h_sql:= h_sql || ' WHERE ' || h_condition;
1846: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
1847: --BUG 1224991
1848: IF UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_B' Or UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_TL' THEN
1849: h_sql:= 'UPDATE ' || x_table_name;
1850: h_sql:= h_sql || ' SET TAB_ID = (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR =:1)'; --|| x_Trg_kpi || ')';
1851: h_sql:= h_sql || ' WHERE INDICATOR = :2'; --|| x_Trg_kpi;
1852: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300 ,part2