APPS.BEN_PEP_CACHE dependencies on BEN_HASH_UTILITY

Line 65: ben_hash_utility.get_hashed_index.

61: logical reads.
62: 115.24 04-May-05 mhoyes - Bug 4350303. Backed out nocopy due to
63: performance regression.
64: 115.25 06-May-05 mhoyes - Bug 4350303. Bypassed call to hash function
65: ben_hash_utility.get_hashed_index.
66: - Removed obsolete procedures.
67: 115.26 30-May-05 mhoyes - Bug 4400538. Moved local procedures out to
68: ben_pep_cache2.
69: 115.27 12-jun-05 mhoyes - Bug 4425771. Defined package locals as

Line 137: -- l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_pgm_id,1)+nvl(p_pl_id,2)

133: -- Get the hashed value
134: -- Bug 4350303
135: l_hv := mod(nvl(p_pgm_id,1)+nvl(p_pl_id,2)+nvl(p_plip_id,3)
136: +nvl(p_ptip_id,4),g_hash_key);
137: -- l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_pgm_id,1)+nvl(p_pl_id,2)
138: -- +nvl(p_plip_id,3)+nvl(p_ptip_id,4));
139: -- Bug 4350303
140: --
141: -- Check the pgm and pl combination is correct

Line 249: -- l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_opt_id,1)+nvl(p_pgm_id,2)

245: --
246: -- Bug 4350303
247: l_hv := mod(nvl(p_opt_id,1)+nvl(p_pgm_id,2)+nvl(p_pl_id,3)
248: +nvl(p_plip_id,4),g_hash_key);
249: -- l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_opt_id,1)+nvl(p_pgm_id,2)
250: -- +nvl(p_pl_id,3)+nvl(p_plip_id,4));
251: -- Bug 4350303
252: --
253: -- Check the pgm and pl combination is correct