APPS.BEN_ECV_UPD dependencies on HR_API

Line 157: When hr_api.check_integrity_violated Then

153: End If;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 15);
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_ecv_shd.g_api_dml := false; --unset the api dml status
160: ben_ecv_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_ecv_shd.g_api_dml := false; --unset the api dml status
160: ben_ecv_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
165: ben_ecv_shd.constraint_error

Line 162: When hr_api.unique_integrity_violated Then

158: -- A check constraint has been violated
159: ben_ecv_shd.g_api_dml := false; --unset the api dml status
160: ben_ecv_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
165: ben_ecv_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
165: ben_ecv_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
170: End dt_update_dml;

Line 544: when hr_api.cannot_find_prog_unit then

540: );
541: --
542: exception
543: --
544: when hr_api.cannot_find_prog_unit then
545: --
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'ben_eligy_crit_values_f'
548: ,p_hook_type => 'AU'

Line 546: hr_api.cannot_find_prog_unit_error

542: exception
543: --
544: when hr_api.cannot_find_prog_unit then
545: --
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'ben_eligy_crit_values_f'
548: ,p_hook_type => 'AU'
549: );
550: --

Line 615: If (p_rec.eligy_prfl_id = hr_api.g_number) then

611: -- p_rec plsql record structure
612: -- to see if a system default is being used. If a system default
613: -- is being used then we must set to the 'current' argument value.
614: --
615: If (p_rec.eligy_prfl_id = hr_api.g_number) then
616: p_rec.eligy_prfl_id := ben_ecv_shd.g_old_rec.eligy_prfl_id;
617: end if;
618: If (p_rec.eligy_criteria_id = hr_api.g_number) then
619: p_rec.eligy_criteria_id := ben_ecv_shd.g_old_rec.eligy_criteria_id;

Line 618: If (p_rec.eligy_criteria_id = hr_api.g_number) then

614: --
615: If (p_rec.eligy_prfl_id = hr_api.g_number) then
616: p_rec.eligy_prfl_id := ben_ecv_shd.g_old_rec.eligy_prfl_id;
617: end if;
618: If (p_rec.eligy_criteria_id = hr_api.g_number) then
619: p_rec.eligy_criteria_id := ben_ecv_shd.g_old_rec.eligy_criteria_id;
620: end if;
621: If (p_rec.number_value1 = hr_api.g_number) then
622: p_rec.number_value1 := ben_ecv_shd.g_old_rec.number_value1;

Line 621: If (p_rec.number_value1 = hr_api.g_number) then

617: end if;
618: If (p_rec.eligy_criteria_id = hr_api.g_number) then
619: p_rec.eligy_criteria_id := ben_ecv_shd.g_old_rec.eligy_criteria_id;
620: end if;
621: If (p_rec.number_value1 = hr_api.g_number) then
622: p_rec.number_value1 := ben_ecv_shd.g_old_rec.number_value1;
623: end if;
624: If (p_rec.number_value2 = hr_api.g_number) then
625: p_rec.number_value2 := ben_ecv_shd.g_old_rec.number_value2;

Line 624: If (p_rec.number_value2 = hr_api.g_number) then

620: end if;
621: If (p_rec.number_value1 = hr_api.g_number) then
622: p_rec.number_value1 := ben_ecv_shd.g_old_rec.number_value1;
623: end if;
624: If (p_rec.number_value2 = hr_api.g_number) then
625: p_rec.number_value2 := ben_ecv_shd.g_old_rec.number_value2;
626: end if;
627: If (p_rec.char_value1 = hr_api.g_varchar2) then
628: p_rec.char_value1 := ben_ecv_shd.g_old_rec.char_value1;

Line 627: If (p_rec.char_value1 = hr_api.g_varchar2) then

623: end if;
624: If (p_rec.number_value2 = hr_api.g_number) then
625: p_rec.number_value2 := ben_ecv_shd.g_old_rec.number_value2;
626: end if;
627: If (p_rec.char_value1 = hr_api.g_varchar2) then
628: p_rec.char_value1 := ben_ecv_shd.g_old_rec.char_value1;
629: end if;
630: If (p_rec.char_value2 = hr_api.g_varchar2) then
631: p_rec.char_value2 := ben_ecv_shd.g_old_rec.char_value2;

Line 630: If (p_rec.char_value2 = hr_api.g_varchar2) then

626: end if;
627: If (p_rec.char_value1 = hr_api.g_varchar2) then
628: p_rec.char_value1 := ben_ecv_shd.g_old_rec.char_value1;
629: end if;
630: If (p_rec.char_value2 = hr_api.g_varchar2) then
631: p_rec.char_value2 := ben_ecv_shd.g_old_rec.char_value2;
632: end if;
633: If (p_rec.date_value1 = hr_api.g_date) then
634: p_rec.date_value1 := ben_ecv_shd.g_old_rec.date_value1;

Line 633: If (p_rec.date_value1 = hr_api.g_date) then

629: end if;
630: If (p_rec.char_value2 = hr_api.g_varchar2) then
631: p_rec.char_value2 := ben_ecv_shd.g_old_rec.char_value2;
632: end if;
633: If (p_rec.date_value1 = hr_api.g_date) then
634: p_rec.date_value1 := ben_ecv_shd.g_old_rec.date_value1;
635: end if;
636: If (p_rec.date_value2 = hr_api.g_date) then
637: p_rec.date_value2 := ben_ecv_shd.g_old_rec.date_value2;

Line 636: If (p_rec.date_value2 = hr_api.g_date) then

632: end if;
633: If (p_rec.date_value1 = hr_api.g_date) then
634: p_rec.date_value1 := ben_ecv_shd.g_old_rec.date_value1;
635: end if;
636: If (p_rec.date_value2 = hr_api.g_date) then
637: p_rec.date_value2 := ben_ecv_shd.g_old_rec.date_value2;
638: end if;
639: If (p_rec.excld_flag = hr_api.g_varchar2) then
640: p_rec.excld_flag := ben_ecv_shd.g_old_rec.excld_flag;

