53: ,p_comments => p_comments);
54:
55:
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'
60: ,p_hook_type => 'BP');
61: end;
54:
55:
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'
60: ,p_hook_type => 'BP');
61: end;
62: --
88: ,p_end_date => p_end_date
89: ,p_comments => p_comments);
90:
91: exception
92: when hr_api.cannot_find_prog_unit then
93: hr_api.cannot_find_prog_unit_error
94: (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'
95: ,p_hook_type => 'AP'
96: );
89: ,p_comments => p_comments);
90:
91: exception
92: when hr_api.cannot_find_prog_unit then
93: hr_api.cannot_find_prog_unit_error
94: (p_module_name => 'PQH_FR_VALIDATION_EVENTS_API.Insert_Validation_event'
95: ,p_hook_type => 'AP'
96: );
97: end;
101: -- Removed p_validate from the generated code to facilitate
102: -- writing wrappers to selfservice easily.
103: --
104: -- if p_validate then
105: -- raise hr_api.validate_enabled;
106: -- end if;
107: --
108: -- Set all output arguments
109: --
113:
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: --
146: procedure Update_Validation_event
147: (p_effective_date in date
148: ,p_validation_event_id in number
149: ,p_object_version_number in out nocopy number
150: ,p_validation_id in number default hr_api.g_number
151: ,p_event_type in varchar2 default hr_api.g_varchar2
152: ,p_event_code in varchar2 default hr_api.g_varchar2
153: ,p_start_date in date default hr_api.g_date
154: ,p_end_date in date default hr_api.g_date
147: (p_effective_date in date
148: ,p_validation_event_id in number
149: ,p_object_version_number in out nocopy number
150: ,p_validation_id in number default hr_api.g_number
151: ,p_event_type in varchar2 default hr_api.g_varchar2
152: ,p_event_code in varchar2 default hr_api.g_varchar2
153: ,p_start_date in date default hr_api.g_date
154: ,p_end_date in date default hr_api.g_date
155: ,p_comments in varchar2 default hr_api.g_varchar2) Is
148: ,p_validation_event_id in number
149: ,p_object_version_number in out nocopy number
150: ,p_validation_id in number default hr_api.g_number
151: ,p_event_type in varchar2 default hr_api.g_varchar2
152: ,p_event_code in varchar2 default hr_api.g_varchar2
153: ,p_start_date in date default hr_api.g_date
154: ,p_end_date in date default hr_api.g_date
155: ,p_comments in varchar2 default hr_api.g_varchar2) Is
156:
149: ,p_object_version_number in out nocopy number
150: ,p_validation_id in number default hr_api.g_number
151: ,p_event_type in varchar2 default hr_api.g_varchar2
152: ,p_event_code in varchar2 default hr_api.g_varchar2
153: ,p_start_date in date default hr_api.g_date
154: ,p_end_date in date default hr_api.g_date
155: ,p_comments in varchar2 default hr_api.g_varchar2) Is
156:
157: l_proc varchar2(72) := g_package||'Update_Validation_event';
150: ,p_validation_id in number default hr_api.g_number
151: ,p_event_type in varchar2 default hr_api.g_varchar2
152: ,p_event_code in varchar2 default hr_api.g_varchar2
153: ,p_start_date in date default hr_api.g_date
154: ,p_end_date in date default hr_api.g_date
155: ,p_comments in varchar2 default hr_api.g_varchar2) Is
156:
157: l_proc varchar2(72) := g_package||'Update_Validation_event';
158: l_object_Version_Number PQH_FR_VALIDATION_EVENTS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
151: ,p_event_type in varchar2 default hr_api.g_varchar2
152: ,p_event_code in varchar2 default hr_api.g_varchar2
153: ,p_start_date in date default hr_api.g_date
154: ,p_end_date in date default hr_api.g_date
155: ,p_comments in varchar2 default hr_api.g_varchar2) Is
156:
157: l_proc varchar2(72) := g_package||'Update_Validation_event';
158: l_object_Version_Number PQH_FR_VALIDATION_EVENTS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
159: L_Effective_Date Date;
184: ,p_end_date => p_end_date
185: ,p_comments => p_comments);
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_Validation_event'
191: ,p_hook_type => 'BP'
192: );
185: ,p_comments => p_comments);
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_Validation_event'
191: ,p_hook_type => 'BP'
192: );
193: end;
220: ,p_end_date => p_end_date
221: ,p_comments => p_comments);
222:
223: exception
224: when hr_api.cannot_find_prog_unit then
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'Update_Validation_event'
227: ,p_hook_type => 'AP'
228: );
221: ,p_comments => p_comments);
222:
223: exception
224: when hr_api.cannot_find_prog_unit then
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'Update_Validation_event'
227: ,p_hook_type => 'AP'
228: );
229: end;
230: --
231: -- When in validation only mode raise the Validate_Enabled exception
232: --
233: -- if p_validate then
234: -- raise hr_api.validate_enabled;
235: -- end if;
236: --
237: -- Set all output arguments
238: --
241:
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 70);
244: exception
245: when hr_api.validate_enabled then
246: --
247: -- As the Validate_Enabled exception has been raised
248: -- we must rollback to the savepoint
249: --
293: (p_validation_event_id => p_validation_event_id
294: ,p_object_version_number => p_object_version_number
295: );
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'delete_Validation_event'
300: ,p_hook_type => 'BP');
301: end;
294: ,p_object_version_number => p_object_version_number
295: );
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'delete_Validation_event'
300: ,p_hook_type => 'BP');
301: end;
302: --
316: ,p_object_version_number => p_object_version_number
317: );
318:
319: exception
320: when hr_api.cannot_find_prog_unit then
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'delete_Validation_event'
323: ,p_hook_type => 'AP');
324: end;
317: );
318:
319: exception
320: when hr_api.cannot_find_prog_unit then
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'delete_Validation_event'
323: ,p_hook_type => 'AP');
324: end;
325: --
325: --
326: -- When in validation only mode raise the Validate_Enabled exception
327: --
328: -- if p_validate then
329: -- raise hr_api.validate_enabled;
330: -- end if;
331: --
332: -- Set all output arguments
333: --
332: -- Set all output arguments
333: --
334: hr_utility.set_location(' Leaving:'||l_proc, 70);
335: exception
336: when hr_api.validate_enabled then
337: --
338: -- As the Validate_Enabled exception has been raised
339: -- we must rollback to the savepoint
340: --