1 PACKAGE HRI_OPL_BEN_ELIG_ENRL_EQ AS
2 /* $Header: hrieqeec.pkh 120.0 2005/09/21 01:26:48 anmajumd noship $ */
3 /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
4 Name : HRI_OPL_BEN_ELIG_ENRL_EQ
5 Purpose : Populate Benefits Eligbility and Enrollment event queue
6 ------------------------------------------------------------------------------
7 History
8 -------
9 Version Date Author Comment
10 -------+----------+----------------+------------------------------------------
11 12.0 30-JUN-05 nhunur Initial Version
12 -------------------------------------------------------------------------------
13 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
14
15 PROCEDURE insert_event (p_rec in ben_pen_shd.g_rec_type,
16 p_effective_date in date,
17 p_datetrack_mode in varchar2 );
18
19 PROCEDURE update_event (p_rec in ben_pen_shd.g_rec_type,
20 p_effective_date in date,
21 p_datetrack_mode in varchar2 );
22
23 PROCEDURE delete_event (p_rec in ben_pen_shd.g_rec_type,
24 p_effective_date in date,
25 p_datetrack_mode in varchar2 );
26
27 function get_plip_id (p_pl_id in number ,
28 p_pgm_id in number,
29 p_effective_date in date ) return number ;
30 function get_lf_evt_dt(p_per_in_ler_id in number ) return date;
31
32 END HRI_OPL_BEN_ELIG_ENRL_EQ;