Line 639: If (p_rec.excld_flag = hr_api.g_varchar2) then

635: end if;
636: If (p_rec.date_value2 = hr_api.g_date) then
637: p_rec.date_value2 := ben_ecv_shd.g_old_rec.date_value2;
638: end if;
639: If (p_rec.excld_flag = hr_api.g_varchar2) then
640: p_rec.excld_flag := ben_ecv_shd.g_old_rec.excld_flag;
641: end if;
642: If (p_rec.business_group_id = hr_api.g_number) then
643: p_rec.business_group_id := ben_ecv_shd.g_old_rec.business_group_id;

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

638: end if;
639: If (p_rec.excld_flag = hr_api.g_varchar2) then
640: p_rec.excld_flag := ben_ecv_shd.g_old_rec.excld_flag;
641: end if;
642: If (p_rec.business_group_id = hr_api.g_number) then
643: p_rec.business_group_id := ben_ecv_shd.g_old_rec.business_group_id;
644: end if;
645: If (p_rec.legislation_code = hr_api.g_varchar2) then
646: p_rec.legislation_code := ben_ecv_shd.g_old_rec.legislation_code;

Line 645: If (p_rec.legislation_code = hr_api.g_varchar2) then

641: end if;
642: If (p_rec.business_group_id = hr_api.g_number) then
643: p_rec.business_group_id := ben_ecv_shd.g_old_rec.business_group_id;
644: end if;
645: If (p_rec.legislation_code = hr_api.g_varchar2) then
646: p_rec.legislation_code := ben_ecv_shd.g_old_rec.legislation_code;
647: end if;
648: If (p_rec.ecv_attribute_category = hr_api.g_varchar2) then
649: p_rec.ecv_attribute_category := ben_ecv_shd.g_old_rec.ecv_attribute_category;

Line 648: If (p_rec.ecv_attribute_category = hr_api.g_varchar2) then

644: end if;
645: If (p_rec.legislation_code = hr_api.g_varchar2) then
646: p_rec.legislation_code := ben_ecv_shd.g_old_rec.legislation_code;
647: end if;
648: If (p_rec.ecv_attribute_category = hr_api.g_varchar2) then
649: p_rec.ecv_attribute_category := ben_ecv_shd.g_old_rec.ecv_attribute_category;
650: end if;
651: If (p_rec.ecv_attribute1 = hr_api.g_varchar2) then
652: p_rec.ecv_attribute1 := ben_ecv_shd.g_old_rec.ecv_attribute1;

Line 651: If (p_rec.ecv_attribute1 = hr_api.g_varchar2) then

647: end if;
648: If (p_rec.ecv_attribute_category = hr_api.g_varchar2) then
649: p_rec.ecv_attribute_category := ben_ecv_shd.g_old_rec.ecv_attribute_category;
650: end if;
651: If (p_rec.ecv_attribute1 = hr_api.g_varchar2) then
652: p_rec.ecv_attribute1 := ben_ecv_shd.g_old_rec.ecv_attribute1;
653: end if;
654: If (p_rec.ecv_attribute2 = hr_api.g_varchar2) then
655: p_rec.ecv_attribute2 := ben_ecv_shd.g_old_rec.ecv_attribute2;

Line 654: If (p_rec.ecv_attribute2 = hr_api.g_varchar2) then

650: end if;
651: If (p_rec.ecv_attribute1 = hr_api.g_varchar2) then
652: p_rec.ecv_attribute1 := ben_ecv_shd.g_old_rec.ecv_attribute1;
653: end if;
654: If (p_rec.ecv_attribute2 = hr_api.g_varchar2) then
655: p_rec.ecv_attribute2 := ben_ecv_shd.g_old_rec.ecv_attribute2;
656: end if;
657: If (p_rec.ecv_attribute3 = hr_api.g_varchar2) then
658: p_rec.ecv_attribute3 := ben_ecv_shd.g_old_rec.ecv_attribute3;

Line 657: If (p_rec.ecv_attribute3 = hr_api.g_varchar2) then

653: end if;
654: If (p_rec.ecv_attribute2 = hr_api.g_varchar2) then
655: p_rec.ecv_attribute2 := ben_ecv_shd.g_old_rec.ecv_attribute2;
656: end if;
657: If (p_rec.ecv_attribute3 = hr_api.g_varchar2) then
658: p_rec.ecv_attribute3 := ben_ecv_shd.g_old_rec.ecv_attribute3;
659: end if;
660: If (p_rec.ecv_attribute4 = hr_api.g_varchar2) then
661: p_rec.ecv_attribute4 := ben_ecv_shd.g_old_rec.ecv_attribute4;

Line 660: If (p_rec.ecv_attribute4 = hr_api.g_varchar2) then

656: end if;
657: If (p_rec.ecv_attribute3 = hr_api.g_varchar2) then
658: p_rec.ecv_attribute3 := ben_ecv_shd.g_old_rec.ecv_attribute3;
659: end if;
660: If (p_rec.ecv_attribute4 = hr_api.g_varchar2) then
661: p_rec.ecv_attribute4 := ben_ecv_shd.g_old_rec.ecv_attribute4;
662: end if;
663: If (p_rec.ecv_attribute5 = hr_api.g_varchar2) then
664: p_rec.ecv_attribute5 := ben_ecv_shd.g_old_rec.ecv_attribute5;

Line 663: If (p_rec.ecv_attribute5 = hr_api.g_varchar2) then

