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_COLOR_RANGES_PUB dependencies on BSC_COLOR_RANGES_PUB

Line 1: package body BSC_COLOR_RANGES_PUB as

1: package body BSC_COLOR_RANGES_PUB as
2: /* $Header: BSCPCRNB.pls 120.4.12000000.1 2007/07/17 07:43:52 appldev noship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'BSC_COLOR_RANGES_PUB';

21: | 26-JUN-2007 ankgoel Bug#6132361 - Handled PL objectives |
22: +======================================================================================+
23: */
24:
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'BSC_COLOR_RANGES_PUB';
26:
27:
28: FUNCTION get_Color_Threshold_Array(
29: p_threshold_color IN VARCHAR2

Line 36: ) RETURN BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

32: /************************************************************************************
33: ************************************************************************************/
34: FUNCTION Get_Def_Color_Range_Rec(
35: p_color_method NUMBER
36: ) RETURN BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
37:
38: /************************************************************************************
39: ************************************************************************************/
40: PROCEDURE Create_Color_Prop_Ranges(

Line 54: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

50: ) IS
51: l_loop_count NUMBER;
52: l_val VARCHAR2(200);
53: l_threshold VARCHAR2(2000);
54: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
55: l_range_id NUMBER;
56: l_is_succ BOOLEAN;
57: l_user_id FND_USER.user_id%TYPE;
58:

Line 169: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

165: IS
166: l_loop_count NUMBER;
167: l_val VARCHAR2(200);
168: l_threshold VARCHAR2(2000);
169: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
170: l_range_id NUMBER;
171: l_is_succ BOOLEAN;
172: l_user_id FND_USER.user_id%TYPE;
173: l_kpi_measure_id NUMBER;

Line 499: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

495: ) IS
496: l_loop_count NUMBER;
497: l_val VARCHAR2(200);
498: l_threshold VARCHAR2(2000);
499: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
500: l_range_id NUMBER;
501: l_is_succ BOOLEAN;
502: l_user_id FND_USER.user_id%TYPE;
503: l_range_count NUMBER;

Line 597: ) RETURN BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec IS

593: END Save_Color_Prop_Ranges;
594:
595: FUNCTION Get_Def_Color_Range_Rec(
596: p_color_method NUMBER
597: ) RETURN BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec IS
598: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
599: l_color_count_def VARCHAR2(1);
600: l_color_count NUMBER;
601: l_index NUMBER;

Line 598: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

594:
595: FUNCTION Get_Def_Color_Range_Rec(
596: p_color_method NUMBER
597: ) RETURN BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec IS
598: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
599: l_color_count_def VARCHAR2(1);
600: l_color_count NUMBER;
601: l_index NUMBER;
602: l_low NUMBER;

Line 832: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

828: ) IS
829: l_loop_count NUMBER;
830: l_val VARCHAR2(200);
831: l_threshold VARCHAR2(2000);
832: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
833: l_range_id NUMBER;
834: l_is_succ BOOLEAN;
835: l_user_id FND_USER.user_id%TYPE;
836: l_kpi_measure_id NUMBER;

Line 1016: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

1012:
1013: l_Count NUMBER;
1014: l_value VARCHAR2(200);
1015: l_range_id NUMBER;
1016: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1017: BEGIN
1018:
1019: FND_MSG_PUB.Initialize;
1020: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1082: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';

1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: WHEN NO_DATA_FOUND THEN
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: IF (x_msg_data IS NOT NULL) THEN
1082: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1083: ELSE
1084: x_msg_data := SQLERRM||' at BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1085: END IF;
1086: WHEN OTHERS THEN

Line 1084: x_msg_data := SQLERRM||' at BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';

1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: IF (x_msg_data IS NOT NULL) THEN
1082: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1083: ELSE
1084: x_msg_data := SQLERRM||' at BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1085: END IF;
1086: WHEN OTHERS THEN
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: IF (x_msg_data IS NOT NULL) THEN

Line 1089: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';

1085: END IF;
1086: WHEN OTHERS THEN
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: IF (x_msg_data IS NOT NULL) THEN
1089: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1090: ELSE
1091: x_msg_data := SQLERRM||' at BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1092: END IF;
1093: END Create_Color_Prop_Ranges;

Line 1091: x_msg_data := SQLERRM||' at BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';

1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: IF (x_msg_data IS NOT NULL) THEN
1089: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1090: ELSE
1091: x_msg_data := SQLERRM||' at BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1092: END IF;
1093: END Create_Color_Prop_Ranges;
1094:
1095: /************************************************************************************

Line 1137: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

1133:
1134: l_Count NUMBER;
1135: l_value VARCHAR2(200);
1136: l_threshold_color VARCHAR2(2000);
1137: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1138: l_format_issue BOOLEAN:= FALSE;
1139: BEGIN
1140: FND_MSG_PUB.Initialize;
1141: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1507: END BSC_COLOR_RANGES_PUB;

1503: END IF;
1504: RETURN l_color_method;
1505: END;
1506:
1507: END BSC_COLOR_RANGES_PUB;