67: l_date_end date := trunc(p_date_end);
68: l_date_closing date := trunc(p_date_closing);
69: --last_posted_date is not truncated to keep the time portion
70: begin
71: hr_utility.set_location('Entering:'|| l_proc, 10);
72: --
73: -- Issue a savepoint
74: --
75: savepoint CREATE_RECRUITMENT_ACTIVITY;
251: --
252: p_recruitment_activity_id := l_recruitment_activity_id;
253: p_object_version_number := l_object_version_number;
254: --
255: hr_utility.set_location(' Leaving:'||l_proc, 70);
256: exception
257: when hr_api.validate_enabled then
258: --
259: -- As the Validate_Enabled exception has been raised
273: --
274: p_recruitment_activity_id := null;
275: p_object_version_number := null;
276: rollback to CREATE_RECRUITMENT_ACTIVITY ;
277: hr_utility.set_location(' Leaving:'||l_proc, 90);
278: raise;
279: end CREATE_RECRUITMENT_ACTIVITY ;
280: --
281: -- -----------------------------------------------------------------------------
337: l_date_end date := trunc(p_date_end);
338: l_date_closing date := trunc(p_date_closing);
339: l_object_version_number number := p_object_version_number;
340: begin
341: hr_utility.set_location('Entering:'|| l_proc, 10);
342: --
343: -- Issue a savepoint
344: --
345: savepoint UPDATE_RECRUITMENT_ACTIVITY;
519: -- Set all output arguments
520: --
521: p_object_version_number := l_object_version_number;
522: --
523: hr_utility.set_location(' Leaving:'||l_proc, 70);
524: exception
525: when hr_api.validate_enabled then
526: --
527: -- As the Validate_Enabled exception has been raised
533: -- (Any key or derived arguments must be set to null
534: -- when validation only mode is being used.)
535: --
536: p_object_version_number := null;
537: hr_utility.set_location(' Leaving:'||l_proc, 80);
538: when others then
539: --
540: -- A validation or unexpected error has occured
541: --
540: -- A validation or unexpected error has occured
541: --
542: p_object_version_number := null;
543: rollback to UPDATE_RECRUITMENT_ACTIVITY ;
544: hr_utility.set_location(' Leaving:'||l_proc, 90);
545: raise;
546: end UPDATE_RECRUITMENT_ACTIVITY;
547: --
548: -- -----------------------------------------------------------------------------
559: --
560: l_proc varchar2(72) := g_package||'DELETE_RECRUITMENT_ACTIVITY ';
561:
562: begin
563: hr_utility.set_location('Entering:'|| l_proc, 10);
564: --
565:
566: -- Issue a savepoint
567: --
618: --
619: -- Set all output arguments
620: --
621: --
622: hr_utility.set_location(' Leaving:'||l_proc, 70);
623: exception
624: when hr_api.validate_enabled then
625: --
626: -- As the Validate_Enabled exception has been raised
631: -- Only set output warning arguments
632: -- (Any key or derived arguments must be set to null
633: -- when validation only mode is being used.)
634: --
635: hr_utility.set_location(' Leaving:'||l_proc, 80);
636: when others then
637: --
638: -- A validation or unexpected error has occured
639: --
637: --
638: -- A validation or unexpected error has occured
639: --
640: rollback to DELETE_RECRUITMENT_ACTIVITY ;
641: hr_utility.set_location(' Leaving:'||l_proc, 90);
642: raise;
643: end DELETE_RECRUITMENT_ACTIVITY;
644: --
645: end PER_RECRUITMENT_ACTIVITY_API;