[Home] [Help]
95: --
96: l_proc varchar2(72) := g_package||'create_election_information';
97: --
98: begin
99: hr_utility.set_location('Entering:'|| l_proc, 12);
100: --
101: -- Issue a savepoint
102: --
103: savepoint create_election_information;
103: savepoint create_election_information;
104: --
105: -- Check that p_rep_body_id, p_business_group_id, election_date are not null.
106: --
107: hr_utility.set_location('Entering mandatory arg check', 20);
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc,
111: p_argument => 'rep_body_id',
127: p_argument_value => p_election_date);
128: --
129: l_effective_date := trunc(p_effective_date);
130: --
131: hr_utility.set_location('Entering: call - create_election_information_b ', 30);
132: --
133: begin
134:
135:
213: );
214:
215: end;
216: --
217: hr_utility.set_location('Entering: call - per_elc_ins.ins ', 40);
218: --
219: per_elc_ins.ins
220: (p_effective_date => l_effective_date
221: ,p_validate => FALSE
291: ,p_election_id => l_election_id
292: ,p_object_version_number => l_object_version_number
293: );
294: --
295: hr_utility.set_location('Entering: call - create_election_information_a', 50);
296: --
297: begin
298: hr_elections_api_bk1.create_election_information_a
299: (p_effective_date => l_effective_date
389: --
390: p_election_id := l_election_id;
391: p_object_version_number := l_object_version_number;
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 70);
394: exception
395: when hr_api.validate_enabled then
396: --
397: -- As the Validate_Enabled exception has been raised
405: --
406: p_election_id := null;
407: p_object_version_number := null;
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 80);
410: when others then
411: --
412: -- A validation or unexpected error has occured
413: --
417: --
418: p_election_id := null;
419: p_object_version_number := null;
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 90);
422: raise;
423: end create_election_information;
424: --
425:
514: --
515: l_proc varchar2(72) := g_package||'update_election_information';
516: --
517: begin
518: hr_utility.set_location('Entering:'|| l_proc, 10);
519: --
520: -- Issue a savepoint
521: --
522: savepoint update_election_information;
522: savepoint update_election_information;
523: --
524: -- Check that p_rep_body_id, p_business_group_id, election_date are not null.
525: --
526: hr_utility.set_location('Entering mandatory arg check', 20);
527: --
528: hr_api.mandatory_arg_error
529: (p_api_name => l_proc,
530: p_argument => 'rep_body_id',
546: p_argument_value => p_election_date);
547: --
548: l_effective_date := trunc(p_effective_date);
549: --
550: hr_utility.set_location('Entering: call - update_election_information_b ', 30);
551: --
552: begin
553:
554: hr_elections_api_bk2.update_election_information_b
633: );
634:
635: end;
636: --
637: hr_utility.set_location('Entering: call - per_elc_upd.upd ', 40);
638: --
639: l_object_version_number := p_object_version_number;
640: --
641: --
714: ,p_election_information29 => p_election_information29
715: ,p_election_information30 => p_election_information30
716: );
717: --
718: hr_utility.set_location('Entering: call - update_election_information_a', 50);
719: --
720: begin
721: --
722: hr_elections_api_bk2.update_election_information_a
808: raise hr_api.validate_enabled;
809: end if;
810: --
811: --
812: hr_utility.set_location(' Leaving:'||l_proc, 70);
813: exception
814: when hr_api.validate_enabled then
815: --
816: -- As the Validate_Enabled exception has been raised
823: -- when validation only mode is being used.)
824: --
825: p_object_version_number := l_object_version_number;
826: --
827: hr_utility.set_location(' Leaving:'||l_proc, 80);
828: when others then
829: --
830: -- A validation or unexpected error has occured
831: --
834: -- set in out parameters and set out parameters
835: --
836: p_object_version_number := l_ovn;
837: p_election_id := null;
838: hr_utility.set_location(' Leaving:'||l_proc, 90);
839: raise;
840: end update_election_information;
841: --
842: -- ----------------------------------------------------------------------------
854: l_proc varchar2(72) := (g_package||'delete_election_information');
855: --
856: begin
857: --
858: hr_utility.set_location('Entering:'|| l_proc, 10);
859: --
860: -- Issue a savepoint if operating in validation only mode
861: --
862: savepoint delete_election_information;
860: -- Issue a savepoint if operating in validation only mode
861: --
862: savepoint delete_election_information;
863: --
864: hr_utility.set_location(l_proc, 20);
865: --
866: -- Process Logic
867: --
868: --
912: -- End of API User Hook for the after hook of delete_election_information
913: --
914: end;
915: --
916: hr_utility.set_location(l_proc, 60);
917: --
918: -- When in validation only mode raise the Validate_Enabled exception
919: --
920: if p_validate then
920: if p_validate then
921: raise hr_api.validate_enabled;
922: end if;
923: --
924: hr_utility.set_location(' Leaving:'||l_proc, 70);
925: --
926: exception
927: --
928: when hr_api.validate_enabled then