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.OTA_LP_ENROLLMENT_SWI dependencies on HR_API

Line 13: ,p_validate in number default hr_api.g_false_num

9: -- |-------------------------< create_lp_enrollment >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_lp_enrollment
12: (p_effective_date in date
13: ,p_validate in number default hr_api.g_false_num
14: ,p_learning_path_id in number
15: ,p_person_id in number default null
16: ,p_contact_id in number default null
17: ,p_path_status_code in varchar2

Line 87: hr_api.constant_to_boolean

83: --
84: -- Convert constant values to their corresponding boolean value
85: --
86: l_validate :=
87: hr_api.constant_to_boolean
88: (p_constant_value => p_validate);
89: --
90: -- Register Surrogate ID or user key values
91: --

Line 203: ,p_person_id in number default hr_api.g_number

199: PROCEDURE update_lp_enrollment
200: (p_effective_date in date
201: ,p_lp_enrollment_id in number
202: ,p_object_version_number in out nocopy number
203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number

Line 204: ,p_contact_id in number default hr_api.g_number

200: (p_effective_date in date
201: ,p_lp_enrollment_id in number
202: ,p_object_version_number in out nocopy number
203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number

Line 205: ,p_path_status_code in varchar2 default hr_api.g_varchar2

201: ,p_lp_enrollment_id in number
202: ,p_object_version_number in out nocopy number
203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date

Line 206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2

202: ,p_object_version_number in out nocopy number
203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date

Line 207: ,p_no_of_mandatory_courses in number default hr_api.g_number

203: ,p_person_id in number default hr_api.g_number
204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number

Line 208: ,p_no_of_completed_courses in number default hr_api.g_number

204: ,p_contact_id in number default hr_api.g_number
205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 209: ,p_completion_target_date in date default hr_api.g_date

205: ,p_path_status_code in varchar2 default hr_api.g_varchar2
206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 210: ,p_completion_date in date default hr_api.g_date

206: ,p_enrollment_source_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 211: ,p_creator_person_id in number default hr_api.g_number

207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 212: ,p_attribute_category in varchar2 default hr_api.g_varchar2

208: ,p_no_of_completed_courses in number default hr_api.g_number
209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 213: ,p_attribute1 in varchar2 default hr_api.g_varchar2

209: ,p_completion_target_date in date default hr_api.g_date
210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 214: ,p_attribute2 in varchar2 default hr_api.g_varchar2

210: ,p_completion_date in date default hr_api.g_date
211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 215: ,p_attribute3 in varchar2 default hr_api.g_varchar2

211: ,p_creator_person_id in number default hr_api.g_number
212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 216: ,p_attribute4 in varchar2 default hr_api.g_varchar2

212: ,p_attribute_category in varchar2 default hr_api.g_varchar2
213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 217: ,p_attribute5 in varchar2 default hr_api.g_varchar2

213: ,p_attribute1 in varchar2 default hr_api.g_varchar2
214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 218: ,p_attribute6 in varchar2 default hr_api.g_varchar2

214: ,p_attribute2 in varchar2 default hr_api.g_varchar2
215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 219: ,p_attribute7 in varchar2 default hr_api.g_varchar2

215: ,p_attribute3 in varchar2 default hr_api.g_varchar2
216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 220: ,p_attribute8 in varchar2 default hr_api.g_varchar2

216: ,p_attribute4 in varchar2 default hr_api.g_varchar2
217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 221: ,p_attribute9 in varchar2 default hr_api.g_varchar2

217: ,p_attribute5 in varchar2 default hr_api.g_varchar2
218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 222: ,p_attribute10 in varchar2 default hr_api.g_varchar2

218: ,p_attribute6 in varchar2 default hr_api.g_varchar2
219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 223: ,p_attribute11 in varchar2 default hr_api.g_varchar2

219: ,p_attribute7 in varchar2 default hr_api.g_varchar2
220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 224: ,p_attribute12 in varchar2 default hr_api.g_varchar2

220: ,p_attribute8 in varchar2 default hr_api.g_varchar2
221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 225: ,p_attribute13 in varchar2 default hr_api.g_varchar2

221: ,p_attribute9 in varchar2 default hr_api.g_varchar2
222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 226: ,p_attribute14 in varchar2 default hr_api.g_varchar2

222: ,p_attribute10 in varchar2 default hr_api.g_varchar2
223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 227: ,p_attribute15 in varchar2 default hr_api.g_varchar2

223: ,p_attribute11 in varchar2 default hr_api.g_varchar2
224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 228: ,p_attribute16 in varchar2 default hr_api.g_varchar2

224: ,p_attribute12 in varchar2 default hr_api.g_varchar2
225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 229: ,p_attribute17 in varchar2 default hr_api.g_varchar2

225: ,p_attribute13 in varchar2 default hr_api.g_varchar2
226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 230: ,p_attribute18 in varchar2 default hr_api.g_varchar2

226: ,p_attribute14 in varchar2 default hr_api.g_varchar2
227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 231: ,p_attribute19 in varchar2 default hr_api.g_varchar2

227: ,p_attribute15 in varchar2 default hr_api.g_varchar2
228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 232: ,p_attribute20 in varchar2 default hr_api.g_varchar2

228: ,p_attribute16 in varchar2 default hr_api.g_varchar2
229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 233: ,p_attribute21 in varchar2 default hr_api.g_varchar2

229: ,p_attribute17 in varchar2 default hr_api.g_varchar2
230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 234: ,p_attribute22 in varchar2 default hr_api.g_varchar2

230: ,p_attribute18 in varchar2 default hr_api.g_varchar2
231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 235: ,p_attribute23 in varchar2 default hr_api.g_varchar2

231: ,p_attribute19 in varchar2 default hr_api.g_varchar2
232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 236: ,p_attribute24 in varchar2 default hr_api.g_varchar2

232: ,p_attribute20 in varchar2 default hr_api.g_varchar2
233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute25 in varchar2 default hr_api.g_varchar2

233: ,p_attribute21 in varchar2 default hr_api.g_varchar2
234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 238: ,p_attribute26 in varchar2 default hr_api.g_varchar2

234: ,p_attribute22 in varchar2 default hr_api.g_varchar2
235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 239: ,p_attribute27 in varchar2 default hr_api.g_varchar2

235: ,p_attribute23 in varchar2 default hr_api.g_varchar2
236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2

Line 240: ,p_attribute28 in varchar2 default hr_api.g_varchar2

236: ,p_attribute24 in varchar2 default hr_api.g_varchar2
237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number

Line 241: ,p_attribute29 in varchar2 default hr_api.g_varchar2

237: ,p_attribute25 in varchar2 default hr_api.g_varchar2
238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num

Line 242: ,p_attribute30 in varchar2 default hr_api.g_varchar2

238: ,p_attribute26 in varchar2 default hr_api.g_varchar2
239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num
246: ,p_return_status out nocopy varchar2

Line 243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2

239: ,p_attribute27 in varchar2 default hr_api.g_varchar2
240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num
246: ,p_return_status out nocopy varchar2
247: ) is

Line 244: ,p_business_group_id in number default hr_api.g_number

240: ,p_attribute28 in varchar2 default hr_api.g_varchar2
241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num
246: ,p_return_status out nocopy varchar2
247: ) is
248: --

Line 245: ,p_validate in number default hr_api.g_false_num

241: ,p_attribute29 in varchar2 default hr_api.g_varchar2
242: ,p_attribute30 in varchar2 default hr_api.g_varchar2
243: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
244: ,p_business_group_id in number default hr_api.g_number
245: ,p_validate in number default hr_api.g_false_num
246: ,p_return_status out nocopy varchar2
247: ) is
248: --
249: -- Variables for API Boolean parameters

