[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: -- Bug 13253435 when moved to next hash index checking whether that
2386: begin
2387: --
2388: for objlook in c_elpept_look loop
2389: --
2390: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
2391: --
2392: -- Check if hashed value is already allocated
2393: --
2394: if g_cache_elpept_lookup.exists(l_id) then
2398: -- Loop until un-allocated has value is derived
2399: --
2400: while not l_not_hash_found loop
2401: --
2402: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2403: --
2404: -- Check if the hash index exists, if not we can use it
2405: --
2406: if not g_cache_elpept_lookup.exists(l_id) then
2431: for objinst in c_elpept_inst loop
2432: --
2433: -- Populate the cache lookup details
2434: --
2435: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
2436: --
2437: -- Check if hashed value is already allocated
2438: --
2439: if g_cache_elpept_lookup(l_id).id = objinst.eligy_prfl_id then
2443: else
2444: --
2445: loop
2446: --
2447: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2448: --
2449: if g_cache_elpept_lookup(l_id).id = objinst.eligy_prfl_id then
2450: --
2451: exit;
2532: --
2533: -- Get the instance details
2534: --
2535: l_torrwnum := 0;
2536: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
2537: --
2538: -- Check if hashed value is already allocated
2539: --
2540: if g_cache_elpept_lookup.exists(l_index) then
2548: -- Loop until un-allocated has value is derived
2549: --
2550: while not l_not_hash_found loop
2551: --
2552: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
2553: --
2554: -- Check if the hash index exists, if not we can use it
2555: --
2556: -- Bug 13253435 when moved to next hash index checking whether that
2645: begin
2646: --
2647: for objlook in c_elpean_look loop
2648: --
2649: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
2650: --
2651: -- Check if hashed value is already allocated
2652: --
2653: if g_cache_elpean_lookup.exists(l_id) then
2657: -- Loop until un-allocated has value is derived
2658: --
2659: while not l_not_hash_found loop
2660: --
2661: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2662: --
2663: -- Check if the hash index exists, if not we can use it
2664: --
2665: if not g_cache_elpean_lookup.exists(l_id) then
2690: for objinst in c_elpean_inst loop
2691: --
2692: -- Populate the cache lookup details
2693: --
2694: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
2695: --
2696: -- Check if hashed value is already allocated
2697: --
2698: if g_cache_elpean_lookup(l_id).id = objinst.eligy_prfl_id then
2702: else
2703: --
2704: loop
2705: --
2706: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2707: --
2708: if g_cache_elpean_lookup(l_id).id = objinst.eligy_prfl_id then
2709: --
2710: exit;
2787: --
2788: -- Get the instance details
2789: --
2790: l_torrwnum := 0;
2791: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
2792: --
2793: -- Check if hashed value is already allocated
2794: --
2795: if g_cache_elpean_lookup.exists(l_index) then
2803: -- Loop until un-allocated has value is derived
2804: --
2805: while not l_not_hash_found loop
2806: --
2807: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
2808: --
2809: -- Check if the hash index exists, if not we can use it
2810: --
2811: -- Bug 13253435 when moved to next hash index checking whether that
2896: begin
2897: --
2898: for objlook in c_elperl_look loop
2899: --
2900: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
2901: --
2902: -- Check if hashed value is already allocated
2903: --
2904: if g_cache_elperl_lookup.exists(l_id) then
2908: -- Loop until un-allocated has value is derived
2909: --
2910: while not l_not_hash_found loop
2911: --
2912: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2913: --
2914: -- Check if the hash index exists, if not we can use it
2915: --
2916: if not g_cache_elperl_lookup.exists(l_id) then
2941: for objinst in c_elperl_inst loop
2942: --
2943: -- Populate the cache lookup details
2944: --
2945: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
2946: --
2947: -- Check if hashed value is already allocated
2948: --
2949: if g_cache_elperl_lookup(l_id).id = objinst.eligy_prfl_id then
2953: else
2954: --
2955: loop
2956: --
2957: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
2958: --
2959: if g_cache_elperl_lookup(l_id).id = objinst.eligy_prfl_id then
2960: --
2961: exit;
3037: --
3038: -- Get the instance details
3039: --
3040: l_torrwnum := 0;
3041: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
3042: --
3043: -- Check if hashed value is already allocated
3044: --
3045: if g_cache_elperl_lookup.exists(l_index) then
3053: -- Loop until un-allocated has value is derived
3054: --
3055: while not l_not_hash_found loop
3056: --
3057: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
3058: --
3059: -- Check if the hash index exists, if not we can use it
3060: --
3061: -- Bug 13253435 when moved to next hash index checking whether that
3149: begin
3150: --
3151: for objlook in c_elpees_look loop
3152: --
3153: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
3154: --
3155: -- Check if hashed value is already allocated
3156: --
3157: if g_cache_elpees_lookup.exists(l_id) then
3161: -- Loop until un-allocated has value is derived
3162: --
3163: while not l_not_hash_found loop
3164: --
3165: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3166: --
3167: -- Check if the hash index exists, if not we can use it
3168: --
3169: if not g_cache_elpees_lookup.exists(l_id) then
3194: for objinst in c_elpees_inst loop
3195: --
3196: -- Populate the cache lookup details
3197: --
3198: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
3199: --
3200: -- Check if hashed value is already allocated
3201: --
3202: if g_cache_elpees_lookup(l_id).id = objinst.eligy_prfl_id then
3206: else
3207: --
3208: loop
3209: --
3210: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3211: --
3212: if g_cache_elpees_lookup(l_id).id = objinst.eligy_prfl_id then
3213: --
3214: exit;
3291: --
3292: -- Get the instance details
3293: --
3294: l_torrwnum := 0;
3295: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
3296: --
3297: -- Check if hashed value is already allocated
3298: --
3299: if g_cache_elpees_lookup.exists(l_index) then
3307: -- Loop until un-allocated has value is derived
3308: --
3309: while not l_not_hash_found loop
3310: --
3311: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
3312: --
3313: -- Check if the hash index exists, if not we can use it
3314: --
3315: -- Bug 13253435 when moved to next hash index checking whether that
3421: begin
3422: --
3423: for objlook in c_elpesa_look loop
3424: --
3425: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
3426: --
3427: -- Check if hashed value is already allocated
3428: --
3429: if g_cache_elpesa_lookup.exists(l_id) then
3433: -- Loop until un-allocated has value is derived
3434: --
3435: while not l_not_hash_found loop
3436: --
3437: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3438: --
3439: -- Check if the hash index exists, if not we can use it
3440: --
3441: if not g_cache_elpesa_lookup.exists(l_id) then
3466: for objinst in c_elpesa_inst loop
3467: --
3468: -- Populate the cache lookup details
3469: --
3470: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
3471: --
3472: -- Check if hashed value is already allocated
3473: --
3474: if g_cache_elpesa_lookup(l_id).id = objinst.eligy_prfl_id then
3478: else
3479: --
3480: loop
3481: --
3482: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3483: --
3484: if g_cache_elpesa_lookup(l_id).id = objinst.eligy_prfl_id then
3485: --
3486: exit;
3564: --
3565: -- Get the instance details
3566: --
3567: l_torrwnum := 0;
3568: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
3569: --
3570: -- Check if hashed value is already allocated
3571: --
3572: if g_cache_elpesa_lookup.exists(l_index) then
3580: -- Loop until un-allocated has value is derived
3581: --
3582: while not l_not_hash_found loop
3583: --
3584: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
3585: --
3586: -- Check if the hash index exists, if not we can use it
3587: --
3588: -- Bug 13253435 when moved to next hash index checking whether that
3686: begin
3687: --
3688: for objlook in c_elpels_look loop
3689: --
3690: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
3691: --
3692: -- Check if hashed value is already allocated
3693: --
3694: if g_cache_elpels_lookup.exists(l_id) then
3698: -- Loop until un-allocated has value is derived
3699: --
3700: while not l_not_hash_found loop
3701: --
3702: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3703: --
3704: -- Check if the hash index exists, if not we can use it
3705: --
3706: if not g_cache_elpels_lookup.exists(l_id) then
3731: for objinst in c_elpels_inst loop
3732: --
3733: -- Populate the cache lookup details
3734: --
3735: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
3736: --
3737: -- Check if hashed value is already allocated
3738: --
3739: if g_cache_elpels_lookup(l_id).id = objinst.eligy_prfl_id then
3743: else
3744: --
3745: loop
3746: --
3747: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3748: --
3749: if g_cache_elpels_lookup(l_id).id = objinst.eligy_prfl_id then
3750: --
3751: exit;
3834: --
3835: -- Get the instance details
3836: --
3837: l_torrwnum := 0;
3838: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
3839: --
3840: -- Check if hashed value is already allocated
3841: --
3842: if g_cache_elpels_lookup.exists(l_index) then
3850: -- Loop until un-allocated has value is derived
3851: --
3852: while not l_not_hash_found loop
3853: --
3854: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
3855: --
3856: -- Check if the hash index exists, if not we can use it
3857: --
3858: -- Bug 13253435 when moved to next hash index checking whether that
3958: begin
3959: --
3960: for objlook in c_elpecp_look loop
3961: --
3962: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
3963: --
3964: -- Check if hashed value is already allocated
3965: --
3966: if g_cache_elpecp_lookup.exists(l_id) then
3970: -- Loop until un-allocated has value is derived
3971: --
3972: while not l_not_hash_found loop
3973: --
3974: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
3975: --
3976: -- Check if the hash index exists, if not we can use it
3977: --
3978: if not g_cache_elpecp_lookup.exists(l_id) then
4003: for objinst in c_elpecp_inst loop
4004: --
4005: -- Populate the cache lookup details
4006: --
4007: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
4008: --
4009: -- Check if hashed value is already allocated
4010: --
4011: if g_cache_elpecp_lookup(l_id).id = objinst.eligy_prfl_id then
4015: else
4016: --
4017: loop
4018: --
4019: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4020: --
4021: if g_cache_elpecp_lookup(l_id).id = objinst.eligy_prfl_id then
4022: --
4023: exit;
4104: --
4105: -- Get the instance details
4106: --
4107: l_torrwnum := 0;
4108: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
4109: --
4110: -- Check if hashed value is already allocated
4111: --
4112: if g_cache_elpecp_lookup.exists(l_index) then
4120: -- Loop until un-allocated has value is derived
4121: --
4122: while not l_not_hash_found loop
4123: --
4124: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
4125: --
4126: -- Check if the hash index exists, if not we can use it
4127: --
4128: -- Bug 13253435 when moved to next hash index checking whether that
4216: begin
4217: --
4218: for objlook in c_elpewl_look loop
4219: --
4220: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
4221: --
4222: -- Check if hashed value is already allocated
4223: --
4224: if g_cache_elpewl_lookup.exists(l_id) then
4228: -- Loop until un-allocated has value is derived
4229: --
4230: while not l_not_hash_found loop
4231: --
4232: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4233: --
4234: -- Check if the hash index exists, if not we can use it
4235: --
4236: if not g_cache_elpewl_lookup.exists(l_id) then
4261: for objinst in c_elpewl_inst loop
4262: --
4263: -- Populate the cache lookup details
4264: --
4265: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
4266: --
4267: -- Check if hashed value is already allocated
4268: --
4269: if g_cache_elpewl_lookup(l_id).id = objinst.eligy_prfl_id then
4273: else
4274: --
4275: loop
4276: --
4277: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4278: --
4279: if g_cache_elpewl_lookup(l_id).id = objinst.eligy_prfl_id then
4280: --
4281: exit;
4358: --
4359: -- Get the instance details
4360: --
4361: l_torrwnum := 0;
4362: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
4363: --
4364: -- Check if hashed value is already allocated
4365: --
4366: if g_cache_elpewl_lookup.exists(l_index) then
4374: -- Loop until un-allocated has value is derived
4375: --
4376: while not l_not_hash_found loop
4377: --
4378: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
4379: --
4380: -- Check if the hash index exists, if not we can use it
4381: --
4382: -- Bug 13253435 when moved to next hash index checking whether that
4470: begin
4471: --
4472: for objlook in c_elpeou_look loop
4473: --
4474: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
4475: --
4476: -- Check if hashed value is already allocated
4477: --
4478: if g_cache_elpeou_lookup.exists(l_id) then
4482: -- Loop until un-allocated has value is derived
4483: --
4484: while not l_not_hash_found loop
4485: --
4486: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4487: --
4488: -- Check if the hash index exists, if not we can use it
4489: --
4490: if not g_cache_elpeou_lookup.exists(l_id) then
4515: for objinst in c_elpeou_inst loop
4516: --
4517: -- Populate the cache lookup details
4518: --
4519: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
4520: --
4521: -- Check if hashed value is already allocated
4522: --
4523: if g_cache_elpeou_lookup(l_id).id = objinst.eligy_prfl_id then
4527: else
4528: --
4529: loop
4530: --
4531: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4532: --
4533: if g_cache_elpeou_lookup(l_id).id = objinst.eligy_prfl_id then
4534: --
4535: exit;
4612: --
4613: -- Get the instance details
4614: --
4615: l_torrwnum := 0;
4616: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
4617: --
4618: -- Check if hashed value is already allocated
4619: --
4620: if g_cache_elpeou_lookup.exists(l_index) then
4628: -- Loop until un-allocated has value is derived
4629: --
4630: while not l_not_hash_found loop
4631: --
4632: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
4633: --
4634: -- Check if the hash index exists, if not we can use it
4635: --
4636: -- Bug 13253435 when moved to next hash index checking whether that
4723: begin
4724: --
4725: for objlook in c_elpehs_look loop
4726: --
4727: l_id := ben_hash_utility.get_hashed_index(objlook.eligy_prfl_id);
4728: --
4729: -- Check if hashed value is already allocated
4730: --
4731: if g_cache_elpehs_lookup.exists(l_id) then
4735: -- Loop until un-allocated has value is derived
4736: --
4737: while not l_not_hash_found loop
4738: --
4739: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4740: --
4741: -- Check if the hash index exists, if not we can use it
4742: --
4743: if not g_cache_elpehs_lookup.exists(l_id) then
4768: for objinst in c_elpehs_inst loop
4769: --
4770: -- Populate the cache lookup details
4771: --
4772: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
4773: --
4774: -- Check if hashed value is already allocated
4775: --
4776: if g_cache_elpehs_lookup(l_id).id = objinst.eligy_prfl_id then
4780: else
4781: --
4782: loop
4783: --
4784: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4785: --
4786: if g_cache_elpehs_lookup(l_id).id = objinst.eligy_prfl_id then
4787: --
4788: exit;
4867: --
4868: -- Get the instance details
4869: --
4870: l_torrwnum := 0;
4871: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
4872: --
4873: -- Check if hashed value is already allocated
4874: --
4875: if g_cache_elpehs_lookup.exists(l_index) then
4884: --
4885: -- hr_utility.set_location('Hashing '||l_proc,40);
4886: while not l_not_hash_found loop
4887: --
4888: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
4889: --
4890: -- Check if the hash index exists, if not we can use it
4891: --
4892: -- Bug 13253435 when moved to next hash index checking whether that
4981: begin
4982: --
4983: for objlook in c_elpefp_look loop
4984: --
4985: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
4986: --
4987: -- Check if hashed value is already allocated
4988: --
4989: if g_cache_elpefp_lookup.exists(l_id) then
4993: -- Loop until un-allocated has value is derived
4994: --
4995: while not l_not_hash_found loop
4996: --
4997: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
4998: --
4999: -- Check if the hash index exists, if not we can use it
5000: --
5001: if not g_cache_elpefp_lookup.exists(l_id) then
5026: for objinst in c_elpefp_inst loop
5027: --
5028: -- Populate the cache lookup details
5029: --
5030: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
5031: --
5032: -- Check if hashed value is already allocated
5033: --
5034: if g_cache_elpefp_lookup(l_id).id = objinst.eligy_prfl_id then
5038: else
5039: --
5040: loop
5041: --
5042: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5043: --
5044: if g_cache_elpefp_lookup(l_id).id = objinst.eligy_prfl_id then
5045: --
5046: exit;
5123: --
5124: -- Get the instance details
5125: --
5126: l_torrwnum := 0;
5127: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
5128: --
5129: -- Check if hashed value is already allocated
5130: --
5131: if g_cache_elpefp_lookup.exists(l_index) then
5139: -- Loop until un-allocated has value is derived
5140: --
5141: while not l_not_hash_found loop
5142: --
5143: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
5144: --
5145: -- Check if the hash index exists, if not we can use it
5146: --
5147: -- Bug 13253435 when moved to next hash index checking whether that
5242: begin
5243: --
5244: for objlook in c_elpesh_look loop
5245: --
5246: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
5247: --
5248: -- Check if hashed value is already allocated
5249: --
5250: if g_cache_elpesh_lookup.exists(l_id) then
5254: -- Loop until un-allocated has value is derived
5255: --
5256: while not l_not_hash_found loop
5257: --
5258: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5259: --
5260: -- Check if the hash index exists, if not we can use it
5261: --
5262: if not g_cache_elpesh_lookup.exists(l_id) then
5287: for objinst in c_elpesh_inst loop
5288: --
5289: -- Populate the cache lookup details
5290: --
5291: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
5292: --
5293: -- Check if hashed value is already allocated
5294: --
5295: if g_cache_elpesh_lookup(l_id).id = objinst.eligy_prfl_id then
5299: else
5300: --
5301: loop
5302: --
5303: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5304: --
5305: if g_cache_elpesh_lookup(l_id).id = objinst.eligy_prfl_id then
5306: --
5307: exit;
5391: --
5392: -- Get the instance details
5393: --
5394: l_torrwnum := 0;
5395: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
5396: --
5397: -- Check if hashed value is already allocated
5398: --
5399: if g_cache_elpesh_lookup.exists(l_index) then
5407: -- Loop until un-allocated has value is derived
5408: --
5409: while not l_not_hash_found loop
5410: --
5411: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
5412: --
5413: -- Check if the hash index exists, if not we can use it
5414: --
5415: -- Bug 13253435 when moved to next hash index checking whether that
5514: begin
5515: --
5516: for objlook in c_elpehw_look loop
5517: --
5518: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
5519: --
5520: -- Check if hashed value is already allocated
5521: --
5522: if g_cache_elpehw_lookup.exists(l_id) then
5526: -- Loop until un-allocated has value is derived
5527: --
5528: while not l_not_hash_found loop
5529: --
5530: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5531: --
5532: -- Check if the hash index exists, if not we can use it
5533: --
5534: if not g_cache_elpehw_lookup.exists(l_id) then
5559: for objinst in c_elpehw_inst loop
5560: --
5561: -- Populate the cache lookup details
5562: --
5563: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
5564: --
5565: -- Check if hashed value is already allocated
5566: --
5567: if g_cache_elpehw_lookup(l_id).id = objinst.eligy_prfl_id then
5571: else
5572: --
5573: loop
5574: --
5575: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5576: --
5577: if g_cache_elpehw_lookup(l_id).id = objinst.eligy_prfl_id then
5578: --
5579: exit;
5661: --
5662: -- Get the instance details
5663: --
5664: l_torrwnum := 0;
5665: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
5666: --
5667: -- Check if hashed value is already allocated
5668: --
5669: if g_cache_elpehw_lookup.exists(l_index) then
5677: -- Loop until un-allocated has value is derived
5678: --
5679: while not l_not_hash_found loop
5680: --
5681: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
5682: --
5683: -- Check if the hash index exists, if not we can use it
5684: --
5685: -- Bug 13253435 when moved to next hash index checking whether that
5787: begin
5788: --
5789: for objlook in c_elpecl_look loop
5790: --
5791: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
5792: --
5793: -- Check if hashed value is already allocated
5794: --
5795: if g_cache_elpecl_lookup.exists(l_id) then
5799: -- Loop until un-allocated has value is derived
5800: --
5801: while not l_not_hash_found loop
5802: --
5803: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5804: --
5805: -- Check if the hash index exists, if not we can use it
5806: --
5807: if not g_cache_elpecl_lookup.exists(l_id) then
5832: for objinst in c_elpecl_inst loop
5833: --
5834: -- Populate the cache lookup details
5835: --
5836: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
5837: --
5838: -- Check if hashed value is already allocated
5839: --
5840: if g_cache_elpecl_lookup(l_id).id = objinst.eligy_prfl_id then
5844: else
5845: --
5846: loop
5847: --
5848: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
5849: --
5850: if g_cache_elpecl_lookup(l_id).id = objinst.eligy_prfl_id then
5851: --
5852: exit;
5935: --
5936: -- Get the instance details
5937: --
5938: l_torrwnum := 0;
5939: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
5940: --
5941: -- Check if hashed value is already allocated
5942: --
5943: if g_cache_elpecl_lookup.exists(l_index) then
5951: -- Loop until un-allocated has value is derived
5952: --
5953: while not l_not_hash_found loop
5954: --
5955: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
5956: --
5957: -- Check if the hash index exists, if not we can use it
5958: --
5959: -- Bug 13253435 when moved to next hash index checking whether that
6061: begin
6062: --
6063: for objlook in c_elpepf_look loop
6064: --
6065: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
6066: --
6067: -- Check if hashed value is already allocated
6068: --
6069: if g_cache_elpepf_lookup.exists(l_id) then
6073: -- Loop until un-allocated has value is derived
6074: --
6075: while not l_not_hash_found loop
6076: --
6077: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6078: --
6079: -- Check if the hash index exists, if not we can use it
6080: --
6081: if not g_cache_elpepf_lookup.exists(l_id) then
6106: for objinst in c_elpepf_inst loop
6107: --
6108: -- Populate the cache lookup details
6109: --
6110: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
6111: --
6112: -- Check if hashed value is already allocated
6113: --
6114: if g_cache_elpepf_lookup(l_id).id = objinst.eligy_prfl_id then
6118: else
6119: --
6120: loop
6121: --
6122: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6123: --
6124: if g_cache_elpepf_lookup(l_id).id = objinst.eligy_prfl_id then
6125: --
6126: exit;
6206: --
6207: -- Get the instance details
6208: --
6209: l_torrwnum := 0;
6210: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
6211: --
6212: -- Check if hashed value is already allocated
6213: --
6214: if g_cache_elpepf_lookup.exists(l_index) then
6222: -- Loop until un-allocated has value is derived
6223: --
6224: while not l_not_hash_found loop
6225: --
6226: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
6227: --
6228: -- Check if the hash index exists, if not we can use it
6229: --
6230: -- Bug 13253435 when moved to next hash index checking whether that
6318: begin
6319: --
6320: for objlook in c_elpegr_look loop
6321: --
6322: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
6323: --
6324: -- Check if hashed value is already allocated
6325: --
6326: if g_cache_elpegr_lookup.exists(l_id) then
6330: -- Loop until un-allocated has value is derived
6331: --
6332: while not l_not_hash_found loop
6333: --
6334: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6335: --
6336: -- Check if the hash index exists, if not we can use it
6337: --
6338: if not g_cache_elpegr_lookup.exists(l_id) then
6363: for objinst in c_elpegr_inst loop
6364: --
6365: -- Populate the cache lookup details
6366: --
6367: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
6368: --
6369: -- Check if hashed value is already allocated
6370: --
6371: if g_cache_elpegr_lookup(l_id).id = objinst.eligy_prfl_id then
6375: else
6376: --
6377: loop
6378: --
6379: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6380: --
6381: if g_cache_elpegr_lookup(l_id).id = objinst.eligy_prfl_id then
6382: --
6383: exit;
6460: --
6461: -- Get the instance details
6462: --
6463: l_torrwnum := 0;
6464: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
6465: --
6466: -- Check if hashed value is already allocated
6467: --
6468: if g_cache_elpegr_lookup.exists(l_index) then
6476: -- Loop until un-allocated has value is derived
6477: --
6478: while not l_not_hash_found loop
6479: --
6480: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
6481: --
6482: -- Check if the hash index exists, if not we can use it
6483: --
6484: -- Bug 13253435 when moved to next hash index checking whether that
6572: begin
6573: --
6574: for objlook in c_elpegn_look loop
6575: --
6576: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
6577: --
6578: -- Check if hashed value is already allocated
6579: --
6580: if g_cache_elpegn_lookup.exists(l_id) then
6584: -- Loop until un-allocated has value is derived
6585: --
6586: while not l_not_hash_found loop
6587: --
6588: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6589: --
6590: -- Check if the hash index exists, if not we can use it
6591: --
6592: if not g_cache_elpegn_lookup.exists(l_id) then
6617: for objinst in c_elpegn_inst loop
6618: --
6619: -- Populate the cache lookup details
6620: --
6621: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
6622: --
6623: -- Check if hashed value is already allocated
6624: --
6625: if g_cache_elpegn_lookup(l_id).id = objinst.eligy_prfl_id then
6629: else
6630: --
6631: loop
6632: --
6633: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6634: --
6635: if g_cache_elpegn_lookup(l_id).id = objinst.eligy_prfl_id then
6636: --
6637: exit;
6714: --
6715: -- Get the instance details
6716: --
6717: l_torrwnum := 0;
6718: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
6719: --
6720: -- Check if hashed value is already allocated
6721: --
6722: if g_cache_elpegn_lookup.exists(l_index) then
6730: -- Loop until un-allocated has value is derived
6731: --
6732: while not l_not_hash_found loop
6733: --
6734: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
6735: --
6736: -- Check if the hash index exists, if not we can use it
6737: --
6738: -- Bug 13253435 when moved to next hash index checking whether that
6825: begin
6826: --
6827: for objlook in c_elpejp_look loop
6828: --
6829: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
6830: --
6831: -- Check if hashed value is already allocated
6832: --
6833: if g_cache_elpejp_lookup.exists(l_id) then
6837: -- Loop until un-allocated has value is derived
6838: --
6839: while not l_not_hash_found loop
6840: --
6841: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6842: --
6843: -- Check if the hash index exists, if not we can use it
6844: --
6845: if not g_cache_elpejp_lookup.exists(l_id) then
6870: for objinst in c_elpejp_inst loop
6871: --
6872: -- Populate the cache lookup details
6873: --
6874: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
6875: --
6876: -- Check if hashed value is already allocated
6877: --
6878: if g_cache_elpejp_lookup(l_id).id = objinst.eligy_prfl_id then
6882: else
6883: --
6884: loop
6885: --
6886: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
6887: --
6888: if g_cache_elpejp_lookup(l_id).id = objinst.eligy_prfl_id then
6889: --
6890: exit;
6965: --
6966: -- Get the instance details
6967: --
6968: l_torrwnum := 0;
6969: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
6970: --
6971: -- Check if hashed value is already allocated
6972: --
6973: if g_cache_elpejp_lookup.exists(l_index) then
6981: -- Loop until un-allocated has value is derived
6982: --
6983: while not l_not_hash_found loop
6984: --
6985: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
6986: --
6987: -- Check if the hash index exists, if not we can use it
6988: --
6989: -- Bug 13253435 when moved to next hash index checking whether that
7077: begin
7078: --
7079: for objlook in c_elpepb_look loop
7080: --
7081: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
7082: --
7083: -- Check if hashed value is already allocated
7084: --
7085: if g_cache_elpepb_lookup.exists(l_id) then
7089: -- Loop until un-allocated has value is derived
7090: --
7091: while not l_not_hash_found loop
7092: --
7093: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7094: --
7095: -- Check if the hash index exists, if not we can use it
7096: --
7097: if not g_cache_elpepb_lookup.exists(l_id) then
7122: for objinst in c_elpepb_inst loop
7123: --
7124: -- Populate the cache lookup details
7125: --
7126: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
7127: --
7128: -- Check if hashed value is already allocated
7129: --
7130: if g_cache_elpepb_lookup(l_id).id = objinst.eligy_prfl_id then
7134: else
7135: --
7136: loop
7137: --
7138: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7139: --
7140: if g_cache_elpepb_lookup(l_id).id = objinst.eligy_prfl_id then
7141: --
7142: exit;
7219: --
7220: -- Get the instance details
7221: --
7222: l_torrwnum := 0;
7223: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
7224: --
7225: -- Check if hashed value is already allocated
7226: --
7227: if g_cache_elpepb_lookup.exists(l_index) then
7235: -- Loop until un-allocated has value is derived
7236: --
7237: while not l_not_hash_found loop
7238: --
7239: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
7240: --
7241: -- Check if the hash index exists, if not we can use it
7242: --
7243: -- Bug 13253435 when moved to next hash index checking whether that
7330: begin
7331: --
7332: for objlook in c_elpepy_look loop
7333: --
7334: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
7335: --
7336: -- Check if hashed value is already allocated
7337: --
7338: if g_cache_elpepy_lookup.exists(l_id) then
7342: -- Loop until un-allocated has value is derived
7343: --
7344: while not l_not_hash_found loop
7345: --
7346: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7347: --
7348: -- Check if the hash index exists, if not we can use it
7349: --
7350: if not g_cache_elpepy_lookup.exists(l_id) then
7375: for objinst in c_elpepy_inst loop
7376: --
7377: -- Populate the cache lookup details
7378: --
7379: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
7380: --
7381: -- Check if hashed value is already allocated
7382: --
7383: if g_cache_elpepy_lookup(l_id).id = objinst.eligy_prfl_id then
7387: else
7388: --
7389: loop
7390: --
7391: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7392: --
7393: if g_cache_elpepy_lookup(l_id).id = objinst.eligy_prfl_id then
7394: --
7395: exit;
7472: --
7473: -- Get the instance details
7474: --
7475: l_torrwnum := 0;
7476: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
7477: --
7478: -- Check if hashed value is already allocated
7479: --
7480: if g_cache_elpepy_lookup.exists(l_index) then
7488: -- Loop until un-allocated has value is derived
7489: --
7490: while not l_not_hash_found loop
7491: --
7492: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
7493: --
7494: -- Check if the hash index exists, if not we can use it
7495: --
7496: -- Bug 13253435 when moved to next hash index checking whether that
7584: begin
7585: --
7586: for objlook in c_elpebu_look loop
7587: --
7588: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
7589: --
7590: -- Check if hashed value is already allocated
7591: --
7592: if g_cache_elpebu_lookup.exists(l_id) then
7596: -- Loop until un-allocated has value is derived
7597: --
7598: while not l_not_hash_found loop
7599: --
7600: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7601: --
7602: -- Check if the hash index exists, if not we can use it
7603: --
7604: if not g_cache_elpebu_lookup.exists(l_id) then
7629: for objinst in c_elpebu_inst loop
7630: --
7631: -- Populate the cache lookup details
7632: --
7633: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
7634: --
7635: -- Check if hashed value is already allocated
7636: --
7637: if g_cache_elpebu_lookup(l_id).id = objinst.eligy_prfl_id then
7641: else
7642: --
7643: loop
7644: --
7645: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7646: --
7647: if g_cache_elpebu_lookup(l_id).id = objinst.eligy_prfl_id then
7648: --
7649: exit;
7726: --
7727: -- Get the instance details
7728: --
7729: l_torrwnum := 0;
7730: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
7731: --
7732: -- Check if hashed value is already allocated
7733: --
7734: if g_cache_elpebu_lookup.exists(l_index) then
7742: -- Loop until un-allocated has value is derived
7743: --
7744: while not l_not_hash_found loop
7745: --
7746: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
7747: --
7748: -- Check if the hash index exists, if not we can use it
7749: --
7750: -- Bug 13253435 when moved to next hash index checking whether that
7838: begin
7839: --
7840: for objlook in c_elpelu_look loop
7841: --
7842: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
7843: --
7844: -- Check if hashed value is already allocated
7845: --
7846: if g_cache_elpelu_lookup.exists(l_id) then
7850: -- Loop until un-allocated has value is derived
7851: --
7852: while not l_not_hash_found loop
7853: --
7854: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7855: --
7856: -- Check if the hash index exists, if not we can use it
7857: --
7858: if not g_cache_elpelu_lookup.exists(l_id) then
7883: for objinst in c_elpelu_inst loop
7884: --
7885: -- Populate the cache lookup details
7886: --
7887: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
7888: --
7889: -- Check if hashed value is already allocated
7890: --
7891: if g_cache_elpelu_lookup(l_id).id = objinst.eligy_prfl_id then
7895: else
7896: --
7897: loop
7898: --
7899: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
7900: --
7901: if g_cache_elpelu_lookup(l_id).id = objinst.eligy_prfl_id then
7902: --
7903: exit;
7980: --
7981: -- Get the instance details
7982: --
7983: l_torrwnum := 0;
7984: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
7985: --
7986: -- Check if hashed value is already allocated
7987: --
7988: if g_cache_elpelu_lookup.exists(l_index) then
7996: -- Loop until un-allocated has value is derived
7997: --
7998: while not l_not_hash_found loop
7999: --
8000: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
8001: --
8002: -- Check if the hash index exists, if not we can use it
8003: --
8004: -- Bug 13253435 when moved to next hash index checking whether that
8093: begin
8094: --
8095: for objlook in c_elpelr_look loop
8096: --
8097: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
8098: --
8099: -- Check if hashed value is already allocated
8100: --
8101: if g_cache_elpelr_lookup.exists(l_id) then
8105: -- Loop until un-allocated has value is derived
8106: --
8107: while not l_not_hash_found loop
8108: --
8109: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8110: --
8111: -- Check if the hash index exists, if not we can use it
8112: --
8113: if not g_cache_elpelr_lookup.exists(l_id) then
8138: for objinst in c_elpelr_inst loop
8139: --
8140: -- Populate the cache lookup details
8141: --
8142: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
8143: --
8144: -- Check if hashed value is already allocated
8145: --
8146: if g_cache_elpelr_lookup(l_id).id = objinst.eligy_prfl_id then
8150: else
8151: --
8152: loop
8153: --
8154: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8155: --
8156: if g_cache_elpelr_lookup(l_id).id = objinst.eligy_prfl_id then
8157: --
8158: exit;
8236: --
8237: -- Get the instance details
8238: --
8239: l_torrwnum := 0;
8240: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
8241: --
8242: -- Check if hashed value is already allocated
8243: --
8244: if g_cache_elpelr_lookup.exists(l_index) then
8252: -- Loop until un-allocated has value is derived
8253: --
8254: while not l_not_hash_found loop
8255: --
8256: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
8257: --
8258: -- Check if the hash index exists, if not we can use it
8259: --
8260: -- Bug 13253435 when moved to next hash index checking whether that
8357: begin
8358: --
8359: for objlook in c_elpeap_look loop
8360: --
8361: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
8362: --
8363: -- Check if hashed value is already allocated
8364: --
8365: if g_cache_elpeap_lookup.exists(l_id) then
8369: -- Loop until un-allocated has value is derived
8370: --
8371: while not l_not_hash_found loop
8372: --
8373: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8374: --
8375: -- Check if the hash index exists, if not we can use it
8376: --
8377: if not g_cache_elpeap_lookup.exists(l_id) then
8402: for objinst in c_elpeap_inst loop
8403: --
8404: -- Populate the cache lookup details
8405: --
8406: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
8407: --
8408: -- Check if hashed value is already allocated
8409: --
8410: if g_cache_elpeap_lookup(l_id).id = objinst.eligy_prfl_id then
8414: else
8415: --
8416: loop
8417: --
8418: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8419: --
8420: if g_cache_elpeap_lookup(l_id).id = objinst.eligy_prfl_id then
8421: --
8422: exit;
8503: --
8504: -- Get the instance details
8505: --
8506: l_torrwnum := 0;
8507: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
8508: --
8509: -- Check if hashed value is already allocated
8510: --
8511: if g_cache_elpeap_lookup.exists(l_index) then
8519: -- Loop until un-allocated has value is derived
8520: --
8521: while not l_not_hash_found loop
8522: --
8523: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
8524: --
8525: -- Check if the hash index exists, if not we can use it
8526: --
8527: -- Bug 13253435 when moved to next hash index checking whether that
8628: begin
8629: --
8630: for objlook in c_elpepz_look loop
8631: --
8632: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
8633: --
8634: -- Check if hashed value is already allocated
8635: --
8636: if g_cache_elpepz_lookup.exists(l_id) then
8640: -- Loop until un-allocated has value is derived
8641: --
8642: while not l_not_hash_found loop
8643: --
8644: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8645: --
8646: -- Check if the hash index exists, if not we can use it
8647: --
8648: if not g_cache_elpepz_lookup.exists(l_id) then
8673: for objinst in c_elpepz_inst loop
8674: --
8675: -- Populate the cache lookup details
8676: --
8677: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
8678: --
8679: -- Check if hashed value is already allocated
8680: --
8681: if g_cache_elpepz_lookup(l_id).id = objinst.eligy_prfl_id then
8685: else
8686: --
8687: loop
8688: --
8689: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8690: --
8691: if g_cache_elpepz_lookup(l_id).id = objinst.eligy_prfl_id then
8692: --
8693: exit;
8771: --
8772: -- Get the instance details
8773: --
8774: l_torrwnum := 0;
8775: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
8776: --
8777: -- Check if hashed value is already allocated
8778: --
8779: if g_cache_elpepz_lookup.exists(l_index) then
8787: -- Loop until un-allocated has value is derived
8788: --
8789: while not l_not_hash_found loop
8790: --
8791: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
8792: --
8793: -- Check if the hash index exists, if not we can use it
8794: --
8795: -- Bug 13253435 when moved to next hash index checking whether that
8883: begin
8884: --
8885: for objlook in c_elpebn_look loop
8886: --
8887: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
8888: --
8889: -- Check if hashed value is already allocated
8890: --
8891: if g_cache_elpebn_lookup.exists(l_id) then
8895: -- Loop until un-allocated has value is derived
8896: --
8897: while not l_not_hash_found loop
8898: --
8899: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8900: --
8901: -- Check if the hash index exists, if not we can use it
8902: --
8903: if not g_cache_elpebn_lookup.exists(l_id) then
8928: for objinst in c_elpebn_inst loop
8929: --
8930: -- Populate the cache lookup details
8931: --
8932: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
8933: --
8934: -- Check if hashed value is already allocated
8935: --
8936: if g_cache_elpebn_lookup(l_id).id = objinst.eligy_prfl_id then
8940: else
8941: --
8942: loop
8943: --
8944: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
8945: --
8946: if g_cache_elpebn_lookup(l_id).id = objinst.eligy_prfl_id then
8947: --
8948: exit;
9025: --
9026: -- Get the instance details
9027: --
9028: l_torrwnum := 0;
9029: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
9030: --
9031: -- Check if hashed value is already allocated
9032: --
9033: if g_cache_elpebn_lookup.exists(l_index) then
9041: -- Loop until un-allocated has value is derived
9042: --
9043: while not l_not_hash_found loop
9044: --
9045: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
9046: --
9047: -- Check if the hash index exists, if not we can use it
9048: --
9049: -- Bug 13253435 when moved to next hash index checking whether that
9143: begin
9144: --
9145: for objlook in c_elpeln_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_elpeln_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_elpeln_lookup.exists(l_id) then
9188: for objinst in c_elpeln_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_elpeln_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_elpeln_lookup(l_id).id = objinst.eligy_prfl_id then
9207: --
9208: exit;
9285: --
9286: -- Get the instance details
9287: --
9288: l_torrwnum := 0;
9289: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
9290: --
9291: -- Check if hashed value is already allocated
9292: --
9293: if g_cache_elpeln_lookup.exists(l_index) then
9301: -- Loop until un-allocated has value is derived
9302: --
9303: while not l_not_hash_found loop
9304: --
9305: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
9306: --
9307: -- Check if the hash index exists, if not we can use it
9308: --
9309: -- Bug 13253435 when moved to next hash index checking whether that
9393: begin
9394: --
9395: for objlook in c_elpepp_look loop
9396: --
9397: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
9398: --
9399: -- Check if hashed value is already allocated
9400: --
9401: if g_cache_elpepp_lookup.exists(l_id) then
9405: -- Loop until un-allocated has value is derived
9406: --
9407: while not l_not_hash_found loop
9408: --
9409: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9410: --
9411: -- Check if the hash index exists, if not we can use it
9412: --
9413: if not g_cache_elpepp_lookup.exists(l_id) then
9438: for objinst in c_elpepp_inst loop
9439: --
9440: -- Populate the cache lookup details
9441: --
9442: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
9443: --
9444: -- Check if hashed value is already allocated
9445: --
9446: if g_cache_elpepp_lookup(l_id).id = objinst.eligy_prfl_id then
9450: else
9451: --
9452: loop
9453: --
9454: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9455: --
9456: if g_cache_elpepp_lookup(l_id).id = objinst.eligy_prfl_id then
9457: --
9458: exit;
9531: --
9532: -- Get the instance details
9533: --
9534: l_torrwnum := 0;
9535: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
9536: --
9537: -- Check if hashed value is already allocated
9538: --
9539: if g_cache_elpepp_lookup.exists(l_index) then
9547: -- Loop until un-allocated has value is derived
9548: --
9549: while not l_not_hash_found loop
9550: --
9551: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
9552: --
9553: -- Check if the hash index exists, if not we can use it
9554: --
9555: -- Bug 13253435 when moved to next hash index checking whether that
9640: begin
9641: --
9642: for objlook in c_elpeoy_look loop
9643: --
9644: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
9645: --
9646: -- Check if hashed value is already allocated
9647: --
9648: if g_cache_elpeoy_lookup.exists(l_id) then
9652: -- Loop until un-allocated has value is derived
9653: --
9654: while not l_not_hash_found loop
9655: --
9656: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9657: --
9658: -- Check if the hash index exists, if not we can use it
9659: --
9660: if not g_cache_elpeoy_lookup.exists(l_id) then
9685: for objinst in c_elpeoy_inst loop
9686: --
9687: -- Populate the cache lookup details
9688: --
9689: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
9690: --
9691: -- Check if hashed value is already allocated
9692: --
9693: if g_cache_elpeoy_lookup(l_id).id = objinst.eligy_prfl_id then
9697: else
9698: --
9699: loop
9700: --
9701: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9702: --
9703: if g_cache_elpeoy_lookup(l_id).id = objinst.eligy_prfl_id then
9704: --
9705: exit;
9780: --
9781: -- Get the instance details
9782: --
9783: l_torrwnum := 0;
9784: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
9785: --
9786: -- Check if hashed value is already allocated
9787: --
9788: if g_cache_elpeoy_lookup.exists(l_index) then
9796: -- Loop until un-allocated has value is derived
9797: --
9798: while not l_not_hash_found loop
9799: --
9800: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
9801: --
9802: -- Check if the hash index exists, if not we can use it
9803: --
9804: -- Bug 13253435 when moved to next hash index checking whether that
9890: begin
9891: --
9892: for objlook in c_elpetd_look loop
9893: --
9894: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
9895: --
9896: -- Check if hashed value is already allocated
9897: --
9898: if g_cache_elpetd_lookup.exists(l_id) then
9902: -- Loop until un-allocated has value is derived
9903: --
9904: while not l_not_hash_found loop
9905: --
9906: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9907: --
9908: -- Check if the hash index exists, if not we can use it
9909: --
9910: if not g_cache_elpetd_lookup.exists(l_id) then
9935: for objinst in c_elpetd_inst loop
9936: --
9937: -- Populate the cache lookup details
9938: --
9939: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
9940: --
9941: -- Check if hashed value is already allocated
9942: --
9943: if g_cache_elpetd_lookup(l_id).id = objinst.eligy_prfl_id then
9947: else
9948: --
9949: loop
9950: --
9951: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
9952: --
9953: if g_cache_elpetd_lookup(l_id).id = objinst.eligy_prfl_id then
9954: --
9955: exit;
10030: --
10031: -- Get the instance details
10032: --
10033: l_torrwnum := 0;
10034: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
10035: --
10036: -- Check if hashed value is already allocated
10037: --
10038: if g_cache_elpetd_lookup.exists(l_index) then
10046: -- Loop until un-allocated has value is derived
10047: --
10048: while not l_not_hash_found loop
10049: --
10050: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index)
10051: ;
10052: --
10053: -- Check if the hash index exists, if not we can use it
10054: --
10137: begin
10138: --
10139: for objlook in c_elpeno_look loop
10140: --
10141: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
10142: --
10143: -- Check if hashed value is already allocated
10144: --
10145: if g_cache_elpeno_lookup.exists(l_id) then
10149: -- Loop until un-allocated has value is derived
10150: --
10151: while not l_not_hash_found loop
10152: --
10153: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10154: --
10155: -- Check if the hash index exists, if not we can use it
10156: --
10157: if not g_cache_elpeno_lookup.exists(l_id) then
10182: for objinst in c_elpeno_inst loop
10183: --
10184: -- Populate the cache lookup details
10185: --
10186: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
10187: --
10188: -- Check if hashed value is already allocated
10189: --
10190: if g_cache_elpeno_lookup(l_id).id = objinst.eligy_prfl_id then
10194: else
10195: --
10196: loop
10197: --
10198: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10199: --
10200: if g_cache_elpeno_lookup(l_id).id = objinst.eligy_prfl_id then
10201: --
10202: exit;
10275: --
10276: -- Get the instance details
10277: --
10278: l_torrwnum := 0;
10279: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
10280: --
10281: -- Check if hashed value is already allocated
10282: --
10283: if g_cache_elpeno_lookup.exists(l_index) then
10291: -- Loop until un-allocated has value is derived
10292: --
10293: while not l_not_hash_found loop
10294: --
10295: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
10296: --
10297: -- Check if the hash index exists, if not we can use it
10298: --
10299: -- Bug 13253435 when moved to next hash index checking whether that
10384: begin
10385: --
10386: for objlook in c_elpeep_look loop
10387: --
10388: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
10389: --
10390: -- Check if hashed value is already allocated
10391: --
10392: if g_cache_elpeep_lookup.exists(l_id) then
10396: -- Loop until un-allocated has value is derived
10397: --
10398: while not l_not_hash_found loop
10399: --
10400: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10401: --
10402: -- Check if the hash index exists, if not we can use it
10403: --
10404: if not g_cache_elpeep_lookup.exists(l_id) then
10429: for objinst in c_elpeep_inst loop
10430: --
10431: -- Populate the cache lookup details
10432: --
10433: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
10434: --
10435: -- Check if hashed value is already allocated
10436: --
10437: if g_cache_elpeep_lookup(l_id).id = objinst.eligy_prfl_id then
10441: else
10442: --
10443: loop
10444: --
10445: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10446: --
10447: if g_cache_elpeep_lookup(l_id).id = objinst.eligy_prfl_id then
10448: --
10449: exit;
10523: --
10524: -- Get the instance details
10525: --
10526: l_torrwnum := 0;
10527: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
10528: --
10529: -- Check if hashed value is already allocated
10530: --
10531: if g_cache_elpeep_lookup.exists(l_index) then
10539: -- Loop until un-allocated has value is derived
10540: --
10541: while not l_not_hash_found loop
10542: --
10543: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
10544: --
10545: -- Check if the hash index exists, if not we can use it
10546: --
10547: -- Bug 13253435 when moved to next hash index checking whether that
10632: begin
10633: --
10634: for objlook in c_elpeei_look loop
10635: --
10636: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
10637: --
10638: -- Check if hashed value is already allocated
10639: --
10640: if g_cache_elpeei_lookup.exists(l_id) then
10644: -- Loop until un-allocated has value is derived
10645: --
10646: while not l_not_hash_found loop
10647: --
10648: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10649: --
10650: -- Check if the hash index exists, if not we can use it
10651: --
10652: if not g_cache_elpeei_lookup.exists(l_id) then
10677: for objinst in c_elpeei_inst loop
10678: --
10679: -- Populate the cache lookup details
10680: --
10681: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
10682: --
10683: -- Check if hashed value is already allocated
10684: --
10685: if g_cache_elpeei_lookup(l_id).id = objinst.eligy_prfl_id then
10689: else
10690: --
10691: loop
10692: --
10693: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10694: --
10695: if g_cache_elpeei_lookup(l_id).id = objinst.eligy_prfl_id then
10696: --
10697: exit;
10771: --
10772: -- Get the instance details
10773: --
10774: l_torrwnum := 0;
10775: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
10776: --
10777: -- Check if hashed value is already allocated
10778: --
10779: if g_cache_elpeei_lookup.exists(l_index) then
10787: -- Loop until un-allocated has value is derived
10788: --
10789: while not l_not_hash_found loop
10790: --
10791: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
10792: --
10793: -- Check if the hash index exists, if not we can use it
10794: --
10795: -- Bug 13253435 when moved to next hash index checking whether that
10880: begin
10881: --
10882: for objlook in c_elpeeg_look loop
10883: --
10884: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
10885: --
10886: -- Check if hashed value is already allocated
10887: --
10888: if g_cache_elpeeg_lookup.exists(l_id) then
10892: -- Loop until un-allocated has value is derived
10893: --
10894: while not l_not_hash_found loop
10895: --
10896: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10897: --
10898: -- Check if the hash index exists, if not we can use it
10899: --
10900: if not g_cache_elpeeg_lookup.exists(l_id) then
10925: for objinst in c_elpeeg_inst loop
10926: --
10927: -- Populate the cache lookup details
10928: --
10929: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
10930: --
10931: -- Check if hashed value is already allocated
10932: --
10933: if g_cache_elpeeg_lookup(l_id).id = objinst.eligy_prfl_id then
10937: else
10938: --
10939: loop
10940: --
10941: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
10942: --
10943: if g_cache_elpeeg_lookup(l_id).id = objinst.eligy_prfl_id then
10944: --
10945: exit;
11019: --
11020: -- Get the instance details
11021: --
11022: l_torrwnum := 0;
11023: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
11024: --
11025: -- Check if hashed value is already allocated
11026: --
11027: if g_cache_elpeeg_lookup.exists(l_index) then
11035: -- Loop until un-allocated has value is derived
11036: --
11037: while not l_not_hash_found loop
11038: --
11039: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
11040: --
11041: -- Check if the hash index exists, if not we can use it
11042: --
11043: -- Bug 13253435 when moved to next hash index checking whether that
11128: begin
11129: --
11130: for objlook in c_elpedp_look loop
11131: --
11132: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
11133: --
11134: -- Check if hashed value is already allocated
11135: --
11136: if g_cache_elpedp_lookup.exists(l_id) then
11140: -- Loop until un-allocated has value is derived
11141: --
11142: while not l_not_hash_found loop
11143: --
11144: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11145: --
11146: -- Check if the hash index exists, if not we can use it
11147: --
11148: if not g_cache_elpedp_lookup.exists(l_id) then
11173: for objinst in c_elpedp_inst loop
11174: --
11175: -- Populate the cache lookup details
11176: --
11177: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
11178: --
11179: -- Check if hashed value is already allocated
11180: --
11181: if g_cache_elpedp_lookup(l_id).id = objinst.eligy_prfl_id then
11185: else
11186: --
11187: loop
11188: --
11189: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11190: --
11191: if g_cache_elpedp_lookup(l_id).id = objinst.eligy_prfl_id then
11192: --
11193: exit;
11267: --
11268: -- Get the instance details
11269: --
11270: l_torrwnum := 0;
11271: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
11272: --
11273: -- Check if hashed value is already allocated
11274: --
11275: if g_cache_elpedp_lookup.exists(l_index) then
11283: -- Loop until un-allocated has value is derived
11284: --
11285: while not l_not_hash_found loop
11286: --
11287: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
11288: --
11289: -- Check if the hash index exists, if not we can use it
11290: --
11291: -- Bug 13253435 when moved to next hash index checking whether that
11379: begin
11380: --
11381: for objlook in c_elpelv_look loop
11382: --
11383: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
11384: --
11385: -- Check if hashed value is already allocated
11386: --
11387: if g_cache_elpelv_lookup.exists(l_id) then
11391: -- Loop until un-allocated has value is derived
11392: --
11393: while not l_not_hash_found loop
11394: --
11395: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11396: --
11397: -- Check if the hash index exists, if not we can use it
11398: --
11399: if not g_cache_elpelv_lookup.exists(l_id) then
11424: for objinst in c_elpelv_inst loop
11425: --
11426: -- Populate the cache lookup details
11427: --
11428: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
11429: --
11430: -- Check if hashed value is already allocated
11431: --
11432: if g_cache_elpelv_lookup(l_id).id = objinst.eligy_prfl_id then
11436: else
11437: --
11438: loop
11439: --
11440: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11441: --
11442: if g_cache_elpelv_lookup(l_id).id = objinst.eligy_prfl_id then
11443: --
11444: exit;
11521: --
11522: -- Get the instance details
11523: --
11524: l_torrwnum := 0;
11525: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
11526: --
11527: -- Check if hashed value is already allocated
11528: --
11529: if g_cache_elpelv_lookup.exists(l_index) then
11537: -- Loop until un-allocated has value is derived
11538: --
11539: while not l_not_hash_found loop
11540: --
11541: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
11542: --
11543: -- Check if the hash index exists, if not we can use it
11544: --
11545: -- Bug 13253435 when moved to next hash index checking whether that
11628: begin
11629: --
11630: for objlook in c_elpeom_look loop
11631: --
11632: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
11633: --
11634: -- Check if hashed value is already allocated
11635: --
11636: if g_cache_elpeom_lookup.exists(l_id) then
11640: -- Loop until un-allocated has value is derived
11641: --
11642: while not l_not_hash_found loop
11643: --
11644: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11645: --
11646: -- Check if the hash index exists, if not we can use it
11647: --
11648: if not g_cache_elpeom_lookup.exists(l_id) then
11673: for objinst in c_elpeom_inst loop
11674: --
11675: -- Populate the cache lookup details
11676: --
11677: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
11678: --
11679: -- Check if hashed value is already allocated
11680: --
11681: if g_cache_elpeom_lookup(l_id).id = objinst.eligy_prfl_id then
11685: else
11686: --
11687: loop
11688: --
11689: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11690: --
11691: if g_cache_elpeom_lookup(l_id).id = objinst.eligy_prfl_id then
11692: --
11693: exit;
11766: --
11767: -- Get the instance details
11768: --
11769: l_torrwnum := 0;
11770: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
11771: --
11772: -- Check if hashed value is already allocated
11773: --
11774: if g_cache_elpeom_lookup.exists(l_index) then
11782: -- Loop until un-allocated has value is derived
11783: --
11784: while not l_not_hash_found loop
11785: --
11786: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
11787: --
11788: -- Check if the hash index exists, if not we can use it
11789: --
11790: -- Bug 13253435 when moved to next hash index checking whether that
11874: begin
11875: --
11876: for objlook in c_elpeai_look loop
11877: --
11878: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
11879: --
11880: -- Check if hashed value is already allocated
11881: --
11882: if g_cache_elpeai_lookup.exists(l_id) then
11886: -- Loop until un-allocated has value is derived
11887: --
11888: while not l_not_hash_found loop
11889: --
11890: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11891: --
11892: -- Check if the hash index exists, if not we can use it
11893: --
11894: if not g_cache_elpeai_lookup.exists(l_id) then
11919: for objinst in c_elpeai_inst loop
11920: --
11921: -- Populate the cache lookup details
11922: --
11923: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
11924: --
11925: -- Check if hashed value is already allocated
11926: --
11927: if g_cache_elpeai_lookup(l_id).id = objinst.eligy_prfl_id then
11931: else
11932: --
11933: loop
11934: --
11935: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
11936: --
11937: if g_cache_elpeai_lookup(l_id).id = objinst.eligy_prfl_id then
11938: --
11939: exit;
12013: --
12014: -- Get the instance details
12015: --
12016: l_torrwnum := 0;
12017: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
12018: --
12019: -- Check if hashed value is already allocated
12020: --
12021: if g_cache_elpeai_lookup.exists(l_index) then
12029: -- Loop until un-allocated has value is derived
12030: --
12031: while not l_not_hash_found loop
12032: --
12033: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
12034: --
12035: -- Check if the hash index exists, if not we can use it
12036: --
12037: -- Bug 13253435 when moved to next hash index checking whether that
12121: begin
12122: --
12123: for objlook in c_elpedi_look loop
12124: --
12125: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
12126: --
12127: -- Check if hashed value is already allocated
12128: --
12129: if g_cache_elpedi_lookup.exists(l_id) then
12133: -- Loop until un-allocated has value is derived
12134: --
12135: while not l_not_hash_found loop
12136: --
12137: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12138: --
12139: -- Check if the hash index exists, if not we can use it
12140: --
12141: if not g_cache_elpedi_lookup.exists(l_id) then
12166: for objinst in c_elpedi_inst loop
12167: --
12168: -- Populate the cache lookup details
12169: --
12170: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
12171: --
12172: -- Check if hashed value is already allocated
12173: --
12174: if g_cache_elpedi_lookup(l_id).id = objinst.eligy_prfl_id then
12178: else
12179: --
12180: loop
12181: --
12182: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12183: --
12184: if g_cache_elpedi_lookup(l_id).id = objinst.eligy_prfl_id then
12185: --
12186: exit;
12260: --
12261: -- Get the instance details
12262: --
12263: l_torrwnum := 0;
12264: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
12265: --
12266: -- Check if hashed value is already allocated
12267: --
12268: if g_cache_elpedi_lookup.exists(l_index) then
12276: -- Loop until un-allocated has value is derived
12277: --
12278: while not l_not_hash_found loop
12279: --
12280: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
12281: --
12282: -- Check if the hash index exists, if not we can use it
12283: --
12284: -- Bug 13253435 when moved to next hash index checking whether that
12369: begin
12370: --
12371: for objlook in c_elpeet_look loop
12372: --
12373: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
12374: --
12375: -- Check if hashed value is already allocated
12376: --
12377: if g_cache_elpeet_lookup.exists(l_id) then
12381: -- Loop until un-allocated has value is derived
12382: --
12383: while not l_not_hash_found loop
12384: --
12385: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12386: --
12387: -- Check if the hash index exists, if not we can use it
12388: --
12389: if not g_cache_elpeet_lookup.exists(l_id) then
12414: for objinst in c_elpeet_inst loop
12415: --
12416: -- Populate the cache lookup details
12417: --
12418: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
12419: --
12420: -- Check if hashed value is already allocated
12421: --
12422: if g_cache_elpeet_lookup(l_id).id = objinst.eligy_prfl_id then
12426: else
12427: --
12428: loop
12429: --
12430: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12431: --
12432: if g_cache_elpeet_lookup(l_id).id = objinst.eligy_prfl_id then
12433: --
12434: exit;
12509: --
12510: -- Get the instance details
12511: --
12512: l_torrwnum := 0;
12513: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
12514: --
12515: -- Check if hashed value is already allocated
12516: --
12517: if g_cache_elpeet_lookup.exists(l_index) then
12525: -- Loop until un-allocated has value is derived
12526: --
12527: while not l_not_hash_found loop
12528: --
12529: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
12530: --
12531: -- Check if the hash index exists, if not we can use it
12532: --
12533: -- Bug 13253435 when moved to next hash index checking whether that
12618: begin
12619: --
12620: for objlook in c_elpedt_look loop
12621: --
12622: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
12623: --
12624: -- Check if hashed value is already allocated
12625: --
12626: if g_cache_elpedt_lookup.exists(l_id) then
12630: -- Loop until un-allocated has value is derived
12631: --
12632: while not l_not_hash_found loop
12633: --
12634: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12635: --
12636: -- Check if the hash index exists, if not we can use it
12637: --
12638: if not g_cache_elpedt_lookup.exists(l_id) then
12663: for objinst in c_elpedt_inst loop
12664: --
12665: -- Populate the cache lookup details
12666: --
12667: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
12668: --
12669: -- Check if hashed value is already allocated
12670: --
12671: if g_cache_elpedt_lookup(l_id).id = objinst.eligy_prfl_id then
12675: else
12676: --
12677: loop
12678: --
12679: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12680: --
12681: if g_cache_elpedt_lookup(l_id).id = objinst.eligy_prfl_id then
12682: --
12683: exit;
12758: --
12759: -- Get the instance details
12760: --
12761: l_torrwnum := 0;
12762: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
12763: --
12764: -- Check if hashed value is already allocated
12765: --
12766: if g_cache_elpedt_lookup.exists(l_index) then
12774: -- Loop until un-allocated has value is derived
12775: --
12776: while not l_not_hash_found loop
12777: --
12778: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
12779: --
12780: -- Check if the hash index exists, if not we can use it
12781: --
12782: -- Bug 13253435 when moved to next hash index checking whether that
12866: begin
12867: --
12868: for objlook in c_elpedg_look loop
12869: --
12870: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
12871: --
12872: -- Check if hashed value is already allocated
12873: --
12874: if g_cache_elpedg_lookup.exists(l_id) then
12878: -- Loop until un-allocated has value is derived
12879: --
12880: while not l_not_hash_found loop
12881: --
12882: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12883: --
12884: -- Check if the hash index exists, if not we can use it
12885: --
12886: if not g_cache_elpedg_lookup.exists(l_id) then
12911: for objinst in c_elpedg_inst loop
12912: --
12913: -- Populate the cache lookup details
12914: --
12915: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
12916: --
12917: -- Check if hashed value is already allocated
12918: --
12919: if g_cache_elpedg_lookup(l_id).id = objinst.eligy_prfl_id then
12923: else
12924: --
12925: loop
12926: --
12927: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
12928: --
12929: if g_cache_elpedg_lookup(l_id).id = objinst.eligy_prfl_id then
12930: --
12931: exit;
13005: --
13006: -- Get the instance details
13007: --
13008: l_torrwnum := 0;
13009: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
13010: --
13011: -- Check if hashed value is already allocated
13012: --
13013: if g_cache_elpedg_lookup.exists(l_index) then
13021: -- Loop until un-allocated has value is derived
13022: --
13023: while not l_not_hash_found loop
13024: --
13025: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
13026: --
13027: -- Check if the hash index exists, if not we can use it
13028: --
13029: -- Bug 13253435 when moved to next hash index checking whether that
13116: begin
13117: --
13118: for objlook in c_elpecq_look loop
13119: --
13120: l_id := ben_hash_utility.get_hashed_index(p_id => objlook.eligy_prfl_id);
13121: --
13122: -- Check if hashed value is already allocated
13123: --
13124: if g_cache_elpecq_lookup.exists(l_id) then
13128: -- Loop until un-allocated has value is derived
13129: --
13130: while not l_not_hash_found loop
13131: --
13132: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
13133: --
13134: -- Check if the hash index exists, if not we can use it
13135: --
13136: if not g_cache_elpecq_lookup.exists(l_id) then
13161: for objinst in c_elpecq_inst loop
13162: --
13163: -- Populate the cache lookup details
13164: --
13165: l_id := ben_hash_utility.get_hashed_index(p_id => objinst.eligy_prfl_id);
13166: --
13167: -- Check if hashed value is already allocated
13168: --
13169: if g_cache_elpecq_lookup(l_id).id = objinst.eligy_prfl_id then
13173: else
13174: --
13175: loop
13176: --
13177: l_id := ben_hash_utility.get_next_hash_index(p_hash_index => l_id);
13178: --
13179: if g_cache_elpecq_lookup(l_id).id = objinst.eligy_prfl_id then
13180: --
13181: exit;
13260: --
13261: -- Get the instance details
13262: --
13263: l_torrwnum := 0;
13264: l_index := ben_hash_utility.get_hashed_index(p_id => p_eligy_prfl_id);
13265: --
13266: -- Check if hashed value is already allocated
13267: --
13268: if g_cache_elpecq_lookup.exists(l_index) then
13276: -- Loop until un-allocated has value is derived
13277: --
13278: while not l_not_hash_found loop
13279: --
13280: l_index := ben_hash_utility.get_next_hash_index(p_hash_index => l_index);
13281: --
13282: -- Check if the hash index exists, if not we can use it
13283: --
13284: -- Bug 13253435 when moved to next hash index checking whether that