APPS.PER_ECO_UPD dependencies on HR_API

Line 127: When hr_api.check_integrity_violated Then

123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: per_eco_shd.g_api_dml := false; -- Unset the api dml status
130: per_eco_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: per_eco_shd.g_api_dml := false; -- Unset the api dml status
130: per_eco_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_eco_shd.g_api_dml := false; -- Unset the api dml status
135: per_eco_shd.constraint_error

Line 132: When hr_api.parent_integrity_violated Then

128: -- A check constraint has been violated
129: per_eco_shd.g_api_dml := false; -- Unset the api dml status
130: per_eco_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_eco_shd.g_api_dml := false; -- Unset the api dml status
135: per_eco_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_eco_shd.g_api_dml := false; -- Unset the api dml status
135: per_eco_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_eco_shd.g_api_dml := false; -- Unset the api dml status
140: per_eco_shd.constraint_error

Line 137: When hr_api.unique_integrity_violated Then

133: -- Parent integrity has been violated
134: per_eco_shd.g_api_dml := false; -- Unset the api dml status
135: per_eco_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_eco_shd.g_api_dml := false; -- Unset the api dml status
140: per_eco_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_eco_shd.g_api_dml := false; -- Unset the api dml status
140: per_eco_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: per_eco_shd.g_api_dml := false; -- Unset the api dml status
144: Raise;
145: End update_dml;

Line 382: when hr_api.cannot_find_prog_unit then

378: );
379: --
380: exception
381: --
382: when hr_api.cannot_find_prog_unit then
383: --
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'PER_ELECTION_CONSTITUENCYS'
386: ,p_hook_type => 'AU');

Line 384: hr_api.cannot_find_prog_unit_error

380: exception
381: --
382: when hr_api.cannot_find_prog_unit then
383: --
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'PER_ELECTION_CONSTITUENCYS'
386: ,p_hook_type => 'AU');
387: --
388: end;

Line 447: If (p_rec.election_id = hr_api.g_number) then

443: -- p_rec plsql record structure
444: -- to see if a system default is being used. If a system default
445: -- is being used then we must set to the 'current' argument value.
446: --
447: If (p_rec.election_id = hr_api.g_number) then
448: p_rec.election_id :=
449: per_eco_shd.g_old_rec.election_id;
450: End If;
451: If (p_rec.business_group_id = hr_api.g_number) then

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

447: If (p_rec.election_id = hr_api.g_number) then
448: p_rec.election_id :=
449: per_eco_shd.g_old_rec.election_id;
450: End If;
451: If (p_rec.business_group_id = hr_api.g_number) then
452: p_rec.business_group_id :=
453: per_eco_shd.g_old_rec.business_group_id;
454: End If;
455: If (p_rec.constituency_id = hr_api.g_number) then

Line 455: If (p_rec.constituency_id = hr_api.g_number) then

451: If (p_rec.business_group_id = hr_api.g_number) then
452: p_rec.business_group_id :=
453: per_eco_shd.g_old_rec.business_group_id;
454: End If;
455: If (p_rec.constituency_id = hr_api.g_number) then
456: p_rec.constituency_id :=
457: per_eco_shd.g_old_rec.constituency_id;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 459: If (p_rec.attribute_category = hr_api.g_varchar2) then

455: If (p_rec.constituency_id = hr_api.g_number) then
456: p_rec.constituency_id :=
457: per_eco_shd.g_old_rec.constituency_id;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: per_eco_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 463: If (p_rec.attribute1 = hr_api.g_varchar2) then

459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: per_eco_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: per_eco_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 467: If (p_rec.attribute2 = hr_api.g_varchar2) then

463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: per_eco_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: per_eco_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 471: If (p_rec.attribute3 = hr_api.g_varchar2) then

467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: per_eco_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: per_eco_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 475: If (p_rec.attribute4 = hr_api.g_varchar2) then

471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: per_eco_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: per_eco_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 479: If (p_rec.attribute5 = hr_api.g_varchar2) then

475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: per_eco_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: per_eco_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 483: If (p_rec.attribute6 = hr_api.g_varchar2) then

