PACKAGE: APPS.BEN_ABS_LER

Source

1 package ben_abs_ler AUTHID CURRENT_USER as
2 /*$Header: beabatrg.pkh 115.8 2003/12/18 03:01:09 hmani ship $*/
3 TYPE g_abs_ler_rec is RECORD
4 (PERSON_ID NUMBER
5 ,BUSINESS_GROUP_ID NUMBER
6 ,DATE_START DATE
7 ,DATE_END DATE
8 ,ABSENCE_ATTENDANCE_TYPE_ID NUMBER
9 ,ABS_ATTENDANCE_REASON_ID  NUMBER
10 ,ABSENCE_ATTENDANCE_ID NUMBER
11 --
12 -- ABSENCES : New columns
13 --
14  ,AUTHORISING_PERSON_ID    NUMBER(10)
15  ,REPLACEMENT_PERSON_ID    NUMBER(10)
16  ,PERIOD_OF_INCAPACITY_ID  NUMBER(9)
17  ,ABSENCE_DAYS             NUMBER(9,4)
18  ,ABSENCE_HOURS            NUMBER(9,4)
19  ,DATE_NOTIFICATION        DATE
20  ,DATE_PROJECTED_END       DATE
21  ,DATE_PROJECTED_START     DATE
22  ,OCCURRENCE               NUMBER(15)
23  ,SSP1_ISSUED              VARCHAR2(30)
24  ,TIME_END                 VARCHAR2(5)
25  ,TIME_PROJECTED_END       VARCHAR2(5)
26  ,TIME_PROJECTED_START     VARCHAR2(5)
27  ,TIME_START               VARCHAR2(5)
28  ,ATTRIBUTE_CATEGORY       VARCHAR2(30)
29  ,ATTRIBUTE1               VARCHAR2(150)
30  ,ATTRIBUTE2               VARCHAR2(150)
31  ,ATTRIBUTE3               VARCHAR2(150)
32  ,ATTRIBUTE4               VARCHAR2(150)
33  ,ATTRIBUTE5               VARCHAR2(150)
34  ,ATTRIBUTE6               VARCHAR2(150)
35  ,ATTRIBUTE7               VARCHAR2(150)
36  ,ATTRIBUTE8               VARCHAR2(150)
37  ,ATTRIBUTE9               VARCHAR2(150)
38  ,ATTRIBUTE10               VARCHAR2(150)
39  ,ATTRIBUTE11               VARCHAR2(150)
40  ,ATTRIBUTE12               VARCHAR2(150)
41  ,ATTRIBUTE13               VARCHAR2(150)
42  ,ATTRIBUTE14               VARCHAR2(150)
43  ,ATTRIBUTE15               VARCHAR2(150)
44  ,ATTRIBUTE16               VARCHAR2(150)
45  ,ATTRIBUTE17               VARCHAR2(150)
46  ,ATTRIBUTE18               VARCHAR2(150)
47  ,ATTRIBUTE19               VARCHAR2(150)
48  ,ATTRIBUTE20               VARCHAR2(150)
49  ,MATERNITY_ID              NUMBER
50  ,SICKNESS_START_DATE       DATE
51  ,SICKNESS_END_DATE         DATE
52  ,PREGNANCY_RELATED_ILLNESS        VARCHAR2(30)
53  ,REASON_FOR_NOTIFICATION_DELAY    VARCHAR2(2000)
54  ,ACCEPT_LATE_NOTIFICATION_FLAG    VARCHAR2(30)
55  ,LINKED_ABSENCE_ID                NUMBER
56  ,BATCH_ID    NUMBER(9)
57  ,ABS_INFORMATION_CATEGORY    VARCHAR2(30)
58  ,ABS_INFORMATION1    VARCHAR2(150)
59  ,ABS_INFORMATION2    VARCHAR2(150)
60  ,ABS_INFORMATION3    VARCHAR2(150)
61  ,ABS_INFORMATION4    VARCHAR2(150)
62  ,ABS_INFORMATION5    VARCHAR2(150)
63  ,ABS_INFORMATION6    VARCHAR2(150)
64  ,ABS_INFORMATION7    VARCHAR2(150)
65  ,ABS_INFORMATION8    VARCHAR2(150)
66  ,ABS_INFORMATION9    VARCHAR2(150)
67  ,ABS_INFORMATION10    VARCHAR2(150)
68  ,ABS_INFORMATION11    VARCHAR2(150)
69  ,ABS_INFORMATION12    VARCHAR2(150)
70  ,ABS_INFORMATION13    VARCHAR2(150)
71  ,ABS_INFORMATION14    VARCHAR2(150)
72  ,ABS_INFORMATION15    VARCHAR2(150)
73  ,ABS_INFORMATION16    VARCHAR2(150)
74  ,ABS_INFORMATION17    VARCHAR2(150)
75  ,ABS_INFORMATION18    VARCHAR2(150)
76  ,ABS_INFORMATION19    VARCHAR2(150)
77  ,ABS_INFORMATION20    VARCHAR2(150)
78  ,ABS_INFORMATION21    VARCHAR2(150)
79  ,ABS_INFORMATION22    VARCHAR2(150)
80  ,ABS_INFORMATION23    VARCHAR2(150)
81  ,ABS_INFORMATION24    VARCHAR2(150)
82  ,ABS_INFORMATION25    VARCHAR2(150)
83  ,ABS_INFORMATION26    VARCHAR2(150)
84  ,ABS_INFORMATION27    VARCHAR2(150)
85  ,ABS_INFORMATION28    VARCHAR2(150)
86  ,ABS_INFORMATION29    VARCHAR2(150)
87  ,ABS_INFORMATION30    VARCHAR2(150)
88 );
89 
90 procedure ler_chk(p_old IN g_abs_ler_rec
91                  ,p_new IN g_abs_ler_rec
92                  ,p_effective_date in date default null );
93 end;