1750: --Get Value Set Display Code
1751: ------------------------------
1752: SELECT value_set_display_code
1753: INTO l_value_set_display_code
1754: FROM fem_value_sets_b
1755: WHERE value_set_id = l_value_set_id;
1756:
1757: FEM_ENGINES_PKG.Tech_Message (
1758: p_severity => c_log_level_1
1938: IF (l_value_set_id IS NOT NULL) THEN
1939: BEGIN
1940: SELECT value_set_display_code
1941: INTO l_value_set_display_code
1942: FROM fem_value_sets_b
1943: WHERE value_set_id = l_value_set_id;
1944:
1945: EXCEPTION
1946: WHEN NO_DATA_FOUND THEN
2107: );
2108:
2109: SELECT value_set_display_code
2110: INTO l_value_set_display_code
2111: FROM fem_value_sets_b
2112: WHERE value_set_id= p_value_set_id;
2113:
2114: FEM_ENGINES_PKG.Tech_Message (
2115: p_severity => c_log_level_2
2212:
2213:
2214: SELECT value_set_id
2215: INTO l_value_set_id
2216: FROM fem_value_sets_b
2217: WHERE value_set_display_code= p_value_set_display_code;
2218:
2219: FEM_ENGINES_PKG.Tech_Message (
2220: p_severity => c_log_level_2