APPS.PER_RSC_UPD dependencies on HR_API

Line 98: When hr_api.check_integrity_violated Then

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

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

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

Line 102: When hr_api.parent_integrity_violated Then

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

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

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

Line 106: When hr_api.unique_integrity_violated Then

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

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

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

Line 259: when hr_api.cannot_find_prog_unit then

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

Line 260: hr_api.cannot_find_prog_unit_error

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;

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

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 500: Raise HR_Api.Validate_Enabled;

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

Line 505: When HR_Api.Validate_Enabled Then

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

Line 519: p_name in varchar2 default hr_api.g_varchar2,

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,

Line 521: p_description in varchar2 default hr_api.g_varchar2,

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,

Line 522: p_max_scale_step in number default hr_api.g_number,

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,

Line 523: p_min_scale_step in number default hr_api.g_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,
527: p_attribute1 in varchar2 default hr_api.g_varchar2,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 544: p_attribute18 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
548: ) is

Line 545: p_attribute19 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
549: --

Line 546: p_attribute20 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: --
550: l_rec per_rsc_shd.g_rec_type;

Line 563: hr_api.g_number,

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,

Line 565: hr_api.g_varchar2,

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,