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_POSTAL_ZIP_RANGE_API dependencies on HR_API

Line 118: when hr_api.cannot_find_prog_unit then

114: ,p_rzr_attribute9 => p_rzr_attribute9
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_postal_zip_range'
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_postal_zip_range'
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_postal_zip_range'
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_postal_zip_range'
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 287: ,p_to_value in varchar2 default hr_api.g_varchar2

283: ,p_pstl_zip_rng_id in number
284: ,p_effective_start_date out nocopy date
285: ,p_effective_end_date out nocopy date
286: ,p_from_value in varchar2
287: ,p_to_value in varchar2 default hr_api.g_varchar2
288: ,p_business_group_id in number default hr_api.g_number
289: ,p_rzr_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_rzr_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2

Line 288: ,p_business_group_id in number default hr_api.g_number

284: ,p_effective_start_date out nocopy date
285: ,p_effective_end_date out nocopy date
286: ,p_from_value in varchar2
287: ,p_to_value in varchar2 default hr_api.g_varchar2
288: ,p_business_group_id in number default hr_api.g_number
289: ,p_rzr_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_rzr_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2

Line 289: ,p_rzr_attribute_category in varchar2 default hr_api.g_varchar2

285: ,p_effective_end_date out nocopy date
286: ,p_from_value in varchar2
287: ,p_to_value in varchar2 default hr_api.g_varchar2
288: ,p_business_group_id in number default hr_api.g_number
289: ,p_rzr_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_rzr_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2

Line 290: ,p_rzr_attribute1 in varchar2 default hr_api.g_varchar2

286: ,p_from_value in varchar2
287: ,p_to_value in varchar2 default hr_api.g_varchar2
288: ,p_business_group_id in number default hr_api.g_number
289: ,p_rzr_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_rzr_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2

Line 291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2

287: ,p_to_value in varchar2 default hr_api.g_varchar2
288: ,p_business_group_id in number default hr_api.g_number
289: ,p_rzr_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_rzr_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2

Line 292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2

288: ,p_business_group_id in number default hr_api.g_number
289: ,p_rzr_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_rzr_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2

Line 293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2

289: ,p_rzr_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_rzr_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2

Line 294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2

290: ,p_rzr_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2

Line 295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2

291: ,p_rzr_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2

Line 296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2

292: ,p_rzr_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2

Line 297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2

293: ,p_rzr_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2

Line 298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2

294: ,p_rzr_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2
302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2

Line 299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2

295: ,p_rzr_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2
302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2
303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2

Line 300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2

296: ,p_rzr_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2
302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2
303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2
304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2

Line 301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2

297: ,p_rzr_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2
302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2
303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2
304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2
305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2

Line 302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2

298: ,p_rzr_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2
302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2
303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2
304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2
305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2
306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2

Line 303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2

299: ,p_rzr_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2
302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2
303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2
304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2
305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2
306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2
307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2

Line 304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2

300: ,p_rzr_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2
302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2
303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2
304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2
305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2
306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2
307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2
308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2

Line 305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2

301: ,p_rzr_attribute2 in varchar2 default hr_api.g_varchar2
302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2
303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2
304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2
305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2
306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2
307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2
308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2
309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2

Line 306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2

302: ,p_rzr_attribute20 in varchar2 default hr_api.g_varchar2
303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2
304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2
305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2
306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2
307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2
308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2
309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2
310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2

Line 307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2

303: ,p_rzr_attribute21 in varchar2 default hr_api.g_varchar2
304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2
305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2
306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2
307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2
308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2
309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2
310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2
311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2

Line 308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2

304: ,p_rzr_attribute22 in varchar2 default hr_api.g_varchar2
305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2
306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2
307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2
308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2
309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2
310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2
311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2
312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2

Line 309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2

305: ,p_rzr_attribute23 in varchar2 default hr_api.g_varchar2
306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2
307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2
308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2
309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2
310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2
311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2
312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2

Line 310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2

306: ,p_rzr_attribute24 in varchar2 default hr_api.g_varchar2
307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2
308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2
309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2
310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2
311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2
312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2
314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2

Line 311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2

307: ,p_rzr_attribute25 in varchar2 default hr_api.g_varchar2
308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2
309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2
310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2
311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2
312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2
314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2

Line 312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2

308: ,p_rzr_attribute26 in varchar2 default hr_api.g_varchar2
309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2
310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2
311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2
312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2
314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_rzr_attribute6 in varchar2 default hr_api.g_varchar2

Line 313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2

309: ,p_rzr_attribute27 in varchar2 default hr_api.g_varchar2
310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2
311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2
312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2
314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_rzr_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_rzr_attribute7 in varchar2 default hr_api.g_varchar2

Line 314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2

310: ,p_rzr_attribute28 in varchar2 default hr_api.g_varchar2
311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2
312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2
314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_rzr_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_rzr_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_rzr_attribute8 in varchar2 default hr_api.g_varchar2

Line 315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2

