1 package ben_prv_ler AUTHID CURRENT_USER as
2 /* $Header: beprvtrg.pkh 115.5 2003/12/18 02:46:28 hmani ship $ */
3 TYPE g_prv_ler_rec is RECORD
4 (PRTT_ENRT_RSLT_ID NUMBER
5 ,PRTT_RT_VAL_ID NUMBER
6 ,BUSINESS_GROUP_ID NUMBER
7 ,RT_STRT_DT DATE
8 ,RT_END_DT DATE
9 ,CMCD_RT_VAL NUMBER(15,2)
10 ,ANN_RT_VAL NUMBER(15,2)
11 ,RT_VAL NUMBER
12 ,RT_OVRIDN_FLAG VARCHAR2(30)
13 ,RT_OVRIDN_THRU_DT DATE
14 ,ELCTNS_MADE_DT DATE
15 ,TX_TYP_CD VARCHAR2(30)
16 ,ACTY_TYP_CD VARCHAR2(30)
17 ,PER_IN_LER_ID NUMBER
18 ,ACTY_BASE_RT_ID NUMBER
19 ,PRTT_RT_VAL_STAT_CD VARCHAR2(30)
20 );
21
22 procedure ler_chk(p_old IN g_prv_ler_rec
23 ,p_new IN g_prv_ler_rec
24 ,p_effective_date IN date );
25 end;