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

APPS.BEN_SERVICE_AREA_API dependencies on HR_API

Line 118: when hr_api.cannot_find_prog_unit then

114: ,p_sva_attribute30 => p_sva_attribute30
115: ,p_effective_date => trunc(p_effective_date)
116: );
117: exception
118: when hr_api.cannot_find_prog_unit then
119: hr_api.cannot_find_prog_unit_error
120: (
121: p_module_name => 'CREATE_SERVICE_AREA'
122: ,p_hook_type => 'BP'

Line 119: hr_api.cannot_find_prog_unit_error

115: ,p_effective_date => trunc(p_effective_date)
116: );
117: exception
118: when hr_api.cannot_find_prog_unit then
119: hr_api.cannot_find_prog_unit_error
120: (
121: p_module_name => 'CREATE_SERVICE_AREA'
122: ,p_hook_type => 'BP'
123: );

Line 219: when hr_api.cannot_find_prog_unit then

215: ,p_object_version_number => l_object_version_number
216: ,p_effective_date => trunc(p_effective_date)
217: );
218: exception
219: when hr_api.cannot_find_prog_unit then
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'CREATE_SERVICE_AREA'
222: ,p_hook_type => 'AP'
223: );

Line 220: hr_api.cannot_find_prog_unit_error

216: ,p_effective_date => trunc(p_effective_date)
217: );
218: exception
219: when hr_api.cannot_find_prog_unit then
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'CREATE_SERVICE_AREA'
222: ,p_hook_type => 'AP'
223: );
224: --

Line 234: raise hr_api.validate_enabled;

230: --
231: -- When in validation only mode raise the Validate_Enabled exception
232: --
233: if p_validate then
234: raise hr_api.validate_enabled;
235: end if;
236: --
237: -- Set all output arguments
238: --

Line 248: when hr_api.validate_enabled then

244: hr_utility.set_location(' Leaving:'||l_proc, 70);
245: --
246: exception
247: --
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised
251: -- we must rollback to the savepoint
252: --

Line 289: ,p_name in varchar2 default hr_api.g_varchar2

