8: -- ----------------------------------------------------------------------------
9: -- |---------------------------< create_checklist >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_checklist
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_name in varchar2
15: ,p_description in varchar2 default null
16: ,p_business_group_id in number default null
87: --
88: -- Convert constant values to their corresponding boolean value
89: --
90: l_validate :=
91: hr_api.constant_to_boolean
92: (p_constant_value => p_validate);
93: --
94: -- Register Surrogate ID or user key values
95: --
205: -- ----------------------------------------------------------------------------
206: -- |---------------------------< update_checklist >---------------------------|
207: -- ----------------------------------------------------------------------------
208: PROCEDURE update_checklist
209: (p_validate in number default hr_api.g_false_num
210: ,p_effective_date in date
211: ,p_checklist_id in number
212: ,p_name in varchar2
213: ,p_description in varchar2 default hr_api.g_varchar2
209: (p_validate in number default hr_api.g_false_num
210: ,p_effective_date in date
211: ,p_checklist_id in number
212: ,p_name in varchar2
213: ,p_description in varchar2 default hr_api.g_varchar2
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_life_event_reason_id in number default hr_api.g_number
216: ,p_checklist_category in varchar2 default hr_api.g_varchar2
217: ,p_attribute_category in varchar2 default hr_api.g_varchar2
210: ,p_effective_date in date
211: ,p_checklist_id in number
212: ,p_name in varchar2
213: ,p_description in varchar2 default hr_api.g_varchar2
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_life_event_reason_id in number default hr_api.g_number
216: ,p_checklist_category in varchar2 default hr_api.g_varchar2
217: ,p_attribute_category in varchar2 default hr_api.g_varchar2
218: ,p_attribute1 in varchar2 default hr_api.g_varchar2
211: ,p_checklist_id in number
212: ,p_name in varchar2
213: ,p_description in varchar2 default hr_api.g_varchar2
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_life_event_reason_id in number default hr_api.g_number
216: ,p_checklist_category in varchar2 default hr_api.g_varchar2
217: ,p_attribute_category in varchar2 default hr_api.g_varchar2
218: ,p_attribute1 in varchar2 default hr_api.g_varchar2
219: ,p_attribute2 in varchar2 default hr_api.g_varchar2
212: ,p_name in varchar2
213: ,p_description in varchar2 default hr_api.g_varchar2
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_life_event_reason_id in number default hr_api.g_number
216: ,p_checklist_category in varchar2 default hr_api.g_varchar2
217: ,p_attribute_category in varchar2 default hr_api.g_varchar2
218: ,p_attribute1 in varchar2 default hr_api.g_varchar2
219: ,p_attribute2 in varchar2 default hr_api.g_varchar2
220: ,p_attribute3 in varchar2 default hr_api.g_varchar2
213: ,p_description in varchar2 default hr_api.g_varchar2
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_life_event_reason_id in number default hr_api.g_number
216: ,p_checklist_category in varchar2 default hr_api.g_varchar2
217: ,p_attribute_category in varchar2 default hr_api.g_varchar2
218: ,p_attribute1 in varchar2 default hr_api.g_varchar2
219: ,p_attribute2 in varchar2 default hr_api.g_varchar2
220: ,p_attribute3 in varchar2 default hr_api.g_varchar2
221: ,p_attribute4 in varchar2 default hr_api.g_varchar2
214: ,p_business_group_id in number default hr_api.g_number
215: ,p_life_event_reason_id in number default hr_api.g_number
216: ,p_checklist_category in varchar2 default hr_api.g_varchar2
217: ,p_attribute_category in varchar2 default hr_api.g_varchar2
218: ,p_attribute1 in varchar2 default hr_api.g_varchar2
219: ,p_attribute2 in varchar2 default hr_api.g_varchar2
220: ,p_attribute3 in varchar2 default hr_api.g_varchar2
221: ,p_attribute4 in varchar2 default hr_api.g_varchar2
222: ,p_attribute5 in varchar2 default hr_api.g_varchar2
215: ,p_life_event_reason_id in number default hr_api.g_number
216: ,p_checklist_category in varchar2 default hr_api.g_varchar2
217: ,p_attribute_category in varchar2 default hr_api.g_varchar2
218: ,p_attribute1 in varchar2 default hr_api.g_varchar2
219: ,p_attribute2 in varchar2 default hr_api.g_varchar2
220: ,p_attribute3 in varchar2 default hr_api.g_varchar2
221: ,p_attribute4 in varchar2 default hr_api.g_varchar2
222: ,p_attribute5 in varchar2 default hr_api.g_varchar2
223: ,p_attribute6 in varchar2 default hr_api.g_varchar2
216: ,p_checklist_category in varchar2 default hr_api.g_varchar2
217: ,p_attribute_category in varchar2 default hr_api.g_varchar2
218: ,p_attribute1 in varchar2 default hr_api.g_varchar2
219: ,p_attribute2 in varchar2 default hr_api.g_varchar2
220: ,p_attribute3 in varchar2 default hr_api.g_varchar2
221: ,p_attribute4 in varchar2 default hr_api.g_varchar2
222: ,p_attribute5 in varchar2 default hr_api.g_varchar2
223: ,p_attribute6 in varchar2 default hr_api.g_varchar2
224: ,p_attribute7 in varchar2 default hr_api.g_varchar2
217: ,p_attribute_category in varchar2 default hr_api.g_varchar2
218: ,p_attribute1 in varchar2 default hr_api.g_varchar2
219: ,p_attribute2 in varchar2 default hr_api.g_varchar2
220: ,p_attribute3 in varchar2 default hr_api.g_varchar2
221: ,p_attribute4 in varchar2 default hr_api.g_varchar2
222: ,p_attribute5 in varchar2 default hr_api.g_varchar2
223: ,p_attribute6 in varchar2 default hr_api.g_varchar2
224: ,p_attribute7 in varchar2 default hr_api.g_varchar2
225: ,p_attribute8 in varchar2 default hr_api.g_varchar2
218: ,p_attribute1 in varchar2 default hr_api.g_varchar2
219: ,p_attribute2 in varchar2 default hr_api.g_varchar2
220: ,p_attribute3 in varchar2 default hr_api.g_varchar2
221: ,p_attribute4 in varchar2 default hr_api.g_varchar2
222: ,p_attribute5 in varchar2 default hr_api.g_varchar2
223: ,p_attribute6 in varchar2 default hr_api.g_varchar2
224: ,p_attribute7 in varchar2 default hr_api.g_varchar2
225: ,p_attribute8 in varchar2 default hr_api.g_varchar2
226: ,p_attribute9 in varchar2 default hr_api.g_varchar2
219: ,p_attribute2 in varchar2 default hr_api.g_varchar2
220: ,p_attribute3 in varchar2 default hr_api.g_varchar2
221: ,p_attribute4 in varchar2 default hr_api.g_varchar2
222: ,p_attribute5 in varchar2 default hr_api.g_varchar2
223: ,p_attribute6 in varchar2 default hr_api.g_varchar2
224: ,p_attribute7 in varchar2 default hr_api.g_varchar2
225: ,p_attribute8 in varchar2 default hr_api.g_varchar2
226: ,p_attribute9 in varchar2 default hr_api.g_varchar2
227: ,p_attribute10 in varchar2 default hr_api.g_varchar2
220: ,p_attribute3 in varchar2 default hr_api.g_varchar2
221: ,p_attribute4 in varchar2 default hr_api.g_varchar2
222: ,p_attribute5 in varchar2 default hr_api.g_varchar2
223: ,p_attribute6 in varchar2 default hr_api.g_varchar2
224: ,p_attribute7 in varchar2 default hr_api.g_varchar2
225: ,p_attribute8 in varchar2 default hr_api.g_varchar2
226: ,p_attribute9 in varchar2 default hr_api.g_varchar2
227: ,p_attribute10 in varchar2 default hr_api.g_varchar2
228: ,p_attribute11 in varchar2 default hr_api.g_varchar2
221: ,p_attribute4 in varchar2 default hr_api.g_varchar2
222: ,p_attribute5 in varchar2 default hr_api.g_varchar2
223: ,p_attribute6 in varchar2 default hr_api.g_varchar2
224: ,p_attribute7 in varchar2 default hr_api.g_varchar2
225: ,p_attribute8 in varchar2 default hr_api.g_varchar2
226: ,p_attribute9 in varchar2 default hr_api.g_varchar2
227: ,p_attribute10 in varchar2 default hr_api.g_varchar2
228: ,p_attribute11 in varchar2 default hr_api.g_varchar2
229: ,p_attribute12 in varchar2 default hr_api.g_varchar2
222: ,p_attribute5 in varchar2 default hr_api.g_varchar2
223: ,p_attribute6 in varchar2 default hr_api.g_varchar2
224: ,p_attribute7 in varchar2 default hr_api.g_varchar2
225: ,p_attribute8 in varchar2 default hr_api.g_varchar2
226: ,p_attribute9 in varchar2 default hr_api.g_varchar2
227: ,p_attribute10 in varchar2 default hr_api.g_varchar2
228: ,p_attribute11 in varchar2 default hr_api.g_varchar2
229: ,p_attribute12 in varchar2 default hr_api.g_varchar2
230: ,p_attribute13 in varchar2 default hr_api.g_varchar2
223: ,p_attribute6 in varchar2 default hr_api.g_varchar2
224: ,p_attribute7 in varchar2 default hr_api.g_varchar2
225: ,p_attribute8 in varchar2 default hr_api.g_varchar2
226: ,p_attribute9 in varchar2 default hr_api.g_varchar2
227: ,p_attribute10 in varchar2 default hr_api.g_varchar2
228: ,p_attribute11 in varchar2 default hr_api.g_varchar2
229: ,p_attribute12 in varchar2 default hr_api.g_varchar2
230: ,p_attribute13 in varchar2 default hr_api.g_varchar2
231: ,p_attribute14 in varchar2 default hr_api.g_varchar2
224: ,p_attribute7 in varchar2 default hr_api.g_varchar2
225: ,p_attribute8 in varchar2 default hr_api.g_varchar2
226: ,p_attribute9 in varchar2 default hr_api.g_varchar2
227: ,p_attribute10 in varchar2 default hr_api.g_varchar2
228: ,p_attribute11 in varchar2 default hr_api.g_varchar2
229: ,p_attribute12 in varchar2 default hr_api.g_varchar2
230: ,p_attribute13 in varchar2 default hr_api.g_varchar2
231: ,p_attribute14 in varchar2 default hr_api.g_varchar2
232: ,p_attribute15 in varchar2 default hr_api.g_varchar2
225: ,p_attribute8 in varchar2 default hr_api.g_varchar2
226: ,p_attribute9 in varchar2 default hr_api.g_varchar2
227: ,p_attribute10 in varchar2 default hr_api.g_varchar2
228: ,p_attribute11 in varchar2 default hr_api.g_varchar2
229: ,p_attribute12 in varchar2 default hr_api.g_varchar2
230: ,p_attribute13 in varchar2 default hr_api.g_varchar2
231: ,p_attribute14 in varchar2 default hr_api.g_varchar2
232: ,p_attribute15 in varchar2 default hr_api.g_varchar2
233: ,p_attribute16 in varchar2 default hr_api.g_varchar2
226: ,p_attribute9 in varchar2 default hr_api.g_varchar2
227: ,p_attribute10 in varchar2 default hr_api.g_varchar2
228: ,p_attribute11 in varchar2 default hr_api.g_varchar2
229: ,p_attribute12 in varchar2 default hr_api.g_varchar2
230: ,p_attribute13 in varchar2 default hr_api.g_varchar2
231: ,p_attribute14 in varchar2 default hr_api.g_varchar2
232: ,p_attribute15 in varchar2 default hr_api.g_varchar2
233: ,p_attribute16 in varchar2 default hr_api.g_varchar2
234: ,p_attribute17 in varchar2 default hr_api.g_varchar2
227: ,p_attribute10 in varchar2 default hr_api.g_varchar2
228: ,p_attribute11 in varchar2 default hr_api.g_varchar2
229: ,p_attribute12 in varchar2 default hr_api.g_varchar2
230: ,p_attribute13 in varchar2 default hr_api.g_varchar2
231: ,p_attribute14 in varchar2 default hr_api.g_varchar2
232: ,p_attribute15 in varchar2 default hr_api.g_varchar2
233: ,p_attribute16 in varchar2 default hr_api.g_varchar2
234: ,p_attribute17 in varchar2 default hr_api.g_varchar2
235: ,p_attribute18 in varchar2 default hr_api.g_varchar2
228: ,p_attribute11 in varchar2 default hr_api.g_varchar2
229: ,p_attribute12 in varchar2 default hr_api.g_varchar2
230: ,p_attribute13 in varchar2 default hr_api.g_varchar2
231: ,p_attribute14 in varchar2 default hr_api.g_varchar2
232: ,p_attribute15 in varchar2 default hr_api.g_varchar2
233: ,p_attribute16 in varchar2 default hr_api.g_varchar2
234: ,p_attribute17 in varchar2 default hr_api.g_varchar2
235: ,p_attribute18 in varchar2 default hr_api.g_varchar2
236: ,p_attribute19 in varchar2 default hr_api.g_varchar2
229: ,p_attribute12 in varchar2 default hr_api.g_varchar2
230: ,p_attribute13 in varchar2 default hr_api.g_varchar2
231: ,p_attribute14 in varchar2 default hr_api.g_varchar2
232: ,p_attribute15 in varchar2 default hr_api.g_varchar2
233: ,p_attribute16 in varchar2 default hr_api.g_varchar2
234: ,p_attribute17 in varchar2 default hr_api.g_varchar2
235: ,p_attribute18 in varchar2 default hr_api.g_varchar2
236: ,p_attribute19 in varchar2 default hr_api.g_varchar2
237: ,p_attribute20 in varchar2 default hr_api.g_varchar2
230: ,p_attribute13 in varchar2 default hr_api.g_varchar2
231: ,p_attribute14 in varchar2 default hr_api.g_varchar2
232: ,p_attribute15 in varchar2 default hr_api.g_varchar2
233: ,p_attribute16 in varchar2 default hr_api.g_varchar2
234: ,p_attribute17 in varchar2 default hr_api.g_varchar2
235: ,p_attribute18 in varchar2 default hr_api.g_varchar2
236: ,p_attribute19 in varchar2 default hr_api.g_varchar2
237: ,p_attribute20 in varchar2 default hr_api.g_varchar2
238: ,p_information_category in varchar2 default hr_api.g_varchar2
231: ,p_attribute14 in varchar2 default hr_api.g_varchar2
232: ,p_attribute15 in varchar2 default hr_api.g_varchar2
233: ,p_attribute16 in varchar2 default hr_api.g_varchar2
234: ,p_attribute17 in varchar2 default hr_api.g_varchar2
235: ,p_attribute18 in varchar2 default hr_api.g_varchar2
236: ,p_attribute19 in varchar2 default hr_api.g_varchar2
237: ,p_attribute20 in varchar2 default hr_api.g_varchar2
238: ,p_information_category in varchar2 default hr_api.g_varchar2
239: ,p_information1 in varchar2 default hr_api.g_varchar2
232: ,p_attribute15 in varchar2 default hr_api.g_varchar2
233: ,p_attribute16 in varchar2 default hr_api.g_varchar2
234: ,p_attribute17 in varchar2 default hr_api.g_varchar2
235: ,p_attribute18 in varchar2 default hr_api.g_varchar2
236: ,p_attribute19 in varchar2 default hr_api.g_varchar2
237: ,p_attribute20 in varchar2 default hr_api.g_varchar2
238: ,p_information_category in varchar2 default hr_api.g_varchar2
239: ,p_information1 in varchar2 default hr_api.g_varchar2
240: ,p_information2 in varchar2 default hr_api.g_varchar2
233: ,p_attribute16 in varchar2 default hr_api.g_varchar2
234: ,p_attribute17 in varchar2 default hr_api.g_varchar2
235: ,p_attribute18 in varchar2 default hr_api.g_varchar2
236: ,p_attribute19 in varchar2 default hr_api.g_varchar2
237: ,p_attribute20 in varchar2 default hr_api.g_varchar2
238: ,p_information_category in varchar2 default hr_api.g_varchar2
239: ,p_information1 in varchar2 default hr_api.g_varchar2
240: ,p_information2 in varchar2 default hr_api.g_varchar2
241: ,p_information3 in varchar2 default hr_api.g_varchar2
234: ,p_attribute17 in varchar2 default hr_api.g_varchar2
235: ,p_attribute18 in varchar2 default hr_api.g_varchar2
236: ,p_attribute19 in varchar2 default hr_api.g_varchar2
237: ,p_attribute20 in varchar2 default hr_api.g_varchar2
238: ,p_information_category in varchar2 default hr_api.g_varchar2
239: ,p_information1 in varchar2 default hr_api.g_varchar2
240: ,p_information2 in varchar2 default hr_api.g_varchar2
241: ,p_information3 in varchar2 default hr_api.g_varchar2
242: ,p_information4 in varchar2 default hr_api.g_varchar2
235: ,p_attribute18 in varchar2 default hr_api.g_varchar2
236: ,p_attribute19 in varchar2 default hr_api.g_varchar2
237: ,p_attribute20 in varchar2 default hr_api.g_varchar2
238: ,p_information_category in varchar2 default hr_api.g_varchar2
239: ,p_information1 in varchar2 default hr_api.g_varchar2
240: ,p_information2 in varchar2 default hr_api.g_varchar2
241: ,p_information3 in varchar2 default hr_api.g_varchar2
242: ,p_information4 in varchar2 default hr_api.g_varchar2
243: ,p_information5 in varchar2 default hr_api.g_varchar2
236: ,p_attribute19 in varchar2 default hr_api.g_varchar2
237: ,p_attribute20 in varchar2 default hr_api.g_varchar2
238: ,p_information_category in varchar2 default hr_api.g_varchar2
239: ,p_information1 in varchar2 default hr_api.g_varchar2
240: ,p_information2 in varchar2 default hr_api.g_varchar2
241: ,p_information3 in varchar2 default hr_api.g_varchar2
242: ,p_information4 in varchar2 default hr_api.g_varchar2
243: ,p_information5 in varchar2 default hr_api.g_varchar2
244: ,p_information6 in varchar2 default hr_api.g_varchar2
237: ,p_attribute20 in varchar2 default hr_api.g_varchar2
238: ,p_information_category in varchar2 default hr_api.g_varchar2
239: ,p_information1 in varchar2 default hr_api.g_varchar2
240: ,p_information2 in varchar2 default hr_api.g_varchar2
241: ,p_information3 in varchar2 default hr_api.g_varchar2
242: ,p_information4 in varchar2 default hr_api.g_varchar2
243: ,p_information5 in varchar2 default hr_api.g_varchar2
244: ,p_information6 in varchar2 default hr_api.g_varchar2
245: ,p_information7 in varchar2 default hr_api.g_varchar2
238: ,p_information_category in varchar2 default hr_api.g_varchar2
239: ,p_information1 in varchar2 default hr_api.g_varchar2
240: ,p_information2 in varchar2 default hr_api.g_varchar2
241: ,p_information3 in varchar2 default hr_api.g_varchar2
242: ,p_information4 in varchar2 default hr_api.g_varchar2
243: ,p_information5 in varchar2 default hr_api.g_varchar2
244: ,p_information6 in varchar2 default hr_api.g_varchar2
245: ,p_information7 in varchar2 default hr_api.g_varchar2
246: ,p_information8 in varchar2 default hr_api.g_varchar2
239: ,p_information1 in varchar2 default hr_api.g_varchar2
240: ,p_information2 in varchar2 default hr_api.g_varchar2
241: ,p_information3 in varchar2 default hr_api.g_varchar2
242: ,p_information4 in varchar2 default hr_api.g_varchar2
243: ,p_information5 in varchar2 default hr_api.g_varchar2
244: ,p_information6 in varchar2 default hr_api.g_varchar2
245: ,p_information7 in varchar2 default hr_api.g_varchar2
246: ,p_information8 in varchar2 default hr_api.g_varchar2
247: ,p_information9 in varchar2 default hr_api.g_varchar2
240: ,p_information2 in varchar2 default hr_api.g_varchar2
241: ,p_information3 in varchar2 default hr_api.g_varchar2
242: ,p_information4 in varchar2 default hr_api.g_varchar2
243: ,p_information5 in varchar2 default hr_api.g_varchar2
244: ,p_information6 in varchar2 default hr_api.g_varchar2
245: ,p_information7 in varchar2 default hr_api.g_varchar2
246: ,p_information8 in varchar2 default hr_api.g_varchar2
247: ,p_information9 in varchar2 default hr_api.g_varchar2
248: ,p_information10 in varchar2 default hr_api.g_varchar2
241: ,p_information3 in varchar2 default hr_api.g_varchar2
242: ,p_information4 in varchar2 default hr_api.g_varchar2
243: ,p_information5 in varchar2 default hr_api.g_varchar2
244: ,p_information6 in varchar2 default hr_api.g_varchar2
245: ,p_information7 in varchar2 default hr_api.g_varchar2
246: ,p_information8 in varchar2 default hr_api.g_varchar2
247: ,p_information9 in varchar2 default hr_api.g_varchar2
248: ,p_information10 in varchar2 default hr_api.g_varchar2
249: ,p_information11 in varchar2 default hr_api.g_varchar2
242: ,p_information4 in varchar2 default hr_api.g_varchar2
243: ,p_information5 in varchar2 default hr_api.g_varchar2
244: ,p_information6 in varchar2 default hr_api.g_varchar2
245: ,p_information7 in varchar2 default hr_api.g_varchar2
246: ,p_information8 in varchar2 default hr_api.g_varchar2
247: ,p_information9 in varchar2 default hr_api.g_varchar2
248: ,p_information10 in varchar2 default hr_api.g_varchar2
249: ,p_information11 in varchar2 default hr_api.g_varchar2
250: ,p_information12 in varchar2 default hr_api.g_varchar2
243: ,p_information5 in varchar2 default hr_api.g_varchar2
244: ,p_information6 in varchar2 default hr_api.g_varchar2
245: ,p_information7 in varchar2 default hr_api.g_varchar2
246: ,p_information8 in varchar2 default hr_api.g_varchar2
247: ,p_information9 in varchar2 default hr_api.g_varchar2
248: ,p_information10 in varchar2 default hr_api.g_varchar2
249: ,p_information11 in varchar2 default hr_api.g_varchar2
250: ,p_information12 in varchar2 default hr_api.g_varchar2
251: ,p_information13 in varchar2 default hr_api.g_varchar2
244: ,p_information6 in varchar2 default hr_api.g_varchar2
245: ,p_information7 in varchar2 default hr_api.g_varchar2
246: ,p_information8 in varchar2 default hr_api.g_varchar2
247: ,p_information9 in varchar2 default hr_api.g_varchar2
248: ,p_information10 in varchar2 default hr_api.g_varchar2
249: ,p_information11 in varchar2 default hr_api.g_varchar2
250: ,p_information12 in varchar2 default hr_api.g_varchar2
251: ,p_information13 in varchar2 default hr_api.g_varchar2
252: ,p_information14 in varchar2 default hr_api.g_varchar2
245: ,p_information7 in varchar2 default hr_api.g_varchar2
246: ,p_information8 in varchar2 default hr_api.g_varchar2
247: ,p_information9 in varchar2 default hr_api.g_varchar2
248: ,p_information10 in varchar2 default hr_api.g_varchar2
249: ,p_information11 in varchar2 default hr_api.g_varchar2
250: ,p_information12 in varchar2 default hr_api.g_varchar2
251: ,p_information13 in varchar2 default hr_api.g_varchar2
252: ,p_information14 in varchar2 default hr_api.g_varchar2
253: ,p_information15 in varchar2 default hr_api.g_varchar2
246: ,p_information8 in varchar2 default hr_api.g_varchar2
247: ,p_information9 in varchar2 default hr_api.g_varchar2
248: ,p_information10 in varchar2 default hr_api.g_varchar2
249: ,p_information11 in varchar2 default hr_api.g_varchar2
250: ,p_information12 in varchar2 default hr_api.g_varchar2
251: ,p_information13 in varchar2 default hr_api.g_varchar2
252: ,p_information14 in varchar2 default hr_api.g_varchar2
253: ,p_information15 in varchar2 default hr_api.g_varchar2
254: ,p_information16 in varchar2 default hr_api.g_varchar2
247: ,p_information9 in varchar2 default hr_api.g_varchar2
248: ,p_information10 in varchar2 default hr_api.g_varchar2
249: ,p_information11 in varchar2 default hr_api.g_varchar2
250: ,p_information12 in varchar2 default hr_api.g_varchar2
251: ,p_information13 in varchar2 default hr_api.g_varchar2
252: ,p_information14 in varchar2 default hr_api.g_varchar2
253: ,p_information15 in varchar2 default hr_api.g_varchar2
254: ,p_information16 in varchar2 default hr_api.g_varchar2
255: ,p_information17 in varchar2 default hr_api.g_varchar2
248: ,p_information10 in varchar2 default hr_api.g_varchar2
249: ,p_information11 in varchar2 default hr_api.g_varchar2
250: ,p_information12 in varchar2 default hr_api.g_varchar2
251: ,p_information13 in varchar2 default hr_api.g_varchar2
252: ,p_information14 in varchar2 default hr_api.g_varchar2
253: ,p_information15 in varchar2 default hr_api.g_varchar2
254: ,p_information16 in varchar2 default hr_api.g_varchar2
255: ,p_information17 in varchar2 default hr_api.g_varchar2
256: ,p_information18 in varchar2 default hr_api.g_varchar2
249: ,p_information11 in varchar2 default hr_api.g_varchar2
250: ,p_information12 in varchar2 default hr_api.g_varchar2
251: ,p_information13 in varchar2 default hr_api.g_varchar2
252: ,p_information14 in varchar2 default hr_api.g_varchar2
253: ,p_information15 in varchar2 default hr_api.g_varchar2
254: ,p_information16 in varchar2 default hr_api.g_varchar2
255: ,p_information17 in varchar2 default hr_api.g_varchar2
256: ,p_information18 in varchar2 default hr_api.g_varchar2
257: ,p_information19 in varchar2 default hr_api.g_varchar2
250: ,p_information12 in varchar2 default hr_api.g_varchar2
251: ,p_information13 in varchar2 default hr_api.g_varchar2
252: ,p_information14 in varchar2 default hr_api.g_varchar2
253: ,p_information15 in varchar2 default hr_api.g_varchar2
254: ,p_information16 in varchar2 default hr_api.g_varchar2
255: ,p_information17 in varchar2 default hr_api.g_varchar2
256: ,p_information18 in varchar2 default hr_api.g_varchar2
257: ,p_information19 in varchar2 default hr_api.g_varchar2
258: ,p_information20 in varchar2 default hr_api.g_varchar2
251: ,p_information13 in varchar2 default hr_api.g_varchar2
252: ,p_information14 in varchar2 default hr_api.g_varchar2
253: ,p_information15 in varchar2 default hr_api.g_varchar2
254: ,p_information16 in varchar2 default hr_api.g_varchar2
255: ,p_information17 in varchar2 default hr_api.g_varchar2
256: ,p_information18 in varchar2 default hr_api.g_varchar2
257: ,p_information19 in varchar2 default hr_api.g_varchar2
258: ,p_information20 in varchar2 default hr_api.g_varchar2
259: ,p_object_version_number in out nocopy number
252: ,p_information14 in varchar2 default hr_api.g_varchar2
253: ,p_information15 in varchar2 default hr_api.g_varchar2
254: ,p_information16 in varchar2 default hr_api.g_varchar2
255: ,p_information17 in varchar2 default hr_api.g_varchar2
256: ,p_information18 in varchar2 default hr_api.g_varchar2
257: ,p_information19 in varchar2 default hr_api.g_varchar2
258: ,p_information20 in varchar2 default hr_api.g_varchar2
259: ,p_object_version_number in out nocopy number
260: ,p_return_status out nocopy varchar2
253: ,p_information15 in varchar2 default hr_api.g_varchar2
254: ,p_information16 in varchar2 default hr_api.g_varchar2
255: ,p_information17 in varchar2 default hr_api.g_varchar2
256: ,p_information18 in varchar2 default hr_api.g_varchar2
257: ,p_information19 in varchar2 default hr_api.g_varchar2
258: ,p_information20 in varchar2 default hr_api.g_varchar2
259: ,p_object_version_number in out nocopy number
260: ,p_return_status out nocopy varchar2
261: ) is
254: ,p_information16 in varchar2 default hr_api.g_varchar2
255: ,p_information17 in varchar2 default hr_api.g_varchar2
256: ,p_information18 in varchar2 default hr_api.g_varchar2
257: ,p_information19 in varchar2 default hr_api.g_varchar2
258: ,p_information20 in varchar2 default hr_api.g_varchar2
259: ,p_object_version_number in out nocopy number
260: ,p_return_status out nocopy varchar2
261: ) is
262: --
285: --
286: -- Convert constant values to their corresponding boolean value
287: --
288: l_validate :=
289: hr_api.constant_to_boolean
290: (p_constant_value => p_validate);
291: --
292: -- Register Surrogate ID or user key values
293: --
399: -- ----------------------------------------------------------------------------
400: -- |---------------------------< delete_checklist >---------------------------|
401: -- ----------------------------------------------------------------------------
402: PROCEDURE delete_checklist
403: (p_validate in number default hr_api.g_false_num
404: ,p_checklist_id in number
405: ,p_object_version_number in number
406: ,p_return_status out nocopy varchar2
407: ) is
429: --
430: -- Convert constant values to their corresponding boolean value
431: --
432: l_validate :=
433: hr_api.constant_to_boolean
434: (p_constant_value => p_validate);
435: --
436: -- Register Surrogate ID or user key values
437: --