738: lk_type in varchar2)
739: return varchar2 is
740: cursor c is
741: select MEANING
742: from WF_LOOKUPS
743: where LOOKUP_TYPE = lk_type
744: order by MEANING;
745:
746: buffer varchar2(32000);
1092:
1093: begin
1094: select MEANING
1095: into buf
1096: from WF_LOOKUPS
1097: where LOOKUP_TYPE = lk_type and LOOKUP_CODE = lk_code;
1098: exception
1099: when no_data_found then
1100: wf_core.token('TYPE', lk_type);
1131: -- Exact match
1132: begin
1133: select LOOKUP_CODE
1134: into buf
1135: from WF_LOOKUPS
1136: where LOOKUP_TYPE = lk_type
1137: and MEANING = lk_meaning;
1138:
1139: return buf;
1145: -- Case-insensitive match
1146: begin
1147: select LOOKUP_CODE
1148: into buf
1149: from WF_LOOKUPS
1150: where LOOKUP_TYPE = lk_type
1151: and upper(MEANING) = upper(lk_meaning);
1152: exception
1153: when no_data_found then
1177: lk_type in varchar2)
1178: return varchar2 is
1179: cursor c is
1180: select LOOKUP_CODE
1181: from WF_LOOKUPS
1182: where LOOKUP_TYPE = lk_type
1183: order by LOOKUP_CODE;
1184:
1185: buffer varchar2(32000);