14: ,p_person_type_usage_id in number
15: ,p_effective_date in date
16: ,p_datetrack_mode in varchar2
17: ,p_object_version_number in out nocopy number
18: ,p_person_type_id in number default hr_api.g_number
19: ,p_attribute_category in varchar2 default hr_api.g_varchar2
20: ,p_attribute1 in varchar2 default hr_api.g_varchar2
21: ,p_attribute2 in varchar2 default hr_api.g_varchar2
22: ,p_attribute3 in varchar2 default hr_api.g_varchar2
15: ,p_effective_date in date
16: ,p_datetrack_mode in varchar2
17: ,p_object_version_number in out nocopy number
18: ,p_person_type_id in number default hr_api.g_number
19: ,p_attribute_category in varchar2 default hr_api.g_varchar2
20: ,p_attribute1 in varchar2 default hr_api.g_varchar2
21: ,p_attribute2 in varchar2 default hr_api.g_varchar2
22: ,p_attribute3 in varchar2 default hr_api.g_varchar2
23: ,p_attribute4 in varchar2 default hr_api.g_varchar2
16: ,p_datetrack_mode in varchar2
17: ,p_object_version_number in out nocopy number
18: ,p_person_type_id in number default hr_api.g_number
19: ,p_attribute_category in varchar2 default hr_api.g_varchar2
20: ,p_attribute1 in varchar2 default hr_api.g_varchar2
21: ,p_attribute2 in varchar2 default hr_api.g_varchar2
22: ,p_attribute3 in varchar2 default hr_api.g_varchar2
23: ,p_attribute4 in varchar2 default hr_api.g_varchar2
24: ,p_attribute5 in varchar2 default hr_api.g_varchar2
17: ,p_object_version_number in out nocopy number
18: ,p_person_type_id in number default hr_api.g_number
19: ,p_attribute_category in varchar2 default hr_api.g_varchar2
20: ,p_attribute1 in varchar2 default hr_api.g_varchar2
21: ,p_attribute2 in varchar2 default hr_api.g_varchar2
22: ,p_attribute3 in varchar2 default hr_api.g_varchar2
23: ,p_attribute4 in varchar2 default hr_api.g_varchar2
24: ,p_attribute5 in varchar2 default hr_api.g_varchar2
25: ,p_attribute6 in varchar2 default hr_api.g_varchar2
18: ,p_person_type_id in number default hr_api.g_number
19: ,p_attribute_category in varchar2 default hr_api.g_varchar2
20: ,p_attribute1 in varchar2 default hr_api.g_varchar2
21: ,p_attribute2 in varchar2 default hr_api.g_varchar2
22: ,p_attribute3 in varchar2 default hr_api.g_varchar2
23: ,p_attribute4 in varchar2 default hr_api.g_varchar2
24: ,p_attribute5 in varchar2 default hr_api.g_varchar2
25: ,p_attribute6 in varchar2 default hr_api.g_varchar2
26: ,p_attribute7 in varchar2 default hr_api.g_varchar2
19: ,p_attribute_category in varchar2 default hr_api.g_varchar2
20: ,p_attribute1 in varchar2 default hr_api.g_varchar2
21: ,p_attribute2 in varchar2 default hr_api.g_varchar2
22: ,p_attribute3 in varchar2 default hr_api.g_varchar2
23: ,p_attribute4 in varchar2 default hr_api.g_varchar2
24: ,p_attribute5 in varchar2 default hr_api.g_varchar2
25: ,p_attribute6 in varchar2 default hr_api.g_varchar2
26: ,p_attribute7 in varchar2 default hr_api.g_varchar2
27: ,p_attribute8 in varchar2 default hr_api.g_varchar2
20: ,p_attribute1 in varchar2 default hr_api.g_varchar2
21: ,p_attribute2 in varchar2 default hr_api.g_varchar2
22: ,p_attribute3 in varchar2 default hr_api.g_varchar2
23: ,p_attribute4 in varchar2 default hr_api.g_varchar2
24: ,p_attribute5 in varchar2 default hr_api.g_varchar2
25: ,p_attribute6 in varchar2 default hr_api.g_varchar2
26: ,p_attribute7 in varchar2 default hr_api.g_varchar2
27: ,p_attribute8 in varchar2 default hr_api.g_varchar2
28: ,p_attribute9 in varchar2 default hr_api.g_varchar2
21: ,p_attribute2 in varchar2 default hr_api.g_varchar2
22: ,p_attribute3 in varchar2 default hr_api.g_varchar2
23: ,p_attribute4 in varchar2 default hr_api.g_varchar2
24: ,p_attribute5 in varchar2 default hr_api.g_varchar2
25: ,p_attribute6 in varchar2 default hr_api.g_varchar2
26: ,p_attribute7 in varchar2 default hr_api.g_varchar2
27: ,p_attribute8 in varchar2 default hr_api.g_varchar2
28: ,p_attribute9 in varchar2 default hr_api.g_varchar2
29: ,p_attribute10 in varchar2 default hr_api.g_varchar2
22: ,p_attribute3 in varchar2 default hr_api.g_varchar2
23: ,p_attribute4 in varchar2 default hr_api.g_varchar2
24: ,p_attribute5 in varchar2 default hr_api.g_varchar2
25: ,p_attribute6 in varchar2 default hr_api.g_varchar2
26: ,p_attribute7 in varchar2 default hr_api.g_varchar2
27: ,p_attribute8 in varchar2 default hr_api.g_varchar2
28: ,p_attribute9 in varchar2 default hr_api.g_varchar2
29: ,p_attribute10 in varchar2 default hr_api.g_varchar2
30: ,p_attribute11 in varchar2 default hr_api.g_varchar2
23: ,p_attribute4 in varchar2 default hr_api.g_varchar2
24: ,p_attribute5 in varchar2 default hr_api.g_varchar2
25: ,p_attribute6 in varchar2 default hr_api.g_varchar2
26: ,p_attribute7 in varchar2 default hr_api.g_varchar2
27: ,p_attribute8 in varchar2 default hr_api.g_varchar2
28: ,p_attribute9 in varchar2 default hr_api.g_varchar2
29: ,p_attribute10 in varchar2 default hr_api.g_varchar2
30: ,p_attribute11 in varchar2 default hr_api.g_varchar2
31: ,p_attribute12 in varchar2 default hr_api.g_varchar2
24: ,p_attribute5 in varchar2 default hr_api.g_varchar2
25: ,p_attribute6 in varchar2 default hr_api.g_varchar2
26: ,p_attribute7 in varchar2 default hr_api.g_varchar2
27: ,p_attribute8 in varchar2 default hr_api.g_varchar2
28: ,p_attribute9 in varchar2 default hr_api.g_varchar2
29: ,p_attribute10 in varchar2 default hr_api.g_varchar2
30: ,p_attribute11 in varchar2 default hr_api.g_varchar2
31: ,p_attribute12 in varchar2 default hr_api.g_varchar2
32: ,p_attribute13 in varchar2 default hr_api.g_varchar2
25: ,p_attribute6 in varchar2 default hr_api.g_varchar2
26: ,p_attribute7 in varchar2 default hr_api.g_varchar2
27: ,p_attribute8 in varchar2 default hr_api.g_varchar2
28: ,p_attribute9 in varchar2 default hr_api.g_varchar2
29: ,p_attribute10 in varchar2 default hr_api.g_varchar2
30: ,p_attribute11 in varchar2 default hr_api.g_varchar2
31: ,p_attribute12 in varchar2 default hr_api.g_varchar2
32: ,p_attribute13 in varchar2 default hr_api.g_varchar2
33: ,p_attribute14 in varchar2 default hr_api.g_varchar2
26: ,p_attribute7 in varchar2 default hr_api.g_varchar2
27: ,p_attribute8 in varchar2 default hr_api.g_varchar2
28: ,p_attribute9 in varchar2 default hr_api.g_varchar2
29: ,p_attribute10 in varchar2 default hr_api.g_varchar2
30: ,p_attribute11 in varchar2 default hr_api.g_varchar2
31: ,p_attribute12 in varchar2 default hr_api.g_varchar2
32: ,p_attribute13 in varchar2 default hr_api.g_varchar2
33: ,p_attribute14 in varchar2 default hr_api.g_varchar2
34: ,p_attribute15 in varchar2 default hr_api.g_varchar2
27: ,p_attribute8 in varchar2 default hr_api.g_varchar2
28: ,p_attribute9 in varchar2 default hr_api.g_varchar2
29: ,p_attribute10 in varchar2 default hr_api.g_varchar2
30: ,p_attribute11 in varchar2 default hr_api.g_varchar2
31: ,p_attribute12 in varchar2 default hr_api.g_varchar2
32: ,p_attribute13 in varchar2 default hr_api.g_varchar2
33: ,p_attribute14 in varchar2 default hr_api.g_varchar2
34: ,p_attribute15 in varchar2 default hr_api.g_varchar2
35: ,p_attribute16 in varchar2 default hr_api.g_varchar2
28: ,p_attribute9 in varchar2 default hr_api.g_varchar2
29: ,p_attribute10 in varchar2 default hr_api.g_varchar2
30: ,p_attribute11 in varchar2 default hr_api.g_varchar2
31: ,p_attribute12 in varchar2 default hr_api.g_varchar2
32: ,p_attribute13 in varchar2 default hr_api.g_varchar2
33: ,p_attribute14 in varchar2 default hr_api.g_varchar2
34: ,p_attribute15 in varchar2 default hr_api.g_varchar2
35: ,p_attribute16 in varchar2 default hr_api.g_varchar2
36: ,p_attribute17 in varchar2 default hr_api.g_varchar2
29: ,p_attribute10 in varchar2 default hr_api.g_varchar2
30: ,p_attribute11 in varchar2 default hr_api.g_varchar2
31: ,p_attribute12 in varchar2 default hr_api.g_varchar2
32: ,p_attribute13 in varchar2 default hr_api.g_varchar2
33: ,p_attribute14 in varchar2 default hr_api.g_varchar2
34: ,p_attribute15 in varchar2 default hr_api.g_varchar2
35: ,p_attribute16 in varchar2 default hr_api.g_varchar2
36: ,p_attribute17 in varchar2 default hr_api.g_varchar2
37: ,p_attribute18 in varchar2 default hr_api.g_varchar2
30: ,p_attribute11 in varchar2 default hr_api.g_varchar2
31: ,p_attribute12 in varchar2 default hr_api.g_varchar2
32: ,p_attribute13 in varchar2 default hr_api.g_varchar2
33: ,p_attribute14 in varchar2 default hr_api.g_varchar2
34: ,p_attribute15 in varchar2 default hr_api.g_varchar2
35: ,p_attribute16 in varchar2 default hr_api.g_varchar2
36: ,p_attribute17 in varchar2 default hr_api.g_varchar2
37: ,p_attribute18 in varchar2 default hr_api.g_varchar2
38: ,p_attribute19 in varchar2 default hr_api.g_varchar2
31: ,p_attribute12 in varchar2 default hr_api.g_varchar2
32: ,p_attribute13 in varchar2 default hr_api.g_varchar2
33: ,p_attribute14 in varchar2 default hr_api.g_varchar2
34: ,p_attribute15 in varchar2 default hr_api.g_varchar2
35: ,p_attribute16 in varchar2 default hr_api.g_varchar2
36: ,p_attribute17 in varchar2 default hr_api.g_varchar2
37: ,p_attribute18 in varchar2 default hr_api.g_varchar2
38: ,p_attribute19 in varchar2 default hr_api.g_varchar2
39: ,p_attribute20 in varchar2 default hr_api.g_varchar2
32: ,p_attribute13 in varchar2 default hr_api.g_varchar2
33: ,p_attribute14 in varchar2 default hr_api.g_varchar2
34: ,p_attribute15 in varchar2 default hr_api.g_varchar2
35: ,p_attribute16 in varchar2 default hr_api.g_varchar2
36: ,p_attribute17 in varchar2 default hr_api.g_varchar2
37: ,p_attribute18 in varchar2 default hr_api.g_varchar2
38: ,p_attribute19 in varchar2 default hr_api.g_varchar2
39: ,p_attribute20 in varchar2 default hr_api.g_varchar2
40: ,p_attribute21 in varchar2 default hr_api.g_varchar2
33: ,p_attribute14 in varchar2 default hr_api.g_varchar2
34: ,p_attribute15 in varchar2 default hr_api.g_varchar2
35: ,p_attribute16 in varchar2 default hr_api.g_varchar2
36: ,p_attribute17 in varchar2 default hr_api.g_varchar2
37: ,p_attribute18 in varchar2 default hr_api.g_varchar2
38: ,p_attribute19 in varchar2 default hr_api.g_varchar2
39: ,p_attribute20 in varchar2 default hr_api.g_varchar2
40: ,p_attribute21 in varchar2 default hr_api.g_varchar2
41: ,p_attribute22 in varchar2 default hr_api.g_varchar2
34: ,p_attribute15 in varchar2 default hr_api.g_varchar2
35: ,p_attribute16 in varchar2 default hr_api.g_varchar2
36: ,p_attribute17 in varchar2 default hr_api.g_varchar2
37: ,p_attribute18 in varchar2 default hr_api.g_varchar2
38: ,p_attribute19 in varchar2 default hr_api.g_varchar2
39: ,p_attribute20 in varchar2 default hr_api.g_varchar2
40: ,p_attribute21 in varchar2 default hr_api.g_varchar2
41: ,p_attribute22 in varchar2 default hr_api.g_varchar2
42: ,p_attribute23 in varchar2 default hr_api.g_varchar2
35: ,p_attribute16 in varchar2 default hr_api.g_varchar2
36: ,p_attribute17 in varchar2 default hr_api.g_varchar2
37: ,p_attribute18 in varchar2 default hr_api.g_varchar2
38: ,p_attribute19 in varchar2 default hr_api.g_varchar2
39: ,p_attribute20 in varchar2 default hr_api.g_varchar2
40: ,p_attribute21 in varchar2 default hr_api.g_varchar2
41: ,p_attribute22 in varchar2 default hr_api.g_varchar2
42: ,p_attribute23 in varchar2 default hr_api.g_varchar2
43: ,p_attribute24 in varchar2 default hr_api.g_varchar2
36: ,p_attribute17 in varchar2 default hr_api.g_varchar2
37: ,p_attribute18 in varchar2 default hr_api.g_varchar2
38: ,p_attribute19 in varchar2 default hr_api.g_varchar2
39: ,p_attribute20 in varchar2 default hr_api.g_varchar2
40: ,p_attribute21 in varchar2 default hr_api.g_varchar2
41: ,p_attribute22 in varchar2 default hr_api.g_varchar2
42: ,p_attribute23 in varchar2 default hr_api.g_varchar2
43: ,p_attribute24 in varchar2 default hr_api.g_varchar2
44: ,p_attribute25 in varchar2 default hr_api.g_varchar2
37: ,p_attribute18 in varchar2 default hr_api.g_varchar2
38: ,p_attribute19 in varchar2 default hr_api.g_varchar2
39: ,p_attribute20 in varchar2 default hr_api.g_varchar2
40: ,p_attribute21 in varchar2 default hr_api.g_varchar2
41: ,p_attribute22 in varchar2 default hr_api.g_varchar2
42: ,p_attribute23 in varchar2 default hr_api.g_varchar2
43: ,p_attribute24 in varchar2 default hr_api.g_varchar2
44: ,p_attribute25 in varchar2 default hr_api.g_varchar2
45: ,p_attribute26 in varchar2 default hr_api.g_varchar2
38: ,p_attribute19 in varchar2 default hr_api.g_varchar2
39: ,p_attribute20 in varchar2 default hr_api.g_varchar2
40: ,p_attribute21 in varchar2 default hr_api.g_varchar2
41: ,p_attribute22 in varchar2 default hr_api.g_varchar2
42: ,p_attribute23 in varchar2 default hr_api.g_varchar2
43: ,p_attribute24 in varchar2 default hr_api.g_varchar2
44: ,p_attribute25 in varchar2 default hr_api.g_varchar2
45: ,p_attribute26 in varchar2 default hr_api.g_varchar2
46: ,p_attribute27 in varchar2 default hr_api.g_varchar2
39: ,p_attribute20 in varchar2 default hr_api.g_varchar2
40: ,p_attribute21 in varchar2 default hr_api.g_varchar2
41: ,p_attribute22 in varchar2 default hr_api.g_varchar2
42: ,p_attribute23 in varchar2 default hr_api.g_varchar2
43: ,p_attribute24 in varchar2 default hr_api.g_varchar2
44: ,p_attribute25 in varchar2 default hr_api.g_varchar2
45: ,p_attribute26 in varchar2 default hr_api.g_varchar2
46: ,p_attribute27 in varchar2 default hr_api.g_varchar2
47: ,p_attribute28 in varchar2 default hr_api.g_varchar2
40: ,p_attribute21 in varchar2 default hr_api.g_varchar2
41: ,p_attribute22 in varchar2 default hr_api.g_varchar2
42: ,p_attribute23 in varchar2 default hr_api.g_varchar2
43: ,p_attribute24 in varchar2 default hr_api.g_varchar2
44: ,p_attribute25 in varchar2 default hr_api.g_varchar2
45: ,p_attribute26 in varchar2 default hr_api.g_varchar2
46: ,p_attribute27 in varchar2 default hr_api.g_varchar2
47: ,p_attribute28 in varchar2 default hr_api.g_varchar2
48: ,p_attribute29 in varchar2 default hr_api.g_varchar2
41: ,p_attribute22 in varchar2 default hr_api.g_varchar2
42: ,p_attribute23 in varchar2 default hr_api.g_varchar2
43: ,p_attribute24 in varchar2 default hr_api.g_varchar2
44: ,p_attribute25 in varchar2 default hr_api.g_varchar2
45: ,p_attribute26 in varchar2 default hr_api.g_varchar2
46: ,p_attribute27 in varchar2 default hr_api.g_varchar2
47: ,p_attribute28 in varchar2 default hr_api.g_varchar2
48: ,p_attribute29 in varchar2 default hr_api.g_varchar2
49: ,p_attribute30 in varchar2 default hr_api.g_varchar2
42: ,p_attribute23 in varchar2 default hr_api.g_varchar2
43: ,p_attribute24 in varchar2 default hr_api.g_varchar2
44: ,p_attribute25 in varchar2 default hr_api.g_varchar2
45: ,p_attribute26 in varchar2 default hr_api.g_varchar2
46: ,p_attribute27 in varchar2 default hr_api.g_varchar2
47: ,p_attribute28 in varchar2 default hr_api.g_varchar2
48: ,p_attribute29 in varchar2 default hr_api.g_varchar2
49: ,p_attribute30 in varchar2 default hr_api.g_varchar2
50: ,p_effective_start_date out nocopy date
43: ,p_attribute24 in varchar2 default hr_api.g_varchar2
44: ,p_attribute25 in varchar2 default hr_api.g_varchar2
45: ,p_attribute26 in varchar2 default hr_api.g_varchar2
46: ,p_attribute27 in varchar2 default hr_api.g_varchar2
47: ,p_attribute28 in varchar2 default hr_api.g_varchar2
48: ,p_attribute29 in varchar2 default hr_api.g_varchar2
49: ,p_attribute30 in varchar2 default hr_api.g_varchar2
50: ,p_effective_start_date out nocopy date
51: ,p_effective_end_date out nocopy date
44: ,p_attribute25 in varchar2 default hr_api.g_varchar2
45: ,p_attribute26 in varchar2 default hr_api.g_varchar2
46: ,p_attribute27 in varchar2 default hr_api.g_varchar2
47: ,p_attribute28 in varchar2 default hr_api.g_varchar2
48: ,p_attribute29 in varchar2 default hr_api.g_varchar2
49: ,p_attribute30 in varchar2 default hr_api.g_varchar2
50: ,p_effective_start_date out nocopy date
51: ,p_effective_end_date out nocopy date
52: ) is
45: ,p_attribute26 in varchar2 default hr_api.g_varchar2
46: ,p_attribute27 in varchar2 default hr_api.g_varchar2
47: ,p_attribute28 in varchar2 default hr_api.g_varchar2
48: ,p_attribute29 in varchar2 default hr_api.g_varchar2
49: ,p_attribute30 in varchar2 default hr_api.g_varchar2
50: ,p_effective_start_date out nocopy date
51: ,p_effective_end_date out nocopy date
52: ) is
53: --
118: ,p_effective_date => l_effective_date
119: ,p_datetrack_mode => p_datetrack_mode
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (p_module_name => 'UPDATE_person_type_usage'
125: ,p_hook_type => 'BP'
126: );
119: ,p_datetrack_mode => p_datetrack_mode
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (p_module_name => 'UPDATE_person_type_usage'
125: ,p_hook_type => 'BP'
126: );
127: --
223: ,p_effective_date => l_effective_date
224: ,p_datetrack_mode => p_datetrack_mode
225: );
226: exception
227: when hr_api.cannot_find_prog_unit then
228: hr_api.cannot_find_prog_unit_error
229: (p_module_name => 'UPDATE_person_type_usage'
230: ,p_hook_type => 'AP'
231: );
224: ,p_datetrack_mode => p_datetrack_mode
225: );
226: exception
227: when hr_api.cannot_find_prog_unit then
228: hr_api.cannot_find_prog_unit_error
229: (p_module_name => 'UPDATE_person_type_usage'
230: ,p_hook_type => 'AP'
231: );
232: --
238: --
239: -- When in validation only mode raise the Validate_Enabled exception
240: --
241: if p_validate then
242: raise hr_api.validate_enabled;
243: end if;
244: --
245: -- Set all output arguments
246: --
251: hr_utility.set_location(' Leaving:'||l_proc, 70);
252: --
253: exception
254: --
255: when hr_api.validate_enabled then
256: --
257: -- As the Validate_Enabled exception has been raised
258: -- we must rollback to the savepoint
259: --
553: --
554: -- Must not exist in hr_standard_lookups where lookup_type is
555: -- HR_SYS_PTU
556: --
557: if not hr_api.not_exists_in_hrstanlookups
558: (p_effective_date => p_effective_date
559: ,p_lookup_type => 'HR_SYS_PTU'
560: ,p_lookup_code => l_person_type
561: ) then
606: ,p_attribute30 => p_attribute30
607: );
608:
609: exception
610: when hr_api.cannot_find_prog_unit then
611: hr_api.cannot_find_prog_unit_error
612: (p_module_name => 'CREATE_person_type_usage'
613: ,p_hook_type => 'BP'
614: );
607: );
608:
609: exception
610: when hr_api.cannot_find_prog_unit then
611: hr_api.cannot_find_prog_unit_error
612: (p_module_name => 'CREATE_person_type_usage'
613: ,p_hook_type => 'BP'
614: );
615: --
709: ,p_effective_end_date => l_effective_end_date
710: );
711:
712: exception
713: when hr_api.cannot_find_prog_unit then
714: hr_api.cannot_find_prog_unit_error
715: (p_module_name => 'CREATE_person_type_usage'
716: ,p_hook_type => 'AP'
717: );
710: );
711:
712: exception
713: when hr_api.cannot_find_prog_unit then
714: hr_api.cannot_find_prog_unit_error
715: (p_module_name => 'CREATE_person_type_usage'
716: ,p_hook_type => 'AP'
717: );
718: --
722: --
723: -- When in validation only mode raise the Validate_Enabled exception
724: --
725: if p_validate then
726: raise hr_api.validate_enabled;
727: end if;
728: --
729: -- Set all output arguments
730: --
736: hr_utility.set_location(' Leaving:'||l_proc, 70);
737: --
738: exception
739: --
740: when hr_api.validate_enabled then
741: --
742: -- As the Validate_Enabled exception has been raised
743: -- we must rollback to the savepoint
744: --
818: -- HR_SYS_PTU
819: --
820: -- PTU Changes
821: --
822: -- if not hr_api.not_exists_in_hrstanlookups
823: -- (p_effective_date => p_effective_date
824: -- ,p_lookup_type => 'HR_SYS_PTU'
825: -- ,p_lookup_code => l_system_person_type
826: -- ) then
843: ,p_object_version_number => l_object_version_number
844: );
845:
846: exception
847: when hr_api.cannot_find_prog_unit then
848: hr_api.cannot_find_prog_unit_error
849: (p_module_name => 'DELETE_person_type_usage'
850: ,p_hook_type => 'BP'
851: );
844: );
845:
846: exception
847: when hr_api.cannot_find_prog_unit then
848: hr_api.cannot_find_prog_unit_error
849: (p_module_name => 'DELETE_person_type_usage'
850: ,p_hook_type => 'BP'
851: );
852: --
886: ,p_effective_end_date => l_effective_end_date
887: );
888:
889: exception
890: when hr_api.cannot_find_prog_unit then
891: hr_api.cannot_find_prog_unit_error
892: (p_module_name => 'DELETE_person_type_usage'
893: ,p_hook_type => 'AP'
894: );
887: );
888:
889: exception
890: when hr_api.cannot_find_prog_unit then
891: hr_api.cannot_find_prog_unit_error
892: (p_module_name => 'DELETE_person_type_usage'
893: ,p_hook_type => 'AP'
894: );
895: --
899: --
900: -- When in validation only mode raise the Validate_Enabled exception
901: --
902: if p_validate then
903: raise hr_api.validate_enabled;
904: end if;
905: p_effective_start_date := l_effective_start_date;
906: p_effective_end_date := l_effective_end_date;
907: p_object_version_number := l_object_version_number;
909: hr_utility.set_location(' Leaving:'||l_proc, 70);
910: --
911: exception
912: --
913: when hr_api.validate_enabled then
914: --
915: -- As the Validate_Enabled exception has been raised
916: -- we must rollback to the savepoint
917: --