294: IS
295: BEGIN
296: SELECT REPLACE (meaning, '''', ''''''), meaning
297: BULK COLLECT INTO g_status_codes, g_status_codes_orig
298: FROM mfg_lookups
299: WHERE lookup_type = 'WMS_TASK_STATUS'
300: ORDER BY lookup_code;
301: END;
302:
304: IS
305: BEGIN
306: SELECT REPLACE (meaning, '''', ''''''), meaning
307: BULK COLLECT INTO g_task_types, g_task_types_orig
308: FROM mfg_lookups
309: WHERE lookup_type = 'WMS_TASK_TYPES'
310: ORDER BY lookup_code;
311: END;
312:
315: IS
316: BEGIN
317: SELECT REPLACE (meaning, '''', '''''')
318: BULK COLLECT INTO g_plan_task_types
319: FROM mfg_lookups
320: WHERE lookup_type = 'WMS_PLAN_TASK_TYPES'
321: ORDER BY lookup_code;
322: END set_plan_task_types;
323:
325: IS
326: BEGIN
327: SELECT REPLACE (meaning, '''', '''''')
328: BULK COLLECT INTO g_plan_status_codes
329: FROM mfg_lookups
330: WHERE lookup_type = 'WMS_OP_PLAN_INSTANCE_STATUS'
331: ORDER BY lookup_code;
332: END;
333: