DBA Data[Home] [Help]

PACKAGE: APPS.BEN_COLLAPSE_LIFE_EVENTS

Source


1 package ben_collapse_life_events AUTHID CURRENT_USER 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;