1 package ben_collapse_life_events as
2 /* $Header: benclple.pkh 120.0 2005/05/28 03:49:44 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 Collapse Life Events
13 Purpose
14 This package is used to collapse life events. It is designed to be
15 called from fast formula but can be called from forms or reports as
16 well.
17 History
18 Date Who Version What?
19 ---- --- ------- -----
20 01 Dec 98 G Perry 115.0 Created.
21 07 Dec 98 G Perry 115.1 Added function
22 get_life_event_occured_date.
23 */
24 -----------------------------------------------------------------------
25 function collapse_life_event
26 (p_effective_date in varchar2,
27 p_assignment_id in number,
28 p_ler_id in number) return number;
29 -----------------------------------------------------------------------
30 function get_life_event_occured_date return varchar2;
31 -----------------------------------------------------------------------
32 end ben_collapse_life_events;