[Home] [Help]
PACKAGE BODY: APPS.PER_MX_DISABILITY_API
Source
1 PACKAGE BODY PER_MX_DISABILITY_API AS
2 /* $Header: pemxwrda.pkb 120.0 2005/05/31 11:32:02 appldev noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : PER_MX_DISABILITY_API
21
22 Description : This is Mexican wrapper package for per_disability_api.
23
24 Change List
25 -----------
26 Date Name Vers Bug No Description
27 ----------- ---------- ------ ------- -------------------------------
28 29-JUN-2004 sdahiya 115.0 Created.
29 29-JUN-2004 sdahiya 115.1 Removed parameter p_deg_of_perm_disability
30 08-JUL-2004 sdahiya 115.2 Enabled defaulting of p_registration_id
31 parameter of update_mx_disability procedure.
32 08-JUL-2004 sdahiya 115.3 Introduced business group check in create_mx_disability
33 and update_mx_disability procedures.
34 *****************************************************************************/
35
36 g_proc_name varchar2 (100);
37
38 /*******************************************************************************
39 Name : create_mx_disability
40 Purpose : This procedure acts as wrapper for per_disability_api.create_disability.
41 *******************************************************************************/
42
43 PROCEDURE CREATE_MX_DISABILITY
44 (p_validate in boolean default false
45 ,p_effective_date in date
46 ,p_person_id in number
47 ,p_category in varchar2
48 ,p_status in varchar2
49 ,p_quota_fte in number default 1.00
50 ,p_organization_id in number default null
51 ,p_registration_id in varchar2
52 ,p_registration_date in date default null
53 ,p_registration_exp_date in date default null
54 ,p_description in varchar2 default null
55 ,p_degree in number default null
56 ,p_reason in varchar2 default null
57 ,p_work_restriction in varchar2 default null
58 ,p_incident_id in number default null
59 ,p_medical_assessment_id in number default null
60 ,p_pre_registration_job in varchar2 default null
61 ,p_attribute_category in varchar2 default null
62 ,p_attribute1 in varchar2 default null
63 ,p_attribute2 in varchar2 default null
64 ,p_attribute3 in varchar2 default null
65 ,p_attribute4 in varchar2 default null
66 ,p_attribute5 in varchar2 default null
67 ,p_attribute6 in varchar2 default null
68 ,p_attribute7 in varchar2 default null
69 ,p_attribute8 in varchar2 default null
70 ,p_attribute9 in varchar2 default null
71 ,p_attribute10 in varchar2 default null
72 ,p_attribute11 in varchar2 default null
73 ,p_attribute12 in varchar2 default null
74 ,p_attribute13 in varchar2 default null
75 ,p_attribute14 in varchar2 default null
76 ,p_attribute15 in varchar2 default null
77 ,p_attribute16 in varchar2 default null
78 ,p_attribute17 in varchar2 default null
79 ,p_attribute18 in varchar2 default null
80 ,p_attribute19 in varchar2 default null
81 ,p_attribute20 in varchar2 default null
82 ,p_attribute21 in varchar2 default null
83 ,p_attribute22 in varchar2 default null
84 ,p_attribute23 in varchar2 default null
85 ,p_attribute24 in varchar2 default null
86 ,p_attribute25 in varchar2 default null
87 ,p_attribute26 in varchar2 default null
88 ,p_attribute27 in varchar2 default null
89 ,p_attribute28 in varchar2 default null
90 ,p_attribute29 in varchar2 default null
91 ,p_attribute30 in varchar2 default null
92 ,p_related_disability_id in varchar2 default null
93 ,p_disability_id out nocopy number
94 ,p_object_version_number out nocopy number
95 ,p_effective_start_date out nocopy date
96 ,p_effective_end_date out nocopy date
97 ) AS
98
99 l_proc_name varchar2(100);
100
101 BEGIN
102 l_proc_name := g_proc_name ||'CREATE_MX_DISABILITY';
103 hr_utility.trace('Entering '||l_proc_name);
104
105 fnd_profile.put('PER_PERSON_ID',p_person_id);
106 hr_mx_utility.check_bus_grp(hr_mx_utility.get_bg_from_person(p_person_id),'MX');
107
108 per_disability_api.create_disability
109 (p_validate => p_validate
110 ,p_effective_date => p_effective_date
111 ,p_person_id => p_person_id
112 ,p_category => p_category
113 ,p_status => p_status
114 ,p_quota_fte => p_quota_fte
115 ,p_organization_id => p_organization_id
116 ,p_registration_id => p_registration_id
117 ,p_registration_date => p_registration_date
118 ,p_registration_exp_date => p_registration_exp_date
119 ,p_description => p_description
120 ,p_degree => p_degree
121 ,p_reason => p_reason
122 ,p_work_restriction => p_work_restriction
123 ,p_incident_id => p_incident_id
124 ,p_medical_assessment_id => p_medical_assessment_id
125 ,p_pre_registration_job => p_pre_registration_job
126 ,p_attribute_category => p_attribute_category
127 ,p_attribute1 => p_attribute1
128 ,p_attribute2 => p_attribute2
129 ,p_attribute3 => p_attribute3
130 ,p_attribute4 => p_attribute4
131 ,p_attribute5 => p_attribute5
132 ,p_attribute6 => p_attribute6
133 ,p_attribute7 => p_attribute7
134 ,p_attribute8 => p_attribute8
135 ,p_attribute9 => p_attribute9
136 ,p_attribute10 => p_attribute10
137 ,p_attribute11 => p_attribute11
138 ,p_attribute12 => p_attribute12
139 ,p_attribute13 => p_attribute13
140 ,p_attribute14 => p_attribute14
141 ,p_attribute15 => p_attribute15
142 ,p_attribute16 => p_attribute16
143 ,p_attribute17 => p_attribute17
144 ,p_attribute18 => p_attribute18
145 ,p_attribute19 => p_attribute19
146 ,p_attribute20 => p_attribute20
147 ,p_attribute21 => p_attribute21
148 ,p_attribute22 => p_attribute22
149 ,p_attribute23 => p_attribute23
150 ,p_attribute24 => p_attribute24
151 ,p_attribute25 => p_attribute25
152 ,p_attribute26 => p_attribute26
153 ,p_attribute27 => p_attribute27
154 ,p_attribute28 => p_attribute28
155 ,p_attribute29 => p_attribute29
156 ,p_attribute30 => p_attribute30
157 ,p_dis_information_category => 'MX'
158 ,p_dis_information1 => p_related_disability_id
159 -- OUT parameters
160 ,p_disability_id => p_disability_id
161 ,p_object_version_number => p_object_version_number
162 ,p_effective_start_date => p_effective_start_date
163 ,p_effective_end_date => p_effective_end_date);
164
165 hr_utility.trace('Leaving '||l_proc_name);
166 END CREATE_MX_DISABILITY;
167
168
169 /*******************************************************************************
170 Name : update_mx_disability
171 Purpose : This procedure acts as wrapper for per_disability_api.update_disability
172 *******************************************************************************/
173
174 PROCEDURE UPDATE_MX_DISABILITY
175 (p_validate in boolean default false
176 ,p_effective_date in date
177 ,p_datetrack_mode in varchar2
178 ,p_disability_id in number
179 ,p_object_version_number in out nocopy number
180 ,p_category in varchar2 default hr_api.g_varchar2
181 ,p_status in varchar2 default hr_api.g_varchar2
182 ,p_quota_fte in number default hr_api.g_number
183 ,p_organization_id in number default hr_api.g_number
184 ,p_registration_id in varchar2 default hr_api.g_varchar2
185 ,p_registration_date in date default hr_api.g_date
186 ,p_registration_exp_date in date default hr_api.g_date
187 ,p_description in varchar2 default hr_api.g_varchar2
188 ,p_degree in number default hr_api.g_number
189 ,p_reason in varchar2 default hr_api.g_varchar2
190 ,p_work_restriction in varchar2 default hr_api.g_varchar2
191 ,p_incident_id in number default hr_api.g_number
192 ,p_medical_assessment_id in number default hr_api.g_number
193 ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
194 ,p_attribute_category in varchar2 default hr_api.g_varchar2
195 ,p_attribute1 in varchar2 default hr_api.g_varchar2
196 ,p_attribute2 in varchar2 default hr_api.g_varchar2
197 ,p_attribute3 in varchar2 default hr_api.g_varchar2
198 ,p_attribute4 in varchar2 default hr_api.g_varchar2
199 ,p_attribute5 in varchar2 default hr_api.g_varchar2
200 ,p_attribute6 in varchar2 default hr_api.g_varchar2
201 ,p_attribute7 in varchar2 default hr_api.g_varchar2
202 ,p_attribute8 in varchar2 default hr_api.g_varchar2
203 ,p_attribute9 in varchar2 default hr_api.g_varchar2
204 ,p_attribute10 in varchar2 default hr_api.g_varchar2
205 ,p_attribute11 in varchar2 default hr_api.g_varchar2
206 ,p_attribute12 in varchar2 default hr_api.g_varchar2
207 ,p_attribute13 in varchar2 default hr_api.g_varchar2
208 ,p_attribute14 in varchar2 default hr_api.g_varchar2
209 ,p_attribute15 in varchar2 default hr_api.g_varchar2
210 ,p_attribute16 in varchar2 default hr_api.g_varchar2
211 ,p_attribute17 in varchar2 default hr_api.g_varchar2
212 ,p_attribute18 in varchar2 default hr_api.g_varchar2
213 ,p_attribute19 in varchar2 default hr_api.g_varchar2
214 ,p_attribute20 in varchar2 default hr_api.g_varchar2
215 ,p_attribute21 in varchar2 default hr_api.g_varchar2
216 ,p_attribute22 in varchar2 default hr_api.g_varchar2
217 ,p_attribute23 in varchar2 default hr_api.g_varchar2
218 ,p_attribute24 in varchar2 default hr_api.g_varchar2
219 ,p_attribute25 in varchar2 default hr_api.g_varchar2
220 ,p_attribute26 in varchar2 default hr_api.g_varchar2
221 ,p_attribute27 in varchar2 default hr_api.g_varchar2
222 ,p_attribute28 in varchar2 default hr_api.g_varchar2
223 ,p_attribute29 in varchar2 default hr_api.g_varchar2
224 ,p_attribute30 in varchar2 default hr_api.g_varchar2
225 ,p_related_disability_id in varchar2 default null
226 ,p_effective_start_date out nocopy date
227 ,p_effective_end_date out nocopy date) AS
228
229 CURSOR csr_get_person_id IS
230 SELECT person_id
231 FROM per_disabilities_f
232 WHERE disability_id = p_disability_id
233 AND rownum < 2;
234
235 l_proc_name varchar2(100);
236 l_person_id per_disabilities_v.person_id%type;
237
238 BEGIN
239 l_proc_name := g_proc_name ||'UPDATE_MX_DISABILITY';
240 hr_utility.trace('Entering '||l_proc_name);
241
242 OPEN csr_get_person_id;
243 FETCH csr_get_person_id INTO l_person_id;
244 CLOSE csr_get_person_id;
245
246 fnd_profile.put('PER_PERSON_ID',l_person_id);
247 hr_mx_utility.check_bus_grp(hr_mx_utility.get_bg_from_person(l_person_id),'MX');
248
249 per_disability_api.update_disability
250 (p_validate => p_validate
251 ,p_effective_date => p_effective_date
252 ,p_datetrack_mode => p_datetrack_mode
253 ,p_disability_id => p_disability_id
254 ,p_object_version_number => p_object_version_number
255 ,p_category => p_category
256 ,p_status => p_status
257 ,p_quota_fte => p_quota_fte
258 ,p_organization_id => p_organization_id
259 ,p_registration_id => p_registration_id
260 ,p_registration_date => p_registration_date
261 ,p_registration_exp_date => p_registration_exp_date
262 ,p_description => p_description
263 ,p_degree => p_degree
264 ,p_reason => p_reason
265 ,p_work_restriction => p_work_restriction
266 ,p_incident_id => p_incident_id
267 ,p_medical_assessment_id => p_medical_assessment_id
268 ,p_pre_registration_job => p_pre_registration_job
269 ,p_attribute_category => p_attribute_category
270 ,p_attribute1 => p_attribute1
271 ,p_attribute2 => p_attribute2
272 ,p_attribute3 => p_attribute3
273 ,p_attribute4 => p_attribute4
274 ,p_attribute5 => p_attribute5
275 ,p_attribute6 => p_attribute6
276 ,p_attribute7 => p_attribute7
277 ,p_attribute8 => p_attribute8
278 ,p_attribute9 => p_attribute9
279 ,p_attribute10 => p_attribute10
280 ,p_attribute11 => p_attribute11
281 ,p_attribute12 => p_attribute12
282 ,p_attribute13 => p_attribute13
283 ,p_attribute14 => p_attribute14
284 ,p_attribute15 => p_attribute15
285 ,p_attribute16 => p_attribute16
286 ,p_attribute17 => p_attribute17
287 ,p_attribute18 => p_attribute18
288 ,p_attribute19 => p_attribute19
289 ,p_attribute20 => p_attribute20
290 ,p_attribute21 => p_attribute21
291 ,p_attribute22 => p_attribute22
292 ,p_attribute23 => p_attribute23
293 ,p_attribute24 => p_attribute24
294 ,p_attribute25 => p_attribute25
295 ,p_attribute26 => p_attribute26
296 ,p_attribute27 => p_attribute27
297 ,p_attribute28 => p_attribute28
298 ,p_attribute29 => p_attribute29
299 ,p_attribute30 => p_attribute30
300 ,p_dis_information_category => 'MX'
301 ,p_dis_information1 => p_related_disability_id
302 ,p_effective_start_date => p_effective_start_date
303 ,p_effective_end_date => p_effective_end_date);
304
305 hr_utility.trace('Leaving '||l_proc_name);
306 END UPDATE_MX_DISABILITY;
307
308 BEGIN
309 g_proc_name := 'PER_MX_DISABILITY_API.';
310 END PER_MX_DISABILITY_API;