285: (p_validate in boolean default false
286: ,p_svc_area_id in number
287: ,p_effective_start_date out nocopy date
288: ,p_effective_end_date out nocopy date
289: ,p_name in varchar2 default hr_api.g_varchar2
290: ,p_org_unit_prdct in varchar2 default hr_api.g_varchar2
291: ,p_business_group_id in number default hr_api.g_number
292: ,p_sva_attribute_category in varchar2 default hr_api.g_varchar2
293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2

Line 290: ,p_org_unit_prdct in varchar2 default hr_api.g_varchar2

286: ,p_svc_area_id in number
287: ,p_effective_start_date out nocopy date
288: ,p_effective_end_date out nocopy date
289: ,p_name in varchar2 default hr_api.g_varchar2
290: ,p_org_unit_prdct in varchar2 default hr_api.g_varchar2
291: ,p_business_group_id in number default hr_api.g_number
292: ,p_sva_attribute_category in varchar2 default hr_api.g_varchar2
293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2
294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2

Line 291: ,p_business_group_id in number default hr_api.g_number

287: ,p_effective_start_date out nocopy date
288: ,p_effective_end_date out nocopy date
289: ,p_name in varchar2 default hr_api.g_varchar2
290: ,p_org_unit_prdct in varchar2 default hr_api.g_varchar2
291: ,p_business_group_id in number default hr_api.g_number
292: ,p_sva_attribute_category in varchar2 default hr_api.g_varchar2
293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2
294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2
295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2

Line 292: ,p_sva_attribute_category in varchar2 default hr_api.g_varchar2

288: ,p_effective_end_date out nocopy date
289: ,p_name in varchar2 default hr_api.g_varchar2
290: ,p_org_unit_prdct in varchar2 default hr_api.g_varchar2
291: ,p_business_group_id in number default hr_api.g_number
292: ,p_sva_attribute_category in varchar2 default hr_api.g_varchar2
293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2
294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2
295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2
296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2

Line 293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2

289: ,p_name in varchar2 default hr_api.g_varchar2
290: ,p_org_unit_prdct in varchar2 default hr_api.g_varchar2
291: ,p_business_group_id in number default hr_api.g_number
292: ,p_sva_attribute_category in varchar2 default hr_api.g_varchar2
293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2
294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2
295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2
296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2
297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2

Line 294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2

290: ,p_org_unit_prdct in varchar2 default hr_api.g_varchar2
291: ,p_business_group_id in number default hr_api.g_number
292: ,p_sva_attribute_category in varchar2 default hr_api.g_varchar2
293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2
294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2
295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2
296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2
297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2
298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2

Line 295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2

291: ,p_business_group_id in number default hr_api.g_number
292: ,p_sva_attribute_category in varchar2 default hr_api.g_varchar2
293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2
294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2
295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2
296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2
297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2
298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2
299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2

Line 296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2

292: ,p_sva_attribute_category in varchar2 default hr_api.g_varchar2
293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2
294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2
295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2
296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2
297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2
298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2
299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2
300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2

Line 297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2

293: ,p_sva_attribute1 in varchar2 default hr_api.g_varchar2
294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2
295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2
296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2
297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2
298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2
299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2
300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2
301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2

Line 298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2

294: ,p_sva_attribute2 in varchar2 default hr_api.g_varchar2
295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2
296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2
297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2
298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2
299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2
300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2
301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2
302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2

Line 299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2

295: ,p_sva_attribute3 in varchar2 default hr_api.g_varchar2
296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2
297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2
298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2
299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2
300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2
301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2
302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2
303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2

Line 300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2

296: ,p_sva_attribute4 in varchar2 default hr_api.g_varchar2
297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2
298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2
299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2
300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2
301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2
302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2
303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2
304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2

Line 301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2

297: ,p_sva_attribute5 in varchar2 default hr_api.g_varchar2
298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2
299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2
300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2
301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2
302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2
303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2
304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2
305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2

Line 302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2

298: ,p_sva_attribute6 in varchar2 default hr_api.g_varchar2
299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2
300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2
301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2
302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2
303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2
304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2
305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2
306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2

Line 303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2

299: ,p_sva_attribute7 in varchar2 default hr_api.g_varchar2
300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2
301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2
302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2
303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2
304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2
305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2
306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2
307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2

Line 304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2

300: ,p_sva_attribute8 in varchar2 default hr_api.g_varchar2
301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2
302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2
303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2
304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2
305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2
306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2
307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2
308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2

Line 305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2

301: ,p_sva_attribute9 in varchar2 default hr_api.g_varchar2
302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2
303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2
304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2
305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2
306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2
307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2
308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2
309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2

Line 306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2

302: ,p_sva_attribute10 in varchar2 default hr_api.g_varchar2
303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2
304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2
305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2
306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2
307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2
308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2
309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2
310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2

Line 307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2

303: ,p_sva_attribute11 in varchar2 default hr_api.g_varchar2
304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2
305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2
306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2
307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2
308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2
309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2
310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2
311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2

Line 308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2

304: ,p_sva_attribute12 in varchar2 default hr_api.g_varchar2
305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2
306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2
307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2
308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2
309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2
310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2
311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2
312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2

Line 309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2

305: ,p_sva_attribute13 in varchar2 default hr_api.g_varchar2
306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2
307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2
308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2
309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2
310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2
311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2
312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2
313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2

Line 310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2

306: ,p_sva_attribute14 in varchar2 default hr_api.g_varchar2
307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2
308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2
309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2
310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2
311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2
312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2
313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2
314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2

Line 311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2

307: ,p_sva_attribute15 in varchar2 default hr_api.g_varchar2
308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2
309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2
310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2
311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2
312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2
313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2
314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2
315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2

Line 312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2

308: ,p_sva_attribute16 in varchar2 default hr_api.g_varchar2
309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2
310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2
311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2
312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2
313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2
314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2
315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2
316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2

Line 313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2

309: ,p_sva_attribute17 in varchar2 default hr_api.g_varchar2
310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2
311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2
312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2
313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2
314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2
315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2
316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2
317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2

Line 314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2

310: ,p_sva_attribute18 in varchar2 default hr_api.g_varchar2
311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2
312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2
313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2
314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2
315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2
316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2
317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2
318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2

Line 315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2

311: ,p_sva_attribute19 in varchar2 default hr_api.g_varchar2
312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2
313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2
314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2
315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2
316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2
317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2
318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2
319: ,p_sva_attribute27 in varchar2 default hr_api.g_varchar2

Line 316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2

312: ,p_sva_attribute20 in varchar2 default hr_api.g_varchar2
313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2
314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2
315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2
316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2
317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2
318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2
319: ,p_sva_attribute27 in varchar2 default hr_api.g_varchar2
320: ,p_sva_attribute28 in varchar2 default hr_api.g_varchar2

Line 317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2

313: ,p_sva_attribute21 in varchar2 default hr_api.g_varchar2
314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2
315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2
316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2
317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2
318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2
319: ,p_sva_attribute27 in varchar2 default hr_api.g_varchar2
320: ,p_sva_attribute28 in varchar2 default hr_api.g_varchar2
321: ,p_sva_attribute29 in varchar2 default hr_api.g_varchar2

Line 318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2

314: ,p_sva_attribute22 in varchar2 default hr_api.g_varchar2
315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2
316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2
317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2
318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2
319: ,p_sva_attribute27 in varchar2 default hr_api.g_varchar2
320: ,p_sva_attribute28 in varchar2 default hr_api.g_varchar2
321: ,p_sva_attribute29 in varchar2 default hr_api.g_varchar2
322: ,p_sva_attribute30 in varchar2 default hr_api.g_varchar2

Line 319: ,p_sva_attribute27 in varchar2 default hr_api.g_varchar2

315: ,p_sva_attribute23 in varchar2 default hr_api.g_varchar2
316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2
317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2
318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2
319: ,p_sva_attribute27 in varchar2 default hr_api.g_varchar2
320: ,p_sva_attribute28 in varchar2 default hr_api.g_varchar2
321: ,p_sva_attribute29 in varchar2 default hr_api.g_varchar2
322: ,p_sva_attribute30 in varchar2 default hr_api.g_varchar2
323: ,p_object_version_number in out nocopy number

Line 320: ,p_sva_attribute28 in varchar2 default hr_api.g_varchar2

316: ,p_sva_attribute24 in varchar2 default hr_api.g_varchar2
317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2
318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2
319: ,p_sva_attribute27 in varchar2 default hr_api.g_varchar2
320: ,p_sva_attribute28 in varchar2 default hr_api.g_varchar2
321: ,p_sva_attribute29 in varchar2 default hr_api.g_varchar2
322: ,p_sva_attribute30 in varchar2 default hr_api.g_varchar2
323: ,p_object_version_number in out nocopy number
324: ,p_effective_date in date

Line 321: ,p_sva_attribute29 in varchar2 default hr_api.g_varchar2

317: ,p_sva_attribute25 in varchar2 default hr_api.g_varchar2
318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2
319: ,p_sva_attribute27 in varchar2 default hr_api.g_varchar2
320: ,p_sva_attribute28 in varchar2 default hr_api.g_varchar2
321: ,p_sva_attribute29 in varchar2 default hr_api.g_varchar2
322: ,p_sva_attribute30 in varchar2 default hr_api.g_varchar2
323: ,p_object_version_number in out nocopy number
324: ,p_effective_date in date
325: ,p_datetrack_mode in varchar2

Line 322: ,p_sva_attribute30 in varchar2 default hr_api.g_varchar2

318: ,p_sva_attribute26 in varchar2 default hr_api.g_varchar2
319: ,p_sva_attribute27 in varchar2 default hr_api.g_varchar2
320: ,p_sva_attribute28 in varchar2 default hr_api.g_varchar2
321: ,p_sva_attribute29 in varchar2 default hr_api.g_varchar2
322: ,p_sva_attribute30 in varchar2 default hr_api.g_varchar2
323: ,p_object_version_number in out nocopy number
324: ,p_effective_date in date
325: ,p_datetrack_mode in varchar2
326: ) is