Line 275: hr_api.constant_to_boolean

271: --
272: -- Convert constant values to their corresponding boolean value
273: --
274: l_validate :=
275: hr_api.constant_to_boolean
276: (p_constant_value => p_validate);
277: --
278: -- Register Surrogate ID or user key values
279: --

Line 386: ,p_validate in number default hr_api.g_false_num

382: -- ----------------------------------------------------------------------------
383: PROCEDURE delete_lp_enrollment
384: (p_lp_enrollment_id in number
385: ,p_object_version_number in number
386: ,p_validate in number default hr_api.g_false_num
387: ,p_return_status out nocopy varchar2
388: ) is
389: --
390: -- Variables for API Boolean parameters

Line 414: hr_api.constant_to_boolean

410: --
411: -- Convert constant values to their corresponding boolean value
412: --
413: l_validate :=
414: hr_api.constant_to_boolean
415: (p_constant_value => p_validate);
416: --
417: -- Register Surrogate ID or user key values
418: --

Line 478: (p_validate in number default hr_api.g_false_num

474: -- ----------------------------------------------------------------------------
475: -- |--------------------------< SUBSCRIBE_TO_LEARNING_PATH>-------------------------|
476: -- ----------------------------------------------------------------------------
477: procedure subscribe_to_learning_path
478: (p_validate in number default hr_api.g_false_num
479: ,p_learning_path_id IN NUMBER
480: ,p_person_id IN NUMBER default null
481: ,p_contact_id IN NUMBER default null
482: ,p_enrollment_source_code IN VARCHAR2

Line 499: hr_api.constant_to_boolean

495: hr_multi_message.enable_message_list;
496: savepoint create_lp_subscription_swi;
497:
498: l_validate :=
499: hr_api.constant_to_boolean
500: (p_constant_value => p_validate);
501:
502: ota_lp_enrollment_api.subscribe_to_learning_path(
503: p_validate => l_validate

Line 544: when hr_api.validate_enabled then

540: p_path_status_code := null;
541: p_return_status := hr_multi_message.get_return_status_disable;
542: hr_utility.set_location(' Leaving:' || l_proc, 30);
543:
544: when hr_api.validate_enabled then
545: --
546: -- As the Validate_Enabled exception has been raised
547: -- we must rollback to the savepoint
548: --