94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: --
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: per_rsc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: per_rsc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: per_rsc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: per_rsc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: per_rsc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: per_rsc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: per_rsc_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: per_rsc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: per_rsc_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: per_rsc_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: Raise;
112: End update_dml;
113: --
255: p_attribute18_o => per_rsc_shd.g_old_rec.attribute18 ,
256: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: ( p_module_name => 'PER_RATING_SCALES'
262: ,p_hook_type => 'AU'
263: );
256: p_attribute19_o => per_rsc_shd.g_old_rec.attribute19 ,
257: p_attribute20_o => per_rsc_shd.g_old_rec.attribute20 );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: ( p_module_name => 'PER_RATING_SCALES'
262: ,p_hook_type => 'AU'
263: );
264: end;
323: -- p_rec plsql record structure
324: -- to see if a system default is being used. If a system default
325: -- is being used then we must set to the 'current' argument value.
326: --
327: If (p_rec.business_group_id = hr_api.g_number) then
328: p_rec.business_group_id :=
329: per_rsc_shd.g_old_rec.business_group_id;
330: End If;
331: If (p_rec.name = hr_api.g_varchar2) then
327: If (p_rec.business_group_id = hr_api.g_number) then
328: p_rec.business_group_id :=
329: per_rsc_shd.g_old_rec.business_group_id;
330: End If;
331: If (p_rec.name = hr_api.g_varchar2) then
332: p_rec.name :=
333: per_rsc_shd.g_old_rec.name;
334: End If;
335: If (p_rec.type = hr_api.g_varchar2) then
331: If (p_rec.name = hr_api.g_varchar2) then
332: p_rec.name :=
333: per_rsc_shd.g_old_rec.name;
334: End If;
335: If (p_rec.type = hr_api.g_varchar2) then
336: p_rec.type :=
337: per_rsc_shd.g_old_rec.type;
338: End If;
339: If (p_rec.description = hr_api.g_varchar2) then
335: If (p_rec.type = hr_api.g_varchar2) then
336: p_rec.type :=
337: per_rsc_shd.g_old_rec.type;
338: End If;
339: If (p_rec.description = hr_api.g_varchar2) then
340: p_rec.description :=
341: per_rsc_shd.g_old_rec.description;
342: End If;
343: If (p_rec.max_scale_step = hr_api.g_number) then
339: If (p_rec.description = hr_api.g_varchar2) then
340: p_rec.description :=
341: per_rsc_shd.g_old_rec.description;
342: End If;
343: If (p_rec.max_scale_step = hr_api.g_number) then
344: p_rec.max_scale_step :=
345: per_rsc_shd.g_old_rec.max_scale_step;
346: End If;
347: If (p_rec.min_scale_step = hr_api.g_number) then
343: If (p_rec.max_scale_step = hr_api.g_number) then
344: p_rec.max_scale_step :=
345: per_rsc_shd.g_old_rec.max_scale_step;
346: End If;
347: If (p_rec.min_scale_step = hr_api.g_number) then
348: p_rec.min_scale_step :=
349: per_rsc_shd.g_old_rec.min_scale_step;
350: End If;
351: if (p_rec.default_flag = hr_api.g_varchar2) then
347: If (p_rec.min_scale_step = hr_api.g_number) then
348: p_rec.min_scale_step :=
349: per_rsc_shd.g_old_rec.min_scale_step;
350: End If;
351: if (p_rec.default_flag = hr_api.g_varchar2) then
352: p_rec.default_flag :=
353: per_rsc_shd.g_old_rec.default_flag;
354: end if;
355: If (p_rec.attribute_category = hr_api.g_varchar2) then
351: if (p_rec.default_flag = hr_api.g_varchar2) then
352: p_rec.default_flag :=
353: per_rsc_shd.g_old_rec.default_flag;
354: end if;
355: If (p_rec.attribute_category = hr_api.g_varchar2) then
356: p_rec.attribute_category :=
357: per_rsc_shd.g_old_rec.attribute_category;
358: End If;
359: If (p_rec.attribute1 = hr_api.g_varchar2) then
355: If (p_rec.attribute_category = hr_api.g_varchar2) then
356: p_rec.attribute_category :=
357: per_rsc_shd.g_old_rec.attribute_category;
358: End If;
359: If (p_rec.attribute1 = hr_api.g_varchar2) then
360: p_rec.attribute1 :=
361: per_rsc_shd.g_old_rec.attribute1;
362: End If;
363: If (p_rec.attribute2 = hr_api.g_varchar2) then
359: If (p_rec.attribute1 = hr_api.g_varchar2) then
360: p_rec.attribute1 :=
361: per_rsc_shd.g_old_rec.attribute1;
362: End If;
363: If (p_rec.attribute2 = hr_api.g_varchar2) then
364: p_rec.attribute2 :=
365: per_rsc_shd.g_old_rec.attribute2;
366: End If;
367: If (p_rec.attribute3 = hr_api.g_varchar2) then
363: If (p_rec.attribute2 = hr_api.g_varchar2) then
364: p_rec.attribute2 :=
365: per_rsc_shd.g_old_rec.attribute2;
366: End If;
367: If (p_rec.attribute3 = hr_api.g_varchar2) then
368: p_rec.attribute3 :=
369: per_rsc_shd.g_old_rec.attribute3;
370: End If;
371: If (p_rec.attribute4 = hr_api.g_varchar2) then
367: If (p_rec.attribute3 = hr_api.g_varchar2) then
368: p_rec.attribute3 :=
369: per_rsc_shd.g_old_rec.attribute3;
370: End If;
371: If (p_rec.attribute4 = hr_api.g_varchar2) then
372: p_rec.attribute4 :=
373: per_rsc_shd.g_old_rec.attribute4;
374: End If;
375: If (p_rec.attribute5 = hr_api.g_varchar2) then
371: If (p_rec.attribute4 = hr_api.g_varchar2) then
372: p_rec.attribute4 :=
373: per_rsc_shd.g_old_rec.attribute4;
374: End If;
375: If (p_rec.attribute5 = hr_api.g_varchar2) then
376: p_rec.attribute5 :=
377: per_rsc_shd.g_old_rec.attribute5;
378: End If;
379: If (p_rec.attribute6 = hr_api.g_varchar2) then
375: If (p_rec.attribute5 = hr_api.g_varchar2) then
376: p_rec.attribute5 :=
377: per_rsc_shd.g_old_rec.attribute5;
378: End If;
379: If (p_rec.attribute6 = hr_api.g_varchar2) then
380: p_rec.attribute6 :=
381: per_rsc_shd.g_old_rec.attribute6;
382: End If;
383: If (p_rec.attribute7 = hr_api.g_varchar2) then
379: If (p_rec.attribute6 = hr_api.g_varchar2) then
380: p_rec.attribute6 :=
381: per_rsc_shd.g_old_rec.attribute6;
382: End If;
383: If (p_rec.attribute7 = hr_api.g_varchar2) then
384: p_rec.attribute7 :=
385: per_rsc_shd.g_old_rec.attribute7;
386: End If;
387: If (p_rec.attribute8 = hr_api.g_varchar2) then
383: If (p_rec.attribute7 = hr_api.g_varchar2) then
384: p_rec.attribute7 :=
385: per_rsc_shd.g_old_rec.attribute7;
386: End If;
387: If (p_rec.attribute8 = hr_api.g_varchar2) then
388: p_rec.attribute8 :=
389: per_rsc_shd.g_old_rec.attribute8;
390: End If;
391: If (p_rec.attribute9 = hr_api.g_varchar2) then
387: If (p_rec.attribute8 = hr_api.g_varchar2) then
388: p_rec.attribute8 :=
389: per_rsc_shd.g_old_rec.attribute8;
390: End If;
391: If (p_rec.attribute9 = hr_api.g_varchar2) then
392: p_rec.attribute9 :=
393: per_rsc_shd.g_old_rec.attribute9;
394: End If;
395: If (p_rec.attribute10 = hr_api.g_varchar2) then
391: If (p_rec.attribute9 = hr_api.g_varchar2) then
392: p_rec.attribute9 :=
393: per_rsc_shd.g_old_rec.attribute9;
394: End If;
395: If (p_rec.attribute10 = hr_api.g_varchar2) then
396: p_rec.attribute10 :=
397: per_rsc_shd.g_old_rec.attribute10;
398: End If;
399: If (p_rec.attribute11 = hr_api.g_varchar2) then
395: If (p_rec.attribute10 = hr_api.g_varchar2) then
396: p_rec.attribute10 :=
397: per_rsc_shd.g_old_rec.attribute10;
398: End If;
399: If (p_rec.attribute11 = hr_api.g_varchar2) then
400: p_rec.attribute11 :=
401: per_rsc_shd.g_old_rec.attribute11;
402: eND iF;
403: If (p_rec.attribute12 = hr_api.g_varchar2) then
399: If (p_rec.attribute11 = hr_api.g_varchar2) then
400: p_rec.attribute11 :=
401: per_rsc_shd.g_old_rec.attribute11;
402: eND iF;
403: If (p_rec.attribute12 = hr_api.g_varchar2) then
404: p_rec.attribute12 :=
405: per_rsc_shd.g_old_rec.attribute12;
406: End If;
407: If (p_rec.attribute13 = hr_api.g_varchar2) then
403: If (p_rec.attribute12 = hr_api.g_varchar2) then
404: p_rec.attribute12 :=
405: per_rsc_shd.g_old_rec.attribute12;
406: End If;
407: If (p_rec.attribute13 = hr_api.g_varchar2) then
408: p_rec.attribute13 :=
409: per_rsc_shd.g_old_rec.attribute13;
410: End If;
411: If (p_rec.attribute14 = hr_api.g_varchar2) then
407: If (p_rec.attribute13 = hr_api.g_varchar2) then
408: p_rec.attribute13 :=
409: per_rsc_shd.g_old_rec.attribute13;
410: End If;
411: If (p_rec.attribute14 = hr_api.g_varchar2) then
412: p_rec.attribute14 :=
413: per_rsc_shd.g_old_rec.attribute14;
414: End If;
415: If (p_rec.attribute15 = hr_api.g_varchar2) then
411: If (p_rec.attribute14 = hr_api.g_varchar2) then
412: p_rec.attribute14 :=
413: per_rsc_shd.g_old_rec.attribute14;
414: End If;
415: If (p_rec.attribute15 = hr_api.g_varchar2) then
416: p_rec.attribute15 :=
417: per_rsc_shd.g_old_rec.attribute15;
418: End If;
419: If (p_rec.attribute16 = hr_api.g_varchar2) then
415: If (p_rec.attribute15 = hr_api.g_varchar2) then
416: p_rec.attribute15 :=
417: per_rsc_shd.g_old_rec.attribute15;
418: End If;
419: If (p_rec.attribute16 = hr_api.g_varchar2) then
420: p_rec.attribute16 :=
421: per_rsc_shd.g_old_rec.attribute16;
422: End If;
423: If (p_rec.attribute17 = hr_api.g_varchar2) then
419: If (p_rec.attribute16 = hr_api.g_varchar2) then
420: p_rec.attribute16 :=
421: per_rsc_shd.g_old_rec.attribute16;
422: End If;
423: If (p_rec.attribute17 = hr_api.g_varchar2) then
424: p_rec.attribute17 :=
425: per_rsc_shd.g_old_rec.attribute17;
426: End If;
427: If (p_rec.attribute18 = hr_api.g_varchar2) then
423: If (p_rec.attribute17 = hr_api.g_varchar2) then
424: p_rec.attribute17 :=
425: per_rsc_shd.g_old_rec.attribute17;
426: End If;
427: If (p_rec.attribute18 = hr_api.g_varchar2) then
428: p_rec.attribute18 :=
429: per_rsc_shd.g_old_rec.attribute18;
430: End If;
431: If (p_rec.attribute19 = hr_api.g_varchar2) then
427: If (p_rec.attribute18 = hr_api.g_varchar2) then
428: p_rec.attribute18 :=
429: per_rsc_shd.g_old_rec.attribute18;
430: End If;
431: If (p_rec.attribute19 = hr_api.g_varchar2) then
432: p_rec.attribute19 :=
433: per_rsc_shd.g_old_rec.attribute19;
434: End If;
435: If (p_rec.attribute20 = hr_api.g_varchar2) then
431: If (p_rec.attribute19 = hr_api.g_varchar2) then
432: p_rec.attribute19 :=
433: per_rsc_shd.g_old_rec.attribute19;
434: End If;
435: If (p_rec.attribute20 = hr_api.g_varchar2) then
436: p_rec.attribute20 :=
437: per_rsc_shd.g_old_rec.attribute20;
438: End If;
439: --
496: --
497: -- If we are validating then raise the Validate_Enabled exception
498: --
499: If p_validate then
500: Raise HR_Api.Validate_Enabled;
501: End If;
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 10);
504: Exception
501: End If;
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 10);
504: Exception
505: When HR_Api.Validate_Enabled Then
506: --
507: -- As the Validate_Enabled exception has been raised
508: -- we must rollback to the savepoint
509: --
515: -- ----------------------------------------------------------------------------
516: Procedure upd
517: (
518: p_rating_scale_id in number,
519: p_name in varchar2 default hr_api.g_varchar2,
520: p_object_version_number in out nocopy number,
521: p_description in varchar2 default hr_api.g_varchar2,
522: p_max_scale_step in number default hr_api.g_number,
523: p_min_scale_step in number default hr_api.g_number,
517: (
518: p_rating_scale_id in number,
519: p_name in varchar2 default hr_api.g_varchar2,
520: p_object_version_number in out nocopy number,
521: p_description in varchar2 default hr_api.g_varchar2,
522: p_max_scale_step in number default hr_api.g_number,
523: p_min_scale_step in number default hr_api.g_number,
524: p_validate in boolean default false,
525: p_default_flag in varchar2 default hr_api.g_varchar2,
518: p_rating_scale_id in number,
519: p_name in varchar2 default hr_api.g_varchar2,
520: p_object_version_number in out nocopy number,
521: p_description in varchar2 default hr_api.g_varchar2,
522: p_max_scale_step in number default hr_api.g_number,
523: p_min_scale_step in number default hr_api.g_number,
524: p_validate in boolean default false,
525: p_default_flag in varchar2 default hr_api.g_varchar2,
526: p_attribute_category in varchar2 default hr_api.g_varchar2,
519: p_name in varchar2 default hr_api.g_varchar2,
520: p_object_version_number in out nocopy number,
521: p_description in varchar2 default hr_api.g_varchar2,
522: p_max_scale_step in number default hr_api.g_number,
523: p_min_scale_step in number default hr_api.g_number,
524: p_validate in boolean default false,
525: p_default_flag in varchar2 default hr_api.g_varchar2,
526: p_attribute_category in varchar2 default hr_api.g_varchar2,
527: p_attribute1 in varchar2 default hr_api.g_varchar2,
521: p_description in varchar2 default hr_api.g_varchar2,
522: p_max_scale_step in number default hr_api.g_number,
523: p_min_scale_step in number default hr_api.g_number,
524: p_validate in boolean default false,
525: p_default_flag in varchar2 default hr_api.g_varchar2,
526: p_attribute_category in varchar2 default hr_api.g_varchar2,
527: p_attribute1 in varchar2 default hr_api.g_varchar2,
528: p_attribute2 in varchar2 default hr_api.g_varchar2,
529: p_attribute3 in varchar2 default hr_api.g_varchar2,
522: p_max_scale_step in number default hr_api.g_number,
523: p_min_scale_step in number default hr_api.g_number,
524: p_validate in boolean default false,
525: p_default_flag in varchar2 default hr_api.g_varchar2,
526: p_attribute_category in varchar2 default hr_api.g_varchar2,
527: p_attribute1 in varchar2 default hr_api.g_varchar2,
528: p_attribute2 in varchar2 default hr_api.g_varchar2,
529: p_attribute3 in varchar2 default hr_api.g_varchar2,
530: p_attribute4 in varchar2 default hr_api.g_varchar2,
523: p_min_scale_step in number default hr_api.g_number,
524: p_validate in boolean default false,
525: p_default_flag in varchar2 default hr_api.g_varchar2,
526: p_attribute_category in varchar2 default hr_api.g_varchar2,
527: p_attribute1 in varchar2 default hr_api.g_varchar2,
528: p_attribute2 in varchar2 default hr_api.g_varchar2,
529: p_attribute3 in varchar2 default hr_api.g_varchar2,
530: p_attribute4 in varchar2 default hr_api.g_varchar2,
531: p_attribute5 in varchar2 default hr_api.g_varchar2,
524: p_validate in boolean default false,
525: p_default_flag in varchar2 default hr_api.g_varchar2,
526: p_attribute_category in varchar2 default hr_api.g_varchar2,
527: p_attribute1 in varchar2 default hr_api.g_varchar2,
528: p_attribute2 in varchar2 default hr_api.g_varchar2,
529: p_attribute3 in varchar2 default hr_api.g_varchar2,
530: p_attribute4 in varchar2 default hr_api.g_varchar2,
531: p_attribute5 in varchar2 default hr_api.g_varchar2,
532: p_attribute6 in varchar2 default hr_api.g_varchar2,
525: p_default_flag in varchar2 default hr_api.g_varchar2,
526: p_attribute_category in varchar2 default hr_api.g_varchar2,
527: p_attribute1 in varchar2 default hr_api.g_varchar2,
528: p_attribute2 in varchar2 default hr_api.g_varchar2,
529: p_attribute3 in varchar2 default hr_api.g_varchar2,
530: p_attribute4 in varchar2 default hr_api.g_varchar2,
531: p_attribute5 in varchar2 default hr_api.g_varchar2,
532: p_attribute6 in varchar2 default hr_api.g_varchar2,
533: p_attribute7 in varchar2 default hr_api.g_varchar2,
526: p_attribute_category in varchar2 default hr_api.g_varchar2,
527: p_attribute1 in varchar2 default hr_api.g_varchar2,
528: p_attribute2 in varchar2 default hr_api.g_varchar2,
529: p_attribute3 in varchar2 default hr_api.g_varchar2,
530: p_attribute4 in varchar2 default hr_api.g_varchar2,
531: p_attribute5 in varchar2 default hr_api.g_varchar2,
532: p_attribute6 in varchar2 default hr_api.g_varchar2,
533: p_attribute7 in varchar2 default hr_api.g_varchar2,
534: p_attribute8 in varchar2 default hr_api.g_varchar2,
527: p_attribute1 in varchar2 default hr_api.g_varchar2,
528: p_attribute2 in varchar2 default hr_api.g_varchar2,
529: p_attribute3 in varchar2 default hr_api.g_varchar2,
530: p_attribute4 in varchar2 default hr_api.g_varchar2,
531: p_attribute5 in varchar2 default hr_api.g_varchar2,
532: p_attribute6 in varchar2 default hr_api.g_varchar2,
533: p_attribute7 in varchar2 default hr_api.g_varchar2,
534: p_attribute8 in varchar2 default hr_api.g_varchar2,
535: p_attribute9 in varchar2 default hr_api.g_varchar2,
528: p_attribute2 in varchar2 default hr_api.g_varchar2,
529: p_attribute3 in varchar2 default hr_api.g_varchar2,
530: p_attribute4 in varchar2 default hr_api.g_varchar2,
531: p_attribute5 in varchar2 default hr_api.g_varchar2,
532: p_attribute6 in varchar2 default hr_api.g_varchar2,
533: p_attribute7 in varchar2 default hr_api.g_varchar2,
534: p_attribute8 in varchar2 default hr_api.g_varchar2,
535: p_attribute9 in varchar2 default hr_api.g_varchar2,
536: p_attribute10 in varchar2 default hr_api.g_varchar2,
529: p_attribute3 in varchar2 default hr_api.g_varchar2,
530: p_attribute4 in varchar2 default hr_api.g_varchar2,
531: p_attribute5 in varchar2 default hr_api.g_varchar2,
532: p_attribute6 in varchar2 default hr_api.g_varchar2,
533: p_attribute7 in varchar2 default hr_api.g_varchar2,
534: p_attribute8 in varchar2 default hr_api.g_varchar2,
535: p_attribute9 in varchar2 default hr_api.g_varchar2,
536: p_attribute10 in varchar2 default hr_api.g_varchar2,
537: p_attribute11 in varchar2 default hr_api.g_varchar2,
530: p_attribute4 in varchar2 default hr_api.g_varchar2,
531: p_attribute5 in varchar2 default hr_api.g_varchar2,
532: p_attribute6 in varchar2 default hr_api.g_varchar2,
533: p_attribute7 in varchar2 default hr_api.g_varchar2,
534: p_attribute8 in varchar2 default hr_api.g_varchar2,
535: p_attribute9 in varchar2 default hr_api.g_varchar2,
536: p_attribute10 in varchar2 default hr_api.g_varchar2,
537: p_attribute11 in varchar2 default hr_api.g_varchar2,
538: p_attribute12 in varchar2 default hr_api.g_varchar2,
531: p_attribute5 in varchar2 default hr_api.g_varchar2,
532: p_attribute6 in varchar2 default hr_api.g_varchar2,
533: p_attribute7 in varchar2 default hr_api.g_varchar2,
534: p_attribute8 in varchar2 default hr_api.g_varchar2,
535: p_attribute9 in varchar2 default hr_api.g_varchar2,
536: p_attribute10 in varchar2 default hr_api.g_varchar2,
537: p_attribute11 in varchar2 default hr_api.g_varchar2,
538: p_attribute12 in varchar2 default hr_api.g_varchar2,
539: p_attribute13 in varchar2 default hr_api.g_varchar2,
532: p_attribute6 in varchar2 default hr_api.g_varchar2,
533: p_attribute7 in varchar2 default hr_api.g_varchar2,
534: p_attribute8 in varchar2 default hr_api.g_varchar2,
535: p_attribute9 in varchar2 default hr_api.g_varchar2,
536: p_attribute10 in varchar2 default hr_api.g_varchar2,
537: p_attribute11 in varchar2 default hr_api.g_varchar2,
538: p_attribute12 in varchar2 default hr_api.g_varchar2,
539: p_attribute13 in varchar2 default hr_api.g_varchar2,
540: p_attribute14 in varchar2 default hr_api.g_varchar2,
533: p_attribute7 in varchar2 default hr_api.g_varchar2,
534: p_attribute8 in varchar2 default hr_api.g_varchar2,
535: p_attribute9 in varchar2 default hr_api.g_varchar2,
536: p_attribute10 in varchar2 default hr_api.g_varchar2,
537: p_attribute11 in varchar2 default hr_api.g_varchar2,
538: p_attribute12 in varchar2 default hr_api.g_varchar2,
539: p_attribute13 in varchar2 default hr_api.g_varchar2,
540: p_attribute14 in varchar2 default hr_api.g_varchar2,
541: p_attribute15 in varchar2 default hr_api.g_varchar2,
534: p_attribute8 in varchar2 default hr_api.g_varchar2,
535: p_attribute9 in varchar2 default hr_api.g_varchar2,
536: p_attribute10 in varchar2 default hr_api.g_varchar2,
537: p_attribute11 in varchar2 default hr_api.g_varchar2,
538: p_attribute12 in varchar2 default hr_api.g_varchar2,
539: p_attribute13 in varchar2 default hr_api.g_varchar2,
540: p_attribute14 in varchar2 default hr_api.g_varchar2,
541: p_attribute15 in varchar2 default hr_api.g_varchar2,
542: p_attribute16 in varchar2 default hr_api.g_varchar2,
535: p_attribute9 in varchar2 default hr_api.g_varchar2,
536: p_attribute10 in varchar2 default hr_api.g_varchar2,
537: p_attribute11 in varchar2 default hr_api.g_varchar2,
538: p_attribute12 in varchar2 default hr_api.g_varchar2,
539: p_attribute13 in varchar2 default hr_api.g_varchar2,
540: p_attribute14 in varchar2 default hr_api.g_varchar2,
541: p_attribute15 in varchar2 default hr_api.g_varchar2,
542: p_attribute16 in varchar2 default hr_api.g_varchar2,
543: p_attribute17 in varchar2 default hr_api.g_varchar2,
536: p_attribute10 in varchar2 default hr_api.g_varchar2,
537: p_attribute11 in varchar2 default hr_api.g_varchar2,
538: p_attribute12 in varchar2 default hr_api.g_varchar2,
539: p_attribute13 in varchar2 default hr_api.g_varchar2,
540: p_attribute14 in varchar2 default hr_api.g_varchar2,
541: p_attribute15 in varchar2 default hr_api.g_varchar2,
542: p_attribute16 in varchar2 default hr_api.g_varchar2,
543: p_attribute17 in varchar2 default hr_api.g_varchar2,
544: p_attribute18 in varchar2 default hr_api.g_varchar2,
537: p_attribute11 in varchar2 default hr_api.g_varchar2,
538: p_attribute12 in varchar2 default hr_api.g_varchar2,
539: p_attribute13 in varchar2 default hr_api.g_varchar2,
540: p_attribute14 in varchar2 default hr_api.g_varchar2,
541: p_attribute15 in varchar2 default hr_api.g_varchar2,
542: p_attribute16 in varchar2 default hr_api.g_varchar2,
543: p_attribute17 in varchar2 default hr_api.g_varchar2,
544: p_attribute18 in varchar2 default hr_api.g_varchar2,
545: p_attribute19 in varchar2 default hr_api.g_varchar2,
538: p_attribute12 in varchar2 default hr_api.g_varchar2,
539: p_attribute13 in varchar2 default hr_api.g_varchar2,
540: p_attribute14 in varchar2 default hr_api.g_varchar2,
541: p_attribute15 in varchar2 default hr_api.g_varchar2,
542: p_attribute16 in varchar2 default hr_api.g_varchar2,
543: p_attribute17 in varchar2 default hr_api.g_varchar2,
544: p_attribute18 in varchar2 default hr_api.g_varchar2,
545: p_attribute19 in varchar2 default hr_api.g_varchar2,
546: p_attribute20 in varchar2 default hr_api.g_varchar2,
539: p_attribute13 in varchar2 default hr_api.g_varchar2,
540: p_attribute14 in varchar2 default hr_api.g_varchar2,
541: p_attribute15 in varchar2 default hr_api.g_varchar2,
542: p_attribute16 in varchar2 default hr_api.g_varchar2,
543: p_attribute17 in varchar2 default hr_api.g_varchar2,
544: p_attribute18 in varchar2 default hr_api.g_varchar2,
545: p_attribute19 in varchar2 default hr_api.g_varchar2,
546: p_attribute20 in varchar2 default hr_api.g_varchar2,
547: p_effective_date in date
540: p_attribute14 in varchar2 default hr_api.g_varchar2,
541: p_attribute15 in varchar2 default hr_api.g_varchar2,
542: p_attribute16 in varchar2 default hr_api.g_varchar2,
543: p_attribute17 in varchar2 default hr_api.g_varchar2,
544: p_attribute18 in varchar2 default hr_api.g_varchar2,
545: p_attribute19 in varchar2 default hr_api.g_varchar2,
546: p_attribute20 in varchar2 default hr_api.g_varchar2,
547: p_effective_date in date
548: ) is
541: p_attribute15 in varchar2 default hr_api.g_varchar2,
542: p_attribute16 in varchar2 default hr_api.g_varchar2,
543: p_attribute17 in varchar2 default hr_api.g_varchar2,
544: p_attribute18 in varchar2 default hr_api.g_varchar2,
545: p_attribute19 in varchar2 default hr_api.g_varchar2,
546: p_attribute20 in varchar2 default hr_api.g_varchar2,
547: p_effective_date in date
548: ) is
549: --
542: p_attribute16 in varchar2 default hr_api.g_varchar2,
543: p_attribute17 in varchar2 default hr_api.g_varchar2,
544: p_attribute18 in varchar2 default hr_api.g_varchar2,
545: p_attribute19 in varchar2 default hr_api.g_varchar2,
546: p_attribute20 in varchar2 default hr_api.g_varchar2,
547: p_effective_date in date
548: ) is
549: --
550: l_rec per_rsc_shd.g_rec_type;
559: l_rec :=
560: per_rsc_shd.convert_args
561: (
562: p_rating_scale_id,
563: hr_api.g_number,
564: p_name,
565: hr_api.g_varchar2,
566: p_object_version_number,
567: p_description,
561: (
562: p_rating_scale_id,
563: hr_api.g_number,
564: p_name,
565: hr_api.g_varchar2,
566: p_object_version_number,
567: p_description,
568: p_max_scale_step,
569: p_min_scale_step,