[Home] [Help]
3: --
4: -- Declare globals
5: --
6: g_package varchar2(50) := 'ben_elp_cache.';
7: g_hash_key number := ben_hash_utility.get_hash_key;
8: g_hash_jump number := ben_hash_utility.get_hash_jump;
9: --
10: -- cobcep
11: --
4: -- Declare globals
5: --
6: g_package varchar2(50) := 'ben_elp_cache.';
7: g_hash_key number := ben_hash_utility.get_hash_key;
8: g_hash_jump number := ben_hash_utility.get_hash_jump;
9: --
10: -- cobcep
11: --
12: g_cobcep_lookup ben_cache.g_cache_lookup_table;
385: )
386: loop
387: --
388: l_hv := mod(nvl(row.pgm_id,1)+nvl(row.ptip_id,2)+nvl(row.plip_id,3)
389: +nvl(row.pl_id,4)+nvl(row.oipl_id,5),ben_hash_utility.get_hash_key);
390: --
391: while ben_elp_cache.g_cobcep_lookup.exists(l_hv)
392: loop
393: --
418: --
419: -- hr_utility.set_location(' St inst loop '||l_proc,10);
420: --
421: l_hv := mod(nvl(objinst.pgm_id,1)+nvl(objinst.ptip_id,2)+nvl(objinst.plip_id,3)
422: +nvl(objinst.pl_id,4)+nvl(objinst.oipl_id,5),ben_hash_utility.get_hash_key);
423: --
424: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
425: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
426: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
588: --
589: -- Get the instance details
590: --
591: l_hv := mod(nvl(p_pgm_id,1)+nvl(p_ptip_id,2)+nvl(p_plip_id,3)
592: +nvl(p_pl_id,4)+nvl(p_oipl_id,5),ben_hash_utility.get_hash_key);
593: --
594: -- Check if hashed value is already allocated
595: --
596: if ben_elp_cache.g_cobcep_lookup.exists(l_hv) then
610: -- Loop until un-allocated has value is derived
611: --
612: while not l_not_hash_found loop
613: --
614: l_hv := ben_hash_utility.get_next_hash_index(p_hash_index => l_hv);
615: --
616: -- Check if the hash index exists, and compare the values
617: --
618: if nvl(g_cobcep_lookup(l_hv).id,-1) = nvl(p_pgm_id,-1)
1104: --
1105: -- Get the instance details
1106: --
1107: l_hv := mod(nvl(p_pgm_id,1)+nvl(p_ptip_id,2)+nvl(p_plip_id,3)
1108: +nvl(p_pl_id,4)+nvl(p_oipl_id,5),ben_hash_utility.get_hash_key);
1109: --
1110: -- Get a unique hash value
1111: --
1112: if g_copcep_odlookup.exists(l_hv) then
1127: -- Loop until un-allocated has value is derived
1128: --
1129: while not l_not_hash_found loop
1130: --
1131: l_hv := ben_hash_utility.get_next_hash_index(p_hash_index => l_hv);
1132: --
1133: -- Check if the hash index exists, and compare the values
1134: --
1135: if nvl(g_copcep_odlookup(l_hv).id,-1) = nvl(p_pgm_id,-1)
1386: --
1387: -- Get the instance details
1388: --
1389: l_hv := mod(nvl(p_pgm_id,1)+nvl(p_ptip_id,2)+nvl(p_plip_id,3)
1390: +nvl(p_pl_id,4)+nvl(p_oipl_id,5),ben_hash_utility.get_hash_key);
1391: --
1392: -- Check if hashed value is already allocated
1393: --
1394: if g_copcep_odlookup.exists(l_hv) then
1409: -- Loop until un-allocated has value is derived
1410: --
1411: while not l_not_hash_found loop
1412: --
1413: l_hv := ben_hash_utility.get_next_hash_index(p_hash_index => l_hv);
1414: --
1415: -- Check if the hash index exists, and compare the values
1416: --
1417: if nvl(g_copcep_odlookup(l_hv).id,-1) = nvl(p_pgm_id,-1)
1700: l_torrwnum := 0;
1701: --
1702: if upper(p_cache_code) = 'ELPEPT' then
1703: --
1704: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
1705: --
1706: -- Check if hashed value is already allocated
1707: --
1708: if g_elpept_lookup.exists(l_index) then
1716: -- Loop until un-allocated has value is derived
1717: --
1718: while not l_not_hash_found loop
1719: --
1720: l_index := ben_hash_utility.get_next_hash_index
1721: (p_hash_index => l_index);
1722: --
1723: -- Check if the hash index exists, if not we can use it
1724: --
1752: end loop;
1753: --
1754: elsif upper(p_cache_code) = 'ELPEES' then
1755: --
1756: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
1757: --
1758: -- Check if hashed value is already allocated
1759: --
1760: if g_elpees_lookup.exists(l_index) then
1768: -- Loop until un-allocated has value is derived
1769: --
1770: while not l_not_hash_found loop
1771: --
1772: l_index := ben_hash_utility.get_next_hash_index
1773: (p_hash_index => l_index);
1774: --
1775: -- Check if the hash index exists, if not we can use it
1776: --
1804: end loop;
1805: --
1806: elsif upper(p_cache_code) = 'ELPESA' then
1807: --
1808: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
1809: --
1810: -- Check if hashed value is already allocated
1811: --
1812: if g_elpesa_lookup.exists(l_index) then
1820: -- Loop until un-allocated has value is derived
1821: --
1822: while not l_not_hash_found loop
1823: --
1824: l_index := ben_hash_utility.get_next_hash_index
1825: (p_hash_index => l_index);
1826: --
1827: -- Check if the hash index exists, if not we can use it
1828: --
1856: end loop;
1857: --
1858: elsif upper(p_cache_code) = 'ELPEHS' then
1859: --
1860: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
1861: --
1862: -- Check if hashed value is already allocated
1863: --
1864: if g_elpehs_lookup.exists(l_index) then
1872: -- Loop until un-allocated has value is derived
1873: --
1874: while not l_not_hash_found loop
1875: --
1876: l_index := ben_hash_utility.get_next_hash_index
1877: (p_hash_index => l_index);
1878: --
1879: -- Check if the hash index exists, if not we can use it
1880: --
1908: end loop;
1909: --
1910: elsif upper(p_cache_code) = 'ELPELS' then
1911: --
1912: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
1913: --
1914: -- Check if hashed value is already allocated
1915: --
1916: if g_elpels_lookup.exists(l_index) then
1924: -- Loop until un-allocated has value is derived
1925: --
1926: while not l_not_hash_found loop
1927: --
1928: l_index := ben_hash_utility.get_next_hash_index
1929: (p_hash_index => l_index);
1930: --
1931: -- Check if the hash index exists, if not we can use it
1932: --
1960: end loop;
1961: --
1962: elsif upper(p_cache_code) = 'ELPECP' then
1963: --
1964: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
1965: --
1966: -- Check if hashed value is already allocated
1967: --
1968: if g_elpecp_lookup.exists(l_index) then
1976: -- Loop until un-allocated has value is derived
1977: --
1978: while not l_not_hash_found loop
1979: --
1980: l_index := ben_hash_utility.get_next_hash_index
1981: (p_hash_index => l_index);
1982: --
1983: -- Check if the hash index exists, if not we can use it
1984: --
2099: begin
2100: --
2101: for objlook in c_elpepg_look loop
2102: --
2103: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
2104: --
2105: -- Check if hashed value is already allocated
2106: --
2107: if g_cache_elpepg_lookup.exists(l_id) then
2111: -- Loop until un-allocated has value is derived
2112: --
2113: while not l_not_hash_found loop
2114: --
2115: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2116: --
2117: -- Check if the hash index exists, if not we can use it
2118: --
2119: if not g_cache_elpepg_lookup.exists(l_id) then
2144: for objinst in c_elpepg_inst loop
2145: --
2146: -- Populate the cache lookup details
2147: --
2148: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
2149: --
2150: -- Check if hashed value is already allocated
2151: --
2152: if g_cache_elpepg_lookup(l_id).id = objinst.eligy_prfl_id then
2156: else
2157: --
2158: loop
2159: --
2160: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2161: --
2162: if g_cache_elpepg_lookup(l_id).id = objinst.eligy_prfl_id then
2163: --
2164: exit;
2271: --
2272: -- Get the instance details
2273: --
2274: l_torrwnum := 0;
2275: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
2276: --
2277: -- Check if hashed value is already allocated
2278: --
2279: if g_cache_elpepg_lookup.exists(l_index) then
2287: -- Loop until un-allocated has value is derived
2288: --
2289: while not l_not_hash_found loop
2290: --
2291: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
2292: --
2293: -- Check if the hash index exists, if not we can use it
2294: --
2295: if not g_cache_elpepg_lookup.exists(l_index) then
2377: begin
2378: --
2379: for objlook in c_elpept_look loop
2380: --
2381: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
2382: --
2383: -- Check if hashed value is already allocated
2384: --
2385: if g_cache_elpept_lookup.exists(l_id) then
2389: -- Loop until un-allocated has value is derived
2390: --
2391: while not l_not_hash_found loop
2392: --
2393: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2394: --
2395: -- Check if the hash index exists, if not we can use it
2396: --
2397: if not g_cache_elpept_lookup.exists(l_id) then
2422: for objinst in c_elpept_inst loop
2423: --
2424: -- Populate the cache lookup details
2425: --
2426: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
2427: --
2428: -- Check if hashed value is already allocated
2429: --
2430: if g_cache_elpept_lookup(l_id).id = objinst.eligy_prfl_id then
2434: else
2435: --
2436: loop
2437: --
2438: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2439: --
2440: if g_cache_elpept_lookup(l_id).id = objinst.eligy_prfl_id then
2441: --
2442: exit;
2523: --
2524: -- Get the instance details
2525: --
2526: l_torrwnum := 0;
2527: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
2528: --
2529: -- Check if hashed value is already allocated
2530: --
2531: if g_cache_elpept_lookup.exists(l_index) then
2539: -- Loop until un-allocated has value is derived
2540: --
2541: while not l_not_hash_found loop
2542: --
2543: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
2544: --
2545: -- Check if the hash index exists, if not we can use it
2546: --
2547: if not g_cache_elpept_lookup.exists(l_index) then
2628: begin
2629: --
2630: for objlook in c_elpean_look loop
2631: --
2632: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
2633: --
2634: -- Check if hashed value is already allocated
2635: --
2636: if g_cache_elpean_lookup.exists(l_id) then
2640: -- Loop until un-allocated has value is derived
2641: --
2642: while not l_not_hash_found loop
2643: --
2644: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2645: --
2646: -- Check if the hash index exists, if not we can use it
2647: --
2648: if not g_cache_elpean_lookup.exists(l_id) then
2673: for objinst in c_elpean_inst loop
2674: --
2675: -- Populate the cache lookup details
2676: --
2677: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
2678: --
2679: -- Check if hashed value is already allocated
2680: --
2681: if g_cache_elpean_lookup(l_id).id = objinst.eligy_prfl_id then
2685: else
2686: --
2687: loop
2688: --
2689: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2690: --
2691: if g_cache_elpean_lookup(l_id).id = objinst.eligy_prfl_id then
2692: --
2693: exit;
2770: --
2771: -- Get the instance details
2772: --
2773: l_torrwnum := 0;
2774: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
2775: --
2776: -- Check if hashed value is already allocated
2777: --
2778: if g_cache_elpean_lookup.exists(l_index) then
2786: -- Loop until un-allocated has value is derived
2787: --
2788: while not l_not_hash_found loop
2789: --
2790: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
2791: --
2792: -- Check if the hash index exists, if not we can use it
2793: --
2794: if not g_cache_elpean_lookup.exists(l_index) then
2871: begin
2872: --
2873: for objlook in c_elperl_look loop
2874: --
2875: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
2876: --
2877: -- Check if hashed value is already allocated
2878: --
2879: if g_cache_elperl_lookup.exists(l_id) then
2883: -- Loop until un-allocated has value is derived
2884: --
2885: while not l_not_hash_found loop
2886: --
2887: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2888: --
2889: -- Check if the hash index exists, if not we can use it
2890: --
2891: if not g_cache_elperl_lookup.exists(l_id) then
2916: for objinst in c_elperl_inst loop
2917: --
2918: -- Populate the cache lookup details
2919: --
2920: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
2921: --
2922: -- Check if hashed value is already allocated
2923: --
2924: if g_cache_elperl_lookup(l_id).id = objinst.eligy_prfl_id then
2928: else
2929: --
2930: loop
2931: --
2932: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2933: --
2934: if g_cache_elperl_lookup(l_id).id = objinst.eligy_prfl_id then
2935: --
2936: exit;
3012: --
3013: -- Get the instance details
3014: --
3015: l_torrwnum := 0;
3016: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
3017: --
3018: -- Check if hashed value is already allocated
3019: --
3020: if g_cache_elperl_lookup.exists(l_index) then
3028: -- Loop until un-allocated has value is derived
3029: --
3030: while not l_not_hash_found loop
3031: --
3032: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
3033: --
3034: -- Check if the hash index exists, if not we can use it
3035: --
3036: if not g_cache_elperl_lookup.exists(l_index) then
3115: begin
3116: --
3117: for objlook in c_elpees_look loop
3118: --
3119: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
3120: --
3121: -- Check if hashed value is already allocated
3122: --
3123: if g_cache_elpees_lookup.exists(l_id) then
3127: -- Loop until un-allocated has value is derived
3128: --
3129: while not l_not_hash_found loop
3130: --
3131: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3132: --
3133: -- Check if the hash index exists, if not we can use it
3134: --
3135: if not g_cache_elpees_lookup.exists(l_id) then
3160: for objinst in c_elpees_inst loop
3161: --
3162: -- Populate the cache lookup details
3163: --
3164: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
3165: --
3166: -- Check if hashed value is already allocated
3167: --
3168: if g_cache_elpees_lookup(l_id).id = objinst.eligy_prfl_id then
3172: else
3173: --
3174: loop
3175: --
3176: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3177: --
3178: if g_cache_elpees_lookup(l_id).id = objinst.eligy_prfl_id then
3179: --
3180: exit;
3257: --
3258: -- Get the instance details
3259: --
3260: l_torrwnum := 0;
3261: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
3262: --
3263: -- Check if hashed value is already allocated
3264: --
3265: if g_cache_elpees_lookup.exists(l_index) then
3273: -- Loop until un-allocated has value is derived
3274: --
3275: while not l_not_hash_found loop
3276: --
3277: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
3278: --
3279: -- Check if the hash index exists, if not we can use it
3280: --
3281: if not g_cache_elpees_lookup.exists(l_index) then
3378: begin
3379: --
3380: for objlook in c_elpesa_look loop
3381: --
3382: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
3383: --
3384: -- Check if hashed value is already allocated
3385: --
3386: if g_cache_elpesa_lookup.exists(l_id) then
3390: -- Loop until un-allocated has value is derived
3391: --
3392: while not l_not_hash_found loop
3393: --
3394: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3395: --
3396: -- Check if the hash index exists, if not we can use it
3397: --
3398: if not g_cache_elpesa_lookup.exists(l_id) then
3423: for objinst in c_elpesa_inst loop
3424: --
3425: -- Populate the cache lookup details
3426: --
3427: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
3428: --
3429: -- Check if hashed value is already allocated
3430: --
3431: if g_cache_elpesa_lookup(l_id).id = objinst.eligy_prfl_id then
3435: else
3436: --
3437: loop
3438: --
3439: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3440: --
3441: if g_cache_elpesa_lookup(l_id).id = objinst.eligy_prfl_id then
3442: --
3443: exit;
3521: --
3522: -- Get the instance details
3523: --
3524: l_torrwnum := 0;
3525: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
3526: --
3527: -- Check if hashed value is already allocated
3528: --
3529: if g_cache_elpesa_lookup.exists(l_index) then
3537: -- Loop until un-allocated has value is derived
3538: --
3539: while not l_not_hash_found loop
3540: --
3541: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
3542: --
3543: -- Check if the hash index exists, if not we can use it
3544: --
3545: if not g_cache_elpesa_lookup.exists(l_index) then
3634: begin
3635: --
3636: for objlook in c_elpels_look loop
3637: --
3638: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
3639: --
3640: -- Check if hashed value is already allocated
3641: --
3642: if g_cache_elpels_lookup.exists(l_id) then
3646: -- Loop until un-allocated has value is derived
3647: --
3648: while not l_not_hash_found loop
3649: --
3650: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3651: --
3652: -- Check if the hash index exists, if not we can use it
3653: --
3654: if not g_cache_elpels_lookup.exists(l_id) then
3679: for objinst in c_elpels_inst loop
3680: --
3681: -- Populate the cache lookup details
3682: --
3683: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
3684: --
3685: -- Check if hashed value is already allocated
3686: --
3687: if g_cache_elpels_lookup(l_id).id = objinst.eligy_prfl_id then
3691: else
3692: --
3693: loop
3694: --
3695: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3696: --
3697: if g_cache_elpels_lookup(l_id).id = objinst.eligy_prfl_id then
3698: --
3699: exit;
3782: --
3783: -- Get the instance details
3784: --
3785: l_torrwnum := 0;
3786: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
3787: --
3788: -- Check if hashed value is already allocated
3789: --
3790: if g_cache_elpels_lookup.exists(l_index) then
3798: -- Loop until un-allocated has value is derived
3799: --
3800: while not l_not_hash_found loop
3801: --
3802: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
3803: --
3804: -- Check if the hash index exists, if not we can use it
3805: --
3806: if not g_cache_elpels_lookup.exists(l_index) then
3897: begin
3898: --
3899: for objlook in c_elpecp_look loop
3900: --
3901: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
3902: --
3903: -- Check if hashed value is already allocated
3904: --
3905: if g_cache_elpecp_lookup.exists(l_id) then
3909: -- Loop until un-allocated has value is derived
3910: --
3911: while not l_not_hash_found loop
3912: --
3913: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3914: --
3915: -- Check if the hash index exists, if not we can use it
3916: --
3917: if not g_cache_elpecp_lookup.exists(l_id) then
3942: for objinst in c_elpecp_inst loop
3943: --
3944: -- Populate the cache lookup details
3945: --
3946: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
3947: --
3948: -- Check if hashed value is already allocated
3949: --
3950: if g_cache_elpecp_lookup(l_id).id = objinst.eligy_prfl_id then
3954: else
3955: --
3956: loop
3957: --
3958: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3959: --
3960: if g_cache_elpecp_lookup(l_id).id = objinst.eligy_prfl_id then
3961: --
3962: exit;
4043: --
4044: -- Get the instance details
4045: --
4046: l_torrwnum := 0;
4047: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
4048: --
4049: -- Check if hashed value is already allocated
4050: --
4051: if g_cache_elpecp_lookup.exists(l_index) then
4059: -- Loop until un-allocated has value is derived
4060: --
4061: while not l_not_hash_found loop
4062: --
4063: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
4064: --
4065: -- Check if the hash index exists, if not we can use it
4066: --
4067: if not g_cache_elpecp_lookup.exists(l_index) then
4146: begin
4147: --
4148: for objlook in c_elpewl_look loop
4149: --
4150: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
4151: --
4152: -- Check if hashed value is already allocated
4153: --
4154: if g_cache_elpewl_lookup.exists(l_id) then
4158: -- Loop until un-allocated has value is derived
4159: --
4160: while not l_not_hash_found loop
4161: --
4162: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4163: --
4164: -- Check if the hash index exists, if not we can use it
4165: --
4166: if not g_cache_elpewl_lookup.exists(l_id) then
4191: for objinst in c_elpewl_inst loop
4192: --
4193: -- Populate the cache lookup details
4194: --
4195: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
4196: --
4197: -- Check if hashed value is already allocated
4198: --
4199: if g_cache_elpewl_lookup(l_id).id = objinst.eligy_prfl_id then
4203: else
4204: --
4205: loop
4206: --
4207: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4208: --
4209: if g_cache_elpewl_lookup(l_id).id = objinst.eligy_prfl_id then
4210: --
4211: exit;
4288: --
4289: -- Get the instance details
4290: --
4291: l_torrwnum := 0;
4292: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
4293: --
4294: -- Check if hashed value is already allocated
4295: --
4296: if g_cache_elpewl_lookup.exists(l_index) then
4304: -- Loop until un-allocated has value is derived
4305: --
4306: while not l_not_hash_found loop
4307: --
4308: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
4309: --
4310: -- Check if the hash index exists, if not we can use it
4311: --
4312: if not g_cache_elpewl_lookup.exists(l_index) then
4391: begin
4392: --
4393: for objlook in c_elpeou_look loop
4394: --
4395: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
4396: --
4397: -- Check if hashed value is already allocated
4398: --
4399: if g_cache_elpeou_lookup.exists(l_id) then
4403: -- Loop until un-allocated has value is derived
4404: --
4405: while not l_not_hash_found loop
4406: --
4407: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4408: --
4409: -- Check if the hash index exists, if not we can use it
4410: --
4411: if not g_cache_elpeou_lookup.exists(l_id) then
4436: for objinst in c_elpeou_inst loop
4437: --
4438: -- Populate the cache lookup details
4439: --
4440: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
4441: --
4442: -- Check if hashed value is already allocated
4443: --
4444: if g_cache_elpeou_lookup(l_id).id = objinst.eligy_prfl_id then
4448: else
4449: --
4450: loop
4451: --
4452: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4453: --
4454: if g_cache_elpeou_lookup(l_id).id = objinst.eligy_prfl_id then
4455: --
4456: exit;
4533: --
4534: -- Get the instance details
4535: --
4536: l_torrwnum := 0;
4537: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
4538: --
4539: -- Check if hashed value is already allocated
4540: --
4541: if g_cache_elpeou_lookup.exists(l_index) then
4549: -- Loop until un-allocated has value is derived
4550: --
4551: while not l_not_hash_found loop
4552: --
4553: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
4554: --
4555: -- Check if the hash index exists, if not we can use it
4556: --
4557: if not g_cache_elpeou_lookup.exists(l_index) then
4635: begin
4636: --
4637: for objlook in c_elpehs_look loop
4638: --
4639: l_id := ben_hash_utility.get_hashed_index(objlook.eligy_prfl_id);
4640: --
4641: -- Check if hashed value is already allocated
4642: --
4643: if g_cache_elpehs_lookup.exists(l_id) then
4647: -- Loop until un-allocated has value is derived
4648: --
4649: while not l_not_hash_found loop
4650: --
4651: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4652: --
4653: -- Check if the hash index exists, if not we can use it
4654: --
4655: if not g_cache_elpehs_lookup.exists(l_id) then
4680: for objinst in c_elpehs_inst loop
4681: --
4682: -- Populate the cache lookup details
4683: --
4684: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
4685: --
4686: -- Check if hashed value is already allocated
4687: --
4688: if g_cache_elpehs_lookup(l_id).id = objinst.eligy_prfl_id then
4692: else
4693: --
4694: loop
4695: --
4696: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4697: --
4698: if g_cache_elpehs_lookup(l_id).id = objinst.eligy_prfl_id then
4699: --
4700: exit;
4779: --
4780: -- Get the instance details
4781: --
4782: l_torrwnum := 0;
4783: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
4784: --
4785: -- Check if hashed value is already allocated
4786: --
4787: if g_cache_elpehs_lookup.exists(l_index) then
4796: --
4797: -- hr_utility.set_location('Hashing '||l_proc,40);
4798: while not l_not_hash_found loop
4799: --
4800: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
4801: --
4802: -- Check if the hash index exists, if not we can use it
4803: --
4804: if not g_cache_elpehs_lookup.exists(l_index) then
4884: begin
4885: --
4886: for objlook in c_elpefp_look loop
4887: --
4888: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
4889: --
4890: -- Check if hashed value is already allocated
4891: --
4892: if g_cache_elpefp_lookup.exists(l_id) then
4896: -- Loop until un-allocated has value is derived
4897: --
4898: while not l_not_hash_found loop
4899: --
4900: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4901: --
4902: -- Check if the hash index exists, if not we can use it
4903: --
4904: if not g_cache_elpefp_lookup.exists(l_id) then
4929: for objinst in c_elpefp_inst loop
4930: --
4931: -- Populate the cache lookup details
4932: --
4933: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
4934: --
4935: -- Check if hashed value is already allocated
4936: --
4937: if g_cache_elpefp_lookup(l_id).id = objinst.eligy_prfl_id then
4941: else
4942: --
4943: loop
4944: --
4945: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4946: --
4947: if g_cache_elpefp_lookup(l_id).id = objinst.eligy_prfl_id then
4948: --
4949: exit;
5026: --
5027: -- Get the instance details
5028: --
5029: l_torrwnum := 0;
5030: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
5031: --
5032: -- Check if hashed value is already allocated
5033: --
5034: if g_cache_elpefp_lookup.exists(l_index) then
5042: -- Loop until un-allocated has value is derived
5043: --
5044: while not l_not_hash_found loop
5045: --
5046: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
5047: --
5048: -- Check if the hash index exists, if not we can use it
5049: --
5050: if not g_cache_elpefp_lookup.exists(l_index) then
5136: begin
5137: --
5138: for objlook in c_elpesh_look loop
5139: --
5140: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
5141: --
5142: -- Check if hashed value is already allocated
5143: --
5144: if g_cache_elpesh_lookup.exists(l_id) then
5148: -- Loop until un-allocated has value is derived
5149: --
5150: while not l_not_hash_found loop
5151: --
5152: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5153: --
5154: -- Check if the hash index exists, if not we can use it
5155: --
5156: if not g_cache_elpesh_lookup.exists(l_id) then
5181: for objinst in c_elpesh_inst loop
5182: --
5183: -- Populate the cache lookup details
5184: --
5185: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
5186: --
5187: -- Check if hashed value is already allocated
5188: --
5189: if g_cache_elpesh_lookup(l_id).id = objinst.eligy_prfl_id then
5193: else
5194: --
5195: loop
5196: --
5197: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5198: --
5199: if g_cache_elpesh_lookup(l_id).id = objinst.eligy_prfl_id then
5200: --
5201: exit;
5285: --
5286: -- Get the instance details
5287: --
5288: l_torrwnum := 0;
5289: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
5290: --
5291: -- Check if hashed value is already allocated
5292: --
5293: if g_cache_elpesh_lookup.exists(l_index) then
5301: -- Loop until un-allocated has value is derived
5302: --
5303: while not l_not_hash_found loop
5304: --
5305: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
5306: --
5307: -- Check if the hash index exists, if not we can use it
5308: --
5309: if not g_cache_elpesh_lookup.exists(l_index) then
5399: begin
5400: --
5401: for objlook in c_elpehw_look loop
5402: --
5403: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
5404: --
5405: -- Check if hashed value is already allocated
5406: --
5407: if g_cache_elpehw_lookup.exists(l_id) then
5411: -- Loop until un-allocated has value is derived
5412: --
5413: while not l_not_hash_found loop
5414: --
5415: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5416: --
5417: -- Check if the hash index exists, if not we can use it
5418: --
5419: if not g_cache_elpehw_lookup.exists(l_id) then
5444: for objinst in c_elpehw_inst loop
5445: --
5446: -- Populate the cache lookup details
5447: --
5448: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
5449: --
5450: -- Check if hashed value is already allocated
5451: --
5452: if g_cache_elpehw_lookup(l_id).id = objinst.eligy_prfl_id then
5456: else
5457: --
5458: loop
5459: --
5460: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5461: --
5462: if g_cache_elpehw_lookup(l_id).id = objinst.eligy_prfl_id then
5463: --
5464: exit;
5546: --
5547: -- Get the instance details
5548: --
5549: l_torrwnum := 0;
5550: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
5551: --
5552: -- Check if hashed value is already allocated
5553: --
5554: if g_cache_elpehw_lookup.exists(l_index) then
5562: -- Loop until un-allocated has value is derived
5563: --
5564: while not l_not_hash_found loop
5565: --
5566: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
5567: --
5568: -- Check if the hash index exists, if not we can use it
5569: --
5570: if not g_cache_elpehw_lookup.exists(l_index) then
5663: begin
5664: --
5665: for objlook in c_elpecl_look loop
5666: --
5667: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
5668: --
5669: -- Check if hashed value is already allocated
5670: --
5671: if g_cache_elpecl_lookup.exists(l_id) then
5675: -- Loop until un-allocated has value is derived
5676: --
5677: while not l_not_hash_found loop
5678: --
5679: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5680: --
5681: -- Check if the hash index exists, if not we can use it
5682: --
5683: if not g_cache_elpecl_lookup.exists(l_id) then
5708: for objinst in c_elpecl_inst loop
5709: --
5710: -- Populate the cache lookup details
5711: --
5712: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
5713: --
5714: -- Check if hashed value is already allocated
5715: --
5716: if g_cache_elpecl_lookup(l_id).id = objinst.eligy_prfl_id then
5720: else
5721: --
5722: loop
5723: --
5724: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5725: --
5726: if g_cache_elpecl_lookup(l_id).id = objinst.eligy_prfl_id then
5727: --
5728: exit;
5811: --
5812: -- Get the instance details
5813: --
5814: l_torrwnum := 0;
5815: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
5816: --
5817: -- Check if hashed value is already allocated
5818: --
5819: if g_cache_elpecl_lookup.exists(l_index) then
5827: -- Loop until un-allocated has value is derived
5828: --
5829: while not l_not_hash_found loop
5830: --
5831: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
5832: --
5833: -- Check if the hash index exists, if not we can use it
5834: --
5835: if not g_cache_elpecl_lookup.exists(l_index) then
5928: begin
5929: --
5930: for objlook in c_elpepf_look loop
5931: --
5932: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
5933: --
5934: -- Check if hashed value is already allocated
5935: --
5936: if g_cache_elpepf_lookup.exists(l_id) then
5940: -- Loop until un-allocated has value is derived
5941: --
5942: while not l_not_hash_found loop
5943: --
5944: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5945: --
5946: -- Check if the hash index exists, if not we can use it
5947: --
5948: if not g_cache_elpepf_lookup.exists(l_id) then
5973: for objinst in c_elpepf_inst loop
5974: --
5975: -- Populate the cache lookup details
5976: --
5977: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
5978: --
5979: -- Check if hashed value is already allocated
5980: --
5981: if g_cache_elpepf_lookup(l_id).id = objinst.eligy_prfl_id then
5985: else
5986: --
5987: loop
5988: --
5989: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5990: --
5991: if g_cache_elpepf_lookup(l_id).id = objinst.eligy_prfl_id then
5992: --
5993: exit;
6073: --
6074: -- Get the instance details
6075: --
6076: l_torrwnum := 0;
6077: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
6078: --
6079: -- Check if hashed value is already allocated
6080: --
6081: if g_cache_elpepf_lookup.exists(l_index) then
6089: -- Loop until un-allocated has value is derived
6090: --
6091: while not l_not_hash_found loop
6092: --
6093: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
6094: --
6095: -- Check if the hash index exists, if not we can use it
6096: --
6097: if not g_cache_elpepf_lookup.exists(l_index) then
6176: begin
6177: --
6178: for objlook in c_elpegr_look loop
6179: --
6180: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
6181: --
6182: -- Check if hashed value is already allocated
6183: --
6184: if g_cache_elpegr_lookup.exists(l_id) then
6188: -- Loop until un-allocated has value is derived
6189: --
6190: while not l_not_hash_found loop
6191: --
6192: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6193: --
6194: -- Check if the hash index exists, if not we can use it
6195: --
6196: if not g_cache_elpegr_lookup.exists(l_id) then
6221: for objinst in c_elpegr_inst loop
6222: --
6223: -- Populate the cache lookup details
6224: --
6225: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
6226: --
6227: -- Check if hashed value is already allocated
6228: --
6229: if g_cache_elpegr_lookup(l_id).id = objinst.eligy_prfl_id then
6233: else
6234: --
6235: loop
6236: --
6237: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6238: --
6239: if g_cache_elpegr_lookup(l_id).id = objinst.eligy_prfl_id then
6240: --
6241: exit;
6318: --
6319: -- Get the instance details
6320: --
6321: l_torrwnum := 0;
6322: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
6323: --
6324: -- Check if hashed value is already allocated
6325: --
6326: if g_cache_elpegr_lookup.exists(l_index) then
6334: -- Loop until un-allocated has value is derived
6335: --
6336: while not l_not_hash_found loop
6337: --
6338: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
6339: --
6340: -- Check if the hash index exists, if not we can use it
6341: --
6342: if not g_cache_elpegr_lookup.exists(l_index) then
6421: begin
6422: --
6423: for objlook in c_elpegn_look loop
6424: --
6425: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
6426: --
6427: -- Check if hashed value is already allocated
6428: --
6429: if g_cache_elpegn_lookup.exists(l_id) then
6433: -- Loop until un-allocated has value is derived
6434: --
6435: while not l_not_hash_found loop
6436: --
6437: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6438: --
6439: -- Check if the hash index exists, if not we can use it
6440: --
6441: if not g_cache_elpegn_lookup.exists(l_id) then
6466: for objinst in c_elpegn_inst loop
6467: --
6468: -- Populate the cache lookup details
6469: --
6470: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
6471: --
6472: -- Check if hashed value is already allocated
6473: --
6474: if g_cache_elpegn_lookup(l_id).id = objinst.eligy_prfl_id then
6478: else
6479: --
6480: loop
6481: --
6482: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6483: --
6484: if g_cache_elpegn_lookup(l_id).id = objinst.eligy_prfl_id then
6485: --
6486: exit;
6563: --
6564: -- Get the instance details
6565: --
6566: l_torrwnum := 0;
6567: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
6568: --
6569: -- Check if hashed value is already allocated
6570: --
6571: if g_cache_elpegn_lookup.exists(l_index) then
6579: -- Loop until un-allocated has value is derived
6580: --
6581: while not l_not_hash_found loop
6582: --
6583: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
6584: --
6585: -- Check if the hash index exists, if not we can use it
6586: --
6587: if not g_cache_elpegn_lookup.exists(l_index) then
6665: begin
6666: --
6667: for objlook in c_elpejp_look loop
6668: --
6669: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
6670: --
6671: -- Check if hashed value is already allocated
6672: --
6673: if g_cache_elpejp_lookup.exists(l_id) then
6677: -- Loop until un-allocated has value is derived
6678: --
6679: while not l_not_hash_found loop
6680: --
6681: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6682: --
6683: -- Check if the hash index exists, if not we can use it
6684: --
6685: if not g_cache_elpejp_lookup.exists(l_id) then
6710: for objinst in c_elpejp_inst loop
6711: --
6712: -- Populate the cache lookup details
6713: --
6714: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
6715: --
6716: -- Check if hashed value is already allocated
6717: --
6718: if g_cache_elpejp_lookup(l_id).id = objinst.eligy_prfl_id then
6722: else
6723: --
6724: loop
6725: --
6726: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6727: --
6728: if g_cache_elpejp_lookup(l_id).id = objinst.eligy_prfl_id then
6729: --
6730: exit;
6805: --
6806: -- Get the instance details
6807: --
6808: l_torrwnum := 0;
6809: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
6810: --
6811: -- Check if hashed value is already allocated
6812: --
6813: if g_cache_elpejp_lookup.exists(l_index) then
6821: -- Loop until un-allocated has value is derived
6822: --
6823: while not l_not_hash_found loop
6824: --
6825: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
6826: --
6827: -- Check if the hash index exists, if not we can use it
6828: --
6829: if not g_cache_elpejp_lookup.exists(l_index) then
6908: begin
6909: --
6910: for objlook in c_elpepb_look loop
6911: --
6912: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
6913: --
6914: -- Check if hashed value is already allocated
6915: --
6916: if g_cache_elpepb_lookup.exists(l_id) then
6920: -- Loop until un-allocated has value is derived
6921: --
6922: while not l_not_hash_found loop
6923: --
6924: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6925: --
6926: -- Check if the hash index exists, if not we can use it
6927: --
6928: if not g_cache_elpepb_lookup.exists(l_id) then
6953: for objinst in c_elpepb_inst loop
6954: --
6955: -- Populate the cache lookup details
6956: --
6957: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
6958: --
6959: -- Check if hashed value is already allocated
6960: --
6961: if g_cache_elpepb_lookup(l_id).id = objinst.eligy_prfl_id then
6965: else
6966: --
6967: loop
6968: --
6969: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6970: --
6971: if g_cache_elpepb_lookup(l_id).id = objinst.eligy_prfl_id then
6972: --
6973: exit;
7050: --
7051: -- Get the instance details
7052: --
7053: l_torrwnum := 0;
7054: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
7055: --
7056: -- Check if hashed value is already allocated
7057: --
7058: if g_cache_elpepb_lookup.exists(l_index) then
7066: -- Loop until un-allocated has value is derived
7067: --
7068: while not l_not_hash_found loop
7069: --
7070: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
7071: --
7072: -- Check if the hash index exists, if not we can use it
7073: --
7074: if not g_cache_elpepb_lookup.exists(l_index) then
7152: begin
7153: --
7154: for objlook in c_elpepy_look loop
7155: --
7156: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
7157: --
7158: -- Check if hashed value is already allocated
7159: --
7160: if g_cache_elpepy_lookup.exists(l_id) then
7164: -- Loop until un-allocated has value is derived
7165: --
7166: while not l_not_hash_found loop
7167: --
7168: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7169: --
7170: -- Check if the hash index exists, if not we can use it
7171: --
7172: if not g_cache_elpepy_lookup.exists(l_id) then
7197: for objinst in c_elpepy_inst loop
7198: --
7199: -- Populate the cache lookup details
7200: --
7201: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
7202: --
7203: -- Check if hashed value is already allocated
7204: --
7205: if g_cache_elpepy_lookup(l_id).id = objinst.eligy_prfl_id then
7209: else
7210: --
7211: loop
7212: --
7213: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7214: --
7215: if g_cache_elpepy_lookup(l_id).id = objinst.eligy_prfl_id then
7216: --
7217: exit;
7294: --
7295: -- Get the instance details
7296: --
7297: l_torrwnum := 0;
7298: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
7299: --
7300: -- Check if hashed value is already allocated
7301: --
7302: if g_cache_elpepy_lookup.exists(l_index) then
7310: -- Loop until un-allocated has value is derived
7311: --
7312: while not l_not_hash_found loop
7313: --
7314: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
7315: --
7316: -- Check if the hash index exists, if not we can use it
7317: --
7318: if not g_cache_elpepy_lookup.exists(l_index) then
7397: begin
7398: --
7399: for objlook in c_elpebu_look loop
7400: --
7401: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
7402: --
7403: -- Check if hashed value is already allocated
7404: --
7405: if g_cache_elpebu_lookup.exists(l_id) then
7409: -- Loop until un-allocated has value is derived
7410: --
7411: while not l_not_hash_found loop
7412: --
7413: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7414: --
7415: -- Check if the hash index exists, if not we can use it
7416: --
7417: if not g_cache_elpebu_lookup.exists(l_id) then
7442: for objinst in c_elpebu_inst loop
7443: --
7444: -- Populate the cache lookup details
7445: --
7446: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
7447: --
7448: -- Check if hashed value is already allocated
7449: --
7450: if g_cache_elpebu_lookup(l_id).id = objinst.eligy_prfl_id then
7454: else
7455: --
7456: loop
7457: --
7458: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7459: --
7460: if g_cache_elpebu_lookup(l_id).id = objinst.eligy_prfl_id then
7461: --
7462: exit;
7539: --
7540: -- Get the instance details
7541: --
7542: l_torrwnum := 0;
7543: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
7544: --
7545: -- Check if hashed value is already allocated
7546: --
7547: if g_cache_elpebu_lookup.exists(l_index) then
7555: -- Loop until un-allocated has value is derived
7556: --
7557: while not l_not_hash_found loop
7558: --
7559: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
7560: --
7561: -- Check if the hash index exists, if not we can use it
7562: --
7563: if not g_cache_elpebu_lookup.exists(l_index) then
7642: begin
7643: --
7644: for objlook in c_elpelu_look loop
7645: --
7646: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
7647: --
7648: -- Check if hashed value is already allocated
7649: --
7650: if g_cache_elpelu_lookup.exists(l_id) then
7654: -- Loop until un-allocated has value is derived
7655: --
7656: while not l_not_hash_found loop
7657: --
7658: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7659: --
7660: -- Check if the hash index exists, if not we can use it
7661: --
7662: if not g_cache_elpelu_lookup.exists(l_id) then
7687: for objinst in c_elpelu_inst loop
7688: --
7689: -- Populate the cache lookup details
7690: --
7691: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
7692: --
7693: -- Check if hashed value is already allocated
7694: --
7695: if g_cache_elpelu_lookup(l_id).id = objinst.eligy_prfl_id then
7699: else
7700: --
7701: loop
7702: --
7703: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7704: --
7705: if g_cache_elpelu_lookup(l_id).id = objinst.eligy_prfl_id then
7706: --
7707: exit;
7784: --
7785: -- Get the instance details
7786: --
7787: l_torrwnum := 0;
7788: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
7789: --
7790: -- Check if hashed value is already allocated
7791: --
7792: if g_cache_elpelu_lookup.exists(l_index) then
7800: -- Loop until un-allocated has value is derived
7801: --
7802: while not l_not_hash_found loop
7803: --
7804: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
7805: --
7806: -- Check if the hash index exists, if not we can use it
7807: --
7808: if not g_cache_elpelu_lookup.exists(l_index) then
7888: begin
7889: --
7890: for objlook in c_elpelr_look loop
7891: --
7892: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
7893: --
7894: -- Check if hashed value is already allocated
7895: --
7896: if g_cache_elpelr_lookup.exists(l_id) then
7900: -- Loop until un-allocated has value is derived
7901: --
7902: while not l_not_hash_found loop
7903: --
7904: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7905: --
7906: -- Check if the hash index exists, if not we can use it
7907: --
7908: if not g_cache_elpelr_lookup.exists(l_id) then
7933: for objinst in c_elpelr_inst loop
7934: --
7935: -- Populate the cache lookup details
7936: --
7937: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
7938: --
7939: -- Check if hashed value is already allocated
7940: --
7941: if g_cache_elpelr_lookup(l_id).id = objinst.eligy_prfl_id then
7945: else
7946: --
7947: loop
7948: --
7949: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7950: --
7951: if g_cache_elpelr_lookup(l_id).id = objinst.eligy_prfl_id then
7952: --
7953: exit;
8031: --
8032: -- Get the instance details
8033: --
8034: l_torrwnum := 0;
8035: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
8036: --
8037: -- Check if hashed value is already allocated
8038: --
8039: if g_cache_elpelr_lookup.exists(l_index) then
8047: -- Loop until un-allocated has value is derived
8048: --
8049: while not l_not_hash_found loop
8050: --
8051: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
8052: --
8053: -- Check if the hash index exists, if not we can use it
8054: --
8055: if not g_cache_elpelr_lookup.exists(l_index) then
8143: begin
8144: --
8145: for objlook in c_elpeap_look loop
8146: --
8147: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
8148: --
8149: -- Check if hashed value is already allocated
8150: --
8151: if g_cache_elpeap_lookup.exists(l_id) then
8155: -- Loop until un-allocated has value is derived
8156: --
8157: while not l_not_hash_found loop
8158: --
8159: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8160: --
8161: -- Check if the hash index exists, if not we can use it
8162: --
8163: if not g_cache_elpeap_lookup.exists(l_id) then
8188: for objinst in c_elpeap_inst loop
8189: --
8190: -- Populate the cache lookup details
8191: --
8192: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
8193: --
8194: -- Check if hashed value is already allocated
8195: --
8196: if g_cache_elpeap_lookup(l_id).id = objinst.eligy_prfl_id then
8200: else
8201: --
8202: loop
8203: --
8204: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8205: --
8206: if g_cache_elpeap_lookup(l_id).id = objinst.eligy_prfl_id then
8207: --
8208: exit;
8289: --
8290: -- Get the instance details
8291: --
8292: l_torrwnum := 0;
8293: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
8294: --
8295: -- Check if hashed value is already allocated
8296: --
8297: if g_cache_elpeap_lookup.exists(l_index) then
8305: -- Loop until un-allocated has value is derived
8306: --
8307: while not l_not_hash_found loop
8308: --
8309: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
8310: --
8311: -- Check if the hash index exists, if not we can use it
8312: --
8313: if not g_cache_elpeap_lookup.exists(l_index) then
8405: begin
8406: --
8407: for objlook in c_elpepz_look loop
8408: --
8409: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
8410: --
8411: -- Check if hashed value is already allocated
8412: --
8413: if g_cache_elpepz_lookup.exists(l_id) then
8417: -- Loop until un-allocated has value is derived
8418: --
8419: while not l_not_hash_found loop
8420: --
8421: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8422: --
8423: -- Check if the hash index exists, if not we can use it
8424: --
8425: if not g_cache_elpepz_lookup.exists(l_id) then
8450: for objinst in c_elpepz_inst loop
8451: --
8452: -- Populate the cache lookup details
8453: --
8454: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
8455: --
8456: -- Check if hashed value is already allocated
8457: --
8458: if g_cache_elpepz_lookup(l_id).id = objinst.eligy_prfl_id then
8462: else
8463: --
8464: loop
8465: --
8466: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8467: --
8468: if g_cache_elpepz_lookup(l_id).id = objinst.eligy_prfl_id then
8469: --
8470: exit;
8548: --
8549: -- Get the instance details
8550: --
8551: l_torrwnum := 0;
8552: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
8553: --
8554: -- Check if hashed value is already allocated
8555: --
8556: if g_cache_elpepz_lookup.exists(l_index) then
8564: -- Loop until un-allocated has value is derived
8565: --
8566: while not l_not_hash_found loop
8567: --
8568: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
8569: --
8570: -- Check if the hash index exists, if not we can use it
8571: --
8572: if not g_cache_elpepz_lookup.exists(l_index) then
8651: begin
8652: --
8653: for objlook in c_elpebn_look loop
8654: --
8655: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
8656: --
8657: -- Check if hashed value is already allocated
8658: --
8659: if g_cache_elpebn_lookup.exists(l_id) then
8663: -- Loop until un-allocated has value is derived
8664: --
8665: while not l_not_hash_found loop
8666: --
8667: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8668: --
8669: -- Check if the hash index exists, if not we can use it
8670: --
8671: if not g_cache_elpebn_lookup.exists(l_id) then
8696: for objinst in c_elpebn_inst loop
8697: --
8698: -- Populate the cache lookup details
8699: --
8700: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
8701: --
8702: -- Check if hashed value is already allocated
8703: --
8704: if g_cache_elpebn_lookup(l_id).id = objinst.eligy_prfl_id then
8708: else
8709: --
8710: loop
8711: --
8712: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8713: --
8714: if g_cache_elpebn_lookup(l_id).id = objinst.eligy_prfl_id then
8715: --
8716: exit;
8793: --
8794: -- Get the instance details
8795: --
8796: l_torrwnum := 0;
8797: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
8798: --
8799: -- Check if hashed value is already allocated
8800: --
8801: if g_cache_elpebn_lookup.exists(l_index) then
8809: -- Loop until un-allocated has value is derived
8810: --
8811: while not l_not_hash_found loop
8812: --
8813: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
8814: --
8815: -- Check if the hash index exists, if not we can use it
8816: --
8817: if not g_cache_elpebn_lookup.exists(l_index) then
8902: begin
8903: --
8904: for objlook in c_elpeln_look loop
8905: --
8906: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
8907: --
8908: -- Check if hashed value is already allocated
8909: --
8910: if g_cache_elpeln_lookup.exists(l_id) then
8914: -- Loop until un-allocated has value is derived
8915: --
8916: while not l_not_hash_found loop
8917: --
8918: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8919: --
8920: -- Check if the hash index exists, if not we can use it
8921: --
8922: if not g_cache_elpeln_lookup.exists(l_id) then
8947: for objinst in c_elpeln_inst loop
8948: --
8949: -- Populate the cache lookup details
8950: --
8951: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
8952: --
8953: -- Check if hashed value is already allocated
8954: --
8955: if g_cache_elpeln_lookup(l_id).id = objinst.eligy_prfl_id then
8959: else
8960: --
8961: loop
8962: --
8963: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8964: --
8965: if g_cache_elpeln_lookup(l_id).id = objinst.eligy_prfl_id then
8966: --
8967: exit;
9044: --
9045: -- Get the instance details
9046: --
9047: l_torrwnum := 0;
9048: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
9049: --
9050: -- Check if hashed value is already allocated
9051: --
9052: if g_cache_elpeln_lookup.exists(l_index) then
9060: -- Loop until un-allocated has value is derived
9061: --
9062: while not l_not_hash_found loop
9063: --
9064: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
9065: --
9066: -- Check if the hash index exists, if not we can use it
9067: --
9068: if not g_cache_elpeln_lookup.exists(l_index) then
9143: begin
9144: --
9145: for objlook in c_elpepp_look loop
9146: --
9147: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
9148: --
9149: -- Check if hashed value is already allocated
9150: --
9151: if g_cache_elpepp_lookup.exists(l_id) then
9155: -- Loop until un-allocated has value is derived
9156: --
9157: while not l_not_hash_found loop
9158: --
9159: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9160: --
9161: -- Check if the hash index exists, if not we can use it
9162: --
9163: if not g_cache_elpepp_lookup.exists(l_id) then
9188: for objinst in c_elpepp_inst loop
9189: --
9190: -- Populate the cache lookup details
9191: --
9192: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
9193: --
9194: -- Check if hashed value is already allocated
9195: --
9196: if g_cache_elpepp_lookup(l_id).id = objinst.eligy_prfl_id then
9200: else
9201: --
9202: loop
9203: --
9204: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9205: --
9206: if g_cache_elpepp_lookup(l_id).id = objinst.eligy_prfl_id then
9207: --
9208: exit;
9281: --
9282: -- Get the instance details
9283: --
9284: l_torrwnum := 0;
9285: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
9286: --
9287: -- Check if hashed value is already allocated
9288: --
9289: if g_cache_elpepp_lookup.exists(l_index) then
9297: -- Loop until un-allocated has value is derived
9298: --
9299: while not l_not_hash_found loop
9300: --
9301: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
9302: --
9303: -- Check if the hash index exists, if not we can use it
9304: --
9305: if not g_cache_elpepp_lookup.exists(l_index) then
9381: begin
9382: --
9383: for objlook in c_elpeoy_look loop
9384: --
9385: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
9386: --
9387: -- Check if hashed value is already allocated
9388: --
9389: if g_cache_elpeoy_lookup.exists(l_id) then
9393: -- Loop until un-allocated has value is derived
9394: --
9395: while not l_not_hash_found loop
9396: --
9397: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9398: --
9399: -- Check if the hash index exists, if not we can use it
9400: --
9401: if not g_cache_elpeoy_lookup.exists(l_id) then
9426: for objinst in c_elpeoy_inst loop
9427: --
9428: -- Populate the cache lookup details
9429: --
9430: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
9431: --
9432: -- Check if hashed value is already allocated
9433: --
9434: if g_cache_elpeoy_lookup(l_id).id = objinst.eligy_prfl_id then
9438: else
9439: --
9440: loop
9441: --
9442: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9443: --
9444: if g_cache_elpeoy_lookup(l_id).id = objinst.eligy_prfl_id then
9445: --
9446: exit;
9521: --
9522: -- Get the instance details
9523: --
9524: l_torrwnum := 0;
9525: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
9526: --
9527: -- Check if hashed value is already allocated
9528: --
9529: if g_cache_elpeoy_lookup.exists(l_index) then
9537: -- Loop until un-allocated has value is derived
9538: --
9539: while not l_not_hash_found loop
9540: --
9541: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
9542: --
9543: -- Check if the hash index exists, if not we can use it
9544: --
9545: if not g_cache_elpeoy_lookup.exists(l_index) then
9622: begin
9623: --
9624: for objlook in c_elpetd_look loop
9625: --
9626: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
9627: --
9628: -- Check if hashed value is already allocated
9629: --
9630: if g_cache_elpetd_lookup.exists(l_id) then
9634: -- Loop until un-allocated has value is derived
9635: --
9636: while not l_not_hash_found loop
9637: --
9638: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9639: --
9640: -- Check if the hash index exists, if not we can use it
9641: --
9642: if not g_cache_elpetd_lookup.exists(l_id) then
9667: for objinst in c_elpetd_inst loop
9668: --
9669: -- Populate the cache lookup details
9670: --
9671: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
9672: --
9673: -- Check if hashed value is already allocated
9674: --
9675: if g_cache_elpetd_lookup(l_id).id = objinst.eligy_prfl_id then
9679: else
9680: --
9681: loop
9682: --
9683: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9684: --
9685: if g_cache_elpetd_lookup(l_id).id = objinst.eligy_prfl_id then
9686: --
9687: exit;
9762: --
9763: -- Get the instance details
9764: --
9765: l_torrwnum := 0;
9766: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
9767: --
9768: -- Check if hashed value is already allocated
9769: --
9770: if g_cache_elpetd_lookup.exists(l_index) then
9778: -- Loop until un-allocated has value is derived
9779: --
9780: while not l_not_hash_found loop
9781: --
9782: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index)
9783: ;
9784: --
9785: -- Check if the hash index exists, if not we can use it
9786: --
9860: begin
9861: --
9862: for objlook in c_elpeno_look loop
9863: --
9864: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
9865: --
9866: -- Check if hashed value is already allocated
9867: --
9868: if g_cache_elpeno_lookup.exists(l_id) then
9872: -- Loop until un-allocated has value is derived
9873: --
9874: while not l_not_hash_found loop
9875: --
9876: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9877: --
9878: -- Check if the hash index exists, if not we can use it
9879: --
9880: if not g_cache_elpeno_lookup.exists(l_id) then
9905: for objinst in c_elpeno_inst loop
9906: --
9907: -- Populate the cache lookup details
9908: --
9909: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
9910: --
9911: -- Check if hashed value is already allocated
9912: --
9913: if g_cache_elpeno_lookup(l_id).id = objinst.eligy_prfl_id then
9917: else
9918: --
9919: loop
9920: --
9921: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9922: --
9923: if g_cache_elpeno_lookup(l_id).id = objinst.eligy_prfl_id then
9924: --
9925: exit;
9998: --
9999: -- Get the instance details
10000: --
10001: l_torrwnum := 0;
10002: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
10003: --
10004: -- Check if hashed value is already allocated
10005: --
10006: if g_cache_elpeno_lookup.exists(l_index) then
10014: -- Loop until un-allocated has value is derived
10015: --
10016: while not l_not_hash_found loop
10017: --
10018: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
10019: --
10020: -- Check if the hash index exists, if not we can use it
10021: --
10022: if not g_cache_elpeno_lookup.exists(l_index) then
10098: begin
10099: --
10100: for objlook in c_elpeep_look loop
10101: --
10102: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
10103: --
10104: -- Check if hashed value is already allocated
10105: --
10106: if g_cache_elpeep_lookup.exists(l_id) then
10110: -- Loop until un-allocated has value is derived
10111: --
10112: while not l_not_hash_found loop
10113: --
10114: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10115: --
10116: -- Check if the hash index exists, if not we can use it
10117: --
10118: if not g_cache_elpeep_lookup.exists(l_id) then
10143: for objinst in c_elpeep_inst loop
10144: --
10145: -- Populate the cache lookup details
10146: --
10147: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
10148: --
10149: -- Check if hashed value is already allocated
10150: --
10151: if g_cache_elpeep_lookup(l_id).id = objinst.eligy_prfl_id then
10155: else
10156: --
10157: loop
10158: --
10159: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10160: --
10161: if g_cache_elpeep_lookup(l_id).id = objinst.eligy_prfl_id then
10162: --
10163: exit;
10237: --
10238: -- Get the instance details
10239: --
10240: l_torrwnum := 0;
10241: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
10242: --
10243: -- Check if hashed value is already allocated
10244: --
10245: if g_cache_elpeep_lookup.exists(l_index) then
10253: -- Loop until un-allocated has value is derived
10254: --
10255: while not l_not_hash_found loop
10256: --
10257: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
10258: --
10259: -- Check if the hash index exists, if not we can use it
10260: --
10261: if not g_cache_elpeep_lookup.exists(l_index) then
10337: begin
10338: --
10339: for objlook in c_elpeei_look loop
10340: --
10341: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
10342: --
10343: -- Check if hashed value is already allocated
10344: --
10345: if g_cache_elpeei_lookup.exists(l_id) then
10349: -- Loop until un-allocated has value is derived
10350: --
10351: while not l_not_hash_found loop
10352: --
10353: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10354: --
10355: -- Check if the hash index exists, if not we can use it
10356: --
10357: if not g_cache_elpeei_lookup.exists(l_id) then
10382: for objinst in c_elpeei_inst loop
10383: --
10384: -- Populate the cache lookup details
10385: --
10386: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
10387: --
10388: -- Check if hashed value is already allocated
10389: --
10390: if g_cache_elpeei_lookup(l_id).id = objinst.eligy_prfl_id then
10394: else
10395: --
10396: loop
10397: --
10398: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10399: --
10400: if g_cache_elpeei_lookup(l_id).id = objinst.eligy_prfl_id then
10401: --
10402: exit;
10476: --
10477: -- Get the instance details
10478: --
10479: l_torrwnum := 0;
10480: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
10481: --
10482: -- Check if hashed value is already allocated
10483: --
10484: if g_cache_elpeei_lookup.exists(l_index) then
10492: -- Loop until un-allocated has value is derived
10493: --
10494: while not l_not_hash_found loop
10495: --
10496: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
10497: --
10498: -- Check if the hash index exists, if not we can use it
10499: --
10500: if not g_cache_elpeei_lookup.exists(l_index) then
10576: begin
10577: --
10578: for objlook in c_elpeeg_look loop
10579: --
10580: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
10581: --
10582: -- Check if hashed value is already allocated
10583: --
10584: if g_cache_elpeeg_lookup.exists(l_id) then
10588: -- Loop until un-allocated has value is derived
10589: --
10590: while not l_not_hash_found loop
10591: --
10592: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10593: --
10594: -- Check if the hash index exists, if not we can use it
10595: --
10596: if not g_cache_elpeeg_lookup.exists(l_id) then
10621: for objinst in c_elpeeg_inst loop
10622: --
10623: -- Populate the cache lookup details
10624: --
10625: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
10626: --
10627: -- Check if hashed value is already allocated
10628: --
10629: if g_cache_elpeeg_lookup(l_id).id = objinst.eligy_prfl_id then
10633: else
10634: --
10635: loop
10636: --
10637: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10638: --
10639: if g_cache_elpeeg_lookup(l_id).id = objinst.eligy_prfl_id then
10640: --
10641: exit;
10715: --
10716: -- Get the instance details
10717: --
10718: l_torrwnum := 0;
10719: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
10720: --
10721: -- Check if hashed value is already allocated
10722: --
10723: if g_cache_elpeeg_lookup.exists(l_index) then
10731: -- Loop until un-allocated has value is derived
10732: --
10733: while not l_not_hash_found loop
10734: --
10735: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
10736: --
10737: -- Check if the hash index exists, if not we can use it
10738: --
10739: if not g_cache_elpeeg_lookup.exists(l_index) then
10815: begin
10816: --
10817: for objlook in c_elpedp_look loop
10818: --
10819: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
10820: --
10821: -- Check if hashed value is already allocated
10822: --
10823: if g_cache_elpedp_lookup.exists(l_id) then
10827: -- Loop until un-allocated has value is derived
10828: --
10829: while not l_not_hash_found loop
10830: --
10831: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10832: --
10833: -- Check if the hash index exists, if not we can use it
10834: --
10835: if not g_cache_elpedp_lookup.exists(l_id) then
10860: for objinst in c_elpedp_inst loop
10861: --
10862: -- Populate the cache lookup details
10863: --
10864: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
10865: --
10866: -- Check if hashed value is already allocated
10867: --
10868: if g_cache_elpedp_lookup(l_id).id = objinst.eligy_prfl_id then
10872: else
10873: --
10874: loop
10875: --
10876: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10877: --
10878: if g_cache_elpedp_lookup(l_id).id = objinst.eligy_prfl_id then
10879: --
10880: exit;
10954: --
10955: -- Get the instance details
10956: --
10957: l_torrwnum := 0;
10958: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
10959: --
10960: -- Check if hashed value is already allocated
10961: --
10962: if g_cache_elpedp_lookup.exists(l_index) then
10970: -- Loop until un-allocated has value is derived
10971: --
10972: while not l_not_hash_found loop
10973: --
10974: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
10975: --
10976: -- Check if the hash index exists, if not we can use it
10977: --
10978: if not g_cache_elpedp_lookup.exists(l_index) then
11057: begin
11058: --
11059: for objlook in c_elpelv_look loop
11060: --
11061: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
11062: --
11063: -- Check if hashed value is already allocated
11064: --
11065: if g_cache_elpelv_lookup.exists(l_id) then
11069: -- Loop until un-allocated has value is derived
11070: --
11071: while not l_not_hash_found loop
11072: --
11073: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11074: --
11075: -- Check if the hash index exists, if not we can use it
11076: --
11077: if not g_cache_elpelv_lookup.exists(l_id) then
11102: for objinst in c_elpelv_inst loop
11103: --
11104: -- Populate the cache lookup details
11105: --
11106: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
11107: --
11108: -- Check if hashed value is already allocated
11109: --
11110: if g_cache_elpelv_lookup(l_id).id = objinst.eligy_prfl_id then
11114: else
11115: --
11116: loop
11117: --
11118: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11119: --
11120: if g_cache_elpelv_lookup(l_id).id = objinst.eligy_prfl_id then
11121: --
11122: exit;
11199: --
11200: -- Get the instance details
11201: --
11202: l_torrwnum := 0;
11203: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
11204: --
11205: -- Check if hashed value is already allocated
11206: --
11207: if g_cache_elpelv_lookup.exists(l_index) then
11215: -- Loop until un-allocated has value is derived
11216: --
11217: while not l_not_hash_found loop
11218: --
11219: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
11220: --
11221: -- Check if the hash index exists, if not we can use it
11222: --
11223: if not g_cache_elpelv_lookup.exists(l_index) then
11297: begin
11298: --
11299: for objlook in c_elpeom_look loop
11300: --
11301: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
11302: --
11303: -- Check if hashed value is already allocated
11304: --
11305: if g_cache_elpeom_lookup.exists(l_id) then
11309: -- Loop until un-allocated has value is derived
11310: --
11311: while not l_not_hash_found loop
11312: --
11313: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11314: --
11315: -- Check if the hash index exists, if not we can use it
11316: --
11317: if not g_cache_elpeom_lookup.exists(l_id) then
11342: for objinst in c_elpeom_inst loop
11343: --
11344: -- Populate the cache lookup details
11345: --
11346: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
11347: --
11348: -- Check if hashed value is already allocated
11349: --
11350: if g_cache_elpeom_lookup(l_id).id = objinst.eligy_prfl_id then
11354: else
11355: --
11356: loop
11357: --
11358: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11359: --
11360: if g_cache_elpeom_lookup(l_id).id = objinst.eligy_prfl_id then
11361: --
11362: exit;
11435: --
11436: -- Get the instance details
11437: --
11438: l_torrwnum := 0;
11439: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
11440: --
11441: -- Check if hashed value is already allocated
11442: --
11443: if g_cache_elpeom_lookup.exists(l_index) then
11451: -- Loop until un-allocated has value is derived
11452: --
11453: while not l_not_hash_found loop
11454: --
11455: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
11456: --
11457: -- Check if the hash index exists, if not we can use it
11458: --
11459: if not g_cache_elpeom_lookup.exists(l_index) then
11534: begin
11535: --
11536: for objlook in c_elpeai_look loop
11537: --
11538: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
11539: --
11540: -- Check if hashed value is already allocated
11541: --
11542: if g_cache_elpeai_lookup.exists(l_id) then
11546: -- Loop until un-allocated has value is derived
11547: --
11548: while not l_not_hash_found loop
11549: --
11550: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11551: --
11552: -- Check if the hash index exists, if not we can use it
11553: --
11554: if not g_cache_elpeai_lookup.exists(l_id) then
11579: for objinst in c_elpeai_inst loop
11580: --
11581: -- Populate the cache lookup details
11582: --
11583: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
11584: --
11585: -- Check if hashed value is already allocated
11586: --
11587: if g_cache_elpeai_lookup(l_id).id = objinst.eligy_prfl_id then
11591: else
11592: --
11593: loop
11594: --
11595: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11596: --
11597: if g_cache_elpeai_lookup(l_id).id = objinst.eligy_prfl_id then
11598: --
11599: exit;
11673: --
11674: -- Get the instance details
11675: --
11676: l_torrwnum := 0;
11677: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
11678: --
11679: -- Check if hashed value is already allocated
11680: --
11681: if g_cache_elpeai_lookup.exists(l_index) then
11689: -- Loop until un-allocated has value is derived
11690: --
11691: while not l_not_hash_found loop
11692: --
11693: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
11694: --
11695: -- Check if the hash index exists, if not we can use it
11696: --
11697: if not g_cache_elpeai_lookup.exists(l_index) then
11772: begin
11773: --
11774: for objlook in c_elpedi_look loop
11775: --
11776: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
11777: --
11778: -- Check if hashed value is already allocated
11779: --
11780: if g_cache_elpedi_lookup.exists(l_id) then
11784: -- Loop until un-allocated has value is derived
11785: --
11786: while not l_not_hash_found loop
11787: --
11788: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11789: --
11790: -- Check if the hash index exists, if not we can use it
11791: --
11792: if not g_cache_elpedi_lookup.exists(l_id) then
11817: for objinst in c_elpedi_inst loop
11818: --
11819: -- Populate the cache lookup details
11820: --
11821: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
11822: --
11823: -- Check if hashed value is already allocated
11824: --
11825: if g_cache_elpedi_lookup(l_id).id = objinst.eligy_prfl_id then
11829: else
11830: --
11831: loop
11832: --
11833: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11834: --
11835: if g_cache_elpedi_lookup(l_id).id = objinst.eligy_prfl_id then
11836: --
11837: exit;
11911: --
11912: -- Get the instance details
11913: --
11914: l_torrwnum := 0;
11915: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
11916: --
11917: -- Check if hashed value is already allocated
11918: --
11919: if g_cache_elpedi_lookup.exists(l_index) then
11927: -- Loop until un-allocated has value is derived
11928: --
11929: while not l_not_hash_found loop
11930: --
11931: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
11932: --
11933: -- Check if the hash index exists, if not we can use it
11934: --
11935: if not g_cache_elpedi_lookup.exists(l_index) then
12011: begin
12012: --
12013: for objlook in c_elpeet_look loop
12014: --
12015: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
12016: --
12017: -- Check if hashed value is already allocated
12018: --
12019: if g_cache_elpeet_lookup.exists(l_id) then
12023: -- Loop until un-allocated has value is derived
12024: --
12025: while not l_not_hash_found loop
12026: --
12027: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12028: --
12029: -- Check if the hash index exists, if not we can use it
12030: --
12031: if not g_cache_elpeet_lookup.exists(l_id) then
12056: for objinst in c_elpeet_inst loop
12057: --
12058: -- Populate the cache lookup details
12059: --
12060: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
12061: --
12062: -- Check if hashed value is already allocated
12063: --
12064: if g_cache_elpeet_lookup(l_id).id = objinst.eligy_prfl_id then
12068: else
12069: --
12070: loop
12071: --
12072: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12073: --
12074: if g_cache_elpeet_lookup(l_id).id = objinst.eligy_prfl_id then
12075: --
12076: exit;
12151: --
12152: -- Get the instance details
12153: --
12154: l_torrwnum := 0;
12155: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
12156: --
12157: -- Check if hashed value is already allocated
12158: --
12159: if g_cache_elpeet_lookup.exists(l_index) then
12167: -- Loop until un-allocated has value is derived
12168: --
12169: while not l_not_hash_found loop
12170: --
12171: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
12172: --
12173: -- Check if the hash index exists, if not we can use it
12174: --
12175: if not g_cache_elpeet_lookup.exists(l_index) then
12251: begin
12252: --
12253: for objlook in c_elpedt_look loop
12254: --
12255: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
12256: --
12257: -- Check if hashed value is already allocated
12258: --
12259: if g_cache_elpedt_lookup.exists(l_id) then
12263: -- Loop until un-allocated has value is derived
12264: --
12265: while not l_not_hash_found loop
12266: --
12267: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12268: --
12269: -- Check if the hash index exists, if not we can use it
12270: --
12271: if not g_cache_elpedt_lookup.exists(l_id) then
12296: for objinst in c_elpedt_inst loop
12297: --
12298: -- Populate the cache lookup details
12299: --
12300: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
12301: --
12302: -- Check if hashed value is already allocated
12303: --
12304: if g_cache_elpedt_lookup(l_id).id = objinst.eligy_prfl_id then
12308: else
12309: --
12310: loop
12311: --
12312: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12313: --
12314: if g_cache_elpedt_lookup(l_id).id = objinst.eligy_prfl_id then
12315: --
12316: exit;
12391: --
12392: -- Get the instance details
12393: --
12394: l_torrwnum := 0;
12395: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
12396: --
12397: -- Check if hashed value is already allocated
12398: --
12399: if g_cache_elpedt_lookup.exists(l_index) then
12407: -- Loop until un-allocated has value is derived
12408: --
12409: while not l_not_hash_found loop
12410: --
12411: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
12412: --
12413: -- Check if the hash index exists, if not we can use it
12414: --
12415: if not g_cache_elpedt_lookup.exists(l_index) then
12490: begin
12491: --
12492: for objlook in c_elpedg_look loop
12493: --
12494: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
12495: --
12496: -- Check if hashed value is already allocated
12497: --
12498: if g_cache_elpedg_lookup.exists(l_id) then
12502: -- Loop until un-allocated has value is derived
12503: --
12504: while not l_not_hash_found loop
12505: --
12506: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12507: --
12508: -- Check if the hash index exists, if not we can use it
12509: --
12510: if not g_cache_elpedg_lookup.exists(l_id) then
12535: for objinst in c_elpedg_inst loop
12536: --
12537: -- Populate the cache lookup details
12538: --
12539: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
12540: --
12541: -- Check if hashed value is already allocated
12542: --
12543: if g_cache_elpedg_lookup(l_id).id = objinst.eligy_prfl_id then
12547: else
12548: --
12549: loop
12550: --
12551: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12552: --
12553: if g_cache_elpedg_lookup(l_id).id = objinst.eligy_prfl_id then
12554: --
12555: exit;
12629: --
12630: -- Get the instance details
12631: --
12632: l_torrwnum := 0;
12633: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
12634: --
12635: -- Check if hashed value is already allocated
12636: --
12637: if g_cache_elpedg_lookup.exists(l_index) then
12645: -- Loop until un-allocated has value is derived
12646: --
12647: while not l_not_hash_found loop
12648: --
12649: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
12650: --
12651: -- Check if the hash index exists, if not we can use it
12652: --
12653: if not g_cache_elpedg_lookup.exists(l_index) then
12731: begin
12732: --
12733: for objlook in c_elpecq_look loop
12734: --
12735: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
12736: --
12737: -- Check if hashed value is already allocated
12738: --
12739: if g_cache_elpecq_lookup.exists(l_id) then
12743: -- Loop until un-allocated has value is derived
12744: --
12745: while not l_not_hash_found loop
12746: --
12747: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12748: --
12749: -- Check if the hash index exists, if not we can use it
12750: --
12751: if not g_cache_elpecq_lookup.exists(l_id) then
12776: for objinst in c_elpecq_inst loop
12777: --
12778: -- Populate the cache lookup details
12779: --
12780: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
12781: --
12782: -- Check if hashed value is already allocated
12783: --
12784: if g_cache_elpecq_lookup(l_id).id = objinst.eligy_prfl_id then
12788: else
12789: --
12790: loop
12791: --
12792: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12793: --
12794: if g_cache_elpecq_lookup(l_id).id = objinst.eligy_prfl_id then
12795: --
12796: exit;
12875: --
12876: -- Get the instance details
12877: --
12878: l_torrwnum := 0;
12879: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
12880: --
12881: -- Check if hashed value is already allocated
12882: --
12883: if g_cache_elpecq_lookup.exists(l_index) then
12891: -- Loop until un-allocated has value is derived
12892: --
12893: while not l_not_hash_found loop
12894: --
12895: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
12896: --
12897: -- Check if the hash index exists, if not we can use it
12898: --
12899: if not g_cache_elpecq_lookup.exists(l_index) then