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_ANALYSIS_OPTIONS_B

Line 98: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_B';

94: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;
95: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
96:
97: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
98: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_B';
99: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
100: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
101: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
102: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 431: FROM BSC_KPI_ANALYSIS_OPTIONS_B

427: ,USER_LEVEL1
428: ,USER_LEVEL1_DEFAULT
429: ,USER_LEVEL2
430: ,USER_LEVEL2_DEFAULT
431: FROM BSC_KPI_ANALYSIS_OPTIONS_B
432: WHERE INDICATOR = h_Trg_kpi_neg;
433:
434: CURSOR c_Dim_level IS
435: SELECT DIM_SET_ID

Line 560: IF p_table_name = 'BSC_KPI_ANALYSIS_OPTIONS_B' THEN

556: Execute Immediate h_sql USING p_Trg_kpi, p_Trg_kpi;
557: END IF;
558:
559: --Bug 2258410 don't override the user wizard preferences
560: IF p_table_name = 'BSC_KPI_ANALYSIS_OPTIONS_B' THEN
561: -- Take the Values from the temporal (negative) records
562: FOR CD IN c_userwizard LOOP
563: UPDATE BSC_KPI_ANALYSIS_OPTIONS_B
564: SET USER_LEVEL0 = CD.USER_LEVEL0

Line 563: UPDATE BSC_KPI_ANALYSIS_OPTIONS_B

559: --Bug 2258410 don't override the user wizard preferences
560: IF p_table_name = 'BSC_KPI_ANALYSIS_OPTIONS_B' THEN
561: -- Take the Values from the temporal (negative) records
562: FOR CD IN c_userwizard LOOP
563: UPDATE BSC_KPI_ANALYSIS_OPTIONS_B
564: SET USER_LEVEL0 = CD.USER_LEVEL0
565: ,USER_LEVEL1 = CD.USER_LEVEL1
566: ,USER_LEVEL1_DEFAULT = CD.USER_LEVEL1_DEFAULT
567: ,USER_LEVEL2 = CD.USER_LEVEL2

Line 1857: IF x_table_name = 'BSC_KPI_ANALYSIS_OPTIONS_B' THEN

1853: Execute Immediate h_sql USING x_Trg_kpi, x_Trg_kpi;
1854: END IF;
1855:
1856: --Bug 2258410 don't override the user wizard preferences
1857: IF x_table_name = 'BSC_KPI_ANALYSIS_OPTIONS_B' THEN
1858: -- Take the Values from the temporal (negative) records
1859: OPEN c_userwizard;
1860: FETCH c_userwizard INTO h_ag,h_aO,h_aOP,h_aOG,h_usl;
1861: WHILE c_userwizard%FOUND LOOP

Line 2259: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_ANALYSIS_OPTIONS_B') THEN

2255: END IF;
2256:
2257: h_Trg_kpi_neg := -1 * x_Trg_kpi;
2258: FOR i IN 1..l_num_kpi_metadata_tables LOOP
2259: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_ANALYSIS_OPTIONS_B') THEN
2260: UPDATE BSC_KPI_ANALYSIS_OPTIONS_B
2261: SET INDICATOR = h_Trg_kpi_neg
2262: WHERE INDICATOR = x_Trg_kpi;
2263: END IF;

Line 2260: UPDATE BSC_KPI_ANALYSIS_OPTIONS_B

2256:
2257: h_Trg_kpi_neg := -1 * x_Trg_kpi;
2258: FOR i IN 1..l_num_kpi_metadata_tables LOOP
2259: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_ANALYSIS_OPTIONS_B') 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

Line 2305: --DBMS_OUTPUT.PUT_LINE(' DELETEING BSC_KPI_ANALYSIS_OPTIONS_B:-' );

2301:
2302: -- Copy records per KPI Measure
2303: Copy_Records_by_Obj_Kpi_Meas(x_src_kpi, x_trg_kpi);
2304:
2305: --DBMS_OUTPUT.PUT_LINE(' DELETEING BSC_KPI_ANALYSIS_OPTIONS_B:-' );
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;

Line 2306: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

2302: -- Copy records per KPI Measure
2303: Copy_Records_by_Obj_Kpi_Meas(x_src_kpi, x_trg_kpi);
2304:
2305: --DBMS_OUTPUT.PUT_LINE(' DELETEING BSC_KPI_ANALYSIS_OPTIONS_B:-' );
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;

Line 2327: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

2323:
2324:
2325: EXCEPTION
2326: WHEN OTHERS THEN
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;