112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: end if;
114:
115: exception
116: when hr_api.check_integrity_violated then
117: hxc_tat_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: when hr_api.parent_integrity_violated then
120: hxc_tat_shd.constraint_error
114:
115: exception
116: when hr_api.check_integrity_violated then
117: hxc_tat_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: when hr_api.parent_integrity_violated then
120: hxc_tat_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: when hr_api.unique_integrity_violated then
115: exception
116: when hr_api.check_integrity_violated then
117: hxc_tat_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: when hr_api.parent_integrity_violated then
120: hxc_tat_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: when hr_api.unique_integrity_violated then
123: hxc_tat_shd.constraint_error
117: hxc_tat_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: when hr_api.parent_integrity_violated then
120: hxc_tat_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: when hr_api.unique_integrity_violated then
123: hxc_tat_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: when others then
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: when hr_api.parent_integrity_violated then
120: hxc_tat_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: when hr_api.unique_integrity_violated then
123: hxc_tat_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: when others then
126: raise;
120: hxc_tat_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: when hr_api.unique_integrity_violated then
123: hxc_tat_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: when others then
126: raise;
127:
128: end update_dml;
363: );
364:
365: exception
366:
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'HXC_TIME_ATTRIBUTES'
370: ,p_hook_type => 'AU');
371: end;
364:
365: exception
366:
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'HXC_TIME_ATTRIBUTES'
370: ,p_hook_type => 'AU');
371: end;
372:
428: -- we must now examine each argument value in the p_rec plsql record
429: -- structure to see if a system default is being used. if a system
430: -- default is being used then we must set to the 'current' argument value.
431:
432: if (p_rec.attribute_category = hr_api.g_varchar2) then
433: p_rec.attribute_category :=
434: hxc_tat_shd.g_old_rec.attribute_category;
435: end if;
436:
433: p_rec.attribute_category :=
434: hxc_tat_shd.g_old_rec.attribute_category;
435: end if;
436:
437: if (p_rec.attribute1 = hr_api.g_varchar2) then
438: p_rec.attribute1 :=
439: hxc_tat_shd.g_old_rec.attribute1;
440: end if;
441:
438: p_rec.attribute1 :=
439: hxc_tat_shd.g_old_rec.attribute1;
440: end if;
441:
442: if (p_rec.attribute2 = hr_api.g_varchar2) then
443: p_rec.attribute2 :=
444: hxc_tat_shd.g_old_rec.attribute2;
445: end if;
446:
443: p_rec.attribute2 :=
444: hxc_tat_shd.g_old_rec.attribute2;
445: end if;
446:
447: if (p_rec.attribute3 = hr_api.g_varchar2) then
448: p_rec.attribute3 :=
449: hxc_tat_shd.g_old_rec.attribute3;
450: end if;
451:
448: p_rec.attribute3 :=
449: hxc_tat_shd.g_old_rec.attribute3;
450: end if;
451:
452: if (p_rec.attribute4 = hr_api.g_varchar2) then
453: p_rec.attribute4 :=
454: hxc_tat_shd.g_old_rec.attribute4;
455: end if;
456:
453: p_rec.attribute4 :=
454: hxc_tat_shd.g_old_rec.attribute4;
455: end if;
456:
457: if (p_rec.attribute5 = hr_api.g_varchar2) then
458: p_rec.attribute5 :=
459: hxc_tat_shd.g_old_rec.attribute5;
460: end if;
461:
458: p_rec.attribute5 :=
459: hxc_tat_shd.g_old_rec.attribute5;
460: end if;
461:
462: if (p_rec.attribute6 = hr_api.g_varchar2) then
463: p_rec.attribute6 :=
464: hxc_tat_shd.g_old_rec.attribute6;
465: end if;
466:
463: p_rec.attribute6 :=
464: hxc_tat_shd.g_old_rec.attribute6;
465: end if;
466:
467: if (p_rec.attribute7 = hr_api.g_varchar2) then
468: p_rec.attribute7 :=
469: hxc_tat_shd.g_old_rec.attribute7;
470: end if;
471:
468: p_rec.attribute7 :=
469: hxc_tat_shd.g_old_rec.attribute7;
470: end if;
471:
472: if (p_rec.attribute8 = hr_api.g_varchar2) then
473: p_rec.attribute8 :=
474: hxc_tat_shd.g_old_rec.attribute8;
475: end if;
476:
473: p_rec.attribute8 :=
474: hxc_tat_shd.g_old_rec.attribute8;
475: end if;
476:
477: if (p_rec.attribute9 = hr_api.g_varchar2) then
478: p_rec.attribute9 :=
479: hxc_tat_shd.g_old_rec.attribute9;
480: end if;
481:
478: p_rec.attribute9 :=
479: hxc_tat_shd.g_old_rec.attribute9;
480: end if;
481:
482: if (p_rec.attribute10 = hr_api.g_varchar2) then
483: p_rec.attribute10 :=
484: hxc_tat_shd.g_old_rec.attribute10;
485: end if;
486:
483: p_rec.attribute10 :=
484: hxc_tat_shd.g_old_rec.attribute10;
485: end if;
486:
487: if (p_rec.attribute11 = hr_api.g_varchar2) then
488: p_rec.attribute11 :=
489: hxc_tat_shd.g_old_rec.attribute11;
490: end if;
491:
488: p_rec.attribute11 :=
489: hxc_tat_shd.g_old_rec.attribute11;
490: end if;
491:
492: if (p_rec.attribute12 = hr_api.g_varchar2) then
493: p_rec.attribute12 :=
494: hxc_tat_shd.g_old_rec.attribute12;
495: end if;
496:
493: p_rec.attribute12 :=
494: hxc_tat_shd.g_old_rec.attribute12;
495: end if;
496:
497: if (p_rec.attribute13 = hr_api.g_varchar2) then
498: p_rec.attribute13 :=
499: hxc_tat_shd.g_old_rec.attribute13;
500: end if;
501:
498: p_rec.attribute13 :=
499: hxc_tat_shd.g_old_rec.attribute13;
500: end if;
501:
502: if (p_rec.attribute14 = hr_api.g_varchar2) then
503: p_rec.attribute14 :=
504: hxc_tat_shd.g_old_rec.attribute14;
505: end if;
506:
503: p_rec.attribute14 :=
504: hxc_tat_shd.g_old_rec.attribute14;
505: end if;
506:
507: if (p_rec.attribute15 = hr_api.g_varchar2) then
508: p_rec.attribute15 :=
509: hxc_tat_shd.g_old_rec.attribute15;
510: end if;
511:
508: p_rec.attribute15 :=
509: hxc_tat_shd.g_old_rec.attribute15;
510: end if;
511:
512: if (p_rec.attribute16 = hr_api.g_varchar2) then
513: p_rec.attribute16 :=
514: hxc_tat_shd.g_old_rec.attribute16;
515: end if;
516:
513: p_rec.attribute16 :=
514: hxc_tat_shd.g_old_rec.attribute16;
515: end if;
516:
517: if (p_rec.attribute17 = hr_api.g_varchar2) then
518: p_rec.attribute17 :=
519: hxc_tat_shd.g_old_rec.attribute17;
520: end if;
521:
518: p_rec.attribute17 :=
519: hxc_tat_shd.g_old_rec.attribute17;
520: end if;
521:
522: if (p_rec.attribute18 = hr_api.g_varchar2) then
523: p_rec.attribute18 :=
524: hxc_tat_shd.g_old_rec.attribute18;
525: end if;
526:
523: p_rec.attribute18 :=
524: hxc_tat_shd.g_old_rec.attribute18;
525: end if;
526:
527: if (p_rec.attribute19 = hr_api.g_varchar2) then
528: p_rec.attribute19 :=
529: hxc_tat_shd.g_old_rec.attribute19;
530: end if;
531:
528: p_rec.attribute19 :=
529: hxc_tat_shd.g_old_rec.attribute19;
530: end if;
531:
532: if (p_rec.attribute20 = hr_api.g_varchar2) then
533: p_rec.attribute20 :=
534: hxc_tat_shd.g_old_rec.attribute20;
535: end if;
536:
533: p_rec.attribute20 :=
534: hxc_tat_shd.g_old_rec.attribute20;
535: end if;
536:
537: if (p_rec.attribute21 = hr_api.g_varchar2) then
538: p_rec.attribute21 :=
539: hxc_tat_shd.g_old_rec.attribute21;
540: end if;
541:
538: p_rec.attribute21 :=
539: hxc_tat_shd.g_old_rec.attribute21;
540: end if;
541:
542: if (p_rec.attribute22 = hr_api.g_varchar2) then
543: p_rec.attribute22 :=
544: hxc_tat_shd.g_old_rec.attribute22;
545: end if;
546:
543: p_rec.attribute22 :=
544: hxc_tat_shd.g_old_rec.attribute22;
545: end if;
546:
547: if (p_rec.attribute23 = hr_api.g_varchar2) then
548: p_rec.attribute23 :=
549: hxc_tat_shd.g_old_rec.attribute23;
550: end if;
551:
548: p_rec.attribute23 :=
549: hxc_tat_shd.g_old_rec.attribute23;
550: end if;
551:
552: if (p_rec.attribute24 = hr_api.g_varchar2) then
553: p_rec.attribute24 :=
554: hxc_tat_shd.g_old_rec.attribute24;
555: end if;
556:
553: p_rec.attribute24 :=
554: hxc_tat_shd.g_old_rec.attribute24;
555: end if;
556:
557: if (p_rec.attribute25 = hr_api.g_varchar2) then
558: p_rec.attribute25 :=
559: hxc_tat_shd.g_old_rec.attribute25;
560: end if;
561:
558: p_rec.attribute25 :=
559: hxc_tat_shd.g_old_rec.attribute25;
560: end if;
561:
562: if (p_rec.attribute26 = hr_api.g_varchar2) then
563: p_rec.attribute26 :=
564: hxc_tat_shd.g_old_rec.attribute26;
565: end if;
566:
563: p_rec.attribute26 :=
564: hxc_tat_shd.g_old_rec.attribute26;
565: end if;
566:
567: if (p_rec.attribute27 = hr_api.g_varchar2) then
568: p_rec.attribute27 :=
569: hxc_tat_shd.g_old_rec.attribute27;
570: end if;
571:
568: p_rec.attribute27 :=
569: hxc_tat_shd.g_old_rec.attribute27;
570: end if;
571:
572: if (p_rec.attribute28 = hr_api.g_varchar2) then
573: p_rec.attribute28 :=
574: hxc_tat_shd.g_old_rec.attribute28;
575: end if;
576:
573: p_rec.attribute28 :=
574: hxc_tat_shd.g_old_rec.attribute28;
575: end if;
576:
577: if (p_rec.attribute29 = hr_api.g_varchar2) then
578: p_rec.attribute29 :=
579: hxc_tat_shd.g_old_rec.attribute29;
580: end if;
581:
578: p_rec.attribute29 :=
579: hxc_tat_shd.g_old_rec.attribute29;
580: end if;
581:
582: if (p_rec.attribute30 = hr_api.g_varchar2) then
583: p_rec.attribute30 :=
584: hxc_tat_shd.g_old_rec.attribute30;
585: end if;
586:
583: p_rec.attribute30 :=
584: hxc_tat_shd.g_old_rec.attribute30;
585: end if;
586:
587: if (p_rec.bld_blk_info_type_id = hr_api.g_number) then
588: p_rec.bld_blk_info_type_id :=
589: hxc_tat_shd.g_old_rec.bld_blk_info_type_id;
590: end if;
591:
588: p_rec.bld_blk_info_type_id :=
589: hxc_tat_shd.g_old_rec.bld_blk_info_type_id;
590: end if;
591:
592: if (p_rec.data_set_id = hr_api.g_number) then
593: p_rec.data_set_id :=
594: hxc_tat_shd.g_old_rec.data_set_id;
595: end if;
596:
654: procedure upd
655: (p_effective_date in date
656: ,p_time_attribute_id in number
657: ,p_object_version_number in out nocopy number
658: ,p_attribute_category in varchar2 default hr_api.g_varchar2
659: ,p_attribute1 in varchar2 default hr_api.g_varchar2
660: ,p_attribute2 in varchar2 default hr_api.g_varchar2
661: ,p_attribute3 in varchar2 default hr_api.g_varchar2
662: ,p_attribute4 in varchar2 default hr_api.g_varchar2
655: (p_effective_date in date
656: ,p_time_attribute_id in number
657: ,p_object_version_number in out nocopy number
658: ,p_attribute_category in varchar2 default hr_api.g_varchar2
659: ,p_attribute1 in varchar2 default hr_api.g_varchar2
660: ,p_attribute2 in varchar2 default hr_api.g_varchar2
661: ,p_attribute3 in varchar2 default hr_api.g_varchar2
662: ,p_attribute4 in varchar2 default hr_api.g_varchar2
663: ,p_attribute5 in varchar2 default hr_api.g_varchar2
656: ,p_time_attribute_id in number
657: ,p_object_version_number in out nocopy number
658: ,p_attribute_category in varchar2 default hr_api.g_varchar2
659: ,p_attribute1 in varchar2 default hr_api.g_varchar2
660: ,p_attribute2 in varchar2 default hr_api.g_varchar2
661: ,p_attribute3 in varchar2 default hr_api.g_varchar2
662: ,p_attribute4 in varchar2 default hr_api.g_varchar2
663: ,p_attribute5 in varchar2 default hr_api.g_varchar2
664: ,p_attribute6 in varchar2 default hr_api.g_varchar2
657: ,p_object_version_number in out nocopy number
658: ,p_attribute_category in varchar2 default hr_api.g_varchar2
659: ,p_attribute1 in varchar2 default hr_api.g_varchar2
660: ,p_attribute2 in varchar2 default hr_api.g_varchar2
661: ,p_attribute3 in varchar2 default hr_api.g_varchar2
662: ,p_attribute4 in varchar2 default hr_api.g_varchar2
663: ,p_attribute5 in varchar2 default hr_api.g_varchar2
664: ,p_attribute6 in varchar2 default hr_api.g_varchar2
665: ,p_attribute7 in varchar2 default hr_api.g_varchar2
658: ,p_attribute_category in varchar2 default hr_api.g_varchar2
659: ,p_attribute1 in varchar2 default hr_api.g_varchar2
660: ,p_attribute2 in varchar2 default hr_api.g_varchar2
661: ,p_attribute3 in varchar2 default hr_api.g_varchar2
662: ,p_attribute4 in varchar2 default hr_api.g_varchar2
663: ,p_attribute5 in varchar2 default hr_api.g_varchar2
664: ,p_attribute6 in varchar2 default hr_api.g_varchar2
665: ,p_attribute7 in varchar2 default hr_api.g_varchar2
666: ,p_attribute8 in varchar2 default hr_api.g_varchar2
659: ,p_attribute1 in varchar2 default hr_api.g_varchar2
660: ,p_attribute2 in varchar2 default hr_api.g_varchar2
661: ,p_attribute3 in varchar2 default hr_api.g_varchar2
662: ,p_attribute4 in varchar2 default hr_api.g_varchar2
663: ,p_attribute5 in varchar2 default hr_api.g_varchar2
664: ,p_attribute6 in varchar2 default hr_api.g_varchar2
665: ,p_attribute7 in varchar2 default hr_api.g_varchar2
666: ,p_attribute8 in varchar2 default hr_api.g_varchar2
667: ,p_attribute9 in varchar2 default hr_api.g_varchar2
660: ,p_attribute2 in varchar2 default hr_api.g_varchar2
661: ,p_attribute3 in varchar2 default hr_api.g_varchar2
662: ,p_attribute4 in varchar2 default hr_api.g_varchar2
663: ,p_attribute5 in varchar2 default hr_api.g_varchar2
664: ,p_attribute6 in varchar2 default hr_api.g_varchar2
665: ,p_attribute7 in varchar2 default hr_api.g_varchar2
666: ,p_attribute8 in varchar2 default hr_api.g_varchar2
667: ,p_attribute9 in varchar2 default hr_api.g_varchar2
668: ,p_attribute10 in varchar2 default hr_api.g_varchar2
661: ,p_attribute3 in varchar2 default hr_api.g_varchar2
662: ,p_attribute4 in varchar2 default hr_api.g_varchar2
663: ,p_attribute5 in varchar2 default hr_api.g_varchar2
664: ,p_attribute6 in varchar2 default hr_api.g_varchar2
665: ,p_attribute7 in varchar2 default hr_api.g_varchar2
666: ,p_attribute8 in varchar2 default hr_api.g_varchar2
667: ,p_attribute9 in varchar2 default hr_api.g_varchar2
668: ,p_attribute10 in varchar2 default hr_api.g_varchar2
669: ,p_attribute11 in varchar2 default hr_api.g_varchar2
662: ,p_attribute4 in varchar2 default hr_api.g_varchar2
663: ,p_attribute5 in varchar2 default hr_api.g_varchar2
664: ,p_attribute6 in varchar2 default hr_api.g_varchar2
665: ,p_attribute7 in varchar2 default hr_api.g_varchar2
666: ,p_attribute8 in varchar2 default hr_api.g_varchar2
667: ,p_attribute9 in varchar2 default hr_api.g_varchar2
668: ,p_attribute10 in varchar2 default hr_api.g_varchar2
669: ,p_attribute11 in varchar2 default hr_api.g_varchar2
670: ,p_attribute12 in varchar2 default hr_api.g_varchar2
663: ,p_attribute5 in varchar2 default hr_api.g_varchar2
664: ,p_attribute6 in varchar2 default hr_api.g_varchar2
665: ,p_attribute7 in varchar2 default hr_api.g_varchar2
666: ,p_attribute8 in varchar2 default hr_api.g_varchar2
667: ,p_attribute9 in varchar2 default hr_api.g_varchar2
668: ,p_attribute10 in varchar2 default hr_api.g_varchar2
669: ,p_attribute11 in varchar2 default hr_api.g_varchar2
670: ,p_attribute12 in varchar2 default hr_api.g_varchar2
671: ,p_attribute13 in varchar2 default hr_api.g_varchar2
664: ,p_attribute6 in varchar2 default hr_api.g_varchar2
665: ,p_attribute7 in varchar2 default hr_api.g_varchar2
666: ,p_attribute8 in varchar2 default hr_api.g_varchar2
667: ,p_attribute9 in varchar2 default hr_api.g_varchar2
668: ,p_attribute10 in varchar2 default hr_api.g_varchar2
669: ,p_attribute11 in varchar2 default hr_api.g_varchar2
670: ,p_attribute12 in varchar2 default hr_api.g_varchar2
671: ,p_attribute13 in varchar2 default hr_api.g_varchar2
672: ,p_attribute14 in varchar2 default hr_api.g_varchar2
665: ,p_attribute7 in varchar2 default hr_api.g_varchar2
666: ,p_attribute8 in varchar2 default hr_api.g_varchar2
667: ,p_attribute9 in varchar2 default hr_api.g_varchar2
668: ,p_attribute10 in varchar2 default hr_api.g_varchar2
669: ,p_attribute11 in varchar2 default hr_api.g_varchar2
670: ,p_attribute12 in varchar2 default hr_api.g_varchar2
671: ,p_attribute13 in varchar2 default hr_api.g_varchar2
672: ,p_attribute14 in varchar2 default hr_api.g_varchar2
673: ,p_attribute15 in varchar2 default hr_api.g_varchar2
666: ,p_attribute8 in varchar2 default hr_api.g_varchar2
667: ,p_attribute9 in varchar2 default hr_api.g_varchar2
668: ,p_attribute10 in varchar2 default hr_api.g_varchar2
669: ,p_attribute11 in varchar2 default hr_api.g_varchar2
670: ,p_attribute12 in varchar2 default hr_api.g_varchar2
671: ,p_attribute13 in varchar2 default hr_api.g_varchar2
672: ,p_attribute14 in varchar2 default hr_api.g_varchar2
673: ,p_attribute15 in varchar2 default hr_api.g_varchar2
674: ,p_attribute16 in varchar2 default hr_api.g_varchar2
667: ,p_attribute9 in varchar2 default hr_api.g_varchar2
668: ,p_attribute10 in varchar2 default hr_api.g_varchar2
669: ,p_attribute11 in varchar2 default hr_api.g_varchar2
670: ,p_attribute12 in varchar2 default hr_api.g_varchar2
671: ,p_attribute13 in varchar2 default hr_api.g_varchar2
672: ,p_attribute14 in varchar2 default hr_api.g_varchar2
673: ,p_attribute15 in varchar2 default hr_api.g_varchar2
674: ,p_attribute16 in varchar2 default hr_api.g_varchar2
675: ,p_attribute17 in varchar2 default hr_api.g_varchar2
668: ,p_attribute10 in varchar2 default hr_api.g_varchar2
669: ,p_attribute11 in varchar2 default hr_api.g_varchar2
670: ,p_attribute12 in varchar2 default hr_api.g_varchar2
671: ,p_attribute13 in varchar2 default hr_api.g_varchar2
672: ,p_attribute14 in varchar2 default hr_api.g_varchar2
673: ,p_attribute15 in varchar2 default hr_api.g_varchar2
674: ,p_attribute16 in varchar2 default hr_api.g_varchar2
675: ,p_attribute17 in varchar2 default hr_api.g_varchar2
676: ,p_attribute18 in varchar2 default hr_api.g_varchar2
669: ,p_attribute11 in varchar2 default hr_api.g_varchar2
670: ,p_attribute12 in varchar2 default hr_api.g_varchar2
671: ,p_attribute13 in varchar2 default hr_api.g_varchar2
672: ,p_attribute14 in varchar2 default hr_api.g_varchar2
673: ,p_attribute15 in varchar2 default hr_api.g_varchar2
674: ,p_attribute16 in varchar2 default hr_api.g_varchar2
675: ,p_attribute17 in varchar2 default hr_api.g_varchar2
676: ,p_attribute18 in varchar2 default hr_api.g_varchar2
677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
670: ,p_attribute12 in varchar2 default hr_api.g_varchar2
671: ,p_attribute13 in varchar2 default hr_api.g_varchar2
672: ,p_attribute14 in varchar2 default hr_api.g_varchar2
673: ,p_attribute15 in varchar2 default hr_api.g_varchar2
674: ,p_attribute16 in varchar2 default hr_api.g_varchar2
675: ,p_attribute17 in varchar2 default hr_api.g_varchar2
676: ,p_attribute18 in varchar2 default hr_api.g_varchar2
677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
671: ,p_attribute13 in varchar2 default hr_api.g_varchar2
672: ,p_attribute14 in varchar2 default hr_api.g_varchar2
673: ,p_attribute15 in varchar2 default hr_api.g_varchar2
674: ,p_attribute16 in varchar2 default hr_api.g_varchar2
675: ,p_attribute17 in varchar2 default hr_api.g_varchar2
676: ,p_attribute18 in varchar2 default hr_api.g_varchar2
677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
679: ,p_attribute21 in varchar2 default hr_api.g_varchar2
672: ,p_attribute14 in varchar2 default hr_api.g_varchar2
673: ,p_attribute15 in varchar2 default hr_api.g_varchar2
674: ,p_attribute16 in varchar2 default hr_api.g_varchar2
675: ,p_attribute17 in varchar2 default hr_api.g_varchar2
676: ,p_attribute18 in varchar2 default hr_api.g_varchar2
677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
679: ,p_attribute21 in varchar2 default hr_api.g_varchar2
680: ,p_attribute22 in varchar2 default hr_api.g_varchar2
673: ,p_attribute15 in varchar2 default hr_api.g_varchar2
674: ,p_attribute16 in varchar2 default hr_api.g_varchar2
675: ,p_attribute17 in varchar2 default hr_api.g_varchar2
676: ,p_attribute18 in varchar2 default hr_api.g_varchar2
677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
679: ,p_attribute21 in varchar2 default hr_api.g_varchar2
680: ,p_attribute22 in varchar2 default hr_api.g_varchar2
681: ,p_attribute23 in varchar2 default hr_api.g_varchar2
674: ,p_attribute16 in varchar2 default hr_api.g_varchar2
675: ,p_attribute17 in varchar2 default hr_api.g_varchar2
676: ,p_attribute18 in varchar2 default hr_api.g_varchar2
677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
679: ,p_attribute21 in varchar2 default hr_api.g_varchar2
680: ,p_attribute22 in varchar2 default hr_api.g_varchar2
681: ,p_attribute23 in varchar2 default hr_api.g_varchar2
682: ,p_attribute24 in varchar2 default hr_api.g_varchar2
675: ,p_attribute17 in varchar2 default hr_api.g_varchar2
676: ,p_attribute18 in varchar2 default hr_api.g_varchar2
677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
679: ,p_attribute21 in varchar2 default hr_api.g_varchar2
680: ,p_attribute22 in varchar2 default hr_api.g_varchar2
681: ,p_attribute23 in varchar2 default hr_api.g_varchar2
682: ,p_attribute24 in varchar2 default hr_api.g_varchar2
683: ,p_attribute25 in varchar2 default hr_api.g_varchar2
676: ,p_attribute18 in varchar2 default hr_api.g_varchar2
677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
679: ,p_attribute21 in varchar2 default hr_api.g_varchar2
680: ,p_attribute22 in varchar2 default hr_api.g_varchar2
681: ,p_attribute23 in varchar2 default hr_api.g_varchar2
682: ,p_attribute24 in varchar2 default hr_api.g_varchar2
683: ,p_attribute25 in varchar2 default hr_api.g_varchar2
684: ,p_attribute26 in varchar2 default hr_api.g_varchar2
677: ,p_attribute19 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
679: ,p_attribute21 in varchar2 default hr_api.g_varchar2
680: ,p_attribute22 in varchar2 default hr_api.g_varchar2
681: ,p_attribute23 in varchar2 default hr_api.g_varchar2
682: ,p_attribute24 in varchar2 default hr_api.g_varchar2
683: ,p_attribute25 in varchar2 default hr_api.g_varchar2
684: ,p_attribute26 in varchar2 default hr_api.g_varchar2
685: ,p_attribute27 in varchar2 default hr_api.g_varchar2
678: ,p_attribute20 in varchar2 default hr_api.g_varchar2
679: ,p_attribute21 in varchar2 default hr_api.g_varchar2
680: ,p_attribute22 in varchar2 default hr_api.g_varchar2
681: ,p_attribute23 in varchar2 default hr_api.g_varchar2
682: ,p_attribute24 in varchar2 default hr_api.g_varchar2
683: ,p_attribute25 in varchar2 default hr_api.g_varchar2
684: ,p_attribute26 in varchar2 default hr_api.g_varchar2
685: ,p_attribute27 in varchar2 default hr_api.g_varchar2
686: ,p_attribute28 in varchar2 default hr_api.g_varchar2
679: ,p_attribute21 in varchar2 default hr_api.g_varchar2
680: ,p_attribute22 in varchar2 default hr_api.g_varchar2
681: ,p_attribute23 in varchar2 default hr_api.g_varchar2
682: ,p_attribute24 in varchar2 default hr_api.g_varchar2
683: ,p_attribute25 in varchar2 default hr_api.g_varchar2
684: ,p_attribute26 in varchar2 default hr_api.g_varchar2
685: ,p_attribute27 in varchar2 default hr_api.g_varchar2
686: ,p_attribute28 in varchar2 default hr_api.g_varchar2
687: ,p_attribute29 in varchar2 default hr_api.g_varchar2
680: ,p_attribute22 in varchar2 default hr_api.g_varchar2
681: ,p_attribute23 in varchar2 default hr_api.g_varchar2
682: ,p_attribute24 in varchar2 default hr_api.g_varchar2
683: ,p_attribute25 in varchar2 default hr_api.g_varchar2
684: ,p_attribute26 in varchar2 default hr_api.g_varchar2
685: ,p_attribute27 in varchar2 default hr_api.g_varchar2
686: ,p_attribute28 in varchar2 default hr_api.g_varchar2
687: ,p_attribute29 in varchar2 default hr_api.g_varchar2
688: ,p_attribute30 in varchar2 default hr_api.g_varchar2
681: ,p_attribute23 in varchar2 default hr_api.g_varchar2
682: ,p_attribute24 in varchar2 default hr_api.g_varchar2
683: ,p_attribute25 in varchar2 default hr_api.g_varchar2
684: ,p_attribute26 in varchar2 default hr_api.g_varchar2
685: ,p_attribute27 in varchar2 default hr_api.g_varchar2
686: ,p_attribute28 in varchar2 default hr_api.g_varchar2
687: ,p_attribute29 in varchar2 default hr_api.g_varchar2
688: ,p_attribute30 in varchar2 default hr_api.g_varchar2
689: ,p_bld_blk_info_type_id in varchar2 default hr_api.g_number
682: ,p_attribute24 in varchar2 default hr_api.g_varchar2
683: ,p_attribute25 in varchar2 default hr_api.g_varchar2
684: ,p_attribute26 in varchar2 default hr_api.g_varchar2
685: ,p_attribute27 in varchar2 default hr_api.g_varchar2
686: ,p_attribute28 in varchar2 default hr_api.g_varchar2
687: ,p_attribute29 in varchar2 default hr_api.g_varchar2
688: ,p_attribute30 in varchar2 default hr_api.g_varchar2
689: ,p_bld_blk_info_type_id in varchar2 default hr_api.g_number
690: ,p_data_set_id in number default hr_api.g_number
683: ,p_attribute25 in varchar2 default hr_api.g_varchar2
684: ,p_attribute26 in varchar2 default hr_api.g_varchar2
685: ,p_attribute27 in varchar2 default hr_api.g_varchar2
686: ,p_attribute28 in varchar2 default hr_api.g_varchar2
687: ,p_attribute29 in varchar2 default hr_api.g_varchar2
688: ,p_attribute30 in varchar2 default hr_api.g_varchar2
689: ,p_bld_blk_info_type_id in varchar2 default hr_api.g_number
690: ,p_data_set_id in number default hr_api.g_number
691: ) is
684: ,p_attribute26 in varchar2 default hr_api.g_varchar2
685: ,p_attribute27 in varchar2 default hr_api.g_varchar2
686: ,p_attribute28 in varchar2 default hr_api.g_varchar2
687: ,p_attribute29 in varchar2 default hr_api.g_varchar2
688: ,p_attribute30 in varchar2 default hr_api.g_varchar2
689: ,p_bld_blk_info_type_id in varchar2 default hr_api.g_number
690: ,p_data_set_id in number default hr_api.g_number
691: ) is
692:
685: ,p_attribute27 in varchar2 default hr_api.g_varchar2
686: ,p_attribute28 in varchar2 default hr_api.g_varchar2
687: ,p_attribute29 in varchar2 default hr_api.g_varchar2
688: ,p_attribute30 in varchar2 default hr_api.g_varchar2
689: ,p_bld_blk_info_type_id in varchar2 default hr_api.g_number
690: ,p_data_set_id in number default hr_api.g_number
691: ) is
692:
693: l_rec hxc_tat_shd.g_rec_type;
686: ,p_attribute28 in varchar2 default hr_api.g_varchar2
687: ,p_attribute29 in varchar2 default hr_api.g_varchar2
688: ,p_attribute30 in varchar2 default hr_api.g_varchar2
689: ,p_bld_blk_info_type_id in varchar2 default hr_api.g_number
690: ,p_data_set_id in number default hr_api.g_number
691: ) is
692:
693: l_rec hxc_tat_shd.g_rec_type;
694: l_proc varchar2(72) ;