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

Line 179: when hr_api.cannot_find_prog_unit then

175: ,p_otp_attribute30 => p_otp_attribute30
176: ,p_effective_date => trunc(p_effective_date)
177: );
178: exception
179: when hr_api.cannot_find_prog_unit then
180: hr_api.cannot_find_prog_unit_error
181: (
182: p_module_name => 'CREATE_opt_pltyp_in_pgm'
183: ,p_hook_type => 'BP'

Line 180: hr_api.cannot_find_prog_unit_error

176: ,p_effective_date => trunc(p_effective_date)
177: );
178: exception
179: when hr_api.cannot_find_prog_unit then
180: hr_api.cannot_find_prog_unit_error
181: (
182: p_module_name => 'CREATE_opt_pltyp_in_pgm'
183: ,p_hook_type => 'BP'
184: );

Line 290: when hr_api.cannot_find_prog_unit then

286: ,p_object_version_number => l_object_version_number
287: ,p_effective_date => trunc(p_effective_date)
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (p_module_name => 'CREATE_opt_pltyp_in_pgm'
293: ,p_hook_type => 'AP'
294: );

Line 291: hr_api.cannot_find_prog_unit_error

287: ,p_effective_date => trunc(p_effective_date)
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (p_module_name => 'CREATE_opt_pltyp_in_pgm'
293: ,p_hook_type => 'AP'
294: );
295: --

Line 305: raise hr_api.validate_enabled;

301: --
302: -- When in validation only mode raise the Validate_Enabled exception
303: --
304: if p_validate then
305: raise hr_api.validate_enabled;
306: end if;
307: --
308: -- Set all output arguments
309: --

Line 319: when hr_api.validate_enabled then

315: hr_utility.set_location(' Leaving:'||l_proc, 70);
316: --
317: exception
318: --
319: when hr_api.validate_enabled then
320: --
321: -- As the Validate_Enabled exception has been raised
322: -- we must rollback to the savepoint
323: --

Line 360: ,p_business_group_id in number default hr_api.g_number

356: (p_validate in boolean default false
357: ,p_optip_id in number
358: ,p_effective_start_date out nocopy date
359: ,p_effective_end_date out nocopy date
360: ,p_business_group_id in number default hr_api.g_number
361: ,p_pgm_id in number default hr_api.g_number
362: ,p_ptip_id in number default hr_api.g_number
363: ,p_pl_typ_id in number default hr_api.g_number
364: ,p_opt_id in number default hr_api.g_number

Line 361: ,p_pgm_id in number default hr_api.g_number

357: ,p_optip_id in number
358: ,p_effective_start_date out nocopy date
359: ,p_effective_end_date out nocopy date
360: ,p_business_group_id in number default hr_api.g_number
361: ,p_pgm_id in number default hr_api.g_number
362: ,p_ptip_id in number default hr_api.g_number
363: ,p_pl_typ_id in number default hr_api.g_number
364: ,p_opt_id in number default hr_api.g_number
365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

Line 362: ,p_ptip_id in number default hr_api.g_number

358: ,p_effective_start_date out nocopy date
359: ,p_effective_end_date out nocopy date
360: ,p_business_group_id in number default hr_api.g_number
361: ,p_pgm_id in number default hr_api.g_number
362: ,p_ptip_id in number default hr_api.g_number
363: ,p_pl_typ_id in number default hr_api.g_number
364: ,p_opt_id in number default hr_api.g_number
365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
366: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 363: ,p_pl_typ_id in number default hr_api.g_number

359: ,p_effective_end_date out nocopy date
360: ,p_business_group_id in number default hr_api.g_number
361: ,p_pgm_id in number default hr_api.g_number
362: ,p_ptip_id in number default hr_api.g_number
363: ,p_pl_typ_id in number default hr_api.g_number
364: ,p_opt_id in number default hr_api.g_number
365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
366: ,p_legislation_code in varchar2 default hr_api.g_varchar2
367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2

Line 364: ,p_opt_id in number default hr_api.g_number

360: ,p_business_group_id in number default hr_api.g_number
361: ,p_pgm_id in number default hr_api.g_number
362: ,p_ptip_id in number default hr_api.g_number
363: ,p_pl_typ_id in number default hr_api.g_number
364: ,p_opt_id in number default hr_api.g_number
365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
366: ,p_legislation_code in varchar2 default hr_api.g_varchar2
367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2

Line 365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

361: ,p_pgm_id in number default hr_api.g_number
362: ,p_ptip_id in number default hr_api.g_number
363: ,p_pl_typ_id in number default hr_api.g_number
364: ,p_opt_id in number default hr_api.g_number
365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
366: ,p_legislation_code in varchar2 default hr_api.g_varchar2
367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2

Line 366: ,p_legislation_code in varchar2 default hr_api.g_varchar2

362: ,p_ptip_id in number default hr_api.g_number
363: ,p_pl_typ_id in number default hr_api.g_number
364: ,p_opt_id in number default hr_api.g_number
365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
366: ,p_legislation_code in varchar2 default hr_api.g_varchar2
367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2

Line 367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2

363: ,p_pl_typ_id in number default hr_api.g_number
364: ,p_opt_id in number default hr_api.g_number
365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
366: ,p_legislation_code in varchar2 default hr_api.g_varchar2
367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2

Line 368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2

364: ,p_opt_id in number default hr_api.g_number
365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
366: ,p_legislation_code in varchar2 default hr_api.g_varchar2
367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2

Line 369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2

365: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
366: ,p_legislation_code in varchar2 default hr_api.g_varchar2
367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2

Line 370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2

366: ,p_legislation_code in varchar2 default hr_api.g_varchar2
367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2

Line 371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2

367: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2

Line 372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2

368: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2

Line 373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2

369: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2

Line 374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2

370: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2

Line 375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2

371: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2

Line 376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2

372: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2

Line 377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2

373: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2

Line 378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2

374: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2

Line 379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2

375: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2

Line 380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2

376: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2

Line 381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2

377: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2

Line 382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2

378: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2

Line 383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2

379: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2

Line 384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2

380: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2

Line 385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2

381: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2

Line 386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2

382: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2

Line 387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2

383: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2

Line 388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2

384: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2

Line 389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2

385: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2

Line 390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2

386: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2

Line 391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2

387: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2

Line 392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2

388: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2

Line 393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2

389: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2

Line 394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2

390: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2

Line 395: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2

391: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2
399: ,p_object_version_number in out nocopy number

Line 396: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2

392: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2
399: ,p_object_version_number in out nocopy number
400: ,p_effective_date in date

Line 397: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2

393: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2
399: ,p_object_version_number in out nocopy number
400: ,p_effective_date in date
401: ,p_datetrack_mode in varchar2

Line 398: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2

394: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
395: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
396: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
397: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
398: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2
399: ,p_object_version_number in out nocopy number
400: ,p_effective_date in date
401: ,p_datetrack_mode in varchar2
402: ) is

