DBA Data[Home] [Help]

PACKAGE: APPS.BEN_PRV_LER

Source


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;