1 PACKAGE HR_NL_DAILY_SICK_AND_RECOVERY AS
2 /* $Header: pernldsr.pkh 120.0.12000000.1 2007/01/22 03:27:44 appldev noship $ */
3 --
4 -- Descroption
5 -- This procedure used in user hook creation for the API
6 -- CREATE_PERSON_ABSENCE
7 -- A row is inserted into PER_NL_ABSENCE_CHANGES
8 -- with UPDATE_TYPE as 'START' for every insert
9 -- into PER_ABSENCE_ATTENDANCES for category 'sickness'
10 --
11 PROCEDURE insert_person_absence_changes
12 (p_absence_attendance_id IN number
13 ,p_effective_date IN date
14 ,p_person_id IN number
15 ,p_date_Projected_start IN date
16 ,p_date_start IN date
17 ,p_abs_information1 IN varchar2
18 ,p_date_projected_end IN date
19 ,p_date_end IN date);
20 --
21 -- Description
22 -- This procedure used in user hook creation for the API
23 -- UPDATE_PERSON_ABSENCE
24 -- A row is inserted into PER_NL_ABSENCE_CHANGES
25 -- with UPDATE_TYPE as 'UPDATE' or 'END' for every
26 -- update in PER_ABSENCE_ATTENDANCES for category 'sickness'
27 --
28 procedure Update_person_absence_changes
29 (p_absence_attendance_id IN number
30 ,p_effective_date IN date
31 ,p_date_end IN date
32 ,p_date_projected_end IN date
33 ,p_date_start IN date
34 ,p_date_projected_start IN date
35 ,p_abs_information1 IN varchar2);
36 --
37 -- Description
38 -- This procedure used in user hook creation for the API
39 -- DELETE_PERSON_ABSENCE
40 -- A row is inserted into PER_NL_ABSENCE_CHANGES
41 -- with UPDATE_TYPE as 'DELETE' for every
42 -- delete in PER_ABSENCE_ATTENDANCES for category 'sickness'
43 --
44 procedure Delete_person_absence_changes
45 (p_absence_attendance_id IN number);
46 --
47 -- Description
48 -- This purge procedure will remove rows from the
49 -- the table PER_NL_ABSENCE_CHANGES which are older than
50 -- one year and will run through concurrent program scheduled to
51 -- run weekly.
52 --
53 procedure purge_per_nl_absence_changes
54 (p_errbuf OUT nocopy varchar2
55 ,p_retcode OUT nocopy varchar2
56 ,p_effective_date IN varchar2
57 ,p_business_group_id IN number);
58 --
59 -- Description
60 -- Call to this procedure will update the value for reported_indicator in
61 -- PER_NL_ABSENCE_CHANGES as 'Y'
62 -- This procedure is called from the report 'Daily Sick and Recovery Report'
63 -- All records reported in the report are updated as updated
64 --
65 procedure update_reported_absence_chgs
66 (p_effective_date IN date
67 ,p_prev_rep_chg IN varchar2
68 ,p_structure_version_id IN number
69 ,p_top_org_id IN number);
70 --
71 END HR_NL_DAILY_SICK_AND_RECOVERY;