142: ,p_cer_attribute30 => p_cer_attribute30
143: ,p_effective_date => trunc(p_effective_date)
144: );
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (
149: p_module_name => 'CREATE_ELIGIBILITY_RULE'
150: ,p_hook_type => 'BP'
143: ,p_effective_date => trunc(p_effective_date)
144: );
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (
149: p_module_name => 'CREATE_ELIGIBILITY_RULE'
150: ,p_hook_type => 'BP'
151: );
249: ,p_object_version_number => l_object_version_number
250: ,p_effective_date => trunc(p_effective_date)
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'CREATE_ELIGIBILITY_RULE'
256: ,p_hook_type => 'AP'
257: );
250: ,p_effective_date => trunc(p_effective_date)
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'CREATE_ELIGIBILITY_RULE'
256: ,p_hook_type => 'AP'
257: );
258: --
320: --
321: -- When in validation only mode raise the Validate_Enabled exception
322: --
323: if p_validate then
324: raise hr_api.validate_enabled;
325: end if;
326: --
327: -- Set all output arguments
328: --
334: hr_utility.set_location(' Leaving:'||l_proc, 70);
335: --
336: exception
337: --
338: when hr_api.validate_enabled then
339: --
340: -- As the Validate_Enabled exception has been raised
341: -- we must rollback to the savepoint
342: --
368: (p_validate in boolean default false
369: ,p_prtn_eligy_rl_id in number
370: ,p_effective_start_date out nocopy date
371: ,p_effective_end_date out nocopy date
372: ,p_business_group_id in number default hr_api.g_number
373: ,p_prtn_elig_id in number default hr_api.g_number
374: ,p_formula_id in number default hr_api.g_number
375: ,p_drvbl_fctr_apls_flag in varchar2 default hr_api.g_varchar2
376: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
369: ,p_prtn_eligy_rl_id in number
370: ,p_effective_start_date out nocopy date
371: ,p_effective_end_date out nocopy date
372: ,p_business_group_id in number default hr_api.g_number
373: ,p_prtn_elig_id in number default hr_api.g_number
374: ,p_formula_id in number default hr_api.g_number
375: ,p_drvbl_fctr_apls_flag in varchar2 default hr_api.g_varchar2
376: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
377: ,p_ordr_to_aply_num in number default hr_api.g_number
370: ,p_effective_start_date out nocopy date
371: ,p_effective_end_date out nocopy date
372: ,p_business_group_id in number default hr_api.g_number
373: ,p_prtn_elig_id in number default hr_api.g_number
374: ,p_formula_id in number default hr_api.g_number
375: ,p_drvbl_fctr_apls_flag in varchar2 default hr_api.g_varchar2
376: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
377: ,p_ordr_to_aply_num in number default hr_api.g_number
378: ,p_cer_attribute_category in varchar2 default hr_api.g_varchar2
371: ,p_effective_end_date out nocopy date
372: ,p_business_group_id in number default hr_api.g_number
373: ,p_prtn_elig_id in number default hr_api.g_number
374: ,p_formula_id in number default hr_api.g_number
375: ,p_drvbl_fctr_apls_flag in varchar2 default hr_api.g_varchar2
376: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
377: ,p_ordr_to_aply_num in number default hr_api.g_number
378: ,p_cer_attribute_category in varchar2 default hr_api.g_varchar2
379: ,p_cer_attribute1 in varchar2 default hr_api.g_varchar2
372: ,p_business_group_id in number default hr_api.g_number
373: ,p_prtn_elig_id in number default hr_api.g_number
374: ,p_formula_id in number default hr_api.g_number
375: ,p_drvbl_fctr_apls_flag in varchar2 default hr_api.g_varchar2
376: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
377: ,p_ordr_to_aply_num in number default hr_api.g_number
378: ,p_cer_attribute_category in varchar2 default hr_api.g_varchar2
379: ,p_cer_attribute1 in varchar2 default hr_api.g_varchar2
380: ,p_cer_attribute2 in varchar2 default hr_api.g_varchar2
373: ,p_prtn_elig_id in number default hr_api.g_number
374: ,p_formula_id in number default hr_api.g_number
375: ,p_drvbl_fctr_apls_flag in varchar2 default hr_api.g_varchar2
376: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
377: ,p_ordr_to_aply_num in number default hr_api.g_number
378: ,p_cer_attribute_category in varchar2 default hr_api.g_varchar2
379: ,p_cer_attribute1 in varchar2 default hr_api.g_varchar2
380: ,p_cer_attribute2 in varchar2 default hr_api.g_varchar2
381: ,p_cer_attribute3 in varchar2 default hr_api.g_varchar2
374: ,p_formula_id in number default hr_api.g_number
375: ,p_drvbl_fctr_apls_flag in varchar2 default hr_api.g_varchar2
376: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
377: ,p_ordr_to_aply_num in number default hr_api.g_number
378: ,p_cer_attribute_category in varchar2 default hr_api.g_varchar2
379: ,p_cer_attribute1 in varchar2 default hr_api.g_varchar2
380: ,p_cer_attribute2 in varchar2 default hr_api.g_varchar2
381: ,p_cer_attribute3 in varchar2 default hr_api.g_varchar2
382: ,p_cer_attribute4 in varchar2 default hr_api.g_varchar2
375: ,p_drvbl_fctr_apls_flag in varchar2 default hr_api.g_varchar2
376: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
377: ,p_ordr_to_aply_num in number default hr_api.g_number
378: ,p_cer_attribute_category in varchar2 default hr_api.g_varchar2
379: ,p_cer_attribute1 in varchar2 default hr_api.g_varchar2
380: ,p_cer_attribute2 in varchar2 default hr_api.g_varchar2
381: ,p_cer_attribute3 in varchar2 default hr_api.g_varchar2
382: ,p_cer_attribute4 in varchar2 default hr_api.g_varchar2
383: ,p_cer_attribute5 in varchar2 default hr_api.g_varchar2
376: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
377: ,p_ordr_to_aply_num in number default hr_api.g_number
378: ,p_cer_attribute_category in varchar2 default hr_api.g_varchar2
379: ,p_cer_attribute1 in varchar2 default hr_api.g_varchar2
380: ,p_cer_attribute2 in varchar2 default hr_api.g_varchar2
381: ,p_cer_attribute3 in varchar2 default hr_api.g_varchar2
382: ,p_cer_attribute4 in varchar2 default hr_api.g_varchar2
383: ,p_cer_attribute5 in varchar2 default hr_api.g_varchar2
384: ,p_cer_attribute6 in varchar2 default hr_api.g_varchar2
377: ,p_ordr_to_aply_num in number default hr_api.g_number
378: ,p_cer_attribute_category in varchar2 default hr_api.g_varchar2
379: ,p_cer_attribute1 in varchar2 default hr_api.g_varchar2
380: ,p_cer_attribute2 in varchar2 default hr_api.g_varchar2
381: ,p_cer_attribute3 in varchar2 default hr_api.g_varchar2
382: ,p_cer_attribute4 in varchar2 default hr_api.g_varchar2
383: ,p_cer_attribute5 in varchar2 default hr_api.g_varchar2
384: ,p_cer_attribute6 in varchar2 default hr_api.g_varchar2
385: ,p_cer_attribute7 in varchar2 default hr_api.g_varchar2
378: ,p_cer_attribute_category in varchar2 default hr_api.g_varchar2
379: ,p_cer_attribute1 in varchar2 default hr_api.g_varchar2
380: ,p_cer_attribute2 in varchar2 default hr_api.g_varchar2
381: ,p_cer_attribute3 in varchar2 default hr_api.g_varchar2
382: ,p_cer_attribute4 in varchar2 default hr_api.g_varchar2
383: ,p_cer_attribute5 in varchar2 default hr_api.g_varchar2
384: ,p_cer_attribute6 in varchar2 default hr_api.g_varchar2
385: ,p_cer_attribute7 in varchar2 default hr_api.g_varchar2
386: ,p_cer_attribute8 in varchar2 default hr_api.g_varchar2
379: ,p_cer_attribute1 in varchar2 default hr_api.g_varchar2
380: ,p_cer_attribute2 in varchar2 default hr_api.g_varchar2
381: ,p_cer_attribute3 in varchar2 default hr_api.g_varchar2
382: ,p_cer_attribute4 in varchar2 default hr_api.g_varchar2
383: ,p_cer_attribute5 in varchar2 default hr_api.g_varchar2
384: ,p_cer_attribute6 in varchar2 default hr_api.g_varchar2
385: ,p_cer_attribute7 in varchar2 default hr_api.g_varchar2
386: ,p_cer_attribute8 in varchar2 default hr_api.g_varchar2
387: ,p_cer_attribute9 in varchar2 default hr_api.g_varchar2
380: ,p_cer_attribute2 in varchar2 default hr_api.g_varchar2
381: ,p_cer_attribute3 in varchar2 default hr_api.g_varchar2
382: ,p_cer_attribute4 in varchar2 default hr_api.g_varchar2
383: ,p_cer_attribute5 in varchar2 default hr_api.g_varchar2
384: ,p_cer_attribute6 in varchar2 default hr_api.g_varchar2
385: ,p_cer_attribute7 in varchar2 default hr_api.g_varchar2
386: ,p_cer_attribute8 in varchar2 default hr_api.g_varchar2
387: ,p_cer_attribute9 in varchar2 default hr_api.g_varchar2
388: ,p_cer_attribute10 in varchar2 default hr_api.g_varchar2
381: ,p_cer_attribute3 in varchar2 default hr_api.g_varchar2
382: ,p_cer_attribute4 in varchar2 default hr_api.g_varchar2
383: ,p_cer_attribute5 in varchar2 default hr_api.g_varchar2
384: ,p_cer_attribute6 in varchar2 default hr_api.g_varchar2
385: ,p_cer_attribute7 in varchar2 default hr_api.g_varchar2
386: ,p_cer_attribute8 in varchar2 default hr_api.g_varchar2
387: ,p_cer_attribute9 in varchar2 default hr_api.g_varchar2
388: ,p_cer_attribute10 in varchar2 default hr_api.g_varchar2
389: ,p_cer_attribute11 in varchar2 default hr_api.g_varchar2
382: ,p_cer_attribute4 in varchar2 default hr_api.g_varchar2
383: ,p_cer_attribute5 in varchar2 default hr_api.g_varchar2
384: ,p_cer_attribute6 in varchar2 default hr_api.g_varchar2
385: ,p_cer_attribute7 in varchar2 default hr_api.g_varchar2
386: ,p_cer_attribute8 in varchar2 default hr_api.g_varchar2
387: ,p_cer_attribute9 in varchar2 default hr_api.g_varchar2
388: ,p_cer_attribute10 in varchar2 default hr_api.g_varchar2
389: ,p_cer_attribute11 in varchar2 default hr_api.g_varchar2
390: ,p_cer_attribute12 in varchar2 default hr_api.g_varchar2
383: ,p_cer_attribute5 in varchar2 default hr_api.g_varchar2
384: ,p_cer_attribute6 in varchar2 default hr_api.g_varchar2
385: ,p_cer_attribute7 in varchar2 default hr_api.g_varchar2
386: ,p_cer_attribute8 in varchar2 default hr_api.g_varchar2
387: ,p_cer_attribute9 in varchar2 default hr_api.g_varchar2
388: ,p_cer_attribute10 in varchar2 default hr_api.g_varchar2
389: ,p_cer_attribute11 in varchar2 default hr_api.g_varchar2
390: ,p_cer_attribute12 in varchar2 default hr_api.g_varchar2
391: ,p_cer_attribute13 in varchar2 default hr_api.g_varchar2
384: ,p_cer_attribute6 in varchar2 default hr_api.g_varchar2
385: ,p_cer_attribute7 in varchar2 default hr_api.g_varchar2
386: ,p_cer_attribute8 in varchar2 default hr_api.g_varchar2
387: ,p_cer_attribute9 in varchar2 default hr_api.g_varchar2
388: ,p_cer_attribute10 in varchar2 default hr_api.g_varchar2
389: ,p_cer_attribute11 in varchar2 default hr_api.g_varchar2
390: ,p_cer_attribute12 in varchar2 default hr_api.g_varchar2
391: ,p_cer_attribute13 in varchar2 default hr_api.g_varchar2
392: ,p_cer_attribute14 in varchar2 default hr_api.g_varchar2
385: ,p_cer_attribute7 in varchar2 default hr_api.g_varchar2
386: ,p_cer_attribute8 in varchar2 default hr_api.g_varchar2
387: ,p_cer_attribute9 in varchar2 default hr_api.g_varchar2
388: ,p_cer_attribute10 in varchar2 default hr_api.g_varchar2
389: ,p_cer_attribute11 in varchar2 default hr_api.g_varchar2
390: ,p_cer_attribute12 in varchar2 default hr_api.g_varchar2
391: ,p_cer_attribute13 in varchar2 default hr_api.g_varchar2
392: ,p_cer_attribute14 in varchar2 default hr_api.g_varchar2
393: ,p_cer_attribute15 in varchar2 default hr_api.g_varchar2
386: ,p_cer_attribute8 in varchar2 default hr_api.g_varchar2
387: ,p_cer_attribute9 in varchar2 default hr_api.g_varchar2
388: ,p_cer_attribute10 in varchar2 default hr_api.g_varchar2
389: ,p_cer_attribute11 in varchar2 default hr_api.g_varchar2
390: ,p_cer_attribute12 in varchar2 default hr_api.g_varchar2
391: ,p_cer_attribute13 in varchar2 default hr_api.g_varchar2
392: ,p_cer_attribute14 in varchar2 default hr_api.g_varchar2
393: ,p_cer_attribute15 in varchar2 default hr_api.g_varchar2
394: ,p_cer_attribute16 in varchar2 default hr_api.g_varchar2
387: ,p_cer_attribute9 in varchar2 default hr_api.g_varchar2
388: ,p_cer_attribute10 in varchar2 default hr_api.g_varchar2
389: ,p_cer_attribute11 in varchar2 default hr_api.g_varchar2
390: ,p_cer_attribute12 in varchar2 default hr_api.g_varchar2
391: ,p_cer_attribute13 in varchar2 default hr_api.g_varchar2
392: ,p_cer_attribute14 in varchar2 default hr_api.g_varchar2
393: ,p_cer_attribute15 in varchar2 default hr_api.g_varchar2
394: ,p_cer_attribute16 in varchar2 default hr_api.g_varchar2
395: ,p_cer_attribute17 in varchar2 default hr_api.g_varchar2
388: ,p_cer_attribute10 in varchar2 default hr_api.g_varchar2
389: ,p_cer_attribute11 in varchar2 default hr_api.g_varchar2
390: ,p_cer_attribute12 in varchar2 default hr_api.g_varchar2
391: ,p_cer_attribute13 in varchar2 default hr_api.g_varchar2
392: ,p_cer_attribute14 in varchar2 default hr_api.g_varchar2
393: ,p_cer_attribute15 in varchar2 default hr_api.g_varchar2
394: ,p_cer_attribute16 in varchar2 default hr_api.g_varchar2
395: ,p_cer_attribute17 in varchar2 default hr_api.g_varchar2
396: ,p_cer_attribute18 in varchar2 default hr_api.g_varchar2
389: ,p_cer_attribute11 in varchar2 default hr_api.g_varchar2
390: ,p_cer_attribute12 in varchar2 default hr_api.g_varchar2
391: ,p_cer_attribute13 in varchar2 default hr_api.g_varchar2
392: ,p_cer_attribute14 in varchar2 default hr_api.g_varchar2
393: ,p_cer_attribute15 in varchar2 default hr_api.g_varchar2
394: ,p_cer_attribute16 in varchar2 default hr_api.g_varchar2
395: ,p_cer_attribute17 in varchar2 default hr_api.g_varchar2
396: ,p_cer_attribute18 in varchar2 default hr_api.g_varchar2
397: ,p_cer_attribute19 in varchar2 default hr_api.g_varchar2
390: ,p_cer_attribute12 in varchar2 default hr_api.g_varchar2
391: ,p_cer_attribute13 in varchar2 default hr_api.g_varchar2
392: ,p_cer_attribute14 in varchar2 default hr_api.g_varchar2
393: ,p_cer_attribute15 in varchar2 default hr_api.g_varchar2
394: ,p_cer_attribute16 in varchar2 default hr_api.g_varchar2
395: ,p_cer_attribute17 in varchar2 default hr_api.g_varchar2
396: ,p_cer_attribute18 in varchar2 default hr_api.g_varchar2
397: ,p_cer_attribute19 in varchar2 default hr_api.g_varchar2
398: ,p_cer_attribute20 in varchar2 default hr_api.g_varchar2
391: ,p_cer_attribute13 in varchar2 default hr_api.g_varchar2
392: ,p_cer_attribute14 in varchar2 default hr_api.g_varchar2
393: ,p_cer_attribute15 in varchar2 default hr_api.g_varchar2
394: ,p_cer_attribute16 in varchar2 default hr_api.g_varchar2
395: ,p_cer_attribute17 in varchar2 default hr_api.g_varchar2
396: ,p_cer_attribute18 in varchar2 default hr_api.g_varchar2
397: ,p_cer_attribute19 in varchar2 default hr_api.g_varchar2
398: ,p_cer_attribute20 in varchar2 default hr_api.g_varchar2
399: ,p_cer_attribute21 in varchar2 default hr_api.g_varchar2
392: ,p_cer_attribute14 in varchar2 default hr_api.g_varchar2
393: ,p_cer_attribute15 in varchar2 default hr_api.g_varchar2
394: ,p_cer_attribute16 in varchar2 default hr_api.g_varchar2
395: ,p_cer_attribute17 in varchar2 default hr_api.g_varchar2
396: ,p_cer_attribute18 in varchar2 default hr_api.g_varchar2
397: ,p_cer_attribute19 in varchar2 default hr_api.g_varchar2
398: ,p_cer_attribute20 in varchar2 default hr_api.g_varchar2
399: ,p_cer_attribute21 in varchar2 default hr_api.g_varchar2
400: ,p_cer_attribute22 in varchar2 default hr_api.g_varchar2
393: ,p_cer_attribute15 in varchar2 default hr_api.g_varchar2
394: ,p_cer_attribute16 in varchar2 default hr_api.g_varchar2
395: ,p_cer_attribute17 in varchar2 default hr_api.g_varchar2
396: ,p_cer_attribute18 in varchar2 default hr_api.g_varchar2
397: ,p_cer_attribute19 in varchar2 default hr_api.g_varchar2
398: ,p_cer_attribute20 in varchar2 default hr_api.g_varchar2
399: ,p_cer_attribute21 in varchar2 default hr_api.g_varchar2
400: ,p_cer_attribute22 in varchar2 default hr_api.g_varchar2
401: ,p_cer_attribute23 in varchar2 default hr_api.g_varchar2
394: ,p_cer_attribute16 in varchar2 default hr_api.g_varchar2
395: ,p_cer_attribute17 in varchar2 default hr_api.g_varchar2
396: ,p_cer_attribute18 in varchar2 default hr_api.g_varchar2
397: ,p_cer_attribute19 in varchar2 default hr_api.g_varchar2
398: ,p_cer_attribute20 in varchar2 default hr_api.g_varchar2
399: ,p_cer_attribute21 in varchar2 default hr_api.g_varchar2
400: ,p_cer_attribute22 in varchar2 default hr_api.g_varchar2
401: ,p_cer_attribute23 in varchar2 default hr_api.g_varchar2
402: ,p_cer_attribute24 in varchar2 default hr_api.g_varchar2
395: ,p_cer_attribute17 in varchar2 default hr_api.g_varchar2
396: ,p_cer_attribute18 in varchar2 default hr_api.g_varchar2
397: ,p_cer_attribute19 in varchar2 default hr_api.g_varchar2
398: ,p_cer_attribute20 in varchar2 default hr_api.g_varchar2
399: ,p_cer_attribute21 in varchar2 default hr_api.g_varchar2
400: ,p_cer_attribute22 in varchar2 default hr_api.g_varchar2
401: ,p_cer_attribute23 in varchar2 default hr_api.g_varchar2
402: ,p_cer_attribute24 in varchar2 default hr_api.g_varchar2
403: ,p_cer_attribute25 in varchar2 default hr_api.g_varchar2
396: ,p_cer_attribute18 in varchar2 default hr_api.g_varchar2
397: ,p_cer_attribute19 in varchar2 default hr_api.g_varchar2
398: ,p_cer_attribute20 in varchar2 default hr_api.g_varchar2
399: ,p_cer_attribute21 in varchar2 default hr_api.g_varchar2
400: ,p_cer_attribute22 in varchar2 default hr_api.g_varchar2
401: ,p_cer_attribute23 in varchar2 default hr_api.g_varchar2
402: ,p_cer_attribute24 in varchar2 default hr_api.g_varchar2
403: ,p_cer_attribute25 in varchar2 default hr_api.g_varchar2
404: ,p_cer_attribute26 in varchar2 default hr_api.g_varchar2
397: ,p_cer_attribute19 in varchar2 default hr_api.g_varchar2
398: ,p_cer_attribute20 in varchar2 default hr_api.g_varchar2
399: ,p_cer_attribute21 in varchar2 default hr_api.g_varchar2
400: ,p_cer_attribute22 in varchar2 default hr_api.g_varchar2
401: ,p_cer_attribute23 in varchar2 default hr_api.g_varchar2
402: ,p_cer_attribute24 in varchar2 default hr_api.g_varchar2
403: ,p_cer_attribute25 in varchar2 default hr_api.g_varchar2
404: ,p_cer_attribute26 in varchar2 default hr_api.g_varchar2
405: ,p_cer_attribute27 in varchar2 default hr_api.g_varchar2
398: ,p_cer_attribute20 in varchar2 default hr_api.g_varchar2
399: ,p_cer_attribute21 in varchar2 default hr_api.g_varchar2
400: ,p_cer_attribute22 in varchar2 default hr_api.g_varchar2
401: ,p_cer_attribute23 in varchar2 default hr_api.g_varchar2
402: ,p_cer_attribute24 in varchar2 default hr_api.g_varchar2
403: ,p_cer_attribute25 in varchar2 default hr_api.g_varchar2
404: ,p_cer_attribute26 in varchar2 default hr_api.g_varchar2
405: ,p_cer_attribute27 in varchar2 default hr_api.g_varchar2
406: ,p_cer_attribute28 in varchar2 default hr_api.g_varchar2
399: ,p_cer_attribute21 in varchar2 default hr_api.g_varchar2
400: ,p_cer_attribute22 in varchar2 default hr_api.g_varchar2
401: ,p_cer_attribute23 in varchar2 default hr_api.g_varchar2
402: ,p_cer_attribute24 in varchar2 default hr_api.g_varchar2
403: ,p_cer_attribute25 in varchar2 default hr_api.g_varchar2
404: ,p_cer_attribute26 in varchar2 default hr_api.g_varchar2
405: ,p_cer_attribute27 in varchar2 default hr_api.g_varchar2
406: ,p_cer_attribute28 in varchar2 default hr_api.g_varchar2
407: ,p_cer_attribute29 in varchar2 default hr_api.g_varchar2
400: ,p_cer_attribute22 in varchar2 default hr_api.g_varchar2
401: ,p_cer_attribute23 in varchar2 default hr_api.g_varchar2
402: ,p_cer_attribute24 in varchar2 default hr_api.g_varchar2
403: ,p_cer_attribute25 in varchar2 default hr_api.g_varchar2
404: ,p_cer_attribute26 in varchar2 default hr_api.g_varchar2
405: ,p_cer_attribute27 in varchar2 default hr_api.g_varchar2
406: ,p_cer_attribute28 in varchar2 default hr_api.g_varchar2
407: ,p_cer_attribute29 in varchar2 default hr_api.g_varchar2
408: ,p_cer_attribute30 in varchar2 default hr_api.g_varchar2
401: ,p_cer_attribute23 in varchar2 default hr_api.g_varchar2
402: ,p_cer_attribute24 in varchar2 default hr_api.g_varchar2
403: ,p_cer_attribute25 in varchar2 default hr_api.g_varchar2
404: ,p_cer_attribute26 in varchar2 default hr_api.g_varchar2
405: ,p_cer_attribute27 in varchar2 default hr_api.g_varchar2
406: ,p_cer_attribute28 in varchar2 default hr_api.g_varchar2
407: ,p_cer_attribute29 in varchar2 default hr_api.g_varchar2
408: ,p_cer_attribute30 in varchar2 default hr_api.g_varchar2
409: ,p_object_version_number in out nocopy number
402: ,p_cer_attribute24 in varchar2 default hr_api.g_varchar2
403: ,p_cer_attribute25 in varchar2 default hr_api.g_varchar2
404: ,p_cer_attribute26 in varchar2 default hr_api.g_varchar2
405: ,p_cer_attribute27 in varchar2 default hr_api.g_varchar2
406: ,p_cer_attribute28 in varchar2 default hr_api.g_varchar2
407: ,p_cer_attribute29 in varchar2 default hr_api.g_varchar2
408: ,p_cer_attribute30 in varchar2 default hr_api.g_varchar2
409: ,p_object_version_number in out nocopy number
410: ,p_effective_date in date
403: ,p_cer_attribute25 in varchar2 default hr_api.g_varchar2
404: ,p_cer_attribute26 in varchar2 default hr_api.g_varchar2
405: ,p_cer_attribute27 in varchar2 default hr_api.g_varchar2
406: ,p_cer_attribute28 in varchar2 default hr_api.g_varchar2
407: ,p_cer_attribute29 in varchar2 default hr_api.g_varchar2
408: ,p_cer_attribute30 in varchar2 default hr_api.g_varchar2
409: ,p_object_version_number in out nocopy number
410: ,p_effective_date in date
411: ,p_datetrack_mode in varchar2
404: ,p_cer_attribute26 in varchar2 default hr_api.g_varchar2
405: ,p_cer_attribute27 in varchar2 default hr_api.g_varchar2
406: ,p_cer_attribute28 in varchar2 default hr_api.g_varchar2
407: ,p_cer_attribute29 in varchar2 default hr_api.g_varchar2
408: ,p_cer_attribute30 in varchar2 default hr_api.g_varchar2
409: ,p_object_version_number in out nocopy number
410: ,p_effective_date in date
411: ,p_datetrack_mode in varchar2
412: ) is
480: ,p_effective_date => trunc(p_effective_date)
481: ,p_datetrack_mode => p_datetrack_mode
482: );
483: exception
484: when hr_api.cannot_find_prog_unit then
485: hr_api.cannot_find_prog_unit_error
486: (p_module_name => 'UPDATE_ELIGIBILITY_RULE'
487: ,p_hook_type => 'BP'
488: );
481: ,p_datetrack_mode => p_datetrack_mode
482: );
483: exception
484: when hr_api.cannot_find_prog_unit then
485: hr_api.cannot_find_prog_unit_error
486: (p_module_name => 'UPDATE_ELIGIBILITY_RULE'
487: ,p_hook_type => 'BP'
488: );
489: --
588: ,p_effective_date => trunc(p_effective_date)
589: ,p_datetrack_mode => p_datetrack_mode
590: );
591: exception
592: when hr_api.cannot_find_prog_unit then
593: hr_api.cannot_find_prog_unit_error
594: (p_module_name => 'UPDATE_ELIGIBILITY_RULE'
595: ,p_hook_type => 'AP'
596: );
589: ,p_datetrack_mode => p_datetrack_mode
590: );
591: exception
592: when hr_api.cannot_find_prog_unit then
593: hr_api.cannot_find_prog_unit_error
594: (p_module_name => 'UPDATE_ELIGIBILITY_RULE'
595: ,p_hook_type => 'AP'
596: );
597: --
603: --
604: -- When in validation only mode raise the Validate_Enabled exception
605: --
606: if p_validate then
607: raise hr_api.validate_enabled;
608: end if;
609: --
610: -- Set all output arguments
611: --
616: hr_utility.set_location(' Leaving:'||l_proc, 70);
617: --
618: exception
619: --
620: when hr_api.validate_enabled then
621: --
622: -- As the Validate_Enabled exception has been raised
623: -- we must rollback to the savepoint
624: --
705: ,p_effective_date => trunc(p_effective_date)
706: ,p_datetrack_mode => p_datetrack_mode
707: );
708: exception
709: when hr_api.cannot_find_prog_unit then
710: hr_api.cannot_find_prog_unit_error
711: (p_module_name => 'DELETE_ELIGIBILITY_RULE'
712: ,p_hook_type => 'BP'
713: );
706: ,p_datetrack_mode => p_datetrack_mode
707: );
708: exception
709: when hr_api.cannot_find_prog_unit then
710: hr_api.cannot_find_prog_unit_error
711: (p_module_name => 'DELETE_ELIGIBILITY_RULE'
712: ,p_hook_type => 'BP'
713: );
714: --
739: ,p_effective_date => trunc(p_effective_date)
740: ,p_datetrack_mode => p_datetrack_mode
741: );
742: exception
743: when hr_api.cannot_find_prog_unit then
744: hr_api.cannot_find_prog_unit_error
745: (p_module_name => 'DELETE_ELIGIBILITY_RULE'
746: ,p_hook_type => 'AP'
747: );
740: ,p_datetrack_mode => p_datetrack_mode
741: );
742: exception
743: when hr_api.cannot_find_prog_unit then
744: hr_api.cannot_find_prog_unit_error
745: (p_module_name => 'DELETE_ELIGIBILITY_RULE'
746: ,p_hook_type => 'AP'
747: );
748: --
857: --
858: -- When in validation only mode raise the Validate_Enabled exception
859: --
860: if p_validate then
861: raise hr_api.validate_enabled;
862: end if;
863: --
864: hr_utility.set_location(' Leaving:'||l_proc, 70);
865: --
864: hr_utility.set_location(' Leaving:'||l_proc, 70);
865: --
866: exception
867: --
868: when hr_api.validate_enabled then
869: --
870: -- As the Validate_Enabled exception has been raised
871: -- we must rollback to the savepoint
872: --