DBA Data[Home] [Help]

APPS.BEN_COBJ_CACHE dependencies on BEN_HASH_UTILITY

Line 35: g_hash_key number := ben_hash_utility.get_hash_key;

31: --
32: -- Globals.
33: --
34: g_package varchar2(50) := 'ben_cobj_cache.';
35: g_hash_key number := ben_hash_utility.get_hash_key;
36: g_hash_jump number := ben_hash_utility.get_hash_jump;
37: --
38: procedure write_oiplip_cache
39: (p_business_group_id in number

Line 36: g_hash_jump number := ben_hash_utility.get_hash_jump;

32: -- Globals.
33: --
34: g_package varchar2(50) := 'ben_cobj_cache.';
35: g_hash_key number := ben_hash_utility.get_hash_key;
36: g_hash_jump number := ben_hash_utility.get_hash_jump;
37: --
38: procedure write_oiplip_cache
39: (p_business_group_id in number
40: ,p_effective_date in date

Line 69: l_hv := mod(objinst.oiplip_id,ben_hash_utility.get_hash_key);

65: ,c_effective_date => p_effective_date
66: )
67: loop
68: --
69: l_hv := mod(objinst.oiplip_id,ben_hash_utility.get_hash_key);
70: --
71: while ben_cobj_cache.g_oiplip_instance.exists(l_hv)
72: loop
73: --

Line 128: l_hv := mod(p_oiplip_id,ben_hash_utility.get_hash_key);

124: end if;
125: --
126: -- Get the instance details
127: --
128: l_hv := mod(p_oiplip_id,ben_hash_utility.get_hash_key);
129: --
130: if g_oiplip_instance(l_hv).oiplip_id = p_oiplip_id
131: then
132: -- Matched row

Line 203: l_hv := mod(objinst.opt_id,ben_hash_utility.get_hash_key);

199: ,c_effective_date => p_effective_date
200: )
201: loop
202: --
203: l_hv := mod(objinst.opt_id,ben_hash_utility.get_hash_key);
204: --
205: while ben_cobj_cache.g_opt_instance.exists(l_hv)
206: loop
207: --

Line 266: l_hv := mod(p_opt_id,ben_hash_utility.get_hash_key);

262: end if;
263: --
264: -- Get the instance details
265: --
266: l_hv := mod(p_opt_id,ben_hash_utility.get_hash_key);
267: --
268: if g_opt_instance(l_hv).opt_id = p_opt_id
269: then
270: -- Matched row

Line 362: l_hv := mod(objinst.oipl_id,ben_hash_utility.get_hash_key);

358: ,c_effective_date => p_effective_date
359: )
360: loop
361: --
362: l_hv := mod(objinst.oipl_id,ben_hash_utility.get_hash_key);
363: --
364: while ben_cobj_cache.g_oipl_instance.exists(l_hv)
365: loop
366: --

Line 444: l_hv := mod(p_oipl_id,ben_hash_utility.get_hash_key);

440: end if;
441: --
442: -- Get the instance details
443: --
444: l_hv := mod(p_oipl_id,ben_hash_utility.get_hash_key);
445: --
446: if g_oipl_instance(l_hv).oipl_id = p_oipl_id
447: then
448: -- Matched row

Line 537: l_hv := mod(objinst.pgm_id,ben_hash_utility.get_hash_key);

533: ,c_effective_date => p_effective_date
534: )
535: loop
536: --
537: l_hv := mod(objinst.pgm_id,ben_hash_utility.get_hash_key);
538: --
539: while ben_cobj_cache.g_pgm_instance.exists(l_hv)
540: loop
541: --

Line 616: l_hv := mod(p_pgm_id,ben_hash_utility.get_hash_key);

612: end if;
613: --
614: -- Get the instance details
615: --
616: l_hv := mod(p_pgm_id,ben_hash_utility.get_hash_key);
617: --
618: if g_pgm_instance(l_hv).pgm_id = p_pgm_id
619: then
620: -- Matched row

Line 712: l_hv := mod(objinst.ptip_id,ben_hash_utility.get_hash_key);

