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

Line 120: when hr_api.cannot_find_prog_unit then

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

Line 121: hr_api.cannot_find_prog_unit_error

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

Line 223: when hr_api.cannot_find_prog_unit then

219: ,p_object_version_number => l_object_version_number
220: ,p_effective_date => trunc(p_effective_date)
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'CREATE_OPTD_MDCR_RT'
226: ,p_hook_type => 'AP'
227: );

Line 224: hr_api.cannot_find_prog_unit_error

220: ,p_effective_date => trunc(p_effective_date)
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'CREATE_OPTD_MDCR_RT'
226: ,p_hook_type => 'AP'
227: );
228: --

Line 247: raise hr_api.validate_enabled;

243: --
244: -- When in validation only mode raise the Validate_Enabled exception
245: --
246: if p_validate then
247: raise hr_api.validate_enabled;
248: end if;
249: --
250: -- Set all output arguments
251: --

Line 261: when hr_api.validate_enabled then

257: hr_utility.set_location(' Leaving:'||l_proc, 70);
258: --
259: exception
260: --
261: when hr_api.validate_enabled then
262: --
263: -- As the Validate_Enabled exception has been raised
264: -- we must rollback to the savepoint
265: --

Line 302: ,p_optd_mdcr_flag in varchar2 default hr_api.g_varchar2

298: (p_validate in boolean default false
299: ,p_OPTD_MDCR_RT_id in number
300: ,p_effective_start_date out nocopy date
301: ,p_effective_end_date out nocopy date
302: ,p_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
303: ,p_exlcd_flag in varchar2 default hr_api.g_varchar2
304: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2

Line 303: ,p_exlcd_flag in varchar2 default hr_api.g_varchar2

299: ,p_OPTD_MDCR_RT_id in number
300: ,p_effective_start_date out nocopy date
301: ,p_effective_end_date out nocopy date
302: ,p_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
303: ,p_exlcd_flag in varchar2 default hr_api.g_varchar2
304: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2

Line 304: ,p_vrbl_rt_prfl_id in number default hr_api.g_number

300: ,p_effective_start_date out nocopy date
301: ,p_effective_end_date out nocopy date
302: ,p_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
303: ,p_exlcd_flag in varchar2 default hr_api.g_varchar2
304: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2

Line 305: ,p_business_group_id in number default hr_api.g_number

301: ,p_effective_end_date out nocopy date
302: ,p_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
303: ,p_exlcd_flag in varchar2 default hr_api.g_varchar2
304: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2

Line 306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2

302: ,p_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
303: ,p_exlcd_flag in varchar2 default hr_api.g_varchar2
304: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2

Line 307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2

303: ,p_exlcd_flag in varchar2 default hr_api.g_varchar2
304: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2

Line 308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2

304: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2

Line 309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2

305: ,p_business_group_id in number default hr_api.g_number
306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2

Line 310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2

306: ,p_omr_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2

Line 311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2

307: ,p_omr_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2

Line 312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2

308: ,p_omr_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2

Line 313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2

309: ,p_omr_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2

Line 314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2

310: ,p_omr_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2

Line 315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2

311: ,p_omr_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2

Line 316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2

312: ,p_omr_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2

Line 317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2

313: ,p_omr_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2

Line 318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2

314: ,p_omr_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2

Line 319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2

315: ,p_omr_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2

Line 320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2

316: ,p_omr_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2

Line 321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2

317: ,p_omr_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2

Line 322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2

318: ,p_omr_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2

Line 323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2

319: ,p_omr_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2

Line 324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2

320: ,p_omr_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2

Line 325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2

321: ,p_omr_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2

Line 326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2

322: ,p_omr_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2

Line 327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2

323: ,p_omr_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2

Line 328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2

324: ,p_omr_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2

Line 329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2

325: ,p_omr_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_omr_attribute27 in varchar2 default hr_api.g_varchar2

Line 330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2

326: ,p_omr_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_omr_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_omr_attribute28 in varchar2 default hr_api.g_varchar2

Line 331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2

327: ,p_omr_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_omr_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_omr_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_omr_attribute29 in varchar2 default hr_api.g_varchar2

Line 332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2

328: ,p_omr_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_omr_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_omr_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_omr_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_omr_attribute30 in varchar2 default hr_api.g_varchar2

Line 333: ,p_omr_attribute27 in varchar2 default hr_api.g_varchar2

329: ,p_omr_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_omr_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_omr_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_omr_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_omr_attribute30 in varchar2 default hr_api.g_varchar2
337: ,p_object_version_number in out nocopy number

Line 334: ,p_omr_attribute28 in varchar2 default hr_api.g_varchar2

330: ,p_omr_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_omr_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_omr_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_omr_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_omr_attribute30 in varchar2 default hr_api.g_varchar2
337: ,p_object_version_number in out nocopy number
338: ,p_effective_date in date

Line 335: ,p_omr_attribute29 in varchar2 default hr_api.g_varchar2

331: ,p_omr_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_omr_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_omr_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_omr_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_omr_attribute30 in varchar2 default hr_api.g_varchar2
337: ,p_object_version_number in out nocopy number
338: ,p_effective_date in date
339: ,p_datetrack_mode in varchar2

Line 336: ,p_omr_attribute30 in varchar2 default hr_api.g_varchar2

332: ,p_omr_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_omr_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_omr_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_omr_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_omr_attribute30 in varchar2 default hr_api.g_varchar2
337: ,p_object_version_number in out nocopy number
338: ,p_effective_date in date
339: ,p_datetrack_mode in varchar2
340: ) is

