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_CERTIFICATION_SWI dependencies on HR_API

Line 13: ,p_validate in number default hr_api.g_false_num

9: -- |-------------------------< create_certification >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_certification
12: (p_effective_date in date
13: ,p_validate in number default hr_api.g_false_num
14: ,p_name in varchar2
15: ,p_business_group_id in number
16: ,p_public_flag in varchar2 default null
17: ,p_initial_completion_date in date default null

Line 88: hr_api.constant_to_boolean

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

Line 211: ,p_name in varchar2 default hr_api.g_varchar2

207: PROCEDURE update_certification
208: (p_effective_date in date
209: ,p_certification_id in number
210: ,p_object_version_number in out nocopy number
211: ,p_name in varchar2 default hr_api.g_varchar2
212: ,p_public_flag in varchar2 default hr_api.g_varchar2
213: ,p_initial_completion_date in date default hr_api.g_date
214: ,p_initial_completion_duration in number default hr_api.g_number
215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2

Line 212: ,p_public_flag in varchar2 default hr_api.g_varchar2

208: (p_effective_date in date
209: ,p_certification_id in number
210: ,p_object_version_number in out nocopy number
211: ,p_name in varchar2 default hr_api.g_varchar2
212: ,p_public_flag in varchar2 default hr_api.g_varchar2
213: ,p_initial_completion_date in date default hr_api.g_date
214: ,p_initial_completion_duration in number default hr_api.g_number
215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
216: ,p_renewal_duration in number default hr_api.g_number

Line 213: ,p_initial_completion_date in date default hr_api.g_date

209: ,p_certification_id in number
210: ,p_object_version_number in out nocopy number
211: ,p_name in varchar2 default hr_api.g_varchar2
212: ,p_public_flag in varchar2 default hr_api.g_varchar2
213: ,p_initial_completion_date in date default hr_api.g_date
214: ,p_initial_completion_duration in number default hr_api.g_number
215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
216: ,p_renewal_duration in number default hr_api.g_number
217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2

Line 214: ,p_initial_completion_duration in number default hr_api.g_number

210: ,p_object_version_number in out nocopy number
211: ,p_name in varchar2 default hr_api.g_varchar2
212: ,p_public_flag in varchar2 default hr_api.g_varchar2
213: ,p_initial_completion_date in date default hr_api.g_date
214: ,p_initial_completion_duration in number default hr_api.g_number
215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
216: ,p_renewal_duration in number default hr_api.g_number
217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
218: ,p_notify_days_before_expire in number default hr_api.g_number

Line 215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2

211: ,p_name in varchar2 default hr_api.g_varchar2
212: ,p_public_flag in varchar2 default hr_api.g_varchar2
213: ,p_initial_completion_date in date default hr_api.g_date
214: ,p_initial_completion_duration in number default hr_api.g_number
215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
216: ,p_renewal_duration in number default hr_api.g_number
217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
218: ,p_notify_days_before_expire in number default hr_api.g_number
219: ,p_start_date_active in date default hr_api.g_date

Line 216: ,p_renewal_duration in number default hr_api.g_number

212: ,p_public_flag in varchar2 default hr_api.g_varchar2
213: ,p_initial_completion_date in date default hr_api.g_date
214: ,p_initial_completion_duration in number default hr_api.g_number
215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
216: ,p_renewal_duration in number default hr_api.g_number
217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
218: ,p_notify_days_before_expire in number default hr_api.g_number
219: ,p_start_date_active in date default hr_api.g_date
220: ,p_end_date_active in date default hr_api.g_date

Line 217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2

213: ,p_initial_completion_date in date default hr_api.g_date
214: ,p_initial_completion_duration in number default hr_api.g_number
215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
216: ,p_renewal_duration in number default hr_api.g_number
217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
218: ,p_notify_days_before_expire in number default hr_api.g_number
219: ,p_start_date_active in date default hr_api.g_date
220: ,p_end_date_active in date default hr_api.g_date
221: ,p_description in varchar2 default hr_api.g_varchar2

Line 218: ,p_notify_days_before_expire in number default hr_api.g_number

214: ,p_initial_completion_duration in number default hr_api.g_number
215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
216: ,p_renewal_duration in number default hr_api.g_number
217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
218: ,p_notify_days_before_expire in number default hr_api.g_number
219: ,p_start_date_active in date default hr_api.g_date
220: ,p_end_date_active in date default hr_api.g_date
221: ,p_description in varchar2 default hr_api.g_varchar2
222: ,p_objectives in varchar2 default hr_api.g_varchar2

Line 219: ,p_start_date_active in date default hr_api.g_date

215: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
216: ,p_renewal_duration in number default hr_api.g_number
217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
218: ,p_notify_days_before_expire in number default hr_api.g_number
219: ,p_start_date_active in date default hr_api.g_date
220: ,p_end_date_active in date default hr_api.g_date
221: ,p_description in varchar2 default hr_api.g_varchar2
222: ,p_objectives in varchar2 default hr_api.g_varchar2
223: ,p_purpose in varchar2 default hr_api.g_varchar2

Line 220: ,p_end_date_active in date default hr_api.g_date

216: ,p_renewal_duration in number default hr_api.g_number
217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
218: ,p_notify_days_before_expire in number default hr_api.g_number
219: ,p_start_date_active in date default hr_api.g_date
220: ,p_end_date_active in date default hr_api.g_date
221: ,p_description in varchar2 default hr_api.g_varchar2
222: ,p_objectives in varchar2 default hr_api.g_varchar2
223: ,p_purpose in varchar2 default hr_api.g_varchar2
224: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 221: ,p_description in varchar2 default hr_api.g_varchar2

217: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
218: ,p_notify_days_before_expire in number default hr_api.g_number
219: ,p_start_date_active in date default hr_api.g_date
220: ,p_end_date_active in date default hr_api.g_date
221: ,p_description in varchar2 default hr_api.g_varchar2
222: ,p_objectives in varchar2 default hr_api.g_varchar2
223: ,p_purpose in varchar2 default hr_api.g_varchar2
224: ,p_keywords in varchar2 default hr_api.g_varchar2
225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2

Line 222: ,p_objectives in varchar2 default hr_api.g_varchar2

218: ,p_notify_days_before_expire in number default hr_api.g_number
219: ,p_start_date_active in date default hr_api.g_date
220: ,p_end_date_active in date default hr_api.g_date
221: ,p_description in varchar2 default hr_api.g_varchar2
222: ,p_objectives in varchar2 default hr_api.g_varchar2
223: ,p_purpose in varchar2 default hr_api.g_varchar2
224: ,p_keywords in varchar2 default hr_api.g_varchar2
225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2

Line 223: ,p_purpose in varchar2 default hr_api.g_varchar2

219: ,p_start_date_active in date default hr_api.g_date
220: ,p_end_date_active in date default hr_api.g_date
221: ,p_description in varchar2 default hr_api.g_varchar2
222: ,p_objectives in varchar2 default hr_api.g_varchar2
223: ,p_purpose in varchar2 default hr_api.g_varchar2
224: ,p_keywords in varchar2 default hr_api.g_varchar2
225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2

Line 224: ,p_keywords in varchar2 default hr_api.g_varchar2

220: ,p_end_date_active in date default hr_api.g_date
221: ,p_description in varchar2 default hr_api.g_varchar2
222: ,p_objectives in varchar2 default hr_api.g_varchar2
223: ,p_purpose in varchar2 default hr_api.g_varchar2
224: ,p_keywords in varchar2 default hr_api.g_varchar2
225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
228: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2

221: ,p_description in varchar2 default hr_api.g_varchar2
222: ,p_objectives in varchar2 default hr_api.g_varchar2
223: ,p_purpose in varchar2 default hr_api.g_varchar2
224: ,p_keywords in varchar2 default hr_api.g_varchar2
225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
228: ,p_attribute_category in varchar2 default hr_api.g_varchar2
229: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2

222: ,p_objectives in varchar2 default hr_api.g_varchar2
223: ,p_purpose in varchar2 default hr_api.g_varchar2
224: ,p_keywords in varchar2 default hr_api.g_varchar2
225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
228: ,p_attribute_category in varchar2 default hr_api.g_varchar2
229: ,p_attribute1 in varchar2 default hr_api.g_varchar2
230: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2

223: ,p_purpose in varchar2 default hr_api.g_varchar2
224: ,p_keywords in varchar2 default hr_api.g_varchar2
225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
228: ,p_attribute_category in varchar2 default hr_api.g_varchar2
229: ,p_attribute1 in varchar2 default hr_api.g_varchar2
230: ,p_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 228: ,p_attribute_category in varchar2 default hr_api.g_varchar2

224: ,p_keywords in varchar2 default hr_api.g_varchar2
225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
228: ,p_attribute_category in varchar2 default hr_api.g_varchar2
229: ,p_attribute1 in varchar2 default hr_api.g_varchar2
230: ,p_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 229: ,p_attribute1 in varchar2 default hr_api.g_varchar2

225: ,p_end_date_comments in varchar2 default hr_api.g_varchar2
226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
228: ,p_attribute_category in varchar2 default hr_api.g_varchar2
229: ,p_attribute1 in varchar2 default hr_api.g_varchar2
230: ,p_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 230: ,p_attribute2 in varchar2 default hr_api.g_varchar2

226: ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
228: ,p_attribute_category in varchar2 default hr_api.g_varchar2
229: ,p_attribute1 in varchar2 default hr_api.g_varchar2
230: ,p_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 231: ,p_attribute3 in varchar2 default hr_api.g_varchar2

227: ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
228: ,p_attribute_category in varchar2 default hr_api.g_varchar2
229: ,p_attribute1 in varchar2 default hr_api.g_varchar2
230: ,p_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 232: ,p_attribute4 in varchar2 default hr_api.g_varchar2

228: ,p_attribute_category in varchar2 default hr_api.g_varchar2
229: ,p_attribute1 in varchar2 default hr_api.g_varchar2
230: ,p_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 233: ,p_attribute5 in varchar2 default hr_api.g_varchar2

229: ,p_attribute1 in varchar2 default hr_api.g_varchar2
230: ,p_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 234: ,p_attribute6 in varchar2 default hr_api.g_varchar2

230: ,p_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 235: ,p_attribute7 in varchar2 default hr_api.g_varchar2

231: ,p_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 236: ,p_attribute8 in varchar2 default hr_api.g_varchar2

232: ,p_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute9 in varchar2 default hr_api.g_varchar2

233: ,p_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 238: ,p_attribute10 in varchar2 default hr_api.g_varchar2

234: ,p_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 239: ,p_attribute11 in varchar2 default hr_api.g_varchar2

235: ,p_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 240: ,p_attribute12 in varchar2 default hr_api.g_varchar2

236: ,p_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 241: ,p_attribute13 in varchar2 default hr_api.g_varchar2

237: ,p_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 242: ,p_attribute14 in varchar2 default hr_api.g_varchar2

238: ,p_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 243: ,p_attribute15 in varchar2 default hr_api.g_varchar2

239: ,p_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 244: ,p_attribute16 in varchar2 default hr_api.g_varchar2

240: ,p_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute17 in varchar2 default hr_api.g_varchar2

241: ,p_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_business_group_id in number default hr_api.g_number

Line 246: ,p_attribute18 in varchar2 default hr_api.g_varchar2

242: ,p_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_business_group_id in number default hr_api.g_number
250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number

Line 247: ,p_attribute19 in varchar2 default hr_api.g_varchar2

243: ,p_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_business_group_id in number default hr_api.g_number
250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2

Line 248: ,p_attribute20 in varchar2 default hr_api.g_varchar2

244: ,p_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_business_group_id in number default hr_api.g_number
250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
252: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2

Line 249: ,p_business_group_id in number default hr_api.g_number

245: ,p_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_business_group_id in number default hr_api.g_number
250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
252: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
253: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2

Line 250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number

246: ,p_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_business_group_id in number default hr_api.g_number
250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
252: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
253: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
254: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2

Line 251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2

247: ,p_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_business_group_id in number default hr_api.g_number
250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
252: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
253: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
254: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
255: ,p_validate in number default hr_api.g_false_num

Line 252: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2

248: ,p_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_business_group_id in number default hr_api.g_number
250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
252: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
253: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
254: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
255: ,p_validate in number default hr_api.g_false_num
256: ,p_return_status out nocopy varchar2

Line 253: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2

249: ,p_business_group_id in number default hr_api.g_number
250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
252: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
253: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
254: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
255: ,p_validate in number default hr_api.g_false_num
256: ,p_return_status out nocopy varchar2
257: ) is

Line 254: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2

250: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
252: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
253: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
254: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
255: ,p_validate in number default hr_api.g_false_num
256: ,p_return_status out nocopy varchar2
257: ) is
258: --

Line 255: ,p_validate in number default hr_api.g_false_num

251: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
252: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
253: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
254: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
255: ,p_validate in number default hr_api.g_false_num
256: ,p_return_status out nocopy varchar2
257: ) is
258: --
259: -- Variables for API Boolean parameters

