75: p_item_type IN VARCHAR2
76: )
77: RETURN VARCHAR2 IS
78:
79: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;
80:
81: CURSOR c_item_type_meaning(p_lookup_code VARCHAR) IS
82: SELECT meaning
83: FROM fnd_lookup_values_vl
79: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;
80:
81: CURSOR c_item_type_meaning(p_lookup_code VARCHAR) IS
82: SELECT meaning
83: FROM fnd_lookup_values_vl
84: WHERE lookup_type = 'ITEM_TYPE'
85: AND lookup_code = p_lookup_code;
86:
87: BEGIN
106: p_approval_status IN VARCHAR2
107: )
108: RETURN VARCHAR2 IS
109:
110: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;
111:
112: CURSOR c_approval_status_meaning(p_approval_status_val VARCHAR) IS
113: SELECT meaning
114: FROM fnd_lookup_values
138: p_conversion_meaning IN VARCHAR2
139: )
140: RETURN VARCHAR2 IS
141:
142: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;
143:
144: CURSOR c_conversion_meaning(p_conversion_val VARCHAR) IS
145: SELECT meaning
146: FROM fnd_lookup_values_vl
142: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;
143:
144: CURSOR c_conversion_meaning(p_conversion_val VARCHAR) IS
145: SELECT meaning
146: FROM fnd_lookup_values_vl
147: WHERE lookup_type = 'MTL_CONVERSION_TYPE'
148: AND lookup_code = p_conversion_val;
149:
150: BEGIN
289: p_style_flag IN VARCHAR2
290: )
291: RETURN VARCHAR2 IS
292:
293: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;
294:
295: CURSOR c_style_flag_meaning(p_style_flag VARCHAR) IS
296: SELECT meaning
297: FROM fnd_lookup_values