DBA Data[Home] [Help]

PACKAGE: APPS.HZ_PERSON_INFO_V2PUB_JW

Source


1 package hz_person_info_v2pub_jw AUTHID CURRENT_USER 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;