81: l_current_derived boolean;
82: --
83: begin
84: --
85: hr_utility.set_location('Entering: '||l_package,10);
86: --
87: -- Open cursor to work out if current event is a derived factor life
88: -- event.
89: --
170: end if;
171: --
172: return l_return_ler_id;
173: --
174: hr_utility.set_location('Leaving: '||l_package,10);
175: --
176: end collapse_potential;
177: --
178: function collapse_life_event(p_effective_date in varchar2,
238: -- CWB Changes End
239: --
240: begin
241: --
242: hr_utility.set_location('Entering: '||l_package,10);
243: --
244: -- First lets convert the effective_date into a date as formula only
245: -- understands text or numbers but we need it in a date format.
246: --
287: -- Return the collapsed life event
288: --
289: return l_ler_id;
290: --
291: hr_utility.set_location('Leaving: '||l_package,10);
292: --
293: end collapse_life_event;
294: --
295: function get_life_event_occured_date return varchar2 is
297: l_package varchar2(80) := g_package||'.get_life_event_occured_date';
298: --
299: begin
300: --
301: hr_utility.set_location('Entering: '||l_package,10);
302: --
303: -- We need to return the life event occured date, remember formula can't
304: -- handle dates so we must typecast the date as a string.
305: --
304: -- handle dates so we must typecast the date as a string.
305: --
306: return to_char(g_lf_evt_ocrd_dt,'DD/MM/YYYY');
307: --
308: hr_utility.set_location('Leaving: '||l_package,10);
309: --
310: end get_life_event_occured_date;
311: --
312: end ben_collapse_life_events;