[Home] [Help]
PACKAGE: APPS.HZ_PERSON_INFO_V2PUB_JW
Source
1 package hz_person_info_v2pub_jw as
2 /* $Header: ARH2PIJS.pls 120.4 2005/06/18 04:29:05 jhuang noship $ */
3 procedure create_person_language_1(p_init_msg_list VARCHAR2
4 , x_language_use_reference_id out nocopy NUMBER
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p1_a0 NUMBER := null
9 , p1_a1 VARCHAR2 := null
10 , p1_a2 NUMBER := null
11 , p1_a3 VARCHAR2 := null
12 , p1_a4 VARCHAR2 := null
13 , p1_a5 VARCHAR2 := null
14 , p1_a6 VARCHAR2 := null
15 , p1_a7 VARCHAR2 := null
16 , p1_a8 VARCHAR2 := null
17 , p1_a9 VARCHAR2 := null
18 , p1_a10 VARCHAR2 := null
19 , p1_a11 NUMBER := null
20 );
21 procedure update_person_language_2(p_init_msg_list VARCHAR2
22 , p_object_version_number in out nocopy NUMBER
23 , x_return_status out nocopy VARCHAR2
24 , x_msg_count out nocopy NUMBER
25 , x_msg_data out nocopy VARCHAR2
26 , p1_a0 NUMBER := null
27 , p1_a1 VARCHAR2 := null
28 , p1_a2 NUMBER := null
29 , p1_a3 VARCHAR2 := null
30 , p1_a4 VARCHAR2 := null
31 , p1_a5 VARCHAR2 := null
32 , p1_a6 VARCHAR2 := null
33 , p1_a7 VARCHAR2 := null
34 , p1_a8 VARCHAR2 := null
35 , p1_a9 VARCHAR2 := null
36 , p1_a10 VARCHAR2 := null
37 , p1_a11 NUMBER := null
38 );
39 procedure get_person_language_rec_3(p_init_msg_list VARCHAR2
40 , p_language_use_reference_id NUMBER
41 , p2_a0 out nocopy NUMBER
42 , p2_a1 out nocopy VARCHAR2
43 , p2_a2 out nocopy NUMBER
44 , p2_a3 out nocopy VARCHAR2
45 , p2_a4 out nocopy VARCHAR2
46 , p2_a5 out nocopy VARCHAR2
47 , p2_a6 out nocopy VARCHAR2
48 , p2_a7 out nocopy VARCHAR2
49 , p2_a8 out nocopy VARCHAR2
50 , p2_a9 out nocopy VARCHAR2
51 , p2_a10 out nocopy VARCHAR2
52 , p2_a11 out nocopy NUMBER
53 , x_return_status out nocopy VARCHAR2
54 , x_msg_count out nocopy NUMBER
55 , x_msg_data out nocopy VARCHAR2
56 );
57 procedure create_citizenship_4(p_init_msg_list VARCHAR2
58 , x_citizenship_id out nocopy NUMBER
59 , x_return_status out nocopy VARCHAR2
60 , x_msg_count out nocopy NUMBER
61 , x_msg_data out nocopy VARCHAR2
62 , p1_a0 NUMBER := null
63 , p1_a1 NUMBER := null
64 , p1_a2 VARCHAR := null
65 , p1_a3 VARCHAR2 := null
66 , p1_a4 DATE := null
67 , p1_a5 DATE := null
68 , p1_a6 DATE := null
69 , p1_a7 VARCHAR2 := null
70 , p1_a8 VARCHAR2 := null
71 , p1_a9 VARCHAR2 := null
72 , p1_a10 VARCHAR2 := null
73 , p1_a11 NUMBER := null
74 );
75 procedure update_citizenship_5(p_init_msg_list VARCHAR2
76 , p_object_version_number in out nocopy NUMBER
77 , x_return_status out nocopy VARCHAR2
78 , x_msg_count out nocopy NUMBER
79 , x_msg_data out nocopy VARCHAR2
80 , p1_a0 NUMBER := null
81 , p1_a1 NUMBER := null
82 , p1_a2 VARCHAR := null
83 , p1_a3 VARCHAR2 := null
84 , p1_a4 DATE := null
85 , p1_a5 DATE := null
86 , p1_a6 DATE := null
87 , p1_a7 VARCHAR2 := null
88 , p1_a8 VARCHAR2 := null
89 , p1_a9 VARCHAR2 := null
90 , p1_a10 VARCHAR2 := null
91 , p1_a11 NUMBER := null
92 );
93 procedure get_citizenship_rec_6(p_init_msg_list VARCHAR2
94 , p_citizenship_id NUMBER
95 , p2_a0 out nocopy NUMBER
96 , p2_a1 out nocopy NUMBER
97 , p2_a2 out nocopy VARCHAR
98 , p2_a3 out nocopy VARCHAR2
99 , p2_a4 out nocopy DATE
100 , p2_a5 out nocopy DATE
101 , p2_a6 out nocopy DATE
102 , p2_a7 out nocopy VARCHAR2
103 , p2_a8 out nocopy VARCHAR2
104 , p2_a9 out nocopy VARCHAR2
105 , p2_a10 out nocopy VARCHAR2
106 , p2_a11 out nocopy NUMBER
107 , x_return_status out nocopy VARCHAR2
108 , x_msg_count out nocopy NUMBER
109 , x_msg_data out nocopy VARCHAR2
110 );
111 procedure create_education_7(p_init_msg_list VARCHAR2
112 , x_education_id out nocopy NUMBER
113 , x_return_status out nocopy VARCHAR2
114 , x_msg_count out nocopy NUMBER
115 , x_msg_data out nocopy VARCHAR2
116 , p1_a0 NUMBER := null
117 , p1_a1 NUMBER := null
118 , p1_a2 VARCHAR2 := null
119 , p1_a3 VARCHAR2 := null
120 , p1_a4 DATE := null
121 , p1_a5 DATE := null
122 , p1_a6 VARCHAR2 := null
123 , p1_a7 NUMBER := null
124 , p1_a8 VARCHAR2 := null
125 , p1_a9 VARCHAR2 := null
126 , p1_a10 VARCHAR2 := null
127 , p1_a11 NUMBER := null
128 );
129 procedure update_education_8(p_init_msg_list VARCHAR2
130 , p_object_version_number in out nocopy NUMBER
131 , x_return_status out nocopy VARCHAR2
132 , x_msg_count out nocopy NUMBER
133 , x_msg_data out nocopy VARCHAR2
134 , p1_a0 NUMBER := null
135 , p1_a1 NUMBER := null
136 , p1_a2 VARCHAR2 := null
137 , p1_a3 VARCHAR2 := null
138 , p1_a4 DATE := null
139 , p1_a5 DATE := null
140 , p1_a6 VARCHAR2 := null
141 , p1_a7 NUMBER := null
142 , p1_a8 VARCHAR2 := null
143 , p1_a9 VARCHAR2 := null
144 , p1_a10 VARCHAR2 := null
145 , p1_a11 NUMBER := null
146 );
147 procedure get_education_rec_9(p_init_msg_list VARCHAR2
148 , p_education_id NUMBER
149 , p2_a0 out nocopy NUMBER
150 , p2_a1 out nocopy NUMBER
151 , p2_a2 out nocopy VARCHAR2
152 , p2_a3 out nocopy VARCHAR2
153 , p2_a4 out nocopy DATE
154 , p2_a5 out nocopy DATE
155 , p2_a6 out nocopy VARCHAR2
156 , p2_a7 out nocopy NUMBER
157 , p2_a8 out nocopy VARCHAR2
158 , p2_a9 out nocopy VARCHAR2
159 , p2_a10 out nocopy VARCHAR2
160 , p2_a11 out nocopy NUMBER
161 , x_return_status out nocopy VARCHAR2
162 , x_msg_count out nocopy NUMBER
163 , x_msg_data out nocopy VARCHAR2
164 );
165 procedure create_employment_history_10(p_init_msg_list VARCHAR2
166 , x_employment_history_id out nocopy NUMBER
167 , x_return_status out nocopy VARCHAR2
168 , x_msg_count out nocopy NUMBER
169 , x_msg_data out nocopy VARCHAR2
170 , p1_a0 NUMBER := null
171 , p1_a1 NUMBER := null
172 , p1_a2 DATE := null
173 , p1_a3 DATE := null
174 , p1_a4 VARCHAR2 := null
175 , p1_a5 VARCHAR2 := null
176 , p1_a6 VARCHAR2 := null
177 , p1_a7 VARCHAR2 := null
178 , p1_a8 NUMBER := null
179 , p1_a9 VARCHAR2 := null
180 , p1_a10 VARCHAR2 := null
181 , p1_a11 VARCHAR2 := null
182 , p1_a12 VARCHAR2 := null
183 , p1_a13 VARCHAR2 := null
184 , p1_a14 VARCHAR2 := null
185 , p1_a15 VARCHAR2 := null
186 , p1_a16 NUMBER := null
187 , p1_a17 VARCHAR2 := null
188 , p1_a18 VARCHAR2 := null
189 , p1_a19 VARCHAR2 := null
190 , p1_a20 NUMBER := null
191 , p1_a21 VARCHAR2 := null
192 , p1_a22 VARCHAR2 := null
193 , p1_a23 VARCHAR2 := null
194 , p1_a24 NUMBER := null
195 );
196 procedure update_employment_history_11(p_init_msg_list VARCHAR2
197 , p_object_version_number in out nocopy NUMBER
198 , x_return_status out nocopy VARCHAR2
199 , x_msg_count out nocopy NUMBER
200 , x_msg_data out nocopy VARCHAR2
201 , p1_a0 NUMBER := null
202 , p1_a1 NUMBER := null
203 , p1_a2 DATE := null
204 , p1_a3 DATE := null
205 , p1_a4 VARCHAR2 := null
206 , p1_a5 VARCHAR2 := null
207 , p1_a6 VARCHAR2 := null
208 , p1_a7 VARCHAR2 := null
209 , p1_a8 NUMBER := null
210 , p1_a9 VARCHAR2 := null
211 , p1_a10 VARCHAR2 := null
212 , p1_a11 VARCHAR2 := null
213 , p1_a12 VARCHAR2 := null
214 , p1_a13 VARCHAR2 := null
215 , p1_a14 VARCHAR2 := null
216 , p1_a15 VARCHAR2 := null
217 , p1_a16 NUMBER := null
218 , p1_a17 VARCHAR2 := null
219 , p1_a18 VARCHAR2 := null
220 , p1_a19 VARCHAR2 := null
221 , p1_a20 NUMBER := null
222 , p1_a21 VARCHAR2 := null
223 , p1_a22 VARCHAR2 := null
224 , p1_a23 VARCHAR2 := null
225 , p1_a24 NUMBER := null
226 );
227 procedure get_employment_history_rec_12(p_init_msg_list VARCHAR2
228 , p_employment_history_id NUMBER
229 , p2_a0 out nocopy NUMBER
230 , p2_a1 out nocopy NUMBER
231 , p2_a2 out nocopy DATE
232 , p2_a3 out nocopy DATE
233 , p2_a4 out nocopy VARCHAR2
234 , p2_a5 out nocopy VARCHAR2
235 , p2_a6 out nocopy VARCHAR2
236 , p2_a7 out nocopy VARCHAR2
237 , p2_a8 out nocopy NUMBER
238 , p2_a9 out nocopy VARCHAR2
239 , p2_a10 out nocopy VARCHAR2
240 , p2_a11 out nocopy VARCHAR2
241 , p2_a12 out nocopy VARCHAR2
242 , p2_a13 out nocopy VARCHAR2
243 , p2_a14 out nocopy VARCHAR2
244 , p2_a15 out nocopy VARCHAR2
245 , p2_a16 out nocopy NUMBER
246 , p2_a17 out nocopy VARCHAR2
247 , p2_a18 out nocopy VARCHAR2
248 , p2_a19 out nocopy VARCHAR2
249 , p2_a20 out nocopy NUMBER
250 , p2_a21 out nocopy VARCHAR2
251 , p2_a22 out nocopy VARCHAR2
252 , p2_a23 out nocopy VARCHAR2
253 , p2_a24 out nocopy NUMBER
254 , x_return_status out nocopy VARCHAR2
255 , x_msg_count out nocopy NUMBER
256 , x_msg_data out nocopy VARCHAR2
257 );
258 procedure create_work_class_13(p_init_msg_list VARCHAR2
259 , x_work_class_id out nocopy NUMBER
260 , x_return_status out nocopy VARCHAR2
261 , x_msg_count out nocopy NUMBER
262 , x_msg_data out nocopy VARCHAR2
263 , p1_a0 NUMBER := null
264 , p1_a1 VARCHAR2 := null
265 , p1_a2 VARCHAR2 := null
266 , p1_a3 NUMBER := null
267 , p1_a4 VARCHAR2 := null
268 , p1_a5 VARCHAR2 := null
269 , p1_a6 NUMBER := null
270 );
271 procedure update_work_class_14(p_init_msg_list VARCHAR2
272 , p_object_version_number in out nocopy NUMBER
273 , x_return_status out nocopy VARCHAR2
274 , x_msg_count out nocopy NUMBER
275 , x_msg_data out nocopy VARCHAR2
276 , p1_a0 NUMBER := null
277 , p1_a1 VARCHAR2 := null
278 , p1_a2 VARCHAR2 := null
279 , p1_a3 NUMBER := null
280 , p1_a4 VARCHAR2 := null
281 , p1_a5 VARCHAR2 := null
282 , p1_a6 NUMBER := null
283 );
284 procedure get_work_class_rec_15(p_init_msg_list VARCHAR2
285 , p_work_class_id NUMBER
286 , p2_a0 out nocopy NUMBER
287 , p2_a1 out nocopy VARCHAR2
288 , p2_a2 out nocopy VARCHAR2
289 , p2_a3 out nocopy NUMBER
290 , p2_a4 out nocopy VARCHAR2
291 , p2_a5 out nocopy VARCHAR2
292 , p2_a6 out nocopy NUMBER
293 , x_return_status out nocopy VARCHAR2
294 , x_msg_count out nocopy NUMBER
295 , x_msg_data out nocopy VARCHAR2
296 );
297 procedure create_person_interest_16(p_init_msg_list VARCHAR2
298 , x_person_interest_id out nocopy NUMBER
299 , x_return_status out nocopy VARCHAR2
300 , x_msg_count out nocopy NUMBER
301 , x_msg_data out nocopy VARCHAR2
302 , p1_a0 NUMBER := null
303 , p1_a1 VARCHAR2 := null
304 , p1_a2 NUMBER := null
305 , p1_a3 VARCHAR2 := null
306 , p1_a4 VARCHAR2 := null
307 , p1_a5 VARCHAR2 := null
308 , p1_a6 VARCHAR2 := null
309 , p1_a7 VARCHAR2 := null
310 , p1_a8 VARCHAR2 := null
311 , p1_a9 VARCHAR2 := null
312 , p1_a10 DATE := null
313 , p1_a11 VARCHAR := null
314 , p1_a12 VARCHAR2 := null
315 , p1_a13 NUMBER := null
316 );
317 procedure update_person_interest_17(p_init_msg_list VARCHAR2
318 , p_object_version_number in out nocopy NUMBER
319 , x_return_status out nocopy VARCHAR2
320 , x_msg_count out nocopy NUMBER
321 , x_msg_data out nocopy VARCHAR2
322 , p1_a0 NUMBER := null
323 , p1_a1 VARCHAR2 := null
324 , p1_a2 NUMBER := null
325 , p1_a3 VARCHAR2 := null
326 , p1_a4 VARCHAR2 := null
327 , p1_a5 VARCHAR2 := null
328 , p1_a6 VARCHAR2 := null
329 , p1_a7 VARCHAR2 := null
330 , p1_a8 VARCHAR2 := null
331 , p1_a9 VARCHAR2 := null
332 , p1_a10 DATE := null
333 , p1_a11 VARCHAR := null
334 , p1_a12 VARCHAR2 := null
335 , p1_a13 NUMBER := null
336 );
337 procedure get_person_interest_rec_18(p_init_msg_list VARCHAR2
338 , p_person_interest_id NUMBER
339 , p2_a0 out nocopy NUMBER
340 , p2_a1 out nocopy VARCHAR2
341 , p2_a2 out nocopy NUMBER
342 , p2_a3 out nocopy VARCHAR2
343 , p2_a4 out nocopy VARCHAR2
344 , p2_a5 out nocopy VARCHAR2
345 , p2_a6 out nocopy VARCHAR2
346 , p2_a7 out nocopy VARCHAR2
347 , p2_a8 out nocopy VARCHAR2
348 , p2_a9 out nocopy VARCHAR2
349 , p2_a10 out nocopy DATE
350 , p2_a11 out nocopy VARCHAR
351 , p2_a12 out nocopy VARCHAR2
352 , p2_a13 out nocopy NUMBER
353 , x_return_status out nocopy VARCHAR2
354 , x_msg_count out nocopy NUMBER
355 , x_msg_data out nocopy VARCHAR2
356 );
357 end hz_person_info_v2pub_jw;