1315: BEGIN
1316: IF p_lookup_code IS NOT NULL AND
1317: p_lookup_type IS NOT NULL THEN
1318:
1319: l_hash_value := DBMS_UTILITY.get_hash_value(
1320: p_lookup_type||'@*?'||p_lookup_code,
1321: 1000,
1322: 25000);
1323:
1352: l_hash_value NUMBER;
1353: BEGIN
1354: IF p_param_value IS NOT NULL THEN
1355:
1356: l_hash_value := DBMS_UTILITY.get_hash_value(
1357: p_param_value,
1358: 1000,
1359: 25000);
1360:
1867: l_hash_value NUMBER;
1868: BEGIN
1869: IF p_Identifier IS NOT NULL THEN
1870:
1871: l_hash_value := DBMS_UTILITY.get_hash_value(
1872: p_Identifier||'@*?',
1873: 1000,
1874: 25000);
1875: