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

Line 140: when hr_api.cannot_find_prog_unit then

136: ,p_rvc_attribute30 => p_rvc_attribute30
137: ,p_effective_date => trunc(p_effective_date)
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (
143: p_module_name => 'CREATE_prv_ctfn_prvdd'
144: ,p_hook_type => 'BP'

Line 141: hr_api.cannot_find_prog_unit_error

137: ,p_effective_date => trunc(p_effective_date)
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (
143: p_module_name => 'CREATE_prv_ctfn_prvdd'
144: ,p_hook_type => 'BP'
145: );

Line 251: when hr_api.cannot_find_prog_unit then

247: ,p_object_version_number => l_object_version_number
248: ,p_effective_date => trunc(p_effective_date)
249: );
250: exception
251: when hr_api.cannot_find_prog_unit then
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'CREATE_prv_ctfn_prvdd'
254: ,p_hook_type => 'AP'
255: );

Line 252: hr_api.cannot_find_prog_unit_error

248: ,p_effective_date => trunc(p_effective_date)
249: );
250: exception
251: when hr_api.cannot_find_prog_unit then
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'CREATE_prv_ctfn_prvdd'
254: ,p_hook_type => 'AP'
255: );
256: --

Line 266: raise hr_api.validate_enabled;

262: --
263: -- When in validation only mode raise the Validate_Enabled exception
264: --
265: if p_validate then
266: raise hr_api.validate_enabled;
267: end if;
268: --
269: -- Set all output arguments
270: --

Line 278: when hr_api.validate_enabled then

274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
279: --
280: -- As the Validate_Enabled exception has been raised
281: -- we must rollback to the savepoint
282: --

Line 310: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

