eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_TASKS_IN_CHECKLIST_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

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

Line 97: hr_api.constant_to_boolean

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: --

Line 223: (p_validate in number default hr_api.g_false_num

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

Line 228: ,p_eligibility_object_id in number default hr_api.g_number

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

Line 229: ,p_eligibility_profile_id 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

Line 230: ,p_ame_attribute_identifier 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

Line 231: ,p_description in varchar2 default hr_api.g_varchar2

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

Line 232: ,p_task_sequence in number default hr_api.g_number

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

Line 233: ,p_mandatory 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

Line 234: ,p_target_duration 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
238: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 235: ,p_target_duration_uom 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

Line 236: ,p_action_url 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

Line 237: ,p_attribute_category 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

Line 238: ,p_attribute1 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

Line 239: ,p_attribute2 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

Line 240: ,p_attribute3 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

Line 241: ,p_attribute4 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

Line 242: ,p_attribute5 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

Line 243: ,p_attribute6 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

Line 244: ,p_attribute7 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

Line 245: ,p_attribute8 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

Line 246: ,p_attribute9 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

Line 247: ,p_attribute10 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

Line 248: ,p_attribute11 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

Line 249: ,p_attribute12 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

Line 250: ,p_attribute13 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

Line 251: ,p_attribute14 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

Line 252: ,p_attribute15 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

Line 253: ,p_attribute16 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

Line 254: ,p_attribute17 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

Line 255: ,p_attribute18 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

Line 256: ,p_attribute19 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

Line 257: ,p_attribute20 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

Line 258: ,p_information_category 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

Line 259: ,p_information1 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

Line 260: ,p_information2 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

Line 261: ,p_information3 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

Line 262: ,p_information4 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

Line 263: ,p_information5 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

Line 264: ,p_information6 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

Line 265: ,p_information7 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

Line 266: ,p_information8 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

Line 267: ,p_information9 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

Line 268: ,p_information10 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

Line 269: ,p_information11 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

Line 270: ,p_information12 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

Line 271: ,p_information13 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

Line 272: ,p_information14 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

Line 273: ,p_information15 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

Line 274: ,p_information16 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

Line 275: ,p_information17 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

Line 276: ,p_information18 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
280: ,p_return_status out nocopy varchar2

Line 277: ,p_information19 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
281: ) is

Line 278: ,p_information20 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
282: --

Line 309: hr_api.constant_to_boolean

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: --

Line 429: (p_validate in number default hr_api.g_false_num

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

Line 459: hr_api.constant_to_boolean

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: --