1 Package hr_salary_survey_line_api AUTHID CURRENT_USER as
2 /* $Header: pesslapi.pkh 120.2 2005/11/03 12:14:14 rthiagar noship $ */
3 /*#
4 * This package contains APIs to create and maintain a Salary Survey details
5 * record.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Salary Survey Line
9 */
13 -- ----------------------------------------------------------------------------
10 --
11 -- ----------------------------------------------------------------------------
12 -- |------------------------< create_salary_survey_line >---------------------|
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a Salary Survey detail record.
18 *
19 * A Salary Survey line records comparable salary figures from the industry.
20 * The process records a survey line for a salary survey header.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * A corresponding Salary Survey must exist.
27 *
28 * <p><b>Post Success</b><br>
29 * Salary survey line is created for the salary survey header.
30 *
31 * <p><b>Post Failure</b><br>
32 * The Salary Survey Line will not be created and an error is raised.
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_salary_survey_id Identifies the parent survey for this survey line
37 * and serves as a foreign key to PER_SALARY_SURVEYS.
38 * @param p_survey_job_name_code The code specifying the job type that this
39 * survey line applies to. Valid values are defined by 'SURVEY_JOB_NAME' lookup
40 * type.
41 * @param p_start_date {@rep:casecolumn PER_SALARY_SURVEY_LINES.START_DATE}
42 * @param p_currency_code The code specifying the currency for the survey.
43 * Serves as a foreign key to FND_CURRENCIES
44 * @param p_survey_region_code The code specifying the Region that this survey
45 * line applies to. Valid values are defined by 'SURVEY_REGION' lookup type.
46 * @param p_survey_seniority_code The code specifying the Seniority that this
47 * survey line applies to. Valid values are defined by 'SURVEY_SENIORITY'
48 * lookup type.
49 * @param p_company_size_code The code specifying the size of the company that
50 * the survey line applies to. Valid values are defined by 'COMPANY_SIZE'
51 * lookup type.
52 * @param p_industry_code The code specifying the industry associated with the
53 * survey line. Valid values are defined by 'INDUSTRY' lookup type.
54 * @param p_survey_age_code The code specifying the Survey Age for the survey
55 * line. Valid values are defined by 'SURVEY_AGE' lookup type.
56 * @param p_end_date {@rep:casecolumn PER_SALARY_SURVEY_LINES.END_DATE}
57 * @param p_differential {@rep:casecolumn PER_SALARY_SURVEY_LINES.DIFFERENTIAL}
58 * @param p_minimum_pay The minimum pay for the job associated with the survey
59 * line.
60 * @param p_mean_pay The mean pay for the job associated with the survey line.
61 * @param p_maximum_pay The maximum pay for the job associated with the survey
62 * line.
63 * @param p_graduate_pay The graduate pay for the job associated with the
64 * survey line.
65 * @param p_starting_pay The starting pay for the job associated with the
66 * survey line.
67 * @param p_percentage_change The percentage by which the pay figures have
68 * changed.
69 * @param p_job_first_quartile The job pay figure for the first quartile.
70 * @param p_job_median_quartile The job pay figure for the median quartile.
71 * @param p_job_third_quartile The job pay figure for the third quartile.
72 * @param p_job_fourth_quartile The job pay figure for the fourth quartile.
73 * @param p_minimum_total_compensation The minimum total compensation.
74 * @param p_mean_total_compensation The mean total compensation.
75 * @param p_maximum_total_compensation The maximum total compensation.
76 * @param p_compnstn_first_quartile {@rep:casecolumn
77 * PER_SALARY_SURVEY_LINES.COMPNSTN_FIRST_QUARTILE}
78 * @param p_compnstn_median_quartile {@rep:casecolumn
79 * PER_SALARY_SURVEY_LINES.COMPNSTN_MEDIAN_QUARTILE}
80 * @param p_compnstn_third_quartile {@rep:casecolumn
81 * PER_SALARY_SURVEY_LINES.COMPNSTN_THIRD_QUARTILE}
82 * @param p_compnstn_fourth_quartile {@rep:casecolumn
83 * PER_SALARY_SURVEY_LINES.COMPNSTN_FOURTH_QUARTILE}
84 * @param p_effective_date Reference date for validating lookup values,
85 * applicable within the active date range. This date does not determine when
86 * the changes take effect.
87 * @param p_attribute_category This context value determines which flexfield
88 * structure to use with the descriptive flexfield segments.
89 * @param p_attribute1 Descriptive flexfield segment.
90 * @param p_attribute2 Descriptive flexfield segment.
91 * @param p_attribute3 Descriptive flexfield segment.
92 * @param p_attribute4 Descriptive flexfield segment.
93 * @param p_attribute5 Descriptive flexfield segment.
94 * @param p_attribute6 Descriptive flexfield segment.
95 * @param p_attribute7 Descriptive flexfield segment.
96 * @param p_attribute8 Descriptive flexfield segment.
97 * @param p_attribute9 Descriptive flexfield segment.
98 * @param p_attribute10 Descriptive flexfield segment.
99 * @param p_attribute11 Descriptive flexfield segment.
100 * @param p_attribute12 Descriptive flexfield segment.
101 * @param p_attribute13 Descriptive flexfield segment.
102 * @param p_attribute14 Descriptive flexfield segment.
103 * @param p_attribute15 Descriptive flexfield segment.
104 * @param p_attribute16 Descriptive flexfield segment.
105 * @param p_attribute17 Descriptive flexfield segment.
106 * @param p_attribute18 Descriptive flexfield segment.
107 * @param p_attribute19 Descriptive flexfield segment.
108 * @param p_attribute20 Descriptive flexfield segment.
109 * @param p_salary_survey_line_id If p_validate is false, uniquely identifies
110 * the survey line created. If p_validate is true, set to null.
111 * @param p_ssl_object_version_number If p_validate is false, set to the object
115 * The existing survey line will be end dated and the new survey line as per
112 * version number of this survey line. If p_validate is true, set to null.
113 * @param p_overlap_warning If this is set to true, then another survey line
114 * exists within this survey with the same details and overlapping date range.
116 * the details provided will be created.
117 * @param p_twenty_fifth_percentile The twenty fifth percentile.
118 * @param p_seventy_fifth_percentile The seventy fifth percentile.
119 * @param p_stock_display_type The code specifying the type that the stock for this
120 * survey line applies to. Valid values are defined by 'STOCK_DISPLAY_TYPE' lookup
121 * type.
122 * @param p_mean_stock The mean stock amount for the job associated with the survey
123 * line. Depending on the p_stock_display_type, the stock value could either be the
124 * number of shares or the money value of the shares.
125 * @param p_minimum_bonus The minimum bonus for the job associated with the survey
126 * line.
127 * @param p_tenth_percentile The tenth percentile.
128 * @param p_min_variable_compensation The minimum variable compensation for the job
129 * associated with the survey line.
130 * @param p_maximum_stock The maximum stock amount for the job associated with the survey
131 * line. Depending on the p_stock_display_type, the stock value could either be the
132 * number of shares or the money value of the shares.
133 * @param p_fiftieth_percentile Fiftieth percentile
134 * @param p_max_variable_compensation The maximum variable compensation for the job
135 * associated with the survey line.
136 * @param p_mean_bonus The mean bonus for the job associated with the survey line.
137 * @param p_maximum_salary_increase The maximum salary increase for the job associated
138 * with the survey line.
139 * @param p_maximum_bonus The maximum bonus for the job associated with the survey line.
140 * @param p_attribute21 Descriptive flexfield segment.
141 * @param p_attribute22 Descriptive flexfield segment.
142 * @param p_attribute23 Descriptive flexfield segment.
143 * @param p_attribute24 Descriptive flexfield segment.
144 * @param p_attribute25 Descriptive flexfield segment.
145 * @param p_attribute26 Descriptive flexfield segment.
146 * @param p_attribute27 Descriptive flexfield segment.
147 * @param p_attribute28 Descriptive flexfield segment.
148 * @param p_minimum_salary_increase The minimum salary increase for the job associated
149 * with the survey line.
150 * @param p_attribute29 Descriptive flexfield segment.
151 * @param p_attribute30 Descriptive flexfield segment.
152 * @param p_mean_salary_increase The mean salary increase for the job associated
153 * with the survey line.
154 * @param p_ninetieth_percentile The ninetieth Percentile.
155 * @param p_mean_variable_compensation The mean variable compensation for the job
156 * associated with the survey line.
157 * @param p_minimum_stock The minimum stock amount for the job associated with the survey
158 * line. Depending on the p_stock_display_type, the stock value could either be the
159 * number of shares or the money value of the shares.
160 * @rep:displayname Create Salary Survey Line
161 * @rep:category BUSINESS_ENTITY PER_SALARY_SURVEY
162 * @rep:scope public
163 * @rep:lifecycle active
164 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
165 */
166 --
167 -- {End Of Comments}
168 --
169 procedure create_salary_survey_line
170 (p_validate in boolean default false
171 ,p_salary_survey_id in number
172 ,p_survey_job_name_code in varchar2
173 ,p_start_date in date
174 ,p_currency_code in varchar2
175 ,p_survey_region_code in varchar2 default null
176 ,p_survey_seniority_code in varchar2 default null
177 ,p_company_size_code in varchar2 default null
178 ,p_industry_code in varchar2 default null
179 ,p_survey_age_code in varchar2 default null
180 ,p_end_date in date default null
181 ,p_differential in number default null
182 ,p_minimum_pay in number default null
183 ,p_mean_pay in number default null
184 ,p_maximum_pay in number default null
185 ,p_graduate_pay in number default null
186 ,p_starting_pay in number default null
187 ,p_percentage_change in number default null
188 ,p_job_first_quartile in number default null
189 ,p_job_median_quartile in number default null
190 ,p_job_third_quartile in number default null
191 ,p_job_fourth_quartile in number default null
192 ,p_minimum_total_compensation in number default null
193 ,p_mean_total_compensation in number default null
194 ,p_maximum_total_compensation in number default null
195 ,p_compnstn_first_quartile in number default null
196 ,p_compnstn_median_quartile in number default null
197 ,p_compnstn_third_quartile in number default null
198 ,p_compnstn_fourth_quartile in number default null
199 /* Added for Enhancement 4021737 */
200 ,p_tenth_percentile in number default null
201 ,p_twenty_fifth_percentile in number default null
202 ,p_fiftieth_percentile in number default null
203 ,p_seventy_fifth_percentile in number default null
204 ,p_ninetieth_percentile in number default null
205 ,p_minimum_bonus in number default null
206 ,p_mean_bonus in number default null
207 ,p_maximum_bonus in number default null
208 ,p_minimum_salary_increase in number default null
212 ,p_mean_variable_compensation in number default null
209 ,p_mean_salary_increase in number default null
210 ,p_maximum_salary_increase in number default null
211 ,p_min_variable_compensation in number default null
213 ,p_max_variable_compensation in number default null
214 ,p_minimum_stock in number default null
215 ,p_mean_stock in number default null
216 ,p_maximum_stock in number default null
217 ,p_stock_display_type in varchar2 default null
218 /*End Enhancement 4021737 */
219 ,p_effective_date in date default null
220 ,p_attribute_category in varchar2 default null
221 ,p_attribute1 in varchar2 default null
222 ,p_attribute2 in varchar2 default null
223 ,p_attribute3 in varchar2 default null
224 ,p_attribute4 in varchar2 default null
225 ,p_attribute5 in varchar2 default null
226 ,p_attribute6 in varchar2 default null
227 ,p_attribute7 in varchar2 default null
228 ,p_attribute8 in varchar2 default null
229 ,p_attribute9 in varchar2 default null
230 ,p_attribute10 in varchar2 default null
231 ,p_attribute11 in varchar2 default null
232 ,p_attribute12 in varchar2 default null
233 ,p_attribute13 in varchar2 default null
234 ,p_attribute14 in varchar2 default null
235 ,p_attribute15 in varchar2 default null
236 ,p_attribute16 in varchar2 default null
237 ,p_attribute17 in varchar2 default null
238 ,p_attribute18 in varchar2 default null
239 ,p_attribute19 in varchar2 default null
240 ,p_attribute20 in varchar2 default null
241 /*Added for Enhancement 4021737 */
242 ,p_attribute21 in varchar2 default null
243 ,p_attribute22 in varchar2 default null
244 ,p_attribute23 in varchar2 default null
245 ,p_attribute24 in varchar2 default null
246 ,p_attribute25 in varchar2 default null
247 ,p_attribute26 in varchar2 default null
248 ,p_attribute27 in varchar2 default null
249 ,p_attribute28 in varchar2 default null
250 ,p_attribute29 in varchar2 default null
251 ,p_attribute30 in varchar2 default null
252 /*End Enhancement 4021737 */
253 ,p_salary_survey_line_id out nocopy number
254 ,p_ssl_object_version_number out nocopy number
255 ,p_overlap_warning out nocopy boolean
256 );
257 --
258 -- ----------------------------------------------------------------------------
259 -- |------------------------< update_salary_survey_line >---------------------|
260 -- ----------------------------------------------------------------------------
261 --
262 -- {Start Of Comments}
263 /*#
264 * This API updates the Salary Survey line.
265 *
266 * This API allows you to update the details of a survey line. A Salary Survey
267 * line records comparative salary figures from the industry. You record a
268 * survey line for a salary survey header.
269 *
270 * <p><b>Licensing</b><br>
271 * This API is licensed for use with Human Resources.
272 *
273 * <p><b>Prerequisites</b><br>
274 * The salary_survey_line_id and object_version_number must all be valid and
275 * exist in the database.
276 *
277 * <p><b>Post Success</b><br>
278 * The salary survey line is updated successfully.
279 *
280 * <p><b>Post Failure</b><br>
281 * The Salary Survey Line will not be updated and an error is raised.
282 * @param p_validate If true, then validation alone will be performed and the
283 * database will remain unchanged. If false and all validation checks pass,
284 * then the database will be modified.
285 * @param p_survey_job_name_code The code specifying the job type that this
286 * survey line applies to. Valid values are defined by 'SURVEY_JOB_NAME' lookup
287 * type.
288 * @param p_start_date {@rep:casecolumn PER_SALARY_SURVEY_LINES.START_DATE}
289 * @param p_currency_code The code specifying the currency for the survey.
290 * Serves as a foreign key to FND_CURRENCIES
291 * @param p_survey_region_code The code specifying the Region that this survey
292 * line applies to. Valid values are defined by 'SURVEY_REGION' lookup type.
293 * @param p_survey_seniority_code The code specifying the Seniority that this
294 * survey line applies to. Valid values are defined by 'SURVEY_SENIORITY'
295 * lookup type.
296 * @param p_company_size_code The code specifying the size of the company that
297 * the survey line applies to. Valid values are defined by 'COMPANY_SIZE'
298 * lookup type.
299 * @param p_industry_code The code specifying the industry associated with the
300 * survey line. Valid values are defined by 'INDUSTRY' lookup type.
301 * @param p_survey_age_code The code specifying the Survey Age for the survey
302 * line. Valid values are defined by 'SURVEY_AGE' lookup type.
303 * @param p_end_date {@rep:casecolumn PER_SALARY_SURVEY_LINES.END_DATE}
304 * @param p_differential {@rep:casecolumn PER_SALARY_SURVEY_LINES.DIFFERENTIAL}
305 * @param p_minimum_pay The minimum pay for the job associated with survey
306 * line.
310 * @param p_graduate_pay The graduate pay for the job associated with survey
307 * @param p_mean_pay The mean pay for the job associated with survey line.
308 * @param p_maximum_pay The maximum pay for the job associated with survey
309 * line.
311 * line.
312 * @param p_starting_pay The starting pay for the job associated with survey
313 * line.
314 * @param p_percentage_change The percentage by which the pay figures have
315 * changed.
316 * @param p_job_first_quartile The job pay figure for the first quartile.
317 * @param p_job_median_quartile The job pay figure for the median quartile.
318 * @param p_job_third_quartile The job pay figure for the third quartile.
319 * @param p_job_fourth_quartile The job pay figure for the fourth quartile.
320 * @param p_minimum_total_compensation The minimum total compensation.
321 * @param p_mean_total_compensation The mean total compensation.
322 * @param p_maximum_total_compensation The maximum total compensation.
323 * @param p_compnstn_first_quartile {@rep:casecolumn
324 * PER_SALARY_SURVEY_LINES.COMPNSTN_FIRST_QUARTILE}
325 * @param p_compnstn_median_quartile {@rep:casecolumn
326 * PER_SALARY_SURVEY_LINES.COMPNSTN_MEDIAN_QUARTILE}
327 * @param p_compnstn_third_quartile {@rep:casecolumn
328 * PER_SALARY_SURVEY_LINES.COMPNSTN_THIRD_QUARTILE}
329 * @param p_compnstn_fourth_quartile {@rep:casecolumn
330 * PER_SALARY_SURVEY_LINES.COMPNSTN_FOURTH_QUARTILE}
331 * @param p_effective_date Reference date for validating lookup values,
332 * applicable within the active date range. This date does not determine when
333 * the changes take effect.
334 * @param p_attribute_category This context value determines which flexfield
335 * structure to use with the descriptive flexfield segments.
336 * @param p_attribute1 Descriptive flexfield segment.
337 * @param p_attribute2 Descriptive flexfield segment.
338 * @param p_attribute3 Descriptive flexfield segment.
339 * @param p_attribute4 Descriptive flexfield segment.
340 * @param p_attribute5 Descriptive flexfield segment.
341 * @param p_attribute6 Descriptive flexfield segment.
342 * @param p_attribute7 Descriptive flexfield segment.
343 * @param p_attribute8 Descriptive flexfield segment.
344 * @param p_attribute9 Descriptive flexfield segment.
345 * @param p_attribute10 Descriptive flexfield segment.
346 * @param p_attribute11 Descriptive flexfield segment.
347 * @param p_attribute12 Descriptive flexfield segment.
348 * @param p_attribute13 Descriptive flexfield segment.
349 * @param p_attribute14 Descriptive flexfield segment.
350 * @param p_attribute15 Descriptive flexfield segment.
351 * @param p_attribute16 Descriptive flexfield segment.
352 * @param p_attribute17 Descriptive flexfield segment.
353 * @param p_attribute18 Descriptive flexfield segment.
354 * @param p_attribute19 Descriptive flexfield segment.
355 * @param p_attribute20 Descriptive flexfield segment.
356 * @param p_salary_survey_line_id Uniquely identifies the survey line to be
357 * updated.
358 * @param p_ssl_object_version_number If p_validate is false, set to the object
359 * version number of this survey line. If p_validate is true, set to null.
360 * @param p_attribute21 Descriptive flexfield segment.
361 * @param p_attribute22 Descriptive flexfield segment.
362 * @param p_attribute23 Descriptive flexfield segment.
363 * @param p_attribute24 Descriptive flexfield segment.
364 * @param p_attribute25 Descriptive flexfield segment.
365 * @param p_attribute26 Descriptive flexfield segment.
366 * @param p_attribute27 Descriptive flexfield segment.
367 * @param p_attribute28 Descriptive flexfield segment.
368 * @param p_attribute29 Descriptive flexfield segment.
369 * @param p_attribute30 Descriptive flexfield segment.
370 * @param p_tenth_percentile The tenth percentile.
371 * @param p_minimum_bonus The minimum bonus for the job associated with the survey
372 * line.
373 * @param p_mean_variable_compensation The mean variable compensation for the job
374 * associated with the survey line.
375 * @param p_maximum_stock The maximum stock amount for the job associated with the survey
376 * line. Depending on the p_stock_display_type, the stock value could either be the
377 * number of shares or the money value of the shares.
378 * @param p_twenty_fifth_percentile The twenty fifth percentile.
379 * @param p_mean_salary_increase The mean salary increase for the job associated
380 * with the survey line.
381 * @param p_ninetieth_percentile The ninetieth percentile.
382 * @param p_seventy_fifth_percentile The seventy fifth percentile.
383 * @param p_maximum_bonus The maximum bonus for the job associated with the survey
384 * line.
385 * @param p_mean_stock The mean stock amount for the job associated with the survey
386 * line. Depending on the p_stock_display_type, the stock value could either be the
387 * number of shares or the money value of the shares.
388 * @param p_min_variable_compensation The minimum variable compensation for the job
389 * associated with the survey line.
390 * @param p_fiftieth_percentile The fiftieth percentile.
391 * @param p_minimum_stock The minimum stock amount for the job associated with the survey
392 * line. Depending on the p_stock_display_type, the stock value could either be the
393 * number of shares or the money value of the shares.
394 * @param p_maximum_salary_increase The maximum salary increase for the job associated
395 * with the survey line.
396 * @param p_max_variable_compensation The maximum variable compensation for the job
397 * associated with the survey line.
398 * @param p_mean_bonus The mean bonus for the job associated with the survey line.
399 * @param p_minimum_salary_increase The minimum salary increase for the job associated
400 * with the survey line.
401 * @param p_stock_display_type The code specifying the type that the stock for this
402 * survey line applies to. Valid values are defined by 'STOCK_DISPLAY_TYPE' lookup
403 * type.
404 * @rep:displayname Update Salary Survey Line
405 * @rep:category BUSINESS_ENTITY PER_SALARY_SURVEY
409 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
406 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
407 * @rep:scope public
408 * @rep:lifecycle active
410 */
411 --
412 -- {End Of Comments}
413 --
414 procedure update_salary_survey_line
415 (p_validate in boolean default false
416 ,p_survey_job_name_code in varchar2
417 ,p_start_date in date
418 ,p_currency_code in varchar2 default hr_api.g_varchar2
419 ,p_survey_region_code in varchar2 default hr_api.g_varchar2
420 ,p_survey_seniority_code in varchar2 default hr_api.g_varchar2
421 ,p_company_size_code in varchar2 default hr_api.g_varchar2
422 ,p_industry_code in varchar2 default hr_api.g_varchar2
423 ,p_survey_age_code in varchar2 default hr_api.g_varchar2
424 ,p_end_date in date default hr_api.g_date
425 ,p_differential in number default hr_api.g_number
426 ,p_minimum_pay in number default hr_api.g_number
427 ,p_mean_pay in number default hr_api.g_number
428 ,p_maximum_pay in number default hr_api.g_number
429 ,p_graduate_pay in number default hr_api.g_number
430 ,p_starting_pay in number default hr_api.g_number
431 ,p_percentage_change in number default hr_api.g_number
432 ,p_job_first_quartile in number default hr_api.g_number
433 ,p_job_median_quartile in number default hr_api.g_number
434 ,p_job_third_quartile in number default hr_api.g_number
435 ,p_job_fourth_quartile in number default hr_api.g_number
436 ,p_minimum_total_compensation in number default hr_api.g_number
437 ,p_mean_total_compensation in number default hr_api.g_number
438 ,p_maximum_total_compensation in number default hr_api.g_number
439 ,p_compnstn_first_quartile in number default hr_api.g_number
440 ,p_compnstn_median_quartile in number default hr_api.g_number
441 ,p_compnstn_third_quartile in number default hr_api.g_number
442 ,p_compnstn_fourth_quartile in number default hr_api.g_number
443 /*Added for Enhancement 4021737 */
444 ,p_tenth_percentile in number default hr_api.g_number
445 ,p_twenty_fifth_percentile in number default hr_api.g_number
446 ,p_fiftieth_percentile in number default hr_api.g_number
447 ,p_seventy_fifth_percentile in number default hr_api.g_number
448 ,p_ninetieth_percentile in number default hr_api.g_number
449 ,p_minimum_bonus in number default hr_api.g_number
450 ,p_mean_bonus in number default hr_api.g_number
451 ,p_maximum_bonus in number default hr_api.g_number
452 ,p_minimum_salary_increase in number default hr_api.g_number
453 ,p_mean_salary_increase in number default hr_api.g_number
454 ,p_maximum_salary_increase in number default hr_api.g_number
455 ,p_min_variable_compensation in number default hr_api.g_number
456 ,p_mean_variable_compensation in number default hr_api.g_number
457 ,p_max_variable_compensation in number default hr_api.g_number
458 ,p_minimum_stock in number default hr_api.g_number
459 ,p_mean_stock in number default hr_api.g_number
460 ,p_maximum_stock in number default hr_api.g_number
461 ,p_stock_display_type in varchar2 default hr_api.g_varchar2
462 /*End Enhancement 4021737 */
463 ,p_effective_date in date default hr_api.g_date
464 ,p_attribute_category in varchar2 default hr_api.g_varchar2
465 ,p_attribute1 in varchar2 default hr_api.g_varchar2
466 ,p_attribute2 in varchar2 default hr_api.g_varchar2
467 ,p_attribute3 in varchar2 default hr_api.g_varchar2
468 ,p_attribute4 in varchar2 default hr_api.g_varchar2
469 ,p_attribute5 in varchar2 default hr_api.g_varchar2
470 ,p_attribute6 in varchar2 default hr_api.g_varchar2
471 ,p_attribute7 in varchar2 default hr_api.g_varchar2
472 ,p_attribute8 in varchar2 default hr_api.g_varchar2
473 ,p_attribute9 in varchar2 default hr_api.g_varchar2
474 ,p_attribute10 in varchar2 default hr_api.g_varchar2
475 ,p_attribute11 in varchar2 default hr_api.g_varchar2
476 ,p_attribute12 in varchar2 default hr_api.g_varchar2
477 ,p_attribute13 in varchar2 default hr_api.g_varchar2
478 ,p_attribute14 in varchar2 default hr_api.g_varchar2
479 ,p_attribute15 in varchar2 default hr_api.g_varchar2
480 ,p_attribute16 in varchar2 default hr_api.g_varchar2
481 ,p_attribute17 in varchar2 default hr_api.g_varchar2
482 ,p_attribute18 in varchar2 default hr_api.g_varchar2
483 ,p_attribute19 in varchar2 default hr_api.g_varchar2
484 ,p_attribute20 in varchar2 default hr_api.g_varchar2
485 /*Added for Enhancement 4021737 */
486 ,p_attribute21 in varchar2 default hr_api.g_varchar2
487 ,p_attribute22 in varchar2 default hr_api.g_varchar2
488 ,p_attribute23 in varchar2 default hr_api.g_varchar2
489 ,p_attribute24 in varchar2 default hr_api.g_varchar2
490 ,p_attribute25 in varchar2 default hr_api.g_varchar2
491 ,p_attribute26 in varchar2 default hr_api.g_varchar2
492 ,p_attribute27 in varchar2 default hr_api.g_varchar2
493 ,p_attribute28 in varchar2 default hr_api.g_varchar2
494 ,p_attribute29 in varchar2 default hr_api.g_varchar2
495 ,p_attribute30 in varchar2 default hr_api.g_varchar2
496 /*End Enhancement 4021737 */
497 ,p_salary_survey_line_id in number
498 ,p_ssl_object_version_number in out nocopy number);
499 --
500 -- ----------------------------------------------------------------------------
501 -- |------------------------< delete_salary_survey_line >---------------------|
502 -- ----------------------------------------------------------------------------
503 --
504 -- {Start Of Comments}
505 /*#
506 * This API deletes a salary survey line.
507 *
508 * You can delete a Salary Survey line only when no mappings exist for the
509 * salary survey line.
510 *
511 * <p><b>Licensing</b><br>
512 * This API is licensed for use with Human Resources.
513 *
514 * <p><b>Prerequisites</b><br>
515 * The salary_survey_line_id and object_version_number must both be valid and
516 * exist in the database.
517 *
518 * <p><b>Post Success</b><br>
519 * The survey line is deleted.
520 *
521 * <p><b>Post Failure</b><br>
522 * The Salary Survey Line will not be deleted and an error is raised.
523 * @param p_validate If true, then validation alone will be performed and the
524 * database will remain unchanged. If false and all validation checks pass,
525 * then the database will be modified.
526 * @param p_salary_survey_line_id Uniquely identifies the survey line to be
527 * deleted.
528 * @param p_ssl_object_version_number The version number of the survey line to
529 * be deleted.
530 * @rep:displayname Delete Salary Survey Line
531 * @rep:category BUSINESS_ENTITY PER_SALARY_SURVEY
532 * @rep:scope public
533 * @rep:lifecycle active
534 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
535 */
536 --
537 -- {End Of Comments}
538 --
539 procedure delete_salary_survey_line
540 (p_validate in boolean default false
541 ,p_salary_survey_line_id in number
542 ,p_ssl_object_version_number in number
543 );
544 --
545 end hr_salary_survey_line_api ;
[Home] [Help]