306: --
307: procedure update_prv_ctfn_prvdd
308: (p_validate in boolean default false
309: ,p_prtt_rt_val_ctfn_prvdd_id in number
310: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
311: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
312: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
313: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
314: ,p_prtt_rt_val_id in number default hr_api.g_number

Line 311: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2

307: procedure update_prv_ctfn_prvdd
308: (p_validate in boolean default false
309: ,p_prtt_rt_val_ctfn_prvdd_id in number
310: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
311: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
312: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
313: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
314: ,p_prtt_rt_val_id in number default hr_api.g_number
315: ,p_business_group_id in number default hr_api.g_number

Line 312: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date

308: (p_validate in boolean default false
309: ,p_prtt_rt_val_ctfn_prvdd_id in number
310: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
311: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
312: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
313: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
314: ,p_prtt_rt_val_id in number default hr_api.g_number
315: ,p_business_group_id in number default hr_api.g_number
316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2

Line 313: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date

309: ,p_prtt_rt_val_ctfn_prvdd_id in number
310: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
311: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
312: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
313: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
314: ,p_prtt_rt_val_id in number default hr_api.g_number
315: ,p_business_group_id in number default hr_api.g_number
316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2
317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2

Line 314: ,p_prtt_rt_val_id in number default hr_api.g_number

310: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
311: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
312: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
313: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
314: ,p_prtt_rt_val_id in number default hr_api.g_number
315: ,p_business_group_id in number default hr_api.g_number
316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2
317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2
318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2

Line 315: ,p_business_group_id in number default hr_api.g_number

311: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
312: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
313: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
314: ,p_prtt_rt_val_id in number default hr_api.g_number
315: ,p_business_group_id in number default hr_api.g_number
316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2
317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2
318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2
319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2

Line 316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2

312: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
313: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
314: ,p_prtt_rt_val_id in number default hr_api.g_number
315: ,p_business_group_id in number default hr_api.g_number
316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2
317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2
318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2
319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2
320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2

Line 317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2

313: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
314: ,p_prtt_rt_val_id in number default hr_api.g_number
315: ,p_business_group_id in number default hr_api.g_number
316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2
317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2
318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2
319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2
320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2
321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2

Line 318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2

314: ,p_prtt_rt_val_id in number default hr_api.g_number
315: ,p_business_group_id in number default hr_api.g_number
316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2
317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2
318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2
319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2
320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2
321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2
322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2

Line 319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2

315: ,p_business_group_id in number default hr_api.g_number
316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2
317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2
318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2
319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2
320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2
321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2
322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2
323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2

Line 320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2

316: ,p_rvc_attribute_category in varchar2 default hr_api.g_varchar2
317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2
318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2
319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2
320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2
321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2
322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2
323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2
324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2

Line 321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2

317: ,p_rvc_attribute1 in varchar2 default hr_api.g_varchar2
318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2
319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2
320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2
321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2
322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2
323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2
324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2
325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2

Line 322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2

318: ,p_rvc_attribute2 in varchar2 default hr_api.g_varchar2
319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2
320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2
321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2
322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2
323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2
324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2
325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2
326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2

Line 323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2

319: ,p_rvc_attribute3 in varchar2 default hr_api.g_varchar2
320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2
321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2
322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2
323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2
324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2
325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2
326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2
327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2

Line 324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2

320: ,p_rvc_attribute4 in varchar2 default hr_api.g_varchar2
321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2
322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2
323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2
324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2
325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2
326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2
327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2
328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2

Line 325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2

321: ,p_rvc_attribute5 in varchar2 default hr_api.g_varchar2
322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2
323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2
324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2
325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2
326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2
327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2
328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2
329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2

Line 326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2

322: ,p_rvc_attribute6 in varchar2 default hr_api.g_varchar2
323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2
324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2
325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2
326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2
327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2
328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2
329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2
330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2

Line 327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2

323: ,p_rvc_attribute7 in varchar2 default hr_api.g_varchar2
324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2
325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2
326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2
327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2
328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2
329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2
330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2
331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2

Line 328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2

324: ,p_rvc_attribute8 in varchar2 default hr_api.g_varchar2
325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2
326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2
327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2
328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2
329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2
330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2
331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2
332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2

Line 329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2

325: ,p_rvc_attribute9 in varchar2 default hr_api.g_varchar2
326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2
327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2
328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2
329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2
330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2
331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2
332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2
333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2

Line 330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2

326: ,p_rvc_attribute10 in varchar2 default hr_api.g_varchar2
327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2
328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2
329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2
330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2
331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2
332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2
333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2
334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2

Line 331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2

327: ,p_rvc_attribute11 in varchar2 default hr_api.g_varchar2
328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2
329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2
330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2
331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2
332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2
333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2
334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2
335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2

Line 332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2

328: ,p_rvc_attribute12 in varchar2 default hr_api.g_varchar2
329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2
330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2
331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2
332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2
333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2
334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2
335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2
336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2

Line 333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2

329: ,p_rvc_attribute13 in varchar2 default hr_api.g_varchar2
330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2
331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2
332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2
333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2
334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2
335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2
336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2
337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2

Line 334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2

330: ,p_rvc_attribute14 in varchar2 default hr_api.g_varchar2
331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2
332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2
333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2
334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2
335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2
336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2
337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2
338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2

Line 335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2

331: ,p_rvc_attribute15 in varchar2 default hr_api.g_varchar2
332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2
333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2
334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2
335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2
336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2
337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2
338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2
339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2

Line 336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2

332: ,p_rvc_attribute16 in varchar2 default hr_api.g_varchar2
333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2
334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2
335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2
336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2
337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2
338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2
339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2
340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2

Line 337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2

333: ,p_rvc_attribute17 in varchar2 default hr_api.g_varchar2
334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2
335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2
336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2
337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2
338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2
339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2
340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2
341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2

Line 338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2

334: ,p_rvc_attribute18 in varchar2 default hr_api.g_varchar2
335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2
336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2
337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2
338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2
339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2
340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2
341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2
342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2

Line 339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2

335: ,p_rvc_attribute19 in varchar2 default hr_api.g_varchar2
336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2
337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2
338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2
339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2
340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2
341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2
342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2
343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2

Line 340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2

336: ,p_rvc_attribute20 in varchar2 default hr_api.g_varchar2
337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2
338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2
339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2
340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2
341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2
342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2
343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2
344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2

Line 341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2

337: ,p_rvc_attribute21 in varchar2 default hr_api.g_varchar2
338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2
339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2
340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2
341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2
342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2
343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2
344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2
345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2

Line 342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2

338: ,p_rvc_attribute22 in varchar2 default hr_api.g_varchar2
339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2
340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2
341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2
342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2
343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2
344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2
345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2
346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2

Line 343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2

339: ,p_rvc_attribute23 in varchar2 default hr_api.g_varchar2
340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2
341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2
342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2
343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2
344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2
345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2
346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number

Line 344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2

340: ,p_rvc_attribute24 in varchar2 default hr_api.g_varchar2
341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2
342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2
343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2
344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2
345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2
346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number

Line 345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2

341: ,p_rvc_attribute25 in varchar2 default hr_api.g_varchar2
342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2
343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2
344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2
345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2
346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number

Line 346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2

342: ,p_rvc_attribute26 in varchar2 default hr_api.g_varchar2
343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2
344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2
345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2
346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date

Line 347: ,p_request_id in number default hr_api.g_number

343: ,p_rvc_attribute27 in varchar2 default hr_api.g_varchar2
344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2
345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2
346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_object_version_number in out nocopy number

Line 348: ,p_program_application_id in number default hr_api.g_number

344: ,p_rvc_attribute28 in varchar2 default hr_api.g_varchar2
345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2
346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_object_version_number in out nocopy number
352: ,p_effective_date in date

Line 349: ,p_program_id in number default hr_api.g_number

345: ,p_rvc_attribute29 in varchar2 default hr_api.g_varchar2
346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_object_version_number in out nocopy number
352: ,p_effective_date in date
353: ) is

Line 350: ,p_program_update_date in date default hr_api.g_date

346: ,p_rvc_attribute30 in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_object_version_number in out nocopy number
352: ,p_effective_date in date
353: ) is
354: --

Line 458: when hr_api.cannot_find_prog_unit then

454: ,p_object_version_number => p_object_version_number
455: ,p_effective_date => trunc(p_effective_date)
456: );
457: exception
458: when hr_api.cannot_find_prog_unit then
459: hr_api.cannot_find_prog_unit_error
460: (p_module_name => 'UPDATE_prv_ctfn_prvdd'
461: ,p_hook_type => 'BP'
462: );

