52: ,p_chunk_number => p_chunk_number
53: ,p_effective_date => trunc(p_effective_date)
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (
59: p_module_name => 'CREATE_person_actions'
60: ,p_hook_type => 'BP'
53: ,p_effective_date => trunc(p_effective_date)
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (
59: p_module_name => 'CREATE_person_actions'
60: ,p_hook_type => 'BP'
61: );
91: ,p_object_version_number => l_object_version_number
92: ,p_effective_date => trunc(p_effective_date)
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'CREATE_person_actions'
98: ,p_hook_type => 'AP'
99: );
92: ,p_effective_date => trunc(p_effective_date)
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'CREATE_person_actions'
98: ,p_hook_type => 'AP'
99: );
100: --
106: --
107: -- When in validation only mode raise the Validate_Enabled exception
108: --
109: if p_validate then
110: raise hr_api.validate_enabled;
111: end if;
112: --
113: -- Set all output arguments
114: --
118: hr_utility.set_location(' Leaving:'||l_proc, 70);
119: --
120: exception
121: --
122: when hr_api.validate_enabled then
123: --
124: -- As the Validate_Enabled exception has been raised
125: -- we must rollback to the savepoint
126: --
151: --
152: procedure update_person_actions
153: (p_validate in boolean default false
154: ,p_person_action_id in number
155: ,p_person_id in number default hr_api.g_number
156: ,p_ler_id in number default hr_api.g_number
157: ,p_benefit_action_id in number default hr_api.g_number
158: ,p_action_status_cd in varchar2 default hr_api.g_varchar2
159: ,p_chunk_number in number default hr_api.g_number
152: procedure update_person_actions
153: (p_validate in boolean default false
154: ,p_person_action_id in number
155: ,p_person_id in number default hr_api.g_number
156: ,p_ler_id in number default hr_api.g_number
157: ,p_benefit_action_id in number default hr_api.g_number
158: ,p_action_status_cd in varchar2 default hr_api.g_varchar2
159: ,p_chunk_number in number default hr_api.g_number
160: ,p_object_version_number in out nocopy number
153: (p_validate in boolean default false
154: ,p_person_action_id in number
155: ,p_person_id in number default hr_api.g_number
156: ,p_ler_id in number default hr_api.g_number
157: ,p_benefit_action_id in number default hr_api.g_number
158: ,p_action_status_cd in varchar2 default hr_api.g_varchar2
159: ,p_chunk_number in number default hr_api.g_number
160: ,p_object_version_number in out nocopy number
161: ,p_effective_date in date
154: ,p_person_action_id in number
155: ,p_person_id in number default hr_api.g_number
156: ,p_ler_id in number default hr_api.g_number
157: ,p_benefit_action_id in number default hr_api.g_number
158: ,p_action_status_cd in varchar2 default hr_api.g_varchar2
159: ,p_chunk_number in number default hr_api.g_number
160: ,p_object_version_number in out nocopy number
161: ,p_effective_date in date
162: ) is
155: ,p_person_id in number default hr_api.g_number
156: ,p_ler_id in number default hr_api.g_number
157: ,p_benefit_action_id in number default hr_api.g_number
158: ,p_action_status_cd in varchar2 default hr_api.g_varchar2
159: ,p_chunk_number in number default hr_api.g_number
160: ,p_object_version_number in out nocopy number
161: ,p_effective_date in date
162: ) is
163: --
195: ,p_object_version_number => p_object_version_number
196: ,p_effective_date => trunc(p_effective_date)
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'UPDATE_person_actions'
202: ,p_hook_type => 'BP'
203: );
196: ,p_effective_date => trunc(p_effective_date)
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'UPDATE_person_actions'
202: ,p_hook_type => 'BP'
203: );
204: --
233: ,p_object_version_number => l_object_version_number
234: ,p_effective_date => trunc(p_effective_date)
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'UPDATE_person_actions'
240: ,p_hook_type => 'AP'
241: );
234: ,p_effective_date => trunc(p_effective_date)
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'UPDATE_person_actions'
240: ,p_hook_type => 'AP'
241: );
242: --
248: --
249: -- When in validation only mode raise the Validate_Enabled exception
250: --
251: if p_validate then
252: raise hr_api.validate_enabled;
253: end if;
254: --
255: -- Set all output arguments
256: --
259: hr_utility.set_location(' Leaving:'||l_proc, 70);
260: --
261: exception
262: --
263: when hr_api.validate_enabled then
264: --
265: -- As the Validate_Enabled exception has been raised
266: -- we must rollback to the savepoint
267: --
324: ,p_object_version_number => p_object_version_number
325: ,p_effective_date => trunc(p_effective_date)
326: );
327: exception
328: when hr_api.cannot_find_prog_unit then
329: hr_api.cannot_find_prog_unit_error
330: (p_module_name => 'DELETE_person_actions'
331: ,p_hook_type => 'BP'
332: );
325: ,p_effective_date => trunc(p_effective_date)
326: );
327: exception
328: when hr_api.cannot_find_prog_unit then
329: hr_api.cannot_find_prog_unit_error
330: (p_module_name => 'DELETE_person_actions'
331: ,p_hook_type => 'BP'
332: );
333: --
352: ,p_object_version_number => l_object_version_number
353: ,p_effective_date => trunc(p_effective_date)
354: );
355: exception
356: when hr_api.cannot_find_prog_unit then
357: hr_api.cannot_find_prog_unit_error
358: (p_module_name => 'DELETE_person_actions'
359: ,p_hook_type => 'AP'
360: );
353: ,p_effective_date => trunc(p_effective_date)
354: );
355: exception
356: when hr_api.cannot_find_prog_unit then
357: hr_api.cannot_find_prog_unit_error
358: (p_module_name => 'DELETE_person_actions'
359: ,p_hook_type => 'AP'
360: );
361: --
367: --
368: -- When in validation only mode raise the Validate_Enabled exception
369: --
370: if p_validate then
371: raise hr_api.validate_enabled;
372: end if;
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 70);
375: --
374: hr_utility.set_location(' Leaving:'||l_proc, 70);
375: --
376: exception
377: --
378: when hr_api.validate_enabled then
379: --
380: -- As the Validate_Enabled exception has been raised
381: -- we must rollback to the savepoint
382: --