eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_HAV_UPD dependencies on HR_API

Line 127: When hr_api.check_integrity_violated Then

123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: end if;
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: --
130: hxc_hav_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: --
130: hxc_hav_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: --
135: hxc_hav_shd.constraint_error

Line 132: When hr_api.parent_integrity_violated Then

128: -- A check constraint has been violated
129: --
130: hxc_hav_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: --
135: hxc_hav_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: --
135: hxc_hav_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: --
140: hxc_hav_shd.constraint_error

Line 137: When hr_api.unique_integrity_violated Then

133: -- Parent integrity has been violated
134: --
135: hxc_hav_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: --
140: hxc_hav_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: --
140: hxc_hav_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: --
144: Raise;
145: End update_dml;

Line 396: when hr_api.cannot_find_prog_unit then

392: );
393: --
394: exception
395: --
396: when hr_api.cannot_find_prog_unit then
397: --
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'HXC_ALIAS_VALUES'
400: ,p_hook_type => 'AU');

Line 398: hr_api.cannot_find_prog_unit_error

394: exception
395: --
396: when hr_api.cannot_find_prog_unit then
397: --
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'HXC_ALIAS_VALUES'
400: ,p_hook_type => 'AU');
401: --
402: end;

Line 463: If (p_rec.alias_value_name = hr_api.g_varchar2) then

459: -- p_rec plsql record structure
460: -- to see if a system default is being used. If a system default
461: -- is being used then we must set to the 'current' argument value.
462: --
463: If (p_rec.alias_value_name = hr_api.g_varchar2) then
464: p_rec.alias_value_name :=
465: hxc_hav_shd.g_old_rec.alias_value_name;
466: End If;
467: If (p_rec.date_from = hr_api.g_date) then

Line 467: If (p_rec.date_from = hr_api.g_date) then

463: If (p_rec.alias_value_name = hr_api.g_varchar2) then
464: p_rec.alias_value_name :=
465: hxc_hav_shd.g_old_rec.alias_value_name;
466: End If;
467: If (p_rec.date_from = hr_api.g_date) then
468: p_rec.date_from :=
469: hxc_hav_shd.g_old_rec.date_from;
470: End If;
471: If (p_rec.date_to = hr_api.g_date) then

Line 471: If (p_rec.date_to = hr_api.g_date) then

467: If (p_rec.date_from = hr_api.g_date) then
468: p_rec.date_from :=
469: hxc_hav_shd.g_old_rec.date_from;
470: End If;
471: If (p_rec.date_to = hr_api.g_date) then
472: p_rec.date_to :=
473: hxc_hav_shd.g_old_rec.date_to;
474: End If;
475: If (p_rec.alias_definition_id = hr_api.g_number) then

Line 475: If (p_rec.alias_definition_id = hr_api.g_number) then

471: If (p_rec.date_to = hr_api.g_date) then
472: p_rec.date_to :=
473: hxc_hav_shd.g_old_rec.date_to;
474: End If;
475: If (p_rec.alias_definition_id = hr_api.g_number) then
476: p_rec.alias_definition_id :=
477: hxc_hav_shd.g_old_rec.alias_definition_id;
478: End If;
479: If (p_rec.enabled_flag = hr_api.g_varchar2) then

Line 479: If (p_rec.enabled_flag = hr_api.g_varchar2) then

475: If (p_rec.alias_definition_id = hr_api.g_number) then
476: p_rec.alias_definition_id :=
477: hxc_hav_shd.g_old_rec.alias_definition_id;
478: End If;
479: If (p_rec.enabled_flag = hr_api.g_varchar2) then
480: p_rec.enabled_flag :=
481: hxc_hav_shd.g_old_rec.enabled_flag;
482: End If;
483: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 483: If (p_rec.attribute_category = hr_api.g_varchar2) then

479: If (p_rec.enabled_flag = hr_api.g_varchar2) then
480: p_rec.enabled_flag :=
481: hxc_hav_shd.g_old_rec.enabled_flag;
482: End If;
483: If (p_rec.attribute_category = hr_api.g_varchar2) then
484: p_rec.attribute_category :=
485: hxc_hav_shd.g_old_rec.attribute_category;
486: End If;
487: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 487: If (p_rec.attribute1 = hr_api.g_varchar2) then

483: If (p_rec.attribute_category = hr_api.g_varchar2) then
484: p_rec.attribute_category :=
485: hxc_hav_shd.g_old_rec.attribute_category;
486: End If;
487: If (p_rec.attribute1 = hr_api.g_varchar2) then
488: p_rec.attribute1 :=
489: hxc_hav_shd.g_old_rec.attribute1;
490: End If;
491: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 491: If (p_rec.attribute2 = hr_api.g_varchar2) then

487: If (p_rec.attribute1 = hr_api.g_varchar2) then
488: p_rec.attribute1 :=
489: hxc_hav_shd.g_old_rec.attribute1;
490: End If;
491: If (p_rec.attribute2 = hr_api.g_varchar2) then
492: p_rec.attribute2 :=
493: hxc_hav_shd.g_old_rec.attribute2;
494: End If;
495: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 495: If (p_rec.attribute3 = hr_api.g_varchar2) then

