67: ,p_per_in_ler_id => p_per_in_ler_id
68: );
69:
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'PQH_RANK_PROCESS_API'
74: ,p_hook_type => 'BP'
75: );
68: );
69:
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'PQH_RANK_PROCESS_API'
74: ,p_hook_type => 'BP'
75: );
76: end;
116: ,p_object_version_number => l_object_version_number
117: ,p_per_in_ler_id => p_per_in_ler_id
118: );
119: exception
120: when hr_api.cannot_find_prog_unit then
121: hr_api.cannot_find_prog_unit_error
122: (p_module_name => 'PQH_RANK_PROCESS_API'
123: ,p_hook_type => 'AP'
124: );
117: ,p_per_in_ler_id => p_per_in_ler_id
118: );
119: exception
120: when hr_api.cannot_find_prog_unit then
121: hr_api.cannot_find_prog_unit_error
122: (p_module_name => 'PQH_RANK_PROCESS_API'
123: ,p_hook_type => 'AP'
124: );
125: end;
126: --
127: -- When in validation only mode raise the Validate_Enabled exception
128: --
129: if p_validate then
130: raise hr_api.validate_enabled;
131: end if;
132: --
133: -- Set all IN OUT and OUT parameters with out values
134: --
136: p_rank_process_id := l_rank_process_id;
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 70);
139: exception
140: when hr_api.validate_enabled then
141: --
142: -- As the Validate_Enabled exception has been raised
143: -- we must rollback to the savepoint
144: --
173: procedure update_rank_process
174: (p_validate in boolean default false
175: ,p_effective_date in date
176: ,p_rank_process_id in number
177: ,p_pgm_id in number default hr_api.g_number
178: ,p_pl_id in number default hr_api.g_number
179: ,p_oipl_id in number default hr_api.g_number
180: ,p_process_cd in varchar2
181: ,p_process_date in date
174: (p_validate in boolean default false
175: ,p_effective_date in date
176: ,p_rank_process_id in number
177: ,p_pgm_id in number default hr_api.g_number
178: ,p_pl_id in number default hr_api.g_number
179: ,p_oipl_id in number default hr_api.g_number
180: ,p_process_cd in varchar2
181: ,p_process_date in date
182: ,p_benefit_action_id in number default hr_api.g_number
175: ,p_effective_date in date
176: ,p_rank_process_id in number
177: ,p_pgm_id in number default hr_api.g_number
178: ,p_pl_id in number default hr_api.g_number
179: ,p_oipl_id in number default hr_api.g_number
180: ,p_process_cd in varchar2
181: ,p_process_date in date
182: ,p_benefit_action_id in number default hr_api.g_number
183: ,p_person_id in number
178: ,p_pl_id in number default hr_api.g_number
179: ,p_oipl_id in number default hr_api.g_number
180: ,p_process_cd in varchar2
181: ,p_process_date in date
182: ,p_benefit_action_id in number default hr_api.g_number
183: ,p_person_id in number
184: ,p_assignment_id in number
185: ,p_total_score in number default hr_api.g_number
186: ,p_request_id in number default hr_api.g_number
181: ,p_process_date in date
182: ,p_benefit_action_id in number default hr_api.g_number
183: ,p_person_id in number
184: ,p_assignment_id in number
185: ,p_total_score in number default hr_api.g_number
186: ,p_request_id in number default hr_api.g_number
187: ,p_business_group_id in number default hr_api.g_number
188: ,p_object_version_number in out nocopy number
189: ,p_per_in_ler_id in number default hr_api.g_number
182: ,p_benefit_action_id in number default hr_api.g_number
183: ,p_person_id in number
184: ,p_assignment_id in number
185: ,p_total_score in number default hr_api.g_number
186: ,p_request_id in number default hr_api.g_number
187: ,p_business_group_id in number default hr_api.g_number
188: ,p_object_version_number in out nocopy number
189: ,p_per_in_ler_id in number default hr_api.g_number
190: ) is
183: ,p_person_id in number
184: ,p_assignment_id in number
185: ,p_total_score in number default hr_api.g_number
186: ,p_request_id in number default hr_api.g_number
187: ,p_business_group_id in number default hr_api.g_number
188: ,p_object_version_number in out nocopy number
189: ,p_per_in_ler_id in number default hr_api.g_number
190: ) is
191: --
185: ,p_total_score in number default hr_api.g_number
186: ,p_request_id in number default hr_api.g_number
187: ,p_business_group_id in number default hr_api.g_number
188: ,p_object_version_number in out nocopy number
189: ,p_per_in_ler_id in number default hr_api.g_number
190: ) is
191: --
192: -- Declare cursors and local variables
193: --
232: ,p_object_version_number => l_object_version_number
233: ,p_per_in_ler_id => p_per_in_ler_id
234: );
235: exception
236: when hr_api.cannot_find_prog_unit then
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'PQH_RANK_PROCESS_API'
239: ,p_hook_type => 'BP'
240: );
233: ,p_per_in_ler_id => p_per_in_ler_id
234: );
235: exception
236: when hr_api.cannot_find_prog_unit then
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'PQH_RANK_PROCESS_API'
239: ,p_hook_type => 'BP'
240: );
241: end;
282: ,p_object_version_number => l_object_version_number
283: ,p_per_in_ler_id => p_per_in_ler_id
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (p_module_name => 'PQH_RANK_PROCESS_API'
289: ,p_hook_type => 'AP'
290: );
283: ,p_per_in_ler_id => p_per_in_ler_id
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (p_module_name => 'PQH_RANK_PROCESS_API'
289: ,p_hook_type => 'AP'
290: );
291: end;
292: --
293: -- When in validation only mode raise the Validate_Enabled exception
294: --
295: if p_validate then
296: raise hr_api.validate_enabled;
297: end if;
298: --
299: -- Set all IN OUT and OUT parameters with out values
300: --
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 70);
304:
305: exception
306: when hr_api.validate_enabled then
307: --
308: -- As the Validate_Enabled exception has been raised
309: -- we must rollback to the savepoint
310: --
367: ,p_rank_process_id => p_rank_process_id
368: ,p_object_version_number => p_object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'PQH_RANK_PROCESS_API'
374: ,p_hook_type => 'BP'
375: );
368: ,p_object_version_number => p_object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'PQH_RANK_PROCESS_API'
374: ,p_hook_type => 'BP'
375: );
376: end;
392: ,p_rank_process_id => p_rank_process_id
393: ,p_object_version_number => p_object_version_number
394: );
395: exception
396: when hr_api.cannot_find_prog_unit then
397: hr_api.cannot_find_prog_unit_error
398: (p_module_name => 'PQH_RANK_PROCESS_API'
399: ,p_hook_type => 'AP'
400: );
393: ,p_object_version_number => p_object_version_number
394: );
395: exception
396: when hr_api.cannot_find_prog_unit then
397: hr_api.cannot_find_prog_unit_error
398: (p_module_name => 'PQH_RANK_PROCESS_API'
399: ,p_hook_type => 'AP'
400: );
401: end;
402: --
403: -- When in validation only mode raise the Validate_Enabled exception
404: --
405: if p_validate then
406: raise hr_api.validate_enabled;
407: end if;
408: --
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 70);
411:
412: exception
413: when hr_api.validate_enabled then
414: --
415: -- As the Validate_Enabled exception has been raised
416: -- we must rollback to the savepoint
417: --