1 package ben_crt_ler AUTHID CURRENT_USER as
2 /* $Header: becrttrg.pkh 115.9 2003/12/18 02:45:46 hmani ship $*/
3 TYPE g_crt_ler_rec is RECORD
4 (PERSON_ID NUMBER
5 ,BUSINESS_GROUP_ID NUMBER
6 ,APLS_PERD_STRTG_DT DATE
7 ,APLS_PERD_ENDG_DT DATE
8 ,CRT_ORDR_TYP_CD VARCHAR2(30)
9 ,rcvd_dt date
10 ,pl_id number
11 ,pl_typ_id number
12 ,crt_ordr_id number
13 );
14
15 procedure ler_chk(p_old IN g_crt_ler_rec
16 ,p_new IN g_crt_ler_rec
17 ,p_effective_date in date );
18 end;