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_TRGR'
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_TRGR'
129: ,p_hook_type => 'BP');
130: --
131: -- End of API User Hook for the before hook of create_PER_CM_TRGR
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_TRGR'
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_TRGR'
235: ,p_hook_type => 'AP');
236: --
237: -- End of API User Hook for the after hook of create_PER_CM_TRGR
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: --
405: ,p_effective_date => trunc(p_effective_date));
406: --
407: exception
408: --
409: when hr_api.cannot_find_prog_unit then
410: --
411: hr_api.cannot_find_prog_unit_error
412: (p_module_name => 'CREATE_PER_CM_TRGR'
413: ,p_hook_type => 'BP');
407: exception
408: --
409: when hr_api.cannot_find_prog_unit then
410: --
411: hr_api.cannot_find_prog_unit_error
412: (p_module_name => 'CREATE_PER_CM_TRGR'
413: ,p_hook_type => 'BP');
414: --
415: -- End of API User Hook for the before hook of create_PER_CM_TRGR
582: ,p_validation_end_date =>l_validation_end_date);
583: --
584: exception
585: --
586: when hr_api.cannot_find_prog_unit then
587: --
588: hr_api.cannot_find_prog_unit_error
589: (p_module_name => 'ben_per_cm_trgr_f'
590: ,p_hook_type => 'AI');
584: exception
585: --
586: when hr_api.cannot_find_prog_unit then
587: --
588: hr_api.cannot_find_prog_unit_error
589: (p_module_name => 'ben_per_cm_trgr_f'
590: ,p_hook_type => 'AI');
591: --
592: end;
643: ,p_effective_date => trunc(p_effective_date));
644: --
645: exception
646: --
647: when hr_api.cannot_find_prog_unit then
648: --
649: hr_api.cannot_find_prog_unit_error
650: (p_module_name => 'CREATE_PER_CM_TRGR'
651: ,p_hook_type => 'AP');
645: exception
646: --
647: when hr_api.cannot_find_prog_unit then
648: --
649: hr_api.cannot_find_prog_unit_error
650: (p_module_name => 'CREATE_PER_CM_TRGR'
651: ,p_hook_type => 'AP');
652: --
653: -- End of API User Hook for the after hook of create_PER_CM_TRGR
656: --
657: -- When in validation only mode raise the Validate_Enabled exception
658: --
659: if p_validate then
660: raise hr_api.validate_enabled;
661: end if;
662: --
663: -- Set all output arguments
664: --
668: p_object_version_number := l_object_version_number;
669: --
670: exception
671: --
672: when hr_api.validate_enabled then
673: --
674: -- As the Validate_Enabled exception has been raised
675: -- we must rollback to the savepoint
676: --
708: (p_validate in boolean default false
709: ,p_per_cm_trgr_id in number
710: ,p_effective_start_date out nocopy date
711: ,p_effective_end_date out nocopy date
712: ,p_cm_trgr_id in number default hr_api.g_number
713: ,p_per_cm_id in number default hr_api.g_number
714: ,p_business_group_id in number default hr_api.g_number
715: ,p_pcr_attribute_category in varchar2 default hr_api.g_varchar2
716: ,p_pcr_attribute1 in varchar2 default hr_api.g_varchar2
709: ,p_per_cm_trgr_id in number
710: ,p_effective_start_date out nocopy date
711: ,p_effective_end_date out nocopy date
712: ,p_cm_trgr_id in number default hr_api.g_number
713: ,p_per_cm_id in number default hr_api.g_number
714: ,p_business_group_id in number default hr_api.g_number
715: ,p_pcr_attribute_category in varchar2 default hr_api.g_varchar2
716: ,p_pcr_attribute1 in varchar2 default hr_api.g_varchar2
717: ,p_pcr_attribute2 in varchar2 default hr_api.g_varchar2
710: ,p_effective_start_date out nocopy date
711: ,p_effective_end_date out nocopy date
712: ,p_cm_trgr_id in number default hr_api.g_number
713: ,p_per_cm_id in number default hr_api.g_number
714: ,p_business_group_id in number default hr_api.g_number
715: ,p_pcr_attribute_category in varchar2 default hr_api.g_varchar2
716: ,p_pcr_attribute1 in varchar2 default hr_api.g_varchar2
717: ,p_pcr_attribute2 in varchar2 default hr_api.g_varchar2
718: ,p_pcr_attribute3 in varchar2 default hr_api.g_varchar2
711: ,p_effective_end_date out nocopy date
712: ,p_cm_trgr_id in number default hr_api.g_number
713: ,p_per_cm_id in number default hr_api.g_number
714: ,p_business_group_id in number default hr_api.g_number
715: ,p_pcr_attribute_category in varchar2 default hr_api.g_varchar2
716: ,p_pcr_attribute1 in varchar2 default hr_api.g_varchar2
717: ,p_pcr_attribute2 in varchar2 default hr_api.g_varchar2
718: ,p_pcr_attribute3 in varchar2 default hr_api.g_varchar2
719: ,p_pcr_attribute4 in varchar2 default hr_api.g_varchar2
712: ,p_cm_trgr_id in number default hr_api.g_number
713: ,p_per_cm_id in number default hr_api.g_number
714: ,p_business_group_id in number default hr_api.g_number
715: ,p_pcr_attribute_category in varchar2 default hr_api.g_varchar2
716: ,p_pcr_attribute1 in varchar2 default hr_api.g_varchar2
717: ,p_pcr_attribute2 in varchar2 default hr_api.g_varchar2
718: ,p_pcr_attribute3 in varchar2 default hr_api.g_varchar2
719: ,p_pcr_attribute4 in varchar2 default hr_api.g_varchar2
720: ,p_pcr_attribute5 in varchar2 default hr_api.g_varchar2
713: ,p_per_cm_id in number default hr_api.g_number
714: ,p_business_group_id in number default hr_api.g_number
715: ,p_pcr_attribute_category in varchar2 default hr_api.g_varchar2
716: ,p_pcr_attribute1 in varchar2 default hr_api.g_varchar2
717: ,p_pcr_attribute2 in varchar2 default hr_api.g_varchar2
718: ,p_pcr_attribute3 in varchar2 default hr_api.g_varchar2
719: ,p_pcr_attribute4 in varchar2 default hr_api.g_varchar2
720: ,p_pcr_attribute5 in varchar2 default hr_api.g_varchar2
721: ,p_pcr_attribute6 in varchar2 default hr_api.g_varchar2
714: ,p_business_group_id in number default hr_api.g_number
715: ,p_pcr_attribute_category in varchar2 default hr_api.g_varchar2
716: ,p_pcr_attribute1 in varchar2 default hr_api.g_varchar2
717: ,p_pcr_attribute2 in varchar2 default hr_api.g_varchar2
718: ,p_pcr_attribute3 in varchar2 default hr_api.g_varchar2
719: ,p_pcr_attribute4 in varchar2 default hr_api.g_varchar2
720: ,p_pcr_attribute5 in varchar2 default hr_api.g_varchar2
721: ,p_pcr_attribute6 in varchar2 default hr_api.g_varchar2
722: ,p_pcr_attribute7 in varchar2 default hr_api.g_varchar2
715: ,p_pcr_attribute_category in varchar2 default hr_api.g_varchar2
716: ,p_pcr_attribute1 in varchar2 default hr_api.g_varchar2
717: ,p_pcr_attribute2 in varchar2 default hr_api.g_varchar2
718: ,p_pcr_attribute3 in varchar2 default hr_api.g_varchar2
719: ,p_pcr_attribute4 in varchar2 default hr_api.g_varchar2
720: ,p_pcr_attribute5 in varchar2 default hr_api.g_varchar2
721: ,p_pcr_attribute6 in varchar2 default hr_api.g_varchar2
722: ,p_pcr_attribute7 in varchar2 default hr_api.g_varchar2
723: ,p_pcr_attribute8 in varchar2 default hr_api.g_varchar2
716: ,p_pcr_attribute1 in varchar2 default hr_api.g_varchar2
717: ,p_pcr_attribute2 in varchar2 default hr_api.g_varchar2
718: ,p_pcr_attribute3 in varchar2 default hr_api.g_varchar2
719: ,p_pcr_attribute4 in varchar2 default hr_api.g_varchar2
720: ,p_pcr_attribute5 in varchar2 default hr_api.g_varchar2
721: ,p_pcr_attribute6 in varchar2 default hr_api.g_varchar2
722: ,p_pcr_attribute7 in varchar2 default hr_api.g_varchar2
723: ,p_pcr_attribute8 in varchar2 default hr_api.g_varchar2
724: ,p_pcr_attribute9 in varchar2 default hr_api.g_varchar2
717: ,p_pcr_attribute2 in varchar2 default hr_api.g_varchar2
718: ,p_pcr_attribute3 in varchar2 default hr_api.g_varchar2
719: ,p_pcr_attribute4 in varchar2 default hr_api.g_varchar2
720: ,p_pcr_attribute5 in varchar2 default hr_api.g_varchar2
721: ,p_pcr_attribute6 in varchar2 default hr_api.g_varchar2
722: ,p_pcr_attribute7 in varchar2 default hr_api.g_varchar2
723: ,p_pcr_attribute8 in varchar2 default hr_api.g_varchar2
724: ,p_pcr_attribute9 in varchar2 default hr_api.g_varchar2
725: ,p_pcr_attribute10 in varchar2 default hr_api.g_varchar2
718: ,p_pcr_attribute3 in varchar2 default hr_api.g_varchar2
719: ,p_pcr_attribute4 in varchar2 default hr_api.g_varchar2
720: ,p_pcr_attribute5 in varchar2 default hr_api.g_varchar2
721: ,p_pcr_attribute6 in varchar2 default hr_api.g_varchar2
722: ,p_pcr_attribute7 in varchar2 default hr_api.g_varchar2
723: ,p_pcr_attribute8 in varchar2 default hr_api.g_varchar2
724: ,p_pcr_attribute9 in varchar2 default hr_api.g_varchar2
725: ,p_pcr_attribute10 in varchar2 default hr_api.g_varchar2
726: ,p_pcr_attribute11 in varchar2 default hr_api.g_varchar2
719: ,p_pcr_attribute4 in varchar2 default hr_api.g_varchar2
720: ,p_pcr_attribute5 in varchar2 default hr_api.g_varchar2
721: ,p_pcr_attribute6 in varchar2 default hr_api.g_varchar2
722: ,p_pcr_attribute7 in varchar2 default hr_api.g_varchar2
723: ,p_pcr_attribute8 in varchar2 default hr_api.g_varchar2
724: ,p_pcr_attribute9 in varchar2 default hr_api.g_varchar2
725: ,p_pcr_attribute10 in varchar2 default hr_api.g_varchar2
726: ,p_pcr_attribute11 in varchar2 default hr_api.g_varchar2
727: ,p_pcr_attribute12 in varchar2 default hr_api.g_varchar2
720: ,p_pcr_attribute5 in varchar2 default hr_api.g_varchar2
721: ,p_pcr_attribute6 in varchar2 default hr_api.g_varchar2
722: ,p_pcr_attribute7 in varchar2 default hr_api.g_varchar2
723: ,p_pcr_attribute8 in varchar2 default hr_api.g_varchar2
724: ,p_pcr_attribute9 in varchar2 default hr_api.g_varchar2
725: ,p_pcr_attribute10 in varchar2 default hr_api.g_varchar2
726: ,p_pcr_attribute11 in varchar2 default hr_api.g_varchar2
727: ,p_pcr_attribute12 in varchar2 default hr_api.g_varchar2
728: ,p_pcr_attribute13 in varchar2 default hr_api.g_varchar2
721: ,p_pcr_attribute6 in varchar2 default hr_api.g_varchar2
722: ,p_pcr_attribute7 in varchar2 default hr_api.g_varchar2
723: ,p_pcr_attribute8 in varchar2 default hr_api.g_varchar2
724: ,p_pcr_attribute9 in varchar2 default hr_api.g_varchar2
725: ,p_pcr_attribute10 in varchar2 default hr_api.g_varchar2
726: ,p_pcr_attribute11 in varchar2 default hr_api.g_varchar2
727: ,p_pcr_attribute12 in varchar2 default hr_api.g_varchar2
728: ,p_pcr_attribute13 in varchar2 default hr_api.g_varchar2
729: ,p_pcr_attribute14 in varchar2 default hr_api.g_varchar2
722: ,p_pcr_attribute7 in varchar2 default hr_api.g_varchar2
723: ,p_pcr_attribute8 in varchar2 default hr_api.g_varchar2
724: ,p_pcr_attribute9 in varchar2 default hr_api.g_varchar2
725: ,p_pcr_attribute10 in varchar2 default hr_api.g_varchar2
726: ,p_pcr_attribute11 in varchar2 default hr_api.g_varchar2
727: ,p_pcr_attribute12 in varchar2 default hr_api.g_varchar2
728: ,p_pcr_attribute13 in varchar2 default hr_api.g_varchar2
729: ,p_pcr_attribute14 in varchar2 default hr_api.g_varchar2
730: ,p_pcr_attribute15 in varchar2 default hr_api.g_varchar2
723: ,p_pcr_attribute8 in varchar2 default hr_api.g_varchar2
724: ,p_pcr_attribute9 in varchar2 default hr_api.g_varchar2
725: ,p_pcr_attribute10 in varchar2 default hr_api.g_varchar2
726: ,p_pcr_attribute11 in varchar2 default hr_api.g_varchar2
727: ,p_pcr_attribute12 in varchar2 default hr_api.g_varchar2
728: ,p_pcr_attribute13 in varchar2 default hr_api.g_varchar2
729: ,p_pcr_attribute14 in varchar2 default hr_api.g_varchar2
730: ,p_pcr_attribute15 in varchar2 default hr_api.g_varchar2
731: ,p_pcr_attribute16 in varchar2 default hr_api.g_varchar2
724: ,p_pcr_attribute9 in varchar2 default hr_api.g_varchar2
725: ,p_pcr_attribute10 in varchar2 default hr_api.g_varchar2
726: ,p_pcr_attribute11 in varchar2 default hr_api.g_varchar2
727: ,p_pcr_attribute12 in varchar2 default hr_api.g_varchar2
728: ,p_pcr_attribute13 in varchar2 default hr_api.g_varchar2
729: ,p_pcr_attribute14 in varchar2 default hr_api.g_varchar2
730: ,p_pcr_attribute15 in varchar2 default hr_api.g_varchar2
731: ,p_pcr_attribute16 in varchar2 default hr_api.g_varchar2
732: ,p_pcr_attribute17 in varchar2 default hr_api.g_varchar2
725: ,p_pcr_attribute10 in varchar2 default hr_api.g_varchar2
726: ,p_pcr_attribute11 in varchar2 default hr_api.g_varchar2
727: ,p_pcr_attribute12 in varchar2 default hr_api.g_varchar2
728: ,p_pcr_attribute13 in varchar2 default hr_api.g_varchar2
729: ,p_pcr_attribute14 in varchar2 default hr_api.g_varchar2
730: ,p_pcr_attribute15 in varchar2 default hr_api.g_varchar2
731: ,p_pcr_attribute16 in varchar2 default hr_api.g_varchar2
732: ,p_pcr_attribute17 in varchar2 default hr_api.g_varchar2
733: ,p_pcr_attribute18 in varchar2 default hr_api.g_varchar2
726: ,p_pcr_attribute11 in varchar2 default hr_api.g_varchar2
727: ,p_pcr_attribute12 in varchar2 default hr_api.g_varchar2
728: ,p_pcr_attribute13 in varchar2 default hr_api.g_varchar2
729: ,p_pcr_attribute14 in varchar2 default hr_api.g_varchar2
730: ,p_pcr_attribute15 in varchar2 default hr_api.g_varchar2
731: ,p_pcr_attribute16 in varchar2 default hr_api.g_varchar2
732: ,p_pcr_attribute17 in varchar2 default hr_api.g_varchar2
733: ,p_pcr_attribute18 in varchar2 default hr_api.g_varchar2
734: ,p_pcr_attribute19 in varchar2 default hr_api.g_varchar2
727: ,p_pcr_attribute12 in varchar2 default hr_api.g_varchar2
728: ,p_pcr_attribute13 in varchar2 default hr_api.g_varchar2
729: ,p_pcr_attribute14 in varchar2 default hr_api.g_varchar2
730: ,p_pcr_attribute15 in varchar2 default hr_api.g_varchar2
731: ,p_pcr_attribute16 in varchar2 default hr_api.g_varchar2
732: ,p_pcr_attribute17 in varchar2 default hr_api.g_varchar2
733: ,p_pcr_attribute18 in varchar2 default hr_api.g_varchar2
734: ,p_pcr_attribute19 in varchar2 default hr_api.g_varchar2
735: ,p_pcr_attribute20 in varchar2 default hr_api.g_varchar2
728: ,p_pcr_attribute13 in varchar2 default hr_api.g_varchar2
729: ,p_pcr_attribute14 in varchar2 default hr_api.g_varchar2
730: ,p_pcr_attribute15 in varchar2 default hr_api.g_varchar2
731: ,p_pcr_attribute16 in varchar2 default hr_api.g_varchar2
732: ,p_pcr_attribute17 in varchar2 default hr_api.g_varchar2
733: ,p_pcr_attribute18 in varchar2 default hr_api.g_varchar2
734: ,p_pcr_attribute19 in varchar2 default hr_api.g_varchar2
735: ,p_pcr_attribute20 in varchar2 default hr_api.g_varchar2
736: ,p_pcr_attribute21 in varchar2 default hr_api.g_varchar2
729: ,p_pcr_attribute14 in varchar2 default hr_api.g_varchar2
730: ,p_pcr_attribute15 in varchar2 default hr_api.g_varchar2
731: ,p_pcr_attribute16 in varchar2 default hr_api.g_varchar2
732: ,p_pcr_attribute17 in varchar2 default hr_api.g_varchar2
733: ,p_pcr_attribute18 in varchar2 default hr_api.g_varchar2
734: ,p_pcr_attribute19 in varchar2 default hr_api.g_varchar2
735: ,p_pcr_attribute20 in varchar2 default hr_api.g_varchar2
736: ,p_pcr_attribute21 in varchar2 default hr_api.g_varchar2
737: ,p_pcr_attribute22 in varchar2 default hr_api.g_varchar2
730: ,p_pcr_attribute15 in varchar2 default hr_api.g_varchar2
731: ,p_pcr_attribute16 in varchar2 default hr_api.g_varchar2
732: ,p_pcr_attribute17 in varchar2 default hr_api.g_varchar2
733: ,p_pcr_attribute18 in varchar2 default hr_api.g_varchar2
734: ,p_pcr_attribute19 in varchar2 default hr_api.g_varchar2
735: ,p_pcr_attribute20 in varchar2 default hr_api.g_varchar2
736: ,p_pcr_attribute21 in varchar2 default hr_api.g_varchar2
737: ,p_pcr_attribute22 in varchar2 default hr_api.g_varchar2
738: ,p_pcr_attribute23 in varchar2 default hr_api.g_varchar2
731: ,p_pcr_attribute16 in varchar2 default hr_api.g_varchar2
732: ,p_pcr_attribute17 in varchar2 default hr_api.g_varchar2
733: ,p_pcr_attribute18 in varchar2 default hr_api.g_varchar2
734: ,p_pcr_attribute19 in varchar2 default hr_api.g_varchar2
735: ,p_pcr_attribute20 in varchar2 default hr_api.g_varchar2
736: ,p_pcr_attribute21 in varchar2 default hr_api.g_varchar2
737: ,p_pcr_attribute22 in varchar2 default hr_api.g_varchar2
738: ,p_pcr_attribute23 in varchar2 default hr_api.g_varchar2
739: ,p_pcr_attribute24 in varchar2 default hr_api.g_varchar2
732: ,p_pcr_attribute17 in varchar2 default hr_api.g_varchar2
733: ,p_pcr_attribute18 in varchar2 default hr_api.g_varchar2
734: ,p_pcr_attribute19 in varchar2 default hr_api.g_varchar2
735: ,p_pcr_attribute20 in varchar2 default hr_api.g_varchar2
736: ,p_pcr_attribute21 in varchar2 default hr_api.g_varchar2
737: ,p_pcr_attribute22 in varchar2 default hr_api.g_varchar2
738: ,p_pcr_attribute23 in varchar2 default hr_api.g_varchar2
739: ,p_pcr_attribute24 in varchar2 default hr_api.g_varchar2
740: ,p_pcr_attribute25 in varchar2 default hr_api.g_varchar2
733: ,p_pcr_attribute18 in varchar2 default hr_api.g_varchar2
734: ,p_pcr_attribute19 in varchar2 default hr_api.g_varchar2
735: ,p_pcr_attribute20 in varchar2 default hr_api.g_varchar2
736: ,p_pcr_attribute21 in varchar2 default hr_api.g_varchar2
737: ,p_pcr_attribute22 in varchar2 default hr_api.g_varchar2
738: ,p_pcr_attribute23 in varchar2 default hr_api.g_varchar2
739: ,p_pcr_attribute24 in varchar2 default hr_api.g_varchar2
740: ,p_pcr_attribute25 in varchar2 default hr_api.g_varchar2
741: ,p_pcr_attribute26 in varchar2 default hr_api.g_varchar2
734: ,p_pcr_attribute19 in varchar2 default hr_api.g_varchar2
735: ,p_pcr_attribute20 in varchar2 default hr_api.g_varchar2
736: ,p_pcr_attribute21 in varchar2 default hr_api.g_varchar2
737: ,p_pcr_attribute22 in varchar2 default hr_api.g_varchar2
738: ,p_pcr_attribute23 in varchar2 default hr_api.g_varchar2
739: ,p_pcr_attribute24 in varchar2 default hr_api.g_varchar2
740: ,p_pcr_attribute25 in varchar2 default hr_api.g_varchar2
741: ,p_pcr_attribute26 in varchar2 default hr_api.g_varchar2
742: ,p_pcr_attribute27 in varchar2 default hr_api.g_varchar2
735: ,p_pcr_attribute20 in varchar2 default hr_api.g_varchar2
736: ,p_pcr_attribute21 in varchar2 default hr_api.g_varchar2
737: ,p_pcr_attribute22 in varchar2 default hr_api.g_varchar2
738: ,p_pcr_attribute23 in varchar2 default hr_api.g_varchar2
739: ,p_pcr_attribute24 in varchar2 default hr_api.g_varchar2
740: ,p_pcr_attribute25 in varchar2 default hr_api.g_varchar2
741: ,p_pcr_attribute26 in varchar2 default hr_api.g_varchar2
742: ,p_pcr_attribute27 in varchar2 default hr_api.g_varchar2
743: ,p_pcr_attribute28 in varchar2 default hr_api.g_varchar2
736: ,p_pcr_attribute21 in varchar2 default hr_api.g_varchar2
737: ,p_pcr_attribute22 in varchar2 default hr_api.g_varchar2
738: ,p_pcr_attribute23 in varchar2 default hr_api.g_varchar2
739: ,p_pcr_attribute24 in varchar2 default hr_api.g_varchar2
740: ,p_pcr_attribute25 in varchar2 default hr_api.g_varchar2
741: ,p_pcr_attribute26 in varchar2 default hr_api.g_varchar2
742: ,p_pcr_attribute27 in varchar2 default hr_api.g_varchar2
743: ,p_pcr_attribute28 in varchar2 default hr_api.g_varchar2
744: ,p_pcr_attribute29 in varchar2 default hr_api.g_varchar2
737: ,p_pcr_attribute22 in varchar2 default hr_api.g_varchar2
738: ,p_pcr_attribute23 in varchar2 default hr_api.g_varchar2
739: ,p_pcr_attribute24 in varchar2 default hr_api.g_varchar2
740: ,p_pcr_attribute25 in varchar2 default hr_api.g_varchar2
741: ,p_pcr_attribute26 in varchar2 default hr_api.g_varchar2
742: ,p_pcr_attribute27 in varchar2 default hr_api.g_varchar2
743: ,p_pcr_attribute28 in varchar2 default hr_api.g_varchar2
744: ,p_pcr_attribute29 in varchar2 default hr_api.g_varchar2
745: ,p_pcr_attribute30 in varchar2 default hr_api.g_varchar2
738: ,p_pcr_attribute23 in varchar2 default hr_api.g_varchar2
739: ,p_pcr_attribute24 in varchar2 default hr_api.g_varchar2
740: ,p_pcr_attribute25 in varchar2 default hr_api.g_varchar2
741: ,p_pcr_attribute26 in varchar2 default hr_api.g_varchar2
742: ,p_pcr_attribute27 in varchar2 default hr_api.g_varchar2
743: ,p_pcr_attribute28 in varchar2 default hr_api.g_varchar2
744: ,p_pcr_attribute29 in varchar2 default hr_api.g_varchar2
745: ,p_pcr_attribute30 in varchar2 default hr_api.g_varchar2
746: ,p_request_id in number default hr_api.g_number
739: ,p_pcr_attribute24 in varchar2 default hr_api.g_varchar2
740: ,p_pcr_attribute25 in varchar2 default hr_api.g_varchar2
741: ,p_pcr_attribute26 in varchar2 default hr_api.g_varchar2
742: ,p_pcr_attribute27 in varchar2 default hr_api.g_varchar2
743: ,p_pcr_attribute28 in varchar2 default hr_api.g_varchar2
744: ,p_pcr_attribute29 in varchar2 default hr_api.g_varchar2
745: ,p_pcr_attribute30 in varchar2 default hr_api.g_varchar2
746: ,p_request_id in number default hr_api.g_number
747: ,p_program_application_id in number default hr_api.g_number
740: ,p_pcr_attribute25 in varchar2 default hr_api.g_varchar2
741: ,p_pcr_attribute26 in varchar2 default hr_api.g_varchar2
742: ,p_pcr_attribute27 in varchar2 default hr_api.g_varchar2
743: ,p_pcr_attribute28 in varchar2 default hr_api.g_varchar2
744: ,p_pcr_attribute29 in varchar2 default hr_api.g_varchar2
745: ,p_pcr_attribute30 in varchar2 default hr_api.g_varchar2
746: ,p_request_id in number default hr_api.g_number
747: ,p_program_application_id in number default hr_api.g_number
748: ,p_program_id in number default hr_api.g_number
741: ,p_pcr_attribute26 in varchar2 default hr_api.g_varchar2
742: ,p_pcr_attribute27 in varchar2 default hr_api.g_varchar2
743: ,p_pcr_attribute28 in varchar2 default hr_api.g_varchar2
744: ,p_pcr_attribute29 in varchar2 default hr_api.g_varchar2
745: ,p_pcr_attribute30 in varchar2 default hr_api.g_varchar2
746: ,p_request_id in number default hr_api.g_number
747: ,p_program_application_id in number default hr_api.g_number
748: ,p_program_id in number default hr_api.g_number
749: ,p_program_update_date in date default hr_api.g_date
742: ,p_pcr_attribute27 in varchar2 default hr_api.g_varchar2
743: ,p_pcr_attribute28 in varchar2 default hr_api.g_varchar2
744: ,p_pcr_attribute29 in varchar2 default hr_api.g_varchar2
745: ,p_pcr_attribute30 in varchar2 default hr_api.g_varchar2
746: ,p_request_id in number default hr_api.g_number
747: ,p_program_application_id in number default hr_api.g_number
748: ,p_program_id in number default hr_api.g_number
749: ,p_program_update_date in date default hr_api.g_date
750: ,p_object_version_number in out nocopy number
743: ,p_pcr_attribute28 in varchar2 default hr_api.g_varchar2
744: ,p_pcr_attribute29 in varchar2 default hr_api.g_varchar2
745: ,p_pcr_attribute30 in varchar2 default hr_api.g_varchar2
746: ,p_request_id in number default hr_api.g_number
747: ,p_program_application_id in number default hr_api.g_number
748: ,p_program_id in number default hr_api.g_number
749: ,p_program_update_date in date default hr_api.g_date
750: ,p_object_version_number in out nocopy number
751: ,p_effective_date in date
744: ,p_pcr_attribute29 in varchar2 default hr_api.g_varchar2
745: ,p_pcr_attribute30 in varchar2 default hr_api.g_varchar2
746: ,p_request_id in number default hr_api.g_number
747: ,p_program_application_id in number default hr_api.g_number
748: ,p_program_id in number default hr_api.g_number
749: ,p_program_update_date in date default hr_api.g_date
750: ,p_object_version_number in out nocopy number
751: ,p_effective_date in date
752: ,p_datetrack_mode in varchar2) is
745: ,p_pcr_attribute30 in varchar2 default hr_api.g_varchar2
746: ,p_request_id in number default hr_api.g_number
747: ,p_program_application_id in number default hr_api.g_number
748: ,p_program_id in number default hr_api.g_number
749: ,p_program_update_date in date default hr_api.g_date
750: ,p_object_version_number in out nocopy number
751: ,p_effective_date in date
752: ,p_datetrack_mode in varchar2) is
753: --
821: ,p_datetrack_mode => p_datetrack_mode);
822: --
823: exception
824: --
825: when hr_api.cannot_find_prog_unit then
826: hr_api.cannot_find_prog_unit_error
827: (p_module_name => 'UPDATE_PER_CM_TRGR'
828: ,p_hook_type => 'BP');
829: --
822: --
823: exception
824: --
825: when hr_api.cannot_find_prog_unit then
826: hr_api.cannot_find_prog_unit_error
827: (p_module_name => 'UPDATE_PER_CM_TRGR'
828: ,p_hook_type => 'BP');
829: --
830: -- End of API User Hook for the before hook of update_PER_CM_TRGR
928: ,p_datetrack_mode => p_datetrack_mode);
929: --
930: exception
931: --
932: when hr_api.cannot_find_prog_unit then
933: --
934: hr_api.cannot_find_prog_unit_error
935: (p_module_name => 'UPDATE_PER_CM_TRGR'
936: ,p_hook_type => 'AP');
930: exception
931: --
932: when hr_api.cannot_find_prog_unit then
933: --
934: hr_api.cannot_find_prog_unit_error
935: (p_module_name => 'UPDATE_PER_CM_TRGR'
936: ,p_hook_type => 'AP');
937: --
938: -- End of API User Hook for the after hook of update_PER_CM_TRGR
943: --
944: -- When in validation only mode raise the Validate_Enabled exception
945: --
946: if p_validate then
947: raise hr_api.validate_enabled;
948: end if;
949: --
950: -- Set all output arguments
951: --
956: hr_utility.set_location(' Leaving:'||l_proc, 70);
957: --
958: exception
959: --
960: when hr_api.validate_enabled then
961: --
962: -- As the Validate_Enabled exception has been raised
963: -- we must rollback to the savepoint
964: --
1027: ,p_datetrack_mode => p_datetrack_mode);
1028: --
1029: exception
1030: --
1031: when hr_api.cannot_find_prog_unit then
1032: --
1033: hr_api.cannot_find_prog_unit_error
1034: (p_module_name => 'DELETE_PER_CM_TRGR'
1035: ,p_hook_type => 'BP');
1029: exception
1030: --
1031: when hr_api.cannot_find_prog_unit then
1032: --
1033: hr_api.cannot_find_prog_unit_error
1034: (p_module_name => 'DELETE_PER_CM_TRGR'
1035: ,p_hook_type => 'BP');
1036: --
1037: -- End of API User Hook for the before hook of delete_PER_CM_TRGR
1059: ,p_datetrack_mode => p_datetrack_mode);
1060: --
1061: exception
1062: --
1063: when hr_api.cannot_find_prog_unit then
1064: --
1065: hr_api.cannot_find_prog_unit_error
1066: (p_module_name => 'DELETE_PER_CM_TRGR'
1067: ,p_hook_type => 'AP');
1061: exception
1062: --
1063: when hr_api.cannot_find_prog_unit then
1064: --
1065: hr_api.cannot_find_prog_unit_error
1066: (p_module_name => 'DELETE_PER_CM_TRGR'
1067: ,p_hook_type => 'AP');
1068: --
1069: -- End of API User Hook for the after hook of delete_PER_CM_TRGR
1074: --
1075: -- When in validation only mode raise the Validate_Enabled exception
1076: --
1077: if p_validate then
1078: raise hr_api.validate_enabled;
1079: end if;
1080: --
1081: hr_utility.set_location(' Leaving:'||l_proc, 70);
1082: --
1081: hr_utility.set_location(' Leaving:'||l_proc, 70);
1082: --
1083: exception
1084: --
1085: when hr_api.validate_enabled then
1086: --
1087: -- As the Validate_Enabled exception has been raised
1088: -- we must rollback to the savepoint
1089: --