Line 476: when hr_api.cannot_find_prog_unit then

472: ,p_effective_date => trunc(p_effective_date)
473: ,p_datetrack_mode => p_datetrack_mode
474: );
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'UPDATE_opt_pltyp_in_pgm'
479: ,p_hook_type => 'BP'
480: );

Line 477: hr_api.cannot_find_prog_unit_error

473: ,p_datetrack_mode => p_datetrack_mode
474: );
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'UPDATE_opt_pltyp_in_pgm'
479: ,p_hook_type => 'BP'
480: );
481: --

Line 588: when hr_api.cannot_find_prog_unit then

584: ,p_effective_date => trunc(p_effective_date)
585: ,p_datetrack_mode => p_datetrack_mode
586: );
587: exception
588: when hr_api.cannot_find_prog_unit then
589: hr_api.cannot_find_prog_unit_error
590: (p_module_name => 'UPDATE_opt_pltyp_in_pgm'
591: ,p_hook_type => 'AP'
592: );

Line 589: hr_api.cannot_find_prog_unit_error

585: ,p_datetrack_mode => p_datetrack_mode
586: );
587: exception
588: when hr_api.cannot_find_prog_unit then
589: hr_api.cannot_find_prog_unit_error
590: (p_module_name => 'UPDATE_opt_pltyp_in_pgm'
591: ,p_hook_type => 'AP'
592: );
593: --

Line 603: raise hr_api.validate_enabled;

599: --
600: -- When in validation only mode raise the Validate_Enabled exception
601: --
602: if p_validate then
603: raise hr_api.validate_enabled;
604: end if;
605: --
606: -- Set all output arguments
607: --

Line 616: when hr_api.validate_enabled then

612: hr_utility.set_location(' Leaving:'||l_proc, 70);
613: --
614: exception
615: --
616: when hr_api.validate_enabled then
617: --
618: -- As the Validate_Enabled exception has been raised
619: -- we must rollback to the savepoint
620: --

Line 693: when hr_api.cannot_find_prog_unit then

689: ,p_effective_date => trunc(p_effective_date)
690: ,p_datetrack_mode => p_datetrack_mode
691: );
692: exception
693: when hr_api.cannot_find_prog_unit then
694: hr_api.cannot_find_prog_unit_error
695: (p_module_name => 'DELETE_opt_pltyp_in_pgm'
696: ,p_hook_type => 'BP'
697: );

Line 694: hr_api.cannot_find_prog_unit_error

690: ,p_datetrack_mode => p_datetrack_mode
691: );
692: exception
693: when hr_api.cannot_find_prog_unit then
694: hr_api.cannot_find_prog_unit_error
695: (p_module_name => 'DELETE_opt_pltyp_in_pgm'
696: ,p_hook_type => 'BP'
697: );
698: --

Line 727: when hr_api.cannot_find_prog_unit then

723: ,p_effective_date => trunc(p_effective_date)
724: ,p_datetrack_mode => p_datetrack_mode
725: );
726: exception
727: when hr_api.cannot_find_prog_unit then
728: hr_api.cannot_find_prog_unit_error
729: (p_module_name => 'DELETE_opt_pltyp_in_pgm'
730: ,p_hook_type => 'AP'
731: );

Line 728: hr_api.cannot_find_prog_unit_error

724: ,p_datetrack_mode => p_datetrack_mode
725: );
726: exception
727: when hr_api.cannot_find_prog_unit then
728: hr_api.cannot_find_prog_unit_error
729: (p_module_name => 'DELETE_opt_pltyp_in_pgm'
730: ,p_hook_type => 'AP'
731: );
732: --

Line 742: raise hr_api.validate_enabled;

738: --
739: -- When in validation only mode raise the Validate_Enabled exception
740: --
741: if p_validate then
742: raise hr_api.validate_enabled;
743: end if;
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 70);
746: --

Line 749: when hr_api.validate_enabled then

745: hr_utility.set_location(' Leaving:'||l_proc, 70);
746: --
747: exception
748: --
749: when hr_api.validate_enabled then
750: --
751: -- As the Validate_Enabled exception has been raised
752: -- we must rollback to the savepoint
753: --