311: ,p_rzr_attribute29 in varchar2 default hr_api.g_varchar2
312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2
314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_rzr_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_rzr_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_rzr_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_rzr_attribute9 in varchar2 default hr_api.g_varchar2

Line 316: ,p_rzr_attribute6 in varchar2 default hr_api.g_varchar2

312: ,p_rzr_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2
314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_rzr_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_rzr_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_rzr_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_rzr_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_object_version_number in out nocopy number

Line 317: ,p_rzr_attribute7 in varchar2 default hr_api.g_varchar2

313: ,p_rzr_attribute30 in varchar2 default hr_api.g_varchar2
314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_rzr_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_rzr_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_rzr_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_rzr_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_object_version_number in out nocopy number
321: ,p_effective_date in date

Line 318: ,p_rzr_attribute8 in varchar2 default hr_api.g_varchar2

314: ,p_rzr_attribute4 in varchar2 default hr_api.g_varchar2
315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_rzr_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_rzr_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_rzr_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_rzr_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_object_version_number in out nocopy number
321: ,p_effective_date in date
322: ,p_datetrack_mode in varchar2

Line 319: ,p_rzr_attribute9 in varchar2 default hr_api.g_varchar2

315: ,p_rzr_attribute5 in varchar2 default hr_api.g_varchar2
316: ,p_rzr_attribute6 in varchar2 default hr_api.g_varchar2
317: ,p_rzr_attribute7 in varchar2 default hr_api.g_varchar2
318: ,p_rzr_attribute8 in varchar2 default hr_api.g_varchar2
319: ,p_rzr_attribute9 in varchar2 default hr_api.g_varchar2
320: ,p_object_version_number in out nocopy number
321: ,p_effective_date in date
322: ,p_datetrack_mode in varchar2
323: ) is

Line 392: when hr_api.cannot_find_prog_unit then

388: ,p_effective_date => trunc(p_effective_date)
389: ,p_datetrack_mode => p_datetrack_mode
390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'UPDATE_postal_zip_range'
395: ,p_hook_type => 'BP'
396: );

Line 393: hr_api.cannot_find_prog_unit_error

389: ,p_datetrack_mode => p_datetrack_mode
390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'UPDATE_postal_zip_range'
395: ,p_hook_type => 'BP'
396: );
397: --

Line 494: when hr_api.cannot_find_prog_unit then

490: ,p_effective_date => trunc(p_effective_date)
491: ,p_datetrack_mode => p_datetrack_mode
492: );
493: exception
494: when hr_api.cannot_find_prog_unit then
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'UPDATE_postal_zip_range'
497: ,p_hook_type => 'AP'
498: );

Line 495: hr_api.cannot_find_prog_unit_error

491: ,p_datetrack_mode => p_datetrack_mode
492: );
493: exception
494: when hr_api.cannot_find_prog_unit then
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'UPDATE_postal_zip_range'
497: ,p_hook_type => 'AP'
498: );
499: --

Line 509: raise hr_api.validate_enabled;

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

Line 522: when hr_api.validate_enabled then

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

Line 595: when hr_api.cannot_find_prog_unit then

591: ,p_effective_date => trunc(p_effective_date)
592: ,p_datetrack_mode => p_datetrack_mode
593: );
594: exception
595: when hr_api.cannot_find_prog_unit then
596: hr_api.cannot_find_prog_unit_error
597: (p_module_name => 'DELETE_postal_zip_range'
598: ,p_hook_type => 'BP'
599: );

Line 596: hr_api.cannot_find_prog_unit_error

592: ,p_datetrack_mode => p_datetrack_mode
593: );
594: exception
595: when hr_api.cannot_find_prog_unit then
596: hr_api.cannot_find_prog_unit_error
597: (p_module_name => 'DELETE_postal_zip_range'
598: ,p_hook_type => 'BP'
599: );
600: --

Line 629: when hr_api.cannot_find_prog_unit then

625: ,p_effective_date => trunc(p_effective_date)
626: ,p_datetrack_mode => p_datetrack_mode
627: );
628: exception
629: when hr_api.cannot_find_prog_unit then
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'DELETE_postal_zip_range'
632: ,p_hook_type => 'AP'
633: );

Line 630: hr_api.cannot_find_prog_unit_error

626: ,p_datetrack_mode => p_datetrack_mode
627: );
628: exception
629: when hr_api.cannot_find_prog_unit then
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'DELETE_postal_zip_range'
632: ,p_hook_type => 'AP'
633: );
634: --

Line 644: raise hr_api.validate_enabled;

640: --
641: -- When in validation only mode raise the Validate_Enabled exception
642: --
643: if p_validate then
644: raise hr_api.validate_enabled;
645: end if;
646: --
647: hr_utility.set_location(' Leaving:'||l_proc, 70);
648: --

Line 651: when hr_api.validate_enabled then

647: hr_utility.set_location(' Leaving:'||l_proc, 70);
648: --
649: exception
650: --
651: when hr_api.validate_enabled then
652: --
653: -- As the Validate_Enabled exception has been raised
654: -- we must rollback to the savepoint
655: --