8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_alloc_checklist >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_alloc_checklist
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_checklist_id in number default null
15: ,p_person_id in number
16: ,p_assignment_id in number default null
88: --
89: -- Convert constant values to their corresponding boolean value
90: --
91: l_validate :=
92: hr_api.constant_to_boolean
93: (p_constant_value => p_validate);
94: --
95: -- Register Surrogate ID or user key values
96: --
206: -- ----------------------------------------------------------------------------
207: -- |------------------------< delete_alloc_checklist >------------------------|
208: -- ----------------------------------------------------------------------------
209: PROCEDURE delete_alloc_checklist
210: (p_validate in number default hr_api.g_false_num
211: ,p_allocated_checklist_id in number
212: ,p_object_version_number in number
213: ,p_return_status out nocopy varchar2
214: ) is
236: --
237: -- Convert constant values to their corresponding boolean value
238: --
239: l_validate :=
240: hr_api.constant_to_boolean
241: (p_constant_value => p_validate);
242: --
243: -- Register Surrogate ID or user key values
244: --
300: -- ----------------------------------------------------------------------------
301: -- |------------------------< update_alloc_checklist >------------------------|
302: -- ----------------------------------------------------------------------------
303: PROCEDURE update_alloc_checklist
304: (p_validate in number default hr_api.g_false_num
305: ,p_effective_date in date
306: ,p_allocated_checklist_id in number
307: ,p_checklist_id in number default hr_api.g_number
308: ,p_person_id in number default hr_api.g_number
303: PROCEDURE update_alloc_checklist
304: (p_validate in number default hr_api.g_false_num
305: ,p_effective_date in date
306: ,p_allocated_checklist_id in number
307: ,p_checklist_id in number default hr_api.g_number
308: ,p_person_id in number default hr_api.g_number
309: ,p_assignment_id in number default hr_api.g_number
310: ,p_checklist_name in varchar2 default hr_api.g_varchar2
311: ,p_description in varchar2 default hr_api.g_varchar2
304: (p_validate in number default hr_api.g_false_num
305: ,p_effective_date in date
306: ,p_allocated_checklist_id in number
307: ,p_checklist_id in number default hr_api.g_number
308: ,p_person_id in number default hr_api.g_number
309: ,p_assignment_id in number default hr_api.g_number
310: ,p_checklist_name in varchar2 default hr_api.g_varchar2
311: ,p_description in varchar2 default hr_api.g_varchar2
312: ,p_checklist_category in varchar2 default hr_api.g_varchar2
305: ,p_effective_date in date
306: ,p_allocated_checklist_id in number
307: ,p_checklist_id in number default hr_api.g_number
308: ,p_person_id in number default hr_api.g_number
309: ,p_assignment_id in number default hr_api.g_number
310: ,p_checklist_name in varchar2 default hr_api.g_varchar2
311: ,p_description in varchar2 default hr_api.g_varchar2
312: ,p_checklist_category in varchar2 default hr_api.g_varchar2
313: ,p_attribute_category in varchar2 default hr_api.g_varchar2
306: ,p_allocated_checklist_id in number
307: ,p_checklist_id in number default hr_api.g_number
308: ,p_person_id in number default hr_api.g_number
309: ,p_assignment_id in number default hr_api.g_number
310: ,p_checklist_name in varchar2 default hr_api.g_varchar2
311: ,p_description in varchar2 default hr_api.g_varchar2
312: ,p_checklist_category in varchar2 default hr_api.g_varchar2
313: ,p_attribute_category in varchar2 default hr_api.g_varchar2
314: ,p_attribute1 in varchar2 default hr_api.g_varchar2
307: ,p_checklist_id in number default hr_api.g_number
308: ,p_person_id in number default hr_api.g_number
309: ,p_assignment_id in number default hr_api.g_number
310: ,p_checklist_name in varchar2 default hr_api.g_varchar2
311: ,p_description in varchar2 default hr_api.g_varchar2
312: ,p_checklist_category in varchar2 default hr_api.g_varchar2
313: ,p_attribute_category in varchar2 default hr_api.g_varchar2
314: ,p_attribute1 in varchar2 default hr_api.g_varchar2
315: ,p_attribute2 in varchar2 default hr_api.g_varchar2
308: ,p_person_id in number default hr_api.g_number
309: ,p_assignment_id in number default hr_api.g_number
310: ,p_checklist_name in varchar2 default hr_api.g_varchar2
311: ,p_description in varchar2 default hr_api.g_varchar2
312: ,p_checklist_category in varchar2 default hr_api.g_varchar2
313: ,p_attribute_category in varchar2 default hr_api.g_varchar2
314: ,p_attribute1 in varchar2 default hr_api.g_varchar2
315: ,p_attribute2 in varchar2 default hr_api.g_varchar2
316: ,p_attribute3 in varchar2 default hr_api.g_varchar2
309: ,p_assignment_id in number default hr_api.g_number
310: ,p_checklist_name in varchar2 default hr_api.g_varchar2
311: ,p_description in varchar2 default hr_api.g_varchar2
312: ,p_checklist_category in varchar2 default hr_api.g_varchar2
313: ,p_attribute_category in varchar2 default hr_api.g_varchar2
314: ,p_attribute1 in varchar2 default hr_api.g_varchar2
315: ,p_attribute2 in varchar2 default hr_api.g_varchar2
316: ,p_attribute3 in varchar2 default hr_api.g_varchar2
317: ,p_attribute4 in varchar2 default hr_api.g_varchar2
310: ,p_checklist_name in varchar2 default hr_api.g_varchar2
311: ,p_description in varchar2 default hr_api.g_varchar2
312: ,p_checklist_category in varchar2 default hr_api.g_varchar2
313: ,p_attribute_category in varchar2 default hr_api.g_varchar2
314: ,p_attribute1 in varchar2 default hr_api.g_varchar2
315: ,p_attribute2 in varchar2 default hr_api.g_varchar2
316: ,p_attribute3 in varchar2 default hr_api.g_varchar2
317: ,p_attribute4 in varchar2 default hr_api.g_varchar2
318: ,p_attribute5 in varchar2 default hr_api.g_varchar2
311: ,p_description in varchar2 default hr_api.g_varchar2
312: ,p_checklist_category in varchar2 default hr_api.g_varchar2
313: ,p_attribute_category in varchar2 default hr_api.g_varchar2
314: ,p_attribute1 in varchar2 default hr_api.g_varchar2
315: ,p_attribute2 in varchar2 default hr_api.g_varchar2
316: ,p_attribute3 in varchar2 default hr_api.g_varchar2
317: ,p_attribute4 in varchar2 default hr_api.g_varchar2
318: ,p_attribute5 in varchar2 default hr_api.g_varchar2
319: ,p_attribute6 in varchar2 default hr_api.g_varchar2
312: ,p_checklist_category in varchar2 default hr_api.g_varchar2
313: ,p_attribute_category in varchar2 default hr_api.g_varchar2
314: ,p_attribute1 in varchar2 default hr_api.g_varchar2
315: ,p_attribute2 in varchar2 default hr_api.g_varchar2
316: ,p_attribute3 in varchar2 default hr_api.g_varchar2
317: ,p_attribute4 in varchar2 default hr_api.g_varchar2
318: ,p_attribute5 in varchar2 default hr_api.g_varchar2
319: ,p_attribute6 in varchar2 default hr_api.g_varchar2
320: ,p_attribute7 in varchar2 default hr_api.g_varchar2
313: ,p_attribute_category in varchar2 default hr_api.g_varchar2
314: ,p_attribute1 in varchar2 default hr_api.g_varchar2
315: ,p_attribute2 in varchar2 default hr_api.g_varchar2
316: ,p_attribute3 in varchar2 default hr_api.g_varchar2
317: ,p_attribute4 in varchar2 default hr_api.g_varchar2
318: ,p_attribute5 in varchar2 default hr_api.g_varchar2
319: ,p_attribute6 in varchar2 default hr_api.g_varchar2
320: ,p_attribute7 in varchar2 default hr_api.g_varchar2
321: ,p_attribute8 in varchar2 default hr_api.g_varchar2
314: ,p_attribute1 in varchar2 default hr_api.g_varchar2
315: ,p_attribute2 in varchar2 default hr_api.g_varchar2
316: ,p_attribute3 in varchar2 default hr_api.g_varchar2
317: ,p_attribute4 in varchar2 default hr_api.g_varchar2
318: ,p_attribute5 in varchar2 default hr_api.g_varchar2
319: ,p_attribute6 in varchar2 default hr_api.g_varchar2
320: ,p_attribute7 in varchar2 default hr_api.g_varchar2
321: ,p_attribute8 in varchar2 default hr_api.g_varchar2
322: ,p_attribute9 in varchar2 default hr_api.g_varchar2
315: ,p_attribute2 in varchar2 default hr_api.g_varchar2
316: ,p_attribute3 in varchar2 default hr_api.g_varchar2
317: ,p_attribute4 in varchar2 default hr_api.g_varchar2
318: ,p_attribute5 in varchar2 default hr_api.g_varchar2
319: ,p_attribute6 in varchar2 default hr_api.g_varchar2
320: ,p_attribute7 in varchar2 default hr_api.g_varchar2
321: ,p_attribute8 in varchar2 default hr_api.g_varchar2
322: ,p_attribute9 in varchar2 default hr_api.g_varchar2
323: ,p_attribute10 in varchar2 default hr_api.g_varchar2
316: ,p_attribute3 in varchar2 default hr_api.g_varchar2
317: ,p_attribute4 in varchar2 default hr_api.g_varchar2
318: ,p_attribute5 in varchar2 default hr_api.g_varchar2
319: ,p_attribute6 in varchar2 default hr_api.g_varchar2
320: ,p_attribute7 in varchar2 default hr_api.g_varchar2
321: ,p_attribute8 in varchar2 default hr_api.g_varchar2
322: ,p_attribute9 in varchar2 default hr_api.g_varchar2
323: ,p_attribute10 in varchar2 default hr_api.g_varchar2
324: ,p_attribute11 in varchar2 default hr_api.g_varchar2
317: ,p_attribute4 in varchar2 default hr_api.g_varchar2
318: ,p_attribute5 in varchar2 default hr_api.g_varchar2
319: ,p_attribute6 in varchar2 default hr_api.g_varchar2
320: ,p_attribute7 in varchar2 default hr_api.g_varchar2
321: ,p_attribute8 in varchar2 default hr_api.g_varchar2
322: ,p_attribute9 in varchar2 default hr_api.g_varchar2
323: ,p_attribute10 in varchar2 default hr_api.g_varchar2
324: ,p_attribute11 in varchar2 default hr_api.g_varchar2
325: ,p_attribute12 in varchar2 default hr_api.g_varchar2
318: ,p_attribute5 in varchar2 default hr_api.g_varchar2
319: ,p_attribute6 in varchar2 default hr_api.g_varchar2
320: ,p_attribute7 in varchar2 default hr_api.g_varchar2
321: ,p_attribute8 in varchar2 default hr_api.g_varchar2
322: ,p_attribute9 in varchar2 default hr_api.g_varchar2
323: ,p_attribute10 in varchar2 default hr_api.g_varchar2
324: ,p_attribute11 in varchar2 default hr_api.g_varchar2
325: ,p_attribute12 in varchar2 default hr_api.g_varchar2
326: ,p_attribute13 in varchar2 default hr_api.g_varchar2
319: ,p_attribute6 in varchar2 default hr_api.g_varchar2
320: ,p_attribute7 in varchar2 default hr_api.g_varchar2
321: ,p_attribute8 in varchar2 default hr_api.g_varchar2
322: ,p_attribute9 in varchar2 default hr_api.g_varchar2
323: ,p_attribute10 in varchar2 default hr_api.g_varchar2
324: ,p_attribute11 in varchar2 default hr_api.g_varchar2
325: ,p_attribute12 in varchar2 default hr_api.g_varchar2
326: ,p_attribute13 in varchar2 default hr_api.g_varchar2
327: ,p_attribute14 in varchar2 default hr_api.g_varchar2
320: ,p_attribute7 in varchar2 default hr_api.g_varchar2
321: ,p_attribute8 in varchar2 default hr_api.g_varchar2
322: ,p_attribute9 in varchar2 default hr_api.g_varchar2
323: ,p_attribute10 in varchar2 default hr_api.g_varchar2
324: ,p_attribute11 in varchar2 default hr_api.g_varchar2
325: ,p_attribute12 in varchar2 default hr_api.g_varchar2
326: ,p_attribute13 in varchar2 default hr_api.g_varchar2
327: ,p_attribute14 in varchar2 default hr_api.g_varchar2
328: ,p_attribute15 in varchar2 default hr_api.g_varchar2
321: ,p_attribute8 in varchar2 default hr_api.g_varchar2
322: ,p_attribute9 in varchar2 default hr_api.g_varchar2
323: ,p_attribute10 in varchar2 default hr_api.g_varchar2
324: ,p_attribute11 in varchar2 default hr_api.g_varchar2
325: ,p_attribute12 in varchar2 default hr_api.g_varchar2
326: ,p_attribute13 in varchar2 default hr_api.g_varchar2
327: ,p_attribute14 in varchar2 default hr_api.g_varchar2
328: ,p_attribute15 in varchar2 default hr_api.g_varchar2
329: ,p_attribute16 in varchar2 default hr_api.g_varchar2
322: ,p_attribute9 in varchar2 default hr_api.g_varchar2
323: ,p_attribute10 in varchar2 default hr_api.g_varchar2
324: ,p_attribute11 in varchar2 default hr_api.g_varchar2
325: ,p_attribute12 in varchar2 default hr_api.g_varchar2
326: ,p_attribute13 in varchar2 default hr_api.g_varchar2
327: ,p_attribute14 in varchar2 default hr_api.g_varchar2
328: ,p_attribute15 in varchar2 default hr_api.g_varchar2
329: ,p_attribute16 in varchar2 default hr_api.g_varchar2
330: ,p_attribute17 in varchar2 default hr_api.g_varchar2
323: ,p_attribute10 in varchar2 default hr_api.g_varchar2
324: ,p_attribute11 in varchar2 default hr_api.g_varchar2
325: ,p_attribute12 in varchar2 default hr_api.g_varchar2
326: ,p_attribute13 in varchar2 default hr_api.g_varchar2
327: ,p_attribute14 in varchar2 default hr_api.g_varchar2
328: ,p_attribute15 in varchar2 default hr_api.g_varchar2
329: ,p_attribute16 in varchar2 default hr_api.g_varchar2
330: ,p_attribute17 in varchar2 default hr_api.g_varchar2
331: ,p_attribute18 in varchar2 default hr_api.g_varchar2
324: ,p_attribute11 in varchar2 default hr_api.g_varchar2
325: ,p_attribute12 in varchar2 default hr_api.g_varchar2
326: ,p_attribute13 in varchar2 default hr_api.g_varchar2
327: ,p_attribute14 in varchar2 default hr_api.g_varchar2
328: ,p_attribute15 in varchar2 default hr_api.g_varchar2
329: ,p_attribute16 in varchar2 default hr_api.g_varchar2
330: ,p_attribute17 in varchar2 default hr_api.g_varchar2
331: ,p_attribute18 in varchar2 default hr_api.g_varchar2
332: ,p_attribute19 in varchar2 default hr_api.g_varchar2
325: ,p_attribute12 in varchar2 default hr_api.g_varchar2
326: ,p_attribute13 in varchar2 default hr_api.g_varchar2
327: ,p_attribute14 in varchar2 default hr_api.g_varchar2
328: ,p_attribute15 in varchar2 default hr_api.g_varchar2
329: ,p_attribute16 in varchar2 default hr_api.g_varchar2
330: ,p_attribute17 in varchar2 default hr_api.g_varchar2
331: ,p_attribute18 in varchar2 default hr_api.g_varchar2
332: ,p_attribute19 in varchar2 default hr_api.g_varchar2
333: ,p_attribute20 in varchar2 default hr_api.g_varchar2
326: ,p_attribute13 in varchar2 default hr_api.g_varchar2
327: ,p_attribute14 in varchar2 default hr_api.g_varchar2
328: ,p_attribute15 in varchar2 default hr_api.g_varchar2
329: ,p_attribute16 in varchar2 default hr_api.g_varchar2
330: ,p_attribute17 in varchar2 default hr_api.g_varchar2
331: ,p_attribute18 in varchar2 default hr_api.g_varchar2
332: ,p_attribute19 in varchar2 default hr_api.g_varchar2
333: ,p_attribute20 in varchar2 default hr_api.g_varchar2
334: ,p_information_category in varchar2 default hr_api.g_varchar2
327: ,p_attribute14 in varchar2 default hr_api.g_varchar2
328: ,p_attribute15 in varchar2 default hr_api.g_varchar2
329: ,p_attribute16 in varchar2 default hr_api.g_varchar2
330: ,p_attribute17 in varchar2 default hr_api.g_varchar2
331: ,p_attribute18 in varchar2 default hr_api.g_varchar2
332: ,p_attribute19 in varchar2 default hr_api.g_varchar2
333: ,p_attribute20 in varchar2 default hr_api.g_varchar2
334: ,p_information_category in varchar2 default hr_api.g_varchar2
335: ,p_information1 in varchar2 default hr_api.g_varchar2
328: ,p_attribute15 in varchar2 default hr_api.g_varchar2
329: ,p_attribute16 in varchar2 default hr_api.g_varchar2
330: ,p_attribute17 in varchar2 default hr_api.g_varchar2
331: ,p_attribute18 in varchar2 default hr_api.g_varchar2
332: ,p_attribute19 in varchar2 default hr_api.g_varchar2
333: ,p_attribute20 in varchar2 default hr_api.g_varchar2
334: ,p_information_category in varchar2 default hr_api.g_varchar2
335: ,p_information1 in varchar2 default hr_api.g_varchar2
336: ,p_information2 in varchar2 default hr_api.g_varchar2
329: ,p_attribute16 in varchar2 default hr_api.g_varchar2
330: ,p_attribute17 in varchar2 default hr_api.g_varchar2
331: ,p_attribute18 in varchar2 default hr_api.g_varchar2
332: ,p_attribute19 in varchar2 default hr_api.g_varchar2
333: ,p_attribute20 in varchar2 default hr_api.g_varchar2
334: ,p_information_category in varchar2 default hr_api.g_varchar2
335: ,p_information1 in varchar2 default hr_api.g_varchar2
336: ,p_information2 in varchar2 default hr_api.g_varchar2
337: ,p_information3 in varchar2 default hr_api.g_varchar2
330: ,p_attribute17 in varchar2 default hr_api.g_varchar2
331: ,p_attribute18 in varchar2 default hr_api.g_varchar2
332: ,p_attribute19 in varchar2 default hr_api.g_varchar2
333: ,p_attribute20 in varchar2 default hr_api.g_varchar2
334: ,p_information_category in varchar2 default hr_api.g_varchar2
335: ,p_information1 in varchar2 default hr_api.g_varchar2
336: ,p_information2 in varchar2 default hr_api.g_varchar2
337: ,p_information3 in varchar2 default hr_api.g_varchar2
338: ,p_information4 in varchar2 default hr_api.g_varchar2
331: ,p_attribute18 in varchar2 default hr_api.g_varchar2
332: ,p_attribute19 in varchar2 default hr_api.g_varchar2
333: ,p_attribute20 in varchar2 default hr_api.g_varchar2
334: ,p_information_category in varchar2 default hr_api.g_varchar2
335: ,p_information1 in varchar2 default hr_api.g_varchar2
336: ,p_information2 in varchar2 default hr_api.g_varchar2
337: ,p_information3 in varchar2 default hr_api.g_varchar2
338: ,p_information4 in varchar2 default hr_api.g_varchar2
339: ,p_information5 in varchar2 default hr_api.g_varchar2
332: ,p_attribute19 in varchar2 default hr_api.g_varchar2
333: ,p_attribute20 in varchar2 default hr_api.g_varchar2
334: ,p_information_category in varchar2 default hr_api.g_varchar2
335: ,p_information1 in varchar2 default hr_api.g_varchar2
336: ,p_information2 in varchar2 default hr_api.g_varchar2
337: ,p_information3 in varchar2 default hr_api.g_varchar2
338: ,p_information4 in varchar2 default hr_api.g_varchar2
339: ,p_information5 in varchar2 default hr_api.g_varchar2
340: ,p_information6 in varchar2 default hr_api.g_varchar2
333: ,p_attribute20 in varchar2 default hr_api.g_varchar2
334: ,p_information_category in varchar2 default hr_api.g_varchar2
335: ,p_information1 in varchar2 default hr_api.g_varchar2
336: ,p_information2 in varchar2 default hr_api.g_varchar2
337: ,p_information3 in varchar2 default hr_api.g_varchar2
338: ,p_information4 in varchar2 default hr_api.g_varchar2
339: ,p_information5 in varchar2 default hr_api.g_varchar2
340: ,p_information6 in varchar2 default hr_api.g_varchar2
341: ,p_information7 in varchar2 default hr_api.g_varchar2
334: ,p_information_category in varchar2 default hr_api.g_varchar2
335: ,p_information1 in varchar2 default hr_api.g_varchar2
336: ,p_information2 in varchar2 default hr_api.g_varchar2
337: ,p_information3 in varchar2 default hr_api.g_varchar2
338: ,p_information4 in varchar2 default hr_api.g_varchar2
339: ,p_information5 in varchar2 default hr_api.g_varchar2
340: ,p_information6 in varchar2 default hr_api.g_varchar2
341: ,p_information7 in varchar2 default hr_api.g_varchar2
342: ,p_information8 in varchar2 default hr_api.g_varchar2
335: ,p_information1 in varchar2 default hr_api.g_varchar2
336: ,p_information2 in varchar2 default hr_api.g_varchar2
337: ,p_information3 in varchar2 default hr_api.g_varchar2
338: ,p_information4 in varchar2 default hr_api.g_varchar2
339: ,p_information5 in varchar2 default hr_api.g_varchar2
340: ,p_information6 in varchar2 default hr_api.g_varchar2
341: ,p_information7 in varchar2 default hr_api.g_varchar2
342: ,p_information8 in varchar2 default hr_api.g_varchar2
343: ,p_information9 in varchar2 default hr_api.g_varchar2
336: ,p_information2 in varchar2 default hr_api.g_varchar2
337: ,p_information3 in varchar2 default hr_api.g_varchar2
338: ,p_information4 in varchar2 default hr_api.g_varchar2
339: ,p_information5 in varchar2 default hr_api.g_varchar2
340: ,p_information6 in varchar2 default hr_api.g_varchar2
341: ,p_information7 in varchar2 default hr_api.g_varchar2
342: ,p_information8 in varchar2 default hr_api.g_varchar2
343: ,p_information9 in varchar2 default hr_api.g_varchar2
344: ,p_information10 in varchar2 default hr_api.g_varchar2
337: ,p_information3 in varchar2 default hr_api.g_varchar2
338: ,p_information4 in varchar2 default hr_api.g_varchar2
339: ,p_information5 in varchar2 default hr_api.g_varchar2
340: ,p_information6 in varchar2 default hr_api.g_varchar2
341: ,p_information7 in varchar2 default hr_api.g_varchar2
342: ,p_information8 in varchar2 default hr_api.g_varchar2
343: ,p_information9 in varchar2 default hr_api.g_varchar2
344: ,p_information10 in varchar2 default hr_api.g_varchar2
345: ,p_information11 in varchar2 default hr_api.g_varchar2
338: ,p_information4 in varchar2 default hr_api.g_varchar2
339: ,p_information5 in varchar2 default hr_api.g_varchar2
340: ,p_information6 in varchar2 default hr_api.g_varchar2
341: ,p_information7 in varchar2 default hr_api.g_varchar2
342: ,p_information8 in varchar2 default hr_api.g_varchar2
343: ,p_information9 in varchar2 default hr_api.g_varchar2
344: ,p_information10 in varchar2 default hr_api.g_varchar2
345: ,p_information11 in varchar2 default hr_api.g_varchar2
346: ,p_information12 in varchar2 default hr_api.g_varchar2
339: ,p_information5 in varchar2 default hr_api.g_varchar2
340: ,p_information6 in varchar2 default hr_api.g_varchar2
341: ,p_information7 in varchar2 default hr_api.g_varchar2
342: ,p_information8 in varchar2 default hr_api.g_varchar2
343: ,p_information9 in varchar2 default hr_api.g_varchar2
344: ,p_information10 in varchar2 default hr_api.g_varchar2
345: ,p_information11 in varchar2 default hr_api.g_varchar2
346: ,p_information12 in varchar2 default hr_api.g_varchar2
347: ,p_information13 in varchar2 default hr_api.g_varchar2
340: ,p_information6 in varchar2 default hr_api.g_varchar2
341: ,p_information7 in varchar2 default hr_api.g_varchar2
342: ,p_information8 in varchar2 default hr_api.g_varchar2
343: ,p_information9 in varchar2 default hr_api.g_varchar2
344: ,p_information10 in varchar2 default hr_api.g_varchar2
345: ,p_information11 in varchar2 default hr_api.g_varchar2
346: ,p_information12 in varchar2 default hr_api.g_varchar2
347: ,p_information13 in varchar2 default hr_api.g_varchar2
348: ,p_information14 in varchar2 default hr_api.g_varchar2
341: ,p_information7 in varchar2 default hr_api.g_varchar2
342: ,p_information8 in varchar2 default hr_api.g_varchar2
343: ,p_information9 in varchar2 default hr_api.g_varchar2
344: ,p_information10 in varchar2 default hr_api.g_varchar2
345: ,p_information11 in varchar2 default hr_api.g_varchar2
346: ,p_information12 in varchar2 default hr_api.g_varchar2
347: ,p_information13 in varchar2 default hr_api.g_varchar2
348: ,p_information14 in varchar2 default hr_api.g_varchar2
349: ,p_information15 in varchar2 default hr_api.g_varchar2
342: ,p_information8 in varchar2 default hr_api.g_varchar2
343: ,p_information9 in varchar2 default hr_api.g_varchar2
344: ,p_information10 in varchar2 default hr_api.g_varchar2
345: ,p_information11 in varchar2 default hr_api.g_varchar2
346: ,p_information12 in varchar2 default hr_api.g_varchar2
347: ,p_information13 in varchar2 default hr_api.g_varchar2
348: ,p_information14 in varchar2 default hr_api.g_varchar2
349: ,p_information15 in varchar2 default hr_api.g_varchar2
350: ,p_information16 in varchar2 default hr_api.g_varchar2
343: ,p_information9 in varchar2 default hr_api.g_varchar2
344: ,p_information10 in varchar2 default hr_api.g_varchar2
345: ,p_information11 in varchar2 default hr_api.g_varchar2
346: ,p_information12 in varchar2 default hr_api.g_varchar2
347: ,p_information13 in varchar2 default hr_api.g_varchar2
348: ,p_information14 in varchar2 default hr_api.g_varchar2
349: ,p_information15 in varchar2 default hr_api.g_varchar2
350: ,p_information16 in varchar2 default hr_api.g_varchar2
351: ,p_information17 in varchar2 default hr_api.g_varchar2
344: ,p_information10 in varchar2 default hr_api.g_varchar2
345: ,p_information11 in varchar2 default hr_api.g_varchar2
346: ,p_information12 in varchar2 default hr_api.g_varchar2
347: ,p_information13 in varchar2 default hr_api.g_varchar2
348: ,p_information14 in varchar2 default hr_api.g_varchar2
349: ,p_information15 in varchar2 default hr_api.g_varchar2
350: ,p_information16 in varchar2 default hr_api.g_varchar2
351: ,p_information17 in varchar2 default hr_api.g_varchar2
352: ,p_information18 in varchar2 default hr_api.g_varchar2
345: ,p_information11 in varchar2 default hr_api.g_varchar2
346: ,p_information12 in varchar2 default hr_api.g_varchar2
347: ,p_information13 in varchar2 default hr_api.g_varchar2
348: ,p_information14 in varchar2 default hr_api.g_varchar2
349: ,p_information15 in varchar2 default hr_api.g_varchar2
350: ,p_information16 in varchar2 default hr_api.g_varchar2
351: ,p_information17 in varchar2 default hr_api.g_varchar2
352: ,p_information18 in varchar2 default hr_api.g_varchar2
353: ,p_information19 in varchar2 default hr_api.g_varchar2
346: ,p_information12 in varchar2 default hr_api.g_varchar2
347: ,p_information13 in varchar2 default hr_api.g_varchar2
348: ,p_information14 in varchar2 default hr_api.g_varchar2
349: ,p_information15 in varchar2 default hr_api.g_varchar2
350: ,p_information16 in varchar2 default hr_api.g_varchar2
351: ,p_information17 in varchar2 default hr_api.g_varchar2
352: ,p_information18 in varchar2 default hr_api.g_varchar2
353: ,p_information19 in varchar2 default hr_api.g_varchar2
354: ,p_information20 in varchar2 default hr_api.g_varchar2
347: ,p_information13 in varchar2 default hr_api.g_varchar2
348: ,p_information14 in varchar2 default hr_api.g_varchar2
349: ,p_information15 in varchar2 default hr_api.g_varchar2
350: ,p_information16 in varchar2 default hr_api.g_varchar2
351: ,p_information17 in varchar2 default hr_api.g_varchar2
352: ,p_information18 in varchar2 default hr_api.g_varchar2
353: ,p_information19 in varchar2 default hr_api.g_varchar2
354: ,p_information20 in varchar2 default hr_api.g_varchar2
355: ,p_object_version_number in out nocopy number
348: ,p_information14 in varchar2 default hr_api.g_varchar2
349: ,p_information15 in varchar2 default hr_api.g_varchar2
350: ,p_information16 in varchar2 default hr_api.g_varchar2
351: ,p_information17 in varchar2 default hr_api.g_varchar2
352: ,p_information18 in varchar2 default hr_api.g_varchar2
353: ,p_information19 in varchar2 default hr_api.g_varchar2
354: ,p_information20 in varchar2 default hr_api.g_varchar2
355: ,p_object_version_number in out nocopy number
356: ,p_return_status out nocopy varchar2
349: ,p_information15 in varchar2 default hr_api.g_varchar2
350: ,p_information16 in varchar2 default hr_api.g_varchar2
351: ,p_information17 in varchar2 default hr_api.g_varchar2
352: ,p_information18 in varchar2 default hr_api.g_varchar2
353: ,p_information19 in varchar2 default hr_api.g_varchar2
354: ,p_information20 in varchar2 default hr_api.g_varchar2
355: ,p_object_version_number in out nocopy number
356: ,p_return_status out nocopy varchar2
357: ) is
350: ,p_information16 in varchar2 default hr_api.g_varchar2
351: ,p_information17 in varchar2 default hr_api.g_varchar2
352: ,p_information18 in varchar2 default hr_api.g_varchar2
353: ,p_information19 in varchar2 default hr_api.g_varchar2
354: ,p_information20 in varchar2 default hr_api.g_varchar2
355: ,p_object_version_number in out nocopy number
356: ,p_return_status out nocopy varchar2
357: ) is
358: --
381: --
382: -- Convert constant values to their corresponding boolean value
383: --
384: l_validate :=
385: hr_api.constant_to_boolean
386: (p_constant_value => p_validate);
387: --
388: -- Register Surrogate ID or user key values
389: --