eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SALARY_SURVEY_LINE_API dependencies on HR_API

Line 123: and nvl(survey_region_code,hr_api.g_varchar2)

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)

Line 124: = nvl(p_survey_region_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)

Line 125: and nvl(survey_seniority_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)

Line 126: = nvl(p_survey_seniority_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)

Line 127: and nvl(company_size_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)

Line 128: = nvl(p_company_size_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)

Line 129: and nvl(industry_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)

Line 130: = nvl(p_industry_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)
134: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

Line 131: and nvl(survey_age_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);
135: --

Line 132: = nvl(p_survey_age_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: --
136: begin

Line 133: and salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)

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: --

Line 134: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

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);

Line 239: when hr_api.cannot_find_prog_unit then

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: );

Line 240: hr_api.cannot_find_prog_unit_error

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;

Line 459: when hr_api.cannot_find_prog_unit then

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: );

Line 460: hr_api.cannot_find_prog_unit_error

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;

Line 471: raise hr_api.validate_enabled;

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

Line 484: when hr_api.validate_enabled then

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: --

Line 525: ,p_currency_code in varchar2 default hr_api.g_varchar2

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

Line 526: ,p_survey_region_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

Line 527: ,p_survey_seniority_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

Line 528: ,p_company_size_code in varchar2 default hr_api.g_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
532: ,p_differential in number default hr_api.g_number

Line 529: ,p_industry_code in varchar2 default hr_api.g_varchar2

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

Line 530: ,p_survey_age_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
534: ,p_mean_pay in number default hr_api.g_number

Line 531: ,p_end_date in date default hr_api.g_date

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

Line 532: ,p_differential 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

Line 533: ,p_minimum_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

Line 534: ,p_mean_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

Line 535: ,p_maximum_pay 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

Line 536: ,p_graduate_pay 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

Line 537: ,p_starting_pay 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

Line 538: ,p_percentage_change 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

Line 539: ,p_job_first_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

Line 540: ,p_job_median_quartile 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

Line 541: ,p_job_third_quartile 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

Line 542: ,p_job_fourth_quartile 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

Line 543: ,p_minimum_total_compensation 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

Line 544: ,p_mean_total_compensation 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

Line 545: ,p_maximum_total_compensation 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

Line 546: ,p_compnstn_first_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 */

Line 547: ,p_compnstn_median_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 */
551: ,p_tenth_percentile in number default hr_api.g_number

Line 548: ,p_compnstn_third_quartile 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

Line 549: ,p_compnstn_fourth_quartile 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

Line 551: ,p_tenth_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

Line 552: ,p_twenty_fifth_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

Line 553: ,p_fiftieth_percentile 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

Line 554: ,p_seventy_fifth_percentile 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

Line 555: ,p_ninetieth_percentile 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

Line 556: ,p_minimum_bonus 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

Line 557: ,p_mean_bonus 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

Line 558: ,p_maximum_bonus 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

Line 559: ,p_minimum_salary_increase 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

Line 560: ,p_mean_salary_increase 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

Line 561: ,p_maximum_salary_increase 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

Line 562: ,p_min_variable_compensation 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

Line 563: ,p_mean_variable_compensation 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

Line 564: ,p_max_variable_compensation 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

Line 565: ,p_minimum_stock 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
569: /* End Enhancement 4021737 */

Line 566: ,p_mean_stock 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 */
570: ,p_effective_date in date default hr_api.g_date

Line 567: ,p_maximum_stock 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
571: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 568: ,p_stock_display_type 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

Line 570: ,p_effective_date in date default hr_api.g_date

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

Line 571: ,p_attribute_category 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

Line 572: ,p_attribute1 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

Line 573: ,p_attribute2 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

Line 574: ,p_attribute3 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

Line 575: ,p_attribute4 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

Line 576: ,p_attribute5 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

Line 577: ,p_attribute6 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

Line 578: ,p_attribute7 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

Line 579: ,p_attribute8 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

Line 580: ,p_attribute9 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

Line 581: ,p_attribute10 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

Line 582: ,p_attribute11 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

Line 583: ,p_attribute12 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

Line 584: ,p_attribute13 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

Line 585: ,p_attribute14 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

Line 586: ,p_attribute15 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

Line 587: ,p_attribute16 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

Line 588: ,p_attribute17 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 */

Line 589: ,p_attribute18 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 */
593: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 590: ,p_attribute19 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

Line 591: ,p_attribute20 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

Line 593: ,p_attribute21 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

Line 594: ,p_attribute22 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

Line 595: ,p_attribute23 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

Line 596: ,p_attribute24 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

Line 597: ,p_attribute25 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

Line 598: ,p_attribute26 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

Line 599: ,p_attribute27 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 */

Line 600: ,p_attribute28 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 */
604: ,p_salary_survey_line_id in number

Line 601: ,p_attribute29 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
605: ,p_ssl_object_version_number in out nocopy number

Line 602: ,p_attribute30 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
606: ) is

Line 722: when hr_api.cannot_find_prog_unit then

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: );

Line 723: hr_api.cannot_find_prog_unit_error

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;

Line 903: when hr_api.cannot_find_prog_unit then

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: );

Line 904: hr_api.cannot_find_prog_unit_error

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;

Line 916: raise hr_api.validate_enabled;

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

Line 927: when hr_api.validate_enabled then

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: --

Line 994: when hr_api.cannot_find_prog_unit then

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: );

Line 995: hr_api.cannot_find_prog_unit_error

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;

Line 1019: when hr_api.cannot_find_prog_unit then

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: );

Line 1020: hr_api.cannot_find_prog_unit_error

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;

Line 1031: raise hr_api.validate_enabled;

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);

Line 1038: when hr_api.validate_enabled then

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: --