116: p_plan_status => p_plan_status,
117: p_readiness_percentage => p_readiness_percentage
118: );
119: EXCEPTION
120: WHEN hr_api.cannot_find_prog_unit
121: THEN
122: hr_api.cannot_find_prog_unit_error (p_module_name => 'create_succession_plan',
123: p_hook_type => 'BP'
124: );
118: );
119: EXCEPTION
120: WHEN hr_api.cannot_find_prog_unit
121: THEN
122: hr_api.cannot_find_prog_unit_error (p_module_name => 'create_succession_plan',
123: p_hook_type => 'BP'
124: );
125: END;
126:
218: p_succession_plan_id => l_succession_plan_id,
219: p_object_version_number => l_object_version_number
220: );
221: EXCEPTION
222: WHEN hr_api.cannot_find_prog_unit
223: THEN
224: hr_api.cannot_find_prog_unit_error (p_module_name => 'create_succession_plan',
225: p_hook_type => 'AP'
226: );
220: );
221: EXCEPTION
222: WHEN hr_api.cannot_find_prog_unit
223: THEN
224: hr_api.cannot_find_prog_unit_error (p_module_name => 'create_succession_plan',
225: p_hook_type => 'AP'
226: );
227: END;
228:
230: -- When in validation only mode raise the Validate_Enabled exception
231: --
232: IF p_validate
233: THEN
234: RAISE hr_api.validate_enabled;
235: END IF;
236:
237: --
238: -- Set all IN OUT and OUT parameters with out values
241: p_object_version_number := l_object_version_number;
242: --
243: hr_utility.set_location (' Leaving:' || l_proc, 70);
244: EXCEPTION
245: WHEN hr_api.validate_enabled
246: THEN
247: --
248: -- As the Validate_Enabled exception has been raised
249: -- we must rollback to the savepoint
280: --
281: PROCEDURE update_succession_plan (
282: p_validate IN BOOLEAN DEFAULT FALSE,
283: p_succession_plan_id IN NUMBER,
284: p_person_id IN NUMBER DEFAULT hr_api.g_number,
285: p_position_id IN NUMBER DEFAULT hr_api.g_number,
286: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
287: p_start_date IN DATE DEFAULT hr_api.g_date,
288: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
281: PROCEDURE update_succession_plan (
282: p_validate IN BOOLEAN DEFAULT FALSE,
283: p_succession_plan_id IN NUMBER,
284: p_person_id IN NUMBER DEFAULT hr_api.g_number,
285: p_position_id IN NUMBER DEFAULT hr_api.g_number,
286: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
287: p_start_date IN DATE DEFAULT hr_api.g_date,
288: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
289: p_end_date IN DATE DEFAULT hr_api.g_date,
282: p_validate IN BOOLEAN DEFAULT FALSE,
283: p_succession_plan_id IN NUMBER,
284: p_person_id IN NUMBER DEFAULT hr_api.g_number,
285: p_position_id IN NUMBER DEFAULT hr_api.g_number,
286: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
287: p_start_date IN DATE DEFAULT hr_api.g_date,
288: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
289: p_end_date IN DATE DEFAULT hr_api.g_date,
290: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
283: p_succession_plan_id IN NUMBER,
284: p_person_id IN NUMBER DEFAULT hr_api.g_number,
285: p_position_id IN NUMBER DEFAULT hr_api.g_number,
286: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
287: p_start_date IN DATE DEFAULT hr_api.g_date,
288: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
289: p_end_date IN DATE DEFAULT hr_api.g_date,
290: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
284: p_person_id IN NUMBER DEFAULT hr_api.g_number,
285: p_position_id IN NUMBER DEFAULT hr_api.g_number,
286: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
287: p_start_date IN DATE DEFAULT hr_api.g_date,
288: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
289: p_end_date IN DATE DEFAULT hr_api.g_date,
290: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
285: p_position_id IN NUMBER DEFAULT hr_api.g_number,
286: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
287: p_start_date IN DATE DEFAULT hr_api.g_date,
288: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
289: p_end_date IN DATE DEFAULT hr_api.g_date,
290: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
286: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
287: p_start_date IN DATE DEFAULT hr_api.g_date,
288: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
289: p_end_date IN DATE DEFAULT hr_api.g_date,
290: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
287: p_start_date IN DATE DEFAULT hr_api.g_date,
288: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
289: p_end_date IN DATE DEFAULT hr_api.g_date,
290: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
288: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
289: p_end_date IN DATE DEFAULT hr_api.g_date,
290: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
289: p_end_date IN DATE DEFAULT hr_api.g_date,
290: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
290: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_effective_date IN DATE,
306: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_effective_date IN DATE,
314: p_job_id IN NUMBER DEFAULT hr_api.g_number,
307: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_effective_date IN DATE,
314: p_job_id IN NUMBER DEFAULT hr_api.g_number,
315: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
308: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_effective_date IN DATE,
314: p_job_id IN NUMBER DEFAULT hr_api.g_number,
315: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
316: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
310: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_effective_date IN DATE,
314: p_job_id IN NUMBER DEFAULT hr_api.g_number,
315: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
316: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
317: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_effective_date IN DATE,
314: p_job_id IN NUMBER DEFAULT hr_api.g_number,
315: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
316: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
317: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
312: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_effective_date IN DATE,
314: p_job_id IN NUMBER DEFAULT hr_api.g_number,
315: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
316: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
317: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
320: p_object_version_number IN OUT NOCOPY NUMBER
313: p_effective_date IN DATE,
314: p_job_id IN NUMBER DEFAULT hr_api.g_number,
315: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
316: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
317: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
320: p_object_version_number IN OUT NOCOPY NUMBER
321: )
314: p_job_id IN NUMBER DEFAULT hr_api.g_number,
315: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
316: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
317: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
320: p_object_version_number IN OUT NOCOPY NUMBER
321: )
322: IS
315: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
316: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
317: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
320: p_object_version_number IN OUT NOCOPY NUMBER
321: )
322: IS
323: --
392: p_succession_plan_id => p_succession_plan_id,
393: p_object_version_number => p_object_version_number
394: );
395: EXCEPTION
396: WHEN hr_api.cannot_find_prog_unit
397: THEN
398: hr_api.cannot_find_prog_unit_error (p_module_name => 'update_succession_plan',
399: p_hook_type => 'BP'
400: );
394: );
395: EXCEPTION
396: WHEN hr_api.cannot_find_prog_unit
397: THEN
398: hr_api.cannot_find_prog_unit_error (p_module_name => 'update_succession_plan',
399: p_hook_type => 'BP'
400: );
401: END;
402:
493: p_succession_plan_id => l_succession_plan_id,
494: p_object_version_number => l_object_version_number
495: );
496: EXCEPTION
497: WHEN hr_api.cannot_find_prog_unit
498: THEN
499: hr_api.cannot_find_prog_unit_error (p_module_name => 'update_succession_plan',
500: p_hook_type => 'AP'
501: );
495: );
496: EXCEPTION
497: WHEN hr_api.cannot_find_prog_unit
498: THEN
499: hr_api.cannot_find_prog_unit_error (p_module_name => 'update_succession_plan',
500: p_hook_type => 'AP'
501: );
502: END;
503:
505: -- When in validation only mode raise the Validate_Enabled exception
506: --
507: IF p_validate
508: THEN
509: RAISE hr_api.validate_enabled;
510: END IF;
511:
512: --
513: -- Set all IN OUT and OUT parameters with out values
515: p_object_version_number := l_object_version_number;
516: --
517: hr_utility.set_location (' Leaving:' || l_proc, 70);
518: EXCEPTION
519: WHEN hr_api.validate_enabled
520: THEN
521: --
522: -- As the Validate_Enabled exception has been raised
523: -- we must rollback to the savepoint
579: (p_succession_plan_id => p_succession_plan_id,
580: p_object_version_number => p_object_version_number
581: );
582: EXCEPTION
583: WHEN hr_api.cannot_find_prog_unit
584: THEN
585: hr_api.cannot_find_prog_unit_error (p_module_name => 'delete_succession_plan',
586: p_hook_type => 'BP'
587: );
581: );
582: EXCEPTION
583: WHEN hr_api.cannot_find_prog_unit
584: THEN
585: hr_api.cannot_find_prog_unit_error (p_module_name => 'delete_succession_plan',
586: p_hook_type => 'BP'
587: );
588: END;
589:
624: (p_succession_plan_id => p_succession_plan_id,
625: p_object_version_number => p_object_version_number
626: );
627: EXCEPTION
628: WHEN hr_api.cannot_find_prog_unit
629: THEN
630: hr_api.cannot_find_prog_unit_error (p_module_name => 'delete_succession_plan',
631: p_hook_type => 'AP'
632: );
626: );
627: EXCEPTION
628: WHEN hr_api.cannot_find_prog_unit
629: THEN
630: hr_api.cannot_find_prog_unit_error (p_module_name => 'delete_succession_plan',
631: p_hook_type => 'AP'
632: );
633: END;
634:
638: -- When in validation only mode raise the Validate_Enabled exception
639: --
640: IF p_validate
641: THEN
642: RAISE hr_api.validate_enabled;
643: END IF;
644:
645: --
646: hr_utility.set_location (' Leaving:' || l_proc, 11);
644:
645: --
646: hr_utility.set_location (' Leaving:' || l_proc, 11);
647: EXCEPTION
648: WHEN hr_api.validate_enabled
649: THEN
650: --
651: -- As the Validate_Enabled exception has been raised
652: -- we must rollback to the savepoint