1 PACKAGE IGS_PE_PERSON_SS_PKG AS
2 /* $Header: IGSPE10S.pls 120.3 2005/09/22 23:51:39 appldev ship $ */
3
4 /* +=======================================================================+
5 | Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 who when what
9 gmaheswa 10-Nov-2003 Bug 3223043 HZ.K Impact Changes .
10 Added 3 new columns to update_employment
11 asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row and update_row changed
12 signature of igs_pe_person_ss_pkg.update_address now includes 3 new parameters
13 --skpandey 21-SEP-2005 Bug: 3663505
14 -- Description: Added ATTRIBUTES 21 TO 24 TO STORE ADDITIONAL INFORMATION
15 */
16
17 PROCEDURE Update_Privacy(
18 p_api_version IN NUMBER,
19 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20 p_commit IN VARCHAR2 := FND_API.G_FALSE,
21 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2,
25 x_privacy_level_id OUT NOCOPY NUMBER,
26 p_mode IN VARCHAR2,
27 p_person_id IN NUMBER,
28 p_privacy_level_id IN NUMBER,
29 p_data_group_id IN NUMBER,
30 p_data_group IN VARCHAR2,
31 p_lvl IN VARCHAR2,
32 p_action IN VARCHAR2,
33 p_whom IN VARCHAR2,
34 p_start_date IN DATE,
35 p_end_date IN DATE
36 );
37
38
39 PROCEDURE Update_Person(
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_person_id IN NUMBER,
44 p_suffix IN VARCHAR2,
45 p_middle_name IN VARCHAR2,
46 p_pre_name_adjunct IN VARCHAR2,
47 p_sex IN VARCHAR2,
48 p_title IN VARCHAR2,
49 p_birth_dt IN DATE,
50 p_preferred_name IN VARCHAR2,
51 p_api_person_id IN VARCHAR2,
52 p_hz_parties_ovn IN OUT NOCOPY NUMBER,
53 p_attribute_category IN VARCHAR2,
54 p_attribute1 IN VARCHAR2,
55 p_attribute2 IN VARCHAR2,
56 p_attribute3 IN VARCHAR2,
57 p_attribute4 IN VARCHAR2,
58 p_attribute5 IN VARCHAR2,
59 p_attribute6 IN VARCHAR2,
60 p_attribute7 IN VARCHAR2,
61 p_attribute8 IN VARCHAR2,
62 p_attribute9 IN VARCHAR2,
63 p_attribute10 IN VARCHAR2,
64 p_attribute11 IN VARCHAR2,
65 p_attribute12 IN VARCHAR2,
66 p_attribute13 IN VARCHAR2,
67 p_attribute14 IN VARCHAR2,
68 p_attribute15 IN VARCHAR2,
69 p_attribute16 IN VARCHAR2,
70 p_attribute17 IN VARCHAR2,
71 p_attribute18 IN VARCHAR2,
72 p_attribute19 IN VARCHAR2,
73 p_attribute20 IN VARCHAR2,
74 p_attribute21 IN VARCHAR2 DEFAULT NULL,
75 p_attribute22 IN VARCHAR2 DEFAULT NULL,
76 p_attribute23 IN VARCHAR2 DEFAULT NULL,
77 p_attribute24 IN VARCHAR2 DEFAULT NULL
78 );
79
80 PROCEDURE Update_Contact(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE,
84 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 x_id OUT NOCOPY NUMBER,
89 p_mode IN VARCHAR2,
90 p_person_id IN NUMBER,
91 p_contact_point_id IN NUMBER,
92 p_contact_point_ovn IN OUT NOCOPY NUMBER,
93 p_status IN VARCHAR2,
94 p_primary_flag IN VARCHAR2,
95 p_phone_area_code IN VARCHAR2,
96 p_phone_country_code IN VARCHAR2,
97 p_phone_number IN VARCHAR2,
98 p_phone_extension IN VARCHAR2,
99 p_phone_line_type IN VARCHAR2,
100 p_email_format IN VARCHAR2,
101 p_email_address IN VARCHAR2
102 );
103
104 PROCEDURE Update_Address(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE,
108 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 x_id OUT NOCOPY NUMBER,
113 p_mode IN VARCHAR2,
114 p_person_id IN NUMBER,
115 p_location_id IN NUMBER,
116 p_start_dt IN DATE,
117 p_end_dt IN DATE,
118 p_party_site_id IN NUMBER,
119 p_addr_line_1 IN VARCHAR2,
120 p_addr_line_2 IN VARCHAR2,
121 p_addr_line_3 IN VARCHAR2,
122 p_addr_line_4 IN VARCHAR2,
123 p_city IN VARCHAR2,
124 p_state IN VARCHAR2,
125 p_province IN VARCHAR2,
126 p_county IN VARCHAR2,
127 p_country IN VARCHAR2,
128 p_country_cd IN VARCHAR2,
129 p_postal_code IN VARCHAR2,
130 p_ident_addr_flag IN VARCHAR2,
131 p_location_ovn IN OUT NOCOPY hz_locations.object_version_number%TYPE,
132 p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
133 p_status IN hz_party_sites.status%TYPE
134 );
135
136
137
138
139 PROCEDURE Update_Usage(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142 p_commit IN VARCHAR2 := FND_API.G_FALSE,
143 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 x_id OUT NOCOPY NUMBER,
148 p_mode IN VARCHAR2,
149 p_party_site_use_id IN NUMBER,
150 p_party_site_id IN NUMBER,
151 p_site_use_type IN VARCHAR2,
152 p_location IN VARCHAR2,
153 p_site_use_id IN NUMBER,
154 p_active IN VARCHAR2,
155 p_hz_party_site_use_ovn IN OUT NOCOPY NUMBER
156 );
157
158
159 PROCEDURE Update_Employment(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162 p_commit IN VARCHAR2 := FND_API.G_FALSE,
163 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 x_id OUT NOCOPY NUMBER,
168 p_mode IN VARCHAR2,
169 p_person_id IN NUMBER,
170 p_employment_history_id IN NUMBER,
171 p_start_dt IN DATE,
172 p_end_dt IN DATE,
173 p_position IN VARCHAR2,
174 p_weekly_work_hours IN NUMBER,
175 p_comments IN VARCHAR2,
176 p_employer IN VARCHAR2,
177 p_employed_by_division_name IN VARCHAR2,
178 p_object_version_number IN OUT NOCOPY NUMBER,
179 p_employed_by_party_id IN NUMBER,
180 p_reason_for_leaving IN VARCHAR2,
181 p_type_of_employment IN VARCHAR2,
182 p_tenure_of_employment IN VARCHAR2
183 );
184
185
186 PROCEDURE Update_Emergency(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189 p_commit IN VARCHAR2 := FND_API.G_FALSE,
190 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 x_id OUT NOCOPY NUMBER,
195 p_mode IN VARCHAR2,
196 p_em_person_id IN NUMBER,
197 p_person_id IN NUMBER,
198 p_given_name IN VARCHAR2,
199 p_surname IN VARCHAR2,
200 p_middle_name IN VARCHAR2,
201 p_preferred_name IN VARCHAR2,
202 p_birthdate IN DATE,
203 p_pre_name_adjunct IN VARCHAR2,
204 p_suffix IN VARCHAR2,
205 p_title IN VARCHAR2,
206 p_rel_end IN VARCHAR2 DEFAULT 'N',
207 p_hz_parties_ovn IN OUT NOCOPY NUMBER,
208 p_hz_rel_ovn IN OUT NOCOPY NUMBER
209 );
210
211
212
213 PROCEDURE Update_Dates(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216 p_commit IN VARCHAR2 := FND_API.G_FALSE,
217 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_person_id IN NUMBER,
222 p_course_cd IN VARCHAR2,
223 p_version_number IN NUMBER,
224 p_nom_year IN VARCHAR2,
225 p_nom_period IN VARCHAR2,
226 p_action IN VARCHAR2
227 );
228
229 FUNCTION Get_Relationship_type
230 RETURN VARCHAR2;
231
232 PRAGMA RESTRICT_REFERENCES(Get_Relationship_type,WNDS,RNDS,WNPS,RNPS);
233
234 PROCEDURE Update_Biographic (
235 P_PERSON_ID IN NUMBER,
236 P_ETHNICITY IN VARCHAR2,
237 P_MARITAL_STATUS IN VARCHAR2,
238 P_MARITAL_STATUS_DATE IN DATE,
239 P_BIRTH_CITY IN VARCHAR2,
240 P_BIRTH_COUNTRY IN VARCHAR2,
241 P_VETERAN IN VARCHAR2,
242 P_RELIGION_CD IN VARCHAR2,
243 P_HZ_OVN IN NUMBER,
244 P_RETURN_STATUS OUT NOCOPY VARCHAR2,
245 P_MSG_COUNT OUT NOCOPY NUMBER,
246 P_MSG_DATA OUT NOCOPY VARCHAR2,
247 P_CALLER IN VARCHAR2 default null
248 );
249
250 PROCEDURE CREATEUPDATE_PERS_ALTID (
251 P_ACTION IN VARCHAR2,
252 P_PE_PERSON_ID IN NUMBER,
253 P_API_PERSON_ID IN VARCHAR2,
254 P_PERSON_ID_TYPE IN VARCHAR2,
255 P_START_DT IN DATE,
256 P_END_DT IN DATE,
257 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
258 P_ATTRIBUTE1 IN VARCHAR2,
259 P_ATTRIBUTE2 IN VARCHAR2,
260 P_ATTRIBUTE3 IN VARCHAR2,
261 P_ATTRIBUTE4 IN VARCHAR2,
262 P_ATTRIBUTE5 IN VARCHAR2,
263 P_ATTRIBUTE6 IN VARCHAR2,
264 P_ATTRIBUTE7 IN VARCHAR2,
265 P_ATTRIBUTE8 IN VARCHAR2,
266 P_ATTRIBUTE9 IN VARCHAR2,
267 P_ATTRIBUTE10 IN VARCHAR2,
268 P_ATTRIBUTE11 IN VARCHAR2,
269 P_ATTRIBUTE12 IN VARCHAR2,
270 P_ATTRIBUTE13 IN VARCHAR2,
271 P_ATTRIBUTE14 IN VARCHAR2,
272 P_ATTRIBUTE15 IN VARCHAR2,
273 P_ATTRIBUTE16 IN VARCHAR2,
274 P_ATTRIBUTE17 IN VARCHAR2,
275 P_ATTRIBUTE18 IN VARCHAR2,
276 P_ATTRIBUTE19 IN VARCHAR2,
277 P_ATTRIBUTE20 IN VARCHAR2,
278 P_REGION_CD IN VARCHAR2,
279 P_RETURN_STATUS OUT NOCOPY VARCHAR2,
280 P_MSG_COUNT OUT NOCOPY NUMBER,
281 P_MSG_DATA OUT NOCOPY VARCHAR2
282 );
283
284 PROCEDURE UPDATE_TEST_RESULT_DETAILS (
285 P_TEST_SEGMENT_ID IN NUMBER,
286 P_TEST_RESULT_ID IN NUMBER,
287 P_TEST_SCORE IN NUMBER,
288 P_RETURN_STATUS OUT NOCOPY VARCHAR2,
289 P_MSG_COUNT OUT NOCOPY NUMBER,
290 P_MSG_DATA OUT NOCOPY VARCHAR2
291 );
292
293 PROCEDURE CREATEUPDATE_RELATIONSHIP (
294 P_MODE IN VARCHAR2,
295 P_RETURN_STATUS OUT NOCOPY VARCHAR2,
296 P_MSG_COUNT OUT NOCOPY NUMBER,
297 P_MSG_DATA OUT NOCOPY VARCHAR2,
298 P_RELATIONSHIP_ID IN OUT NOCOPY NUMBER,
299 P_DIRECTIONAL_FLAG IN VARCHAR2,
300 P_SUBJECT_ID IN NUMBER,
301 P_OBJECT_ID IN OUT NOCOPY NUMBER,
302 P_FIRST_NAME IN VARCHAR2,
303 P_LAST_NAME IN VARCHAR2,
304 P_MIDDLE_NAME IN VARCHAR2,
305 P_PREFERRED_NAME IN VARCHAR2,
306 P_BIRTHDATE IN DATE,
307 P_PRE_NAME_ADJUNCT IN VARCHAR2,
308 P_SUFFIX IN VARCHAR2,
309 P_TITLE IN VARCHAR2,
310 P_HZ_PARTIES_OVN IN OUT NOCOPY NUMBER,
311 P_HZ_REL_OVN IN OUT NOCOPY NUMBER,
312 P_JOINT_MAILING IN VARCHAR2,
313 P_NEXT_OF_KIN IN VARCHAR2,
314 P_EMERGENCY_CONTACT IN VARCHAR2,
315 P_DECEASED IN VARCHAR2,
316 P_GENDER IN VARCHAR2,
317 P_MARITAL_STATUS IN VARCHAR2,
318 P_REP_FACULTY IN VARCHAR2,
319 P_REP_STAFF IN VARCHAR2,
320 P_REP_STUDENT IN VARCHAR2,
321 P_REP_ALUMNI IN VARCHAR2,
322 P_REL_START_DATE IN DATE,
323 P_REL_END_DATE IN DATE,
324 P_REL_CODE IN VARCHAR2,
325 P_COPY_PRIMARY_ADDR IN VARCHAR2
326 );
327
328
329
330 END IGS_PE_PERSON_SS_PKG;