110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: per_psh_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: per_psh_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: per_psh_shd.constraint_error
115: -- A check constraint has been violated
116: --
117: per_psh_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: per_psh_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: per_psh_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: per_psh_shd.constraint_error
120: -- Parent integrity has been violated
121: --
122: per_psh_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: per_psh_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: per_psh_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;
132: End update_dml;
359: );
360: --
361: exception
362: --
363: when hr_api.cannot_find_prog_unit then
364: --
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'PER_SCORECARD_SHARING'
367: ,p_hook_type => 'AU');
361: exception
362: --
363: when hr_api.cannot_find_prog_unit then
364: --
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'PER_SCORECARD_SHARING'
367: ,p_hook_type => 'AU');
368: --
369: end;
424: -- p_rec plsql record structure
425: -- to see if a system default is being used. If a system default
426: -- is being used then we must set to the 'current' argument value.
427: --
428: If (p_rec.scorecard_id = hr_api.g_number) then
429: p_rec.scorecard_id :=
430: per_psh_shd.g_old_rec.scorecard_id;
431: End If;
432: If (p_rec.person_id = hr_api.g_number) then
428: If (p_rec.scorecard_id = hr_api.g_number) then
429: p_rec.scorecard_id :=
430: per_psh_shd.g_old_rec.scorecard_id;
431: End If;
432: If (p_rec.person_id = hr_api.g_number) then
433: p_rec.person_id :=
434: per_psh_shd.g_old_rec.person_id;
435: End If;
436: If (p_rec.attribute_category = hr_api.g_varchar2) then
432: If (p_rec.person_id = hr_api.g_number) then
433: p_rec.person_id :=
434: per_psh_shd.g_old_rec.person_id;
435: End If;
436: If (p_rec.attribute_category = hr_api.g_varchar2) then
437: p_rec.attribute_category :=
438: per_psh_shd.g_old_rec.attribute_category;
439: End If;
440: If (p_rec.attribute1 = hr_api.g_varchar2) then
436: If (p_rec.attribute_category = hr_api.g_varchar2) then
437: p_rec.attribute_category :=
438: per_psh_shd.g_old_rec.attribute_category;
439: End If;
440: If (p_rec.attribute1 = hr_api.g_varchar2) then
441: p_rec.attribute1 :=
442: per_psh_shd.g_old_rec.attribute1;
443: End If;
444: If (p_rec.attribute2 = hr_api.g_varchar2) then
440: If (p_rec.attribute1 = hr_api.g_varchar2) then
441: p_rec.attribute1 :=
442: per_psh_shd.g_old_rec.attribute1;
443: End If;
444: If (p_rec.attribute2 = hr_api.g_varchar2) then
445: p_rec.attribute2 :=
446: per_psh_shd.g_old_rec.attribute2;
447: End If;
448: If (p_rec.attribute3 = hr_api.g_varchar2) then
444: If (p_rec.attribute2 = hr_api.g_varchar2) then
445: p_rec.attribute2 :=
446: per_psh_shd.g_old_rec.attribute2;
447: End If;
448: If (p_rec.attribute3 = hr_api.g_varchar2) then
449: p_rec.attribute3 :=
450: per_psh_shd.g_old_rec.attribute3;
451: End If;
452: If (p_rec.attribute4 = hr_api.g_varchar2) then
448: If (p_rec.attribute3 = hr_api.g_varchar2) then
449: p_rec.attribute3 :=
450: per_psh_shd.g_old_rec.attribute3;
451: End If;
452: If (p_rec.attribute4 = hr_api.g_varchar2) then
453: p_rec.attribute4 :=
454: per_psh_shd.g_old_rec.attribute4;
455: End If;
456: If (p_rec.attribute5 = hr_api.g_varchar2) then
452: If (p_rec.attribute4 = hr_api.g_varchar2) then
453: p_rec.attribute4 :=
454: per_psh_shd.g_old_rec.attribute4;
455: End If;
456: If (p_rec.attribute5 = hr_api.g_varchar2) then
457: p_rec.attribute5 :=
458: per_psh_shd.g_old_rec.attribute5;
459: End If;
460: If (p_rec.attribute6 = hr_api.g_varchar2) then
456: If (p_rec.attribute5 = hr_api.g_varchar2) then
457: p_rec.attribute5 :=
458: per_psh_shd.g_old_rec.attribute5;
459: End If;
460: If (p_rec.attribute6 = hr_api.g_varchar2) then
461: p_rec.attribute6 :=
462: per_psh_shd.g_old_rec.attribute6;
463: End If;
464: If (p_rec.attribute7 = hr_api.g_varchar2) then
460: If (p_rec.attribute6 = hr_api.g_varchar2) then
461: p_rec.attribute6 :=
462: per_psh_shd.g_old_rec.attribute6;
463: End If;
464: If (p_rec.attribute7 = hr_api.g_varchar2) then
465: p_rec.attribute7 :=
466: per_psh_shd.g_old_rec.attribute7;
467: End If;
468: If (p_rec.attribute8 = hr_api.g_varchar2) then
464: If (p_rec.attribute7 = hr_api.g_varchar2) then
465: p_rec.attribute7 :=
466: per_psh_shd.g_old_rec.attribute7;
467: End If;
468: If (p_rec.attribute8 = hr_api.g_varchar2) then
469: p_rec.attribute8 :=
470: per_psh_shd.g_old_rec.attribute8;
471: End If;
472: If (p_rec.attribute9 = hr_api.g_varchar2) then
468: If (p_rec.attribute8 = hr_api.g_varchar2) then
469: p_rec.attribute8 :=
470: per_psh_shd.g_old_rec.attribute8;
471: End If;
472: If (p_rec.attribute9 = hr_api.g_varchar2) then
473: p_rec.attribute9 :=
474: per_psh_shd.g_old_rec.attribute9;
475: End If;
476: If (p_rec.attribute10 = hr_api.g_varchar2) then
472: If (p_rec.attribute9 = hr_api.g_varchar2) then
473: p_rec.attribute9 :=
474: per_psh_shd.g_old_rec.attribute9;
475: End If;
476: If (p_rec.attribute10 = hr_api.g_varchar2) then
477: p_rec.attribute10 :=
478: per_psh_shd.g_old_rec.attribute10;
479: End If;
480: If (p_rec.attribute11 = hr_api.g_varchar2) then
476: If (p_rec.attribute10 = hr_api.g_varchar2) then
477: p_rec.attribute10 :=
478: per_psh_shd.g_old_rec.attribute10;
479: End If;
480: If (p_rec.attribute11 = hr_api.g_varchar2) then
481: p_rec.attribute11 :=
482: per_psh_shd.g_old_rec.attribute11;
483: End If;
484: If (p_rec.attribute12 = hr_api.g_varchar2) then
480: If (p_rec.attribute11 = hr_api.g_varchar2) then
481: p_rec.attribute11 :=
482: per_psh_shd.g_old_rec.attribute11;
483: End If;
484: If (p_rec.attribute12 = hr_api.g_varchar2) then
485: p_rec.attribute12 :=
486: per_psh_shd.g_old_rec.attribute12;
487: End If;
488: If (p_rec.attribute13 = hr_api.g_varchar2) then
484: If (p_rec.attribute12 = hr_api.g_varchar2) then
485: p_rec.attribute12 :=
486: per_psh_shd.g_old_rec.attribute12;
487: End If;
488: If (p_rec.attribute13 = hr_api.g_varchar2) then
489: p_rec.attribute13 :=
490: per_psh_shd.g_old_rec.attribute13;
491: End If;
492: If (p_rec.attribute14 = hr_api.g_varchar2) then
488: If (p_rec.attribute13 = hr_api.g_varchar2) then
489: p_rec.attribute13 :=
490: per_psh_shd.g_old_rec.attribute13;
491: End If;
492: If (p_rec.attribute14 = hr_api.g_varchar2) then
493: p_rec.attribute14 :=
494: per_psh_shd.g_old_rec.attribute14;
495: End If;
496: If (p_rec.attribute15 = hr_api.g_varchar2) then
492: If (p_rec.attribute14 = hr_api.g_varchar2) then
493: p_rec.attribute14 :=
494: per_psh_shd.g_old_rec.attribute14;
495: End If;
496: If (p_rec.attribute15 = hr_api.g_varchar2) then
497: p_rec.attribute15 :=
498: per_psh_shd.g_old_rec.attribute15;
499: End If;
500: If (p_rec.attribute16 = hr_api.g_varchar2) then
496: If (p_rec.attribute15 = hr_api.g_varchar2) then
497: p_rec.attribute15 :=
498: per_psh_shd.g_old_rec.attribute15;
499: End If;
500: If (p_rec.attribute16 = hr_api.g_varchar2) then
501: p_rec.attribute16 :=
502: per_psh_shd.g_old_rec.attribute16;
503: End If;
504: If (p_rec.attribute17 = hr_api.g_varchar2) then
500: If (p_rec.attribute16 = hr_api.g_varchar2) then
501: p_rec.attribute16 :=
502: per_psh_shd.g_old_rec.attribute16;
503: End If;
504: If (p_rec.attribute17 = hr_api.g_varchar2) then
505: p_rec.attribute17 :=
506: per_psh_shd.g_old_rec.attribute17;
507: End If;
508: If (p_rec.attribute18 = hr_api.g_varchar2) then
504: If (p_rec.attribute17 = hr_api.g_varchar2) then
505: p_rec.attribute17 :=
506: per_psh_shd.g_old_rec.attribute17;
507: End If;
508: If (p_rec.attribute18 = hr_api.g_varchar2) then
509: p_rec.attribute18 :=
510: per_psh_shd.g_old_rec.attribute18;
511: End If;
512: If (p_rec.attribute19 = hr_api.g_varchar2) then
508: If (p_rec.attribute18 = hr_api.g_varchar2) then
509: p_rec.attribute18 :=
510: per_psh_shd.g_old_rec.attribute18;
511: End If;
512: If (p_rec.attribute19 = hr_api.g_varchar2) then
513: p_rec.attribute19 :=
514: per_psh_shd.g_old_rec.attribute19;
515: End If;
516: If (p_rec.attribute20 = hr_api.g_varchar2) then
512: If (p_rec.attribute19 = hr_api.g_varchar2) then
513: p_rec.attribute19 :=
514: per_psh_shd.g_old_rec.attribute19;
515: End If;
516: If (p_rec.attribute20 = hr_api.g_varchar2) then
517: p_rec.attribute20 :=
518: per_psh_shd.g_old_rec.attribute20;
519: End If;
520: If (p_rec.attribute21 = hr_api.g_varchar2) then
516: If (p_rec.attribute20 = hr_api.g_varchar2) then
517: p_rec.attribute20 :=
518: per_psh_shd.g_old_rec.attribute20;
519: End If;
520: If (p_rec.attribute21 = hr_api.g_varchar2) then
521: p_rec.attribute21 :=
522: per_psh_shd.g_old_rec.attribute21;
523: End If;
524: If (p_rec.attribute22 = hr_api.g_varchar2) then
520: If (p_rec.attribute21 = hr_api.g_varchar2) then
521: p_rec.attribute21 :=
522: per_psh_shd.g_old_rec.attribute21;
523: End If;
524: If (p_rec.attribute22 = hr_api.g_varchar2) then
525: p_rec.attribute22 :=
526: per_psh_shd.g_old_rec.attribute22;
527: End If;
528: If (p_rec.attribute23 = hr_api.g_varchar2) then
524: If (p_rec.attribute22 = hr_api.g_varchar2) then
525: p_rec.attribute22 :=
526: per_psh_shd.g_old_rec.attribute22;
527: End If;
528: If (p_rec.attribute23 = hr_api.g_varchar2) then
529: p_rec.attribute23 :=
530: per_psh_shd.g_old_rec.attribute23;
531: End If;
532: If (p_rec.attribute24 = hr_api.g_varchar2) then
528: If (p_rec.attribute23 = hr_api.g_varchar2) then
529: p_rec.attribute23 :=
530: per_psh_shd.g_old_rec.attribute23;
531: End If;
532: If (p_rec.attribute24 = hr_api.g_varchar2) then
533: p_rec.attribute24 :=
534: per_psh_shd.g_old_rec.attribute24;
535: End If;
536: If (p_rec.attribute25 = hr_api.g_varchar2) then
532: If (p_rec.attribute24 = hr_api.g_varchar2) then
533: p_rec.attribute24 :=
534: per_psh_shd.g_old_rec.attribute24;
535: End If;
536: If (p_rec.attribute25 = hr_api.g_varchar2) then
537: p_rec.attribute25 :=
538: per_psh_shd.g_old_rec.attribute25;
539: End If;
540: If (p_rec.attribute26 = hr_api.g_varchar2) then
536: If (p_rec.attribute25 = hr_api.g_varchar2) then
537: p_rec.attribute25 :=
538: per_psh_shd.g_old_rec.attribute25;
539: End If;
540: If (p_rec.attribute26 = hr_api.g_varchar2) then
541: p_rec.attribute26 :=
542: per_psh_shd.g_old_rec.attribute26;
543: End If;
544: If (p_rec.attribute27 = hr_api.g_varchar2) then
540: If (p_rec.attribute26 = hr_api.g_varchar2) then
541: p_rec.attribute26 :=
542: per_psh_shd.g_old_rec.attribute26;
543: End If;
544: If (p_rec.attribute27 = hr_api.g_varchar2) then
545: p_rec.attribute27 :=
546: per_psh_shd.g_old_rec.attribute27;
547: End If;
548: If (p_rec.attribute28 = hr_api.g_varchar2) then
544: If (p_rec.attribute27 = hr_api.g_varchar2) then
545: p_rec.attribute27 :=
546: per_psh_shd.g_old_rec.attribute27;
547: End If;
548: If (p_rec.attribute28 = hr_api.g_varchar2) then
549: p_rec.attribute28 :=
550: per_psh_shd.g_old_rec.attribute28;
551: End If;
552: If (p_rec.attribute29 = hr_api.g_varchar2) then
548: If (p_rec.attribute28 = hr_api.g_varchar2) then
549: p_rec.attribute28 :=
550: per_psh_shd.g_old_rec.attribute28;
551: End If;
552: If (p_rec.attribute29 = hr_api.g_varchar2) then
553: p_rec.attribute29 :=
554: per_psh_shd.g_old_rec.attribute29;
555: End If;
556: If (p_rec.attribute30 = hr_api.g_varchar2) then
552: If (p_rec.attribute29 = hr_api.g_varchar2) then
553: p_rec.attribute29 :=
554: per_psh_shd.g_old_rec.attribute29;
555: End If;
556: If (p_rec.attribute30 = hr_api.g_varchar2) then
557: p_rec.attribute30 :=
558: per_psh_shd.g_old_rec.attribute30;
559: End If;
560: --
616: -- ----------------------------------------------------------------------------
617: Procedure upd
618: (p_sharing_instance_id in number
619: ,p_object_version_number in out nocopy number
620: ,p_scorecard_id in number default hr_api.g_number
621: ,p_person_id in number default hr_api.g_number
622: ,p_attribute_category in varchar2 default hr_api.g_varchar2
623: ,p_attribute1 in varchar2 default hr_api.g_varchar2
624: ,p_attribute2 in varchar2 default hr_api.g_varchar2
617: Procedure upd
618: (p_sharing_instance_id in number
619: ,p_object_version_number in out nocopy number
620: ,p_scorecard_id in number default hr_api.g_number
621: ,p_person_id in number default hr_api.g_number
622: ,p_attribute_category in varchar2 default hr_api.g_varchar2
623: ,p_attribute1 in varchar2 default hr_api.g_varchar2
624: ,p_attribute2 in varchar2 default hr_api.g_varchar2
625: ,p_attribute3 in varchar2 default hr_api.g_varchar2
618: (p_sharing_instance_id in number
619: ,p_object_version_number in out nocopy number
620: ,p_scorecard_id in number default hr_api.g_number
621: ,p_person_id in number default hr_api.g_number
622: ,p_attribute_category in varchar2 default hr_api.g_varchar2
623: ,p_attribute1 in varchar2 default hr_api.g_varchar2
624: ,p_attribute2 in varchar2 default hr_api.g_varchar2
625: ,p_attribute3 in varchar2 default hr_api.g_varchar2
626: ,p_attribute4 in varchar2 default hr_api.g_varchar2
619: ,p_object_version_number in out nocopy number
620: ,p_scorecard_id in number default hr_api.g_number
621: ,p_person_id in number default hr_api.g_number
622: ,p_attribute_category in varchar2 default hr_api.g_varchar2
623: ,p_attribute1 in varchar2 default hr_api.g_varchar2
624: ,p_attribute2 in varchar2 default hr_api.g_varchar2
625: ,p_attribute3 in varchar2 default hr_api.g_varchar2
626: ,p_attribute4 in varchar2 default hr_api.g_varchar2
627: ,p_attribute5 in varchar2 default hr_api.g_varchar2
620: ,p_scorecard_id in number default hr_api.g_number
621: ,p_person_id in number default hr_api.g_number
622: ,p_attribute_category in varchar2 default hr_api.g_varchar2
623: ,p_attribute1 in varchar2 default hr_api.g_varchar2
624: ,p_attribute2 in varchar2 default hr_api.g_varchar2
625: ,p_attribute3 in varchar2 default hr_api.g_varchar2
626: ,p_attribute4 in varchar2 default hr_api.g_varchar2
627: ,p_attribute5 in varchar2 default hr_api.g_varchar2
628: ,p_attribute6 in varchar2 default hr_api.g_varchar2
621: ,p_person_id in number default hr_api.g_number
622: ,p_attribute_category in varchar2 default hr_api.g_varchar2
623: ,p_attribute1 in varchar2 default hr_api.g_varchar2
624: ,p_attribute2 in varchar2 default hr_api.g_varchar2
625: ,p_attribute3 in varchar2 default hr_api.g_varchar2
626: ,p_attribute4 in varchar2 default hr_api.g_varchar2
627: ,p_attribute5 in varchar2 default hr_api.g_varchar2
628: ,p_attribute6 in varchar2 default hr_api.g_varchar2
629: ,p_attribute7 in varchar2 default hr_api.g_varchar2
622: ,p_attribute_category in varchar2 default hr_api.g_varchar2
623: ,p_attribute1 in varchar2 default hr_api.g_varchar2
624: ,p_attribute2 in varchar2 default hr_api.g_varchar2
625: ,p_attribute3 in varchar2 default hr_api.g_varchar2
626: ,p_attribute4 in varchar2 default hr_api.g_varchar2
627: ,p_attribute5 in varchar2 default hr_api.g_varchar2
628: ,p_attribute6 in varchar2 default hr_api.g_varchar2
629: ,p_attribute7 in varchar2 default hr_api.g_varchar2
630: ,p_attribute8 in varchar2 default hr_api.g_varchar2
623: ,p_attribute1 in varchar2 default hr_api.g_varchar2
624: ,p_attribute2 in varchar2 default hr_api.g_varchar2
625: ,p_attribute3 in varchar2 default hr_api.g_varchar2
626: ,p_attribute4 in varchar2 default hr_api.g_varchar2
627: ,p_attribute5 in varchar2 default hr_api.g_varchar2
628: ,p_attribute6 in varchar2 default hr_api.g_varchar2
629: ,p_attribute7 in varchar2 default hr_api.g_varchar2
630: ,p_attribute8 in varchar2 default hr_api.g_varchar2
631: ,p_attribute9 in varchar2 default hr_api.g_varchar2
624: ,p_attribute2 in varchar2 default hr_api.g_varchar2
625: ,p_attribute3 in varchar2 default hr_api.g_varchar2
626: ,p_attribute4 in varchar2 default hr_api.g_varchar2
627: ,p_attribute5 in varchar2 default hr_api.g_varchar2
628: ,p_attribute6 in varchar2 default hr_api.g_varchar2
629: ,p_attribute7 in varchar2 default hr_api.g_varchar2
630: ,p_attribute8 in varchar2 default hr_api.g_varchar2
631: ,p_attribute9 in varchar2 default hr_api.g_varchar2
632: ,p_attribute10 in varchar2 default hr_api.g_varchar2
625: ,p_attribute3 in varchar2 default hr_api.g_varchar2
626: ,p_attribute4 in varchar2 default hr_api.g_varchar2
627: ,p_attribute5 in varchar2 default hr_api.g_varchar2
628: ,p_attribute6 in varchar2 default hr_api.g_varchar2
629: ,p_attribute7 in varchar2 default hr_api.g_varchar2
630: ,p_attribute8 in varchar2 default hr_api.g_varchar2
631: ,p_attribute9 in varchar2 default hr_api.g_varchar2
632: ,p_attribute10 in varchar2 default hr_api.g_varchar2
633: ,p_attribute11 in varchar2 default hr_api.g_varchar2
626: ,p_attribute4 in varchar2 default hr_api.g_varchar2
627: ,p_attribute5 in varchar2 default hr_api.g_varchar2
628: ,p_attribute6 in varchar2 default hr_api.g_varchar2
629: ,p_attribute7 in varchar2 default hr_api.g_varchar2
630: ,p_attribute8 in varchar2 default hr_api.g_varchar2
631: ,p_attribute9 in varchar2 default hr_api.g_varchar2
632: ,p_attribute10 in varchar2 default hr_api.g_varchar2
633: ,p_attribute11 in varchar2 default hr_api.g_varchar2
634: ,p_attribute12 in varchar2 default hr_api.g_varchar2
627: ,p_attribute5 in varchar2 default hr_api.g_varchar2
628: ,p_attribute6 in varchar2 default hr_api.g_varchar2
629: ,p_attribute7 in varchar2 default hr_api.g_varchar2
630: ,p_attribute8 in varchar2 default hr_api.g_varchar2
631: ,p_attribute9 in varchar2 default hr_api.g_varchar2
632: ,p_attribute10 in varchar2 default hr_api.g_varchar2
633: ,p_attribute11 in varchar2 default hr_api.g_varchar2
634: ,p_attribute12 in varchar2 default hr_api.g_varchar2
635: ,p_attribute13 in varchar2 default hr_api.g_varchar2
628: ,p_attribute6 in varchar2 default hr_api.g_varchar2
629: ,p_attribute7 in varchar2 default hr_api.g_varchar2
630: ,p_attribute8 in varchar2 default hr_api.g_varchar2
631: ,p_attribute9 in varchar2 default hr_api.g_varchar2
632: ,p_attribute10 in varchar2 default hr_api.g_varchar2
633: ,p_attribute11 in varchar2 default hr_api.g_varchar2
634: ,p_attribute12 in varchar2 default hr_api.g_varchar2
635: ,p_attribute13 in varchar2 default hr_api.g_varchar2
636: ,p_attribute14 in varchar2 default hr_api.g_varchar2
629: ,p_attribute7 in varchar2 default hr_api.g_varchar2
630: ,p_attribute8 in varchar2 default hr_api.g_varchar2
631: ,p_attribute9 in varchar2 default hr_api.g_varchar2
632: ,p_attribute10 in varchar2 default hr_api.g_varchar2
633: ,p_attribute11 in varchar2 default hr_api.g_varchar2
634: ,p_attribute12 in varchar2 default hr_api.g_varchar2
635: ,p_attribute13 in varchar2 default hr_api.g_varchar2
636: ,p_attribute14 in varchar2 default hr_api.g_varchar2
637: ,p_attribute15 in varchar2 default hr_api.g_varchar2
630: ,p_attribute8 in varchar2 default hr_api.g_varchar2
631: ,p_attribute9 in varchar2 default hr_api.g_varchar2
632: ,p_attribute10 in varchar2 default hr_api.g_varchar2
633: ,p_attribute11 in varchar2 default hr_api.g_varchar2
634: ,p_attribute12 in varchar2 default hr_api.g_varchar2
635: ,p_attribute13 in varchar2 default hr_api.g_varchar2
636: ,p_attribute14 in varchar2 default hr_api.g_varchar2
637: ,p_attribute15 in varchar2 default hr_api.g_varchar2
638: ,p_attribute16 in varchar2 default hr_api.g_varchar2
631: ,p_attribute9 in varchar2 default hr_api.g_varchar2
632: ,p_attribute10 in varchar2 default hr_api.g_varchar2
633: ,p_attribute11 in varchar2 default hr_api.g_varchar2
634: ,p_attribute12 in varchar2 default hr_api.g_varchar2
635: ,p_attribute13 in varchar2 default hr_api.g_varchar2
636: ,p_attribute14 in varchar2 default hr_api.g_varchar2
637: ,p_attribute15 in varchar2 default hr_api.g_varchar2
638: ,p_attribute16 in varchar2 default hr_api.g_varchar2
639: ,p_attribute17 in varchar2 default hr_api.g_varchar2
632: ,p_attribute10 in varchar2 default hr_api.g_varchar2
633: ,p_attribute11 in varchar2 default hr_api.g_varchar2
634: ,p_attribute12 in varchar2 default hr_api.g_varchar2
635: ,p_attribute13 in varchar2 default hr_api.g_varchar2
636: ,p_attribute14 in varchar2 default hr_api.g_varchar2
637: ,p_attribute15 in varchar2 default hr_api.g_varchar2
638: ,p_attribute16 in varchar2 default hr_api.g_varchar2
639: ,p_attribute17 in varchar2 default hr_api.g_varchar2
640: ,p_attribute18 in varchar2 default hr_api.g_varchar2
633: ,p_attribute11 in varchar2 default hr_api.g_varchar2
634: ,p_attribute12 in varchar2 default hr_api.g_varchar2
635: ,p_attribute13 in varchar2 default hr_api.g_varchar2
636: ,p_attribute14 in varchar2 default hr_api.g_varchar2
637: ,p_attribute15 in varchar2 default hr_api.g_varchar2
638: ,p_attribute16 in varchar2 default hr_api.g_varchar2
639: ,p_attribute17 in varchar2 default hr_api.g_varchar2
640: ,p_attribute18 in varchar2 default hr_api.g_varchar2
641: ,p_attribute19 in varchar2 default hr_api.g_varchar2
634: ,p_attribute12 in varchar2 default hr_api.g_varchar2
635: ,p_attribute13 in varchar2 default hr_api.g_varchar2
636: ,p_attribute14 in varchar2 default hr_api.g_varchar2
637: ,p_attribute15 in varchar2 default hr_api.g_varchar2
638: ,p_attribute16 in varchar2 default hr_api.g_varchar2
639: ,p_attribute17 in varchar2 default hr_api.g_varchar2
640: ,p_attribute18 in varchar2 default hr_api.g_varchar2
641: ,p_attribute19 in varchar2 default hr_api.g_varchar2
642: ,p_attribute20 in varchar2 default hr_api.g_varchar2
635: ,p_attribute13 in varchar2 default hr_api.g_varchar2
636: ,p_attribute14 in varchar2 default hr_api.g_varchar2
637: ,p_attribute15 in varchar2 default hr_api.g_varchar2
638: ,p_attribute16 in varchar2 default hr_api.g_varchar2
639: ,p_attribute17 in varchar2 default hr_api.g_varchar2
640: ,p_attribute18 in varchar2 default hr_api.g_varchar2
641: ,p_attribute19 in varchar2 default hr_api.g_varchar2
642: ,p_attribute20 in varchar2 default hr_api.g_varchar2
643: ,p_attribute21 in varchar2 default hr_api.g_varchar2
636: ,p_attribute14 in varchar2 default hr_api.g_varchar2
637: ,p_attribute15 in varchar2 default hr_api.g_varchar2
638: ,p_attribute16 in varchar2 default hr_api.g_varchar2
639: ,p_attribute17 in varchar2 default hr_api.g_varchar2
640: ,p_attribute18 in varchar2 default hr_api.g_varchar2
641: ,p_attribute19 in varchar2 default hr_api.g_varchar2
642: ,p_attribute20 in varchar2 default hr_api.g_varchar2
643: ,p_attribute21 in varchar2 default hr_api.g_varchar2
644: ,p_attribute22 in varchar2 default hr_api.g_varchar2
637: ,p_attribute15 in varchar2 default hr_api.g_varchar2
638: ,p_attribute16 in varchar2 default hr_api.g_varchar2
639: ,p_attribute17 in varchar2 default hr_api.g_varchar2
640: ,p_attribute18 in varchar2 default hr_api.g_varchar2
641: ,p_attribute19 in varchar2 default hr_api.g_varchar2
642: ,p_attribute20 in varchar2 default hr_api.g_varchar2
643: ,p_attribute21 in varchar2 default hr_api.g_varchar2
644: ,p_attribute22 in varchar2 default hr_api.g_varchar2
645: ,p_attribute23 in varchar2 default hr_api.g_varchar2
638: ,p_attribute16 in varchar2 default hr_api.g_varchar2
639: ,p_attribute17 in varchar2 default hr_api.g_varchar2
640: ,p_attribute18 in varchar2 default hr_api.g_varchar2
641: ,p_attribute19 in varchar2 default hr_api.g_varchar2
642: ,p_attribute20 in varchar2 default hr_api.g_varchar2
643: ,p_attribute21 in varchar2 default hr_api.g_varchar2
644: ,p_attribute22 in varchar2 default hr_api.g_varchar2
645: ,p_attribute23 in varchar2 default hr_api.g_varchar2
646: ,p_attribute24 in varchar2 default hr_api.g_varchar2
639: ,p_attribute17 in varchar2 default hr_api.g_varchar2
640: ,p_attribute18 in varchar2 default hr_api.g_varchar2
641: ,p_attribute19 in varchar2 default hr_api.g_varchar2
642: ,p_attribute20 in varchar2 default hr_api.g_varchar2
643: ,p_attribute21 in varchar2 default hr_api.g_varchar2
644: ,p_attribute22 in varchar2 default hr_api.g_varchar2
645: ,p_attribute23 in varchar2 default hr_api.g_varchar2
646: ,p_attribute24 in varchar2 default hr_api.g_varchar2
647: ,p_attribute25 in varchar2 default hr_api.g_varchar2
640: ,p_attribute18 in varchar2 default hr_api.g_varchar2
641: ,p_attribute19 in varchar2 default hr_api.g_varchar2
642: ,p_attribute20 in varchar2 default hr_api.g_varchar2
643: ,p_attribute21 in varchar2 default hr_api.g_varchar2
644: ,p_attribute22 in varchar2 default hr_api.g_varchar2
645: ,p_attribute23 in varchar2 default hr_api.g_varchar2
646: ,p_attribute24 in varchar2 default hr_api.g_varchar2
647: ,p_attribute25 in varchar2 default hr_api.g_varchar2
648: ,p_attribute26 in varchar2 default hr_api.g_varchar2
641: ,p_attribute19 in varchar2 default hr_api.g_varchar2
642: ,p_attribute20 in varchar2 default hr_api.g_varchar2
643: ,p_attribute21 in varchar2 default hr_api.g_varchar2
644: ,p_attribute22 in varchar2 default hr_api.g_varchar2
645: ,p_attribute23 in varchar2 default hr_api.g_varchar2
646: ,p_attribute24 in varchar2 default hr_api.g_varchar2
647: ,p_attribute25 in varchar2 default hr_api.g_varchar2
648: ,p_attribute26 in varchar2 default hr_api.g_varchar2
649: ,p_attribute27 in varchar2 default hr_api.g_varchar2
642: ,p_attribute20 in varchar2 default hr_api.g_varchar2
643: ,p_attribute21 in varchar2 default hr_api.g_varchar2
644: ,p_attribute22 in varchar2 default hr_api.g_varchar2
645: ,p_attribute23 in varchar2 default hr_api.g_varchar2
646: ,p_attribute24 in varchar2 default hr_api.g_varchar2
647: ,p_attribute25 in varchar2 default hr_api.g_varchar2
648: ,p_attribute26 in varchar2 default hr_api.g_varchar2
649: ,p_attribute27 in varchar2 default hr_api.g_varchar2
650: ,p_attribute28 in varchar2 default hr_api.g_varchar2
643: ,p_attribute21 in varchar2 default hr_api.g_varchar2
644: ,p_attribute22 in varchar2 default hr_api.g_varchar2
645: ,p_attribute23 in varchar2 default hr_api.g_varchar2
646: ,p_attribute24 in varchar2 default hr_api.g_varchar2
647: ,p_attribute25 in varchar2 default hr_api.g_varchar2
648: ,p_attribute26 in varchar2 default hr_api.g_varchar2
649: ,p_attribute27 in varchar2 default hr_api.g_varchar2
650: ,p_attribute28 in varchar2 default hr_api.g_varchar2
651: ,p_attribute29 in varchar2 default hr_api.g_varchar2
644: ,p_attribute22 in varchar2 default hr_api.g_varchar2
645: ,p_attribute23 in varchar2 default hr_api.g_varchar2
646: ,p_attribute24 in varchar2 default hr_api.g_varchar2
647: ,p_attribute25 in varchar2 default hr_api.g_varchar2
648: ,p_attribute26 in varchar2 default hr_api.g_varchar2
649: ,p_attribute27 in varchar2 default hr_api.g_varchar2
650: ,p_attribute28 in varchar2 default hr_api.g_varchar2
651: ,p_attribute29 in varchar2 default hr_api.g_varchar2
652: ,p_attribute30 in varchar2 default hr_api.g_varchar2
645: ,p_attribute23 in varchar2 default hr_api.g_varchar2
646: ,p_attribute24 in varchar2 default hr_api.g_varchar2
647: ,p_attribute25 in varchar2 default hr_api.g_varchar2
648: ,p_attribute26 in varchar2 default hr_api.g_varchar2
649: ,p_attribute27 in varchar2 default hr_api.g_varchar2
650: ,p_attribute28 in varchar2 default hr_api.g_varchar2
651: ,p_attribute29 in varchar2 default hr_api.g_varchar2
652: ,p_attribute30 in varchar2 default hr_api.g_varchar2
653: ) is
646: ,p_attribute24 in varchar2 default hr_api.g_varchar2
647: ,p_attribute25 in varchar2 default hr_api.g_varchar2
648: ,p_attribute26 in varchar2 default hr_api.g_varchar2
649: ,p_attribute27 in varchar2 default hr_api.g_varchar2
650: ,p_attribute28 in varchar2 default hr_api.g_varchar2
651: ,p_attribute29 in varchar2 default hr_api.g_varchar2
652: ,p_attribute30 in varchar2 default hr_api.g_varchar2
653: ) is
654: --
647: ,p_attribute25 in varchar2 default hr_api.g_varchar2
648: ,p_attribute26 in varchar2 default hr_api.g_varchar2
649: ,p_attribute27 in varchar2 default hr_api.g_varchar2
650: ,p_attribute28 in varchar2 default hr_api.g_varchar2
651: ,p_attribute29 in varchar2 default hr_api.g_varchar2
652: ,p_attribute30 in varchar2 default hr_api.g_varchar2
653: ) is
654: --
655: l_rec per_psh_shd.g_rec_type;
648: ,p_attribute26 in varchar2 default hr_api.g_varchar2
649: ,p_attribute27 in varchar2 default hr_api.g_varchar2
650: ,p_attribute28 in varchar2 default hr_api.g_varchar2
651: ,p_attribute29 in varchar2 default hr_api.g_varchar2
652: ,p_attribute30 in varchar2 default hr_api.g_varchar2
653: ) is
654: --
655: l_rec per_psh_shd.g_rec_type;
656: l_proc varchar2(72) := g_package||'upd';