APPS.EGO_ITEM_COMPARE_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 79: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;

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

Line 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

Line 110: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;

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

Line 142: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;

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

Line 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

Line 293: l_display_val FND_LOOKUP_VALUES_VL.MEANING%TYPE;

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