DBA Data[Home] [Help]

PACKAGE: APPS.BEN_EGD_LER

Source


1 package ben_egd_ler as
2 /* $Header: beegdtrg.pkh 120.0.12000000.1 2007/01/19 04:53:50 appldev noship $ */
3 TYPE g_egd_ler_rec is RECORD
4 (DPNT_PERSON_ID NUMBER
5 ,BUSINESS_GROUP_ID NUMBER
6 ,ELIG_STRT_DT DATE
7 ,ELIG_THRU_DT DATE
8 ,DPNT_INELIG_FLAG VARCHAR2(30)
9 ,OVRDN_FLAG  VARCHAR2(30)
10 ,CREATE_DT DATE
11 ,OVRDN_THRU_DT DATE
12 ,ELIG_DPNT_ID NUMBER
13 ,INELG_RSN_CD VARCHAR2(30)
14 ,ELIG_PER_ELCTBL_CHC_ID NUMBER
15 ,PER_IN_LER_ID  NUMBER
16 ,ELIG_PER_ID    NUMBER
17 ,ELIG_PER_OPT_ID NUMBER
18 ,ELIG_CVRD_DPNT_ID NUMBER
19 );
20 
21 procedure ler_chk(p_old            in g_egd_ler_rec
22                  ,p_new            in g_egd_ler_rec
23                  ,p_effective_date in date);
24 end;