APPS.PER_SSL_UPD dependencies on HR_API

Line 157: When hr_api.check_integrity_violated Then

153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: --
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: per_ssl_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then

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

156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: per_ssl_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: per_ssl_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 161: When hr_api.parent_integrity_violated Then

157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: per_ssl_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: per_ssl_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then

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

160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: per_ssl_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: per_ssl_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 165: When hr_api.unique_integrity_violated Then

161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: per_ssl_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: per_ssl_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then

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

164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: per_ssl_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: Raise;
171: End update_dml;
172: --

Line 583: when hr_api.cannot_find_prog_unit then

579: /*End Enhancement 4021737 */
580: );
581:
582: exception
583: when hr_api.cannot_find_prog_unit then
584: hr_api.cannot_find_prog_unit_error
585: (p_module_name => 'PER_SALARY_SURVEY_LINES'
586: ,p_hook_type => 'AU'
587: );

Line 584: hr_api.cannot_find_prog_unit_error

580: );
581:
582: exception
583: when hr_api.cannot_find_prog_unit then
584: hr_api.cannot_find_prog_unit_error
585: (p_module_name => 'PER_SALARY_SURVEY_LINES'
586: ,p_hook_type => 'AU'
587: );
588: end;

Line 651: If (p_rec.salary_survey_id = hr_api.g_number) Then

647: -- p_rec plsql record structure
648: -- to see If a system default is being used. If a system default
649: -- is being used Then we must set to the 'current' argument value.
650: --
651: If (p_rec.salary_survey_id = hr_api.g_number) Then
652: p_rec.salary_survey_id :=
653: per_ssl_shd.g_old_rec.salary_survey_id;
654: End If;
655: If (p_rec.survey_job_name_code = hr_api.g_varchar2) Then

Line 655: If (p_rec.survey_job_name_code = hr_api.g_varchar2) Then

651: If (p_rec.salary_survey_id = hr_api.g_number) Then
652: p_rec.salary_survey_id :=
653: per_ssl_shd.g_old_rec.salary_survey_id;
654: End If;
655: If (p_rec.survey_job_name_code = hr_api.g_varchar2) Then
656: p_rec.survey_job_name_code :=
657: per_ssl_shd.g_old_rec.survey_job_name_code;
658: End If;
659: If (p_rec.survey_region_code = hr_api.g_varchar2) Then

Line 659: If (p_rec.survey_region_code = hr_api.g_varchar2) Then

655: If (p_rec.survey_job_name_code = hr_api.g_varchar2) Then
656: p_rec.survey_job_name_code :=
657: per_ssl_shd.g_old_rec.survey_job_name_code;
658: End If;
659: If (p_rec.survey_region_code = hr_api.g_varchar2) Then
660: p_rec.survey_region_code :=
661: per_ssl_shd.g_old_rec.survey_region_code;
662: End If;
663: If (p_rec.survey_seniority_code = hr_api.g_varchar2) Then

Line 663: If (p_rec.survey_seniority_code = hr_api.g_varchar2) Then

659: If (p_rec.survey_region_code = hr_api.g_varchar2) Then
660: p_rec.survey_region_code :=
661: per_ssl_shd.g_old_rec.survey_region_code;
662: End If;
663: If (p_rec.survey_seniority_code = hr_api.g_varchar2) Then
664: p_rec.survey_seniority_code :=
665: per_ssl_shd.g_old_rec.survey_seniority_code;
666: End If;
667: If (p_rec.company_size_code = hr_api.g_varchar2) Then

Line 667: If (p_rec.company_size_code = hr_api.g_varchar2) Then

663: If (p_rec.survey_seniority_code = hr_api.g_varchar2) Then
664: p_rec.survey_seniority_code :=
665: per_ssl_shd.g_old_rec.survey_seniority_code;
666: End If;
667: If (p_rec.company_size_code = hr_api.g_varchar2) Then
668: p_rec.company_size_code :=
669: per_ssl_shd.g_old_rec.company_size_code;
670: End If;
671: If (p_rec.industry_code = hr_api.g_varchar2) Then

Line 671: If (p_rec.industry_code = hr_api.g_varchar2) Then

667: If (p_rec.company_size_code = hr_api.g_varchar2) Then
668: p_rec.company_size_code :=
669: per_ssl_shd.g_old_rec.company_size_code;
670: End If;
671: If (p_rec.industry_code = hr_api.g_varchar2) Then
672: p_rec.industry_code :=
673: per_ssl_shd.g_old_rec.industry_code;
674: End If;
675: If (p_rec.survey_age_code = hr_api.g_varchar2) Then

Line 675: If (p_rec.survey_age_code = hr_api.g_varchar2) Then

671: If (p_rec.industry_code = hr_api.g_varchar2) Then
672: p_rec.industry_code :=
673: per_ssl_shd.g_old_rec.industry_code;
674: End If;
675: If (p_rec.survey_age_code = hr_api.g_varchar2) Then
676: p_rec.survey_age_code :=
677: per_ssl_shd.g_old_rec.survey_age_code;
678: End If;
679: If (p_rec.start_date = hr_api.g_date) Then

Line 679: If (p_rec.start_date = hr_api.g_date) Then

675: If (p_rec.survey_age_code = hr_api.g_varchar2) Then
676: p_rec.survey_age_code :=
677: per_ssl_shd.g_old_rec.survey_age_code;
678: End If;
679: If (p_rec.start_date = hr_api.g_date) Then
680: p_rec.start_date :=
681: per_ssl_shd.g_old_rec.start_date;
682: End If;
683: If (p_rec.end_date = hr_api.g_date) Then

Line 683: If (p_rec.end_date = hr_api.g_date) Then

679: If (p_rec.start_date = hr_api.g_date) Then
680: p_rec.start_date :=
681: per_ssl_shd.g_old_rec.start_date;
682: End If;
683: If (p_rec.end_date = hr_api.g_date) Then
684: p_rec.end_date :=
685: per_ssl_shd.g_old_rec.end_date;
686: End If;
687: If (p_rec.currency_code = hr_api.g_varchar2) then

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

683: If (p_rec.end_date = hr_api.g_date) Then
684: p_rec.end_date :=
685: per_ssl_shd.g_old_rec.end_date;
686: End If;
687: If (p_rec.currency_code = hr_api.g_varchar2) then
688: p_rec.currency_code :=
689: per_ssl_shd.g_old_rec.currency_code;
690: End If;
691: If (p_rec.differential = hr_api.g_number) Then

Line 691: If (p_rec.differential = hr_api.g_number) Then

687: If (p_rec.currency_code = hr_api.g_varchar2) then
688: p_rec.currency_code :=
689: per_ssl_shd.g_old_rec.currency_code;
690: End If;
691: If (p_rec.differential = hr_api.g_number) Then
692: p_rec.differential :=
693: per_ssl_shd.g_old_rec.differential;
694: End If;
695: If (p_rec.minimum_pay = hr_api.g_number ) Then

Line 695: If (p_rec.minimum_pay = hr_api.g_number ) Then

691: If (p_rec.differential = hr_api.g_number) Then
692: p_rec.differential :=
693: per_ssl_shd.g_old_rec.differential;
694: End If;
695: If (p_rec.minimum_pay = hr_api.g_number ) Then
696: p_rec.minimum_pay :=
697: per_ssl_shd.g_old_rec.minimum_pay;
698: End If;
699: If (p_rec.mean_pay = hr_api.g_number ) Then

Line 699: If (p_rec.mean_pay = hr_api.g_number ) Then

695: If (p_rec.minimum_pay = hr_api.g_number ) Then
696: p_rec.minimum_pay :=
697: per_ssl_shd.g_old_rec.minimum_pay;
698: End If;
699: If (p_rec.mean_pay = hr_api.g_number ) Then
700: p_rec.mean_pay :=
701: per_ssl_shd.g_old_rec.mean_pay;
702: End If;
703: If (p_rec.maximum_pay = hr_api.g_number ) Then

Line 703: If (p_rec.maximum_pay = hr_api.g_number ) Then

699: If (p_rec.mean_pay = hr_api.g_number ) Then
700: p_rec.mean_pay :=
701: per_ssl_shd.g_old_rec.mean_pay;
702: End If;
703: If (p_rec.maximum_pay = hr_api.g_number ) Then
704: p_rec.maximum_pay :=
705: per_ssl_shd.g_old_rec.maximum_pay;
706: End If;
707: If (p_rec.graduate_pay = hr_api.g_number ) Then

Line 707: If (p_rec.graduate_pay = hr_api.g_number ) Then

703: If (p_rec.maximum_pay = hr_api.g_number ) Then
704: p_rec.maximum_pay :=
705: per_ssl_shd.g_old_rec.maximum_pay;
706: End If;
707: If (p_rec.graduate_pay = hr_api.g_number ) Then
708: p_rec.graduate_pay :=
709: per_ssl_shd.g_old_rec.graduate_pay;
710: End If;
711: If (p_rec.starting_pay = hr_api.g_number ) Then

Line 711: If (p_rec.starting_pay = hr_api.g_number ) Then

707: If (p_rec.graduate_pay = hr_api.g_number ) Then
708: p_rec.graduate_pay :=
709: per_ssl_shd.g_old_rec.graduate_pay;
710: End If;
711: If (p_rec.starting_pay = hr_api.g_number ) Then
712: p_rec.starting_pay :=
713: per_ssl_shd.g_old_rec.starting_pay;
714: End If;
715: If (p_rec.percentage_change = hr_api.g_number ) Then

Line 715: If (p_rec.percentage_change = hr_api.g_number ) Then

711: If (p_rec.starting_pay = hr_api.g_number ) Then
712: p_rec.starting_pay :=
713: per_ssl_shd.g_old_rec.starting_pay;
714: End If;
715: If (p_rec.percentage_change = hr_api.g_number ) Then
716: p_rec.percentage_change :=
717: per_ssl_shd.g_old_rec.percentage_change;
718: End If;
719: If (p_rec.job_first_quartile = hr_api.g_number ) Then

Line 719: If (p_rec.job_first_quartile = hr_api.g_number ) Then

715: If (p_rec.percentage_change = hr_api.g_number ) Then
716: p_rec.percentage_change :=
717: per_ssl_shd.g_old_rec.percentage_change;
718: End If;
719: If (p_rec.job_first_quartile = hr_api.g_number ) Then
720: p_rec.job_first_quartile :=
721: per_ssl_shd.g_old_rec.job_first_quartile;
722: End If;
723: If (p_rec.job_median_quartile = hr_api.g_number ) Then

Line 723: If (p_rec.job_median_quartile = hr_api.g_number ) Then

719: If (p_rec.job_first_quartile = hr_api.g_number ) Then
720: p_rec.job_first_quartile :=
721: per_ssl_shd.g_old_rec.job_first_quartile;
722: End If;
723: If (p_rec.job_median_quartile = hr_api.g_number ) Then
724: p_rec.job_median_quartile :=
725: per_ssl_shd.g_old_rec.job_median_quartile;
726: End If;
727: If (p_rec.job_third_quartile = hr_api.g_number ) Then

Line 727: If (p_rec.job_third_quartile = hr_api.g_number ) Then

