DBA Data[Home] [Help]

PACKAGE: APPS.HR_CONTACT_REL_BK1

Source


1 Package hr_contact_rel_bk1 as
2 /* $Header: pecrlapi.pkh 120.1 2005/10/02 02:14:06 aroussel $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< create_contact_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure create_contact_b
9   (p_start_date                   in        date
10   ,p_business_group_id            in        number
11   ,p_person_id                    in        number
12   ,p_contact_person_id            in        number
13   ,p_contact_type                 in        varchar2
14   ,p_ctr_comments                 in        varchar2
15   ,p_primary_contact_flag         in        varchar2
16   ,p_date_start                   in        date
17   ,p_start_life_reason_id         in        number
18   ,p_date_end                     in        date
19   ,p_end_life_reason_id           in        number
20   ,p_rltd_per_rsds_w_dsgntr_flag  in        varchar2
21   ,p_personal_flag                in        varchar2
22   ,p_sequence_number              in        number
23   ,p_cont_attribute_category      in        varchar2
24   ,p_cont_attribute1              in        varchar2
25   ,p_cont_attribute2              in        varchar2
26   ,p_cont_attribute3              in        varchar2
27   ,p_cont_attribute4              in        varchar2
28   ,p_cont_attribute5              in        varchar2
29   ,p_cont_attribute6              in        varchar2
30   ,p_cont_attribute7              in        varchar2
31   ,p_cont_attribute8              in        varchar2
32   ,p_cont_attribute9              in        varchar2
33   ,p_cont_attribute10             in        varchar2
34   ,p_cont_attribute11             in        varchar2
35   ,p_cont_attribute12             in        varchar2
36   ,p_cont_attribute13             in        varchar2
37   ,p_cont_attribute14             in        varchar2
38   ,p_cont_attribute15             in        varchar2
39   ,p_cont_attribute16             in        varchar2
40   ,p_cont_attribute17             in        varchar2
41   ,p_cont_attribute18             in        varchar2
42   ,p_cont_attribute19             in        varchar2
43   ,p_cont_attribute20             in        varchar2
44   ,p_cont_information_category      in        varchar2
45   ,p_cont_information1              in        varchar2
46   ,p_cont_information2              in        varchar2
47   ,p_cont_information3              in        varchar2
48   ,p_cont_information4              in        varchar2
49   ,p_cont_information5              in        varchar2
50   ,p_cont_information6              in        varchar2
51   ,p_cont_information7              in        varchar2
52   ,p_cont_information8              in        varchar2
53   ,p_cont_information9              in        varchar2
54   ,p_cont_information10             in        varchar2
55   ,p_cont_information11             in        varchar2
56   ,p_cont_information12             in        varchar2
57   ,p_cont_information13             in        varchar2
58   ,p_cont_information14             in        varchar2
59   ,p_cont_information15             in        varchar2
60   ,p_cont_information16             in        varchar2
61   ,p_cont_information17             in        varchar2
62   ,p_cont_information18             in        varchar2
63   ,p_cont_information19             in        varchar2
64   ,p_cont_information20             in        varchar2
65   ,p_third_party_pay_flag         in        varchar2
66   ,p_bondholder_flag              in        varchar2
67   ,p_dependent_flag               in        varchar2
68   ,p_beneficiary_flag             in        varchar2
69   ,p_last_name                    in        varchar2
70   ,p_sex                          in        varchar2
71   ,p_person_type_id               in        number
72   ,p_per_comments                 in        varchar2
73   ,p_date_of_birth                in        date
74   ,p_email_address                in        varchar2
75   ,p_first_name                   in        varchar2
76   ,p_known_as                     in        varchar2
77   ,p_marital_status               in        varchar2
78   ,p_middle_names                 in        varchar2
79   ,p_nationality                  in        varchar2
80   ,p_national_identifier          in        varchar2
81   ,p_previous_last_name           in        varchar2
82   ,p_registered_disabled_flag     in        varchar2
83   ,p_title                        in        varchar2
84   ,p_work_telephone               in        varchar2
85   ,p_attribute_category           in        varchar2
86   ,p_attribute1                   in        varchar2
87   ,p_attribute2                   in        varchar2
88   ,p_attribute3                   in        varchar2
89   ,p_attribute4                   in        varchar2
90   ,p_attribute5                   in        varchar2
91   ,p_attribute6                   in        varchar2
92   ,p_attribute7                   in        varchar2
93   ,p_attribute8                   in        varchar2
94   ,p_attribute9                   in        varchar2
95   ,p_attribute10                  in        varchar2
96   ,p_attribute11                  in        varchar2
97   ,p_attribute12                  in        varchar2
98   ,p_attribute13                  in        varchar2
99   ,p_attribute14                  in        varchar2
100   ,p_attribute15                  in        varchar2
101   ,p_attribute16                  in        varchar2
102   ,p_attribute17                  in        varchar2
103   ,p_attribute18                  in        varchar2
104   ,p_attribute19                  in        varchar2
105   ,p_attribute20                  in        varchar2
106   ,p_attribute21                  in        varchar2
107   ,p_attribute22                  in        varchar2
108   ,p_attribute23                  in        varchar2
109   ,p_attribute24                  in        varchar2
110   ,p_attribute25                  in        varchar2
111   ,p_attribute26                  in        varchar2
112   ,p_attribute27                  in        varchar2
113   ,p_attribute28                  in        varchar2
114   ,p_attribute29                  in        varchar2
115   ,p_attribute30                  in        varchar2
116   ,p_per_information_category     in        varchar2
117   ,p_per_information1             in        varchar2
118   ,p_per_information2             in        varchar2
119   ,p_per_information3             in        varchar2
120   ,p_per_information4             in        varchar2
121   ,p_per_information5             in        varchar2
122   ,p_per_information6             in        varchar2
123   ,p_per_information7             in        varchar2
124   ,p_per_information8             in        varchar2
125   ,p_per_information9             in        varchar2
126   ,p_per_information10            in        varchar2
127   ,p_per_information11            in        varchar2
128   ,p_per_information12            in        varchar2
129   ,p_per_information13            in        varchar2
130   ,p_per_information14            in        varchar2
131   ,p_per_information15            in        varchar2
132   ,p_per_information16            in        varchar2
133   ,p_per_information17            in        varchar2
134   ,p_per_information18            in        varchar2
135   ,p_per_information19            in        varchar2
136   ,p_per_information20            in        varchar2
137   ,p_per_information21            in        varchar2
138   ,p_per_information22            in        varchar2
139   ,p_per_information23            in        varchar2
140   ,p_per_information24            in        varchar2
141   ,p_per_information25            in        varchar2
142   ,p_per_information26            in        varchar2
143   ,p_per_information27            in        varchar2
144   ,p_per_information28            in        varchar2
145   ,p_per_information29            in        varchar2
146   ,p_per_information30            in        varchar2
147   ,p_correspondence_language      in        varchar2
148   ,p_honors                       in        varchar2
149   ,p_pre_name_adjunct             in        varchar2
150   ,p_suffix                       in        varchar2
151   ,p_create_mirror_flag           in        varchar2
152   ,p_mirror_type                  in        varchar2
153   ,p_mirror_cont_attribute_cat    in        varchar2
154   ,p_mirror_cont_attribute1       in        varchar2
155   ,p_mirror_cont_attribute2       in        varchar2
156   ,p_mirror_cont_attribute3       in        varchar2
157   ,p_mirror_cont_attribute4       in        varchar2
158   ,p_mirror_cont_attribute5       in        varchar2
159   ,p_mirror_cont_attribute6       in        varchar2
160   ,p_mirror_cont_attribute7       in        varchar2
161   ,p_mirror_cont_attribute8       in        varchar2
162   ,p_mirror_cont_attribute9       in        varchar2
163   ,p_mirror_cont_attribute10      in        varchar2
164   ,p_mirror_cont_attribute11      in        varchar2
165   ,p_mirror_cont_attribute12      in        varchar2
166   ,p_mirror_cont_attribute13      in        varchar2
167   ,p_mirror_cont_attribute14      in        varchar2
168   ,p_mirror_cont_attribute15      in        varchar2
169   ,p_mirror_cont_attribute16      in        varchar2
170   ,p_mirror_cont_attribute17      in        varchar2
171   ,p_mirror_cont_attribute18      in        varchar2
172   ,p_mirror_cont_attribute19      in        varchar2
173   ,p_mirror_cont_attribute20      in        varchar2
174   ,p_mirror_cont_information_cat    in        varchar2
175   ,p_mirror_cont_information1       in        varchar2
176   ,p_mirror_cont_information2       in        varchar2
177   ,p_mirror_cont_information3       in        varchar2
178   ,p_mirror_cont_information4       in        varchar2
179   ,p_mirror_cont_information5       in        varchar2
180   ,p_mirror_cont_information6       in        varchar2
181   ,p_mirror_cont_information7       in        varchar2
182   ,p_mirror_cont_information8       in        varchar2
183   ,p_mirror_cont_information9       in        varchar2
184   ,p_mirror_cont_information10      in        varchar2
185   ,p_mirror_cont_information11      in        varchar2
186   ,p_mirror_cont_information12      in        varchar2
187   ,p_mirror_cont_information13      in        varchar2
188   ,p_mirror_cont_information14      in        varchar2
189   ,p_mirror_cont_information15      in        varchar2
190   ,p_mirror_cont_information16      in        varchar2
191   ,p_mirror_cont_information17      in        varchar2
192   ,p_mirror_cont_information18      in        varchar2
193   ,p_mirror_cont_information19      in        varchar2
194   ,p_mirror_cont_information20      in        varchar2
195   );
196 --
197 -- -----------------------------------------------------------------
198 -- |---------------------------< create_contact_a >-----------------|
199 -- -----------------------------------------------------------------
200 --
201 procedure create_contact_a
202   (p_start_date                   in        date
203   ,p_business_group_id            in        number
204   ,p_person_id                    in        number
205   ,p_contact_person_id            in        number
206   ,p_contact_type                 in        varchar2
207   ,p_ctr_comments                 in        varchar2
208   ,p_primary_contact_flag         in        varchar2
209   ,p_date_start                   in        date
210   ,p_start_life_reason_id         in        number
211   ,p_date_end                     in        date
212   ,p_end_life_reason_id           in        number
213   ,p_rltd_per_rsds_w_dsgntr_flag  in        varchar2
214   ,p_personal_flag                in        varchar2
215   ,p_sequence_number              in        number
216   ,p_cont_attribute_category      in        varchar2
217   ,p_cont_attribute1              in        varchar2
218   ,p_cont_attribute2              in        varchar2
219   ,p_cont_attribute3              in        varchar2
220   ,p_cont_attribute4              in        varchar2
221   ,p_cont_attribute5              in        varchar2
222   ,p_cont_attribute6              in        varchar2
223   ,p_cont_attribute7              in        varchar2
224   ,p_cont_attribute8              in        varchar2
225   ,p_cont_attribute9              in        varchar2
226   ,p_cont_attribute10             in        varchar2
227   ,p_cont_attribute11             in        varchar2
228   ,p_cont_attribute12             in        varchar2
229   ,p_cont_attribute13             in        varchar2
230   ,p_cont_attribute14             in        varchar2
231   ,p_cont_attribute15             in        varchar2
232   ,p_cont_attribute16             in        varchar2
233   ,p_cont_attribute17             in        varchar2
234   ,p_cont_attribute18             in        varchar2
235   ,p_cont_attribute19             in        varchar2
236   ,p_cont_attribute20             in        varchar2
237   ,p_cont_information_category      in        varchar2
238   ,p_cont_information1              in        varchar2
239   ,p_cont_information2              in        varchar2
240   ,p_cont_information3              in        varchar2
241   ,p_cont_information4              in        varchar2
242   ,p_cont_information5              in        varchar2
243   ,p_cont_information6              in        varchar2
244   ,p_cont_information7              in        varchar2
245   ,p_cont_information8              in        varchar2
246   ,p_cont_information9              in        varchar2
247   ,p_cont_information10             in        varchar2
248   ,p_cont_information11             in        varchar2
249   ,p_cont_information12             in        varchar2
250   ,p_cont_information13             in        varchar2
251   ,p_cont_information14             in        varchar2
252   ,p_cont_information15             in        varchar2
253   ,p_cont_information16             in        varchar2
254   ,p_cont_information17             in        varchar2
255   ,p_cont_information18             in        varchar2
256   ,p_cont_information19             in        varchar2
257   ,p_cont_information20             in        varchar2
258   ,p_third_party_pay_flag         in        varchar2
259   ,p_bondholder_flag              in        varchar2
260   ,p_dependent_flag               in        varchar2
261   ,p_beneficiary_flag             in        varchar2
262   ,p_last_name                    in        varchar2
263   ,p_sex                          in        varchar2
264   ,p_person_type_id               in        number
265   ,p_per_comments                 in        varchar2
266   ,p_date_of_birth                in        date
267   ,p_email_address                in        varchar2
268   ,p_first_name                   in        varchar2
269   ,p_known_as                     in        varchar2
270   ,p_marital_status               in        varchar2
271   ,p_middle_names                 in        varchar2
272   ,p_nationality                  in        varchar2
273   ,p_national_identifier          in        varchar2
274   ,p_previous_last_name           in        varchar2
275   ,p_registered_disabled_flag     in        varchar2
276   ,p_title                        in        varchar2
277   ,p_work_telephone               in        varchar2
278   ,p_attribute_category           in        varchar2
279   ,p_attribute1                   in        varchar2
280   ,p_attribute2                   in        varchar2
281   ,p_attribute3                   in        varchar2
282   ,p_attribute4                   in        varchar2
283   ,p_attribute5                   in        varchar2
284   ,p_attribute6                   in        varchar2
285   ,p_attribute7                   in        varchar2
286   ,p_attribute8                   in        varchar2
287   ,p_attribute9                   in        varchar2
288   ,p_attribute10                  in        varchar2
289   ,p_attribute11                  in        varchar2
290   ,p_attribute12                  in        varchar2
291   ,p_attribute13                  in        varchar2
292   ,p_attribute14                  in        varchar2
293   ,p_attribute15                  in        varchar2
294   ,p_attribute16                  in        varchar2
295   ,p_attribute17                  in        varchar2
296   ,p_attribute18                  in        varchar2
297   ,p_attribute19                  in        varchar2
298   ,p_attribute20                  in        varchar2
299   ,p_attribute21                  in        varchar2
300   ,p_attribute22                  in        varchar2
301   ,p_attribute23                  in        varchar2
302   ,p_attribute24                  in        varchar2
303   ,p_attribute25                  in        varchar2
304   ,p_attribute26                  in        varchar2
305   ,p_attribute27                  in        varchar2
309   ,p_per_information_category     in        varchar2
306   ,p_attribute28                  in        varchar2
307   ,p_attribute29                  in        varchar2
308   ,p_attribute30                  in        varchar2
310   ,p_per_information1             in        varchar2
311   ,p_per_information2             in        varchar2
312   ,p_per_information3             in        varchar2
313   ,p_per_information4             in        varchar2
314   ,p_per_information5             in        varchar2
315   ,p_per_information6             in        varchar2
316   ,p_per_information7             in        varchar2
317   ,p_per_information8             in        varchar2
318   ,p_per_information9             in        varchar2
319   ,p_per_information10            in        varchar2
320   ,p_per_information11            in        varchar2
321   ,p_per_information12            in        varchar2
322   ,p_per_information13            in        varchar2
323   ,p_per_information14            in        varchar2
324   ,p_per_information15            in        varchar2
325   ,p_per_information16            in        varchar2
326   ,p_per_information17            in        varchar2
327   ,p_per_information18            in        varchar2
328   ,p_per_information19            in        varchar2
329   ,p_per_information20            in        varchar2
330   ,p_per_information21            in        varchar2
331   ,p_per_information22            in        varchar2
332   ,p_per_information23            in        varchar2
333   ,p_per_information24            in        varchar2
334   ,p_per_information25            in        varchar2
335   ,p_per_information26            in        varchar2
336   ,p_per_information27            in        varchar2
337   ,p_per_information28            in        varchar2
338   ,p_per_information29            in        varchar2
339   ,p_per_information30            in        varchar2
340   ,p_correspondence_language      in        varchar2
341   ,p_honors                       in        varchar2
342   ,p_pre_name_adjunct             in        varchar2
343   ,p_suffix                       in        varchar2
344   ,p_create_mirror_flag           in        varchar2
345   ,p_mirror_type                  in        varchar2
346   ,p_mirror_cont_attribute_cat    in        varchar2
347   ,p_mirror_cont_attribute1       in        varchar2
348   ,p_mirror_cont_attribute2       in        varchar2
349   ,p_mirror_cont_attribute3       in        varchar2
350   ,p_mirror_cont_attribute4       in        varchar2
351   ,p_mirror_cont_attribute5       in        varchar2
352   ,p_mirror_cont_attribute6       in        varchar2
353   ,p_mirror_cont_attribute7       in        varchar2
354   ,p_mirror_cont_attribute8       in        varchar2
355   ,p_mirror_cont_attribute9       in        varchar2
356   ,p_mirror_cont_attribute10      in        varchar2
357   ,p_mirror_cont_attribute11      in        varchar2
358   ,p_mirror_cont_attribute12      in        varchar2
359   ,p_mirror_cont_attribute13      in        varchar2
360   ,p_mirror_cont_attribute14      in        varchar2
361   ,p_mirror_cont_attribute15      in        varchar2
362   ,p_mirror_cont_attribute16      in        varchar2
363   ,p_mirror_cont_attribute17      in        varchar2
364   ,p_mirror_cont_attribute18      in        varchar2
365   ,p_mirror_cont_attribute19      in        varchar2
366   ,p_mirror_cont_attribute20      in        varchar2
367   ,p_mirror_cont_information_cat    in        varchar2
368   ,p_mirror_cont_information1       in        varchar2
369   ,p_mirror_cont_information2       in        varchar2
370   ,p_mirror_cont_information3       in        varchar2
371   ,p_mirror_cont_information4       in        varchar2
372   ,p_mirror_cont_information5       in        varchar2
373   ,p_mirror_cont_information6       in        varchar2
374   ,p_mirror_cont_information7       in        varchar2
375   ,p_mirror_cont_information8       in        varchar2
376   ,p_mirror_cont_information9       in        varchar2
377   ,p_mirror_cont_information10      in        varchar2
378   ,p_mirror_cont_information11      in        varchar2
379   ,p_mirror_cont_information12      in        varchar2
380   ,p_mirror_cont_information13      in        varchar2
381   ,p_mirror_cont_information14      in        varchar2
382   ,p_mirror_cont_information15      in        varchar2
383   ,p_mirror_cont_information16      in        varchar2
384   ,p_mirror_cont_information17      in        varchar2
385   ,p_mirror_cont_information18      in        varchar2
386   ,p_mirror_cont_information19      in        varchar2
387   ,p_mirror_cont_information20      in        varchar2
388   ,p_contact_relationship_id      in        number
389   ,p_ctr_object_version_number    in        number
390   ,p_per_person_id                in        number
391   ,p_per_object_version_number    in        number
392   ,p_per_effective_start_date     in        date
393   ,p_per_effective_end_date       in        date
394   ,p_full_name                    in        varchar2
395   ,p_per_comment_id               in        number
396   ,p_name_combination_warning     in        boolean
397   ,p_orig_hire_warning            in        boolean
398   );
399 --
400 end hr_contact_rel_bk1;