DBA Data[Home] [Help]

APPS.BEN_PRTT_PREM_API dependencies on HR_API

Line 429: when hr_api.cannot_find_prog_unit then

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'

Line 430: hr_api.cannot_find_prog_unit_error

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: );

Line 544: when hr_api.cannot_find_prog_unit then

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: );

Line 545: hr_api.cannot_find_prog_unit_error

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: --

Line 559: raise hr_api.validate_enabled;

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: --

Line 573: when hr_api.validate_enabled then

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: --

Line 736: when hr_api.cannot_find_prog_unit then

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'

Line 737: hr_api.cannot_find_prog_unit_error

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: );

Line 851: when hr_api.cannot_find_prog_unit then

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: );

Line 852: hr_api.cannot_find_prog_unit_error

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: --

Line 866: raise hr_api.validate_enabled;

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: --

Line 880: when hr_api.validate_enabled then

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: --

Line 914: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2

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

Line 915: ,p_std_prem_val in number default hr_api.g_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

Line 916: ,p_actl_prem_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

Line 917: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

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

Line 919: ,p_business_group_id in number default hr_api.g_number

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

Line 920: ,p_ppe_attribute_category 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

Line 921: ,p_ppe_attribute1 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

Line 922: ,p_ppe_attribute2 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

Line 923: ,p_ppe_attribute3 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

Line 924: ,p_ppe_attribute4 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

Line 925: ,p_ppe_attribute5 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

Line 926: ,p_ppe_attribute6 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

Line 927: ,p_ppe_attribute7 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

Line 928: ,p_ppe_attribute8 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

Line 929: ,p_ppe_attribute9 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

Line 930: ,p_ppe_attribute10 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

Line 931: ,p_ppe_attribute11 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

Line 932: ,p_ppe_attribute12 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

Line 933: ,p_ppe_attribute13 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

Line 934: ,p_ppe_attribute14 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

Line 935: ,p_ppe_attribute15 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

Line 936: ,p_ppe_attribute16 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

Line 937: ,p_ppe_attribute17 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

Line 938: ,p_ppe_attribute18 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

Line 939: ,p_ppe_attribute19 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

Line 940: ,p_ppe_attribute20 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

Line 941: ,p_ppe_attribute21 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

Line 942: ,p_ppe_attribute22 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

Line 943: ,p_ppe_attribute23 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

Line 944: ,p_ppe_attribute24 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

Line 945: ,p_ppe_attribute25 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

Line 946: ,p_ppe_attribute26 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

Line 947: ,p_ppe_attribute27 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

Line 948: ,p_ppe_attribute28 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
952: ,p_request_id in number default hr_api.g_number

Line 949: ,p_ppe_attribute29 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
953: ,p_program_application_id in number default hr_api.g_number

Line 950: ,p_ppe_attribute30 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
954: ,p_program_id in number default hr_api.g_number

Line 952: ,p_request_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

Line 953: ,p_program_application_id in number default hr_api.g_number

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

Line 954: ,p_program_id in number default hr_api.g_number

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

Line 955: ,p_program_update_date in date default hr_api.g_date

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: --

Line 1034: when hr_api.cannot_find_prog_unit then

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: );

Line 1035: hr_api.cannot_find_prog_unit_error

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: --

Line 1150: when hr_api.cannot_find_prog_unit then

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: );

Line 1151: hr_api.cannot_find_prog_unit_error

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: --

Line 1165: raise hr_api.validate_enabled;

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: --

Line 1178: when hr_api.validate_enabled then

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: --

Line 1208: ,p_std_prem_uom in varchar2 default hr_api.g_varchar2

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

Line 1209: ,p_std_prem_val 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

Line 1210: ,p_actl_prem_id in number default hr_api.g_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
1214: ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2

Line 1211: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

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

Line 1212: ,p_business_group_id in number default hr_api.g_number

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

Line 1213: ,p_ppe_attribute_category 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

Line 1214: ,p_ppe_attribute1 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

Line 1215: ,p_ppe_attribute2 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

Line 1216: ,p_ppe_attribute3 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

Line 1217: ,p_ppe_attribute4 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

Line 1218: ,p_ppe_attribute5 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

Line 1219: ,p_ppe_attribute6 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

Line 1220: ,p_ppe_attribute7 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

Line 1221: ,p_ppe_attribute8 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

Line 1222: ,p_ppe_attribute9 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

Line 1223: ,p_ppe_attribute10 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

Line 1224: ,p_ppe_attribute11 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

Line 1225: ,p_ppe_attribute12 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

Line 1226: ,p_ppe_attribute13 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

Line 1227: ,p_ppe_attribute14 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

Line 1228: ,p_ppe_attribute15 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

Line 1229: ,p_ppe_attribute16 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

Line 1230: ,p_ppe_attribute17 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

Line 1231: ,p_ppe_attribute18 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

Line 1232: ,p_ppe_attribute19 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

Line 1233: ,p_ppe_attribute20 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

Line 1234: ,p_ppe_attribute21 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

Line 1235: ,p_ppe_attribute22 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

Line 1236: ,p_ppe_attribute23 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

Line 1237: ,p_ppe_attribute24 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

Line 1238: ,p_ppe_attribute25 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

Line 1239: ,p_ppe_attribute26 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

Line 1240: ,p_ppe_attribute27 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

Line 1241: ,p_ppe_attribute28 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
1245: ,p_request_id in number default hr_api.g_number

Line 1242: ,p_ppe_attribute29 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
1246: ,p_program_application_id in number default hr_api.g_number

Line 1243: ,p_ppe_attribute30 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
1247: ,p_program_id in number default hr_api.g_number

Line 1245: ,p_request_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

Line 1246: ,p_program_application_id in number default hr_api.g_number

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

Line 1247: ,p_program_id in number default hr_api.g_number

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

Line 1248: ,p_program_update_date in date default hr_api.g_date

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: --

Line 1281: l_per_in_ler_id:=hr_api.g_number;

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);

Line 1344: when hr_api.cannot_find_prog_unit then

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: );

Line 1345: hr_api.cannot_find_prog_unit_error

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: --

Line 1460: when hr_api.cannot_find_prog_unit then

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: );

Line 1461: hr_api.cannot_find_prog_unit_error

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: --

Line 1475: raise hr_api.validate_enabled;

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: --

Line 1488: when hr_api.validate_enabled then

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: --

Line 1557: when hr_api.cannot_find_prog_unit then

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: );

Line 1558: hr_api.cannot_find_prog_unit_error

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: --

Line 1591: when hr_api.cannot_find_prog_unit then

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: );

Line 1592: hr_api.cannot_find_prog_unit_error

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: --

Line 1606: raise hr_api.validate_enabled;

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: --

Line 1613: when hr_api.validate_enabled then

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: --