51: ,p_date_amended => p_date_amended
52: ,p_date_acknowledged => p_date_acknowledged
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_incident'
58: ,p_hook_type => 'BP'
59: );
52: ,p_date_acknowledged => p_date_acknowledged
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_incident'
58: ,p_hook_type => 'BP'
59: );
60: end;
90: ,p_compl_incident_id => l_compl_incident_id
91: ,p_object_version_number => l_object_version_number
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (p_module_name => 'create_compl_incident'
97: ,p_hook_type => 'AP'
98: );
91: ,p_object_version_number => l_object_version_number
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (p_module_name => 'create_compl_incident'
97: ,p_hook_type => 'AP'
98: );
99: end;
100: --
101: -- When in validation only mode raise the Validate_Enabled exception
102: --
103: if p_validate then
104: raise hr_api.validate_enabled;
105: end if;
106: --
107: -- Set all output arguments
108: --
110: p_object_version_number := l_object_version_number;
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 70);
113: exception
114: when hr_api.validate_enabled then
115: --
116: -- As the Validate_Enabled exception has been raised
117: -- we must rollback to the savepoint
118: --
145: procedure update_compl_incident
146: (p_validate in boolean default false
147: ,p_effective_date in date
148: ,p_compl_incident_id in number
149: ,p_compl_claim_id in number default hr_api.g_number
150: ,p_incident_date in date default hr_api.g_date
151: ,p_description in varchar2 default hr_api.g_varchar2
152: ,p_date_amended in date default hr_api.g_date
153: ,p_date_acknowledged in date default hr_api.g_date
146: (p_validate in boolean default false
147: ,p_effective_date in date
148: ,p_compl_incident_id in number
149: ,p_compl_claim_id in number default hr_api.g_number
150: ,p_incident_date in date default hr_api.g_date
151: ,p_description in varchar2 default hr_api.g_varchar2
152: ,p_date_amended in date default hr_api.g_date
153: ,p_date_acknowledged in date default hr_api.g_date
154: ,p_object_version_number in out nocopy number
147: ,p_effective_date in date
148: ,p_compl_incident_id in number
149: ,p_compl_claim_id in number default hr_api.g_number
150: ,p_incident_date in date default hr_api.g_date
151: ,p_description in varchar2 default hr_api.g_varchar2
152: ,p_date_amended in date default hr_api.g_date
153: ,p_date_acknowledged in date default hr_api.g_date
154: ,p_object_version_number in out nocopy number
155: )
148: ,p_compl_incident_id in number
149: ,p_compl_claim_id in number default hr_api.g_number
150: ,p_incident_date in date default hr_api.g_date
151: ,p_description in varchar2 default hr_api.g_varchar2
152: ,p_date_amended in date default hr_api.g_date
153: ,p_date_acknowledged in date default hr_api.g_date
154: ,p_object_version_number in out nocopy number
155: )
156:
149: ,p_compl_claim_id in number default hr_api.g_number
150: ,p_incident_date in date default hr_api.g_date
151: ,p_description in varchar2 default hr_api.g_varchar2
152: ,p_date_amended in date default hr_api.g_date
153: ,p_date_acknowledged in date default hr_api.g_date
154: ,p_object_version_number in out nocopy number
155: )
156:
157: is
179: ,p_compl_incident_id => p_compl_incident_id
180: ,p_object_version_number => p_object_version_number
181: );
182: exception
183: when hr_api.cannot_find_prog_unit then
184: hr_api.cannot_find_prog_unit_error
185: (p_module_name => 'update_compl_incident'
186: ,p_hook_type => 'BP'
187: );
180: ,p_object_version_number => p_object_version_number
181: );
182: exception
183: when hr_api.cannot_find_prog_unit then
184: hr_api.cannot_find_prog_unit_error
185: (p_module_name => 'update_compl_incident'
186: ,p_hook_type => 'BP'
187: );
188: end;
219: ,p_compl_incident_id => p_compl_incident_id
220: ,p_object_version_number => l_object_version_number
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'update_compl_incident'
226: ,p_hook_type => 'AP'
227: );
220: ,p_object_version_number => l_object_version_number
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'update_compl_incident'
226: ,p_hook_type => 'AP'
227: );
228: end;
229: --
230: -- When in validation only mode raise the Validate_Enabled exception
231: --
232: if p_validate then
233: raise hr_api.validate_enabled;
234: end if;
235: --
236: -- Set all output arguments
237: --
238: p_object_version_number := l_object_version_number;
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 70);
241: exception
242: when hr_api.validate_enabled then
243: --
244: -- As the Validate_Enabled exception has been raised
245: -- we must rollback to the savepoint
246: --
296: (p_compl_incident_id => p_compl_incident_id
297: ,p_object_version_number => p_object_version_number
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'delete_compl_incident'
303: ,p_hook_type => 'BP'
304: );
297: ,p_object_version_number => p_object_version_number
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'delete_compl_incident'
303: ,p_hook_type => 'BP'
304: );
305: end;
321: (p_compl_incident_id => p_compl_incident_id
322: ,p_object_version_number => p_object_version_number
323: );
324: exception
325: when hr_api.cannot_find_prog_unit then
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'delete_compl_incident'
328: ,p_hook_type => 'AP'
329: );
322: ,p_object_version_number => p_object_version_number
323: );
324: exception
325: when hr_api.cannot_find_prog_unit then
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'delete_compl_incident'
328: ,p_hook_type => 'AP'
329: );
330: end;
331: --
332: -- When in validation only mode raise the Validate_Enabled exception
333: --
334: if p_validate then
335: raise hr_api.validate_enabled;
336: end if;
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 11);
339: exception
336: end if;
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 11);
339: exception
340: when hr_api.validate_enabled then
341: -- we must rollback to the savepoint
342: --
343: ROLLBACK TO delete_compl_incident;
344: --