723: If (p_rec.job_median_quartile = hr_api.g_number ) Then
724: p_rec.job_median_quartile :=
725: per_ssl_shd.g_old_rec.job_median_quartile;
726: End If;
727: If (p_rec.job_third_quartile = hr_api.g_number ) Then
728: p_rec.job_third_quartile :=
729: per_ssl_shd.g_old_rec.job_third_quartile;
730: End If;
731: If (p_rec.job_fourth_quartile = hr_api.g_number ) Then

Line 731: If (p_rec.job_fourth_quartile = hr_api.g_number ) Then

727: If (p_rec.job_third_quartile = hr_api.g_number ) Then
728: p_rec.job_third_quartile :=
729: per_ssl_shd.g_old_rec.job_third_quartile;
730: End If;
731: If (p_rec.job_fourth_quartile = hr_api.g_number ) Then
732: p_rec.job_fourth_quartile :=
733: per_ssl_shd.g_old_rec.job_fourth_quartile;
734: End If;
735: If (p_rec.minimum_total_compensation = hr_api.g_number ) Then

Line 735: If (p_rec.minimum_total_compensation = hr_api.g_number ) Then

731: If (p_rec.job_fourth_quartile = hr_api.g_number ) Then
732: p_rec.job_fourth_quartile :=
733: per_ssl_shd.g_old_rec.job_fourth_quartile;
734: End If;
735: If (p_rec.minimum_total_compensation = hr_api.g_number ) Then
736: p_rec.minimum_total_compensation :=
737: per_ssl_shd.g_old_rec.minimum_total_compensation;
738: End If;
739: If (p_rec.mean_total_compensation = hr_api.g_number ) Then

Line 739: If (p_rec.mean_total_compensation = hr_api.g_number ) Then

735: If (p_rec.minimum_total_compensation = hr_api.g_number ) Then
736: p_rec.minimum_total_compensation :=
737: per_ssl_shd.g_old_rec.minimum_total_compensation;
738: End If;
739: If (p_rec.mean_total_compensation = hr_api.g_number ) Then
740: p_rec.mean_total_compensation :=
741: per_ssl_shd.g_old_rec.mean_total_compensation;
742: End If;
743: If (p_rec.maximum_total_compensation = hr_api.g_number ) Then

Line 743: If (p_rec.maximum_total_compensation = hr_api.g_number ) Then

739: If (p_rec.mean_total_compensation = hr_api.g_number ) Then
740: p_rec.mean_total_compensation :=
741: per_ssl_shd.g_old_rec.mean_total_compensation;
742: End If;
743: If (p_rec.maximum_total_compensation = hr_api.g_number ) Then
744: p_rec.maximum_total_compensation :=
745: per_ssl_shd.g_old_rec.maximum_total_compensation;
746: End If;
747: If (p_rec.compnstn_first_quartile = hr_api.g_number ) Then

Line 747: If (p_rec.compnstn_first_quartile = hr_api.g_number ) Then

743: If (p_rec.maximum_total_compensation = hr_api.g_number ) Then
744: p_rec.maximum_total_compensation :=
745: per_ssl_shd.g_old_rec.maximum_total_compensation;
746: End If;
747: If (p_rec.compnstn_first_quartile = hr_api.g_number ) Then
748: p_rec.compnstn_first_quartile :=
749: per_ssl_shd.g_old_rec.compnstn_first_quartile;
750: End If;
751: If (p_rec.compnstn_median_quartile = hr_api.g_number ) Then

Line 751: If (p_rec.compnstn_median_quartile = hr_api.g_number ) Then

747: If (p_rec.compnstn_first_quartile = hr_api.g_number ) Then
748: p_rec.compnstn_first_quartile :=
749: per_ssl_shd.g_old_rec.compnstn_first_quartile;
750: End If;
751: If (p_rec.compnstn_median_quartile = hr_api.g_number ) Then
752: p_rec.compnstn_median_quartile :=
753: per_ssl_shd.g_old_rec.compnstn_median_quartile;
754: End If;
755: If (p_rec.compnstn_third_quartile = hr_api.g_number ) Then

Line 755: If (p_rec.compnstn_third_quartile = hr_api.g_number ) Then

751: If (p_rec.compnstn_median_quartile = hr_api.g_number ) Then
752: p_rec.compnstn_median_quartile :=
753: per_ssl_shd.g_old_rec.compnstn_median_quartile;
754: End If;
755: If (p_rec.compnstn_third_quartile = hr_api.g_number ) Then
756: p_rec.compnstn_third_quartile :=
757: per_ssl_shd.g_old_rec.compnstn_third_quartile;
758: End If;
759: If (p_rec.compnstn_fourth_quartile = hr_api.g_number ) Then

Line 759: If (p_rec.compnstn_fourth_quartile = hr_api.g_number ) Then

755: If (p_rec.compnstn_third_quartile = hr_api.g_number ) Then
756: p_rec.compnstn_third_quartile :=
757: per_ssl_shd.g_old_rec.compnstn_third_quartile;
758: End If;
759: If (p_rec.compnstn_fourth_quartile = hr_api.g_number ) Then
760: p_rec.compnstn_fourth_quartile :=
761: per_ssl_shd.g_old_rec.compnstn_fourth_quartile;
762: End If;
763: /*Added for Enhancement 4021737 */

Line 764: If (p_rec.tenth_percentile = hr_api.g_number ) Then

760: p_rec.compnstn_fourth_quartile :=
761: per_ssl_shd.g_old_rec.compnstn_fourth_quartile;
762: End If;
763: /*Added for Enhancement 4021737 */
764: If (p_rec.tenth_percentile = hr_api.g_number ) Then
765: p_rec.tenth_percentile :=
766: per_ssl_shd.g_old_rec.tenth_percentile;
767: End If;
768: If (p_rec.twenty_fifth_percentile = hr_api.g_number ) Then

Line 768: If (p_rec.twenty_fifth_percentile = hr_api.g_number ) Then

764: If (p_rec.tenth_percentile = hr_api.g_number ) Then
765: p_rec.tenth_percentile :=
766: per_ssl_shd.g_old_rec.tenth_percentile;
767: End If;
768: If (p_rec.twenty_fifth_percentile = hr_api.g_number ) Then
769: p_rec.twenty_fifth_percentile :=
770: per_ssl_shd.g_old_rec.twenty_fifth_percentile;
771: End If;
772: If (p_rec.fiftieth_percentile = hr_api.g_number ) Then

Line 772: If (p_rec.fiftieth_percentile = hr_api.g_number ) Then

768: If (p_rec.twenty_fifth_percentile = hr_api.g_number ) Then
769: p_rec.twenty_fifth_percentile :=
770: per_ssl_shd.g_old_rec.twenty_fifth_percentile;
771: End If;
772: If (p_rec.fiftieth_percentile = hr_api.g_number ) Then
773: p_rec.fiftieth_percentile :=
774: per_ssl_shd.g_old_rec.fiftieth_percentile;
775: End If;
776: If (p_rec.seventy_fifth_percentile = hr_api.g_number ) Then

Line 776: If (p_rec.seventy_fifth_percentile = hr_api.g_number ) Then

772: If (p_rec.fiftieth_percentile = hr_api.g_number ) Then
773: p_rec.fiftieth_percentile :=
774: per_ssl_shd.g_old_rec.fiftieth_percentile;
775: End If;
776: If (p_rec.seventy_fifth_percentile = hr_api.g_number ) Then
777: p_rec.seventy_fifth_percentile :=
778: per_ssl_shd.g_old_rec.seventy_fifth_percentile;
779: End If;
780: If (p_rec.ninetieth_percentile = hr_api.g_number ) Then

Line 780: If (p_rec.ninetieth_percentile = hr_api.g_number ) Then

776: If (p_rec.seventy_fifth_percentile = hr_api.g_number ) Then
777: p_rec.seventy_fifth_percentile :=
778: per_ssl_shd.g_old_rec.seventy_fifth_percentile;
779: End If;
780: If (p_rec.ninetieth_percentile = hr_api.g_number ) Then
781: p_rec.ninetieth_percentile :=
782: per_ssl_shd.g_old_rec.ninetieth_percentile;
783: End If;
784: If (p_rec.minimum_bonus = hr_api.g_number ) Then

Line 784: If (p_rec.minimum_bonus = hr_api.g_number ) Then

780: If (p_rec.ninetieth_percentile = hr_api.g_number ) Then
781: p_rec.ninetieth_percentile :=
782: per_ssl_shd.g_old_rec.ninetieth_percentile;
783: End If;
784: If (p_rec.minimum_bonus = hr_api.g_number ) Then
785: p_rec.minimum_bonus :=
786: per_ssl_shd.g_old_rec.minimum_bonus;
787: End If;
788: If (p_rec.mean_bonus = hr_api.g_number ) Then

Line 788: If (p_rec.mean_bonus = hr_api.g_number ) Then

784: If (p_rec.minimum_bonus = hr_api.g_number ) Then
785: p_rec.minimum_bonus :=
786: per_ssl_shd.g_old_rec.minimum_bonus;
787: End If;
788: If (p_rec.mean_bonus = hr_api.g_number ) Then
789: p_rec.mean_bonus :=
790: per_ssl_shd.g_old_rec.mean_bonus;
791: End If;
792: If (p_rec.maximum_bonus = hr_api.g_number ) Then

Line 792: If (p_rec.maximum_bonus = hr_api.g_number ) Then

788: If (p_rec.mean_bonus = hr_api.g_number ) Then
789: p_rec.mean_bonus :=
790: per_ssl_shd.g_old_rec.mean_bonus;
791: End If;
792: If (p_rec.maximum_bonus = hr_api.g_number ) Then
793: p_rec.maximum_bonus :=
794: per_ssl_shd.g_old_rec.maximum_bonus;
795: End If;
796: If (p_rec.minimum_salary_increase = hr_api.g_number ) Then

Line 796: If (p_rec.minimum_salary_increase = hr_api.g_number ) Then

792: If (p_rec.maximum_bonus = hr_api.g_number ) Then
793: p_rec.maximum_bonus :=
794: per_ssl_shd.g_old_rec.maximum_bonus;
795: End If;
796: If (p_rec.minimum_salary_increase = hr_api.g_number ) Then
797: p_rec.minimum_salary_increase :=
798: per_ssl_shd.g_old_rec.minimum_salary_increase;
799: End If;
800: If (p_rec.mean_salary_increase = hr_api.g_number ) Then

Line 800: If (p_rec.mean_salary_increase = hr_api.g_number ) Then

796: If (p_rec.minimum_salary_increase = hr_api.g_number ) Then
797: p_rec.minimum_salary_increase :=
798: per_ssl_shd.g_old_rec.minimum_salary_increase;
799: End If;
800: If (p_rec.mean_salary_increase = hr_api.g_number ) Then
801: p_rec.mean_salary_increase :=
802: per_ssl_shd.g_old_rec.mean_salary_increase;
803: End If;
804: If (p_rec.maximum_salary_increase = hr_api.g_number ) Then

Line 804: If (p_rec.maximum_salary_increase = hr_api.g_number ) Then

800: If (p_rec.mean_salary_increase = hr_api.g_number ) Then
801: p_rec.mean_salary_increase :=
802: per_ssl_shd.g_old_rec.mean_salary_increase;
803: End If;
804: If (p_rec.maximum_salary_increase = hr_api.g_number ) Then
805: p_rec.maximum_salary_increase :=
806: per_ssl_shd.g_old_rec.maximum_salary_increase;
807: End If;
808: If (p_rec.min_variable_compensation = hr_api.g_number ) Then

