51: ,p_type in varchar2
52: ,p_line_score_formula_id in number default null
53: ,p_default_job_competencies in varchar2 default null
54: ,p_available_flag in varchar2 default null
55: ,p_validate in number default hr_api.g_false_num
56: ,p_effective_date in date
57: ,p_return_status out nocopy varchar2
58: ) is
59: --
81: --
82: -- Convert constant values to their corresponding boolean value
83: --
84: l_validate :=
85: hr_api.constant_to_boolean
86: (p_constant_value => p_validate);
87: --
88: -- Register Surrogate ID or user key values
89: --
192: -- ----------------------------------------------------------------------------
193: -- |------------------------< delete_assessment_type >------------------------|
194: -- ----------------------------------------------------------------------------
195: PROCEDURE delete_assessment_type
196: (p_validate in number default hr_api.g_false_num
197: ,p_assessment_type_id in number
198: ,p_object_version_number in number
199: ,p_return_status out nocopy varchar2
200: ) is
222: --
223: -- Convert constant values to their corresponding boolean value
224: --
225: l_validate :=
226: hr_api.constant_to_boolean
227: (p_constant_value => p_validate);
228: --
229: -- Register Surrogate ID or user key values
230: --
287: -- |------------------------< update_assessment_type >------------------------|
288: -- ----------------------------------------------------------------------------
289: PROCEDURE update_assessment_type
290: (p_assessment_type_id in number
291: ,p_name in varchar2 default hr_api.g_varchar2
292: ,p_description in varchar2 default hr_api.g_varchar2
293: ,p_rating_scale_id in number default hr_api.g_number
294: ,p_weighting_scale_id in number default hr_api.g_number
295: ,p_rating_scale_comment in varchar2 default hr_api.g_varchar2
288: -- ----------------------------------------------------------------------------
289: PROCEDURE update_assessment_type
290: (p_assessment_type_id in number
291: ,p_name in varchar2 default hr_api.g_varchar2
292: ,p_description in varchar2 default hr_api.g_varchar2
293: ,p_rating_scale_id in number default hr_api.g_number
294: ,p_weighting_scale_id in number default hr_api.g_number
295: ,p_rating_scale_comment in varchar2 default hr_api.g_varchar2
296: ,p_weighting_scale_comment in varchar2 default hr_api.g_varchar2
289: PROCEDURE update_assessment_type
290: (p_assessment_type_id in number
291: ,p_name in varchar2 default hr_api.g_varchar2
292: ,p_description in varchar2 default hr_api.g_varchar2
293: ,p_rating_scale_id in number default hr_api.g_number
294: ,p_weighting_scale_id in number default hr_api.g_number
295: ,p_rating_scale_comment in varchar2 default hr_api.g_varchar2
296: ,p_weighting_scale_comment in varchar2 default hr_api.g_varchar2
297: ,p_assessment_classification in varchar2 default hr_api.g_varchar2
290: (p_assessment_type_id in number
291: ,p_name in varchar2 default hr_api.g_varchar2
292: ,p_description in varchar2 default hr_api.g_varchar2
293: ,p_rating_scale_id in number default hr_api.g_number
294: ,p_weighting_scale_id in number default hr_api.g_number
295: ,p_rating_scale_comment in varchar2 default hr_api.g_varchar2
296: ,p_weighting_scale_comment in varchar2 default hr_api.g_varchar2
297: ,p_assessment_classification in varchar2 default hr_api.g_varchar2
298: ,p_display_assessment_comments in varchar2 default hr_api.g_varchar2
291: ,p_name in varchar2 default hr_api.g_varchar2
292: ,p_description in varchar2 default hr_api.g_varchar2
293: ,p_rating_scale_id in number default hr_api.g_number
294: ,p_weighting_scale_id in number default hr_api.g_number
295: ,p_rating_scale_comment in varchar2 default hr_api.g_varchar2
296: ,p_weighting_scale_comment in varchar2 default hr_api.g_varchar2
297: ,p_assessment_classification in varchar2 default hr_api.g_varchar2
298: ,p_display_assessment_comments in varchar2 default hr_api.g_varchar2
299: ,p_date_from in date default hr_api.g_date
292: ,p_description in varchar2 default hr_api.g_varchar2
293: ,p_rating_scale_id in number default hr_api.g_number
294: ,p_weighting_scale_id in number default hr_api.g_number
295: ,p_rating_scale_comment in varchar2 default hr_api.g_varchar2
296: ,p_weighting_scale_comment in varchar2 default hr_api.g_varchar2
297: ,p_assessment_classification in varchar2 default hr_api.g_varchar2
298: ,p_display_assessment_comments in varchar2 default hr_api.g_varchar2
299: ,p_date_from in date default hr_api.g_date
300: ,p_date_to in date default hr_api.g_date
293: ,p_rating_scale_id in number default hr_api.g_number
294: ,p_weighting_scale_id in number default hr_api.g_number
295: ,p_rating_scale_comment in varchar2 default hr_api.g_varchar2
296: ,p_weighting_scale_comment in varchar2 default hr_api.g_varchar2
297: ,p_assessment_classification in varchar2 default hr_api.g_varchar2
298: ,p_display_assessment_comments in varchar2 default hr_api.g_varchar2
299: ,p_date_from in date default hr_api.g_date
300: ,p_date_to in date default hr_api.g_date
301: ,p_comments in varchar2 default hr_api.g_varchar2
294: ,p_weighting_scale_id in number default hr_api.g_number
295: ,p_rating_scale_comment in varchar2 default hr_api.g_varchar2
296: ,p_weighting_scale_comment in varchar2 default hr_api.g_varchar2
297: ,p_assessment_classification in varchar2 default hr_api.g_varchar2
298: ,p_display_assessment_comments in varchar2 default hr_api.g_varchar2
299: ,p_date_from in date default hr_api.g_date
300: ,p_date_to in date default hr_api.g_date
301: ,p_comments in varchar2 default hr_api.g_varchar2
302: ,p_instructions in varchar2 default hr_api.g_varchar2
295: ,p_rating_scale_comment in varchar2 default hr_api.g_varchar2
296: ,p_weighting_scale_comment in varchar2 default hr_api.g_varchar2
297: ,p_assessment_classification in varchar2 default hr_api.g_varchar2
298: ,p_display_assessment_comments in varchar2 default hr_api.g_varchar2
299: ,p_date_from in date default hr_api.g_date
300: ,p_date_to in date default hr_api.g_date
301: ,p_comments in varchar2 default hr_api.g_varchar2
302: ,p_instructions in varchar2 default hr_api.g_varchar2
303: ,p_weighting_classification in varchar2 default hr_api.g_varchar2
296: ,p_weighting_scale_comment in varchar2 default hr_api.g_varchar2
297: ,p_assessment_classification in varchar2 default hr_api.g_varchar2
298: ,p_display_assessment_comments in varchar2 default hr_api.g_varchar2
299: ,p_date_from in date default hr_api.g_date
300: ,p_date_to in date default hr_api.g_date
301: ,p_comments in varchar2 default hr_api.g_varchar2
302: ,p_instructions in varchar2 default hr_api.g_varchar2
303: ,p_weighting_classification in varchar2 default hr_api.g_varchar2
304: ,p_line_score_formula in varchar2 default hr_api.g_varchar2
297: ,p_assessment_classification in varchar2 default hr_api.g_varchar2
298: ,p_display_assessment_comments in varchar2 default hr_api.g_varchar2
299: ,p_date_from in date default hr_api.g_date
300: ,p_date_to in date default hr_api.g_date
301: ,p_comments in varchar2 default hr_api.g_varchar2
302: ,p_instructions in varchar2 default hr_api.g_varchar2
303: ,p_weighting_classification in varchar2 default hr_api.g_varchar2
304: ,p_line_score_formula in varchar2 default hr_api.g_varchar2
305: ,p_total_score_formula in varchar2 default hr_api.g_varchar2
298: ,p_display_assessment_comments in varchar2 default hr_api.g_varchar2
299: ,p_date_from in date default hr_api.g_date
300: ,p_date_to in date default hr_api.g_date
301: ,p_comments in varchar2 default hr_api.g_varchar2
302: ,p_instructions in varchar2 default hr_api.g_varchar2
303: ,p_weighting_classification in varchar2 default hr_api.g_varchar2
304: ,p_line_score_formula in varchar2 default hr_api.g_varchar2
305: ,p_total_score_formula in varchar2 default hr_api.g_varchar2
306: ,p_object_version_number in out nocopy number
299: ,p_date_from in date default hr_api.g_date
300: ,p_date_to in date default hr_api.g_date
301: ,p_comments in varchar2 default hr_api.g_varchar2
302: ,p_instructions in varchar2 default hr_api.g_varchar2
303: ,p_weighting_classification in varchar2 default hr_api.g_varchar2
304: ,p_line_score_formula in varchar2 default hr_api.g_varchar2
305: ,p_total_score_formula in varchar2 default hr_api.g_varchar2
306: ,p_object_version_number in out nocopy number
307: ,p_attribute_category in varchar2 default hr_api.g_varchar2
300: ,p_date_to in date default hr_api.g_date
301: ,p_comments in varchar2 default hr_api.g_varchar2
302: ,p_instructions in varchar2 default hr_api.g_varchar2
303: ,p_weighting_classification in varchar2 default hr_api.g_varchar2
304: ,p_line_score_formula in varchar2 default hr_api.g_varchar2
305: ,p_total_score_formula in varchar2 default hr_api.g_varchar2
306: ,p_object_version_number in out nocopy number
307: ,p_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_attribute1 in varchar2 default hr_api.g_varchar2
301: ,p_comments in varchar2 default hr_api.g_varchar2
302: ,p_instructions in varchar2 default hr_api.g_varchar2
303: ,p_weighting_classification in varchar2 default hr_api.g_varchar2
304: ,p_line_score_formula in varchar2 default hr_api.g_varchar2
305: ,p_total_score_formula in varchar2 default hr_api.g_varchar2
306: ,p_object_version_number in out nocopy number
307: ,p_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_attribute2 in varchar2 default hr_api.g_varchar2
303: ,p_weighting_classification in varchar2 default hr_api.g_varchar2
304: ,p_line_score_formula in varchar2 default hr_api.g_varchar2
305: ,p_total_score_formula in varchar2 default hr_api.g_varchar2
306: ,p_object_version_number in out nocopy number
307: ,p_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_attribute4 in varchar2 default hr_api.g_varchar2
304: ,p_line_score_formula in varchar2 default hr_api.g_varchar2
305: ,p_total_score_formula in varchar2 default hr_api.g_varchar2
306: ,p_object_version_number in out nocopy number
307: ,p_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_attribute5 in varchar2 default hr_api.g_varchar2
305: ,p_total_score_formula in varchar2 default hr_api.g_varchar2
306: ,p_object_version_number in out nocopy number
307: ,p_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_attribute6 in varchar2 default hr_api.g_varchar2
306: ,p_object_version_number in out nocopy number
307: ,p_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_attribute7 in varchar2 default hr_api.g_varchar2
307: ,p_attribute_category in varchar2 default hr_api.g_varchar2
308: ,p_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_attribute8 in varchar2 default hr_api.g_varchar2
308: ,p_attribute1 in varchar2 default hr_api.g_varchar2
309: ,p_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_attribute9 in varchar2 default hr_api.g_varchar2
309: ,p_attribute2 in varchar2 default hr_api.g_varchar2
310: ,p_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_attribute10 in varchar2 default hr_api.g_varchar2
310: ,p_attribute3 in varchar2 default hr_api.g_varchar2
311: ,p_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_attribute11 in varchar2 default hr_api.g_varchar2
311: ,p_attribute4 in varchar2 default hr_api.g_varchar2
312: ,p_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_attribute11 in varchar2 default hr_api.g_varchar2
319: ,p_attribute12 in varchar2 default hr_api.g_varchar2
312: ,p_attribute5 in varchar2 default hr_api.g_varchar2
313: ,p_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_attribute11 in varchar2 default hr_api.g_varchar2
319: ,p_attribute12 in varchar2 default hr_api.g_varchar2
320: ,p_attribute13 in varchar2 default hr_api.g_varchar2
313: ,p_attribute6 in varchar2 default hr_api.g_varchar2
314: ,p_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_attribute11 in varchar2 default hr_api.g_varchar2
319: ,p_attribute12 in varchar2 default hr_api.g_varchar2
320: ,p_attribute13 in varchar2 default hr_api.g_varchar2
321: ,p_attribute14 in varchar2 default hr_api.g_varchar2
314: ,p_attribute7 in varchar2 default hr_api.g_varchar2
315: ,p_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_attribute11 in varchar2 default hr_api.g_varchar2
319: ,p_attribute12 in varchar2 default hr_api.g_varchar2
320: ,p_attribute13 in varchar2 default hr_api.g_varchar2
321: ,p_attribute14 in varchar2 default hr_api.g_varchar2
322: ,p_attribute15 in varchar2 default hr_api.g_varchar2
315: ,p_attribute8 in varchar2 default hr_api.g_varchar2
316: ,p_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_attribute11 in varchar2 default hr_api.g_varchar2
319: ,p_attribute12 in varchar2 default hr_api.g_varchar2
320: ,p_attribute13 in varchar2 default hr_api.g_varchar2
321: ,p_attribute14 in varchar2 default hr_api.g_varchar2
322: ,p_attribute15 in varchar2 default hr_api.g_varchar2
323: ,p_attribute16 in varchar2 default hr_api.g_varchar2
316: ,p_attribute9 in varchar2 default hr_api.g_varchar2
317: ,p_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_attribute11 in varchar2 default hr_api.g_varchar2
319: ,p_attribute12 in varchar2 default hr_api.g_varchar2
320: ,p_attribute13 in varchar2 default hr_api.g_varchar2
321: ,p_attribute14 in varchar2 default hr_api.g_varchar2
322: ,p_attribute15 in varchar2 default hr_api.g_varchar2
323: ,p_attribute16 in varchar2 default hr_api.g_varchar2
324: ,p_attribute17 in varchar2 default hr_api.g_varchar2
317: ,p_attribute10 in varchar2 default hr_api.g_varchar2
318: ,p_attribute11 in varchar2 default hr_api.g_varchar2
319: ,p_attribute12 in varchar2 default hr_api.g_varchar2
320: ,p_attribute13 in varchar2 default hr_api.g_varchar2
321: ,p_attribute14 in varchar2 default hr_api.g_varchar2
322: ,p_attribute15 in varchar2 default hr_api.g_varchar2
323: ,p_attribute16 in varchar2 default hr_api.g_varchar2
324: ,p_attribute17 in varchar2 default hr_api.g_varchar2
325: ,p_attribute18 in varchar2 default hr_api.g_varchar2
318: ,p_attribute11 in varchar2 default hr_api.g_varchar2
319: ,p_attribute12 in varchar2 default hr_api.g_varchar2
320: ,p_attribute13 in varchar2 default hr_api.g_varchar2
321: ,p_attribute14 in varchar2 default hr_api.g_varchar2
322: ,p_attribute15 in varchar2 default hr_api.g_varchar2
323: ,p_attribute16 in varchar2 default hr_api.g_varchar2
324: ,p_attribute17 in varchar2 default hr_api.g_varchar2
325: ,p_attribute18 in varchar2 default hr_api.g_varchar2
326: ,p_attribute19 in varchar2 default hr_api.g_varchar2
319: ,p_attribute12 in varchar2 default hr_api.g_varchar2
320: ,p_attribute13 in varchar2 default hr_api.g_varchar2
321: ,p_attribute14 in varchar2 default hr_api.g_varchar2
322: ,p_attribute15 in varchar2 default hr_api.g_varchar2
323: ,p_attribute16 in varchar2 default hr_api.g_varchar2
324: ,p_attribute17 in varchar2 default hr_api.g_varchar2
325: ,p_attribute18 in varchar2 default hr_api.g_varchar2
326: ,p_attribute19 in varchar2 default hr_api.g_varchar2
327: ,p_attribute20 in varchar2 default hr_api.g_varchar2
320: ,p_attribute13 in varchar2 default hr_api.g_varchar2
321: ,p_attribute14 in varchar2 default hr_api.g_varchar2
322: ,p_attribute15 in varchar2 default hr_api.g_varchar2
323: ,p_attribute16 in varchar2 default hr_api.g_varchar2
324: ,p_attribute17 in varchar2 default hr_api.g_varchar2
325: ,p_attribute18 in varchar2 default hr_api.g_varchar2
326: ,p_attribute19 in varchar2 default hr_api.g_varchar2
327: ,p_attribute20 in varchar2 default hr_api.g_varchar2
328: ,p_type in varchar2 default hr_api.g_varchar2
321: ,p_attribute14 in varchar2 default hr_api.g_varchar2
322: ,p_attribute15 in varchar2 default hr_api.g_varchar2
323: ,p_attribute16 in varchar2 default hr_api.g_varchar2
324: ,p_attribute17 in varchar2 default hr_api.g_varchar2
325: ,p_attribute18 in varchar2 default hr_api.g_varchar2
326: ,p_attribute19 in varchar2 default hr_api.g_varchar2
327: ,p_attribute20 in varchar2 default hr_api.g_varchar2
328: ,p_type in varchar2 default hr_api.g_varchar2
329: ,p_line_score_formula_id in number default hr_api.g_number
322: ,p_attribute15 in varchar2 default hr_api.g_varchar2
323: ,p_attribute16 in varchar2 default hr_api.g_varchar2
324: ,p_attribute17 in varchar2 default hr_api.g_varchar2
325: ,p_attribute18 in varchar2 default hr_api.g_varchar2
326: ,p_attribute19 in varchar2 default hr_api.g_varchar2
327: ,p_attribute20 in varchar2 default hr_api.g_varchar2
328: ,p_type in varchar2 default hr_api.g_varchar2
329: ,p_line_score_formula_id in number default hr_api.g_number
330: ,p_default_job_competencies in varchar2 default hr_api.g_varchar2
323: ,p_attribute16 in varchar2 default hr_api.g_varchar2
324: ,p_attribute17 in varchar2 default hr_api.g_varchar2
325: ,p_attribute18 in varchar2 default hr_api.g_varchar2
326: ,p_attribute19 in varchar2 default hr_api.g_varchar2
327: ,p_attribute20 in varchar2 default hr_api.g_varchar2
328: ,p_type in varchar2 default hr_api.g_varchar2
329: ,p_line_score_formula_id in number default hr_api.g_number
330: ,p_default_job_competencies in varchar2 default hr_api.g_varchar2
331: ,p_available_flag in varchar2 default hr_api.g_varchar2
324: ,p_attribute17 in varchar2 default hr_api.g_varchar2
325: ,p_attribute18 in varchar2 default hr_api.g_varchar2
326: ,p_attribute19 in varchar2 default hr_api.g_varchar2
327: ,p_attribute20 in varchar2 default hr_api.g_varchar2
328: ,p_type in varchar2 default hr_api.g_varchar2
329: ,p_line_score_formula_id in number default hr_api.g_number
330: ,p_default_job_competencies in varchar2 default hr_api.g_varchar2
331: ,p_available_flag in varchar2 default hr_api.g_varchar2
332: ,p_validate in number default hr_api.g_false_num
325: ,p_attribute18 in varchar2 default hr_api.g_varchar2
326: ,p_attribute19 in varchar2 default hr_api.g_varchar2
327: ,p_attribute20 in varchar2 default hr_api.g_varchar2
328: ,p_type in varchar2 default hr_api.g_varchar2
329: ,p_line_score_formula_id in number default hr_api.g_number
330: ,p_default_job_competencies in varchar2 default hr_api.g_varchar2
331: ,p_available_flag in varchar2 default hr_api.g_varchar2
332: ,p_validate in number default hr_api.g_false_num
333: ,p_effective_date in date
326: ,p_attribute19 in varchar2 default hr_api.g_varchar2
327: ,p_attribute20 in varchar2 default hr_api.g_varchar2
328: ,p_type in varchar2 default hr_api.g_varchar2
329: ,p_line_score_formula_id in number default hr_api.g_number
330: ,p_default_job_competencies in varchar2 default hr_api.g_varchar2
331: ,p_available_flag in varchar2 default hr_api.g_varchar2
332: ,p_validate in number default hr_api.g_false_num
333: ,p_effective_date in date
334: ,p_return_status out nocopy varchar2
327: ,p_attribute20 in varchar2 default hr_api.g_varchar2
328: ,p_type in varchar2 default hr_api.g_varchar2
329: ,p_line_score_formula_id in number default hr_api.g_number
330: ,p_default_job_competencies in varchar2 default hr_api.g_varchar2
331: ,p_available_flag in varchar2 default hr_api.g_varchar2
332: ,p_validate in number default hr_api.g_false_num
333: ,p_effective_date in date
334: ,p_return_status out nocopy varchar2
335: ) is
328: ,p_type in varchar2 default hr_api.g_varchar2
329: ,p_line_score_formula_id in number default hr_api.g_number
330: ,p_default_job_competencies in varchar2 default hr_api.g_varchar2
331: ,p_available_flag in varchar2 default hr_api.g_varchar2
332: ,p_validate in number default hr_api.g_false_num
333: ,p_effective_date in date
334: ,p_return_status out nocopy varchar2
335: ) is
336: --
359: --
360: -- Convert constant values to their corresponding boolean value
361: --
362: l_validate :=
363: hr_api.constant_to_boolean
364: (p_constant_value => p_validate);
365: --
366: -- Register Surrogate ID or user key values
367: --