1 PACKAGE BODY PER_PL_AEI_INFO AS
2 /* $Header: peplaeip.pkb 120.3 2006/09/13 10:19:05 mseshadr noship $ */
3
4
5 g_package varchar2(16):='PER_PL_AEI_INFO.';
6
7 cursor csr_assgt_start_date( R_ASSIGNMENT_ID in number)is
8 select min(effective_start_date),max(effective_end_date) from per_all_assignments_f where ASSIGNMENT_ID=R_ASSIGNMENT_ID;
9
10
11 -- private procedure to validate data
12 -- entered during creation of payment conditions.
13 PROCEDURE CREATE_PL_PAYMENT_CONDITIONS(
14 P_ASSIGNMENT_ID in NUMBER ,
15 P_AEI_INFORMATION1 in varchar2 ,
16 P_AEI_INFORMATION2 in varchar2 ,
17 P_AEI_INFORMATION3 in varchar2 ,
18 P_AEI_INFORMATION4 in varchar2 ,
19 P_AEI_INFORMATION5 in varchar2 ,
20 P_AEI_INFORMATION6 in varchar2 ,
21 P_AEI_INFORMATION7 in varchar2 )
22
23 as
24
25 l_end_of_time date;
26 l_proc varchar2(44);--16+28
27 l_date_from date;--p_aei_information1
28 l_date_to date;--p_aei_information2
29 l_assignment_start_date date;
30 l_assignment_end_date date;
31
32
33 cursor csr_payment_condition_ins is
34 select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
35 from per_assignment_extra_info
36 where information_type='PL_PAYMENT_CONDITIONS'
37 and ASSIGNMENT_ID=p_assignment_id
38 and aei_information_category='PL_PAYMENT_CONDITIONS'
39 and AEI_INFORMATION3=p_AEI_INFORMATION3
40 and (
41 l_date_from between fnd_date.canonical_to_date(aei_information1)
42 and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
43 or nvl(l_date_to,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
44 and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
45 or fnd_date.canonical_to_date(aei_information1)
46 between l_date_from
47 and nvl(l_date_to,l_end_of_time)
48 );
49 l_payment_cond_row csr_payment_condition_ins%rowtype;
50
51 BEGIN
52 l_proc:=g_package||'CREATE_PL_PAYMENT_CONDITIONS';
53 hr_utility.set_location(l_proc,10);
54 l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);
55 l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);
56 l_end_of_time :=hr_general.end_of_time;
57
58 if (l_date_from >l_date_to ) then
59 hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
60 hr_utility.raise_error;
61 end if; --date check
62 --Message: You entered a start date later than the end date.
63 -- Please enter a start date earlier than or the same as the end date.
64
65 --Make sure that start date is after Assignemnt start date
66 open csr_assgt_start_date(P_ASSIGNMENT_ID);
67 fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
68 close csr_assgt_start_date;
69
70 if (l_date_from < l_assignment_start_date) or nvl(l_date_to,l_end_of_time)>l_assignment_end_date then
71 hr_utility.set_message(800,'HR_375886_PAYMENT_COND_DATES');
72 hr_utility.raise_error;
73 end if;
74
75 --ensure that for this information_type(PL_PAYMENT_CONDITIONS),assignemnt_id and type of salary(p_aei_information3)
76 --there isnt another record having same type of salary with overlapping dates
77
78 open csr_payment_condition_ins;
79 fetch csr_payment_condition_ins into l_payment_cond_row;
80 if csr_payment_condition_ins%found then
81 close csr_payment_condition_ins;
82 if l_payment_cond_row.aei_information2 is not null then
83 --there exists an end date for the record...display both start and end dates
84 hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
85 hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
86 hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
87 hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));
88 hr_utility.raise_error;
89 else
90 --there doesnt exist a end date for this record...hence display only the start date
91 --new message being used as we cannot display 31-dec-4712 to user---
92 hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
93 hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
94 hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
95 hr_utility.raise_error;
96 end if; --aei information2 is not null
97 end if; --csr_payment_condition_ins found
98 close csr_payment_condition_ins;
99
100 hr_utility.set_location('Leaving'||l_proc,20);
101 END;
102
103 procedure UPDATE_PL_PAYMENT_CONDITIONS(
104
105 P_ASSIGNMENT_EXTRA_INFO_ID in NUMBER,
106 P_AEI_INFORMATION1 in varchar2 ,
107 P_AEI_INFORMATION2 in varchar2 ,
108 P_AEI_INFORMATION3 in varchar2 ,
109 P_AEI_INFORMATION4 in varchar2 ,
110 P_AEI_INFORMATION5 in varchar2 ,
111 P_AEI_INFORMATION6 in varchar2 ,
112 P_AEI_INFORMATION7 in varchar2
113 )
114 as
115
116 l_end_of_time date;
117 l_proc varchar2(44);--16+28
118 l_date_from date;--p_aei_information1
119 l_date_to date;--p_aei_information2
120 l_assignment_start_date date;
121 l_assignment_end_date date;
122 l_assignment_id number;
123
124 cursor csr_assignment_id is
125 select assignment_id
126 from per_assignment_extra_info
127 where information_type='PL_PAYMENT_CONDITIONS'
128 and ASSIGNMENT_EXTRA_INFO_ID=P_ASSIGNMENT_EXTRA_INFO_ID;
129
130 cursor csr_payment_condition_upd(r_assignment_id in number) is
131 select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
132 from per_assignment_extra_info
133 where information_type='PL_PAYMENT_CONDITIONS'
134 and per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id
135 and aei_information_category='PL_PAYMENT_CONDITIONS'
136 and AEI_INFORMATION3=p_AEI_INFORMATION3
137 and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
138 and (
139 l_date_from between fnd_date.canonical_to_date(aei_information1)
140 and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
141 or nvl(l_date_to ,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
142 and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
143 or fnd_date.canonical_to_date(aei_information1)
144 between l_date_from
145 and nvl(l_date_to ,l_end_of_time)
146 );
147 l_payment_cond_row csr_payment_condition_upd%rowtype;
148
149 Begin
150
151 l_proc:= g_package||'UPDATE_PL_PAYMENT_CONITIONS';
152 hr_utility.set_location('Entering '||l_proc,10);
153 l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);
154 l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);
155 l_end_of_time :=hr_general.end_of_time;
156
157 if (l_date_from >l_date_to ) then
158 hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
159 hr_utility.raise_error;
160 end if; --date check
161 --Message: You entered a start date later than the end date.
162 -- Please enter a start date earlier than or the same as the end date.
163
164 open csr_assignment_id;
165 fetch csr_assignment_id into l_assignment_id;
166 close csr_assignment_id;
167
168 --Make sure that start date is after Assignemnt start date
169 open csr_assgt_start_date(l_ASSIGNMENT_ID);
170 fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
171 close csr_assgt_start_date;
172
173 if (l_date_from < l_assignment_start_date ) or nvl(l_date_to,l_end_of_time)>l_assignment_end_date then
174 hr_utility.set_message(800,'HR_375886_PAYMENT_COND_DATES');
175 hr_utility.raise_error;
176 end if;
177
178
179 open csr_payment_condition_upd(l_assignment_id);
180 fetch csr_payment_condition_upd into l_payment_cond_row;
181 if csr_payment_condition_upd%found then
182 close csr_payment_condition_upd;
183 if l_payment_cond_row.aei_information2 is not null then
184 --there exists an end date for the record...display both start and end dates
185 hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
186 hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
187 hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
188 hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));
189 hr_utility.raise_error;
190 else
191 --there doesnt exist a end date for this record...hence display only the start date
192 --new message being used as we cannot display 31-dec-4712 to user---
193 hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
194 hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
195 hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
196 hr_utility.raise_error;
197 end if; --aei information2 is not null
198 end if;--csr_payment_condition_upd found
199 close csr_payment_condition_upd;
200
201 hr_utility.set_location('Leaving'||l_proc,20);
202
203 Exception
204 When others then
205 hr_utility.raise_error;
206
207 END UPDATE_PL_PAYMENT_CONDITIONS; --end procedure
208
209
210
211
212 procedure CREATE_PL_ASSGT_EXTRA_INFO(
213 P_ASSIGNMENT_ID in NUMBER ,
214 p_information_type in varchar2,
215 p_aei_information_category in varchar2,
216 P_AEI_INFORMATION1 in varchar2 ,
217 P_AEI_INFORMATION2 in varchar2 ,
218 P_AEI_INFORMATION3 in varchar2 ,
219 P_AEI_INFORMATION4 in varchar2 ,
220 P_AEI_INFORMATION5 in varchar2 ,
221 P_AEI_INFORMATION6 in varchar2 ,
222 P_AEI_INFORMATION7 in varchar2
223 ) as
224
225
226 cursor csr_work_condition_date_ins is
227 select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
228 from per_assignment_extra_info
229 where information_type='PL_OTHER_WORK_CONDITIONS'
230 and ASSIGNMENT_ID=p_assignment_id
231 and aei_information_category=p_aei_information_category
232 and AEI_INFORMATION3=p_AEI_INFORMATION3
233 and (
234 fnd_date.canonical_to_date(p_aei_information1)
235 between fnd_date.canonical_to_date(aei_information1)
236 and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237 or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238 between fnd_date.canonical_to_date(aei_information1)
239 and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240 or fnd_date.canonical_to_date( aei_information1)
241 between fnd_date.canonical_to_date(p_aei_information1)
242 and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243 or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
244 between fnd_date.canonical_to_date(p_aei_information1)
245 and fnd_date.canonical_to_date(p_aei_information2)
246 );
247 l_work_cond_row csr_work_condition_date_ins%rowtype;
248 l_assignment_start_date date;
249 l_assignment_end_date date;
250 l_proc varchar2(26);
251
252 Begin
253
254 /*Create new private procedure for each of the
255 newly added Assignmenmt EIT,pass on the reqd
256 parameters to the private procedure,and perform
257 necessary validations there
258 */
259
260 l_proc:='CREATE_PL_ASSGT_EXTRA_INFO';
261 /* Added for GSI Bug 5472781 */
262 IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
263 hr_utility.set_location('Leaving : '||l_proc,10);
264 return;
265 END IF;
266 hr_utility.set_location('Entering '||g_package||l_proc,10);
267
268 if p_information_type='PL_OTHER_WORK_CONDITIONS' then
269 --ensure start date is less than end date
270 --HR_ORG_START_DATE_PL already contains an apt message.so using it.
271 if (fnd_date.canonical_to_date(p_AEI_INFORMATION1)>fnd_date.canonical_to_date(p_AEI_INFORMATION2)) then
272 hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
273 hr_utility.raise_error;
274 end if; --date check
275
276 hr_utility.set_location(g_package||l_proc,20);
277 --Make sure that start date is after Assignemnt start date
278 open csr_assgt_start_date(P_ASSIGNMENT_ID);
279 fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
280 close csr_assgt_start_date;
281
282 hr_utility.set_location(g_package||l_proc,30);
283
284 if (fnd_date.canonical_to_date(p_aei_information1)<l_assignment_start_date) or
285 nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then
286 hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');
287 hr_utility.raise_error;
288 end if;
289
290
291 hr_utility.set_location(g_package||l_proc,40);
292
293 --ensure that for this information_type,assignemnt_id and Kind of Work(p_aei_information3),
294 --there isnt another record having same Kind of Work
295 --with overlapping dates
296
297 open csr_work_condition_date_ins;
298 fetch csr_work_condition_date_ins into l_work_cond_row;
299 if csr_work_condition_date_ins%found then
300 close csr_work_condition_date_ins;
301 if l_work_cond_row.aei_information2 is not null then
302 --there exists an end date for the record...display both start and end dates
303 hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
304 hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
305 hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
306 hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
307 hr_utility.raise_error;
308 else
309 --there doesnt exist a end date for this record...hence display only the start date
310 --new message being used as we cannot display 31-dec-4712 to user---
311 hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
312 hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
313 hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
314 hr_utility.raise_error;
315 end if; --aei information2 is not null
316 end if; --csr_work_condition_date_ins found
317 close csr_work_condition_date_ins;
318
319 --better to have different internal procedures to check each of the Assignment EITS
320 --than to go abt checking here.
321
322 elsif p_information_type='PL_PAYMENT_CONDITIONS' then
323
324 CREATE_PL_PAYMENT_CONDITIONS(
325 P_ASSIGNMENT_ID => P_ASSIGNMENT_ID ,
326 P_AEI_INFORMATION1 => P_AEI_INFORMATION1,
327 P_AEI_INFORMATION2 => P_AEI_INFORMATION2,
328 P_AEI_INFORMATION3 => P_AEI_INFORMATION3,
329 P_AEI_INFORMATION4 => P_AEI_INFORMATION4,
330 P_AEI_INFORMATION5 => P_AEI_INFORMATION5,
331 P_AEI_INFORMATION6 => P_AEI_INFORMATION6,
332 P_AEI_INFORMATION7 => P_AEI_INFORMATION7);
333
334 end if;
335
336 hr_utility.set_location('Leaving'||g_package||l_proc,50);
337
338
339 Exception
340 When others then
341 hr_utility.raise_error;
342 end; --end procedure
343
344
345 procedure UPDATE_PL_ASSGT_EXTRA_INFO(
346
347 P_ASSIGNMENT_EXTRA_INFO_ID in NUMBER,
348 p_aei_information_category in VARCHAR2,
349 P_AEI_INFORMATION1 in varchar2 ,
350 P_AEI_INFORMATION2 in varchar2 ,
351 P_AEI_INFORMATION3 in varchar2 ,
352 P_AEI_INFORMATION4 in varchar2 ,
353 P_AEI_INFORMATION5 in varchar2 ,
354 P_AEI_INFORMATION6 in varchar2 ,
355 P_AEI_INFORMATION7 in varchar2
356 )
357 as
358
359
360 cursor csr_assignment_id is
361 select assignment_id
362 from per_assignment_extra_info
363 where information_type='PL_OTHER_WORK_CONDITIONS'
364 and ASSIGNMENT_EXTRA_INFO_ID=P_ASSIGNMENT_EXTRA_INFO_ID;
365
366 cursor csr_work_condition_date_upd(r_assignment_id in number) is
367 select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
368 from per_assignment_extra_info
369 where information_type='PL_OTHER_WORK_CONDITIONS'
370 and per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id
371 and aei_information_category=p_aei_information_category
372 and AEI_INFORMATION3=p_AEI_INFORMATION3
373 and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
374 and (
375 fnd_date.canonical_to_date(p_aei_information1)
376 between fnd_date.canonical_to_date(aei_information1)
377 and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378 or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379 between fnd_date.canonical_to_date(aei_information1)
380 and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381 or fnd_date.canonical_to_date(aei_information1)
382 between fnd_date.canonical_to_date(p_aei_information1)
383 and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384 or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
385 between fnd_date.canonical_to_date(p_aei_information1)
386 and fnd_date.canonical_to_date(p_aei_information2)
387 );
388 l_assignment_id number;
389 l_assignment_start_date date;
390 l_assignment_end_date date;
391 l_work_cond_row csr_work_condition_date_upd%rowtype;
392 l_proc varchar2(26);
393
394 begin
395
396 /*Create new private procedure for each of the
397 newly added Assignmenmt EIT,pass on the reqd
398 parameters to the private procedure,and perform
399 necessary validations there
400 */
401
402 l_proc:= 'UPDATE_PL_ASSGT_EXTRA_INFO';
403 /* Added for GSI Bug 5472781 */
404 IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
405 hr_utility.set_location('Leaving : '||l_proc,10);
406 return;
407 END IF;
408 hr_utility.set_location('Entering '||g_package||l_proc,10);
409
410 if p_aei_information_category = 'PL_OTHER_WORK_CONDITIONS' then
411 if (fnd_date.canonical_to_date(p_AEI_INFORMATION1)>fnd_date.canonical_to_date(p_AEI_INFORMATION2)) then
412 hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
413 hr_utility.raise_error;
414 end if;
415
416 open csr_assignment_id;
417 fetch csr_assignment_id into l_assignment_id;
418 close csr_assignment_id;
419
420 hr_utility.set_location(g_package||l_proc,20);
421
425 close csr_assgt_start_date;
422 --Make sure that start date is after Assignemnt start date
423 open csr_assgt_start_date(l_ASSIGNMENT_ID);
424 fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
426
427 if (fnd_date.canonical_to_date(p_aei_information1)<l_assignment_start_date) or
428 nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then
429 hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');
430 hr_utility.raise_error;
431 end if;
432
433 hr_utility.set_location(g_package||l_proc,30);
434
435 open csr_work_condition_date_upd(l_assignment_id);
436 fetch csr_work_condition_date_upd into l_work_cond_row;
437 if csr_work_condition_date_upd%found then
438 close csr_work_condition_date_upd;
439 if l_work_cond_row.aei_information2 is not null then
440 --there exists an end date for the record...display both start and end dates
441 hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
442 hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
443 hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
444 hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
445 hr_utility.raise_error;
446 else
447 --there doesnt exist a end date for this record...hence display only the start date
448 --new message being used as we cannot display 31-dec-4712 to user---
449 hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
450 hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
451 hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
452 hr_utility.raise_error;
453 end if; --aei information2 is not null
454 end if;--csr_work_condition_date_upd found
455 close csr_work_condition_date_upd;
456
457 elsif P_AEI_INFORMATION_CATEGORY='PL_PAYMENT_CONDITIONS' then
458
459 UPDATE_PL_PAYMENT_CONDITIONS( P_ASSIGNMENT_EXTRA_INFO_ID => P_ASSIGNMENT_EXTRA_INFO_ID,
460 P_AEI_INFORMATION1 => P_AEI_INFORMATION1,
461 P_AEI_INFORMATION2 => P_AEI_INFORMATION2,
462 P_AEI_INFORMATION3 => P_AEI_INFORMATION3,
466 P_AEI_INFORMATION7 => P_AEI_INFORMATION7);
463 P_AEI_INFORMATION4 => P_AEI_INFORMATION4,
464 P_AEI_INFORMATION5 => P_AEI_INFORMATION5,
465 P_AEI_INFORMATION6 => P_AEI_INFORMATION6,
467 end if;--p_aei_information_category='PL_PAYMENT_CONDITIONS'
468
469 hr_utility.set_location('Leaving'||g_package||l_proc,40);
470
471
472 Exception
473 When others then
474 hr_utility.raise_error;
475
476 END UPDATE_PL_ASSGT_EXTRA_INFO; --end procedure update
477
478 END PER_PL_AEI_INFO ; --end package