[Home] [Help]
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;