67: ,p_plan_readiness_rule => p_plan_readiness_rule
68: ,p_max_successors => p_max_successors );
69:
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'create_successee_detail_b'
74: ,p_hook_type => 'BP'
75: );
68: ,p_max_successors => p_max_successors );
69:
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'create_successee_detail_b'
74: ,p_hook_type => 'BP'
75: );
76: end;
125: ,p_max_successors => p_max_successors
126: ,p_successee_detail_id => l_successee_detail_id
127: );
128: exception
129: when hr_api.cannot_find_prog_unit then
130: hr_api.cannot_find_prog_unit_error
131: (p_module_name => 'create_successee_detail_b'
132: ,p_hook_type => 'AP'
133: );
126: ,p_successee_detail_id => l_successee_detail_id
127: );
128: exception
129: when hr_api.cannot_find_prog_unit then
130: hr_api.cannot_find_prog_unit_error
131: (p_module_name => 'create_successee_detail_b'
132: ,p_hook_type => 'AP'
133: );
134: end;
137: --
138: -- When in validation only mode raise the Validate_Enabled exception
139: --
140: if p_validate then
141: raise hr_api.validate_enabled;
142: end if;
143: --
144: -- Set all IN OUT and OUT parameters with out values
145: --
147: p_object_version_number := l_object_version_number;
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 70);
150: exception
151: when hr_api.validate_enabled then
152: --
153: -- As the Validate_Enabled exception has been raised
154: -- we must rollback to the savepoint
155: --
186: (p_validate in boolean default false
187: ,p_effective_date in date
188: ,p_successee_detail_id in number
189: ,p_object_version_number in out nocopy number
190: ,p_business_group_id in number default hr_api.g_number
191: ,p_successee_type in varchar2 default hr_api.g_varchar2
192: ,p_successee_id in number default hr_api.g_number
193: ,p_display_permissions in varchar2 default hr_api.g_varchar2
194: ,p_allow_npws in varchar2 default hr_api.g_varchar2
187: ,p_effective_date in date
188: ,p_successee_detail_id in number
189: ,p_object_version_number in out nocopy number
190: ,p_business_group_id in number default hr_api.g_number
191: ,p_successee_type in varchar2 default hr_api.g_varchar2
192: ,p_successee_id in number default hr_api.g_number
193: ,p_display_permissions in varchar2 default hr_api.g_varchar2
194: ,p_allow_npws in varchar2 default hr_api.g_varchar2
195: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
188: ,p_successee_detail_id in number
189: ,p_object_version_number in out nocopy number
190: ,p_business_group_id in number default hr_api.g_number
191: ,p_successee_type in varchar2 default hr_api.g_varchar2
192: ,p_successee_id in number default hr_api.g_number
193: ,p_display_permissions in varchar2 default hr_api.g_varchar2
194: ,p_allow_npws in varchar2 default hr_api.g_varchar2
195: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
196: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
189: ,p_object_version_number in out nocopy number
190: ,p_business_group_id in number default hr_api.g_number
191: ,p_successee_type in varchar2 default hr_api.g_varchar2
192: ,p_successee_id in number default hr_api.g_number
193: ,p_display_permissions in varchar2 default hr_api.g_varchar2
194: ,p_allow_npws in varchar2 default hr_api.g_varchar2
195: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
196: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
197: ,p_max_plans in number default hr_api.g_number
190: ,p_business_group_id in number default hr_api.g_number
191: ,p_successee_type in varchar2 default hr_api.g_varchar2
192: ,p_successee_id in number default hr_api.g_number
193: ,p_display_permissions in varchar2 default hr_api.g_varchar2
194: ,p_allow_npws in varchar2 default hr_api.g_varchar2
195: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
196: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
197: ,p_max_plans in number default hr_api.g_number
198: ,p_key_entity in varchar2 default hr_api.g_varchar2
191: ,p_successee_type in varchar2 default hr_api.g_varchar2
192: ,p_successee_id in number default hr_api.g_number
193: ,p_display_permissions in varchar2 default hr_api.g_varchar2
194: ,p_allow_npws in varchar2 default hr_api.g_varchar2
195: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
196: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
197: ,p_max_plans in number default hr_api.g_number
198: ,p_key_entity in varchar2 default hr_api.g_varchar2
199: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
192: ,p_successee_id in number default hr_api.g_number
193: ,p_display_permissions in varchar2 default hr_api.g_varchar2
194: ,p_allow_npws in varchar2 default hr_api.g_varchar2
195: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
196: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
197: ,p_max_plans in number default hr_api.g_number
198: ,p_key_entity in varchar2 default hr_api.g_varchar2
199: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
200: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
193: ,p_display_permissions in varchar2 default hr_api.g_varchar2
194: ,p_allow_npws in varchar2 default hr_api.g_varchar2
195: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
196: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
197: ,p_max_plans in number default hr_api.g_number
198: ,p_key_entity in varchar2 default hr_api.g_varchar2
199: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
200: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
201: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
194: ,p_allow_npws in varchar2 default hr_api.g_varchar2
195: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
196: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
197: ,p_max_plans in number default hr_api.g_number
198: ,p_key_entity in varchar2 default hr_api.g_varchar2
199: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
200: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
201: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
202: ,p_max_successors in number default hr_api.g_number
195: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
196: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
197: ,p_max_plans in number default hr_api.g_number
198: ,p_key_entity in varchar2 default hr_api.g_varchar2
199: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
200: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
201: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
202: ,p_max_successors in number default hr_api.g_number
203: ) is
196: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
197: ,p_max_plans in number default hr_api.g_number
198: ,p_key_entity in varchar2 default hr_api.g_varchar2
199: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
200: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
201: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
202: ,p_max_successors in number default hr_api.g_number
203: ) is
204: --
197: ,p_max_plans in number default hr_api.g_number
198: ,p_key_entity in varchar2 default hr_api.g_varchar2
199: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
200: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
201: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
202: ,p_max_successors in number default hr_api.g_number
203: ) is
204: --
205: -- Declare cursors and local variables
198: ,p_key_entity in varchar2 default hr_api.g_varchar2
199: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
200: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
201: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
202: ,p_max_successors in number default hr_api.g_number
203: ) is
204: --
205: -- Declare cursors and local variables
206: --
243: ,p_max_successors => p_max_successors
244: ,p_successee_detail_id => p_successee_detail_id
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'update_successee_detail_b'
250: ,p_hook_type => 'BP'
251: );
244: ,p_successee_detail_id => p_successee_detail_id
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'update_successee_detail_b'
250: ,p_hook_type => 'BP'
251: );
252: end;
302: ,p_max_successors => p_max_successors
303: ,p_successee_detail_id => p_successee_detail_id
304: );
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'update_successee_detail_b'
309: ,p_hook_type => 'AP'
310: );
303: ,p_successee_detail_id => p_successee_detail_id
304: );
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'update_successee_detail_b'
309: ,p_hook_type => 'AP'
310: );
311: end;
314: --
315: -- When in validation only mode raise the Validate_Enabled exception
316: --
317: if p_validate then
318: raise hr_api.validate_enabled;
319: end if;
320: --
321: -- Set all IN OUT and OUT parameters with out values
322: --
323: p_object_version_number := l_object_version_number;
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised
330: -- we must rollback to the savepoint
331: --
377: --
378: -- When in validation only mode raise the Validate_Enabled exception
379: --
380: if p_validate then
381: raise hr_api.validate_enabled;
382: end if;
383: --
384: -- Set all IN OUT and OUT parameters with out values
385: --
385: --
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 70);
388: exception
389: when hr_api.validate_enabled then
390: --
391: -- As the Validate_Enabled exception has been raised
392: -- we must rollback to the savepoint
393: --