54: ,p_legislation_code => p_legislation_code
55: ,p_proration_style => p_proration_style
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'CREATE_DATETRACKED_EVENT',
61: p_hook_type => 'BP'
62: );
55: ,p_proration_style => p_proration_style
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'CREATE_DATETRACKED_EVENT',
61: p_hook_type => 'BP'
62: );
63: end;
92: ,p_object_version_number => l_object_version_number
93: ,p_proration_style => p_proration_style
94: );
95: exception
96: when hr_api.cannot_find_prog_unit then
97: hr_api.cannot_find_prog_unit_error
98: (p_module_name => 'CREATE_DATETRACKED_EVENT',
99: p_hook_type => 'AP'
100: );
93: ,p_proration_style => p_proration_style
94: );
95: exception
96: when hr_api.cannot_find_prog_unit then
97: hr_api.cannot_find_prog_unit_error
98: (p_module_name => 'CREATE_DATETRACKED_EVENT',
99: p_hook_type => 'AP'
100: );
101: end;
100: );
101: end;
102: --
103: If p_validate then
104: Raise HR_Api.Validate_Enabled;
105: End If;
106: --
107: p_object_version_number := l_object_version_number;
108: p_datetracked_event_id := l_datetracked_event_id;
108: p_datetracked_event_id := l_datetracked_event_id;
109: --
110: exception
111: --
112: when HR_Api.Validate_Enabled then
113: --
114: -- A validation or unexpected error has occured
115: --
116: ROLLBACK TO create_datetracked_event;
129: (p_validate in boolean default false
130: ,p_effective_date in date
131: ,p_datetracked_event_id in number
132: ,p_object_version_number in out nocopy number
133: ,p_event_group_id in number default hr_api.g_number
134: ,p_dated_table_id in number default hr_api.g_number
135: ,p_update_type in varchar2 default hr_api.g_varchar2
136: ,p_column_name in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
130: ,p_effective_date in date
131: ,p_datetracked_event_id in number
132: ,p_object_version_number in out nocopy number
133: ,p_event_group_id in number default hr_api.g_number
134: ,p_dated_table_id in number default hr_api.g_number
135: ,p_update_type in varchar2 default hr_api.g_varchar2
136: ,p_column_name in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_legislation_code in varchar2 default hr_api.g_varchar2
131: ,p_datetracked_event_id in number
132: ,p_object_version_number in out nocopy number
133: ,p_event_group_id in number default hr_api.g_number
134: ,p_dated_table_id in number default hr_api.g_number
135: ,p_update_type in varchar2 default hr_api.g_varchar2
136: ,p_column_name in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_legislation_code in varchar2 default hr_api.g_varchar2
139: ,p_proration_style in varchar2 default hr_api.g_varchar2
132: ,p_object_version_number in out nocopy number
133: ,p_event_group_id in number default hr_api.g_number
134: ,p_dated_table_id in number default hr_api.g_number
135: ,p_update_type in varchar2 default hr_api.g_varchar2
136: ,p_column_name in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_legislation_code in varchar2 default hr_api.g_varchar2
139: ,p_proration_style in varchar2 default hr_api.g_varchar2
140: ) IS
133: ,p_event_group_id in number default hr_api.g_number
134: ,p_dated_table_id in number default hr_api.g_number
135: ,p_update_type in varchar2 default hr_api.g_varchar2
136: ,p_column_name in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_legislation_code in varchar2 default hr_api.g_varchar2
139: ,p_proration_style in varchar2 default hr_api.g_varchar2
140: ) IS
141: --
134: ,p_dated_table_id in number default hr_api.g_number
135: ,p_update_type in varchar2 default hr_api.g_varchar2
136: ,p_column_name in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_legislation_code in varchar2 default hr_api.g_varchar2
139: ,p_proration_style in varchar2 default hr_api.g_varchar2
140: ) IS
141: --
142: -- Declare cursors and local variables
135: ,p_update_type in varchar2 default hr_api.g_varchar2
136: ,p_column_name in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_legislation_code in varchar2 default hr_api.g_varchar2
139: ,p_proration_style in varchar2 default hr_api.g_varchar2
140: ) IS
141: --
142: -- Declare cursors and local variables
143: --
169: ,p_legislation_code => p_legislation_code
170: ,p_proration_style => p_proration_style
171: );
172: exception
173: when hr_api.cannot_find_prog_unit then
174: hr_api.cannot_find_prog_unit_error
175: (p_module_name => 'UPDATE_DATETRACKED_EVENT',
176: p_hook_type => 'BP'
177: );
170: ,p_proration_style => p_proration_style
171: );
172: exception
173: when hr_api.cannot_find_prog_unit then
174: hr_api.cannot_find_prog_unit_error
175: (p_module_name => 'UPDATE_DATETRACKED_EVENT',
176: p_hook_type => 'BP'
177: );
178: end;
208: ,p_proration_style => p_proration_style
209: );
210:
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_DATETRACKED_EVENT',
215: p_hook_type => 'AP'
216: );
209: );
210:
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_DATETRACKED_EVENT',
215: p_hook_type => 'AP'
216: );
217: end;
218: --
219: -- End of API User Hook for the after hook of update_DATETRACKED_EVENT.
220: --
221: If p_validate then
222: Raise HR_Api.Validate_Enabled;
223: End If;
224: --
225: p_object_version_number := l_object_version_number;
226: --
225: p_object_version_number := l_object_version_number;
226: --
227: exception
228: --
229: when HR_Api.Validate_Enabled then
230: --
231: -- A validation or unexpected error has occured
232: --
233: ROLLBACK TO update_datetracked_event;
270: ( p_datetracked_event_id => p_datetracked_event_id
271: ,p_object_version_number => l_object_version_number
272: );
273: exception
274: when hr_api.cannot_find_prog_unit then
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'DELETE_DATETRACKED_EVENT',
277: p_hook_type => 'BP'
278: );
271: ,p_object_version_number => l_object_version_number
272: );
273: exception
274: when hr_api.cannot_find_prog_unit then
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'DELETE_DATETRACKED_EVENT',
277: p_hook_type => 'BP'
278: );
279: end;
292: ( p_datetracked_event_id => p_datetracked_event_id
293: ,p_object_version_number => l_object_version_number
294: );
295: exception
296: when hr_api.cannot_find_prog_unit then
297: hr_api.cannot_find_prog_unit_error
298: (p_module_name => 'DELETE_DATETRACKED_EVENT',
299: p_hook_type => 'AP'
300: );
293: ,p_object_version_number => l_object_version_number
294: );
295: exception
296: when hr_api.cannot_find_prog_unit then
297: hr_api.cannot_find_prog_unit_error
298: (p_module_name => 'DELETE_DATETRACKED_EVENT',
299: p_hook_type => 'AP'
300: );
301: end;
299: p_hook_type => 'AP'
300: );
301: end;
302: If p_validate then
303: Raise HR_Api.Validate_Enabled;
304: End If;
305: --
306: exception
307: when HR_Api.Validate_Enabled then
303: Raise HR_Api.Validate_Enabled;
304: End If;
305: --
306: exception
307: when HR_Api.Validate_Enabled then
308: --
309: -- A validation or unexpected error has occured
310: --
311: ROLLBACK TO delete_datetracked_event;