659: end if;
660: If (p_rec.ecv_attribute4 = hr_api.g_varchar2) then
661: p_rec.ecv_attribute4 := ben_ecv_shd.g_old_rec.ecv_attribute4;
662: end if;
663: If (p_rec.ecv_attribute5 = hr_api.g_varchar2) then
664: p_rec.ecv_attribute5 := ben_ecv_shd.g_old_rec.ecv_attribute5;
665: end if;
666: If (p_rec.ecv_attribute6 = hr_api.g_varchar2) then
667: p_rec.ecv_attribute6 := ben_ecv_shd.g_old_rec.ecv_attribute6;

Line 666: If (p_rec.ecv_attribute6 = hr_api.g_varchar2) then

662: end if;
663: If (p_rec.ecv_attribute5 = hr_api.g_varchar2) then
664: p_rec.ecv_attribute5 := ben_ecv_shd.g_old_rec.ecv_attribute5;
665: end if;
666: If (p_rec.ecv_attribute6 = hr_api.g_varchar2) then
667: p_rec.ecv_attribute6 := ben_ecv_shd.g_old_rec.ecv_attribute6;
668: end if;
669: If (p_rec.ecv_attribute7 = hr_api.g_varchar2) then
670: p_rec.ecv_attribute7 := ben_ecv_shd.g_old_rec.ecv_attribute7;

Line 669: If (p_rec.ecv_attribute7 = hr_api.g_varchar2) then

665: end if;
666: If (p_rec.ecv_attribute6 = hr_api.g_varchar2) then
667: p_rec.ecv_attribute6 := ben_ecv_shd.g_old_rec.ecv_attribute6;
668: end if;
669: If (p_rec.ecv_attribute7 = hr_api.g_varchar2) then
670: p_rec.ecv_attribute7 := ben_ecv_shd.g_old_rec.ecv_attribute7;
671: end if;
672: If (p_rec.ecv_attribute8 = hr_api.g_varchar2) then
673: p_rec.ecv_attribute8 := ben_ecv_shd.g_old_rec.ecv_attribute8;

Line 672: If (p_rec.ecv_attribute8 = hr_api.g_varchar2) then

668: end if;
669: If (p_rec.ecv_attribute7 = hr_api.g_varchar2) then
670: p_rec.ecv_attribute7 := ben_ecv_shd.g_old_rec.ecv_attribute7;
671: end if;
672: If (p_rec.ecv_attribute8 = hr_api.g_varchar2) then
673: p_rec.ecv_attribute8 := ben_ecv_shd.g_old_rec.ecv_attribute8;
674: end if;
675: If (p_rec.ecv_attribute9 = hr_api.g_varchar2) then
676: p_rec.ecv_attribute9 := ben_ecv_shd.g_old_rec.ecv_attribute9;

Line 675: If (p_rec.ecv_attribute9 = hr_api.g_varchar2) then

671: end if;
672: If (p_rec.ecv_attribute8 = hr_api.g_varchar2) then
673: p_rec.ecv_attribute8 := ben_ecv_shd.g_old_rec.ecv_attribute8;
674: end if;
675: If (p_rec.ecv_attribute9 = hr_api.g_varchar2) then
676: p_rec.ecv_attribute9 := ben_ecv_shd.g_old_rec.ecv_attribute9;
677: end if;
678: If (p_rec.ecv_attribute10 = hr_api.g_varchar2) then
679: p_rec.ecv_attribute10 := ben_ecv_shd.g_old_rec.ecv_attribute10;

Line 678: If (p_rec.ecv_attribute10 = hr_api.g_varchar2) then

674: end if;
675: If (p_rec.ecv_attribute9 = hr_api.g_varchar2) then
676: p_rec.ecv_attribute9 := ben_ecv_shd.g_old_rec.ecv_attribute9;
677: end if;
678: If (p_rec.ecv_attribute10 = hr_api.g_varchar2) then
679: p_rec.ecv_attribute10 := ben_ecv_shd.g_old_rec.ecv_attribute10;
680: end if;
681: If (p_rec.ecv_attribute11 = hr_api.g_varchar2) then
682: p_rec.ecv_attribute11 := ben_ecv_shd.g_old_rec.ecv_attribute11;

Line 681: If (p_rec.ecv_attribute11 = hr_api.g_varchar2) then

677: end if;
678: If (p_rec.ecv_attribute10 = hr_api.g_varchar2) then
679: p_rec.ecv_attribute10 := ben_ecv_shd.g_old_rec.ecv_attribute10;
680: end if;
681: If (p_rec.ecv_attribute11 = hr_api.g_varchar2) then
682: p_rec.ecv_attribute11 := ben_ecv_shd.g_old_rec.ecv_attribute11;
683: end if;
684: If (p_rec.ecv_attribute12 = hr_api.g_varchar2) then
685: p_rec.ecv_attribute12 := ben_ecv_shd.g_old_rec.ecv_attribute12;

Line 684: If (p_rec.ecv_attribute12 = hr_api.g_varchar2) then

680: end if;
681: If (p_rec.ecv_attribute11 = hr_api.g_varchar2) then
682: p_rec.ecv_attribute11 := ben_ecv_shd.g_old_rec.ecv_attribute11;
683: end if;
684: If (p_rec.ecv_attribute12 = hr_api.g_varchar2) then
685: p_rec.ecv_attribute12 := ben_ecv_shd.g_old_rec.ecv_attribute12;
686: end if;
687: If (p_rec.ecv_attribute13 = hr_api.g_varchar2) then
688: p_rec.ecv_attribute13 := ben_ecv_shd.g_old_rec.ecv_attribute13;

Line 687: If (p_rec.ecv_attribute13 = hr_api.g_varchar2) then

