260: submit in boolean)
261: as
262: cursor lookup_codes(p_lookup_type varchar2) is
263: select MEANING, LOOKUP_CODE
264: from WF_LOOKUPS
265: where LOOKUP_TYPE = p_lookup_type
266: order by MEANING;
267:
268: template varchar2(4000);
331: indexer number := otherattr;
332:
333: cursor lookup_codes(p_lookup_type varchar2) is
334: select MEANING, LOOKUP_CODE
335: from WF_LOOKUPS
336: where LOOKUP_TYPE = p_lookup_type
337: order by MEANING;
338: begin
339: -- Check number of response values.
339: -- Check number of response values.
340: begin
341: select count(1)
342: into respcnt
343: from WF_LOOKUPS
344: where LOOKUP_TYPE = format;
345: exception
346: when no_data_found then
347: return;
484: meaning varchar2(80);
485: begin
486: select WL.MEANING
487: into meaning
488: from WF_LOOKUPS WL
489: where WL.LOOKUP_TYPE = GetLookupMeaning.ltype
490: and WL.LOOKUP_CODE = GetLookupMeaning.lcode;
491:
492: return(meaning);