122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
129: hr_oru_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
129: hr_oru_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
134: hr_oru_shd.constraint_error
127: -- A check constraint has been violated
128: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
129: hr_oru_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
134: hr_oru_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
134: hr_oru_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
139: hr_oru_shd.constraint_error
132: -- Parent integrity has been violated
133: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
134: hr_oru_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
139: hr_oru_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
139: hr_oru_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
143: Raise;
144: End update_dml;
421: );
422: --
423: exception
424: --
425: when hr_api.cannot_find_prog_unit then
426: --
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'HR_ALL_ORGANIZATION_UNITS'
429: ,p_hook_type => 'AU');
423: exception
424: --
425: when hr_api.cannot_find_prog_unit then
426: --
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'HR_ALL_ORGANIZATION_UNITS'
429: ,p_hook_type => 'AU');
430: --
431: end;
486: -- p_rec plsql record structure
487: -- to see if a system default is being used. If a system default
488: -- is being used then we must set to the 'current' argument value.
489: --
490: If (p_rec.business_group_id = hr_api.g_number) then
491: p_rec.business_group_id :=
492: hr_oru_shd.g_old_rec.business_group_id;
493: End If;
494: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
490: If (p_rec.business_group_id = hr_api.g_number) then
491: p_rec.business_group_id :=
492: hr_oru_shd.g_old_rec.business_group_id;
493: End If;
494: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
495: p_rec.cost_allocation_keyflex_id :=
496: hr_oru_shd.g_old_rec.cost_allocation_keyflex_id;
497: End If;
498: If (p_rec.location_id = hr_api.g_number) then
494: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
495: p_rec.cost_allocation_keyflex_id :=
496: hr_oru_shd.g_old_rec.cost_allocation_keyflex_id;
497: End If;
498: If (p_rec.location_id = hr_api.g_number) then
499: p_rec.location_id :=
500: hr_oru_shd.g_old_rec.location_id;
501: End If;
502: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
498: If (p_rec.location_id = hr_api.g_number) then
499: p_rec.location_id :=
500: hr_oru_shd.g_old_rec.location_id;
501: End If;
502: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
503: p_rec.soft_coding_keyflex_id :=
504: hr_oru_shd.g_old_rec.soft_coding_keyflex_id;
505: End If;
506: If (p_rec.date_from = hr_api.g_date) then
502: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
503: p_rec.soft_coding_keyflex_id :=
504: hr_oru_shd.g_old_rec.soft_coding_keyflex_id;
505: End If;
506: If (p_rec.date_from = hr_api.g_date) then
507: p_rec.date_from :=
508: hr_oru_shd.g_old_rec.date_from;
509: End If;
510: If (p_rec.name = hr_api.g_varchar2) then
506: If (p_rec.date_from = hr_api.g_date) then
507: p_rec.date_from :=
508: hr_oru_shd.g_old_rec.date_from;
509: End If;
510: If (p_rec.name = hr_api.g_varchar2) then
511: p_rec.name :=
512: hr_oru_shd.g_old_rec.name;
513: End If;
514: If (p_rec.comments = hr_api.g_varchar2) then
510: If (p_rec.name = hr_api.g_varchar2) then
511: p_rec.name :=
512: hr_oru_shd.g_old_rec.name;
513: End If;
514: If (p_rec.comments = hr_api.g_varchar2) then
515: p_rec.comments :=
516: hr_oru_shd.g_old_rec.comments;
517: End If;
518: If (p_rec.date_to = hr_api.g_date) then
514: If (p_rec.comments = hr_api.g_varchar2) then
515: p_rec.comments :=
516: hr_oru_shd.g_old_rec.comments;
517: End If;
518: If (p_rec.date_to = hr_api.g_date) then
519: p_rec.date_to :=
520: hr_oru_shd.g_old_rec.date_to;
521: End If;
522: If (p_rec.internal_external_flag = hr_api.g_varchar2) then
518: If (p_rec.date_to = hr_api.g_date) then
519: p_rec.date_to :=
520: hr_oru_shd.g_old_rec.date_to;
521: End If;
522: If (p_rec.internal_external_flag = hr_api.g_varchar2) then
523: p_rec.internal_external_flag :=
524: hr_oru_shd.g_old_rec.internal_external_flag;
525: End If;
526: If (p_rec.internal_address_line = hr_api.g_varchar2) then
522: If (p_rec.internal_external_flag = hr_api.g_varchar2) then
523: p_rec.internal_external_flag :=
524: hr_oru_shd.g_old_rec.internal_external_flag;
525: End If;
526: If (p_rec.internal_address_line = hr_api.g_varchar2) then
527: p_rec.internal_address_line :=
528: hr_oru_shd.g_old_rec.internal_address_line;
529: End If;
530: If (p_rec.type = hr_api.g_varchar2) then
526: If (p_rec.internal_address_line = hr_api.g_varchar2) then
527: p_rec.internal_address_line :=
528: hr_oru_shd.g_old_rec.internal_address_line;
529: End If;
530: If (p_rec.type = hr_api.g_varchar2) then
531: p_rec.type :=
532: hr_oru_shd.g_old_rec.type;
533: End If;
534: If (p_rec.request_id = hr_api.g_number) then
530: If (p_rec.type = hr_api.g_varchar2) then
531: p_rec.type :=
532: hr_oru_shd.g_old_rec.type;
533: End If;
534: If (p_rec.request_id = hr_api.g_number) then
535: p_rec.request_id :=
536: hr_oru_shd.g_old_rec.request_id;
537: End If;
538: If (p_rec.program_application_id = hr_api.g_number) then
534: If (p_rec.request_id = hr_api.g_number) then
535: p_rec.request_id :=
536: hr_oru_shd.g_old_rec.request_id;
537: End If;
538: If (p_rec.program_application_id = hr_api.g_number) then
539: p_rec.program_application_id :=
540: hr_oru_shd.g_old_rec.program_application_id;
541: End If;
542: If (p_rec.program_id = hr_api.g_number) then
538: If (p_rec.program_application_id = hr_api.g_number) then
539: p_rec.program_application_id :=
540: hr_oru_shd.g_old_rec.program_application_id;
541: End If;
542: If (p_rec.program_id = hr_api.g_number) then
543: p_rec.program_id :=
544: hr_oru_shd.g_old_rec.program_id;
545: End If;
546: If (p_rec.program_update_date = hr_api.g_date) then
542: If (p_rec.program_id = hr_api.g_number) then
543: p_rec.program_id :=
544: hr_oru_shd.g_old_rec.program_id;
545: End If;
546: If (p_rec.program_update_date = hr_api.g_date) then
547: p_rec.program_update_date :=
548: hr_oru_shd.g_old_rec.program_update_date;
549: End If;
550: If (p_rec.attribute_category = hr_api.g_varchar2) then
546: If (p_rec.program_update_date = hr_api.g_date) then
547: p_rec.program_update_date :=
548: hr_oru_shd.g_old_rec.program_update_date;
549: End If;
550: If (p_rec.attribute_category = hr_api.g_varchar2) then
551: p_rec.attribute_category :=
552: hr_oru_shd.g_old_rec.attribute_category;
553: End If;
554: If (p_rec.attribute1 = hr_api.g_varchar2) then
550: If (p_rec.attribute_category = hr_api.g_varchar2) then
551: p_rec.attribute_category :=
552: hr_oru_shd.g_old_rec.attribute_category;
553: End If;
554: If (p_rec.attribute1 = hr_api.g_varchar2) then
555: p_rec.attribute1 :=
556: hr_oru_shd.g_old_rec.attribute1;
557: End If;
558: If (p_rec.attribute2 = hr_api.g_varchar2) then
554: If (p_rec.attribute1 = hr_api.g_varchar2) then
555: p_rec.attribute1 :=
556: hr_oru_shd.g_old_rec.attribute1;
557: End If;
558: If (p_rec.attribute2 = hr_api.g_varchar2) then
559: p_rec.attribute2 :=
560: hr_oru_shd.g_old_rec.attribute2;
561: End If;
562: If (p_rec.attribute3 = hr_api.g_varchar2) then
558: If (p_rec.attribute2 = hr_api.g_varchar2) then
559: p_rec.attribute2 :=
560: hr_oru_shd.g_old_rec.attribute2;
561: End If;
562: If (p_rec.attribute3 = hr_api.g_varchar2) then
563: p_rec.attribute3 :=
564: hr_oru_shd.g_old_rec.attribute3;
565: End If;
566: If (p_rec.attribute4 = hr_api.g_varchar2) then
562: If (p_rec.attribute3 = hr_api.g_varchar2) then
563: p_rec.attribute3 :=
564: hr_oru_shd.g_old_rec.attribute3;
565: End If;
566: If (p_rec.attribute4 = hr_api.g_varchar2) then
567: p_rec.attribute4 :=
568: hr_oru_shd.g_old_rec.attribute4;
569: End If;
570: If (p_rec.attribute5 = hr_api.g_varchar2) then
566: If (p_rec.attribute4 = hr_api.g_varchar2) then
567: p_rec.attribute4 :=
568: hr_oru_shd.g_old_rec.attribute4;
569: End If;
570: If (p_rec.attribute5 = hr_api.g_varchar2) then
571: p_rec.attribute5 :=
572: hr_oru_shd.g_old_rec.attribute5;
573: End If;
574: If (p_rec.attribute6 = hr_api.g_varchar2) then
570: If (p_rec.attribute5 = hr_api.g_varchar2) then
571: p_rec.attribute5 :=
572: hr_oru_shd.g_old_rec.attribute5;
573: End If;
574: If (p_rec.attribute6 = hr_api.g_varchar2) then
575: p_rec.attribute6 :=
576: hr_oru_shd.g_old_rec.attribute6;
577: End If;
578: If (p_rec.attribute7 = hr_api.g_varchar2) then
574: If (p_rec.attribute6 = hr_api.g_varchar2) then
575: p_rec.attribute6 :=
576: hr_oru_shd.g_old_rec.attribute6;
577: End If;
578: If (p_rec.attribute7 = hr_api.g_varchar2) then
579: p_rec.attribute7 :=
580: hr_oru_shd.g_old_rec.attribute7;
581: End If;
582: If (p_rec.attribute8 = hr_api.g_varchar2) then
578: If (p_rec.attribute7 = hr_api.g_varchar2) then
579: p_rec.attribute7 :=
580: hr_oru_shd.g_old_rec.attribute7;
581: End If;
582: If (p_rec.attribute8 = hr_api.g_varchar2) then
583: p_rec.attribute8 :=
584: hr_oru_shd.g_old_rec.attribute8;
585: End If;
586: If (p_rec.attribute9 = hr_api.g_varchar2) then
582: If (p_rec.attribute8 = hr_api.g_varchar2) then
583: p_rec.attribute8 :=
584: hr_oru_shd.g_old_rec.attribute8;
585: End If;
586: If (p_rec.attribute9 = hr_api.g_varchar2) then
587: p_rec.attribute9 :=
588: hr_oru_shd.g_old_rec.attribute9;
589: End If;
590: If (p_rec.attribute10 = hr_api.g_varchar2) then
586: If (p_rec.attribute9 = hr_api.g_varchar2) then
587: p_rec.attribute9 :=
588: hr_oru_shd.g_old_rec.attribute9;
589: End If;
590: If (p_rec.attribute10 = hr_api.g_varchar2) then
591: p_rec.attribute10 :=
592: hr_oru_shd.g_old_rec.attribute10;
593: End If;
594: If (p_rec.attribute11 = hr_api.g_varchar2) then
590: If (p_rec.attribute10 = hr_api.g_varchar2) then
591: p_rec.attribute10 :=
592: hr_oru_shd.g_old_rec.attribute10;
593: End If;
594: If (p_rec.attribute11 = hr_api.g_varchar2) then
595: p_rec.attribute11 :=
596: hr_oru_shd.g_old_rec.attribute11;
597: End If;
598: If (p_rec.attribute12 = hr_api.g_varchar2) then
594: If (p_rec.attribute11 = hr_api.g_varchar2) then
595: p_rec.attribute11 :=
596: hr_oru_shd.g_old_rec.attribute11;
597: End If;
598: If (p_rec.attribute12 = hr_api.g_varchar2) then
599: p_rec.attribute12 :=
600: hr_oru_shd.g_old_rec.attribute12;
601: End If;
602: If (p_rec.attribute13 = hr_api.g_varchar2) then
598: If (p_rec.attribute12 = hr_api.g_varchar2) then
599: p_rec.attribute12 :=
600: hr_oru_shd.g_old_rec.attribute12;
601: End If;
602: If (p_rec.attribute13 = hr_api.g_varchar2) then
603: p_rec.attribute13 :=
604: hr_oru_shd.g_old_rec.attribute13;
605: End If;
606: If (p_rec.attribute14 = hr_api.g_varchar2) then
602: If (p_rec.attribute13 = hr_api.g_varchar2) then
603: p_rec.attribute13 :=
604: hr_oru_shd.g_old_rec.attribute13;
605: End If;
606: If (p_rec.attribute14 = hr_api.g_varchar2) then
607: p_rec.attribute14 :=
608: hr_oru_shd.g_old_rec.attribute14;
609: End If;
610: If (p_rec.attribute15 = hr_api.g_varchar2) then
606: If (p_rec.attribute14 = hr_api.g_varchar2) then
607: p_rec.attribute14 :=
608: hr_oru_shd.g_old_rec.attribute14;
609: End If;
610: If (p_rec.attribute15 = hr_api.g_varchar2) then
611: p_rec.attribute15 :=
612: hr_oru_shd.g_old_rec.attribute15;
613: End If;
614: If (p_rec.attribute16 = hr_api.g_varchar2) then
610: If (p_rec.attribute15 = hr_api.g_varchar2) then
611: p_rec.attribute15 :=
612: hr_oru_shd.g_old_rec.attribute15;
613: End If;
614: If (p_rec.attribute16 = hr_api.g_varchar2) then
615: p_rec.attribute16 :=
616: hr_oru_shd.g_old_rec.attribute16;
617: End If;
618: If (p_rec.attribute17 = hr_api.g_varchar2) then
614: If (p_rec.attribute16 = hr_api.g_varchar2) then
615: p_rec.attribute16 :=
616: hr_oru_shd.g_old_rec.attribute16;
617: End If;
618: If (p_rec.attribute17 = hr_api.g_varchar2) then
619: p_rec.attribute17 :=
620: hr_oru_shd.g_old_rec.attribute17;
621: End If;
622: If (p_rec.attribute18 = hr_api.g_varchar2) then
618: If (p_rec.attribute17 = hr_api.g_varchar2) then
619: p_rec.attribute17 :=
620: hr_oru_shd.g_old_rec.attribute17;
621: End If;
622: If (p_rec.attribute18 = hr_api.g_varchar2) then
623: p_rec.attribute18 :=
624: hr_oru_shd.g_old_rec.attribute18;
625: End If;
626: If (p_rec.attribute19 = hr_api.g_varchar2) then
622: If (p_rec.attribute18 = hr_api.g_varchar2) then
623: p_rec.attribute18 :=
624: hr_oru_shd.g_old_rec.attribute18;
625: End If;
626: If (p_rec.attribute19 = hr_api.g_varchar2) then
627: p_rec.attribute19 :=
628: hr_oru_shd.g_old_rec.attribute19;
629: End If;
630: If (p_rec.attribute20 = hr_api.g_varchar2) then
626: If (p_rec.attribute19 = hr_api.g_varchar2) then
627: p_rec.attribute19 :=
628: hr_oru_shd.g_old_rec.attribute19;
629: End If;
630: If (p_rec.attribute20 = hr_api.g_varchar2) then
631: p_rec.attribute20 :=
632: hr_oru_shd.g_old_rec.attribute20;
633: End If;
634: --Enhancement 4040086
631: p_rec.attribute20 :=
632: hr_oru_shd.g_old_rec.attribute20;
633: End If;
634: --Enhancement 4040086
635: If (p_rec.attribute21 = hr_api.g_varchar2) then
636: p_rec.attribute21 :=
637: hr_oru_shd.g_old_rec.attribute21;
638: End If;
639: If (p_rec.attribute22 = hr_api.g_varchar2) then
635: If (p_rec.attribute21 = hr_api.g_varchar2) then
636: p_rec.attribute21 :=
637: hr_oru_shd.g_old_rec.attribute21;
638: End If;
639: If (p_rec.attribute22 = hr_api.g_varchar2) then
640: p_rec.attribute22 :=
641: hr_oru_shd.g_old_rec.attribute22;
642: End If;
643: If (p_rec.attribute23 = hr_api.g_varchar2) then
639: If (p_rec.attribute22 = hr_api.g_varchar2) then
640: p_rec.attribute22 :=
641: hr_oru_shd.g_old_rec.attribute22;
642: End If;
643: If (p_rec.attribute23 = hr_api.g_varchar2) then
644: p_rec.attribute23 :=
645: hr_oru_shd.g_old_rec.attribute23;
646: End If;
647: If (p_rec.attribute24 = hr_api.g_varchar2) then
643: If (p_rec.attribute23 = hr_api.g_varchar2) then
644: p_rec.attribute23 :=
645: hr_oru_shd.g_old_rec.attribute23;
646: End If;
647: If (p_rec.attribute24 = hr_api.g_varchar2) then
648: p_rec.attribute24 :=
649: hr_oru_shd.g_old_rec.attribute24;
650: End If;
651: If (p_rec.attribute25 = hr_api.g_varchar2) then
647: If (p_rec.attribute24 = hr_api.g_varchar2) then
648: p_rec.attribute24 :=
649: hr_oru_shd.g_old_rec.attribute24;
650: End If;
651: If (p_rec.attribute25 = hr_api.g_varchar2) then
652: p_rec.attribute25 :=
653: hr_oru_shd.g_old_rec.attribute25;
654: End If;
655: If (p_rec.attribute26 = hr_api.g_varchar2) then
651: If (p_rec.attribute25 = hr_api.g_varchar2) then
652: p_rec.attribute25 :=
653: hr_oru_shd.g_old_rec.attribute25;
654: End If;
655: If (p_rec.attribute26 = hr_api.g_varchar2) then
656: p_rec.attribute26 :=
657: hr_oru_shd.g_old_rec.attribute26;
658: End If;
659: If (p_rec.attribute27 = hr_api.g_varchar2) then
655: If (p_rec.attribute26 = hr_api.g_varchar2) then
656: p_rec.attribute26 :=
657: hr_oru_shd.g_old_rec.attribute26;
658: End If;
659: If (p_rec.attribute27 = hr_api.g_varchar2) then
660: p_rec.attribute27 :=
661: hr_oru_shd.g_old_rec.attribute27;
662: End If;
663: If (p_rec.attribute28 = hr_api.g_varchar2) then
659: If (p_rec.attribute27 = hr_api.g_varchar2) then
660: p_rec.attribute27 :=
661: hr_oru_shd.g_old_rec.attribute27;
662: End If;
663: If (p_rec.attribute28 = hr_api.g_varchar2) then
664: p_rec.attribute28 :=
665: hr_oru_shd.g_old_rec.attribute28;
666: End If;
667: If (p_rec.attribute29 = hr_api.g_varchar2) then
663: If (p_rec.attribute28 = hr_api.g_varchar2) then
664: p_rec.attribute28 :=
665: hr_oru_shd.g_old_rec.attribute28;
666: End If;
667: If (p_rec.attribute29 = hr_api.g_varchar2) then
668: p_rec.attribute29 :=
669: hr_oru_shd.g_old_rec.attribute29;
670: End If;
671: If (p_rec.attribute30 = hr_api.g_varchar2) then
667: If (p_rec.attribute29 = hr_api.g_varchar2) then
668: p_rec.attribute29 :=
669: hr_oru_shd.g_old_rec.attribute29;
670: End If;
671: If (p_rec.attribute30 = hr_api.g_varchar2) then
672: p_rec.attribute30 :=
673: hr_oru_shd.g_old_rec.attribute30;
674: End If;
675: --End Enhancement 4040086
732: Procedure upd
733: (p_effective_date in date
734: ,p_organization_id in number
735: ,p_object_version_number in out nocopy number
736: ,p_business_group_id in number default hr_api.g_number
737: ,p_date_from in date default hr_api.g_date
738: ,p_name in varchar2 default hr_api.g_varchar2
739: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
740: ,p_location_id in number default hr_api.g_number
733: (p_effective_date in date
734: ,p_organization_id in number
735: ,p_object_version_number in out nocopy number
736: ,p_business_group_id in number default hr_api.g_number
737: ,p_date_from in date default hr_api.g_date
738: ,p_name in varchar2 default hr_api.g_varchar2
739: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
740: ,p_location_id in number default hr_api.g_number
741: -- Bug 3040119
734: ,p_organization_id in number
735: ,p_object_version_number in out nocopy number
736: ,p_business_group_id in number default hr_api.g_number
737: ,p_date_from in date default hr_api.g_date
738: ,p_name in varchar2 default hr_api.g_varchar2
739: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
740: ,p_location_id in number default hr_api.g_number
741: -- Bug 3040119
742: --,p_soft_coding_keyflex_id in number default hr_api.g_number
735: ,p_object_version_number in out nocopy number
736: ,p_business_group_id in number default hr_api.g_number
737: ,p_date_from in date default hr_api.g_date
738: ,p_name in varchar2 default hr_api.g_varchar2
739: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
740: ,p_location_id in number default hr_api.g_number
741: -- Bug 3040119
742: --,p_soft_coding_keyflex_id in number default hr_api.g_number
743: ,p_date_to in date default hr_api.g_date
736: ,p_business_group_id in number default hr_api.g_number
737: ,p_date_from in date default hr_api.g_date
738: ,p_name in varchar2 default hr_api.g_varchar2
739: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
740: ,p_location_id in number default hr_api.g_number
741: -- Bug 3040119
742: --,p_soft_coding_keyflex_id in number default hr_api.g_number
743: ,p_date_to in date default hr_api.g_date
744: ,p_internal_external_flag in varchar2 default hr_api.g_varchar2
738: ,p_name in varchar2 default hr_api.g_varchar2
739: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
740: ,p_location_id in number default hr_api.g_number
741: -- Bug 3040119
742: --,p_soft_coding_keyflex_id in number default hr_api.g_number
743: ,p_date_to in date default hr_api.g_date
744: ,p_internal_external_flag in varchar2 default hr_api.g_varchar2
745: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
746: ,p_type in varchar2 default hr_api.g_varchar2
739: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
740: ,p_location_id in number default hr_api.g_number
741: -- Bug 3040119
742: --,p_soft_coding_keyflex_id in number default hr_api.g_number
743: ,p_date_to in date default hr_api.g_date
744: ,p_internal_external_flag in varchar2 default hr_api.g_varchar2
745: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
746: ,p_type in varchar2 default hr_api.g_varchar2
747: ,p_comments in varchar2 default hr_api.g_varchar2
740: ,p_location_id in number default hr_api.g_number
741: -- Bug 3040119
742: --,p_soft_coding_keyflex_id in number default hr_api.g_number
743: ,p_date_to in date default hr_api.g_date
744: ,p_internal_external_flag in varchar2 default hr_api.g_varchar2
745: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
746: ,p_type in varchar2 default hr_api.g_varchar2
747: ,p_comments in varchar2 default hr_api.g_varchar2
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
741: -- Bug 3040119
742: --,p_soft_coding_keyflex_id in number default hr_api.g_number
743: ,p_date_to in date default hr_api.g_date
744: ,p_internal_external_flag in varchar2 default hr_api.g_varchar2
745: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
746: ,p_type in varchar2 default hr_api.g_varchar2
747: ,p_comments in varchar2 default hr_api.g_varchar2
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
742: --,p_soft_coding_keyflex_id in number default hr_api.g_number
743: ,p_date_to in date default hr_api.g_date
744: ,p_internal_external_flag in varchar2 default hr_api.g_varchar2
745: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
746: ,p_type in varchar2 default hr_api.g_varchar2
747: ,p_comments in varchar2 default hr_api.g_varchar2
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
743: ,p_date_to in date default hr_api.g_date
744: ,p_internal_external_flag in varchar2 default hr_api.g_varchar2
745: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
746: ,p_type in varchar2 default hr_api.g_varchar2
747: ,p_comments in varchar2 default hr_api.g_varchar2
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
744: ,p_internal_external_flag in varchar2 default hr_api.g_varchar2
745: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
746: ,p_type in varchar2 default hr_api.g_varchar2
747: ,p_comments in varchar2 default hr_api.g_varchar2
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
745: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
746: ,p_type in varchar2 default hr_api.g_varchar2
747: ,p_comments in varchar2 default hr_api.g_varchar2
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
746: ,p_type in varchar2 default hr_api.g_varchar2
747: ,p_comments in varchar2 default hr_api.g_varchar2
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
747: ,p_comments in varchar2 default hr_api.g_varchar2
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
748: ,p_attribute_category in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
749: ,p_attribute1 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
750: ,p_attribute2 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
751: ,p_attribute3 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
752: ,p_attribute4 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
753: ,p_attribute5 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
754: ,p_attribute6 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
755: ,p_attribute7 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
756: ,p_attribute8 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
757: ,p_attribute9 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
758: ,p_attribute10 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
759: ,p_attribute11 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
760: ,p_attribute12 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
761: ,p_attribute13 in varchar2 default hr_api.g_varchar2
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: --Enhancement 4040086
762: ,p_attribute14 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: --Enhancement 4040086
770: ,p_attribute21 in varchar2 default hr_api.g_varchar2
763: ,p_attribute15 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: --Enhancement 4040086
770: ,p_attribute21 in varchar2 default hr_api.g_varchar2
771: ,p_attribute22 in varchar2 default hr_api.g_varchar2
764: ,p_attribute16 in varchar2 default hr_api.g_varchar2
765: ,p_attribute17 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: --Enhancement 4040086
770: ,p_attribute21 in varchar2 default hr_api.g_varchar2
771: ,p_attribute22 in varchar2 default hr_api.g_varchar2
772: ,p_attribute23 in varchar2 default hr_api.g_varchar2
766: ,p_attribute18 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: --Enhancement 4040086
770: ,p_attribute21 in varchar2 default hr_api.g_varchar2
771: ,p_attribute22 in varchar2 default hr_api.g_varchar2
772: ,p_attribute23 in varchar2 default hr_api.g_varchar2
773: ,p_attribute24 in varchar2 default hr_api.g_varchar2
774: ,p_attribute25 in varchar2 default hr_api.g_varchar2
767: ,p_attribute19 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: --Enhancement 4040086
770: ,p_attribute21 in varchar2 default hr_api.g_varchar2
771: ,p_attribute22 in varchar2 default hr_api.g_varchar2
772: ,p_attribute23 in varchar2 default hr_api.g_varchar2
773: ,p_attribute24 in varchar2 default hr_api.g_varchar2
774: ,p_attribute25 in varchar2 default hr_api.g_varchar2
775: ,p_attribute26 in varchar2 default hr_api.g_varchar2
768: ,p_attribute20 in varchar2 default hr_api.g_varchar2
769: --Enhancement 4040086
770: ,p_attribute21 in varchar2 default hr_api.g_varchar2
771: ,p_attribute22 in varchar2 default hr_api.g_varchar2
772: ,p_attribute23 in varchar2 default hr_api.g_varchar2
773: ,p_attribute24 in varchar2 default hr_api.g_varchar2
774: ,p_attribute25 in varchar2 default hr_api.g_varchar2
775: ,p_attribute26 in varchar2 default hr_api.g_varchar2
776: ,p_attribute27 in varchar2 default hr_api.g_varchar2
769: --Enhancement 4040086
770: ,p_attribute21 in varchar2 default hr_api.g_varchar2
771: ,p_attribute22 in varchar2 default hr_api.g_varchar2
772: ,p_attribute23 in varchar2 default hr_api.g_varchar2
773: ,p_attribute24 in varchar2 default hr_api.g_varchar2
774: ,p_attribute25 in varchar2 default hr_api.g_varchar2
775: ,p_attribute26 in varchar2 default hr_api.g_varchar2
776: ,p_attribute27 in varchar2 default hr_api.g_varchar2
777: ,p_attribute28 in varchar2 default hr_api.g_varchar2
770: ,p_attribute21 in varchar2 default hr_api.g_varchar2
771: ,p_attribute22 in varchar2 default hr_api.g_varchar2
772: ,p_attribute23 in varchar2 default hr_api.g_varchar2
773: ,p_attribute24 in varchar2 default hr_api.g_varchar2
774: ,p_attribute25 in varchar2 default hr_api.g_varchar2
775: ,p_attribute26 in varchar2 default hr_api.g_varchar2
776: ,p_attribute27 in varchar2 default hr_api.g_varchar2
777: ,p_attribute28 in varchar2 default hr_api.g_varchar2
778: ,p_attribute29 in varchar2 default hr_api.g_varchar2
771: ,p_attribute22 in varchar2 default hr_api.g_varchar2
772: ,p_attribute23 in varchar2 default hr_api.g_varchar2
773: ,p_attribute24 in varchar2 default hr_api.g_varchar2
774: ,p_attribute25 in varchar2 default hr_api.g_varchar2
775: ,p_attribute26 in varchar2 default hr_api.g_varchar2
776: ,p_attribute27 in varchar2 default hr_api.g_varchar2
777: ,p_attribute28 in varchar2 default hr_api.g_varchar2
778: ,p_attribute29 in varchar2 default hr_api.g_varchar2
779: ,p_attribute30 in varchar2 default hr_api.g_varchar2
772: ,p_attribute23 in varchar2 default hr_api.g_varchar2
773: ,p_attribute24 in varchar2 default hr_api.g_varchar2
774: ,p_attribute25 in varchar2 default hr_api.g_varchar2
775: ,p_attribute26 in varchar2 default hr_api.g_varchar2
776: ,p_attribute27 in varchar2 default hr_api.g_varchar2
777: ,p_attribute28 in varchar2 default hr_api.g_varchar2
778: ,p_attribute29 in varchar2 default hr_api.g_varchar2
779: ,p_attribute30 in varchar2 default hr_api.g_varchar2
780: --End Enhancement 4040086
773: ,p_attribute24 in varchar2 default hr_api.g_varchar2
774: ,p_attribute25 in varchar2 default hr_api.g_varchar2
775: ,p_attribute26 in varchar2 default hr_api.g_varchar2
776: ,p_attribute27 in varchar2 default hr_api.g_varchar2
777: ,p_attribute28 in varchar2 default hr_api.g_varchar2
778: ,p_attribute29 in varchar2 default hr_api.g_varchar2
779: ,p_attribute30 in varchar2 default hr_api.g_varchar2
780: --End Enhancement 4040086
781: ,p_duplicate_org_warning out nocopy boolean
774: ,p_attribute25 in varchar2 default hr_api.g_varchar2
775: ,p_attribute26 in varchar2 default hr_api.g_varchar2
776: ,p_attribute27 in varchar2 default hr_api.g_varchar2
777: ,p_attribute28 in varchar2 default hr_api.g_varchar2
778: ,p_attribute29 in varchar2 default hr_api.g_varchar2
779: ,p_attribute30 in varchar2 default hr_api.g_varchar2
780: --End Enhancement 4040086
781: ,p_duplicate_org_warning out nocopy boolean
782: ) is
775: ,p_attribute26 in varchar2 default hr_api.g_varchar2
776: ,p_attribute27 in varchar2 default hr_api.g_varchar2
777: ,p_attribute28 in varchar2 default hr_api.g_varchar2
778: ,p_attribute29 in varchar2 default hr_api.g_varchar2
779: ,p_attribute30 in varchar2 default hr_api.g_varchar2
780: --End Enhancement 4040086
781: ,p_duplicate_org_warning out nocopy boolean
782: ) is
783: --
805: ,p_date_to
806: ,p_internal_external_flag
807: ,p_internal_address_line
808: ,p_type
809: ,hr_api.g_number
810: ,hr_api.g_number
811: ,hr_api.g_number
812: ,hr_api.g_date
813: ,p_attribute_category
806: ,p_internal_external_flag
807: ,p_internal_address_line
808: ,p_type
809: ,hr_api.g_number
810: ,hr_api.g_number
811: ,hr_api.g_number
812: ,hr_api.g_date
813: ,p_attribute_category
814: ,p_attribute1
807: ,p_internal_address_line
808: ,p_type
809: ,hr_api.g_number
810: ,hr_api.g_number
811: ,hr_api.g_number
812: ,hr_api.g_date
813: ,p_attribute_category
814: ,p_attribute1
815: ,p_attribute2
808: ,p_type
809: ,hr_api.g_number
810: ,hr_api.g_number
811: ,hr_api.g_number
812: ,hr_api.g_date
813: ,p_attribute_category
814: ,p_attribute1
815: ,p_attribute2
816: ,p_attribute3