683: end if;
684: If (p_rec.ecv_attribute12 = hr_api.g_varchar2) then
685: p_rec.ecv_attribute12 := ben_ecv_shd.g_old_rec.ecv_attribute12;
686: end if;
687: If (p_rec.ecv_attribute13 = hr_api.g_varchar2) then
688: p_rec.ecv_attribute13 := ben_ecv_shd.g_old_rec.ecv_attribute13;
689: end if;
690: If (p_rec.ecv_attribute14 = hr_api.g_varchar2) then
691: p_rec.ecv_attribute14 := ben_ecv_shd.g_old_rec.ecv_attribute14;

Line 690: If (p_rec.ecv_attribute14 = hr_api.g_varchar2) then

686: end if;
687: If (p_rec.ecv_attribute13 = hr_api.g_varchar2) then
688: p_rec.ecv_attribute13 := ben_ecv_shd.g_old_rec.ecv_attribute13;
689: end if;
690: If (p_rec.ecv_attribute14 = hr_api.g_varchar2) then
691: p_rec.ecv_attribute14 := ben_ecv_shd.g_old_rec.ecv_attribute14;
692: end if;
693: If (p_rec.ecv_attribute15 = hr_api.g_varchar2) then
694: p_rec.ecv_attribute15 := ben_ecv_shd.g_old_rec.ecv_attribute15;

Line 693: If (p_rec.ecv_attribute15 = hr_api.g_varchar2) then

689: end if;
690: If (p_rec.ecv_attribute14 = hr_api.g_varchar2) then
691: p_rec.ecv_attribute14 := ben_ecv_shd.g_old_rec.ecv_attribute14;
692: end if;
693: If (p_rec.ecv_attribute15 = hr_api.g_varchar2) then
694: p_rec.ecv_attribute15 := ben_ecv_shd.g_old_rec.ecv_attribute15;
695: end if;
696: If (p_rec.ecv_attribute16 = hr_api.g_varchar2) then
697: p_rec.ecv_attribute16 := ben_ecv_shd.g_old_rec.ecv_attribute16;

Line 696: If (p_rec.ecv_attribute16 = hr_api.g_varchar2) then

692: end if;
693: If (p_rec.ecv_attribute15 = hr_api.g_varchar2) then
694: p_rec.ecv_attribute15 := ben_ecv_shd.g_old_rec.ecv_attribute15;
695: end if;
696: If (p_rec.ecv_attribute16 = hr_api.g_varchar2) then
697: p_rec.ecv_attribute16 := ben_ecv_shd.g_old_rec.ecv_attribute16;
698: end if;
699: If (p_rec.ecv_attribute17 = hr_api.g_varchar2) then
700: p_rec.ecv_attribute17 := ben_ecv_shd.g_old_rec.ecv_attribute17;

Line 699: If (p_rec.ecv_attribute17 = hr_api.g_varchar2) then

695: end if;
696: If (p_rec.ecv_attribute16 = hr_api.g_varchar2) then
697: p_rec.ecv_attribute16 := ben_ecv_shd.g_old_rec.ecv_attribute16;
698: end if;
699: If (p_rec.ecv_attribute17 = hr_api.g_varchar2) then
700: p_rec.ecv_attribute17 := ben_ecv_shd.g_old_rec.ecv_attribute17;
701: end if;
702: If (p_rec.ecv_attribute18 = hr_api.g_varchar2) then
703: p_rec.ecv_attribute18 := ben_ecv_shd.g_old_rec.ecv_attribute18;

Line 702: If (p_rec.ecv_attribute18 = hr_api.g_varchar2) then

698: end if;
699: If (p_rec.ecv_attribute17 = hr_api.g_varchar2) then
700: p_rec.ecv_attribute17 := ben_ecv_shd.g_old_rec.ecv_attribute17;
701: end if;
702: If (p_rec.ecv_attribute18 = hr_api.g_varchar2) then
703: p_rec.ecv_attribute18 := ben_ecv_shd.g_old_rec.ecv_attribute18;
704: end if;
705: If (p_rec.ecv_attribute19 = hr_api.g_varchar2) then
706: p_rec.ecv_attribute19 := ben_ecv_shd.g_old_rec.ecv_attribute19;

Line 705: If (p_rec.ecv_attribute19 = hr_api.g_varchar2) then

701: end if;
702: If (p_rec.ecv_attribute18 = hr_api.g_varchar2) then
703: p_rec.ecv_attribute18 := ben_ecv_shd.g_old_rec.ecv_attribute18;
704: end if;
705: If (p_rec.ecv_attribute19 = hr_api.g_varchar2) then
706: p_rec.ecv_attribute19 := ben_ecv_shd.g_old_rec.ecv_attribute19;
707: end if;
708: If (p_rec.ecv_attribute20 = hr_api.g_varchar2) then
709: p_rec.ecv_attribute20 := ben_ecv_shd.g_old_rec.ecv_attribute20;

Line 708: If (p_rec.ecv_attribute20 = hr_api.g_varchar2) then

704: end if;
705: If (p_rec.ecv_attribute19 = hr_api.g_varchar2) then
706: p_rec.ecv_attribute19 := ben_ecv_shd.g_old_rec.ecv_attribute19;
707: end if;
708: If (p_rec.ecv_attribute20 = hr_api.g_varchar2) then
709: p_rec.ecv_attribute20 := ben_ecv_shd.g_old_rec.ecv_attribute20;
710: end if;
711: If (p_rec.ecv_attribute21 = hr_api.g_varchar2) then
712: p_rec.ecv_attribute21 := ben_ecv_shd.g_old_rec.ecv_attribute21;

Line 711: If (p_rec.ecv_attribute21 = hr_api.g_varchar2) then

707: end if;
708: If (p_rec.ecv_attribute20 = hr_api.g_varchar2) then
709: p_rec.ecv_attribute20 := ben_ecv_shd.g_old_rec.ecv_attribute20;
710: end if;
711: If (p_rec.ecv_attribute21 = hr_api.g_varchar2) then
712: p_rec.ecv_attribute21 := ben_ecv_shd.g_old_rec.ecv_attribute21;
713: end if;
714: If (p_rec.ecv_attribute22 = hr_api.g_varchar2) then
715: p_rec.ecv_attribute22 := ben_ecv_shd.g_old_rec.ecv_attribute22;

