36: * @param p_effective_date Determines when the DateTrack operation comes into
37: * force.
38: * @param p_language_code Specifies to which language the translation values
39: * apply. You can set to the base or any installed language. The default value
40: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
41: * value.
42: * @param p_name Qualification type name.
43: * @param p_category A grouping or categorization of the qualification type.
44: * Valid values are defined in the PER_CATEGORIES lookup type.
95: --
96: procedure create_no_qualification_type
97: (p_validate in boolean default false
98: ,p_effective_date in date
99: ,p_language_code in varchar2 default hr_api.userenv_lang
100: ,p_name in varchar2
101: ,p_category in varchar2
102: ,p_rank in number default null
103: ,p_attribute_category in varchar2 default null
172: * @param p_effective_date Determines when the DateTrack operation comes into
173: * force.
174: * @param p_language_code Specifies to which language the translation values
175: * apply. You can set to the base or any installed language. The default value
176: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
177: * value.
178: * @param p_name Qualification type name.
179: * @param p_category A grouping or categorization of the qualification type.
180: * Valid values are defined in the PER_CATEGORIES lookup type.
230: (p_validate in boolean default false
231: ,p_qualification_type_id in number
232: ,p_object_version_number in out nocopy number
233: ,p_effective_date in date
234: ,p_language_code in varchar2 default hr_api.userenv_lang
235: ,p_name in varchar2 default hr_api.g_varchar2
236: ,p_category in varchar2 default hr_api.g_varchar2
237: ,p_rank in number default hr_api.g_number
238: ,p_attribute_category in varchar2 default hr_api.g_varchar2
231: ,p_qualification_type_id in number
232: ,p_object_version_number in out nocopy number
233: ,p_effective_date in date
234: ,p_language_code in varchar2 default hr_api.userenv_lang
235: ,p_name in varchar2 default hr_api.g_varchar2
236: ,p_category in varchar2 default hr_api.g_varchar2
237: ,p_rank in number default hr_api.g_number
238: ,p_attribute_category in varchar2 default hr_api.g_varchar2
239: ,p_attribute1 in varchar2 default hr_api.g_varchar2
232: ,p_object_version_number in out nocopy number
233: ,p_effective_date in date
234: ,p_language_code in varchar2 default hr_api.userenv_lang
235: ,p_name in varchar2 default hr_api.g_varchar2
236: ,p_category in varchar2 default hr_api.g_varchar2
237: ,p_rank in number default hr_api.g_number
238: ,p_attribute_category in varchar2 default hr_api.g_varchar2
239: ,p_attribute1 in varchar2 default hr_api.g_varchar2
240: ,p_attribute2 in varchar2 default hr_api.g_varchar2
233: ,p_effective_date in date
234: ,p_language_code in varchar2 default hr_api.userenv_lang
235: ,p_name in varchar2 default hr_api.g_varchar2
236: ,p_category in varchar2 default hr_api.g_varchar2
237: ,p_rank in number default hr_api.g_number
238: ,p_attribute_category in varchar2 default hr_api.g_varchar2
239: ,p_attribute1 in varchar2 default hr_api.g_varchar2
240: ,p_attribute2 in varchar2 default hr_api.g_varchar2
241: ,p_attribute3 in varchar2 default hr_api.g_varchar2
234: ,p_language_code in varchar2 default hr_api.userenv_lang
235: ,p_name in varchar2 default hr_api.g_varchar2
236: ,p_category in varchar2 default hr_api.g_varchar2
237: ,p_rank in number default hr_api.g_number
238: ,p_attribute_category in varchar2 default hr_api.g_varchar2
239: ,p_attribute1 in varchar2 default hr_api.g_varchar2
240: ,p_attribute2 in varchar2 default hr_api.g_varchar2
241: ,p_attribute3 in varchar2 default hr_api.g_varchar2
242: ,p_attribute4 in varchar2 default hr_api.g_varchar2
235: ,p_name in varchar2 default hr_api.g_varchar2
236: ,p_category in varchar2 default hr_api.g_varchar2
237: ,p_rank in number default hr_api.g_number
238: ,p_attribute_category in varchar2 default hr_api.g_varchar2
239: ,p_attribute1 in varchar2 default hr_api.g_varchar2
240: ,p_attribute2 in varchar2 default hr_api.g_varchar2
241: ,p_attribute3 in varchar2 default hr_api.g_varchar2
242: ,p_attribute4 in varchar2 default hr_api.g_varchar2
243: ,p_attribute5 in varchar2 default hr_api.g_varchar2
236: ,p_category in varchar2 default hr_api.g_varchar2
237: ,p_rank in number default hr_api.g_number
238: ,p_attribute_category in varchar2 default hr_api.g_varchar2
239: ,p_attribute1 in varchar2 default hr_api.g_varchar2
240: ,p_attribute2 in varchar2 default hr_api.g_varchar2
241: ,p_attribute3 in varchar2 default hr_api.g_varchar2
242: ,p_attribute4 in varchar2 default hr_api.g_varchar2
243: ,p_attribute5 in varchar2 default hr_api.g_varchar2
244: ,p_attribute6 in varchar2 default hr_api.g_varchar2
237: ,p_rank in number default hr_api.g_number
238: ,p_attribute_category in varchar2 default hr_api.g_varchar2
239: ,p_attribute1 in varchar2 default hr_api.g_varchar2
240: ,p_attribute2 in varchar2 default hr_api.g_varchar2
241: ,p_attribute3 in varchar2 default hr_api.g_varchar2
242: ,p_attribute4 in varchar2 default hr_api.g_varchar2
243: ,p_attribute5 in varchar2 default hr_api.g_varchar2
244: ,p_attribute6 in varchar2 default hr_api.g_varchar2
245: ,p_attribute7 in varchar2 default hr_api.g_varchar2
238: ,p_attribute_category in varchar2 default hr_api.g_varchar2
239: ,p_attribute1 in varchar2 default hr_api.g_varchar2
240: ,p_attribute2 in varchar2 default hr_api.g_varchar2
241: ,p_attribute3 in varchar2 default hr_api.g_varchar2
242: ,p_attribute4 in varchar2 default hr_api.g_varchar2
243: ,p_attribute5 in varchar2 default hr_api.g_varchar2
244: ,p_attribute6 in varchar2 default hr_api.g_varchar2
245: ,p_attribute7 in varchar2 default hr_api.g_varchar2
246: ,p_attribute8 in varchar2 default hr_api.g_varchar2
239: ,p_attribute1 in varchar2 default hr_api.g_varchar2
240: ,p_attribute2 in varchar2 default hr_api.g_varchar2
241: ,p_attribute3 in varchar2 default hr_api.g_varchar2
242: ,p_attribute4 in varchar2 default hr_api.g_varchar2
243: ,p_attribute5 in varchar2 default hr_api.g_varchar2
244: ,p_attribute6 in varchar2 default hr_api.g_varchar2
245: ,p_attribute7 in varchar2 default hr_api.g_varchar2
246: ,p_attribute8 in varchar2 default hr_api.g_varchar2
247: ,p_attribute9 in varchar2 default hr_api.g_varchar2
240: ,p_attribute2 in varchar2 default hr_api.g_varchar2
241: ,p_attribute3 in varchar2 default hr_api.g_varchar2
242: ,p_attribute4 in varchar2 default hr_api.g_varchar2
243: ,p_attribute5 in varchar2 default hr_api.g_varchar2
244: ,p_attribute6 in varchar2 default hr_api.g_varchar2
245: ,p_attribute7 in varchar2 default hr_api.g_varchar2
246: ,p_attribute8 in varchar2 default hr_api.g_varchar2
247: ,p_attribute9 in varchar2 default hr_api.g_varchar2
248: ,p_attribute10 in varchar2 default hr_api.g_varchar2
241: ,p_attribute3 in varchar2 default hr_api.g_varchar2
242: ,p_attribute4 in varchar2 default hr_api.g_varchar2
243: ,p_attribute5 in varchar2 default hr_api.g_varchar2
244: ,p_attribute6 in varchar2 default hr_api.g_varchar2
245: ,p_attribute7 in varchar2 default hr_api.g_varchar2
246: ,p_attribute8 in varchar2 default hr_api.g_varchar2
247: ,p_attribute9 in varchar2 default hr_api.g_varchar2
248: ,p_attribute10 in varchar2 default hr_api.g_varchar2
249: ,p_attribute11 in varchar2 default hr_api.g_varchar2
242: ,p_attribute4 in varchar2 default hr_api.g_varchar2
243: ,p_attribute5 in varchar2 default hr_api.g_varchar2
244: ,p_attribute6 in varchar2 default hr_api.g_varchar2
245: ,p_attribute7 in varchar2 default hr_api.g_varchar2
246: ,p_attribute8 in varchar2 default hr_api.g_varchar2
247: ,p_attribute9 in varchar2 default hr_api.g_varchar2
248: ,p_attribute10 in varchar2 default hr_api.g_varchar2
249: ,p_attribute11 in varchar2 default hr_api.g_varchar2
250: ,p_attribute12 in varchar2 default hr_api.g_varchar2
243: ,p_attribute5 in varchar2 default hr_api.g_varchar2
244: ,p_attribute6 in varchar2 default hr_api.g_varchar2
245: ,p_attribute7 in varchar2 default hr_api.g_varchar2
246: ,p_attribute8 in varchar2 default hr_api.g_varchar2
247: ,p_attribute9 in varchar2 default hr_api.g_varchar2
248: ,p_attribute10 in varchar2 default hr_api.g_varchar2
249: ,p_attribute11 in varchar2 default hr_api.g_varchar2
250: ,p_attribute12 in varchar2 default hr_api.g_varchar2
251: ,p_attribute13 in varchar2 default hr_api.g_varchar2
244: ,p_attribute6 in varchar2 default hr_api.g_varchar2
245: ,p_attribute7 in varchar2 default hr_api.g_varchar2
246: ,p_attribute8 in varchar2 default hr_api.g_varchar2
247: ,p_attribute9 in varchar2 default hr_api.g_varchar2
248: ,p_attribute10 in varchar2 default hr_api.g_varchar2
249: ,p_attribute11 in varchar2 default hr_api.g_varchar2
250: ,p_attribute12 in varchar2 default hr_api.g_varchar2
251: ,p_attribute13 in varchar2 default hr_api.g_varchar2
252: ,p_attribute14 in varchar2 default hr_api.g_varchar2
245: ,p_attribute7 in varchar2 default hr_api.g_varchar2
246: ,p_attribute8 in varchar2 default hr_api.g_varchar2
247: ,p_attribute9 in varchar2 default hr_api.g_varchar2
248: ,p_attribute10 in varchar2 default hr_api.g_varchar2
249: ,p_attribute11 in varchar2 default hr_api.g_varchar2
250: ,p_attribute12 in varchar2 default hr_api.g_varchar2
251: ,p_attribute13 in varchar2 default hr_api.g_varchar2
252: ,p_attribute14 in varchar2 default hr_api.g_varchar2
253: ,p_attribute15 in varchar2 default hr_api.g_varchar2
246: ,p_attribute8 in varchar2 default hr_api.g_varchar2
247: ,p_attribute9 in varchar2 default hr_api.g_varchar2
248: ,p_attribute10 in varchar2 default hr_api.g_varchar2
249: ,p_attribute11 in varchar2 default hr_api.g_varchar2
250: ,p_attribute12 in varchar2 default hr_api.g_varchar2
251: ,p_attribute13 in varchar2 default hr_api.g_varchar2
252: ,p_attribute14 in varchar2 default hr_api.g_varchar2
253: ,p_attribute15 in varchar2 default hr_api.g_varchar2
254: ,p_attribute16 in varchar2 default hr_api.g_varchar2
247: ,p_attribute9 in varchar2 default hr_api.g_varchar2
248: ,p_attribute10 in varchar2 default hr_api.g_varchar2
249: ,p_attribute11 in varchar2 default hr_api.g_varchar2
250: ,p_attribute12 in varchar2 default hr_api.g_varchar2
251: ,p_attribute13 in varchar2 default hr_api.g_varchar2
252: ,p_attribute14 in varchar2 default hr_api.g_varchar2
253: ,p_attribute15 in varchar2 default hr_api.g_varchar2
254: ,p_attribute16 in varchar2 default hr_api.g_varchar2
255: ,p_attribute17 in varchar2 default hr_api.g_varchar2
248: ,p_attribute10 in varchar2 default hr_api.g_varchar2
249: ,p_attribute11 in varchar2 default hr_api.g_varchar2
250: ,p_attribute12 in varchar2 default hr_api.g_varchar2
251: ,p_attribute13 in varchar2 default hr_api.g_varchar2
252: ,p_attribute14 in varchar2 default hr_api.g_varchar2
253: ,p_attribute15 in varchar2 default hr_api.g_varchar2
254: ,p_attribute16 in varchar2 default hr_api.g_varchar2
255: ,p_attribute17 in varchar2 default hr_api.g_varchar2
256: ,p_attribute18 in varchar2 default hr_api.g_varchar2
249: ,p_attribute11 in varchar2 default hr_api.g_varchar2
250: ,p_attribute12 in varchar2 default hr_api.g_varchar2
251: ,p_attribute13 in varchar2 default hr_api.g_varchar2
252: ,p_attribute14 in varchar2 default hr_api.g_varchar2
253: ,p_attribute15 in varchar2 default hr_api.g_varchar2
254: ,p_attribute16 in varchar2 default hr_api.g_varchar2
255: ,p_attribute17 in varchar2 default hr_api.g_varchar2
256: ,p_attribute18 in varchar2 default hr_api.g_varchar2
257: ,p_attribute19 in varchar2 default hr_api.g_varchar2
250: ,p_attribute12 in varchar2 default hr_api.g_varchar2
251: ,p_attribute13 in varchar2 default hr_api.g_varchar2
252: ,p_attribute14 in varchar2 default hr_api.g_varchar2
253: ,p_attribute15 in varchar2 default hr_api.g_varchar2
254: ,p_attribute16 in varchar2 default hr_api.g_varchar2
255: ,p_attribute17 in varchar2 default hr_api.g_varchar2
256: ,p_attribute18 in varchar2 default hr_api.g_varchar2
257: ,p_attribute19 in varchar2 default hr_api.g_varchar2
258: ,p_attribute20 in varchar2 default hr_api.g_varchar2
251: ,p_attribute13 in varchar2 default hr_api.g_varchar2
252: ,p_attribute14 in varchar2 default hr_api.g_varchar2
253: ,p_attribute15 in varchar2 default hr_api.g_varchar2
254: ,p_attribute16 in varchar2 default hr_api.g_varchar2
255: ,p_attribute17 in varchar2 default hr_api.g_varchar2
256: ,p_attribute18 in varchar2 default hr_api.g_varchar2
257: ,p_attribute19 in varchar2 default hr_api.g_varchar2
258: ,p_attribute20 in varchar2 default hr_api.g_varchar2
259: ,p_information_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute14 in varchar2 default hr_api.g_varchar2
253: ,p_attribute15 in varchar2 default hr_api.g_varchar2
254: ,p_attribute16 in varchar2 default hr_api.g_varchar2
255: ,p_attribute17 in varchar2 default hr_api.g_varchar2
256: ,p_attribute18 in varchar2 default hr_api.g_varchar2
257: ,p_attribute19 in varchar2 default hr_api.g_varchar2
258: ,p_attribute20 in varchar2 default hr_api.g_varchar2
259: ,p_information_category in varchar2 default hr_api.g_varchar2
260: ,p_nus2000_code in varchar2 default hr_api.g_varchar2
253: ,p_attribute15 in varchar2 default hr_api.g_varchar2
254: ,p_attribute16 in varchar2 default hr_api.g_varchar2
255: ,p_attribute17 in varchar2 default hr_api.g_varchar2
256: ,p_attribute18 in varchar2 default hr_api.g_varchar2
257: ,p_attribute19 in varchar2 default hr_api.g_varchar2
258: ,p_attribute20 in varchar2 default hr_api.g_varchar2
259: ,p_information_category in varchar2 default hr_api.g_varchar2
260: ,p_nus2000_code in varchar2 default hr_api.g_varchar2
261: ,p_qual_framework_id in number default hr_api.g_number
254: ,p_attribute16 in varchar2 default hr_api.g_varchar2
255: ,p_attribute17 in varchar2 default hr_api.g_varchar2
256: ,p_attribute18 in varchar2 default hr_api.g_varchar2
257: ,p_attribute19 in varchar2 default hr_api.g_varchar2
258: ,p_attribute20 in varchar2 default hr_api.g_varchar2
259: ,p_information_category in varchar2 default hr_api.g_varchar2
260: ,p_nus2000_code in varchar2 default hr_api.g_varchar2
261: ,p_qual_framework_id in number default hr_api.g_number
262: ,p_qualification_type in varchar2 default hr_api.g_varchar2
255: ,p_attribute17 in varchar2 default hr_api.g_varchar2
256: ,p_attribute18 in varchar2 default hr_api.g_varchar2
257: ,p_attribute19 in varchar2 default hr_api.g_varchar2
258: ,p_attribute20 in varchar2 default hr_api.g_varchar2
259: ,p_information_category in varchar2 default hr_api.g_varchar2
260: ,p_nus2000_code in varchar2 default hr_api.g_varchar2
261: ,p_qual_framework_id in number default hr_api.g_number
262: ,p_qualification_type in varchar2 default hr_api.g_varchar2
263: ,p_credit_type in varchar2 default hr_api.g_varchar2
256: ,p_attribute18 in varchar2 default hr_api.g_varchar2
257: ,p_attribute19 in varchar2 default hr_api.g_varchar2
258: ,p_attribute20 in varchar2 default hr_api.g_varchar2
259: ,p_information_category in varchar2 default hr_api.g_varchar2
260: ,p_nus2000_code in varchar2 default hr_api.g_varchar2
261: ,p_qual_framework_id in number default hr_api.g_number
262: ,p_qualification_type in varchar2 default hr_api.g_varchar2
263: ,p_credit_type in varchar2 default hr_api.g_varchar2
264: ,p_credits in number default hr_api.g_number
257: ,p_attribute19 in varchar2 default hr_api.g_varchar2
258: ,p_attribute20 in varchar2 default hr_api.g_varchar2
259: ,p_information_category in varchar2 default hr_api.g_varchar2
260: ,p_nus2000_code in varchar2 default hr_api.g_varchar2
261: ,p_qual_framework_id in number default hr_api.g_number
262: ,p_qualification_type in varchar2 default hr_api.g_varchar2
263: ,p_credit_type in varchar2 default hr_api.g_varchar2
264: ,p_credits in number default hr_api.g_number
265: ,p_level_type in varchar2 default hr_api.g_varchar2
258: ,p_attribute20 in varchar2 default hr_api.g_varchar2
259: ,p_information_category in varchar2 default hr_api.g_varchar2
260: ,p_nus2000_code in varchar2 default hr_api.g_varchar2
261: ,p_qual_framework_id in number default hr_api.g_number
262: ,p_qualification_type in varchar2 default hr_api.g_varchar2
263: ,p_credit_type in varchar2 default hr_api.g_varchar2
264: ,p_credits in number default hr_api.g_number
265: ,p_level_type in varchar2 default hr_api.g_varchar2
266: ,p_level_number in number default hr_api.g_number
259: ,p_information_category in varchar2 default hr_api.g_varchar2
260: ,p_nus2000_code in varchar2 default hr_api.g_varchar2
261: ,p_qual_framework_id in number default hr_api.g_number
262: ,p_qualification_type in varchar2 default hr_api.g_varchar2
263: ,p_credit_type in varchar2 default hr_api.g_varchar2
264: ,p_credits in number default hr_api.g_number
265: ,p_level_type in varchar2 default hr_api.g_varchar2
266: ,p_level_number in number default hr_api.g_number
267: ,p_field in varchar2 default hr_api.g_varchar2
260: ,p_nus2000_code in varchar2 default hr_api.g_varchar2
261: ,p_qual_framework_id in number default hr_api.g_number
262: ,p_qualification_type in varchar2 default hr_api.g_varchar2
263: ,p_credit_type in varchar2 default hr_api.g_varchar2
264: ,p_credits in number default hr_api.g_number
265: ,p_level_type in varchar2 default hr_api.g_varchar2
266: ,p_level_number in number default hr_api.g_number
267: ,p_field in varchar2 default hr_api.g_varchar2
268: ,p_sub_field in varchar2 default hr_api.g_varchar2
261: ,p_qual_framework_id in number default hr_api.g_number
262: ,p_qualification_type in varchar2 default hr_api.g_varchar2
263: ,p_credit_type in varchar2 default hr_api.g_varchar2
264: ,p_credits in number default hr_api.g_number
265: ,p_level_type in varchar2 default hr_api.g_varchar2
266: ,p_level_number in number default hr_api.g_number
267: ,p_field in varchar2 default hr_api.g_varchar2
268: ,p_sub_field in varchar2 default hr_api.g_varchar2
269: ,p_provider in varchar2 default hr_api.g_varchar2
262: ,p_qualification_type in varchar2 default hr_api.g_varchar2
263: ,p_credit_type in varchar2 default hr_api.g_varchar2
264: ,p_credits in number default hr_api.g_number
265: ,p_level_type in varchar2 default hr_api.g_varchar2
266: ,p_level_number in number default hr_api.g_number
267: ,p_field in varchar2 default hr_api.g_varchar2
268: ,p_sub_field in varchar2 default hr_api.g_varchar2
269: ,p_provider in varchar2 default hr_api.g_varchar2
270: ,p_qa_organization in varchar2 default hr_api.g_varchar2
263: ,p_credit_type in varchar2 default hr_api.g_varchar2
264: ,p_credits in number default hr_api.g_number
265: ,p_level_type in varchar2 default hr_api.g_varchar2
266: ,p_level_number in number default hr_api.g_number
267: ,p_field in varchar2 default hr_api.g_varchar2
268: ,p_sub_field in varchar2 default hr_api.g_varchar2
269: ,p_provider in varchar2 default hr_api.g_varchar2
270: ,p_qa_organization in varchar2 default hr_api.g_varchar2
271: );
264: ,p_credits in number default hr_api.g_number
265: ,p_level_type in varchar2 default hr_api.g_varchar2
266: ,p_level_number in number default hr_api.g_number
267: ,p_field in varchar2 default hr_api.g_varchar2
268: ,p_sub_field in varchar2 default hr_api.g_varchar2
269: ,p_provider in varchar2 default hr_api.g_varchar2
270: ,p_qa_organization in varchar2 default hr_api.g_varchar2
271: );
272:
265: ,p_level_type in varchar2 default hr_api.g_varchar2
266: ,p_level_number in number default hr_api.g_number
267: ,p_field in varchar2 default hr_api.g_varchar2
268: ,p_sub_field in varchar2 default hr_api.g_varchar2
269: ,p_provider in varchar2 default hr_api.g_varchar2
270: ,p_qa_organization in varchar2 default hr_api.g_varchar2
271: );
272:
273: end hr_no_qualification_type_api;
266: ,p_level_number in number default hr_api.g_number
267: ,p_field in varchar2 default hr_api.g_varchar2
268: ,p_sub_field in varchar2 default hr_api.g_varchar2
269: ,p_provider in varchar2 default hr_api.g_varchar2
270: ,p_qa_organization in varchar2 default hr_api.g_varchar2
271: );
272:
273: end hr_no_qualification_type_api;