51: ,p_agency_finding => p_agency_finding
52: ,p_aj_finding => p_aj_finding
53: );
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'create_compl_basis'
58: ,p_hook_type => 'BP'
59: );
52: ,p_aj_finding => p_aj_finding
53: );
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'create_compl_basis'
58: ,p_hook_type => 'BP'
59: );
60: end;
93: ,p_compl_basis_id => l_compl_basis_id
94: ,p_object_version_number => l_object_version_number
95: );
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'create_compl_basis'
100: ,p_hook_type => 'AP'
101: );
94: ,p_object_version_number => l_object_version_number
95: );
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'create_compl_basis'
100: ,p_hook_type => 'AP'
101: );
102: end;
103: --
104: -- When in validation only mode raise the Validate_Enabled exception
105: --
106: if p_validate then
107: raise hr_api.validate_enabled;
108: end if;
109: --
110: -- Set all output arguments
111: --
113: p_object_version_number := l_object_version_number;
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 70);
116: exception
117: when hr_api.validate_enabled then
118: --
119: -- As the Validate_Enabled exception has been raised
120: -- we must rollback to the savepoint
121: --
147: procedure update_compl_basis
148: (p_validate in boolean default false
149: ,p_effective_date in date
150: ,p_compl_basis_id in number
151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
148: (p_validate in boolean default false
149: ,p_effective_date in date
150: ,p_compl_basis_id in number
151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2
149: ,p_effective_date in date
150: ,p_compl_basis_id in number
151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
150: ,p_compl_basis_id in number
151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: )
151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: )
159:
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: )
159:
160: is
184: ,p_compl_basis_id => p_compl_basis_id
185: ,p_object_version_number => p_object_version_number
186: );
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'update_compl_basis'
191: ,p_hook_type => 'BP'
192: );
185: ,p_object_version_number => p_object_version_number
186: );
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'update_compl_basis'
191: ,p_hook_type => 'BP'
192: );
193: end;
225: ,p_compl_basis_id => p_compl_basis_id
226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'update_compl_basis'
232: ,p_hook_type => 'AP'
233: );
226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'update_compl_basis'
232: ,p_hook_type => 'AP'
233: );
234: end;
235: --
236: -- When in validation only mode raise the Validate_Enabled exception
237: --
238: if p_validate then
239: raise hr_api.validate_enabled;
240: end if;
241: --
242: -- Set all output arguments
243: --
244: p_object_version_number := l_object_version_number;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: exception
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised
251: -- we must rollback to the savepoint
252: --
303: (p_compl_basis_id => p_compl_basis_id
304: ,p_object_version_number => p_object_version_number
305: );
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'delete_compl_basis'
310: ,p_hook_type => 'BP'
311: );
304: ,p_object_version_number => p_object_version_number
305: );
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'delete_compl_basis'
310: ,p_hook_type => 'BP'
311: );
312: end;
327: (p_compl_basis_id => p_compl_basis_id
328: ,p_object_version_number => p_object_version_number
329: );
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'delete_compl_basis'
334: ,p_hook_type => 'AP'
335: );
328: ,p_object_version_number => p_object_version_number
329: );
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'delete_compl_basis'
334: ,p_hook_type => 'AP'
335: );
336: end;
337: --
338: -- When in validation only mode raise the Validate_Enabled exception
339: --
340: if p_validate then
341: raise hr_api.validate_enabled;
342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 11);
345: exception
342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 11);
345: exception
346: when hr_api.validate_enabled then
347: -- we must rollback to the savepoint
348: --
349: ROLLBACK TO delete_compl_basis;
350: --