Line 285: hr_api.constant_to_boolean

281: --
282: -- Convert constant values to their corresponding boolean value
283: --
284: l_validate :=
285: hr_api.constant_to_boolean
286: (p_constant_value => p_validate);
287: --
288: -- Register Surrogate ID or user key values
289: --

Line 291: IF p_name <> hr_api.g_varchar2 THEN

287: --
288: -- Register Surrogate ID or user key values
289: --
290:
291: IF p_name <> hr_api.g_varchar2 THEN
292: check_duplicate_name
293: ( p_name => p_name
294: ,p_certification_id => p_certification_id
295: ,p_business_group_id=> p_business_group_id

Line 406: ,p_validate in number default hr_api.g_false_num

402: -- ----------------------------------------------------------------------------
403: PROCEDURE delete_certification
404: (p_certification_id in number
405: ,p_object_version_number in number
406: ,p_validate in number default hr_api.g_false_num
407: ,p_return_status out nocopy varchar2
408: ) is
409: --
410: -- Variables for API Boolean parameters

Line 434: hr_api.constant_to_boolean

430: --
431: -- Convert constant values to their corresponding boolean value
432: --
433: l_validate :=
434: hr_api.constant_to_boolean
435: (p_constant_value => p_validate);
436: --
437: -- Register Surrogate ID or user key values
438: --