Line 714: If (p_rec.ecv_attribute22 = hr_api.g_varchar2) then

710: end if;
711: If (p_rec.ecv_attribute21 = hr_api.g_varchar2) then
712: p_rec.ecv_attribute21 := ben_ecv_shd.g_old_rec.ecv_attribute21;
713: end if;
714: If (p_rec.ecv_attribute22 = hr_api.g_varchar2) then
715: p_rec.ecv_attribute22 := ben_ecv_shd.g_old_rec.ecv_attribute22;
716: end if;
717: If (p_rec.ecv_attribute23 = hr_api.g_varchar2) then
718: p_rec.ecv_attribute23 := ben_ecv_shd.g_old_rec.ecv_attribute23;

Line 717: If (p_rec.ecv_attribute23 = hr_api.g_varchar2) then

713: end if;
714: If (p_rec.ecv_attribute22 = hr_api.g_varchar2) then
715: p_rec.ecv_attribute22 := ben_ecv_shd.g_old_rec.ecv_attribute22;
716: end if;
717: If (p_rec.ecv_attribute23 = hr_api.g_varchar2) then
718: p_rec.ecv_attribute23 := ben_ecv_shd.g_old_rec.ecv_attribute23;
719: end if;
720: If (p_rec.ecv_attribute24 = hr_api.g_varchar2) then
721: p_rec.ecv_attribute24 := ben_ecv_shd.g_old_rec.ecv_attribute24;

Line 720: If (p_rec.ecv_attribute24 = hr_api.g_varchar2) then

716: end if;
717: If (p_rec.ecv_attribute23 = hr_api.g_varchar2) then
718: p_rec.ecv_attribute23 := ben_ecv_shd.g_old_rec.ecv_attribute23;
719: end if;
720: If (p_rec.ecv_attribute24 = hr_api.g_varchar2) then
721: p_rec.ecv_attribute24 := ben_ecv_shd.g_old_rec.ecv_attribute24;
722: end if;
723: If (p_rec.ecv_attribute25 = hr_api.g_varchar2) then
724: p_rec.ecv_attribute25 := ben_ecv_shd.g_old_rec.ecv_attribute25;

Line 723: If (p_rec.ecv_attribute25 = hr_api.g_varchar2) then

719: end if;
720: If (p_rec.ecv_attribute24 = hr_api.g_varchar2) then
721: p_rec.ecv_attribute24 := ben_ecv_shd.g_old_rec.ecv_attribute24;
722: end if;
723: If (p_rec.ecv_attribute25 = hr_api.g_varchar2) then
724: p_rec.ecv_attribute25 := ben_ecv_shd.g_old_rec.ecv_attribute25;
725: end if;
726: If (p_rec.ecv_attribute26 = hr_api.g_varchar2) then
727: p_rec.ecv_attribute26 := ben_ecv_shd.g_old_rec.ecv_attribute26;

Line 726: If (p_rec.ecv_attribute26 = hr_api.g_varchar2) then

722: end if;
723: If (p_rec.ecv_attribute25 = hr_api.g_varchar2) then
724: p_rec.ecv_attribute25 := ben_ecv_shd.g_old_rec.ecv_attribute25;
725: end if;
726: If (p_rec.ecv_attribute26 = hr_api.g_varchar2) then
727: p_rec.ecv_attribute26 := ben_ecv_shd.g_old_rec.ecv_attribute26;
728: end if;
729: If (p_rec.ecv_attribute27 = hr_api.g_varchar2) then
730: p_rec.ecv_attribute27 := ben_ecv_shd.g_old_rec.ecv_attribute27;

Line 729: If (p_rec.ecv_attribute27 = hr_api.g_varchar2) then

725: end if;
726: If (p_rec.ecv_attribute26 = hr_api.g_varchar2) then
727: p_rec.ecv_attribute26 := ben_ecv_shd.g_old_rec.ecv_attribute26;
728: end if;
729: If (p_rec.ecv_attribute27 = hr_api.g_varchar2) then
730: p_rec.ecv_attribute27 := ben_ecv_shd.g_old_rec.ecv_attribute27;
731: end if;
732: If (p_rec.ecv_attribute28 = hr_api.g_varchar2) then
733: p_rec.ecv_attribute28 := ben_ecv_shd.g_old_rec.ecv_attribute28;

Line 732: If (p_rec.ecv_attribute28 = hr_api.g_varchar2) then

728: end if;
729: If (p_rec.ecv_attribute27 = hr_api.g_varchar2) then
730: p_rec.ecv_attribute27 := ben_ecv_shd.g_old_rec.ecv_attribute27;
731: end if;
732: If (p_rec.ecv_attribute28 = hr_api.g_varchar2) then
733: p_rec.ecv_attribute28 := ben_ecv_shd.g_old_rec.ecv_attribute28;
734: end if;
735: If (p_rec.ecv_attribute29 = hr_api.g_varchar2) then
736: p_rec.ecv_attribute29 := ben_ecv_shd.g_old_rec.ecv_attribute29;

Line 735: If (p_rec.ecv_attribute29 = hr_api.g_varchar2) then

731: end if;
732: If (p_rec.ecv_attribute28 = hr_api.g_varchar2) then
733: p_rec.ecv_attribute28 := ben_ecv_shd.g_old_rec.ecv_attribute28;
734: end if;
735: If (p_rec.ecv_attribute29 = hr_api.g_varchar2) then
736: p_rec.ecv_attribute29 := ben_ecv_shd.g_old_rec.ecv_attribute29;
737: end if;
738: If (p_rec.ecv_attribute30 = hr_api.g_varchar2) then
739: p_rec.ecv_attribute30 := ben_ecv_shd.g_old_rec.ecv_attribute30;