Line 395: when hr_api.cannot_find_prog_unit then

391: ,p_effective_date => trunc(p_effective_date)
392: ,p_datetrack_mode => p_datetrack_mode
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'UPDATE_SERVICE_AREA'
398: ,p_hook_type => 'BP'
399: );

Line 396: hr_api.cannot_find_prog_unit_error

392: ,p_datetrack_mode => p_datetrack_mode
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'UPDATE_SERVICE_AREA'
398: ,p_hook_type => 'BP'
399: );
400: --

Line 497: when hr_api.cannot_find_prog_unit then

493: ,p_effective_date => trunc(p_effective_date)
494: ,p_datetrack_mode => p_datetrack_mode
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'UPDATE_SERVICE_AREA'
500: ,p_hook_type => 'AP'
501: );

Line 498: hr_api.cannot_find_prog_unit_error

494: ,p_datetrack_mode => p_datetrack_mode
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'UPDATE_SERVICE_AREA'
500: ,p_hook_type => 'AP'
501: );
502: --

Line 512: raise hr_api.validate_enabled;

508: --
509: -- When in validation only mode raise the Validate_Enabled exception
510: --
511: if p_validate then
512: raise hr_api.validate_enabled;
513: end if;
514: --
515: -- Set all output arguments
516: --

Line 525: when hr_api.validate_enabled then