479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: per_eco_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: per_eco_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 487: If (p_rec.attribute7 = hr_api.g_varchar2) then

483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: per_eco_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: per_eco_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 491: If (p_rec.attribute8 = hr_api.g_varchar2) then

487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: per_eco_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: per_eco_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 495: If (p_rec.attribute9 = hr_api.g_varchar2) then

491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: per_eco_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: per_eco_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 499: If (p_rec.attribute10 = hr_api.g_varchar2) then

495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: per_eco_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: per_eco_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 503: If (p_rec.attribute11 = hr_api.g_varchar2) then

499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: per_eco_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: per_eco_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 507: If (p_rec.attribute12 = hr_api.g_varchar2) then

503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: per_eco_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: per_eco_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 511: If (p_rec.attribute13 = hr_api.g_varchar2) then

507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: per_eco_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: per_eco_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 515: If (p_rec.attribute14 = hr_api.g_varchar2) then

511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: per_eco_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: per_eco_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 519: If (p_rec.attribute15 = hr_api.g_varchar2) then

515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: per_eco_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: per_eco_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 523: If (p_rec.attribute16 = hr_api.g_varchar2) then

519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: per_eco_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: per_eco_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 527: If (p_rec.attribute17 = hr_api.g_varchar2) then

523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: per_eco_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: per_eco_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 531: If (p_rec.attribute18 = hr_api.g_varchar2) then

527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: per_eco_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: per_eco_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 535: If (p_rec.attribute19 = hr_api.g_varchar2) then

531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: per_eco_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: per_eco_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 539: If (p_rec.attribute20 = hr_api.g_varchar2) then

535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: per_eco_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: per_eco_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 543: If (p_rec.attribute21 = hr_api.g_varchar2) then

539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: per_eco_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.attribute21 = hr_api.g_varchar2) then
544: p_rec.attribute21 :=
545: per_eco_shd.g_old_rec.attribute21;
546: End If;
547: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 547: If (p_rec.attribute22 = hr_api.g_varchar2) then

543: If (p_rec.attribute21 = hr_api.g_varchar2) then
544: p_rec.attribute21 :=
545: per_eco_shd.g_old_rec.attribute21;
546: End If;
547: If (p_rec.attribute22 = hr_api.g_varchar2) then
548: p_rec.attribute22 :=
549: per_eco_shd.g_old_rec.attribute22;
550: End If;
551: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 551: If (p_rec.attribute23 = hr_api.g_varchar2) then

547: If (p_rec.attribute22 = hr_api.g_varchar2) then
548: p_rec.attribute22 :=
549: per_eco_shd.g_old_rec.attribute22;
550: End If;
551: If (p_rec.attribute23 = hr_api.g_varchar2) then
552: p_rec.attribute23 :=
553: per_eco_shd.g_old_rec.attribute23;
554: End If;
555: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 555: If (p_rec.attribute24 = hr_api.g_varchar2) then

551: If (p_rec.attribute23 = hr_api.g_varchar2) then
552: p_rec.attribute23 :=
553: per_eco_shd.g_old_rec.attribute23;
554: End If;
555: If (p_rec.attribute24 = hr_api.g_varchar2) then
556: p_rec.attribute24 :=
557: per_eco_shd.g_old_rec.attribute24;
558: End If;
559: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 559: If (p_rec.attribute25 = hr_api.g_varchar2) then

555: If (p_rec.attribute24 = hr_api.g_varchar2) then
556: p_rec.attribute24 :=
557: per_eco_shd.g_old_rec.attribute24;
558: End If;
559: If (p_rec.attribute25 = hr_api.g_varchar2) then
560: p_rec.attribute25 :=
561: per_eco_shd.g_old_rec.attribute25;
562: End If;
563: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 563: If (p_rec.attribute26 = hr_api.g_varchar2) then

559: If (p_rec.attribute25 = hr_api.g_varchar2) then
560: p_rec.attribute25 :=
561: per_eco_shd.g_old_rec.attribute25;
562: End If;
563: If (p_rec.attribute26 = hr_api.g_varchar2) then
564: p_rec.attribute26 :=
565: per_eco_shd.g_old_rec.attribute26;
566: End If;
567: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 567: If (p_rec.attribute27 = hr_api.g_varchar2) then

