119: from per_salary_survey_lines
120: where l_start_date > start_date
121: and end_date is null
122: and survey_job_name_code = p_survey_job_name_code
123: and nvl(survey_region_code,hr_api.g_varchar2)
124: = nvl(p_survey_region_code,hr_api.g_varchar2)
125: and nvl(survey_seniority_code,hr_api.g_varchar2)
126: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
127: and nvl(company_size_code,hr_api.g_varchar2)
120: where l_start_date > start_date
121: and end_date is null
122: and survey_job_name_code = p_survey_job_name_code
123: and nvl(survey_region_code,hr_api.g_varchar2)
124: = nvl(p_survey_region_code,hr_api.g_varchar2)
125: and nvl(survey_seniority_code,hr_api.g_varchar2)
126: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
127: and nvl(company_size_code,hr_api.g_varchar2)
128: = nvl(p_company_size_code,hr_api.g_varchar2)
121: and end_date is null
122: and survey_job_name_code = p_survey_job_name_code
123: and nvl(survey_region_code,hr_api.g_varchar2)
124: = nvl(p_survey_region_code,hr_api.g_varchar2)
125: and nvl(survey_seniority_code,hr_api.g_varchar2)
126: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
127: and nvl(company_size_code,hr_api.g_varchar2)
128: = nvl(p_company_size_code,hr_api.g_varchar2)
129: and nvl(industry_code,hr_api.g_varchar2)
122: and survey_job_name_code = p_survey_job_name_code
123: and nvl(survey_region_code,hr_api.g_varchar2)
124: = nvl(p_survey_region_code,hr_api.g_varchar2)
125: and nvl(survey_seniority_code,hr_api.g_varchar2)
126: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
127: and nvl(company_size_code,hr_api.g_varchar2)
128: = nvl(p_company_size_code,hr_api.g_varchar2)
129: and nvl(industry_code,hr_api.g_varchar2)
130: = nvl(p_industry_code,hr_api.g_varchar2)
123: and nvl(survey_region_code,hr_api.g_varchar2)
124: = nvl(p_survey_region_code,hr_api.g_varchar2)
125: and nvl(survey_seniority_code,hr_api.g_varchar2)
126: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
127: and nvl(company_size_code,hr_api.g_varchar2)
128: = nvl(p_company_size_code,hr_api.g_varchar2)
129: and nvl(industry_code,hr_api.g_varchar2)
130: = nvl(p_industry_code,hr_api.g_varchar2)
131: and nvl(survey_age_code,hr_api.g_varchar2)
124: = nvl(p_survey_region_code,hr_api.g_varchar2)
125: and nvl(survey_seniority_code,hr_api.g_varchar2)
126: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
127: and nvl(company_size_code,hr_api.g_varchar2)
128: = nvl(p_company_size_code,hr_api.g_varchar2)
129: and nvl(industry_code,hr_api.g_varchar2)
130: = nvl(p_industry_code,hr_api.g_varchar2)
131: and nvl(survey_age_code,hr_api.g_varchar2)
132: = nvl(p_survey_age_code,hr_api.g_varchar2)
125: and nvl(survey_seniority_code,hr_api.g_varchar2)
126: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
127: and nvl(company_size_code,hr_api.g_varchar2)
128: = nvl(p_company_size_code,hr_api.g_varchar2)
129: and nvl(industry_code,hr_api.g_varchar2)
130: = nvl(p_industry_code,hr_api.g_varchar2)
131: and nvl(survey_age_code,hr_api.g_varchar2)
132: = nvl(p_survey_age_code,hr_api.g_varchar2)
133: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
126: = nvl(p_survey_seniority_code,hr_api.g_varchar2)
127: and nvl(company_size_code,hr_api.g_varchar2)
128: = nvl(p_company_size_code,hr_api.g_varchar2)
129: and nvl(industry_code,hr_api.g_varchar2)
130: = nvl(p_industry_code,hr_api.g_varchar2)
131: and nvl(survey_age_code,hr_api.g_varchar2)
132: = nvl(p_survey_age_code,hr_api.g_varchar2)
133: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
134: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
127: and nvl(company_size_code,hr_api.g_varchar2)
128: = nvl(p_company_size_code,hr_api.g_varchar2)
129: and nvl(industry_code,hr_api.g_varchar2)
130: = nvl(p_industry_code,hr_api.g_varchar2)
131: and nvl(survey_age_code,hr_api.g_varchar2)
132: = nvl(p_survey_age_code,hr_api.g_varchar2)
133: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
134: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
135: --
128: = nvl(p_company_size_code,hr_api.g_varchar2)
129: and nvl(industry_code,hr_api.g_varchar2)
130: = nvl(p_industry_code,hr_api.g_varchar2)
131: and nvl(survey_age_code,hr_api.g_varchar2)
132: = nvl(p_survey_age_code,hr_api.g_varchar2)
133: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
134: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
135: --
136: begin
129: and nvl(industry_code,hr_api.g_varchar2)
130: = nvl(p_industry_code,hr_api.g_varchar2)
131: and nvl(survey_age_code,hr_api.g_varchar2)
132: = nvl(p_survey_age_code,hr_api.g_varchar2)
133: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
134: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
135: --
136: begin
137: --
130: = nvl(p_industry_code,hr_api.g_varchar2)
131: and nvl(survey_age_code,hr_api.g_varchar2)
132: = nvl(p_survey_age_code,hr_api.g_varchar2)
133: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
134: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
135: --
136: begin
137: --
138: hr_utility.set_location('Entering:'|| l_proc, 10);
235: p_attribute30 => p_attribute30
236: /* End Enhancement 4021737 */
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'create_salary_survey_line'
242: ,p_hook_type => 'BP'
243: );
236: /* End Enhancement 4021737 */
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'create_salary_survey_line'
242: ,p_hook_type => 'BP'
243: );
244: end;
455: p_ssl_object_version_number => l_ssl_object_version_number,
456: p_overlap_warning => l_overlap_warning
457: );
458: exception
459: when hr_api.cannot_find_prog_unit then
460: hr_api.cannot_find_prog_unit_error
461: (p_module_name => 'create_salary_survey_line'
462: ,p_hook_type => 'AP'
463: );
456: p_overlap_warning => l_overlap_warning
457: );
458: exception
459: when hr_api.cannot_find_prog_unit then
460: hr_api.cannot_find_prog_unit_error
461: (p_module_name => 'create_salary_survey_line'
462: ,p_hook_type => 'AP'
463: );
464: end;
467: -- When in validation only mode raise the Validate_Enabled exception
468: --
469: if p_validate then
470: --
471: raise hr_api.validate_enabled;
472: --
473: end if;
474: --
475: -- Set all output arguments
480: --
481: hr_utility.set_location(' Leaving:'||l_proc, 70);
482: --
483: exception
484: when hr_api.validate_enabled then
485: --
486: -- As the Validate_Enabled exception has been raised
487: -- we must rollback to the savepoint
488: --
521: procedure update_salary_survey_line
522: (p_validate in boolean default false
523: ,p_survey_job_name_code in varchar2
524: ,p_start_date in date
525: ,p_currency_code in varchar2 default hr_api.g_varchar2
526: ,p_survey_region_code in varchar2 default hr_api.g_varchar2
527: ,p_survey_seniority_code in varchar2 default hr_api.g_varchar2
528: ,p_company_size_code in varchar2 default hr_api.g_varchar2
529: ,p_industry_code in varchar2 default hr_api.g_varchar2
522: (p_validate in boolean default false
523: ,p_survey_job_name_code in varchar2
524: ,p_start_date in date
525: ,p_currency_code in varchar2 default hr_api.g_varchar2
526: ,p_survey_region_code in varchar2 default hr_api.g_varchar2
527: ,p_survey_seniority_code in varchar2 default hr_api.g_varchar2
528: ,p_company_size_code in varchar2 default hr_api.g_varchar2
529: ,p_industry_code in varchar2 default hr_api.g_varchar2
530: ,p_survey_age_code in varchar2 default hr_api.g_varchar2
523: ,p_survey_job_name_code in varchar2
524: ,p_start_date in date
525: ,p_currency_code in varchar2 default hr_api.g_varchar2
526: ,p_survey_region_code in varchar2 default hr_api.g_varchar2
527: ,p_survey_seniority_code in varchar2 default hr_api.g_varchar2
528: ,p_company_size_code in varchar2 default hr_api.g_varchar2
529: ,p_industry_code in varchar2 default hr_api.g_varchar2
530: ,p_survey_age_code in varchar2 default hr_api.g_varchar2
531: ,p_end_date in date default hr_api.g_date
524: ,p_start_date in date
525: ,p_currency_code in varchar2 default hr_api.g_varchar2
526: ,p_survey_region_code in varchar2 default hr_api.g_varchar2
527: ,p_survey_seniority_code in varchar2 default hr_api.g_varchar2
528: ,p_company_size_code in varchar2 default hr_api.g_varchar2
529: ,p_industry_code in varchar2 default hr_api.g_varchar2
530: ,p_survey_age_code in varchar2 default hr_api.g_varchar2
531: ,p_end_date in date default hr_api.g_date
532: ,p_differential in number default hr_api.g_number
525: ,p_currency_code in varchar2 default hr_api.g_varchar2
526: ,p_survey_region_code in varchar2 default hr_api.g_varchar2
527: ,p_survey_seniority_code in varchar2 default hr_api.g_varchar2
528: ,p_company_size_code in varchar2 default hr_api.g_varchar2
529: ,p_industry_code in varchar2 default hr_api.g_varchar2
530: ,p_survey_age_code in varchar2 default hr_api.g_varchar2
531: ,p_end_date in date default hr_api.g_date
532: ,p_differential in number default hr_api.g_number
533: ,p_minimum_pay in number default hr_api.g_number
526: ,p_survey_region_code in varchar2 default hr_api.g_varchar2
527: ,p_survey_seniority_code in varchar2 default hr_api.g_varchar2
528: ,p_company_size_code in varchar2 default hr_api.g_varchar2
529: ,p_industry_code in varchar2 default hr_api.g_varchar2
530: ,p_survey_age_code in varchar2 default hr_api.g_varchar2
531: ,p_end_date in date default hr_api.g_date
532: ,p_differential in number default hr_api.g_number
533: ,p_minimum_pay in number default hr_api.g_number
534: ,p_mean_pay in number default hr_api.g_number
527: ,p_survey_seniority_code in varchar2 default hr_api.g_varchar2
528: ,p_company_size_code in varchar2 default hr_api.g_varchar2
529: ,p_industry_code in varchar2 default hr_api.g_varchar2
530: ,p_survey_age_code in varchar2 default hr_api.g_varchar2
531: ,p_end_date in date default hr_api.g_date
532: ,p_differential in number default hr_api.g_number
533: ,p_minimum_pay in number default hr_api.g_number
534: ,p_mean_pay in number default hr_api.g_number
535: ,p_maximum_pay in number default hr_api.g_number
528: ,p_company_size_code in varchar2 default hr_api.g_varchar2
529: ,p_industry_code in varchar2 default hr_api.g_varchar2
530: ,p_survey_age_code in varchar2 default hr_api.g_varchar2
531: ,p_end_date in date default hr_api.g_date
532: ,p_differential in number default hr_api.g_number
533: ,p_minimum_pay in number default hr_api.g_number
534: ,p_mean_pay in number default hr_api.g_number
535: ,p_maximum_pay in number default hr_api.g_number
536: ,p_graduate_pay in number default hr_api.g_number
529: ,p_industry_code in varchar2 default hr_api.g_varchar2
530: ,p_survey_age_code in varchar2 default hr_api.g_varchar2
531: ,p_end_date in date default hr_api.g_date
532: ,p_differential in number default hr_api.g_number
533: ,p_minimum_pay in number default hr_api.g_number
534: ,p_mean_pay in number default hr_api.g_number
535: ,p_maximum_pay in number default hr_api.g_number
536: ,p_graduate_pay in number default hr_api.g_number
537: ,p_starting_pay in number default hr_api.g_number
530: ,p_survey_age_code in varchar2 default hr_api.g_varchar2
531: ,p_end_date in date default hr_api.g_date
532: ,p_differential in number default hr_api.g_number
533: ,p_minimum_pay in number default hr_api.g_number
534: ,p_mean_pay in number default hr_api.g_number
535: ,p_maximum_pay in number default hr_api.g_number
536: ,p_graduate_pay in number default hr_api.g_number
537: ,p_starting_pay in number default hr_api.g_number
538: ,p_percentage_change in number default hr_api.g_number
531: ,p_end_date in date default hr_api.g_date
532: ,p_differential in number default hr_api.g_number
533: ,p_minimum_pay in number default hr_api.g_number
534: ,p_mean_pay in number default hr_api.g_number
535: ,p_maximum_pay in number default hr_api.g_number
536: ,p_graduate_pay in number default hr_api.g_number
537: ,p_starting_pay in number default hr_api.g_number
538: ,p_percentage_change in number default hr_api.g_number
539: ,p_job_first_quartile in number default hr_api.g_number
532: ,p_differential in number default hr_api.g_number
533: ,p_minimum_pay in number default hr_api.g_number
534: ,p_mean_pay in number default hr_api.g_number
535: ,p_maximum_pay in number default hr_api.g_number
536: ,p_graduate_pay in number default hr_api.g_number
537: ,p_starting_pay in number default hr_api.g_number
538: ,p_percentage_change in number default hr_api.g_number
539: ,p_job_first_quartile in number default hr_api.g_number
540: ,p_job_median_quartile in number default hr_api.g_number
533: ,p_minimum_pay in number default hr_api.g_number
534: ,p_mean_pay in number default hr_api.g_number
535: ,p_maximum_pay in number default hr_api.g_number
536: ,p_graduate_pay in number default hr_api.g_number
537: ,p_starting_pay in number default hr_api.g_number
538: ,p_percentage_change in number default hr_api.g_number
539: ,p_job_first_quartile in number default hr_api.g_number
540: ,p_job_median_quartile in number default hr_api.g_number
541: ,p_job_third_quartile in number default hr_api.g_number
534: ,p_mean_pay in number default hr_api.g_number
535: ,p_maximum_pay in number default hr_api.g_number
536: ,p_graduate_pay in number default hr_api.g_number
537: ,p_starting_pay in number default hr_api.g_number
538: ,p_percentage_change in number default hr_api.g_number
539: ,p_job_first_quartile in number default hr_api.g_number
540: ,p_job_median_quartile in number default hr_api.g_number
541: ,p_job_third_quartile in number default hr_api.g_number
542: ,p_job_fourth_quartile in number default hr_api.g_number
535: ,p_maximum_pay in number default hr_api.g_number
536: ,p_graduate_pay in number default hr_api.g_number
537: ,p_starting_pay in number default hr_api.g_number
538: ,p_percentage_change in number default hr_api.g_number
539: ,p_job_first_quartile in number default hr_api.g_number
540: ,p_job_median_quartile in number default hr_api.g_number
541: ,p_job_third_quartile in number default hr_api.g_number
542: ,p_job_fourth_quartile in number default hr_api.g_number
543: ,p_minimum_total_compensation in number default hr_api.g_number
536: ,p_graduate_pay in number default hr_api.g_number
537: ,p_starting_pay in number default hr_api.g_number
538: ,p_percentage_change in number default hr_api.g_number
539: ,p_job_first_quartile in number default hr_api.g_number
540: ,p_job_median_quartile in number default hr_api.g_number
541: ,p_job_third_quartile in number default hr_api.g_number
542: ,p_job_fourth_quartile in number default hr_api.g_number
543: ,p_minimum_total_compensation in number default hr_api.g_number
544: ,p_mean_total_compensation in number default hr_api.g_number
537: ,p_starting_pay in number default hr_api.g_number
538: ,p_percentage_change in number default hr_api.g_number
539: ,p_job_first_quartile in number default hr_api.g_number
540: ,p_job_median_quartile in number default hr_api.g_number
541: ,p_job_third_quartile in number default hr_api.g_number
542: ,p_job_fourth_quartile in number default hr_api.g_number
543: ,p_minimum_total_compensation in number default hr_api.g_number
544: ,p_mean_total_compensation in number default hr_api.g_number
545: ,p_maximum_total_compensation in number default hr_api.g_number
538: ,p_percentage_change in number default hr_api.g_number
539: ,p_job_first_quartile in number default hr_api.g_number
540: ,p_job_median_quartile in number default hr_api.g_number
541: ,p_job_third_quartile in number default hr_api.g_number
542: ,p_job_fourth_quartile in number default hr_api.g_number
543: ,p_minimum_total_compensation in number default hr_api.g_number
544: ,p_mean_total_compensation in number default hr_api.g_number
545: ,p_maximum_total_compensation in number default hr_api.g_number
546: ,p_compnstn_first_quartile in number default hr_api.g_number
539: ,p_job_first_quartile in number default hr_api.g_number
540: ,p_job_median_quartile in number default hr_api.g_number
541: ,p_job_third_quartile in number default hr_api.g_number
542: ,p_job_fourth_quartile in number default hr_api.g_number
543: ,p_minimum_total_compensation in number default hr_api.g_number
544: ,p_mean_total_compensation in number default hr_api.g_number
545: ,p_maximum_total_compensation in number default hr_api.g_number
546: ,p_compnstn_first_quartile in number default hr_api.g_number
547: ,p_compnstn_median_quartile in number default hr_api.g_number
540: ,p_job_median_quartile in number default hr_api.g_number
541: ,p_job_third_quartile in number default hr_api.g_number
542: ,p_job_fourth_quartile in number default hr_api.g_number
543: ,p_minimum_total_compensation in number default hr_api.g_number
544: ,p_mean_total_compensation in number default hr_api.g_number
545: ,p_maximum_total_compensation in number default hr_api.g_number
546: ,p_compnstn_first_quartile in number default hr_api.g_number
547: ,p_compnstn_median_quartile in number default hr_api.g_number
548: ,p_compnstn_third_quartile in number default hr_api.g_number
541: ,p_job_third_quartile in number default hr_api.g_number
542: ,p_job_fourth_quartile in number default hr_api.g_number
543: ,p_minimum_total_compensation in number default hr_api.g_number
544: ,p_mean_total_compensation in number default hr_api.g_number
545: ,p_maximum_total_compensation in number default hr_api.g_number
546: ,p_compnstn_first_quartile in number default hr_api.g_number
547: ,p_compnstn_median_quartile in number default hr_api.g_number
548: ,p_compnstn_third_quartile in number default hr_api.g_number
549: ,p_compnstn_fourth_quartile in number default hr_api.g_number
542: ,p_job_fourth_quartile in number default hr_api.g_number
543: ,p_minimum_total_compensation in number default hr_api.g_number
544: ,p_mean_total_compensation in number default hr_api.g_number
545: ,p_maximum_total_compensation in number default hr_api.g_number
546: ,p_compnstn_first_quartile in number default hr_api.g_number
547: ,p_compnstn_median_quartile in number default hr_api.g_number
548: ,p_compnstn_third_quartile in number default hr_api.g_number
549: ,p_compnstn_fourth_quartile in number default hr_api.g_number
550: /*Added for Enhancement 4021737 */
543: ,p_minimum_total_compensation in number default hr_api.g_number
544: ,p_mean_total_compensation in number default hr_api.g_number
545: ,p_maximum_total_compensation in number default hr_api.g_number
546: ,p_compnstn_first_quartile in number default hr_api.g_number
547: ,p_compnstn_median_quartile in number default hr_api.g_number
548: ,p_compnstn_third_quartile in number default hr_api.g_number
549: ,p_compnstn_fourth_quartile in number default hr_api.g_number
550: /*Added for Enhancement 4021737 */
551: ,p_tenth_percentile in number default hr_api.g_number
544: ,p_mean_total_compensation in number default hr_api.g_number
545: ,p_maximum_total_compensation in number default hr_api.g_number
546: ,p_compnstn_first_quartile in number default hr_api.g_number
547: ,p_compnstn_median_quartile in number default hr_api.g_number
548: ,p_compnstn_third_quartile in number default hr_api.g_number
549: ,p_compnstn_fourth_quartile in number default hr_api.g_number
550: /*Added for Enhancement 4021737 */
551: ,p_tenth_percentile in number default hr_api.g_number
552: ,p_twenty_fifth_percentile in number default hr_api.g_number
545: ,p_maximum_total_compensation in number default hr_api.g_number
546: ,p_compnstn_first_quartile in number default hr_api.g_number
547: ,p_compnstn_median_quartile in number default hr_api.g_number
548: ,p_compnstn_third_quartile in number default hr_api.g_number
549: ,p_compnstn_fourth_quartile in number default hr_api.g_number
550: /*Added for Enhancement 4021737 */
551: ,p_tenth_percentile in number default hr_api.g_number
552: ,p_twenty_fifth_percentile in number default hr_api.g_number
553: ,p_fiftieth_percentile in number default hr_api.g_number
547: ,p_compnstn_median_quartile in number default hr_api.g_number
548: ,p_compnstn_third_quartile in number default hr_api.g_number
549: ,p_compnstn_fourth_quartile in number default hr_api.g_number
550: /*Added for Enhancement 4021737 */
551: ,p_tenth_percentile in number default hr_api.g_number
552: ,p_twenty_fifth_percentile in number default hr_api.g_number
553: ,p_fiftieth_percentile in number default hr_api.g_number
554: ,p_seventy_fifth_percentile in number default hr_api.g_number
555: ,p_ninetieth_percentile in number default hr_api.g_number
548: ,p_compnstn_third_quartile in number default hr_api.g_number
549: ,p_compnstn_fourth_quartile in number default hr_api.g_number
550: /*Added for Enhancement 4021737 */
551: ,p_tenth_percentile in number default hr_api.g_number
552: ,p_twenty_fifth_percentile in number default hr_api.g_number
553: ,p_fiftieth_percentile in number default hr_api.g_number
554: ,p_seventy_fifth_percentile in number default hr_api.g_number
555: ,p_ninetieth_percentile in number default hr_api.g_number
556: ,p_minimum_bonus in number default hr_api.g_number
549: ,p_compnstn_fourth_quartile in number default hr_api.g_number
550: /*Added for Enhancement 4021737 */
551: ,p_tenth_percentile in number default hr_api.g_number
552: ,p_twenty_fifth_percentile in number default hr_api.g_number
553: ,p_fiftieth_percentile in number default hr_api.g_number
554: ,p_seventy_fifth_percentile in number default hr_api.g_number
555: ,p_ninetieth_percentile in number default hr_api.g_number
556: ,p_minimum_bonus in number default hr_api.g_number
557: ,p_mean_bonus in number default hr_api.g_number
550: /*Added for Enhancement 4021737 */
551: ,p_tenth_percentile in number default hr_api.g_number
552: ,p_twenty_fifth_percentile in number default hr_api.g_number
553: ,p_fiftieth_percentile in number default hr_api.g_number
554: ,p_seventy_fifth_percentile in number default hr_api.g_number
555: ,p_ninetieth_percentile in number default hr_api.g_number
556: ,p_minimum_bonus in number default hr_api.g_number
557: ,p_mean_bonus in number default hr_api.g_number
558: ,p_maximum_bonus in number default hr_api.g_number
551: ,p_tenth_percentile in number default hr_api.g_number
552: ,p_twenty_fifth_percentile in number default hr_api.g_number
553: ,p_fiftieth_percentile in number default hr_api.g_number
554: ,p_seventy_fifth_percentile in number default hr_api.g_number
555: ,p_ninetieth_percentile in number default hr_api.g_number
556: ,p_minimum_bonus in number default hr_api.g_number
557: ,p_mean_bonus in number default hr_api.g_number
558: ,p_maximum_bonus in number default hr_api.g_number
559: ,p_minimum_salary_increase in number default hr_api.g_number
552: ,p_twenty_fifth_percentile in number default hr_api.g_number
553: ,p_fiftieth_percentile in number default hr_api.g_number
554: ,p_seventy_fifth_percentile in number default hr_api.g_number
555: ,p_ninetieth_percentile in number default hr_api.g_number
556: ,p_minimum_bonus in number default hr_api.g_number
557: ,p_mean_bonus in number default hr_api.g_number
558: ,p_maximum_bonus in number default hr_api.g_number
559: ,p_minimum_salary_increase in number default hr_api.g_number
560: ,p_mean_salary_increase in number default hr_api.g_number
553: ,p_fiftieth_percentile in number default hr_api.g_number
554: ,p_seventy_fifth_percentile in number default hr_api.g_number
555: ,p_ninetieth_percentile in number default hr_api.g_number
556: ,p_minimum_bonus in number default hr_api.g_number
557: ,p_mean_bonus in number default hr_api.g_number
558: ,p_maximum_bonus in number default hr_api.g_number
559: ,p_minimum_salary_increase in number default hr_api.g_number
560: ,p_mean_salary_increase in number default hr_api.g_number
561: ,p_maximum_salary_increase in number default hr_api.g_number
554: ,p_seventy_fifth_percentile in number default hr_api.g_number
555: ,p_ninetieth_percentile in number default hr_api.g_number
556: ,p_minimum_bonus in number default hr_api.g_number
557: ,p_mean_bonus in number default hr_api.g_number
558: ,p_maximum_bonus in number default hr_api.g_number
559: ,p_minimum_salary_increase in number default hr_api.g_number
560: ,p_mean_salary_increase in number default hr_api.g_number
561: ,p_maximum_salary_increase in number default hr_api.g_number
562: ,p_min_variable_compensation in number default hr_api.g_number
555: ,p_ninetieth_percentile in number default hr_api.g_number
556: ,p_minimum_bonus in number default hr_api.g_number
557: ,p_mean_bonus in number default hr_api.g_number
558: ,p_maximum_bonus in number default hr_api.g_number
559: ,p_minimum_salary_increase in number default hr_api.g_number
560: ,p_mean_salary_increase in number default hr_api.g_number
561: ,p_maximum_salary_increase in number default hr_api.g_number
562: ,p_min_variable_compensation in number default hr_api.g_number
563: ,p_mean_variable_compensation in number default hr_api.g_number
556: ,p_minimum_bonus in number default hr_api.g_number
557: ,p_mean_bonus in number default hr_api.g_number
558: ,p_maximum_bonus in number default hr_api.g_number
559: ,p_minimum_salary_increase in number default hr_api.g_number
560: ,p_mean_salary_increase in number default hr_api.g_number
561: ,p_maximum_salary_increase in number default hr_api.g_number
562: ,p_min_variable_compensation in number default hr_api.g_number
563: ,p_mean_variable_compensation in number default hr_api.g_number
564: ,p_max_variable_compensation in number default hr_api.g_number
557: ,p_mean_bonus in number default hr_api.g_number
558: ,p_maximum_bonus in number default hr_api.g_number
559: ,p_minimum_salary_increase in number default hr_api.g_number
560: ,p_mean_salary_increase in number default hr_api.g_number
561: ,p_maximum_salary_increase in number default hr_api.g_number
562: ,p_min_variable_compensation in number default hr_api.g_number
563: ,p_mean_variable_compensation in number default hr_api.g_number
564: ,p_max_variable_compensation in number default hr_api.g_number
565: ,p_minimum_stock in number default hr_api.g_number
558: ,p_maximum_bonus in number default hr_api.g_number
559: ,p_minimum_salary_increase in number default hr_api.g_number
560: ,p_mean_salary_increase in number default hr_api.g_number
561: ,p_maximum_salary_increase in number default hr_api.g_number
562: ,p_min_variable_compensation in number default hr_api.g_number
563: ,p_mean_variable_compensation in number default hr_api.g_number
564: ,p_max_variable_compensation in number default hr_api.g_number
565: ,p_minimum_stock in number default hr_api.g_number
566: ,p_mean_stock in number default hr_api.g_number
559: ,p_minimum_salary_increase in number default hr_api.g_number
560: ,p_mean_salary_increase in number default hr_api.g_number
561: ,p_maximum_salary_increase in number default hr_api.g_number
562: ,p_min_variable_compensation in number default hr_api.g_number
563: ,p_mean_variable_compensation in number default hr_api.g_number
564: ,p_max_variable_compensation in number default hr_api.g_number
565: ,p_minimum_stock in number default hr_api.g_number
566: ,p_mean_stock in number default hr_api.g_number
567: ,p_maximum_stock in number default hr_api.g_number
560: ,p_mean_salary_increase in number default hr_api.g_number
561: ,p_maximum_salary_increase in number default hr_api.g_number
562: ,p_min_variable_compensation in number default hr_api.g_number
563: ,p_mean_variable_compensation in number default hr_api.g_number
564: ,p_max_variable_compensation in number default hr_api.g_number
565: ,p_minimum_stock in number default hr_api.g_number
566: ,p_mean_stock in number default hr_api.g_number
567: ,p_maximum_stock in number default hr_api.g_number
568: ,p_stock_display_type in varchar2 default hr_api.g_varchar2
561: ,p_maximum_salary_increase in number default hr_api.g_number
562: ,p_min_variable_compensation in number default hr_api.g_number
563: ,p_mean_variable_compensation in number default hr_api.g_number
564: ,p_max_variable_compensation in number default hr_api.g_number
565: ,p_minimum_stock in number default hr_api.g_number
566: ,p_mean_stock in number default hr_api.g_number
567: ,p_maximum_stock in number default hr_api.g_number
568: ,p_stock_display_type in varchar2 default hr_api.g_varchar2
569: /* End Enhancement 4021737 */
562: ,p_min_variable_compensation in number default hr_api.g_number
563: ,p_mean_variable_compensation in number default hr_api.g_number
564: ,p_max_variable_compensation in number default hr_api.g_number
565: ,p_minimum_stock in number default hr_api.g_number
566: ,p_mean_stock in number default hr_api.g_number
567: ,p_maximum_stock in number default hr_api.g_number
568: ,p_stock_display_type in varchar2 default hr_api.g_varchar2
569: /* End Enhancement 4021737 */
570: ,p_effective_date in date default hr_api.g_date
563: ,p_mean_variable_compensation in number default hr_api.g_number
564: ,p_max_variable_compensation in number default hr_api.g_number
565: ,p_minimum_stock in number default hr_api.g_number
566: ,p_mean_stock in number default hr_api.g_number
567: ,p_maximum_stock in number default hr_api.g_number
568: ,p_stock_display_type in varchar2 default hr_api.g_varchar2
569: /* End Enhancement 4021737 */
570: ,p_effective_date in date default hr_api.g_date
571: ,p_attribute_category in varchar2 default hr_api.g_varchar2
564: ,p_max_variable_compensation in number default hr_api.g_number
565: ,p_minimum_stock in number default hr_api.g_number
566: ,p_mean_stock in number default hr_api.g_number
567: ,p_maximum_stock in number default hr_api.g_number
568: ,p_stock_display_type in varchar2 default hr_api.g_varchar2
569: /* End Enhancement 4021737 */
570: ,p_effective_date in date default hr_api.g_date
571: ,p_attribute_category in varchar2 default hr_api.g_varchar2
572: ,p_attribute1 in varchar2 default hr_api.g_varchar2
566: ,p_mean_stock in number default hr_api.g_number
567: ,p_maximum_stock in number default hr_api.g_number
568: ,p_stock_display_type in varchar2 default hr_api.g_varchar2
569: /* End Enhancement 4021737 */
570: ,p_effective_date in date default hr_api.g_date
571: ,p_attribute_category in varchar2 default hr_api.g_varchar2
572: ,p_attribute1 in varchar2 default hr_api.g_varchar2
573: ,p_attribute2 in varchar2 default hr_api.g_varchar2
574: ,p_attribute3 in varchar2 default hr_api.g_varchar2
567: ,p_maximum_stock in number default hr_api.g_number
568: ,p_stock_display_type in varchar2 default hr_api.g_varchar2
569: /* End Enhancement 4021737 */
570: ,p_effective_date in date default hr_api.g_date
571: ,p_attribute_category in varchar2 default hr_api.g_varchar2
572: ,p_attribute1 in varchar2 default hr_api.g_varchar2
573: ,p_attribute2 in varchar2 default hr_api.g_varchar2
574: ,p_attribute3 in varchar2 default hr_api.g_varchar2
575: ,p_attribute4 in varchar2 default hr_api.g_varchar2
568: ,p_stock_display_type in varchar2 default hr_api.g_varchar2
569: /* End Enhancement 4021737 */
570: ,p_effective_date in date default hr_api.g_date
571: ,p_attribute_category in varchar2 default hr_api.g_varchar2
572: ,p_attribute1 in varchar2 default hr_api.g_varchar2
573: ,p_attribute2 in varchar2 default hr_api.g_varchar2
574: ,p_attribute3 in varchar2 default hr_api.g_varchar2
575: ,p_attribute4 in varchar2 default hr_api.g_varchar2
576: ,p_attribute5 in varchar2 default hr_api.g_varchar2
569: /* End Enhancement 4021737 */
570: ,p_effective_date in date default hr_api.g_date
571: ,p_attribute_category in varchar2 default hr_api.g_varchar2
572: ,p_attribute1 in varchar2 default hr_api.g_varchar2
573: ,p_attribute2 in varchar2 default hr_api.g_varchar2
574: ,p_attribute3 in varchar2 default hr_api.g_varchar2
575: ,p_attribute4 in varchar2 default hr_api.g_varchar2
576: ,p_attribute5 in varchar2 default hr_api.g_varchar2
577: ,p_attribute6 in varchar2 default hr_api.g_varchar2
570: ,p_effective_date in date default hr_api.g_date
571: ,p_attribute_category in varchar2 default hr_api.g_varchar2
572: ,p_attribute1 in varchar2 default hr_api.g_varchar2
573: ,p_attribute2 in varchar2 default hr_api.g_varchar2
574: ,p_attribute3 in varchar2 default hr_api.g_varchar2
575: ,p_attribute4 in varchar2 default hr_api.g_varchar2
576: ,p_attribute5 in varchar2 default hr_api.g_varchar2
577: ,p_attribute6 in varchar2 default hr_api.g_varchar2
578: ,p_attribute7 in varchar2 default hr_api.g_varchar2
571: ,p_attribute_category in varchar2 default hr_api.g_varchar2
572: ,p_attribute1 in varchar2 default hr_api.g_varchar2
573: ,p_attribute2 in varchar2 default hr_api.g_varchar2
574: ,p_attribute3 in varchar2 default hr_api.g_varchar2
575: ,p_attribute4 in varchar2 default hr_api.g_varchar2
576: ,p_attribute5 in varchar2 default hr_api.g_varchar2
577: ,p_attribute6 in varchar2 default hr_api.g_varchar2
578: ,p_attribute7 in varchar2 default hr_api.g_varchar2
579: ,p_attribute8 in varchar2 default hr_api.g_varchar2
572: ,p_attribute1 in varchar2 default hr_api.g_varchar2
573: ,p_attribute2 in varchar2 default hr_api.g_varchar2
574: ,p_attribute3 in varchar2 default hr_api.g_varchar2
575: ,p_attribute4 in varchar2 default hr_api.g_varchar2
576: ,p_attribute5 in varchar2 default hr_api.g_varchar2
577: ,p_attribute6 in varchar2 default hr_api.g_varchar2
578: ,p_attribute7 in varchar2 default hr_api.g_varchar2
579: ,p_attribute8 in varchar2 default hr_api.g_varchar2
580: ,p_attribute9 in varchar2 default hr_api.g_varchar2
573: ,p_attribute2 in varchar2 default hr_api.g_varchar2
574: ,p_attribute3 in varchar2 default hr_api.g_varchar2
575: ,p_attribute4 in varchar2 default hr_api.g_varchar2
576: ,p_attribute5 in varchar2 default hr_api.g_varchar2
577: ,p_attribute6 in varchar2 default hr_api.g_varchar2
578: ,p_attribute7 in varchar2 default hr_api.g_varchar2
579: ,p_attribute8 in varchar2 default hr_api.g_varchar2
580: ,p_attribute9 in varchar2 default hr_api.g_varchar2
581: ,p_attribute10 in varchar2 default hr_api.g_varchar2
574: ,p_attribute3 in varchar2 default hr_api.g_varchar2
575: ,p_attribute4 in varchar2 default hr_api.g_varchar2
576: ,p_attribute5 in varchar2 default hr_api.g_varchar2
577: ,p_attribute6 in varchar2 default hr_api.g_varchar2
578: ,p_attribute7 in varchar2 default hr_api.g_varchar2
579: ,p_attribute8 in varchar2 default hr_api.g_varchar2
580: ,p_attribute9 in varchar2 default hr_api.g_varchar2
581: ,p_attribute10 in varchar2 default hr_api.g_varchar2
582: ,p_attribute11 in varchar2 default hr_api.g_varchar2
575: ,p_attribute4 in varchar2 default hr_api.g_varchar2
576: ,p_attribute5 in varchar2 default hr_api.g_varchar2
577: ,p_attribute6 in varchar2 default hr_api.g_varchar2
578: ,p_attribute7 in varchar2 default hr_api.g_varchar2
579: ,p_attribute8 in varchar2 default hr_api.g_varchar2
580: ,p_attribute9 in varchar2 default hr_api.g_varchar2
581: ,p_attribute10 in varchar2 default hr_api.g_varchar2
582: ,p_attribute11 in varchar2 default hr_api.g_varchar2
583: ,p_attribute12 in varchar2 default hr_api.g_varchar2
576: ,p_attribute5 in varchar2 default hr_api.g_varchar2
577: ,p_attribute6 in varchar2 default hr_api.g_varchar2
578: ,p_attribute7 in varchar2 default hr_api.g_varchar2
579: ,p_attribute8 in varchar2 default hr_api.g_varchar2
580: ,p_attribute9 in varchar2 default hr_api.g_varchar2
581: ,p_attribute10 in varchar2 default hr_api.g_varchar2
582: ,p_attribute11 in varchar2 default hr_api.g_varchar2
583: ,p_attribute12 in varchar2 default hr_api.g_varchar2
584: ,p_attribute13 in varchar2 default hr_api.g_varchar2
577: ,p_attribute6 in varchar2 default hr_api.g_varchar2
578: ,p_attribute7 in varchar2 default hr_api.g_varchar2
579: ,p_attribute8 in varchar2 default hr_api.g_varchar2
580: ,p_attribute9 in varchar2 default hr_api.g_varchar2
581: ,p_attribute10 in varchar2 default hr_api.g_varchar2
582: ,p_attribute11 in varchar2 default hr_api.g_varchar2
583: ,p_attribute12 in varchar2 default hr_api.g_varchar2
584: ,p_attribute13 in varchar2 default hr_api.g_varchar2
585: ,p_attribute14 in varchar2 default hr_api.g_varchar2
578: ,p_attribute7 in varchar2 default hr_api.g_varchar2
579: ,p_attribute8 in varchar2 default hr_api.g_varchar2
580: ,p_attribute9 in varchar2 default hr_api.g_varchar2
581: ,p_attribute10 in varchar2 default hr_api.g_varchar2
582: ,p_attribute11 in varchar2 default hr_api.g_varchar2
583: ,p_attribute12 in varchar2 default hr_api.g_varchar2
584: ,p_attribute13 in varchar2 default hr_api.g_varchar2
585: ,p_attribute14 in varchar2 default hr_api.g_varchar2
586: ,p_attribute15 in varchar2 default hr_api.g_varchar2
579: ,p_attribute8 in varchar2 default hr_api.g_varchar2
580: ,p_attribute9 in varchar2 default hr_api.g_varchar2
581: ,p_attribute10 in varchar2 default hr_api.g_varchar2
582: ,p_attribute11 in varchar2 default hr_api.g_varchar2
583: ,p_attribute12 in varchar2 default hr_api.g_varchar2
584: ,p_attribute13 in varchar2 default hr_api.g_varchar2
585: ,p_attribute14 in varchar2 default hr_api.g_varchar2
586: ,p_attribute15 in varchar2 default hr_api.g_varchar2
587: ,p_attribute16 in varchar2 default hr_api.g_varchar2
580: ,p_attribute9 in varchar2 default hr_api.g_varchar2
581: ,p_attribute10 in varchar2 default hr_api.g_varchar2
582: ,p_attribute11 in varchar2 default hr_api.g_varchar2
583: ,p_attribute12 in varchar2 default hr_api.g_varchar2
584: ,p_attribute13 in varchar2 default hr_api.g_varchar2
585: ,p_attribute14 in varchar2 default hr_api.g_varchar2
586: ,p_attribute15 in varchar2 default hr_api.g_varchar2
587: ,p_attribute16 in varchar2 default hr_api.g_varchar2
588: ,p_attribute17 in varchar2 default hr_api.g_varchar2
581: ,p_attribute10 in varchar2 default hr_api.g_varchar2
582: ,p_attribute11 in varchar2 default hr_api.g_varchar2
583: ,p_attribute12 in varchar2 default hr_api.g_varchar2
584: ,p_attribute13 in varchar2 default hr_api.g_varchar2
585: ,p_attribute14 in varchar2 default hr_api.g_varchar2
586: ,p_attribute15 in varchar2 default hr_api.g_varchar2
587: ,p_attribute16 in varchar2 default hr_api.g_varchar2
588: ,p_attribute17 in varchar2 default hr_api.g_varchar2
589: ,p_attribute18 in varchar2 default hr_api.g_varchar2
582: ,p_attribute11 in varchar2 default hr_api.g_varchar2
583: ,p_attribute12 in varchar2 default hr_api.g_varchar2
584: ,p_attribute13 in varchar2 default hr_api.g_varchar2
585: ,p_attribute14 in varchar2 default hr_api.g_varchar2
586: ,p_attribute15 in varchar2 default hr_api.g_varchar2
587: ,p_attribute16 in varchar2 default hr_api.g_varchar2
588: ,p_attribute17 in varchar2 default hr_api.g_varchar2
589: ,p_attribute18 in varchar2 default hr_api.g_varchar2
590: ,p_attribute19 in varchar2 default hr_api.g_varchar2
583: ,p_attribute12 in varchar2 default hr_api.g_varchar2
584: ,p_attribute13 in varchar2 default hr_api.g_varchar2
585: ,p_attribute14 in varchar2 default hr_api.g_varchar2
586: ,p_attribute15 in varchar2 default hr_api.g_varchar2
587: ,p_attribute16 in varchar2 default hr_api.g_varchar2
588: ,p_attribute17 in varchar2 default hr_api.g_varchar2
589: ,p_attribute18 in varchar2 default hr_api.g_varchar2
590: ,p_attribute19 in varchar2 default hr_api.g_varchar2
591: ,p_attribute20 in varchar2 default hr_api.g_varchar2
584: ,p_attribute13 in varchar2 default hr_api.g_varchar2
585: ,p_attribute14 in varchar2 default hr_api.g_varchar2
586: ,p_attribute15 in varchar2 default hr_api.g_varchar2
587: ,p_attribute16 in varchar2 default hr_api.g_varchar2
588: ,p_attribute17 in varchar2 default hr_api.g_varchar2
589: ,p_attribute18 in varchar2 default hr_api.g_varchar2
590: ,p_attribute19 in varchar2 default hr_api.g_varchar2
591: ,p_attribute20 in varchar2 default hr_api.g_varchar2
592: /*Added for Enhancement 4021737 */
585: ,p_attribute14 in varchar2 default hr_api.g_varchar2
586: ,p_attribute15 in varchar2 default hr_api.g_varchar2
587: ,p_attribute16 in varchar2 default hr_api.g_varchar2
588: ,p_attribute17 in varchar2 default hr_api.g_varchar2
589: ,p_attribute18 in varchar2 default hr_api.g_varchar2
590: ,p_attribute19 in varchar2 default hr_api.g_varchar2
591: ,p_attribute20 in varchar2 default hr_api.g_varchar2
592: /*Added for Enhancement 4021737 */
593: ,p_attribute21 in varchar2 default hr_api.g_varchar2
586: ,p_attribute15 in varchar2 default hr_api.g_varchar2
587: ,p_attribute16 in varchar2 default hr_api.g_varchar2
588: ,p_attribute17 in varchar2 default hr_api.g_varchar2
589: ,p_attribute18 in varchar2 default hr_api.g_varchar2
590: ,p_attribute19 in varchar2 default hr_api.g_varchar2
591: ,p_attribute20 in varchar2 default hr_api.g_varchar2
592: /*Added for Enhancement 4021737 */
593: ,p_attribute21 in varchar2 default hr_api.g_varchar2
594: ,p_attribute22 in varchar2 default hr_api.g_varchar2
587: ,p_attribute16 in varchar2 default hr_api.g_varchar2
588: ,p_attribute17 in varchar2 default hr_api.g_varchar2
589: ,p_attribute18 in varchar2 default hr_api.g_varchar2
590: ,p_attribute19 in varchar2 default hr_api.g_varchar2
591: ,p_attribute20 in varchar2 default hr_api.g_varchar2
592: /*Added for Enhancement 4021737 */
593: ,p_attribute21 in varchar2 default hr_api.g_varchar2
594: ,p_attribute22 in varchar2 default hr_api.g_varchar2
595: ,p_attribute23 in varchar2 default hr_api.g_varchar2
589: ,p_attribute18 in varchar2 default hr_api.g_varchar2
590: ,p_attribute19 in varchar2 default hr_api.g_varchar2
591: ,p_attribute20 in varchar2 default hr_api.g_varchar2
592: /*Added for Enhancement 4021737 */
593: ,p_attribute21 in varchar2 default hr_api.g_varchar2
594: ,p_attribute22 in varchar2 default hr_api.g_varchar2
595: ,p_attribute23 in varchar2 default hr_api.g_varchar2
596: ,p_attribute24 in varchar2 default hr_api.g_varchar2
597: ,p_attribute25 in varchar2 default hr_api.g_varchar2
590: ,p_attribute19 in varchar2 default hr_api.g_varchar2
591: ,p_attribute20 in varchar2 default hr_api.g_varchar2
592: /*Added for Enhancement 4021737 */
593: ,p_attribute21 in varchar2 default hr_api.g_varchar2
594: ,p_attribute22 in varchar2 default hr_api.g_varchar2
595: ,p_attribute23 in varchar2 default hr_api.g_varchar2
596: ,p_attribute24 in varchar2 default hr_api.g_varchar2
597: ,p_attribute25 in varchar2 default hr_api.g_varchar2
598: ,p_attribute26 in varchar2 default hr_api.g_varchar2
591: ,p_attribute20 in varchar2 default hr_api.g_varchar2
592: /*Added for Enhancement 4021737 */
593: ,p_attribute21 in varchar2 default hr_api.g_varchar2
594: ,p_attribute22 in varchar2 default hr_api.g_varchar2
595: ,p_attribute23 in varchar2 default hr_api.g_varchar2
596: ,p_attribute24 in varchar2 default hr_api.g_varchar2
597: ,p_attribute25 in varchar2 default hr_api.g_varchar2
598: ,p_attribute26 in varchar2 default hr_api.g_varchar2
599: ,p_attribute27 in varchar2 default hr_api.g_varchar2
592: /*Added for Enhancement 4021737 */
593: ,p_attribute21 in varchar2 default hr_api.g_varchar2
594: ,p_attribute22 in varchar2 default hr_api.g_varchar2
595: ,p_attribute23 in varchar2 default hr_api.g_varchar2
596: ,p_attribute24 in varchar2 default hr_api.g_varchar2
597: ,p_attribute25 in varchar2 default hr_api.g_varchar2
598: ,p_attribute26 in varchar2 default hr_api.g_varchar2
599: ,p_attribute27 in varchar2 default hr_api.g_varchar2
600: ,p_attribute28 in varchar2 default hr_api.g_varchar2
593: ,p_attribute21 in varchar2 default hr_api.g_varchar2
594: ,p_attribute22 in varchar2 default hr_api.g_varchar2
595: ,p_attribute23 in varchar2 default hr_api.g_varchar2
596: ,p_attribute24 in varchar2 default hr_api.g_varchar2
597: ,p_attribute25 in varchar2 default hr_api.g_varchar2
598: ,p_attribute26 in varchar2 default hr_api.g_varchar2
599: ,p_attribute27 in varchar2 default hr_api.g_varchar2
600: ,p_attribute28 in varchar2 default hr_api.g_varchar2
601: ,p_attribute29 in varchar2 default hr_api.g_varchar2
594: ,p_attribute22 in varchar2 default hr_api.g_varchar2
595: ,p_attribute23 in varchar2 default hr_api.g_varchar2
596: ,p_attribute24 in varchar2 default hr_api.g_varchar2
597: ,p_attribute25 in varchar2 default hr_api.g_varchar2
598: ,p_attribute26 in varchar2 default hr_api.g_varchar2
599: ,p_attribute27 in varchar2 default hr_api.g_varchar2
600: ,p_attribute28 in varchar2 default hr_api.g_varchar2
601: ,p_attribute29 in varchar2 default hr_api.g_varchar2
602: ,p_attribute30 in varchar2 default hr_api.g_varchar2
595: ,p_attribute23 in varchar2 default hr_api.g_varchar2
596: ,p_attribute24 in varchar2 default hr_api.g_varchar2
597: ,p_attribute25 in varchar2 default hr_api.g_varchar2
598: ,p_attribute26 in varchar2 default hr_api.g_varchar2
599: ,p_attribute27 in varchar2 default hr_api.g_varchar2
600: ,p_attribute28 in varchar2 default hr_api.g_varchar2
601: ,p_attribute29 in varchar2 default hr_api.g_varchar2
602: ,p_attribute30 in varchar2 default hr_api.g_varchar2
603: /* End Enhancement 4021737 */
596: ,p_attribute24 in varchar2 default hr_api.g_varchar2
597: ,p_attribute25 in varchar2 default hr_api.g_varchar2
598: ,p_attribute26 in varchar2 default hr_api.g_varchar2
599: ,p_attribute27 in varchar2 default hr_api.g_varchar2
600: ,p_attribute28 in varchar2 default hr_api.g_varchar2
601: ,p_attribute29 in varchar2 default hr_api.g_varchar2
602: ,p_attribute30 in varchar2 default hr_api.g_varchar2
603: /* End Enhancement 4021737 */
604: ,p_salary_survey_line_id in number
597: ,p_attribute25 in varchar2 default hr_api.g_varchar2
598: ,p_attribute26 in varchar2 default hr_api.g_varchar2
599: ,p_attribute27 in varchar2 default hr_api.g_varchar2
600: ,p_attribute28 in varchar2 default hr_api.g_varchar2
601: ,p_attribute29 in varchar2 default hr_api.g_varchar2
602: ,p_attribute30 in varchar2 default hr_api.g_varchar2
603: /* End Enhancement 4021737 */
604: ,p_salary_survey_line_id in number
605: ,p_ssl_object_version_number in out nocopy number
598: ,p_attribute26 in varchar2 default hr_api.g_varchar2
599: ,p_attribute27 in varchar2 default hr_api.g_varchar2
600: ,p_attribute28 in varchar2 default hr_api.g_varchar2
601: ,p_attribute29 in varchar2 default hr_api.g_varchar2
602: ,p_attribute30 in varchar2 default hr_api.g_varchar2
603: /* End Enhancement 4021737 */
604: ,p_salary_survey_line_id in number
605: ,p_ssl_object_version_number in out nocopy number
606: ) is
718: p_attribute30 => p_attribute30,
719: p_ssl_object_version_number => l_ssl_object_version_number
720: );
721: exception
722: when hr_api.cannot_find_prog_unit then
723: hr_api.cannot_find_prog_unit_error
724: (p_module_name => 'update_salary_survey_line'
725: ,p_hook_type => 'BP'
726: );
719: p_ssl_object_version_number => l_ssl_object_version_number
720: );
721: exception
722: when hr_api.cannot_find_prog_unit then
723: hr_api.cannot_find_prog_unit_error
724: (p_module_name => 'update_salary_survey_line'
725: ,p_hook_type => 'BP'
726: );
727: end;
899: p_salary_survey_line_id => l_salary_survey_line_id,
900: p_ssl_object_version_number => l_ssl_object_version_number
901: );
902: exception
903: when hr_api.cannot_find_prog_unit then
904: hr_api.cannot_find_prog_unit_error
905: (p_module_name => 'update_salary_survey_line'
906: ,p_hook_type => 'AP'
907: );
900: p_ssl_object_version_number => l_ssl_object_version_number
901: );
902: exception
903: when hr_api.cannot_find_prog_unit then
904: hr_api.cannot_find_prog_unit_error
905: (p_module_name => 'update_salary_survey_line'
906: ,p_hook_type => 'AP'
907: );
908: end;
912: -- When in validation only mode raise the Validate_Enabled exception
913: --
914: if p_validate then
915: --
916: raise hr_api.validate_enabled;
917: --
918: end if;
919: --
920: -- Set all output arguments
923: --
924: hr_utility.set_location(' Leaving:'||l_proc, 70);
925: --
926: exception
927: when hr_api.validate_enabled then
928: --
929: -- As the Validate_Enabled exception has been raised
930: -- we must rollback to the savepoint
931: --
990: (p_salary_survey_line_id => l_salary_survey_line_id
991: ,p_ssl_object_version_number => l_ssl_object_version_number
992: );
993: exception
994: when hr_api.cannot_find_prog_unit then
995: hr_api.cannot_find_prog_unit_error
996: (p_module_name => 'delete_salary_survey_line'
997: ,p_hook_type => 'BP'
998: );
991: ,p_ssl_object_version_number => l_ssl_object_version_number
992: );
993: exception
994: when hr_api.cannot_find_prog_unit then
995: hr_api.cannot_find_prog_unit_error
996: (p_module_name => 'delete_salary_survey_line'
997: ,p_hook_type => 'BP'
998: );
999: end;
1015: (p_salary_survey_line_id => l_salary_survey_line_id
1016: ,p_ssl_object_version_number => l_ssl_object_version_number
1017: );
1018: exception
1019: when hr_api.cannot_find_prog_unit then
1020: hr_api.cannot_find_prog_unit_error
1021: (p_module_name => 'delete_salary_survey_line'
1022: ,p_hook_type => 'AP'
1023: );
1016: ,p_ssl_object_version_number => l_ssl_object_version_number
1017: );
1018: exception
1019: when hr_api.cannot_find_prog_unit then
1020: hr_api.cannot_find_prog_unit_error
1021: (p_module_name => 'delete_salary_survey_line'
1022: ,p_hook_type => 'AP'
1023: );
1024: end;
1027: -- When in validation only mode raise the Validate_Enabled exception
1028: --
1029: if p_validate then
1030: --
1031: raise hr_api.validate_enabled;
1032: --
1033: end if;
1034: --
1035: hr_utility.set_location(' Leaving:'||l_proc, 70);
1034: --
1035: hr_utility.set_location(' Leaving:'||l_proc, 70);
1036: --
1037: exception
1038: when hr_api.validate_enabled then
1039: --
1040: -- As the Validate_Enabled exception has been raised
1041: -- we must rollback to the savepoint
1042: --