PACKAGE: APPS.BEN_CON_LER

Source

1 package ben_con_ler AUTHID CURRENT_USER as
2 /* $Header: becontrg.pkh 120.0.12010000.1 2008/07/29 11:09:22 appldev ship $ */
3 TYPE g_con_ler_rec is RECORD
4 (PERSON_ID NUMBER
5 ,CONTACT_PERSON_ID NUMBER
6 ,BUSINESS_GROUP_ID NUMBER
7 ,DATE_START DATE
8 ,DATE_END DATE
9 ,CONTACT_TYPE VARCHAR2(30)
10 ,PERSONAL_FLAG VARCHAR2(30)
11 ,START_LIFE_REASON_ID NUMBER
12 ,END_LIFE_REASON_ID NUMBER
13 ,RLTD_PER_RSDS_W_DSGNTR_FLAG VARCHAR2(30)
14 ,CONTACT_RELATIONSHIP_ID NUMBER
15 -- bug fix 1772037
16 ,CONT_ATTRIBUTE1  VARCHAR2(150)
17 ,CONT_ATTRIBUTE2  VARCHAR2(150)
18 ,CONT_ATTRIBUTE3  VARCHAR2(150)
19 ,CONT_ATTRIBUTE4  VARCHAR2(150)
20 ,CONT_ATTRIBUTE5  VARCHAR2(150)
21 ,CONT_ATTRIBUTE6  VARCHAR2(150)
22 ,CONT_ATTRIBUTE7  VARCHAR2(150)
23 ,CONT_ATTRIBUTE8  VARCHAR2(150)
24 ,CONT_ATTRIBUTE9  VARCHAR2(150)
25 ,CONT_ATTRIBUTE10 VARCHAR2(150)
26 ,CONT_ATTRIBUTE11 VARCHAR2(150)
27 ,CONT_ATTRIBUTE12 VARCHAR2(150)
28 ,CONT_ATTRIBUTE13 VARCHAR2(150)
29 ,CONT_ATTRIBUTE14 VARCHAR2(150)
30 ,CONT_ATTRIBUTE15 VARCHAR2(150)
31 ,CONT_ATTRIBUTE16 VARCHAR2(150)
32 ,CONT_ATTRIBUTE17 VARCHAR2(150)
33 ,CONT_ATTRIBUTE18 VARCHAR2(150)
34 ,CONT_ATTRIBUTE19 VARCHAR2(150)
35 ,CONT_ATTRIBUTE20 VARCHAR2(150)
36 -- end fix 1772037
37 );
38 
39 procedure ler_chk(p_old IN g_con_ler_rec
40                  ,p_new IN g_con_ler_rec
41                  ,p_effective_date in date default null );
42 end;