304: return l_cache;
305: else
306: select meaning
307: into meaning_text
308: from mfg_lookups
309: where lookup_type = arg_lookup_type
310: and lookup_code = arg_lookup_code;
311: /*
312: select lv.meaning
354: p_lookup_code number;
355:
356: cursor cur_lookup is
357: select meaning
358: from mfg_lookups
359: where lookup_type = p_lookup_type
360: and lookup_code = p_lookup_code;
361: BEGIN
362:
3033:
3034: if arg_exception_type < 999 then
3035: select meaning
3036: into l_text
3037: from mfg_lookups
3038: where lookup_type = 'MSC_X_EXCEPTION_TYPE'
3039: and lookup_code = arg_exception_type;
3040: else
3041: select EXCEPTION_TYPE exception_type_text