121: ,p_effective_date => trunc(p_effective_date));
122: --
123: exception
124: --
125: when hr_api.cannot_find_prog_unit then
126: --
127: hr_api.cannot_find_prog_unit_error
128: (p_module_name => 'CREATE_PER_CM_USG'
129: ,p_hook_type => 'BP');
123: exception
124: --
125: when hr_api.cannot_find_prog_unit then
126: --
127: hr_api.cannot_find_prog_unit_error
128: (p_module_name => 'CREATE_PER_CM_USG'
129: ,p_hook_type => 'BP');
130: --
131: -- End of API User Hook for the before hook of create_PER_CM_USG
227: ,p_effective_date => trunc(p_effective_date));
228: --
229: exception
230: --
231: when hr_api.cannot_find_prog_unit then
232: --
233: hr_api.cannot_find_prog_unit_error
234: (p_module_name => 'CREATE_PER_CM_USG'
235: ,p_hook_type => 'AP');
229: exception
230: --
231: when hr_api.cannot_find_prog_unit then
232: --
233: hr_api.cannot_find_prog_unit_error
234: (p_module_name => 'CREATE_PER_CM_USG'
235: ,p_hook_type => 'AP');
236: --
237: -- End of API User Hook for the after hook of create_PER_CM_USG
242: --
243: -- When in validation only mode raise the Validate_Enabled exception
244: --
245: if p_validate then
246: raise hr_api.validate_enabled;
247: end if;
248: --
249: -- Set all output arguments
250: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: --
258: exception
259: --
260: when hr_api.validate_enabled then
261: --
262: -- As the Validate_Enabled exception has been raised
263: -- we must rollback to the savepoint
264: --
408: ,p_effective_date => trunc(p_effective_date));
409: --
410: exception
411: --
412: when hr_api.cannot_find_prog_unit then
413: --
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'CREATE_PER_CM_USG'
416: ,p_hook_type => 'BP');
410: exception
411: --
412: when hr_api.cannot_find_prog_unit then
413: --
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'CREATE_PER_CM_USG'
416: ,p_hook_type => 'BP');
417: --
418: -- End of API User Hook for the before hook of create_PER_CM_USG
586: ,p_validation_end_date =>l_validation_end_date);
587: --
588: exception
589: --
590: when hr_api.cannot_find_prog_unit then
591: --
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'ben_per_cm_usg_f'
594: ,p_hook_type => 'AI');
588: exception
589: --
590: when hr_api.cannot_find_prog_unit then
591: --
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'ben_per_cm_usg_f'
594: ,p_hook_type => 'AI');
595: --
596: end;
647: ,p_effective_date => trunc(p_effective_date));
648: --
649: exception
650: --
651: when hr_api.cannot_find_prog_unit then
652: --
653: hr_api.cannot_find_prog_unit_error
654: (p_module_name => 'CREATE_PER_CM_USG'
655: ,p_hook_type => 'AP');
649: exception
650: --
651: when hr_api.cannot_find_prog_unit then
652: --
653: hr_api.cannot_find_prog_unit_error
654: (p_module_name => 'CREATE_PER_CM_USG'
655: ,p_hook_type => 'AP');
656: --
657: -- End of API User Hook for the after hook of create_PER_CM_USG
660: --
661: -- When in validation only mode raise the Validate_Enabled exception
662: --
663: if p_validate then
664: raise hr_api.validate_enabled;
665: end if;
666: --
667: -- Set all output arguments
668: --
672: p_object_version_number := l_object_version_number;
673: --
674: exception
675: --
676: when hr_api.validate_enabled then
677: --
678: -- As the Validate_Enabled exception has been raised
679: -- we must rollback to the savepoint
680: --
711: (p_validate in boolean default false
712: ,p_per_cm_usg_id in number
713: ,p_effective_start_date out nocopy date
714: ,p_effective_end_date out nocopy date
715: ,p_per_cm_id in number default hr_api.g_number
716: ,p_cm_typ_usg_id in number default hr_api.g_number
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_pcu_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcu_attribute1 in varchar2 default hr_api.g_varchar2
712: ,p_per_cm_usg_id in number
713: ,p_effective_start_date out nocopy date
714: ,p_effective_end_date out nocopy date
715: ,p_per_cm_id in number default hr_api.g_number
716: ,p_cm_typ_usg_id in number default hr_api.g_number
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_pcu_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcu_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcu_attribute2 in varchar2 default hr_api.g_varchar2
713: ,p_effective_start_date out nocopy date
714: ,p_effective_end_date out nocopy date
715: ,p_per_cm_id in number default hr_api.g_number
716: ,p_cm_typ_usg_id in number default hr_api.g_number
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_pcu_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcu_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcu_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcu_attribute3 in varchar2 default hr_api.g_varchar2
714: ,p_effective_end_date out nocopy date
715: ,p_per_cm_id in number default hr_api.g_number
716: ,p_cm_typ_usg_id in number default hr_api.g_number
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_pcu_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcu_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcu_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcu_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcu_attribute4 in varchar2 default hr_api.g_varchar2
715: ,p_per_cm_id in number default hr_api.g_number
716: ,p_cm_typ_usg_id in number default hr_api.g_number
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_pcu_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcu_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcu_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcu_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcu_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcu_attribute5 in varchar2 default hr_api.g_varchar2
716: ,p_cm_typ_usg_id in number default hr_api.g_number
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_pcu_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcu_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcu_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcu_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcu_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcu_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcu_attribute6 in varchar2 default hr_api.g_varchar2
717: ,p_business_group_id in number default hr_api.g_number
718: ,p_pcu_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcu_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcu_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcu_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcu_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcu_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcu_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcu_attribute7 in varchar2 default hr_api.g_varchar2
718: ,p_pcu_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcu_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcu_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcu_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcu_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcu_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcu_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcu_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcu_attribute8 in varchar2 default hr_api.g_varchar2
719: ,p_pcu_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcu_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcu_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcu_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcu_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcu_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcu_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcu_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcu_attribute9 in varchar2 default hr_api.g_varchar2
720: ,p_pcu_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcu_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcu_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcu_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcu_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcu_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcu_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcu_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcu_attribute10 in varchar2 default hr_api.g_varchar2
721: ,p_pcu_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcu_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcu_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcu_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcu_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcu_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcu_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcu_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcu_attribute11 in varchar2 default hr_api.g_varchar2
722: ,p_pcu_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcu_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcu_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcu_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcu_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcu_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcu_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcu_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcu_attribute12 in varchar2 default hr_api.g_varchar2
723: ,p_pcu_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcu_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcu_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcu_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcu_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcu_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcu_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcu_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcu_attribute13 in varchar2 default hr_api.g_varchar2
724: ,p_pcu_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcu_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcu_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcu_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcu_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcu_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcu_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcu_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcu_attribute14 in varchar2 default hr_api.g_varchar2
725: ,p_pcu_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcu_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcu_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcu_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcu_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcu_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcu_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcu_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcu_attribute15 in varchar2 default hr_api.g_varchar2
726: ,p_pcu_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcu_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcu_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcu_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcu_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcu_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcu_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcu_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcu_attribute16 in varchar2 default hr_api.g_varchar2
727: ,p_pcu_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcu_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcu_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcu_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcu_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcu_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcu_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcu_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcu_attribute17 in varchar2 default hr_api.g_varchar2
728: ,p_pcu_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcu_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcu_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcu_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcu_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcu_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcu_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcu_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcu_attribute18 in varchar2 default hr_api.g_varchar2
729: ,p_pcu_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcu_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcu_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcu_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcu_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcu_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcu_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcu_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcu_attribute19 in varchar2 default hr_api.g_varchar2
730: ,p_pcu_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcu_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcu_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcu_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcu_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcu_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcu_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcu_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcu_attribute20 in varchar2 default hr_api.g_varchar2
731: ,p_pcu_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcu_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcu_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcu_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcu_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcu_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcu_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcu_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcu_attribute21 in varchar2 default hr_api.g_varchar2
732: ,p_pcu_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcu_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcu_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcu_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcu_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcu_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcu_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcu_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcu_attribute22 in varchar2 default hr_api.g_varchar2
733: ,p_pcu_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcu_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcu_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcu_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcu_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcu_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcu_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcu_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcu_attribute23 in varchar2 default hr_api.g_varchar2
734: ,p_pcu_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcu_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcu_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcu_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcu_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcu_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcu_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcu_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcu_attribute24 in varchar2 default hr_api.g_varchar2
735: ,p_pcu_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcu_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcu_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcu_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcu_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcu_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcu_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcu_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcu_attribute25 in varchar2 default hr_api.g_varchar2
736: ,p_pcu_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcu_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcu_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcu_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcu_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcu_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcu_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcu_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcu_attribute26 in varchar2 default hr_api.g_varchar2
737: ,p_pcu_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcu_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcu_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcu_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcu_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcu_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcu_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcu_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcu_attribute27 in varchar2 default hr_api.g_varchar2
738: ,p_pcu_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcu_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcu_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcu_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcu_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcu_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcu_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcu_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcu_attribute28 in varchar2 default hr_api.g_varchar2
739: ,p_pcu_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcu_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcu_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcu_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcu_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcu_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcu_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcu_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcu_attribute29 in varchar2 default hr_api.g_varchar2
740: ,p_pcu_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcu_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcu_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcu_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcu_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcu_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcu_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcu_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcu_attribute30 in varchar2 default hr_api.g_varchar2
741: ,p_pcu_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcu_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcu_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcu_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcu_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcu_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcu_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcu_attribute30 in varchar2 default hr_api.g_varchar2
749: ,p_request_id in number default hr_api.g_number
742: ,p_pcu_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcu_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcu_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcu_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcu_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcu_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcu_attribute30 in varchar2 default hr_api.g_varchar2
749: ,p_request_id in number default hr_api.g_number
750: ,p_program_application_id in number default hr_api.g_number
743: ,p_pcu_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcu_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcu_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcu_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcu_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcu_attribute30 in varchar2 default hr_api.g_varchar2
749: ,p_request_id in number default hr_api.g_number
750: ,p_program_application_id in number default hr_api.g_number
751: ,p_program_id in number default hr_api.g_number
744: ,p_pcu_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcu_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcu_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcu_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcu_attribute30 in varchar2 default hr_api.g_varchar2
749: ,p_request_id in number default hr_api.g_number
750: ,p_program_application_id in number default hr_api.g_number
751: ,p_program_id in number default hr_api.g_number
752: ,p_program_update_date in date default hr_api.g_date
745: ,p_pcu_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcu_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcu_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcu_attribute30 in varchar2 default hr_api.g_varchar2
749: ,p_request_id in number default hr_api.g_number
750: ,p_program_application_id in number default hr_api.g_number
751: ,p_program_id in number default hr_api.g_number
752: ,p_program_update_date in date default hr_api.g_date
753: ,p_object_version_number in out nocopy number
746: ,p_pcu_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcu_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcu_attribute30 in varchar2 default hr_api.g_varchar2
749: ,p_request_id in number default hr_api.g_number
750: ,p_program_application_id in number default hr_api.g_number
751: ,p_program_id in number default hr_api.g_number
752: ,p_program_update_date in date default hr_api.g_date
753: ,p_object_version_number in out nocopy number
754: ,p_effective_date in date
747: ,p_pcu_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcu_attribute30 in varchar2 default hr_api.g_varchar2
749: ,p_request_id in number default hr_api.g_number
750: ,p_program_application_id in number default hr_api.g_number
751: ,p_program_id in number default hr_api.g_number
752: ,p_program_update_date in date default hr_api.g_date
753: ,p_object_version_number in out nocopy number
754: ,p_effective_date in date
755: ,p_datetrack_mode in varchar2) is
748: ,p_pcu_attribute30 in varchar2 default hr_api.g_varchar2
749: ,p_request_id in number default hr_api.g_number
750: ,p_program_application_id in number default hr_api.g_number
751: ,p_program_id in number default hr_api.g_number
752: ,p_program_update_date in date default hr_api.g_date
753: ,p_object_version_number in out nocopy number
754: ,p_effective_date in date
755: ,p_datetrack_mode in varchar2) is
756: --
824: ,p_datetrack_mode => p_datetrack_mode);
825: --
826: exception
827: --
828: when hr_api.cannot_find_prog_unit then
829: --
830: hr_api.cannot_find_prog_unit_error
831: (p_module_name => 'UPDATE_PER_CM_USG'
832: ,p_hook_type => 'BP');
826: exception
827: --
828: when hr_api.cannot_find_prog_unit then
829: --
830: hr_api.cannot_find_prog_unit_error
831: (p_module_name => 'UPDATE_PER_CM_USG'
832: ,p_hook_type => 'BP');
833: --
834: -- End of API User Hook for the before hook of update_PER_CM_USG
932: ,p_datetrack_mode => p_datetrack_mode);
933: --
934: exception
935: --
936: when hr_api.cannot_find_prog_unit then
937: --
938: hr_api.cannot_find_prog_unit_error
939: (p_module_name => 'UPDATE_PER_CM_USG'
940: ,p_hook_type => 'AP');
934: exception
935: --
936: when hr_api.cannot_find_prog_unit then
937: --
938: hr_api.cannot_find_prog_unit_error
939: (p_module_name => 'UPDATE_PER_CM_USG'
940: ,p_hook_type => 'AP');
941: --
942: -- End of API User Hook for the after hook of update_PER_CM_USG
947: --
948: -- When in validation only mode raise the Validate_Enabled exception
949: --
950: if p_validate then
951: raise hr_api.validate_enabled;
952: end if;
953: --
954: -- Set all output arguments
955: --
960: hr_utility.set_location(' Leaving:'||l_proc, 70);
961: --
962: exception
963: --
964: when hr_api.validate_enabled then
965: --
966: -- As the Validate_Enabled exception has been raised
967: -- we must rollback to the savepoint
968: --
1033: ,p_datetrack_mode => p_datetrack_mode);
1034: --
1035: exception
1036: --
1037: when hr_api.cannot_find_prog_unit then
1038: --
1039: hr_api.cannot_find_prog_unit_error
1040: (p_module_name => 'DELETE_PER_CM_USG'
1041: ,p_hook_type => 'BP');
1035: exception
1036: --
1037: when hr_api.cannot_find_prog_unit then
1038: --
1039: hr_api.cannot_find_prog_unit_error
1040: (p_module_name => 'DELETE_PER_CM_USG'
1041: ,p_hook_type => 'BP');
1042: --
1043: -- End of API User Hook for the before hook of delete_PER_CM_USG
1065: ,p_datetrack_mode => p_datetrack_mode);
1066: --
1067: exception
1068: --
1069: when hr_api.cannot_find_prog_unit then
1070: --
1071: hr_api.cannot_find_prog_unit_error
1072: (p_module_name => 'DELETE_PER_CM_USG'
1073: ,p_hook_type => 'AP');
1067: exception
1068: --
1069: when hr_api.cannot_find_prog_unit then
1070: --
1071: hr_api.cannot_find_prog_unit_error
1072: (p_module_name => 'DELETE_PER_CM_USG'
1073: ,p_hook_type => 'AP');
1074: --
1075: -- End of API User Hook for the after hook of delete_PER_CM_USG
1080: --
1081: -- When in validation only mode raise the Validate_Enabled exception
1082: --
1083: if p_validate then
1084: raise hr_api.validate_enabled;
1085: end if;
1086: --
1087: hr_utility.set_location(' Leaving:'||l_proc, 70);
1088: --
1087: hr_utility.set_location(' Leaving:'||l_proc, 70);
1088: --
1089: exception
1090: --
1091: when hr_api.validate_enabled then
1092: --
1093: -- As the Validate_Enabled exception has been raised
1094: -- we must rollback to the savepoint
1095: --