491: If (p_rec.attribute2 = hr_api.g_varchar2) then
492: p_rec.attribute2 :=
493: hxc_hav_shd.g_old_rec.attribute2;
494: End If;
495: If (p_rec.attribute3 = hr_api.g_varchar2) then
496: p_rec.attribute3 :=
497: hxc_hav_shd.g_old_rec.attribute3;
498: End If;
499: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 499: If (p_rec.attribute4 = hr_api.g_varchar2) then

495: If (p_rec.attribute3 = hr_api.g_varchar2) then
496: p_rec.attribute3 :=
497: hxc_hav_shd.g_old_rec.attribute3;
498: End If;
499: If (p_rec.attribute4 = hr_api.g_varchar2) then
500: p_rec.attribute4 :=
501: hxc_hav_shd.g_old_rec.attribute4;
502: End If;
503: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 503: If (p_rec.attribute5 = hr_api.g_varchar2) then

499: If (p_rec.attribute4 = hr_api.g_varchar2) then
500: p_rec.attribute4 :=
501: hxc_hav_shd.g_old_rec.attribute4;
502: End If;
503: If (p_rec.attribute5 = hr_api.g_varchar2) then
504: p_rec.attribute5 :=
505: hxc_hav_shd.g_old_rec.attribute5;
506: End If;
507: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 507: If (p_rec.attribute6 = hr_api.g_varchar2) then

503: If (p_rec.attribute5 = hr_api.g_varchar2) then
504: p_rec.attribute5 :=
505: hxc_hav_shd.g_old_rec.attribute5;
506: End If;
507: If (p_rec.attribute6 = hr_api.g_varchar2) then
508: p_rec.attribute6 :=
509: hxc_hav_shd.g_old_rec.attribute6;
510: End If;
511: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 511: If (p_rec.attribute7 = hr_api.g_varchar2) then

507: If (p_rec.attribute6 = hr_api.g_varchar2) then
508: p_rec.attribute6 :=
509: hxc_hav_shd.g_old_rec.attribute6;
510: End If;
511: If (p_rec.attribute7 = hr_api.g_varchar2) then
512: p_rec.attribute7 :=
513: hxc_hav_shd.g_old_rec.attribute7;
514: End If;
515: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 515: If (p_rec.attribute8 = hr_api.g_varchar2) then

511: If (p_rec.attribute7 = hr_api.g_varchar2) then
512: p_rec.attribute7 :=
513: hxc_hav_shd.g_old_rec.attribute7;
514: End If;
515: If (p_rec.attribute8 = hr_api.g_varchar2) then
516: p_rec.attribute8 :=
517: hxc_hav_shd.g_old_rec.attribute8;
518: End If;
519: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 519: If (p_rec.attribute9 = hr_api.g_varchar2) then

515: If (p_rec.attribute8 = hr_api.g_varchar2) then
516: p_rec.attribute8 :=
517: hxc_hav_shd.g_old_rec.attribute8;
518: End If;
519: If (p_rec.attribute9 = hr_api.g_varchar2) then
520: p_rec.attribute9 :=
521: hxc_hav_shd.g_old_rec.attribute9;
522: End If;
523: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 523: If (p_rec.attribute10 = hr_api.g_varchar2) then

519: If (p_rec.attribute9 = hr_api.g_varchar2) then
520: p_rec.attribute9 :=
521: hxc_hav_shd.g_old_rec.attribute9;
522: End If;
523: If (p_rec.attribute10 = hr_api.g_varchar2) then
524: p_rec.attribute10 :=
525: hxc_hav_shd.g_old_rec.attribute10;
526: End If;
527: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 527: If (p_rec.attribute11 = hr_api.g_varchar2) then

523: If (p_rec.attribute10 = hr_api.g_varchar2) then
524: p_rec.attribute10 :=
525: hxc_hav_shd.g_old_rec.attribute10;
526: End If;
527: If (p_rec.attribute11 = hr_api.g_varchar2) then
528: p_rec.attribute11 :=
529: hxc_hav_shd.g_old_rec.attribute11;
530: End If;
531: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 531: If (p_rec.attribute12 = hr_api.g_varchar2) then

527: If (p_rec.attribute11 = hr_api.g_varchar2) then
528: p_rec.attribute11 :=
529: hxc_hav_shd.g_old_rec.attribute11;
530: End If;
531: If (p_rec.attribute12 = hr_api.g_varchar2) then
532: p_rec.attribute12 :=
533: hxc_hav_shd.g_old_rec.attribute12;
534: End If;
535: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 535: If (p_rec.attribute13 = hr_api.g_varchar2) then

531: If (p_rec.attribute12 = hr_api.g_varchar2) then
532: p_rec.attribute12 :=
533: hxc_hav_shd.g_old_rec.attribute12;
534: End If;
535: If (p_rec.attribute13 = hr_api.g_varchar2) then
536: p_rec.attribute13 :=
537: hxc_hav_shd.g_old_rec.attribute13;
538: End If;
539: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 539: If (p_rec.attribute14 = hr_api.g_varchar2) then