708: ,c_effective_date => p_effective_date
709: )
710: loop
711: --
712: l_hv := mod(objinst.ptip_id,ben_hash_utility.get_hash_key);
713: --
714: while ben_cobj_cache.g_ptip_instance.exists(l_hv)
715: loop
716: --

Line 794: l_hv := mod(p_ptip_id,ben_hash_utility.get_hash_key);

790: end if;
791: --
792: -- Get the instance details
793: --
794: l_hv := mod(p_ptip_id,ben_hash_utility.get_hash_key);
795: --
796: if g_ptip_instance(l_hv).ptip_id = p_ptip_id
797: then
798: -- Matched row

Line 888: l_hv := mod(objinst.plip_id,ben_hash_utility.get_hash_key);

884: ,c_effective_date => p_effective_date
885: )
886: loop
887: --
888: l_hv := mod(objinst.plip_id,ben_hash_utility.get_hash_key);
889: --
890: while ben_cobj_cache.g_plip_instance.exists(l_hv)
891: loop
892: --

Line 968: l_hv := mod(p_plip_id,ben_hash_utility.get_hash_key);

964: end if;
965: --
966: -- Get the instance details
967: --
968: l_hv := mod(p_plip_id,ben_hash_utility.get_hash_key);
969: --
970: if g_plip_instance(l_hv).plip_id = p_plip_id
971: then
972: -- Matched row

Line 1086: l_hv := mod(objinst.pl_id,ben_hash_utility.get_hash_key);

1082: ,c_effective_date => p_effective_date
1083: )
1084: loop
1085: --
1086: l_hv := mod(objinst.pl_id,ben_hash_utility.get_hash_key);
1087: --
1088: while ben_cobj_cache.g_pl_instance.exists(l_hv)
1089: loop
1090: --

Line 1190: l_hv := mod(p_pl_id,ben_hash_utility.get_hash_key);

1186: end if;
1187: --
1188: -- Get the instance details
1189: --
1190: l_hv := mod(p_pl_id,ben_hash_utility.get_hash_key);
1191: --
1192: if g_pl_instance(l_hv).pl_id = p_pl_id
1193: then
1194: -- Matched row

Line 1280: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(objinst.ler_id,1)

1276: ,c_effective_date => p_effective_date
1277: )
1278: loop
1279: --
1280: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(objinst.ler_id,1)
1281: +nvl(objinst.pgm_id,1)+nvl(objinst.ptip_id,1)+nvl(objinst.plip_id,1)
1282: +nvl(objinst.pl_id,1)+nvl(objinst.oipl_id,1));
1283: --
1284: while ben_cobj_cache.g_etpr_instance.exists(l_hv)

Line 1335: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_ler_id,1)

1331: end if;
1332: --
1333: -- Get the instance details
1334: --
1335: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_ler_id,1)
1336: +nvl(p_pgm_id,1)+nvl(p_ptip_id,1)+nvl(p_plip_id,1)+nvl(p_pl_id,1)
1337: +nvl(p_oipl_id,1));
1338: --
1339: if nvl(g_etpr_instance(l_hv).ler_id,-1) = nvl(p_ler_id,-1)

Line 1432: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(objinst.pgm_id,1)

1428: ,c_effective_date => p_effective_date
1429: )
1430: loop
1431: --
1432: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(objinst.pgm_id,1)
1433: +nvl(objinst.ptip_id,1)+nvl(objinst.plip_id,1)+nvl(objinst.pl_id,1)
1434: +nvl(objinst.oipl_id,1));
1435: --
1436: while ben_cobj_cache.g_prel_instance.exists(l_hv)

Line 1486: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_pgm_id,1)

1482: end if;
1483: --
1484: -- Get the instance details
1485: --
1486: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_pgm_id,1)
1487: +nvl(p_ptip_id,1)+nvl(p_plip_id,1)+nvl(p_pl_id,1)
1488: +nvl(p_oipl_id,1));
1489: --
1490: if nvl(g_prel_instance(l_hv).pgm_id,-1) = nvl(p_pgm_id,-1)