APPS.BSC_COLOR_UPGRADE dependencies on THRESHOLD_ARRAY

Line 1014: l_threshold THRESHOLD_ARRAY;

1010: , p_m3_l3 IN NUMBER
1011: , p_m3_l4 IN NUMBER
1012: )
1013: IS
1014: l_threshold THRESHOLD_ARRAY;
1015: l_property_value NUMBER;
1016: x_return_status VARCHAR2(1);
1017: x_msg_count NUMBER(3);
1018: x_msg_data VARCHAR2(2000);

Line 1021: l_threshold := threshold_array(1,2,3);

1017: x_msg_count NUMBER(3);
1018: x_msg_data VARCHAR2(2000);
1019: BEGIN
1020: IF (p_color_method = 1 OR p_color_method IS NULL) THEN -- Target Met Above plan
1021: l_threshold := threshold_array(1,2,3);
1022: l_threshold(1) := '1::'|| p_m1_l2 ||':'|| 192; -- Red
1023: l_threshold(2) := '2:'|| p_m1_l2||':'|| p_m1_l1 ||':'|| 49919; -- Yellow
1024: l_threshold(3) := '3:'|| p_m1_l1||'::'|| 24865; --Green
1025: IF (p_color_method IS NULL) THEN

Line 1041: l_threshold := threshold_array(1,2,3);

1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039: END IF;
1040: IF (p_color_method = 2 OR p_color_method IS NULL) THEN -- Target Met Below plan
1041: l_threshold := threshold_array(1,2,3);
1042: l_threshold(1) := '1::'|| p_m2_l2 ||':'|| 24865; -- Green
1043: l_threshold(2) := '2:'|| p_m2_l2||':'|| p_m2_l1 ||':'|| 49919; -- Yellow
1044: l_threshold(3) := '3:'||p_m2_l1||'::'|| 192; --Red
1045: IF (p_color_method IS NULL) THEN

Line 1061: l_threshold := threshold_array(1,2,3,4,5);

1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059: END IF;
1060: IF (p_color_method = 3 OR p_color_method IS NULL) THEN -- Target Met In Between
1061: l_threshold := threshold_array(1,2,3,4,5);
1062: l_threshold(1) := '1::'|| p_m3_l4 ||':'|| 192; -- Red
1063: l_threshold(2) := '2:'|| p_m3_l4||':'|| p_m3_l3 ||':'|| 49919; -- Yellow
1064: l_threshold(3) := '3:'|| p_m3_l3||':'|| p_m3_l2 ||':'|| 24865; --Green
1065: l_threshold(4) := '4:'|| p_m3_l2||':'|| p_m3_l1 ||':'|| 49919; --Yellow