8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_task_in_ckl >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_task_in_ckl
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_checklist_id in number
15: ,p_checklist_task_name in varchar2
16: ,p_eligibility_object_id in number default null
93: --
94: -- Convert constant values to their corresponding boolean value
95: --
96: l_validate :=
97: hr_api.constant_to_boolean
98: (p_constant_value => p_validate);
99: --
100: -- Register Surrogate ID or user key values
101: --
219: -- ----------------------------------------------------------------------------
220: -- |--------------------------< update_task_in_ckl >--------------------------|
221: -- ----------------------------------------------------------------------------
222: PROCEDURE update_task_in_ckl
223: (p_validate in number default hr_api.g_false_num
224: ,p_effective_date in date
225: ,p_task_in_checklist_id in number
226: ,p_checklist_id in number
227: ,p_checklist_task_name in varchar2
224: ,p_effective_date in date
225: ,p_task_in_checklist_id in number
226: ,p_checklist_id in number
227: ,p_checklist_task_name in varchar2
228: ,p_eligibility_object_id in number default hr_api.g_number
229: ,p_eligibility_profile_id in number default hr_api.g_number
230: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
231: ,p_description in varchar2 default hr_api.g_varchar2
232: ,p_task_sequence in number default hr_api.g_number
225: ,p_task_in_checklist_id in number
226: ,p_checklist_id in number
227: ,p_checklist_task_name in varchar2
228: ,p_eligibility_object_id in number default hr_api.g_number
229: ,p_eligibility_profile_id in number default hr_api.g_number
230: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
231: ,p_description in varchar2 default hr_api.g_varchar2
232: ,p_task_sequence in number default hr_api.g_number
233: ,p_mandatory in varchar2 default hr_api.g_varchar2
226: ,p_checklist_id in number
227: ,p_checklist_task_name in varchar2
228: ,p_eligibility_object_id in number default hr_api.g_number
229: ,p_eligibility_profile_id in number default hr_api.g_number
230: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
231: ,p_description in varchar2 default hr_api.g_varchar2
232: ,p_task_sequence in number default hr_api.g_number
233: ,p_mandatory in varchar2 default hr_api.g_varchar2
234: ,p_target_duration in number default hr_api.g_number
227: ,p_checklist_task_name in varchar2
228: ,p_eligibility_object_id in number default hr_api.g_number
229: ,p_eligibility_profile_id in number default hr_api.g_number
230: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
231: ,p_description in varchar2 default hr_api.g_varchar2
232: ,p_task_sequence in number default hr_api.g_number
233: ,p_mandatory in varchar2 default hr_api.g_varchar2
234: ,p_target_duration in number default hr_api.g_number
235: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
228: ,p_eligibility_object_id in number default hr_api.g_number
229: ,p_eligibility_profile_id in number default hr_api.g_number
230: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
231: ,p_description in varchar2 default hr_api.g_varchar2
232: ,p_task_sequence in number default hr_api.g_number
233: ,p_mandatory in varchar2 default hr_api.g_varchar2
234: ,p_target_duration in number default hr_api.g_number
235: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
236: ,p_action_url in varchar2 default hr_api.g_varchar2
229: ,p_eligibility_profile_id in number default hr_api.g_number
230: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
231: ,p_description in varchar2 default hr_api.g_varchar2
232: ,p_task_sequence in number default hr_api.g_number
233: ,p_mandatory in varchar2 default hr_api.g_varchar2
234: ,p_target_duration in number default hr_api.g_number
235: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
236: ,p_action_url in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
230: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
231: ,p_description in varchar2 default hr_api.g_varchar2
232: ,p_task_sequence in number default hr_api.g_number
233: ,p_mandatory in varchar2 default hr_api.g_varchar2
234: ,p_target_duration in number default hr_api.g_number
235: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
236: ,p_action_url in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
231: ,p_description in varchar2 default hr_api.g_varchar2
232: ,p_task_sequence in number default hr_api.g_number
233: ,p_mandatory in varchar2 default hr_api.g_varchar2
234: ,p_target_duration in number default hr_api.g_number
235: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
236: ,p_action_url in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
232: ,p_task_sequence in number default hr_api.g_number
233: ,p_mandatory in varchar2 default hr_api.g_varchar2
234: ,p_target_duration in number default hr_api.g_number
235: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
236: ,p_action_url in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
233: ,p_mandatory in varchar2 default hr_api.g_varchar2
234: ,p_target_duration in number default hr_api.g_number
235: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
236: ,p_action_url in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
234: ,p_target_duration in number default hr_api.g_number
235: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
236: ,p_action_url in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
235: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
236: ,p_action_url in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
236: ,p_action_url in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
237: ,p_attribute_category in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
239: ,p_attribute2 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
240: ,p_attribute3 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
241: ,p_attribute4 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
242: ,p_attribute5 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
243: ,p_attribute6 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
244: ,p_attribute7 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
245: ,p_attribute8 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
246: ,p_attribute9 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
247: ,p_attribute10 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
248: ,p_attribute11 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
249: ,p_attribute12 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
250: ,p_attribute13 in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_information_category in varchar2 default hr_api.g_varchar2
251: ,p_attribute14 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_information_category in varchar2 default hr_api.g_varchar2
259: ,p_information1 in varchar2 default hr_api.g_varchar2
252: ,p_attribute15 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_information_category in varchar2 default hr_api.g_varchar2
259: ,p_information1 in varchar2 default hr_api.g_varchar2
260: ,p_information2 in varchar2 default hr_api.g_varchar2
253: ,p_attribute16 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_information_category in varchar2 default hr_api.g_varchar2
259: ,p_information1 in varchar2 default hr_api.g_varchar2
260: ,p_information2 in varchar2 default hr_api.g_varchar2
261: ,p_information3 in varchar2 default hr_api.g_varchar2
254: ,p_attribute17 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_information_category in varchar2 default hr_api.g_varchar2
259: ,p_information1 in varchar2 default hr_api.g_varchar2
260: ,p_information2 in varchar2 default hr_api.g_varchar2
261: ,p_information3 in varchar2 default hr_api.g_varchar2
262: ,p_information4 in varchar2 default hr_api.g_varchar2
255: ,p_attribute18 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_information_category in varchar2 default hr_api.g_varchar2
259: ,p_information1 in varchar2 default hr_api.g_varchar2
260: ,p_information2 in varchar2 default hr_api.g_varchar2
261: ,p_information3 in varchar2 default hr_api.g_varchar2
262: ,p_information4 in varchar2 default hr_api.g_varchar2
263: ,p_information5 in varchar2 default hr_api.g_varchar2
256: ,p_attribute19 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_information_category in varchar2 default hr_api.g_varchar2
259: ,p_information1 in varchar2 default hr_api.g_varchar2
260: ,p_information2 in varchar2 default hr_api.g_varchar2
261: ,p_information3 in varchar2 default hr_api.g_varchar2
262: ,p_information4 in varchar2 default hr_api.g_varchar2
263: ,p_information5 in varchar2 default hr_api.g_varchar2
264: ,p_information6 in varchar2 default hr_api.g_varchar2
257: ,p_attribute20 in varchar2 default hr_api.g_varchar2
258: ,p_information_category in varchar2 default hr_api.g_varchar2
259: ,p_information1 in varchar2 default hr_api.g_varchar2
260: ,p_information2 in varchar2 default hr_api.g_varchar2
261: ,p_information3 in varchar2 default hr_api.g_varchar2
262: ,p_information4 in varchar2 default hr_api.g_varchar2
263: ,p_information5 in varchar2 default hr_api.g_varchar2
264: ,p_information6 in varchar2 default hr_api.g_varchar2
265: ,p_information7 in varchar2 default hr_api.g_varchar2
258: ,p_information_category in varchar2 default hr_api.g_varchar2
259: ,p_information1 in varchar2 default hr_api.g_varchar2
260: ,p_information2 in varchar2 default hr_api.g_varchar2
261: ,p_information3 in varchar2 default hr_api.g_varchar2
262: ,p_information4 in varchar2 default hr_api.g_varchar2
263: ,p_information5 in varchar2 default hr_api.g_varchar2
264: ,p_information6 in varchar2 default hr_api.g_varchar2
265: ,p_information7 in varchar2 default hr_api.g_varchar2
266: ,p_information8 in varchar2 default hr_api.g_varchar2
259: ,p_information1 in varchar2 default hr_api.g_varchar2
260: ,p_information2 in varchar2 default hr_api.g_varchar2
261: ,p_information3 in varchar2 default hr_api.g_varchar2
262: ,p_information4 in varchar2 default hr_api.g_varchar2
263: ,p_information5 in varchar2 default hr_api.g_varchar2
264: ,p_information6 in varchar2 default hr_api.g_varchar2
265: ,p_information7 in varchar2 default hr_api.g_varchar2
266: ,p_information8 in varchar2 default hr_api.g_varchar2
267: ,p_information9 in varchar2 default hr_api.g_varchar2
260: ,p_information2 in varchar2 default hr_api.g_varchar2
261: ,p_information3 in varchar2 default hr_api.g_varchar2
262: ,p_information4 in varchar2 default hr_api.g_varchar2
263: ,p_information5 in varchar2 default hr_api.g_varchar2
264: ,p_information6 in varchar2 default hr_api.g_varchar2
265: ,p_information7 in varchar2 default hr_api.g_varchar2
266: ,p_information8 in varchar2 default hr_api.g_varchar2
267: ,p_information9 in varchar2 default hr_api.g_varchar2
268: ,p_information10 in varchar2 default hr_api.g_varchar2
261: ,p_information3 in varchar2 default hr_api.g_varchar2
262: ,p_information4 in varchar2 default hr_api.g_varchar2
263: ,p_information5 in varchar2 default hr_api.g_varchar2
264: ,p_information6 in varchar2 default hr_api.g_varchar2
265: ,p_information7 in varchar2 default hr_api.g_varchar2
266: ,p_information8 in varchar2 default hr_api.g_varchar2
267: ,p_information9 in varchar2 default hr_api.g_varchar2
268: ,p_information10 in varchar2 default hr_api.g_varchar2
269: ,p_information11 in varchar2 default hr_api.g_varchar2
262: ,p_information4 in varchar2 default hr_api.g_varchar2
263: ,p_information5 in varchar2 default hr_api.g_varchar2
264: ,p_information6 in varchar2 default hr_api.g_varchar2
265: ,p_information7 in varchar2 default hr_api.g_varchar2
266: ,p_information8 in varchar2 default hr_api.g_varchar2
267: ,p_information9 in varchar2 default hr_api.g_varchar2
268: ,p_information10 in varchar2 default hr_api.g_varchar2
269: ,p_information11 in varchar2 default hr_api.g_varchar2
270: ,p_information12 in varchar2 default hr_api.g_varchar2
263: ,p_information5 in varchar2 default hr_api.g_varchar2
264: ,p_information6 in varchar2 default hr_api.g_varchar2
265: ,p_information7 in varchar2 default hr_api.g_varchar2
266: ,p_information8 in varchar2 default hr_api.g_varchar2
267: ,p_information9 in varchar2 default hr_api.g_varchar2
268: ,p_information10 in varchar2 default hr_api.g_varchar2
269: ,p_information11 in varchar2 default hr_api.g_varchar2
270: ,p_information12 in varchar2 default hr_api.g_varchar2
271: ,p_information13 in varchar2 default hr_api.g_varchar2
264: ,p_information6 in varchar2 default hr_api.g_varchar2
265: ,p_information7 in varchar2 default hr_api.g_varchar2
266: ,p_information8 in varchar2 default hr_api.g_varchar2
267: ,p_information9 in varchar2 default hr_api.g_varchar2
268: ,p_information10 in varchar2 default hr_api.g_varchar2
269: ,p_information11 in varchar2 default hr_api.g_varchar2
270: ,p_information12 in varchar2 default hr_api.g_varchar2
271: ,p_information13 in varchar2 default hr_api.g_varchar2
272: ,p_information14 in varchar2 default hr_api.g_varchar2
265: ,p_information7 in varchar2 default hr_api.g_varchar2
266: ,p_information8 in varchar2 default hr_api.g_varchar2
267: ,p_information9 in varchar2 default hr_api.g_varchar2
268: ,p_information10 in varchar2 default hr_api.g_varchar2
269: ,p_information11 in varchar2 default hr_api.g_varchar2
270: ,p_information12 in varchar2 default hr_api.g_varchar2
271: ,p_information13 in varchar2 default hr_api.g_varchar2
272: ,p_information14 in varchar2 default hr_api.g_varchar2
273: ,p_information15 in varchar2 default hr_api.g_varchar2
266: ,p_information8 in varchar2 default hr_api.g_varchar2
267: ,p_information9 in varchar2 default hr_api.g_varchar2
268: ,p_information10 in varchar2 default hr_api.g_varchar2
269: ,p_information11 in varchar2 default hr_api.g_varchar2
270: ,p_information12 in varchar2 default hr_api.g_varchar2
271: ,p_information13 in varchar2 default hr_api.g_varchar2
272: ,p_information14 in varchar2 default hr_api.g_varchar2
273: ,p_information15 in varchar2 default hr_api.g_varchar2
274: ,p_information16 in varchar2 default hr_api.g_varchar2
267: ,p_information9 in varchar2 default hr_api.g_varchar2
268: ,p_information10 in varchar2 default hr_api.g_varchar2
269: ,p_information11 in varchar2 default hr_api.g_varchar2
270: ,p_information12 in varchar2 default hr_api.g_varchar2
271: ,p_information13 in varchar2 default hr_api.g_varchar2
272: ,p_information14 in varchar2 default hr_api.g_varchar2
273: ,p_information15 in varchar2 default hr_api.g_varchar2
274: ,p_information16 in varchar2 default hr_api.g_varchar2
275: ,p_information17 in varchar2 default hr_api.g_varchar2
268: ,p_information10 in varchar2 default hr_api.g_varchar2
269: ,p_information11 in varchar2 default hr_api.g_varchar2
270: ,p_information12 in varchar2 default hr_api.g_varchar2
271: ,p_information13 in varchar2 default hr_api.g_varchar2
272: ,p_information14 in varchar2 default hr_api.g_varchar2
273: ,p_information15 in varchar2 default hr_api.g_varchar2
274: ,p_information16 in varchar2 default hr_api.g_varchar2
275: ,p_information17 in varchar2 default hr_api.g_varchar2
276: ,p_information18 in varchar2 default hr_api.g_varchar2
269: ,p_information11 in varchar2 default hr_api.g_varchar2
270: ,p_information12 in varchar2 default hr_api.g_varchar2
271: ,p_information13 in varchar2 default hr_api.g_varchar2
272: ,p_information14 in varchar2 default hr_api.g_varchar2
273: ,p_information15 in varchar2 default hr_api.g_varchar2
274: ,p_information16 in varchar2 default hr_api.g_varchar2
275: ,p_information17 in varchar2 default hr_api.g_varchar2
276: ,p_information18 in varchar2 default hr_api.g_varchar2
277: ,p_information19 in varchar2 default hr_api.g_varchar2
270: ,p_information12 in varchar2 default hr_api.g_varchar2
271: ,p_information13 in varchar2 default hr_api.g_varchar2
272: ,p_information14 in varchar2 default hr_api.g_varchar2
273: ,p_information15 in varchar2 default hr_api.g_varchar2
274: ,p_information16 in varchar2 default hr_api.g_varchar2
275: ,p_information17 in varchar2 default hr_api.g_varchar2
276: ,p_information18 in varchar2 default hr_api.g_varchar2
277: ,p_information19 in varchar2 default hr_api.g_varchar2
278: ,p_information20 in varchar2 default hr_api.g_varchar2
271: ,p_information13 in varchar2 default hr_api.g_varchar2
272: ,p_information14 in varchar2 default hr_api.g_varchar2
273: ,p_information15 in varchar2 default hr_api.g_varchar2
274: ,p_information16 in varchar2 default hr_api.g_varchar2
275: ,p_information17 in varchar2 default hr_api.g_varchar2
276: ,p_information18 in varchar2 default hr_api.g_varchar2
277: ,p_information19 in varchar2 default hr_api.g_varchar2
278: ,p_information20 in varchar2 default hr_api.g_varchar2
279: ,p_object_version_number in out nocopy number
272: ,p_information14 in varchar2 default hr_api.g_varchar2
273: ,p_information15 in varchar2 default hr_api.g_varchar2
274: ,p_information16 in varchar2 default hr_api.g_varchar2
275: ,p_information17 in varchar2 default hr_api.g_varchar2
276: ,p_information18 in varchar2 default hr_api.g_varchar2
277: ,p_information19 in varchar2 default hr_api.g_varchar2
278: ,p_information20 in varchar2 default hr_api.g_varchar2
279: ,p_object_version_number in out nocopy number
280: ,p_return_status out nocopy varchar2
273: ,p_information15 in varchar2 default hr_api.g_varchar2
274: ,p_information16 in varchar2 default hr_api.g_varchar2
275: ,p_information17 in varchar2 default hr_api.g_varchar2
276: ,p_information18 in varchar2 default hr_api.g_varchar2
277: ,p_information19 in varchar2 default hr_api.g_varchar2
278: ,p_information20 in varchar2 default hr_api.g_varchar2
279: ,p_object_version_number in out nocopy number
280: ,p_return_status out nocopy varchar2
281: ) is
274: ,p_information16 in varchar2 default hr_api.g_varchar2
275: ,p_information17 in varchar2 default hr_api.g_varchar2
276: ,p_information18 in varchar2 default hr_api.g_varchar2
277: ,p_information19 in varchar2 default hr_api.g_varchar2
278: ,p_information20 in varchar2 default hr_api.g_varchar2
279: ,p_object_version_number in out nocopy number
280: ,p_return_status out nocopy varchar2
281: ) is
282: --
305: --
306: -- Convert constant values to their corresponding boolean value
307: --
308: l_validate :=
309: hr_api.constant_to_boolean
310: (p_constant_value => p_validate);
311: --
312: -- Register Surrogate ID or user key values
313: --
425: -- ----------------------------------------------------------------------------
426: -- |--------------------------< delete_task_in_ckl >--------------------------|
427: -- ----------------------------------------------------------------------------
428: PROCEDURE delete_task_in_ckl
429: (p_validate in number default hr_api.g_false_num
430: ,p_task_in_checklist_id in number
431: ,p_object_version_number in number
432: ,p_return_status out nocopy varchar2
433: ) is
455: --
456: -- Convert constant values to their corresponding boolean value
457: --
458: l_validate :=
459: hr_api.constant_to_boolean
460: (p_constant_value => p_validate);
461: --
462: -- Register Surrogate ID or user key values
463: --