263:
264: END IF;
265:
266: -- Get the hash value of the Type + Code
267: l_hash_code := DBMS_UTILITY.get_hash_value(
268: p_lookup_type||'@*?'||p_lookup_code,
269: 1000,
270: 25000);
271:
274: return(l_meaning);
275: END IF;
276:
277: -- Check if the Type is already cached
278: l_hash_type := DBMS_UTILITY.get_hash_value(
279: p_lookup_type,
280: 1000,
281: 25000);
282:
296:
297: -- Cache the Lookup Type only once
298: IF NOT l_is_lktype_chc THEN
299: l_is_lktype_chc := TRUE;
300: l_hash_type := DBMS_UTILITY.get_hash_value(
301: p_lookup_type,
302: 1000,
303: 25000
304: );
305: l_lookups_type_rec(l_hash_type) := p_lookup_type;
306:
307: END IF;
308:
309: l_db_hash_code := DBMS_UTILITY.get_hash_value(
310: l_lookup_rec.lookup_type||'@*?'||l_lookup_rec.lookup_code,
311: 1000,
312: 25000);
313:
375: return(NULL);
376: END IF;
377:
378: -- Get the hash value of the Type + Code
379: l_hash_code := DBMS_UTILITY.get_hash_value(
380: p_lookup_type||'@*?'||p_lookup_code||'@*?'||p_sys_award_year,
381: 1000,
382: 25000);
383:
386: return(l_meaning);
387: END IF;
388:
389: -- Check if the Type is already cached
390: l_hash_type := DBMS_UTILITY.get_hash_value(
391: p_lookup_type||'@*?'||p_sys_award_year,
392: 1000,
393: 25000);
394:
407:
408: -- Cache the Lookup Type only once
409: IF NOT l_is_lktype_chc THEN
410: l_is_lktype_chc := TRUE;
411: l_hash_type := DBMS_UTILITY.get_hash_value(
412: p_lookup_type||'@*?'||p_sys_award_year,
413: 1000,
414: 25000
415: );
416: l_lookups_type_rec(l_hash_type) := p_lookup_type;
417:
418: END IF;
419:
420: l_db_hash_code := DBMS_UTILITY.get_hash_value(
421: l_lookup_rec.lookup_type||'@*?'||l_lookup_rec.lookup_code||'@*?'||p_sys_award_year,
422: 1000,
423: 25000);
424: