eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.HR_CONTACT_RELATIONSHIPS

Source


1 PACKAGE HR_CONTACT_RELATIONSHIPS as
2 /* $Header: pecon02t.pkh 120.2 2006/02/13 06:12:59 asgugupt noship $ */
3 /*===========================================================================+
4  |               Copyright (c) 1993 Oracle Corporation                       |
5  |                  Redwood Shores, California, USA                          |
6  |                       All rights reserved.                                |
7  +===========================================================================*/
8 /*---------------------------------------------------------------------------
9 Description
10 -----------
11 
12 Date        Author    Version Description
13 ---------   --------- ------- -------------------------------------------
14 09-May-94   JRhodes   80.0    Created Initial Version
15 25-Jan-95   JRhodes   70.4    Added ATTRIBUTE21-30 for people
16                               Added REGISTERED_DISABLED_FLAG
17 05-Jul-95   TMathers  70.5    Added validate_address and check_ppm.
18 13-Jul-95   TMathers  70.6    Added extra parmeters to check_ppm.
19 11-Sep-95   SSDesai   70.7    Added check_beneficiary and check_dependent.
20 18-Jul-97   RKamiyam  70.8    Added per_information1 to 30 and known_as cols
21 16-Feb-99   ASahay    110.3   Added function multiple_contacts
22 10-Feb-00   KSivagur  110.4   Added parameters p_pre_name_adjunct and p_suffix
23 14-NOV-02   MGettins  115.6   Added npw_number parameter to get_person_details.
24 15-NOV-02   MGettins  115.7   Added dbdrv lines.
25 04-DEC-02   PKakar    115.8   Added nocopy changes
26 24-JAN-02   DCasemor  115.9   Overloaded get_person_details.
27 13-FEB-05   asgugupt  115.10  Overloaded get_person_details for bug no 4957699.
28 ---------------------------------------------------------------------------*/
29 
30 /* OVERLOADED; includes p_npw_number. This has been overloaded because
31    of other team's dependencies on this procedure.  Their code becomes
32    invalid unless this is overloaded and due to time constraints it is
33    not possible to coordinate the changing of all dependent code. */
34 PROCEDURE get_person_details
35 (p_person_id IN NUMBER
36 ,p_session_date IN DATE
37 ,p_first_name IN OUT NOCOPY varchar2
38 ,p_middle_names IN OUT NOCOPY varchar2
39 ,p_pre_name_adjunct IN OUT NOCOPY varchar2
40 ,p_suffix IN OUT NOCOPY varchar2
41 ,p_title IN OUT NOCOPY varchar2
42 ,p_sex IN OUT NOCOPY varchar2
43 ,p_date_of_birth IN OUT NOCOPY DATE
44 ,p_age IN OUT NOCOPY number
45 ,p_employee_number IN OUT NOCOPY varchar2
46 ,p_applicant_number IN OUT NOCOPY varchar2
47 ,p_title_desc IN OUT NOCOPY varchar2
48 ,p_national_identifier IN OUT NOCOPY VARCHAR2
49 ,p_person_type_id IN OUT NOCOPY number
50 ,p_user_person_type IN OUT NOCOPY varchar2
51 ,p_system_person_type IN OUT NOCOPY varchar2
52 ,p_current_employee_flag IN OUT NOCOPY varchar2
53 ,p_current_applicant_flag IN OUT NOCOPY varchar2
54 ,p_current_emp_or_apl_flag IN OUT NOCOPY varchar2
55 ,p_registered_disabled_flag IN OUT NOCOPY varchar2
56 ,p_attribute_category IN OUT NOCOPY varchar2
57 ,p_attribute1 IN OUT NOCOPY varchar2
58 ,p_attribute2 IN OUT NOCOPY varchar2
59 ,p_attribute3 IN OUT NOCOPY varchar2
60 ,p_attribute4 IN OUT NOCOPY varchar2
61 ,p_attribute5 IN OUT NOCOPY varchar2
62 ,p_attribute6 IN OUT NOCOPY varchar2
63 ,p_attribute7 IN OUT NOCOPY varchar2
64 ,p_attribute8 IN OUT NOCOPY varchar2
65 ,p_attribute9 IN OUT NOCOPY varchar2
66 ,p_attribute10 IN OUT NOCOPY varchar2
67 ,p_attribute11 IN OUT NOCOPY varchar2
68 ,p_attribute12 IN OUT NOCOPY varchar2
69 ,p_attribute13 IN OUT NOCOPY varchar2
70 ,p_attribute14 IN OUT NOCOPY varchar2
71 ,p_attribute15 IN OUT NOCOPY varchar2
72 ,p_attribute16 IN OUT NOCOPY varchar2
73 ,p_attribute17 IN OUT NOCOPY varchar2
74 ,p_attribute18 IN OUT NOCOPY varchar2
75 ,p_attribute19 IN OUT NOCOPY varchar2
76 ,p_attribute20 IN OUT NOCOPY varchar2
77 ,p_attribute21 IN OUT NOCOPY varchar2
78 ,p_attribute22 IN OUT NOCOPY varchar2
79 ,p_attribute23 IN OUT NOCOPY varchar2
80 ,p_attribute24 IN OUT NOCOPY varchar2
81 ,p_attribute25 IN OUT NOCOPY varchar2
82 ,p_attribute26 IN OUT NOCOPY varchar2
83 ,p_attribute27 IN OUT NOCOPY varchar2
84 ,p_attribute28 IN OUT NOCOPY varchar2
85 ,p_attribute29 IN OUT NOCOPY varchar2
86 ,p_attribute30 IN OUT NOCOPY varchar2
87 ,p_comment_id IN OUT NOCOPY number
88 ,p_contact_only IN OUT NOCOPY varchar2
89 ,p_per_information_category IN OUT NOCOPY varchar2
90 ,p_per_information1 IN OUT NOCOPY varchar2
91 ,p_per_information2 IN OUT NOCOPY varchar2
92 ,p_per_information3 IN OUT NOCOPY varchar2
93 ,p_per_information4 IN OUT NOCOPY varchar2
94 ,p_per_information5 IN OUT NOCOPY varchar2
95 ,p_per_information6 IN OUT NOCOPY varchar2
96 ,p_per_information7 IN OUT NOCOPY varchar2
97 ,p_per_information8 IN OUT NOCOPY varchar2
98 ,p_per_information9 IN OUT NOCOPY varchar2
99 ,p_per_information10 IN OUT NOCOPY varchar2
100 ,p_per_information11 IN OUT NOCOPY varchar2
101 ,p_per_information12 IN OUT NOCOPY varchar2
102 ,p_per_information13 IN OUT NOCOPY varchar2
103 ,p_per_information14 IN OUT NOCOPY varchar2
104 ,p_per_information15 IN OUT NOCOPY varchar2
105 ,p_per_information16 IN OUT NOCOPY varchar2
106 ,p_per_information17 IN OUT NOCOPY varchar2
107 ,p_per_information18 IN OUT NOCOPY varchar2
108 ,p_per_information19 IN OUT NOCOPY varchar2
109 ,p_per_information20 IN OUT NOCOPY varchar2
110 ,p_per_information21 IN OUT NOCOPY varchar2
111 ,p_per_information22 IN OUT NOCOPY varchar2
112 ,p_per_information23 IN OUT NOCOPY varchar2
113 ,p_per_information24 IN OUT NOCOPY varchar2
114 ,p_per_information25 IN OUT NOCOPY varchar2
115 ,p_per_information26 IN OUT NOCOPY varchar2
116 ,p_per_information27 IN OUT NOCOPY varchar2
117 ,p_per_information28 IN OUT NOCOPY varchar2
118 ,p_per_information29 IN OUT NOCOPY varchar2
119 ,p_per_information30 IN OUT NOCOPY varchar2
120 ,p_known_as          IN OUT NOCOPY varchar2
121 ,p_npw_number        IN OUT NOCOPY varchar2);
122 
123 PROCEDURE get_person_details
124 (p_person_id IN NUMBER
125 ,p_session_date IN DATE
126 ,p_first_name IN OUT NOCOPY varchar2
127 ,p_middle_names IN OUT NOCOPY varchar2
128 ,p_pre_name_adjunct IN OUT NOCOPY varchar2
129 ,p_suffix IN OUT NOCOPY varchar2
130 ,p_title IN OUT NOCOPY varchar2
131 ,p_sex IN OUT NOCOPY varchar2
132 ,p_date_of_birth IN OUT NOCOPY DATE
133 ,p_age IN OUT NOCOPY number
134 ,p_employee_number IN OUT NOCOPY varchar2
135 ,p_applicant_number IN OUT NOCOPY varchar2
136 ,p_title_desc IN OUT NOCOPY varchar2
137 ,p_national_identifier IN OUT NOCOPY VARCHAR2
138 ,p_person_type_id IN OUT NOCOPY number
139 ,p_user_person_type IN OUT NOCOPY varchar2
140 ,p_system_person_type IN OUT NOCOPY varchar2
141 ,p_current_employee_flag IN OUT NOCOPY varchar2
142 ,p_current_applicant_flag IN OUT NOCOPY varchar2
143 ,p_current_emp_or_apl_flag IN OUT NOCOPY varchar2
144 ,p_registered_disabled_flag IN OUT NOCOPY varchar2
145 ,p_attribute_category IN OUT NOCOPY varchar2
146 ,p_attribute1 IN OUT NOCOPY varchar2
147 ,p_attribute2 IN OUT NOCOPY varchar2
148 ,p_attribute3 IN OUT NOCOPY varchar2
149 ,p_attribute4 IN OUT NOCOPY varchar2
150 ,p_attribute5 IN OUT NOCOPY varchar2
151 ,p_attribute6 IN OUT NOCOPY varchar2
152 ,p_attribute7 IN OUT NOCOPY varchar2
153 ,p_attribute8 IN OUT NOCOPY varchar2
154 ,p_attribute9 IN OUT NOCOPY varchar2
155 ,p_attribute10 IN OUT NOCOPY varchar2
156 ,p_attribute11 IN OUT NOCOPY varchar2
157 ,p_attribute12 IN OUT NOCOPY varchar2
158 ,p_attribute13 IN OUT NOCOPY varchar2
159 ,p_attribute14 IN OUT NOCOPY varchar2
160 ,p_attribute15 IN OUT NOCOPY varchar2
161 ,p_attribute16 IN OUT NOCOPY varchar2
162 ,p_attribute17 IN OUT NOCOPY varchar2
163 ,p_attribute18 IN OUT NOCOPY varchar2
164 ,p_attribute19 IN OUT NOCOPY varchar2
165 ,p_attribute20 IN OUT NOCOPY varchar2
166 ,p_attribute21 IN OUT NOCOPY varchar2
167 ,p_attribute22 IN OUT NOCOPY varchar2
168 ,p_attribute23 IN OUT NOCOPY varchar2
169 ,p_attribute24 IN OUT NOCOPY varchar2
170 ,p_attribute25 IN OUT NOCOPY varchar2
171 ,p_attribute26 IN OUT NOCOPY varchar2
172 ,p_attribute27 IN OUT NOCOPY varchar2
173 ,p_attribute28 IN OUT NOCOPY varchar2
174 ,p_attribute29 IN OUT NOCOPY varchar2
175 ,p_attribute30 IN OUT NOCOPY varchar2
176 ,p_comment_id IN OUT NOCOPY number
177 ,p_contact_only IN OUT NOCOPY varchar2
178 ,p_per_information_category IN OUT NOCOPY varchar2
179 ,p_per_information1 IN OUT NOCOPY varchar2
180 ,p_per_information2 IN OUT NOCOPY varchar2
181 ,p_per_information3 IN OUT NOCOPY varchar2
182 ,p_per_information4 IN OUT NOCOPY varchar2
183 ,p_per_information5 IN OUT NOCOPY varchar2
184 ,p_per_information6 IN OUT NOCOPY varchar2
185 ,p_per_information7 IN OUT NOCOPY varchar2
186 ,p_per_information8 IN OUT NOCOPY varchar2
187 ,p_per_information9 IN OUT NOCOPY varchar2
188 ,p_per_information10 IN OUT NOCOPY varchar2
189 ,p_per_information11 IN OUT NOCOPY varchar2
190 ,p_per_information12 IN OUT NOCOPY varchar2
191 ,p_per_information13 IN OUT NOCOPY varchar2
192 ,p_per_information14 IN OUT NOCOPY varchar2
193 ,p_per_information15 IN OUT NOCOPY varchar2
194 ,p_per_information16 IN OUT NOCOPY varchar2
195 ,p_per_information17 IN OUT NOCOPY varchar2
196 ,p_per_information18 IN OUT NOCOPY varchar2
197 ,p_per_information19 IN OUT NOCOPY varchar2
198 ,p_per_information20 IN OUT NOCOPY varchar2
199 ,p_per_information21 IN OUT NOCOPY varchar2
200 ,p_per_information22 IN OUT NOCOPY varchar2
201 ,p_per_information23 IN OUT NOCOPY varchar2
202 ,p_per_information24 IN OUT NOCOPY varchar2
203 ,p_per_information25 IN OUT NOCOPY varchar2
204 ,p_per_information26 IN OUT NOCOPY varchar2
205 ,p_per_information27 IN OUT NOCOPY varchar2
206 ,p_per_information28 IN OUT NOCOPY varchar2
207 ,p_per_information29 IN OUT NOCOPY varchar2
208 ,p_per_information30 IN OUT NOCOPY varchar2
209 ,p_known_as          IN OUT NOCOPY varchar2);
210 -- fix for bug 4957699 starts here.
211 PROCEDURE get_person_details
212 (p_person_id IN NUMBER
213 ,p_session_date IN DATE
214 ,p_first_name IN OUT NOCOPY varchar2
215 ,p_middle_names IN OUT NOCOPY varchar2
216 ,p_pre_name_adjunct IN OUT NOCOPY varchar2
217 ,p_suffix IN OUT NOCOPY varchar2
218 ,p_title IN OUT NOCOPY varchar2
219 ,p_sex IN OUT NOCOPY varchar2
220 ,p_date_of_birth IN OUT NOCOPY DATE
221 ,p_age IN OUT NOCOPY number
222 ,p_employee_number IN OUT NOCOPY varchar2
223 ,p_applicant_number IN OUT NOCOPY varchar2
224 ,p_title_desc IN OUT NOCOPY varchar2
225 ,p_national_identifier IN OUT NOCOPY VARCHAR2
226 ,p_person_type_id IN OUT NOCOPY number
227 ,p_user_person_type IN OUT NOCOPY varchar2
228 ,p_system_person_type IN OUT NOCOPY varchar2
229 ,p_current_employee_flag IN OUT NOCOPY varchar2
230 ,p_current_applicant_flag IN OUT NOCOPY varchar2
231 ,p_current_emp_or_apl_flag IN OUT NOCOPY varchar2
232 ,p_registered_disabled_flag IN OUT NOCOPY varchar2
233 ,p_attribute_category IN OUT NOCOPY varchar2
234 ,p_attribute1 IN OUT NOCOPY varchar2
235 ,p_attribute2 IN OUT NOCOPY varchar2
236 ,p_attribute3 IN OUT NOCOPY varchar2
237 ,p_attribute4 IN OUT NOCOPY varchar2
238 ,p_attribute5 IN OUT NOCOPY varchar2
239 ,p_attribute6 IN OUT NOCOPY varchar2
240 ,p_attribute7 IN OUT NOCOPY varchar2
241 ,p_attribute8 IN OUT NOCOPY varchar2
242 ,p_attribute9 IN OUT NOCOPY varchar2
243 ,p_attribute10 IN OUT NOCOPY varchar2
244 ,p_attribute11 IN OUT NOCOPY varchar2
245 ,p_attribute12 IN OUT NOCOPY varchar2
246 ,p_attribute13 IN OUT NOCOPY varchar2
247 ,p_attribute14 IN OUT NOCOPY varchar2
248 ,p_attribute15 IN OUT NOCOPY varchar2
249 ,p_attribute16 IN OUT NOCOPY varchar2
250 ,p_attribute17 IN OUT NOCOPY varchar2
251 ,p_attribute18 IN OUT NOCOPY varchar2
252 ,p_attribute19 IN OUT NOCOPY varchar2
253 ,p_attribute20 IN OUT NOCOPY varchar2
254 ,p_attribute21 IN OUT NOCOPY varchar2
255 ,p_attribute22 IN OUT NOCOPY varchar2
256 ,p_attribute23 IN OUT NOCOPY varchar2
257 ,p_attribute24 IN OUT NOCOPY varchar2
258 ,p_attribute25 IN OUT NOCOPY varchar2
259 ,p_attribute26 IN OUT NOCOPY varchar2
260 ,p_attribute27 IN OUT NOCOPY varchar2
261 ,p_attribute28 IN OUT NOCOPY varchar2
262 ,p_attribute29 IN OUT NOCOPY varchar2
263 ,p_attribute30 IN OUT NOCOPY varchar2
264 ,p_comment_id IN OUT NOCOPY number
265 ,p_contact_only IN OUT NOCOPY varchar2
266 ,p_per_information_category IN OUT NOCOPY varchar2
267 ,p_per_information1 IN OUT NOCOPY varchar2
268 ,p_per_information2 IN OUT NOCOPY varchar2
269 ,p_per_information3 IN OUT NOCOPY varchar2
270 ,p_per_information4 IN OUT NOCOPY varchar2
271 ,p_per_information5 IN OUT NOCOPY varchar2
272 ,p_per_information6 IN OUT NOCOPY varchar2
273 ,p_per_information7 IN OUT NOCOPY varchar2
274 ,p_per_information8 IN OUT NOCOPY varchar2
275 ,p_per_information9 IN OUT NOCOPY varchar2
276 ,p_per_information10 IN OUT NOCOPY varchar2
277 ,p_per_information11 IN OUT NOCOPY varchar2
278 ,p_per_information12 IN OUT NOCOPY varchar2
279 ,p_per_information13 IN OUT NOCOPY varchar2
280 ,p_per_information14 IN OUT NOCOPY varchar2
281 ,p_per_information15 IN OUT NOCOPY varchar2
282 ,p_per_information16 IN OUT NOCOPY varchar2
283 ,p_per_information17 IN OUT NOCOPY varchar2
284 ,p_per_information18 IN OUT NOCOPY varchar2
285 ,p_per_information19 IN OUT NOCOPY varchar2
286 ,p_per_information20 IN OUT NOCOPY varchar2
287 ,p_per_information21 IN OUT NOCOPY varchar2
288 ,p_per_information22 IN OUT NOCOPY varchar2
289 ,p_per_information23 IN OUT NOCOPY varchar2
290 ,p_per_information24 IN OUT NOCOPY varchar2
291 ,p_per_information25 IN OUT NOCOPY varchar2
292 ,p_per_information26 IN OUT NOCOPY varchar2
293 ,p_per_information27 IN OUT NOCOPY varchar2
294 ,p_per_information28 IN OUT NOCOPY varchar2
295 ,p_per_information29 IN OUT NOCOPY varchar2
296 ,p_per_information30 IN OUT NOCOPY varchar2
300  -- fix for bug 4957699 ends here.
297 ,p_known_as          IN OUT NOCOPY varchar2
298 ,p_npw_number        IN OUT NOCOPY varchar2
299 ,p_date_of_death     IN OUT NOCOPY DATE);
301 FUNCTION contact_only(p_person_id number) return VARCHAR2;
302 
303 FUNCTION multiple_contacts(p_person_id number) return VARCHAR2;
304 
305 PROCEDURE get_default_ctype(p_business_group_id number
306                            ,p_def_type_id IN OUT NOCOPY number
307                            ,p_def_type IN OUT NOCOPY varchar2
308                            ,p_def_sys_type IN OUT NOCOPY varchar2);
309 
310 FUNCTION get_application(p_form_name VARCHAR2) return VARCHAR2;
311 
312 FUNCTION validate_address(p_contact_id NUMBER) RETURN BOOLEAN;
313 --
314 PROCEDURE check_ppm(p_contact_id NUMBER
315                     ,p_contact_relationship_id  NUMBER
316                     ,p_mode VARCHAR2);
317 --
318 PROCEDURE check_beneficiary(p_person_id NUMBER, p_contact_id NUMBER);
319 --
320 PROCEDURE check_dependent(p_contact_relationship_id NUMBER);
321 --
322 END HR_CONTACT_RELATIONSHIPS;