1 PACKAGE hr_process_address_ss AUTHID CURRENT_USER AS
2 /* $Header: hraddwrs.pkh 120.1 2011/11/15 12:00:54 sidsaxen ship $*/
3
4 gv_wf_review_region_item constant wf_item_attributes.name%type
5 := 'HR_REVIEW_REGION_ITEM';
6 g_date_format constant varchar2(10):='RRRR-MM-DD';
7
8 /*
9 ||===========================================================================
10 || PROCEDURE: create_person_address
11 ||---------------------------------------------------------------------------
12 ||
13 || Description:
14 || Description:
15 || This procedure will call the actual API -
16 || hr_person_address_api.create_person_address()
17 ||
18 || Pre Conditions:
19 ||
20 || In Arguments:
21 || Contains entire list of parameters that are defined in the actual
22 || API. For details see peaddapi.pkb file.
23 ||
24 || out nocopy Arguments:
25 ||
26 || In out nocopy Arguments:
27 ||
28 || Post Success:
29 || Executes the API call.
30 ||
31 || Post Failure:
32 || Raises an exception
33 ||
34 || Access Status:
35 || Public.
36 ||
37 ||===========================================================================
38 */
39 PROCEDURE create_person_address
40 (p_validate in number default 0
41 ,p_effective_date in date
42 ,p_pradd_ovlapval_override in number default 0
43 ,p_validate_county in number default 1
44 ,p_person_id in number
45 --
46 -- PB Add :
47 -- The transaction steps have to be created by the login personid.
48 -- In case of adding address for contacts person_id is contact_person_id.
49 -- Login person id is say employee who is adding the address to his contact.
50 --
51 ,p_login_person_id in number default null
52 ,p_business_group_id in number default null
53 ,p_primary_flag in varchar2
54 ,p_style in varchar2
55 ,p_date_from in date
56 ,p_date_to in date default null
57 ,p_address_type in varchar2 default hr_api.g_varchar2
58 ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
59 ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
60 ,p_address_line1 in varchar2 default hr_api.g_varchar2
61 ,p_address_line2 in varchar2 default hr_api.g_varchar2
62 ,p_address_line3 in varchar2 default hr_api.g_varchar2
63 ,p_town_or_city in varchar2 default hr_api.g_varchar2
64 ,p_region_1 in varchar2 default hr_api.g_varchar2
65 ,p_region_2 in varchar2 default hr_api.g_varchar2
66 ,p_region_3 in varchar2 default hr_api.g_varchar2
67 ,p_postal_code in varchar2 default hr_api.g_varchar2
68 ,p_country in varchar2 default hr_api.g_varchar2
69 ,p_country_meaning in varchar2 default hr_api.g_varchar2
70 ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
71 ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
72 ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
73 ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
74 ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
75 ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
76 ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
77 ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
78 ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
79 ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
80 ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
81 ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
82 ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
83 ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
84 ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
85 ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
86 ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
87 ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
88 ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
89 ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
90 ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
91 ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
92 ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
93 ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
94 ,p_add_information13 in varchar2 default hr_api.g_varchar2
95 ,p_add_information14 in varchar2 default hr_api.g_varchar2
96 ,p_add_information15 in varchar2 default hr_api.g_varchar2
97 ,p_add_information16 in varchar2 default hr_api.g_varchar2
98 ,p_add_information17 in varchar2 default hr_api.g_varchar2
99 ,p_add_information18 in varchar2 default hr_api.g_varchar2
100 ,p_add_information19 in varchar2 default hr_api.g_varchar2
101 ,p_add_information20 in varchar2 default hr_api.g_varchar2
102 ,p_address_id out nocopy number
103 ,p_object_version_number out nocopy number
104 -- StartRegistration
105 ,p_contact_or_person in varchar2 default null
106 -- EndRegistration
107 ,p_item_type in varchar2
108 ,p_item_key in varchar2
109 ,p_activity_id in number
110 ,p_action in varchar2
111 ,p_old_address_id in number default null
112 ,p_old_object_version_number in number default null
113 ,p_save_mode in varchar2 default null
114 ,p_error_message out nocopy long
115 ,p_contact_relationship_id in number default hr_api.g_number
116 );
117
118 /*
119 ||===========================================================================
120 || PROCEDURE: update_person_address
121 ||---------------------------------------------------------------------------
122 ||
123 || Description:
124 || Description:
125 || This procedure will call the actual API -
126 || hr_person_address_api.update_person_address()
127 ||
128 || Pre Conditions:
129 ||
130 || In Arguments:
131 || Contains entire list of parameters that are defined in the actual
132 || API. For details see peaddapi.pkb file.
133 ||
134 || out nocopy Arguments:
135 ||
136 || In out nocopy Arguments:
137 ||
138 || Post Success:
139 || Executes the API call.
140 ||
141 || Post Failure:
142 || Raises an exception
143 ||
144 || Access Status:
145 || Public.
146 ||
147 ||===========================================================================
148 */
149
150 PROCEDURE update_person_address
151 (p_validate in number default 0
152 ,p_effective_date in date
153 ,p_validate_county in number default 1
154 ,p_address_id in number
155 ,p_object_version_number in out nocopy number
156 ,p_date_from in date default hr_api.g_date
157 ,p_date_to in date default hr_api.g_date
158 ,p_address_type in varchar2 default hr_api.g_varchar2
159 ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
160 ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
161 ,p_address_line1 in varchar2 default hr_api.g_varchar2
162 ,p_address_line2 in varchar2 default hr_api.g_varchar2
163 ,p_address_line3 in varchar2 default hr_api.g_varchar2
164 ,p_town_or_city in varchar2 default hr_api.g_varchar2
165 ,p_region_1 in varchar2 default hr_api.g_varchar2
166 ,p_region_2 in varchar2 default hr_api.g_varchar2
167 ,p_region_3 in varchar2 default hr_api.g_varchar2
168 ,p_postal_code in varchar2 default hr_api.g_varchar2
169 ,p_country in varchar2 default hr_api.g_varchar2
170 ,p_country_meaning in varchar2 default hr_api.g_varchar2
171 ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
172 ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
173 ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
174 ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
175 ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
176 ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
177 ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
178 ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
179 ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
180 ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
181 ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
182 ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
183 ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
184 ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
185 ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
186 ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
187 ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
188 ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
189 ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
190 ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
191 ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
192 ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
193 ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
194 ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
195 ,p_add_information13 in varchar2 default hr_api.g_varchar2
196 ,p_add_information14 in varchar2 default hr_api.g_varchar2
197 ,p_add_information15 in varchar2 default hr_api.g_varchar2
198 ,p_add_information16 in varchar2 default hr_api.g_varchar2
199 ,p_add_information17 in varchar2 default hr_api.g_varchar2
200 ,p_add_information18 in varchar2 default hr_api.g_varchar2
201 ,p_add_information19 in varchar2 default hr_api.g_varchar2
202 ,p_add_information20 in varchar2 default hr_api.g_varchar2
203 ,p_item_type in varchar2
204 ,p_item_key in varchar2
205 ,p_activity_id in number
206 ,p_person_id in number
207 --
208 -- PB Add :
209 -- The transaction steps have to be created by the login personid.
210 -- In case of adding phones for contacts parent_is is contact_person_id.
211 -- Login person id is say employee who is adding the phones to his contact.
212 --
213 ,p_contact_or_person in varchar2 default null
214 ,p_login_person_id in number default null
215 ,p_primary_flag in varchar2
216 ,p_style in varchar2
217 ,p_action in varchar2
218 ,p_save_mode in varchar2 default null
219 ,p_error_message out nocopy long
220 ,p_contact_relationship_id in number default hr_api.g_number
221 );
222
223 -- ---------------------- < get_address_data_from_tt> -------------------------
224 -- ---------------------------------------------------------------------------
225 -- Purpose: This procedure will get transaction data which are pending for
226 -- approval in workflow for a given person id, workflow process name
227 -- and workflow activity name. This is the overloaded version.
228 -- ---------------------------------------------------------------------------
229
230 PROCEDURE get_address_data_from_tt
231 (p_item_type in varchar2
232 ,p_process_name in varchar2
233 ,p_activity_name in varchar2
234 ,p_current_person_id in varchar2
235 ,p_effective_date out nocopy date
236 ,p_person_id out nocopy number
237 ,p_address_id out nocopy number
238 ,p_object_version_number out nocopy number
239 ,p_primary_flag out nocopy varchar2
240 ,p_style out nocopy varchar2
241 ,p_date_from out nocopy date
242 ,p_date_to out nocopy date
243 ,p_address_type out nocopy varchar2
244 ,p_address_type_meaning out nocopy varchar2
245 ,p_comments out nocopy varchar2
246 ,p_address_line1 out nocopy varchar2
247 ,p_address_line2 out nocopy varchar2
248 ,p_address_line3 out nocopy varchar2
249 ,p_town_or_city out nocopy varchar2
250 ,p_region_1 out nocopy varchar2
251 ,p_region_2 out nocopy varchar2
252 ,p_region_3 out nocopy varchar2
253 ,p_postal_code out nocopy varchar2
254 ,p_country out nocopy varchar2
255 ,p_country_meaning out nocopy varchar2
256 ,p_telephone_number_1 out nocopy varchar2
257 ,p_telephone_number_2 out nocopy varchar2
258 ,p_telephone_number_3 out nocopy varchar2
259 ,p_addr_attribute_category out nocopy varchar2
260 ,p_addr_attribute1 out nocopy varchar2
261 ,p_addr_attribute2 out nocopy varchar2
262 ,p_addr_attribute3 out nocopy varchar2
263 ,p_addr_attribute4 out nocopy varchar2
264 ,p_addr_attribute5 out nocopy varchar2
265 ,p_addr_attribute6 out nocopy varchar2
266 ,p_addr_attribute7 out nocopy varchar2
267 ,p_addr_attribute8 out nocopy varchar2
268 ,p_addr_attribute9 out nocopy varchar2
269 ,p_addr_attribute10 out nocopy varchar2
270 ,p_addr_attribute11 out nocopy varchar2
271 ,p_addr_attribute12 out nocopy varchar2
272 ,p_addr_attribute13 out nocopy varchar2
273 ,p_addr_attribute14 out nocopy varchar2
274 ,p_addr_attribute15 out nocopy varchar2
275 ,p_addr_attribute16 out nocopy varchar2
276 ,p_addr_attribute17 out nocopy varchar2
277 ,p_addr_attribute18 out nocopy varchar2
278 ,p_addr_attribute19 out nocopy varchar2
279 ,p_addr_attribute20 out nocopy varchar2
280 ,p_add_information17 out nocopy varchar2
281 ,p_add_information18 out nocopy varchar2
282 ,p_add_information19 out nocopy varchar2
283 ,p_add_information20 out nocopy varchar2
284 ,p_action out nocopy varchar2
285 ,p_old_address_id out nocopy varchar2
286 ,p_add_information13 out nocopy varchar2
287 ,p_add_information14 out nocopy varchar2
288 ,p_add_information15 out nocopy varchar2
289 ,p_add_information16 out nocopy varchar2
290 );
291
292 -- ---------------------------------------------------------------------------
293 -- ---------------------- < get_address_data_from_tt> -------------------------
294 -- ---------------------------------------------------------------------------
295 -- Purpose: This procedure will get transaction data which are pending for
296 -- approval in workflow for a transaction step id.
297 -- ---------------------------------------------------------------------------
298
299 PROCEDURE get_address_data_from_tt
300 (p_transaction_step_id in number
301 ,p_effective_date out nocopy date
302 ,p_person_id out nocopy number
303 ,p_address_id out nocopy number
304 ,p_object_version_number out nocopy number
305 ,p_primary_flag out nocopy varchar2
306 ,p_style out nocopy varchar2
307 ,p_date_from out nocopy date
308 ,p_date_to out nocopy date
309 ,p_address_type out nocopy varchar2
310 ,p_address_type_meaning out nocopy varchar2
311 ,p_comments out nocopy varchar2
312 ,p_address_line1 out nocopy varchar2
313 ,p_address_line2 out nocopy varchar2
314 ,p_address_line3 out nocopy varchar2
315 ,p_town_or_city out nocopy varchar2
316 ,p_region_1 out nocopy varchar2
317 ,p_region_2 out nocopy varchar2
318 ,p_region_3 out nocopy varchar2
319 ,p_postal_code out nocopy varchar2
320 ,p_country out nocopy varchar2
321 ,p_country_meaning out nocopy varchar2
322 ,p_telephone_number_1 out nocopy varchar2
323 ,p_telephone_number_2 out nocopy varchar2
324 ,p_telephone_number_3 out nocopy varchar2
325 ,p_addr_attribute_category out nocopy varchar2
326 ,p_addr_attribute1 out nocopy varchar2
327 ,p_addr_attribute2 out nocopy varchar2
328 ,p_addr_attribute3 out nocopy varchar2
329 ,p_addr_attribute4 out nocopy varchar2
330 ,p_addr_attribute5 out nocopy varchar2
331 ,p_addr_attribute6 out nocopy varchar2
332 ,p_addr_attribute7 out nocopy varchar2
333 ,p_addr_attribute8 out nocopy varchar2
334 ,p_addr_attribute9 out nocopy varchar2
335 ,p_addr_attribute10 out nocopy varchar2
336 ,p_addr_attribute11 out nocopy varchar2
337 ,p_addr_attribute12 out nocopy varchar2
338 ,p_addr_attribute13 out nocopy varchar2
339 ,p_addr_attribute14 out nocopy varchar2
340 ,p_addr_attribute15 out nocopy varchar2
341 ,p_addr_attribute16 out nocopy varchar2
342 ,p_addr_attribute17 out nocopy varchar2
343 ,p_addr_attribute18 out nocopy varchar2
344 ,p_addr_attribute19 out nocopy varchar2
345 ,p_addr_attribute20 out nocopy varchar2
346 ,p_add_information17 out nocopy varchar2
347 ,p_add_information18 out nocopy varchar2
348 ,p_add_information19 out nocopy varchar2
349 ,p_add_information20 out nocopy varchar2
350 ,p_action out nocopy varchar2
351 ,p_old_address_id out nocopy varchar2
352 ,p_add_information13 out nocopy varchar2
353 ,p_add_information14 out nocopy varchar2
354 ,p_add_information15 out nocopy varchar2
355 ,p_add_information16 out nocopy varchar2
356 );
357
358 -- ---------------------------------------------------------------------------
359 -- ---------------------- < get_address_data_from_tt> -------------------------
360 -- ---------------------------------------------------------------------------
361 -- Purpose: This procedure will get transaction data which are saved earlier
362 -- in the current transaction. This is invoked when a user click BACK
363 -- button to go back from the Review page to Update page to correct
364 -- typos or make further changes. Hence, we need to use the item_type
365 -- item_key passed in to retrieve the transaction record.
366 -- This is an overloaded version.
367 -- ---------------------------------------------------------------------------
368 PROCEDURE get_address_data_from_tt
369 (p_item_type in varchar2
370 ,p_item_key in varchar2
371 ,p_activity_id in varchar2
372 ,p_trans_rec_count out nocopy number
373 ,p_effective_date out nocopy date
374 ,p_person_id out nocopy number
375 ,p_address_id out nocopy number
376 ,p_object_version_number out nocopy number
377 ,p_primary_flag out nocopy varchar2
378 ,p_style out nocopy varchar2
379 ,p_date_from out nocopy date
380 ,p_date_to out nocopy date
381 ,p_address_type out nocopy varchar2
382 ,p_address_type_meaning out nocopy varchar2
383 ,p_comments out nocopy varchar2
384 ,p_address_line1 out nocopy varchar2
385 ,p_address_line2 out nocopy varchar2
386 ,p_address_line3 out nocopy varchar2
387 ,p_town_or_city out nocopy varchar2
388 ,p_region_1 out nocopy varchar2
389 ,p_region_2 out nocopy varchar2
390 ,p_region_3 out nocopy varchar2
391 ,p_postal_code out nocopy varchar2
392 ,p_country out nocopy varchar2
393 ,p_country_meaning out nocopy varchar2
394 ,p_telephone_number_1 out nocopy varchar2
395 ,p_telephone_number_2 out nocopy varchar2
396 ,p_telephone_number_3 out nocopy varchar2
397 ,p_addr_attribute_category out nocopy varchar2
398 ,p_addr_attribute1 out nocopy varchar2
399 ,p_addr_attribute2 out nocopy varchar2
400 ,p_addr_attribute3 out nocopy varchar2
401 ,p_addr_attribute4 out nocopy varchar2
402 ,p_addr_attribute5 out nocopy varchar2
403 ,p_addr_attribute6 out nocopy varchar2
404 ,p_addr_attribute7 out nocopy varchar2
405 ,p_addr_attribute8 out nocopy varchar2
406 ,p_addr_attribute9 out nocopy varchar2
407 ,p_addr_attribute10 out nocopy varchar2
408 ,p_addr_attribute11 out nocopy varchar2
409 ,p_addr_attribute12 out nocopy varchar2
410 ,p_addr_attribute13 out nocopy varchar2
411 ,p_addr_attribute14 out nocopy varchar2
412 ,p_addr_attribute15 out nocopy varchar2
413 ,p_addr_attribute16 out nocopy varchar2
414 ,p_addr_attribute17 out nocopy varchar2
415 ,p_addr_attribute18 out nocopy varchar2
416 ,p_addr_attribute19 out nocopy varchar2
417 ,p_addr_attribute20 out nocopy varchar2
418 ,p_add_information17 out nocopy varchar2
419 ,p_add_information18 out nocopy varchar2
420 ,p_add_information19 out nocopy varchar2
421 ,p_add_information20 out nocopy varchar2
422 ,p_action out nocopy varchar2
423 ,p_old_address_id out nocopy varchar2
424 ,p_add_information13 out nocopy varchar2
425 ,p_add_information14 out nocopy varchar2
426 ,p_add_information15 out nocopy varchar2
427 ,p_add_information16 out nocopy varchar2
428 );
429
430
431 /*---------------------------------------------------------------------------+
432 | |
433 | Name : process_api |
434 | |
435 | Purpose : This will procedure is invoked whenever approver |
436 | approves the address change. |
437 | |
438 +-----------------------------------------------------------------------------*/
439 procedure process_api
440 (p_validate in boolean default false
441 ,p_transaction_step_id in number
442 ,p_effective_date in varchar2 default null
443 );
444
445 END hr_process_address_ss;