89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: --
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: per_rtl_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: per_rtl_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: per_rtl_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: per_rtl_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: per_rtl_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: per_rtl_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: per_rtl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: per_rtl_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: per_rtl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: per_rtl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: Raise;
107: End update_dml;
108: --
249: p_attribute19_o => per_rtl_shd.g_old_rec.attribute19 ,
250: p_attribute20_o => per_rtl_shd.g_old_rec.attribute20 );
251:
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: ( p_module_name => 'PER_RATING_LEVELS'
256: ,p_hook_type => 'AU'
257: );
250: p_attribute20_o => per_rtl_shd.g_old_rec.attribute20 );
251:
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: ( p_module_name => 'PER_RATING_LEVELS'
256: ,p_hook_type => 'AU'
257: );
258: end;
317: -- p_rec plsql record structure
318: -- to see if a system default is being used. If a system default
319: -- is being used then we must set to the 'current' argument value.
320: --
321: If (p_rec.business_group_id = hr_api.g_number) then
322: p_rec.business_group_id :=
323: per_rtl_shd.g_old_rec.business_group_id;
324: End If;
325: If (p_rec.step_value = hr_api.g_number) then
321: If (p_rec.business_group_id = hr_api.g_number) then
322: p_rec.business_group_id :=
323: per_rtl_shd.g_old_rec.business_group_id;
324: End If;
325: If (p_rec.step_value = hr_api.g_number) then
326: p_rec.step_value :=
327: per_rtl_shd.g_old_rec.step_value;
328: End If;
329: If (p_rec.rating_scale_id = hr_api.g_number) then
325: If (p_rec.step_value = hr_api.g_number) then
326: p_rec.step_value :=
327: per_rtl_shd.g_old_rec.step_value;
328: End If;
329: If (p_rec.rating_scale_id = hr_api.g_number) then
330: p_rec.rating_scale_id :=
331: per_rtl_shd.g_old_rec.rating_scale_id;
332: End If;
333: If (p_rec.name = hr_api.g_varchar2) then
329: If (p_rec.rating_scale_id = hr_api.g_number) then
330: p_rec.rating_scale_id :=
331: per_rtl_shd.g_old_rec.rating_scale_id;
332: End If;
333: If (p_rec.name = hr_api.g_varchar2) then
334: p_rec.name :=
335: per_rtl_shd.g_old_rec.name;
336: End If;
337: If (p_rec.competence_id = hr_api.g_number) then
333: If (p_rec.name = hr_api.g_varchar2) then
334: p_rec.name :=
335: per_rtl_shd.g_old_rec.name;
336: End If;
337: If (p_rec.competence_id = hr_api.g_number) then
338: p_rec.competence_id :=
339: per_rtl_shd.g_old_rec.competence_id;
340: End If;
341: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
337: If (p_rec.competence_id = hr_api.g_number) then
338: p_rec.competence_id :=
339: per_rtl_shd.g_old_rec.competence_id;
340: End If;
341: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
342: p_rec.behavioural_indicator :=
343: per_rtl_shd.g_old_rec.behavioural_indicator;
344: End If;
345: If (p_rec.attribute_category = hr_api.g_varchar2) then
341: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
342: p_rec.behavioural_indicator :=
343: per_rtl_shd.g_old_rec.behavioural_indicator;
344: End If;
345: If (p_rec.attribute_category = hr_api.g_varchar2) then
346: p_rec.attribute_category :=
347: per_rtl_shd.g_old_rec.attribute_category;
348: End If;
349: If (p_rec.attribute1 = hr_api.g_varchar2) then
345: If (p_rec.attribute_category = hr_api.g_varchar2) then
346: p_rec.attribute_category :=
347: per_rtl_shd.g_old_rec.attribute_category;
348: End If;
349: If (p_rec.attribute1 = hr_api.g_varchar2) then
350: p_rec.attribute1 :=
351: per_rtl_shd.g_old_rec.attribute1;
352: End If;
353: If (p_rec.attribute2 = hr_api.g_varchar2) then
349: If (p_rec.attribute1 = hr_api.g_varchar2) then
350: p_rec.attribute1 :=
351: per_rtl_shd.g_old_rec.attribute1;
352: End If;
353: If (p_rec.attribute2 = hr_api.g_varchar2) then
354: p_rec.attribute2 :=
355: per_rtl_shd.g_old_rec.attribute2;
356: End If;
357: If (p_rec.attribute3 = hr_api.g_varchar2) then
353: If (p_rec.attribute2 = hr_api.g_varchar2) then
354: p_rec.attribute2 :=
355: per_rtl_shd.g_old_rec.attribute2;
356: End If;
357: If (p_rec.attribute3 = hr_api.g_varchar2) then
358: p_rec.attribute3 :=
359: per_rtl_shd.g_old_rec.attribute3;
360: End If;
361: If (p_rec.attribute4 = hr_api.g_varchar2) then
357: If (p_rec.attribute3 = hr_api.g_varchar2) then
358: p_rec.attribute3 :=
359: per_rtl_shd.g_old_rec.attribute3;
360: End If;
361: If (p_rec.attribute4 = hr_api.g_varchar2) then
362: p_rec.attribute4 :=
363: per_rtl_shd.g_old_rec.attribute4;
364: End If;
365: If (p_rec.attribute5 = hr_api.g_varchar2) then
361: If (p_rec.attribute4 = hr_api.g_varchar2) then
362: p_rec.attribute4 :=
363: per_rtl_shd.g_old_rec.attribute4;
364: End If;
365: If (p_rec.attribute5 = hr_api.g_varchar2) then
366: p_rec.attribute5 :=
367: per_rtl_shd.g_old_rec.attribute5;
368: End If;
369: If (p_rec.attribute6 = hr_api.g_varchar2) then
365: If (p_rec.attribute5 = hr_api.g_varchar2) then
366: p_rec.attribute5 :=
367: per_rtl_shd.g_old_rec.attribute5;
368: End If;
369: If (p_rec.attribute6 = hr_api.g_varchar2) then
370: p_rec.attribute6 :=
371: per_rtl_shd.g_old_rec.attribute6;
372: End If;
373: If (p_rec.attribute7 = hr_api.g_varchar2) then
369: If (p_rec.attribute6 = hr_api.g_varchar2) then
370: p_rec.attribute6 :=
371: per_rtl_shd.g_old_rec.attribute6;
372: End If;
373: If (p_rec.attribute7 = hr_api.g_varchar2) then
374: p_rec.attribute7 :=
375: per_rtl_shd.g_old_rec.attribute7;
376: End If;
377: If (p_rec.attribute8 = hr_api.g_varchar2) then
373: If (p_rec.attribute7 = hr_api.g_varchar2) then
374: p_rec.attribute7 :=
375: per_rtl_shd.g_old_rec.attribute7;
376: End If;
377: If (p_rec.attribute8 = hr_api.g_varchar2) then
378: p_rec.attribute8 :=
379: per_rtl_shd.g_old_rec.attribute8;
380: End If;
381: If (p_rec.attribute9 = hr_api.g_varchar2) then
377: If (p_rec.attribute8 = hr_api.g_varchar2) then
378: p_rec.attribute8 :=
379: per_rtl_shd.g_old_rec.attribute8;
380: End If;
381: If (p_rec.attribute9 = hr_api.g_varchar2) then
382: p_rec.attribute9 :=
383: per_rtl_shd.g_old_rec.attribute9;
384: End If;
385: If (p_rec.attribute10 = hr_api.g_varchar2) then
381: If (p_rec.attribute9 = hr_api.g_varchar2) then
382: p_rec.attribute9 :=
383: per_rtl_shd.g_old_rec.attribute9;
384: End If;
385: If (p_rec.attribute10 = hr_api.g_varchar2) then
386: p_rec.attribute10 :=
387: per_rtl_shd.g_old_rec.attribute10;
388: End If;
389: If (p_rec.attribute11 = hr_api.g_varchar2) then
385: If (p_rec.attribute10 = hr_api.g_varchar2) then
386: p_rec.attribute10 :=
387: per_rtl_shd.g_old_rec.attribute10;
388: End If;
389: If (p_rec.attribute11 = hr_api.g_varchar2) then
390: p_rec.attribute11 :=
391: per_rtl_shd.g_old_rec.attribute11;
392: End If;
393: If (p_rec.attribute12 = hr_api.g_varchar2) then
389: If (p_rec.attribute11 = hr_api.g_varchar2) then
390: p_rec.attribute11 :=
391: per_rtl_shd.g_old_rec.attribute11;
392: End If;
393: If (p_rec.attribute12 = hr_api.g_varchar2) then
394: p_rec.attribute12 :=
395: per_rtl_shd.g_old_rec.attribute12;
396: End If;
397: If (p_rec.attribute13 = hr_api.g_varchar2) then
393: If (p_rec.attribute12 = hr_api.g_varchar2) then
394: p_rec.attribute12 :=
395: per_rtl_shd.g_old_rec.attribute12;
396: End If;
397: If (p_rec.attribute13 = hr_api.g_varchar2) then
398: p_rec.attribute13 :=
399: per_rtl_shd.g_old_rec.attribute13;
400: End If;
401: If (p_rec.attribute14 = hr_api.g_varchar2) then
397: If (p_rec.attribute13 = hr_api.g_varchar2) then
398: p_rec.attribute13 :=
399: per_rtl_shd.g_old_rec.attribute13;
400: End If;
401: If (p_rec.attribute14 = hr_api.g_varchar2) then
402: p_rec.attribute14 :=
403: per_rtl_shd.g_old_rec.attribute14;
404: End If;
405: If (p_rec.attribute15 = hr_api.g_varchar2) then
401: If (p_rec.attribute14 = hr_api.g_varchar2) then
402: p_rec.attribute14 :=
403: per_rtl_shd.g_old_rec.attribute14;
404: End If;
405: If (p_rec.attribute15 = hr_api.g_varchar2) then
406: p_rec.attribute15 :=
407: per_rtl_shd.g_old_rec.attribute15;
408: End If;
409: If (p_rec.attribute16 = hr_api.g_varchar2) then
405: If (p_rec.attribute15 = hr_api.g_varchar2) then
406: p_rec.attribute15 :=
407: per_rtl_shd.g_old_rec.attribute15;
408: End If;
409: If (p_rec.attribute16 = hr_api.g_varchar2) then
410: p_rec.attribute16 :=
411: per_rtl_shd.g_old_rec.attribute16;
412: End If;
413: If (p_rec.attribute17 = hr_api.g_varchar2) then
409: If (p_rec.attribute16 = hr_api.g_varchar2) then
410: p_rec.attribute16 :=
411: per_rtl_shd.g_old_rec.attribute16;
412: End If;
413: If (p_rec.attribute17 = hr_api.g_varchar2) then
414: p_rec.attribute17 :=
415: per_rtl_shd.g_old_rec.attribute17;
416: End If;
417: If (p_rec.attribute18 = hr_api.g_varchar2) then
413: If (p_rec.attribute17 = hr_api.g_varchar2) then
414: p_rec.attribute17 :=
415: per_rtl_shd.g_old_rec.attribute17;
416: End If;
417: If (p_rec.attribute18 = hr_api.g_varchar2) then
418: p_rec.attribute18 :=
419: per_rtl_shd.g_old_rec.attribute18;
420: End If;
421: If (p_rec.attribute19 = hr_api.g_varchar2) then
417: If (p_rec.attribute18 = hr_api.g_varchar2) then
418: p_rec.attribute18 :=
419: per_rtl_shd.g_old_rec.attribute18;
420: End If;
421: If (p_rec.attribute19 = hr_api.g_varchar2) then
422: p_rec.attribute19 :=
423: per_rtl_shd.g_old_rec.attribute19;
424: End If;
425: If (p_rec.attribute20 = hr_api.g_varchar2) then
421: If (p_rec.attribute19 = hr_api.g_varchar2) then
422: p_rec.attribute19 :=
423: per_rtl_shd.g_old_rec.attribute19;
424: End If;
425: If (p_rec.attribute20 = hr_api.g_varchar2) then
426: p_rec.attribute20 :=
427: per_rtl_shd.g_old_rec.attribute20;
428: End If;
429: --
486: --
487: -- If we are validating then raise the Validate_Enabled exception
488: --
489: If p_validate then
490: Raise HR_Api.Validate_Enabled;
491: End If;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: Exception
491: End If;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: Exception
495: When HR_Api.Validate_Enabled Then
496: --
497: -- As the Validate_Enabled exception has been raised
498: -- we must rollback to the savepoint
499: --
505: -- ----------------------------------------------------------------------------
506: Procedure upd
507: (
508: p_rating_level_id in number,
509: p_name in varchar2 default hr_api.g_varchar2,
510: p_object_version_number in out nocopy number,
511: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
512: p_attribute_category in varchar2 default hr_api.g_varchar2,
513: p_attribute1 in varchar2 default hr_api.g_varchar2,
507: (
508: p_rating_level_id in number,
509: p_name in varchar2 default hr_api.g_varchar2,
510: p_object_version_number in out nocopy number,
511: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
512: p_attribute_category in varchar2 default hr_api.g_varchar2,
513: p_attribute1 in varchar2 default hr_api.g_varchar2,
514: p_attribute2 in varchar2 default hr_api.g_varchar2,
515: p_attribute3 in varchar2 default hr_api.g_varchar2,
508: p_rating_level_id in number,
509: p_name in varchar2 default hr_api.g_varchar2,
510: p_object_version_number in out nocopy number,
511: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
512: p_attribute_category in varchar2 default hr_api.g_varchar2,
513: p_attribute1 in varchar2 default hr_api.g_varchar2,
514: p_attribute2 in varchar2 default hr_api.g_varchar2,
515: p_attribute3 in varchar2 default hr_api.g_varchar2,
516: p_attribute4 in varchar2 default hr_api.g_varchar2,
509: p_name in varchar2 default hr_api.g_varchar2,
510: p_object_version_number in out nocopy number,
511: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
512: p_attribute_category in varchar2 default hr_api.g_varchar2,
513: p_attribute1 in varchar2 default hr_api.g_varchar2,
514: p_attribute2 in varchar2 default hr_api.g_varchar2,
515: p_attribute3 in varchar2 default hr_api.g_varchar2,
516: p_attribute4 in varchar2 default hr_api.g_varchar2,
517: p_attribute5 in varchar2 default hr_api.g_varchar2,
510: p_object_version_number in out nocopy number,
511: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
512: p_attribute_category in varchar2 default hr_api.g_varchar2,
513: p_attribute1 in varchar2 default hr_api.g_varchar2,
514: p_attribute2 in varchar2 default hr_api.g_varchar2,
515: p_attribute3 in varchar2 default hr_api.g_varchar2,
516: p_attribute4 in varchar2 default hr_api.g_varchar2,
517: p_attribute5 in varchar2 default hr_api.g_varchar2,
518: p_attribute6 in varchar2 default hr_api.g_varchar2,
511: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
512: p_attribute_category in varchar2 default hr_api.g_varchar2,
513: p_attribute1 in varchar2 default hr_api.g_varchar2,
514: p_attribute2 in varchar2 default hr_api.g_varchar2,
515: p_attribute3 in varchar2 default hr_api.g_varchar2,
516: p_attribute4 in varchar2 default hr_api.g_varchar2,
517: p_attribute5 in varchar2 default hr_api.g_varchar2,
518: p_attribute6 in varchar2 default hr_api.g_varchar2,
519: p_attribute7 in varchar2 default hr_api.g_varchar2,
512: p_attribute_category in varchar2 default hr_api.g_varchar2,
513: p_attribute1 in varchar2 default hr_api.g_varchar2,
514: p_attribute2 in varchar2 default hr_api.g_varchar2,
515: p_attribute3 in varchar2 default hr_api.g_varchar2,
516: p_attribute4 in varchar2 default hr_api.g_varchar2,
517: p_attribute5 in varchar2 default hr_api.g_varchar2,
518: p_attribute6 in varchar2 default hr_api.g_varchar2,
519: p_attribute7 in varchar2 default hr_api.g_varchar2,
520: p_attribute8 in varchar2 default hr_api.g_varchar2,
513: p_attribute1 in varchar2 default hr_api.g_varchar2,
514: p_attribute2 in varchar2 default hr_api.g_varchar2,
515: p_attribute3 in varchar2 default hr_api.g_varchar2,
516: p_attribute4 in varchar2 default hr_api.g_varchar2,
517: p_attribute5 in varchar2 default hr_api.g_varchar2,
518: p_attribute6 in varchar2 default hr_api.g_varchar2,
519: p_attribute7 in varchar2 default hr_api.g_varchar2,
520: p_attribute8 in varchar2 default hr_api.g_varchar2,
521: p_attribute9 in varchar2 default hr_api.g_varchar2,
514: p_attribute2 in varchar2 default hr_api.g_varchar2,
515: p_attribute3 in varchar2 default hr_api.g_varchar2,
516: p_attribute4 in varchar2 default hr_api.g_varchar2,
517: p_attribute5 in varchar2 default hr_api.g_varchar2,
518: p_attribute6 in varchar2 default hr_api.g_varchar2,
519: p_attribute7 in varchar2 default hr_api.g_varchar2,
520: p_attribute8 in varchar2 default hr_api.g_varchar2,
521: p_attribute9 in varchar2 default hr_api.g_varchar2,
522: p_attribute10 in varchar2 default hr_api.g_varchar2,
515: p_attribute3 in varchar2 default hr_api.g_varchar2,
516: p_attribute4 in varchar2 default hr_api.g_varchar2,
517: p_attribute5 in varchar2 default hr_api.g_varchar2,
518: p_attribute6 in varchar2 default hr_api.g_varchar2,
519: p_attribute7 in varchar2 default hr_api.g_varchar2,
520: p_attribute8 in varchar2 default hr_api.g_varchar2,
521: p_attribute9 in varchar2 default hr_api.g_varchar2,
522: p_attribute10 in varchar2 default hr_api.g_varchar2,
523: p_attribute11 in varchar2 default hr_api.g_varchar2,
516: p_attribute4 in varchar2 default hr_api.g_varchar2,
517: p_attribute5 in varchar2 default hr_api.g_varchar2,
518: p_attribute6 in varchar2 default hr_api.g_varchar2,
519: p_attribute7 in varchar2 default hr_api.g_varchar2,
520: p_attribute8 in varchar2 default hr_api.g_varchar2,
521: p_attribute9 in varchar2 default hr_api.g_varchar2,
522: p_attribute10 in varchar2 default hr_api.g_varchar2,
523: p_attribute11 in varchar2 default hr_api.g_varchar2,
524: p_attribute12 in varchar2 default hr_api.g_varchar2,
517: p_attribute5 in varchar2 default hr_api.g_varchar2,
518: p_attribute6 in varchar2 default hr_api.g_varchar2,
519: p_attribute7 in varchar2 default hr_api.g_varchar2,
520: p_attribute8 in varchar2 default hr_api.g_varchar2,
521: p_attribute9 in varchar2 default hr_api.g_varchar2,
522: p_attribute10 in varchar2 default hr_api.g_varchar2,
523: p_attribute11 in varchar2 default hr_api.g_varchar2,
524: p_attribute12 in varchar2 default hr_api.g_varchar2,
525: p_attribute13 in varchar2 default hr_api.g_varchar2,
518: p_attribute6 in varchar2 default hr_api.g_varchar2,
519: p_attribute7 in varchar2 default hr_api.g_varchar2,
520: p_attribute8 in varchar2 default hr_api.g_varchar2,
521: p_attribute9 in varchar2 default hr_api.g_varchar2,
522: p_attribute10 in varchar2 default hr_api.g_varchar2,
523: p_attribute11 in varchar2 default hr_api.g_varchar2,
524: p_attribute12 in varchar2 default hr_api.g_varchar2,
525: p_attribute13 in varchar2 default hr_api.g_varchar2,
526: p_attribute14 in varchar2 default hr_api.g_varchar2,
519: p_attribute7 in varchar2 default hr_api.g_varchar2,
520: p_attribute8 in varchar2 default hr_api.g_varchar2,
521: p_attribute9 in varchar2 default hr_api.g_varchar2,
522: p_attribute10 in varchar2 default hr_api.g_varchar2,
523: p_attribute11 in varchar2 default hr_api.g_varchar2,
524: p_attribute12 in varchar2 default hr_api.g_varchar2,
525: p_attribute13 in varchar2 default hr_api.g_varchar2,
526: p_attribute14 in varchar2 default hr_api.g_varchar2,
527: p_attribute15 in varchar2 default hr_api.g_varchar2,
520: p_attribute8 in varchar2 default hr_api.g_varchar2,
521: p_attribute9 in varchar2 default hr_api.g_varchar2,
522: p_attribute10 in varchar2 default hr_api.g_varchar2,
523: p_attribute11 in varchar2 default hr_api.g_varchar2,
524: p_attribute12 in varchar2 default hr_api.g_varchar2,
525: p_attribute13 in varchar2 default hr_api.g_varchar2,
526: p_attribute14 in varchar2 default hr_api.g_varchar2,
527: p_attribute15 in varchar2 default hr_api.g_varchar2,
528: p_attribute16 in varchar2 default hr_api.g_varchar2,
521: p_attribute9 in varchar2 default hr_api.g_varchar2,
522: p_attribute10 in varchar2 default hr_api.g_varchar2,
523: p_attribute11 in varchar2 default hr_api.g_varchar2,
524: p_attribute12 in varchar2 default hr_api.g_varchar2,
525: p_attribute13 in varchar2 default hr_api.g_varchar2,
526: p_attribute14 in varchar2 default hr_api.g_varchar2,
527: p_attribute15 in varchar2 default hr_api.g_varchar2,
528: p_attribute16 in varchar2 default hr_api.g_varchar2,
529: p_attribute17 in varchar2 default hr_api.g_varchar2,
522: p_attribute10 in varchar2 default hr_api.g_varchar2,
523: p_attribute11 in varchar2 default hr_api.g_varchar2,
524: p_attribute12 in varchar2 default hr_api.g_varchar2,
525: p_attribute13 in varchar2 default hr_api.g_varchar2,
526: p_attribute14 in varchar2 default hr_api.g_varchar2,
527: p_attribute15 in varchar2 default hr_api.g_varchar2,
528: p_attribute16 in varchar2 default hr_api.g_varchar2,
529: p_attribute17 in varchar2 default hr_api.g_varchar2,
530: p_attribute18 in varchar2 default hr_api.g_varchar2,
523: p_attribute11 in varchar2 default hr_api.g_varchar2,
524: p_attribute12 in varchar2 default hr_api.g_varchar2,
525: p_attribute13 in varchar2 default hr_api.g_varchar2,
526: p_attribute14 in varchar2 default hr_api.g_varchar2,
527: p_attribute15 in varchar2 default hr_api.g_varchar2,
528: p_attribute16 in varchar2 default hr_api.g_varchar2,
529: p_attribute17 in varchar2 default hr_api.g_varchar2,
530: p_attribute18 in varchar2 default hr_api.g_varchar2,
531: p_attribute19 in varchar2 default hr_api.g_varchar2,
524: p_attribute12 in varchar2 default hr_api.g_varchar2,
525: p_attribute13 in varchar2 default hr_api.g_varchar2,
526: p_attribute14 in varchar2 default hr_api.g_varchar2,
527: p_attribute15 in varchar2 default hr_api.g_varchar2,
528: p_attribute16 in varchar2 default hr_api.g_varchar2,
529: p_attribute17 in varchar2 default hr_api.g_varchar2,
530: p_attribute18 in varchar2 default hr_api.g_varchar2,
531: p_attribute19 in varchar2 default hr_api.g_varchar2,
532: p_attribute20 in varchar2 default hr_api.g_varchar2,
525: p_attribute13 in varchar2 default hr_api.g_varchar2,
526: p_attribute14 in varchar2 default hr_api.g_varchar2,
527: p_attribute15 in varchar2 default hr_api.g_varchar2,
528: p_attribute16 in varchar2 default hr_api.g_varchar2,
529: p_attribute17 in varchar2 default hr_api.g_varchar2,
530: p_attribute18 in varchar2 default hr_api.g_varchar2,
531: p_attribute19 in varchar2 default hr_api.g_varchar2,
532: p_attribute20 in varchar2 default hr_api.g_varchar2,
533: p_effective_date in date ,
526: p_attribute14 in varchar2 default hr_api.g_varchar2,
527: p_attribute15 in varchar2 default hr_api.g_varchar2,
528: p_attribute16 in varchar2 default hr_api.g_varchar2,
529: p_attribute17 in varchar2 default hr_api.g_varchar2,
530: p_attribute18 in varchar2 default hr_api.g_varchar2,
531: p_attribute19 in varchar2 default hr_api.g_varchar2,
532: p_attribute20 in varchar2 default hr_api.g_varchar2,
533: p_effective_date in date ,
534: p_validate in boolean default false
527: p_attribute15 in varchar2 default hr_api.g_varchar2,
528: p_attribute16 in varchar2 default hr_api.g_varchar2,
529: p_attribute17 in varchar2 default hr_api.g_varchar2,
530: p_attribute18 in varchar2 default hr_api.g_varchar2,
531: p_attribute19 in varchar2 default hr_api.g_varchar2,
532: p_attribute20 in varchar2 default hr_api.g_varchar2,
533: p_effective_date in date ,
534: p_validate in boolean default false
535: ) is
528: p_attribute16 in varchar2 default hr_api.g_varchar2,
529: p_attribute17 in varchar2 default hr_api.g_varchar2,
530: p_attribute18 in varchar2 default hr_api.g_varchar2,
531: p_attribute19 in varchar2 default hr_api.g_varchar2,
532: p_attribute20 in varchar2 default hr_api.g_varchar2,
533: p_effective_date in date ,
534: p_validate in boolean default false
535: ) is
536: --
546: l_rec :=
547: per_rtl_shd.convert_args
548: (
549: p_rating_level_id,
550: hr_api.g_number,
551: hr_api.g_number,
552: hr_api.g_number,
553: p_name,
554: p_object_version_number,
547: per_rtl_shd.convert_args
548: (
549: p_rating_level_id,
550: hr_api.g_number,
551: hr_api.g_number,
552: hr_api.g_number,
553: p_name,
554: p_object_version_number,
555: p_behavioural_indicator,
548: (
549: p_rating_level_id,
550: hr_api.g_number,
551: hr_api.g_number,
552: hr_api.g_number,
553: p_name,
554: p_object_version_number,
555: p_behavioural_indicator,
556: hr_api.g_number,
552: hr_api.g_number,
553: p_name,
554: p_object_version_number,
555: p_behavioural_indicator,
556: hr_api.g_number,
557: p_attribute_category,
558: p_attribute1,
559: p_attribute2,
560: p_attribute3,