563: If (p_rec.attribute26 = hr_api.g_varchar2) then
564: p_rec.attribute26 :=
565: per_eco_shd.g_old_rec.attribute26;
566: End If;
567: If (p_rec.attribute27 = hr_api.g_varchar2) then
568: p_rec.attribute27 :=
569: per_eco_shd.g_old_rec.attribute27;
570: End If;
571: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 571: If (p_rec.attribute28 = hr_api.g_varchar2) then

567: If (p_rec.attribute27 = hr_api.g_varchar2) then
568: p_rec.attribute27 :=
569: per_eco_shd.g_old_rec.attribute27;
570: End If;
571: If (p_rec.attribute28 = hr_api.g_varchar2) then
572: p_rec.attribute28 :=
573: per_eco_shd.g_old_rec.attribute28;
574: End If;
575: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 575: If (p_rec.attribute29 = hr_api.g_varchar2) then

571: If (p_rec.attribute28 = hr_api.g_varchar2) then
572: p_rec.attribute28 :=
573: per_eco_shd.g_old_rec.attribute28;
574: End If;
575: If (p_rec.attribute29 = hr_api.g_varchar2) then
576: p_rec.attribute29 :=
577: per_eco_shd.g_old_rec.attribute29;
578: End If;
579: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 579: If (p_rec.attribute30 = hr_api.g_varchar2) then

575: If (p_rec.attribute29 = hr_api.g_varchar2) then
576: p_rec.attribute29 :=
577: per_eco_shd.g_old_rec.attribute29;
578: End If;
579: If (p_rec.attribute30 = hr_api.g_varchar2) then
580: p_rec.attribute30 :=
581: per_eco_shd.g_old_rec.attribute30;
582: End If;
583: --

Line 646: Raise HR_Api.Validate_Enabled;

642: --
643: -- If we are validating then raise the Validate_Enabled exception
644: --
645: If p_validate then
646: Raise HR_Api.Validate_Enabled;
647: End If;
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: Exception

Line 651: When HR_Api.Validate_Enabled Then

647: End If;
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: Exception
651: When HR_Api.Validate_Enabled Then
652: --
653: -- As the Validate_Enabled exception has been raised
654: -- we must rollback to the savepoint
655: --

Line 668: ,p_election_id in number default hr_api.g_number

