[Home] [Help]
PACKAGE BODY: APPS.HR_DEPLOYMENT_FACTOR_SWI
Source
1 Package Body hr_deployment_factor_swi as
2 /* $Header: pedpfswi.pkb 120.0 2005/05/31 07:45:37 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_deployment_factor_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-----------------------< create_person_dpmt_factor >-----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_person_dpmt_factor
13 (p_validate in number default hr_api.g_false_num
14 ,p_effective_date in date
15 ,p_person_id in number
16 ,p_work_any_country in varchar2
17 ,p_work_any_location in varchar2
18 ,p_relocate_domestically in varchar2
19 ,p_relocate_internationally in varchar2
20 ,p_travel_required in varchar2
21 ,p_country1 in varchar2 default null
22 ,p_country2 in varchar2 default null
23 ,p_country3 in varchar2 default null
24 ,p_work_duration in varchar2 default null
25 ,p_work_schedule in varchar2 default null
26 ,p_work_hours in varchar2 default null
27 ,p_fte_capacity in varchar2 default null
28 ,p_visit_internationally in varchar2 default null
29 ,p_only_current_location in varchar2 default null
30 ,p_no_country1 in varchar2 default null
31 ,p_no_country2 in varchar2 default null
32 ,p_no_country3 in varchar2 default null
33 ,p_comments in varchar2 default null
34 ,p_earliest_available_date in date default null
35 ,p_available_for_transfer in varchar2 default null
36 ,p_relocation_preference in varchar2 default null
37 ,p_attribute_category in varchar2 default null
38 ,p_attribute1 in varchar2 default null
39 ,p_attribute2 in varchar2 default null
40 ,p_attribute3 in varchar2 default null
41 ,p_attribute4 in varchar2 default null
42 ,p_attribute5 in varchar2 default null
43 ,p_attribute6 in varchar2 default null
44 ,p_attribute7 in varchar2 default null
45 ,p_attribute8 in varchar2 default null
46 ,p_attribute9 in varchar2 default null
47 ,p_attribute10 in varchar2 default null
48 ,p_attribute11 in varchar2 default null
49 ,p_attribute12 in varchar2 default null
50 ,p_attribute13 in varchar2 default null
51 ,p_attribute14 in varchar2 default null
52 ,p_attribute15 in varchar2 default null
53 ,p_attribute16 in varchar2 default null
54 ,p_attribute17 in varchar2 default null
55 ,p_attribute18 in varchar2 default null
56 ,p_attribute19 in varchar2 default null
57 ,p_attribute20 in varchar2 default null
58 ,p_deployment_factor_id out nocopy number
59 ,p_object_version_number out nocopy number
60 ) is
61 --
62 -- Declare cursors and local variables
63 --
64 l_effective_date date;
65 l_earliest_available_date date;
66 l_proc varchar2(72) := g_package||'create_person_dpmt_factor';
67 l_deployment_factor_id per_deployment_factors.deployment_factor_id%type;
68 l_object_version_number per_deployment_factors.object_version_number%type;
69 l_business_group_id per_all_people_f.business_group_id%type;
70 l_validate boolean;
71 --
72 --
73 begin
74 hr_utility.set_location('Entering:'|| l_proc, 10);
75 --
76 -- Issue a savepoint
77 --
78 savepoint create_person_dpmt_factor_swi;
79
80 l_validate :=
81 hr_api.constant_to_boolean
82 (p_constant_value => p_validate);
83
84 -- Call the Deployment API
85 hr_deployment_factor_api.create_person_dpmt_factor
86 (p_validate => l_validate
87 ,p_effective_date => p_effective_date
88 ,p_person_id => p_person_id
89 ,p_work_any_country => p_work_any_country
90 ,p_work_any_location => p_work_any_location
91 ,p_relocate_domestically => p_relocate_domestically
92 ,p_relocate_internationally => p_relocate_internationally
93 ,p_travel_required => p_travel_required
94 ,p_country1 => p_country1
95 ,p_country2 => p_country2
96 ,p_country3 => p_country3
97 ,p_work_duration => p_work_duration
98 ,p_work_schedule => p_work_schedule
99 ,p_work_hours => p_work_hours
100 ,p_fte_capacity => p_fte_capacity
101 ,p_visit_internationally => p_visit_internationally
102 ,p_only_current_location => p_only_current_location
103 ,p_no_country1 => p_no_country1
104 ,p_no_country2 => p_no_country2
105 ,p_no_country3 => p_no_country3
106 ,p_comments => p_comments
107 ,p_earliest_available_date => p_earliest_available_date
108 ,p_available_for_transfer => p_available_for_transfer
109 ,p_relocation_preference => p_relocation_preference
110 ,p_attribute_category => p_attribute_category
111 ,p_attribute1 => p_attribute1
112 ,p_attribute2 => p_attribute2
113 ,p_attribute3 => p_attribute3
114 ,p_attribute4 => p_attribute4
115 ,p_attribute5 => p_attribute5
116 ,p_attribute6 => p_attribute6
117 ,p_attribute7 => p_attribute7
118 ,p_attribute8 => p_attribute8
119 ,p_attribute9 => p_attribute9
120 ,p_attribute10 => p_attribute10
121 ,p_attribute11 => p_attribute11
122 ,p_attribute12 => p_attribute12
123 ,p_attribute13 => p_attribute13
124 ,p_attribute14 => p_attribute14
125 ,p_attribute15 => p_attribute15
126 ,p_attribute16 => p_attribute16
127 ,p_attribute17 => p_attribute17
128 ,p_attribute18 => p_attribute18
129 ,p_attribute19 => p_attribute19
130 ,p_attribute20 => p_attribute20
131 ,p_deployment_factor_id => l_deployment_factor_id
132 ,p_object_version_number => l_object_version_number);
133
134 --
135 -- Truncate the time portion from all IN date parameters
136 --
137
138 -- Set all output arguments
139 --
140 p_deployment_factor_id := l_deployment_factor_id;
141 p_object_version_number := l_object_version_number;
142 --
143 hr_utility.set_location(' Leaving:'||l_proc, 20);
144 exception
145 when others then
146 --
147 -- A validation or unexpected error has occured
148 --
149 rollback to create_person_dpmt_factor_swi;
150 --
151 -- set in out parameters and set out parameters
152 --
153 p_deployment_factor_id := null;
154 p_object_version_number := null;
155 --
156 hr_utility.set_location(' Leaving:'||l_proc, 30);
157 raise;
158 end create_person_dpmt_factor;
159 --
160 -- ----------------------------------------------------------------------------
161 -- |-----------------------< update_person_dpmt_factor >-----------------------|
162 -- ----------------------------------------------------------------------------
163 --
164 procedure update_person_dpmt_factor
165 (p_validate in number default hr_api.g_false_num
166 ,p_effective_date in date
167 ,p_deployment_factor_id in number
168 ,p_object_version_number in out nocopy number
169 ,p_work_any_country in varchar2 default hr_api.g_varchar2
170 ,p_work_any_location in varchar2 default hr_api.g_varchar2
171 ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
172 ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
173 ,p_travel_required in varchar2 default hr_api.g_varchar2
174 ,p_country1 in varchar2 default hr_api.g_varchar2
175 ,p_country2 in varchar2 default hr_api.g_varchar2
176 ,p_country3 in varchar2 default hr_api.g_varchar2
177 ,p_work_duration in varchar2 default hr_api.g_varchar2
178 ,p_work_schedule in varchar2 default hr_api.g_varchar2
179 ,p_work_hours in varchar2 default hr_api.g_varchar2
180 ,p_fte_capacity in varchar2 default hr_api.g_varchar2
181 ,p_visit_internationally in varchar2 default hr_api.g_varchar2
182 ,p_only_current_location in varchar2 default hr_api.g_varchar2
183 ,p_no_country1 in varchar2 default hr_api.g_varchar2
184 ,p_no_country2 in varchar2 default hr_api.g_varchar2
185 ,p_no_country3 in varchar2 default hr_api.g_varchar2
186 ,p_comments in varchar2 default hr_api.g_varchar2
187 ,p_earliest_available_date in date default hr_api.g_date
188 ,p_available_for_transfer in varchar2 default hr_api.g_varchar2
189 ,p_relocation_preference in varchar2 default hr_api.g_varchar2
190 ,p_attribute_category in varchar2 default hr_api.g_varchar2
191 ,p_attribute1 in varchar2 default hr_api.g_varchar2
192 ,p_attribute2 in varchar2 default hr_api.g_varchar2
193 ,p_attribute3 in varchar2 default hr_api.g_varchar2
194 ,p_attribute4 in varchar2 default hr_api.g_varchar2
195 ,p_attribute5 in varchar2 default hr_api.g_varchar2
196 ,p_attribute6 in varchar2 default hr_api.g_varchar2
197 ,p_attribute7 in varchar2 default hr_api.g_varchar2
198 ,p_attribute8 in varchar2 default hr_api.g_varchar2
199 ,p_attribute9 in varchar2 default hr_api.g_varchar2
200 ,p_attribute10 in varchar2 default hr_api.g_varchar2
201 ,p_attribute11 in varchar2 default hr_api.g_varchar2
202 ,p_attribute12 in varchar2 default hr_api.g_varchar2
203 ,p_attribute13 in varchar2 default hr_api.g_varchar2
204 ,p_attribute14 in varchar2 default hr_api.g_varchar2
205 ,p_attribute15 in varchar2 default hr_api.g_varchar2
206 ,p_attribute16 in varchar2 default hr_api.g_varchar2
207 ,p_attribute17 in varchar2 default hr_api.g_varchar2
208 ,p_attribute18 in varchar2 default hr_api.g_varchar2
209 ,p_attribute19 in varchar2 default hr_api.g_varchar2
210 ,p_attribute20 in varchar2 default hr_api.g_varchar2
211 ) is
212 --r
213 -- Declare cursors and local vaiables
214 --
215 l_effective_date date;
216 l_earliest_available_date date;
217 l_proc varchar2(72) := g_package||'update_person_dpmt_factor';
218 l_object_version_number per_deployment_factors.object_version_number%type;
219 l_ovn per_deployment_factors.object_version_number%type := p_object_version_number;
220 l_api_updating boolean;
221 l_validate boolean;
222 --
223 begin
224 hr_utility.set_location('Entering:'|| l_proc, 10);
225 --
226 -- Issue a savepoint
227 --
228 savepoint update_person_dpmt_factor_swi;
229
230 l_validate :=
231 hr_api.constant_to_boolean
232 (p_constant_value => p_validate);
233
234 hr_deployment_factor_api.update_person_dpmt_factor
235 (p_validate => l_validate
236 ,p_effective_date => p_effective_date
237 ,p_deployment_factor_id => p_deployment_factor_id
238 ,p_object_version_number => p_object_version_number
239 ,p_work_any_country => p_work_any_country
240 ,p_work_any_location => p_work_any_location
241 ,p_relocate_domestically => p_relocate_domestically
242 ,p_relocate_internationally => p_relocate_internationally
243 ,p_travel_required => p_travel_required
244 ,p_country1 => p_country1
245 ,p_country2 => p_country2
246 ,p_country3 => p_country3
247 ,p_work_duration => p_work_duration
248 ,p_work_schedule => p_work_schedule
249 ,p_work_hours => p_work_hours
250 ,p_fte_capacity => p_fte_capacity
251 ,p_visit_internationally => p_visit_internationally
252 ,p_only_current_location => p_only_current_location
253 ,p_no_country1 => p_no_country1
254 ,p_no_country2 => p_no_country2
255 ,p_no_country3 => p_no_country3
256 ,p_comments => p_comments
257 ,p_earliest_available_date => p_earliest_available_date
258 ,p_available_for_transfer => p_available_for_transfer
259 ,p_relocation_preference => p_relocation_preference
260 ,p_attribute_category => p_attribute_category
261 ,p_attribute1 => p_attribute1
262 ,p_attribute2 => p_attribute2
263 ,p_attribute3 => p_attribute3
264 ,p_attribute4 => p_attribute4
265 ,p_attribute5 => p_attribute5
266 ,p_attribute6 => p_attribute6
267 ,p_attribute7 => p_attribute7
268 ,p_attribute8 => p_attribute8
269 ,p_attribute9 => p_attribute9
270 ,p_attribute10 => p_attribute10
271 ,p_attribute11 => p_attribute11
272 ,p_attribute12 => p_attribute12
273 ,p_attribute13 => p_attribute13
274 ,p_attribute14 => p_attribute14
275 ,p_attribute15 => p_attribute15
276 ,p_attribute16 => p_attribute16
277 ,p_attribute17 => p_attribute17
278 ,p_attribute18 => p_attribute18
279 ,p_attribute19 => p_attribute19
280 ,p_attribute20 => p_attribute20);
281
282 --
283 -- Set all output arguments
284 --
285 p_object_version_number := l_object_version_number;
286 --
287 hr_utility.set_location(' Leaving:'||l_proc, 20);
288 exception
289 when others then
290 --
291 -- A validation or unexpected error has occured
292 --
293 rollback to update_person_dpmt_factor_swi;
294 --
295 -- set in out parameters and set out parameters
296 --
297 p_object_version_number := l_ovn;
298 --
299 hr_utility.set_location(' Leaving:'||l_proc, 30);
300 raise;
301 end update_person_dpmt_factor;
302 --
303 end hr_deployment_factor_swi;