425: ,p_program_update_date => p_program_update_date
426: ,p_effective_date => trunc(p_effective_date)
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (
432: p_module_name => 'CREATE_PRTT_PREM'
433: ,p_hook_type => 'BP'
426: ,p_effective_date => trunc(p_effective_date)
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (
432: p_module_name => 'CREATE_PRTT_PREM'
433: ,p_hook_type => 'BP'
434: );
540: ,p_program_update_date => p_program_update_date
541: ,p_effective_date => trunc(p_effective_date)
542: );
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'CREATE_PRTT_PREM'
547: ,p_hook_type => 'AP'
548: );
541: ,p_effective_date => trunc(p_effective_date)
542: );
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'CREATE_PRTT_PREM'
547: ,p_hook_type => 'AP'
548: );
549: --
555: --
556: -- When in validation only mode raise the Validate_Enabled exception
557: --
558: if p_validate then
559: raise hr_api.validate_enabled;
560: end if;
561: --
562: -- Set all output arguments
563: --
569: hr_utility.set_location(' Leaving:'||l_proc, 70);
570: --
571: exception
572: --
573: when hr_api.validate_enabled then
574: --
575: -- As the Validate_Enabled exception has been raised
576: -- we must rollback to the savepoint
577: --
732: ,p_program_update_date => p_program_update_date
733: ,p_effective_date => trunc(p_effective_date)
734: );
735: exception
736: when hr_api.cannot_find_prog_unit then
737: hr_api.cannot_find_prog_unit_error
738: (
739: p_module_name => 'CREATE_PRTT_PREM'
740: ,p_hook_type => 'BP'
733: ,p_effective_date => trunc(p_effective_date)
734: );
735: exception
736: when hr_api.cannot_find_prog_unit then
737: hr_api.cannot_find_prog_unit_error
738: (
739: p_module_name => 'CREATE_PRTT_PREM'
740: ,p_hook_type => 'BP'
741: );
847: ,p_program_update_date => p_program_update_date
848: ,p_effective_date => trunc(p_effective_date)
849: );
850: exception
851: when hr_api.cannot_find_prog_unit then
852: hr_api.cannot_find_prog_unit_error
853: (p_module_name => 'CREATE_PRTT_PREM'
854: ,p_hook_type => 'AP'
855: );
848: ,p_effective_date => trunc(p_effective_date)
849: );
850: exception
851: when hr_api.cannot_find_prog_unit then
852: hr_api.cannot_find_prog_unit_error
853: (p_module_name => 'CREATE_PRTT_PREM'
854: ,p_hook_type => 'AP'
855: );
856: --
862: --
863: -- When in validation only mode raise the Validate_Enabled exception
864: --
865: if p_validate then
866: raise hr_api.validate_enabled;
867: end if;
868: --
869: -- Set all output arguments
870: --
876: hr_utility.set_location(' Leaving:'||l_proc, 70);
877: --
878: exception
879: --
880: when hr_api.validate_enabled then
881: --
882: -- As the Validate_Enabled exception has been raised
883: -- we must rollback to the savepoint
884: --
910: (p_validate in boolean default false
911: ,p_prtt_prem_id in number
912: ,p_effective_start_date out nocopy date
913: ,p_effective_end_date out nocopy date
914: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
915: ,p_std_prem_val in number default hr_api.g_number
916: ,p_actl_prem_id in number default hr_api.g_number
917: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
918: ,p_per_in_ler_id in number
911: ,p_prtt_prem_id in number
912: ,p_effective_start_date out nocopy date
913: ,p_effective_end_date out nocopy date
914: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
915: ,p_std_prem_val in number default hr_api.g_number
916: ,p_actl_prem_id in number default hr_api.g_number
917: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
918: ,p_per_in_ler_id in number
919: ,p_business_group_id in number default hr_api.g_number
912: ,p_effective_start_date out nocopy date
913: ,p_effective_end_date out nocopy date
914: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
915: ,p_std_prem_val in number default hr_api.g_number
916: ,p_actl_prem_id in number default hr_api.g_number
917: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
918: ,p_per_in_ler_id in number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
913: ,p_effective_end_date out nocopy date
914: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
915: ,p_std_prem_val in number default hr_api.g_number
916: ,p_actl_prem_id in number default hr_api.g_number
917: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
918: ,p_per_in_ler_id in number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
921: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
915: ,p_std_prem_val in number default hr_api.g_number
916: ,p_actl_prem_id in number default hr_api.g_number
917: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
918: ,p_per_in_ler_id in number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
921: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
922: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
923: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
916: ,p_actl_prem_id in number default hr_api.g_number
917: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
918: ,p_per_in_ler_id in number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
921: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
922: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
923: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
924: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
917: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
918: ,p_per_in_ler_id in number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
921: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
922: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
923: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
924: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
925: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
918: ,p_per_in_ler_id in number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
921: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
922: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
923: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
924: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
925: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
926: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
921: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
922: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
923: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
924: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
925: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
926: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
927: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
920: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
921: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
922: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
923: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
924: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
925: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
926: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
927: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
928: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
921: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
922: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
923: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
924: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
925: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
926: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
927: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
928: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
929: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
922: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
923: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
924: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
925: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
926: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
927: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
928: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
929: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
930: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
923: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
924: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
925: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
926: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
927: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
928: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
929: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
930: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
931: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
924: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
925: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
926: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
927: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
928: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
929: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
930: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
931: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
932: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
925: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
926: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
927: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
928: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
929: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
930: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
931: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
932: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
933: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
926: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
927: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
928: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
929: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
930: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
931: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
932: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
933: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
934: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
927: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
928: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
929: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
930: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
931: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
932: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
933: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
934: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
935: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
928: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
929: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
930: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
931: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
932: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
933: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
934: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
935: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
936: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
929: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
930: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
931: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
932: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
933: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
934: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
935: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
936: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
937: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
930: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
931: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
932: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
933: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
934: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
935: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
936: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
937: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
938: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
931: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
932: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
933: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
934: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
935: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
936: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
937: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
938: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
939: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
932: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
933: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
934: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
935: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
936: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
937: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
938: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
939: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
940: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
933: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
934: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
935: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
936: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
937: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
938: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
939: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
940: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
941: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
934: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
935: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
936: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
937: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
938: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
939: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
940: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
941: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
942: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
935: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
936: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
937: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
938: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
939: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
940: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
941: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
942: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
943: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
936: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
937: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
938: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
939: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
940: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
941: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
942: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
943: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
944: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
937: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
938: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
939: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
940: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
941: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
942: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
943: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
944: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
945: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
938: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
939: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
940: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
941: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
942: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
943: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
944: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
945: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
946: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
939: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
940: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
941: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
942: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
943: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
944: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
945: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
946: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
947: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
940: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
941: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
942: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
943: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
944: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
945: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
946: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
947: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
948: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
941: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
942: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
943: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
944: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
945: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
946: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
947: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
948: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
949: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
942: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
943: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
944: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
945: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
946: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
947: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
948: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
949: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
950: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
943: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
944: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
945: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
946: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
947: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
948: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
949: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
950: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
951: ,p_object_version_number in out nocopy number
944: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
945: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
946: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
947: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
948: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
949: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
950: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
951: ,p_object_version_number in out nocopy number
952: ,p_request_id in number default hr_api.g_number
945: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
946: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
947: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
948: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
949: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
950: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
951: ,p_object_version_number in out nocopy number
952: ,p_request_id in number default hr_api.g_number
953: ,p_program_application_id in number default hr_api.g_number
946: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
947: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
948: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
949: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
950: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
951: ,p_object_version_number in out nocopy number
952: ,p_request_id in number default hr_api.g_number
953: ,p_program_application_id in number default hr_api.g_number
954: ,p_program_id in number default hr_api.g_number
948: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
949: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
950: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
951: ,p_object_version_number in out nocopy number
952: ,p_request_id in number default hr_api.g_number
953: ,p_program_application_id in number default hr_api.g_number
954: ,p_program_id in number default hr_api.g_number
955: ,p_program_update_date in date default hr_api.g_date
956: ,p_effective_date in date
949: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
950: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
951: ,p_object_version_number in out nocopy number
952: ,p_request_id in number default hr_api.g_number
953: ,p_program_application_id in number default hr_api.g_number
954: ,p_program_id in number default hr_api.g_number
955: ,p_program_update_date in date default hr_api.g_date
956: ,p_effective_date in date
957: ,p_datetrack_mode in varchar2
950: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
951: ,p_object_version_number in out nocopy number
952: ,p_request_id in number default hr_api.g_number
953: ,p_program_application_id in number default hr_api.g_number
954: ,p_program_id in number default hr_api.g_number
955: ,p_program_update_date in date default hr_api.g_date
956: ,p_effective_date in date
957: ,p_datetrack_mode in varchar2
958: ) is
951: ,p_object_version_number in out nocopy number
952: ,p_request_id in number default hr_api.g_number
953: ,p_program_application_id in number default hr_api.g_number
954: ,p_program_id in number default hr_api.g_number
955: ,p_program_update_date in date default hr_api.g_date
956: ,p_effective_date in date
957: ,p_datetrack_mode in varchar2
958: ) is
959: --
1030: ,p_effective_date => trunc(p_effective_date)
1031: ,p_datetrack_mode => p_datetrack_mode
1032: );
1033: exception
1034: when hr_api.cannot_find_prog_unit then
1035: hr_api.cannot_find_prog_unit_error
1036: (p_module_name => 'UPDATE_PRTT_PREM'
1037: ,p_hook_type => 'BP'
1038: );
1031: ,p_datetrack_mode => p_datetrack_mode
1032: );
1033: exception
1034: when hr_api.cannot_find_prog_unit then
1035: hr_api.cannot_find_prog_unit_error
1036: (p_module_name => 'UPDATE_PRTT_PREM'
1037: ,p_hook_type => 'BP'
1038: );
1039: --
1146: ,p_effective_date => trunc(p_effective_date)
1147: ,p_datetrack_mode => p_datetrack_mode
1148: );
1149: exception
1150: when hr_api.cannot_find_prog_unit then
1151: hr_api.cannot_find_prog_unit_error
1152: (p_module_name => 'UPDATE_PRTT_PREM'
1153: ,p_hook_type => 'AP'
1154: );
1147: ,p_datetrack_mode => p_datetrack_mode
1148: );
1149: exception
1150: when hr_api.cannot_find_prog_unit then
1151: hr_api.cannot_find_prog_unit_error
1152: (p_module_name => 'UPDATE_PRTT_PREM'
1153: ,p_hook_type => 'AP'
1154: );
1155: --
1161: --
1162: -- When in validation only mode raise the Validate_Enabled exception
1163: --
1164: if p_validate then
1165: raise hr_api.validate_enabled;
1166: end if;
1167: --
1168: -- Set all output arguments
1169: --
1174: hr_utility.set_location(' Leaving:'||l_proc, 70);
1175: --
1176: exception
1177: --
1178: when hr_api.validate_enabled then
1179: --
1180: -- As the Validate_Enabled exception has been raised
1181: -- we must rollback to the savepoint
1182: --
1204: (p_validate in boolean default false
1205: ,p_prtt_prem_id in number
1206: ,p_effective_start_date out nocopy date
1207: ,p_effective_end_date out nocopy date
1208: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
1209: ,p_std_prem_val in number default hr_api.g_number
1210: ,p_actl_prem_id in number default hr_api.g_number
1211: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1212: ,p_business_group_id in number default hr_api.g_number
1205: ,p_prtt_prem_id in number
1206: ,p_effective_start_date out nocopy date
1207: ,p_effective_end_date out nocopy date
1208: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
1209: ,p_std_prem_val in number default hr_api.g_number
1210: ,p_actl_prem_id in number default hr_api.g_number
1211: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1212: ,p_business_group_id in number default hr_api.g_number
1213: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
1206: ,p_effective_start_date out nocopy date
1207: ,p_effective_end_date out nocopy date
1208: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
1209: ,p_std_prem_val in number default hr_api.g_number
1210: ,p_actl_prem_id in number default hr_api.g_number
1211: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1212: ,p_business_group_id in number default hr_api.g_number
1213: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
1207: ,p_effective_end_date out nocopy date
1208: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
1209: ,p_std_prem_val in number default hr_api.g_number
1210: ,p_actl_prem_id in number default hr_api.g_number
1211: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1212: ,p_business_group_id in number default hr_api.g_number
1213: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
1215: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
1208: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
1209: ,p_std_prem_val in number default hr_api.g_number
1210: ,p_actl_prem_id in number default hr_api.g_number
1211: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1212: ,p_business_group_id in number default hr_api.g_number
1213: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
1215: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
1216: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
1209: ,p_std_prem_val in number default hr_api.g_number
1210: ,p_actl_prem_id in number default hr_api.g_number
1211: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1212: ,p_business_group_id in number default hr_api.g_number
1213: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
1215: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
1216: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
1217: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
1210: ,p_actl_prem_id in number default hr_api.g_number
1211: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1212: ,p_business_group_id in number default hr_api.g_number
1213: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
1215: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
1216: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
1217: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
1218: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
1211: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1212: ,p_business_group_id in number default hr_api.g_number
1213: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
1215: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
1216: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
1217: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
1218: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
1219: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
1212: ,p_business_group_id in number default hr_api.g_number
1213: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
1215: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
1216: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
1217: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
1218: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
1219: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
1220: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
1213: ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
1215: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
1216: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
1217: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
1218: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
1219: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
1220: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
1221: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
1215: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
1216: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
1217: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
1218: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
1219: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
1220: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
1221: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
1222: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
1215: ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
1216: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
1217: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
1218: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
1219: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
1220: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
1221: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
1222: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
1223: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
1216: ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
1217: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
1218: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
1219: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
1220: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
1221: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
1222: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
1223: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
1224: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
1217: ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
1218: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
1219: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
1220: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
1221: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
1222: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
1223: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
1224: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
1225: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
1218: ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
1219: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
1220: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
1221: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
1222: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
1223: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
1224: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
1225: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
1226: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
1219: ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
1220: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
1221: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
1222: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
1223: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
1224: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
1225: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
1226: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
1227: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
1220: ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
1221: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
1222: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
1223: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
1224: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
1225: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
1226: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
1227: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
1228: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
1221: ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
1222: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
1223: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
1224: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
1225: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
1226: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
1227: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
1228: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
1229: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
1222: ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
1223: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
1224: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
1225: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
1226: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
1227: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
1228: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
1229: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
1230: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
1223: ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
1224: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
1225: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
1226: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
1227: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
1228: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
1229: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
1230: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
1231: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
1224: ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
1225: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
1226: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
1227: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
1228: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
1229: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
1230: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
1231: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
1232: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
1225: ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
1226: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
1227: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
1228: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
1229: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
1230: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
1231: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
1232: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
1233: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
1226: ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
1227: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
1228: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
1229: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
1230: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
1231: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
1232: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
1233: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
1234: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
1227: ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
1228: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
1229: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
1230: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
1231: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
1232: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
1233: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
1234: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
1235: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
1228: ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
1229: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
1230: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
1231: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
1232: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
1233: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
1234: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
1235: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
1236: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
1229: ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
1230: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
1231: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
1232: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
1233: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
1234: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
1235: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
1236: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
1237: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
1230: ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
1231: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
1232: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
1233: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
1234: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
1235: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
1236: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
1237: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
1238: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
1231: ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
1232: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
1233: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
1234: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
1235: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
1236: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
1237: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
1238: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
1239: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
1232: ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
1233: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
1234: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
1235: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
1236: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
1237: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
1238: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
1239: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
1240: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
1233: ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
1234: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
1235: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
1236: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
1237: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
1238: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
1239: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
1240: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
1241: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
1234: ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
1235: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
1236: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
1237: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
1238: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
1239: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
1240: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
1241: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
1242: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
1235: ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
1236: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
1237: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
1238: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
1239: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
1240: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
1241: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
1242: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
1243: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
1236: ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
1237: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
1238: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
1239: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
1240: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
1241: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
1242: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
1243: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
1244: ,p_object_version_number in out nocopy number
1237: ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
1238: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
1239: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
1240: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
1241: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
1242: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
1243: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
1244: ,p_object_version_number in out nocopy number
1245: ,p_request_id in number default hr_api.g_number
1238: ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
1239: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
1240: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
1241: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
1242: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
1243: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
1244: ,p_object_version_number in out nocopy number
1245: ,p_request_id in number default hr_api.g_number
1246: ,p_program_application_id in number default hr_api.g_number
1239: ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
1240: ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
1241: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
1242: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
1243: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
1244: ,p_object_version_number in out nocopy number
1245: ,p_request_id in number default hr_api.g_number
1246: ,p_program_application_id in number default hr_api.g_number
1247: ,p_program_id in number default hr_api.g_number
1241: ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
1242: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
1243: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
1244: ,p_object_version_number in out nocopy number
1245: ,p_request_id in number default hr_api.g_number
1246: ,p_program_application_id in number default hr_api.g_number
1247: ,p_program_id in number default hr_api.g_number
1248: ,p_program_update_date in date default hr_api.g_date
1249: ,p_effective_date in date
1242: ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
1243: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
1244: ,p_object_version_number in out nocopy number
1245: ,p_request_id in number default hr_api.g_number
1246: ,p_program_application_id in number default hr_api.g_number
1247: ,p_program_id in number default hr_api.g_number
1248: ,p_program_update_date in date default hr_api.g_date
1249: ,p_effective_date in date
1250: ,p_datetrack_mode in varchar2
1243: ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
1244: ,p_object_version_number in out nocopy number
1245: ,p_request_id in number default hr_api.g_number
1246: ,p_program_application_id in number default hr_api.g_number
1247: ,p_program_id in number default hr_api.g_number
1248: ,p_program_update_date in date default hr_api.g_date
1249: ,p_effective_date in date
1250: ,p_datetrack_mode in varchar2
1251: ) is
1244: ,p_object_version_number in out nocopy number
1245: ,p_request_id in number default hr_api.g_number
1246: ,p_program_application_id in number default hr_api.g_number
1247: ,p_program_id in number default hr_api.g_number
1248: ,p_program_update_date in date default hr_api.g_date
1249: ,p_effective_date in date
1250: ,p_datetrack_mode in varchar2
1251: ) is
1252: --
1277: --
1278: open c_per_in_ler;
1279: fetch c_per_in_ler into l_per_in_ler_id;
1280: if c_per_in_ler%notfound then
1281: l_per_in_ler_id:=hr_api.g_number;
1282: end if;
1283: close c_per_in_ler;
1284: --
1285: hr_utility.set_location(l_proc, 20);
1340: ,p_effective_date => trunc(p_effective_date)
1341: ,p_datetrack_mode => p_datetrack_mode
1342: );
1343: exception
1344: when hr_api.cannot_find_prog_unit then
1345: hr_api.cannot_find_prog_unit_error
1346: (p_module_name => 'UPDATE_PRTT_PREM'
1347: ,p_hook_type => 'BP'
1348: );
1341: ,p_datetrack_mode => p_datetrack_mode
1342: );
1343: exception
1344: when hr_api.cannot_find_prog_unit then
1345: hr_api.cannot_find_prog_unit_error
1346: (p_module_name => 'UPDATE_PRTT_PREM'
1347: ,p_hook_type => 'BP'
1348: );
1349: --
1456: ,p_effective_date => trunc(p_effective_date)
1457: ,p_datetrack_mode => p_datetrack_mode
1458: );
1459: exception
1460: when hr_api.cannot_find_prog_unit then
1461: hr_api.cannot_find_prog_unit_error
1462: (p_module_name => 'UPDATE_PRTT_PREM'
1463: ,p_hook_type => 'AP'
1464: );
1457: ,p_datetrack_mode => p_datetrack_mode
1458: );
1459: exception
1460: when hr_api.cannot_find_prog_unit then
1461: hr_api.cannot_find_prog_unit_error
1462: (p_module_name => 'UPDATE_PRTT_PREM'
1463: ,p_hook_type => 'AP'
1464: );
1465: --
1471: --
1472: -- When in validation only mode raise the Validate_Enabled exception
1473: --
1474: if p_validate then
1475: raise hr_api.validate_enabled;
1476: end if;
1477: --
1478: -- Set all output arguments
1479: --
1484: hr_utility.set_location(' Leaving:'||l_proc, 70);
1485: --
1486: exception
1487: --
1488: when hr_api.validate_enabled then
1489: --
1490: -- As the Validate_Enabled exception has been raised
1491: -- we must rollback to the savepoint
1492: --
1553: ,p_effective_date => trunc(p_effective_date)
1554: ,p_datetrack_mode => p_datetrack_mode
1555: );
1556: exception
1557: when hr_api.cannot_find_prog_unit then
1558: hr_api.cannot_find_prog_unit_error
1559: (p_module_name => 'DELETE_PRTT_PREM'
1560: ,p_hook_type => 'BP'
1561: );
1554: ,p_datetrack_mode => p_datetrack_mode
1555: );
1556: exception
1557: when hr_api.cannot_find_prog_unit then
1558: hr_api.cannot_find_prog_unit_error
1559: (p_module_name => 'DELETE_PRTT_PREM'
1560: ,p_hook_type => 'BP'
1561: );
1562: --
1587: ,p_effective_date => trunc(p_effective_date)
1588: ,p_datetrack_mode => p_datetrack_mode
1589: );
1590: exception
1591: when hr_api.cannot_find_prog_unit then
1592: hr_api.cannot_find_prog_unit_error
1593: (p_module_name => 'DELETE_PRTT_PREM'
1594: ,p_hook_type => 'AP'
1595: );
1588: ,p_datetrack_mode => p_datetrack_mode
1589: );
1590: exception
1591: when hr_api.cannot_find_prog_unit then
1592: hr_api.cannot_find_prog_unit_error
1593: (p_module_name => 'DELETE_PRTT_PREM'
1594: ,p_hook_type => 'AP'
1595: );
1596: --
1602: --
1603: -- When in validation only mode raise the Validate_Enabled exception
1604: --
1605: if p_validate then
1606: raise hr_api.validate_enabled;
1607: end if;
1608: --
1609: hr_utility.set_location(' Leaving:'||l_proc, 70);
1610: --
1609: hr_utility.set_location(' Leaving:'||l_proc, 70);
1610: --
1611: exception
1612: --
1613: when hr_api.validate_enabled then
1614: --
1615: -- As the Validate_Enabled exception has been raised
1616: -- we must rollback to the savepoint
1617: --