20: ,p_variance_type in varchar2 default null
21: ,p_variance_value in number default null
22: ,p_comparison_type in varchar2 default null
23: ,p_comparison_value in number default null
24: ,p_language_code in varchar2 default hr_api.userenv_lang
25: ,p_exception_report_id out nocopy number
26: ,p_object_version_number out nocopy number
27: ,p_output_format_type in varchar2
28: ,p_variance_operator in varchar2
46:
47: hr_utility.set_location(l_proc, 20);
48:
49: l_language_code := p_language_code;
50: hr_api.validate_language_code(p_language_code => l_language_code);
51:
52: --
53: -- Call Before Process User Hook
54: --
67: ,p_output_format_type => p_output_format_type
68: ,p_variance_operator => p_variance_operator
69: );
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'create_exception_report'
74: ,p_hook_type => 'BP'
75: );
68: ,p_variance_operator => p_variance_operator
69: );
70: exception
71: when hr_api.cannot_find_prog_unit then
72: hr_api.cannot_find_prog_unit_error
73: (p_module_name => 'create_exception_report'
74: ,p_hook_type => 'BP'
75: );
76: end;
131: ,p_output_format_type => p_output_format_type
132: ,p_variance_operator => p_variance_operator
133: );
134: exception
135: when hr_api.cannot_find_prog_unit then
136: hr_api.cannot_find_prog_unit_error
137: (p_module_name => 'create_exception_report'
138: ,p_hook_type => 'AP'
139: );
132: ,p_variance_operator => p_variance_operator
133: );
134: exception
135: when hr_api.cannot_find_prog_unit then
136: hr_api.cannot_find_prog_unit_error
137: (p_module_name => 'create_exception_report'
138: ,p_hook_type => 'AP'
139: );
140: end;
142: --
143: -- When in validation only mode raise the Validate_Enabled exception
144: --
145: if p_validate then
146: raise hr_api.validate_enabled;
147: end if;
148: --
149: -- Set all output arguments
150: --
152: p_object_version_number := l_object_version_number;
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 70);
155: exception
156: when hr_api.validate_enabled then
157: --
158: -- As the Validate_Enabled exception has been raised
159: -- we must rollback to the savepoint
160: --
183: -- ----------------------------------------------------------------------------
184: --
185: procedure update_exception_report
186: (p_validate in boolean default false
187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
184: --
185: procedure update_exception_report
186: (p_validate in boolean default false
187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
185: procedure update_exception_report
186: (p_validate in boolean default false
187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
186: (p_validate in boolean default false
187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
187: ,p_exception_report_name in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
189: ,p_business_group_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
190: ,p_currency_code in varchar2 default hr_api.g_varchar2
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
191: ,p_balance_type_id in number default hr_api.g_number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
192: ,p_balance_dimension_id in number default hr_api.g_number
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2
193: ,p_variance_type in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2
201: ,p_variance_operator in varchar2 default hr_api.g_varchar2
194: ,p_variance_value in number default hr_api.g_number
195: ,p_comparison_type in varchar2 default hr_api.g_varchar2
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2
201: ,p_variance_operator in varchar2 default hr_api.g_varchar2
202:
196: ,p_comparison_value in number default hr_api.g_number
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2
201: ,p_variance_operator in varchar2 default hr_api.g_varchar2
202:
203: ) is
204:
197: ,p_exception_report_id in number default hr_api.g_number
198: ,p_language_code in varchar2 default hr_api.userenv_lang
199: ,p_object_version_number in out nocopy number
200: ,p_output_format_type in varchar2 default hr_api.g_varchar2
201: ,p_variance_operator in varchar2 default hr_api.g_varchar2
202:
203: ) is
204:
205: --
218:
219: hr_utility.set_location(l_proc, 20);
220:
221: l_language_code := p_language_code;
222: hr_api.validate_language_code(p_language_code => l_language_code);
223:
224: --
225: -- Call Before Process User Hook
226: --
241: ,p_output_format_type => p_output_format_type
242: ,p_variance_operator => p_variance_operator
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_exception_report'
248: ,p_hook_type => 'BP'
249: );
242: ,p_variance_operator => p_variance_operator
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_exception_report'
248: ,p_hook_type => 'BP'
249: );
250: end;
306: ,p_output_format_type => p_output_format_type
307: ,p_variance_operator => p_variance_operator
308: );
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'update_exception_report'
313: ,p_hook_type => 'AP'
314: );
307: ,p_variance_operator => p_variance_operator
308: );
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'update_exception_report'
313: ,p_hook_type => 'AP'
314: );
315: end;
317: --
318: -- When in validation only mode raise the Validate_Enabled exception
319: --
320: if p_validate then
321: raise hr_api.validate_enabled;
322: end if;
323: --
324: -- Set all output arguments
325: --
326: p_object_version_number := l_object_version_number;
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 70);
329: exception
330: when hr_api.validate_enabled then
331: --
332: -- As the Validate_Enabled exception has been raised
333: -- we must rollback to the savepoint
334: --
393: ,p_business_group_id => l_business_group_id
394: ,p_object_version_number => p_object_version_number
395: );
396: exception
397: when hr_api.cannot_find_prog_unit then
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'delete_exception_report'
400: ,p_hook_type => 'BP'
401: );
394: ,p_object_version_number => p_object_version_number
395: );
396: exception
397: when hr_api.cannot_find_prog_unit then
398: hr_api.cannot_find_prog_unit_error
399: (p_module_name => 'delete_exception_report'
400: ,p_hook_type => 'BP'
401: );
402: end;
431: ,p_business_group_id => l_business_group_id
432: ,p_object_version_number => p_object_version_number
433: );
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'delete_exception_report'
438: ,p_hook_type => 'AP'
439: );
432: ,p_object_version_number => p_object_version_number
433: );
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'delete_exception_report'
438: ,p_hook_type => 'AP'
439: );
440: end;
442: --
443: -- When in validation only mode raise the Validate_Enabled exception
444: --
445: if p_validate then
446: raise hr_api.validate_enabled;
447: end if;
448: --
449: -- Set all output arguments
450: --
450: --
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 70);
453: exception
454: when hr_api.validate_enabled then
455: --
456: -- As the Validate_Enabled exception has been raised
457: -- we must rollback to the savepoint
458: --