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'
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: );
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: );
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: --
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: --
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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: );
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: --
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: );
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: --
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.
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: --
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: --
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: --
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: );
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: --
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: );
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: --
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: --
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: --