664: (p_effective_date in date
665: ,p_election_constituency_id in out nocopy number
666: ,p_object_version_number in out nocopy number
667: ,p_validate in boolean default false
668: ,p_election_id in number default hr_api.g_number
669: ,p_business_group_id in number default hr_api.g_number
670: ,p_constituency_id in number default hr_api.g_number
671: ,p_attribute_category in varchar2 default hr_api.g_varchar2
672: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 669: ,p_business_group_id in number default hr_api.g_number

665: ,p_election_constituency_id in out nocopy number
666: ,p_object_version_number in out nocopy number
667: ,p_validate in boolean default false
668: ,p_election_id in number default hr_api.g_number
669: ,p_business_group_id in number default hr_api.g_number
670: ,p_constituency_id in number default hr_api.g_number
671: ,p_attribute_category in varchar2 default hr_api.g_varchar2
672: ,p_attribute1 in varchar2 default hr_api.g_varchar2
673: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 670: ,p_constituency_id in number default hr_api.g_number

666: ,p_object_version_number in out nocopy number
667: ,p_validate in boolean default false
668: ,p_election_id in number default hr_api.g_number
669: ,p_business_group_id in number default hr_api.g_number
670: ,p_constituency_id in number default hr_api.g_number
671: ,p_attribute_category in varchar2 default hr_api.g_varchar2
672: ,p_attribute1 in varchar2 default hr_api.g_varchar2
673: ,p_attribute2 in varchar2 default hr_api.g_varchar2
674: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 671: ,p_attribute_category in varchar2 default hr_api.g_varchar2

667: ,p_validate in boolean default false
668: ,p_election_id in number default hr_api.g_number
669: ,p_business_group_id in number default hr_api.g_number
670: ,p_constituency_id in number default hr_api.g_number
671: ,p_attribute_category in varchar2 default hr_api.g_varchar2
672: ,p_attribute1 in varchar2 default hr_api.g_varchar2
673: ,p_attribute2 in varchar2 default hr_api.g_varchar2
674: ,p_attribute3 in varchar2 default hr_api.g_varchar2
675: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 672: ,p_attribute1 in varchar2 default hr_api.g_varchar2

668: ,p_election_id in number default hr_api.g_number
669: ,p_business_group_id in number default hr_api.g_number
670: ,p_constituency_id in number default hr_api.g_number
671: ,p_attribute_category in varchar2 default hr_api.g_varchar2
672: ,p_attribute1 in varchar2 default hr_api.g_varchar2
673: ,p_attribute2 in varchar2 default hr_api.g_varchar2
674: ,p_attribute3 in varchar2 default hr_api.g_varchar2
675: ,p_attribute4 in varchar2 default hr_api.g_varchar2
676: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 673: ,p_attribute2 in varchar2 default hr_api.g_varchar2

669: ,p_business_group_id in number default hr_api.g_number
670: ,p_constituency_id in number default hr_api.g_number
671: ,p_attribute_category in varchar2 default hr_api.g_varchar2
672: ,p_attribute1 in varchar2 default hr_api.g_varchar2
673: ,p_attribute2 in varchar2 default hr_api.g_varchar2
674: ,p_attribute3 in varchar2 default hr_api.g_varchar2
675: ,p_attribute4 in varchar2 default hr_api.g_varchar2
676: ,p_attribute5 in varchar2 default hr_api.g_varchar2
677: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 674: ,p_attribute3 in varchar2 default hr_api.g_varchar2

670: ,p_constituency_id in number default hr_api.g_number
671: ,p_attribute_category in varchar2 default hr_api.g_varchar2
672: ,p_attribute1 in varchar2 default hr_api.g_varchar2
673: ,p_attribute2 in varchar2 default hr_api.g_varchar2
674: ,p_attribute3 in varchar2 default hr_api.g_varchar2
675: ,p_attribute4 in varchar2 default hr_api.g_varchar2
676: ,p_attribute5 in varchar2 default hr_api.g_varchar2
677: ,p_attribute6 in varchar2 default hr_api.g_varchar2
678: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 675: ,p_attribute4 in varchar2 default hr_api.g_varchar2

671: ,p_attribute_category in varchar2 default hr_api.g_varchar2
672: ,p_attribute1 in varchar2 default hr_api.g_varchar2
673: ,p_attribute2 in varchar2 default hr_api.g_varchar2
674: ,p_attribute3 in varchar2 default hr_api.g_varchar2
675: ,p_attribute4 in varchar2 default hr_api.g_varchar2
676: ,p_attribute5 in varchar2 default hr_api.g_varchar2
677: ,p_attribute6 in varchar2 default hr_api.g_varchar2
678: ,p_attribute7 in varchar2 default hr_api.g_varchar2
679: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 676: ,p_attribute5 in varchar2 default hr_api.g_varchar2

672: ,p_attribute1 in varchar2 default hr_api.g_varchar2
673: ,p_attribute2 in varchar2 default hr_api.g_varchar2
674: ,p_attribute3 in varchar2 default hr_api.g_varchar2
675: ,p_attribute4 in varchar2 default hr_api.g_varchar2
676: ,p_attribute5 in varchar2 default hr_api.g_varchar2
677: ,p_attribute6 in varchar2 default hr_api.g_varchar2
678: ,p_attribute7 in varchar2 default hr_api.g_varchar2
679: ,p_attribute8 in varchar2 default hr_api.g_varchar2
680: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 677: ,p_attribute6 in varchar2 default hr_api.g_varchar2

673: ,p_attribute2 in varchar2 default hr_api.g_varchar2
674: ,p_attribute3 in varchar2 default hr_api.g_varchar2
675: ,p_attribute4 in varchar2 default hr_api.g_varchar2
676: ,p_attribute5 in varchar2 default hr_api.g_varchar2
677: ,p_attribute6 in varchar2 default hr_api.g_varchar2
678: ,p_attribute7 in varchar2 default hr_api.g_varchar2
679: ,p_attribute8 in varchar2 default hr_api.g_varchar2
680: ,p_attribute9 in varchar2 default hr_api.g_varchar2
681: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 678: ,p_attribute7 in varchar2 default hr_api.g_varchar2

674: ,p_attribute3 in varchar2 default hr_api.g_varchar2
675: ,p_attribute4 in varchar2 default hr_api.g_varchar2
676: ,p_attribute5 in varchar2 default hr_api.g_varchar2
677: ,p_attribute6 in varchar2 default hr_api.g_varchar2
678: ,p_attribute7 in varchar2 default hr_api.g_varchar2
679: ,p_attribute8 in varchar2 default hr_api.g_varchar2
680: ,p_attribute9 in varchar2 default hr_api.g_varchar2
681: ,p_attribute10 in varchar2 default hr_api.g_varchar2
682: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 679: ,p_attribute8 in varchar2 default hr_api.g_varchar2

675: ,p_attribute4 in varchar2 default hr_api.g_varchar2
676: ,p_attribute5 in varchar2 default hr_api.g_varchar2
677: ,p_attribute6 in varchar2 default hr_api.g_varchar2
678: ,p_attribute7 in varchar2 default hr_api.g_varchar2
679: ,p_attribute8 in varchar2 default hr_api.g_varchar2
680: ,p_attribute9 in varchar2 default hr_api.g_varchar2
681: ,p_attribute10 in varchar2 default hr_api.g_varchar2
682: ,p_attribute11 in varchar2 default hr_api.g_varchar2
683: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 680: ,p_attribute9 in varchar2 default hr_api.g_varchar2

676: ,p_attribute5 in varchar2 default hr_api.g_varchar2
677: ,p_attribute6 in varchar2 default hr_api.g_varchar2
678: ,p_attribute7 in varchar2 default hr_api.g_varchar2
679: ,p_attribute8 in varchar2 default hr_api.g_varchar2
680: ,p_attribute9 in varchar2 default hr_api.g_varchar2
681: ,p_attribute10 in varchar2 default hr_api.g_varchar2
682: ,p_attribute11 in varchar2 default hr_api.g_varchar2
683: ,p_attribute12 in varchar2 default hr_api.g_varchar2
684: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 681: ,p_attribute10 in varchar2 default hr_api.g_varchar2

677: ,p_attribute6 in varchar2 default hr_api.g_varchar2
678: ,p_attribute7 in varchar2 default hr_api.g_varchar2
679: ,p_attribute8 in varchar2 default hr_api.g_varchar2
680: ,p_attribute9 in varchar2 default hr_api.g_varchar2
681: ,p_attribute10 in varchar2 default hr_api.g_varchar2
682: ,p_attribute11 in varchar2 default hr_api.g_varchar2
683: ,p_attribute12 in varchar2 default hr_api.g_varchar2
684: ,p_attribute13 in varchar2 default hr_api.g_varchar2
685: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 682: ,p_attribute11 in varchar2 default hr_api.g_varchar2

678: ,p_attribute7 in varchar2 default hr_api.g_varchar2
679: ,p_attribute8 in varchar2 default hr_api.g_varchar2
680: ,p_attribute9 in varchar2 default hr_api.g_varchar2
681: ,p_attribute10 in varchar2 default hr_api.g_varchar2
682: ,p_attribute11 in varchar2 default hr_api.g_varchar2
683: ,p_attribute12 in varchar2 default hr_api.g_varchar2
684: ,p_attribute13 in varchar2 default hr_api.g_varchar2
685: ,p_attribute14 in varchar2 default hr_api.g_varchar2
686: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 683: ,p_attribute12 in varchar2 default hr_api.g_varchar2

679: ,p_attribute8 in varchar2 default hr_api.g_varchar2
680: ,p_attribute9 in varchar2 default hr_api.g_varchar2
681: ,p_attribute10 in varchar2 default hr_api.g_varchar2
682: ,p_attribute11 in varchar2 default hr_api.g_varchar2
683: ,p_attribute12 in varchar2 default hr_api.g_varchar2
684: ,p_attribute13 in varchar2 default hr_api.g_varchar2
685: ,p_attribute14 in varchar2 default hr_api.g_varchar2
686: ,p_attribute15 in varchar2 default hr_api.g_varchar2
687: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 684: ,p_attribute13 in varchar2 default hr_api.g_varchar2

680: ,p_attribute9 in varchar2 default hr_api.g_varchar2
681: ,p_attribute10 in varchar2 default hr_api.g_varchar2
682: ,p_attribute11 in varchar2 default hr_api.g_varchar2
683: ,p_attribute12 in varchar2 default hr_api.g_varchar2
684: ,p_attribute13 in varchar2 default hr_api.g_varchar2
685: ,p_attribute14 in varchar2 default hr_api.g_varchar2
686: ,p_attribute15 in varchar2 default hr_api.g_varchar2
687: ,p_attribute16 in varchar2 default hr_api.g_varchar2
688: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 685: ,p_attribute14 in varchar2 default hr_api.g_varchar2

681: ,p_attribute10 in varchar2 default hr_api.g_varchar2
682: ,p_attribute11 in varchar2 default hr_api.g_varchar2
683: ,p_attribute12 in varchar2 default hr_api.g_varchar2
684: ,p_attribute13 in varchar2 default hr_api.g_varchar2
685: ,p_attribute14 in varchar2 default hr_api.g_varchar2
686: ,p_attribute15 in varchar2 default hr_api.g_varchar2
687: ,p_attribute16 in varchar2 default hr_api.g_varchar2
688: ,p_attribute17 in varchar2 default hr_api.g_varchar2
689: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 686: ,p_attribute15 in varchar2 default hr_api.g_varchar2

682: ,p_attribute11 in varchar2 default hr_api.g_varchar2
683: ,p_attribute12 in varchar2 default hr_api.g_varchar2
684: ,p_attribute13 in varchar2 default hr_api.g_varchar2
685: ,p_attribute14 in varchar2 default hr_api.g_varchar2
686: ,p_attribute15 in varchar2 default hr_api.g_varchar2
687: ,p_attribute16 in varchar2 default hr_api.g_varchar2
688: ,p_attribute17 in varchar2 default hr_api.g_varchar2
689: ,p_attribute18 in varchar2 default hr_api.g_varchar2
690: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 687: ,p_attribute16 in varchar2 default hr_api.g_varchar2

683: ,p_attribute12 in varchar2 default hr_api.g_varchar2
684: ,p_attribute13 in varchar2 default hr_api.g_varchar2
685: ,p_attribute14 in varchar2 default hr_api.g_varchar2
686: ,p_attribute15 in varchar2 default hr_api.g_varchar2
687: ,p_attribute16 in varchar2 default hr_api.g_varchar2
688: ,p_attribute17 in varchar2 default hr_api.g_varchar2
689: ,p_attribute18 in varchar2 default hr_api.g_varchar2
690: ,p_attribute19 in varchar2 default hr_api.g_varchar2
691: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 688: ,p_attribute17 in varchar2 default hr_api.g_varchar2

684: ,p_attribute13 in varchar2 default hr_api.g_varchar2
685: ,p_attribute14 in varchar2 default hr_api.g_varchar2
686: ,p_attribute15 in varchar2 default hr_api.g_varchar2
687: ,p_attribute16 in varchar2 default hr_api.g_varchar2
688: ,p_attribute17 in varchar2 default hr_api.g_varchar2
689: ,p_attribute18 in varchar2 default hr_api.g_varchar2
690: ,p_attribute19 in varchar2 default hr_api.g_varchar2
691: ,p_attribute20 in varchar2 default hr_api.g_varchar2
692: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 689: ,p_attribute18 in varchar2 default hr_api.g_varchar2

685: ,p_attribute14 in varchar2 default hr_api.g_varchar2
686: ,p_attribute15 in varchar2 default hr_api.g_varchar2
687: ,p_attribute16 in varchar2 default hr_api.g_varchar2
688: ,p_attribute17 in varchar2 default hr_api.g_varchar2
689: ,p_attribute18 in varchar2 default hr_api.g_varchar2
690: ,p_attribute19 in varchar2 default hr_api.g_varchar2
691: ,p_attribute20 in varchar2 default hr_api.g_varchar2
692: ,p_attribute21 in varchar2 default hr_api.g_varchar2
693: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 690: ,p_attribute19 in varchar2 default hr_api.g_varchar2

686: ,p_attribute15 in varchar2 default hr_api.g_varchar2
687: ,p_attribute16 in varchar2 default hr_api.g_varchar2
688: ,p_attribute17 in varchar2 default hr_api.g_varchar2
689: ,p_attribute18 in varchar2 default hr_api.g_varchar2
690: ,p_attribute19 in varchar2 default hr_api.g_varchar2
691: ,p_attribute20 in varchar2 default hr_api.g_varchar2
692: ,p_attribute21 in varchar2 default hr_api.g_varchar2
693: ,p_attribute22 in varchar2 default hr_api.g_varchar2
694: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 691: ,p_attribute20 in varchar2 default hr_api.g_varchar2

687: ,p_attribute16 in varchar2 default hr_api.g_varchar2
688: ,p_attribute17 in varchar2 default hr_api.g_varchar2
689: ,p_attribute18 in varchar2 default hr_api.g_varchar2
690: ,p_attribute19 in varchar2 default hr_api.g_varchar2
691: ,p_attribute20 in varchar2 default hr_api.g_varchar2
692: ,p_attribute21 in varchar2 default hr_api.g_varchar2
693: ,p_attribute22 in varchar2 default hr_api.g_varchar2
694: ,p_attribute23 in varchar2 default hr_api.g_varchar2
695: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 692: ,p_attribute21 in varchar2 default hr_api.g_varchar2

688: ,p_attribute17 in varchar2 default hr_api.g_varchar2
689: ,p_attribute18 in varchar2 default hr_api.g_varchar2
690: ,p_attribute19 in varchar2 default hr_api.g_varchar2
691: ,p_attribute20 in varchar2 default hr_api.g_varchar2
692: ,p_attribute21 in varchar2 default hr_api.g_varchar2
693: ,p_attribute22 in varchar2 default hr_api.g_varchar2
694: ,p_attribute23 in varchar2 default hr_api.g_varchar2
695: ,p_attribute24 in varchar2 default hr_api.g_varchar2
696: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 693: ,p_attribute22 in varchar2 default hr_api.g_varchar2

689: ,p_attribute18 in varchar2 default hr_api.g_varchar2
690: ,p_attribute19 in varchar2 default hr_api.g_varchar2
691: ,p_attribute20 in varchar2 default hr_api.g_varchar2
692: ,p_attribute21 in varchar2 default hr_api.g_varchar2
693: ,p_attribute22 in varchar2 default hr_api.g_varchar2
694: ,p_attribute23 in varchar2 default hr_api.g_varchar2
695: ,p_attribute24 in varchar2 default hr_api.g_varchar2
696: ,p_attribute25 in varchar2 default hr_api.g_varchar2
697: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 694: ,p_attribute23 in varchar2 default hr_api.g_varchar2

690: ,p_attribute19 in varchar2 default hr_api.g_varchar2
691: ,p_attribute20 in varchar2 default hr_api.g_varchar2
692: ,p_attribute21 in varchar2 default hr_api.g_varchar2
693: ,p_attribute22 in varchar2 default hr_api.g_varchar2
694: ,p_attribute23 in varchar2 default hr_api.g_varchar2
695: ,p_attribute24 in varchar2 default hr_api.g_varchar2
696: ,p_attribute25 in varchar2 default hr_api.g_varchar2
697: ,p_attribute26 in varchar2 default hr_api.g_varchar2
698: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 695: ,p_attribute24 in varchar2 default hr_api.g_varchar2

691: ,p_attribute20 in varchar2 default hr_api.g_varchar2
692: ,p_attribute21 in varchar2 default hr_api.g_varchar2
693: ,p_attribute22 in varchar2 default hr_api.g_varchar2
694: ,p_attribute23 in varchar2 default hr_api.g_varchar2
695: ,p_attribute24 in varchar2 default hr_api.g_varchar2
696: ,p_attribute25 in varchar2 default hr_api.g_varchar2
697: ,p_attribute26 in varchar2 default hr_api.g_varchar2
698: ,p_attribute27 in varchar2 default hr_api.g_varchar2
699: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 696: ,p_attribute25 in varchar2 default hr_api.g_varchar2

692: ,p_attribute21 in varchar2 default hr_api.g_varchar2
693: ,p_attribute22 in varchar2 default hr_api.g_varchar2
694: ,p_attribute23 in varchar2 default hr_api.g_varchar2
695: ,p_attribute24 in varchar2 default hr_api.g_varchar2
696: ,p_attribute25 in varchar2 default hr_api.g_varchar2
697: ,p_attribute26 in varchar2 default hr_api.g_varchar2
698: ,p_attribute27 in varchar2 default hr_api.g_varchar2
699: ,p_attribute28 in varchar2 default hr_api.g_varchar2
700: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 697: ,p_attribute26 in varchar2 default hr_api.g_varchar2

693: ,p_attribute22 in varchar2 default hr_api.g_varchar2
694: ,p_attribute23 in varchar2 default hr_api.g_varchar2
695: ,p_attribute24 in varchar2 default hr_api.g_varchar2
696: ,p_attribute25 in varchar2 default hr_api.g_varchar2
697: ,p_attribute26 in varchar2 default hr_api.g_varchar2
698: ,p_attribute27 in varchar2 default hr_api.g_varchar2
699: ,p_attribute28 in varchar2 default hr_api.g_varchar2
700: ,p_attribute29 in varchar2 default hr_api.g_varchar2
701: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 698: ,p_attribute27 in varchar2 default hr_api.g_varchar2

694: ,p_attribute23 in varchar2 default hr_api.g_varchar2
695: ,p_attribute24 in varchar2 default hr_api.g_varchar2
696: ,p_attribute25 in varchar2 default hr_api.g_varchar2
697: ,p_attribute26 in varchar2 default hr_api.g_varchar2
698: ,p_attribute27 in varchar2 default hr_api.g_varchar2
699: ,p_attribute28 in varchar2 default hr_api.g_varchar2
700: ,p_attribute29 in varchar2 default hr_api.g_varchar2
701: ,p_attribute30 in varchar2 default hr_api.g_varchar2
702: ) is