521: hr_utility.set_location(' Leaving:'||l_proc, 70);
522: --
523: exception
524: --
525: when hr_api.validate_enabled then
526: --
527: -- As the Validate_Enabled exception has been raised
528: -- we must rollback to the savepoint
529: --

Line 600: when hr_api.cannot_find_prog_unit then

596: ,p_effective_date => trunc(p_effective_date)
597: ,p_datetrack_mode => p_datetrack_mode
598: );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'DELETE_SERVICE_AREA'
603: ,p_hook_type => 'BP'
604: );

Line 601: hr_api.cannot_find_prog_unit_error

597: ,p_datetrack_mode => p_datetrack_mode
598: );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'DELETE_SERVICE_AREA'
603: ,p_hook_type => 'BP'
604: );
605: --

Line 634: when hr_api.cannot_find_prog_unit then

630: ,p_effective_date => trunc(p_effective_date)
631: ,p_datetrack_mode => p_datetrack_mode
632: );
633: exception
634: when hr_api.cannot_find_prog_unit then
635: hr_api.cannot_find_prog_unit_error
636: (p_module_name => 'DELETE_SERVICE_AREA'
637: ,p_hook_type => 'AP'
638: );

Line 635: hr_api.cannot_find_prog_unit_error

631: ,p_datetrack_mode => p_datetrack_mode
632: );
633: exception
634: when hr_api.cannot_find_prog_unit then
635: hr_api.cannot_find_prog_unit_error
636: (p_module_name => 'DELETE_SERVICE_AREA'
637: ,p_hook_type => 'AP'
638: );
639: --

Line 649: raise hr_api.validate_enabled;

645: --
646: -- When in validation only mode raise the Validate_Enabled exception
647: --
648: if p_validate then
649: raise hr_api.validate_enabled;
650: end if;
651: --
652: hr_utility.set_location(' Leaving:'||l_proc, 70);
653: --

Line 656: when hr_api.validate_enabled then

652: hr_utility.set_location(' Leaving:'||l_proc, 70);
653: --
654: exception
655: --
656: when hr_api.validate_enabled then
657: --
658: -- As the Validate_Enabled exception has been raised
659: -- we must rollback to the savepoint
660: --