62: ,p_retroactive_status => p_retroactive_status
63: ,p_noted_value => p_noted_value
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (p_module_name => 'CREATE_PROCESS_EVENT',
69: p_hook_type => 'BP'
70: );
63: ,p_noted_value => p_noted_value
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (p_module_name => 'CREATE_PROCESS_EVENT',
69: p_hook_type => 'BP'
70: );
71: end;
111: ,p_retroactive_status => p_retroactive_status
112: ,p_noted_value => p_noted_value
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'CREATE_PROCESS_EVENT',
118: p_hook_type => 'AP'
119: );
112: ,p_noted_value => p_noted_value
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'CREATE_PROCESS_EVENT',
118: p_hook_type => 'AP'
119: );
120: end;
119: );
120: end;
121: --
122: If p_validate then
123: Raise HR_Api.Validate_Enabled;
124: End If;
125: --
126: p_object_version_number := l_object_version_number;
127: --
126: p_object_version_number := l_object_version_number;
127: --
128: exception
129: --
130: when HR_Api.Validate_Enabled then
131: --
132: -- A validation or unexpected error has occured
133: --
134: ROLLBACK TO create_process_event;
149: (
150: p_validate in boolean default false
151: ,p_process_event_id in number
152: ,p_object_version_number in out nocopy number
153: ,p_assignment_id in number default hr_api.g_number
154: ,p_effective_date in date default hr_api.g_date
155: ,p_change_type in varchar2 default hr_api.g_varchar2
156: ,p_status in varchar2 default hr_api.g_varchar2
157: ,p_description in varchar2 default hr_api.g_varchar2
150: p_validate in boolean default false
151: ,p_process_event_id in number
152: ,p_object_version_number in out nocopy number
153: ,p_assignment_id in number default hr_api.g_number
154: ,p_effective_date in date default hr_api.g_date
155: ,p_change_type in varchar2 default hr_api.g_varchar2
156: ,p_status in varchar2 default hr_api.g_varchar2
157: ,p_description in varchar2 default hr_api.g_varchar2
158: ,p_event_update_id in number default hr_api.g_number
151: ,p_process_event_id in number
152: ,p_object_version_number in out nocopy number
153: ,p_assignment_id in number default hr_api.g_number
154: ,p_effective_date in date default hr_api.g_date
155: ,p_change_type in varchar2 default hr_api.g_varchar2
156: ,p_status in varchar2 default hr_api.g_varchar2
157: ,p_description in varchar2 default hr_api.g_varchar2
158: ,p_event_update_id in number default hr_api.g_number
159: ,p_org_process_event_group_id in number default hr_api.g_number
152: ,p_object_version_number in out nocopy number
153: ,p_assignment_id in number default hr_api.g_number
154: ,p_effective_date in date default hr_api.g_date
155: ,p_change_type in varchar2 default hr_api.g_varchar2
156: ,p_status in varchar2 default hr_api.g_varchar2
157: ,p_description in varchar2 default hr_api.g_varchar2
158: ,p_event_update_id in number default hr_api.g_number
159: ,p_org_process_event_group_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
153: ,p_assignment_id in number default hr_api.g_number
154: ,p_effective_date in date default hr_api.g_date
155: ,p_change_type in varchar2 default hr_api.g_varchar2
156: ,p_status in varchar2 default hr_api.g_varchar2
157: ,p_description in varchar2 default hr_api.g_varchar2
158: ,p_event_update_id in number default hr_api.g_number
159: ,p_org_process_event_group_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
154: ,p_effective_date in date default hr_api.g_date
155: ,p_change_type in varchar2 default hr_api.g_varchar2
156: ,p_status in varchar2 default hr_api.g_varchar2
157: ,p_description in varchar2 default hr_api.g_varchar2
158: ,p_event_update_id in number default hr_api.g_number
159: ,p_org_process_event_group_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
162: ,p_calculation_date in date default hr_api.g_date
155: ,p_change_type in varchar2 default hr_api.g_varchar2
156: ,p_status in varchar2 default hr_api.g_varchar2
157: ,p_description in varchar2 default hr_api.g_varchar2
158: ,p_event_update_id in number default hr_api.g_number
159: ,p_org_process_event_group_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
162: ,p_calculation_date in date default hr_api.g_date
163: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
156: ,p_status in varchar2 default hr_api.g_varchar2
157: ,p_description in varchar2 default hr_api.g_varchar2
158: ,p_event_update_id in number default hr_api.g_number
159: ,p_org_process_event_group_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
162: ,p_calculation_date in date default hr_api.g_date
163: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
164: ,p_noted_value in varchar2 default hr_api.g_varchar2
157: ,p_description in varchar2 default hr_api.g_varchar2
158: ,p_event_update_id in number default hr_api.g_number
159: ,p_org_process_event_group_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
162: ,p_calculation_date in date default hr_api.g_date
163: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
164: ,p_noted_value in varchar2 default hr_api.g_varchar2
165: )is
158: ,p_event_update_id in number default hr_api.g_number
159: ,p_org_process_event_group_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
162: ,p_calculation_date in date default hr_api.g_date
163: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
164: ,p_noted_value in varchar2 default hr_api.g_varchar2
165: )is
166: --
159: ,p_org_process_event_group_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
162: ,p_calculation_date in date default hr_api.g_date
163: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
164: ,p_noted_value in varchar2 default hr_api.g_varchar2
165: )is
166: --
167: -- Declare cursors and local variables
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
162: ,p_calculation_date in date default hr_api.g_date
163: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
164: ,p_noted_value in varchar2 default hr_api.g_varchar2
165: )is
166: --
167: -- Declare cursors and local variables
168: --
198: ,p_retroactive_status => p_retroactive_status
199: ,p_noted_value => p_noted_value
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'UPDATE_PROCESS_EVENT',
205: p_hook_type => 'BP'
206: );
199: ,p_noted_value => p_noted_value
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'UPDATE_PROCESS_EVENT',
205: p_hook_type => 'BP'
206: );
207: end;
243: ,p_retroactive_status => p_retroactive_status
244: ,p_noted_value => p_noted_value
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_PROCESS_EVENT',
250: p_hook_type => 'AP'
251: );
244: ,p_noted_value => p_noted_value
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_PROCESS_EVENT',
250: p_hook_type => 'AP'
251: );
252: end;
255: --
256: hr_utility.set_location('Entering:'|| l_proc, 20);
257: --
258: If p_validate then
259: Raise HR_Api.Validate_Enabled;
260: End If;
261: --
262: exception
263: --
260: End If;
261: --
262: exception
263: --
264: when HR_Api.Validate_Enabled then
265: --
266: -- A validation or unexpected error has occured
267: --
268: ROLLBACK TO update_process_event;
307: p_process_event_id => p_process_event_id
308: ,p_object_version_number => l_object_version_number
309: );
310: exception
311: when hr_api.cannot_find_prog_unit then
312: hr_api.cannot_find_prog_unit_error
313: (p_module_name => 'DELETE_PROCESS_EVENT',
314: p_hook_type => 'BP'
315: );
308: ,p_object_version_number => l_object_version_number
309: );
310: exception
311: when hr_api.cannot_find_prog_unit then
312: hr_api.cannot_find_prog_unit_error
313: (p_module_name => 'DELETE_PROCESS_EVENT',
314: p_hook_type => 'BP'
315: );
316: end;
330: p_process_event_id => p_process_event_id
331: ,p_object_version_number => l_object_version_number
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'DELETE_PROCESS_EVENT',
337: p_hook_type => 'AP'
338: );
331: ,p_object_version_number => l_object_version_number
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'DELETE_PROCESS_EVENT',
337: p_hook_type => 'AP'
338: );
339: end;
338: );
339: end;
340: --
341: If p_validate then
342: Raise HR_Api.Validate_Enabled;
343: End If;
344: --
345: exception
346: when HR_Api.Validate_Enabled then
342: Raise HR_Api.Validate_Enabled;
343: End If;
344: --
345: exception
346: when HR_Api.Validate_Enabled then
347: --
348: -- A validation or unexpected error has occured
349: --
350: ROLLBACK TO delete_process_event;