DBA Data[Home] [Help]

APPS.HR_ASSESSMENT_TYPES_SWI dependencies on HR_API

Line 55: ,p_validate in number default hr_api.g_false_num

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

Line 85: hr_api.constant_to_boolean

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

Line 196: (p_validate in number default hr_api.g_false_num

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

Line 226: hr_api.constant_to_boolean

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

Line 291: ,p_name in varchar2 default hr_api.g_varchar2

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

Line 292: ,p_description 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

Line 293: ,p_rating_scale_id in number default hr_api.g_number

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

Line 294: ,p_weighting_scale_id in number default hr_api.g_number

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

Line 295: ,p_rating_scale_comment 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

Line 296: ,p_weighting_scale_comment 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
300: ,p_date_to in date default hr_api.g_date

Line 297: ,p_assessment_classification 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
301: ,p_comments in varchar2 default hr_api.g_varchar2

Line 298: ,p_display_assessment_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

Line 299: ,p_date_from in date default hr_api.g_date

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

Line 300: ,p_date_to in date default hr_api.g_date

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

Line 301: ,p_comments 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

Line 302: ,p_instructions 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

Line 303: ,p_weighting_classification 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
307: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 304: ,p_line_score_formula 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

Line 305: ,p_total_score_formula 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

Line 307: ,p_attribute_category 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

Line 308: ,p_attribute1 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

Line 309: ,p_attribute2 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

Line 310: ,p_attribute3 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

Line 311: ,p_attribute4 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

Line 312: ,p_attribute5 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

Line 313: ,p_attribute6 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

Line 314: ,p_attribute7 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

Line 315: ,p_attribute8 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

Line 316: ,p_attribute9 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

Line 317: ,p_attribute10 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

Line 318: ,p_attribute11 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

Line 319: ,p_attribute12 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

Line 320: ,p_attribute13 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

Line 321: ,p_attribute14 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

Line 322: ,p_attribute15 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

Line 323: ,p_attribute16 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

Line 324: ,p_attribute17 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

Line 325: ,p_attribute18 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

Line 326: ,p_attribute19 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
330: ,p_default_job_competencies in varchar2 default hr_api.g_varchar2

Line 327: ,p_attribute20 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

Line 328: ,p_type 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

Line 329: ,p_line_score_formula_id in number default hr_api.g_number

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

Line 330: ,p_default_job_competencies 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
334: ,p_return_status out nocopy varchar2

Line 331: ,p_available_flag 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
335: ) is

Line 332: ,p_validate in number default hr_api.g_false_num

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

Line 363: hr_api.constant_to_boolean

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