54: ,p_population_count => p_population_count
55: ,p_proposed_rank => p_proposed_rank
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
61: ,p_hook_type => 'BP'
62: );
55: ,p_proposed_rank => p_proposed_rank
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
61: ,p_hook_type => 'BP'
62: );
63: end;
91: ,p_rank_process_approval_id => l_rank_process_approval_id
92: ,p_object_version_number => l_object_version_number
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
98: ,p_hook_type => 'AP'
99: );
92: ,p_object_version_number => l_object_version_number
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
98: ,p_hook_type => 'AP'
99: );
100: end;
101: --
102: -- When in validation only mode raise the Validate_Enabled exception
103: --
104: if p_validate then
105: raise hr_api.validate_enabled;
106: end if;
107: --
108: -- Set all IN OUT and OUT parameters with out values
109: --
111: p_object_version_number := l_object_version_number;
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: exception
115: when hr_api.validate_enabled then
116: --
117: -- As the Validate_Enabled exception has been raised
118: -- we must rollback to the savepoint
119: --
150: ,p_effective_date in date
151: ,p_rank_process_approval_id in number
152: ,p_rank_process_id in number
153: ,p_approval_date in date
154: ,p_supervisor_id in number default hr_api.g_number
155: ,p_system_rank in number default hr_api.g_number
156: ,p_population_count in number default hr_api.g_number
157: ,p_proposed_rank in number default hr_api.g_number
158: ,p_object_version_number in out nocopy number
151: ,p_rank_process_approval_id in number
152: ,p_rank_process_id in number
153: ,p_approval_date in date
154: ,p_supervisor_id in number default hr_api.g_number
155: ,p_system_rank in number default hr_api.g_number
156: ,p_population_count in number default hr_api.g_number
157: ,p_proposed_rank in number default hr_api.g_number
158: ,p_object_version_number in out nocopy number
159: ) is
152: ,p_rank_process_id in number
153: ,p_approval_date in date
154: ,p_supervisor_id in number default hr_api.g_number
155: ,p_system_rank in number default hr_api.g_number
156: ,p_population_count in number default hr_api.g_number
157: ,p_proposed_rank in number default hr_api.g_number
158: ,p_object_version_number in out nocopy number
159: ) is
160: --
153: ,p_approval_date in date
154: ,p_supervisor_id in number default hr_api.g_number
155: ,p_system_rank in number default hr_api.g_number
156: ,p_population_count in number default hr_api.g_number
157: ,p_proposed_rank in number default hr_api.g_number
158: ,p_object_version_number in out nocopy number
159: ) is
160: --
161: -- Declare cursors and local variables
194: ,p_proposed_rank => p_proposed_rank
195: ,p_object_version_number => l_object_version_number
196: );
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error
200: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
201: ,p_hook_type => 'BP'
202: );
195: ,p_object_version_number => l_object_version_number
196: );
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error
200: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
201: ,p_hook_type => 'BP'
202: );
203: end;
231: ,p_proposed_rank => p_proposed_rank
232: ,p_object_version_number => l_object_version_number
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
238: ,p_hook_type => 'AP'
239: );
232: ,p_object_version_number => l_object_version_number
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
238: ,p_hook_type => 'AP'
239: );
240: end;
241: --
242: -- When in validation only mode raise the Validate_Enabled exception
243: --
244: if p_validate then
245: raise hr_api.validate_enabled;
246: end if;
247: --
248: -- Set all IN OUT and OUT parameters with out values
249: --
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 70);
253:
254: exception
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: --
315: ,p_rank_process_approval_id => p_rank_process_approval_id
316: ,p_object_version_number => p_object_version_number
317: );
318: exception
319: when hr_api.cannot_find_prog_unit then
320: hr_api.cannot_find_prog_unit_error
321: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
322: ,p_hook_type => 'BP'
323: );
316: ,p_object_version_number => p_object_version_number
317: );
318: exception
319: when hr_api.cannot_find_prog_unit then
320: hr_api.cannot_find_prog_unit_error
321: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
322: ,p_hook_type => 'BP'
323: );
324: end;
340: ,p_rank_process_approval_id => p_rank_process_approval_id
341: ,p_object_version_number => p_object_version_number
342: );
343: exception
344: when hr_api.cannot_find_prog_unit then
345: hr_api.cannot_find_prog_unit_error
346: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
347: ,p_hook_type => 'AP'
348: );
341: ,p_object_version_number => p_object_version_number
342: );
343: exception
344: when hr_api.cannot_find_prog_unit then
345: hr_api.cannot_find_prog_unit_error
346: (p_module_name => 'PQH_RANK_PROCESS_APPROVAL_API'
347: ,p_hook_type => 'AP'
348: );
349: end;
350: --
351: -- When in validation only mode raise the Validate_Enabled exception
352: --
353: if p_validate then
354: raise hr_api.validate_enabled;
355: end if;
356: --
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 70);
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 70);
359:
360: exception
361: when hr_api.validate_enabled then
362: --
363: -- As the Validate_Enabled exception has been raised
364: -- we must rollback to the savepoint
365: --