DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on MFG_LOOKUPS

Line 168: l_lookup_meaning MFG_LOOKUPS.MEANING%TYPE;

164: , p_old_context NUMBER
165: , p_new_context NUMBER
166: ) RETURN BOOLEAN IS
167:
168: l_lookup_meaning MFG_LOOKUPS.MEANING%TYPE;
169:
170: BEGIN
171: IF ( p_old_context = LPN_CONTEXT_INV ) THEN
172: IF ( p_new_context IN(1, 2, 3, 4, 5, 6, 8, 11) ) THEN

Line 227: FROM mfg_lookups

223: fnd_message.set_name('INV', 'WMS_CONTEXT_CHANGE_ERR');
224:
225: SELECT meaning
226: INTO l_lookup_meaning
227: FROM mfg_lookups
228: WHERE lookup_type = 'WMS_LPN_CONTEXT'
229: AND lookup_code = p_old_context;
230: fnd_message.set_token('CONTEXT1', l_lookup_meaning);
231:

Line 234: FROM mfg_lookups

230: fnd_message.set_token('CONTEXT1', l_lookup_meaning);
231:
232: SELECT meaning
233: INTO l_lookup_meaning
234: FROM mfg_lookups
235: WHERE lookup_type = 'WMS_LPN_CONTEXT'
236: AND lookup_code = p_new_context;
237: fnd_message.set_token('CONTEXT2', l_lookup_meaning);
238: