23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_exception_report
27: (p_validate in number default hr_api.g_false_num
28: ,p_exception_report_name in varchar2
29: ,p_legislation_code in varchar2 default null
30: ,p_business_group_id in number default null
31: ,p_currency_code in varchar2 default null
65: --
66: -- {End of comments}
67: -- ----------------------------------------------------------------------------
68: PROCEDURE delete_exception_report
69: (p_validate in number default hr_api.g_false_num
70: ,p_exception_report_id in number
71: ,p_object_version_number in number
72: ,p_return_status out nocopy varchar2
73: );
94: --
95: -- {End of comments}
96: -- ----------------------------------------------------------------------------
97: PROCEDURE update_exception_report
98: (p_validate in number default hr_api.g_false_num
99: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
100: ,p_legislation_code in varchar2 default hr_api.g_varchar2
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_currency_code in varchar2 default hr_api.g_varchar2
95: -- {End of comments}
96: -- ----------------------------------------------------------------------------
97: PROCEDURE update_exception_report
98: (p_validate in number default hr_api.g_false_num
99: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
100: ,p_legislation_code in varchar2 default hr_api.g_varchar2
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_currency_code in varchar2 default hr_api.g_varchar2
103: ,p_balance_type_id in number default hr_api.g_number
96: -- ----------------------------------------------------------------------------
97: PROCEDURE update_exception_report
98: (p_validate in number default hr_api.g_false_num
99: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
100: ,p_legislation_code in varchar2 default hr_api.g_varchar2
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_currency_code in varchar2 default hr_api.g_varchar2
103: ,p_balance_type_id in number default hr_api.g_number
104: ,p_balance_dimension_id in number default hr_api.g_number
97: PROCEDURE update_exception_report
98: (p_validate in number default hr_api.g_false_num
99: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
100: ,p_legislation_code in varchar2 default hr_api.g_varchar2
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_currency_code in varchar2 default hr_api.g_varchar2
103: ,p_balance_type_id in number default hr_api.g_number
104: ,p_balance_dimension_id in number default hr_api.g_number
105: ,p_variance_type in varchar2 default hr_api.g_varchar2
98: (p_validate in number default hr_api.g_false_num
99: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
100: ,p_legislation_code in varchar2 default hr_api.g_varchar2
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_currency_code in varchar2 default hr_api.g_varchar2
103: ,p_balance_type_id in number default hr_api.g_number
104: ,p_balance_dimension_id in number default hr_api.g_number
105: ,p_variance_type in varchar2 default hr_api.g_varchar2
106: ,p_variance_value in number default hr_api.g_number
99: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
100: ,p_legislation_code in varchar2 default hr_api.g_varchar2
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_currency_code in varchar2 default hr_api.g_varchar2
103: ,p_balance_type_id in number default hr_api.g_number
104: ,p_balance_dimension_id in number default hr_api.g_number
105: ,p_variance_type in varchar2 default hr_api.g_varchar2
106: ,p_variance_value in number default hr_api.g_number
107: ,p_comparison_type in varchar2 default hr_api.g_varchar2
100: ,p_legislation_code in varchar2 default hr_api.g_varchar2
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_currency_code in varchar2 default hr_api.g_varchar2
103: ,p_balance_type_id in number default hr_api.g_number
104: ,p_balance_dimension_id in number default hr_api.g_number
105: ,p_variance_type in varchar2 default hr_api.g_varchar2
106: ,p_variance_value in number default hr_api.g_number
107: ,p_comparison_type in varchar2 default hr_api.g_varchar2
108: ,p_comparison_value in number default hr_api.g_number
101: ,p_business_group_id in number default hr_api.g_number
102: ,p_currency_code in varchar2 default hr_api.g_varchar2
103: ,p_balance_type_id in number default hr_api.g_number
104: ,p_balance_dimension_id in number default hr_api.g_number
105: ,p_variance_type in varchar2 default hr_api.g_varchar2
106: ,p_variance_value in number default hr_api.g_number
107: ,p_comparison_type in varchar2 default hr_api.g_varchar2
108: ,p_comparison_value in number default hr_api.g_number
109: ,p_exception_report_id in number default hr_api.g_number
102: ,p_currency_code in varchar2 default hr_api.g_varchar2
103: ,p_balance_type_id in number default hr_api.g_number
104: ,p_balance_dimension_id in number default hr_api.g_number
105: ,p_variance_type in varchar2 default hr_api.g_varchar2
106: ,p_variance_value in number default hr_api.g_number
107: ,p_comparison_type in varchar2 default hr_api.g_varchar2
108: ,p_comparison_value in number default hr_api.g_number
109: ,p_exception_report_id in number default hr_api.g_number
110: ,p_language_code in varchar2 default hr_api.g_varchar2
103: ,p_balance_type_id in number default hr_api.g_number
104: ,p_balance_dimension_id in number default hr_api.g_number
105: ,p_variance_type in varchar2 default hr_api.g_varchar2
106: ,p_variance_value in number default hr_api.g_number
107: ,p_comparison_type in varchar2 default hr_api.g_varchar2
108: ,p_comparison_value in number default hr_api.g_number
109: ,p_exception_report_id in number default hr_api.g_number
110: ,p_language_code in varchar2 default hr_api.g_varchar2
111: ,p_object_version_number in out nocopy number
104: ,p_balance_dimension_id in number default hr_api.g_number
105: ,p_variance_type in varchar2 default hr_api.g_varchar2
106: ,p_variance_value in number default hr_api.g_number
107: ,p_comparison_type in varchar2 default hr_api.g_varchar2
108: ,p_comparison_value in number default hr_api.g_number
109: ,p_exception_report_id in number default hr_api.g_number
110: ,p_language_code in varchar2 default hr_api.g_varchar2
111: ,p_object_version_number in out nocopy number
112: ,p_output_format_type in varchar2 default hr_api.g_varchar2
105: ,p_variance_type in varchar2 default hr_api.g_varchar2
106: ,p_variance_value in number default hr_api.g_number
107: ,p_comparison_type in varchar2 default hr_api.g_varchar2
108: ,p_comparison_value in number default hr_api.g_number
109: ,p_exception_report_id in number default hr_api.g_number
110: ,p_language_code in varchar2 default hr_api.g_varchar2
111: ,p_object_version_number in out nocopy number
112: ,p_output_format_type in varchar2 default hr_api.g_varchar2
113: ,p_variance_operator in varchar2 default hr_api.g_varchar2
106: ,p_variance_value in number default hr_api.g_number
107: ,p_comparison_type in varchar2 default hr_api.g_varchar2
108: ,p_comparison_value in number default hr_api.g_number
109: ,p_exception_report_id in number default hr_api.g_number
110: ,p_language_code in varchar2 default hr_api.g_varchar2
111: ,p_object_version_number in out nocopy number
112: ,p_output_format_type in varchar2 default hr_api.g_varchar2
113: ,p_variance_operator in varchar2 default hr_api.g_varchar2
114: ,p_return_status out nocopy varchar2
108: ,p_comparison_value in number default hr_api.g_number
109: ,p_exception_report_id in number default hr_api.g_number
110: ,p_language_code in varchar2 default hr_api.g_varchar2
111: ,p_object_version_number in out nocopy number
112: ,p_output_format_type in varchar2 default hr_api.g_varchar2
113: ,p_variance_operator in varchar2 default hr_api.g_varchar2
114: ,p_return_status out nocopy varchar2
115: );
116: -- ----------------------------------------------------------------------------
109: ,p_exception_report_id in number default hr_api.g_number
110: ,p_language_code in varchar2 default hr_api.g_varchar2
111: ,p_object_version_number in out nocopy number
112: ,p_output_format_type in varchar2 default hr_api.g_varchar2
113: ,p_variance_operator in varchar2 default hr_api.g_varchar2
114: ,p_return_status out nocopy varchar2
115: );
116: -- ----------------------------------------------------------------------------
117: -- |------------------------< submit_request_set >-----------------------|
137: -- {End of comments}
138: -- ----------------------------------------------------------------------------
139:
140: procedure submit_request_set(
141: p_validate in number default hr_api.g_false_num
142: ,p_exception_report_id in number
143: ,p_legislation_code in varchar2 default null
144: ,p_business_group_id in number default null
145: ,p_consolidation_set_id in number default null