Line 808: If (p_rec.min_variable_compensation = hr_api.g_number ) Then

804: If (p_rec.maximum_salary_increase = hr_api.g_number ) Then
805: p_rec.maximum_salary_increase :=
806: per_ssl_shd.g_old_rec.maximum_salary_increase;
807: End If;
808: If (p_rec.min_variable_compensation = hr_api.g_number ) Then
809: p_rec.min_variable_compensation :=
810: per_ssl_shd.g_old_rec.min_variable_compensation;
811: End If;
812: If (p_rec.mean_variable_compensation = hr_api.g_number ) Then

Line 812: If (p_rec.mean_variable_compensation = hr_api.g_number ) Then

808: If (p_rec.min_variable_compensation = hr_api.g_number ) Then
809: p_rec.min_variable_compensation :=
810: per_ssl_shd.g_old_rec.min_variable_compensation;
811: End If;
812: If (p_rec.mean_variable_compensation = hr_api.g_number ) Then
813: p_rec.mean_variable_compensation :=
814: per_ssl_shd.g_old_rec.mean_variable_compensation;
815: End If;
816: If (p_rec.max_variable_compensation = hr_api.g_number ) Then

Line 816: If (p_rec.max_variable_compensation = hr_api.g_number ) Then

812: If (p_rec.mean_variable_compensation = hr_api.g_number ) Then
813: p_rec.mean_variable_compensation :=
814: per_ssl_shd.g_old_rec.mean_variable_compensation;
815: End If;
816: If (p_rec.max_variable_compensation = hr_api.g_number ) Then
817: p_rec.max_variable_compensation :=
818: per_ssl_shd.g_old_rec.max_variable_compensation;
819: End If;
820: If (p_rec.minimum_stock = hr_api.g_number ) Then

Line 820: If (p_rec.minimum_stock = hr_api.g_number ) Then

816: If (p_rec.max_variable_compensation = hr_api.g_number ) Then
817: p_rec.max_variable_compensation :=
818: per_ssl_shd.g_old_rec.max_variable_compensation;
819: End If;
820: If (p_rec.minimum_stock = hr_api.g_number ) Then
821: p_rec.minimum_stock :=
822: per_ssl_shd.g_old_rec.minimum_stock;
823: End If;
824: If (p_rec.mean_stock = hr_api.g_number ) Then

Line 824: If (p_rec.mean_stock = hr_api.g_number ) Then

820: If (p_rec.minimum_stock = hr_api.g_number ) Then
821: p_rec.minimum_stock :=
822: per_ssl_shd.g_old_rec.minimum_stock;
823: End If;
824: If (p_rec.mean_stock = hr_api.g_number ) Then
825: p_rec.mean_stock :=
826: per_ssl_shd.g_old_rec.mean_stock;
827: End If;
828: If (p_rec.maximum_stock = hr_api.g_number ) Then

Line 828: If (p_rec.maximum_stock = hr_api.g_number ) Then

824: If (p_rec.mean_stock = hr_api.g_number ) Then
825: p_rec.mean_stock :=
826: per_ssl_shd.g_old_rec.mean_stock;
827: End If;
828: If (p_rec.maximum_stock = hr_api.g_number ) Then
829: p_rec.maximum_stock :=
830: per_ssl_shd.g_old_rec.maximum_stock;
831: End If;
832: If (p_rec.stock_display_type = hr_api.g_varchar2) Then

Line 832: If (p_rec.stock_display_type = hr_api.g_varchar2) Then

828: If (p_rec.maximum_stock = hr_api.g_number ) Then
829: p_rec.maximum_stock :=
830: per_ssl_shd.g_old_rec.maximum_stock;
831: End If;
832: If (p_rec.stock_display_type = hr_api.g_varchar2) Then
833: p_rec.stock_display_type :=
834: per_ssl_shd.g_old_rec.stock_display_type;
835: End If;
836: /*End Enhancement 4021737 */

Line 837: If (p_rec.attribute_category = hr_api.g_varchar2 ) Then

833: p_rec.stock_display_type :=
834: per_ssl_shd.g_old_rec.stock_display_type;
835: End If;
836: /*End Enhancement 4021737 */
837: If (p_rec.attribute_category = hr_api.g_varchar2 ) Then
838: p_rec.attribute_category :=
839: per_ssl_shd.g_old_rec.attribute_category;
840: End If;
841: If (p_rec.attribute1 = hr_api.g_varchar2) Then

Line 841: If (p_rec.attribute1 = hr_api.g_varchar2) Then

837: If (p_rec.attribute_category = hr_api.g_varchar2 ) Then
838: p_rec.attribute_category :=
839: per_ssl_shd.g_old_rec.attribute_category;
840: End If;
841: If (p_rec.attribute1 = hr_api.g_varchar2) Then
842: p_rec.attribute1 :=
843: per_ssl_shd.g_old_rec.attribute1;
844: End If;
845: If (p_rec.attribute2 = hr_api.g_varchar2) Then

Line 845: If (p_rec.attribute2 = hr_api.g_varchar2) Then

841: If (p_rec.attribute1 = hr_api.g_varchar2) Then
842: p_rec.attribute1 :=
843: per_ssl_shd.g_old_rec.attribute1;
844: End If;
845: If (p_rec.attribute2 = hr_api.g_varchar2) Then
846: p_rec.attribute2 :=
847: per_ssl_shd.g_old_rec.attribute2;
848: End If;
849: If (p_rec.attribute3 = hr_api.g_varchar2) Then

Line 849: If (p_rec.attribute3 = hr_api.g_varchar2) Then

845: If (p_rec.attribute2 = hr_api.g_varchar2) Then
846: p_rec.attribute2 :=
847: per_ssl_shd.g_old_rec.attribute2;
848: End If;
849: If (p_rec.attribute3 = hr_api.g_varchar2) Then
850: p_rec.attribute3 :=
851: per_ssl_shd.g_old_rec.attribute3;
852: End If;
853: If (p_rec.attribute4 = hr_api.g_varchar2) Then

Line 853: If (p_rec.attribute4 = hr_api.g_varchar2) Then

849: If (p_rec.attribute3 = hr_api.g_varchar2) Then
850: p_rec.attribute3 :=
851: per_ssl_shd.g_old_rec.attribute3;
852: End If;
853: If (p_rec.attribute4 = hr_api.g_varchar2) Then
854: p_rec.attribute4 :=
855: per_ssl_shd.g_old_rec.attribute4;
856: End If;
857: If (p_rec.attribute5 = hr_api.g_varchar2) Then

Line 857: If (p_rec.attribute5 = hr_api.g_varchar2) Then

853: If (p_rec.attribute4 = hr_api.g_varchar2) Then
854: p_rec.attribute4 :=
855: per_ssl_shd.g_old_rec.attribute4;
856: End If;
857: If (p_rec.attribute5 = hr_api.g_varchar2) Then
858: p_rec.attribute5 :=
859: per_ssl_shd.g_old_rec.attribute5;
860: End If;
861: If (p_rec.attribute6 = hr_api.g_varchar2) Then

Line 861: If (p_rec.attribute6 = hr_api.g_varchar2) Then

857: If (p_rec.attribute5 = hr_api.g_varchar2) Then
858: p_rec.attribute5 :=
859: per_ssl_shd.g_old_rec.attribute5;
860: End If;
861: If (p_rec.attribute6 = hr_api.g_varchar2) Then
862: p_rec.attribute6 :=
863: per_ssl_shd.g_old_rec.attribute6;
864: End If;
865: If (p_rec.attribute7 = hr_api.g_varchar2) Then

Line 865: If (p_rec.attribute7 = hr_api.g_varchar2) Then

861: If (p_rec.attribute6 = hr_api.g_varchar2) Then
862: p_rec.attribute6 :=
863: per_ssl_shd.g_old_rec.attribute6;
864: End If;
865: If (p_rec.attribute7 = hr_api.g_varchar2) Then
866: p_rec.attribute7 :=
867: per_ssl_shd.g_old_rec.attribute7;
868: End If;
869: If (p_rec.attribute8 = hr_api.g_varchar2) Then

Line 869: If (p_rec.attribute8 = hr_api.g_varchar2) Then

865: If (p_rec.attribute7 = hr_api.g_varchar2) Then
866: p_rec.attribute7 :=
867: per_ssl_shd.g_old_rec.attribute7;
868: End If;
869: If (p_rec.attribute8 = hr_api.g_varchar2) Then
870: p_rec.attribute8 :=
871: per_ssl_shd.g_old_rec.attribute8;
872: End If;
873: If (p_rec.attribute9 = hr_api.g_varchar2) Then

Line 873: If (p_rec.attribute9 = hr_api.g_varchar2) Then

869: If (p_rec.attribute8 = hr_api.g_varchar2) Then
870: p_rec.attribute8 :=
871: per_ssl_shd.g_old_rec.attribute8;
872: End If;
873: If (p_rec.attribute9 = hr_api.g_varchar2) Then
874: p_rec.attribute9 :=
875: per_ssl_shd.g_old_rec.attribute9;
876: End If;
877: If (p_rec.attribute10 = hr_api.g_varchar2) Then

Line 877: If (p_rec.attribute10 = hr_api.g_varchar2) Then

873: If (p_rec.attribute9 = hr_api.g_varchar2) Then
874: p_rec.attribute9 :=
875: per_ssl_shd.g_old_rec.attribute9;
876: End If;
877: If (p_rec.attribute10 = hr_api.g_varchar2) Then
878: p_rec.attribute10 :=
879: per_ssl_shd.g_old_rec.attribute10;
880: End If;
881: If (p_rec.attribute11 = hr_api.g_varchar2) Then

Line 881: If (p_rec.attribute11 = hr_api.g_varchar2) Then

877: If (p_rec.attribute10 = hr_api.g_varchar2) Then
878: p_rec.attribute10 :=
879: per_ssl_shd.g_old_rec.attribute10;
880: End If;
881: If (p_rec.attribute11 = hr_api.g_varchar2) Then
882: p_rec.attribute11 :=
883: per_ssl_shd.g_old_rec.attribute11;
884: End If;
885: If (p_rec.attribute12 = hr_api.g_varchar2) Then

Line 885: If (p_rec.attribute12 = hr_api.g_varchar2) Then

881: If (p_rec.attribute11 = hr_api.g_varchar2) Then
882: p_rec.attribute11 :=
883: per_ssl_shd.g_old_rec.attribute11;
884: End If;
885: If (p_rec.attribute12 = hr_api.g_varchar2) Then
886: p_rec.attribute12 :=
887: per_ssl_shd.g_old_rec.attribute12;
888: End If;
889: If (p_rec.attribute13 = hr_api.g_varchar2) Then

Line 889: If (p_rec.attribute13 = hr_api.g_varchar2) Then

885: If (p_rec.attribute12 = hr_api.g_varchar2) Then
886: p_rec.attribute12 :=
887: per_ssl_shd.g_old_rec.attribute12;
888: End If;
889: If (p_rec.attribute13 = hr_api.g_varchar2) Then
890: p_rec.attribute13 :=
891: per_ssl_shd.g_old_rec.attribute13;
892: End If;
893: If (p_rec.attribute14 = hr_api.g_varchar2) Then

Line 893: If (p_rec.attribute14 = hr_api.g_varchar2) Then

