93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: per_sha_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: per_sha_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: per_sha_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_sha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_sha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_sha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: Raise;
111: End update_dml;
112: --
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception
257: when hr_api.cannot_find_prog_unit then
258: hr_api.cannot_find_prog_unit_error
259: (p_module_name => 'PER_STD_HOLIDAY_ABSENCES'
260: ,p_hook_type => 'AU'
261: );
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception
257: when hr_api.cannot_find_prog_unit then
258: hr_api.cannot_find_prog_unit_error
259: (p_module_name => 'PER_STD_HOLIDAY_ABSENCES'
260: ,p_hook_type => 'AU'
261: );
262: end;
320: -- p_rec plsql record structure
321: -- to see if a system default is being used. If a system default
322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.date_not_taken = hr_api.g_date) then
325: p_rec.date_not_taken :=
326: per_sha_shd.g_old_rec.date_not_taken;
327: End If;
328: If (p_rec.person_id = hr_api.g_number) then
324: If (p_rec.date_not_taken = hr_api.g_date) then
325: p_rec.date_not_taken :=
326: per_sha_shd.g_old_rec.date_not_taken;
327: End If;
328: If (p_rec.person_id = hr_api.g_number) then
329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
328: If (p_rec.person_id = hr_api.g_number) then
329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=
338: per_sha_shd.g_old_rec.actual_date_taken;
339: End If;
340: If (p_rec.reason = hr_api.g_varchar2) then
336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=
338: per_sha_shd.g_old_rec.actual_date_taken;
339: End If;
340: If (p_rec.reason = hr_api.g_varchar2) then
341: p_rec.reason :=
342: per_sha_shd.g_old_rec.reason;
343: End If;
344: If (p_rec.expired = hr_api.g_varchar2) then
340: If (p_rec.reason = hr_api.g_varchar2) then
341: p_rec.reason :=
342: per_sha_shd.g_old_rec.reason;
343: End If;
344: If (p_rec.expired = hr_api.g_varchar2) then
345: p_rec.expired :=
346: per_sha_shd.g_old_rec.expired;
347: End If;
348: If (p_rec.attribute_category = hr_api.g_varchar2) then
344: If (p_rec.expired = hr_api.g_varchar2) then
345: p_rec.expired :=
346: per_sha_shd.g_old_rec.expired;
347: End If;
348: If (p_rec.attribute_category = hr_api.g_varchar2) then
349: p_rec.attribute_category :=
350: per_sha_shd.g_old_rec.attribute_category;
351: End If;
352: If (p_rec.attribute1 = hr_api.g_varchar2) then
348: If (p_rec.attribute_category = hr_api.g_varchar2) then
349: p_rec.attribute_category :=
350: per_sha_shd.g_old_rec.attribute_category;
351: End If;
352: If (p_rec.attribute1 = hr_api.g_varchar2) then
353: p_rec.attribute1 :=
354: per_sha_shd.g_old_rec.attribute1;
355: End If;
356: If (p_rec.attribute2 = hr_api.g_varchar2) then
352: If (p_rec.attribute1 = hr_api.g_varchar2) then
353: p_rec.attribute1 :=
354: per_sha_shd.g_old_rec.attribute1;
355: End If;
356: If (p_rec.attribute2 = hr_api.g_varchar2) then
357: p_rec.attribute2 :=
358: per_sha_shd.g_old_rec.attribute2;
359: End If;
360: If (p_rec.attribute3 = hr_api.g_varchar2) then
356: If (p_rec.attribute2 = hr_api.g_varchar2) then
357: p_rec.attribute2 :=
358: per_sha_shd.g_old_rec.attribute2;
359: End If;
360: If (p_rec.attribute3 = hr_api.g_varchar2) then
361: p_rec.attribute3 :=
362: per_sha_shd.g_old_rec.attribute3;
363: End If;
364: If (p_rec.attribute4 = hr_api.g_varchar2) then
360: If (p_rec.attribute3 = hr_api.g_varchar2) then
361: p_rec.attribute3 :=
362: per_sha_shd.g_old_rec.attribute3;
363: End If;
364: If (p_rec.attribute4 = hr_api.g_varchar2) then
365: p_rec.attribute4 :=
366: per_sha_shd.g_old_rec.attribute4;
367: End If;
368: If (p_rec.attribute5 = hr_api.g_varchar2) then
364: If (p_rec.attribute4 = hr_api.g_varchar2) then
365: p_rec.attribute4 :=
366: per_sha_shd.g_old_rec.attribute4;
367: End If;
368: If (p_rec.attribute5 = hr_api.g_varchar2) then
369: p_rec.attribute5 :=
370: per_sha_shd.g_old_rec.attribute5;
371: End If;
372: If (p_rec.attribute6 = hr_api.g_varchar2) then
368: If (p_rec.attribute5 = hr_api.g_varchar2) then
369: p_rec.attribute5 :=
370: per_sha_shd.g_old_rec.attribute5;
371: End If;
372: If (p_rec.attribute6 = hr_api.g_varchar2) then
373: p_rec.attribute6 :=
374: per_sha_shd.g_old_rec.attribute6;
375: End If;
376: If (p_rec.attribute7 = hr_api.g_varchar2) then
372: If (p_rec.attribute6 = hr_api.g_varchar2) then
373: p_rec.attribute6 :=
374: per_sha_shd.g_old_rec.attribute6;
375: End If;
376: If (p_rec.attribute7 = hr_api.g_varchar2) then
377: p_rec.attribute7 :=
378: per_sha_shd.g_old_rec.attribute7;
379: End If;
380: If (p_rec.attribute8 = hr_api.g_varchar2) then
376: If (p_rec.attribute7 = hr_api.g_varchar2) then
377: p_rec.attribute7 :=
378: per_sha_shd.g_old_rec.attribute7;
379: End If;
380: If (p_rec.attribute8 = hr_api.g_varchar2) then
381: p_rec.attribute8 :=
382: per_sha_shd.g_old_rec.attribute8;
383: End If;
384: If (p_rec.attribute9 = hr_api.g_varchar2) then
380: If (p_rec.attribute8 = hr_api.g_varchar2) then
381: p_rec.attribute8 :=
382: per_sha_shd.g_old_rec.attribute8;
383: End If;
384: If (p_rec.attribute9 = hr_api.g_varchar2) then
385: p_rec.attribute9 :=
386: per_sha_shd.g_old_rec.attribute9;
387: End If;
388: If (p_rec.attribute10 = hr_api.g_varchar2) then
384: If (p_rec.attribute9 = hr_api.g_varchar2) then
385: p_rec.attribute9 :=
386: per_sha_shd.g_old_rec.attribute9;
387: End If;
388: If (p_rec.attribute10 = hr_api.g_varchar2) then
389: p_rec.attribute10 :=
390: per_sha_shd.g_old_rec.attribute10;
391: End If;
392: If (p_rec.attribute11 = hr_api.g_varchar2) then
388: If (p_rec.attribute10 = hr_api.g_varchar2) then
389: p_rec.attribute10 :=
390: per_sha_shd.g_old_rec.attribute10;
391: End If;
392: If (p_rec.attribute11 = hr_api.g_varchar2) then
393: p_rec.attribute11 :=
394: per_sha_shd.g_old_rec.attribute11;
395: End If;
396: If (p_rec.attribute12 = hr_api.g_varchar2) then
392: If (p_rec.attribute11 = hr_api.g_varchar2) then
393: p_rec.attribute11 :=
394: per_sha_shd.g_old_rec.attribute11;
395: End If;
396: If (p_rec.attribute12 = hr_api.g_varchar2) then
397: p_rec.attribute12 :=
398: per_sha_shd.g_old_rec.attribute12;
399: End If;
400: If (p_rec.attribute13 = hr_api.g_varchar2) then
396: If (p_rec.attribute12 = hr_api.g_varchar2) then
397: p_rec.attribute12 :=
398: per_sha_shd.g_old_rec.attribute12;
399: End If;
400: If (p_rec.attribute13 = hr_api.g_varchar2) then
401: p_rec.attribute13 :=
402: per_sha_shd.g_old_rec.attribute13;
403: End If;
404: If (p_rec.attribute14 = hr_api.g_varchar2) then
400: If (p_rec.attribute13 = hr_api.g_varchar2) then
401: p_rec.attribute13 :=
402: per_sha_shd.g_old_rec.attribute13;
403: End If;
404: If (p_rec.attribute14 = hr_api.g_varchar2) then
405: p_rec.attribute14 :=
406: per_sha_shd.g_old_rec.attribute14;
407: End If;
408: If (p_rec.attribute15 = hr_api.g_varchar2) then
404: If (p_rec.attribute14 = hr_api.g_varchar2) then
405: p_rec.attribute14 :=
406: per_sha_shd.g_old_rec.attribute14;
407: End If;
408: If (p_rec.attribute15 = hr_api.g_varchar2) then
409: p_rec.attribute15 :=
410: per_sha_shd.g_old_rec.attribute15;
411: End If;
412: If (p_rec.attribute16 = hr_api.g_varchar2) then
408: If (p_rec.attribute15 = hr_api.g_varchar2) then
409: p_rec.attribute15 :=
410: per_sha_shd.g_old_rec.attribute15;
411: End If;
412: If (p_rec.attribute16 = hr_api.g_varchar2) then
413: p_rec.attribute16 :=
414: per_sha_shd.g_old_rec.attribute16;
415: End If;
416: If (p_rec.attribute17 = hr_api.g_varchar2) then
412: If (p_rec.attribute16 = hr_api.g_varchar2) then
413: p_rec.attribute16 :=
414: per_sha_shd.g_old_rec.attribute16;
415: End If;
416: If (p_rec.attribute17 = hr_api.g_varchar2) then
417: p_rec.attribute17 :=
418: per_sha_shd.g_old_rec.attribute17;
419: End If;
420: If (p_rec.attribute18 = hr_api.g_varchar2) then
416: If (p_rec.attribute17 = hr_api.g_varchar2) then
417: p_rec.attribute17 :=
418: per_sha_shd.g_old_rec.attribute17;
419: End If;
420: If (p_rec.attribute18 = hr_api.g_varchar2) then
421: p_rec.attribute18 :=
422: per_sha_shd.g_old_rec.attribute18;
423: End If;
424: If (p_rec.attribute19 = hr_api.g_varchar2) then
420: If (p_rec.attribute18 = hr_api.g_varchar2) then
421: p_rec.attribute18 :=
422: per_sha_shd.g_old_rec.attribute18;
423: End If;
424: If (p_rec.attribute19 = hr_api.g_varchar2) then
425: p_rec.attribute19 :=
426: per_sha_shd.g_old_rec.attribute19;
427: End If;
428: If (p_rec.attribute20 = hr_api.g_varchar2) then
424: If (p_rec.attribute19 = hr_api.g_varchar2) then
425: p_rec.attribute19 :=
426: per_sha_shd.g_old_rec.attribute19;
427: End If;
428: If (p_rec.attribute20 = hr_api.g_varchar2) then
429: p_rec.attribute20 :=
430: per_sha_shd.g_old_rec.attribute20;
431: End If;
432:
483: -- ----------------------------------------------------------------------------
484: Procedure upd
485: (
486: p_std_holiday_absences_id in number,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
484: Procedure upd
485: (
486: p_std_holiday_absences_id in number,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
485: (
486: p_std_holiday_absences_id in number,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
486: p_std_holiday_absences_id in number,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
487: p_date_not_taken in date default hr_api.g_date,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
488: p_person_id in number default hr_api.g_number,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
489: p_standard_holiday_id in number default hr_api.g_number,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
490: p_actual_date_taken in date default hr_api.g_date,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
491: p_reason in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
492: p_expired in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
493: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
494: p_attribute1 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
495: p_attribute2 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
496: p_attribute3 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
497: p_attribute4 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
498: p_attribute5 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
499: p_attribute6 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
500: p_attribute7 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
501: p_attribute8 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
502: p_attribute9 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
503: p_attribute10 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
504: p_attribute11 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
505: p_attribute12 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
506: p_attribute13 in varchar2 default hr_api.g_varchar2,
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number
507: p_attribute14 in varchar2 default hr_api.g_varchar2,
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number
515: ) is
508: p_attribute15 in varchar2 default hr_api.g_varchar2,
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number
515: ) is
516: --
509: p_attribute16 in varchar2 default hr_api.g_varchar2,
510: p_attribute17 in varchar2 default hr_api.g_varchar2,
511: p_attribute18 in varchar2 default hr_api.g_varchar2,
512: p_attribute19 in varchar2 default hr_api.g_varchar2,
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number
515: ) is
516: --
517: l_rec per_sha_shd.g_rec_type;