PACKAGE: APPS.BEN_ADD_LER

Source

1 package ben_add_ler AUTHID CURRENT_USER as
2 /* $Header: beaddtrg.pkh 115.6 2002/06/03 04:55:11 pkm ship     $ */
3 TYPE g_add_ler_rec is RECORD
4 (PERSON_ID NUMBER
5 ,BUSINESS_GROUP_ID NUMBER
6 ,DATE_FROM DATE
7 ,DATE_TO DATE
8 ,PRIMARY_FLAG VARCHAR2(30)
9 ,POSTAL_CODE VARCHAR2(30)
10 ,REGION_2 VARCHAR2(120)   -- modified size from 70 to 120, Bug 2383576
11 ,ADDRESS_TYPE VARCHAR2(30)
12 ,ADDRESS_ID NUMBER
13 );
14 
15 procedure ler_chk(p_old IN g_add_ler_rec
16                  ,p_new IN g_add_ler_rec
17                  ,p_effective_date in date default null );
18 end;