Line 459: hr_api.cannot_find_prog_unit_error

455: ,p_effective_date => trunc(p_effective_date)
456: );
457: exception
458: when hr_api.cannot_find_prog_unit then
459: hr_api.cannot_find_prog_unit_error
460: (p_module_name => 'UPDATE_prv_ctfn_prvdd'
461: ,p_hook_type => 'BP'
462: );
463: --

Line 568: when hr_api.cannot_find_prog_unit then

564: ,p_object_version_number => l_object_version_number
565: ,p_effective_date => trunc(p_effective_date)
566: );
567: exception
568: when hr_api.cannot_find_prog_unit then
569: hr_api.cannot_find_prog_unit_error
570: (p_module_name => 'UPDATE_prv_ctfn_prvdd'
571: ,p_hook_type => 'AP'
572: );

Line 569: hr_api.cannot_find_prog_unit_error

565: ,p_effective_date => trunc(p_effective_date)
566: );
567: exception
568: when hr_api.cannot_find_prog_unit then
569: hr_api.cannot_find_prog_unit_error
570: (p_module_name => 'UPDATE_prv_ctfn_prvdd'
571: ,p_hook_type => 'AP'
572: );
573: --

Line 580: if nvl(p_enrt_ctfn_recd_dt, hr_api.g_date) <> hr_api.g_date and

576: end;
577: --
578: -- LGE : if certification recieved then create element entry.
579: --
580: if nvl(p_enrt_ctfn_recd_dt, hr_api.g_date) <> hr_api.g_date and
581: nvl(p_enrt_ctfn_dnd_dt, hr_api.g_date) = hr_api.g_date
582: then
583: --
584: -- Create element entry.

Line 581: nvl(p_enrt_ctfn_dnd_dt, hr_api.g_date) = hr_api.g_date

577: --
578: -- LGE : if certification recieved then create element entry.
579: --
580: if nvl(p_enrt_ctfn_recd_dt, hr_api.g_date) <> hr_api.g_date and
581: nvl(p_enrt_ctfn_dnd_dt, hr_api.g_date) = hr_api.g_date
582: then
583: --
584: -- Create element entry.
585: --

Line 625: raise hr_api.validate_enabled;

621: --
622: -- When in validation only mode raise the Validate_Enabled exception
623: --
624: if p_validate then
625: raise hr_api.validate_enabled;
626: end if;
627: --
628: -- Set all output arguments
629: --

Line 637: when hr_api.validate_enabled then

633: hr_utility.set_location(' Leaving:'||l_proc, 70);
634: --
635: exception
636: --
637: when hr_api.validate_enabled then
638: --
639: -- As the Validate_Enabled exception has been raised
640: -- we must rollback to the savepoint
641: --

Line 721: when hr_api.cannot_find_prog_unit then

717: (p_prtt_rt_val_ctfn_prvdd_id => p_prtt_rt_val_ctfn_prvdd_id
718: ,p_object_version_number => p_object_version_number
719: ,p_effective_date => trunc(p_effective_date) );
720: exception
721: when hr_api.cannot_find_prog_unit then
722: hr_api.cannot_find_prog_unit_error
723: (p_module_name => 'DELETE_prv_ctfn_prvdd'
724: ,p_hook_type => 'BP'
725: );

Line 722: hr_api.cannot_find_prog_unit_error

718: ,p_object_version_number => p_object_version_number
719: ,p_effective_date => trunc(p_effective_date) );
720: exception
721: when hr_api.cannot_find_prog_unit then
722: hr_api.cannot_find_prog_unit_error
723: (p_module_name => 'DELETE_prv_ctfn_prvdd'
724: ,p_hook_type => 'BP'
725: );
726: --

Line 750: when hr_api.cannot_find_prog_unit then

746: ,p_object_version_number => l_object_version_number
747: ,p_effective_date => trunc(p_effective_date)
748: );
749: exception
750: when hr_api.cannot_find_prog_unit then
751: hr_api.cannot_find_prog_unit_error
752: (p_module_name => 'DELETE_prv_ctfn_prvdd'
753: ,p_hook_type => 'AP'
754: );

Line 751: hr_api.cannot_find_prog_unit_error

747: ,p_effective_date => trunc(p_effective_date)
748: );
749: exception
750: when hr_api.cannot_find_prog_unit then
751: hr_api.cannot_find_prog_unit_error
752: (p_module_name => 'DELETE_prv_ctfn_prvdd'
753: ,p_hook_type => 'AP'
754: );
755: --

Line 765: raise hr_api.validate_enabled;

761: --
762: -- When in validation only mode raise the Validate_Enabled exception
763: --
764: if p_validate then
765: raise hr_api.validate_enabled;
766: end if;
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 70);
769: --

Line 772: when hr_api.validate_enabled then

768: hr_utility.set_location(' Leaving:'||l_proc, 70);
769: --
770: exception
771: --
772: when hr_api.validate_enabled then
773: --
774: -- As the Validate_Enabled exception has been raised
775: -- we must rollback to the savepoint
776: --