889: If (p_rec.attribute13 = hr_api.g_varchar2) Then
890: p_rec.attribute13 :=
891: per_ssl_shd.g_old_rec.attribute13;
892: End If;
893: If (p_rec.attribute14 = hr_api.g_varchar2) Then
894: p_rec.attribute14 :=
895: per_ssl_shd.g_old_rec.attribute14;
896: End If;
897: If (p_rec.attribute15 = hr_api.g_varchar2) Then

Line 897: If (p_rec.attribute15 = hr_api.g_varchar2) Then

893: If (p_rec.attribute14 = hr_api.g_varchar2) Then
894: p_rec.attribute14 :=
895: per_ssl_shd.g_old_rec.attribute14;
896: End If;
897: If (p_rec.attribute15 = hr_api.g_varchar2) Then
898: p_rec.attribute15 :=
899: per_ssl_shd.g_old_rec.attribute15;
900: End If;
901: If (p_rec.attribute16 = hr_api.g_varchar2) Then

Line 901: If (p_rec.attribute16 = hr_api.g_varchar2) Then

897: If (p_rec.attribute15 = hr_api.g_varchar2) Then
898: p_rec.attribute15 :=
899: per_ssl_shd.g_old_rec.attribute15;
900: End If;
901: If (p_rec.attribute16 = hr_api.g_varchar2) Then
902: p_rec.attribute16 :=
903: per_ssl_shd.g_old_rec.attribute16;
904: End If;
905: If (p_rec.attribute17 = hr_api.g_varchar2) Then

Line 905: If (p_rec.attribute17 = hr_api.g_varchar2) Then

901: If (p_rec.attribute16 = hr_api.g_varchar2) Then
902: p_rec.attribute16 :=
903: per_ssl_shd.g_old_rec.attribute16;
904: End If;
905: If (p_rec.attribute17 = hr_api.g_varchar2) Then
906: p_rec.attribute17 :=
907: per_ssl_shd.g_old_rec.attribute17;
908: End If;
909: If (p_rec.attribute18 = hr_api.g_varchar2) Then

Line 909: If (p_rec.attribute18 = hr_api.g_varchar2) Then

905: If (p_rec.attribute17 = hr_api.g_varchar2) Then
906: p_rec.attribute17 :=
907: per_ssl_shd.g_old_rec.attribute17;
908: End If;
909: If (p_rec.attribute18 = hr_api.g_varchar2) Then
910: p_rec.attribute18 :=
911: per_ssl_shd.g_old_rec.attribute18;
912: End If;
913: If (p_rec.attribute19 = hr_api.g_varchar2) Then

Line 913: If (p_rec.attribute19 = hr_api.g_varchar2) Then

909: If (p_rec.attribute18 = hr_api.g_varchar2) Then
910: p_rec.attribute18 :=
911: per_ssl_shd.g_old_rec.attribute18;
912: End If;
913: If (p_rec.attribute19 = hr_api.g_varchar2) Then
914: p_rec.attribute19 :=
915: per_ssl_shd.g_old_rec.attribute19;
916: End If;
917: If (p_rec.attribute20 = hr_api.g_varchar2) Then

Line 917: If (p_rec.attribute20 = hr_api.g_varchar2) Then

913: If (p_rec.attribute19 = hr_api.g_varchar2) Then
914: p_rec.attribute19 :=
915: per_ssl_shd.g_old_rec.attribute19;
916: End If;
917: If (p_rec.attribute20 = hr_api.g_varchar2) Then
918: p_rec.attribute20 :=
919: per_ssl_shd.g_old_rec.attribute20;
920: End If;
921: /*Added for Enhancement 4021737 */

Line 922: If (p_rec.attribute21 = hr_api.g_varchar2) Then

918: p_rec.attribute20 :=
919: per_ssl_shd.g_old_rec.attribute20;
920: End If;
921: /*Added for Enhancement 4021737 */
922: If (p_rec.attribute21 = hr_api.g_varchar2) Then
923: p_rec.attribute21 :=
924: per_ssl_shd.g_old_rec.attribute21;
925: End If;
926: If (p_rec.attribute22 = hr_api.g_varchar2) Then

Line 926: If (p_rec.attribute22 = hr_api.g_varchar2) Then

922: If (p_rec.attribute21 = hr_api.g_varchar2) Then
923: p_rec.attribute21 :=
924: per_ssl_shd.g_old_rec.attribute21;
925: End If;
926: If (p_rec.attribute22 = hr_api.g_varchar2) Then
927: p_rec.attribute22 :=
928: per_ssl_shd.g_old_rec.attribute22;
929: End If;
930: If (p_rec.attribute23 = hr_api.g_varchar2) Then

Line 930: If (p_rec.attribute23 = hr_api.g_varchar2) Then

926: If (p_rec.attribute22 = hr_api.g_varchar2) Then
927: p_rec.attribute22 :=
928: per_ssl_shd.g_old_rec.attribute22;
929: End If;
930: If (p_rec.attribute23 = hr_api.g_varchar2) Then
931: p_rec.attribute23 :=
932: per_ssl_shd.g_old_rec.attribute23;
933: End If;
934: If (p_rec.attribute24 = hr_api.g_varchar2) Then

Line 934: If (p_rec.attribute24 = hr_api.g_varchar2) Then

930: If (p_rec.attribute23 = hr_api.g_varchar2) Then
931: p_rec.attribute23 :=
932: per_ssl_shd.g_old_rec.attribute23;
933: End If;
934: If (p_rec.attribute24 = hr_api.g_varchar2) Then
935: p_rec.attribute24 :=
936: per_ssl_shd.g_old_rec.attribute24;
937: End If;
938: If (p_rec.attribute25 = hr_api.g_varchar2) Then

Line 938: If (p_rec.attribute25 = hr_api.g_varchar2) Then

934: If (p_rec.attribute24 = hr_api.g_varchar2) Then
935: p_rec.attribute24 :=
936: per_ssl_shd.g_old_rec.attribute24;
937: End If;
938: If (p_rec.attribute25 = hr_api.g_varchar2) Then
939: p_rec.attribute25 :=
940: per_ssl_shd.g_old_rec.attribute25;
941: End If;
942: If (p_rec.attribute26 = hr_api.g_varchar2) Then

Line 942: If (p_rec.attribute26 = hr_api.g_varchar2) Then

938: If (p_rec.attribute25 = hr_api.g_varchar2) Then
939: p_rec.attribute25 :=
940: per_ssl_shd.g_old_rec.attribute25;
941: End If;
942: If (p_rec.attribute26 = hr_api.g_varchar2) Then
943: p_rec.attribute26 :=
944: per_ssl_shd.g_old_rec.attribute26;
945: End If;
946: If (p_rec.attribute27 = hr_api.g_varchar2) Then

Line 946: If (p_rec.attribute27 = hr_api.g_varchar2) Then

942: If (p_rec.attribute26 = hr_api.g_varchar2) Then
943: p_rec.attribute26 :=
944: per_ssl_shd.g_old_rec.attribute26;
945: End If;
946: If (p_rec.attribute27 = hr_api.g_varchar2) Then
947: p_rec.attribute27 :=
948: per_ssl_shd.g_old_rec.attribute27;
949: End If;
950: If (p_rec.attribute28 = hr_api.g_varchar2) Then

Line 950: If (p_rec.attribute28 = hr_api.g_varchar2) Then

946: If (p_rec.attribute27 = hr_api.g_varchar2) Then
947: p_rec.attribute27 :=
948: per_ssl_shd.g_old_rec.attribute27;
949: End If;
950: If (p_rec.attribute28 = hr_api.g_varchar2) Then
951: p_rec.attribute28 :=
952: per_ssl_shd.g_old_rec.attribute28;
953: End If;
954: If (p_rec.attribute29 = hr_api.g_varchar2) Then

Line 954: If (p_rec.attribute29 = hr_api.g_varchar2) Then

950: If (p_rec.attribute28 = hr_api.g_varchar2) Then
951: p_rec.attribute28 :=
952: per_ssl_shd.g_old_rec.attribute28;
953: End If;
954: If (p_rec.attribute29 = hr_api.g_varchar2) Then
955: p_rec.attribute29 :=
956: per_ssl_shd.g_old_rec.attribute29;
957: End If;
958: If (p_rec.attribute30 = hr_api.g_varchar2) Then

Line 958: If (p_rec.attribute30 = hr_api.g_varchar2) Then

954: If (p_rec.attribute29 = hr_api.g_varchar2) Then
955: p_rec.attribute29 :=
956: per_ssl_shd.g_old_rec.attribute29;
957: End If;
958: If (p_rec.attribute30 = hr_api.g_varchar2) Then
959: p_rec.attribute30 :=
960: per_ssl_shd.g_old_rec.attribute30;
961: End If;
962: /*End Enhancement 4021737 */

Line 1019: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,

