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_KPIS_B

Line 60: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPIS_B';

56: /* TABLES TO BE COPIED BASED ON OBJECTIVE */
57: g_num_kpi_metadata_tables := 0;
58:
59: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
60: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPIS_B';
61: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE;
62: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR;
63: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
64: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 660: FROM BSC_KPIS_B

656: PROCEDURE Init_variables(x_indicator IN NUMBER) IS
657:
658: CURSOR c_kpi IS
659: SELECT INDICATOR_TYPE,CONFIG_TYPE
660: FROM BSC_KPIS_B
661: WHERE INDICATOR = x_indicator;
662:
663: h_msg VARCHAR2(1000);
664:

Line 716: SELECT INDICATOR FROM BSC_KPIS_B

712: +---------------------------------------------------------------------------*/
713: PROCEDURE Deflt_RefreshInvalidKpis IS
714:
715: CURSOR c_kpi_invalid IS
716: SELECT INDICATOR FROM BSC_KPIS_B
717: WHERE PROTOTYPE_FLAG<>2 AND
718: INDICATOR NOT IN (SELECT INDICATOR FROM BSC_KPI_DEFAULTS_VL);
719:
720: h_msg VARCHAR2(1000);

Line 766: FROM BSC_KPIS_B

762: PROCEDURE Deflt_RefreshKpi(x_indicator IN NUMBER) IS
763:
764: CURSOR c_kpi IS
765: SELECT INDICATOR_TYPE,CONFIG_TYPE
766: FROM BSC_KPIS_B
767: WHERE INDICATOR = x_indicator;
768:
769: h_msg VARCHAR2(1000);
770: h_exist NUMBER(1);

Line 1672: FROM BSC_KPIS_B B, BSC_KPI_PERIODICITIES P

1668: BSC_KPIS_VL
1669: WHERE INDICATOR= l_indicator;
1670: CURSOR c_periodicity IS
1671: SELECT P.PERIODICITY_ID,P.CURRENT_PERIOD
1672: FROM BSC_KPIS_B B, BSC_KPI_PERIODICITIES P
1673: WHERE P.INDICATOR= l_indicator
1674: AND P.INDICATOR= B.INDICATOR AND
1675: P.PERIODICITY_ID = B.PERIODICITY_ID;
1676:

Line 2137: | - BSC_KPIS_B is a special case

Line 2176: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;

2172: Init_Kpi_Metadata_Tables_Array();
2173:
2174: SELECT NVL(CSF_ID,1)
2175: INTO h_CSF_id
2176: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2177: SELECT NVL(IND_GROUP_ID,1)
2178: INTO h_Ind_group_id
2179: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2180: SELECT NVL(DISP_ORDER,1)

Line 2179: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;

2175: INTO h_CSF_id
2176: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2177: SELECT NVL(IND_GROUP_ID,1)
2178: INTO h_Ind_group_id
2179: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2180: SELECT NVL(DISP_ORDER,1)
2181: INTO h_Disp_Order
2182: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2183: SELECT NVL(SHARE_FLAG,0)

Line 2182: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;

2178: INTO h_Ind_group_id
2179: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2180: SELECT NVL(DISP_ORDER,1)
2181: INTO h_Disp_Order
2182: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2183: SELECT NVL(SHARE_FLAG,0)
2184: INTO h_Source_Flag
2185: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2186: SELECT SOURCE_INDICATOR

Line 2185: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;

2181: INTO h_Disp_Order
2182: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2183: SELECT NVL(SHARE_FLAG,0)
2184: INTO h_Source_Flag
2185: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2186: SELECT SOURCE_INDICATOR
2187: INTO h_Source_Indicator
2188: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2189: --Get Prototype Flag 04/26/02

Line 2188: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;

2184: INTO h_Source_Flag
2185: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2186: SELECT SOURCE_INDICATOR
2187: INTO h_Source_Indicator
2188: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2189: --Get Prototype Flag 04/26/02
2190: -- Get the status
2191: SELECT NVL(PROTOTYPE_FLAG,1)
2192: INTO h_TRG_Flag

Line 2193: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;

2189: --Get Prototype Flag 04/26/02
2190: -- Get the status
2191: SELECT NVL(PROTOTYPE_FLAG,1)
2192: INTO h_TRG_Flag
2193: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2194:
2195: --Fisrt Duplicate the data to BSC_KPIS_B
2196: Duplicate_Record_by_Indicator('BSC_KPIS_B', x_Src_kpi, x_Trg_kpi);
2197:

