[Home] [Help]
60: --
61: l_proc varchar2(72) := g_package||'create_election_constituency';
62: --
63: begin
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Issue a savepoint
67: --
68: savepoint create_elec_con;
68: savepoint create_elec_con;
69: --
70: -- Check that p_election_id, p_business_group_id, p_constituency_id are not null.
71: --
72: hr_utility.set_location('Entering mandatory arg check', 20);
73: --
74: hr_api.mandatory_arg_error
75: (p_api_name => l_proc,
76: p_argument => 'election_id',
92: p_argument_value => p_effective_date);
93: --
94: l_effective_date := trunc(p_effective_date);
95: --
96: hr_utility.set_location('Entering: call - create_election_constituency_b ', 30);
97: --
98: begin
99:
100: hr_elc_constituencys_api_bk1.create_election_constituency_b
142: );
143:
144: end;
145: --
146: hr_utility.set_location('Entering: call - per_eco_ins.ins ', 40);
147: --
148: per_eco_ins.ins
149: (p_effective_date => l_effective_date
150: ,p_validate => FALSE
185: ,p_election_constituency_id => l_election_constituency_id
186: ,p_object_version_number => l_object_version_number
187: );
188: --
189: hr_utility.set_location('Entering: call - create_election_constits_a', 50);
190: --
191: begin
192: hr_elc_constituencys_api_bk1.create_election_constituency_a
193: (p_effective_date => l_effective_date
247: --
248: p_election_constituency_id := l_election_constituency_id;
249: p_object_version_number := l_object_version_number;
250: --
251: hr_utility.set_location(' Leaving:'||l_proc, 70);
252: exception
253: when hr_api.validate_enabled then
254: --
255: -- As the Validate_Enabled exception has been raised
263: --
264: p_election_constituency_id := null;
265: p_object_version_number := null;
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 80);
268: when others then
269: --
270: -- A validation or unexpected error has occured
271: --
275: --
276: p_election_constituency_id := null;
277: p_object_version_number := null;
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 90);
280: raise;
281: end create_election_constituency;
282: --
283:
336: --
337: l_proc varchar2(72) := g_package||'update_election_constituency';
338: --
339: begin
340: hr_utility.set_location('Entering:'|| l_proc, 10);
341: --
342: -- Issue a savepoint
343: --
344: savepoint update_election_constituency;
344: savepoint update_election_constituency;
345: --
346: -- Check that p_constituency_id, p_business_group_id, election_id are not null.
347: --
348: hr_utility.set_location('Entering mandatory arg check', 20);
349: --
350: hr_api.mandatory_arg_error
351: (p_api_name => l_proc,
352: p_argument => 'constituency_id',
368: p_argument_value => p_election_id);
369: --
370: l_effective_date := trunc(p_effective_date);
371: --
372: hr_utility.set_location('Entering: call - update_election_constituency_b ', 30);
373: --
374: begin
375:
376: hr_elc_constituencys_api_bk2.update_election_constituency_b
420: );
421:
422: end;
423: --
424: hr_utility.set_location('Entering: call - per_eco_upd.upd ', 40);
425: --
426: l_object_version_number := p_object_version_number;
427: --
428: --
466: ,p_attribute30 => p_attribute30
467: ,p_object_version_number => p_object_version_number
468: );
469: --
470: hr_utility.set_location('Entering: call - update_election_constituency_a', 50);
471: --
472: begin
473: --
474: hr_elc_constituencys_api_bk2.update_election_constituency_a
525: raise hr_api.validate_enabled;
526: end if;
527: --
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 70);
530: exception
531: when hr_api.validate_enabled then
532: --
533: -- As the Validate_Enabled exception has been raised
540: -- when validation only mode is being used.)
541: --
542: p_object_version_number := l_object_version_number;
543: --
544: hr_utility.set_location(' Leaving:'||l_proc, 80);
545: when others then
546: --
547: -- A validation or unexpected error has occured
548: --
551: -- set in out parameters and set out parameters
552: --
553: p_object_version_number := l_object_version_number;
554: p_election_constituency_id := null;
555: hr_utility.set_location(' Leaving:'||l_proc, 90);
556: raise;
557: end update_election_constituency;
558: --
559: -- ----------------------------------------------------------------------------
578: where election_constituency_id = p_election_constituency_id;
579: --
580: begin
581: --
582: hr_utility.set_location('Entering:'|| l_proc, 10);
583: --
584: -- Issue a savepoint if operating in validation only mode
585: --
586: savepoint delete_election_constituency;
584: -- Issue a savepoint if operating in validation only mode
585: --
586: savepoint delete_election_constituency;
587: --
588: hr_utility.set_location(l_proc, 20);
589: --
590: -- Process Logic
591: --
592: hr_api.mandatory_arg_error
649: -- End of API User Hook for the after hook of delete_election_constituency
650: --
651: end;
652: --
653: hr_utility.set_location(l_proc, 60);
654: --
655: -- When in validation only mode raise the Validate_Enabled exception
656: --
657: if p_validate then
657: if p_validate then
658: raise hr_api.validate_enabled;
659: end if;
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 70);
662: --
663: exception
664: --
665: when hr_api.validate_enabled then