PACKAGE: APPS.HR_ABSUTIL_SS

Source

1 PACKAGE HR_ABSUTIL_SS AUTHID CURRENT_USER AS
2 /* $Header: hrabsutlss.pkh 120.5.12020000.2 2012/09/04 10:12:39 narpalan 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 getAbsenceCategoryCode(p_transaction_id in number,
18                             p_absence_attendance_id in number) return varchar2;
19 
20 function getAbsenceHoursDuration(p_transaction_id in number,
21                             p_absence_attendance_id in number) return number;
22 
23 function getAbsenceDaysDuration(p_transaction_id in number,
24                             p_absence_attendance_id in number) return number;
25 
26 function getApprovalStatus(p_transaction_id in number,
27                             p_absence_attendance_id in number) return varchar2;
28 
29 function getAbsenceStatus(p_transaction_id in number,
30                             p_absence_attendance_id in number) return varchar2;
31 
32 function isUpdateAllowed(p_transaction_id in number,
33                          p_absence_attendance_id in number,
34                          p_transaction_status in varchar2) return varchar2;
35 
36 function isConfirmAllowed(p_transaction_id in number,
37                           p_absence_attendance_id in number) return varchar2;
38 
39 function isCancelAllowed(p_transaction_id in number,
40                             p_absence_attendance_id in number,
41                          p_transaction_status in varchar2) return varchar2;
42 
43 function hasSupportingDocuments(p_transaction_id in number,
44                             p_absence_attendance_id in number) return varchar2;
45 
46 procedure getAbsenceNotificationDetails(p_transaction_id in number
47                                        ,p_notification_subject out nocopy varchar2);
48 
49 function getApprovalStatusCode(p_transaction_id in number,
50                            p_absence_attendance_id in number) return varchar2;
51 
52 function getAbsDurHours(
53   p_absence_attendance_type_id in  number
54  ,p_business_group_id          in  number
55  ,p_effective_date             in  date
56  ,p_person_id                  in  number
57  ,p_date_start                 in  date
58  ,p_date_end                   in  date
59  ,p_time_start                 in  varchar2
60  ,p_time_end                   in  varchar2)
61   return number;
62 
63 function getAbsDurDays(
64   p_absence_attendance_type_id in  number
65  ,p_business_group_id          in  number
66  ,p_effective_date             in  date
67  ,p_person_id                  in  number
68  ,p_date_start                 in  date
69  ,p_date_end                   in  date
70  ,p_time_start                 in  varchar2
71  ,p_time_end                   in  varchar2)
72  return number;
73 
74 function getAbsenceStatusValue(p_transaction_id in Varchar2) return varchar2;
75 
76 procedure delete_transaction
77 (p_transaction_id in	   number);
78 
79 procedure remove_absence_transaction(p_absence_attendance_id in number);
80 
81 END HR_ABSUTIL_SS;