1: package body ben_pep_cache as
2: /* $Header: benpepch.pkb 120.3 2005/10/21 01:58:44 abparekh noship $ */
3: --
4: /*
5: +==============================================================================+
64: 115.25 06-May-05 mhoyes - Bug 4350303. Bypassed call to hash function
65: ben_hash_utility.get_hashed_index.
66: - Removed obsolete procedures.
67: 115.26 30-May-05 mhoyes - Bug 4400538. Moved local procedures out to
68: ben_pep_cache2.
69: 115.27 12-jun-05 mhoyes - Bug 4425771. Defined package locals as
70: globals.
71: 115.28 20-Oct-05 abparekh - Bug 4646361 : Added NOCOPY hint to out parameters
72: -----------------------------------------------------------------------------
105: null;
106: --
107: else
108: --
109: ben_pep_cache.clear_down_pepcache;
110: g_pilpep_cached := false;
111: --
112: end if;
113: --
117: then
118: --
119: -- Build the cache
120: --
121: ben_pep_cache2.write_pilpep_cache
122: (p_person_id => p_person_id
123: ,p_business_group_id => p_business_group_id
124: ,p_effective_date => p_effective_date
125: );
216: null;
217: --
218: else
219: --
220: ben_pep_cache.clear_down_epocache;
221: g_optpilepo_cached := false;
222: --
223: end if;
224: --
228: then
229: --
230: -- Build the cache
231: --
232: ben_pep_cache2.write_pilepo_cache
233: (p_person_id => p_person_id
234: ,p_business_group_id => p_business_group_id
235: ,p_effective_date => p_effective_date
236: );
729: procedure clear_down_cache
730: is
731: begin
732: --
733: ben_pep_cache.clear_down_pepcache;
734: ben_pep_cache.clear_down_epocache;
735: --
736: end clear_down_cache;
737: --
730: is
731: begin
732: --
733: ben_pep_cache.clear_down_pepcache;
734: ben_pep_cache.clear_down_epocache;
735: --
736: end clear_down_cache;
737: --
738: procedure clear_down_pepcache
760: g_optpilepo_personid := null;
761: --
762: end clear_down_epocache;
763: --
764: end ben_pep_cache;