163: ,p_time_access_calc_rule1 => p_time_access_calc_rule1
164: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
165: );
166: exception
167: when hr_api.cannot_find_prog_unit then
168: hr_api.cannot_find_prog_unit_error
169: (
170: p_module_name => 'CREATE_eligy_criteria'
171: ,p_hook_type => 'BP'
164: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
165: );
166: exception
167: when hr_api.cannot_find_prog_unit then
168: hr_api.cannot_find_prog_unit_error
169: (
170: p_module_name => 'CREATE_eligy_criteria'
171: ,p_hook_type => 'BP'
172: );
312: ,p_time_access_calc_rule1 => p_time_access_calc_rule1
313: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'CREATE_eligy_criteria'
319: ,p_hook_type => 'AP'
320: );
313: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'CREATE_eligy_criteria'
319: ,p_hook_type => 'AP'
320: );
321: --
327: --
328: -- When in validation only mode raise the Validate_Enabled exception
329: --
330: if p_validate then
331: raise hr_api.validate_enabled;
332: end if;
333: --
334: -- Set all output arguments
335: --
339:
340: --
341: exception
342: --
343: when hr_api.validate_enabled then
344: --
345: -- As the Validate_Enabled exception has been raised
346: -- we must rollback to the savepoint
347: --
372: procedure update_eligy_criteria
373: (
374: p_validate in boolean default false
375: ,p_eligy_criteria_id in number
376: ,p_name in varchar2 default hr_api.g_varchar2
377: ,p_short_code in varchar2 default hr_api.g_varchar2
378: ,p_description in varchar2 default hr_api.g_varchar2
379: ,p_criteria_type in varchar2 default hr_api.g_varchar2
380: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
373: (
374: p_validate in boolean default false
375: ,p_eligy_criteria_id in number
376: ,p_name in varchar2 default hr_api.g_varchar2
377: ,p_short_code in varchar2 default hr_api.g_varchar2
378: ,p_description in varchar2 default hr_api.g_varchar2
379: ,p_criteria_type in varchar2 default hr_api.g_varchar2
380: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
381: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
374: p_validate in boolean default false
375: ,p_eligy_criteria_id in number
376: ,p_name in varchar2 default hr_api.g_varchar2
377: ,p_short_code in varchar2 default hr_api.g_varchar2
378: ,p_description in varchar2 default hr_api.g_varchar2
379: ,p_criteria_type in varchar2 default hr_api.g_varchar2
380: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
381: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
382: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
375: ,p_eligy_criteria_id in number
376: ,p_name in varchar2 default hr_api.g_varchar2
377: ,p_short_code in varchar2 default hr_api.g_varchar2
378: ,p_description in varchar2 default hr_api.g_varchar2
379: ,p_criteria_type in varchar2 default hr_api.g_varchar2
380: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
381: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
382: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
383: ,p_col1_value_set_id in number default hr_api.g_number
376: ,p_name in varchar2 default hr_api.g_varchar2
377: ,p_short_code in varchar2 default hr_api.g_varchar2
378: ,p_description in varchar2 default hr_api.g_varchar2
379: ,p_criteria_type in varchar2 default hr_api.g_varchar2
380: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
381: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
382: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
383: ,p_col1_value_set_id in number default hr_api.g_number
384: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
377: ,p_short_code in varchar2 default hr_api.g_varchar2
378: ,p_description in varchar2 default hr_api.g_varchar2
379: ,p_criteria_type in varchar2 default hr_api.g_varchar2
380: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
381: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
382: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
383: ,p_col1_value_set_id in number default hr_api.g_number
384: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
385: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
378: ,p_description in varchar2 default hr_api.g_varchar2
379: ,p_criteria_type in varchar2 default hr_api.g_varchar2
380: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
381: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
382: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
383: ,p_col1_value_set_id in number default hr_api.g_number
384: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
385: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
386: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
379: ,p_criteria_type in varchar2 default hr_api.g_varchar2
380: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
381: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
382: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
383: ,p_col1_value_set_id in number default hr_api.g_number
384: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
385: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
386: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
387: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
380: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
381: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
382: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
383: ,p_col1_value_set_id in number default hr_api.g_number
384: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
385: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
386: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
387: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
388: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
381: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
382: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
383: ,p_col1_value_set_id in number default hr_api.g_number
384: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
385: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
386: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
387: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
388: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
389: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
382: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
383: ,p_col1_value_set_id in number default hr_api.g_number
384: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
385: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
386: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
387: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
388: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
389: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
390: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
383: ,p_col1_value_set_id in number default hr_api.g_number
384: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
385: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
386: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
387: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
388: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
389: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
390: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
391: ,p_col2_value_set_id in number default hr_api.g_number
384: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
385: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
386: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
387: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
388: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
389: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
390: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
391: ,p_col2_value_set_id in number default hr_api.g_number
392: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
385: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
386: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
387: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
388: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
389: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
390: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
391: ,p_col2_value_set_id in number default hr_api.g_number
392: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
393: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
386: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
387: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
388: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
389: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
390: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
391: ,p_col2_value_set_id in number default hr_api.g_number
392: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
393: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
394: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
387: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
388: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
389: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
390: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
391: ,p_col2_value_set_id in number default hr_api.g_number
392: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
393: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
394: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
395: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
388: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
389: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
390: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
391: ,p_col2_value_set_id in number default hr_api.g_number
392: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
393: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
394: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
395: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
396: ,p_access_calc_rule in number default hr_api.g_number
389: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
390: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
391: ,p_col2_value_set_id in number default hr_api.g_number
392: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
393: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
394: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
395: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
396: ,p_access_calc_rule in number default hr_api.g_number
397: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
390: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
391: ,p_col2_value_set_id in number default hr_api.g_number
392: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
393: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
394: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
395: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
396: ,p_access_calc_rule in number default hr_api.g_number
397: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
398: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
391: ,p_col2_value_set_id in number default hr_api.g_number
392: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
393: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
394: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
395: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
396: ,p_access_calc_rule in number default hr_api.g_number
397: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
398: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
399: ,p_business_group_id in number default hr_api.g_number
392: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
393: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
394: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
395: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
396: ,p_access_calc_rule in number default hr_api.g_number
397: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
398: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
399: ,p_business_group_id in number default hr_api.g_number
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
393: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
394: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
395: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
396: ,p_access_calc_rule in number default hr_api.g_number
397: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
398: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
399: ,p_business_group_id in number default hr_api.g_number
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
394: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
395: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
396: ,p_access_calc_rule in number default hr_api.g_number
397: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
398: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
399: ,p_business_group_id in number default hr_api.g_number
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
395: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
396: ,p_access_calc_rule in number default hr_api.g_number
397: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
398: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
399: ,p_business_group_id in number default hr_api.g_number
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
396: ,p_access_calc_rule in number default hr_api.g_number
397: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
398: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
399: ,p_business_group_id in number default hr_api.g_number
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
397: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
398: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
399: ,p_business_group_id in number default hr_api.g_number
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
398: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
399: ,p_business_group_id in number default hr_api.g_number
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
399: ,p_business_group_id in number default hr_api.g_number
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
401: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
402: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
403: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
404: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
405: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
406: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
407: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
408: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
409: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
410: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
411: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
412: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
413: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
414: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
415: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
416: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
417: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
418: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
419: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
420: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
421: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
422: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
423: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
424: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_object_version_number in out nocopy number
425: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_object_version_number in out nocopy number
433: ,p_effective_date in date
426: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_object_version_number in out nocopy number
433: ,p_effective_date in date
434: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
427: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_object_version_number in out nocopy number
433: ,p_effective_date in date
434: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
435: ,p_access_calc_rule2 in number default hr_api.g_number
430: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_object_version_number in out nocopy number
433: ,p_effective_date in date
434: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
435: ,p_access_calc_rule2 in number default hr_api.g_number
436: ,p_time_access_calc_rule1 in number default hr_api.g_number
437: ,p_time_access_calc_rule2 in number default hr_api.g_number
438: ) is
431: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_object_version_number in out nocopy number
433: ,p_effective_date in date
434: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
435: ,p_access_calc_rule2 in number default hr_api.g_number
436: ,p_time_access_calc_rule1 in number default hr_api.g_number
437: ,p_time_access_calc_rule2 in number default hr_api.g_number
438: ) is
439: --
432: ,p_object_version_number in out nocopy number
433: ,p_effective_date in date
434: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
435: ,p_access_calc_rule2 in number default hr_api.g_number
436: ,p_time_access_calc_rule1 in number default hr_api.g_number
437: ,p_time_access_calc_rule2 in number default hr_api.g_number
438: ) is
439: --
440: -- Declare cursors and local variables
433: ,p_effective_date in date
434: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
435: ,p_access_calc_rule2 in number default hr_api.g_number
436: ,p_time_access_calc_rule1 in number default hr_api.g_number
437: ,p_time_access_calc_rule2 in number default hr_api.g_number
438: ) is
439: --
440: -- Declare cursors and local variables
441: --
531: ,p_time_access_calc_rule1 => p_time_access_calc_rule1
532: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
533: );
534: exception
535: when hr_api.cannot_find_prog_unit then
536: hr_api.cannot_find_prog_unit_error
537: (p_module_name => 'UPDATE_eligy_criteria'
538: ,p_hook_type => 'BP'
539: );
532: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
533: );
534: exception
535: when hr_api.cannot_find_prog_unit then
536: hr_api.cannot_find_prog_unit_error
537: (p_module_name => 'UPDATE_eligy_criteria'
538: ,p_hook_type => 'BP'
539: );
540: --
679: ,p_time_access_calc_rule1 => p_time_access_calc_rule1
680: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
681: );
682: exception
683: when hr_api.cannot_find_prog_unit then
684: hr_api.cannot_find_prog_unit_error
685: (p_module_name => 'UPDATE_eligy_criteria'
686: ,p_hook_type => 'AP'
687: );
680: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
681: );
682: exception
683: when hr_api.cannot_find_prog_unit then
684: hr_api.cannot_find_prog_unit_error
685: (p_module_name => 'UPDATE_eligy_criteria'
686: ,p_hook_type => 'AP'
687: );
688: --
694: --
695: -- When in validation only mode raise the Validate_Enabled exception
696: --
697: if p_validate then
698: raise hr_api.validate_enabled;
699: end if;
700: --
701: -- Set all output arguments
702: --
705:
706: --
707: exception
708: --
709: when hr_api.validate_enabled then
710: --
711: -- As the Validate_Enabled exception has been raised
712: -- we must rollback to the savepoint
713: --
768: ,p_object_version_number => p_object_version_number
769: ,p_effective_date => trunc(p_effective_date)
770: );
771: exception
772: when hr_api.cannot_find_prog_unit then
773: hr_api.cannot_find_prog_unit_error
774: (p_module_name => 'DELETE_eligy_criteria'
775: ,p_hook_type => 'BP'
776: );
769: ,p_effective_date => trunc(p_effective_date)
770: );
771: exception
772: when hr_api.cannot_find_prog_unit then
773: hr_api.cannot_find_prog_unit_error
774: (p_module_name => 'DELETE_eligy_criteria'
775: ,p_hook_type => 'BP'
776: );
777: --
796: ,p_object_version_number => l_object_version_number
797: ,p_effective_date => trunc(p_effective_date)
798: );
799: exception
800: when hr_api.cannot_find_prog_unit then
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'DELETE_eligy_criteria'
803: ,p_hook_type => 'AP'
804: );
797: ,p_effective_date => trunc(p_effective_date)
798: );
799: exception
800: when hr_api.cannot_find_prog_unit then
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'DELETE_eligy_criteria'
803: ,p_hook_type => 'AP'
804: );
805: --
811: --
812: -- When in validation only mode raise the Validate_Enabled exception
813: --
814: if p_validate then
815: raise hr_api.validate_enabled;
816: end if;
817: --
818:
819: --
818:
819: --
820: exception
821: --
822: when hr_api.validate_enabled then
823: --
824: -- As the Validate_Enabled exception has been raised
825: -- we must rollback to the savepoint
826: --