[Home] [Help]
PACKAGE: APPS.HR_CONTACT_EXTRA_INFO_SWI
Source
1 package hr_contact_extra_info_swi AUTHID CURRENT_USER as
2 /* $Header: pereiswi.pkh 120.0.12000000.1 2007/02/08 10:26:23 ssutar noship $ */
3
4 procedure create_contact_extra_info(
5 p_validate in number,
6 p_contact_extra_info_id in number,
7 p_effective_date in date,
8 p_contact_relationship_id in number,
9 p_information_type in varchar2,
10 p_cei_information_category in varchar2 default null,
11 p_cei_information1 in varchar2 default null,
12 p_cei_information2 in varchar2 default null,
13 p_cei_information3 in varchar2 default null,
14 p_cei_information4 in varchar2 default null,
15 p_cei_information5 in varchar2 default null,
16 p_cei_information6 in varchar2 default null,
17 p_cei_information7 in varchar2 default null,
18 p_cei_information8 in varchar2 default null,
19 p_cei_information9 in varchar2 default null,
20 p_cei_information10 in varchar2 default null,
21 p_cei_information11 in varchar2 default null,
22 p_cei_information12 in varchar2 default null,
23 p_cei_information13 in varchar2 default null,
24 p_cei_information14 in varchar2 default null,
25 p_cei_information15 in varchar2 default null,
26 p_cei_information16 in varchar2 default null,
27 p_cei_information17 in varchar2 default null,
28 p_cei_information18 in varchar2 default null,
29 p_cei_information19 in varchar2 default null,
30 p_cei_information20 in varchar2 default null,
31 p_cei_information21 in varchar2 default null,
32 p_cei_information22 in varchar2 default null,
33 p_cei_information23 in varchar2 default null,
34 p_cei_information24 in varchar2 default null,
35 p_cei_information25 in varchar2 default null,
36 p_cei_information26 in varchar2 default null,
37 p_cei_information27 in varchar2 default null,
38 p_cei_information28 in varchar2 default null,
39 p_cei_information29 in varchar2 default null,
40 p_cei_information30 in varchar2 default null,
41 p_cei_attribute_category in varchar2 default null,
42 p_cei_attribute1 in varchar2 default null,
43 p_cei_attribute2 in varchar2 default null,
44 p_cei_attribute3 in varchar2 default null,
45 p_cei_attribute4 in varchar2 default null,
46 p_cei_attribute5 in varchar2 default null,
47 p_cei_attribute6 in varchar2 default null,
48 p_cei_attribute7 in varchar2 default null,
49 p_cei_attribute8 in varchar2 default null,
50 p_cei_attribute9 in varchar2 default null,
51 p_cei_attribute10 in varchar2 default null,
52 p_cei_attribute11 in varchar2 default null,
53 p_cei_attribute12 in varchar2 default null,
54 p_cei_attribute13 in varchar2 default null,
55 p_cei_attribute14 in varchar2 default null,
56 p_cei_attribute15 in varchar2 default null,
57 p_cei_attribute16 in varchar2 default null,
58 p_cei_attribute17 in varchar2 default null,
59 p_cei_attribute18 in varchar2 default null,
60 p_cei_attribute19 in varchar2 default null,
61 p_cei_attribute20 in varchar2 default null,
62 p_object_version_number out nocopy number,
63 p_effective_start_date out nocopy date,
64 p_effective_end_date out nocopy date,
65 p_return_status out nocopy varchar2
66 );
67
68 ----------------------------------------------------------------------------
69 procedure update_contact_extra_info(
70 p_validate in number,
71 p_effective_date in date,
72 p_datetrack_update_mode in varchar2,
73 p_contact_extra_info_id in number,
74 p_contact_relationship_id in number default hr_api.g_number,
75 p_information_type in varchar2 default hr_api.g_varchar2,
76 p_object_version_number in out nocopy number,
77 p_cei_information_category in varchar2 default hr_api.g_varchar2,
78 p_cei_information1 in varchar2 default hr_api.g_varchar2,
79 p_cei_information2 in varchar2 default hr_api.g_varchar2,
80 p_cei_information3 in varchar2 default hr_api.g_varchar2,
81 p_cei_information4 in varchar2 default hr_api.g_varchar2,
82 p_cei_information5 in varchar2 default hr_api.g_varchar2,
83 p_cei_information6 in varchar2 default hr_api.g_varchar2,
84 p_cei_information7 in varchar2 default hr_api.g_varchar2,
85 p_cei_information8 in varchar2 default hr_api.g_varchar2,
86 p_cei_information9 in varchar2 default hr_api.g_varchar2,
87 p_cei_information10 in varchar2 default hr_api.g_varchar2,
88 p_cei_information11 in varchar2 default hr_api.g_varchar2,
89 p_cei_information12 in varchar2 default hr_api.g_varchar2,
90 p_cei_information13 in varchar2 default hr_api.g_varchar2,
91 p_cei_information14 in varchar2 default hr_api.g_varchar2,
92 p_cei_information15 in varchar2 default hr_api.g_varchar2,
93 p_cei_information16 in varchar2 default hr_api.g_varchar2,
94 p_cei_information17 in varchar2 default hr_api.g_varchar2,
95 p_cei_information18 in varchar2 default hr_api.g_varchar2,
96 p_cei_information19 in varchar2 default hr_api.g_varchar2,
97 p_cei_information20 in varchar2 default hr_api.g_varchar2,
98 p_cei_information21 in varchar2 default hr_api.g_varchar2,
99 p_cei_information22 in varchar2 default hr_api.g_varchar2,
100 p_cei_information23 in varchar2 default hr_api.g_varchar2,
101 p_cei_information24 in varchar2 default hr_api.g_varchar2,
102 p_cei_information25 in varchar2 default hr_api.g_varchar2,
103 p_cei_information26 in varchar2 default hr_api.g_varchar2,
104 p_cei_information27 in varchar2 default hr_api.g_varchar2,
105 p_cei_information28 in varchar2 default hr_api.g_varchar2,
106 p_cei_information29 in varchar2 default hr_api.g_varchar2,
107 p_cei_information30 in varchar2 default hr_api.g_varchar2,
108 p_cei_attribute_category in varchar2 default hr_api.g_varchar2,
109 p_cei_attribute1 in varchar2 default hr_api.g_varchar2,
110 p_cei_attribute2 in varchar2 default hr_api.g_varchar2,
111 p_cei_attribute3 in varchar2 default hr_api.g_varchar2,
112 p_cei_attribute4 in varchar2 default hr_api.g_varchar2,
113 p_cei_attribute5 in varchar2 default hr_api.g_varchar2,
114 p_cei_attribute6 in varchar2 default hr_api.g_varchar2,
115 p_cei_attribute7 in varchar2 default hr_api.g_varchar2,
116 p_cei_attribute8 in varchar2 default hr_api.g_varchar2,
117 p_cei_attribute9 in varchar2 default hr_api.g_varchar2,
118 p_cei_attribute10 in varchar2 default hr_api.g_varchar2,
119 p_cei_attribute11 in varchar2 default hr_api.g_varchar2,
120 p_cei_attribute12 in varchar2 default hr_api.g_varchar2,
121 p_cei_attribute13 in varchar2 default hr_api.g_varchar2,
122 p_cei_attribute14 in varchar2 default hr_api.g_varchar2,
123 p_cei_attribute15 in varchar2 default hr_api.g_varchar2,
124 p_cei_attribute16 in varchar2 default hr_api.g_varchar2,
125 p_cei_attribute17 in varchar2 default hr_api.g_varchar2,
126 p_cei_attribute18 in varchar2 default hr_api.g_varchar2,
127 p_cei_attribute19 in varchar2 default hr_api.g_varchar2,
128 p_cei_attribute20 in varchar2 default hr_api.g_varchar2,
129 p_effective_start_date out nocopy date,
130 p_effective_end_date out nocopy date,
131 p_return_status out nocopy varchar2
132 );
133 ----------------------------------------------------------------------------
134 procedure delete_contact_extra_info(
135 p_validate in number,
136 p_effective_date in date,
137 p_datetrack_delete_mode in varchar2,
138 p_contact_extra_info_id in number,
139 p_object_version_number in out nocopy number,
140 p_effective_start_date out nocopy date,
141 p_effective_end_date out nocopy date,
142 p_return_status out nocopy varchar2
143 );
144
145 end hr_contact_extra_info_swi;