Line 738: If (p_rec.ecv_attribute30 = hr_api.g_varchar2) then

734: end if;
735: If (p_rec.ecv_attribute29 = hr_api.g_varchar2) then
736: p_rec.ecv_attribute29 := ben_ecv_shd.g_old_rec.ecv_attribute29;
737: end if;
738: If (p_rec.ecv_attribute30 = hr_api.g_varchar2) then
739: p_rec.ecv_attribute30 := ben_ecv_shd.g_old_rec.ecv_attribute30;
740: end if;
741: If (p_rec.criteria_score = hr_api.g_number) then
742: p_rec.criteria_score := ben_ecv_shd.g_old_rec.criteria_score;

Line 741: If (p_rec.criteria_score = hr_api.g_number) then

737: end if;
738: If (p_rec.ecv_attribute30 = hr_api.g_varchar2) then
739: p_rec.ecv_attribute30 := ben_ecv_shd.g_old_rec.ecv_attribute30;
740: end if;
741: If (p_rec.criteria_score = hr_api.g_number) then
742: p_rec.criteria_score := ben_ecv_shd.g_old_rec.criteria_score;
743: end if;
744: If (p_rec.criteria_weight = hr_api.g_number) then
745: p_rec.criteria_weight := ben_ecv_shd.g_old_rec.criteria_weight;

Line 744: If (p_rec.criteria_weight = hr_api.g_number) then

740: end if;
741: If (p_rec.criteria_score = hr_api.g_number) then
742: p_rec.criteria_score := ben_ecv_shd.g_old_rec.criteria_score;
743: end if;
744: If (p_rec.criteria_weight = hr_api.g_number) then
745: p_rec.criteria_weight := ben_ecv_shd.g_old_rec.criteria_weight;
746: end if;
747: If (p_rec.Char_value3 = hr_api.g_varchar2) then
748: p_rec.Char_value3 := ben_ecv_shd.g_old_rec.Char_value3;

Line 747: If (p_rec.Char_value3 = hr_api.g_varchar2) then

743: end if;
744: If (p_rec.criteria_weight = hr_api.g_number) then
745: p_rec.criteria_weight := ben_ecv_shd.g_old_rec.criteria_weight;
746: end if;
747: If (p_rec.Char_value3 = hr_api.g_varchar2) then
748: p_rec.Char_value3 := ben_ecv_shd.g_old_rec.Char_value3;
749: end if;
750: If (p_rec.Char_value4 = hr_api.g_varchar2) then
751: p_rec.Char_value4 := ben_ecv_shd.g_old_rec.Char_value4;

Line 750: If (p_rec.Char_value4 = hr_api.g_varchar2) then

746: end if;
747: If (p_rec.Char_value3 = hr_api.g_varchar2) then
748: p_rec.Char_value3 := ben_ecv_shd.g_old_rec.Char_value3;
749: end if;
750: If (p_rec.Char_value4 = hr_api.g_varchar2) then
751: p_rec.Char_value4 := ben_ecv_shd.g_old_rec.Char_value4;
752: end if;
753: If (p_rec.Number_value3 = hr_api.g_number) then
754: p_rec.Number_value3 := ben_ecv_shd.g_old_rec.Number_value3;

Line 753: If (p_rec.Number_value3 = hr_api.g_number) then

749: end if;
750: If (p_rec.Char_value4 = hr_api.g_varchar2) then
751: p_rec.Char_value4 := ben_ecv_shd.g_old_rec.Char_value4;
752: end if;
753: If (p_rec.Number_value3 = hr_api.g_number) then
754: p_rec.Number_value3 := ben_ecv_shd.g_old_rec.Number_value3;
755: end if;
756: If (p_rec.Number_value4 = hr_api.g_number) then
757: p_rec.Number_value4 := ben_ecv_shd.g_old_rec.Number_value4;

Line 756: If (p_rec.Number_value4 = hr_api.g_number) then

752: end if;
753: If (p_rec.Number_value3 = hr_api.g_number) then
754: p_rec.Number_value3 := ben_ecv_shd.g_old_rec.Number_value3;
755: end if;
756: If (p_rec.Number_value4 = hr_api.g_number) then
757: p_rec.Number_value4 := ben_ecv_shd.g_old_rec.Number_value4;
758: end if;
759: If (p_rec.Date_value3 = hr_api.g_date) then
760: p_rec.Date_value3 := ben_ecv_shd.g_old_rec.Date_value3;

Line 759: If (p_rec.Date_value3 = hr_api.g_date) then

755: end if;
756: If (p_rec.Number_value4 = hr_api.g_number) then
757: p_rec.Number_value4 := ben_ecv_shd.g_old_rec.Number_value4;
758: end if;
759: If (p_rec.Date_value3 = hr_api.g_date) then
760: p_rec.Date_value3 := ben_ecv_shd.g_old_rec.Date_value3;
761: end if;
762: If (p_rec.Date_value4 = hr_api.g_date) then
763: p_rec.Date_value4 := ben_ecv_shd.g_old_rec.Date_value4;

Line 762: If (p_rec.Date_value4 = hr_api.g_date) then

758: end if;
759: If (p_rec.Date_value3 = hr_api.g_date) then
760: p_rec.Date_value3 := ben_ecv_shd.g_old_rec.Date_value3;
761: end if;
762: If (p_rec.Date_value4 = hr_api.g_date) then
763: p_rec.Date_value4 := ben_ecv_shd.g_old_rec.Date_value4;
764: end if;
765:
766: --

Line 850: ,p_eligy_prfl_id In Number default hr_api.g_number

