DBA Data[Home] [Help]

APPS.BEN_COBJ_CACHE dependencies on BEN_HASH_UTILITY

Line 37: g_hash_key number := ben_hash_utility.get_hash_key;

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

Line 38: g_hash_jump number := ben_hash_utility.get_hash_jump;

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

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

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

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

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

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

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

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

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

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

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

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

444: end if;
445: --
446: -- Get the instance details
447: --
448: l_hv := mod(p_oipl_id,ben_hash_utility.get_hash_key);
449: --
450: if g_oipl_instance(l_hv).oipl_id = p_oipl_id
451: then
452: -- Matched row

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

538: ,c_effective_date => p_effective_date
539: )
540: loop
541: --
542: l_hv := mod(objinst.pgm_id,ben_hash_utility.get_hash_key);
543: --
544: while ben_cobj_cache.g_pgm_instance.exists(l_hv)
545: loop
546: --

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

618: end if;
619: --
620: -- Get the instance details
621: --
622: l_hv := mod(p_pgm_id,ben_hash_utility.get_hash_key);
623: --
624: if g_pgm_instance(l_hv).pgm_id = p_pgm_id
625: then
626: -- Matched row

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

715: ,c_effective_date => p_effective_date
716: )
717: loop
718: --
719: l_hv := mod(objinst.ptip_id,ben_hash_utility.get_hash_key);
720: --
721: while ben_cobj_cache.g_ptip_instance.exists(l_hv)
722: loop
723: --

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

798: end if;
799: --
800: -- Get the instance details
801: --
802: l_hv := mod(p_ptip_id,ben_hash_utility.get_hash_key);
803: --
804: if g_ptip_instance(l_hv).ptip_id = p_ptip_id
805: then
806: -- Matched row

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

893: ,c_effective_date => p_effective_date
894: )
895: loop
896: --
897: l_hv := mod(objinst.plip_id,ben_hash_utility.get_hash_key);
898: --
899: while ben_cobj_cache.g_plip_instance.exists(l_hv)
900: loop
901: --

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

974: end if;
975: --
976: -- Get the instance details
977: --
978: l_hv := mod(p_plip_id,ben_hash_utility.get_hash_key);
979: --
980: if g_plip_instance(l_hv).plip_id = p_plip_id
981: then
982: -- Matched row

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

1093: ,c_effective_date => p_effective_date
1094: )
1095: loop
1096: --
1097: l_hv := mod(objinst.pl_id,ben_hash_utility.get_hash_key);
1098: --
1099: while ben_cobj_cache.g_pl_instance.exists(l_hv)
1100: loop
1101: --

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

1198: end if;
1199: --
1200: -- Get the instance details
1201: --
1202: l_hv := mod(p_pl_id,ben_hash_utility.get_hash_key);
1203: --
1204: if g_pl_instance(l_hv).pl_id = p_pl_id
1205: then
1206: -- Matched row

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

1288: ,c_effective_date => p_effective_date
1289: )
1290: loop
1291: --
1292: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(objinst.ler_id,1)
1293: +nvl(objinst.pgm_id,1)+nvl(objinst.ptip_id,1)+nvl(objinst.plip_id,1)
1294: +nvl(objinst.pl_id,1)+nvl(objinst.oipl_id,1));
1295: --
1296: while ben_cobj_cache.g_etpr_instance.exists(l_hv)

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

1343: end if;
1344: --
1345: -- Get the instance details
1346: --
1347: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_ler_id,1)
1348: +nvl(p_pgm_id,1)+nvl(p_ptip_id,1)+nvl(p_plip_id,1)+nvl(p_pl_id,1)
1349: +nvl(p_oipl_id,1));
1350: --
1351: if nvl(g_etpr_instance(l_hv).ler_id,-1) = nvl(p_ler_id,-1)

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

1440: ,c_effective_date => p_effective_date
1441: )
1442: loop
1443: --
1444: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(objinst.pgm_id,1)
1445: +nvl(objinst.ptip_id,1)+nvl(objinst.plip_id,1)+nvl(objinst.pl_id,1)
1446: +nvl(objinst.oipl_id,1));
1447: --
1448: while ben_cobj_cache.g_prel_instance.exists(l_hv)

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

1494: end if;
1495: --
1496: -- Get the instance details
1497: --
1498: l_hv := ben_hash_utility.get_hashed_index(p_id => nvl(p_pgm_id,1)
1499: +nvl(p_ptip_id,1)+nvl(p_plip_id,1)+nvl(p_pl_id,1)
1500: +nvl(p_oipl_id,1));
1501: --
1502: if nvl(g_prel_instance(l_hv).pgm_id,-1) = nvl(p_pgm_id,-1)