[Home] [Help]
22: ,p_business_group_id in number
23: ,p_election_id in number
24: ,p_rank in number
25: ,p_role_id out nocopy number
26: ,p_ovn_per_roles out nocopy number
27: ) is
28:
29: --
30: -- Declare cursors and local variables
31: --
32:
33: l_proc varchar2(72) := g_package||'create_election_result';
34: l_job_group_id number;
35: l_role_id per_roles.role_id%TYPE;
36: l_ovn_election_candidates per_election_candidates.object_version_number%TYPE;
37: l_temp_ovn per_election_candidates.object_version_number%TYPE := p_ovn_election_candidates;
38: l_ovn_per_roles per_roles.object_version_number%TYPE;
39: l_effective_date date;
34: l_job_group_id number;
35: l_role_id per_roles.role_id%TYPE;
36: l_ovn_election_candidates per_election_candidates.object_version_number%TYPE;
37: l_temp_ovn per_election_candidates.object_version_number%TYPE := p_ovn_election_candidates;
38: l_ovn_per_roles per_roles.object_version_number%TYPE;
39: l_effective_date date;
40: l_start_date date;
41: l_end_date date;
42: --
65: close c_get_job_group_id;
66: --
67: -- store ovn passed in
68: l_ovn_election_candidates := p_ovn_election_candidates;
69: -- Call per_supplementary_role_api to create the record in per_roles
70: per_supplementary_role_api.create_supplementary_role
71: (p_effective_date => l_effective_date
72: ,p_job_group_id => l_job_group_id
73: ,p_job_id => p_job_id
75: ,p_start_date => l_start_date
76: ,p_end_date => l_end_date
77: ,p_primary_contact_flag => p_primary_contact_flag
78: ,p_role_id => l_role_id
79: ,p_object_version_number => l_ovn_per_roles);
80: --
81: -- Call the per_elc_candidate_api to insert the rank and
82: -- role for the candidate.
83:
100: -- Set all output arguments
101: --
102: p_role_id := l_role_id;
103: p_ovn_election_candidates := l_ovn_election_candidates;
104: p_ovn_per_roles := l_ovn_per_roles;
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 70);
107: exception
108: when hr_api.validate_enabled then
116: -- (Any key or derived arguments must be set to null
117: -- when validation only mode is being used.)
118: --
119: p_role_id := null;
120: p_ovn_per_roles := null;
121:
122: hr_utility.set_location(' Leaving:'||l_proc, 80);
123: when others then
124: --
128: --
129: -- set in out parameters and set out parameters
130: --
131: p_role_id := null;
132: p_ovn_per_roles := null;
133: p_ovn_election_candidates := l_temp_ovn;
134: hr_utility.set_location(' Leaving:'||l_proc, 90);
135: raise;
136: end create_election_result;
143: procedure update_election_result
144: (p_validate in boolean default false
145: ,p_effective_date in date
146: ,p_role_id in number
147: ,p_ovn_per_roles in out nocopy number
148: ,p_job_id in number default hr_api.g_number
149: ,p_person_id in number default hr_api.g_number
150: ,p_start_date in date default hr_api.g_date
151: ,p_end_date in date default hr_api.g_date
163:
164: l_proc varchar2(72) := g_package||'update_election_result';
165: l_job_group_id number;
166: l_ovn_election_candidates per_election_candidates.object_version_number%TYPE;
167: l_ovn_per_roles per_roles.object_version_number%TYPE;
168: l_effective_date date;
169: l_start_date date;
170: l_end_date date;
171: --
194: close c_get_job_group_id;
195: --
196: -- store ovn passed in
197: l_ovn_election_candidates := p_ovn_election_candidates;
198: l_ovn_per_roles := p_ovn_per_roles;
199:
200: -- Call per_supplementary_role_api to update the record in per_roles
201: per_supplementary_role_api.update_supplementary_role
202: (p_effective_date => l_effective_date
196: -- store ovn passed in
197: l_ovn_election_candidates := p_ovn_election_candidates;
198: l_ovn_per_roles := p_ovn_per_roles;
199:
200: -- Call per_supplementary_role_api to update the record in per_roles
201: per_supplementary_role_api.update_supplementary_role
202: (p_effective_date => l_effective_date
203: ,p_role_id => p_role_id
204: ,p_object_version_number => l_ovn_per_roles
200: -- Call per_supplementary_role_api to update the record in per_roles
201: per_supplementary_role_api.update_supplementary_role
202: (p_effective_date => l_effective_date
203: ,p_role_id => p_role_id
204: ,p_object_version_number => l_ovn_per_roles
205: ,p_start_date => l_start_date
206: ,p_end_date => l_end_date
207: ,p_primary_contact_flag => p_primary_contact_flag);
208: --
220: ,p_role_id => p_role_id);
221: -- Set all output arguments
222: --
223: p_ovn_election_candidates := l_ovn_election_candidates;
224: p_ovn_per_roles := l_ovn_per_roles;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 70);
227: exception
228: when hr_api.validate_enabled then
236: -- (Any key or derived arguments must be set to null
237: -- when validation only mode is being used.)
238: --
239: p_ovn_election_candidates := null;
240: p_ovn_per_roles := null;
241:
242: hr_utility.set_location(' Leaving:'||l_proc, 80);
243: when others then
244: --
248: --
249: -- set in out parameters and set out parameters
250: --
251: p_ovn_election_candidates := null;
252: p_ovn_per_roles := null;
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 90);
255: raise;
256: end update_election_result;