APPS.PER_RTL_UPD dependencies on HR_API

Line 93: When hr_api.check_integrity_violated Then

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

Line 96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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));

Line 97: When hr_api.parent_integrity_violated Then

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

Line 100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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));

Line 101: When hr_api.unique_integrity_violated Then

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

Line 104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 253: when hr_api.cannot_find_prog_unit then

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

Line 254: hr_api.cannot_find_prog_unit_error

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;

Line 321: If (p_rec.business_group_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 490: Raise HR_Api.Validate_Enabled;

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

Line 495: When HR_Api.Validate_Enabled Then

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

Line 509: p_name in varchar2 default hr_api.g_varchar2,

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,

Line 511: p_behavioural_indicator 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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 530: p_attribute18 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 ,
534: p_validate in boolean default false

Line 531: p_attribute19 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
535: ) is

Line 532: p_attribute20 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
536: --

Line 550: hr_api.g_number,

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,

Line 551: hr_api.g_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,

Line 552: hr_api.g_number,

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,

Line 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,