9: -- ----------------------------------------------------------------------------
10: -- |------------------------< create_succession_plan >------------------------|
11: -- ----------------------------------------------------------------------------
12: PROCEDURE create_succession_plan (
13: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
14: p_person_id IN NUMBER,
15: p_position_id IN NUMBER DEFAULT NULL,
16: p_business_group_id IN NUMBER,
17: p_start_date IN DATE,
76: --
77: --
78: -- Convert constant values to their corresponding boolean value
79: --
80: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
81: --
82: -- Register Surrogate ID or user key values
83: --
84: per_suc_ins.set_base_key_value (p_succession_plan_id => p_succession_plan_id);
186: -- ----------------------------------------------------------------------------
187: -- |------------------------< delete_succession_plan >------------------------|
188: -- ----------------------------------------------------------------------------
189: PROCEDURE delete_succession_plan (
190: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
191: p_succession_plan_id IN NUMBER,
192: p_object_version_number IN NUMBER,
193: p_return_status OUT NOCOPY VARCHAR2
194: )
216: --
217: --
218: -- Convert constant values to their corresponding boolean value
219: --
220: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
221: --
222: -- Register Surrogate ID or user key values
223: --
224: --
285: -- ----------------------------------------------------------------------------
286: -- |------------------------< update_succession_plan >------------------------|
287: -- ----------------------------------------------------------------------------
288: PROCEDURE update_succession_plan (
289: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
290: p_succession_plan_id IN NUMBER,
291: p_person_id IN NUMBER DEFAULT hr_api.g_number,
292: p_position_id IN NUMBER DEFAULT hr_api.g_number,
293: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
287: -- ----------------------------------------------------------------------------
288: PROCEDURE update_succession_plan (
289: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
290: p_succession_plan_id IN NUMBER,
291: p_person_id IN NUMBER DEFAULT hr_api.g_number,
292: p_position_id IN NUMBER DEFAULT hr_api.g_number,
293: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
294: p_start_date IN DATE DEFAULT hr_api.g_date,
295: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
288: PROCEDURE update_succession_plan (
289: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
290: p_succession_plan_id IN NUMBER,
291: p_person_id IN NUMBER DEFAULT hr_api.g_number,
292: p_position_id IN NUMBER DEFAULT hr_api.g_number,
293: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
294: p_start_date IN DATE DEFAULT hr_api.g_date,
295: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_end_date IN DATE DEFAULT hr_api.g_date,
289: p_validate IN NUMBER DEFAULT hr_api.g_false_num,
290: p_succession_plan_id IN NUMBER,
291: p_person_id IN NUMBER DEFAULT hr_api.g_number,
292: p_position_id IN NUMBER DEFAULT hr_api.g_number,
293: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
294: p_start_date IN DATE DEFAULT hr_api.g_date,
295: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_end_date IN DATE DEFAULT hr_api.g_date,
297: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
290: p_succession_plan_id IN NUMBER,
291: p_person_id IN NUMBER DEFAULT hr_api.g_number,
292: p_position_id IN NUMBER DEFAULT hr_api.g_number,
293: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
294: p_start_date IN DATE DEFAULT hr_api.g_date,
295: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_end_date IN DATE DEFAULT hr_api.g_date,
297: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
291: p_person_id IN NUMBER DEFAULT hr_api.g_number,
292: p_position_id IN NUMBER DEFAULT hr_api.g_number,
293: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
294: p_start_date IN DATE DEFAULT hr_api.g_date,
295: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_end_date IN DATE DEFAULT hr_api.g_date,
297: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
292: p_position_id IN NUMBER DEFAULT hr_api.g_number,
293: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
294: p_start_date IN DATE DEFAULT hr_api.g_date,
295: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_end_date IN DATE DEFAULT hr_api.g_date,
297: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
293: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
294: p_start_date IN DATE DEFAULT hr_api.g_date,
295: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_end_date IN DATE DEFAULT hr_api.g_date,
297: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
294: p_start_date IN DATE DEFAULT hr_api.g_date,
295: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_end_date IN DATE DEFAULT hr_api.g_date,
297: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
295: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_end_date IN DATE DEFAULT hr_api.g_date,
297: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
296: p_end_date IN DATE DEFAULT hr_api.g_date,
297: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
297: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
298: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
299: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
300: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
301: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
302: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
303: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
304: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
305: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
306: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
314: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
307: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
314: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
315: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
308: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
314: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
315: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
316: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
309: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
314: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
315: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
316: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
317: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
310: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
314: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
315: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
316: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
317: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
311: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
314: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
315: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
316: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
317: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
312: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
313: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
314: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
315: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
316: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
317: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
320: p_effective_date IN DATE,
313: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
314: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
315: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
316: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
317: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
320: p_effective_date IN DATE,
321: p_job_id IN NUMBER DEFAULT hr_api.g_number,
314: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
315: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
316: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
317: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
320: p_effective_date IN DATE,
321: p_job_id IN NUMBER DEFAULT hr_api.g_number,
322: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
315: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
316: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
317: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
320: p_effective_date IN DATE,
321: p_job_id IN NUMBER DEFAULT hr_api.g_number,
322: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
323: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
317: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
318: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
320: p_effective_date IN DATE,
321: p_job_id IN NUMBER DEFAULT hr_api.g_number,
322: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
323: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
324: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
325: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
318: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
319: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
320: p_effective_date IN DATE,
321: p_job_id IN NUMBER DEFAULT hr_api.g_number,
322: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
323: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
324: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
325: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
326: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
319: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
320: p_effective_date IN DATE,
321: p_job_id IN NUMBER DEFAULT hr_api.g_number,
322: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
323: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
324: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
325: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
326: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
327: p_object_version_number IN OUT NOCOPY NUMBER,
320: p_effective_date IN DATE,
321: p_job_id IN NUMBER DEFAULT hr_api.g_number,
322: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
323: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
324: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
325: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
326: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
327: p_object_version_number IN OUT NOCOPY NUMBER,
328: p_return_status OUT NOCOPY VARCHAR2
321: p_job_id IN NUMBER DEFAULT hr_api.g_number,
322: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
323: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
324: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
325: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
326: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
327: p_object_version_number IN OUT NOCOPY NUMBER,
328: p_return_status OUT NOCOPY VARCHAR2
329: )
322: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
323: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
324: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
325: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
326: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
327: p_object_version_number IN OUT NOCOPY NUMBER,
328: p_return_status OUT NOCOPY VARCHAR2
329: )
330: IS
353: l_object_version_number := p_object_version_number;
354: --
355: -- Convert constant values to their corresponding boolean value
356: --
357: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
358: --
359: -- Register Surrogate ID or user key values
360: --
361: --