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