143: ,p_effective_date => trunc(p_effective_date));
144: --
145: exception
146: --
147: when hr_api.cannot_find_prog_unit then
148: --
149: hr_api.cannot_find_prog_unit_error
150: (p_module_name => 'CREATE_PER_CM_PRVDD'
151: ,p_hook_type => 'BP');
145: exception
146: --
147: when hr_api.cannot_find_prog_unit then
148: --
149: hr_api.cannot_find_prog_unit_error
150: (p_module_name => 'CREATE_PER_CM_PRVDD'
151: ,p_hook_type => 'BP');
152: --
153: -- End of API User Hook for the before hook of create_PER_CM_PRVDD
271: ,p_effective_date => trunc(p_effective_date));
272: --
273: exception
274: --
275: when hr_api.cannot_find_prog_unit then
276: --
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'CREATE_PER_CM_PRVDD'
279: ,p_hook_type => 'AP');
273: exception
274: --
275: when hr_api.cannot_find_prog_unit then
276: --
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'CREATE_PER_CM_PRVDD'
279: ,p_hook_type => 'AP');
280: --
281: -- End of API User Hook for the after hook of create_PER_CM_PRVDD
286: --
287: -- When in validation only mode raise the Validate_Enabled exception
288: --
289: if p_validate then
290: raise hr_api.validate_enabled;
291: end if;
292: --
293: -- Set all output arguments
294: --
300: hr_utility.set_location(' Leaving:'||l_proc, 70);
301: --
302: exception
303: --
304: when hr_api.validate_enabled then
305: --
306: -- As the Validate_Enabled exception has been raised
307: -- we must rollback to the savepoint
308: --
472: ,p_effective_date => trunc(p_effective_date));
473: --
474: exception
475: --
476: when hr_api.cannot_find_prog_unit then
477: --
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'CREATE_PER_CM_PRVDD'
480: ,p_hook_type => 'BP');
474: exception
475: --
476: when hr_api.cannot_find_prog_unit then
477: --
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'CREATE_PER_CM_PRVDD'
480: ,p_hook_type => 'BP');
481: --
482: -- End of API User Hook for the before hook of create_PER_CM_PRVDD
682: ,p_validation_end_date =>l_validation_end_date);
683: --
684: exception
685: --
686: when hr_api.cannot_find_prog_unit then
687: --
688: hr_api.cannot_find_prog_unit_error
689: (p_module_name => 'ben_per_cm_prvdd_f'
690: ,p_hook_type => 'AI');
684: exception
685: --
686: when hr_api.cannot_find_prog_unit then
687: --
688: hr_api.cannot_find_prog_unit_error
689: (p_module_name => 'ben_per_cm_prvdd_f'
690: ,p_hook_type => 'AI');
691: --
692: end;
752: ,p_effective_date => trunc(p_effective_date));
753: --
754: exception
755: --
756: when hr_api.cannot_find_prog_unit then
757: --
758: hr_api.cannot_find_prog_unit_error
759: (p_module_name => 'CREATE_PER_CM_PRVDD'
760: ,p_hook_type => 'AP');
754: exception
755: --
756: when hr_api.cannot_find_prog_unit then
757: --
758: hr_api.cannot_find_prog_unit_error
759: (p_module_name => 'CREATE_PER_CM_PRVDD'
760: ,p_hook_type => 'AP');
761: --
762: -- End of API User Hook for the after hook of create_PER_CM_PRVDD
765: --
766: -- When in validation only mode raise the Validate_Enabled exception
767: --
768: if p_validate then
769: raise hr_api.validate_enabled;
770: end if;
771: --
772: -- Set all output arguments
773: --
777: p_object_version_number := l_object_version_number;
778: --
779: exception
780: --
781: when hr_api.validate_enabled then
782: --
783: -- As the Validate_Enabled exception has been raised
784: -- we must rollback to the savepoint
785: --
814: (p_validate in boolean default false
815: ,p_per_cm_prvdd_id in number
816: ,p_effective_start_date out nocopy date
817: ,p_effective_end_date out nocopy date
818: ,p_rqstd_flag in varchar2 default hr_api.g_varchar2
819: ,p_per_cm_prvdd_stat_cd in varchar2 default hr_api.g_varchar2
820: ,p_cm_dlvry_med_cd in varchar2 default hr_api.g_varchar2
821: ,p_cm_dlvry_mthd_cd in varchar2 default hr_api.g_varchar2
822: ,p_sent_dt in date default hr_api.g_date
815: ,p_per_cm_prvdd_id in number
816: ,p_effective_start_date out nocopy date
817: ,p_effective_end_date out nocopy date
818: ,p_rqstd_flag in varchar2 default hr_api.g_varchar2
819: ,p_per_cm_prvdd_stat_cd in varchar2 default hr_api.g_varchar2
820: ,p_cm_dlvry_med_cd in varchar2 default hr_api.g_varchar2
821: ,p_cm_dlvry_mthd_cd in varchar2 default hr_api.g_varchar2
822: ,p_sent_dt in date default hr_api.g_date
823: ,p_instnc_num in number default hr_api.g_number
816: ,p_effective_start_date out nocopy date
817: ,p_effective_end_date out nocopy date
818: ,p_rqstd_flag in varchar2 default hr_api.g_varchar2
819: ,p_per_cm_prvdd_stat_cd in varchar2 default hr_api.g_varchar2
820: ,p_cm_dlvry_med_cd in varchar2 default hr_api.g_varchar2
821: ,p_cm_dlvry_mthd_cd in varchar2 default hr_api.g_varchar2
822: ,p_sent_dt in date default hr_api.g_date
823: ,p_instnc_num in number default hr_api.g_number
824: ,p_to_be_sent_dt in date default hr_api.g_date
817: ,p_effective_end_date out nocopy date
818: ,p_rqstd_flag in varchar2 default hr_api.g_varchar2
819: ,p_per_cm_prvdd_stat_cd in varchar2 default hr_api.g_varchar2
820: ,p_cm_dlvry_med_cd in varchar2 default hr_api.g_varchar2
821: ,p_cm_dlvry_mthd_cd in varchar2 default hr_api.g_varchar2
822: ,p_sent_dt in date default hr_api.g_date
823: ,p_instnc_num in number default hr_api.g_number
824: ,p_to_be_sent_dt in date default hr_api.g_date
825: ,p_dlvry_instn_txt in varchar2 default hr_api.g_varchar2
818: ,p_rqstd_flag in varchar2 default hr_api.g_varchar2
819: ,p_per_cm_prvdd_stat_cd in varchar2 default hr_api.g_varchar2
820: ,p_cm_dlvry_med_cd in varchar2 default hr_api.g_varchar2
821: ,p_cm_dlvry_mthd_cd in varchar2 default hr_api.g_varchar2
822: ,p_sent_dt in date default hr_api.g_date
823: ,p_instnc_num in number default hr_api.g_number
824: ,p_to_be_sent_dt in date default hr_api.g_date
825: ,p_dlvry_instn_txt in varchar2 default hr_api.g_varchar2
826: ,p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2
819: ,p_per_cm_prvdd_stat_cd in varchar2 default hr_api.g_varchar2
820: ,p_cm_dlvry_med_cd in varchar2 default hr_api.g_varchar2
821: ,p_cm_dlvry_mthd_cd in varchar2 default hr_api.g_varchar2
822: ,p_sent_dt in date default hr_api.g_date
823: ,p_instnc_num in number default hr_api.g_number
824: ,p_to_be_sent_dt in date default hr_api.g_date
825: ,p_dlvry_instn_txt in varchar2 default hr_api.g_varchar2
826: ,p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2
827: ,p_resnd_rsn_cd in varchar2 default hr_api.g_varchar2
820: ,p_cm_dlvry_med_cd in varchar2 default hr_api.g_varchar2
821: ,p_cm_dlvry_mthd_cd in varchar2 default hr_api.g_varchar2
822: ,p_sent_dt in date default hr_api.g_date
823: ,p_instnc_num in number default hr_api.g_number
824: ,p_to_be_sent_dt in date default hr_api.g_date
825: ,p_dlvry_instn_txt in varchar2 default hr_api.g_varchar2
826: ,p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2
827: ,p_resnd_rsn_cd in varchar2 default hr_api.g_varchar2
828: ,p_resnd_cmnt_txt in varchar2 default hr_api.g_varchar2
821: ,p_cm_dlvry_mthd_cd in varchar2 default hr_api.g_varchar2
822: ,p_sent_dt in date default hr_api.g_date
823: ,p_instnc_num in number default hr_api.g_number
824: ,p_to_be_sent_dt in date default hr_api.g_date
825: ,p_dlvry_instn_txt in varchar2 default hr_api.g_varchar2
826: ,p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2
827: ,p_resnd_rsn_cd in varchar2 default hr_api.g_varchar2
828: ,p_resnd_cmnt_txt in varchar2 default hr_api.g_varchar2
829: ,p_per_cm_id in number default hr_api.g_number
822: ,p_sent_dt in date default hr_api.g_date
823: ,p_instnc_num in number default hr_api.g_number
824: ,p_to_be_sent_dt in date default hr_api.g_date
825: ,p_dlvry_instn_txt in varchar2 default hr_api.g_varchar2
826: ,p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2
827: ,p_resnd_rsn_cd in varchar2 default hr_api.g_varchar2
828: ,p_resnd_cmnt_txt in varchar2 default hr_api.g_varchar2
829: ,p_per_cm_id in number default hr_api.g_number
830: ,p_address_id in number default hr_api.g_number
823: ,p_instnc_num in number default hr_api.g_number
824: ,p_to_be_sent_dt in date default hr_api.g_date
825: ,p_dlvry_instn_txt in varchar2 default hr_api.g_varchar2
826: ,p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2
827: ,p_resnd_rsn_cd in varchar2 default hr_api.g_varchar2
828: ,p_resnd_cmnt_txt in varchar2 default hr_api.g_varchar2
829: ,p_per_cm_id in number default hr_api.g_number
830: ,p_address_id in number default hr_api.g_number
831: ,p_business_group_id in number default hr_api.g_number
824: ,p_to_be_sent_dt in date default hr_api.g_date
825: ,p_dlvry_instn_txt in varchar2 default hr_api.g_varchar2
826: ,p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2
827: ,p_resnd_rsn_cd in varchar2 default hr_api.g_varchar2
828: ,p_resnd_cmnt_txt in varchar2 default hr_api.g_varchar2
829: ,p_per_cm_id in number default hr_api.g_number
830: ,p_address_id in number default hr_api.g_number
831: ,p_business_group_id in number default hr_api.g_number
832: ,p_pcd_attribute_category in varchar2 default hr_api.g_varchar2
825: ,p_dlvry_instn_txt in varchar2 default hr_api.g_varchar2
826: ,p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2
827: ,p_resnd_rsn_cd in varchar2 default hr_api.g_varchar2
828: ,p_resnd_cmnt_txt in varchar2 default hr_api.g_varchar2
829: ,p_per_cm_id in number default hr_api.g_number
830: ,p_address_id in number default hr_api.g_number
831: ,p_business_group_id in number default hr_api.g_number
832: ,p_pcd_attribute_category in varchar2 default hr_api.g_varchar2
833: ,p_pcd_attribute1 in varchar2 default hr_api.g_varchar2
826: ,p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2
827: ,p_resnd_rsn_cd in varchar2 default hr_api.g_varchar2
828: ,p_resnd_cmnt_txt in varchar2 default hr_api.g_varchar2
829: ,p_per_cm_id in number default hr_api.g_number
830: ,p_address_id in number default hr_api.g_number
831: ,p_business_group_id in number default hr_api.g_number
832: ,p_pcd_attribute_category in varchar2 default hr_api.g_varchar2
833: ,p_pcd_attribute1 in varchar2 default hr_api.g_varchar2
834: ,p_pcd_attribute2 in varchar2 default hr_api.g_varchar2
827: ,p_resnd_rsn_cd in varchar2 default hr_api.g_varchar2
828: ,p_resnd_cmnt_txt in varchar2 default hr_api.g_varchar2
829: ,p_per_cm_id in number default hr_api.g_number
830: ,p_address_id in number default hr_api.g_number
831: ,p_business_group_id in number default hr_api.g_number
832: ,p_pcd_attribute_category in varchar2 default hr_api.g_varchar2
833: ,p_pcd_attribute1 in varchar2 default hr_api.g_varchar2
834: ,p_pcd_attribute2 in varchar2 default hr_api.g_varchar2
835: ,p_pcd_attribute3 in varchar2 default hr_api.g_varchar2
828: ,p_resnd_cmnt_txt in varchar2 default hr_api.g_varchar2
829: ,p_per_cm_id in number default hr_api.g_number
830: ,p_address_id in number default hr_api.g_number
831: ,p_business_group_id in number default hr_api.g_number
832: ,p_pcd_attribute_category in varchar2 default hr_api.g_varchar2
833: ,p_pcd_attribute1 in varchar2 default hr_api.g_varchar2
834: ,p_pcd_attribute2 in varchar2 default hr_api.g_varchar2
835: ,p_pcd_attribute3 in varchar2 default hr_api.g_varchar2
836: ,p_pcd_attribute4 in varchar2 default hr_api.g_varchar2
829: ,p_per_cm_id in number default hr_api.g_number
830: ,p_address_id in number default hr_api.g_number
831: ,p_business_group_id in number default hr_api.g_number
832: ,p_pcd_attribute_category in varchar2 default hr_api.g_varchar2
833: ,p_pcd_attribute1 in varchar2 default hr_api.g_varchar2
834: ,p_pcd_attribute2 in varchar2 default hr_api.g_varchar2
835: ,p_pcd_attribute3 in varchar2 default hr_api.g_varchar2
836: ,p_pcd_attribute4 in varchar2 default hr_api.g_varchar2
837: ,p_pcd_attribute5 in varchar2 default hr_api.g_varchar2
830: ,p_address_id in number default hr_api.g_number
831: ,p_business_group_id in number default hr_api.g_number
832: ,p_pcd_attribute_category in varchar2 default hr_api.g_varchar2
833: ,p_pcd_attribute1 in varchar2 default hr_api.g_varchar2
834: ,p_pcd_attribute2 in varchar2 default hr_api.g_varchar2
835: ,p_pcd_attribute3 in varchar2 default hr_api.g_varchar2
836: ,p_pcd_attribute4 in varchar2 default hr_api.g_varchar2
837: ,p_pcd_attribute5 in varchar2 default hr_api.g_varchar2
838: ,p_pcd_attribute6 in varchar2 default hr_api.g_varchar2
831: ,p_business_group_id in number default hr_api.g_number
832: ,p_pcd_attribute_category in varchar2 default hr_api.g_varchar2
833: ,p_pcd_attribute1 in varchar2 default hr_api.g_varchar2
834: ,p_pcd_attribute2 in varchar2 default hr_api.g_varchar2
835: ,p_pcd_attribute3 in varchar2 default hr_api.g_varchar2
836: ,p_pcd_attribute4 in varchar2 default hr_api.g_varchar2
837: ,p_pcd_attribute5 in varchar2 default hr_api.g_varchar2
838: ,p_pcd_attribute6 in varchar2 default hr_api.g_varchar2
839: ,p_pcd_attribute7 in varchar2 default hr_api.g_varchar2
832: ,p_pcd_attribute_category in varchar2 default hr_api.g_varchar2
833: ,p_pcd_attribute1 in varchar2 default hr_api.g_varchar2
834: ,p_pcd_attribute2 in varchar2 default hr_api.g_varchar2
835: ,p_pcd_attribute3 in varchar2 default hr_api.g_varchar2
836: ,p_pcd_attribute4 in varchar2 default hr_api.g_varchar2
837: ,p_pcd_attribute5 in varchar2 default hr_api.g_varchar2
838: ,p_pcd_attribute6 in varchar2 default hr_api.g_varchar2
839: ,p_pcd_attribute7 in varchar2 default hr_api.g_varchar2
840: ,p_pcd_attribute8 in varchar2 default hr_api.g_varchar2
833: ,p_pcd_attribute1 in varchar2 default hr_api.g_varchar2
834: ,p_pcd_attribute2 in varchar2 default hr_api.g_varchar2
835: ,p_pcd_attribute3 in varchar2 default hr_api.g_varchar2
836: ,p_pcd_attribute4 in varchar2 default hr_api.g_varchar2
837: ,p_pcd_attribute5 in varchar2 default hr_api.g_varchar2
838: ,p_pcd_attribute6 in varchar2 default hr_api.g_varchar2
839: ,p_pcd_attribute7 in varchar2 default hr_api.g_varchar2
840: ,p_pcd_attribute8 in varchar2 default hr_api.g_varchar2
841: ,p_pcd_attribute9 in varchar2 default hr_api.g_varchar2
834: ,p_pcd_attribute2 in varchar2 default hr_api.g_varchar2
835: ,p_pcd_attribute3 in varchar2 default hr_api.g_varchar2
836: ,p_pcd_attribute4 in varchar2 default hr_api.g_varchar2
837: ,p_pcd_attribute5 in varchar2 default hr_api.g_varchar2
838: ,p_pcd_attribute6 in varchar2 default hr_api.g_varchar2
839: ,p_pcd_attribute7 in varchar2 default hr_api.g_varchar2
840: ,p_pcd_attribute8 in varchar2 default hr_api.g_varchar2
841: ,p_pcd_attribute9 in varchar2 default hr_api.g_varchar2
842: ,p_pcd_attribute10 in varchar2 default hr_api.g_varchar2
835: ,p_pcd_attribute3 in varchar2 default hr_api.g_varchar2
836: ,p_pcd_attribute4 in varchar2 default hr_api.g_varchar2
837: ,p_pcd_attribute5 in varchar2 default hr_api.g_varchar2
838: ,p_pcd_attribute6 in varchar2 default hr_api.g_varchar2
839: ,p_pcd_attribute7 in varchar2 default hr_api.g_varchar2
840: ,p_pcd_attribute8 in varchar2 default hr_api.g_varchar2
841: ,p_pcd_attribute9 in varchar2 default hr_api.g_varchar2
842: ,p_pcd_attribute10 in varchar2 default hr_api.g_varchar2
843: ,p_pcd_attribute11 in varchar2 default hr_api.g_varchar2
836: ,p_pcd_attribute4 in varchar2 default hr_api.g_varchar2
837: ,p_pcd_attribute5 in varchar2 default hr_api.g_varchar2
838: ,p_pcd_attribute6 in varchar2 default hr_api.g_varchar2
839: ,p_pcd_attribute7 in varchar2 default hr_api.g_varchar2
840: ,p_pcd_attribute8 in varchar2 default hr_api.g_varchar2
841: ,p_pcd_attribute9 in varchar2 default hr_api.g_varchar2
842: ,p_pcd_attribute10 in varchar2 default hr_api.g_varchar2
843: ,p_pcd_attribute11 in varchar2 default hr_api.g_varchar2
844: ,p_pcd_attribute12 in varchar2 default hr_api.g_varchar2
837: ,p_pcd_attribute5 in varchar2 default hr_api.g_varchar2
838: ,p_pcd_attribute6 in varchar2 default hr_api.g_varchar2
839: ,p_pcd_attribute7 in varchar2 default hr_api.g_varchar2
840: ,p_pcd_attribute8 in varchar2 default hr_api.g_varchar2
841: ,p_pcd_attribute9 in varchar2 default hr_api.g_varchar2
842: ,p_pcd_attribute10 in varchar2 default hr_api.g_varchar2
843: ,p_pcd_attribute11 in varchar2 default hr_api.g_varchar2
844: ,p_pcd_attribute12 in varchar2 default hr_api.g_varchar2
845: ,p_pcd_attribute13 in varchar2 default hr_api.g_varchar2
838: ,p_pcd_attribute6 in varchar2 default hr_api.g_varchar2
839: ,p_pcd_attribute7 in varchar2 default hr_api.g_varchar2
840: ,p_pcd_attribute8 in varchar2 default hr_api.g_varchar2
841: ,p_pcd_attribute9 in varchar2 default hr_api.g_varchar2
842: ,p_pcd_attribute10 in varchar2 default hr_api.g_varchar2
843: ,p_pcd_attribute11 in varchar2 default hr_api.g_varchar2
844: ,p_pcd_attribute12 in varchar2 default hr_api.g_varchar2
845: ,p_pcd_attribute13 in varchar2 default hr_api.g_varchar2
846: ,p_pcd_attribute14 in varchar2 default hr_api.g_varchar2
839: ,p_pcd_attribute7 in varchar2 default hr_api.g_varchar2
840: ,p_pcd_attribute8 in varchar2 default hr_api.g_varchar2
841: ,p_pcd_attribute9 in varchar2 default hr_api.g_varchar2
842: ,p_pcd_attribute10 in varchar2 default hr_api.g_varchar2
843: ,p_pcd_attribute11 in varchar2 default hr_api.g_varchar2
844: ,p_pcd_attribute12 in varchar2 default hr_api.g_varchar2
845: ,p_pcd_attribute13 in varchar2 default hr_api.g_varchar2
846: ,p_pcd_attribute14 in varchar2 default hr_api.g_varchar2
847: ,p_pcd_attribute15 in varchar2 default hr_api.g_varchar2
840: ,p_pcd_attribute8 in varchar2 default hr_api.g_varchar2
841: ,p_pcd_attribute9 in varchar2 default hr_api.g_varchar2
842: ,p_pcd_attribute10 in varchar2 default hr_api.g_varchar2
843: ,p_pcd_attribute11 in varchar2 default hr_api.g_varchar2
844: ,p_pcd_attribute12 in varchar2 default hr_api.g_varchar2
845: ,p_pcd_attribute13 in varchar2 default hr_api.g_varchar2
846: ,p_pcd_attribute14 in varchar2 default hr_api.g_varchar2
847: ,p_pcd_attribute15 in varchar2 default hr_api.g_varchar2
848: ,p_pcd_attribute16 in varchar2 default hr_api.g_varchar2
841: ,p_pcd_attribute9 in varchar2 default hr_api.g_varchar2
842: ,p_pcd_attribute10 in varchar2 default hr_api.g_varchar2
843: ,p_pcd_attribute11 in varchar2 default hr_api.g_varchar2
844: ,p_pcd_attribute12 in varchar2 default hr_api.g_varchar2
845: ,p_pcd_attribute13 in varchar2 default hr_api.g_varchar2
846: ,p_pcd_attribute14 in varchar2 default hr_api.g_varchar2
847: ,p_pcd_attribute15 in varchar2 default hr_api.g_varchar2
848: ,p_pcd_attribute16 in varchar2 default hr_api.g_varchar2
849: ,p_pcd_attribute17 in varchar2 default hr_api.g_varchar2
842: ,p_pcd_attribute10 in varchar2 default hr_api.g_varchar2
843: ,p_pcd_attribute11 in varchar2 default hr_api.g_varchar2
844: ,p_pcd_attribute12 in varchar2 default hr_api.g_varchar2
845: ,p_pcd_attribute13 in varchar2 default hr_api.g_varchar2
846: ,p_pcd_attribute14 in varchar2 default hr_api.g_varchar2
847: ,p_pcd_attribute15 in varchar2 default hr_api.g_varchar2
848: ,p_pcd_attribute16 in varchar2 default hr_api.g_varchar2
849: ,p_pcd_attribute17 in varchar2 default hr_api.g_varchar2
850: ,p_pcd_attribute18 in varchar2 default hr_api.g_varchar2
843: ,p_pcd_attribute11 in varchar2 default hr_api.g_varchar2
844: ,p_pcd_attribute12 in varchar2 default hr_api.g_varchar2
845: ,p_pcd_attribute13 in varchar2 default hr_api.g_varchar2
846: ,p_pcd_attribute14 in varchar2 default hr_api.g_varchar2
847: ,p_pcd_attribute15 in varchar2 default hr_api.g_varchar2
848: ,p_pcd_attribute16 in varchar2 default hr_api.g_varchar2
849: ,p_pcd_attribute17 in varchar2 default hr_api.g_varchar2
850: ,p_pcd_attribute18 in varchar2 default hr_api.g_varchar2
851: ,p_pcd_attribute19 in varchar2 default hr_api.g_varchar2
844: ,p_pcd_attribute12 in varchar2 default hr_api.g_varchar2
845: ,p_pcd_attribute13 in varchar2 default hr_api.g_varchar2
846: ,p_pcd_attribute14 in varchar2 default hr_api.g_varchar2
847: ,p_pcd_attribute15 in varchar2 default hr_api.g_varchar2
848: ,p_pcd_attribute16 in varchar2 default hr_api.g_varchar2
849: ,p_pcd_attribute17 in varchar2 default hr_api.g_varchar2
850: ,p_pcd_attribute18 in varchar2 default hr_api.g_varchar2
851: ,p_pcd_attribute19 in varchar2 default hr_api.g_varchar2
852: ,p_pcd_attribute20 in varchar2 default hr_api.g_varchar2
845: ,p_pcd_attribute13 in varchar2 default hr_api.g_varchar2
846: ,p_pcd_attribute14 in varchar2 default hr_api.g_varchar2
847: ,p_pcd_attribute15 in varchar2 default hr_api.g_varchar2
848: ,p_pcd_attribute16 in varchar2 default hr_api.g_varchar2
849: ,p_pcd_attribute17 in varchar2 default hr_api.g_varchar2
850: ,p_pcd_attribute18 in varchar2 default hr_api.g_varchar2
851: ,p_pcd_attribute19 in varchar2 default hr_api.g_varchar2
852: ,p_pcd_attribute20 in varchar2 default hr_api.g_varchar2
853: ,p_pcd_attribute21 in varchar2 default hr_api.g_varchar2
846: ,p_pcd_attribute14 in varchar2 default hr_api.g_varchar2
847: ,p_pcd_attribute15 in varchar2 default hr_api.g_varchar2
848: ,p_pcd_attribute16 in varchar2 default hr_api.g_varchar2
849: ,p_pcd_attribute17 in varchar2 default hr_api.g_varchar2
850: ,p_pcd_attribute18 in varchar2 default hr_api.g_varchar2
851: ,p_pcd_attribute19 in varchar2 default hr_api.g_varchar2
852: ,p_pcd_attribute20 in varchar2 default hr_api.g_varchar2
853: ,p_pcd_attribute21 in varchar2 default hr_api.g_varchar2
854: ,p_pcd_attribute22 in varchar2 default hr_api.g_varchar2
847: ,p_pcd_attribute15 in varchar2 default hr_api.g_varchar2
848: ,p_pcd_attribute16 in varchar2 default hr_api.g_varchar2
849: ,p_pcd_attribute17 in varchar2 default hr_api.g_varchar2
850: ,p_pcd_attribute18 in varchar2 default hr_api.g_varchar2
851: ,p_pcd_attribute19 in varchar2 default hr_api.g_varchar2
852: ,p_pcd_attribute20 in varchar2 default hr_api.g_varchar2
853: ,p_pcd_attribute21 in varchar2 default hr_api.g_varchar2
854: ,p_pcd_attribute22 in varchar2 default hr_api.g_varchar2
855: ,p_pcd_attribute23 in varchar2 default hr_api.g_varchar2
848: ,p_pcd_attribute16 in varchar2 default hr_api.g_varchar2
849: ,p_pcd_attribute17 in varchar2 default hr_api.g_varchar2
850: ,p_pcd_attribute18 in varchar2 default hr_api.g_varchar2
851: ,p_pcd_attribute19 in varchar2 default hr_api.g_varchar2
852: ,p_pcd_attribute20 in varchar2 default hr_api.g_varchar2
853: ,p_pcd_attribute21 in varchar2 default hr_api.g_varchar2
854: ,p_pcd_attribute22 in varchar2 default hr_api.g_varchar2
855: ,p_pcd_attribute23 in varchar2 default hr_api.g_varchar2
856: ,p_pcd_attribute24 in varchar2 default hr_api.g_varchar2
849: ,p_pcd_attribute17 in varchar2 default hr_api.g_varchar2
850: ,p_pcd_attribute18 in varchar2 default hr_api.g_varchar2
851: ,p_pcd_attribute19 in varchar2 default hr_api.g_varchar2
852: ,p_pcd_attribute20 in varchar2 default hr_api.g_varchar2
853: ,p_pcd_attribute21 in varchar2 default hr_api.g_varchar2
854: ,p_pcd_attribute22 in varchar2 default hr_api.g_varchar2
855: ,p_pcd_attribute23 in varchar2 default hr_api.g_varchar2
856: ,p_pcd_attribute24 in varchar2 default hr_api.g_varchar2
857: ,p_pcd_attribute25 in varchar2 default hr_api.g_varchar2
850: ,p_pcd_attribute18 in varchar2 default hr_api.g_varchar2
851: ,p_pcd_attribute19 in varchar2 default hr_api.g_varchar2
852: ,p_pcd_attribute20 in varchar2 default hr_api.g_varchar2
853: ,p_pcd_attribute21 in varchar2 default hr_api.g_varchar2
854: ,p_pcd_attribute22 in varchar2 default hr_api.g_varchar2
855: ,p_pcd_attribute23 in varchar2 default hr_api.g_varchar2
856: ,p_pcd_attribute24 in varchar2 default hr_api.g_varchar2
857: ,p_pcd_attribute25 in varchar2 default hr_api.g_varchar2
858: ,p_pcd_attribute26 in varchar2 default hr_api.g_varchar2
851: ,p_pcd_attribute19 in varchar2 default hr_api.g_varchar2
852: ,p_pcd_attribute20 in varchar2 default hr_api.g_varchar2
853: ,p_pcd_attribute21 in varchar2 default hr_api.g_varchar2
854: ,p_pcd_attribute22 in varchar2 default hr_api.g_varchar2
855: ,p_pcd_attribute23 in varchar2 default hr_api.g_varchar2
856: ,p_pcd_attribute24 in varchar2 default hr_api.g_varchar2
857: ,p_pcd_attribute25 in varchar2 default hr_api.g_varchar2
858: ,p_pcd_attribute26 in varchar2 default hr_api.g_varchar2
859: ,p_pcd_attribute27 in varchar2 default hr_api.g_varchar2
852: ,p_pcd_attribute20 in varchar2 default hr_api.g_varchar2
853: ,p_pcd_attribute21 in varchar2 default hr_api.g_varchar2
854: ,p_pcd_attribute22 in varchar2 default hr_api.g_varchar2
855: ,p_pcd_attribute23 in varchar2 default hr_api.g_varchar2
856: ,p_pcd_attribute24 in varchar2 default hr_api.g_varchar2
857: ,p_pcd_attribute25 in varchar2 default hr_api.g_varchar2
858: ,p_pcd_attribute26 in varchar2 default hr_api.g_varchar2
859: ,p_pcd_attribute27 in varchar2 default hr_api.g_varchar2
860: ,p_pcd_attribute28 in varchar2 default hr_api.g_varchar2
853: ,p_pcd_attribute21 in varchar2 default hr_api.g_varchar2
854: ,p_pcd_attribute22 in varchar2 default hr_api.g_varchar2
855: ,p_pcd_attribute23 in varchar2 default hr_api.g_varchar2
856: ,p_pcd_attribute24 in varchar2 default hr_api.g_varchar2
857: ,p_pcd_attribute25 in varchar2 default hr_api.g_varchar2
858: ,p_pcd_attribute26 in varchar2 default hr_api.g_varchar2
859: ,p_pcd_attribute27 in varchar2 default hr_api.g_varchar2
860: ,p_pcd_attribute28 in varchar2 default hr_api.g_varchar2
861: ,p_pcd_attribute29 in varchar2 default hr_api.g_varchar2
854: ,p_pcd_attribute22 in varchar2 default hr_api.g_varchar2
855: ,p_pcd_attribute23 in varchar2 default hr_api.g_varchar2
856: ,p_pcd_attribute24 in varchar2 default hr_api.g_varchar2
857: ,p_pcd_attribute25 in varchar2 default hr_api.g_varchar2
858: ,p_pcd_attribute26 in varchar2 default hr_api.g_varchar2
859: ,p_pcd_attribute27 in varchar2 default hr_api.g_varchar2
860: ,p_pcd_attribute28 in varchar2 default hr_api.g_varchar2
861: ,p_pcd_attribute29 in varchar2 default hr_api.g_varchar2
862: ,p_pcd_attribute30 in varchar2 default hr_api.g_varchar2
855: ,p_pcd_attribute23 in varchar2 default hr_api.g_varchar2
856: ,p_pcd_attribute24 in varchar2 default hr_api.g_varchar2
857: ,p_pcd_attribute25 in varchar2 default hr_api.g_varchar2
858: ,p_pcd_attribute26 in varchar2 default hr_api.g_varchar2
859: ,p_pcd_attribute27 in varchar2 default hr_api.g_varchar2
860: ,p_pcd_attribute28 in varchar2 default hr_api.g_varchar2
861: ,p_pcd_attribute29 in varchar2 default hr_api.g_varchar2
862: ,p_pcd_attribute30 in varchar2 default hr_api.g_varchar2
863: ,p_request_id in number default hr_api.g_number
856: ,p_pcd_attribute24 in varchar2 default hr_api.g_varchar2
857: ,p_pcd_attribute25 in varchar2 default hr_api.g_varchar2
858: ,p_pcd_attribute26 in varchar2 default hr_api.g_varchar2
859: ,p_pcd_attribute27 in varchar2 default hr_api.g_varchar2
860: ,p_pcd_attribute28 in varchar2 default hr_api.g_varchar2
861: ,p_pcd_attribute29 in varchar2 default hr_api.g_varchar2
862: ,p_pcd_attribute30 in varchar2 default hr_api.g_varchar2
863: ,p_request_id in number default hr_api.g_number
864: ,p_program_application_id in number default hr_api.g_number
857: ,p_pcd_attribute25 in varchar2 default hr_api.g_varchar2
858: ,p_pcd_attribute26 in varchar2 default hr_api.g_varchar2
859: ,p_pcd_attribute27 in varchar2 default hr_api.g_varchar2
860: ,p_pcd_attribute28 in varchar2 default hr_api.g_varchar2
861: ,p_pcd_attribute29 in varchar2 default hr_api.g_varchar2
862: ,p_pcd_attribute30 in varchar2 default hr_api.g_varchar2
863: ,p_request_id in number default hr_api.g_number
864: ,p_program_application_id in number default hr_api.g_number
865: ,p_program_id in number default hr_api.g_number
858: ,p_pcd_attribute26 in varchar2 default hr_api.g_varchar2
859: ,p_pcd_attribute27 in varchar2 default hr_api.g_varchar2
860: ,p_pcd_attribute28 in varchar2 default hr_api.g_varchar2
861: ,p_pcd_attribute29 in varchar2 default hr_api.g_varchar2
862: ,p_pcd_attribute30 in varchar2 default hr_api.g_varchar2
863: ,p_request_id in number default hr_api.g_number
864: ,p_program_application_id in number default hr_api.g_number
865: ,p_program_id in number default hr_api.g_number
866: ,p_program_update_date in date default hr_api.g_date
859: ,p_pcd_attribute27 in varchar2 default hr_api.g_varchar2
860: ,p_pcd_attribute28 in varchar2 default hr_api.g_varchar2
861: ,p_pcd_attribute29 in varchar2 default hr_api.g_varchar2
862: ,p_pcd_attribute30 in varchar2 default hr_api.g_varchar2
863: ,p_request_id in number default hr_api.g_number
864: ,p_program_application_id in number default hr_api.g_number
865: ,p_program_id in number default hr_api.g_number
866: ,p_program_update_date in date default hr_api.g_date
867: ,p_object_version_number in out nocopy number
860: ,p_pcd_attribute28 in varchar2 default hr_api.g_varchar2
861: ,p_pcd_attribute29 in varchar2 default hr_api.g_varchar2
862: ,p_pcd_attribute30 in varchar2 default hr_api.g_varchar2
863: ,p_request_id in number default hr_api.g_number
864: ,p_program_application_id in number default hr_api.g_number
865: ,p_program_id in number default hr_api.g_number
866: ,p_program_update_date in date default hr_api.g_date
867: ,p_object_version_number in out nocopy number
868: ,p_effective_date in date
861: ,p_pcd_attribute29 in varchar2 default hr_api.g_varchar2
862: ,p_pcd_attribute30 in varchar2 default hr_api.g_varchar2
863: ,p_request_id in number default hr_api.g_number
864: ,p_program_application_id in number default hr_api.g_number
865: ,p_program_id in number default hr_api.g_number
866: ,p_program_update_date in date default hr_api.g_date
867: ,p_object_version_number in out nocopy number
868: ,p_effective_date in date
869: ,p_datetrack_mode in varchar2) is
862: ,p_pcd_attribute30 in varchar2 default hr_api.g_varchar2
863: ,p_request_id in number default hr_api.g_number
864: ,p_program_application_id in number default hr_api.g_number
865: ,p_program_id in number default hr_api.g_number
866: ,p_program_update_date in date default hr_api.g_date
867: ,p_object_version_number in out nocopy number
868: ,p_effective_date in date
869: ,p_datetrack_mode in varchar2) is
870: --
949: ,p_datetrack_mode => p_datetrack_mode);
950: --
951: exception
952: --
953: when hr_api.cannot_find_prog_unit then
954: --
955: hr_api.cannot_find_prog_unit_error
956: (p_module_name => 'UPDATE_PER_CM_PRVDD'
957: ,p_hook_type => 'BP');
951: exception
952: --
953: when hr_api.cannot_find_prog_unit then
954: --
955: hr_api.cannot_find_prog_unit_error
956: (p_module_name => 'UPDATE_PER_CM_PRVDD'
957: ,p_hook_type => 'BP');
958: --
959: -- End of API User Hook for the before hook of update_PER_CM_PRVDD
1079: ,p_datetrack_mode => p_datetrack_mode);
1080: --
1081: exception
1082: --
1083: when hr_api.cannot_find_prog_unit then
1084: --
1085: hr_api.cannot_find_prog_unit_error
1086: (p_module_name => 'UPDATE_PER_CM_PRVDD'
1087: ,p_hook_type => 'AP');
1081: exception
1082: --
1083: when hr_api.cannot_find_prog_unit then
1084: --
1085: hr_api.cannot_find_prog_unit_error
1086: (p_module_name => 'UPDATE_PER_CM_PRVDD'
1087: ,p_hook_type => 'AP');
1088: --
1089: -- End of API User Hook for the after hook of update_PER_CM_PRVDD
1094: --
1095: -- When in validation only mode raise the Validate_Enabled exception
1096: --
1097: if p_validate then
1098: raise hr_api.validate_enabled;
1099: end if;
1100: --
1101: -- Set all output arguments
1102: --
1107: hr_utility.set_location(' Leaving:'||l_proc, 70);
1108: --
1109: exception
1110: --
1111: when hr_api.validate_enabled then
1112: --
1113: -- As the Validate_Enabled exception has been raised
1114: -- we must rollback to the savepoint
1115: --
1177: ,p_datetrack_mode => p_datetrack_mode);
1178: --
1179: exception
1180: --
1181: when hr_api.cannot_find_prog_unit then
1182: --
1183: hr_api.cannot_find_prog_unit_error
1184: (p_module_name => 'DELETE_PER_CM_PRVDD'
1185: ,p_hook_type => 'BP');
1179: exception
1180: --
1181: when hr_api.cannot_find_prog_unit then
1182: --
1183: hr_api.cannot_find_prog_unit_error
1184: (p_module_name => 'DELETE_PER_CM_PRVDD'
1185: ,p_hook_type => 'BP');
1186: --
1187: -- End of API User Hook for the before hook of delete_PER_CM_PRVDD
1209: ,p_datetrack_mode => p_datetrack_mode);
1210: --
1211: exception
1212: --
1213: when hr_api.cannot_find_prog_unit then
1214: --
1215: hr_api.cannot_find_prog_unit_error
1216: (p_module_name => 'DELETE_PER_CM_PRVDD'
1217: ,p_hook_type => 'AP');
1211: exception
1212: --
1213: when hr_api.cannot_find_prog_unit then
1214: --
1215: hr_api.cannot_find_prog_unit_error
1216: (p_module_name => 'DELETE_PER_CM_PRVDD'
1217: ,p_hook_type => 'AP');
1218: --
1219: -- End of API User Hook for the after hook of delete_PER_CM_PRVDD
1224: --
1225: -- When in validation only mode raise the Validate_Enabled exception
1226: --
1227: if p_validate then
1228: raise hr_api.validate_enabled;
1229: end if;
1230: --
1231: hr_utility.set_location(' Leaving:'||l_proc, 70);
1232: --
1231: hr_utility.set_location(' Leaving:'||l_proc, 70);
1232: --
1233: exception
1234: --
1235: when hr_api.validate_enabled then
1236: --
1237: -- As the Validate_Enabled exception has been raised
1238: -- we must rollback to the savepoint
1239: --