PACKAGE: APPS.BEN_PAC_LER

Source

1 package ben_pac_ler AUTHID CURRENT_USER as
2 /* $Header: bepactrg.pkh 115.0 2004/02/13 07:41:55 nhunur noship $ */
3 
4 
5 TYPE  g_pac_ler_rec is RECORD
6 (PERSON_ANALYSIS_ID               NUMBER(15)
7  ,BUSINESS_GROUP_ID                NUMBER(15)
8  ,ANALYSIS_CRITERIA_ID             NUMBER(15)
9  ,PERSON_ID                        NUMBER(10)
10  ,COMMENTS                         LONG
11  ,DATE_FROM                        DATE
12  ,DATE_TO                          DATE
13  ,ID_FLEX_NUM                      NUMBER
14  ,ATTRIBUTE_CATEGORY               VARCHAR2(30)
15  ,ATTRIBUTE1                       VARCHAR2(150)
16  ,ATTRIBUTE2                       VARCHAR2(150)
17  ,ATTRIBUTE3                       VARCHAR2(150)
18  ,ATTRIBUTE4                       VARCHAR2(150)
19  ,ATTRIBUTE5                       VARCHAR2(150)
20  ,ATTRIBUTE6                       VARCHAR2(150)
21  ,ATTRIBUTE7                       VARCHAR2(150)
22  ,ATTRIBUTE8                       VARCHAR2(150)
23  ,ATTRIBUTE9                       VARCHAR2(150)
24  ,ATTRIBUTE10                      VARCHAR2(150)
25  ,ATTRIBUTE11                      VARCHAR2(150)
26  ,ATTRIBUTE12                      VARCHAR2(150)
27  ,ATTRIBUTE13                      VARCHAR2(150)
28  ,ATTRIBUTE14                      VARCHAR2(150)
29  ,ATTRIBUTE15                      VARCHAR2(150)
30  ,ATTRIBUTE16                      VARCHAR2(150)
31  ,ATTRIBUTE17                      VARCHAR2(150)
32  ,ATTRIBUTE18                      VARCHAR2(150)
33  ,ATTRIBUTE19                      VARCHAR2(150)
34  ,ATTRIBUTE20                      VARCHAR2(150));
35  --
36 procedure ler_chk(p_old IN g_pac_ler_rec
37                  ,p_new IN g_pac_ler_rec
38                  ,p_effective_date in date default null );
39 end;