4 -- ---------------------------------------------------------------------------+
1 PACKAGE hr_process_contact_ss AUTHID CURRENT_USER AS
2 /* $Header: hrconwrs.pkh 120.4 2011/11/15 11:59:17 sidsaxen ship $*/
3 --
5 -- ---------------------- < get_contact_relationship_tt> -------------------------
6 -- ---------------------------------------------------------------------------
7 -- Purpose: This procedure will get transaction data which are saved earlier
8 -- in the current transaction. This is invoked when a user click BACK
9 -- button to go back from the Review page to Update page to correct
10 -- typos or make further changes. Hence, we need to use the item_type
11 -- item_key passed in to retrieve the transaction record.
12 -- This is an overloaded version.
13 -- ---------------------------------------------------------------------------
14 --
15 g_is_address_updated boolean := false;
16 g_date_format constant varchar2(10):='RRRR/MM/DD';
17 g_correct constant varchar2(10) := 'CORRECT';
18 g_change constant varchar2(10) := 'CHANGE';
19 g_attribute_update constant varchar2(100) := 'ATTRIBUTE_UPDATE';
20 g_attribute_correct constant varchar2(100) := 'ATTRIBUTE_CORRECTION';
21 g_update_for_approval constant varchar2(100) := 'UPDATE_FOR_APPROVAL';
22 g_update_basic_details constant varchar2(100) := 'UPDATE_BASIC_DETAILS';
23 g_trans_actvty_result_code constant varchar2(100) := 'NEXT';
24 g_contact_person_id number;
25 -- ----------------------------------------------------------------------------
26 -- Following global variables will hold the Function Attribute
27 -- Internal Name. ( For Workflow )
28 -- ----------------------------------------------------------------------------
29 g_basic_details VARCHAR2(100) := 'BASIC_DETAILS';
30 g_contacts VARCHAR2(100) := 'CONTACTS';
31 g_phone_numbers VARCHAR2(100) := 'PHONE_NUMBERS';
32 g_main_address VARCHAR2(100) := 'MAIN_ADDRESS';
33 g_secondary_address VARCHAR2(100) := 'SECONDARY_ADDRESS';
34 --
35 --
36 -- ---------------------------------------------------------------------------
37 -- ---------------------- < get_contact_relationship_tt> -------------------------
38 -- ---------------------------------------------------------------------------
39 -- Purpose: This procedure will get which regions are changed in earlier save
40 -- in the current transaction. This is invoked when a user click BACK
41 -- button to go back from the Review page to Update page to correct
45 -- Based on the output of this procedure Review page layout is built.
42 -- typos or make further changes. Hence, we need to use the item_type
43 -- item_key passed in to retrieve the transaction record.
44 -- This is also used when the user first time navigates to review page.
46 -- Ex : If contacts and phone changed then both are shown, if Only
47 -- phone changed then shows phone data.
48 -- ---------------------------------------------------------------------------
49 --
50 PROCEDURE get_contact_regions_status_tt
51 (p_item_type in varchar2
52 ,p_item_key in varchar2
53 ,p_activity_id in varchar2
54 ,p_trans_rec_count out nocopy number
55 ,p_contact_changed out nocopy varchar2
56 ,p_phone_changed out nocopy varchar2
57 ,p_address_changed out nocopy varchar2
58 ,p_second_address_changed out nocopy varchar2
59 ,p_parent_id out nocopy varchar2
60 ,p_contact_person_id out nocopy varchar2
61 ,p_contact_relationship_id out nocopy varchar2
62 ,p_contact_operation out nocopy varchar2
63 ,p_shared_Residence_Flag out nocopy varchar2
64 ,p_save_mode out nocopy varchar2
65 ,p_address_id out nocopy varchar2
66 ,p_contact_step_id out nocopy varchar2
67 ,p_phone_step_id out nocopy varchar2
68 ,p_address_step_id out nocopy varchar2
69 ,p_second_address_step_id out nocopy varchar2
70 ,p_first_name out nocopy varchar2
71 ,p_last_name out nocopy varchar2
72 ,p_contact_set in varchar2
73 );
74 --
75 PROCEDURE get_contact_relationship_tt
76 (p_item_type in varchar2
77 ,p_item_key in varchar2
78 ,p_activity_id in number
79 ,p_trans_rec_count out nocopy number
80 ,p_effective_date out nocopy date
81 ,p_attribute_update_mode out nocopy varchar2
82 ,P_CONTACT_RELATIONSHIP_ID out nocopy NUMBER
83 ,P_CONTACT_TYPE out nocopy VARCHAR2
84 ,P_COMMENTS out nocopy VARCHAR2
85 ,P_PRIMARY_CONTACT_FLAG out nocopy VARCHAR2
86 ,P_THIRD_PARTY_PAY_FLAG out nocopy VARCHAR2
87 ,p_bondholder_flag out nocopy varchar2
88 ,p_date_start out nocopy date
89 ,p_start_life_reason_id out nocopy number
90 ,p_date_end out nocopy date
91 ,p_end_life_reason_id out nocopy number
92 ,p_rltd_per_rsds_w_dsgntr_flag out nocopy varchar2
93 ,p_personal_flag out nocopy varchar2
94 ,p_sequence_number out nocopy number
95 ,p_dependent_flag out nocopy varchar2
96 ,p_beneficiary_flag out nocopy varchar2
97 ,p_cont_attribute_category out nocopy varchar2
98 ,p_cont_attribute1 out nocopy varchar2
99 ,p_cont_attribute2 out nocopy varchar2
100 ,p_cont_attribute3 out nocopy varchar2
101 ,p_cont_attribute4 out nocopy varchar2
102 ,p_cont_attribute5 out nocopy varchar2
103 ,p_cont_attribute6 out nocopy varchar2
104 ,p_cont_attribute7 out nocopy varchar2
105 ,p_cont_attribute8 out nocopy varchar2
106 ,p_cont_attribute9 out nocopy varchar2
107 ,p_cont_attribute10 out nocopy varchar2
108 ,p_cont_attribute11 out nocopy varchar2
109 ,p_cont_attribute12 out nocopy varchar2
110 ,p_cont_attribute13 out nocopy varchar2
111 ,p_cont_attribute14 out nocopy varchar2
112 ,p_cont_attribute15 out nocopy varchar2
113 ,p_cont_attribute16 out nocopy varchar2
114 ,p_cont_attribute17 out nocopy varchar2
115 ,p_cont_attribute18 out nocopy varchar2
116 ,p_cont_attribute19 out nocopy varchar2
117 ,p_cont_attribute20 out nocopy varchar2
118 ,P_CONT_INFORMATION_CATEGORY out nocopy varchar2
119 ,P_CONT_INFORMATION1 out nocopy varchar2
120 ,P_CONT_INFORMATION2 out nocopy varchar2
121 ,P_CONT_INFORMATION3 out nocopy varchar2
122 ,P_CONT_INFORMATION4 out nocopy varchar2
123 ,P_CONT_INFORMATION5 out nocopy varchar2
124 ,P_CONT_INFORMATION6 out nocopy varchar2
125 ,P_CONT_INFORMATION7 out nocopy varchar2
126 ,P_CONT_INFORMATION8 out nocopy varchar2
127 ,P_CONT_INFORMATION9 out nocopy varchar2
128 ,P_CONT_INFORMATION10 out nocopy varchar2
129 ,P_CONT_INFORMATION11 out nocopy varchar2
130 ,P_CONT_INFORMATION12 out nocopy varchar2
131 ,P_CONT_INFORMATION13 out nocopy varchar2
132 ,P_CONT_INFORMATION14 out nocopy varchar2
133 ,P_CONT_INFORMATION15 out nocopy varchar2
134 ,P_CONT_INFORMATION16 out nocopy varchar2
135 ,P_CONT_INFORMATION17 out nocopy varchar2
136 ,P_CONT_INFORMATION18 out nocopy varchar2
137 ,P_CONT_INFORMATION19 out nocopy varchar2
138 ,P_CONT_INFORMATION20 out nocopy varchar2
139 ,p_object_version_number out nocopy number
140 ,p_review_proc_call out nocopy varchar2
141 );
142 --
143 --
144 -- ---------------------------------------------------------------------------
148 -- approval in workflow for a transaction step id.
145 -- ---------------------- < get_contact_relationship_tt> -------------------------
146 -- ---------------------------------------------------------------------------
147 -- Purpose: This procedure will get transaction data which are pending for
149 -- This is the procedure which does the actual work.
150 -- ---------------------------------------------------------------------------
151 procedure get_contact_relationship_tt
152 (p_transaction_step_id in number
153 ,p_effective_date out nocopy date
154 ,p_attribute_update_mode out nocopy varchar2
155 ,P_CONTACT_RELATIONSHIP_ID out nocopy NUMBER
156 ,P_CONTACT_TYPE out nocopy VARCHAR2
157 ,P_COMMENTS out nocopy VARCHAR2
158 ,P_PRIMARY_CONTACT_FLAG out nocopy VARCHAR2
159 ,P_THIRD_PARTY_PAY_FLAG out nocopy VARCHAR2
160 ,p_bondholder_flag out nocopy varchar2
161 ,p_date_start out nocopy date
162 ,p_start_life_reason_id out nocopy number
163 ,p_date_end out nocopy date
164 ,p_end_life_reason_id out nocopy number
165 ,p_rltd_per_rsds_w_dsgntr_flag out nocopy varchar2
166 ,p_personal_flag out nocopy varchar2
167 ,p_sequence_number out nocopy number
168 ,p_dependent_flag out nocopy varchar2
169 ,p_beneficiary_flag out nocopy varchar2
170 ,p_cont_attribute_category out nocopy varchar2
171 ,p_cont_attribute1 out nocopy varchar2
172 ,p_cont_attribute2 out nocopy varchar2
173 ,p_cont_attribute3 out nocopy varchar2
174 ,p_cont_attribute4 out nocopy varchar2
175 ,p_cont_attribute5 out nocopy varchar2
176 ,p_cont_attribute6 out nocopy varchar2
177 ,p_cont_attribute7 out nocopy varchar2
178 ,p_cont_attribute8 out nocopy varchar2
179 ,p_cont_attribute9 out nocopy varchar2
180 ,p_cont_attribute10 out nocopy varchar2
181 ,p_cont_attribute11 out nocopy varchar2
182 ,p_cont_attribute12 out nocopy varchar2
183 ,p_cont_attribute13 out nocopy varchar2
184 ,p_cont_attribute14 out nocopy varchar2
185 ,p_cont_attribute15 out nocopy varchar2
186 ,p_cont_attribute16 out nocopy varchar2
187 ,p_cont_attribute17 out nocopy varchar2
188 ,p_cont_attribute18 out nocopy varchar2
189 ,p_cont_attribute19 out nocopy varchar2
190 ,p_cont_attribute20 out nocopy varchar2
191 ,P_CONT_INFORMATION_CATEGORY out nocopy varchar2
192 ,P_CONT_INFORMATION1 out nocopy varchar2
193 ,P_CONT_INFORMATION2 out nocopy varchar2
194 ,P_CONT_INFORMATION3 out nocopy varchar2
195 ,P_CONT_INFORMATION4 out nocopy varchar2
196 ,P_CONT_INFORMATION5 out nocopy varchar2
197 ,P_CONT_INFORMATION6 out nocopy varchar2
198 ,P_CONT_INFORMATION7 out nocopy varchar2
199 ,P_CONT_INFORMATION8 out nocopy varchar2
200 ,P_CONT_INFORMATION9 out nocopy varchar2
201 ,P_CONT_INFORMATION10 out nocopy varchar2
202 ,P_CONT_INFORMATION11 out nocopy varchar2
203 ,P_CONT_INFORMATION12 out nocopy varchar2
204 ,P_CONT_INFORMATION13 out nocopy varchar2
205 ,P_CONT_INFORMATION14 out nocopy varchar2
206 ,P_CONT_INFORMATION15 out nocopy varchar2
207 ,P_CONT_INFORMATION16 out nocopy varchar2
208 ,P_CONT_INFORMATION17 out nocopy varchar2
209 ,P_CONT_INFORMATION18 out nocopy varchar2
210 ,P_CONT_INFORMATION19 out nocopy varchar2
211 ,P_CONT_INFORMATION20 out nocopy varchar2
212 ,p_object_version_number out nocopy number
213 ,p_review_proc_call out nocopy varchar2
214 );
215 --
216
217 procedure is_address_updated
218 (P_CONTACT_RELATIONSHIP_ID in number
219 ,P_DATE_START in date
220 ,p_transaction_step_id IN NUMBER
221 ,p_contact_person_id in number
222 ,p_person_id number) ;
223
224 /*
225 ||===========================================================================
226 || PROCEDURE: update_contact_relationship
227 ||---------------------------------------------------------------------------
228 ||
229 || Description:
230 || Description:
231 || This procedure will call the actual API -
232 || hr_contact_rel_api.update_contact_relationship()
233 ||
234 || Pre Conditions:
235 ||
236 || In Arguments:
237 || Contains entire list of parameters that are defined in the actual
238 || API. For details see peaddapi.pkb file.
239 ||
240 || out nocopy Arguments:
241 ||
242 || In out nocopy Arguments:
243 ||
244 || Post Success:
245 || Executes the API call.
246 ||
247 || Post Failure:
248 || Raises an exception
249 ||
250 || Access Status:
251 || Public.
252 ||
253 ||===========================================================================
254 */
255
256 PROCEDURE update_contact_relationship
257 (p_validate in varchar2 default 'Y'
258 ,p_cont_effective_date in date
259 ,p_contact_relationship_id in number
260 ,p_contact_type in varchar2 default hr_api.g_varchar2
264 ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
261 ,p_ctr_comments in clob default hr_api.g_varchar2 -- Bug#13362792
262 ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
263 ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
265 ,p_date_start in date default hr_api.g_date
266 ,p_start_life_reason_id in number default hr_api.g_number
267 ,p_date_end in date default hr_api.g_date
268 ,p_end_life_reason_id in number default hr_api.g_number
269 ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
270 ,p_personal_flag in varchar2 default hr_api.g_varchar2
271 ,p_sequence_number in number default hr_api.g_number
272 ,p_dependent_flag in varchar2 default hr_api.g_varchar2
273 ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
274 ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
275 ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
276 ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
277 ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
278 ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
279 ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
280 ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
281 ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
282 ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
283 ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
284 ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
285 ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
286 ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
287 ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
288 ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
289 ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
290 ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
291 ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
292 ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
293 ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
294 ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
295 ,p_person_id in number -- this could be p_login_person_id
296 ,p_login_person_id in number default hr_api.g_number
297 ,p_cont_object_version_number in out nocopy number
298 ,p_item_type in varchar2
299 ,p_item_key in varchar2
300 ,p_activity_id in number
301 ,p_action in varchar2 -- this is p_action_type
302 ,p_process_section_name in varchar2
303 ,p_review_page_region_code in varchar2 default hr_api.g_varchar2
304
305 -- Update_person parameters
306
307 ,p_per_effective_date in date
308 ,p_datetrack_update_mode in varchar2
309 ,p_cont_person_id in number
310 ,p_per_object_version_number in out nocopy number
311 ,p_person_type_id in number default hr_api.g_number
312 ,p_last_name in varchar2 default hr_api.g_varchar2
313 ,p_applicant_number in varchar2 default hr_api.g_varchar2
314 ,p_per_comments in varchar2 default hr_api.g_varchar2
315 ,p_date_employee_data_verified in date default hr_api.g_date
316 ,p_date_of_birth in date default hr_api.g_date
317 ,p_email_address in varchar2 default hr_api.g_varchar2
318 ,p_employee_number in out nocopy varchar2
319 ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
320 ,p_first_name in varchar2 default hr_api.g_varchar2
321 ,p_known_as in varchar2 default hr_api.g_varchar2
322 ,p_marital_status in varchar2 default hr_api.g_varchar2
323 ,p_middle_names in varchar2 default hr_api.g_varchar2
324 ,p_nationality in varchar2 default hr_api.g_varchar2
325 ,p_national_identifier in varchar2 default hr_api.g_varchar2
326 ,p_previous_last_name in varchar2 default hr_api.g_varchar2
327 ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
328 ,p_sex in varchar2 default hr_api.g_varchar2
329 ,p_title in varchar2 default hr_api.g_varchar2
330 ,p_vendor_id in number default hr_api.g_number
331 ,p_work_telephone in varchar2 default hr_api.g_varchar2
332 ,p_attribute_category in varchar2 default hr_api.g_varchar2
333 ,p_attribute1 in varchar2 default hr_api.g_varchar2
334 ,p_attribute2 in varchar2 default hr_api.g_varchar2
335 ,p_attribute3 in varchar2 default hr_api.g_varchar2
336 ,p_attribute4 in varchar2 default hr_api.g_varchar2
337 ,p_attribute5 in varchar2 default hr_api.g_varchar2
338 ,p_attribute6 in varchar2 default hr_api.g_varchar2
339 ,p_attribute7 in varchar2 default hr_api.g_varchar2
340 ,p_attribute8 in varchar2 default hr_api.g_varchar2
341 ,p_attribute9 in varchar2 default hr_api.g_varchar2
342 ,p_attribute10 in varchar2 default hr_api.g_varchar2
346 ,p_attribute14 in varchar2 default hr_api.g_varchar2
343 ,p_attribute11 in varchar2 default hr_api.g_varchar2
344 ,p_attribute12 in varchar2 default hr_api.g_varchar2
345 ,p_attribute13 in varchar2 default hr_api.g_varchar2
347 ,p_attribute15 in varchar2 default hr_api.g_varchar2
348 ,p_attribute16 in varchar2 default hr_api.g_varchar2
349 ,p_attribute17 in varchar2 default hr_api.g_varchar2
350 ,p_attribute18 in varchar2 default hr_api.g_varchar2
351 ,p_attribute19 in varchar2 default hr_api.g_varchar2
352 ,p_attribute20 in varchar2 default hr_api.g_varchar2
353 ,p_attribute21 in varchar2 default hr_api.g_varchar2
354 ,p_attribute22 in varchar2 default hr_api.g_varchar2
355 ,p_attribute23 in varchar2 default hr_api.g_varchar2
356 ,p_attribute24 in varchar2 default hr_api.g_varchar2
357 ,p_attribute25 in varchar2 default hr_api.g_varchar2
358 ,p_attribute26 in varchar2 default hr_api.g_varchar2
359 ,p_attribute27 in varchar2 default hr_api.g_varchar2
360 ,p_attribute28 in varchar2 default hr_api.g_varchar2
361 ,p_attribute29 in varchar2 default hr_api.g_varchar2
362 ,p_attribute30 in varchar2 default hr_api.g_varchar2
363 ,p_per_information_category in varchar2 default hr_api.g_varchar2
364 ,p_per_information1 in varchar2 default hr_api.g_varchar2
365 ,p_per_information2 in varchar2 default hr_api.g_varchar2
366 ,p_per_information3 in varchar2 default hr_api.g_varchar2
367 ,p_per_information4 in varchar2 default hr_api.g_varchar2
368 ,p_per_information5 in varchar2 default hr_api.g_varchar2
369 ,p_per_information6 in varchar2 default hr_api.g_varchar2
370 ,p_per_information7 in varchar2 default hr_api.g_varchar2
371 ,p_per_information8 in varchar2 default hr_api.g_varchar2
372 ,p_per_information9 in varchar2 default hr_api.g_varchar2
373 ,p_per_information10 in varchar2 default hr_api.g_varchar2
374 ,p_per_information11 in varchar2 default hr_api.g_varchar2
375 ,p_per_information12 in varchar2 default hr_api.g_varchar2
376 ,p_per_information13 in varchar2 default hr_api.g_varchar2
377 ,p_per_information14 in varchar2 default hr_api.g_varchar2
378 ,p_per_information15 in varchar2 default hr_api.g_varchar2
379 ,p_per_information16 in varchar2 default hr_api.g_varchar2
380 ,p_per_information17 in varchar2 default hr_api.g_varchar2
381 ,p_per_information18 in varchar2 default hr_api.g_varchar2
382 ,p_per_information19 in varchar2 default hr_api.g_varchar2
383 ,p_per_information20 in varchar2 default hr_api.g_varchar2
384 ,p_per_information21 in varchar2 default hr_api.g_varchar2
385 ,p_per_information22 in varchar2 default hr_api.g_varchar2
386 ,p_per_information23 in varchar2 default hr_api.g_varchar2
387 ,p_per_information24 in varchar2 default hr_api.g_varchar2
388 ,p_per_information25 in varchar2 default hr_api.g_varchar2
389 ,p_per_information26 in varchar2 default hr_api.g_varchar2
390 ,p_per_information27 in varchar2 default hr_api.g_varchar2
391 ,p_per_information28 in varchar2 default hr_api.g_varchar2
392 ,p_per_information29 in varchar2 default hr_api.g_varchar2
393 ,p_per_information30 in varchar2 default hr_api.g_varchar2
394 ,p_date_of_death in date default hr_api.g_date
395 ,p_background_check_status in varchar2 default hr_api.g_varchar2
396 ,p_background_date_check in date default hr_api.g_date
397 ,p_blood_type in varchar2 default hr_api.g_varchar2
398 ,p_correspondence_language in varchar2 default hr_api.g_varchar2
399 ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
400 ,p_fte_capacity in number default hr_api.g_number
401 ,p_hold_applicant_date_until in date default hr_api.g_date
402 ,p_honors in varchar2 default hr_api.g_varchar2
403 ,p_internal_location in varchar2 default hr_api.g_varchar2
404 ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
405 ,p_last_medical_test_date in date default hr_api.g_date
406 ,p_mailstop in varchar2 default hr_api.g_varchar2
407 ,p_office_number in varchar2 default hr_api.g_varchar2
408 ,p_on_military_service in varchar2 default hr_api.g_varchar2
409 ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
410 ,p_projected_start_date in date default hr_api.g_date
411 ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
412 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
413 ,p_resume_exists in varchar2 default hr_api.g_varchar2
414 ,p_resume_last_updated in date default hr_api.g_date
415 ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
416 ,p_student_status in varchar2 default hr_api.g_varchar2
417 ,p_work_schedule in varchar2 default hr_api.g_varchar2
418 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
419 ,p_suffix in varchar2 default hr_api.g_varchar2
420 ,p_benefit_group_id in number default hr_api.g_number
421 ,p_receipt_of_death_cert_date in date default hr_api.g_date
425 ,p_dpdnt_adoption_date in date default hr_api.g_date
422 ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
423 ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
424 ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
426 ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
427 ,p_original_date_of_hire in date default hr_api.g_date
428 ,p_adjusted_svc_date in date default hr_api.g_date
429 ,p_town_of_birth in varchar2 default hr_api.g_varchar2
430 ,p_region_of_birth in varchar2 default hr_api.g_varchar2
431 ,p_country_of_birth in varchar2 default hr_api.g_varchar2
432 ,p_global_person_id in varchar2 default hr_api.g_varchar2
433 ,p_business_group_id in number default hr_api.g_number
434 ,p_contact_operation in varchar2 default hr_api.g_varchar2
435 ,p_emrg_cont_flag in varchar2 default hr_api.g_varchar2
436 ,p_dpdnt_bnf_flag in varchar2 default hr_api.g_varchar2
437 ,p_save_mode in varchar2 default null
438 -- Added new params
439 ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
440 ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
441 ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
442 ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
443 ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
444 ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
445 ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
446 ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
447 ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
448 ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
449 ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
450 ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
451 ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
452 ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
453 ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
454 ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
455 ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
456 ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
457 ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
458 ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
459 ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
460 ,p_effective_start_date out nocopy date
461 ,p_effective_end_date out nocopy date
462 ,p_full_name out nocopy varchar2
463 ,p_comment_id out nocopy number
464 ,p_name_combination_warning out nocopy varchar2
465 ,p_assign_payroll_warning out nocopy varchar2
466 ,p_orig_hire_warning out nocopy varchar2
467 ,p_ni_duplicate_warn_or_err out nocopy varchar2
468 ,p_orig_rel_type in varchar2 default null
469 );
470 --
471 --
472 -- ---------------------------------------------------------------------------
473 -- ---------------------------- < is_rec_changed > ---------------------------
474 -- ---------------------------------------------------------------------------
475 -- Purpose: This function will check field by field to determine if there
476 -- are any changes made to the record.
477 -- ---------------------------------------------------------------------------
478 FUNCTION is_rec_changed (
479 p_effective_date in date
480 ,p_contact_relationship_id in number
481 ,p_contact_type in varchar2 default hr_api.g_varchar2
482 ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
483 ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
484 ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
485 ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
486 ,p_date_start in date default hr_api.g_date
487 ,p_start_life_reason_id in number default hr_api.g_number
488 ,p_date_end in date default hr_api.g_date
489 ,p_end_life_reason_id in number default hr_api.g_number
490 ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
491 ,p_personal_flag in varchar2 default hr_api.g_varchar2
492 ,p_sequence_number in number default hr_api.g_number
493 ,p_dependent_flag in varchar2 default hr_api.g_varchar2
494 ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
495 ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
496 ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
497 ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
498 ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
499 ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
500 ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
501 ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
502 ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
503 ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
504 ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
508 ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
505 ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
506 ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
507 ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
509 ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
510 ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
511 ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
512 ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
513 ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
514 ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
515 ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
516 -- Added new params
517 ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
518 ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
519 ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
520 ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
521 ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
522 ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
523 ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
524 ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
525 ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
526 ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
527 ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
528 ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
529 ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
530 ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
531 ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
532 ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
533 ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
534 ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
535 ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
536 ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
537 ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
538 ,p_object_version_number in number ) return boolean;
539 -- ---------------------------------------------------------------------------
540 -- ---------------------- < get_contact_from_tt> -------------------------
541 -- ---------------------------------------------------------------------------
542 -- Purpose: This procedure will get transaction data which are saved earlier
543 -- in the current transaction. This is invoked when a user click BACK
544 -- button to go back from the Review page to Update page to correct
545 -- typos or make further changes. Hence, we need to use the item_type
546 -- item_key passed in to retrieve the transaction record.
547 -- This is an overloaded version.
548 -- ---------------------------------------------------------------------------
549
550 procedure get_contact_from_tt
551 (
552 p_start_date out nocopy date
553 ,p_business_group_id out nocopy number
554 ,p_person_id out nocopy number
555 ,p_contact_person_id out nocopy number
556 ,p_contact_type out nocopy varchar2
557 ,p_ctr_comments out nocopy varchar2
558 ,p_primary_contact_flag out nocopy varchar2
559 ,p_date_start out nocopy date
560 ,p_start_life_reason_id out nocopy number
561 ,p_date_end out nocopy date
562 ,p_end_life_reason_id out nocopy number
563 ,p_rltd_per_rsds_w_dsgntr_flag out nocopy varchar2
564 ,p_personal_flag out nocopy varchar2
565 ,p_sequence_number out nocopy number
566 ,p_cont_attribute_category out nocopy varchar2
567 ,p_cont_attribute1 out nocopy varchar2
568 ,p_cont_attribute2 out nocopy varchar2
569 ,p_cont_attribute3 out nocopy varchar2
570 ,p_cont_attribute4 out nocopy varchar2
571 ,p_cont_attribute5 out nocopy varchar2
572 ,p_cont_attribute6 out nocopy varchar2
573 ,p_cont_attribute7 out nocopy varchar2
574 ,p_cont_attribute8 out nocopy varchar2
575 ,p_cont_attribute9 out nocopy varchar2
576 ,p_cont_attribute10 out nocopy varchar2
577 ,p_cont_attribute11 out nocopy varchar2
578 ,p_cont_attribute12 out nocopy varchar2
579 ,p_cont_attribute13 out nocopy varchar2
580 ,p_cont_attribute14 out nocopy varchar2
581 ,p_cont_attribute15 out nocopy varchar2
582 ,p_cont_attribute16 out nocopy varchar2
583 ,p_cont_attribute17 out nocopy varchar2
584 ,p_cont_attribute18 out nocopy varchar2
585 ,p_cont_attribute19 out nocopy varchar2
586 ,p_cont_attribute20 out nocopy varchar2
587 ,p_third_party_pay_flag out nocopy varchar2
588 ,p_bondholder_flag out nocopy varchar2
589 ,p_dependent_flag out nocopy varchar2
590 ,p_beneficiary_flag out nocopy varchar2
591 ,p_last_name out nocopy varchar2
592 ,p_sex out nocopy varchar2
596 ,p_date_of_birth out nocopy date
593 ,p_sex_meaning out nocopy varchar2
594 ,p_person_type_id out nocopy number
595 ,p_per_comments out nocopy varchar2
597 ,p_email_address out nocopy varchar2
598 ,p_first_name out nocopy varchar2
599 ,p_known_as out nocopy varchar2
600 ,p_marital_status out nocopy varchar2
601 ,p_marital_status_meaning out nocopy varchar2
602 ,p_student_status out nocopy varchar2
603 ,p_student_status_meaning out nocopy varchar2
604 ,p_middle_names out nocopy varchar2
605 ,p_nationality out nocopy varchar2
606 ,p_national_identifier out nocopy varchar2
607 ,p_previous_last_name out nocopy varchar2
608 ,p_registered_disabled_flag out nocopy varchar2
609 ,p_registered_disabled out nocopy varchar2
610 ,p_title out nocopy varchar2
611 ,p_work_telephone out nocopy varchar2
612 ,p_attribute_category out nocopy varchar2
613 ,p_attribute1 out nocopy varchar2
614 ,p_attribute2 out nocopy varchar2
615 ,p_attribute3 out nocopy varchar2
616 ,p_attribute4 out nocopy varchar2
617 ,p_attribute5 out nocopy varchar2
618 ,p_attribute6 out nocopy varchar2
619 ,p_attribute7 out nocopy varchar2
620 ,p_attribute8 out nocopy varchar2
621 ,p_attribute9 out nocopy varchar2
622 ,p_attribute10 out nocopy varchar2
623 ,p_attribute11 out nocopy varchar2
624 ,p_attribute12 out nocopy varchar2
625 ,p_attribute13 out nocopy varchar2
626 ,p_attribute14 out nocopy varchar2
627 ,p_attribute15 out nocopy varchar2
628 ,p_attribute16 out nocopy varchar2
629 ,p_attribute17 out nocopy varchar2
630 ,p_attribute18 out nocopy varchar2
631 ,p_attribute19 out nocopy varchar2
632 ,p_attribute20 out nocopy varchar2
633 ,p_attribute21 out nocopy varchar2
634 ,p_attribute22 out nocopy varchar2
635 ,p_attribute23 out nocopy varchar2
636 ,p_attribute24 out nocopy varchar2
637 ,p_attribute25 out nocopy varchar2
638 ,p_attribute26 out nocopy varchar2
639 ,p_attribute27 out nocopy varchar2
640 ,p_attribute28 out nocopy varchar2
641 ,p_attribute29 out nocopy varchar2
642 ,p_attribute30 out nocopy varchar2
643 ,p_per_information_category out nocopy varchar2
644 ,p_per_information1 out nocopy varchar2
645 ,p_per_information2 out nocopy varchar2
646 ,p_per_information3 out nocopy varchar2
647 ,p_per_information4 out nocopy varchar2
648 ,p_per_information5 out nocopy varchar2
649 ,p_per_information6 out nocopy varchar2
650 ,p_per_information7 out nocopy varchar2
651 ,p_per_information8 out nocopy varchar2
652 ,p_per_information9 out nocopy varchar2
653 ,p_per_information10 out nocopy varchar2
654 ,p_per_information11 out nocopy varchar2
655 ,p_per_information12 out nocopy varchar2
656 ,p_per_information13 out nocopy varchar2
657 ,p_per_information14 out nocopy varchar2
658 ,p_per_information15 out nocopy varchar2
659 ,p_per_information16 out nocopy varchar2
660 ,p_per_information17 out nocopy varchar2
661 ,p_per_information18 out nocopy varchar2
662 ,p_per_information19 out nocopy varchar2
663 ,p_per_information20 out nocopy varchar2
664 ,p_per_information21 out nocopy varchar2
665 ,p_per_information22 out nocopy varchar2
666 ,p_per_information23 out nocopy varchar2
667 ,p_per_information24 out nocopy varchar2
668 ,p_per_information25 out nocopy varchar2
669 ,p_per_information26 out nocopy varchar2
670 ,p_per_information27 out nocopy varchar2
671 ,p_per_information28 out nocopy varchar2
672 ,p_per_information29 out nocopy varchar2
673 ,p_per_information30 out nocopy varchar2
674 ,p_uses_tobacco_flag out nocopy varchar2
675 ,p_uses_tobacco_meaning out nocopy varchar2
676 ,p_on_military_service out nocopy varchar2
677 ,p_on_military_service_meaning out nocopy varchar2
678 ,p_dpdnt_vlntry_svce_flag out nocopy varchar2
679 ,p_dpdnt_vlntry_svce_meaning out nocopy varchar2
680 ,p_correspondence_language out nocopy varchar2
681 ,p_honors out nocopy varchar2
682 ,p_pre_name_adjunct out nocopy varchar2
683 ,p_suffix out nocopy varchar2
684 ,p_create_mirror_flag out nocopy varchar2
685 ,p_mirror_type out nocopy varchar2
686 ,p_mirror_cont_attribute_cat out nocopy varchar2
687 ,p_mirror_cont_attribute1 out nocopy varchar2
688 ,p_mirror_cont_attribute2 out nocopy varchar2
692 ,p_mirror_cont_attribute6 out nocopy varchar2
689 ,p_mirror_cont_attribute3 out nocopy varchar2
690 ,p_mirror_cont_attribute4 out nocopy varchar2
691 ,p_mirror_cont_attribute5 out nocopy varchar2
693 ,p_mirror_cont_attribute7 out nocopy varchar2
694 ,p_mirror_cont_attribute8 out nocopy varchar2
695 ,p_mirror_cont_attribute9 out nocopy varchar2
696 ,p_mirror_cont_attribute10 out nocopy varchar2
697 ,p_mirror_cont_attribute11 out nocopy varchar2
698 ,p_mirror_cont_attribute12 out nocopy varchar2
699 ,p_mirror_cont_attribute13 out nocopy varchar2
700 ,p_mirror_cont_attribute14 out nocopy varchar2
701 ,p_mirror_cont_attribute15 out nocopy varchar2
702 ,p_mirror_cont_attribute16 out nocopy varchar2
703 ,p_mirror_cont_attribute17 out nocopy varchar2
704 ,p_mirror_cont_attribute18 out nocopy varchar2
705 ,p_mirror_cont_attribute19 out nocopy varchar2
706 ,p_mirror_cont_attribute20 out nocopy varchar2
707 ,p_item_type in varchar2
708 ,p_item_key in varchar2
709 ,p_activity_id in number
710 ,p_action out nocopy varchar2
711 ,p_login_person_id out nocopy number
712 ,p_process_section_name out nocopy varchar2
713 ,p_review_page_region_code out nocopy varchar2
714 -- Bug 1914891
715 ,p_date_of_death out nocopy date
716 ,p_dpdnt_adoption_date out nocopy date
717 ,p_title_meaning out nocopy varchar2
718 ,p_contact_type_meaning out nocopy varchar2
719 ,p_contact_operation out nocopy varchar2
720 ,p_emrg_cont_flag out nocopy varchar2
721 ,p_dpdnt_bnf_flag out nocopy varchar2
722 ,p_contact_relationship_id out nocopy number
723 ,p_cont_object_version_number out nocopy number
724 -- bug# 2315163
725 ,p_is_emrg_cont out nocopy varchar2
726 ,p_is_dpdnt_bnf out nocopy varchar2
727 ,P_CONT_INFORMATION_CATEGORY out nocopy varchar2
728 ,P_CONT_INFORMATION1 out nocopy varchar2
729 ,P_CONT_INFORMATION2 out nocopy varchar2
730 ,P_CONT_INFORMATION3 out nocopy varchar2
731 ,P_CONT_INFORMATION4 out nocopy varchar2
732 ,P_CONT_INFORMATION5 out nocopy varchar2
733 ,P_CONT_INFORMATION6 out nocopy varchar2
734 ,P_CONT_INFORMATION7 out nocopy varchar2
735 ,P_CONT_INFORMATION8 out nocopy varchar2
736 ,P_CONT_INFORMATION9 out nocopy varchar2
737 ,P_CONT_INFORMATION10 out nocopy varchar2
738 ,P_CONT_INFORMATION11 out nocopy varchar2
739 ,P_CONT_INFORMATION12 out nocopy varchar2
740 ,P_CONT_INFORMATION13 out nocopy varchar2
741 ,P_CONT_INFORMATION14 out nocopy varchar2
742 ,P_CONT_INFORMATION15 out nocopy varchar2
743 ,P_CONT_INFORMATION16 out nocopy varchar2
744 ,P_CONT_INFORMATION17 out nocopy varchar2
745 ,P_CONT_INFORMATION18 out nocopy varchar2
746 ,P_CONT_INFORMATION19 out nocopy varchar2
747 ,P_CONT_INFORMATION20 out nocopy varchar2
748 );
749 --
750
751 -- ---------------------------------------------------------------------------
752 -- ---------------------- < get_contact_from_tt> -------------------------
753 -- ---------------------------------------------------------------------------
754 -- Purpose: This procedure will get transaction data which are pending for
755 -- approval in workflow for a transaction step id.
756 -- This is the procedure which does the actual work.
757 -- ---------------------------------------------------------------------------
758
759 procedure get_contact_from_tt
760 (p_transaction_step_id in number
761 ,p_start_date out nocopy date
762 ,p_business_group_id out nocopy number
763 ,p_person_id out nocopy number
764 ,p_contact_person_id out nocopy number
765 ,p_contact_type out nocopy varchar2
766 ,p_ctr_comments out nocopy varchar2
767 ,p_primary_contact_flag out nocopy varchar2
768 ,p_date_start out nocopy date
769 ,p_start_life_reason_id out nocopy number
770 ,p_date_end out nocopy date
771 ,p_end_life_reason_id out nocopy number
772 ,p_rltd_per_rsds_w_dsgntr_flag out nocopy varchar2
773 ,p_personal_flag out nocopy varchar2
774 ,p_sequence_number out nocopy number
775 ,p_cont_attribute_category out nocopy varchar2
776 ,p_cont_attribute1 out nocopy varchar2
777 ,p_cont_attribute2 out nocopy varchar2
778 ,p_cont_attribute3 out nocopy varchar2
779 ,p_cont_attribute4 out nocopy varchar2
780 ,p_cont_attribute5 out nocopy varchar2
781 ,p_cont_attribute6 out nocopy varchar2
782 ,p_cont_attribute7 out nocopy varchar2
783 ,p_cont_attribute8 out nocopy varchar2
784 ,p_cont_attribute9 out nocopy varchar2
785 ,p_cont_attribute10 out nocopy varchar2
786 ,p_cont_attribute11 out nocopy varchar2
787 ,p_cont_attribute12 out nocopy varchar2
788 ,p_cont_attribute13 out nocopy varchar2
792 ,p_cont_attribute17 out nocopy varchar2
789 ,p_cont_attribute14 out nocopy varchar2
790 ,p_cont_attribute15 out nocopy varchar2
791 ,p_cont_attribute16 out nocopy varchar2
793 ,p_cont_attribute18 out nocopy varchar2
794 ,p_cont_attribute19 out nocopy varchar2
795 ,p_cont_attribute20 out nocopy varchar2
796 ,p_third_party_pay_flag out nocopy varchar2
797 ,p_bondholder_flag out nocopy varchar2
798 ,p_dependent_flag out nocopy varchar2
799 ,p_beneficiary_flag out nocopy varchar2
800 ,p_last_name out nocopy varchar2
801 ,p_sex out nocopy varchar2
802 ,p_sex_meaning out nocopy varchar2
803 ,p_person_type_id out nocopy number
804 ,p_per_comments out nocopy varchar2
805 ,p_date_of_birth out nocopy date
806 ,p_email_address out nocopy varchar2
807 ,p_first_name out nocopy varchar2
808 ,p_known_as out nocopy varchar2
809 ,p_marital_status out nocopy varchar2
810 ,p_marital_status_meaning out nocopy varchar2
811 ,p_student_status out nocopy varchar2
812 ,p_student_status_meaning out nocopy varchar2
813 ,p_middle_names out nocopy varchar2
814 ,p_nationality out nocopy varchar2
815 ,p_national_identifier out nocopy varchar2
816 ,p_previous_last_name out nocopy varchar2
817 ,p_registered_disabled_flag out nocopy varchar2
818 ,p_registered_disabled out nocopy varchar2
819 ,p_title out nocopy varchar2
820 ,p_work_telephone out nocopy varchar2
821 ,p_attribute_category out nocopy varchar2
822 ,p_attribute1 out nocopy varchar2
823 ,p_attribute2 out nocopy varchar2
824 ,p_attribute3 out nocopy varchar2
825 ,p_attribute4 out nocopy varchar2
826 ,p_attribute5 out nocopy varchar2
827 ,p_attribute6 out nocopy varchar2
828 ,p_attribute7 out nocopy varchar2
829 ,p_attribute8 out nocopy varchar2
830 ,p_attribute9 out nocopy varchar2
831 ,p_attribute10 out nocopy varchar2
832 ,p_attribute11 out nocopy varchar2
833 ,p_attribute12 out nocopy varchar2
834 ,p_attribute13 out nocopy varchar2
835 ,p_attribute14 out nocopy varchar2
836 ,p_attribute15 out nocopy varchar2
837 ,p_attribute16 out nocopy varchar2
838 ,p_attribute17 out nocopy varchar2
839 ,p_attribute18 out nocopy varchar2
840 ,p_attribute19 out nocopy varchar2
841 ,p_attribute20 out nocopy varchar2
842 ,p_attribute21 out nocopy varchar2
843 ,p_attribute22 out nocopy varchar2
844 ,p_attribute23 out nocopy varchar2
845 ,p_attribute24 out nocopy varchar2
846 ,p_attribute25 out nocopy varchar2
847 ,p_attribute26 out nocopy varchar2
848 ,p_attribute27 out nocopy varchar2
849 ,p_attribute28 out nocopy varchar2
850 ,p_attribute29 out nocopy varchar2
851 ,p_attribute30 out nocopy varchar2
852 ,p_per_information_category out nocopy varchar2
853 ,p_per_information1 out nocopy varchar2
854 ,p_per_information2 out nocopy varchar2
855 ,p_per_information3 out nocopy varchar2
856 ,p_per_information4 out nocopy varchar2
857 ,p_per_information5 out nocopy varchar2
858 ,p_per_information6 out nocopy varchar2
859 ,p_per_information7 out nocopy varchar2
860 ,p_per_information8 out nocopy varchar2
861 ,p_per_information9 out nocopy varchar2
862 ,p_per_information10 out nocopy varchar2
863 ,p_per_information11 out nocopy varchar2
864 ,p_per_information12 out nocopy varchar2
865 ,p_per_information13 out nocopy varchar2
866 ,p_per_information14 out nocopy varchar2
867 ,p_per_information15 out nocopy varchar2
868 ,p_per_information16 out nocopy varchar2
869 ,p_per_information17 out nocopy varchar2
870 ,p_per_information18 out nocopy varchar2
871 ,p_per_information19 out nocopy varchar2
872 ,p_per_information20 out nocopy varchar2
873 ,p_per_information21 out nocopy varchar2
874 ,p_per_information22 out nocopy varchar2
875 ,p_per_information23 out nocopy varchar2
876 ,p_per_information24 out nocopy varchar2
877 ,p_per_information25 out nocopy varchar2
878 ,p_per_information26 out nocopy varchar2
879 ,p_per_information27 out nocopy varchar2
880 ,p_per_information28 out nocopy varchar2
881 ,p_per_information29 out nocopy varchar2
882 ,p_per_information30 out nocopy varchar2
883 ,p_uses_tobacco_flag out nocopy varchar2
887 ,p_dpdnt_vlntry_svce_flag out nocopy varchar2
884 ,p_uses_tobacco_meaning out nocopy varchar2
885 ,p_on_military_service out nocopy varchar2
886 ,p_on_military_service_meaning out nocopy varchar2
888 ,p_dpdnt_vlntry_svce_meaning out nocopy varchar2
889 ,p_correspondence_language out nocopy varchar2
890 ,p_honors out nocopy varchar2
891 ,p_pre_name_adjunct out nocopy varchar2
892 ,p_suffix out nocopy varchar2
893 ,p_create_mirror_flag out nocopy varchar2
894 ,p_mirror_type out nocopy varchar2
895 ,p_mirror_cont_attribute_cat out nocopy varchar2
896 ,p_mirror_cont_attribute1 out nocopy varchar2
897 ,p_mirror_cont_attribute2 out nocopy varchar2
898 ,p_mirror_cont_attribute3 out nocopy varchar2
899 ,p_mirror_cont_attribute4 out nocopy varchar2
900 ,p_mirror_cont_attribute5 out nocopy varchar2
901 ,p_mirror_cont_attribute6 out nocopy varchar2
902 ,p_mirror_cont_attribute7 out nocopy varchar2
903 ,p_mirror_cont_attribute8 out nocopy varchar2
904 ,p_mirror_cont_attribute9 out nocopy varchar2
905 ,p_mirror_cont_attribute10 out nocopy varchar2
906 ,p_mirror_cont_attribute11 out nocopy varchar2
907 ,p_mirror_cont_attribute12 out nocopy varchar2
908 ,p_mirror_cont_attribute13 out nocopy varchar2
909 ,p_mirror_cont_attribute14 out nocopy varchar2
910 ,p_mirror_cont_attribute15 out nocopy varchar2
911 ,p_mirror_cont_attribute16 out nocopy varchar2
912 ,p_mirror_cont_attribute17 out nocopy varchar2
913 ,p_mirror_cont_attribute18 out nocopy varchar2
914 ,p_mirror_cont_attribute19 out nocopy varchar2
915 ,p_mirror_cont_attribute20 out nocopy varchar2
916 ,p_action out nocopy varchar2
917 ,p_login_person_id out nocopy number
918 ,p_process_section_name out nocopy varchar2
919 ,p_review_page_region_code out nocopy varchar2
920 -- Bug 1914891
921 ,p_date_of_death out nocopy date
922 ,p_dpdnt_adoption_date out nocopy date
923 ,p_title_meaning out nocopy varchar2
924 ,p_contact_type_meaning out nocopy varchar2
925 ,p_contact_operation out nocopy varchar2
926 ,p_emrg_cont_flag out nocopy varchar2
927 ,p_dpdnt_bnf_flag out nocopy varchar2
928 ,p_contact_relationship_id out nocopy number
929 ,p_cont_object_version_number out nocopy number
930 -- bug# 2315163
931 ,p_is_emrg_cont out nocopy varchar2
932 ,p_is_dpdnt_bnf out nocopy varchar2
933 ,P_CONT_INFORMATION_CATEGORY out nocopy varchar2
934 ,P_CONT_INFORMATION1 out nocopy varchar2
935 ,P_CONT_INFORMATION2 out nocopy varchar2
936 ,P_CONT_INFORMATION3 out nocopy varchar2
937 ,P_CONT_INFORMATION4 out nocopy varchar2
938 ,P_CONT_INFORMATION5 out nocopy varchar2
939 ,P_CONT_INFORMATION6 out nocopy varchar2
940 ,P_CONT_INFORMATION7 out nocopy varchar2
941 ,P_CONT_INFORMATION8 out nocopy varchar2
942 ,P_CONT_INFORMATION9 out nocopy varchar2
943 ,P_CONT_INFORMATION10 out nocopy varchar2
944 ,P_CONT_INFORMATION11 out nocopy varchar2
945 ,P_CONT_INFORMATION12 out nocopy varchar2
946 ,P_CONT_INFORMATION13 out nocopy varchar2
947 ,P_CONT_INFORMATION14 out nocopy varchar2
948 ,P_CONT_INFORMATION15 out nocopy varchar2
949 ,P_CONT_INFORMATION16 out nocopy varchar2
950 ,P_CONT_INFORMATION17 out nocopy varchar2
951 ,P_CONT_INFORMATION18 out nocopy varchar2
952 ,P_CONT_INFORMATION19 out nocopy varchar2
953 ,P_CONT_INFORMATION20 out nocopy varchar2
954 );
955 /*
956 ||===========================================================================
957 || PROCEDURE: create_contact_tt
958 ||---------------------------------------------------------------------------
959 ||
960 || Description:
961 || Description:
962 || This procedure will call the actual API -
963 || hr_contact_rel_api.create_contact_tt()
964 ||
965 || Pre Conditions:
966 ||
967 || In Arguments:
968 || Contains entire list of parameters that are defined in the actual
969 || API. For details see pecrlapi.pkb file.
970 ||
971 || out nocopy Arguments:
972 ||
973 || In out nocopy Arguments:
974 ||
975 || Post Success:
976 || Executes the API call.
977 ||
978 || Post Failure:
979 || Raises an exception
980 ||
981 || Access Status:
982 || Public.
983 ||
984 ||===========================================================================
985 */
986
987 procedure create_contact_tt
988 (p_validate in number default 0
989 ,p_start_date in date
990 ,p_business_group_id in number
991 ,p_person_id in number
992 ,p_contact_person_id in number default null
993 ,p_contact_type in varchar2
994 ,p_ctr_comments in varchar2 default null
995 ,p_primary_contact_flag in varchar2 default 'N'
999 ,p_end_life_reason_id in number default null
996 ,p_date_start in date default null
997 ,p_start_life_reason_id in number default null
998 ,p_date_end in date default null
1000 ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default 'N'
1001 ,p_personal_flag in varchar2 default 'N'
1002 ,p_sequence_number in number default null
1003 ,p_cont_attribute_category in varchar2 default null
1004 ,p_cont_attribute1 in varchar2 default null
1005 ,p_cont_attribute2 in varchar2 default null
1006 ,p_cont_attribute3 in varchar2 default null
1007 ,p_cont_attribute4 in varchar2 default null
1008 ,p_cont_attribute5 in varchar2 default null
1009 ,p_cont_attribute6 in varchar2 default null
1010 ,p_cont_attribute7 in varchar2 default null
1011 ,p_cont_attribute8 in varchar2 default null
1012 ,p_cont_attribute9 in varchar2 default null
1013 ,p_cont_attribute10 in varchar2 default null
1014 ,p_cont_attribute11 in varchar2 default null
1015 ,p_cont_attribute12 in varchar2 default null
1016 ,p_cont_attribute13 in varchar2 default null
1017 ,p_cont_attribute14 in varchar2 default null
1018 ,p_cont_attribute15 in varchar2 default null
1019 ,p_cont_attribute16 in varchar2 default null
1020 ,p_cont_attribute17 in varchar2 default null
1021 ,p_cont_attribute18 in varchar2 default null
1022 ,p_cont_attribute19 in varchar2 default null
1023 ,p_cont_attribute20 in varchar2 default null
1024 ,p_third_party_pay_flag in varchar2 default 'N'
1025 ,p_bondholder_flag in varchar2 default 'N'
1026 ,p_dependent_flag in varchar2 default 'N'
1027 ,p_beneficiary_flag in varchar2 default 'N'
1028 ,p_last_name in varchar2 default null
1029 ,p_sex in varchar2 default null
1030 ,p_person_type_id in number default null
1031 ,p_per_comments in varchar2 default null
1032 ,p_date_of_birth in date default null
1033 ,p_email_address in varchar2 default null
1034 ,p_first_name in varchar2 default null
1035 ,p_known_as in varchar2 default null
1036 ,p_marital_status in varchar2 default null
1037 ,p_middle_names in varchar2 default null
1038 ,p_nationality in varchar2 default null
1039 ,p_national_identifier in varchar2 default null
1040 ,p_previous_last_name in varchar2 default null
1041 ,p_registered_disabled_flag in varchar2 default null
1042 ,p_title in varchar2 default null
1043 ,p_work_telephone in varchar2 default null
1044 ,p_attribute_category in varchar2 default null
1045 ,p_attribute1 in varchar2 default null
1046 ,p_attribute2 in varchar2 default null
1047 ,p_attribute3 in varchar2 default null
1048 ,p_attribute4 in varchar2 default null
1049 ,p_attribute5 in varchar2 default null
1050 ,p_attribute6 in varchar2 default null
1051 ,p_attribute7 in varchar2 default null
1052 ,p_attribute8 in varchar2 default null
1053 ,p_attribute9 in varchar2 default null
1054 ,p_attribute10 in varchar2 default null
1055 ,p_attribute11 in varchar2 default null
1056 ,p_attribute12 in varchar2 default null
1057 ,p_attribute13 in varchar2 default null
1058 ,p_attribute14 in varchar2 default null
1059 ,p_attribute15 in varchar2 default null
1060 ,p_attribute16 in varchar2 default null
1061 ,p_attribute17 in varchar2 default null
1062 ,p_attribute18 in varchar2 default null
1063 ,p_attribute19 in varchar2 default null
1064 ,p_attribute20 in varchar2 default null
1065 ,p_attribute21 in varchar2 default null
1066 ,p_attribute22 in varchar2 default null
1067 ,p_attribute23 in varchar2 default null
1068 ,p_attribute24 in varchar2 default null
1069 ,p_attribute25 in varchar2 default null
1070 ,p_attribute26 in varchar2 default null
1071 ,p_attribute27 in varchar2 default null
1072 ,p_attribute28 in varchar2 default null
1073 ,p_attribute29 in varchar2 default null
1074 ,p_attribute30 in varchar2 default null
1075 ,p_per_information_category in varchar2 default null
1076 ,p_per_information1 in varchar2 default null
1077 ,p_per_information2 in varchar2 default null
1078 ,p_per_information3 in varchar2 default null
1079 ,p_per_information4 in varchar2 default null
1080 ,p_per_information5 in varchar2 default null
1081 ,p_per_information6 in varchar2 default null
1082 ,p_per_information7 in varchar2 default null
1083 ,p_per_information8 in varchar2 default null
1084 ,p_per_information9 in varchar2 default null
1085 ,p_per_information10 in varchar2 default null
1086 ,p_per_information11 in varchar2 default null
1087 ,p_per_information12 in varchar2 default null
1088 ,p_per_information13 in varchar2 default null
1089 ,p_per_information14 in varchar2 default null
1090 ,p_per_information15 in varchar2 default null
1091 ,p_per_information16 in varchar2 default null
1092 ,p_per_information17 in varchar2 default null
1093 ,p_per_information18 in varchar2 default null
1094 ,p_per_information19 in varchar2 default null
1095 ,p_per_information20 in varchar2 default null
1096 ,p_per_information21 in varchar2 default null
1097 ,p_per_information22 in varchar2 default null
1098 ,p_per_information23 in varchar2 default null
1099 ,p_per_information24 in varchar2 default null
1100 ,p_per_information25 in varchar2 default null
1101 ,p_per_information26 in varchar2 default null
1102 ,p_per_information27 in varchar2 default null
1103 ,p_per_information28 in varchar2 default null
1104 ,p_per_information29 in varchar2 default null
1105 ,p_per_information30 in varchar2 default null
1106 ,p_correspondence_language in varchar2 default null
1107 ,p_honors in varchar2 default null
1108 ,p_pre_name_adjunct in varchar2 default null
1109 ,p_suffix in varchar2 default null
1110 ,p_create_mirror_flag in varchar2 default 'N'
1111 ,p_mirror_type in varchar2 default null
1112 ,p_mirror_cont_attribute_cat in varchar2 default null
1113 ,p_mirror_cont_attribute1 in varchar2 default null
1114 ,p_mirror_cont_attribute2 in varchar2 default null
1115 ,p_mirror_cont_attribute3 in varchar2 default null
1116 ,p_mirror_cont_attribute4 in varchar2 default null
1117 ,p_mirror_cont_attribute5 in varchar2 default null
1118 ,p_mirror_cont_attribute6 in varchar2 default null
1119 ,p_mirror_cont_attribute7 in varchar2 default null
1120 ,p_mirror_cont_attribute8 in varchar2 default null
1121 ,p_mirror_cont_attribute9 in varchar2 default null
1122 ,p_mirror_cont_attribute10 in varchar2 default null
1123 ,p_mirror_cont_attribute11 in varchar2 default null
1124 ,p_mirror_cont_attribute12 in varchar2 default null
1125 ,p_mirror_cont_attribute13 in varchar2 default null
1126 ,p_mirror_cont_attribute14 in varchar2 default null
1127 ,p_mirror_cont_attribute15 in varchar2 default null
1128 ,p_mirror_cont_attribute16 in varchar2 default null
1129 ,p_mirror_cont_attribute17 in varchar2 default null
1130 ,p_mirror_cont_attribute18 in varchar2 default null
1131 ,p_mirror_cont_attribute19 in varchar2 default null
1132 ,p_mirror_cont_attribute20 in varchar2 default null
1133 ,p_item_type in varchar2
1134 ,p_item_key in varchar2
1135 ,p_activity_id in number
1136 ,p_action in varchar2
1137 ,p_login_person_id in number
1138 ,p_process_section_name in varchar2
1139 ,p_review_page_region_code in varchar2 default null
1140
1141 ,p_adjusted_svc_date in date default null
1142 ,p_datetrack_update_mode in varchar2 default hr_api.g_correction --
1143 ,p_applicant_number in varchar2 default null
1144 ,p_background_check_status in varchar2 default null
1145 ,p_background_date_check in date default null
1146 ,p_benefit_group_id in number default null
1147 ,p_blood_type in varchar2 default null
1148 ,p_coord_ben_med_pln_no in varchar2 default null
1149 ,p_coord_ben_no_cvg_flag in varchar2 default null
1150 ,p_country_of_birth in varchar2 default null
1151 ,p_date_employee_data_verified in date default null
1152 ,p_date_of_death in date default null
1153 ,p_dpdnt_adoption_date in date default null
1154 ,p_dpdnt_vlntry_svce_flag in varchar2 default null
1155 ,p_employee_number in out nocopy varchar2
1156 ,p_expense_check_send_to_addres in varchar2 default null
1157 ,p_fast_path_employee in varchar2 default null
1158 ,p_fte_capacity in number default null
1159 ,p_global_person_id in varchar2 default null
1160 ,p_hold_applicant_date_until in date default null
1161 ,p_internal_location in varchar2 default null
1162 ,p_last_medical_test_by in varchar2 default null
1163 ,p_last_medical_test_date in date default null
1164 ,p_mailstop in varchar2 default null
1165 ,p_office_number in varchar2 default null
1166 ,p_on_military_service in varchar2 default null
1167 ,p_original_date_of_hire in date default null
1168 ,p_projected_start_date in date default null
1169 ,p_receipt_of_death_cert_date in date default null
1170 ,p_region_of_birth in varchar2 default null
1171 ,p_rehire_authorizor in varchar2 default null
1172 ,p_rehire_recommendation in varchar2 default null
1173 ,p_rehire_reason in varchar2 default null
1174 ,p_resume_exists in varchar2 default null
1175 ,p_resume_last_updated in date default null
1176 ,p_second_passport_exists in varchar2 default null
1177 ,p_student_status in varchar2 default null
1178 ,p_town_of_birth in varchar2 default null
1179 ,p_uses_tobacco_flag in varchar2 default null
1180 ,p_vendor_id in number default null
1181 ,p_work_schedule in varchar2 default null
1182 ,p_contact_operation in varchar2 default null
1183 ,p_emrg_cont_flag in varchar2 default 'N'
1184 ,p_dpdnt_bnf_flag in varchar2 default 'N'
1185 ,p_save_mode in varchar2 default null
1186 -- Added new parameters
1187 ,P_CONT_INFORMATION_CATEGORY in varchar2 default null
1188 ,P_CONT_INFORMATION1 in varchar2 default null
1189 ,P_CONT_INFORMATION2 in varchar2 default null
1190 ,P_CONT_INFORMATION3 in varchar2 default null
1191 ,P_CONT_INFORMATION4 in varchar2 default null
1192 ,P_CONT_INFORMATION5 in varchar2 default null
1193 ,P_CONT_INFORMATION6 in varchar2 default null
1194 ,P_CONT_INFORMATION7 in varchar2 default null
1195 ,P_CONT_INFORMATION8 in varchar2 default null
1196 ,P_CONT_INFORMATION9 in varchar2 default null
1197 ,P_CONT_INFORMATION10 in varchar2 default null
1198 ,P_CONT_INFORMATION11 in varchar2 default null
1199 ,P_CONT_INFORMATION12 in varchar2 default null
1200 ,P_CONT_INFORMATION13 in varchar2 default null
1201 ,P_CONT_INFORMATION14 in varchar2 default null
1202 ,P_CONT_INFORMATION15 in varchar2 default null
1203 ,P_CONT_INFORMATION16 in varchar2 default null
1204 ,P_CONT_INFORMATION17 in varchar2 default null
1205 ,P_CONT_INFORMATION18 in varchar2 default null
1206 ,P_CONT_INFORMATION19 in varchar2 default null
1207 ,P_CONT_INFORMATION20 in varchar2 default null
1208 --bug 4634855
1209 ,P_MIRROR_CONT_INFORMATION_CAT in varchar2 default null
1210 ,P_MIRROR_CONT_INFORMATION1 in varchar2 default null
1211 ,P_MIRROR_CONT_INFORMATION2 in varchar2 default null
1212 ,P_MIRROR_CONT_INFORMATION3 in varchar2 default null
1213 ,P_MIRROR_CONT_INFORMATION4 in varchar2 default null
1214 ,P_MIRROR_CONT_INFORMATION5 in varchar2 default null
1215 ,P_MIRROR_CONT_INFORMATION6 in varchar2 default null
1216 ,P_MIRROR_CONT_INFORMATION7 in varchar2 default null
1217 ,P_MIRROR_CONT_INFORMATION8 in varchar2 default null
1218 ,P_MIRROR_CONT_INFORMATION9 in varchar2 default null
1219 ,P_MIRROR_CONT_INFORMATION10 in varchar2 default null
1220 ,P_MIRROR_CONT_INFORMATION11 in varchar2 default null
1221 ,P_MIRROR_CONT_INFORMATION12 in varchar2 default null
1222 ,P_MIRROR_CONT_INFORMATION13 in varchar2 default null
1223 ,P_MIRROR_CONT_INFORMATION14 in varchar2 default null
1224 ,P_MIRROR_CONT_INFORMATION15 in varchar2 default null
1225 ,P_MIRROR_CONT_INFORMATION16 in varchar2 default null
1226 ,P_MIRROR_CONT_INFORMATION17 in varchar2 default null
1227 ,P_MIRROR_CONT_INFORMATION18 in varchar2 default null
1228 ,P_MIRROR_CONT_INFORMATION19 in varchar2 default null
1229 ,P_MIRROR_CONT_INFORMATION20 in varchar2 default null
1230
1231 ,p_contact_relationship_id out nocopy number
1232 ,p_ctr_object_version_number out nocopy number
1233 ,p_per_person_id out nocopy number
1234 ,p_per_object_version_number out nocopy number
1235 ,p_per_effective_start_date out nocopy date
1239 ,p_con_name_combination_warning out nocopy varchar2
1236 ,p_per_effective_end_date out nocopy date
1237 ,p_full_name out nocopy varchar2
1238 ,p_per_comment_id out nocopy number
1240 ,p_per_name_combination_warning out nocopy varchar2
1241 ,p_con_orig_hire_warning out nocopy varchar2
1242 ,p_per_orig_hire_warning out nocopy varchar2
1243 ,p_per_assign_payroll_warning out nocopy varchar2
1244 ,p_ni_duplicate_warn_or_err out nocopy varchar2
1245 ) ;
1246
1247 Function is_con_rec_changed (
1248 p_adjusted_svc_date in date default hr_api.g_date
1249 ,p_applicant_number in varchar2 default hr_api.g_varchar2
1250 ,p_background_check_status in varchar2 default hr_api.g_varchar2
1251 ,p_background_date_check in date default hr_api.g_date
1252 ,p_benefit_group_id in number default hr_api.g_number
1253 ,p_blood_type in varchar2 default hr_api.g_varchar2
1254 ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1255 ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1256 ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1257 ,p_date_employee_data_verified in date default hr_api.g_date
1258 ,p_date_of_death in date default hr_api.g_date
1259 ,p_dpdnt_adoption_date in date default hr_api.g_date
1260 ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1261 ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1262 ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1263 ,p_fte_capacity in number default hr_api.g_number
1264 ,p_global_person_id in varchar2 default hr_api.g_varchar2
1265 ,p_hold_applicant_date_until in date default hr_api.g_date
1266 ,p_internal_location in varchar2 default hr_api.g_varchar2
1267 ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1268 ,p_last_medical_test_date in date default hr_api.g_date
1269 ,p_mailstop in varchar2 default hr_api.g_varchar2
1270 ,p_office_number in varchar2 default hr_api.g_varchar2
1271 ,p_on_military_service in varchar2 default hr_api.g_varchar2
1272 ,p_original_date_of_hire in date default hr_api.g_date
1273 ,p_projected_start_date in date default hr_api.g_date
1274 ,p_receipt_of_death_cert_date in date default hr_api.g_date
1275 ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1276 ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1277 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1278 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1279 ,p_resume_exists in varchar2 default hr_api.g_varchar2
1280 ,p_resume_last_updated in date default hr_api.g_date
1281 ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1282 ,p_student_status in varchar2 default hr_api.g_varchar2
1283 ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1284 ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1285 ,p_vendor_id in number default hr_api.g_number
1286 ,p_work_schedule in varchar2 default hr_api.g_varchar2 )
1287 return boolean ;
1288 --
1289 -- ---------------------------------------------------------------------------
1290 -- ----------------------------- < process_create_contact_api> -----------------------------
1291 -- ---------------------------------------------------------------------------
1292 -- This procedure will call the api to create
1293 -- to the database with p_validate equal to false.
1294 -- For contacts there is no approver process attached.
1295 --
1296 -- ---------------------------------------------------------------------------
1297 PROCEDURE process_create_contact_api
1298 (p_validate IN BOOLEAN DEFAULT FALSE
1299 ,p_transaction_step_id IN NUMBER
1300 ,p_effective_date in varchar2 default null
1301 );
1302
1303 --
1304 -- ---------------------------------------------------------------------------
1305 -- ----------------------------- < process_api > -----------------------------
1306 -- ---------------------------------------------------------------------------
1307 -- Purpose: This procedure will be invoked in workflow notification
1308 -- when an approver approves all the changes. This procedure
1309 -- will call the api to update to the database with p_validate
1310 -- equal to false.
1311 -- For contacts there is no approver process attached.
1312 --
1313 -- ---------------------------------------------------------------------------
1314 PROCEDURE process_api
1315 (p_validate IN BOOLEAN DEFAULT FALSE
1316 ,p_transaction_step_id IN NUMBER
1317 ,p_effective_date in varchar2 default null
1318 );
1319
1320 /*
1321 ||===========================================================================
1322 || PROCEDURE: end_contact_relationship
1323 ||---------------------------------------------------------------------------
1324 ||
1325 || Description:
1326 || Description:
1327 || This procedure will call the actual API -
1328 || hr_contact_rel_api.update_contact_relationship()
1329 ||
1330 || Pre Conditions:
1331 ||
1332 || In Arguments:
1333 || Contains entire list of parameters that are defined in the actual
1334 || API. For details see peaddapi.pkb file.
1335 ||
1336 || out nocopy Arguments:
1337 ||
1338 || In out nocopy Arguments:
1339 ||
1340 || Post Success:
1341 || Executes the API call.
1345 ||
1342 ||
1343 || Post Failure:
1344 || Raises an exception
1346 || Access Status:
1347 || Public.
1348 ||
1349 ||===========================================================================
1350 */
1351
1352 PROCEDURE end_contact_relationship
1353 (p_validate in number default 0
1354 ,p_effective_date in date
1355 ,p_contact_relationship_id in number
1356 ,p_contact_type in varchar2 default hr_api.g_varchar2
1357 ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1358 ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1359 ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1360 ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1361 ,p_date_start in date default hr_api.g_date
1362 ,p_start_life_reason_id in number default hr_api.g_number
1363 ,p_date_end in date default hr_api.g_date
1364 ,p_end_life_reason_id in number default hr_api.g_number
1365 ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1366 ,p_personal_flag in varchar2 default hr_api.g_varchar2
1367 ,p_sequence_number in number default hr_api.g_number
1368 ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1369 ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1370 ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1371 ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1372 ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1373 ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1374 ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1375 ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1376 ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1377 ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1378 ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1379 ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1380 ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1381 ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1382 ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1383 ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1384 ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1385 ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1386 ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1387 ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1388 ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1389 ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1390 ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1391 ,p_person_id in number -- this could be p_login_person_id
1392 ,p_object_version_number in out nocopy number
1393 ,p_item_type in varchar2
1394 ,p_item_key in varchar2
1395 ,p_activity_id in number
1396 ,p_action in varchar2 -- this is p_action_type
1397 ,p_process_section_name in varchar2
1398 ,p_review_page_region_code in varchar2 default hr_api.g_varchar2
1399 ,p_save_mode in varchar2 default null
1400 -- SFL needs it bug #2082333
1401 ,p_login_person_id in number
1402 ,p_contact_person_id in number
1403 -- Bug 2723267 change
1404 ,p_contact_operation in varchar2
1405 -- Bug 3152505
1406 ,p_end_other_rel in varchar2
1407 ,p_other_rel_id in number
1408 );
1409 --
1410 -- ---------------------------------------------------------------------------
1411 -- ----------------------------- < process_end_api > -----------------------------
1412 -- ---------------------------------------------------------------------------
1413 -- Purpose: This procedure will be invoked in workflow notification
1414 -- when an approver approves all the changes. This procedure
1415 -- will call the api to update to the database with p_validate
1416 -- equal to false.
1417 -- For contacts there is no approver process attached.
1418 --
1419 -- ---------------------------------------------------------------------------
1420 PROCEDURE process_end_api
1421 (p_validate IN BOOLEAN DEFAULT FALSE
1422 ,p_transaction_step_id IN NUMBER
1423 ,p_effective_date in varchar2 default null
1424 );
1425 --
1426 -- ----------------------------------------------------------------------------
1427 -- |-------------------------< is_contact_added>------------------------|
1428 -- ----------------------------------------------------------------------------
1429 -- Purpose: This procedure will be called from contacts subprocess, which will
1430 -- determine if the control sholud go to the contacts page again or to the
1431 -- conatcs decision page.
1432 -- Case1 : If no contacts were added in this session Then Goto Decision page
1433 -- ( may be from contacts - back button
1434 -- Case2 : If there are some contacts added,Then Goto Contacts page to show last contact added
1435 -- ( coming from back button)
1436 --
1437 -- Parameters:
1438 -- Input
1442 -- not yet-- p_contact_set - required. It is the Last contact set added in to trx.
1439 -- p_item_type - required. It is the item type for the workflow process.
1440 -- p_item_key - required. It is the item key for the workflow process.
1441 -- p_actid - required. It is the item key for the workflow process.
1443
1444 -- Output Parameters:
1445 -- 1) p_resultout - will populate the result code for the activity
1446 -- Purpose: This procedure will read the HR_RUNTIME_APPROVAL_REQ_FLAG item level
1447 -- attribute value and branch accordingly. This value will be set by the review
1448 -- page by reading its attribute level attribute HR_APPROVAL_REQ_FLAG
1449 -- ----------------------------------------------------------------------------
1450 PROCEDURE is_contact_added
1451 (itemtype in varchar2
1452 ,itemkey in varchar2
1453 ,actid in number
1454 ,funcmode in varchar2 -- i need to remove this
1455 ,resultout out nocopy varchar2);
1456 --
1457 -- ----------------------------------------------------------------------------
1458 -- |-----------------------< delete_transaction_steps>------------------------|
1459 -- ----------------------------------------------------------------------------
1460 -- Purpose: These procedures will be called from contacts subprocess, which will
1461 -- remove the steps thst have been saved and are to be removed as the
1462 -- user went back to the contacts page and this data is displayed on
1463 -- the page and will be saved later.
1464 --
1465 PROCEDURE delete_transaction_steps(
1466 p_item_type IN varchar2,
1467 p_item_key IN varchar2,
1468 p_actid IN varchar2,
1469 p_login_person_id IN varchar2);
1470 -- ----------------------------------------------------------------------------
1471 -- |-----------------------< delete_transaction_steps Overloaded>------------------------|
1472 -- ----------------------------------------------------------------------------
1473 -- Purpose: These procedures will be called from contacts subprocess, which will
1474 -- remove the steps thst have been saved and are to be removed as the
1475 -- user went back to the contacts page and this data is displayed on
1476 -- the page and will be saved later.
1477 --
1478 PROCEDURE delete_transaction_steps(
1479 p_item_type IN varchar2,
1480 p_item_key IN varchar2,
1481 p_actid IN varchar2,
1482 p_login_person_id IN varchar2,
1483 p_mode IN varchar2);
1484 ---
1485 /*
1486 procedure save_for_later_validation
1487 (p_item_type in varchar2
1488 ,p_item_key in varchar2
1489 ,p_return out nocopy varchar2);
1490 --
1491 */
1492 procedure update_object_version
1493 (p_transaction_step_id in number
1494 ,p_login_person_id in number);
1495
1496 -- Bug # 2263008: checks if duplicate SSN is entered.
1497 procedure check_ni_unique
1498 (p_national_identifier in varchar2 default null
1499 ,p_business_group_id in number
1500 ,p_person_id in number
1501 ,p_ni_duplicate_warn_or_err out nocopy varchar2);
1502 --
1503 -- Bug 3152505 :a new procedure to make a validation call to create_contact_api.
1504 procedure call_contact_api
1505 (p_validate in boolean default false
1506 ,p_start_date in date
1507 ,p_business_group_id in number
1508 ,p_person_id in number
1509 ,p_contact_person_id in number default null
1510 ,p_contact_type in varchar2
1511 ,p_ctr_comments in varchar2 default null
1512 ,p_primary_contact_flag in varchar2 default 'N'
1513 ,p_date_start in date default null
1514 ,p_start_life_reason_id in number default null
1515 ,p_date_end in date default null
1516 ,p_end_life_reason_id in number default null
1517 ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default 'N'
1518 ,p_personal_flag in varchar2 default 'N'
1519 ,p_sequence_number in number default null
1520 ,p_cont_attribute_category in varchar2 default null
1521 ,p_cont_attribute1 in varchar2 default null
1522 ,p_cont_attribute2 in varchar2 default null
1523 ,p_cont_attribute3 in varchar2 default null
1524 ,p_cont_attribute4 in varchar2 default null
1525 ,p_cont_attribute5 in varchar2 default null
1526 ,p_cont_attribute6 in varchar2 default null
1527 ,p_cont_attribute7 in varchar2 default null
1528 ,p_cont_attribute8 in varchar2 default null
1529 ,p_cont_attribute9 in varchar2 default null
1530 ,p_cont_attribute10 in varchar2 default null
1531 ,p_cont_attribute11 in varchar2 default null
1532 ,p_cont_attribute12 in varchar2 default null
1533 ,p_cont_attribute13 in varchar2 default null
1534 ,p_cont_attribute14 in varchar2 default null
1535 ,p_cont_attribute15 in varchar2 default null
1536 ,p_cont_attribute16 in varchar2 default null
1537 ,p_cont_attribute17 in varchar2 default null
1538 ,p_cont_attribute18 in varchar2 default null
1539 ,p_cont_attribute19 in varchar2 default null
1540 ,p_cont_attribute20 in varchar2 default null
1541 ,p_cont_information_category in varchar2 default null
1542 ,p_cont_information1 in varchar2 default null
1543 ,p_cont_information2 in varchar2 default null
1544 ,p_cont_information3 in varchar2 default null
1548 ,p_cont_information7 in varchar2 default null
1545 ,p_cont_information4 in varchar2 default null
1546 ,p_cont_information5 in varchar2 default null
1547 ,p_cont_information6 in varchar2 default null
1549 ,p_cont_information8 in varchar2 default null
1550 ,p_cont_information9 in varchar2 default null
1551 ,p_cont_information10 in varchar2 default null
1552 ,p_cont_information11 in varchar2 default null
1553 ,p_cont_information12 in varchar2 default null
1554 ,p_cont_information13 in varchar2 default null
1555 ,p_cont_information14 in varchar2 default null
1556 ,p_cont_information15 in varchar2 default null
1557 ,p_cont_information16 in varchar2 default null
1558 ,p_cont_information17 in varchar2 default null
1559 ,p_cont_information18 in varchar2 default null
1560 ,p_cont_information19 in varchar2 default null
1561 ,p_cont_information20 in varchar2 default null
1562 ,p_third_party_pay_flag in varchar2 default 'N'
1563 ,p_bondholder_flag in varchar2 default 'N'
1564 ,p_dependent_flag in varchar2 default 'N'
1565 ,p_beneficiary_flag in varchar2 default 'N'
1566 ,p_last_name in varchar2 default null
1567 ,p_sex in varchar2 default null
1568 ,p_person_type_id in number default null
1569 ,p_per_comments in varchar2 default null
1570 ,p_date_of_birth in date default null
1571 ,p_email_address in varchar2 default null
1572 ,p_first_name in varchar2 default null
1573 ,p_known_as in varchar2 default null
1574 ,p_marital_status in varchar2 default null
1575 ,p_middle_names in varchar2 default null
1576 ,p_nationality in varchar2 default null
1577 ,p_national_identifier in varchar2 default null
1578 ,p_previous_last_name in varchar2 default null
1579 ,p_registered_disabled_flag in varchar2 default null
1580 ,p_title in varchar2 default null
1581 ,p_work_telephone in varchar2 default null
1582 ,p_attribute_category in varchar2 default null
1583 ,p_attribute1 in varchar2 default null
1584 ,p_attribute2 in varchar2 default null
1585 ,p_attribute3 in varchar2 default null
1586 ,p_attribute4 in varchar2 default null
1587 ,p_attribute5 in varchar2 default null
1588 ,p_attribute6 in varchar2 default null
1589 ,p_attribute7 in varchar2 default null
1590 ,p_attribute8 in varchar2 default null
1591 ,p_attribute9 in varchar2 default null
1592 ,p_attribute10 in varchar2 default null
1593 ,p_attribute11 in varchar2 default null
1594 ,p_attribute12 in varchar2 default null
1595 ,p_attribute13 in varchar2 default null
1596 ,p_attribute14 in varchar2 default null
1597 ,p_attribute15 in varchar2 default null
1598 ,p_attribute16 in varchar2 default null
1599 ,p_attribute17 in varchar2 default null
1600 ,p_attribute18 in varchar2 default null
1601 ,p_attribute19 in varchar2 default null
1602 ,p_attribute20 in varchar2 default null
1603 ,p_attribute21 in varchar2 default null
1604 ,p_attribute22 in varchar2 default null
1605 ,p_attribute23 in varchar2 default null
1606 ,p_attribute24 in varchar2 default null
1607 ,p_attribute25 in varchar2 default null
1608 ,p_attribute26 in varchar2 default null
1609 ,p_attribute27 in varchar2 default null
1610 ,p_attribute28 in varchar2 default null
1611 ,p_attribute29 in varchar2 default null
1612 ,p_attribute30 in varchar2 default null
1613 ,p_per_information_category in varchar2 default null
1614 ,p_per_information1 in varchar2 default null
1615 ,p_per_information2 in varchar2 default null
1616 ,p_per_information3 in varchar2 default null
1617 ,p_per_information4 in varchar2 default null
1618 ,p_per_information5 in varchar2 default null
1619 ,p_per_information6 in varchar2 default null
1620 ,p_per_information7 in varchar2 default null
1621 ,p_per_information8 in varchar2 default null
1622 ,p_per_information9 in varchar2 default null
1623 ,p_per_information10 in varchar2 default null
1624 ,p_per_information11 in varchar2 default null
1625 ,p_per_information12 in varchar2 default null
1626 ,p_per_information13 in varchar2 default null
1627 ,p_per_information14 in varchar2 default null
1628 ,p_per_information15 in varchar2 default null
1629 ,p_per_information16 in varchar2 default null
1630 ,p_per_information17 in varchar2 default null
1634 ,p_per_information21 in varchar2 default null
1631 ,p_per_information18 in varchar2 default null
1632 ,p_per_information19 in varchar2 default null
1633 ,p_per_information20 in varchar2 default null
1635 ,p_per_information22 in varchar2 default null
1636 ,p_per_information23 in varchar2 default null
1637 ,p_per_information24 in varchar2 default null
1638 ,p_per_information25 in varchar2 default null
1639 ,p_per_information26 in varchar2 default null
1640 ,p_per_information27 in varchar2 default null
1641 ,p_per_information28 in varchar2 default null
1642 ,p_per_information29 in varchar2 default null
1643 ,p_per_information30 in varchar2 default null
1644 ,p_correspondence_language in varchar2 default null
1645 ,p_honors in varchar2 default null
1646 ,p_pre_name_adjunct in varchar2 default null
1647 ,p_suffix in varchar2 default null
1648 ,p_create_mirror_flag in varchar2 default 'N'
1649 ,p_mirror_type in varchar2 default null
1650 ,p_mirror_cont_attribute_cat in varchar2 default null
1651 ,p_mirror_cont_attribute1 in varchar2 default null
1652 ,p_mirror_cont_attribute2 in varchar2 default null
1653 ,p_mirror_cont_attribute3 in varchar2 default null
1654 ,p_mirror_cont_attribute4 in varchar2 default null
1655 ,p_mirror_cont_attribute5 in varchar2 default null
1656 ,p_mirror_cont_attribute6 in varchar2 default null
1657 ,p_mirror_cont_attribute7 in varchar2 default null
1658 ,p_mirror_cont_attribute8 in varchar2 default null
1659 ,p_mirror_cont_attribute9 in varchar2 default null
1660 ,p_mirror_cont_attribute10 in varchar2 default null
1661 ,p_mirror_cont_attribute11 in varchar2 default null
1662 ,p_mirror_cont_attribute12 in varchar2 default null
1663 ,p_mirror_cont_attribute13 in varchar2 default null
1664 ,p_mirror_cont_attribute14 in varchar2 default null
1665 ,p_mirror_cont_attribute15 in varchar2 default null
1666 ,p_mirror_cont_attribute16 in varchar2 default null
1667 ,p_mirror_cont_attribute17 in varchar2 default null
1668 ,p_mirror_cont_attribute18 in varchar2 default null
1669 ,p_mirror_cont_attribute19 in varchar2 default null
1670 ,p_mirror_cont_attribute20 in varchar2 default null
1671 ,p_mirror_cont_information_cat in varchar2 default null
1672 ,p_mirror_cont_information1 in varchar2 default null
1673 ,p_mirror_cont_information2 in varchar2 default null
1674 ,p_mirror_cont_information3 in varchar2 default null
1675 ,p_mirror_cont_information4 in varchar2 default null
1676 ,p_mirror_cont_information5 in varchar2 default null
1677 ,p_mirror_cont_information6 in varchar2 default null
1678 ,p_mirror_cont_information7 in varchar2 default null
1679 ,p_mirror_cont_information8 in varchar2 default null
1680 ,p_mirror_cont_information9 in varchar2 default null
1681 ,p_mirror_cont_information10 in varchar2 default null
1682 ,p_mirror_cont_information11 in varchar2 default null
1683 ,p_mirror_cont_information12 in varchar2 default null
1684 ,p_mirror_cont_information13 in varchar2 default null
1685 ,p_mirror_cont_information14 in varchar2 default null
1686 ,p_mirror_cont_information15 in varchar2 default null
1687 ,p_mirror_cont_information16 in varchar2 default null
1688 ,p_mirror_cont_information17 in varchar2 default null
1689 ,p_mirror_cont_information18 in varchar2 default null
1690 ,p_mirror_cont_information19 in varchar2 default null
1691 ,p_mirror_cont_information20 in varchar2 default null
1692 --
1693 ,p_contact_relationship_id out nocopy number
1694 ,p_ctr_object_version_number out nocopy number
1695 ,p_per_person_id out nocopy number
1696 ,p_per_object_version_number out nocopy number
1697 ,p_per_effective_start_date out nocopy date
1698 ,p_per_effective_end_date out nocopy date
1699 ,p_full_name out nocopy varchar2
1700 ,p_per_comment_id out nocopy number
1701 ,p_name_combination_warning out nocopy boolean
1702 ,p_orig_hire_warning out nocopy boolean
1703 --
1704 ,p_contact_operation in varchar2
1705 ,p_emrg_cont_flag in varchar2 default 'N'
1706 );
1707 --
1708 procedure get_emrg_rel_id (
1709 P_contact_relationship_id in number
1710 ,p_contact_person_id in number
1711 ,p_emrg_rel_id out nocopy varchar2
1712 ,p_no_of_non_emrg_rel out nocopy varchar2
1713 ,p_other_rel_type out nocopy varchar2
1714 ,p_emrg_rel_type out nocopy varchar2)
1715 ;
1716 --
1717 procedure validate_rel_start_date (
1718 p_person_id in number
1719 ,p_item_key in varchar2
1720 ,p_save_mode in varchar2
1721 ,p_date_start in out nocopy date
1722 ,p_date_of_birth in date)
1723 ;
1724 --
1725 /* This function checks if teh primary contact field has changed.And if the
1726 Primary Contact field has changed, it validates it.
1727 */
1728 Procedure validate_primary_cont_flag(
1729 p_contact_relationship_id in number
1730 ,p_primary_contact_flag in varchar2
1731 ,p_date_start in date
1732 ,p_contact_person_id in number
1733 ,p_object_version_number in out nocopy number)
1734 ;
1735
1736 END hr_process_contact_ss;
1737
[Home] [Help]