8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_exception_report >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_exception_report
12: (p_validate in number default hr_api.g_false_num
13: ,p_exception_report_name in varchar2
14: ,p_legislation_code in varchar2 default null
15: ,p_business_group_id in number default null
16: ,p_currency_code in varchar2 default null
51: --
52: -- Convert constant values to their corresponding boolean value
53: --
54: l_validate :=
55: hr_api.constant_to_boolean
56: (p_constant_value => p_validate);
57: --
58: -- Register Surrogate ID or user key values
59: --
132: -- ----------------------------------------------------------------------------
133: -- |------------------------< delete_exception_report >-----------------------|
134: -- ----------------------------------------------------------------------------
135: PROCEDURE delete_exception_report
136: (p_validate in number default hr_api.g_false_num
137: ,p_exception_report_id in number
138: ,p_object_version_number in number
139: ,p_return_status out nocopy varchar2
140: ) is
162: --
163: -- Convert constant values to their corresponding boolean value
164: --
165: l_validate :=
166: hr_api.constant_to_boolean
167: (p_constant_value => p_validate);
168: --
169: -- Register Surrogate ID or user key values
170: --
226: -- ----------------------------------------------------------------------------
227: -- |------------------------< update_exception_report >-----------------------|
228: -- ----------------------------------------------------------------------------
229: PROCEDURE update_exception_report
230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
227: -- |------------------------< update_exception_report >-----------------------|
228: -- ----------------------------------------------------------------------------
229: PROCEDURE update_exception_report
230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
228: -- ----------------------------------------------------------------------------
229: PROCEDURE update_exception_report
230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
229: PROCEDURE update_exception_report
230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
230: (p_validate in number default hr_api.g_false_num
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
231: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
232: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
233: ,p_business_group_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
234: ,p_currency_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
235: ,p_balance_type_id in number default hr_api.g_number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
236: ,p_balance_dimension_id in number default hr_api.g_number
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2
237: ,p_variance_type in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2
245: ,p_variance_operator in varchar2 default hr_api.g_varchar2
238: ,p_variance_value in number default hr_api.g_number
239: ,p_comparison_type in varchar2 default hr_api.g_varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2
245: ,p_variance_operator in varchar2 default hr_api.g_varchar2
246: ,p_return_status out nocopy varchar2
240: ,p_comparison_value in number default hr_api.g_number
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2
245: ,p_variance_operator in varchar2 default hr_api.g_varchar2
246: ,p_return_status out nocopy varchar2
247: ) is
248: --
241: ,p_exception_report_id in number default hr_api.g_number
242: ,p_language_code in varchar2 default hr_api.g_varchar2
243: ,p_object_version_number in out nocopy number
244: ,p_output_format_type in varchar2 default hr_api.g_varchar2
245: ,p_variance_operator in varchar2 default hr_api.g_varchar2
246: ,p_return_status out nocopy varchar2
247: ) is
248: --
249: -- Variables for API Boolean parameters
271: --
272: -- Convert constant values to their corresponding boolean value
273: --
274: l_validate :=
275: hr_api.constant_to_boolean
276: (p_constant_value => p_validate);
277: --
278: -- Register Surrogate ID or user key values
279: --
352: -- ----------------------------------------------------------------------------
353: -- |------------------------< submit_request_set >-----------------------|
354: -- ----------------------------------------------------------------------------
355: procedure submit_request_set(
356: p_validate in number default hr_api.g_false_num
357: ,p_exception_report_id in number
358: ,p_legislation_code in varchar2 default null
359: ,p_business_group_id in number default null
360: ,p_consolidation_set_id in number default null