APPS.HXC_TAT_UPD dependencies on HR_API

Line 116: when hr_api.check_integrity_violated then

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

Line 118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 119: when hr_api.parent_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

Line 121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 122: when hr_api.unique_integrity_violated 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;

Line 124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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;

Line 367: when hr_api.cannot_find_prog_unit then

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;

Line 368: hr_api.cannot_find_prog_unit_error

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:

Line 432: if (p_rec.attribute_category = hr_api.g_varchar2) then

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:

Line 437: if (p_rec.attribute1 = hr_api.g_varchar2) then

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:

Line 442: if (p_rec.attribute2 = hr_api.g_varchar2) then

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:

Line 447: if (p_rec.attribute3 = hr_api.g_varchar2) then

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:

Line 452: if (p_rec.attribute4 = hr_api.g_varchar2) then

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:

Line 457: if (p_rec.attribute5 = hr_api.g_varchar2) then

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:

Line 462: if (p_rec.attribute6 = hr_api.g_varchar2) then

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:

Line 467: if (p_rec.attribute7 = hr_api.g_varchar2) then

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:

Line 472: if (p_rec.attribute8 = hr_api.g_varchar2) then

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:

Line 477: if (p_rec.attribute9 = hr_api.g_varchar2) then

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:

Line 482: if (p_rec.attribute10 = hr_api.g_varchar2) then

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:

Line 487: if (p_rec.attribute11 = hr_api.g_varchar2) then

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:

Line 492: if (p_rec.attribute12 = hr_api.g_varchar2) then

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:

Line 497: if (p_rec.attribute13 = hr_api.g_varchar2) then

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:

Line 502: if (p_rec.attribute14 = hr_api.g_varchar2) then

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:

Line 507: if (p_rec.attribute15 = hr_api.g_varchar2) then

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:

Line 512: if (p_rec.attribute16 = hr_api.g_varchar2) then

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:

Line 517: if (p_rec.attribute17 = hr_api.g_varchar2) then

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:

Line 522: if (p_rec.attribute18 = hr_api.g_varchar2) then

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:

Line 527: if (p_rec.attribute19 = hr_api.g_varchar2) then

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:

Line 532: if (p_rec.attribute20 = hr_api.g_varchar2) then

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:

Line 537: if (p_rec.attribute21 = hr_api.g_varchar2) then

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:

Line 542: if (p_rec.attribute22 = hr_api.g_varchar2) then

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:

Line 547: if (p_rec.attribute23 = hr_api.g_varchar2) then

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:

Line 552: if (p_rec.attribute24 = hr_api.g_varchar2) then

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:

Line 557: if (p_rec.attribute25 = hr_api.g_varchar2) then

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:

Line 562: if (p_rec.attribute26 = hr_api.g_varchar2) then

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:

Line 567: if (p_rec.attribute27 = hr_api.g_varchar2) then

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:

Line 572: if (p_rec.attribute28 = hr_api.g_varchar2) then

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:

Line 577: if (p_rec.attribute29 = hr_api.g_varchar2) then

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:

Line 582: if (p_rec.attribute30 = hr_api.g_varchar2) then

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:

Line 587: if (p_rec.bld_blk_info_type_id = hr_api.g_number) then

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:

Line 592: if (p_rec.data_set_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:
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:

Line 658: ,p_attribute_category in varchar2 default hr_api.g_varchar2

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

Line 659: ,p_attribute1 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

Line 660: ,p_attribute2 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

Line 661: ,p_attribute3 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

Line 662: ,p_attribute4 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

Line 663: ,p_attribute5 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

Line 664: ,p_attribute6 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

Line 665: ,p_attribute7 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

Line 666: ,p_attribute8 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

Line 667: ,p_attribute9 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

Line 668: ,p_attribute10 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

Line 669: ,p_attribute11 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

Line 670: ,p_attribute12 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

Line 671: ,p_attribute13 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

Line 672: ,p_attribute14 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

Line 673: ,p_attribute15 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

Line 674: ,p_attribute16 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

Line 675: ,p_attribute17 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

Line 676: ,p_attribute18 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

Line 677: ,p_attribute19 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

Line 678: ,p_attribute20 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

Line 679: ,p_attribute21 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

Line 680: ,p_attribute22 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

Line 681: ,p_attribute23 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

Line 682: ,p_attribute24 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

Line 683: ,p_attribute25 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

Line 684: ,p_attribute26 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

Line 685: ,p_attribute27 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

Line 686: ,p_attribute28 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
690: ,p_data_set_id in number default hr_api.g_number

Line 687: ,p_attribute29 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
691: ) is

Line 688: ,p_attribute30 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
692:

Line 689: ,p_bld_blk_info_type_id in varchar2 default hr_api.g_number

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;

Line 690: ,p_data_set_id in number default hr_api.g_number

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) ;