535: If (p_rec.attribute13 = hr_api.g_varchar2) then
536: p_rec.attribute13 :=
537: hxc_hav_shd.g_old_rec.attribute13;
538: End If;
539: If (p_rec.attribute14 = hr_api.g_varchar2) then
540: p_rec.attribute14 :=
541: hxc_hav_shd.g_old_rec.attribute14;
542: End If;
543: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 543: If (p_rec.attribute15 = hr_api.g_varchar2) then

539: If (p_rec.attribute14 = hr_api.g_varchar2) then
540: p_rec.attribute14 :=
541: hxc_hav_shd.g_old_rec.attribute14;
542: End If;
543: If (p_rec.attribute15 = hr_api.g_varchar2) then
544: p_rec.attribute15 :=
545: hxc_hav_shd.g_old_rec.attribute15;
546: End If;
547: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 547: If (p_rec.attribute16 = hr_api.g_varchar2) then

543: If (p_rec.attribute15 = hr_api.g_varchar2) then
544: p_rec.attribute15 :=
545: hxc_hav_shd.g_old_rec.attribute15;
546: End If;
547: If (p_rec.attribute16 = hr_api.g_varchar2) then
548: p_rec.attribute16 :=
549: hxc_hav_shd.g_old_rec.attribute16;
550: End If;
551: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 551: If (p_rec.attribute17 = hr_api.g_varchar2) then

547: If (p_rec.attribute16 = hr_api.g_varchar2) then
548: p_rec.attribute16 :=
549: hxc_hav_shd.g_old_rec.attribute16;
550: End If;
551: If (p_rec.attribute17 = hr_api.g_varchar2) then
552: p_rec.attribute17 :=
553: hxc_hav_shd.g_old_rec.attribute17;
554: End If;
555: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 555: If (p_rec.attribute18 = hr_api.g_varchar2) then

551: If (p_rec.attribute17 = hr_api.g_varchar2) then
552: p_rec.attribute17 :=
553: hxc_hav_shd.g_old_rec.attribute17;
554: End If;
555: If (p_rec.attribute18 = hr_api.g_varchar2) then
556: p_rec.attribute18 :=
557: hxc_hav_shd.g_old_rec.attribute18;
558: End If;
559: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 559: If (p_rec.attribute19 = hr_api.g_varchar2) then

555: If (p_rec.attribute18 = hr_api.g_varchar2) then
556: p_rec.attribute18 :=
557: hxc_hav_shd.g_old_rec.attribute18;
558: End If;
559: If (p_rec.attribute19 = hr_api.g_varchar2) then
560: p_rec.attribute19 :=
561: hxc_hav_shd.g_old_rec.attribute19;
562: End If;
563: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 563: If (p_rec.attribute20 = hr_api.g_varchar2) then

559: If (p_rec.attribute19 = hr_api.g_varchar2) then
560: p_rec.attribute19 :=
561: hxc_hav_shd.g_old_rec.attribute19;
562: End If;
563: If (p_rec.attribute20 = hr_api.g_varchar2) then
564: p_rec.attribute20 :=
565: hxc_hav_shd.g_old_rec.attribute20;
566: End If;
567: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 567: If (p_rec.attribute21 = hr_api.g_varchar2) then

563: If (p_rec.attribute20 = hr_api.g_varchar2) then
564: p_rec.attribute20 :=
565: hxc_hav_shd.g_old_rec.attribute20;
566: End If;
567: If (p_rec.attribute21 = hr_api.g_varchar2) then
568: p_rec.attribute21 :=
569: hxc_hav_shd.g_old_rec.attribute21;
570: End If;
571: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 571: If (p_rec.attribute22 = hr_api.g_varchar2) then

567: If (p_rec.attribute21 = hr_api.g_varchar2) then
568: p_rec.attribute21 :=
569: hxc_hav_shd.g_old_rec.attribute21;
570: End If;
571: If (p_rec.attribute22 = hr_api.g_varchar2) then
572: p_rec.attribute22 :=
573: hxc_hav_shd.g_old_rec.attribute22;
574: End If;
575: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 575: If (p_rec.attribute23 = hr_api.g_varchar2) then

571: If (p_rec.attribute22 = hr_api.g_varchar2) then
572: p_rec.attribute22 :=
573: hxc_hav_shd.g_old_rec.attribute22;
574: End If;
575: If (p_rec.attribute23 = hr_api.g_varchar2) then
576: p_rec.attribute23 :=
577: hxc_hav_shd.g_old_rec.attribute23;
578: End If;
579: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 579: If (p_rec.attribute24 = hr_api.g_varchar2) then

575: If (p_rec.attribute23 = hr_api.g_varchar2) then
576: p_rec.attribute23 :=
577: hxc_hav_shd.g_old_rec.attribute23;
578: End If;
579: If (p_rec.attribute24 = hr_api.g_varchar2) then
580: p_rec.attribute24 :=
581: hxc_hav_shd.g_old_rec.attribute24;
582: End If;
583: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 583: If (p_rec.attribute25 = hr_api.g_varchar2) then