Line 2195: --Fisrt Duplicate the data to BSC_KPIS_B

2191: SELECT NVL(PROTOTYPE_FLAG,1)
2192: INTO h_TRG_Flag
2193: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2194:
2195: --Fisrt Duplicate the data to BSC_KPIS_B
2196: Duplicate_Record_by_Indicator('BSC_KPIS_B', x_Src_kpi, x_Trg_kpi);
2197:
2198: --Restore the properties
2199: BscKpisB_Update(x_Trg_kpi, 'CSF_ID', h_CSF_id);

Line 2196: Duplicate_Record_by_Indicator('BSC_KPIS_B', x_Src_kpi, x_Trg_kpi);

2192: INTO h_TRG_Flag
2193: FROM BSC_KPIS_B WHERE INDICATOR = x_Trg_kpi;
2194:
2195: --Fisrt Duplicate the data to BSC_KPIS_B
2196: Duplicate_Record_by_Indicator('BSC_KPIS_B', x_Src_kpi, x_Trg_kpi);
2197:
2198: --Restore the properties
2199: BscKpisB_Update(x_Trg_kpi, 'CSF_ID', h_CSF_id);
2200: BscKpisB_Update(x_Trg_kpi, 'IND_GROUP_ID', h_Ind_group_id);

Line 2207: h_sql := 'UPDATE BSC_KPIS_B SET SHARE_FLAG =3 ' || h_condition;

2203: BscKpisB_Update(x_Trg_kpi, 'SOURCE_INDICATOR', h_Source_Indicator);
2204:
2205: --UPDATE SHARE_FLAG
2206: h_condition := 'WHERE INDICATOR = :1 '; --|| x_Trg_kpi;
2207: h_sql := 'UPDATE BSC_KPIS_B SET SHARE_FLAG =3 ' || h_condition;
2208: Execute Immediate h_sql USING x_Trg_kpi;
2209:
2210: h_condition := 'WHERE INDICATOR = :2 '; --|| x_Trg_kpi;
2211: h_sql := 'UPDATE BSC_KPIS_B SET SOURCE_INDICATOR =:1 ' --|| x_Src_kpi

Line 2211: h_sql := 'UPDATE BSC_KPIS_B SET SOURCE_INDICATOR =:1 ' --|| x_Src_kpi

2207: h_sql := 'UPDATE BSC_KPIS_B SET SHARE_FLAG =3 ' || h_condition;
2208: Execute Immediate h_sql USING x_Trg_kpi;
2209:
2210: h_condition := 'WHERE INDICATOR = :2 '; --|| x_Trg_kpi;
2211: h_sql := 'UPDATE BSC_KPIS_B SET SOURCE_INDICATOR =:1 ' --|| x_Src_kpi
2212: || h_condition;
2213: Execute Immediate h_sql USING x_Src_kpi, x_Trg_kpi;
2214:
2215: -- Get the status

Line 2218: FROM BSC_KPIS_B WHERE INDICATOR = x_Src_kpi;

2214:
2215: -- Get the status
2216: SELECT NVL(PROTOTYPE_FLAG,1)
2217: INTO h_SRC_Flag
2218: FROM BSC_KPIS_B WHERE INDICATOR = x_Src_kpi;
2219:
2220: ---04/26/02 Validate the prototype flag
2221: IF h_SRC_Flag <> h_TRG_Flag THEN
2222: -- Critical status are propage to the child

