119: ,p_available_flag => p_available_flag
120: ,p_effective_date => p_effective_date
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'create_assessment_type',
126: p_hook_type => 'BP'
127: );
120: ,p_effective_date => p_effective_date
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'create_assessment_type',
126: p_hook_type => 'BP'
127: );
128: end;
233: ,p_available_flag => p_available_flag
234: ,p_effective_date => p_effective_date
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'create_assessment_type',
240: p_hook_type => 'AP'
241: );
234: ,p_effective_date => p_effective_date
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'create_assessment_type',
240: p_hook_type => 'AP'
241: );
242: end;
245: --
246: -- When in validation only mode raise the Validate_Enabled exception
247: --
248: if p_validate then
249: raise hr_api.validate_enabled;
250: end if;
251: --
252: -- Set all output arguments
253: --
255: p_object_version_number := l_object_version_number;
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 11);
258: exception
259: when hr_api.validate_enabled then
260: --
261: -- As the Validate_Enabled exception has been raised
262: -- we must rollback to the savepoint
263: --
290: -- ---------------------------------------------------------------------------
291: --
292: procedure update_assessment_type
293: (p_assessment_type_id in number,
294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
291: --
292: procedure update_assessment_type
293: (p_assessment_type_id in number,
294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
292: procedure update_assessment_type
293: (p_assessment_type_id in number,
294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
293: (p_assessment_type_id in number,
294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,
336: p_validate in boolean default false,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,
336: p_validate in boolean default false,
337: p_effective_date in date
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,
336: p_validate in boolean default false,
337: p_effective_date in date
338: ) is
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,
336: p_validate in boolean default false,
337: p_effective_date in date
338: ) is
339: --
399: p_available_flag => p_available_flag,
400: p_effective_date => p_effective_date
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'update_assessment_type',
406: p_hook_type => 'BP'
407: );
400: p_effective_date => p_effective_date
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'update_assessment_type',
406: p_hook_type => 'BP'
407: );
408: end;
514: p_available_flag => p_available_flag,
515: p_effective_date => p_effective_date
516: );
517: exception
518: when hr_api.cannot_find_prog_unit then
519: hr_api.cannot_find_prog_unit_error
520: (p_module_name => 'update_assessment_type',
521: p_hook_type => 'AP'
522: );
515: p_effective_date => p_effective_date
516: );
517: exception
518: when hr_api.cannot_find_prog_unit then
519: hr_api.cannot_find_prog_unit_error
520: (p_module_name => 'update_assessment_type',
521: p_hook_type => 'AP'
522: );
523: end;
526: --
527: -- When in validation only mode raise the Validate_Enabled exception
528: --
529: if p_validate then
530: raise hr_api.validate_enabled;
531: end if;
532: --
533: -- Set all output arguments. l_object_version_number now has the new
534: -- object version number as the update was successful
536: p_object_version_number := l_object_version_number;
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 11);
539: exception
540: when hr_api.validate_enabled then
541: --
542: -- As the Validate_Enabled exception has been raised
543: -- we must rollback to the savepoint
544: --
598: p_assessment_type_id => p_assessment_type_id
599: ,p_object_version_number => p_object_version_number
600: );
601: exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'delete_assessment_type',
605: p_hook_type => 'BP'
606: );
599: ,p_object_version_number => p_object_version_number
600: );
601: exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'delete_assessment_type',
605: p_hook_type => 'BP'
606: );
607: end;
632: p_assessment_type_id => p_assessment_type_id
633: ,p_object_version_number => p_object_version_number
634: );
635: exception
636: when hr_api.cannot_find_prog_unit then
637: hr_api.cannot_find_prog_unit_error
638: (p_module_name => 'delete_assessment_type',
639: p_hook_type => 'AP'
640: );
633: ,p_object_version_number => p_object_version_number
634: );
635: exception
636: when hr_api.cannot_find_prog_unit then
637: hr_api.cannot_find_prog_unit_error
638: (p_module_name => 'delete_assessment_type',
639: p_hook_type => 'AP'
640: );
641: end;
644: --
645: -- When in validation only mode raise the Validate_Enabled exception
646: --
647: if p_validate then
648: raise hr_api.validate_enabled;
649: end if;
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 11);
652: exception
649: end if;
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 11);
652: exception
653: when hr_api.validate_enabled then
654: --
655: -- As the Validate_Enabled exception has been raised
656: -- we must rollback to the savepoint
657: --