4 --
1 Package PER_GB_ABSENCE_EVIDENCE_SWI AUTHID CURRENT_USER As
2 /* $Header: pergbabsswi.pkh 120.0 2011/03/16 17:33:51 npannamp noship $ */
3 --
5 -- ----------------------------------------------------------------------------
6 -- |--------------------< create_gb_absence_evidence >------------------------|
7 -- ----------------------------------------------------------------------------
8 -- {Start of comments}
9 --
10 -- Description:
11 -- This procedure is the self-service wrapper procedure to the following
12 -- API: hr_person_absence_api.create_person_absence
13 --
14 -- Pre-requisites
18 -- p_return_status will return value indicating success.
15 -- All 'IN' parameters to this procedure have been appropriately derived.
16 --
17 -- Post Success:
19 --
20 -- Post Failure:
21 -- p_return_status will return value indication failure.
22 --
23 -- Access Status:
24 -- Internal Development use only.
25 --
26 -- {End of comments}
27 -- ----------------------------------------------------------------------------
28 PROCEDURE create_gb_absence_evidence
29 (p_validate in number default hr_api.g_false_num
30 ,p_effective_date in date default null
31 ,p_person_id in number default null
32 ,p_business_group_id in number default null
33 ,p_absence_attendance_type_id in number default null
34 ,p_evidence_date in date default null
35 ,p_evidence_source in varchar2 default null
36 ,p_absence_attendance_id in number default null
37 ,p_maternity_id in number default null
38 ,p_medical_type in varchar2 default null
39 ,p_self_certificate in varchar2 default null
40 ,p_predicted_fitness_date in date default null
41 ,p_evidence_status in varchar2 default null
42 ,p_evidence_details in varchar2 default null
43 ,p_accept_late_evidence_flag in varchar2 default null
44 ,p_reason_for_late_evidence in varchar2 default null
45 ,p_evidence_received_date in date default null
46 ,p_attribute_category in varchar2 default null
47 ,p_attribute1 in varchar2 default null
48 ,p_attribute2 in varchar2 default null
49 ,p_attribute3 in varchar2 default null
50 ,p_attribute4 in varchar2 default null
51 ,p_attribute5 in varchar2 default null
52 ,p_attribute6 in varchar2 default null
53 ,p_attribute7 in varchar2 default null
54 ,p_attribute8 in varchar2 default null
55 ,p_attribute9 in varchar2 default null
56 ,p_attribute10 in varchar2 default null
57 ,p_attribute11 in varchar2 default null
58 ,p_attribute12 in varchar2 default null
59 ,p_attribute13 in varchar2 default null
60 ,p_attribute14 in varchar2 default null
61 ,p_attribute15 in varchar2 default null
62 ,p_attribute16 in varchar2 default null
63 ,p_attribute17 in varchar2 default null
64 ,p_attribute18 in varchar2 default null
65 ,p_attribute19 in varchar2 default null
66 ,p_attribute20 in varchar2 default null
67 ,p_medical_id in out nocopy number
68 ,p_object_version_number out nocopy number
69 ,p_return_status out nocopy varchar2
70 ) ;
71 -- ----------------------------------------------------------------------------
72 -- |-------------< update_gb_absence_evidence >------------------------|
73 -- ----------------------------------------------------------------------------
74 -- {Start of comments}
75 --
76 -- Description:
77 -- This procedure is the self-service wrapper procedure to the following
78 -- API: hr_person_absence_api.update_person_absence
79 --
80 -- Pre-requisites
81 -- All 'IN' parameters to this procedure have been appropriately derived.
82 --
83 -- Post Success:
84 -- p_return_status will return value indicating success.
85 --
86 -- Post Failure:
87 -- p_return_status will return value indication failure.
88 --
89 -- Access Status:
90 -- Internal Development use only.
91 --
92 -- {End of comments}
93 -- ----------------------------------------------------------------------------
94 PROCEDURE update_gb_absence_evidence
95 (p_validate in number default hr_api.g_false_num
96 ,p_effective_date in date default hr_api.g_date
97 ,p_person_id in number default hr_api.g_number
98 ,p_business_group_id in number default hr_api.g_number
99 ,p_absence_attendance_type_id in number default hr_api.g_number
100 ,p_evidence_date in date default hr_api.g_date
101 ,p_evidence_source in varchar2 default hr_api.g_varchar2
102 ,p_absence_attendance_id in number default hr_api.g_number
103 ,p_maternity_id in number default hr_api.g_number
104 ,p_medical_type in varchar2 default hr_api.g_varchar2
105 ,p_self_certificate in varchar2 default hr_api.g_varchar2
106 ,p_predicted_fitness_date in date default hr_api.g_date
107 ,p_evidence_status in varchar2 default hr_api.g_varchar2
108 ,p_evidence_details in varchar2 default hr_api.g_varchar2
109 ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
110 ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
111 ,p_evidence_received_date in date default hr_api.g_date
112 ,p_attribute_category in varchar2 default hr_api.g_varchar2
113 ,p_attribute1 in varchar2 default hr_api.g_varchar2
114 ,p_attribute2 in varchar2 default hr_api.g_varchar2
115 ,p_attribute3 in varchar2 default hr_api.g_varchar2
116 ,p_attribute4 in varchar2 default hr_api.g_varchar2
117 ,p_attribute5 in varchar2 default hr_api.g_varchar2
118 ,p_attribute6 in varchar2 default hr_api.g_varchar2
119 ,p_attribute7 in varchar2 default hr_api.g_varchar2
120 ,p_attribute8 in varchar2 default hr_api.g_varchar2
121 ,p_attribute9 in varchar2 default hr_api.g_varchar2
122 ,p_attribute10 in varchar2 default hr_api.g_varchar2
123 ,p_attribute11 in varchar2 default hr_api.g_varchar2
124 ,p_attribute12 in varchar2 default hr_api.g_varchar2
125 ,p_attribute13 in varchar2 default hr_api.g_varchar2
126 ,p_attribute14 in varchar2 default hr_api.g_varchar2
127 ,p_attribute15 in varchar2 default hr_api.g_varchar2
128 ,p_attribute16 in varchar2 default hr_api.g_varchar2
129 ,p_attribute17 in varchar2 default hr_api.g_varchar2
130 ,p_attribute18 in varchar2 default hr_api.g_varchar2
131 ,p_attribute19 in varchar2 default hr_api.g_varchar2
132 ,p_attribute20 in varchar2 default hr_api.g_varchar2
133 ,p_medical_id in out nocopy number
134 ,p_object_version_number out nocopy number
135 ,p_return_status out nocopy varchar2
136 ) ;
137 -- ----------------------------------------------------------------------------
138 -- |-------------< delete_gb_absence_evidence >------------------------|
139 -- ----------------------------------------------------------------------------
140 -- {Start of comments}
141 --
142 -- Description:
143 -- This procedure is the self-service wrapper procedure to the following
144 -- API: hr_person_absence_api.delete_person_absence
145 --
146 -- Pre-requisites
147 -- All 'IN' parameters to this procedure have been appropriately derived.
148 --
149 -- Post Success:
150 -- p_return_status will return value indicating success.
151 --
152 -- Post Failure:
153 -- p_return_status will return value indication failure.
154 --
155 -- Access Status:
156 -- Internal Development use only.
157 --
158 -- {End of comments}
159 -- ----------------------------------------------------------------------------
160 PROCEDURE delete_gb_absence_evidence
161 (p_validate in number default hr_api.g_false_num
162 ,p_absence_attendance_id in number
163 ,p_medical_id in number
164 ,p_object_version_number in number
165 ,p_return_status out nocopy varchar2
166 );
167
168 -- ----------------------------------------------------------------------------
169 -- |---------------------------< process_api >--------------------------------|
170 -- ----------------------------------------------------------------------------
171 -- {Start of comments}
172 --
173 -- Description:
174 -- This procedure is responsible for commiting data from transaction
175 -- table (hr_api_transaction_step_id) to the base table
176 --
177 -- Parameters:
178 -- p_document is the document having the data that needs to be committed
179 -- p_return_status is the return status after committing the date. In case of
180 -- any errors/warnings the p_return_status is populated with 'E' or 'W'
181 -- p_validate is the flag to indicate whether to rollback data or not
182 -- p_effective_date is the current effective date
183 --
184 -- Access Status:
185 -- Internal Development use only.
186 --
187 -- {End of comments}
188 -- ----------------------------------------------------------------------------
189
190 Procedure process_api
191 ( p_document in CLOB
192 ,p_return_status out nocopy VARCHAR2
193 ,p_validate in number default hr_api.g_false_num
194 ,p_effective_date in date default null
195 );
196
197 end PER_GB_ABSENCE_EVIDENCE_SWI;