APPS.IGS_PE_PERS_IMP_001 dependencies on DBMS_UTILITY

Line 1796: l_hash_code := DBMS_UTILITY.GET_HASH_VALUE(p_lookup_type||'@*?'||p_lookup_code||'@*?'||p_application_id,1000,25000);

1792: THEN
1793:
1794: -- all parameters passed. Proceed further...
1795:
1796: l_hash_code := DBMS_UTILITY.GET_HASH_VALUE(p_lookup_type||'@*?'||p_lookup_code||'@*?'||p_application_id,1000,25000);
1797:
1798: IF l_lookups_tab.EXISTS(l_hash_code)
1799: THEN
1800: RETURN(TRUE);

Line 1804: l_hash_code := DBMS_UTILITY.GET_HASH_VALUE(p_lookup_type||'@*?'||p_application_id,1000,25000);

1800: RETURN(TRUE);
1801: ELSE
1802: -- check if the lookup type was cached or not.
1803:
1804: l_hash_code := DBMS_UTILITY.GET_HASH_VALUE(p_lookup_type||'@*?'||p_application_id,1000,25000);
1805:
1806: IF l_lookup_type_tab.EXISTS(l_hash_code)
1807: THEN
1808: -- Lookup type was cached, but the lookup code passed to the function is not associated with it. The combination is invalid.

Line 1820: l_hash_code:=DBMS_UTILITY.GET_HASH_VALUE(p_lookup_type||'@*?'||p_application_id,1000,25000);

1816:
1817: IF (l_var = 'X') THEN
1818: -- cache the lookup type and the lookup codes.
1819:
1820: l_hash_code:=DBMS_UTILITY.GET_HASH_VALUE(p_lookup_type||'@*?'||p_application_id,1000,25000);
1821:
1822: l_lookup_type_tab(l_hash_code):=p_lookup_type;
1823:
1824: -- cache the lookup codes for this type also.

Line 1834: l_hash_code:=DBMS_UTILITY.GET_HASH_VALUE(l_rec.lookup_type||'@*?'||l_rec.lookup_code||'@*?'||p_application_id,1000,25000);

1830:
1831: l_var2:=NULL;
1832: l_var2:=l_rec.lookup_type||'@*?'||l_rec.lookup_code;
1833:
1834: l_hash_code:=DBMS_UTILITY.GET_HASH_VALUE(l_rec.lookup_type||'@*?'||l_rec.lookup_code||'@*?'||p_application_id,1000,25000);
1835: l_lookups_tab(l_hash_code):=l_var2;
1836:
1837: END LOOP;
1838: CLOSE c_fetch_lkups;