128: ,p_tcv_attribute30 => p_tcv_attribute30
129: ,p_effective_date => trunc(p_effective_date)
130: );
131: exception
132: when hr_api.cannot_find_prog_unit then
133: hr_api.cannot_find_prog_unit_error
134: (
135: p_module_name => 'CREATE_ttl_cvg_vol_rt'
136: ,p_hook_type => 'BP'
129: ,p_effective_date => trunc(p_effective_date)
130: );
131: exception
132: when hr_api.cannot_find_prog_unit then
133: hr_api.cannot_find_prog_unit_error
134: (
135: p_module_name => 'CREATE_ttl_cvg_vol_rt'
136: ,p_hook_type => 'BP'
137: );
243: ,p_object_version_number => l_object_version_number
244: ,p_effective_date => trunc(p_effective_date)
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'CREATE_ttl_cvg_vol_rt'
250: ,p_hook_type => 'AP'
251: );
244: ,p_effective_date => trunc(p_effective_date)
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'CREATE_ttl_cvg_vol_rt'
250: ,p_hook_type => 'AP'
251: );
252: --
267: --
268: -- When in validation only mode raise the Validate_Enabled exception
269: --
270: if p_validate then
271: raise hr_api.validate_enabled;
272: end if;
273: --
274: -- Set all output arguments
275: --
281: hr_utility.set_location(' Leaving:'||l_proc, 70);
282: --
283: exception
284: --
285: when hr_api.validate_enabled then
286: --
287: -- As the Validate_Enabled exception has been raised
288: -- we must rollback to the savepoint
289: --
322: (p_validate in boolean default false
323: ,p_ttl_cvg_vol_rt_id in number
324: ,p_effective_start_date out nocopy date
325: ,p_effective_end_date out nocopy date
326: ,p_business_group_id in number default hr_api.g_number
327: ,p_excld_flag in varchar2 default hr_api.g_varchar2
328: ,p_no_mn_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mx_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_ordr_num in number default hr_api.g_number
323: ,p_ttl_cvg_vol_rt_id in number
324: ,p_effective_start_date out nocopy date
325: ,p_effective_end_date out nocopy date
326: ,p_business_group_id in number default hr_api.g_number
327: ,p_excld_flag in varchar2 default hr_api.g_varchar2
328: ,p_no_mn_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mx_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_ordr_num in number default hr_api.g_number
331: ,p_mn_cvg_vol_amt in number default hr_api.g_number
324: ,p_effective_start_date out nocopy date
325: ,p_effective_end_date out nocopy date
326: ,p_business_group_id in number default hr_api.g_number
327: ,p_excld_flag in varchar2 default hr_api.g_varchar2
328: ,p_no_mn_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mx_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_ordr_num in number default hr_api.g_number
331: ,p_mn_cvg_vol_amt in number default hr_api.g_number
332: ,p_mx_cvg_vol_amt in number default hr_api.g_number
325: ,p_effective_end_date out nocopy date
326: ,p_business_group_id in number default hr_api.g_number
327: ,p_excld_flag in varchar2 default hr_api.g_varchar2
328: ,p_no_mn_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mx_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_ordr_num in number default hr_api.g_number
331: ,p_mn_cvg_vol_amt in number default hr_api.g_number
332: ,p_mx_cvg_vol_amt in number default hr_api.g_number
333: ,p_cvg_vol_det_cd in varchar2 default hr_api.g_varchar2
326: ,p_business_group_id in number default hr_api.g_number
327: ,p_excld_flag in varchar2 default hr_api.g_varchar2
328: ,p_no_mn_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mx_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_ordr_num in number default hr_api.g_number
331: ,p_mn_cvg_vol_amt in number default hr_api.g_number
332: ,p_mx_cvg_vol_amt in number default hr_api.g_number
333: ,p_cvg_vol_det_cd in varchar2 default hr_api.g_varchar2
334: ,p_cvg_vol_det_rl in number default hr_api.g_number
327: ,p_excld_flag in varchar2 default hr_api.g_varchar2
328: ,p_no_mn_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mx_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_ordr_num in number default hr_api.g_number
331: ,p_mn_cvg_vol_amt in number default hr_api.g_number
332: ,p_mx_cvg_vol_amt in number default hr_api.g_number
333: ,p_cvg_vol_det_cd in varchar2 default hr_api.g_varchar2
334: ,p_cvg_vol_det_rl in number default hr_api.g_number
335: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
328: ,p_no_mn_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mx_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_ordr_num in number default hr_api.g_number
331: ,p_mn_cvg_vol_amt in number default hr_api.g_number
332: ,p_mx_cvg_vol_amt in number default hr_api.g_number
333: ,p_cvg_vol_det_cd in varchar2 default hr_api.g_varchar2
334: ,p_cvg_vol_det_rl in number default hr_api.g_number
335: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
336: ,p_tcv_attribute_category in varchar2 default hr_api.g_varchar2
329: ,p_no_mx_cvg_vol_amt_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_ordr_num in number default hr_api.g_number
331: ,p_mn_cvg_vol_amt in number default hr_api.g_number
332: ,p_mx_cvg_vol_amt in number default hr_api.g_number
333: ,p_cvg_vol_det_cd in varchar2 default hr_api.g_varchar2
334: ,p_cvg_vol_det_rl in number default hr_api.g_number
335: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
336: ,p_tcv_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_tcv_attribute1 in varchar2 default hr_api.g_varchar2
330: ,p_ordr_num in number default hr_api.g_number
331: ,p_mn_cvg_vol_amt in number default hr_api.g_number
332: ,p_mx_cvg_vol_amt in number default hr_api.g_number
333: ,p_cvg_vol_det_cd in varchar2 default hr_api.g_varchar2
334: ,p_cvg_vol_det_rl in number default hr_api.g_number
335: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
336: ,p_tcv_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_tcv_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_tcv_attribute2 in varchar2 default hr_api.g_varchar2
331: ,p_mn_cvg_vol_amt in number default hr_api.g_number
332: ,p_mx_cvg_vol_amt in number default hr_api.g_number
333: ,p_cvg_vol_det_cd in varchar2 default hr_api.g_varchar2
334: ,p_cvg_vol_det_rl in number default hr_api.g_number
335: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
336: ,p_tcv_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_tcv_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_tcv_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_tcv_attribute3 in varchar2 default hr_api.g_varchar2
332: ,p_mx_cvg_vol_amt in number default hr_api.g_number
333: ,p_cvg_vol_det_cd in varchar2 default hr_api.g_varchar2
334: ,p_cvg_vol_det_rl in number default hr_api.g_number
335: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
336: ,p_tcv_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_tcv_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_tcv_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_tcv_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_tcv_attribute4 in varchar2 default hr_api.g_varchar2
333: ,p_cvg_vol_det_cd in varchar2 default hr_api.g_varchar2
334: ,p_cvg_vol_det_rl in number default hr_api.g_number
335: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
336: ,p_tcv_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_tcv_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_tcv_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_tcv_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_tcv_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_tcv_attribute5 in varchar2 default hr_api.g_varchar2
334: ,p_cvg_vol_det_rl in number default hr_api.g_number
335: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
336: ,p_tcv_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_tcv_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_tcv_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_tcv_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_tcv_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_tcv_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_tcv_attribute6 in varchar2 default hr_api.g_varchar2
335: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
336: ,p_tcv_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_tcv_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_tcv_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_tcv_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_tcv_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_tcv_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_tcv_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_tcv_attribute7 in varchar2 default hr_api.g_varchar2
336: ,p_tcv_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_tcv_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_tcv_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_tcv_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_tcv_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_tcv_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_tcv_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_tcv_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_tcv_attribute8 in varchar2 default hr_api.g_varchar2
337: ,p_tcv_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_tcv_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_tcv_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_tcv_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_tcv_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_tcv_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_tcv_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_tcv_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_tcv_attribute9 in varchar2 default hr_api.g_varchar2
338: ,p_tcv_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_tcv_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_tcv_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_tcv_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_tcv_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_tcv_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_tcv_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_tcv_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_tcv_attribute10 in varchar2 default hr_api.g_varchar2
339: ,p_tcv_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_tcv_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_tcv_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_tcv_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_tcv_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_tcv_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_tcv_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_tcv_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_tcv_attribute11 in varchar2 default hr_api.g_varchar2
340: ,p_tcv_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_tcv_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_tcv_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_tcv_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_tcv_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_tcv_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_tcv_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_tcv_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_tcv_attribute12 in varchar2 default hr_api.g_varchar2
341: ,p_tcv_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_tcv_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_tcv_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_tcv_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_tcv_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_tcv_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_tcv_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_tcv_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_tcv_attribute13 in varchar2 default hr_api.g_varchar2
342: ,p_tcv_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_tcv_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_tcv_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_tcv_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_tcv_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_tcv_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_tcv_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_tcv_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_tcv_attribute14 in varchar2 default hr_api.g_varchar2
343: ,p_tcv_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_tcv_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_tcv_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_tcv_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_tcv_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_tcv_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_tcv_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_tcv_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_tcv_attribute15 in varchar2 default hr_api.g_varchar2
344: ,p_tcv_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_tcv_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_tcv_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_tcv_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_tcv_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_tcv_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_tcv_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_tcv_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_tcv_attribute16 in varchar2 default hr_api.g_varchar2
345: ,p_tcv_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_tcv_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_tcv_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_tcv_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_tcv_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_tcv_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_tcv_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_tcv_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_tcv_attribute17 in varchar2 default hr_api.g_varchar2
346: ,p_tcv_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_tcv_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_tcv_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_tcv_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_tcv_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_tcv_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_tcv_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_tcv_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_tcv_attribute18 in varchar2 default hr_api.g_varchar2
347: ,p_tcv_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_tcv_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_tcv_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_tcv_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_tcv_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_tcv_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_tcv_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_tcv_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_tcv_attribute19 in varchar2 default hr_api.g_varchar2
348: ,p_tcv_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_tcv_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_tcv_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_tcv_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_tcv_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_tcv_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_tcv_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_tcv_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_tcv_attribute20 in varchar2 default hr_api.g_varchar2
349: ,p_tcv_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_tcv_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_tcv_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_tcv_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_tcv_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_tcv_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_tcv_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_tcv_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_tcv_attribute21 in varchar2 default hr_api.g_varchar2
350: ,p_tcv_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_tcv_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_tcv_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_tcv_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_tcv_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_tcv_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_tcv_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_tcv_attribute21 in varchar2 default hr_api.g_varchar2
358: ,p_tcv_attribute22 in varchar2 default hr_api.g_varchar2
351: ,p_tcv_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_tcv_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_tcv_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_tcv_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_tcv_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_tcv_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_tcv_attribute21 in varchar2 default hr_api.g_varchar2
358: ,p_tcv_attribute22 in varchar2 default hr_api.g_varchar2
359: ,p_tcv_attribute23 in varchar2 default hr_api.g_varchar2
352: ,p_tcv_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_tcv_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_tcv_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_tcv_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_tcv_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_tcv_attribute21 in varchar2 default hr_api.g_varchar2
358: ,p_tcv_attribute22 in varchar2 default hr_api.g_varchar2
359: ,p_tcv_attribute23 in varchar2 default hr_api.g_varchar2
360: ,p_tcv_attribute24 in varchar2 default hr_api.g_varchar2
353: ,p_tcv_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_tcv_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_tcv_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_tcv_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_tcv_attribute21 in varchar2 default hr_api.g_varchar2
358: ,p_tcv_attribute22 in varchar2 default hr_api.g_varchar2
359: ,p_tcv_attribute23 in varchar2 default hr_api.g_varchar2
360: ,p_tcv_attribute24 in varchar2 default hr_api.g_varchar2
361: ,p_tcv_attribute25 in varchar2 default hr_api.g_varchar2
354: ,p_tcv_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_tcv_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_tcv_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_tcv_attribute21 in varchar2 default hr_api.g_varchar2
358: ,p_tcv_attribute22 in varchar2 default hr_api.g_varchar2
359: ,p_tcv_attribute23 in varchar2 default hr_api.g_varchar2
360: ,p_tcv_attribute24 in varchar2 default hr_api.g_varchar2
361: ,p_tcv_attribute25 in varchar2 default hr_api.g_varchar2
362: ,p_tcv_attribute26 in varchar2 default hr_api.g_varchar2
355: ,p_tcv_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_tcv_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_tcv_attribute21 in varchar2 default hr_api.g_varchar2
358: ,p_tcv_attribute22 in varchar2 default hr_api.g_varchar2
359: ,p_tcv_attribute23 in varchar2 default hr_api.g_varchar2
360: ,p_tcv_attribute24 in varchar2 default hr_api.g_varchar2
361: ,p_tcv_attribute25 in varchar2 default hr_api.g_varchar2
362: ,p_tcv_attribute26 in varchar2 default hr_api.g_varchar2
363: ,p_tcv_attribute27 in varchar2 default hr_api.g_varchar2
356: ,p_tcv_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_tcv_attribute21 in varchar2 default hr_api.g_varchar2
358: ,p_tcv_attribute22 in varchar2 default hr_api.g_varchar2
359: ,p_tcv_attribute23 in varchar2 default hr_api.g_varchar2
360: ,p_tcv_attribute24 in varchar2 default hr_api.g_varchar2
361: ,p_tcv_attribute25 in varchar2 default hr_api.g_varchar2
362: ,p_tcv_attribute26 in varchar2 default hr_api.g_varchar2
363: ,p_tcv_attribute27 in varchar2 default hr_api.g_varchar2
364: ,p_tcv_attribute28 in varchar2 default hr_api.g_varchar2
357: ,p_tcv_attribute21 in varchar2 default hr_api.g_varchar2
358: ,p_tcv_attribute22 in varchar2 default hr_api.g_varchar2
359: ,p_tcv_attribute23 in varchar2 default hr_api.g_varchar2
360: ,p_tcv_attribute24 in varchar2 default hr_api.g_varchar2
361: ,p_tcv_attribute25 in varchar2 default hr_api.g_varchar2
362: ,p_tcv_attribute26 in varchar2 default hr_api.g_varchar2
363: ,p_tcv_attribute27 in varchar2 default hr_api.g_varchar2
364: ,p_tcv_attribute28 in varchar2 default hr_api.g_varchar2
365: ,p_tcv_attribute29 in varchar2 default hr_api.g_varchar2
358: ,p_tcv_attribute22 in varchar2 default hr_api.g_varchar2
359: ,p_tcv_attribute23 in varchar2 default hr_api.g_varchar2
360: ,p_tcv_attribute24 in varchar2 default hr_api.g_varchar2
361: ,p_tcv_attribute25 in varchar2 default hr_api.g_varchar2
362: ,p_tcv_attribute26 in varchar2 default hr_api.g_varchar2
363: ,p_tcv_attribute27 in varchar2 default hr_api.g_varchar2
364: ,p_tcv_attribute28 in varchar2 default hr_api.g_varchar2
365: ,p_tcv_attribute29 in varchar2 default hr_api.g_varchar2
366: ,p_tcv_attribute30 in varchar2 default hr_api.g_varchar2
359: ,p_tcv_attribute23 in varchar2 default hr_api.g_varchar2
360: ,p_tcv_attribute24 in varchar2 default hr_api.g_varchar2
361: ,p_tcv_attribute25 in varchar2 default hr_api.g_varchar2
362: ,p_tcv_attribute26 in varchar2 default hr_api.g_varchar2
363: ,p_tcv_attribute27 in varchar2 default hr_api.g_varchar2
364: ,p_tcv_attribute28 in varchar2 default hr_api.g_varchar2
365: ,p_tcv_attribute29 in varchar2 default hr_api.g_varchar2
366: ,p_tcv_attribute30 in varchar2 default hr_api.g_varchar2
367: ,p_object_version_number in out nocopy number
360: ,p_tcv_attribute24 in varchar2 default hr_api.g_varchar2
361: ,p_tcv_attribute25 in varchar2 default hr_api.g_varchar2
362: ,p_tcv_attribute26 in varchar2 default hr_api.g_varchar2
363: ,p_tcv_attribute27 in varchar2 default hr_api.g_varchar2
364: ,p_tcv_attribute28 in varchar2 default hr_api.g_varchar2
365: ,p_tcv_attribute29 in varchar2 default hr_api.g_varchar2
366: ,p_tcv_attribute30 in varchar2 default hr_api.g_varchar2
367: ,p_object_version_number in out nocopy number
368: ,p_effective_date in date
361: ,p_tcv_attribute25 in varchar2 default hr_api.g_varchar2
362: ,p_tcv_attribute26 in varchar2 default hr_api.g_varchar2
363: ,p_tcv_attribute27 in varchar2 default hr_api.g_varchar2
364: ,p_tcv_attribute28 in varchar2 default hr_api.g_varchar2
365: ,p_tcv_attribute29 in varchar2 default hr_api.g_varchar2
366: ,p_tcv_attribute30 in varchar2 default hr_api.g_varchar2
367: ,p_object_version_number in out nocopy number
368: ,p_effective_date in date
369: ,p_datetrack_mode in varchar2
362: ,p_tcv_attribute26 in varchar2 default hr_api.g_varchar2
363: ,p_tcv_attribute27 in varchar2 default hr_api.g_varchar2
364: ,p_tcv_attribute28 in varchar2 default hr_api.g_varchar2
365: ,p_tcv_attribute29 in varchar2 default hr_api.g_varchar2
366: ,p_tcv_attribute30 in varchar2 default hr_api.g_varchar2
367: ,p_object_version_number in out nocopy number
368: ,p_effective_date in date
369: ,p_datetrack_mode in varchar2
370: ) is
442: ,p_effective_date => trunc(p_effective_date)
443: ,p_datetrack_mode => p_datetrack_mode
444: );
445: exception
446: when hr_api.cannot_find_prog_unit then
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'UPDATE_ttl_cvg_vol_rt'
449: ,p_hook_type => 'BP'
450: );
443: ,p_datetrack_mode => p_datetrack_mode
444: );
445: exception
446: when hr_api.cannot_find_prog_unit then
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'UPDATE_ttl_cvg_vol_rt'
449: ,p_hook_type => 'BP'
450: );
451: --
558: ,p_effective_date => trunc(p_effective_date)
559: ,p_datetrack_mode => p_datetrack_mode
560: );
561: exception
562: when hr_api.cannot_find_prog_unit then
563: hr_api.cannot_find_prog_unit_error
564: (p_module_name => 'UPDATE_ttl_cvg_vol_rt'
565: ,p_hook_type => 'AP'
566: );
559: ,p_datetrack_mode => p_datetrack_mode
560: );
561: exception
562: when hr_api.cannot_find_prog_unit then
563: hr_api.cannot_find_prog_unit_error
564: (p_module_name => 'UPDATE_ttl_cvg_vol_rt'
565: ,p_hook_type => 'AP'
566: );
567: --
573: --
574: -- When in validation only mode raise the Validate_Enabled exception
575: --
576: if p_validate then
577: raise hr_api.validate_enabled;
578: end if;
579: --
580: -- Set all output arguments
581: --
586: hr_utility.set_location(' Leaving:'||l_proc, 70);
587: --
588: exception
589: --
590: when hr_api.validate_enabled then
591: --
592: -- As the Validate_Enabled exception has been raised
593: -- we must rollback to the savepoint
594: --
661: ,p_effective_date => trunc(p_effective_date)
662: ,p_datetrack_mode => p_datetrack_mode
663: );
664: exception
665: when hr_api.cannot_find_prog_unit then
666: hr_api.cannot_find_prog_unit_error
667: (p_module_name => 'DELETE_ttl_cvg_vol_rt'
668: ,p_hook_type => 'BP'
669: );
662: ,p_datetrack_mode => p_datetrack_mode
663: );
664: exception
665: when hr_api.cannot_find_prog_unit then
666: hr_api.cannot_find_prog_unit_error
667: (p_module_name => 'DELETE_ttl_cvg_vol_rt'
668: ,p_hook_type => 'BP'
669: );
670: --
695: ,p_effective_date => trunc(p_effective_date)
696: ,p_datetrack_mode => p_datetrack_mode
697: );
698: exception
699: when hr_api.cannot_find_prog_unit then
700: hr_api.cannot_find_prog_unit_error
701: (p_module_name => 'DELETE_ttl_cvg_vol_rt'
702: ,p_hook_type => 'AP'
703: );
696: ,p_datetrack_mode => p_datetrack_mode
697: );
698: exception
699: when hr_api.cannot_find_prog_unit then
700: hr_api.cannot_find_prog_unit_error
701: (p_module_name => 'DELETE_ttl_cvg_vol_rt'
702: ,p_hook_type => 'AP'
703: );
704: --
719: --
720: -- When in validation only mode raise the Validate_Enabled exception
721: --
722: if p_validate then
723: raise hr_api.validate_enabled;
724: end if;
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 70);
727: --
726: hr_utility.set_location(' Leaving:'||l_proc, 70);
727: --
728: exception
729: --
730: when hr_api.validate_enabled then
731: --
732: -- As the Validate_Enabled exception has been raised
733: -- we must rollback to the savepoint
734: --