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_PERIODICITIES

Line 243: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES';

239: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
240: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
241:
242: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
243: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES';
244: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
245: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
246: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
247: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 251: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES_USER';

247: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
248: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
249:
250: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
251: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PERIODICITIES_USER';
252: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
253: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
254: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
255: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 453: FROM BSC_KPI_PERIODICITIES

449: ,USER_LEVEL1
450: ,USER_LEVEL1_DEFAULT
451: ,USER_LEVEL2
452: ,USER_LEVEL2_DEFAULT
453: FROM BSC_KPI_PERIODICITIES
454: WHERE INDICATOR = h_Trg_kpi_neg;
455:
456: CURSOR c_Calculation IS
457: SELECT CALCULATION_ID

Line 592: IF p_table_name = 'BSC_KPI_PERIODICITIES' THEN

588: AND DIM_LEVEL_INDEX = CD.DIM_LEVEL_INDEX;
589: END LOOP;
590: END IF;
591:
592: IF p_table_name = 'BSC_KPI_PERIODICITIES' THEN
593: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_PERIODICITIES:-');
594: FOR CD IN c_Periodicity LOOP
595: UPDATE BSC_KPI_PERIODICITIES
596: SET USER_LEVEL0 = CD.USER_LEVEL0

Line 593: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_PERIODICITIES:-');

589: END LOOP;
590: END IF;
591:
592: IF p_table_name = 'BSC_KPI_PERIODICITIES' THEN
593: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_PERIODICITIES:-');
594: FOR CD IN c_Periodicity LOOP
595: UPDATE BSC_KPI_PERIODICITIES
596: SET USER_LEVEL0 = CD.USER_LEVEL0
597: ,USER_LEVEL1 = CD.USER_LEVEL1

Line 595: UPDATE BSC_KPI_PERIODICITIES

591:
592: IF p_table_name = 'BSC_KPI_PERIODICITIES' THEN
593: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_PERIODICITIES:-');
594: FOR CD IN c_Periodicity LOOP
595: UPDATE BSC_KPI_PERIODICITIES
596: SET USER_LEVEL0 = CD.USER_LEVEL0
597: ,USER_LEVEL1 = CD.USER_LEVEL1
598: ,USER_LEVEL1_DEFAULT = CD.USER_LEVEL1_DEFAULT
599: ,USER_LEVEL2 = CD.USER_LEVEL2

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 2264: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_PERIODICITIES') THEN

2260: UPDATE BSC_KPI_ANALYSIS_OPTIONS_B
2261: SET INDICATOR = h_Trg_kpi_neg
2262: WHERE INDICATOR = x_Trg_kpi;
2263: END IF;
2264: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_PERIODICITIES') THEN
2265: UPDATE BSC_KPI_PERIODICITIES
2266: SET INDICATOR = h_Trg_kpi_neg
2267: WHERE INDICATOR = x_Trg_kpi;
2268: END IF;

Line 2265: UPDATE BSC_KPI_PERIODICITIES

2261: SET INDICATOR = h_Trg_kpi_neg
2262: WHERE INDICATOR = x_Trg_kpi;
2263: END IF;
2264: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_PERIODICITIES') THEN
2265: UPDATE BSC_KPI_PERIODICITIES
2266: SET INDICATOR = h_Trg_kpi_neg
2267: WHERE INDICATOR = x_Trg_kpi;
2268: END IF;
2269: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_CALCULATIONS') THEN

Line 2310: h_sql := 'DELETE BSC_KPI_PERIODICITIES WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

2306: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2307: Execute Immediate h_sql USING h_Trg_kpi_neg;
2308: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_TL WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2309: Execute Immediate h_sql USING h_Trg_kpi_neg;
2310: h_sql := 'DELETE BSC_KPI_PERIODICITIES WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2311: Execute Immediate h_sql USING h_Trg_kpi_neg;
2312: h_sql := 'DELETE BSC_KPI_CALCULATIONS WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2313: Execute Immediate h_sql USING h_Trg_kpi_neg;
2314: h_sql := 'DELETE BSC_KPI_DIM_LEVELS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

Line 2331: h_sql := 'DELETE BSC_KPI_PERIODICITIES WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

2327: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2328: Execute Immediate h_sql USING h_Trg_kpi_neg;
2329: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_TL WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2330: Execute Immediate h_sql USING h_Trg_kpi_neg;
2331: h_sql := 'DELETE BSC_KPI_PERIODICITIES WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2332: Execute Immediate h_sql USING h_Trg_kpi_neg;
2333: h_sql := 'DELETE BSC_KPI_CALCULATIONS WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2334: Execute Immediate h_sql USING h_Trg_kpi_neg;
2335: h_sql := 'DELETE BSC_KPI_DIM_LEVELS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

Line 2665: NULL TABLE_NAME,NULL FILTER_CONDITION FROM BSC_KPI_PERIODICITIES

2661: DELETE BSC_KPI_DATA_TABLES WHERE DIM_SET_ID =0 AND INDICATOR = p_indicator;
2662: INSERT INTO BSC_KPI_DATA_TABLES
2663: (INDICATOR,PERIODICITY_ID,DIM_SET_ID,LEVEL_COMB,TABLE_NAME,FILTER_CONDITION)
2664: (SELECT INDICATOR INDICATOR,PERIODICITY_ID PERIODICITY_ID,0 DIM_SET_ID,'?' LEVEL_COMB,
2665: NULL TABLE_NAME,NULL FILTER_CONDITION FROM BSC_KPI_PERIODICITIES
2666: WHERE INDICATOR = p_indicator);
2667: END IF;
2668:
2669: END IF;