102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
109: ota_anc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
109: ota_anc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
114: ota_anc_shd.constraint_error
107: -- A check constraint has been violated
108: --
109: ota_anc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
114: ota_anc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
114: ota_anc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: ota_anc_shd.constraint_error
112: -- Parent integrity has been violated
113: --
114: ota_anc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: ota_anc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: ota_anc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;
124: End update_dml;
321: );
322: --
323: exception
324: --
325: when hr_api.cannot_find_prog_unit then
326: --
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'OTA_ANNOUNCEMENTS'
329: ,p_hook_type => 'AU');
323: exception
324: --
325: when hr_api.cannot_find_prog_unit then
326: --
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'OTA_ANNOUNCEMENTS'
329: ,p_hook_type => 'AU');
330: --
331: end;
386: -- p_rec plsql record structure
387: -- to see if a system default is being used. If a system default
388: -- is being used then we must set to the 'current' argument value.
389: --
390: If (p_rec.business_group_id = hr_api.g_number) then
391: p_rec.business_group_id :=
392: ota_anc_shd.g_old_rec.business_group_id;
393: End If;
394: If (p_rec.start_date_active = hr_api.g_date) then
390: If (p_rec.business_group_id = hr_api.g_number) then
391: p_rec.business_group_id :=
392: ota_anc_shd.g_old_rec.business_group_id;
393: End If;
394: If (p_rec.start_date_active = hr_api.g_date) then
395: p_rec.start_date_active :=
396: ota_anc_shd.g_old_rec.start_date_active;
397: End If;
398: If (p_rec.end_date_active = hr_api.g_date) then
394: If (p_rec.start_date_active = hr_api.g_date) then
395: p_rec.start_date_active :=
396: ota_anc_shd.g_old_rec.start_date_active;
397: End If;
398: If (p_rec.end_date_active = hr_api.g_date) then
399: p_rec.end_date_active :=
400: ota_anc_shd.g_old_rec.end_date_active;
401: End If;
402: If (p_rec.owner_id = hr_api.g_number) then
398: If (p_rec.end_date_active = hr_api.g_date) then
399: p_rec.end_date_active :=
400: ota_anc_shd.g_old_rec.end_date_active;
401: End If;
402: If (p_rec.owner_id = hr_api.g_number) then
403: p_rec.owner_id :=
404: ota_anc_shd.g_old_rec.owner_id;
405: End If;
406: If (p_rec.attribute_category = hr_api.g_varchar2) then
402: If (p_rec.owner_id = hr_api.g_number) then
403: p_rec.owner_id :=
404: ota_anc_shd.g_old_rec.owner_id;
405: End If;
406: If (p_rec.attribute_category = hr_api.g_varchar2) then
407: p_rec.attribute_category :=
408: ota_anc_shd.g_old_rec.attribute_category;
409: End If;
410: If (p_rec.attribute1 = hr_api.g_varchar2) then
406: If (p_rec.attribute_category = hr_api.g_varchar2) then
407: p_rec.attribute_category :=
408: ota_anc_shd.g_old_rec.attribute_category;
409: End If;
410: If (p_rec.attribute1 = hr_api.g_varchar2) then
411: p_rec.attribute1 :=
412: ota_anc_shd.g_old_rec.attribute1;
413: End If;
414: If (p_rec.attribute2 = hr_api.g_varchar2) then
410: If (p_rec.attribute1 = hr_api.g_varchar2) then
411: p_rec.attribute1 :=
412: ota_anc_shd.g_old_rec.attribute1;
413: End If;
414: If (p_rec.attribute2 = hr_api.g_varchar2) then
415: p_rec.attribute2 :=
416: ota_anc_shd.g_old_rec.attribute2;
417: End If;
418: If (p_rec.attribute3 = hr_api.g_varchar2) then
414: If (p_rec.attribute2 = hr_api.g_varchar2) then
415: p_rec.attribute2 :=
416: ota_anc_shd.g_old_rec.attribute2;
417: End If;
418: If (p_rec.attribute3 = hr_api.g_varchar2) then
419: p_rec.attribute3 :=
420: ota_anc_shd.g_old_rec.attribute3;
421: End If;
422: If (p_rec.attribute4 = hr_api.g_varchar2) then
418: If (p_rec.attribute3 = hr_api.g_varchar2) then
419: p_rec.attribute3 :=
420: ota_anc_shd.g_old_rec.attribute3;
421: End If;
422: If (p_rec.attribute4 = hr_api.g_varchar2) then
423: p_rec.attribute4 :=
424: ota_anc_shd.g_old_rec.attribute4;
425: End If;
426: If (p_rec.attribute5 = hr_api.g_varchar2) then
422: If (p_rec.attribute4 = hr_api.g_varchar2) then
423: p_rec.attribute4 :=
424: ota_anc_shd.g_old_rec.attribute4;
425: End If;
426: If (p_rec.attribute5 = hr_api.g_varchar2) then
427: p_rec.attribute5 :=
428: ota_anc_shd.g_old_rec.attribute5;
429: End If;
430: If (p_rec.attribute6 = hr_api.g_varchar2) then
426: If (p_rec.attribute5 = hr_api.g_varchar2) then
427: p_rec.attribute5 :=
428: ota_anc_shd.g_old_rec.attribute5;
429: End If;
430: If (p_rec.attribute6 = hr_api.g_varchar2) then
431: p_rec.attribute6 :=
432: ota_anc_shd.g_old_rec.attribute6;
433: End If;
434: If (p_rec.attribute7 = hr_api.g_varchar2) then
430: If (p_rec.attribute6 = hr_api.g_varchar2) then
431: p_rec.attribute6 :=
432: ota_anc_shd.g_old_rec.attribute6;
433: End If;
434: If (p_rec.attribute7 = hr_api.g_varchar2) then
435: p_rec.attribute7 :=
436: ota_anc_shd.g_old_rec.attribute7;
437: End If;
438: If (p_rec.attribute8 = hr_api.g_varchar2) then
434: If (p_rec.attribute7 = hr_api.g_varchar2) then
435: p_rec.attribute7 :=
436: ota_anc_shd.g_old_rec.attribute7;
437: End If;
438: If (p_rec.attribute8 = hr_api.g_varchar2) then
439: p_rec.attribute8 :=
440: ota_anc_shd.g_old_rec.attribute8;
441: End If;
442: If (p_rec.attribute9 = hr_api.g_varchar2) then
438: If (p_rec.attribute8 = hr_api.g_varchar2) then
439: p_rec.attribute8 :=
440: ota_anc_shd.g_old_rec.attribute8;
441: End If;
442: If (p_rec.attribute9 = hr_api.g_varchar2) then
443: p_rec.attribute9 :=
444: ota_anc_shd.g_old_rec.attribute9;
445: End If;
446: If (p_rec.attribute10 = hr_api.g_varchar2) then
442: If (p_rec.attribute9 = hr_api.g_varchar2) then
443: p_rec.attribute9 :=
444: ota_anc_shd.g_old_rec.attribute9;
445: End If;
446: If (p_rec.attribute10 = hr_api.g_varchar2) then
447: p_rec.attribute10 :=
448: ota_anc_shd.g_old_rec.attribute10;
449: End If;
450: If (p_rec.attribute11 = hr_api.g_varchar2) then
446: If (p_rec.attribute10 = hr_api.g_varchar2) then
447: p_rec.attribute10 :=
448: ota_anc_shd.g_old_rec.attribute10;
449: End If;
450: If (p_rec.attribute11 = hr_api.g_varchar2) then
451: p_rec.attribute11 :=
452: ota_anc_shd.g_old_rec.attribute11;
453: End If;
454: If (p_rec.attribute12 = hr_api.g_varchar2) then
450: If (p_rec.attribute11 = hr_api.g_varchar2) then
451: p_rec.attribute11 :=
452: ota_anc_shd.g_old_rec.attribute11;
453: End If;
454: If (p_rec.attribute12 = hr_api.g_varchar2) then
455: p_rec.attribute12 :=
456: ota_anc_shd.g_old_rec.attribute12;
457: End If;
458: If (p_rec.attribute13 = hr_api.g_varchar2) then
454: If (p_rec.attribute12 = hr_api.g_varchar2) then
455: p_rec.attribute12 :=
456: ota_anc_shd.g_old_rec.attribute12;
457: End If;
458: If (p_rec.attribute13 = hr_api.g_varchar2) then
459: p_rec.attribute13 :=
460: ota_anc_shd.g_old_rec.attribute13;
461: End If;
462: If (p_rec.attribute14 = hr_api.g_varchar2) then
458: If (p_rec.attribute13 = hr_api.g_varchar2) then
459: p_rec.attribute13 :=
460: ota_anc_shd.g_old_rec.attribute13;
461: End If;
462: If (p_rec.attribute14 = hr_api.g_varchar2) then
463: p_rec.attribute14 :=
464: ota_anc_shd.g_old_rec.attribute14;
465: End If;
466: If (p_rec.attribute15 = hr_api.g_varchar2) then
462: If (p_rec.attribute14 = hr_api.g_varchar2) then
463: p_rec.attribute14 :=
464: ota_anc_shd.g_old_rec.attribute14;
465: End If;
466: If (p_rec.attribute15 = hr_api.g_varchar2) then
467: p_rec.attribute15 :=
468: ota_anc_shd.g_old_rec.attribute15;
469: End If;
470: If (p_rec.attribute16 = hr_api.g_varchar2) then
466: If (p_rec.attribute15 = hr_api.g_varchar2) then
467: p_rec.attribute15 :=
468: ota_anc_shd.g_old_rec.attribute15;
469: End If;
470: If (p_rec.attribute16 = hr_api.g_varchar2) then
471: p_rec.attribute16 :=
472: ota_anc_shd.g_old_rec.attribute16;
473: End If;
474: If (p_rec.attribute17 = hr_api.g_varchar2) then
470: If (p_rec.attribute16 = hr_api.g_varchar2) then
471: p_rec.attribute16 :=
472: ota_anc_shd.g_old_rec.attribute16;
473: End If;
474: If (p_rec.attribute17 = hr_api.g_varchar2) then
475: p_rec.attribute17 :=
476: ota_anc_shd.g_old_rec.attribute17;
477: End If;
478: If (p_rec.attribute18 = hr_api.g_varchar2) then
474: If (p_rec.attribute17 = hr_api.g_varchar2) then
475: p_rec.attribute17 :=
476: ota_anc_shd.g_old_rec.attribute17;
477: End If;
478: If (p_rec.attribute18 = hr_api.g_varchar2) then
479: p_rec.attribute18 :=
480: ota_anc_shd.g_old_rec.attribute18;
481: End If;
482: If (p_rec.attribute19 = hr_api.g_varchar2) then
478: If (p_rec.attribute18 = hr_api.g_varchar2) then
479: p_rec.attribute18 :=
480: ota_anc_shd.g_old_rec.attribute18;
481: End If;
482: If (p_rec.attribute19 = hr_api.g_varchar2) then
483: p_rec.attribute19 :=
484: ota_anc_shd.g_old_rec.attribute19;
485: End If;
486: If (p_rec.attribute20 = hr_api.g_varchar2) then
482: If (p_rec.attribute19 = hr_api.g_varchar2) then
483: p_rec.attribute19 :=
484: ota_anc_shd.g_old_rec.attribute19;
485: End If;
486: If (p_rec.attribute20 = hr_api.g_varchar2) then
487: p_rec.attribute20 :=
488: ota_anc_shd.g_old_rec.attribute20;
489: End If;
490: --
550: Procedure upd
551: (p_effective_date in date
552: ,p_announcement_id in number
553: ,p_object_version_number in out nocopy number
554: ,p_business_group_id in number default hr_api.g_number
555: ,p_start_date_active in date default hr_api.g_date
556: ,p_end_date_active in date default hr_api.g_date
557: ,p_owner_id in number default hr_api.g_number
558: ,p_attribute_category in varchar2 default hr_api.g_varchar2
551: (p_effective_date in date
552: ,p_announcement_id in number
553: ,p_object_version_number in out nocopy number
554: ,p_business_group_id in number default hr_api.g_number
555: ,p_start_date_active in date default hr_api.g_date
556: ,p_end_date_active in date default hr_api.g_date
557: ,p_owner_id in number default hr_api.g_number
558: ,p_attribute_category in varchar2 default hr_api.g_varchar2
559: ,p_attribute1 in varchar2 default hr_api.g_varchar2
552: ,p_announcement_id in number
553: ,p_object_version_number in out nocopy number
554: ,p_business_group_id in number default hr_api.g_number
555: ,p_start_date_active in date default hr_api.g_date
556: ,p_end_date_active in date default hr_api.g_date
557: ,p_owner_id in number default hr_api.g_number
558: ,p_attribute_category in varchar2 default hr_api.g_varchar2
559: ,p_attribute1 in varchar2 default hr_api.g_varchar2
560: ,p_attribute2 in varchar2 default hr_api.g_varchar2
553: ,p_object_version_number in out nocopy number
554: ,p_business_group_id in number default hr_api.g_number
555: ,p_start_date_active in date default hr_api.g_date
556: ,p_end_date_active in date default hr_api.g_date
557: ,p_owner_id in number default hr_api.g_number
558: ,p_attribute_category in varchar2 default hr_api.g_varchar2
559: ,p_attribute1 in varchar2 default hr_api.g_varchar2
560: ,p_attribute2 in varchar2 default hr_api.g_varchar2
561: ,p_attribute3 in varchar2 default hr_api.g_varchar2
554: ,p_business_group_id in number default hr_api.g_number
555: ,p_start_date_active in date default hr_api.g_date
556: ,p_end_date_active in date default hr_api.g_date
557: ,p_owner_id in number default hr_api.g_number
558: ,p_attribute_category in varchar2 default hr_api.g_varchar2
559: ,p_attribute1 in varchar2 default hr_api.g_varchar2
560: ,p_attribute2 in varchar2 default hr_api.g_varchar2
561: ,p_attribute3 in varchar2 default hr_api.g_varchar2
562: ,p_attribute4 in varchar2 default hr_api.g_varchar2
555: ,p_start_date_active in date default hr_api.g_date
556: ,p_end_date_active in date default hr_api.g_date
557: ,p_owner_id in number default hr_api.g_number
558: ,p_attribute_category in varchar2 default hr_api.g_varchar2
559: ,p_attribute1 in varchar2 default hr_api.g_varchar2
560: ,p_attribute2 in varchar2 default hr_api.g_varchar2
561: ,p_attribute3 in varchar2 default hr_api.g_varchar2
562: ,p_attribute4 in varchar2 default hr_api.g_varchar2
563: ,p_attribute5 in varchar2 default hr_api.g_varchar2
556: ,p_end_date_active in date default hr_api.g_date
557: ,p_owner_id in number default hr_api.g_number
558: ,p_attribute_category in varchar2 default hr_api.g_varchar2
559: ,p_attribute1 in varchar2 default hr_api.g_varchar2
560: ,p_attribute2 in varchar2 default hr_api.g_varchar2
561: ,p_attribute3 in varchar2 default hr_api.g_varchar2
562: ,p_attribute4 in varchar2 default hr_api.g_varchar2
563: ,p_attribute5 in varchar2 default hr_api.g_varchar2
564: ,p_attribute6 in varchar2 default hr_api.g_varchar2
557: ,p_owner_id in number default hr_api.g_number
558: ,p_attribute_category in varchar2 default hr_api.g_varchar2
559: ,p_attribute1 in varchar2 default hr_api.g_varchar2
560: ,p_attribute2 in varchar2 default hr_api.g_varchar2
561: ,p_attribute3 in varchar2 default hr_api.g_varchar2
562: ,p_attribute4 in varchar2 default hr_api.g_varchar2
563: ,p_attribute5 in varchar2 default hr_api.g_varchar2
564: ,p_attribute6 in varchar2 default hr_api.g_varchar2
565: ,p_attribute7 in varchar2 default hr_api.g_varchar2
558: ,p_attribute_category in varchar2 default hr_api.g_varchar2
559: ,p_attribute1 in varchar2 default hr_api.g_varchar2
560: ,p_attribute2 in varchar2 default hr_api.g_varchar2
561: ,p_attribute3 in varchar2 default hr_api.g_varchar2
562: ,p_attribute4 in varchar2 default hr_api.g_varchar2
563: ,p_attribute5 in varchar2 default hr_api.g_varchar2
564: ,p_attribute6 in varchar2 default hr_api.g_varchar2
565: ,p_attribute7 in varchar2 default hr_api.g_varchar2
566: ,p_attribute8 in varchar2 default hr_api.g_varchar2
559: ,p_attribute1 in varchar2 default hr_api.g_varchar2
560: ,p_attribute2 in varchar2 default hr_api.g_varchar2
561: ,p_attribute3 in varchar2 default hr_api.g_varchar2
562: ,p_attribute4 in varchar2 default hr_api.g_varchar2
563: ,p_attribute5 in varchar2 default hr_api.g_varchar2
564: ,p_attribute6 in varchar2 default hr_api.g_varchar2
565: ,p_attribute7 in varchar2 default hr_api.g_varchar2
566: ,p_attribute8 in varchar2 default hr_api.g_varchar2
567: ,p_attribute9 in varchar2 default hr_api.g_varchar2
560: ,p_attribute2 in varchar2 default hr_api.g_varchar2
561: ,p_attribute3 in varchar2 default hr_api.g_varchar2
562: ,p_attribute4 in varchar2 default hr_api.g_varchar2
563: ,p_attribute5 in varchar2 default hr_api.g_varchar2
564: ,p_attribute6 in varchar2 default hr_api.g_varchar2
565: ,p_attribute7 in varchar2 default hr_api.g_varchar2
566: ,p_attribute8 in varchar2 default hr_api.g_varchar2
567: ,p_attribute9 in varchar2 default hr_api.g_varchar2
568: ,p_attribute10 in varchar2 default hr_api.g_varchar2
561: ,p_attribute3 in varchar2 default hr_api.g_varchar2
562: ,p_attribute4 in varchar2 default hr_api.g_varchar2
563: ,p_attribute5 in varchar2 default hr_api.g_varchar2
564: ,p_attribute6 in varchar2 default hr_api.g_varchar2
565: ,p_attribute7 in varchar2 default hr_api.g_varchar2
566: ,p_attribute8 in varchar2 default hr_api.g_varchar2
567: ,p_attribute9 in varchar2 default hr_api.g_varchar2
568: ,p_attribute10 in varchar2 default hr_api.g_varchar2
569: ,p_attribute11 in varchar2 default hr_api.g_varchar2
562: ,p_attribute4 in varchar2 default hr_api.g_varchar2
563: ,p_attribute5 in varchar2 default hr_api.g_varchar2
564: ,p_attribute6 in varchar2 default hr_api.g_varchar2
565: ,p_attribute7 in varchar2 default hr_api.g_varchar2
566: ,p_attribute8 in varchar2 default hr_api.g_varchar2
567: ,p_attribute9 in varchar2 default hr_api.g_varchar2
568: ,p_attribute10 in varchar2 default hr_api.g_varchar2
569: ,p_attribute11 in varchar2 default hr_api.g_varchar2
570: ,p_attribute12 in varchar2 default hr_api.g_varchar2
563: ,p_attribute5 in varchar2 default hr_api.g_varchar2
564: ,p_attribute6 in varchar2 default hr_api.g_varchar2
565: ,p_attribute7 in varchar2 default hr_api.g_varchar2
566: ,p_attribute8 in varchar2 default hr_api.g_varchar2
567: ,p_attribute9 in varchar2 default hr_api.g_varchar2
568: ,p_attribute10 in varchar2 default hr_api.g_varchar2
569: ,p_attribute11 in varchar2 default hr_api.g_varchar2
570: ,p_attribute12 in varchar2 default hr_api.g_varchar2
571: ,p_attribute13 in varchar2 default hr_api.g_varchar2
564: ,p_attribute6 in varchar2 default hr_api.g_varchar2
565: ,p_attribute7 in varchar2 default hr_api.g_varchar2
566: ,p_attribute8 in varchar2 default hr_api.g_varchar2
567: ,p_attribute9 in varchar2 default hr_api.g_varchar2
568: ,p_attribute10 in varchar2 default hr_api.g_varchar2
569: ,p_attribute11 in varchar2 default hr_api.g_varchar2
570: ,p_attribute12 in varchar2 default hr_api.g_varchar2
571: ,p_attribute13 in varchar2 default hr_api.g_varchar2
572: ,p_attribute14 in varchar2 default hr_api.g_varchar2
565: ,p_attribute7 in varchar2 default hr_api.g_varchar2
566: ,p_attribute8 in varchar2 default hr_api.g_varchar2
567: ,p_attribute9 in varchar2 default hr_api.g_varchar2
568: ,p_attribute10 in varchar2 default hr_api.g_varchar2
569: ,p_attribute11 in varchar2 default hr_api.g_varchar2
570: ,p_attribute12 in varchar2 default hr_api.g_varchar2
571: ,p_attribute13 in varchar2 default hr_api.g_varchar2
572: ,p_attribute14 in varchar2 default hr_api.g_varchar2
573: ,p_attribute15 in varchar2 default hr_api.g_varchar2
566: ,p_attribute8 in varchar2 default hr_api.g_varchar2
567: ,p_attribute9 in varchar2 default hr_api.g_varchar2
568: ,p_attribute10 in varchar2 default hr_api.g_varchar2
569: ,p_attribute11 in varchar2 default hr_api.g_varchar2
570: ,p_attribute12 in varchar2 default hr_api.g_varchar2
571: ,p_attribute13 in varchar2 default hr_api.g_varchar2
572: ,p_attribute14 in varchar2 default hr_api.g_varchar2
573: ,p_attribute15 in varchar2 default hr_api.g_varchar2
574: ,p_attribute16 in varchar2 default hr_api.g_varchar2
567: ,p_attribute9 in varchar2 default hr_api.g_varchar2
568: ,p_attribute10 in varchar2 default hr_api.g_varchar2
569: ,p_attribute11 in varchar2 default hr_api.g_varchar2
570: ,p_attribute12 in varchar2 default hr_api.g_varchar2
571: ,p_attribute13 in varchar2 default hr_api.g_varchar2
572: ,p_attribute14 in varchar2 default hr_api.g_varchar2
573: ,p_attribute15 in varchar2 default hr_api.g_varchar2
574: ,p_attribute16 in varchar2 default hr_api.g_varchar2
575: ,p_attribute17 in varchar2 default hr_api.g_varchar2
568: ,p_attribute10 in varchar2 default hr_api.g_varchar2
569: ,p_attribute11 in varchar2 default hr_api.g_varchar2
570: ,p_attribute12 in varchar2 default hr_api.g_varchar2
571: ,p_attribute13 in varchar2 default hr_api.g_varchar2
572: ,p_attribute14 in varchar2 default hr_api.g_varchar2
573: ,p_attribute15 in varchar2 default hr_api.g_varchar2
574: ,p_attribute16 in varchar2 default hr_api.g_varchar2
575: ,p_attribute17 in varchar2 default hr_api.g_varchar2
576: ,p_attribute18 in varchar2 default hr_api.g_varchar2
569: ,p_attribute11 in varchar2 default hr_api.g_varchar2
570: ,p_attribute12 in varchar2 default hr_api.g_varchar2
571: ,p_attribute13 in varchar2 default hr_api.g_varchar2
572: ,p_attribute14 in varchar2 default hr_api.g_varchar2
573: ,p_attribute15 in varchar2 default hr_api.g_varchar2
574: ,p_attribute16 in varchar2 default hr_api.g_varchar2
575: ,p_attribute17 in varchar2 default hr_api.g_varchar2
576: ,p_attribute18 in varchar2 default hr_api.g_varchar2
577: ,p_attribute19 in varchar2 default hr_api.g_varchar2
570: ,p_attribute12 in varchar2 default hr_api.g_varchar2
571: ,p_attribute13 in varchar2 default hr_api.g_varchar2
572: ,p_attribute14 in varchar2 default hr_api.g_varchar2
573: ,p_attribute15 in varchar2 default hr_api.g_varchar2
574: ,p_attribute16 in varchar2 default hr_api.g_varchar2
575: ,p_attribute17 in varchar2 default hr_api.g_varchar2
576: ,p_attribute18 in varchar2 default hr_api.g_varchar2
577: ,p_attribute19 in varchar2 default hr_api.g_varchar2
578: ,p_attribute20 in varchar2 default hr_api.g_varchar2
571: ,p_attribute13 in varchar2 default hr_api.g_varchar2
572: ,p_attribute14 in varchar2 default hr_api.g_varchar2
573: ,p_attribute15 in varchar2 default hr_api.g_varchar2
574: ,p_attribute16 in varchar2 default hr_api.g_varchar2
575: ,p_attribute17 in varchar2 default hr_api.g_varchar2
576: ,p_attribute18 in varchar2 default hr_api.g_varchar2
577: ,p_attribute19 in varchar2 default hr_api.g_varchar2
578: ,p_attribute20 in varchar2 default hr_api.g_varchar2
579: ) is
572: ,p_attribute14 in varchar2 default hr_api.g_varchar2
573: ,p_attribute15 in varchar2 default hr_api.g_varchar2
574: ,p_attribute16 in varchar2 default hr_api.g_varchar2
575: ,p_attribute17 in varchar2 default hr_api.g_varchar2
576: ,p_attribute18 in varchar2 default hr_api.g_varchar2
577: ,p_attribute19 in varchar2 default hr_api.g_varchar2
578: ,p_attribute20 in varchar2 default hr_api.g_varchar2
579: ) is
580: --
573: ,p_attribute15 in varchar2 default hr_api.g_varchar2
574: ,p_attribute16 in varchar2 default hr_api.g_varchar2
575: ,p_attribute17 in varchar2 default hr_api.g_varchar2
576: ,p_attribute18 in varchar2 default hr_api.g_varchar2
577: ,p_attribute19 in varchar2 default hr_api.g_varchar2
578: ,p_attribute20 in varchar2 default hr_api.g_varchar2
579: ) is
580: --
581: l_rec ota_anc_shd.g_rec_type;
574: ,p_attribute16 in varchar2 default hr_api.g_varchar2
575: ,p_attribute17 in varchar2 default hr_api.g_varchar2
576: ,p_attribute18 in varchar2 default hr_api.g_varchar2
577: ,p_attribute19 in varchar2 default hr_api.g_varchar2
578: ,p_attribute20 in varchar2 default hr_api.g_varchar2
579: ) is
580: --
581: l_rec ota_anc_shd.g_rec_type;
582: l_proc varchar2(72) := g_package||'upd';