261: -- {End Of Comments}
262: --
263: procedure update_assessment_type
264: (p_assessment_type_id in number,
265: p_name in varchar2 default hr_api.g_varchar2,
266: p_description in varchar2 default hr_api.g_varchar2,
267: p_rating_scale_id in number default hr_api.g_number,
268: p_weighting_scale_id in number default hr_api.g_number,
269: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
262: --
263: procedure update_assessment_type
264: (p_assessment_type_id in number,
265: p_name in varchar2 default hr_api.g_varchar2,
266: p_description in varchar2 default hr_api.g_varchar2,
267: p_rating_scale_id in number default hr_api.g_number,
268: p_weighting_scale_id in number default hr_api.g_number,
269: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
270: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
263: procedure update_assessment_type
264: (p_assessment_type_id in number,
265: p_name in varchar2 default hr_api.g_varchar2,
266: p_description in varchar2 default hr_api.g_varchar2,
267: p_rating_scale_id in number default hr_api.g_number,
268: p_weighting_scale_id in number default hr_api.g_number,
269: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
270: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
271: p_assessment_classification in varchar2 default hr_api.g_varchar2,
264: (p_assessment_type_id in number,
265: p_name in varchar2 default hr_api.g_varchar2,
266: p_description in varchar2 default hr_api.g_varchar2,
267: p_rating_scale_id in number default hr_api.g_number,
268: p_weighting_scale_id in number default hr_api.g_number,
269: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
270: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
271: p_assessment_classification in varchar2 default hr_api.g_varchar2,
272: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
265: p_name in varchar2 default hr_api.g_varchar2,
266: p_description in varchar2 default hr_api.g_varchar2,
267: p_rating_scale_id in number default hr_api.g_number,
268: p_weighting_scale_id in number default hr_api.g_number,
269: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
270: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
271: p_assessment_classification in varchar2 default hr_api.g_varchar2,
272: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
273: p_date_from in date default hr_api.g_date,
266: p_description in varchar2 default hr_api.g_varchar2,
267: p_rating_scale_id in number default hr_api.g_number,
268: p_weighting_scale_id in number default hr_api.g_number,
269: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
270: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
271: p_assessment_classification in varchar2 default hr_api.g_varchar2,
272: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
273: p_date_from in date default hr_api.g_date,
274: p_date_to in date default hr_api.g_date,
267: p_rating_scale_id in number default hr_api.g_number,
268: p_weighting_scale_id in number default hr_api.g_number,
269: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
270: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
271: p_assessment_classification in varchar2 default hr_api.g_varchar2,
272: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
273: p_date_from in date default hr_api.g_date,
274: p_date_to in date default hr_api.g_date,
275: p_comments in varchar2 default hr_api.g_varchar2,
268: p_weighting_scale_id in number default hr_api.g_number,
269: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
270: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
271: p_assessment_classification in varchar2 default hr_api.g_varchar2,
272: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
273: p_date_from in date default hr_api.g_date,
274: p_date_to in date default hr_api.g_date,
275: p_comments in varchar2 default hr_api.g_varchar2,
276: p_instructions in varchar2 default hr_api.g_varchar2,
269: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
270: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
271: p_assessment_classification in varchar2 default hr_api.g_varchar2,
272: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
273: p_date_from in date default hr_api.g_date,
274: p_date_to in date default hr_api.g_date,
275: p_comments in varchar2 default hr_api.g_varchar2,
276: p_instructions in varchar2 default hr_api.g_varchar2,
277: p_weighting_classification in varchar2 default hr_api.g_varchar2,
270: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
271: p_assessment_classification in varchar2 default hr_api.g_varchar2,
272: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
273: p_date_from in date default hr_api.g_date,
274: p_date_to in date default hr_api.g_date,
275: p_comments in varchar2 default hr_api.g_varchar2,
276: p_instructions in varchar2 default hr_api.g_varchar2,
277: p_weighting_classification in varchar2 default hr_api.g_varchar2,
278: p_line_score_formula in varchar2 default hr_api.g_varchar2,
271: p_assessment_classification in varchar2 default hr_api.g_varchar2,
272: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
273: p_date_from in date default hr_api.g_date,
274: p_date_to in date default hr_api.g_date,
275: p_comments in varchar2 default hr_api.g_varchar2,
276: p_instructions in varchar2 default hr_api.g_varchar2,
277: p_weighting_classification in varchar2 default hr_api.g_varchar2,
278: p_line_score_formula in varchar2 default hr_api.g_varchar2,
279: p_total_score_formula in varchar2 default hr_api.g_varchar2,
272: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
273: p_date_from in date default hr_api.g_date,
274: p_date_to in date default hr_api.g_date,
275: p_comments in varchar2 default hr_api.g_varchar2,
276: p_instructions in varchar2 default hr_api.g_varchar2,
277: p_weighting_classification in varchar2 default hr_api.g_varchar2,
278: p_line_score_formula in varchar2 default hr_api.g_varchar2,
279: p_total_score_formula in varchar2 default hr_api.g_varchar2,
280: p_object_version_number in out nocopy number,
273: p_date_from in date default hr_api.g_date,
274: p_date_to in date default hr_api.g_date,
275: p_comments in varchar2 default hr_api.g_varchar2,
276: p_instructions in varchar2 default hr_api.g_varchar2,
277: p_weighting_classification in varchar2 default hr_api.g_varchar2,
278: p_line_score_formula in varchar2 default hr_api.g_varchar2,
279: p_total_score_formula in varchar2 default hr_api.g_varchar2,
280: p_object_version_number in out nocopy number,
281: --
274: p_date_to in date default hr_api.g_date,
275: p_comments in varchar2 default hr_api.g_varchar2,
276: p_instructions in varchar2 default hr_api.g_varchar2,
277: p_weighting_classification in varchar2 default hr_api.g_varchar2,
278: p_line_score_formula in varchar2 default hr_api.g_varchar2,
279: p_total_score_formula in varchar2 default hr_api.g_varchar2,
280: p_object_version_number in out nocopy number,
281: --
282: p_attribute_category in varchar2 default hr_api.g_varchar2,
275: p_comments in varchar2 default hr_api.g_varchar2,
276: p_instructions in varchar2 default hr_api.g_varchar2,
277: p_weighting_classification in varchar2 default hr_api.g_varchar2,
278: p_line_score_formula in varchar2 default hr_api.g_varchar2,
279: p_total_score_formula in varchar2 default hr_api.g_varchar2,
280: p_object_version_number in out nocopy number,
281: --
282: p_attribute_category in varchar2 default hr_api.g_varchar2,
283: p_attribute1 in varchar2 default hr_api.g_varchar2,
278: p_line_score_formula in varchar2 default hr_api.g_varchar2,
279: p_total_score_formula in varchar2 default hr_api.g_varchar2,
280: p_object_version_number in out nocopy number,
281: --
282: p_attribute_category in varchar2 default hr_api.g_varchar2,
283: p_attribute1 in varchar2 default hr_api.g_varchar2,
284: p_attribute2 in varchar2 default hr_api.g_varchar2,
285: p_attribute3 in varchar2 default hr_api.g_varchar2,
286: p_attribute4 in varchar2 default hr_api.g_varchar2,
279: p_total_score_formula in varchar2 default hr_api.g_varchar2,
280: p_object_version_number in out nocopy number,
281: --
282: p_attribute_category in varchar2 default hr_api.g_varchar2,
283: p_attribute1 in varchar2 default hr_api.g_varchar2,
284: p_attribute2 in varchar2 default hr_api.g_varchar2,
285: p_attribute3 in varchar2 default hr_api.g_varchar2,
286: p_attribute4 in varchar2 default hr_api.g_varchar2,
287: p_attribute5 in varchar2 default hr_api.g_varchar2,
280: p_object_version_number in out nocopy number,
281: --
282: p_attribute_category in varchar2 default hr_api.g_varchar2,
283: p_attribute1 in varchar2 default hr_api.g_varchar2,
284: p_attribute2 in varchar2 default hr_api.g_varchar2,
285: p_attribute3 in varchar2 default hr_api.g_varchar2,
286: p_attribute4 in varchar2 default hr_api.g_varchar2,
287: p_attribute5 in varchar2 default hr_api.g_varchar2,
288: p_attribute6 in varchar2 default hr_api.g_varchar2,
281: --
282: p_attribute_category in varchar2 default hr_api.g_varchar2,
283: p_attribute1 in varchar2 default hr_api.g_varchar2,
284: p_attribute2 in varchar2 default hr_api.g_varchar2,
285: p_attribute3 in varchar2 default hr_api.g_varchar2,
286: p_attribute4 in varchar2 default hr_api.g_varchar2,
287: p_attribute5 in varchar2 default hr_api.g_varchar2,
288: p_attribute6 in varchar2 default hr_api.g_varchar2,
289: p_attribute7 in varchar2 default hr_api.g_varchar2,
282: p_attribute_category in varchar2 default hr_api.g_varchar2,
283: p_attribute1 in varchar2 default hr_api.g_varchar2,
284: p_attribute2 in varchar2 default hr_api.g_varchar2,
285: p_attribute3 in varchar2 default hr_api.g_varchar2,
286: p_attribute4 in varchar2 default hr_api.g_varchar2,
287: p_attribute5 in varchar2 default hr_api.g_varchar2,
288: p_attribute6 in varchar2 default hr_api.g_varchar2,
289: p_attribute7 in varchar2 default hr_api.g_varchar2,
290: p_attribute8 in varchar2 default hr_api.g_varchar2,
283: p_attribute1 in varchar2 default hr_api.g_varchar2,
284: p_attribute2 in varchar2 default hr_api.g_varchar2,
285: p_attribute3 in varchar2 default hr_api.g_varchar2,
286: p_attribute4 in varchar2 default hr_api.g_varchar2,
287: p_attribute5 in varchar2 default hr_api.g_varchar2,
288: p_attribute6 in varchar2 default hr_api.g_varchar2,
289: p_attribute7 in varchar2 default hr_api.g_varchar2,
290: p_attribute8 in varchar2 default hr_api.g_varchar2,
291: p_attribute9 in varchar2 default hr_api.g_varchar2,
284: p_attribute2 in varchar2 default hr_api.g_varchar2,
285: p_attribute3 in varchar2 default hr_api.g_varchar2,
286: p_attribute4 in varchar2 default hr_api.g_varchar2,
287: p_attribute5 in varchar2 default hr_api.g_varchar2,
288: p_attribute6 in varchar2 default hr_api.g_varchar2,
289: p_attribute7 in varchar2 default hr_api.g_varchar2,
290: p_attribute8 in varchar2 default hr_api.g_varchar2,
291: p_attribute9 in varchar2 default hr_api.g_varchar2,
292: p_attribute10 in varchar2 default hr_api.g_varchar2,
285: p_attribute3 in varchar2 default hr_api.g_varchar2,
286: p_attribute4 in varchar2 default hr_api.g_varchar2,
287: p_attribute5 in varchar2 default hr_api.g_varchar2,
288: p_attribute6 in varchar2 default hr_api.g_varchar2,
289: p_attribute7 in varchar2 default hr_api.g_varchar2,
290: p_attribute8 in varchar2 default hr_api.g_varchar2,
291: p_attribute9 in varchar2 default hr_api.g_varchar2,
292: p_attribute10 in varchar2 default hr_api.g_varchar2,
293: p_attribute11 in varchar2 default hr_api.g_varchar2,
286: p_attribute4 in varchar2 default hr_api.g_varchar2,
287: p_attribute5 in varchar2 default hr_api.g_varchar2,
288: p_attribute6 in varchar2 default hr_api.g_varchar2,
289: p_attribute7 in varchar2 default hr_api.g_varchar2,
290: p_attribute8 in varchar2 default hr_api.g_varchar2,
291: p_attribute9 in varchar2 default hr_api.g_varchar2,
292: p_attribute10 in varchar2 default hr_api.g_varchar2,
293: p_attribute11 in varchar2 default hr_api.g_varchar2,
294: p_attribute12 in varchar2 default hr_api.g_varchar2,
287: p_attribute5 in varchar2 default hr_api.g_varchar2,
288: p_attribute6 in varchar2 default hr_api.g_varchar2,
289: p_attribute7 in varchar2 default hr_api.g_varchar2,
290: p_attribute8 in varchar2 default hr_api.g_varchar2,
291: p_attribute9 in varchar2 default hr_api.g_varchar2,
292: p_attribute10 in varchar2 default hr_api.g_varchar2,
293: p_attribute11 in varchar2 default hr_api.g_varchar2,
294: p_attribute12 in varchar2 default hr_api.g_varchar2,
295: p_attribute13 in varchar2 default hr_api.g_varchar2,
288: p_attribute6 in varchar2 default hr_api.g_varchar2,
289: p_attribute7 in varchar2 default hr_api.g_varchar2,
290: p_attribute8 in varchar2 default hr_api.g_varchar2,
291: p_attribute9 in varchar2 default hr_api.g_varchar2,
292: p_attribute10 in varchar2 default hr_api.g_varchar2,
293: p_attribute11 in varchar2 default hr_api.g_varchar2,
294: p_attribute12 in varchar2 default hr_api.g_varchar2,
295: p_attribute13 in varchar2 default hr_api.g_varchar2,
296: p_attribute14 in varchar2 default hr_api.g_varchar2,
289: p_attribute7 in varchar2 default hr_api.g_varchar2,
290: p_attribute8 in varchar2 default hr_api.g_varchar2,
291: p_attribute9 in varchar2 default hr_api.g_varchar2,
292: p_attribute10 in varchar2 default hr_api.g_varchar2,
293: p_attribute11 in varchar2 default hr_api.g_varchar2,
294: p_attribute12 in varchar2 default hr_api.g_varchar2,
295: p_attribute13 in varchar2 default hr_api.g_varchar2,
296: p_attribute14 in varchar2 default hr_api.g_varchar2,
297: p_attribute15 in varchar2 default hr_api.g_varchar2,
290: p_attribute8 in varchar2 default hr_api.g_varchar2,
291: p_attribute9 in varchar2 default hr_api.g_varchar2,
292: p_attribute10 in varchar2 default hr_api.g_varchar2,
293: p_attribute11 in varchar2 default hr_api.g_varchar2,
294: p_attribute12 in varchar2 default hr_api.g_varchar2,
295: p_attribute13 in varchar2 default hr_api.g_varchar2,
296: p_attribute14 in varchar2 default hr_api.g_varchar2,
297: p_attribute15 in varchar2 default hr_api.g_varchar2,
298: p_attribute16 in varchar2 default hr_api.g_varchar2,
291: p_attribute9 in varchar2 default hr_api.g_varchar2,
292: p_attribute10 in varchar2 default hr_api.g_varchar2,
293: p_attribute11 in varchar2 default hr_api.g_varchar2,
294: p_attribute12 in varchar2 default hr_api.g_varchar2,
295: p_attribute13 in varchar2 default hr_api.g_varchar2,
296: p_attribute14 in varchar2 default hr_api.g_varchar2,
297: p_attribute15 in varchar2 default hr_api.g_varchar2,
298: p_attribute16 in varchar2 default hr_api.g_varchar2,
299: p_attribute17 in varchar2 default hr_api.g_varchar2,
292: p_attribute10 in varchar2 default hr_api.g_varchar2,
293: p_attribute11 in varchar2 default hr_api.g_varchar2,
294: p_attribute12 in varchar2 default hr_api.g_varchar2,
295: p_attribute13 in varchar2 default hr_api.g_varchar2,
296: p_attribute14 in varchar2 default hr_api.g_varchar2,
297: p_attribute15 in varchar2 default hr_api.g_varchar2,
298: p_attribute16 in varchar2 default hr_api.g_varchar2,
299: p_attribute17 in varchar2 default hr_api.g_varchar2,
300: p_attribute18 in varchar2 default hr_api.g_varchar2,
293: p_attribute11 in varchar2 default hr_api.g_varchar2,
294: p_attribute12 in varchar2 default hr_api.g_varchar2,
295: p_attribute13 in varchar2 default hr_api.g_varchar2,
296: p_attribute14 in varchar2 default hr_api.g_varchar2,
297: p_attribute15 in varchar2 default hr_api.g_varchar2,
298: p_attribute16 in varchar2 default hr_api.g_varchar2,
299: p_attribute17 in varchar2 default hr_api.g_varchar2,
300: p_attribute18 in varchar2 default hr_api.g_varchar2,
301: p_attribute19 in varchar2 default hr_api.g_varchar2,
294: p_attribute12 in varchar2 default hr_api.g_varchar2,
295: p_attribute13 in varchar2 default hr_api.g_varchar2,
296: p_attribute14 in varchar2 default hr_api.g_varchar2,
297: p_attribute15 in varchar2 default hr_api.g_varchar2,
298: p_attribute16 in varchar2 default hr_api.g_varchar2,
299: p_attribute17 in varchar2 default hr_api.g_varchar2,
300: p_attribute18 in varchar2 default hr_api.g_varchar2,
301: p_attribute19 in varchar2 default hr_api.g_varchar2,
302: p_attribute20 in varchar2 default hr_api.g_varchar2,
295: p_attribute13 in varchar2 default hr_api.g_varchar2,
296: p_attribute14 in varchar2 default hr_api.g_varchar2,
297: p_attribute15 in varchar2 default hr_api.g_varchar2,
298: p_attribute16 in varchar2 default hr_api.g_varchar2,
299: p_attribute17 in varchar2 default hr_api.g_varchar2,
300: p_attribute18 in varchar2 default hr_api.g_varchar2,
301: p_attribute19 in varchar2 default hr_api.g_varchar2,
302: p_attribute20 in varchar2 default hr_api.g_varchar2,
303: p_type in varchar2 default hr_api.g_varchar2,
296: p_attribute14 in varchar2 default hr_api.g_varchar2,
297: p_attribute15 in varchar2 default hr_api.g_varchar2,
298: p_attribute16 in varchar2 default hr_api.g_varchar2,
299: p_attribute17 in varchar2 default hr_api.g_varchar2,
300: p_attribute18 in varchar2 default hr_api.g_varchar2,
301: p_attribute19 in varchar2 default hr_api.g_varchar2,
302: p_attribute20 in varchar2 default hr_api.g_varchar2,
303: p_type in varchar2 default hr_api.g_varchar2,
304: p_line_score_formula_id in number default hr_api.g_number,
297: p_attribute15 in varchar2 default hr_api.g_varchar2,
298: p_attribute16 in varchar2 default hr_api.g_varchar2,
299: p_attribute17 in varchar2 default hr_api.g_varchar2,
300: p_attribute18 in varchar2 default hr_api.g_varchar2,
301: p_attribute19 in varchar2 default hr_api.g_varchar2,
302: p_attribute20 in varchar2 default hr_api.g_varchar2,
303: p_type in varchar2 default hr_api.g_varchar2,
304: p_line_score_formula_id in number default hr_api.g_number,
305: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
298: p_attribute16 in varchar2 default hr_api.g_varchar2,
299: p_attribute17 in varchar2 default hr_api.g_varchar2,
300: p_attribute18 in varchar2 default hr_api.g_varchar2,
301: p_attribute19 in varchar2 default hr_api.g_varchar2,
302: p_attribute20 in varchar2 default hr_api.g_varchar2,
303: p_type in varchar2 default hr_api.g_varchar2,
304: p_line_score_formula_id in number default hr_api.g_number,
305: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
306: p_available_flag in varchar2 default hr_api.g_varchar2,
299: p_attribute17 in varchar2 default hr_api.g_varchar2,
300: p_attribute18 in varchar2 default hr_api.g_varchar2,
301: p_attribute19 in varchar2 default hr_api.g_varchar2,
302: p_attribute20 in varchar2 default hr_api.g_varchar2,
303: p_type in varchar2 default hr_api.g_varchar2,
304: p_line_score_formula_id in number default hr_api.g_number,
305: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
306: p_available_flag in varchar2 default hr_api.g_varchar2,
307: p_validate in boolean default false,
300: p_attribute18 in varchar2 default hr_api.g_varchar2,
301: p_attribute19 in varchar2 default hr_api.g_varchar2,
302: p_attribute20 in varchar2 default hr_api.g_varchar2,
303: p_type in varchar2 default hr_api.g_varchar2,
304: p_line_score_formula_id in number default hr_api.g_number,
305: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
306: p_available_flag in varchar2 default hr_api.g_varchar2,
307: p_validate in boolean default false,
308: p_effective_date in date
301: p_attribute19 in varchar2 default hr_api.g_varchar2,
302: p_attribute20 in varchar2 default hr_api.g_varchar2,
303: p_type in varchar2 default hr_api.g_varchar2,
304: p_line_score_formula_id in number default hr_api.g_number,
305: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
306: p_available_flag in varchar2 default hr_api.g_varchar2,
307: p_validate in boolean default false,
308: p_effective_date in date
309: );
302: p_attribute20 in varchar2 default hr_api.g_varchar2,
303: p_type in varchar2 default hr_api.g_varchar2,
304: p_line_score_formula_id in number default hr_api.g_number,
305: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
306: p_available_flag in varchar2 default hr_api.g_varchar2,
307: p_validate in boolean default false,
308: p_effective_date in date
309: );
310: --