107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
114: ota_ple_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
114: ota_ple_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
119: ota_ple_shd.constraint_error
112: -- A check constraint has been violated
113: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
114: ota_ple_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
119: ota_ple_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
119: ota_ple_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
124: ota_ple_shd.constraint_error
117: -- Parent integrity has been violated
118: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
119: ota_ple_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
124: ota_ple_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
124: ota_ple_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
128: Raise;
129: End update_dml;
268: -- p_rec plsql record structure
269: -- to see if a system default is being used. If a system default
270: -- is being used then we must set to the 'current' argument value.
271: --
272: If (p_rec.vendor_supply_id = hr_api.g_number) then
273: p_rec.vendor_supply_id :=
274: ota_ple_shd.g_old_rec.vendor_supply_id;
275: End If;
276: If (p_rec.activity_version_id = hr_api.g_number) then
272: If (p_rec.vendor_supply_id = hr_api.g_number) then
273: p_rec.vendor_supply_id :=
274: ota_ple_shd.g_old_rec.vendor_supply_id;
275: End If;
276: If (p_rec.activity_version_id = hr_api.g_number) then
277: p_rec.activity_version_id :=
278: ota_ple_shd.g_old_rec.activity_version_id;
279: End If;
280: If (p_rec.price_list_id = hr_api.g_number) then
276: If (p_rec.activity_version_id = hr_api.g_number) then
277: p_rec.activity_version_id :=
278: ota_ple_shd.g_old_rec.activity_version_id;
279: End If;
280: If (p_rec.price_list_id = hr_api.g_number) then
281: p_rec.price_list_id :=
282: ota_ple_shd.g_old_rec.price_list_id;
283: End If;
284: If (p_rec.price = hr_api.g_number) then
280: If (p_rec.price_list_id = hr_api.g_number) then
281: p_rec.price_list_id :=
282: ota_ple_shd.g_old_rec.price_list_id;
283: End If;
284: If (p_rec.price = hr_api.g_number) then
285: p_rec.price :=
286: ota_ple_shd.g_old_rec.price;
287: End If;
288: If (p_rec.price_basis = hr_api.g_varchar2) then
284: If (p_rec.price = hr_api.g_number) then
285: p_rec.price :=
286: ota_ple_shd.g_old_rec.price;
287: End If;
288: If (p_rec.price_basis = hr_api.g_varchar2) then
289: p_rec.price_basis :=
290: ota_ple_shd.g_old_rec.price_basis;
291: End If;
292: If (p_rec.start_date = hr_api.g_date) then
288: If (p_rec.price_basis = hr_api.g_varchar2) then
289: p_rec.price_basis :=
290: ota_ple_shd.g_old_rec.price_basis;
291: End If;
292: If (p_rec.start_date = hr_api.g_date) then
293: p_rec.start_date :=
294: ota_ple_shd.g_old_rec.start_date;
295: End If;
296: If (p_rec.comments = hr_api.g_varchar2) then
292: If (p_rec.start_date = hr_api.g_date) then
293: p_rec.start_date :=
294: ota_ple_shd.g_old_rec.start_date;
295: End If;
296: If (p_rec.comments = hr_api.g_varchar2) then
297: p_rec.comments :=
298: ota_ple_shd.g_old_rec.comments;
299: End If;
300: If (p_rec.end_date = hr_api.g_date) then
296: If (p_rec.comments = hr_api.g_varchar2) then
297: p_rec.comments :=
298: ota_ple_shd.g_old_rec.comments;
299: End If;
300: If (p_rec.end_date = hr_api.g_date) then
301: p_rec.end_date :=
302: ota_ple_shd.g_old_rec.end_date;
303: End If;
304: If (p_rec.maximum_attendees = hr_api.g_number) then
300: If (p_rec.end_date = hr_api.g_date) then
301: p_rec.end_date :=
302: ota_ple_shd.g_old_rec.end_date;
303: End If;
304: If (p_rec.maximum_attendees = hr_api.g_number) then
305: p_rec.maximum_attendees :=
306: ota_ple_shd.g_old_rec.maximum_attendees;
307: End If;
308: If (p_rec.minimum_attendees = hr_api.g_number) then
304: If (p_rec.maximum_attendees = hr_api.g_number) then
305: p_rec.maximum_attendees :=
306: ota_ple_shd.g_old_rec.maximum_attendees;
307: End If;
308: If (p_rec.minimum_attendees = hr_api.g_number) then
309: p_rec.minimum_attendees :=
310: ota_ple_shd.g_old_rec.minimum_attendees;
311: End If;
312: If (p_rec.ple_information_category = hr_api.g_varchar2) then
308: If (p_rec.minimum_attendees = hr_api.g_number) then
309: p_rec.minimum_attendees :=
310: ota_ple_shd.g_old_rec.minimum_attendees;
311: End If;
312: If (p_rec.ple_information_category = hr_api.g_varchar2) then
313: p_rec.ple_information_category :=
314: ota_ple_shd.g_old_rec.ple_information_category;
315: End If;
316: If (p_rec.ple_information1 = hr_api.g_varchar2) then
312: If (p_rec.ple_information_category = hr_api.g_varchar2) then
313: p_rec.ple_information_category :=
314: ota_ple_shd.g_old_rec.ple_information_category;
315: End If;
316: If (p_rec.ple_information1 = hr_api.g_varchar2) then
317: p_rec.ple_information1 :=
318: ota_ple_shd.g_old_rec.ple_information1;
319: End If;
320: If (p_rec.ple_information2 = hr_api.g_varchar2) then
316: If (p_rec.ple_information1 = hr_api.g_varchar2) then
317: p_rec.ple_information1 :=
318: ota_ple_shd.g_old_rec.ple_information1;
319: End If;
320: If (p_rec.ple_information2 = hr_api.g_varchar2) then
321: p_rec.ple_information2 :=
322: ota_ple_shd.g_old_rec.ple_information2;
323: End If;
324: If (p_rec.ple_information3 = hr_api.g_varchar2) then
320: If (p_rec.ple_information2 = hr_api.g_varchar2) then
321: p_rec.ple_information2 :=
322: ota_ple_shd.g_old_rec.ple_information2;
323: End If;
324: If (p_rec.ple_information3 = hr_api.g_varchar2) then
325: p_rec.ple_information3 :=
326: ota_ple_shd.g_old_rec.ple_information3;
327: End If;
328: If (p_rec.ple_information4 = hr_api.g_varchar2) then
324: If (p_rec.ple_information3 = hr_api.g_varchar2) then
325: p_rec.ple_information3 :=
326: ota_ple_shd.g_old_rec.ple_information3;
327: End If;
328: If (p_rec.ple_information4 = hr_api.g_varchar2) then
329: p_rec.ple_information4 :=
330: ota_ple_shd.g_old_rec.ple_information4;
331: End If;
332: If (p_rec.ple_information5 = hr_api.g_varchar2) then
328: If (p_rec.ple_information4 = hr_api.g_varchar2) then
329: p_rec.ple_information4 :=
330: ota_ple_shd.g_old_rec.ple_information4;
331: End If;
332: If (p_rec.ple_information5 = hr_api.g_varchar2) then
333: p_rec.ple_information5 :=
334: ota_ple_shd.g_old_rec.ple_information5;
335: End If;
336: If (p_rec.ple_information6 = hr_api.g_varchar2) then
332: If (p_rec.ple_information5 = hr_api.g_varchar2) then
333: p_rec.ple_information5 :=
334: ota_ple_shd.g_old_rec.ple_information5;
335: End If;
336: If (p_rec.ple_information6 = hr_api.g_varchar2) then
337: p_rec.ple_information6 :=
338: ota_ple_shd.g_old_rec.ple_information6;
339: End If;
340: If (p_rec.ple_information7 = hr_api.g_varchar2) then
336: If (p_rec.ple_information6 = hr_api.g_varchar2) then
337: p_rec.ple_information6 :=
338: ota_ple_shd.g_old_rec.ple_information6;
339: End If;
340: If (p_rec.ple_information7 = hr_api.g_varchar2) then
341: p_rec.ple_information7 :=
342: ota_ple_shd.g_old_rec.ple_information7;
343: End If;
344: If (p_rec.ple_information8 = hr_api.g_varchar2) then
340: If (p_rec.ple_information7 = hr_api.g_varchar2) then
341: p_rec.ple_information7 :=
342: ota_ple_shd.g_old_rec.ple_information7;
343: End If;
344: If (p_rec.ple_information8 = hr_api.g_varchar2) then
345: p_rec.ple_information8 :=
346: ota_ple_shd.g_old_rec.ple_information8;
347: End If;
348: If (p_rec.ple_information9 = hr_api.g_varchar2) then
344: If (p_rec.ple_information8 = hr_api.g_varchar2) then
345: p_rec.ple_information8 :=
346: ota_ple_shd.g_old_rec.ple_information8;
347: End If;
348: If (p_rec.ple_information9 = hr_api.g_varchar2) then
349: p_rec.ple_information9 :=
350: ota_ple_shd.g_old_rec.ple_information9;
351: End If;
352: If (p_rec.ple_information10 = hr_api.g_varchar2) then
348: If (p_rec.ple_information9 = hr_api.g_varchar2) then
349: p_rec.ple_information9 :=
350: ota_ple_shd.g_old_rec.ple_information9;
351: End If;
352: If (p_rec.ple_information10 = hr_api.g_varchar2) then
353: p_rec.ple_information10 :=
354: ota_ple_shd.g_old_rec.ple_information10;
355: End If;
356: If (p_rec.ple_information11 = hr_api.g_varchar2) then
352: If (p_rec.ple_information10 = hr_api.g_varchar2) then
353: p_rec.ple_information10 :=
354: ota_ple_shd.g_old_rec.ple_information10;
355: End If;
356: If (p_rec.ple_information11 = hr_api.g_varchar2) then
357: p_rec.ple_information11 :=
358: ota_ple_shd.g_old_rec.ple_information11;
359: End If;
360: If (p_rec.ple_information12 = hr_api.g_varchar2) then
356: If (p_rec.ple_information11 = hr_api.g_varchar2) then
357: p_rec.ple_information11 :=
358: ota_ple_shd.g_old_rec.ple_information11;
359: End If;
360: If (p_rec.ple_information12 = hr_api.g_varchar2) then
361: p_rec.ple_information12 :=
362: ota_ple_shd.g_old_rec.ple_information12;
363: End If;
364: If (p_rec.ple_information13 = hr_api.g_varchar2) then
360: If (p_rec.ple_information12 = hr_api.g_varchar2) then
361: p_rec.ple_information12 :=
362: ota_ple_shd.g_old_rec.ple_information12;
363: End If;
364: If (p_rec.ple_information13 = hr_api.g_varchar2) then
365: p_rec.ple_information13 :=
366: ota_ple_shd.g_old_rec.ple_information13;
367: End If;
368: If (p_rec.ple_information14 = hr_api.g_varchar2) then
364: If (p_rec.ple_information13 = hr_api.g_varchar2) then
365: p_rec.ple_information13 :=
366: ota_ple_shd.g_old_rec.ple_information13;
367: End If;
368: If (p_rec.ple_information14 = hr_api.g_varchar2) then
369: p_rec.ple_information14 :=
370: ota_ple_shd.g_old_rec.ple_information14;
371: End If;
372: If (p_rec.ple_information15 = hr_api.g_varchar2) then
368: If (p_rec.ple_information14 = hr_api.g_varchar2) then
369: p_rec.ple_information14 :=
370: ota_ple_shd.g_old_rec.ple_information14;
371: End If;
372: If (p_rec.ple_information15 = hr_api.g_varchar2) then
373: p_rec.ple_information15 :=
374: ota_ple_shd.g_old_rec.ple_information15;
375: End If;
376: If (p_rec.ple_information16 = hr_api.g_varchar2) then
372: If (p_rec.ple_information15 = hr_api.g_varchar2) then
373: p_rec.ple_information15 :=
374: ota_ple_shd.g_old_rec.ple_information15;
375: End If;
376: If (p_rec.ple_information16 = hr_api.g_varchar2) then
377: p_rec.ple_information16 :=
378: ota_ple_shd.g_old_rec.ple_information16;
379: End If;
380: If (p_rec.ple_information17 = hr_api.g_varchar2) then
376: If (p_rec.ple_information16 = hr_api.g_varchar2) then
377: p_rec.ple_information16 :=
378: ota_ple_shd.g_old_rec.ple_information16;
379: End If;
380: If (p_rec.ple_information17 = hr_api.g_varchar2) then
381: p_rec.ple_information17 :=
382: ota_ple_shd.g_old_rec.ple_information17;
383: End If;
384: If (p_rec.ple_information18 = hr_api.g_varchar2) then
380: If (p_rec.ple_information17 = hr_api.g_varchar2) then
381: p_rec.ple_information17 :=
382: ota_ple_shd.g_old_rec.ple_information17;
383: End If;
384: If (p_rec.ple_information18 = hr_api.g_varchar2) then
385: p_rec.ple_information18 :=
386: ota_ple_shd.g_old_rec.ple_information18;
387: End If;
388: If (p_rec.ple_information19 = hr_api.g_varchar2) then
384: If (p_rec.ple_information18 = hr_api.g_varchar2) then
385: p_rec.ple_information18 :=
386: ota_ple_shd.g_old_rec.ple_information18;
387: End If;
388: If (p_rec.ple_information19 = hr_api.g_varchar2) then
389: p_rec.ple_information19 :=
390: ota_ple_shd.g_old_rec.ple_information19;
391: End If;
392: If (p_rec.ple_information20 = hr_api.g_varchar2) then
388: If (p_rec.ple_information19 = hr_api.g_varchar2) then
389: p_rec.ple_information19 :=
390: ota_ple_shd.g_old_rec.ple_information19;
391: End If;
392: If (p_rec.ple_information20 = hr_api.g_varchar2) then
393: p_rec.ple_information20 :=
394: ota_ple_shd.g_old_rec.ple_information20;
395: End If;
396: --
454: --
455: -- If we are validating then raise the Validate_Enabled exception
456: --
457: If p_validate then
458: Raise HR_Api.Validate_Enabled;
459: End If;
460: --
461: hr_utility.set_location(' Leaving:'||l_proc, 10);
462: Exception
459: End If;
460: --
461: hr_utility.set_location(' Leaving:'||l_proc, 10);
462: Exception
463: When HR_Api.Validate_Enabled Then
464: --
465: -- As the Validate_Enabled exception has been raised
466: -- we must rollback to the savepoint
467: --
473: -- ----------------------------------------------------------------------------
474: Procedure upd
475: (
476: p_price_list_entry_id in number,
477: p_vendor_supply_id in number default hr_api.g_number,
478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
474: Procedure upd
475: (
476: p_price_list_entry_id in number,
477: p_vendor_supply_id in number default hr_api.g_number,
478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
475: (
476: p_price_list_entry_id in number,
477: p_vendor_supply_id in number default hr_api.g_number,
478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
477: p_vendor_supply_id in number default hr_api.g_number,
478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,
509: p_validate in boolean default false
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,
509: p_validate in boolean default false
510: ) is
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,
509: p_validate in boolean default false
510: ) is
511: --
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,
509: p_validate in boolean default false
510: ) is
511: --
512: l_rec ota_ple_shd.g_rec_type;