91: ,p_attribute19 => p_attribute19
92: ,p_attribute20 => p_attribute20
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'create_salary_survey'
98: ,p_hook_type => 'BP'
99: );
92: ,p_attribute20 => p_attribute20
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'create_salary_survey'
98: ,p_hook_type => 'BP'
99: );
100: end;
170: ,p_salary_survey_id => l_salary_survey_id
171: ,p_object_version_number => l_object_version_number
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'create_salary_survey'
177: ,p_hook_type => 'AP'
178: );
171: ,p_object_version_number => l_object_version_number
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'create_salary_survey'
177: ,p_hook_type => 'AP'
178: );
179: end;
182: -- When in validation only mode raise the Validate_Enabled exception
183: --
184: if p_validate then
185: --
186: raise hr_api.validate_enabled;
187: --
188: end if;
189: --
190: -- Set all output arguments
194: --
195: hr_utility.set_location(' Leaving:'||l_proc, 70);
196: --
197: exception
198: when hr_api.validate_enabled then
199: --
200: -- As the Validate_Enabled exception has been raised
201: -- we must rollback to the savepoint
202: --
231: -- ----------------------------------------------------------------------------
232: --
233: procedure update_salary_survey
234: (p_validate in boolean default false
235: ,p_survey_name in varchar2 default hr_api.g_varchar2
236: --ras ,p_currency_code in varchar2 default hr_api.g_varchar2
237: ,p_survey_type_code in varchar2 default hr_api.g_varchar2
238: ,p_base_region in varchar2 default hr_api.g_varchar2
239: ,p_effective_date in date default hr_api.g_date
232: --
233: procedure update_salary_survey
234: (p_validate in boolean default false
235: ,p_survey_name in varchar2 default hr_api.g_varchar2
236: --ras ,p_currency_code in varchar2 default hr_api.g_varchar2
237: ,p_survey_type_code in varchar2 default hr_api.g_varchar2
238: ,p_base_region in varchar2 default hr_api.g_varchar2
239: ,p_effective_date in date default hr_api.g_date
240: ,p_attribute_category in varchar2 default hr_api.g_varchar2
233: procedure update_salary_survey
234: (p_validate in boolean default false
235: ,p_survey_name in varchar2 default hr_api.g_varchar2
236: --ras ,p_currency_code in varchar2 default hr_api.g_varchar2
237: ,p_survey_type_code in varchar2 default hr_api.g_varchar2
238: ,p_base_region in varchar2 default hr_api.g_varchar2
239: ,p_effective_date in date default hr_api.g_date
240: ,p_attribute_category in varchar2 default hr_api.g_varchar2
241: ,p_attribute1 in varchar2 default hr_api.g_varchar2
234: (p_validate in boolean default false
235: ,p_survey_name in varchar2 default hr_api.g_varchar2
236: --ras ,p_currency_code in varchar2 default hr_api.g_varchar2
237: ,p_survey_type_code in varchar2 default hr_api.g_varchar2
238: ,p_base_region in varchar2 default hr_api.g_varchar2
239: ,p_effective_date in date default hr_api.g_date
240: ,p_attribute_category in varchar2 default hr_api.g_varchar2
241: ,p_attribute1 in varchar2 default hr_api.g_varchar2
242: ,p_attribute2 in varchar2 default hr_api.g_varchar2
235: ,p_survey_name in varchar2 default hr_api.g_varchar2
236: --ras ,p_currency_code in varchar2 default hr_api.g_varchar2
237: ,p_survey_type_code in varchar2 default hr_api.g_varchar2
238: ,p_base_region in varchar2 default hr_api.g_varchar2
239: ,p_effective_date in date default hr_api.g_date
240: ,p_attribute_category in varchar2 default hr_api.g_varchar2
241: ,p_attribute1 in varchar2 default hr_api.g_varchar2
242: ,p_attribute2 in varchar2 default hr_api.g_varchar2
243: ,p_attribute3 in varchar2 default hr_api.g_varchar2
236: --ras ,p_currency_code in varchar2 default hr_api.g_varchar2
237: ,p_survey_type_code in varchar2 default hr_api.g_varchar2
238: ,p_base_region in varchar2 default hr_api.g_varchar2
239: ,p_effective_date in date default hr_api.g_date
240: ,p_attribute_category in varchar2 default hr_api.g_varchar2
241: ,p_attribute1 in varchar2 default hr_api.g_varchar2
242: ,p_attribute2 in varchar2 default hr_api.g_varchar2
243: ,p_attribute3 in varchar2 default hr_api.g_varchar2
244: ,p_attribute4 in varchar2 default hr_api.g_varchar2
237: ,p_survey_type_code in varchar2 default hr_api.g_varchar2
238: ,p_base_region in varchar2 default hr_api.g_varchar2
239: ,p_effective_date in date default hr_api.g_date
240: ,p_attribute_category in varchar2 default hr_api.g_varchar2
241: ,p_attribute1 in varchar2 default hr_api.g_varchar2
242: ,p_attribute2 in varchar2 default hr_api.g_varchar2
243: ,p_attribute3 in varchar2 default hr_api.g_varchar2
244: ,p_attribute4 in varchar2 default hr_api.g_varchar2
245: ,p_attribute5 in varchar2 default hr_api.g_varchar2
238: ,p_base_region in varchar2 default hr_api.g_varchar2
239: ,p_effective_date in date default hr_api.g_date
240: ,p_attribute_category in varchar2 default hr_api.g_varchar2
241: ,p_attribute1 in varchar2 default hr_api.g_varchar2
242: ,p_attribute2 in varchar2 default hr_api.g_varchar2
243: ,p_attribute3 in varchar2 default hr_api.g_varchar2
244: ,p_attribute4 in varchar2 default hr_api.g_varchar2
245: ,p_attribute5 in varchar2 default hr_api.g_varchar2
246: ,p_attribute6 in varchar2 default hr_api.g_varchar2
239: ,p_effective_date in date default hr_api.g_date
240: ,p_attribute_category in varchar2 default hr_api.g_varchar2
241: ,p_attribute1 in varchar2 default hr_api.g_varchar2
242: ,p_attribute2 in varchar2 default hr_api.g_varchar2
243: ,p_attribute3 in varchar2 default hr_api.g_varchar2
244: ,p_attribute4 in varchar2 default hr_api.g_varchar2
245: ,p_attribute5 in varchar2 default hr_api.g_varchar2
246: ,p_attribute6 in varchar2 default hr_api.g_varchar2
247: ,p_attribute7 in varchar2 default hr_api.g_varchar2
240: ,p_attribute_category in varchar2 default hr_api.g_varchar2
241: ,p_attribute1 in varchar2 default hr_api.g_varchar2
242: ,p_attribute2 in varchar2 default hr_api.g_varchar2
243: ,p_attribute3 in varchar2 default hr_api.g_varchar2
244: ,p_attribute4 in varchar2 default hr_api.g_varchar2
245: ,p_attribute5 in varchar2 default hr_api.g_varchar2
246: ,p_attribute6 in varchar2 default hr_api.g_varchar2
247: ,p_attribute7 in varchar2 default hr_api.g_varchar2
248: ,p_attribute8 in varchar2 default hr_api.g_varchar2
241: ,p_attribute1 in varchar2 default hr_api.g_varchar2
242: ,p_attribute2 in varchar2 default hr_api.g_varchar2
243: ,p_attribute3 in varchar2 default hr_api.g_varchar2
244: ,p_attribute4 in varchar2 default hr_api.g_varchar2
245: ,p_attribute5 in varchar2 default hr_api.g_varchar2
246: ,p_attribute6 in varchar2 default hr_api.g_varchar2
247: ,p_attribute7 in varchar2 default hr_api.g_varchar2
248: ,p_attribute8 in varchar2 default hr_api.g_varchar2
249: ,p_attribute9 in varchar2 default hr_api.g_varchar2
242: ,p_attribute2 in varchar2 default hr_api.g_varchar2
243: ,p_attribute3 in varchar2 default hr_api.g_varchar2
244: ,p_attribute4 in varchar2 default hr_api.g_varchar2
245: ,p_attribute5 in varchar2 default hr_api.g_varchar2
246: ,p_attribute6 in varchar2 default hr_api.g_varchar2
247: ,p_attribute7 in varchar2 default hr_api.g_varchar2
248: ,p_attribute8 in varchar2 default hr_api.g_varchar2
249: ,p_attribute9 in varchar2 default hr_api.g_varchar2
250: ,p_attribute10 in varchar2 default hr_api.g_varchar2
243: ,p_attribute3 in varchar2 default hr_api.g_varchar2
244: ,p_attribute4 in varchar2 default hr_api.g_varchar2
245: ,p_attribute5 in varchar2 default hr_api.g_varchar2
246: ,p_attribute6 in varchar2 default hr_api.g_varchar2
247: ,p_attribute7 in varchar2 default hr_api.g_varchar2
248: ,p_attribute8 in varchar2 default hr_api.g_varchar2
249: ,p_attribute9 in varchar2 default hr_api.g_varchar2
250: ,p_attribute10 in varchar2 default hr_api.g_varchar2
251: ,p_attribute11 in varchar2 default hr_api.g_varchar2
244: ,p_attribute4 in varchar2 default hr_api.g_varchar2
245: ,p_attribute5 in varchar2 default hr_api.g_varchar2
246: ,p_attribute6 in varchar2 default hr_api.g_varchar2
247: ,p_attribute7 in varchar2 default hr_api.g_varchar2
248: ,p_attribute8 in varchar2 default hr_api.g_varchar2
249: ,p_attribute9 in varchar2 default hr_api.g_varchar2
250: ,p_attribute10 in varchar2 default hr_api.g_varchar2
251: ,p_attribute11 in varchar2 default hr_api.g_varchar2
252: ,p_attribute12 in varchar2 default hr_api.g_varchar2
245: ,p_attribute5 in varchar2 default hr_api.g_varchar2
246: ,p_attribute6 in varchar2 default hr_api.g_varchar2
247: ,p_attribute7 in varchar2 default hr_api.g_varchar2
248: ,p_attribute8 in varchar2 default hr_api.g_varchar2
249: ,p_attribute9 in varchar2 default hr_api.g_varchar2
250: ,p_attribute10 in varchar2 default hr_api.g_varchar2
251: ,p_attribute11 in varchar2 default hr_api.g_varchar2
252: ,p_attribute12 in varchar2 default hr_api.g_varchar2
253: ,p_attribute13 in varchar2 default hr_api.g_varchar2
246: ,p_attribute6 in varchar2 default hr_api.g_varchar2
247: ,p_attribute7 in varchar2 default hr_api.g_varchar2
248: ,p_attribute8 in varchar2 default hr_api.g_varchar2
249: ,p_attribute9 in varchar2 default hr_api.g_varchar2
250: ,p_attribute10 in varchar2 default hr_api.g_varchar2
251: ,p_attribute11 in varchar2 default hr_api.g_varchar2
252: ,p_attribute12 in varchar2 default hr_api.g_varchar2
253: ,p_attribute13 in varchar2 default hr_api.g_varchar2
254: ,p_attribute14 in varchar2 default hr_api.g_varchar2
247: ,p_attribute7 in varchar2 default hr_api.g_varchar2
248: ,p_attribute8 in varchar2 default hr_api.g_varchar2
249: ,p_attribute9 in varchar2 default hr_api.g_varchar2
250: ,p_attribute10 in varchar2 default hr_api.g_varchar2
251: ,p_attribute11 in varchar2 default hr_api.g_varchar2
252: ,p_attribute12 in varchar2 default hr_api.g_varchar2
253: ,p_attribute13 in varchar2 default hr_api.g_varchar2
254: ,p_attribute14 in varchar2 default hr_api.g_varchar2
255: ,p_attribute15 in varchar2 default hr_api.g_varchar2
248: ,p_attribute8 in varchar2 default hr_api.g_varchar2
249: ,p_attribute9 in varchar2 default hr_api.g_varchar2
250: ,p_attribute10 in varchar2 default hr_api.g_varchar2
251: ,p_attribute11 in varchar2 default hr_api.g_varchar2
252: ,p_attribute12 in varchar2 default hr_api.g_varchar2
253: ,p_attribute13 in varchar2 default hr_api.g_varchar2
254: ,p_attribute14 in varchar2 default hr_api.g_varchar2
255: ,p_attribute15 in varchar2 default hr_api.g_varchar2
256: ,p_attribute16 in varchar2 default hr_api.g_varchar2
249: ,p_attribute9 in varchar2 default hr_api.g_varchar2
250: ,p_attribute10 in varchar2 default hr_api.g_varchar2
251: ,p_attribute11 in varchar2 default hr_api.g_varchar2
252: ,p_attribute12 in varchar2 default hr_api.g_varchar2
253: ,p_attribute13 in varchar2 default hr_api.g_varchar2
254: ,p_attribute14 in varchar2 default hr_api.g_varchar2
255: ,p_attribute15 in varchar2 default hr_api.g_varchar2
256: ,p_attribute16 in varchar2 default hr_api.g_varchar2
257: ,p_attribute17 in varchar2 default hr_api.g_varchar2
250: ,p_attribute10 in varchar2 default hr_api.g_varchar2
251: ,p_attribute11 in varchar2 default hr_api.g_varchar2
252: ,p_attribute12 in varchar2 default hr_api.g_varchar2
253: ,p_attribute13 in varchar2 default hr_api.g_varchar2
254: ,p_attribute14 in varchar2 default hr_api.g_varchar2
255: ,p_attribute15 in varchar2 default hr_api.g_varchar2
256: ,p_attribute16 in varchar2 default hr_api.g_varchar2
257: ,p_attribute17 in varchar2 default hr_api.g_varchar2
258: ,p_attribute18 in varchar2 default hr_api.g_varchar2
251: ,p_attribute11 in varchar2 default hr_api.g_varchar2
252: ,p_attribute12 in varchar2 default hr_api.g_varchar2
253: ,p_attribute13 in varchar2 default hr_api.g_varchar2
254: ,p_attribute14 in varchar2 default hr_api.g_varchar2
255: ,p_attribute15 in varchar2 default hr_api.g_varchar2
256: ,p_attribute16 in varchar2 default hr_api.g_varchar2
257: ,p_attribute17 in varchar2 default hr_api.g_varchar2
258: ,p_attribute18 in varchar2 default hr_api.g_varchar2
259: ,p_attribute19 in varchar2 default hr_api.g_varchar2
252: ,p_attribute12 in varchar2 default hr_api.g_varchar2
253: ,p_attribute13 in varchar2 default hr_api.g_varchar2
254: ,p_attribute14 in varchar2 default hr_api.g_varchar2
255: ,p_attribute15 in varchar2 default hr_api.g_varchar2
256: ,p_attribute16 in varchar2 default hr_api.g_varchar2
257: ,p_attribute17 in varchar2 default hr_api.g_varchar2
258: ,p_attribute18 in varchar2 default hr_api.g_varchar2
259: ,p_attribute19 in varchar2 default hr_api.g_varchar2
260: ,p_attribute20 in varchar2 default hr_api.g_varchar2
253: ,p_attribute13 in varchar2 default hr_api.g_varchar2
254: ,p_attribute14 in varchar2 default hr_api.g_varchar2
255: ,p_attribute15 in varchar2 default hr_api.g_varchar2
256: ,p_attribute16 in varchar2 default hr_api.g_varchar2
257: ,p_attribute17 in varchar2 default hr_api.g_varchar2
258: ,p_attribute18 in varchar2 default hr_api.g_varchar2
259: ,p_attribute19 in varchar2 default hr_api.g_varchar2
260: ,p_attribute20 in varchar2 default hr_api.g_varchar2
261: ,p_salary_survey_id in number
254: ,p_attribute14 in varchar2 default hr_api.g_varchar2
255: ,p_attribute15 in varchar2 default hr_api.g_varchar2
256: ,p_attribute16 in varchar2 default hr_api.g_varchar2
257: ,p_attribute17 in varchar2 default hr_api.g_varchar2
258: ,p_attribute18 in varchar2 default hr_api.g_varchar2
259: ,p_attribute19 in varchar2 default hr_api.g_varchar2
260: ,p_attribute20 in varchar2 default hr_api.g_varchar2
261: ,p_salary_survey_id in number
262: ,p_object_version_number in out nocopy number
255: ,p_attribute15 in varchar2 default hr_api.g_varchar2
256: ,p_attribute16 in varchar2 default hr_api.g_varchar2
257: ,p_attribute17 in varchar2 default hr_api.g_varchar2
258: ,p_attribute18 in varchar2 default hr_api.g_varchar2
259: ,p_attribute19 in varchar2 default hr_api.g_varchar2
260: ,p_attribute20 in varchar2 default hr_api.g_varchar2
261: ,p_salary_survey_id in number
262: ,p_object_version_number in out nocopy number
263: ) is
256: ,p_attribute16 in varchar2 default hr_api.g_varchar2
257: ,p_attribute17 in varchar2 default hr_api.g_varchar2
258: ,p_attribute18 in varchar2 default hr_api.g_varchar2
259: ,p_attribute19 in varchar2 default hr_api.g_varchar2
260: ,p_attribute20 in varchar2 default hr_api.g_varchar2
261: ,p_salary_survey_id in number
262: ,p_object_version_number in out nocopy number
263: ) is
264: --
314: p_object_version_number => l_object_version_number
315: );
316:
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'update_salary_survey'
321: ,p_hook_type => 'BP'
322: );
315: );
316:
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'update_salary_survey'
321: ,p_hook_type => 'BP'
322: );
323: end;
389: p_attribute19 => p_attribute19,
390: p_attribute20 => p_attribute20
391: );
392: exception
393: when hr_api.cannot_find_prog_unit then
394: hr_api.cannot_find_prog_unit_error
395: (p_module_name => 'update_salary_survey'
396: ,p_hook_type => 'AP'
397: );
390: p_attribute20 => p_attribute20
391: );
392: exception
393: when hr_api.cannot_find_prog_unit then
394: hr_api.cannot_find_prog_unit_error
395: (p_module_name => 'update_salary_survey'
396: ,p_hook_type => 'AP'
397: );
398: end;
401: -- When in validation only mode raise the Validate_Enabled exception
402: --
403: if p_validate then
404: --
405: raise hr_api.validate_enabled;
406: --
407: end if;
408: --
409: -- Set all output arguments
412: --
413: hr_utility.set_location(' Leaving:'||l_proc, 70);
414: --
415: exception
416: when hr_api.validate_enabled then
417: --
418: -- As the Validate_Enabled exception has been raised
419: -- we must rollback to the savepoint
420: --
482: (p_salary_survey_id => l_salary_survey_id
483: ,p_object_version_number => l_object_version_number
484: );
485: exception
486: when hr_api.cannot_find_prog_unit then
487: hr_api.cannot_find_prog_unit_error
488: (p_module_name => 'delete_salary_survey'
489: ,p_hook_type => 'BP'
490: );
483: ,p_object_version_number => l_object_version_number
484: );
485: exception
486: when hr_api.cannot_find_prog_unit then
487: hr_api.cannot_find_prog_unit_error
488: (p_module_name => 'delete_salary_survey'
489: ,p_hook_type => 'BP'
490: );
491: end;
507: (p_salary_survey_id => l_salary_survey_id
508: ,p_object_version_number => l_object_version_number
509: );
510: exception
511: when hr_api.cannot_find_prog_unit then
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'delete_salary_survey'
514: ,p_hook_type => 'AP'
515: );
508: ,p_object_version_number => l_object_version_number
509: );
510: exception
511: when hr_api.cannot_find_prog_unit then
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'delete_salary_survey'
514: ,p_hook_type => 'AP'
515: );
516: end;
519: -- When in validation only mode raise the Validate_Enabled exception
520: --
521: if p_validate then
522: --
523: raise hr_api.validate_enabled;
524: --
525: end if;
526: --
527: hr_utility.set_location(' Leaving:'||l_proc, 70);
526: --
527: hr_utility.set_location(' Leaving:'||l_proc, 70);
528: --
529: exception
530: when hr_api.validate_enabled then
531: --
532: -- As the Validate_Enabled exception has been raised
533: -- we must rollback to the savepoint
534: --