77: ,p_business_group_id => p_business_group_id
78: ,p_legislation_code => p_legislation_code
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'CREATE_ITERATIVE_RULE'
84: ,p_hook_type => 'BP'
85: );
78: ,p_legislation_code => p_legislation_code
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'CREATE_ITERATIVE_RULE'
84: ,p_hook_type => 'BP'
85: );
86: end;
123: ,p_effective_start_date => l_effective_start_date
124: ,p_effective_end_date => l_effective_end_date
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'CREATE_ITERATIVE_RULE'
130: ,p_hook_type => 'AP'
131: );
124: ,p_effective_end_date => l_effective_end_date
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'CREATE_ITERATIVE_RULE'
130: ,p_hook_type => 'AP'
131: );
132: end;
134: -- Bug no. 4038593
135: -- When in validation only mode raise the Validate_Enabled exception
136: --
137: if p_validate then
138: raise hr_api.validate_enabled;
139: end if;
140: --
141: p_iterative_rule_id := l_iterative_rule_id;
142: p_object_version_number := l_object_version_number;
144: p_effective_end_date := l_effective_end_date;
145:
146: exception
147: --
148: when hr_api.validate_enabled then
149: --
150: -- As the Validate_Enabled exception has been raised
151: -- we must rollback to the savepoint
152: --
211: ,p_effective_date in date
212: ,p_datetrack_mode in varchar2
213: ,p_iterative_rule_id in number
214: ,p_object_version_number in out nocopy number
215: ,p_element_type_id in number default hr_api.g_number
216: ,p_result_name in varchar2 default hr_api.g_varchar2
217: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
218: ,p_input_value_id in number default hr_api.g_number
219: ,p_severity_level in varchar2 default hr_api.g_varchar2
212: ,p_datetrack_mode in varchar2
213: ,p_iterative_rule_id in number
214: ,p_object_version_number in out nocopy number
215: ,p_element_type_id in number default hr_api.g_number
216: ,p_result_name in varchar2 default hr_api.g_varchar2
217: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
218: ,p_input_value_id in number default hr_api.g_number
219: ,p_severity_level in varchar2 default hr_api.g_varchar2
220: ,p_business_group_id in number default hr_api.g_number
213: ,p_iterative_rule_id in number
214: ,p_object_version_number in out nocopy number
215: ,p_element_type_id in number default hr_api.g_number
216: ,p_result_name in varchar2 default hr_api.g_varchar2
217: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
218: ,p_input_value_id in number default hr_api.g_number
219: ,p_severity_level in varchar2 default hr_api.g_varchar2
220: ,p_business_group_id in number default hr_api.g_number
221: ,p_legislation_code in varchar2 default hr_api.g_varchar2
214: ,p_object_version_number in out nocopy number
215: ,p_element_type_id in number default hr_api.g_number
216: ,p_result_name in varchar2 default hr_api.g_varchar2
217: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
218: ,p_input_value_id in number default hr_api.g_number
219: ,p_severity_level in varchar2 default hr_api.g_varchar2
220: ,p_business_group_id in number default hr_api.g_number
221: ,p_legislation_code in varchar2 default hr_api.g_varchar2
222: ,p_effective_start_date out nocopy date
215: ,p_element_type_id in number default hr_api.g_number
216: ,p_result_name in varchar2 default hr_api.g_varchar2
217: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
218: ,p_input_value_id in number default hr_api.g_number
219: ,p_severity_level in varchar2 default hr_api.g_varchar2
220: ,p_business_group_id in number default hr_api.g_number
221: ,p_legislation_code in varchar2 default hr_api.g_varchar2
222: ,p_effective_start_date out nocopy date
223: ,p_effective_end_date out nocopy date
216: ,p_result_name in varchar2 default hr_api.g_varchar2
217: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
218: ,p_input_value_id in number default hr_api.g_number
219: ,p_severity_level in varchar2 default hr_api.g_varchar2
220: ,p_business_group_id in number default hr_api.g_number
221: ,p_legislation_code in varchar2 default hr_api.g_varchar2
222: ,p_effective_start_date out nocopy date
223: ,p_effective_end_date out nocopy date
224: ) is
217: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
218: ,p_input_value_id in number default hr_api.g_number
219: ,p_severity_level in varchar2 default hr_api.g_varchar2
220: ,p_business_group_id in number default hr_api.g_number
221: ,p_legislation_code in varchar2 default hr_api.g_varchar2
222: ,p_effective_start_date out nocopy date
223: ,p_effective_end_date out nocopy date
224: ) is
225: --
262: ,p_business_group_id => p_business_group_id
263: ,p_legislation_code => p_legislation_code
264: );
265: exception
266: when hr_api.cannot_find_prog_unit then
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'UPDATE_ITERATIVE_RULE'
269: ,p_hook_type => 'BP'
270: );
263: ,p_legislation_code => p_legislation_code
264: );
265: exception
266: when hr_api.cannot_find_prog_unit then
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'UPDATE_ITERATIVE_RULE'
269: ,p_hook_type => 'BP'
270: );
271: end;
305: ,p_effective_start_date => l_effective_start_date
306: ,p_effective_end_date => l_effective_end_date
307: );
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'UPDATE_ITERATIVE_RULE'
312: ,p_hook_type => 'AP'
313: );
306: ,p_effective_end_date => l_effective_end_date
307: );
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'UPDATE_ITERATIVE_RULE'
312: ,p_hook_type => 'AP'
313: );
314: end;
318: -- Bug no. 4038593
319: -- When in validation only mode raise the Validate_Enabled exception
320: --
321: if p_validate then
322: raise hr_api.validate_enabled;
323: end if;
324: --
325: p_object_version_number := l_object_version_number;
326: p_effective_start_date := l_effective_start_date;
327: p_effective_end_date := l_effective_end_date;
328:
329: exception
330: --
331: when hr_api.validate_enabled then
332: --
333: -- As the Validate_Enabled exception has been raised
334: -- we must rollback to the savepoint
335: --
430: ,p_iterative_rule_id => p_iterative_rule_id
431: ,p_object_version_number => l_object_version_number
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'DELETE_ITERATIVE_RULE'
437: ,p_hook_type => 'BP'
438: );
431: ,p_object_version_number => l_object_version_number
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'DELETE_ITERATIVE_RULE'
437: ,p_hook_type => 'BP'
438: );
439: end;
460: ,p_effective_start_date => l_effective_start_date
461: ,p_effective_end_date => l_effective_end_date
462: );
463: exception
464: when hr_api.cannot_find_prog_unit then
465: hr_api.cannot_find_prog_unit_error
466: (p_module_name => 'DELETE_ITERATIVE_RULE'
467: ,p_hook_type => 'AP'
468: );
461: ,p_effective_end_date => l_effective_end_date
462: );
463: exception
464: when hr_api.cannot_find_prog_unit then
465: hr_api.cannot_find_prog_unit_error
466: (p_module_name => 'DELETE_ITERATIVE_RULE'
467: ,p_hook_type => 'AP'
468: );
469: end;
474: -- Bug no. 4038593
475: -- When in validation only mode raise the Validate_Enabled exception
476: --
477: if p_validate then
478: raise hr_api.validate_enabled;
479: end if;
480: --
481: p_object_version_number := l_object_version_number;
482: p_effective_start_date := l_effective_start_date;
483: p_effective_end_date := l_effective_end_date;
484: --
485: exception
486: --
487: when hr_api.validate_enabled then
488: --
489: -- As the Validate_Enabled exception has been raised
490: -- we must rollback to the savepoint
491: --