161: ,p_effective_date => trunc(p_effective_date));
162: --
163: exception
164: --
165: when hr_api.cannot_find_prog_unit then
166: hr_api.cannot_find_prog_unit_error
167: (p_module_name => 'CREATE_clpse_lf_evt'
168: ,p_hook_type => 'BP');
169: --
162: --
163: exception
164: --
165: when hr_api.cannot_find_prog_unit then
166: hr_api.cannot_find_prog_unit_error
167: (p_module_name => 'CREATE_clpse_lf_evt'
168: ,p_hook_type => 'BP');
169: --
170: -- End of API User Hook for the before hook of create_clpse_lf_evt
306: ,p_effective_date => trunc(p_effective_date));
307: --
308: exception
309: --
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'CREATE_clpse_lf_evt'
313: ,p_hook_type => 'AP');
314: --
307: --
308: exception
309: --
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'CREATE_clpse_lf_evt'
313: ,p_hook_type => 'AP');
314: --
315: -- End of API User Hook for the after hook of create_clpse_lf_evt
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: --
372: (p_validate in boolean default false
373: ,p_clpse_lf_evt_id in number
374: ,p_effective_start_date out nocopy date
375: ,p_effective_end_date out nocopy date
376: ,p_business_group_id in number default hr_api.g_number
377: ,p_seq in number default hr_api.g_number
378: ,p_ler1_id in number default hr_api.g_number
379: ,p_bool1_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler2_id in number default hr_api.g_number
373: ,p_clpse_lf_evt_id in number
374: ,p_effective_start_date out nocopy date
375: ,p_effective_end_date out nocopy date
376: ,p_business_group_id in number default hr_api.g_number
377: ,p_seq in number default hr_api.g_number
378: ,p_ler1_id in number default hr_api.g_number
379: ,p_bool1_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler2_id in number default hr_api.g_number
381: ,p_bool2_cd in varchar2 default hr_api.g_varchar2
374: ,p_effective_start_date out nocopy date
375: ,p_effective_end_date out nocopy date
376: ,p_business_group_id in number default hr_api.g_number
377: ,p_seq in number default hr_api.g_number
378: ,p_ler1_id in number default hr_api.g_number
379: ,p_bool1_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler2_id in number default hr_api.g_number
381: ,p_bool2_cd in varchar2 default hr_api.g_varchar2
382: ,p_ler3_id in number default hr_api.g_number
375: ,p_effective_end_date out nocopy date
376: ,p_business_group_id in number default hr_api.g_number
377: ,p_seq in number default hr_api.g_number
378: ,p_ler1_id in number default hr_api.g_number
379: ,p_bool1_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler2_id in number default hr_api.g_number
381: ,p_bool2_cd in varchar2 default hr_api.g_varchar2
382: ,p_ler3_id in number default hr_api.g_number
383: ,p_bool3_cd in varchar2 default hr_api.g_varchar2
376: ,p_business_group_id in number default hr_api.g_number
377: ,p_seq in number default hr_api.g_number
378: ,p_ler1_id in number default hr_api.g_number
379: ,p_bool1_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler2_id in number default hr_api.g_number
381: ,p_bool2_cd in varchar2 default hr_api.g_varchar2
382: ,p_ler3_id in number default hr_api.g_number
383: ,p_bool3_cd in varchar2 default hr_api.g_varchar2
384: ,p_ler4_id in number default hr_api.g_number
377: ,p_seq in number default hr_api.g_number
378: ,p_ler1_id in number default hr_api.g_number
379: ,p_bool1_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler2_id in number default hr_api.g_number
381: ,p_bool2_cd in varchar2 default hr_api.g_varchar2
382: ,p_ler3_id in number default hr_api.g_number
383: ,p_bool3_cd in varchar2 default hr_api.g_varchar2
384: ,p_ler4_id in number default hr_api.g_number
385: ,p_bool4_cd in varchar2 default hr_api.g_varchar2
378: ,p_ler1_id in number default hr_api.g_number
379: ,p_bool1_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler2_id in number default hr_api.g_number
381: ,p_bool2_cd in varchar2 default hr_api.g_varchar2
382: ,p_ler3_id in number default hr_api.g_number
383: ,p_bool3_cd in varchar2 default hr_api.g_varchar2
384: ,p_ler4_id in number default hr_api.g_number
385: ,p_bool4_cd in varchar2 default hr_api.g_varchar2
386: ,p_ler5_id in number default hr_api.g_number
379: ,p_bool1_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler2_id in number default hr_api.g_number
381: ,p_bool2_cd in varchar2 default hr_api.g_varchar2
382: ,p_ler3_id in number default hr_api.g_number
383: ,p_bool3_cd in varchar2 default hr_api.g_varchar2
384: ,p_ler4_id in number default hr_api.g_number
385: ,p_bool4_cd in varchar2 default hr_api.g_varchar2
386: ,p_ler5_id in number default hr_api.g_number
387: ,p_bool5_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler2_id in number default hr_api.g_number
381: ,p_bool2_cd in varchar2 default hr_api.g_varchar2
382: ,p_ler3_id in number default hr_api.g_number
383: ,p_bool3_cd in varchar2 default hr_api.g_varchar2
384: ,p_ler4_id in number default hr_api.g_number
385: ,p_bool4_cd in varchar2 default hr_api.g_varchar2
386: ,p_ler5_id in number default hr_api.g_number
387: ,p_bool5_cd in varchar2 default hr_api.g_varchar2
388: ,p_ler6_id in number default hr_api.g_number
381: ,p_bool2_cd in varchar2 default hr_api.g_varchar2
382: ,p_ler3_id in number default hr_api.g_number
383: ,p_bool3_cd in varchar2 default hr_api.g_varchar2
384: ,p_ler4_id in number default hr_api.g_number
385: ,p_bool4_cd in varchar2 default hr_api.g_varchar2
386: ,p_ler5_id in number default hr_api.g_number
387: ,p_bool5_cd in varchar2 default hr_api.g_varchar2
388: ,p_ler6_id in number default hr_api.g_number
389: ,p_bool6_cd in varchar2 default hr_api.g_varchar2
382: ,p_ler3_id in number default hr_api.g_number
383: ,p_bool3_cd in varchar2 default hr_api.g_varchar2
384: ,p_ler4_id in number default hr_api.g_number
385: ,p_bool4_cd in varchar2 default hr_api.g_varchar2
386: ,p_ler5_id in number default hr_api.g_number
387: ,p_bool5_cd in varchar2 default hr_api.g_varchar2
388: ,p_ler6_id in number default hr_api.g_number
389: ,p_bool6_cd in varchar2 default hr_api.g_varchar2
390: ,p_ler7_id in number default hr_api.g_number
383: ,p_bool3_cd in varchar2 default hr_api.g_varchar2
384: ,p_ler4_id in number default hr_api.g_number
385: ,p_bool4_cd in varchar2 default hr_api.g_varchar2
386: ,p_ler5_id in number default hr_api.g_number
387: ,p_bool5_cd in varchar2 default hr_api.g_varchar2
388: ,p_ler6_id in number default hr_api.g_number
389: ,p_bool6_cd in varchar2 default hr_api.g_varchar2
390: ,p_ler7_id in number default hr_api.g_number
391: ,p_bool7_cd in varchar2 default hr_api.g_varchar2
384: ,p_ler4_id in number default hr_api.g_number
385: ,p_bool4_cd in varchar2 default hr_api.g_varchar2
386: ,p_ler5_id in number default hr_api.g_number
387: ,p_bool5_cd in varchar2 default hr_api.g_varchar2
388: ,p_ler6_id in number default hr_api.g_number
389: ,p_bool6_cd in varchar2 default hr_api.g_varchar2
390: ,p_ler7_id in number default hr_api.g_number
391: ,p_bool7_cd in varchar2 default hr_api.g_varchar2
392: ,p_ler8_id in number default hr_api.g_number
385: ,p_bool4_cd in varchar2 default hr_api.g_varchar2
386: ,p_ler5_id in number default hr_api.g_number
387: ,p_bool5_cd in varchar2 default hr_api.g_varchar2
388: ,p_ler6_id in number default hr_api.g_number
389: ,p_bool6_cd in varchar2 default hr_api.g_varchar2
390: ,p_ler7_id in number default hr_api.g_number
391: ,p_bool7_cd in varchar2 default hr_api.g_varchar2
392: ,p_ler8_id in number default hr_api.g_number
393: ,p_bool8_cd in varchar2 default hr_api.g_varchar2
386: ,p_ler5_id in number default hr_api.g_number
387: ,p_bool5_cd in varchar2 default hr_api.g_varchar2
388: ,p_ler6_id in number default hr_api.g_number
389: ,p_bool6_cd in varchar2 default hr_api.g_varchar2
390: ,p_ler7_id in number default hr_api.g_number
391: ,p_bool7_cd in varchar2 default hr_api.g_varchar2
392: ,p_ler8_id in number default hr_api.g_number
393: ,p_bool8_cd in varchar2 default hr_api.g_varchar2
394: ,p_ler9_id in number default hr_api.g_number
387: ,p_bool5_cd in varchar2 default hr_api.g_varchar2
388: ,p_ler6_id in number default hr_api.g_number
389: ,p_bool6_cd in varchar2 default hr_api.g_varchar2
390: ,p_ler7_id in number default hr_api.g_number
391: ,p_bool7_cd in varchar2 default hr_api.g_varchar2
392: ,p_ler8_id in number default hr_api.g_number
393: ,p_bool8_cd in varchar2 default hr_api.g_varchar2
394: ,p_ler9_id in number default hr_api.g_number
395: ,p_bool9_cd in varchar2 default hr_api.g_varchar2
388: ,p_ler6_id in number default hr_api.g_number
389: ,p_bool6_cd in varchar2 default hr_api.g_varchar2
390: ,p_ler7_id in number default hr_api.g_number
391: ,p_bool7_cd in varchar2 default hr_api.g_varchar2
392: ,p_ler8_id in number default hr_api.g_number
393: ,p_bool8_cd in varchar2 default hr_api.g_varchar2
394: ,p_ler9_id in number default hr_api.g_number
395: ,p_bool9_cd in varchar2 default hr_api.g_varchar2
396: ,p_ler10_id in number default hr_api.g_number
389: ,p_bool6_cd in varchar2 default hr_api.g_varchar2
390: ,p_ler7_id in number default hr_api.g_number
391: ,p_bool7_cd in varchar2 default hr_api.g_varchar2
392: ,p_ler8_id in number default hr_api.g_number
393: ,p_bool8_cd in varchar2 default hr_api.g_varchar2
394: ,p_ler9_id in number default hr_api.g_number
395: ,p_bool9_cd in varchar2 default hr_api.g_varchar2
396: ,p_ler10_id in number default hr_api.g_number
397: ,p_eval_cd in varchar2 default hr_api.g_varchar2
390: ,p_ler7_id in number default hr_api.g_number
391: ,p_bool7_cd in varchar2 default hr_api.g_varchar2
392: ,p_ler8_id in number default hr_api.g_number
393: ,p_bool8_cd in varchar2 default hr_api.g_varchar2
394: ,p_ler9_id in number default hr_api.g_number
395: ,p_bool9_cd in varchar2 default hr_api.g_varchar2
396: ,p_ler10_id in number default hr_api.g_number
397: ,p_eval_cd in varchar2 default hr_api.g_varchar2
398: ,p_eval_rl in number default hr_api.g_number
391: ,p_bool7_cd in varchar2 default hr_api.g_varchar2
392: ,p_ler8_id in number default hr_api.g_number
393: ,p_bool8_cd in varchar2 default hr_api.g_varchar2
394: ,p_ler9_id in number default hr_api.g_number
395: ,p_bool9_cd in varchar2 default hr_api.g_varchar2
396: ,p_ler10_id in number default hr_api.g_number
397: ,p_eval_cd in varchar2 default hr_api.g_varchar2
398: ,p_eval_rl in number default hr_api.g_number
399: ,p_tlrnc_dys_num in number default hr_api.g_number
392: ,p_ler8_id in number default hr_api.g_number
393: ,p_bool8_cd in varchar2 default hr_api.g_varchar2
394: ,p_ler9_id in number default hr_api.g_number
395: ,p_bool9_cd in varchar2 default hr_api.g_varchar2
396: ,p_ler10_id in number default hr_api.g_number
397: ,p_eval_cd in varchar2 default hr_api.g_varchar2
398: ,p_eval_rl in number default hr_api.g_number
399: ,p_tlrnc_dys_num in number default hr_api.g_number
400: ,p_eval_ler_id in number default hr_api.g_number
393: ,p_bool8_cd in varchar2 default hr_api.g_varchar2
394: ,p_ler9_id in number default hr_api.g_number
395: ,p_bool9_cd in varchar2 default hr_api.g_varchar2
396: ,p_ler10_id in number default hr_api.g_number
397: ,p_eval_cd in varchar2 default hr_api.g_varchar2
398: ,p_eval_rl in number default hr_api.g_number
399: ,p_tlrnc_dys_num in number default hr_api.g_number
400: ,p_eval_ler_id in number default hr_api.g_number
401: ,p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2
394: ,p_ler9_id in number default hr_api.g_number
395: ,p_bool9_cd in varchar2 default hr_api.g_varchar2
396: ,p_ler10_id in number default hr_api.g_number
397: ,p_eval_cd in varchar2 default hr_api.g_varchar2
398: ,p_eval_rl in number default hr_api.g_number
399: ,p_tlrnc_dys_num in number default hr_api.g_number
400: ,p_eval_ler_id in number default hr_api.g_number
401: ,p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2
402: ,p_eval_ler_det_rl in number default hr_api.g_number
395: ,p_bool9_cd in varchar2 default hr_api.g_varchar2
396: ,p_ler10_id in number default hr_api.g_number
397: ,p_eval_cd in varchar2 default hr_api.g_varchar2
398: ,p_eval_rl in number default hr_api.g_number
399: ,p_tlrnc_dys_num in number default hr_api.g_number
400: ,p_eval_ler_id in number default hr_api.g_number
401: ,p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2
402: ,p_eval_ler_det_rl in number default hr_api.g_number
403: ,p_clp_attribute_category in varchar2 default hr_api.g_varchar2
396: ,p_ler10_id in number default hr_api.g_number
397: ,p_eval_cd in varchar2 default hr_api.g_varchar2
398: ,p_eval_rl in number default hr_api.g_number
399: ,p_tlrnc_dys_num in number default hr_api.g_number
400: ,p_eval_ler_id in number default hr_api.g_number
401: ,p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2
402: ,p_eval_ler_det_rl in number default hr_api.g_number
403: ,p_clp_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_clp_attribute1 in varchar2 default hr_api.g_varchar2
397: ,p_eval_cd in varchar2 default hr_api.g_varchar2
398: ,p_eval_rl in number default hr_api.g_number
399: ,p_tlrnc_dys_num in number default hr_api.g_number
400: ,p_eval_ler_id in number default hr_api.g_number
401: ,p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2
402: ,p_eval_ler_det_rl in number default hr_api.g_number
403: ,p_clp_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_clp_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_clp_attribute2 in varchar2 default hr_api.g_varchar2
398: ,p_eval_rl in number default hr_api.g_number
399: ,p_tlrnc_dys_num in number default hr_api.g_number
400: ,p_eval_ler_id in number default hr_api.g_number
401: ,p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2
402: ,p_eval_ler_det_rl in number default hr_api.g_number
403: ,p_clp_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_clp_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_clp_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_clp_attribute3 in varchar2 default hr_api.g_varchar2
399: ,p_tlrnc_dys_num in number default hr_api.g_number
400: ,p_eval_ler_id in number default hr_api.g_number
401: ,p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2
402: ,p_eval_ler_det_rl in number default hr_api.g_number
403: ,p_clp_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_clp_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_clp_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_clp_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_clp_attribute4 in varchar2 default hr_api.g_varchar2
400: ,p_eval_ler_id in number default hr_api.g_number
401: ,p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2
402: ,p_eval_ler_det_rl in number default hr_api.g_number
403: ,p_clp_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_clp_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_clp_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_clp_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_clp_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_clp_attribute5 in varchar2 default hr_api.g_varchar2
401: ,p_eval_ler_det_cd in varchar2 default hr_api.g_varchar2
402: ,p_eval_ler_det_rl in number default hr_api.g_number
403: ,p_clp_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_clp_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_clp_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_clp_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_clp_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_clp_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_clp_attribute6 in varchar2 default hr_api.g_varchar2
402: ,p_eval_ler_det_rl in number default hr_api.g_number
403: ,p_clp_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_clp_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_clp_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_clp_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_clp_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_clp_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_clp_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_clp_attribute7 in varchar2 default hr_api.g_varchar2
403: ,p_clp_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_clp_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_clp_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_clp_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_clp_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_clp_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_clp_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_clp_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_clp_attribute8 in varchar2 default hr_api.g_varchar2
404: ,p_clp_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_clp_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_clp_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_clp_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_clp_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_clp_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_clp_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_clp_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_clp_attribute9 in varchar2 default hr_api.g_varchar2
405: ,p_clp_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_clp_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_clp_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_clp_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_clp_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_clp_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_clp_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_clp_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_clp_attribute10 in varchar2 default hr_api.g_varchar2
406: ,p_clp_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_clp_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_clp_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_clp_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_clp_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_clp_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_clp_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_clp_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_clp_attribute11 in varchar2 default hr_api.g_varchar2
407: ,p_clp_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_clp_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_clp_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_clp_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_clp_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_clp_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_clp_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_clp_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_clp_attribute12 in varchar2 default hr_api.g_varchar2
408: ,p_clp_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_clp_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_clp_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_clp_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_clp_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_clp_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_clp_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_clp_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_clp_attribute13 in varchar2 default hr_api.g_varchar2
409: ,p_clp_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_clp_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_clp_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_clp_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_clp_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_clp_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_clp_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_clp_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_clp_attribute14 in varchar2 default hr_api.g_varchar2
410: ,p_clp_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_clp_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_clp_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_clp_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_clp_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_clp_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_clp_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_clp_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_clp_attribute15 in varchar2 default hr_api.g_varchar2
411: ,p_clp_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_clp_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_clp_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_clp_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_clp_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_clp_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_clp_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_clp_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_clp_attribute16 in varchar2 default hr_api.g_varchar2
412: ,p_clp_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_clp_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_clp_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_clp_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_clp_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_clp_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_clp_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_clp_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_clp_attribute17 in varchar2 default hr_api.g_varchar2
413: ,p_clp_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_clp_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_clp_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_clp_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_clp_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_clp_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_clp_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_clp_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_clp_attribute18 in varchar2 default hr_api.g_varchar2
414: ,p_clp_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_clp_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_clp_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_clp_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_clp_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_clp_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_clp_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_clp_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_clp_attribute19 in varchar2 default hr_api.g_varchar2
415: ,p_clp_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_clp_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_clp_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_clp_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_clp_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_clp_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_clp_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_clp_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_clp_attribute20 in varchar2 default hr_api.g_varchar2
416: ,p_clp_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_clp_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_clp_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_clp_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_clp_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_clp_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_clp_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_clp_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_clp_attribute21 in varchar2 default hr_api.g_varchar2
417: ,p_clp_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_clp_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_clp_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_clp_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_clp_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_clp_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_clp_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_clp_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_clp_attribute22 in varchar2 default hr_api.g_varchar2
418: ,p_clp_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_clp_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_clp_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_clp_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_clp_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_clp_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_clp_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_clp_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_clp_attribute23 in varchar2 default hr_api.g_varchar2
419: ,p_clp_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_clp_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_clp_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_clp_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_clp_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_clp_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_clp_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_clp_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_clp_attribute24 in varchar2 default hr_api.g_varchar2
420: ,p_clp_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_clp_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_clp_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_clp_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_clp_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_clp_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_clp_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_clp_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_clp_attribute25 in varchar2 default hr_api.g_varchar2
421: ,p_clp_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_clp_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_clp_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_clp_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_clp_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_clp_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_clp_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_clp_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_clp_attribute26 in varchar2 default hr_api.g_varchar2
422: ,p_clp_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_clp_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_clp_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_clp_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_clp_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_clp_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_clp_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_clp_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_clp_attribute27 in varchar2 default hr_api.g_varchar2
423: ,p_clp_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_clp_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_clp_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_clp_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_clp_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_clp_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_clp_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_clp_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_clp_attribute28 in varchar2 default hr_api.g_varchar2
424: ,p_clp_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_clp_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_clp_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_clp_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_clp_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_clp_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_clp_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_clp_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_clp_attribute29 in varchar2 default hr_api.g_varchar2
425: ,p_clp_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_clp_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_clp_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_clp_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_clp_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_clp_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_clp_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_clp_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_clp_attribute30 in varchar2 default hr_api.g_varchar2
426: ,p_clp_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_clp_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_clp_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_clp_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_clp_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_clp_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_clp_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_clp_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_object_version_number in out nocopy number
427: ,p_clp_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_clp_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_clp_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_clp_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_clp_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_clp_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_clp_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_object_version_number in out nocopy number
435: ,p_effective_date in date
428: ,p_clp_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_clp_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_clp_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_clp_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_clp_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_clp_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_object_version_number in out nocopy number
435: ,p_effective_date in date
436: ,p_datetrack_mode in varchar2) is
429: ,p_clp_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_clp_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_clp_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_clp_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_clp_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_object_version_number in out nocopy number
435: ,p_effective_date in date
436: ,p_datetrack_mode in varchar2) is
437: --
525: ,p_datetrack_mode => p_datetrack_mode);
526: --
527: exception
528: --
529: when hr_api.cannot_find_prog_unit then
530: hr_api.cannot_find_prog_unit_error
531: (p_module_name => 'UPDATE_clpse_lf_evt'
532: ,p_hook_type => 'BP');
533: --
526: --
527: exception
528: --
529: when hr_api.cannot_find_prog_unit then
530: hr_api.cannot_find_prog_unit_error
531: (p_module_name => 'UPDATE_clpse_lf_evt'
532: ,p_hook_type => 'BP');
533: --
534: -- End of API User Hook for the before hook of update_clpse_lf_evt
672: ,p_datetrack_mode => p_datetrack_mode);
673: --
674: exception
675: --
676: when hr_api.cannot_find_prog_unit then
677: hr_api.cannot_find_prog_unit_error
678: (p_module_name => 'UPDATE_clpse_lf_evt'
679: ,p_hook_type => 'AP');
680: --
673: --
674: exception
675: --
676: when hr_api.cannot_find_prog_unit then
677: hr_api.cannot_find_prog_unit_error
678: (p_module_name => 'UPDATE_clpse_lf_evt'
679: ,p_hook_type => 'AP');
680: --
681: -- End of API User Hook for the after hook of update_clpse_lf_evt
686: --
687: -- When in validation only mode raise the Validate_Enabled exception
688: --
689: if p_validate then
690: raise hr_api.validate_enabled;
691: end if;
692: --
693: -- Set all output arguments
694: --
699: hr_utility.set_location(' Leaving:'||l_proc, 70);
700: --
701: exception
702: --
703: when hr_api.validate_enabled then
704: --
705: -- As the Validate_Enabled exception has been raised
706: -- we must rollback to the savepoint
707: --
771: ,p_datetrack_mode => p_datetrack_mode);
772: --
773: exception
774: --
775: when hr_api.cannot_find_prog_unit then
776: hr_api.cannot_find_prog_unit_error
777: (p_module_name => 'DELETE_clpse_lf_evt'
778: ,p_hook_type => 'BP');
779: --
772: --
773: exception
774: --
775: when hr_api.cannot_find_prog_unit then
776: hr_api.cannot_find_prog_unit_error
777: (p_module_name => 'DELETE_clpse_lf_evt'
778: ,p_hook_type => 'BP');
779: --
780: -- End of API User Hook for the before hook of delete_clpse_lf_evt
802: ,p_datetrack_mode => p_datetrack_mode);
803: --
804: exception
805: --
806: when hr_api.cannot_find_prog_unit then
807: hr_api.cannot_find_prog_unit_error
808: (p_module_name => 'DELETE_clpse_lf_evt'
809: ,p_hook_type => 'AP');
810: --
803: --
804: exception
805: --
806: when hr_api.cannot_find_prog_unit then
807: hr_api.cannot_find_prog_unit_error
808: (p_module_name => 'DELETE_clpse_lf_evt'
809: ,p_hook_type => 'AP');
810: --
811: -- End of API User Hook for the after hook of delete_clpse_lf_evt
816: --
817: -- When in validation only mode raise the Validate_Enabled exception
818: --
819: if p_validate then
820: raise hr_api.validate_enabled;
821: end if;
822: --
823: hr_utility.set_location(' Leaving:'||l_proc, 70);
824: --
823: hr_utility.set_location(' Leaving:'||l_proc, 70);
824: --
825: exception
826: --
827: when hr_api.validate_enabled then
828: --
829: -- As the Validate_Enabled exception has been raised
830: -- we must rollback to the savepoint
831: --