PACKAGE: APPS.HR_ABSUTIL_SS

Source

1 PACKAGE HR_ABSUTIL_SS AS
2 /* $Header: hrabsutlss.pkh 120.3 2007/12/03 16:58:41 rachakra ship $ */
3 -- Package Variables
4 --
5 function getStartDate(p_transaction_id in number,
6                        p_absence_attendance_id in number) return date;
7 
8 function getEndDate(p_transaction_id in number,
9                        p_absence_attendance_id in number) return date;
10 
11 function getAbsenceType(p_transaction_id in number,
12                             p_absence_attendance_id in number) return varchar2;
13 
14 function getAbsenceCategory(p_transaction_id in number,
15                             p_absence_attendance_id in number) return varchar2;
16 
17 function getAbsenceHoursDuration(p_transaction_id in number,
18                             p_absence_attendance_id in number) return number;
19 
20 function getAbsenceDaysDuration(p_transaction_id in number,
21                             p_absence_attendance_id in number) return number;
22 
23 function getApprovalStatus(p_transaction_id in number,
24                             p_absence_attendance_id in number) return varchar2;
25 
26 function getAbsenceStatus(p_transaction_id in number,
27                             p_absence_attendance_id in number) return varchar2;
28 
29 function isUpdateAllowed(p_transaction_id in number,
30                          p_absence_attendance_id in number,
31                          p_transaction_status in varchar2) return varchar2;
32 
33 function isConfirmAllowed(p_transaction_id in number,
34                           p_absence_attendance_id in number) return varchar2;
35 
36 function isCancelAllowed(p_transaction_id in number,
37                             p_absence_attendance_id in number,
38                          p_transaction_status in varchar2) return varchar2;
39 
40 function hasSupportingDocuments(p_transaction_id in number,
41                             p_absence_attendance_id in number) return varchar2;
42 
43 procedure getAbsenceNotificationDetails(p_transaction_id in number
44                                        ,p_notification_subject out nocopy varchar2);
45 
46 function getApprovalStatusCode(p_transaction_id in number,
47                            p_absence_attendance_id in number) return varchar2;
48 
49 function getAbsDurHours(
50   p_absence_attendance_type_id in  number
51  ,p_business_group_id          in  number
52  ,p_effective_date             in  date
53  ,p_person_id                  in  number
54  ,p_date_start                 in  date
55  ,p_date_end                   in  date
56  ,p_time_start                 in  varchar2
57  ,p_time_end                   in  varchar2)
58   return number;
59 
60 function getAbsDurDays(
61   p_absence_attendance_type_id in  number
62  ,p_business_group_id          in  number
63  ,p_effective_date             in  date
64  ,p_person_id                  in  number
65  ,p_date_start                 in  date
66  ,p_date_end                   in  date
67  ,p_time_start                 in  varchar2
68  ,p_time_end                   in  varchar2)
69  return number;
70 
71 function getAbsenceStatusValue(p_transaction_id in Varchar2) return varchar2;
72 
73 END HR_ABSUTIL_SS;