1015: Procedure upd
1016: (
1017: p_salary_survey_line_id in number,
1018: p_object_version_number in out nocopy number,
1019: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
1020: p_survey_region_code in varchar2 default hr_api.g_varchar2,
1021: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
1022: p_company_size_code in varchar2 default hr_api.g_varchar2,
1023: p_industry_code in varchar2 default hr_api.g_varchar2,

Line 1020: p_survey_region_code in varchar2 default hr_api.g_varchar2,

1016: (
1017: p_salary_survey_line_id in number,
1018: p_object_version_number in out nocopy number,
1019: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
1020: p_survey_region_code in varchar2 default hr_api.g_varchar2,
1021: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
1022: p_company_size_code in varchar2 default hr_api.g_varchar2,
1023: p_industry_code in varchar2 default hr_api.g_varchar2,
1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,

Line 1021: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,

1017: p_salary_survey_line_id in number,
1018: p_object_version_number in out nocopy number,
1019: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
1020: p_survey_region_code in varchar2 default hr_api.g_varchar2,
1021: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
1022: p_company_size_code in varchar2 default hr_api.g_varchar2,
1023: p_industry_code in varchar2 default hr_api.g_varchar2,
1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,
1025: p_start_date in date default hr_api.g_date,

Line 1022: p_company_size_code in varchar2 default hr_api.g_varchar2,

1018: p_object_version_number in out nocopy number,
1019: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
1020: p_survey_region_code in varchar2 default hr_api.g_varchar2,
1021: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
1022: p_company_size_code in varchar2 default hr_api.g_varchar2,
1023: p_industry_code in varchar2 default hr_api.g_varchar2,
1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,
1025: p_start_date in date default hr_api.g_date,
1026: p_end_date in date default hr_api.g_date,

Line 1023: p_industry_code in varchar2 default hr_api.g_varchar2,

1019: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
1020: p_survey_region_code in varchar2 default hr_api.g_varchar2,
1021: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
1022: p_company_size_code in varchar2 default hr_api.g_varchar2,
1023: p_industry_code in varchar2 default hr_api.g_varchar2,
1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,
1025: p_start_date in date default hr_api.g_date,
1026: p_end_date in date default hr_api.g_date,
1027: p_currency_code in varchar2 default hr_api.g_varchar2,

Line 1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,

1020: p_survey_region_code in varchar2 default hr_api.g_varchar2,
1021: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
1022: p_company_size_code in varchar2 default hr_api.g_varchar2,
1023: p_industry_code in varchar2 default hr_api.g_varchar2,
1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,
1025: p_start_date in date default hr_api.g_date,
1026: p_end_date in date default hr_api.g_date,
1027: p_currency_code in varchar2 default hr_api.g_varchar2,
1028: p_differential in number default hr_api.g_number,

Line 1025: p_start_date in date default hr_api.g_date,

1021: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
1022: p_company_size_code in varchar2 default hr_api.g_varchar2,
1023: p_industry_code in varchar2 default hr_api.g_varchar2,
1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,
1025: p_start_date in date default hr_api.g_date,
1026: p_end_date in date default hr_api.g_date,
1027: p_currency_code in varchar2 default hr_api.g_varchar2,
1028: p_differential in number default hr_api.g_number,
1029: p_minimum_pay in number default hr_api.g_number,

Line 1026: p_end_date in date default hr_api.g_date,

1022: p_company_size_code in varchar2 default hr_api.g_varchar2,
1023: p_industry_code in varchar2 default hr_api.g_varchar2,
1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,
1025: p_start_date in date default hr_api.g_date,
1026: p_end_date in date default hr_api.g_date,
1027: p_currency_code in varchar2 default hr_api.g_varchar2,
1028: p_differential in number default hr_api.g_number,
1029: p_minimum_pay in number default hr_api.g_number,
1030: p_mean_pay in number default hr_api.g_number,

Line 1027: p_currency_code in varchar2 default hr_api.g_varchar2,

1023: p_industry_code in varchar2 default hr_api.g_varchar2,
1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,
1025: p_start_date in date default hr_api.g_date,
1026: p_end_date in date default hr_api.g_date,
1027: p_currency_code in varchar2 default hr_api.g_varchar2,
1028: p_differential in number default hr_api.g_number,
1029: p_minimum_pay in number default hr_api.g_number,
1030: p_mean_pay in number default hr_api.g_number,
1031: p_maximum_pay in number default hr_api.g_number,

Line 1028: p_differential in number default hr_api.g_number,

1024: p_survey_age_code in varchar2 default hr_api.g_varchar2,
1025: p_start_date in date default hr_api.g_date,
1026: p_end_date in date default hr_api.g_date,
1027: p_currency_code in varchar2 default hr_api.g_varchar2,
1028: p_differential in number default hr_api.g_number,
1029: p_minimum_pay in number default hr_api.g_number,
1030: p_mean_pay in number default hr_api.g_number,
1031: p_maximum_pay in number default hr_api.g_number,
1032: p_graduate_pay in number default hr_api.g_number,

Line 1029: p_minimum_pay in number default hr_api.g_number,

1025: p_start_date in date default hr_api.g_date,
1026: p_end_date in date default hr_api.g_date,
1027: p_currency_code in varchar2 default hr_api.g_varchar2,
1028: p_differential in number default hr_api.g_number,
1029: p_minimum_pay in number default hr_api.g_number,
1030: p_mean_pay in number default hr_api.g_number,
1031: p_maximum_pay in number default hr_api.g_number,
1032: p_graduate_pay in number default hr_api.g_number,
1033: p_starting_pay in number default hr_api.g_number,

Line 1030: p_mean_pay in number default hr_api.g_number,

1026: p_end_date in date default hr_api.g_date,
1027: p_currency_code in varchar2 default hr_api.g_varchar2,
1028: p_differential in number default hr_api.g_number,
1029: p_minimum_pay in number default hr_api.g_number,
1030: p_mean_pay in number default hr_api.g_number,
1031: p_maximum_pay in number default hr_api.g_number,
1032: p_graduate_pay in number default hr_api.g_number,
1033: p_starting_pay in number default hr_api.g_number,
1034: p_percentage_change in number default hr_api.g_number,

Line 1031: p_maximum_pay in number default hr_api.g_number,

1027: p_currency_code in varchar2 default hr_api.g_varchar2,
1028: p_differential in number default hr_api.g_number,
1029: p_minimum_pay in number default hr_api.g_number,
1030: p_mean_pay in number default hr_api.g_number,
1031: p_maximum_pay in number default hr_api.g_number,
1032: p_graduate_pay in number default hr_api.g_number,
1033: p_starting_pay in number default hr_api.g_number,
1034: p_percentage_change in number default hr_api.g_number,
1035: p_job_first_quartile in number default hr_api.g_number,

Line 1032: p_graduate_pay in number default hr_api.g_number,

1028: p_differential in number default hr_api.g_number,
1029: p_minimum_pay in number default hr_api.g_number,
1030: p_mean_pay in number default hr_api.g_number,
1031: p_maximum_pay in number default hr_api.g_number,
1032: p_graduate_pay in number default hr_api.g_number,
1033: p_starting_pay in number default hr_api.g_number,
1034: p_percentage_change in number default hr_api.g_number,
1035: p_job_first_quartile in number default hr_api.g_number,
1036: p_job_median_quartile in number default hr_api.g_number,

Line 1033: p_starting_pay in number default hr_api.g_number,

1029: p_minimum_pay in number default hr_api.g_number,
1030: p_mean_pay in number default hr_api.g_number,
1031: p_maximum_pay in number default hr_api.g_number,
1032: p_graduate_pay in number default hr_api.g_number,
1033: p_starting_pay in number default hr_api.g_number,
1034: p_percentage_change in number default hr_api.g_number,
1035: p_job_first_quartile in number default hr_api.g_number,
1036: p_job_median_quartile in number default hr_api.g_number,
1037: p_job_third_quartile in number default hr_api.g_number,

Line 1034: p_percentage_change in number default hr_api.g_number,

1030: p_mean_pay in number default hr_api.g_number,
1031: p_maximum_pay in number default hr_api.g_number,
1032: p_graduate_pay in number default hr_api.g_number,
1033: p_starting_pay in number default hr_api.g_number,
1034: p_percentage_change in number default hr_api.g_number,
1035: p_job_first_quartile in number default hr_api.g_number,
1036: p_job_median_quartile in number default hr_api.g_number,
1037: p_job_third_quartile in number default hr_api.g_number,
1038: p_job_fourth_quartile in number default hr_api.g_number,

Line 1035: p_job_first_quartile in number default hr_api.g_number,

1031: p_maximum_pay in number default hr_api.g_number,
1032: p_graduate_pay in number default hr_api.g_number,
1033: p_starting_pay in number default hr_api.g_number,
1034: p_percentage_change in number default hr_api.g_number,
1035: p_job_first_quartile in number default hr_api.g_number,
1036: p_job_median_quartile in number default hr_api.g_number,
1037: p_job_third_quartile in number default hr_api.g_number,
1038: p_job_fourth_quartile in number default hr_api.g_number,
1039: p_minimum_total_compensation in number default hr_api.g_number,

Line 1036: p_job_median_quartile in number default hr_api.g_number,

1032: p_graduate_pay in number default hr_api.g_number,
1033: p_starting_pay in number default hr_api.g_number,
1034: p_percentage_change in number default hr_api.g_number,
1035: p_job_first_quartile in number default hr_api.g_number,
1036: p_job_median_quartile in number default hr_api.g_number,
1037: p_job_third_quartile in number default hr_api.g_number,
1038: p_job_fourth_quartile in number default hr_api.g_number,
1039: p_minimum_total_compensation in number default hr_api.g_number,
1040: p_mean_total_compensation in number default hr_api.g_number,

Line 1037: p_job_third_quartile in number default hr_api.g_number,

1033: p_starting_pay in number default hr_api.g_number,
1034: p_percentage_change in number default hr_api.g_number,
1035: p_job_first_quartile in number default hr_api.g_number,
1036: p_job_median_quartile in number default hr_api.g_number,
1037: p_job_third_quartile in number default hr_api.g_number,
1038: p_job_fourth_quartile in number default hr_api.g_number,
1039: p_minimum_total_compensation in number default hr_api.g_number,
1040: p_mean_total_compensation in number default hr_api.g_number,
1041: p_maximum_total_compensation in number default hr_api.g_number,

Line 1038: p_job_fourth_quartile in number default hr_api.g_number,

1034: p_percentage_change in number default hr_api.g_number,
1035: p_job_first_quartile in number default hr_api.g_number,
1036: p_job_median_quartile in number default hr_api.g_number,
1037: p_job_third_quartile in number default hr_api.g_number,
1038: p_job_fourth_quartile in number default hr_api.g_number,
1039: p_minimum_total_compensation in number default hr_api.g_number,
1040: p_mean_total_compensation in number default hr_api.g_number,
1041: p_maximum_total_compensation in number default hr_api.g_number,
1042: p_compnstn_first_quartile in number default hr_api.g_number,

Line 1039: p_minimum_total_compensation in number default hr_api.g_number,

1035: p_job_first_quartile in number default hr_api.g_number,
1036: p_job_median_quartile in number default hr_api.g_number,
1037: p_job_third_quartile in number default hr_api.g_number,
1038: p_job_fourth_quartile in number default hr_api.g_number,
1039: p_minimum_total_compensation in number default hr_api.g_number,
1040: p_mean_total_compensation in number default hr_api.g_number,
1041: p_maximum_total_compensation in number default hr_api.g_number,
1042: p_compnstn_first_quartile in number default hr_api.g_number,
1043: p_compnstn_median_quartile in number default hr_api.g_number,

Line 1040: p_mean_total_compensation in number default hr_api.g_number,

1036: p_job_median_quartile in number default hr_api.g_number,
1037: p_job_third_quartile in number default hr_api.g_number,
1038: p_job_fourth_quartile in number default hr_api.g_number,
1039: p_minimum_total_compensation in number default hr_api.g_number,
1040: p_mean_total_compensation in number default hr_api.g_number,
1041: p_maximum_total_compensation in number default hr_api.g_number,
1042: p_compnstn_first_quartile in number default hr_api.g_number,
1043: p_compnstn_median_quartile in number default hr_api.g_number,
1044: p_compnstn_third_quartile in number default hr_api.g_number,

Line 1041: p_maximum_total_compensation in number default hr_api.g_number,

1037: p_job_third_quartile in number default hr_api.g_number,
1038: p_job_fourth_quartile in number default hr_api.g_number,
1039: p_minimum_total_compensation in number default hr_api.g_number,
1040: p_mean_total_compensation in number default hr_api.g_number,
1041: p_maximum_total_compensation in number default hr_api.g_number,
1042: p_compnstn_first_quartile in number default hr_api.g_number,
1043: p_compnstn_median_quartile in number default hr_api.g_number,
1044: p_compnstn_third_quartile in number default hr_api.g_number,
1045: p_compnstn_fourth_quartile in number default hr_api.g_number,

Line 1042: p_compnstn_first_quartile in number default hr_api.g_number,

1038: p_job_fourth_quartile in number default hr_api.g_number,
1039: p_minimum_total_compensation in number default hr_api.g_number,
1040: p_mean_total_compensation in number default hr_api.g_number,
1041: p_maximum_total_compensation in number default hr_api.g_number,
1042: p_compnstn_first_quartile in number default hr_api.g_number,
1043: p_compnstn_median_quartile in number default hr_api.g_number,
1044: p_compnstn_third_quartile in number default hr_api.g_number,
1045: p_compnstn_fourth_quartile in number default hr_api.g_number,
1046: /*Added for Enhancement 4021737 */

Line 1043: p_compnstn_median_quartile in number default hr_api.g_number,

1039: p_minimum_total_compensation in number default hr_api.g_number,
1040: p_mean_total_compensation in number default hr_api.g_number,
1041: p_maximum_total_compensation in number default hr_api.g_number,
1042: p_compnstn_first_quartile in number default hr_api.g_number,
1043: p_compnstn_median_quartile in number default hr_api.g_number,
1044: p_compnstn_third_quartile in number default hr_api.g_number,
1045: p_compnstn_fourth_quartile in number default hr_api.g_number,
1046: /*Added for Enhancement 4021737 */
1047: p_tenth_percentile in number default hr_api.g_number,

Line 1044: p_compnstn_third_quartile in number default hr_api.g_number,

1040: p_mean_total_compensation in number default hr_api.g_number,
1041: p_maximum_total_compensation in number default hr_api.g_number,
1042: p_compnstn_first_quartile in number default hr_api.g_number,
1043: p_compnstn_median_quartile in number default hr_api.g_number,
1044: p_compnstn_third_quartile in number default hr_api.g_number,
1045: p_compnstn_fourth_quartile in number default hr_api.g_number,
1046: /*Added for Enhancement 4021737 */
1047: p_tenth_percentile in number default hr_api.g_number,
1048: p_twenty_fifth_percentile in number default hr_api.g_number,

Line 1045: p_compnstn_fourth_quartile in number default hr_api.g_number,

1041: p_maximum_total_compensation in number default hr_api.g_number,
1042: p_compnstn_first_quartile in number default hr_api.g_number,
1043: p_compnstn_median_quartile in number default hr_api.g_number,
1044: p_compnstn_third_quartile in number default hr_api.g_number,
1045: p_compnstn_fourth_quartile in number default hr_api.g_number,
1046: /*Added for Enhancement 4021737 */
1047: p_tenth_percentile in number default hr_api.g_number,
1048: p_twenty_fifth_percentile in number default hr_api.g_number,
1049: p_fiftieth_percentile in number default hr_api.g_number,

Line 1047: p_tenth_percentile in number default hr_api.g_number,

1043: p_compnstn_median_quartile in number default hr_api.g_number,
1044: p_compnstn_third_quartile in number default hr_api.g_number,
1045: p_compnstn_fourth_quartile in number default hr_api.g_number,
1046: /*Added for Enhancement 4021737 */
1047: p_tenth_percentile in number default hr_api.g_number,
1048: p_twenty_fifth_percentile in number default hr_api.g_number,
1049: p_fiftieth_percentile in number default hr_api.g_number,
1050: p_seventy_fifth_percentile in number default hr_api.g_number,
1051: p_ninetieth_percentile in number default hr_api.g_number,

Line 1048: p_twenty_fifth_percentile in number default hr_api.g_number,

1044: p_compnstn_third_quartile in number default hr_api.g_number,
1045: p_compnstn_fourth_quartile in number default hr_api.g_number,
1046: /*Added for Enhancement 4021737 */
1047: p_tenth_percentile in number default hr_api.g_number,
1048: p_twenty_fifth_percentile in number default hr_api.g_number,
1049: p_fiftieth_percentile in number default hr_api.g_number,
1050: p_seventy_fifth_percentile in number default hr_api.g_number,
1051: p_ninetieth_percentile in number default hr_api.g_number,
1052: p_minimum_bonus in number default hr_api.g_number,

Line 1049: p_fiftieth_percentile in number default hr_api.g_number,

1045: p_compnstn_fourth_quartile in number default hr_api.g_number,
1046: /*Added for Enhancement 4021737 */
1047: p_tenth_percentile in number default hr_api.g_number,
1048: p_twenty_fifth_percentile in number default hr_api.g_number,
1049: p_fiftieth_percentile in number default hr_api.g_number,
1050: p_seventy_fifth_percentile in number default hr_api.g_number,
1051: p_ninetieth_percentile in number default hr_api.g_number,
1052: p_minimum_bonus in number default hr_api.g_number,
1053: p_mean_bonus in number default hr_api.g_number,

Line 1050: p_seventy_fifth_percentile in number default hr_api.g_number,

1046: /*Added for Enhancement 4021737 */
1047: p_tenth_percentile in number default hr_api.g_number,
1048: p_twenty_fifth_percentile in number default hr_api.g_number,
1049: p_fiftieth_percentile in number default hr_api.g_number,
1050: p_seventy_fifth_percentile in number default hr_api.g_number,
1051: p_ninetieth_percentile in number default hr_api.g_number,
1052: p_minimum_bonus in number default hr_api.g_number,
1053: p_mean_bonus in number default hr_api.g_number,
1054: p_maximum_bonus in number default hr_api.g_number,

Line 1051: p_ninetieth_percentile in number default hr_api.g_number,

1047: p_tenth_percentile in number default hr_api.g_number,
1048: p_twenty_fifth_percentile in number default hr_api.g_number,
1049: p_fiftieth_percentile in number default hr_api.g_number,
1050: p_seventy_fifth_percentile in number default hr_api.g_number,
1051: p_ninetieth_percentile in number default hr_api.g_number,
1052: p_minimum_bonus in number default hr_api.g_number,
1053: p_mean_bonus in number default hr_api.g_number,
1054: p_maximum_bonus in number default hr_api.g_number,
1055: p_minimum_salary_increase in number default hr_api.g_number,

Line 1052: p_minimum_bonus in number default hr_api.g_number,

1048: p_twenty_fifth_percentile in number default hr_api.g_number,
1049: p_fiftieth_percentile in number default hr_api.g_number,
1050: p_seventy_fifth_percentile in number default hr_api.g_number,
1051: p_ninetieth_percentile in number default hr_api.g_number,
1052: p_minimum_bonus in number default hr_api.g_number,
1053: p_mean_bonus in number default hr_api.g_number,
1054: p_maximum_bonus in number default hr_api.g_number,
1055: p_minimum_salary_increase in number default hr_api.g_number,
1056: p_mean_salary_increase in number default hr_api.g_number,

Line 1053: p_mean_bonus in number default hr_api.g_number,

1049: p_fiftieth_percentile in number default hr_api.g_number,
1050: p_seventy_fifth_percentile in number default hr_api.g_number,
1051: p_ninetieth_percentile in number default hr_api.g_number,
1052: p_minimum_bonus in number default hr_api.g_number,
1053: p_mean_bonus in number default hr_api.g_number,
1054: p_maximum_bonus in number default hr_api.g_number,
1055: p_minimum_salary_increase in number default hr_api.g_number,
1056: p_mean_salary_increase in number default hr_api.g_number,
1057: p_maximum_salary_increase in number default hr_api.g_number,

Line 1054: p_maximum_bonus in number default hr_api.g_number,

1050: p_seventy_fifth_percentile in number default hr_api.g_number,
1051: p_ninetieth_percentile in number default hr_api.g_number,
1052: p_minimum_bonus in number default hr_api.g_number,
1053: p_mean_bonus in number default hr_api.g_number,
1054: p_maximum_bonus in number default hr_api.g_number,
1055: p_minimum_salary_increase in number default hr_api.g_number,
1056: p_mean_salary_increase in number default hr_api.g_number,
1057: p_maximum_salary_increase in number default hr_api.g_number,
1058: p_min_variable_compensation in number default hr_api.g_number,

Line 1055: p_minimum_salary_increase in number default hr_api.g_number,

1051: p_ninetieth_percentile in number default hr_api.g_number,
1052: p_minimum_bonus in number default hr_api.g_number,
1053: p_mean_bonus in number default hr_api.g_number,
1054: p_maximum_bonus in number default hr_api.g_number,
1055: p_minimum_salary_increase in number default hr_api.g_number,
1056: p_mean_salary_increase in number default hr_api.g_number,
1057: p_maximum_salary_increase in number default hr_api.g_number,
1058: p_min_variable_compensation in number default hr_api.g_number,
1059: p_mean_variable_compensation in number default hr_api.g_number,

Line 1056: p_mean_salary_increase in number default hr_api.g_number,

1052: p_minimum_bonus in number default hr_api.g_number,
1053: p_mean_bonus in number default hr_api.g_number,
1054: p_maximum_bonus in number default hr_api.g_number,
1055: p_minimum_salary_increase in number default hr_api.g_number,
1056: p_mean_salary_increase in number default hr_api.g_number,
1057: p_maximum_salary_increase in number default hr_api.g_number,
1058: p_min_variable_compensation in number default hr_api.g_number,
1059: p_mean_variable_compensation in number default hr_api.g_number,
1060: p_max_variable_compensation in number default hr_api.g_number,

Line 1057: p_maximum_salary_increase in number default hr_api.g_number,

1053: p_mean_bonus in number default hr_api.g_number,
1054: p_maximum_bonus in number default hr_api.g_number,
1055: p_minimum_salary_increase in number default hr_api.g_number,
1056: p_mean_salary_increase in number default hr_api.g_number,
1057: p_maximum_salary_increase in number default hr_api.g_number,
1058: p_min_variable_compensation in number default hr_api.g_number,
1059: p_mean_variable_compensation in number default hr_api.g_number,
1060: p_max_variable_compensation in number default hr_api.g_number,
1061: p_minimum_stock in number default hr_api.g_number,

Line 1058: p_min_variable_compensation in number default hr_api.g_number,

1054: p_maximum_bonus in number default hr_api.g_number,
1055: p_minimum_salary_increase in number default hr_api.g_number,
1056: p_mean_salary_increase in number default hr_api.g_number,
1057: p_maximum_salary_increase in number default hr_api.g_number,
1058: p_min_variable_compensation in number default hr_api.g_number,
1059: p_mean_variable_compensation in number default hr_api.g_number,
1060: p_max_variable_compensation in number default hr_api.g_number,
1061: p_minimum_stock in number default hr_api.g_number,
1062: p_mean_stock in number default hr_api.g_number,

Line 1059: p_mean_variable_compensation in number default hr_api.g_number,

1055: p_minimum_salary_increase in number default hr_api.g_number,
1056: p_mean_salary_increase in number default hr_api.g_number,
1057: p_maximum_salary_increase in number default hr_api.g_number,
1058: p_min_variable_compensation in number default hr_api.g_number,
1059: p_mean_variable_compensation in number default hr_api.g_number,
1060: p_max_variable_compensation in number default hr_api.g_number,
1061: p_minimum_stock in number default hr_api.g_number,
1062: p_mean_stock in number default hr_api.g_number,
1063: p_maximum_stock in number default hr_api.g_number,

Line 1060: p_max_variable_compensation in number default hr_api.g_number,

1056: p_mean_salary_increase in number default hr_api.g_number,
1057: p_maximum_salary_increase in number default hr_api.g_number,
1058: p_min_variable_compensation in number default hr_api.g_number,
1059: p_mean_variable_compensation in number default hr_api.g_number,
1060: p_max_variable_compensation in number default hr_api.g_number,
1061: p_minimum_stock in number default hr_api.g_number,
1062: p_mean_stock in number default hr_api.g_number,
1063: p_maximum_stock in number default hr_api.g_number,
1064: p_stock_display_type in varchar2 default hr_api.g_varchar2,

Line 1061: p_minimum_stock in number default hr_api.g_number,

1057: p_maximum_salary_increase in number default hr_api.g_number,
1058: p_min_variable_compensation in number default hr_api.g_number,
1059: p_mean_variable_compensation in number default hr_api.g_number,
1060: p_max_variable_compensation in number default hr_api.g_number,
1061: p_minimum_stock in number default hr_api.g_number,
1062: p_mean_stock in number default hr_api.g_number,
1063: p_maximum_stock in number default hr_api.g_number,
1064: p_stock_display_type in varchar2 default hr_api.g_varchar2,
1065: /*End Enhancement 4021737 */

Line 1062: p_mean_stock in number default hr_api.g_number,

1058: p_min_variable_compensation in number default hr_api.g_number,
1059: p_mean_variable_compensation in number default hr_api.g_number,
1060: p_max_variable_compensation in number default hr_api.g_number,
1061: p_minimum_stock in number default hr_api.g_number,
1062: p_mean_stock in number default hr_api.g_number,
1063: p_maximum_stock in number default hr_api.g_number,
1064: p_stock_display_type in varchar2 default hr_api.g_varchar2,
1065: /*End Enhancement 4021737 */
1066: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 1063: p_maximum_stock in number default hr_api.g_number,

1059: p_mean_variable_compensation in number default hr_api.g_number,
1060: p_max_variable_compensation in number default hr_api.g_number,
1061: p_minimum_stock in number default hr_api.g_number,
1062: p_mean_stock in number default hr_api.g_number,
1063: p_maximum_stock in number default hr_api.g_number,
1064: p_stock_display_type in varchar2 default hr_api.g_varchar2,
1065: /*End Enhancement 4021737 */
1066: p_attribute_category in varchar2 default hr_api.g_varchar2,
1067: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 1064: p_stock_display_type in varchar2 default hr_api.g_varchar2,

1060: p_max_variable_compensation in number default hr_api.g_number,
1061: p_minimum_stock in number default hr_api.g_number,
1062: p_mean_stock in number default hr_api.g_number,
1063: p_maximum_stock in number default hr_api.g_number,
1064: p_stock_display_type in varchar2 default hr_api.g_varchar2,
1065: /*End Enhancement 4021737 */
1066: p_attribute_category in varchar2 default hr_api.g_varchar2,
1067: p_attribute1 in varchar2 default hr_api.g_varchar2,
1068: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 1066: p_attribute_category in varchar2 default hr_api.g_varchar2,

1062: p_mean_stock in number default hr_api.g_number,
1063: p_maximum_stock in number default hr_api.g_number,
1064: p_stock_display_type in varchar2 default hr_api.g_varchar2,
1065: /*End Enhancement 4021737 */
1066: p_attribute_category in varchar2 default hr_api.g_varchar2,
1067: p_attribute1 in varchar2 default hr_api.g_varchar2,
1068: p_attribute2 in varchar2 default hr_api.g_varchar2,
1069: p_attribute3 in varchar2 default hr_api.g_varchar2,
1070: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 1067: p_attribute1 in varchar2 default hr_api.g_varchar2,

1063: p_maximum_stock in number default hr_api.g_number,
1064: p_stock_display_type in varchar2 default hr_api.g_varchar2,
1065: /*End Enhancement 4021737 */
1066: p_attribute_category in varchar2 default hr_api.g_varchar2,
1067: p_attribute1 in varchar2 default hr_api.g_varchar2,
1068: p_attribute2 in varchar2 default hr_api.g_varchar2,
1069: p_attribute3 in varchar2 default hr_api.g_varchar2,
1070: p_attribute4 in varchar2 default hr_api.g_varchar2,
1071: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 1068: p_attribute2 in varchar2 default hr_api.g_varchar2,

1064: p_stock_display_type in varchar2 default hr_api.g_varchar2,
1065: /*End Enhancement 4021737 */
1066: p_attribute_category in varchar2 default hr_api.g_varchar2,
1067: p_attribute1 in varchar2 default hr_api.g_varchar2,
1068: p_attribute2 in varchar2 default hr_api.g_varchar2,
1069: p_attribute3 in varchar2 default hr_api.g_varchar2,
1070: p_attribute4 in varchar2 default hr_api.g_varchar2,
1071: p_attribute5 in varchar2 default hr_api.g_varchar2,
1072: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 1069: p_attribute3 in varchar2 default hr_api.g_varchar2,

1065: /*End Enhancement 4021737 */
1066: p_attribute_category in varchar2 default hr_api.g_varchar2,
1067: p_attribute1 in varchar2 default hr_api.g_varchar2,
1068: p_attribute2 in varchar2 default hr_api.g_varchar2,
1069: p_attribute3 in varchar2 default hr_api.g_varchar2,
1070: p_attribute4 in varchar2 default hr_api.g_varchar2,
1071: p_attribute5 in varchar2 default hr_api.g_varchar2,
1072: p_attribute6 in varchar2 default hr_api.g_varchar2,
1073: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 1070: p_attribute4 in varchar2 default hr_api.g_varchar2,

1066: p_attribute_category in varchar2 default hr_api.g_varchar2,
1067: p_attribute1 in varchar2 default hr_api.g_varchar2,
1068: p_attribute2 in varchar2 default hr_api.g_varchar2,
1069: p_attribute3 in varchar2 default hr_api.g_varchar2,
1070: p_attribute4 in varchar2 default hr_api.g_varchar2,
1071: p_attribute5 in varchar2 default hr_api.g_varchar2,
1072: p_attribute6 in varchar2 default hr_api.g_varchar2,
1073: p_attribute7 in varchar2 default hr_api.g_varchar2,
1074: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 1071: p_attribute5 in varchar2 default hr_api.g_varchar2,

1067: p_attribute1 in varchar2 default hr_api.g_varchar2,
1068: p_attribute2 in varchar2 default hr_api.g_varchar2,
1069: p_attribute3 in varchar2 default hr_api.g_varchar2,
1070: p_attribute4 in varchar2 default hr_api.g_varchar2,
1071: p_attribute5 in varchar2 default hr_api.g_varchar2,
1072: p_attribute6 in varchar2 default hr_api.g_varchar2,
1073: p_attribute7 in varchar2 default hr_api.g_varchar2,
1074: p_attribute8 in varchar2 default hr_api.g_varchar2,
1075: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 1072: p_attribute6 in varchar2 default hr_api.g_varchar2,

1068: p_attribute2 in varchar2 default hr_api.g_varchar2,
1069: p_attribute3 in varchar2 default hr_api.g_varchar2,
1070: p_attribute4 in varchar2 default hr_api.g_varchar2,
1071: p_attribute5 in varchar2 default hr_api.g_varchar2,
1072: p_attribute6 in varchar2 default hr_api.g_varchar2,
1073: p_attribute7 in varchar2 default hr_api.g_varchar2,
1074: p_attribute8 in varchar2 default hr_api.g_varchar2,
1075: p_attribute9 in varchar2 default hr_api.g_varchar2,
1076: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 1073: p_attribute7 in varchar2 default hr_api.g_varchar2,

1069: p_attribute3 in varchar2 default hr_api.g_varchar2,
1070: p_attribute4 in varchar2 default hr_api.g_varchar2,
1071: p_attribute5 in varchar2 default hr_api.g_varchar2,
1072: p_attribute6 in varchar2 default hr_api.g_varchar2,
1073: p_attribute7 in varchar2 default hr_api.g_varchar2,
1074: p_attribute8 in varchar2 default hr_api.g_varchar2,
1075: p_attribute9 in varchar2 default hr_api.g_varchar2,
1076: p_attribute10 in varchar2 default hr_api.g_varchar2,
1077: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 1074: p_attribute8 in varchar2 default hr_api.g_varchar2,

1070: p_attribute4 in varchar2 default hr_api.g_varchar2,
1071: p_attribute5 in varchar2 default hr_api.g_varchar2,
1072: p_attribute6 in varchar2 default hr_api.g_varchar2,
1073: p_attribute7 in varchar2 default hr_api.g_varchar2,
1074: p_attribute8 in varchar2 default hr_api.g_varchar2,
1075: p_attribute9 in varchar2 default hr_api.g_varchar2,
1076: p_attribute10 in varchar2 default hr_api.g_varchar2,
1077: p_attribute11 in varchar2 default hr_api.g_varchar2,
1078: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 1075: p_attribute9 in varchar2 default hr_api.g_varchar2,

1071: p_attribute5 in varchar2 default hr_api.g_varchar2,
1072: p_attribute6 in varchar2 default hr_api.g_varchar2,
1073: p_attribute7 in varchar2 default hr_api.g_varchar2,
1074: p_attribute8 in varchar2 default hr_api.g_varchar2,
1075: p_attribute9 in varchar2 default hr_api.g_varchar2,
1076: p_attribute10 in varchar2 default hr_api.g_varchar2,
1077: p_attribute11 in varchar2 default hr_api.g_varchar2,
1078: p_attribute12 in varchar2 default hr_api.g_varchar2,
1079: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 1076: p_attribute10 in varchar2 default hr_api.g_varchar2,

1072: p_attribute6 in varchar2 default hr_api.g_varchar2,
1073: p_attribute7 in varchar2 default hr_api.g_varchar2,
1074: p_attribute8 in varchar2 default hr_api.g_varchar2,
1075: p_attribute9 in varchar2 default hr_api.g_varchar2,
1076: p_attribute10 in varchar2 default hr_api.g_varchar2,
1077: p_attribute11 in varchar2 default hr_api.g_varchar2,
1078: p_attribute12 in varchar2 default hr_api.g_varchar2,
1079: p_attribute13 in varchar2 default hr_api.g_varchar2,
1080: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 1077: p_attribute11 in varchar2 default hr_api.g_varchar2,

1073: p_attribute7 in varchar2 default hr_api.g_varchar2,
1074: p_attribute8 in varchar2 default hr_api.g_varchar2,
1075: p_attribute9 in varchar2 default hr_api.g_varchar2,
1076: p_attribute10 in varchar2 default hr_api.g_varchar2,
1077: p_attribute11 in varchar2 default hr_api.g_varchar2,
1078: p_attribute12 in varchar2 default hr_api.g_varchar2,
1079: p_attribute13 in varchar2 default hr_api.g_varchar2,
1080: p_attribute14 in varchar2 default hr_api.g_varchar2,
1081: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 1078: p_attribute12 in varchar2 default hr_api.g_varchar2,

1074: p_attribute8 in varchar2 default hr_api.g_varchar2,
1075: p_attribute9 in varchar2 default hr_api.g_varchar2,
1076: p_attribute10 in varchar2 default hr_api.g_varchar2,
1077: p_attribute11 in varchar2 default hr_api.g_varchar2,
1078: p_attribute12 in varchar2 default hr_api.g_varchar2,
1079: p_attribute13 in varchar2 default hr_api.g_varchar2,
1080: p_attribute14 in varchar2 default hr_api.g_varchar2,
1081: p_attribute15 in varchar2 default hr_api.g_varchar2,
1082: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 1079: p_attribute13 in varchar2 default hr_api.g_varchar2,

1075: p_attribute9 in varchar2 default hr_api.g_varchar2,
1076: p_attribute10 in varchar2 default hr_api.g_varchar2,
1077: p_attribute11 in varchar2 default hr_api.g_varchar2,
1078: p_attribute12 in varchar2 default hr_api.g_varchar2,
1079: p_attribute13 in varchar2 default hr_api.g_varchar2,
1080: p_attribute14 in varchar2 default hr_api.g_varchar2,
1081: p_attribute15 in varchar2 default hr_api.g_varchar2,
1082: p_attribute16 in varchar2 default hr_api.g_varchar2,
1083: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 1080: p_attribute14 in varchar2 default hr_api.g_varchar2,

1076: p_attribute10 in varchar2 default hr_api.g_varchar2,
1077: p_attribute11 in varchar2 default hr_api.g_varchar2,
1078: p_attribute12 in varchar2 default hr_api.g_varchar2,
1079: p_attribute13 in varchar2 default hr_api.g_varchar2,
1080: p_attribute14 in varchar2 default hr_api.g_varchar2,
1081: p_attribute15 in varchar2 default hr_api.g_varchar2,
1082: p_attribute16 in varchar2 default hr_api.g_varchar2,
1083: p_attribute17 in varchar2 default hr_api.g_varchar2,
1084: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 1081: p_attribute15 in varchar2 default hr_api.g_varchar2,

1077: p_attribute11 in varchar2 default hr_api.g_varchar2,
1078: p_attribute12 in varchar2 default hr_api.g_varchar2,
1079: p_attribute13 in varchar2 default hr_api.g_varchar2,
1080: p_attribute14 in varchar2 default hr_api.g_varchar2,
1081: p_attribute15 in varchar2 default hr_api.g_varchar2,
1082: p_attribute16 in varchar2 default hr_api.g_varchar2,
1083: p_attribute17 in varchar2 default hr_api.g_varchar2,
1084: p_attribute18 in varchar2 default hr_api.g_varchar2,
1085: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 1082: p_attribute16 in varchar2 default hr_api.g_varchar2,

1078: p_attribute12 in varchar2 default hr_api.g_varchar2,
1079: p_attribute13 in varchar2 default hr_api.g_varchar2,
1080: p_attribute14 in varchar2 default hr_api.g_varchar2,
1081: p_attribute15 in varchar2 default hr_api.g_varchar2,
1082: p_attribute16 in varchar2 default hr_api.g_varchar2,
1083: p_attribute17 in varchar2 default hr_api.g_varchar2,
1084: p_attribute18 in varchar2 default hr_api.g_varchar2,
1085: p_attribute19 in varchar2 default hr_api.g_varchar2,
1086: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 1083: p_attribute17 in varchar2 default hr_api.g_varchar2,

1079: p_attribute13 in varchar2 default hr_api.g_varchar2,
1080: p_attribute14 in varchar2 default hr_api.g_varchar2,
1081: p_attribute15 in varchar2 default hr_api.g_varchar2,
1082: p_attribute16 in varchar2 default hr_api.g_varchar2,
1083: p_attribute17 in varchar2 default hr_api.g_varchar2,
1084: p_attribute18 in varchar2 default hr_api.g_varchar2,
1085: p_attribute19 in varchar2 default hr_api.g_varchar2,
1086: p_attribute20 in varchar2 default hr_api.g_varchar2,
1087: /*Added for Enhancement 4021737 */

Line 1084: p_attribute18 in varchar2 default hr_api.g_varchar2,

1080: p_attribute14 in varchar2 default hr_api.g_varchar2,
1081: p_attribute15 in varchar2 default hr_api.g_varchar2,
1082: p_attribute16 in varchar2 default hr_api.g_varchar2,
1083: p_attribute17 in varchar2 default hr_api.g_varchar2,
1084: p_attribute18 in varchar2 default hr_api.g_varchar2,
1085: p_attribute19 in varchar2 default hr_api.g_varchar2,
1086: p_attribute20 in varchar2 default hr_api.g_varchar2,
1087: /*Added for Enhancement 4021737 */
1088: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 1085: p_attribute19 in varchar2 default hr_api.g_varchar2,

1081: p_attribute15 in varchar2 default hr_api.g_varchar2,
1082: p_attribute16 in varchar2 default hr_api.g_varchar2,
1083: p_attribute17 in varchar2 default hr_api.g_varchar2,
1084: p_attribute18 in varchar2 default hr_api.g_varchar2,
1085: p_attribute19 in varchar2 default hr_api.g_varchar2,
1086: p_attribute20 in varchar2 default hr_api.g_varchar2,
1087: /*Added for Enhancement 4021737 */
1088: p_attribute21 in varchar2 default hr_api.g_varchar2,
1089: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 1086: p_attribute20 in varchar2 default hr_api.g_varchar2,

1082: p_attribute16 in varchar2 default hr_api.g_varchar2,
1083: p_attribute17 in varchar2 default hr_api.g_varchar2,
1084: p_attribute18 in varchar2 default hr_api.g_varchar2,
1085: p_attribute19 in varchar2 default hr_api.g_varchar2,
1086: p_attribute20 in varchar2 default hr_api.g_varchar2,
1087: /*Added for Enhancement 4021737 */
1088: p_attribute21 in varchar2 default hr_api.g_varchar2,
1089: p_attribute22 in varchar2 default hr_api.g_varchar2,
1090: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 1088: p_attribute21 in varchar2 default hr_api.g_varchar2,

1084: p_attribute18 in varchar2 default hr_api.g_varchar2,
1085: p_attribute19 in varchar2 default hr_api.g_varchar2,
1086: p_attribute20 in varchar2 default hr_api.g_varchar2,
1087: /*Added for Enhancement 4021737 */
1088: p_attribute21 in varchar2 default hr_api.g_varchar2,
1089: p_attribute22 in varchar2 default hr_api.g_varchar2,
1090: p_attribute23 in varchar2 default hr_api.g_varchar2,
1091: p_attribute24 in varchar2 default hr_api.g_varchar2,
1092: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 1089: p_attribute22 in varchar2 default hr_api.g_varchar2,

1085: p_attribute19 in varchar2 default hr_api.g_varchar2,
1086: p_attribute20 in varchar2 default hr_api.g_varchar2,
1087: /*Added for Enhancement 4021737 */
1088: p_attribute21 in varchar2 default hr_api.g_varchar2,
1089: p_attribute22 in varchar2 default hr_api.g_varchar2,
1090: p_attribute23 in varchar2 default hr_api.g_varchar2,
1091: p_attribute24 in varchar2 default hr_api.g_varchar2,
1092: p_attribute25 in varchar2 default hr_api.g_varchar2,
1093: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 1090: p_attribute23 in varchar2 default hr_api.g_varchar2,

1086: p_attribute20 in varchar2 default hr_api.g_varchar2,
1087: /*Added for Enhancement 4021737 */
1088: p_attribute21 in varchar2 default hr_api.g_varchar2,
1089: p_attribute22 in varchar2 default hr_api.g_varchar2,
1090: p_attribute23 in varchar2 default hr_api.g_varchar2,
1091: p_attribute24 in varchar2 default hr_api.g_varchar2,
1092: p_attribute25 in varchar2 default hr_api.g_varchar2,
1093: p_attribute26 in varchar2 default hr_api.g_varchar2,
1094: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 1091: p_attribute24 in varchar2 default hr_api.g_varchar2,

1087: /*Added for Enhancement 4021737 */
1088: p_attribute21 in varchar2 default hr_api.g_varchar2,
1089: p_attribute22 in varchar2 default hr_api.g_varchar2,
1090: p_attribute23 in varchar2 default hr_api.g_varchar2,
1091: p_attribute24 in varchar2 default hr_api.g_varchar2,
1092: p_attribute25 in varchar2 default hr_api.g_varchar2,
1093: p_attribute26 in varchar2 default hr_api.g_varchar2,
1094: p_attribute27 in varchar2 default hr_api.g_varchar2,
1095: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 1092: p_attribute25 in varchar2 default hr_api.g_varchar2,

1088: p_attribute21 in varchar2 default hr_api.g_varchar2,
1089: p_attribute22 in varchar2 default hr_api.g_varchar2,
1090: p_attribute23 in varchar2 default hr_api.g_varchar2,
1091: p_attribute24 in varchar2 default hr_api.g_varchar2,
1092: p_attribute25 in varchar2 default hr_api.g_varchar2,
1093: p_attribute26 in varchar2 default hr_api.g_varchar2,
1094: p_attribute27 in varchar2 default hr_api.g_varchar2,
1095: p_attribute28 in varchar2 default hr_api.g_varchar2,
1096: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 1093: p_attribute26 in varchar2 default hr_api.g_varchar2,

1089: p_attribute22 in varchar2 default hr_api.g_varchar2,
1090: p_attribute23 in varchar2 default hr_api.g_varchar2,
1091: p_attribute24 in varchar2 default hr_api.g_varchar2,
1092: p_attribute25 in varchar2 default hr_api.g_varchar2,
1093: p_attribute26 in varchar2 default hr_api.g_varchar2,
1094: p_attribute27 in varchar2 default hr_api.g_varchar2,
1095: p_attribute28 in varchar2 default hr_api.g_varchar2,
1096: p_attribute29 in varchar2 default hr_api.g_varchar2,
1097: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 1094: p_attribute27 in varchar2 default hr_api.g_varchar2,

1090: p_attribute23 in varchar2 default hr_api.g_varchar2,
1091: p_attribute24 in varchar2 default hr_api.g_varchar2,
1092: p_attribute25 in varchar2 default hr_api.g_varchar2,
1093: p_attribute26 in varchar2 default hr_api.g_varchar2,
1094: p_attribute27 in varchar2 default hr_api.g_varchar2,
1095: p_attribute28 in varchar2 default hr_api.g_varchar2,
1096: p_attribute29 in varchar2 default hr_api.g_varchar2,
1097: p_attribute30 in varchar2 default hr_api.g_varchar2,
1098: /*End Enhancement 4021737 */

Line 1095: p_attribute28 in varchar2 default hr_api.g_varchar2,

1091: p_attribute24 in varchar2 default hr_api.g_varchar2,
1092: p_attribute25 in varchar2 default hr_api.g_varchar2,
1093: p_attribute26 in varchar2 default hr_api.g_varchar2,
1094: p_attribute27 in varchar2 default hr_api.g_varchar2,
1095: p_attribute28 in varchar2 default hr_api.g_varchar2,
1096: p_attribute29 in varchar2 default hr_api.g_varchar2,
1097: p_attribute30 in varchar2 default hr_api.g_varchar2,
1098: /*End Enhancement 4021737 */
1099: p_effective_date in date

Line 1096: p_attribute29 in varchar2 default hr_api.g_varchar2,

1092: p_attribute25 in varchar2 default hr_api.g_varchar2,
1093: p_attribute26 in varchar2 default hr_api.g_varchar2,
1094: p_attribute27 in varchar2 default hr_api.g_varchar2,
1095: p_attribute28 in varchar2 default hr_api.g_varchar2,
1096: p_attribute29 in varchar2 default hr_api.g_varchar2,
1097: p_attribute30 in varchar2 default hr_api.g_varchar2,
1098: /*End Enhancement 4021737 */
1099: p_effective_date in date
1100: ) is

Line 1097: p_attribute30 in varchar2 default hr_api.g_varchar2,

1093: p_attribute26 in varchar2 default hr_api.g_varchar2,
1094: p_attribute27 in varchar2 default hr_api.g_varchar2,
1095: p_attribute28 in varchar2 default hr_api.g_varchar2,
1096: p_attribute29 in varchar2 default hr_api.g_varchar2,
1097: p_attribute30 in varchar2 default hr_api.g_varchar2,
1098: /*End Enhancement 4021737 */
1099: p_effective_date in date
1100: ) is
1101: --

Line 1116: hr_api.g_number,

1112: per_ssl_shd.convert_args
1113: (
1114: p_salary_survey_line_id,
1115: p_object_version_number,
1116: hr_api.g_number,
1117: p_survey_job_name_code,
1118: p_survey_region_code,
1119: p_survey_seniority_code,
1120: p_company_size_code,