275: BEGIN
276: IF X_lookup_code IS NOT NULL AND
277: X_lookup_type IS NOT NULL THEN
278:
279: l_hash_value := DBMS_UTILITY.get_hash_value(
280: X_lookup_type||'@*?'||X_lookup_code,
281: 1000,
282: 25000);
283:
321: BEGIN
322: IF X_Meaning IS NOT NULL AND
323: X_lookup_type IS NOT NULL THEN
324:
325: l_hash_value := DBMS_UTILITY.get_hash_value(
326: X_lookup_type||'@*?'||X_meaning,
327: 1000,
328: 25000);
329: IF faxlkpcd_table.EXISTS(l_hash_value) THEN