DBA Data[Home] [Help]

APPS.EGO_ITEM_COMPARE_PKG dependencies on FND_LOOKUP_VALUES

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 114: FROM fnd_lookup_values

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
115: WHERE language = userenv('LANG')
116: AND lookup_type = 'INV_ITEM_APPROVAL_STATUS'
117: AND lookup_code = p_approval_status_val;
118:

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

Line 297: FROM fnd_lookup_values

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
298: WHERE language = userenv('LANG')
299: AND lookup_type = 'EGO_YES_NO'
300: AND lookup_code = p_style_flag;
301:

Line 392: --FND_LOOKUP_VALUES.MEANING is VARCHAR(80).

388: l_item_attr_val VARCHAR2(1000);
389:
390: --Some Item Attribute values are CODEs that need to be translated into
391: --Meanings, which will be displayed to the user.
392: --FND_LOOKUP_VALUES.MEANING is VARCHAR(80).
393: --There might be other types of Code to Meaning translation other than
394: --through FND_LOOKUP_VALUES, so having a little more length.
395: l_display_val VARCHAR2(200);
396:

Line 394: --through FND_LOOKUP_VALUES, so having a little more length.

390: --Some Item Attribute values are CODEs that need to be translated into
391: --Meanings, which will be displayed to the user.
392: --FND_LOOKUP_VALUES.MEANING is VARCHAR(80).
393: --There might be other types of Code to Meaning translation other than
394: --through FND_LOOKUP_VALUES, so having a little more length.
395: l_display_val VARCHAR2(200);
396:
397: l_exec_val PLS_INTEGER;
398: