99: Procedure upd
100: (
101: p_salary_survey_line_id in number,
102: p_object_version_number in out nocopy number,
103: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
104: p_survey_region_code in varchar2 default hr_api.g_varchar2,
105: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
106: p_company_size_code in varchar2 default hr_api.g_varchar2,
107: p_industry_code in varchar2 default hr_api.g_varchar2,
100: (
101: p_salary_survey_line_id in number,
102: p_object_version_number in out nocopy number,
103: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
104: p_survey_region_code in varchar2 default hr_api.g_varchar2,
105: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
106: p_company_size_code in varchar2 default hr_api.g_varchar2,
107: p_industry_code in varchar2 default hr_api.g_varchar2,
108: p_survey_age_code in varchar2 default hr_api.g_varchar2,
101: p_salary_survey_line_id in number,
102: p_object_version_number in out nocopy number,
103: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
104: p_survey_region_code in varchar2 default hr_api.g_varchar2,
105: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
106: p_company_size_code in varchar2 default hr_api.g_varchar2,
107: p_industry_code in varchar2 default hr_api.g_varchar2,
108: p_survey_age_code in varchar2 default hr_api.g_varchar2,
109: p_start_date in date default hr_api.g_date,
102: p_object_version_number in out nocopy number,
103: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
104: p_survey_region_code in varchar2 default hr_api.g_varchar2,
105: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
106: p_company_size_code in varchar2 default hr_api.g_varchar2,
107: p_industry_code in varchar2 default hr_api.g_varchar2,
108: p_survey_age_code in varchar2 default hr_api.g_varchar2,
109: p_start_date in date default hr_api.g_date,
110: p_end_date in date default hr_api.g_date,
103: p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
104: p_survey_region_code in varchar2 default hr_api.g_varchar2,
105: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
106: p_company_size_code in varchar2 default hr_api.g_varchar2,
107: p_industry_code in varchar2 default hr_api.g_varchar2,
108: p_survey_age_code in varchar2 default hr_api.g_varchar2,
109: p_start_date in date default hr_api.g_date,
110: p_end_date in date default hr_api.g_date,
111: p_currency_code in varchar2 default hr_api.g_varchar2,
104: p_survey_region_code in varchar2 default hr_api.g_varchar2,
105: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
106: p_company_size_code in varchar2 default hr_api.g_varchar2,
107: p_industry_code in varchar2 default hr_api.g_varchar2,
108: p_survey_age_code in varchar2 default hr_api.g_varchar2,
109: p_start_date in date default hr_api.g_date,
110: p_end_date in date default hr_api.g_date,
111: p_currency_code in varchar2 default hr_api.g_varchar2,
112: p_differential in number default hr_api.g_number,
105: p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
106: p_company_size_code in varchar2 default hr_api.g_varchar2,
107: p_industry_code in varchar2 default hr_api.g_varchar2,
108: p_survey_age_code in varchar2 default hr_api.g_varchar2,
109: p_start_date in date default hr_api.g_date,
110: p_end_date in date default hr_api.g_date,
111: p_currency_code in varchar2 default hr_api.g_varchar2,
112: p_differential in number default hr_api.g_number,
113: p_minimum_pay in number default hr_api.g_number,
106: p_company_size_code in varchar2 default hr_api.g_varchar2,
107: p_industry_code in varchar2 default hr_api.g_varchar2,
108: p_survey_age_code in varchar2 default hr_api.g_varchar2,
109: p_start_date in date default hr_api.g_date,
110: p_end_date in date default hr_api.g_date,
111: p_currency_code in varchar2 default hr_api.g_varchar2,
112: p_differential in number default hr_api.g_number,
113: p_minimum_pay in number default hr_api.g_number,
114: p_mean_pay in number default hr_api.g_number,
107: p_industry_code in varchar2 default hr_api.g_varchar2,
108: p_survey_age_code in varchar2 default hr_api.g_varchar2,
109: p_start_date in date default hr_api.g_date,
110: p_end_date in date default hr_api.g_date,
111: p_currency_code in varchar2 default hr_api.g_varchar2,
112: p_differential in number default hr_api.g_number,
113: p_minimum_pay in number default hr_api.g_number,
114: p_mean_pay in number default hr_api.g_number,
115: p_maximum_pay in number default hr_api.g_number,
108: p_survey_age_code in varchar2 default hr_api.g_varchar2,
109: p_start_date in date default hr_api.g_date,
110: p_end_date in date default hr_api.g_date,
111: p_currency_code in varchar2 default hr_api.g_varchar2,
112: p_differential in number default hr_api.g_number,
113: p_minimum_pay in number default hr_api.g_number,
114: p_mean_pay in number default hr_api.g_number,
115: p_maximum_pay in number default hr_api.g_number,
116: p_graduate_pay in number default hr_api.g_number,
109: p_start_date in date default hr_api.g_date,
110: p_end_date in date default hr_api.g_date,
111: p_currency_code in varchar2 default hr_api.g_varchar2,
112: p_differential in number default hr_api.g_number,
113: p_minimum_pay in number default hr_api.g_number,
114: p_mean_pay in number default hr_api.g_number,
115: p_maximum_pay in number default hr_api.g_number,
116: p_graduate_pay in number default hr_api.g_number,
117: p_starting_pay in number default hr_api.g_number,
110: p_end_date in date default hr_api.g_date,
111: p_currency_code in varchar2 default hr_api.g_varchar2,
112: p_differential in number default hr_api.g_number,
113: p_minimum_pay in number default hr_api.g_number,
114: p_mean_pay in number default hr_api.g_number,
115: p_maximum_pay in number default hr_api.g_number,
116: p_graduate_pay in number default hr_api.g_number,
117: p_starting_pay in number default hr_api.g_number,
118: p_percentage_change in number default hr_api.g_number,
111: p_currency_code in varchar2 default hr_api.g_varchar2,
112: p_differential in number default hr_api.g_number,
113: p_minimum_pay in number default hr_api.g_number,
114: p_mean_pay in number default hr_api.g_number,
115: p_maximum_pay in number default hr_api.g_number,
116: p_graduate_pay in number default hr_api.g_number,
117: p_starting_pay in number default hr_api.g_number,
118: p_percentage_change in number default hr_api.g_number,
119: p_job_first_quartile in number default hr_api.g_number,
112: p_differential in number default hr_api.g_number,
113: p_minimum_pay in number default hr_api.g_number,
114: p_mean_pay in number default hr_api.g_number,
115: p_maximum_pay in number default hr_api.g_number,
116: p_graduate_pay in number default hr_api.g_number,
117: p_starting_pay in number default hr_api.g_number,
118: p_percentage_change in number default hr_api.g_number,
119: p_job_first_quartile in number default hr_api.g_number,
120: p_job_median_quartile in number default hr_api.g_number,
113: p_minimum_pay in number default hr_api.g_number,
114: p_mean_pay in number default hr_api.g_number,
115: p_maximum_pay in number default hr_api.g_number,
116: p_graduate_pay in number default hr_api.g_number,
117: p_starting_pay in number default hr_api.g_number,
118: p_percentage_change in number default hr_api.g_number,
119: p_job_first_quartile in number default hr_api.g_number,
120: p_job_median_quartile in number default hr_api.g_number,
121: p_job_third_quartile in number default hr_api.g_number,
114: p_mean_pay in number default hr_api.g_number,
115: p_maximum_pay in number default hr_api.g_number,
116: p_graduate_pay in number default hr_api.g_number,
117: p_starting_pay in number default hr_api.g_number,
118: p_percentage_change in number default hr_api.g_number,
119: p_job_first_quartile in number default hr_api.g_number,
120: p_job_median_quartile in number default hr_api.g_number,
121: p_job_third_quartile in number default hr_api.g_number,
122: p_job_fourth_quartile in number default hr_api.g_number,
115: p_maximum_pay in number default hr_api.g_number,
116: p_graduate_pay in number default hr_api.g_number,
117: p_starting_pay in number default hr_api.g_number,
118: p_percentage_change in number default hr_api.g_number,
119: p_job_first_quartile in number default hr_api.g_number,
120: p_job_median_quartile in number default hr_api.g_number,
121: p_job_third_quartile in number default hr_api.g_number,
122: p_job_fourth_quartile in number default hr_api.g_number,
123: p_minimum_total_compensation in number default hr_api.g_number,
116: p_graduate_pay in number default hr_api.g_number,
117: p_starting_pay in number default hr_api.g_number,
118: p_percentage_change in number default hr_api.g_number,
119: p_job_first_quartile in number default hr_api.g_number,
120: p_job_median_quartile in number default hr_api.g_number,
121: p_job_third_quartile in number default hr_api.g_number,
122: p_job_fourth_quartile in number default hr_api.g_number,
123: p_minimum_total_compensation in number default hr_api.g_number,
124: p_mean_total_compensation in number default hr_api.g_number,
117: p_starting_pay in number default hr_api.g_number,
118: p_percentage_change in number default hr_api.g_number,
119: p_job_first_quartile in number default hr_api.g_number,
120: p_job_median_quartile in number default hr_api.g_number,
121: p_job_third_quartile in number default hr_api.g_number,
122: p_job_fourth_quartile in number default hr_api.g_number,
123: p_minimum_total_compensation in number default hr_api.g_number,
124: p_mean_total_compensation in number default hr_api.g_number,
125: p_maximum_total_compensation in number default hr_api.g_number,
118: p_percentage_change in number default hr_api.g_number,
119: p_job_first_quartile in number default hr_api.g_number,
120: p_job_median_quartile in number default hr_api.g_number,
121: p_job_third_quartile in number default hr_api.g_number,
122: p_job_fourth_quartile in number default hr_api.g_number,
123: p_minimum_total_compensation in number default hr_api.g_number,
124: p_mean_total_compensation in number default hr_api.g_number,
125: p_maximum_total_compensation in number default hr_api.g_number,
126: p_compnstn_first_quartile in number default hr_api.g_number,
119: p_job_first_quartile in number default hr_api.g_number,
120: p_job_median_quartile in number default hr_api.g_number,
121: p_job_third_quartile in number default hr_api.g_number,
122: p_job_fourth_quartile in number default hr_api.g_number,
123: p_minimum_total_compensation in number default hr_api.g_number,
124: p_mean_total_compensation in number default hr_api.g_number,
125: p_maximum_total_compensation in number default hr_api.g_number,
126: p_compnstn_first_quartile in number default hr_api.g_number,
127: p_compnstn_median_quartile in number default hr_api.g_number,
120: p_job_median_quartile in number default hr_api.g_number,
121: p_job_third_quartile in number default hr_api.g_number,
122: p_job_fourth_quartile in number default hr_api.g_number,
123: p_minimum_total_compensation in number default hr_api.g_number,
124: p_mean_total_compensation in number default hr_api.g_number,
125: p_maximum_total_compensation in number default hr_api.g_number,
126: p_compnstn_first_quartile in number default hr_api.g_number,
127: p_compnstn_median_quartile in number default hr_api.g_number,
128: p_compnstn_third_quartile in number default hr_api.g_number,
121: p_job_third_quartile in number default hr_api.g_number,
122: p_job_fourth_quartile in number default hr_api.g_number,
123: p_minimum_total_compensation in number default hr_api.g_number,
124: p_mean_total_compensation in number default hr_api.g_number,
125: p_maximum_total_compensation in number default hr_api.g_number,
126: p_compnstn_first_quartile in number default hr_api.g_number,
127: p_compnstn_median_quartile in number default hr_api.g_number,
128: p_compnstn_third_quartile in number default hr_api.g_number,
129: p_compnstn_fourth_quartile in number default hr_api.g_number,
122: p_job_fourth_quartile in number default hr_api.g_number,
123: p_minimum_total_compensation in number default hr_api.g_number,
124: p_mean_total_compensation in number default hr_api.g_number,
125: p_maximum_total_compensation in number default hr_api.g_number,
126: p_compnstn_first_quartile in number default hr_api.g_number,
127: p_compnstn_median_quartile in number default hr_api.g_number,
128: p_compnstn_third_quartile in number default hr_api.g_number,
129: p_compnstn_fourth_quartile in number default hr_api.g_number,
130: /*Added for Enhancement 4021737 */
123: p_minimum_total_compensation in number default hr_api.g_number,
124: p_mean_total_compensation in number default hr_api.g_number,
125: p_maximum_total_compensation in number default hr_api.g_number,
126: p_compnstn_first_quartile in number default hr_api.g_number,
127: p_compnstn_median_quartile in number default hr_api.g_number,
128: p_compnstn_third_quartile in number default hr_api.g_number,
129: p_compnstn_fourth_quartile in number default hr_api.g_number,
130: /*Added for Enhancement 4021737 */
131: p_tenth_percentile in number default hr_api.g_number,
124: p_mean_total_compensation in number default hr_api.g_number,
125: p_maximum_total_compensation in number default hr_api.g_number,
126: p_compnstn_first_quartile in number default hr_api.g_number,
127: p_compnstn_median_quartile in number default hr_api.g_number,
128: p_compnstn_third_quartile in number default hr_api.g_number,
129: p_compnstn_fourth_quartile in number default hr_api.g_number,
130: /*Added for Enhancement 4021737 */
131: p_tenth_percentile in number default hr_api.g_number,
132: p_twenty_fifth_percentile in number default hr_api.g_number,
125: p_maximum_total_compensation in number default hr_api.g_number,
126: p_compnstn_first_quartile in number default hr_api.g_number,
127: p_compnstn_median_quartile in number default hr_api.g_number,
128: p_compnstn_third_quartile in number default hr_api.g_number,
129: p_compnstn_fourth_quartile in number default hr_api.g_number,
130: /*Added for Enhancement 4021737 */
131: p_tenth_percentile in number default hr_api.g_number,
132: p_twenty_fifth_percentile in number default hr_api.g_number,
133: p_fiftieth_percentile in number default hr_api.g_number,
127: p_compnstn_median_quartile in number default hr_api.g_number,
128: p_compnstn_third_quartile in number default hr_api.g_number,
129: p_compnstn_fourth_quartile in number default hr_api.g_number,
130: /*Added for Enhancement 4021737 */
131: p_tenth_percentile in number default hr_api.g_number,
132: p_twenty_fifth_percentile in number default hr_api.g_number,
133: p_fiftieth_percentile in number default hr_api.g_number,
134: p_seventy_fifth_percentile in number default hr_api.g_number,
135: p_ninetieth_percentile in number default hr_api.g_number,
128: p_compnstn_third_quartile in number default hr_api.g_number,
129: p_compnstn_fourth_quartile in number default hr_api.g_number,
130: /*Added for Enhancement 4021737 */
131: p_tenth_percentile in number default hr_api.g_number,
132: p_twenty_fifth_percentile in number default hr_api.g_number,
133: p_fiftieth_percentile in number default hr_api.g_number,
134: p_seventy_fifth_percentile in number default hr_api.g_number,
135: p_ninetieth_percentile in number default hr_api.g_number,
136: p_minimum_bonus in number default hr_api.g_number,
129: p_compnstn_fourth_quartile in number default hr_api.g_number,
130: /*Added for Enhancement 4021737 */
131: p_tenth_percentile in number default hr_api.g_number,
132: p_twenty_fifth_percentile in number default hr_api.g_number,
133: p_fiftieth_percentile in number default hr_api.g_number,
134: p_seventy_fifth_percentile in number default hr_api.g_number,
135: p_ninetieth_percentile in number default hr_api.g_number,
136: p_minimum_bonus in number default hr_api.g_number,
137: p_mean_bonus in number default hr_api.g_number,
130: /*Added for Enhancement 4021737 */
131: p_tenth_percentile in number default hr_api.g_number,
132: p_twenty_fifth_percentile in number default hr_api.g_number,
133: p_fiftieth_percentile in number default hr_api.g_number,
134: p_seventy_fifth_percentile in number default hr_api.g_number,
135: p_ninetieth_percentile in number default hr_api.g_number,
136: p_minimum_bonus in number default hr_api.g_number,
137: p_mean_bonus in number default hr_api.g_number,
138: p_maximum_bonus in number default hr_api.g_number,
131: p_tenth_percentile in number default hr_api.g_number,
132: p_twenty_fifth_percentile in number default hr_api.g_number,
133: p_fiftieth_percentile in number default hr_api.g_number,
134: p_seventy_fifth_percentile in number default hr_api.g_number,
135: p_ninetieth_percentile in number default hr_api.g_number,
136: p_minimum_bonus in number default hr_api.g_number,
137: p_mean_bonus in number default hr_api.g_number,
138: p_maximum_bonus in number default hr_api.g_number,
139: p_minimum_salary_increase in number default hr_api.g_number,
132: p_twenty_fifth_percentile in number default hr_api.g_number,
133: p_fiftieth_percentile in number default hr_api.g_number,
134: p_seventy_fifth_percentile in number default hr_api.g_number,
135: p_ninetieth_percentile in number default hr_api.g_number,
136: p_minimum_bonus in number default hr_api.g_number,
137: p_mean_bonus in number default hr_api.g_number,
138: p_maximum_bonus in number default hr_api.g_number,
139: p_minimum_salary_increase in number default hr_api.g_number,
140: p_mean_salary_increase in number default hr_api.g_number,
133: p_fiftieth_percentile in number default hr_api.g_number,
134: p_seventy_fifth_percentile in number default hr_api.g_number,
135: p_ninetieth_percentile in number default hr_api.g_number,
136: p_minimum_bonus in number default hr_api.g_number,
137: p_mean_bonus in number default hr_api.g_number,
138: p_maximum_bonus in number default hr_api.g_number,
139: p_minimum_salary_increase in number default hr_api.g_number,
140: p_mean_salary_increase in number default hr_api.g_number,
141: p_maximum_salary_increase in number default hr_api.g_number,
134: p_seventy_fifth_percentile in number default hr_api.g_number,
135: p_ninetieth_percentile in number default hr_api.g_number,
136: p_minimum_bonus in number default hr_api.g_number,
137: p_mean_bonus in number default hr_api.g_number,
138: p_maximum_bonus in number default hr_api.g_number,
139: p_minimum_salary_increase in number default hr_api.g_number,
140: p_mean_salary_increase in number default hr_api.g_number,
141: p_maximum_salary_increase in number default hr_api.g_number,
142: p_min_variable_compensation in number default hr_api.g_number,
135: p_ninetieth_percentile in number default hr_api.g_number,
136: p_minimum_bonus in number default hr_api.g_number,
137: p_mean_bonus in number default hr_api.g_number,
138: p_maximum_bonus in number default hr_api.g_number,
139: p_minimum_salary_increase in number default hr_api.g_number,
140: p_mean_salary_increase in number default hr_api.g_number,
141: p_maximum_salary_increase in number default hr_api.g_number,
142: p_min_variable_compensation in number default hr_api.g_number,
143: p_mean_variable_compensation in number default hr_api.g_number,
136: p_minimum_bonus in number default hr_api.g_number,
137: p_mean_bonus in number default hr_api.g_number,
138: p_maximum_bonus in number default hr_api.g_number,
139: p_minimum_salary_increase in number default hr_api.g_number,
140: p_mean_salary_increase in number default hr_api.g_number,
141: p_maximum_salary_increase in number default hr_api.g_number,
142: p_min_variable_compensation in number default hr_api.g_number,
143: p_mean_variable_compensation in number default hr_api.g_number,
144: p_max_variable_compensation in number default hr_api.g_number,
137: p_mean_bonus in number default hr_api.g_number,
138: p_maximum_bonus in number default hr_api.g_number,
139: p_minimum_salary_increase in number default hr_api.g_number,
140: p_mean_salary_increase in number default hr_api.g_number,
141: p_maximum_salary_increase in number default hr_api.g_number,
142: p_min_variable_compensation in number default hr_api.g_number,
143: p_mean_variable_compensation in number default hr_api.g_number,
144: p_max_variable_compensation in number default hr_api.g_number,
145: p_minimum_stock in number default hr_api.g_number,
138: p_maximum_bonus in number default hr_api.g_number,
139: p_minimum_salary_increase in number default hr_api.g_number,
140: p_mean_salary_increase in number default hr_api.g_number,
141: p_maximum_salary_increase in number default hr_api.g_number,
142: p_min_variable_compensation in number default hr_api.g_number,
143: p_mean_variable_compensation in number default hr_api.g_number,
144: p_max_variable_compensation in number default hr_api.g_number,
145: p_minimum_stock in number default hr_api.g_number,
146: p_mean_stock in number default hr_api.g_number,
139: p_minimum_salary_increase in number default hr_api.g_number,
140: p_mean_salary_increase in number default hr_api.g_number,
141: p_maximum_salary_increase in number default hr_api.g_number,
142: p_min_variable_compensation in number default hr_api.g_number,
143: p_mean_variable_compensation in number default hr_api.g_number,
144: p_max_variable_compensation in number default hr_api.g_number,
145: p_minimum_stock in number default hr_api.g_number,
146: p_mean_stock in number default hr_api.g_number,
147: p_maximum_stock in number default hr_api.g_number,
140: p_mean_salary_increase in number default hr_api.g_number,
141: p_maximum_salary_increase in number default hr_api.g_number,
142: p_min_variable_compensation in number default hr_api.g_number,
143: p_mean_variable_compensation in number default hr_api.g_number,
144: p_max_variable_compensation in number default hr_api.g_number,
145: p_minimum_stock in number default hr_api.g_number,
146: p_mean_stock in number default hr_api.g_number,
147: p_maximum_stock in number default hr_api.g_number,
148: p_stock_display_type in varchar2 default hr_api.g_varchar2,
141: p_maximum_salary_increase in number default hr_api.g_number,
142: p_min_variable_compensation in number default hr_api.g_number,
143: p_mean_variable_compensation in number default hr_api.g_number,
144: p_max_variable_compensation in number default hr_api.g_number,
145: p_minimum_stock in number default hr_api.g_number,
146: p_mean_stock in number default hr_api.g_number,
147: p_maximum_stock in number default hr_api.g_number,
148: p_stock_display_type in varchar2 default hr_api.g_varchar2,
149: /*End Enhancement 4021737 */
142: p_min_variable_compensation in number default hr_api.g_number,
143: p_mean_variable_compensation in number default hr_api.g_number,
144: p_max_variable_compensation in number default hr_api.g_number,
145: p_minimum_stock in number default hr_api.g_number,
146: p_mean_stock in number default hr_api.g_number,
147: p_maximum_stock in number default hr_api.g_number,
148: p_stock_display_type in varchar2 default hr_api.g_varchar2,
149: /*End Enhancement 4021737 */
150: p_attribute_category in varchar2 default hr_api.g_varchar2,
143: p_mean_variable_compensation in number default hr_api.g_number,
144: p_max_variable_compensation in number default hr_api.g_number,
145: p_minimum_stock in number default hr_api.g_number,
146: p_mean_stock in number default hr_api.g_number,
147: p_maximum_stock in number default hr_api.g_number,
148: p_stock_display_type in varchar2 default hr_api.g_varchar2,
149: /*End Enhancement 4021737 */
150: p_attribute_category in varchar2 default hr_api.g_varchar2,
151: p_attribute1 in varchar2 default hr_api.g_varchar2,
144: p_max_variable_compensation in number default hr_api.g_number,
145: p_minimum_stock in number default hr_api.g_number,
146: p_mean_stock in number default hr_api.g_number,
147: p_maximum_stock in number default hr_api.g_number,
148: p_stock_display_type in varchar2 default hr_api.g_varchar2,
149: /*End Enhancement 4021737 */
150: p_attribute_category in varchar2 default hr_api.g_varchar2,
151: p_attribute1 in varchar2 default hr_api.g_varchar2,
152: p_attribute2 in varchar2 default hr_api.g_varchar2,
146: p_mean_stock in number default hr_api.g_number,
147: p_maximum_stock in number default hr_api.g_number,
148: p_stock_display_type in varchar2 default hr_api.g_varchar2,
149: /*End Enhancement 4021737 */
150: p_attribute_category in varchar2 default hr_api.g_varchar2,
151: p_attribute1 in varchar2 default hr_api.g_varchar2,
152: p_attribute2 in varchar2 default hr_api.g_varchar2,
153: p_attribute3 in varchar2 default hr_api.g_varchar2,
154: p_attribute4 in varchar2 default hr_api.g_varchar2,
147: p_maximum_stock in number default hr_api.g_number,
148: p_stock_display_type in varchar2 default hr_api.g_varchar2,
149: /*End Enhancement 4021737 */
150: p_attribute_category in varchar2 default hr_api.g_varchar2,
151: p_attribute1 in varchar2 default hr_api.g_varchar2,
152: p_attribute2 in varchar2 default hr_api.g_varchar2,
153: p_attribute3 in varchar2 default hr_api.g_varchar2,
154: p_attribute4 in varchar2 default hr_api.g_varchar2,
155: p_attribute5 in varchar2 default hr_api.g_varchar2,
148: p_stock_display_type in varchar2 default hr_api.g_varchar2,
149: /*End Enhancement 4021737 */
150: p_attribute_category in varchar2 default hr_api.g_varchar2,
151: p_attribute1 in varchar2 default hr_api.g_varchar2,
152: p_attribute2 in varchar2 default hr_api.g_varchar2,
153: p_attribute3 in varchar2 default hr_api.g_varchar2,
154: p_attribute4 in varchar2 default hr_api.g_varchar2,
155: p_attribute5 in varchar2 default hr_api.g_varchar2,
156: p_attribute6 in varchar2 default hr_api.g_varchar2,
149: /*End Enhancement 4021737 */
150: p_attribute_category in varchar2 default hr_api.g_varchar2,
151: p_attribute1 in varchar2 default hr_api.g_varchar2,
152: p_attribute2 in varchar2 default hr_api.g_varchar2,
153: p_attribute3 in varchar2 default hr_api.g_varchar2,
154: p_attribute4 in varchar2 default hr_api.g_varchar2,
155: p_attribute5 in varchar2 default hr_api.g_varchar2,
156: p_attribute6 in varchar2 default hr_api.g_varchar2,
157: p_attribute7 in varchar2 default hr_api.g_varchar2,
150: p_attribute_category in varchar2 default hr_api.g_varchar2,
151: p_attribute1 in varchar2 default hr_api.g_varchar2,
152: p_attribute2 in varchar2 default hr_api.g_varchar2,
153: p_attribute3 in varchar2 default hr_api.g_varchar2,
154: p_attribute4 in varchar2 default hr_api.g_varchar2,
155: p_attribute5 in varchar2 default hr_api.g_varchar2,
156: p_attribute6 in varchar2 default hr_api.g_varchar2,
157: p_attribute7 in varchar2 default hr_api.g_varchar2,
158: p_attribute8 in varchar2 default hr_api.g_varchar2,
151: p_attribute1 in varchar2 default hr_api.g_varchar2,
152: p_attribute2 in varchar2 default hr_api.g_varchar2,
153: p_attribute3 in varchar2 default hr_api.g_varchar2,
154: p_attribute4 in varchar2 default hr_api.g_varchar2,
155: p_attribute5 in varchar2 default hr_api.g_varchar2,
156: p_attribute6 in varchar2 default hr_api.g_varchar2,
157: p_attribute7 in varchar2 default hr_api.g_varchar2,
158: p_attribute8 in varchar2 default hr_api.g_varchar2,
159: p_attribute9 in varchar2 default hr_api.g_varchar2,
152: p_attribute2 in varchar2 default hr_api.g_varchar2,
153: p_attribute3 in varchar2 default hr_api.g_varchar2,
154: p_attribute4 in varchar2 default hr_api.g_varchar2,
155: p_attribute5 in varchar2 default hr_api.g_varchar2,
156: p_attribute6 in varchar2 default hr_api.g_varchar2,
157: p_attribute7 in varchar2 default hr_api.g_varchar2,
158: p_attribute8 in varchar2 default hr_api.g_varchar2,
159: p_attribute9 in varchar2 default hr_api.g_varchar2,
160: p_attribute10 in varchar2 default hr_api.g_varchar2,
153: p_attribute3 in varchar2 default hr_api.g_varchar2,
154: p_attribute4 in varchar2 default hr_api.g_varchar2,
155: p_attribute5 in varchar2 default hr_api.g_varchar2,
156: p_attribute6 in varchar2 default hr_api.g_varchar2,
157: p_attribute7 in varchar2 default hr_api.g_varchar2,
158: p_attribute8 in varchar2 default hr_api.g_varchar2,
159: p_attribute9 in varchar2 default hr_api.g_varchar2,
160: p_attribute10 in varchar2 default hr_api.g_varchar2,
161: p_attribute11 in varchar2 default hr_api.g_varchar2,
154: p_attribute4 in varchar2 default hr_api.g_varchar2,
155: p_attribute5 in varchar2 default hr_api.g_varchar2,
156: p_attribute6 in varchar2 default hr_api.g_varchar2,
157: p_attribute7 in varchar2 default hr_api.g_varchar2,
158: p_attribute8 in varchar2 default hr_api.g_varchar2,
159: p_attribute9 in varchar2 default hr_api.g_varchar2,
160: p_attribute10 in varchar2 default hr_api.g_varchar2,
161: p_attribute11 in varchar2 default hr_api.g_varchar2,
162: p_attribute12 in varchar2 default hr_api.g_varchar2,
155: p_attribute5 in varchar2 default hr_api.g_varchar2,
156: p_attribute6 in varchar2 default hr_api.g_varchar2,
157: p_attribute7 in varchar2 default hr_api.g_varchar2,
158: p_attribute8 in varchar2 default hr_api.g_varchar2,
159: p_attribute9 in varchar2 default hr_api.g_varchar2,
160: p_attribute10 in varchar2 default hr_api.g_varchar2,
161: p_attribute11 in varchar2 default hr_api.g_varchar2,
162: p_attribute12 in varchar2 default hr_api.g_varchar2,
163: p_attribute13 in varchar2 default hr_api.g_varchar2,
156: p_attribute6 in varchar2 default hr_api.g_varchar2,
157: p_attribute7 in varchar2 default hr_api.g_varchar2,
158: p_attribute8 in varchar2 default hr_api.g_varchar2,
159: p_attribute9 in varchar2 default hr_api.g_varchar2,
160: p_attribute10 in varchar2 default hr_api.g_varchar2,
161: p_attribute11 in varchar2 default hr_api.g_varchar2,
162: p_attribute12 in varchar2 default hr_api.g_varchar2,
163: p_attribute13 in varchar2 default hr_api.g_varchar2,
164: p_attribute14 in varchar2 default hr_api.g_varchar2,
157: p_attribute7 in varchar2 default hr_api.g_varchar2,
158: p_attribute8 in varchar2 default hr_api.g_varchar2,
159: p_attribute9 in varchar2 default hr_api.g_varchar2,
160: p_attribute10 in varchar2 default hr_api.g_varchar2,
161: p_attribute11 in varchar2 default hr_api.g_varchar2,
162: p_attribute12 in varchar2 default hr_api.g_varchar2,
163: p_attribute13 in varchar2 default hr_api.g_varchar2,
164: p_attribute14 in varchar2 default hr_api.g_varchar2,
165: p_attribute15 in varchar2 default hr_api.g_varchar2,
158: p_attribute8 in varchar2 default hr_api.g_varchar2,
159: p_attribute9 in varchar2 default hr_api.g_varchar2,
160: p_attribute10 in varchar2 default hr_api.g_varchar2,
161: p_attribute11 in varchar2 default hr_api.g_varchar2,
162: p_attribute12 in varchar2 default hr_api.g_varchar2,
163: p_attribute13 in varchar2 default hr_api.g_varchar2,
164: p_attribute14 in varchar2 default hr_api.g_varchar2,
165: p_attribute15 in varchar2 default hr_api.g_varchar2,
166: p_attribute16 in varchar2 default hr_api.g_varchar2,
159: p_attribute9 in varchar2 default hr_api.g_varchar2,
160: p_attribute10 in varchar2 default hr_api.g_varchar2,
161: p_attribute11 in varchar2 default hr_api.g_varchar2,
162: p_attribute12 in varchar2 default hr_api.g_varchar2,
163: p_attribute13 in varchar2 default hr_api.g_varchar2,
164: p_attribute14 in varchar2 default hr_api.g_varchar2,
165: p_attribute15 in varchar2 default hr_api.g_varchar2,
166: p_attribute16 in varchar2 default hr_api.g_varchar2,
167: p_attribute17 in varchar2 default hr_api.g_varchar2,
160: p_attribute10 in varchar2 default hr_api.g_varchar2,
161: p_attribute11 in varchar2 default hr_api.g_varchar2,
162: p_attribute12 in varchar2 default hr_api.g_varchar2,
163: p_attribute13 in varchar2 default hr_api.g_varchar2,
164: p_attribute14 in varchar2 default hr_api.g_varchar2,
165: p_attribute15 in varchar2 default hr_api.g_varchar2,
166: p_attribute16 in varchar2 default hr_api.g_varchar2,
167: p_attribute17 in varchar2 default hr_api.g_varchar2,
168: p_attribute18 in varchar2 default hr_api.g_varchar2,
161: p_attribute11 in varchar2 default hr_api.g_varchar2,
162: p_attribute12 in varchar2 default hr_api.g_varchar2,
163: p_attribute13 in varchar2 default hr_api.g_varchar2,
164: p_attribute14 in varchar2 default hr_api.g_varchar2,
165: p_attribute15 in varchar2 default hr_api.g_varchar2,
166: p_attribute16 in varchar2 default hr_api.g_varchar2,
167: p_attribute17 in varchar2 default hr_api.g_varchar2,
168: p_attribute18 in varchar2 default hr_api.g_varchar2,
169: p_attribute19 in varchar2 default hr_api.g_varchar2,
162: p_attribute12 in varchar2 default hr_api.g_varchar2,
163: p_attribute13 in varchar2 default hr_api.g_varchar2,
164: p_attribute14 in varchar2 default hr_api.g_varchar2,
165: p_attribute15 in varchar2 default hr_api.g_varchar2,
166: p_attribute16 in varchar2 default hr_api.g_varchar2,
167: p_attribute17 in varchar2 default hr_api.g_varchar2,
168: p_attribute18 in varchar2 default hr_api.g_varchar2,
169: p_attribute19 in varchar2 default hr_api.g_varchar2,
170: p_attribute20 in varchar2 default hr_api.g_varchar2,
163: p_attribute13 in varchar2 default hr_api.g_varchar2,
164: p_attribute14 in varchar2 default hr_api.g_varchar2,
165: p_attribute15 in varchar2 default hr_api.g_varchar2,
166: p_attribute16 in varchar2 default hr_api.g_varchar2,
167: p_attribute17 in varchar2 default hr_api.g_varchar2,
168: p_attribute18 in varchar2 default hr_api.g_varchar2,
169: p_attribute19 in varchar2 default hr_api.g_varchar2,
170: p_attribute20 in varchar2 default hr_api.g_varchar2,
171: /*Added for Enhancement 4021737 */
164: p_attribute14 in varchar2 default hr_api.g_varchar2,
165: p_attribute15 in varchar2 default hr_api.g_varchar2,
166: p_attribute16 in varchar2 default hr_api.g_varchar2,
167: p_attribute17 in varchar2 default hr_api.g_varchar2,
168: p_attribute18 in varchar2 default hr_api.g_varchar2,
169: p_attribute19 in varchar2 default hr_api.g_varchar2,
170: p_attribute20 in varchar2 default hr_api.g_varchar2,
171: /*Added for Enhancement 4021737 */
172: p_attribute21 in varchar2 default hr_api.g_varchar2,
165: p_attribute15 in varchar2 default hr_api.g_varchar2,
166: p_attribute16 in varchar2 default hr_api.g_varchar2,
167: p_attribute17 in varchar2 default hr_api.g_varchar2,
168: p_attribute18 in varchar2 default hr_api.g_varchar2,
169: p_attribute19 in varchar2 default hr_api.g_varchar2,
170: p_attribute20 in varchar2 default hr_api.g_varchar2,
171: /*Added for Enhancement 4021737 */
172: p_attribute21 in varchar2 default hr_api.g_varchar2,
173: p_attribute22 in varchar2 default hr_api.g_varchar2,
166: p_attribute16 in varchar2 default hr_api.g_varchar2,
167: p_attribute17 in varchar2 default hr_api.g_varchar2,
168: p_attribute18 in varchar2 default hr_api.g_varchar2,
169: p_attribute19 in varchar2 default hr_api.g_varchar2,
170: p_attribute20 in varchar2 default hr_api.g_varchar2,
171: /*Added for Enhancement 4021737 */
172: p_attribute21 in varchar2 default hr_api.g_varchar2,
173: p_attribute22 in varchar2 default hr_api.g_varchar2,
174: p_attribute23 in varchar2 default hr_api.g_varchar2,
168: p_attribute18 in varchar2 default hr_api.g_varchar2,
169: p_attribute19 in varchar2 default hr_api.g_varchar2,
170: p_attribute20 in varchar2 default hr_api.g_varchar2,
171: /*Added for Enhancement 4021737 */
172: p_attribute21 in varchar2 default hr_api.g_varchar2,
173: p_attribute22 in varchar2 default hr_api.g_varchar2,
174: p_attribute23 in varchar2 default hr_api.g_varchar2,
175: p_attribute24 in varchar2 default hr_api.g_varchar2,
176: p_attribute25 in varchar2 default hr_api.g_varchar2,
169: p_attribute19 in varchar2 default hr_api.g_varchar2,
170: p_attribute20 in varchar2 default hr_api.g_varchar2,
171: /*Added for Enhancement 4021737 */
172: p_attribute21 in varchar2 default hr_api.g_varchar2,
173: p_attribute22 in varchar2 default hr_api.g_varchar2,
174: p_attribute23 in varchar2 default hr_api.g_varchar2,
175: p_attribute24 in varchar2 default hr_api.g_varchar2,
176: p_attribute25 in varchar2 default hr_api.g_varchar2,
177: p_attribute26 in varchar2 default hr_api.g_varchar2,
170: p_attribute20 in varchar2 default hr_api.g_varchar2,
171: /*Added for Enhancement 4021737 */
172: p_attribute21 in varchar2 default hr_api.g_varchar2,
173: p_attribute22 in varchar2 default hr_api.g_varchar2,
174: p_attribute23 in varchar2 default hr_api.g_varchar2,
175: p_attribute24 in varchar2 default hr_api.g_varchar2,
176: p_attribute25 in varchar2 default hr_api.g_varchar2,
177: p_attribute26 in varchar2 default hr_api.g_varchar2,
178: p_attribute27 in varchar2 default hr_api.g_varchar2,
171: /*Added for Enhancement 4021737 */
172: p_attribute21 in varchar2 default hr_api.g_varchar2,
173: p_attribute22 in varchar2 default hr_api.g_varchar2,
174: p_attribute23 in varchar2 default hr_api.g_varchar2,
175: p_attribute24 in varchar2 default hr_api.g_varchar2,
176: p_attribute25 in varchar2 default hr_api.g_varchar2,
177: p_attribute26 in varchar2 default hr_api.g_varchar2,
178: p_attribute27 in varchar2 default hr_api.g_varchar2,
179: p_attribute28 in varchar2 default hr_api.g_varchar2,
172: p_attribute21 in varchar2 default hr_api.g_varchar2,
173: p_attribute22 in varchar2 default hr_api.g_varchar2,
174: p_attribute23 in varchar2 default hr_api.g_varchar2,
175: p_attribute24 in varchar2 default hr_api.g_varchar2,
176: p_attribute25 in varchar2 default hr_api.g_varchar2,
177: p_attribute26 in varchar2 default hr_api.g_varchar2,
178: p_attribute27 in varchar2 default hr_api.g_varchar2,
179: p_attribute28 in varchar2 default hr_api.g_varchar2,
180: p_attribute29 in varchar2 default hr_api.g_varchar2,
173: p_attribute22 in varchar2 default hr_api.g_varchar2,
174: p_attribute23 in varchar2 default hr_api.g_varchar2,
175: p_attribute24 in varchar2 default hr_api.g_varchar2,
176: p_attribute25 in varchar2 default hr_api.g_varchar2,
177: p_attribute26 in varchar2 default hr_api.g_varchar2,
178: p_attribute27 in varchar2 default hr_api.g_varchar2,
179: p_attribute28 in varchar2 default hr_api.g_varchar2,
180: p_attribute29 in varchar2 default hr_api.g_varchar2,
181: p_attribute30 in varchar2 default hr_api.g_varchar2,
174: p_attribute23 in varchar2 default hr_api.g_varchar2,
175: p_attribute24 in varchar2 default hr_api.g_varchar2,
176: p_attribute25 in varchar2 default hr_api.g_varchar2,
177: p_attribute26 in varchar2 default hr_api.g_varchar2,
178: p_attribute27 in varchar2 default hr_api.g_varchar2,
179: p_attribute28 in varchar2 default hr_api.g_varchar2,
180: p_attribute29 in varchar2 default hr_api.g_varchar2,
181: p_attribute30 in varchar2 default hr_api.g_varchar2,
182: /*End Enhancement 4021737 */
175: p_attribute24 in varchar2 default hr_api.g_varchar2,
176: p_attribute25 in varchar2 default hr_api.g_varchar2,
177: p_attribute26 in varchar2 default hr_api.g_varchar2,
178: p_attribute27 in varchar2 default hr_api.g_varchar2,
179: p_attribute28 in varchar2 default hr_api.g_varchar2,
180: p_attribute29 in varchar2 default hr_api.g_varchar2,
181: p_attribute30 in varchar2 default hr_api.g_varchar2,
182: /*End Enhancement 4021737 */
183: p_effective_date in date default hr_api.g_date
176: p_attribute25 in varchar2 default hr_api.g_varchar2,
177: p_attribute26 in varchar2 default hr_api.g_varchar2,
178: p_attribute27 in varchar2 default hr_api.g_varchar2,
179: p_attribute28 in varchar2 default hr_api.g_varchar2,
180: p_attribute29 in varchar2 default hr_api.g_varchar2,
181: p_attribute30 in varchar2 default hr_api.g_varchar2,
182: /*End Enhancement 4021737 */
183: p_effective_date in date default hr_api.g_date
184: );
177: p_attribute26 in varchar2 default hr_api.g_varchar2,
178: p_attribute27 in varchar2 default hr_api.g_varchar2,
179: p_attribute28 in varchar2 default hr_api.g_varchar2,
180: p_attribute29 in varchar2 default hr_api.g_varchar2,
181: p_attribute30 in varchar2 default hr_api.g_varchar2,
182: /*End Enhancement 4021737 */
183: p_effective_date in date default hr_api.g_date
184: );
185: --
179: p_attribute28 in varchar2 default hr_api.g_varchar2,
180: p_attribute29 in varchar2 default hr_api.g_varchar2,
181: p_attribute30 in varchar2 default hr_api.g_varchar2,
182: /*End Enhancement 4021737 */
183: p_effective_date in date default hr_api.g_date
184: );
185: --
186: end per_ssl_upd;