Line 410: when hr_api.cannot_find_prog_unit then

406: ,p_effective_date => trunc(p_effective_date)
407: ,p_datetrack_mode => p_datetrack_mode
408: );
409: exception
410: when hr_api.cannot_find_prog_unit then
411: hr_api.cannot_find_prog_unit_error
412: (p_module_name => 'UPDATE_OPTD_MDCR_RT'
413: ,p_hook_type => 'BP'
414: );

Line 411: hr_api.cannot_find_prog_unit_error

407: ,p_datetrack_mode => p_datetrack_mode
408: );
409: exception
410: when hr_api.cannot_find_prog_unit then
411: hr_api.cannot_find_prog_unit_error
412: (p_module_name => 'UPDATE_OPTD_MDCR_RT'
413: ,p_hook_type => 'BP'
414: );
415: --

Line 514: when hr_api.cannot_find_prog_unit then

510: ,p_effective_date => trunc(p_effective_date)
511: ,p_datetrack_mode => p_datetrack_mode
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'UPDATE_OPTD_MDCR_RT'
517: ,p_hook_type => 'AP'
518: );

Line 515: hr_api.cannot_find_prog_unit_error

511: ,p_datetrack_mode => p_datetrack_mode
512: );
513: exception
514: when hr_api.cannot_find_prog_unit then
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'UPDATE_OPTD_MDCR_RT'
517: ,p_hook_type => 'AP'
518: );
519: --

Line 529: raise hr_api.validate_enabled;

525: --
526: -- When in validation only mode raise the Validate_Enabled exception
527: --
528: if p_validate then
529: raise hr_api.validate_enabled;
530: end if;
531: --
532: -- Set all output arguments
533: --

Line 542: when hr_api.validate_enabled then

538: hr_utility.set_location(' Leaving:'||l_proc, 70);
539: --
540: exception
541: --
542: when hr_api.validate_enabled then
543: --
544: -- As the Validate_Enabled exception has been raised
545: -- we must rollback to the savepoint
546: --

Line 621: when hr_api.cannot_find_prog_unit then

617: ,p_effective_date => trunc(p_effective_date)
618: ,p_datetrack_mode => p_datetrack_mode
619: );
620: exception
621: when hr_api.cannot_find_prog_unit then
622: hr_api.cannot_find_prog_unit_error
623: (p_module_name => 'DELETE_OPTD_MDCR_RT'
624: ,p_hook_type => 'BP'
625: );

Line 622: hr_api.cannot_find_prog_unit_error

618: ,p_datetrack_mode => p_datetrack_mode
619: );
620: exception
621: when hr_api.cannot_find_prog_unit then
622: hr_api.cannot_find_prog_unit_error
623: (p_module_name => 'DELETE_OPTD_MDCR_RT'
624: ,p_hook_type => 'BP'
625: );
626: --

Line 655: when hr_api.cannot_find_prog_unit then

651: ,p_effective_date => trunc(p_effective_date)
652: ,p_datetrack_mode => p_datetrack_mode
653: );
654: exception
655: when hr_api.cannot_find_prog_unit then
656: hr_api.cannot_find_prog_unit_error
657: (p_module_name => 'DELETE_OPTD_MDCR_RT'
658: ,p_hook_type => 'AP'
659: );

Line 656: hr_api.cannot_find_prog_unit_error

652: ,p_datetrack_mode => p_datetrack_mode
653: );
654: exception
655: when hr_api.cannot_find_prog_unit then
656: hr_api.cannot_find_prog_unit_error
657: (p_module_name => 'DELETE_OPTD_MDCR_RT'
658: ,p_hook_type => 'AP'
659: );
660: --

Line 679: raise hr_api.validate_enabled;

675: --
676: -- When in validation only mode raise the Validate_Enabled exception
677: --
678: if p_validate then
679: raise hr_api.validate_enabled;
680: end if;
681: --
682: hr_utility.set_location(' Leaving:'||l_proc, 70);
683: --

Line 686: when hr_api.validate_enabled then

682: hr_utility.set_location(' Leaving:'||l_proc, 70);
683: --
684: exception
685: --
686: when hr_api.validate_enabled then
687: --
688: -- As the Validate_Enabled exception has been raised
689: -- we must rollback to the savepoint
690: --