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 THRESHOLD_ARRAY

Line 28: FUNCTION get_Color_Threshold_Array(

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
30: ) RETURN THRESHOLD_ARRAY;
31:
32: /************************************************************************************

Line 30: ) RETURN THRESHOLD_ARRAY;

26:
27:
28: FUNCTION get_Color_Threshold_Array(
29: p_threshold_color IN VARCHAR2
30: ) RETURN THRESHOLD_ARRAY;
31:
32: /************************************************************************************
33: ************************************************************************************/
34: FUNCTION Get_Def_Color_Range_Rec(

Line 45: ,p_threshold_color IN THRESHOLD_ARRAY

41: p_commit IN VARCHAR2 := FND_API.G_FALSE
42: ,p_objective_id IN NUMBER
43: ,p_kpi_measure_id IN NUMBER
44: ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
45: ,p_threshold_color IN THRESHOLD_ARRAY
46: ,p_property_value IN VARCHAR2 := NULL
47: ,x_return_status OUT NOCOPY VARCHAR2
48: ,x_msg_count OUT NOCOPY NUMBER
49: ,x_msg_data OUT NOCOPY VARCHAR2

Line 458: l_threshold_array THRESHOLD_ARRAY;

454: ,x_return_status OUT NOCOPY VARCHAR2
455: ,x_msg_count OUT NOCOPY NUMBER
456: ,x_msg_data OUT NOCOPY VARCHAR2
457: ) IS
458: l_threshold_array THRESHOLD_ARRAY;
459: BEGIN
460: IF (p_threshold_color IS NULL) THEN
461: l_threshold_array := NULL;
462: ELSE

Line 461: l_threshold_array := NULL;

457: ) IS
458: l_threshold_array THRESHOLD_ARRAY;
459: BEGIN
460: IF (p_threshold_color IS NULL) THEN
461: l_threshold_array := NULL;
462: ELSE
463: l_threshold_array := get_Color_Threshold_Array(p_threshold_color);
464: END IF;
465: Save_Color_Prop_Ranges(p_objective_id => p_objective_id

Line 463: l_threshold_array := get_Color_Threshold_Array(p_threshold_color);

459: BEGIN
460: IF (p_threshold_color IS NULL) THEN
461: l_threshold_array := NULL;
462: ELSE
463: l_threshold_array := get_Color_Threshold_Array(p_threshold_color);
464: END IF;
465: Save_Color_Prop_Ranges(p_objective_id => p_objective_id
466: ,p_kpi_measure_id => p_kpi_measure_id
467: ,p_color_type => p_color_type

Line 468: ,p_threshold_color => l_threshold_array

464: END IF;
465: Save_Color_Prop_Ranges(p_objective_id => p_objective_id
466: ,p_kpi_measure_id => p_kpi_measure_id
467: ,p_color_type => p_color_type
468: ,p_threshold_color => l_threshold_array
469: ,p_property_value => p_property_value
470: ,p_cascade_shared => p_cascade_shared
471: ,p_time_stamp => p_time_stamp
472: ,x_return_status => x_return_status

Line 488: ,p_threshold_color IN THRESHOLD_ARRAY

484: p_commit IN VARCHAR2 := FND_API.G_FALSE
485: ,p_objective_id IN NUMBER
486: ,p_kpi_measure_id IN NUMBER
487: ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
488: ,p_threshold_color IN THRESHOLD_ARRAY
489: ,p_property_value IN NUMBER := NULL
490: ,p_cascade_shared IN BOOLEAN
491: ,p_time_stamp IN DATE := NULL -- Granular Locking
492: ,x_return_status OUT NOCOPY VARCHAR2

Line 822: ,p_threshold_color IN THRESHOLD_ARRAY

818: p_commit IN VARCHAR2 := FND_API.G_FALSE
819: ,p_objective_id IN NUMBER
820: ,p_kpi_measure_id IN NUMBER
821: ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
822: ,p_threshold_color IN THRESHOLD_ARRAY
823: ,p_property_value IN NUMBER := NULL
824: ,p_time_stamp IN DATE := NULL -- Granular Locking
825: ,x_return_status OUT NOCOPY VARCHAR2
826: ,x_msg_count OUT NOCOPY NUMBER

Line 1097: FUNCTION get_Color_Threshold_Array(

1093: END Create_Color_Prop_Ranges;
1094:
1095: /************************************************************************************
1096: ************************************************************************************/
1097: FUNCTION get_Color_Threshold_Array(
1098: p_threshold_color IN VARCHAR2
1099: ) RETURN THRESHOLD_ARRAY IS
1100: l_Count NUMBER;
1101: l_value VARCHAR2(200);

Line 1099: ) RETURN THRESHOLD_ARRAY IS

1095: /************************************************************************************
1096: ************************************************************************************/
1097: FUNCTION get_Color_Threshold_Array(
1098: p_threshold_color IN VARCHAR2
1099: ) RETURN THRESHOLD_ARRAY IS
1100: l_Count NUMBER;
1101: l_value VARCHAR2(200);
1102: l_threshold_color VARCHAR2(2000);
1103: l_threshold_array THRESHOLD_ARRAY;

Line 1103: l_threshold_array THRESHOLD_ARRAY;

1099: ) RETURN THRESHOLD_ARRAY IS
1100: l_Count NUMBER;
1101: l_value VARCHAR2(200);
1102: l_threshold_color VARCHAR2(2000);
1103: l_threshold_array THRESHOLD_ARRAY;
1104: BEGIN
1105:
1106: -- p_threshold_color value will be in format -> 1:20:345;2:40:345;3:80:456
1107: l_threshold_color := p_threshold_color;

Line 1111: l_threshold_array := THRESHOLD_ARRAY(1);

1107: l_threshold_color := p_threshold_color;
1108:
1109: l_count := 1;
1110:
1111: l_threshold_array := THRESHOLD_ARRAY(1);
1112: WHILE (Get_Next_Token(l_threshold_color,';',l_value)) LOOP
1113: IF(l_count > 1) THEN
1114: l_threshold_array.EXTEND;
1115: END IF;

Line 1114: l_threshold_array.EXTEND;

1110:
1111: l_threshold_array := THRESHOLD_ARRAY(1);
1112: WHILE (Get_Next_Token(l_threshold_color,';',l_value)) LOOP
1113: IF(l_count > 1) THEN
1114: l_threshold_array.EXTEND;
1115: END IF;
1116: l_threshold_array(l_count) := l_value;
1117: l_count := l_count + 1;
1118: END LOOP;

Line 1116: l_threshold_array(l_count) := l_value;

1112: WHILE (Get_Next_Token(l_threshold_color,';',l_value)) LOOP
1113: IF(l_count > 1) THEN
1114: l_threshold_array.EXTEND;
1115: END IF;
1116: l_threshold_array(l_count) := l_value;
1117: l_count := l_count + 1;
1118: END LOOP;
1119:
1120: RETURN l_threshold_array;

Line 1120: RETURN l_threshold_array;

1116: l_threshold_array(l_count) := l_value;
1117: l_count := l_count + 1;
1118: END LOOP;
1119:
1120: RETURN l_threshold_array;
1121: END get_Color_Threshold_Array;
1122:
1123: /************************************************************************************
1124: ************************************************************************************/

Line 1121: END get_Color_Threshold_Array;

1117: l_count := l_count + 1;
1118: END LOOP;
1119:
1120: RETURN l_threshold_array;
1121: END get_Color_Threshold_Array;
1122:
1123: /************************************************************************************
1124: ************************************************************************************/
1125: PROCEDURE Create_Color_Ranges(