579: If (p_rec.attribute24 = hr_api.g_varchar2) then
580: p_rec.attribute24 :=
581: hxc_hav_shd.g_old_rec.attribute24;
582: End If;
583: If (p_rec.attribute25 = hr_api.g_varchar2) then
584: p_rec.attribute25 :=
585: hxc_hav_shd.g_old_rec.attribute25;
586: End If;
587: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 587: If (p_rec.attribute26 = hr_api.g_varchar2) then

583: If (p_rec.attribute25 = hr_api.g_varchar2) then
584: p_rec.attribute25 :=
585: hxc_hav_shd.g_old_rec.attribute25;
586: End If;
587: If (p_rec.attribute26 = hr_api.g_varchar2) then
588: p_rec.attribute26 :=
589: hxc_hav_shd.g_old_rec.attribute26;
590: End If;
591: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 591: If (p_rec.attribute27 = hr_api.g_varchar2) then

587: If (p_rec.attribute26 = hr_api.g_varchar2) then
588: p_rec.attribute26 :=
589: hxc_hav_shd.g_old_rec.attribute26;
590: End If;
591: If (p_rec.attribute27 = hr_api.g_varchar2) then
592: p_rec.attribute27 :=
593: hxc_hav_shd.g_old_rec.attribute27;
594: End If;
595: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 595: If (p_rec.attribute28 = hr_api.g_varchar2) then

591: If (p_rec.attribute27 = hr_api.g_varchar2) then
592: p_rec.attribute27 :=
593: hxc_hav_shd.g_old_rec.attribute27;
594: End If;
595: If (p_rec.attribute28 = hr_api.g_varchar2) then
596: p_rec.attribute28 :=
597: hxc_hav_shd.g_old_rec.attribute28;
598: End If;
599: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 599: If (p_rec.attribute29 = hr_api.g_varchar2) then

595: If (p_rec.attribute28 = hr_api.g_varchar2) then
596: p_rec.attribute28 :=
597: hxc_hav_shd.g_old_rec.attribute28;
598: End If;
599: If (p_rec.attribute29 = hr_api.g_varchar2) then
600: p_rec.attribute29 :=
601: hxc_hav_shd.g_old_rec.attribute29;
602: End If;
603: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 603: If (p_rec.attribute30 = hr_api.g_varchar2) then

599: If (p_rec.attribute29 = hr_api.g_varchar2) then
600: p_rec.attribute29 :=
601: hxc_hav_shd.g_old_rec.attribute29;
602: End If;
603: If (p_rec.attribute30 = hr_api.g_varchar2) then
604: p_rec.attribute30 :=
605: hxc_hav_shd.g_old_rec.attribute30;
606: End If;
607: --

Line 665: ,p_alias_value_name in varchar2 default hr_api.g_varchar2