Line 699: ,p_attribute28 in varchar2 default hr_api.g_varchar2

695: ,p_attribute24 in varchar2 default hr_api.g_varchar2
696: ,p_attribute25 in varchar2 default hr_api.g_varchar2
697: ,p_attribute26 in varchar2 default hr_api.g_varchar2
698: ,p_attribute27 in varchar2 default hr_api.g_varchar2
699: ,p_attribute28 in varchar2 default hr_api.g_varchar2
700: ,p_attribute29 in varchar2 default hr_api.g_varchar2
701: ,p_attribute30 in varchar2 default hr_api.g_varchar2
702: ) is
703: --

Line 700: ,p_attribute29 in varchar2 default hr_api.g_varchar2

696: ,p_attribute25 in varchar2 default hr_api.g_varchar2
697: ,p_attribute26 in varchar2 default hr_api.g_varchar2
698: ,p_attribute27 in varchar2 default hr_api.g_varchar2
699: ,p_attribute28 in varchar2 default hr_api.g_varchar2
700: ,p_attribute29 in varchar2 default hr_api.g_varchar2
701: ,p_attribute30 in varchar2 default hr_api.g_varchar2
702: ) is
703: --
704: l_rec per_eco_shd.g_rec_type;

Line 701: ,p_attribute30 in varchar2 default hr_api.g_varchar2

697: ,p_attribute26 in varchar2 default hr_api.g_varchar2
698: ,p_attribute27 in varchar2 default hr_api.g_varchar2
699: ,p_attribute28 in varchar2 default hr_api.g_varchar2
700: ,p_attribute29 in varchar2 default hr_api.g_varchar2
701: ,p_attribute30 in varchar2 default hr_api.g_varchar2
702: ) is
703: --
704: l_rec per_eco_shd.g_rec_type;
705: l_proc varchar2(72) := g_package||'upd';