8: -- ----------------------------------------------------------------------------
9: -- |---------------------------< create_alloc_task >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_alloc_task
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_allocated_checklist_id in number
15: ,p_task_name in varchar2 default null
16: ,p_description in varchar2 default null
96: --
97: -- Convert constant values to their corresponding boolean value
98: --
99: l_validate :=
100: hr_api.constant_to_boolean
101: (p_constant_value => p_validate);
102: --
103: -- Register Surrogate ID or user key values
104: --
222: -- ----------------------------------------------------------------------------
223: -- |---------------------------< delete_alloc_task >--------------------------|
224: -- ----------------------------------------------------------------------------
225: PROCEDURE delete_alloc_task
226: (p_validate in number default hr_api.g_false_num
227: ,p_allocated_task_id in number
228: ,p_object_version_number in number
229: ,p_return_status out nocopy varchar2
230: ) is
252: --
253: -- Convert constant values to their corresponding boolean value
254: --
255: l_validate :=
256: hr_api.constant_to_boolean
257: (p_constant_value => p_validate);
258: --
259: -- Register Surrogate ID or user key values
260: --
316: -- ----------------------------------------------------------------------------
317: -- |---------------------------< update_alloc_task >--------------------------|
318: -- ----------------------------------------------------------------------------
319: PROCEDURE update_alloc_task
320: (p_validate in number default hr_api.g_false_num
321: ,p_effective_date in date
322: ,p_allocated_task_id in number
323: ,p_allocated_checklist_id in number
324: ,p_task_name in varchar2 default hr_api.g_varchar2
320: (p_validate in number default hr_api.g_false_num
321: ,p_effective_date in date
322: ,p_allocated_task_id in number
323: ,p_allocated_checklist_id in number
324: ,p_task_name in varchar2 default hr_api.g_varchar2
325: ,p_description in varchar2 default hr_api.g_varchar2
326: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
327: ,p_performer_orig_sys_id in number default hr_api.g_number
328: ,p_task_owner_person_id in number default hr_api.g_number
321: ,p_effective_date in date
322: ,p_allocated_task_id in number
323: ,p_allocated_checklist_id in number
324: ,p_task_name in varchar2 default hr_api.g_varchar2
325: ,p_description in varchar2 default hr_api.g_varchar2
326: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
327: ,p_performer_orig_sys_id in number default hr_api.g_number
328: ,p_task_owner_person_id in number default hr_api.g_number
329: ,p_task_sequence in number default hr_api.g_number
322: ,p_allocated_task_id in number
323: ,p_allocated_checklist_id in number
324: ,p_task_name in varchar2 default hr_api.g_varchar2
325: ,p_description in varchar2 default hr_api.g_varchar2
326: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
327: ,p_performer_orig_sys_id in number default hr_api.g_number
328: ,p_task_owner_person_id in number default hr_api.g_number
329: ,p_task_sequence in number default hr_api.g_number
330: ,p_target_start_date in date default hr_api.g_date
323: ,p_allocated_checklist_id in number
324: ,p_task_name in varchar2 default hr_api.g_varchar2
325: ,p_description in varchar2 default hr_api.g_varchar2
326: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
327: ,p_performer_orig_sys_id in number default hr_api.g_number
328: ,p_task_owner_person_id in number default hr_api.g_number
329: ,p_task_sequence in number default hr_api.g_number
330: ,p_target_start_date in date default hr_api.g_date
331: ,p_target_end_date in date default hr_api.g_date
324: ,p_task_name in varchar2 default hr_api.g_varchar2
325: ,p_description in varchar2 default hr_api.g_varchar2
326: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
327: ,p_performer_orig_sys_id in number default hr_api.g_number
328: ,p_task_owner_person_id in number default hr_api.g_number
329: ,p_task_sequence in number default hr_api.g_number
330: ,p_target_start_date in date default hr_api.g_date
331: ,p_target_end_date in date default hr_api.g_date
332: ,p_actual_start_date in date default hr_api.g_date
325: ,p_description in varchar2 default hr_api.g_varchar2
326: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
327: ,p_performer_orig_sys_id in number default hr_api.g_number
328: ,p_task_owner_person_id in number default hr_api.g_number
329: ,p_task_sequence in number default hr_api.g_number
330: ,p_target_start_date in date default hr_api.g_date
331: ,p_target_end_date in date default hr_api.g_date
332: ,p_actual_start_date in date default hr_api.g_date
333: ,p_actual_end_date in date default hr_api.g_date
326: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
327: ,p_performer_orig_sys_id in number default hr_api.g_number
328: ,p_task_owner_person_id in number default hr_api.g_number
329: ,p_task_sequence in number default hr_api.g_number
330: ,p_target_start_date in date default hr_api.g_date
331: ,p_target_end_date in date default hr_api.g_date
332: ,p_actual_start_date in date default hr_api.g_date
333: ,p_actual_end_date in date default hr_api.g_date
334: ,p_action_url in varchar2 default hr_api.g_varchar2
327: ,p_performer_orig_sys_id in number default hr_api.g_number
328: ,p_task_owner_person_id in number default hr_api.g_number
329: ,p_task_sequence in number default hr_api.g_number
330: ,p_target_start_date in date default hr_api.g_date
331: ,p_target_end_date in date default hr_api.g_date
332: ,p_actual_start_date in date default hr_api.g_date
333: ,p_actual_end_date in date default hr_api.g_date
334: ,p_action_url in varchar2 default hr_api.g_varchar2
335: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
328: ,p_task_owner_person_id in number default hr_api.g_number
329: ,p_task_sequence in number default hr_api.g_number
330: ,p_target_start_date in date default hr_api.g_date
331: ,p_target_end_date in date default hr_api.g_date
332: ,p_actual_start_date in date default hr_api.g_date
333: ,p_actual_end_date in date default hr_api.g_date
334: ,p_action_url in varchar2 default hr_api.g_varchar2
335: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
336: ,p_status in varchar2 default hr_api.g_varchar2
329: ,p_task_sequence in number default hr_api.g_number
330: ,p_target_start_date in date default hr_api.g_date
331: ,p_target_end_date in date default hr_api.g_date
332: ,p_actual_start_date in date default hr_api.g_date
333: ,p_actual_end_date in date default hr_api.g_date
334: ,p_action_url in varchar2 default hr_api.g_varchar2
335: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
336: ,p_status in varchar2 default hr_api.g_varchar2
337: ,p_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_target_start_date in date default hr_api.g_date
331: ,p_target_end_date in date default hr_api.g_date
332: ,p_actual_start_date in date default hr_api.g_date
333: ,p_actual_end_date in date default hr_api.g_date
334: ,p_action_url in varchar2 default hr_api.g_varchar2
335: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
336: ,p_status in varchar2 default hr_api.g_varchar2
337: ,p_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_target_end_date in date default hr_api.g_date
332: ,p_actual_start_date in date default hr_api.g_date
333: ,p_actual_end_date in date default hr_api.g_date
334: ,p_action_url in varchar2 default hr_api.g_varchar2
335: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
336: ,p_status in varchar2 default hr_api.g_varchar2
337: ,p_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_actual_start_date in date default hr_api.g_date
333: ,p_actual_end_date in date default hr_api.g_date
334: ,p_action_url in varchar2 default hr_api.g_varchar2
335: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
336: ,p_status in varchar2 default hr_api.g_varchar2
337: ,p_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_actual_end_date in date default hr_api.g_date
334: ,p_action_url in varchar2 default hr_api.g_varchar2
335: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
336: ,p_status in varchar2 default hr_api.g_varchar2
337: ,p_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_action_url in varchar2 default hr_api.g_varchar2
335: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
336: ,p_status in varchar2 default hr_api.g_varchar2
337: ,p_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
336: ,p_status in varchar2 default hr_api.g_varchar2
337: ,p_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_status in varchar2 default hr_api.g_varchar2
337: ,p_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_information_category in varchar2 default hr_api.g_varchar2
351: ,p_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_information_category in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
352: ,p_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_information_category in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
353: ,p_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_information_category in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
354: ,p_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_information_category in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
355: ,p_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_information_category in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
356: ,p_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_information_category in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
357: ,p_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_information_category in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
358: ,p_information_category in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
380: ,p_return_status out nocopy varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
380: ,p_return_status out nocopy varchar2
381: ) is
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_object_version_number in out nocopy number
380: ,p_return_status out nocopy varchar2
381: ) is
382: --
405: --
406: -- Convert constant values to their corresponding boolean value
407: --
408: l_validate :=
409: hr_api.constant_to_boolean
410: (p_constant_value => p_validate);
411: --
412: -- Register Surrogate ID or user key values
413: --