PACKAGE: APPS.BEN_ECD_LER

Source

1 package ben_ecd_ler AUTHID CURRENT_USER as
2 /*$Header: beecdtrg.pkh 120.1.12000000.1 2007/01/19 03:49:38 appldev noship $*/
3 TYPE g_ecd_ler_rec is RECORD
4 (PRTT_ENRT_RSLT_ID NUMBER
5 ,ELIG_CVRD_DPNT_ID NUMBER
6 ,DPNT_PERSON_ID    NUMBER
7 ,BUSINESS_GROUP_ID NUMBER
8 ,EFFECTIVE_START_DATE DATE
9 ,EFFECTIVE_END_DATE DATE
10 --,CVRD_FLAG VARCHAR2(30)
11 ,CVG_STRT_DT DATE
12 ,CVG_THRU_DT DATE
13 ,OVRDN_FLAG VARCHAR2(30)
14 ,OVRDN_THRU_DT DATE
15 );
16 procedure ler_chk(p_old IN g_ecd_ler_rec
17                  ,p_new IN g_ecd_ler_rec
18                  ,p_effective_date IN date default NULL );
19 end;