8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_exception_group >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_exception_group
12: (p_validate in number default hr_api.g_false_num
13: ,p_exception_group_name in varchar2 default null
14: ,p_exception_report_id in number
15: ,p_legislation_code in varchar2 default null
16: ,p_business_group_id in number default null
45: --
46: -- Convert constant values to their corresponding boolean value
47: --
48: l_validate :=
49: hr_api.constant_to_boolean
50: (p_constant_value => p_validate);
51: --
52: -- Register Surrogate ID or user key values
53: --
120: -- ----------------------------------------------------------------------------
121: -- |------------------------< delete_exception_group >------------------------|
122: -- ----------------------------------------------------------------------------
123: PROCEDURE delete_exception_group
124: (p_validate in number default hr_api.g_false_num
125: ,p_exception_group_id in number
126: ,p_object_version_number in number
127: ,p_return_status out nocopy varchar2
128: ) is
150: --
151: -- Convert constant values to their corresponding boolean value
152: --
153: l_validate :=
154: hr_api.constant_to_boolean
155: (p_constant_value => p_validate);
156: --
157: -- Register Surrogate ID or user key values
158: --
214: -- ----------------------------------------------------------------------------
215: -- |------------------------< update_exception_group >------------------------|
216: -- ----------------------------------------------------------------------------
217: PROCEDURE update_exception_group
218: (p_validate in number default hr_api.g_false_num
219: ,p_exception_group_id in number default hr_api.g_number
220: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
221: ,p_exception_report_id in number default hr_api.g_number
222: ,p_legislation_code in varchar2 default hr_api.g_varchar2
215: -- |------------------------< update_exception_group >------------------------|
216: -- ----------------------------------------------------------------------------
217: PROCEDURE update_exception_group
218: (p_validate in number default hr_api.g_false_num
219: ,p_exception_group_id in number default hr_api.g_number
220: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
221: ,p_exception_report_id in number default hr_api.g_number
222: ,p_legislation_code in varchar2 default hr_api.g_varchar2
223: ,p_business_group_id in number default hr_api.g_number
216: -- ----------------------------------------------------------------------------
217: PROCEDURE update_exception_group
218: (p_validate in number default hr_api.g_false_num
219: ,p_exception_group_id in number default hr_api.g_number
220: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
221: ,p_exception_report_id in number default hr_api.g_number
222: ,p_legislation_code in varchar2 default hr_api.g_varchar2
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_consolidation_set_id in number default hr_api.g_number
217: PROCEDURE update_exception_group
218: (p_validate in number default hr_api.g_false_num
219: ,p_exception_group_id in number default hr_api.g_number
220: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
221: ,p_exception_report_id in number default hr_api.g_number
222: ,p_legislation_code in varchar2 default hr_api.g_varchar2
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_consolidation_set_id in number default hr_api.g_number
225: ,p_payroll_id in number default hr_api.g_number
218: (p_validate in number default hr_api.g_false_num
219: ,p_exception_group_id in number default hr_api.g_number
220: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
221: ,p_exception_report_id in number default hr_api.g_number
222: ,p_legislation_code in varchar2 default hr_api.g_varchar2
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_consolidation_set_id in number default hr_api.g_number
225: ,p_payroll_id in number default hr_api.g_number
226: ,p_object_version_number in out nocopy number
219: ,p_exception_group_id in number default hr_api.g_number
220: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
221: ,p_exception_report_id in number default hr_api.g_number
222: ,p_legislation_code in varchar2 default hr_api.g_varchar2
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_consolidation_set_id in number default hr_api.g_number
225: ,p_payroll_id in number default hr_api.g_number
226: ,p_object_version_number in out nocopy number
227: ,p_output_format in varchar2 default hr_api.g_varchar2
220: ,p_exception_group_name in varchar2 default hr_api.g_varchar2
221: ,p_exception_report_id in number default hr_api.g_number
222: ,p_legislation_code in varchar2 default hr_api.g_varchar2
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_consolidation_set_id in number default hr_api.g_number
225: ,p_payroll_id in number default hr_api.g_number
226: ,p_object_version_number in out nocopy number
227: ,p_output_format in varchar2 default hr_api.g_varchar2
228: ,p_return_status out nocopy varchar2
221: ,p_exception_report_id in number default hr_api.g_number
222: ,p_legislation_code in varchar2 default hr_api.g_varchar2
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_consolidation_set_id in number default hr_api.g_number
225: ,p_payroll_id in number default hr_api.g_number
226: ,p_object_version_number in out nocopy number
227: ,p_output_format in varchar2 default hr_api.g_varchar2
228: ,p_return_status out nocopy varchar2
229: ) is
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_consolidation_set_id in number default hr_api.g_number
225: ,p_payroll_id in number default hr_api.g_number
226: ,p_object_version_number in out nocopy number
227: ,p_output_format in varchar2 default hr_api.g_varchar2
228: ,p_return_status out nocopy varchar2
229: ) is
230: --
231: -- Variables for API Boolean parameters
253: --
254: -- Convert constant values to their corresponding boolean value
255: --
256: l_validate :=
257: hr_api.constant_to_boolean
258: (p_constant_value => p_validate);
259: --
260: -- Register Surrogate ID or user key values
261: --