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_DESIGNER_PVT

Line 1: PACKAGE BODY BSC_DESIGNER_PVT AS

1: PACKAGE BODY BSC_DESIGNER_PVT AS
2: /* $Header: BSCDSGB.pls 120.14 2007/06/29 08:29:01 ankgoel ship $ */
3:
4: g_kpi_metadata_tables t_kpi_metadata_tables;
5: g_num_kpi_metadata_tables NUMBER := 0;

Line 1952: h_sql:= h_sql || ' FROM ' || BSC_DESIGNER_PVT.Format_DbLink_String(p_table_name);

1948: END IF;
1949: h_sql:= h_sql || x_arr_columns(i) || ' AS ' || x_arr_columns(i);
1950: END LOOP;
1951:
1952: h_sql:= h_sql || ' FROM ' || BSC_DESIGNER_PVT.Format_DbLink_String(p_table_name);
1953: h_sql:= h_sql || ' WHERE indicator = ' || p_src_kpi ;
1954: IF p_src_kpi_measure_id IS NULL THEN
1955: h_sql:= h_sql || ' AND kpi_measure_id IS NULL';
1956: ELSE

Line 1969: , x_source => 'BSC_DESIGNER_PVT.insert_kpi_meas_data'

1965: IF c_column%ISOPEN THEN
1966: CLOSE c_column;
1967: END IF;
1968: BSC_MESSAGE.Add( x_message => SQLERRM
1969: , x_source => 'BSC_DESIGNER_PVT.insert_kpi_meas_data'
1970: );
1971: RAISE;
1972: END insert_kpi_meas_data;
1973:

Line 1990: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT color_range_id, property_value FROM bsc_color_type_props');

1986: l_src_property_value NUMBER;
1987: TYPE c_cur_type IS REF CURSOR;
1988: c_color_range c_cur_type;
1989: BEGIN
1990: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT color_range_id, property_value FROM bsc_color_type_props');
1991: l_sql := l_sql || 'WHERE indicator = :1';
1992:
1993: IF p_src_kpi_measure_id IS NULL THEN
1994: l_sql := l_sql || ' AND kpi_measure_id IS NULL';

Line 2021: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(', low , high , color_id FROM bsc_color_ranges');

2017:
2018:
2019: l_sql := 'INSERT INTO bsc_color_ranges (color_range_id, color_range_sequence, low, high, color_id)';
2020: l_sql := l_sql || 'SELECT '|| l_trg_color_range_id || ' AS color_range_id, color_range_sequence';
2021: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(', low , high , color_id FROM bsc_color_ranges');
2022: l_sql := l_sql || 'WHERE color_range_id = :1';
2023:
2024: EXECUTE IMMEDIATE l_sql USING l_src_color_range_id;
2025:

Line 2035: , x_source => 'BSC_DESIGNER_PVT.Copy_Thresholds'

2031: IF c_color_range%ISOPEN THEN
2032: CLOSE c_color_range;
2033: END IF;
2034: BSC_MESSAGE.Add( x_message => SQLERRM
2035: , x_source => 'BSC_DESIGNER_PVT.Copy_Thresholds'
2036: );
2037: RAISE;
2038: END Copy_Thresholds;
2039:

Line 2068: l_ao_comb_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT distinct kpi_measure_id FROM bsc_kpi_analysis_measures_b');

2064:
2065: END IF;
2066: END LOOP;
2067:
2068: l_ao_comb_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT distinct kpi_measure_id FROM bsc_kpi_analysis_measures_b');
2069: l_ao_comb_sql := l_ao_comb_sql || 'WHERE indicator = :1';
2070: OPEN c_src_ao_comb FOR l_ao_comb_sql USING p_src_kpi;
2071: LOOP
2072: FETCH c_src_ao_comb INTO l_src_kpi_measure_id;

Line 2125: , x_source => 'BSC_DESIGNER_PVT.Copy_Records_by_Obj_Kpi_Meas'