661: -- ----------------------------------------------------------------------------
662: Procedure upd
663: (p_alias_value_id in number
664: ,p_object_version_number in out nocopy number
665: ,p_alias_value_name in varchar2 default hr_api.g_varchar2
666: ,p_date_from in date default hr_api.g_date
667: ,p_alias_definition_id in number default hr_api.g_number
668: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
669: ,p_date_to in date default hr_api.g_date

Line 666: ,p_date_from in date default hr_api.g_date

662: Procedure upd
663: (p_alias_value_id in number
664: ,p_object_version_number in out nocopy number
665: ,p_alias_value_name in varchar2 default hr_api.g_varchar2
666: ,p_date_from in date default hr_api.g_date
667: ,p_alias_definition_id in number default hr_api.g_number
668: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
669: ,p_date_to in date default hr_api.g_date
670: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 667: ,p_alias_definition_id in number default hr_api.g_number

663: (p_alias_value_id in number
664: ,p_object_version_number in out nocopy number
665: ,p_alias_value_name in varchar2 default hr_api.g_varchar2
666: ,p_date_from in date default hr_api.g_date
667: ,p_alias_definition_id in number default hr_api.g_number
668: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
669: ,p_date_to in date default hr_api.g_date
670: ,p_attribute_category in varchar2 default hr_api.g_varchar2
671: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 668: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

664: ,p_object_version_number in out nocopy number
665: ,p_alias_value_name in varchar2 default hr_api.g_varchar2
666: ,p_date_from in date default hr_api.g_date
667: ,p_alias_definition_id in number default hr_api.g_number
668: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
669: ,p_date_to in date default hr_api.g_date
670: ,p_attribute_category in varchar2 default hr_api.g_varchar2
671: ,p_attribute1 in varchar2 default hr_api.g_varchar2
672: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 669: ,p_date_to in date default hr_api.g_date

665: ,p_alias_value_name in varchar2 default hr_api.g_varchar2
666: ,p_date_from in date default hr_api.g_date
667: ,p_alias_definition_id in number default hr_api.g_number
668: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
669: ,p_date_to in date default hr_api.g_date
670: ,p_attribute_category in varchar2 default hr_api.g_varchar2
671: ,p_attribute1 in varchar2 default hr_api.g_varchar2
672: ,p_attribute2 in varchar2 default hr_api.g_varchar2
673: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 670: ,p_attribute_category in varchar2 default hr_api.g_varchar2

666: ,p_date_from in date default hr_api.g_date
667: ,p_alias_definition_id in number default hr_api.g_number
668: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
669: ,p_date_to in date default hr_api.g_date
670: ,p_attribute_category in varchar2 default hr_api.g_varchar2
671: ,p_attribute1 in varchar2 default hr_api.g_varchar2
672: ,p_attribute2 in varchar2 default hr_api.g_varchar2
673: ,p_attribute3 in varchar2 default hr_api.g_varchar2
674: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 671: ,p_attribute1 in varchar2 default hr_api.g_varchar2

667: ,p_alias_definition_id in number default hr_api.g_number
668: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
669: ,p_date_to in date default hr_api.g_date
670: ,p_attribute_category in varchar2 default hr_api.g_varchar2
671: ,p_attribute1 in varchar2 default hr_api.g_varchar2
672: ,p_attribute2 in varchar2 default hr_api.g_varchar2
673: ,p_attribute3 in varchar2 default hr_api.g_varchar2
674: ,p_attribute4 in varchar2 default hr_api.g_varchar2
675: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 672: ,p_attribute2 in varchar2 default hr_api.g_varchar2

668: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
669: ,p_date_to in date default hr_api.g_date
670: ,p_attribute_category in varchar2 default hr_api.g_varchar2
671: ,p_attribute1 in varchar2 default hr_api.g_varchar2
672: ,p_attribute2 in varchar2 default hr_api.g_varchar2
673: ,p_attribute3 in varchar2 default hr_api.g_varchar2
674: ,p_attribute4 in varchar2 default hr_api.g_varchar2
675: ,p_attribute5 in varchar2 default hr_api.g_varchar2
676: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 673: ,p_attribute3 in varchar2 default hr_api.g_varchar2

669: ,p_date_to in date default hr_api.g_date
670: ,p_attribute_category in varchar2 default hr_api.g_varchar2
671: ,p_attribute1 in varchar2 default hr_api.g_varchar2
672: ,p_attribute2 in varchar2 default hr_api.g_varchar2
673: ,p_attribute3 in varchar2 default hr_api.g_varchar2
674: ,p_attribute4 in varchar2 default hr_api.g_varchar2
675: ,p_attribute5 in varchar2 default hr_api.g_varchar2
676: ,p_attribute6 in varchar2 default hr_api.g_varchar2
677: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 674: ,p_attribute4 in varchar2 default hr_api.g_varchar2

670: ,p_attribute_category in varchar2 default hr_api.g_varchar2
671: ,p_attribute1 in varchar2 default hr_api.g_varchar2
672: ,p_attribute2 in varchar2 default hr_api.g_varchar2
673: ,p_attribute3 in varchar2 default hr_api.g_varchar2
674: ,p_attribute4 in varchar2 default hr_api.g_varchar2
675: ,p_attribute5 in varchar2 default hr_api.g_varchar2
676: ,p_attribute6 in varchar2 default hr_api.g_varchar2
677: ,p_attribute7 in varchar2 default hr_api.g_varchar2
678: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 675: ,p_attribute5 in varchar2 default hr_api.g_varchar2

671: ,p_attribute1 in varchar2 default hr_api.g_varchar2
672: ,p_attribute2 in varchar2 default hr_api.g_varchar2
673: ,p_attribute3 in varchar2 default hr_api.g_varchar2
674: ,p_attribute4 in varchar2 default hr_api.g_varchar2
675: ,p_attribute5 in varchar2 default hr_api.g_varchar2
676: ,p_attribute6 in varchar2 default hr_api.g_varchar2
677: ,p_attribute7 in varchar2 default hr_api.g_varchar2
678: ,p_attribute8 in varchar2 default hr_api.g_varchar2
679: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 676: ,p_attribute6 in varchar2 default hr_api.g_varchar2

672: ,p_attribute2 in varchar2 default hr_api.g_varchar2
673: ,p_attribute3 in varchar2 default hr_api.g_varchar2
674: ,p_attribute4 in varchar2 default hr_api.g_varchar2
675: ,p_attribute5 in varchar2 default hr_api.g_varchar2
676: ,p_attribute6 in varchar2 default hr_api.g_varchar2
677: ,p_attribute7 in varchar2 default hr_api.g_varchar2
678: ,p_attribute8 in varchar2 default hr_api.g_varchar2
679: ,p_attribute9 in varchar2 default hr_api.g_varchar2
680: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 677: ,p_attribute7 in varchar2 default hr_api.g_varchar2

673: ,p_attribute3 in varchar2 default hr_api.g_varchar2
674: ,p_attribute4 in varchar2 default hr_api.g_varchar2
675: ,p_attribute5 in varchar2 default hr_api.g_varchar2
676: ,p_attribute6 in varchar2 default hr_api.g_varchar2
677: ,p_attribute7 in varchar2 default hr_api.g_varchar2
678: ,p_attribute8 in varchar2 default hr_api.g_varchar2
679: ,p_attribute9 in varchar2 default hr_api.g_varchar2
680: ,p_attribute10 in varchar2 default hr_api.g_varchar2
681: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 678: ,p_attribute8 in varchar2 default hr_api.g_varchar2

674: ,p_attribute4 in varchar2 default hr_api.g_varchar2
675: ,p_attribute5 in varchar2 default hr_api.g_varchar2
676: ,p_attribute6 in varchar2 default hr_api.g_varchar2
677: ,p_attribute7 in varchar2 default hr_api.g_varchar2
678: ,p_attribute8 in varchar2 default hr_api.g_varchar2
679: ,p_attribute9 in varchar2 default hr_api.g_varchar2
680: ,p_attribute10 in varchar2 default hr_api.g_varchar2
681: ,p_attribute11 in varchar2 default hr_api.g_varchar2
682: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 679: ,p_attribute9 in varchar2 default hr_api.g_varchar2

675: ,p_attribute5 in varchar2 default hr_api.g_varchar2
676: ,p_attribute6 in varchar2 default hr_api.g_varchar2
677: ,p_attribute7 in varchar2 default hr_api.g_varchar2
678: ,p_attribute8 in varchar2 default hr_api.g_varchar2
679: ,p_attribute9 in varchar2 default hr_api.g_varchar2
680: ,p_attribute10 in varchar2 default hr_api.g_varchar2
681: ,p_attribute11 in varchar2 default hr_api.g_varchar2
682: ,p_attribute12 in varchar2 default hr_api.g_varchar2
683: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 680: ,p_attribute10 in varchar2 default hr_api.g_varchar2

676: ,p_attribute6 in varchar2 default hr_api.g_varchar2
677: ,p_attribute7 in varchar2 default hr_api.g_varchar2
678: ,p_attribute8 in varchar2 default hr_api.g_varchar2
679: ,p_attribute9 in varchar2 default hr_api.g_varchar2
680: ,p_attribute10 in varchar2 default hr_api.g_varchar2
681: ,p_attribute11 in varchar2 default hr_api.g_varchar2
682: ,p_attribute12 in varchar2 default hr_api.g_varchar2
683: ,p_attribute13 in varchar2 default hr_api.g_varchar2
684: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 681: ,p_attribute11 in varchar2 default hr_api.g_varchar2

677: ,p_attribute7 in varchar2 default hr_api.g_varchar2
678: ,p_attribute8 in varchar2 default hr_api.g_varchar2
679: ,p_attribute9 in varchar2 default hr_api.g_varchar2
680: ,p_attribute10 in varchar2 default hr_api.g_varchar2
681: ,p_attribute11 in varchar2 default hr_api.g_varchar2
682: ,p_attribute12 in varchar2 default hr_api.g_varchar2
683: ,p_attribute13 in varchar2 default hr_api.g_varchar2
684: ,p_attribute14 in varchar2 default hr_api.g_varchar2
685: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 682: ,p_attribute12 in varchar2 default hr_api.g_varchar2

678: ,p_attribute8 in varchar2 default hr_api.g_varchar2
679: ,p_attribute9 in varchar2 default hr_api.g_varchar2
680: ,p_attribute10 in varchar2 default hr_api.g_varchar2
681: ,p_attribute11 in varchar2 default hr_api.g_varchar2
682: ,p_attribute12 in varchar2 default hr_api.g_varchar2
683: ,p_attribute13 in varchar2 default hr_api.g_varchar2
684: ,p_attribute14 in varchar2 default hr_api.g_varchar2
685: ,p_attribute15 in varchar2 default hr_api.g_varchar2
686: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 683: ,p_attribute13 in varchar2 default hr_api.g_varchar2

679: ,p_attribute9 in varchar2 default hr_api.g_varchar2
680: ,p_attribute10 in varchar2 default hr_api.g_varchar2
681: ,p_attribute11 in varchar2 default hr_api.g_varchar2
682: ,p_attribute12 in varchar2 default hr_api.g_varchar2
683: ,p_attribute13 in varchar2 default hr_api.g_varchar2
684: ,p_attribute14 in varchar2 default hr_api.g_varchar2
685: ,p_attribute15 in varchar2 default hr_api.g_varchar2
686: ,p_attribute16 in varchar2 default hr_api.g_varchar2
687: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 684: ,p_attribute14 in varchar2 default hr_api.g_varchar2

680: ,p_attribute10 in varchar2 default hr_api.g_varchar2
681: ,p_attribute11 in varchar2 default hr_api.g_varchar2
682: ,p_attribute12 in varchar2 default hr_api.g_varchar2
683: ,p_attribute13 in varchar2 default hr_api.g_varchar2
684: ,p_attribute14 in varchar2 default hr_api.g_varchar2
685: ,p_attribute15 in varchar2 default hr_api.g_varchar2
686: ,p_attribute16 in varchar2 default hr_api.g_varchar2
687: ,p_attribute17 in varchar2 default hr_api.g_varchar2
688: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 685: ,p_attribute15 in varchar2 default hr_api.g_varchar2

681: ,p_attribute11 in varchar2 default hr_api.g_varchar2
682: ,p_attribute12 in varchar2 default hr_api.g_varchar2
683: ,p_attribute13 in varchar2 default hr_api.g_varchar2
684: ,p_attribute14 in varchar2 default hr_api.g_varchar2
685: ,p_attribute15 in varchar2 default hr_api.g_varchar2
686: ,p_attribute16 in varchar2 default hr_api.g_varchar2
687: ,p_attribute17 in varchar2 default hr_api.g_varchar2
688: ,p_attribute18 in varchar2 default hr_api.g_varchar2
689: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 686: ,p_attribute16 in varchar2 default hr_api.g_varchar2

682: ,p_attribute12 in varchar2 default hr_api.g_varchar2
683: ,p_attribute13 in varchar2 default hr_api.g_varchar2
684: ,p_attribute14 in varchar2 default hr_api.g_varchar2
685: ,p_attribute15 in varchar2 default hr_api.g_varchar2
686: ,p_attribute16 in varchar2 default hr_api.g_varchar2
687: ,p_attribute17 in varchar2 default hr_api.g_varchar2
688: ,p_attribute18 in varchar2 default hr_api.g_varchar2
689: ,p_attribute19 in varchar2 default hr_api.g_varchar2
690: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 687: ,p_attribute17 in varchar2 default hr_api.g_varchar2

683: ,p_attribute13 in varchar2 default hr_api.g_varchar2
684: ,p_attribute14 in varchar2 default hr_api.g_varchar2
685: ,p_attribute15 in varchar2 default hr_api.g_varchar2
686: ,p_attribute16 in varchar2 default hr_api.g_varchar2
687: ,p_attribute17 in varchar2 default hr_api.g_varchar2
688: ,p_attribute18 in varchar2 default hr_api.g_varchar2
689: ,p_attribute19 in varchar2 default hr_api.g_varchar2
690: ,p_attribute20 in varchar2 default hr_api.g_varchar2
691: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 688: ,p_attribute18 in varchar2 default hr_api.g_varchar2

684: ,p_attribute14 in varchar2 default hr_api.g_varchar2
685: ,p_attribute15 in varchar2 default hr_api.g_varchar2
686: ,p_attribute16 in varchar2 default hr_api.g_varchar2
687: ,p_attribute17 in varchar2 default hr_api.g_varchar2
688: ,p_attribute18 in varchar2 default hr_api.g_varchar2
689: ,p_attribute19 in varchar2 default hr_api.g_varchar2
690: ,p_attribute20 in varchar2 default hr_api.g_varchar2
691: ,p_attribute21 in varchar2 default hr_api.g_varchar2
692: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 689: ,p_attribute19 in varchar2 default hr_api.g_varchar2

685: ,p_attribute15 in varchar2 default hr_api.g_varchar2
686: ,p_attribute16 in varchar2 default hr_api.g_varchar2
687: ,p_attribute17 in varchar2 default hr_api.g_varchar2
688: ,p_attribute18 in varchar2 default hr_api.g_varchar2
689: ,p_attribute19 in varchar2 default hr_api.g_varchar2
690: ,p_attribute20 in varchar2 default hr_api.g_varchar2
691: ,p_attribute21 in varchar2 default hr_api.g_varchar2
692: ,p_attribute22 in varchar2 default hr_api.g_varchar2
693: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 690: ,p_attribute20 in varchar2 default hr_api.g_varchar2

686: ,p_attribute16 in varchar2 default hr_api.g_varchar2
687: ,p_attribute17 in varchar2 default hr_api.g_varchar2
688: ,p_attribute18 in varchar2 default hr_api.g_varchar2
689: ,p_attribute19 in varchar2 default hr_api.g_varchar2
690: ,p_attribute20 in varchar2 default hr_api.g_varchar2
691: ,p_attribute21 in varchar2 default hr_api.g_varchar2
692: ,p_attribute22 in varchar2 default hr_api.g_varchar2
693: ,p_attribute23 in varchar2 default hr_api.g_varchar2
694: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 691: ,p_attribute21 in varchar2 default hr_api.g_varchar2

687: ,p_attribute17 in varchar2 default hr_api.g_varchar2
688: ,p_attribute18 in varchar2 default hr_api.g_varchar2
689: ,p_attribute19 in varchar2 default hr_api.g_varchar2
690: ,p_attribute20 in varchar2 default hr_api.g_varchar2
691: ,p_attribute21 in varchar2 default hr_api.g_varchar2
692: ,p_attribute22 in varchar2 default hr_api.g_varchar2
693: ,p_attribute23 in varchar2 default hr_api.g_varchar2
694: ,p_attribute24 in varchar2 default hr_api.g_varchar2
695: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 692: ,p_attribute22 in varchar2 default hr_api.g_varchar2

688: ,p_attribute18 in varchar2 default hr_api.g_varchar2
689: ,p_attribute19 in varchar2 default hr_api.g_varchar2
690: ,p_attribute20 in varchar2 default hr_api.g_varchar2
691: ,p_attribute21 in varchar2 default hr_api.g_varchar2
692: ,p_attribute22 in varchar2 default hr_api.g_varchar2
693: ,p_attribute23 in varchar2 default hr_api.g_varchar2
694: ,p_attribute24 in varchar2 default hr_api.g_varchar2
695: ,p_attribute25 in varchar2 default hr_api.g_varchar2
696: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 693: ,p_attribute23 in varchar2 default hr_api.g_varchar2

689: ,p_attribute19 in varchar2 default hr_api.g_varchar2
690: ,p_attribute20 in varchar2 default hr_api.g_varchar2
691: ,p_attribute21 in varchar2 default hr_api.g_varchar2
692: ,p_attribute22 in varchar2 default hr_api.g_varchar2
693: ,p_attribute23 in varchar2 default hr_api.g_varchar2
694: ,p_attribute24 in varchar2 default hr_api.g_varchar2
695: ,p_attribute25 in varchar2 default hr_api.g_varchar2
696: ,p_attribute26 in varchar2 default hr_api.g_varchar2
697: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 694: ,p_attribute24 in varchar2 default hr_api.g_varchar2

690: ,p_attribute20 in varchar2 default hr_api.g_varchar2
691: ,p_attribute21 in varchar2 default hr_api.g_varchar2
692: ,p_attribute22 in varchar2 default hr_api.g_varchar2
693: ,p_attribute23 in varchar2 default hr_api.g_varchar2
694: ,p_attribute24 in varchar2 default hr_api.g_varchar2
695: ,p_attribute25 in varchar2 default hr_api.g_varchar2
696: ,p_attribute26 in varchar2 default hr_api.g_varchar2
697: ,p_attribute27 in varchar2 default hr_api.g_varchar2
698: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 695: ,p_attribute25 in varchar2 default hr_api.g_varchar2

691: ,p_attribute21 in varchar2 default hr_api.g_varchar2
692: ,p_attribute22 in varchar2 default hr_api.g_varchar2
693: ,p_attribute23 in varchar2 default hr_api.g_varchar2
694: ,p_attribute24 in varchar2 default hr_api.g_varchar2
695: ,p_attribute25 in varchar2 default hr_api.g_varchar2
696: ,p_attribute26 in varchar2 default hr_api.g_varchar2
697: ,p_attribute27 in varchar2 default hr_api.g_varchar2
698: ,p_attribute28 in varchar2 default hr_api.g_varchar2
699: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 696: ,p_attribute26 in varchar2 default hr_api.g_varchar2

692: ,p_attribute22 in varchar2 default hr_api.g_varchar2
693: ,p_attribute23 in varchar2 default hr_api.g_varchar2
694: ,p_attribute24 in varchar2 default hr_api.g_varchar2
695: ,p_attribute25 in varchar2 default hr_api.g_varchar2
696: ,p_attribute26 in varchar2 default hr_api.g_varchar2
697: ,p_attribute27 in varchar2 default hr_api.g_varchar2
698: ,p_attribute28 in varchar2 default hr_api.g_varchar2
699: ,p_attribute29 in varchar2 default hr_api.g_varchar2
700: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 697: ,p_attribute27 in varchar2 default hr_api.g_varchar2

693: ,p_attribute23 in varchar2 default hr_api.g_varchar2
694: ,p_attribute24 in varchar2 default hr_api.g_varchar2
695: ,p_attribute25 in varchar2 default hr_api.g_varchar2
696: ,p_attribute26 in varchar2 default hr_api.g_varchar2
697: ,p_attribute27 in varchar2 default hr_api.g_varchar2
698: ,p_attribute28 in varchar2 default hr_api.g_varchar2
699: ,p_attribute29 in varchar2 default hr_api.g_varchar2
700: ,p_attribute30 in varchar2 default hr_api.g_varchar2
701: ) is

Line 698: ,p_attribute28 in varchar2 default hr_api.g_varchar2

694: ,p_attribute24 in varchar2 default hr_api.g_varchar2
695: ,p_attribute25 in varchar2 default hr_api.g_varchar2
696: ,p_attribute26 in varchar2 default hr_api.g_varchar2
697: ,p_attribute27 in varchar2 default hr_api.g_varchar2
698: ,p_attribute28 in varchar2 default hr_api.g_varchar2
699: ,p_attribute29 in varchar2 default hr_api.g_varchar2
700: ,p_attribute30 in varchar2 default hr_api.g_varchar2
701: ) is
702: --

Line 699: ,p_attribute29 in varchar2 default hr_api.g_varchar2

695: ,p_attribute25 in varchar2 default hr_api.g_varchar2
696: ,p_attribute26 in varchar2 default hr_api.g_varchar2
697: ,p_attribute27 in varchar2 default hr_api.g_varchar2
698: ,p_attribute28 in varchar2 default hr_api.g_varchar2
699: ,p_attribute29 in varchar2 default hr_api.g_varchar2
700: ,p_attribute30 in varchar2 default hr_api.g_varchar2
701: ) is
702: --
703: l_rec hxc_hav_shd.g_rec_type;

Line 700: ,p_attribute30 in varchar2 default hr_api.g_varchar2

696: ,p_attribute26 in varchar2 default hr_api.g_varchar2
697: ,p_attribute27 in varchar2 default hr_api.g_varchar2
698: ,p_attribute28 in varchar2 default hr_api.g_varchar2
699: ,p_attribute29 in varchar2 default hr_api.g_varchar2
700: ,p_attribute30 in varchar2 default hr_api.g_varchar2
701: ) is
702: --
703: l_rec hxc_hav_shd.g_rec_type;
704: l_proc varchar2(72);