DBA Data[Home] [Help]

APPS.HR_SALARY_SURVEY_API dependencies on HR_API

Line 95: when hr_api.cannot_find_prog_unit then

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

Line 96: hr_api.cannot_find_prog_unit_error

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;

Line 174: when hr_api.cannot_find_prog_unit then

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

Line 175: hr_api.cannot_find_prog_unit_error

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;

Line 186: raise hr_api.validate_enabled;

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

Line 198: when hr_api.validate_enabled then

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

Line 235: ,p_survey_name in varchar2 default hr_api.g_varchar2

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

Line 236: --ras ,p_currency_code in varchar2 default hr_api.g_varchar2

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

Line 237: ,p_survey_type_code 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

Line 238: ,p_base_region 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

Line 239: ,p_effective_date in date default hr_api.g_date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 257: ,p_attribute17 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

Line 258: ,p_attribute18 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
262: ,p_object_version_number in out nocopy number

Line 259: ,p_attribute19 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
263: ) is

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

Line 318: when hr_api.cannot_find_prog_unit then

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

Line 319: hr_api.cannot_find_prog_unit_error

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;

Line 393: when hr_api.cannot_find_prog_unit then

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

Line 394: hr_api.cannot_find_prog_unit_error

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;

Line 405: raise hr_api.validate_enabled;

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

Line 416: when hr_api.validate_enabled then

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

Line 486: when hr_api.cannot_find_prog_unit then

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

Line 487: hr_api.cannot_find_prog_unit_error

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;

Line 511: when hr_api.cannot_find_prog_unit then

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

Line 512: hr_api.cannot_find_prog_unit_error

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;

Line 523: raise hr_api.validate_enabled;

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

Line 530: when hr_api.validate_enabled then

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