2121:
2122: EXCEPTION
2123: WHEN OTHERS THEN
2124: BSC_MESSAGE.Add( x_message => SQLERRM
2125: , x_source => 'BSC_DESIGNER_PVT.Copy_Records_by_Obj_Kpi_Meas'
2126: );
2127: RAISE;
2128: END Copy_Records_by_Obj_Kpi_Meas;
2129:

Line 2475: x_source => 'BSC_DESIGNER_PVT.Update_Kpi_Prototype_Flag');

2471:
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: BSC_MESSAGE.Add(x_message => SQLERRM,
2475: x_source => 'BSC_DESIGNER_PVT.Update_Kpi_Prototype_Flag');
2476: END Update_Kpi_Prototype_Flag;
2477:
2478:
2479: /*===========================================================================+

Line 2894: BSC_DESIGNER_PVT.Dimension_Change(h_grp_id, x_flag);

2890: FETCH c_group_id INTO h_grp_id;
2891:
2892: -- --DBMS_OUTPUT.PUT_LINE('h_kpi' || h_kpi);
2893:
2894: BSC_DESIGNER_PVT.Dimension_Change(h_grp_id, x_flag);
2895:
2896: CLOSE c_group_id;
2897:
2898: EXCEPTION

Line 3044: x_msg_data := x_msg_data || p_table_name || ' ->BSC_DESIGNER_PVT.Copy_Objective_Record ';

3040: WHEN NO_DATA_FOUND THEN
3041: ROLLBACK TO BscCopyObjRecordPub;
3042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3043: IF (x_msg_data IS NOT NULL) THEN
3044: x_msg_data := x_msg_data || p_table_name || ' ->BSC_DESIGNER_PVT.Copy_Objective_Record ';
3045: ELSE
3046: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Copy_Objective_Record ';
3047: END IF;
3048: WHEN OTHERS THEN

Line 3046: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Copy_Objective_Record ';

3042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3043: IF (x_msg_data IS NOT NULL) THEN
3044: x_msg_data := x_msg_data || p_table_name || ' ->BSC_DESIGNER_PVT.Copy_Objective_Record ';
3045: ELSE
3046: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Copy_Objective_Record ';
3047: END IF;
3048: WHEN OTHERS THEN
3049: ROLLBACK TO BscCopyObjRecordPub;
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3052: x_msg_data := x_msg_data ||p_table_name || ' -> BSC_DESIGNER_PVT.Copy_Objective_Record ';

3048: WHEN OTHERS THEN
3049: ROLLBACK TO BscCopyObjRecordPub;
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3051: IF (x_msg_data IS NOT NULL) THEN
3052: x_msg_data := x_msg_data ||p_table_name || ' -> BSC_DESIGNER_PVT.Copy_Objective_Record ';
3053: ELSE
3054: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Copy_Objective_Record ';
3055: END IF;
3056: END Copy_Objective_Record;

Line 3054: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Copy_Objective_Record ';

3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3051: IF (x_msg_data IS NOT NULL) THEN
3052: x_msg_data := x_msg_data ||p_table_name || ' -> BSC_DESIGNER_PVT.Copy_Objective_Record ';
3053: ELSE
3054: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Copy_Objective_Record ';
3055: END IF;
3056: END Copy_Objective_Record;
3057:
3058: /************************************************************************************

Line 3288: x_msg_data := x_msg_data || p_table_name || ' ->BSC_DESIGNER_PVT.Process_TL_Table ';

3284: WHEN NO_DATA_FOUND THEN
3285: ROLLBACK TO BscProcessTLTableInfo;
3286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3287: IF (x_msg_data IS NOT NULL) THEN
3288: x_msg_data := x_msg_data || p_table_name || ' ->BSC_DESIGNER_PVT.Process_TL_Table ';
3289: ELSE
3290: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Process_TL_Table ';
3291: END IF;
3292: WHEN OTHERS THEN

Line 3290: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Process_TL_Table ';

3286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3287: IF (x_msg_data IS NOT NULL) THEN
3288: x_msg_data := x_msg_data || p_table_name || ' ->BSC_DESIGNER_PVT.Process_TL_Table ';
3289: ELSE
3290: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Process_TL_Table ';
3291: END IF;
3292: WHEN OTHERS THEN
3293: ROLLBACK TO BscProcessTLTableInfo;
3294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3296: x_msg_data := x_msg_data ||p_table_name || ' -> BSC_DESIGNER_PVT.Process_TL_Table ';

3292: WHEN OTHERS THEN
3293: ROLLBACK TO BscProcessTLTableInfo;
3294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3295: IF (x_msg_data IS NOT NULL) THEN
3296: x_msg_data := x_msg_data ||p_table_name || ' -> BSC_DESIGNER_PVT.Process_TL_Table ';
3297: ELSE
3298: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Process_TL_Table ';
3299: END IF;
3300: END Process_TL_Table;

Line 3298: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Process_TL_Table ';

3294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3295: IF (x_msg_data IS NOT NULL) THEN
3296: x_msg_data := x_msg_data ||p_table_name || ' -> BSC_DESIGNER_PVT.Process_TL_Table ';
3297: ELSE
3298: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Process_TL_Table ';
3299: END IF;
3300: END Process_TL_Table;
3301:
3302:

Line 3336: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT DECODE(share_flag, 2, 3, 5) FROM bsc_kpis_vl');

3332:
3333: BSC_APPS.Init_Bsc_Apps;
3334: Init_Kpi_Metadata_Tables_Array();
3335:
3336: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT DECODE(share_flag, 2, 3, 5) FROM bsc_kpis_vl');
3337: l_sql := l_sql || 'WHERE indicator = :1';
3338: OPEN l_cursor FOR l_sql USING p_Source_Indicator;
3339: FETCH l_cursor INTO l_Copy_Type;
3340: CLOSE l_cursor;

Line 3423: x_msg_data := x_msg_data || ' ->BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';

3419: WHEN NO_DATA_FOUND THEN
3420: ROLLBACK TO BscCopyKpiMetadataPub;
3421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3422: IF (x_msg_data IS NOT NULL) THEN
3423: x_msg_data := x_msg_data || ' ->BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3424: ELSE
3425: x_msg_data := SQLERRM || 'BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3426: END IF;
3427: WHEN OTHERS THEN

Line 3425: x_msg_data := SQLERRM || 'BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';

3421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3422: IF (x_msg_data IS NOT NULL) THEN
3423: x_msg_data := x_msg_data || ' ->BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3424: ELSE
3425: x_msg_data := SQLERRM || 'BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3426: END IF;
3427: WHEN OTHERS THEN
3428: ROLLBACK TO BscCopyKpiMetadataPub;
3429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3431: x_msg_data := x_msg_data || ' ->BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';

3427: WHEN OTHERS THEN
3428: ROLLBACK TO BscCopyKpiMetadataPub;
3429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3430: IF (x_msg_data IS NOT NULL) THEN
3431: x_msg_data := x_msg_data || ' ->BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3432: ELSE
3433: x_msg_data := SQLERRM || 'BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3434: END IF;
3435: END Copy_Kpi_Metadata;

Line 3433: x_msg_data := SQLERRM || 'BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';

3429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3430: IF (x_msg_data IS NOT NULL) THEN
3431: x_msg_data := x_msg_data || ' ->BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3432: ELSE
3433: x_msg_data := SQLERRM || 'BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3434: END IF;
3435: END Copy_Kpi_Metadata;
3436:
3437: /************************************************************************************

Line 3457: END BSC_DESIGNER_PVT;

3453: RETURN p_Sql|| ' ';
3454: END Format_DbLink_String;
3455:
3456:
3457: END BSC_DESIGNER_PVT;