Line 2288: IF ((l_kpi_metadata_tables(i).table_name <> 'BSC_KPIS_B' )

2284:
2285: END LOOP;
2286:
2287: FOR i IN 1..l_num_kpi_metadata_tables LOOP
2288: IF ((l_kpi_metadata_tables(i).table_name <> 'BSC_KPIS_B' )
2289: AND (l_kpi_metadata_tables(i).table_name <> 'BSC_KPIS_TL' )
2290: AND (l_kpi_metadata_tables(i).table_name <> 'BSC_KPI_CAUSE_EFFECT_RELS' )
2291: AND (l_kpi_metadata_tables(i).table_name <> 'BSC_KPI_DATA_TABLES') )THEN
2292: Copy_Record_by_Indicator_Table(l_kpi_metadata_tables(i).table_name,l_kpi_metadata_tables(i).table_type,l_kpi_metadata_tables(i).table_column, x_Src_kpi, x_Trg_kpi);

Line 2321: h_sql := 'UPDATE BSC_KPIS_B SET SHARE_FLAG =2 ' || h_condition;

2317: Execute Immediate h_sql USING h_Trg_kpi_neg;
2318:
2319: --UPDATE SHARE_FLAG
2320: h_condition := 'WHERE INDICATOR = :1'; --|| x_Trg_kpi;
2321: h_sql := 'UPDATE BSC_KPIS_B SET SHARE_FLAG =2 ' || h_condition;
2322: Execute Immediate h_sql USING x_Trg_kpi;
2323:
2324:
2325: EXCEPTION

Line 2349: | Updates a record in the BSC_KPIS_B table.

2345:
2346: PROCEDURE BscKpisB_Update(x_Ind IN NUMBER, x_Field IN VARCHAR, x_Val IN VARCHAR) IS
2347: /*===========================================================================+
2348: | DESCRIPTION:
2349: | Updates a record in the BSC_KPIS_B table.
2350: | PARAMETERS:
2351: | Ind Indicator Code
2352: | VARIABLE Variable name
2353: | Valor Value

Line 2362: h_sql := 'UPDATE BSC_KPIS_B SET ' || x_Field || ' = :1 '

2358: +---------------------------------------------------------------------------*/
2359: h_sql VARCHAR2(32000);
2360: BEGIN
2361: --Validation
2362: h_sql := 'UPDATE BSC_KPIS_B SET ' || x_Field || ' = :1 '
2363: || ' WHERE INDICATOR=:2'; --|| x_Ind;
2364: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300 ,part2
2365: Execute Immediate h_sql USING x_Val, x_Ind;
2366: --DBMS_OUTPUT.PUT_LINE('h_sql :' || h_sql );

Line 2561: FROM BSC_KPIS_B

2557: -- Get the current indicator status
2558: h_currentFlag := 1;
2559: SELECT PROTOTYPE_FLAG
2560: INTO h_currentFlag
2561: FROM BSC_KPIS_B
2562: WHERE INDICATOR = p_indicator;
2563:
2564: --DBMS_OUTPUT.PUT_LINE('3. Current KPI Deflt values (' || p_indicator || ') = ' || h_currentFlag);
2565:

Line 2646: UPDATE BSC_KPIS_B SET PROTOTYPE_FLAG =h_newflag

2642: -- Refresh the tab panel
2643: --- ======>ON HOLD gRefresh_type.tab = True
2644:
2645: -- Call BscKpisB_Update(indicator, "PROTOTYPE_FLAG", h_newflag)
2646: UPDATE BSC_KPIS_B SET PROTOTYPE_FLAG =h_newflag
2647: WHERE INDICATOR = p_indicator;
2648:
2649: -- RECORD IN MIND_TABLES_NEW
2650: -- Recreate the Information for MIND_TABLES_NEW

Line 2680: UPDATE BSC_KPIS_B SET PUBLISH_FLAG = 1

2676: --- ======>ON HOLD tmp = MsgBox(msg_tmp.Text, vbYesNo, gKpiDesignerTitle)
2677: --YES
2678: IF h_tmp = 1 THEN
2679: -- Call BscKpisB_Update(indicator, "PUBLISH_FLAG", 1)
2680: UPDATE BSC_KPIS_B SET PUBLISH_FLAG = 1
2681: WHERE INDICATOR = p_indicator;
2682: ELSE
2683: -- Call BscKpisB_Update(indicator, "PUBLISH_FLAG", 0)
2684: UPDATE BSC_KPIS_B SET PUBLISH_FLAG = 0

Line 2684: UPDATE BSC_KPIS_B SET PUBLISH_FLAG = 0

2680: UPDATE BSC_KPIS_B SET PUBLISH_FLAG = 1
2681: WHERE INDICATOR = p_indicator;
2682: ELSE
2683: -- Call BscKpisB_Update(indicator, "PUBLISH_FLAG", 0)
2684: UPDATE BSC_KPIS_B SET PUBLISH_FLAG = 0
2685: WHERE INDICATOR = p_indicator;
2686: END IF;
2687: END IF;
2688: END IF;