eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_TYPE_USAGE_API dependencies on HR_API

Line 18: ,p_person_type_id in number default hr_api.g_number

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

Line 19: ,p_attribute_category 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

Line 20: ,p_attribute1 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

Line 21: ,p_attribute2 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

Line 22: ,p_attribute3 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

Line 23: ,p_attribute4 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

Line 24: ,p_attribute5 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

Line 25: ,p_attribute6 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

Line 26: ,p_attribute7 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

Line 27: ,p_attribute8 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

Line 28: ,p_attribute9 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

Line 29: ,p_attribute10 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

Line 30: ,p_attribute11 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

Line 31: ,p_attribute12 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

Line 32: ,p_attribute13 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

Line 33: ,p_attribute14 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

Line 34: ,p_attribute15 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

Line 35: ,p_attribute16 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

Line 36: ,p_attribute17 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

Line 37: ,p_attribute18 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

Line 38: ,p_attribute19 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

Line 39: ,p_attribute20 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

Line 40: ,p_attribute21 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

Line 41: ,p_attribute22 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

Line 42: ,p_attribute23 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

Line 43: ,p_attribute24 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

Line 44: ,p_attribute25 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

Line 45: ,p_attribute26 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

Line 46: ,p_attribute27 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

Line 47: ,p_attribute28 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
51: ,p_effective_end_date out nocopy date

Line 48: ,p_attribute29 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
52: ) is

Line 49: ,p_attribute30 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
53: --

Line 122: when hr_api.cannot_find_prog_unit then

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

Line 123: hr_api.cannot_find_prog_unit_error

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

Line 227: when hr_api.cannot_find_prog_unit then

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

Line 228: hr_api.cannot_find_prog_unit_error

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

Line 242: raise hr_api.validate_enabled;

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

Line 255: when hr_api.validate_enabled then

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

Line 557: if not hr_api.not_exists_in_hrstanlookups

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

Line 610: when hr_api.cannot_find_prog_unit 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: );

Line 611: hr_api.cannot_find_prog_unit_error

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

Line 713: when hr_api.cannot_find_prog_unit then

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

Line 714: hr_api.cannot_find_prog_unit_error

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

Line 726: raise hr_api.validate_enabled;

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

Line 740: when hr_api.validate_enabled then

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

Line 822: -- if not hr_api.not_exists_in_hrstanlookups

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

Line 847: when hr_api.cannot_find_prog_unit 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: );

Line 848: hr_api.cannot_find_prog_unit_error

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

Line 890: when hr_api.cannot_find_prog_unit then

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

Line 891: hr_api.cannot_find_prog_unit_error

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

Line 903: raise hr_api.validate_enabled;

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;

Line 913: when hr_api.validate_enabled then

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