846: -- ----------------------------------------------------------------------------
847: Procedure upd
848: (
849: p_eligy_crit_values_id In Number
850: ,p_eligy_prfl_id In Number default hr_api.g_number
851: ,p_eligy_criteria_id In Number default hr_api.g_number
852: ,p_effective_start_date Out nocopy Date
853: ,p_effective_end_date Out nocopy Date
854: ,p_ordr_num In Number default hr_api.g_number

Line 851: ,p_eligy_criteria_id In Number default hr_api.g_number

847: Procedure upd
848: (
849: p_eligy_crit_values_id In Number
850: ,p_eligy_prfl_id In Number default hr_api.g_number
851: ,p_eligy_criteria_id In Number default hr_api.g_number
852: ,p_effective_start_date Out nocopy Date
853: ,p_effective_end_date Out nocopy Date
854: ,p_ordr_num In Number default hr_api.g_number
855: ,p_number_value1 In Number default hr_api.g_number

Line 854: ,p_ordr_num In Number default hr_api.g_number

850: ,p_eligy_prfl_id In Number default hr_api.g_number
851: ,p_eligy_criteria_id In Number default hr_api.g_number
852: ,p_effective_start_date Out nocopy Date
853: ,p_effective_end_date Out nocopy Date
854: ,p_ordr_num In Number default hr_api.g_number
855: ,p_number_value1 In Number default hr_api.g_number
856: ,p_number_value2 In Number default hr_api.g_number
857: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2

Line 855: ,p_number_value1 In Number default hr_api.g_number

851: ,p_eligy_criteria_id In Number default hr_api.g_number
852: ,p_effective_start_date Out nocopy Date
853: ,p_effective_end_date Out nocopy Date
854: ,p_ordr_num In Number default hr_api.g_number
855: ,p_number_value1 In Number default hr_api.g_number
856: ,p_number_value2 In Number default hr_api.g_number
857: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
859: ,p_date_value1 In Date default hr_api.g_date

Line 856: ,p_number_value2 In Number default hr_api.g_number

852: ,p_effective_start_date Out nocopy Date
853: ,p_effective_end_date Out nocopy Date
854: ,p_ordr_num In Number default hr_api.g_number
855: ,p_number_value1 In Number default hr_api.g_number
856: ,p_number_value2 In Number default hr_api.g_number
857: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
859: ,p_date_value1 In Date default hr_api.g_date
860: ,p_date_value2 In Date default hr_api.g_date

Line 857: ,p_char_value1 In Varchar2 default hr_api.g_varchar2

853: ,p_effective_end_date Out nocopy Date
854: ,p_ordr_num In Number default hr_api.g_number
855: ,p_number_value1 In Number default hr_api.g_number
856: ,p_number_value2 In Number default hr_api.g_number
857: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
859: ,p_date_value1 In Date default hr_api.g_date
860: ,p_date_value2 In Date default hr_api.g_date
861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2

Line 858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2

854: ,p_ordr_num In Number default hr_api.g_number
855: ,p_number_value1 In Number default hr_api.g_number
856: ,p_number_value2 In Number default hr_api.g_number
857: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
859: ,p_date_value1 In Date default hr_api.g_date
860: ,p_date_value2 In Date default hr_api.g_date
861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2
862: ,p_business_group_id In Number default hr_api.g_number

Line 859: ,p_date_value1 In Date default hr_api.g_date

855: ,p_number_value1 In Number default hr_api.g_number
856: ,p_number_value2 In Number default hr_api.g_number
857: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
859: ,p_date_value1 In Date default hr_api.g_date
860: ,p_date_value2 In Date default hr_api.g_date
861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2
862: ,p_business_group_id In Number default hr_api.g_number
863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2

Line 860: ,p_date_value2 In Date default hr_api.g_date

856: ,p_number_value2 In Number default hr_api.g_number
857: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
859: ,p_date_value1 In Date default hr_api.g_date
860: ,p_date_value2 In Date default hr_api.g_date
861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2
862: ,p_business_group_id In Number default hr_api.g_number
863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2
864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2

Line 861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2

857: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
859: ,p_date_value1 In Date default hr_api.g_date
860: ,p_date_value2 In Date default hr_api.g_date
861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2
862: ,p_business_group_id In Number default hr_api.g_number
863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2
864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2

Line 862: ,p_business_group_id In Number default hr_api.g_number

858: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
859: ,p_date_value1 In Date default hr_api.g_date
860: ,p_date_value2 In Date default hr_api.g_date
861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2
862: ,p_business_group_id In Number default hr_api.g_number
863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2
864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2

Line 863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2

859: ,p_date_value1 In Date default hr_api.g_date
860: ,p_date_value2 In Date default hr_api.g_date
861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2
862: ,p_business_group_id In Number default hr_api.g_number
863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2
864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2

Line 864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2

860: ,p_date_value2 In Date default hr_api.g_date
861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2
862: ,p_business_group_id In Number default hr_api.g_number
863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2
864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2

Line 865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2

861: ,p_excld_flag In Varchar2 default hr_api.g_Varchar2
862: ,p_business_group_id In Number default hr_api.g_number
863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2
864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2

Line 866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2

862: ,p_business_group_id In Number default hr_api.g_number
863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2
864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2

Line 867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2

863: ,p_legislation_code In Varchar2 default hr_api.g_varchar2
864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2

Line 868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2

864: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2

Line 869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2

865: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2

Line 870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2

866: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2

Line 871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2

867: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2

Line 872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2

868: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2

Line 873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2

869: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2

Line 874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2

870: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2

Line 875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2

871: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2

Line 876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2

872: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2

Line 877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2

873: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2

Line 878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2

874: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2

Line 879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2

875: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2

Line 880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2

876: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2

Line 881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2

877: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2

Line 882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2

878: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2

Line 883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2

879: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2

Line 884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2

880: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2

Line 885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2

881: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2

Line 886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2

882: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2

Line 887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2

883: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
891: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2

Line 888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2

884: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
891: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
892: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2

Line 889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2

885: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
891: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
892: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
893: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2

Line 890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2

886: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
891: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
892: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
893: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
894: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2

Line 891: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2

887: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
891: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
892: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
893: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
894: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
895: ,p_object_version_number In Out nocopy Number

Line 892: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2

888: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
891: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
892: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
893: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
894: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
895: ,p_object_version_number In Out nocopy Number
896: ,p_effective_date In Date

Line 893: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2

889: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
891: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
892: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
893: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
894: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
895: ,p_object_version_number In Out nocopy Number
896: ,p_effective_date In Date
897: ,p_datetrack_mode In varchar2

Line 894: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2

890: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
891: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
892: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
893: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
894: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
895: ,p_object_version_number In Out nocopy Number
896: ,p_effective_date In Date
897: ,p_datetrack_mode In varchar2
898: ,p_criteria_score In Number default hr_api.g_number

Line 898: ,p_criteria_score In Number default hr_api.g_number

894: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
895: ,p_object_version_number In Out nocopy Number
896: ,p_effective_date In Date
897: ,p_datetrack_mode In varchar2
898: ,p_criteria_score In Number default hr_api.g_number
899: ,p_criteria_weight In Number default hr_api.g_number
900: ,p_Char_value3 In Varchar2 default hr_api.g_varchar2
901: ,p_Char_value4 In Varchar2 default hr_api.g_varchar2
902: ,p_Number_value3 In Number default hr_api.g_number

Line 899: ,p_criteria_weight In Number default hr_api.g_number

895: ,p_object_version_number In Out nocopy Number
896: ,p_effective_date In Date
897: ,p_datetrack_mode In varchar2
898: ,p_criteria_score In Number default hr_api.g_number
899: ,p_criteria_weight In Number default hr_api.g_number
900: ,p_Char_value3 In Varchar2 default hr_api.g_varchar2
901: ,p_Char_value4 In Varchar2 default hr_api.g_varchar2
902: ,p_Number_value3 In Number default hr_api.g_number
903: ,p_Number_value4 In Number default hr_api.g_number

Line 900: ,p_Char_value3 In Varchar2 default hr_api.g_varchar2

896: ,p_effective_date In Date
897: ,p_datetrack_mode In varchar2
898: ,p_criteria_score In Number default hr_api.g_number
899: ,p_criteria_weight In Number default hr_api.g_number
900: ,p_Char_value3 In Varchar2 default hr_api.g_varchar2
901: ,p_Char_value4 In Varchar2 default hr_api.g_varchar2
902: ,p_Number_value3 In Number default hr_api.g_number
903: ,p_Number_value4 In Number default hr_api.g_number
904: ,p_Date_value3 In Date default hr_api.g_date

Line 901: ,p_Char_value4 In Varchar2 default hr_api.g_varchar2

897: ,p_datetrack_mode In varchar2
898: ,p_criteria_score In Number default hr_api.g_number
899: ,p_criteria_weight In Number default hr_api.g_number
900: ,p_Char_value3 In Varchar2 default hr_api.g_varchar2
901: ,p_Char_value4 In Varchar2 default hr_api.g_varchar2
902: ,p_Number_value3 In Number default hr_api.g_number
903: ,p_Number_value4 In Number default hr_api.g_number
904: ,p_Date_value3 In Date default hr_api.g_date
905: ,p_Date_value4 In Date default hr_api.g_date

Line 902: ,p_Number_value3 In Number default hr_api.g_number

898: ,p_criteria_score In Number default hr_api.g_number
899: ,p_criteria_weight In Number default hr_api.g_number
900: ,p_Char_value3 In Varchar2 default hr_api.g_varchar2
901: ,p_Char_value4 In Varchar2 default hr_api.g_varchar2
902: ,p_Number_value3 In Number default hr_api.g_number
903: ,p_Number_value4 In Number default hr_api.g_number
904: ,p_Date_value3 In Date default hr_api.g_date
905: ,p_Date_value4 In Date default hr_api.g_date
906: ) is

Line 903: ,p_Number_value4 In Number default hr_api.g_number

899: ,p_criteria_weight In Number default hr_api.g_number
900: ,p_Char_value3 In Varchar2 default hr_api.g_varchar2
901: ,p_Char_value4 In Varchar2 default hr_api.g_varchar2
902: ,p_Number_value3 In Number default hr_api.g_number
903: ,p_Number_value4 In Number default hr_api.g_number
904: ,p_Date_value3 In Date default hr_api.g_date
905: ,p_Date_value4 In Date default hr_api.g_date
906: ) is
907: --

Line 904: ,p_Date_value3 In Date default hr_api.g_date

900: ,p_Char_value3 In Varchar2 default hr_api.g_varchar2
901: ,p_Char_value4 In Varchar2 default hr_api.g_varchar2
902: ,p_Number_value3 In Number default hr_api.g_number
903: ,p_Number_value4 In Number default hr_api.g_number
904: ,p_Date_value3 In Date default hr_api.g_date
905: ,p_Date_value4 In Date default hr_api.g_date
906: ) is
907: --
908: l_rec ben_ecv_shd.g_rec_type;

Line 905: ,p_Date_value4 In Date default hr_api.g_date

901: ,p_Char_value4 In Varchar2 default hr_api.g_varchar2
902: ,p_Number_value3 In Number default hr_api.g_number
903: ,p_Number_value4 In Number default hr_api.g_number
904: ,p_Date_value3 In Date default hr_api.g_date
905: ,p_Date_value4 In Date default hr_api.g_date
906: ) is
907: --
908: l_rec ben_ecv_shd.g_rec_type;
909: l_proc varchar2(72) := g_package||'upd';