54: l_end_date date;
55: l_swi_package_name varchar2(30) := 'IRC_INTERVIEW_DETAILS_SWI';
56: l_effective_date date;
57: begin
58: hr_utility.set_location('Entering:'|| l_proc, 10);
59: --
60: -- Issue a savepoint
61: --
62: savepoint create_irc_interview_details;
198: p_object_version_number := l_object_version_number;
199: p_start_date := l_start_date;
200: p_end_date := l_end_date;
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 70);
203: exception
204: when hr_api.validate_enabled then
205: --
206: -- As the Validate_Enabled exception has been raised
215: p_interview_details_id := null;
216: p_object_version_number := null;
217: p_start_date := null;
218: p_end_date := null;
219: hr_utility.set_location(' Leaving:'||l_proc, 80);
220: when others then
221: --
222: -- A validation or unexpected error has occured
223: --
229: p_interview_details_id := null;
230: p_object_version_number := null;
231: p_start_date := null;
232: p_end_date := null;
233: hr_utility.set_location(' Leaving:'||l_proc, 90);
234: raise;
235: end create_irc_interview_details;
236: --
237: --
282: l_end_date date;
283: l_effective_date date;
284: l_proc varchar2(72) := g_package||'update_irc_interview_details';
285: begin
286: hr_utility.set_location('Entering:'|| l_proc, 10);
287: --
288: -- Issue a savepoint
289: --
290: savepoint update_irc_interview_details;
430: p_object_version_number := l_object_version_number;
431: p_start_date := l_start_date;
432: p_end_date := l_end_date;
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 70);
435: exception
436: when hr_api.validate_enabled then
437: --
438: -- As the Validate_Enabled exception has been raised
445: -- when validation only mode is being used.)
446: --
447: p_start_date := null;
448: p_end_date := null;
449: hr_utility.set_location(' Leaving:'||l_proc, 80);
450: when others then
451: --
452: -- A validation or unexpected error has occured
453: --
457: -- OUT parameters, including warnings, to null
458: --
459: p_start_date := null;
460: p_end_date := null;
461: hr_utility.set_location(' Leaving:'||l_proc, 90);
462: raise;
463: end update_irc_interview_details;
464: --
465: end irc_interview_details_api;