[Home] [Help]
PACKAGE BODY: APPS.PER_PERSON_ADDRESS_EVENT
Source
1 Package Body PER_PERSON_ADDRESS_EVENT as
2 /* $Header: peaddbev.pkb 120.3 2012/02/03 09:55:46 shpatro ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' PER_PERSON_ADDRESS_EVENT.';
7 --
8 -- --------------------------------------------------------------------------------------------------
9 -- |--------------------------< RAISE_CREATE_BUSINESS_EVENT >----------------------------------------|
10 -- --------------------------------------------------------------------------------------------------
11
12 procedure RAISE_CREATE_BUSINESS_EVENT
13 (
14 p_effective_date date,
15 p_pradd_ovlapval_override boolean,
16 p_validate_county boolean,
17 p_person_id number,
18 p_primary_flag varchar2,
19 p_style varchar2,
20 p_date_from date,
21 p_date_to date,
22 p_address_type varchar2,
23 p_comments CLOB, -- Bug#13375642
24 p_address_line1 varchar2,
25 p_address_line2 varchar2,
26 p_address_line3 varchar2,
27 p_town_or_city varchar2,
28 p_region_1 varchar2,
29 p_region_2 varchar2,
30 p_region_3 varchar2,
31 p_postal_code varchar2,
32 p_country varchar2,
33 p_telephone_number_1 varchar2,
34 p_telephone_number_2 varchar2,
35 p_telephone_number_3 varchar2,
36 p_addr_attribute_category varchar2,
37 p_addr_attribute1 varchar2,
38 p_addr_attribute2 varchar2,
39 p_addr_attribute3 varchar2,
40 p_addr_attribute4 varchar2,
41 p_addr_attribute5 varchar2,
42 p_addr_attribute6 varchar2,
43 p_addr_attribute7 varchar2,
44 p_addr_attribute8 varchar2,
45 p_addr_attribute9 varchar2,
46 p_addr_attribute10 varchar2,
47 p_addr_attribute11 varchar2,
48 p_addr_attribute12 varchar2,
49 p_addr_attribute13 varchar2,
50 p_addr_attribute14 varchar2,
51 p_addr_attribute15 varchar2,
52 p_addr_attribute16 varchar2,
53 p_addr_attribute17 varchar2,
54 p_addr_attribute18 varchar2,
55 p_addr_attribute19 varchar2,
56 p_addr_attribute20 varchar2,
57 p_add_information13 varchar2,
58 p_add_information14 varchar2,
59 p_add_information15 varchar2,
60 p_add_information16 varchar2,
61 p_add_information17 varchar2,
62 p_add_information18 varchar2,
63 p_add_information19 varchar2,
64 p_add_information20 varchar2,
65 p_address_id number,
66 p_object_version_number number,
67 p_party_id number
68 )
69 is
70 begin
71 HR_PERSON_ADDRESS_BE1.create_person_address_a(
72 p_effective_date => p_effective_date
73 ,p_pradd_ovlapval_override => p_pradd_ovlapval_override
74 ,p_validate_county => p_validate_county
75 ,p_person_id => p_person_id
76 ,p_primary_flag => p_primary_flag
77 ,p_style => p_style
78 ,p_date_from => p_date_from
79 ,p_date_to => p_date_to
80 ,p_address_type => p_address_type
81 ,p_comments => p_comments
82 ,p_address_line1 => p_address_line1
83 ,p_address_line2 => p_address_line2
84 ,p_address_line3 => p_address_line3
85 ,p_town_or_city => p_town_or_city
86 ,p_region_1 => p_region_1
87 ,p_region_2 => p_region_2
88 ,p_region_3 => p_region_3
89 ,p_postal_code => p_postal_code
90 ,p_country => p_country
91 ,p_telephone_number_1 => p_telephone_number_1
92 ,p_telephone_number_2 => p_telephone_number_2
93 ,p_telephone_number_3 => p_telephone_number_3
94 ,p_addr_attribute_category => p_addr_attribute_category
95 ,p_addr_attribute1 => p_addr_attribute1
96 ,p_addr_attribute2 => p_addr_attribute2
97 ,p_addr_attribute3 => p_addr_attribute3
98 ,p_addr_attribute4 => p_addr_attribute4
99 ,p_addr_attribute5 => p_addr_attribute5
100 ,p_addr_attribute6 => p_addr_attribute6
101 ,p_addr_attribute7 => p_addr_attribute7
102 ,p_addr_attribute8 => p_addr_attribute8
103 ,p_addr_attribute9 => p_addr_attribute9
104 ,p_addr_attribute10 => p_addr_attribute10
105 ,p_addr_attribute11 => p_addr_attribute11
106 ,p_addr_attribute12 => p_addr_attribute12
107 ,p_addr_attribute13 => p_addr_attribute13
108 ,p_addr_attribute14 => p_addr_attribute14
109 ,p_addr_attribute15 => p_addr_attribute15
110 ,p_addr_attribute16 => p_addr_attribute16
111 ,p_addr_attribute17 => p_addr_attribute17
112 ,p_addr_attribute18 => p_addr_attribute18
113 ,p_addr_attribute19 => p_addr_attribute19
114 ,p_addr_attribute20 => p_addr_attribute20
115 ,p_add_information13 => p_add_information13
116 ,p_add_information14 => p_add_information14
117 ,p_add_information15 => p_add_information15
118 ,p_add_information16 => p_add_information16
119 ,p_add_information17 => p_add_information17
120 ,p_add_information18 => p_add_information18
121 ,p_add_information19 => p_add_information19
122 ,p_add_information20 => p_add_information20
123 ,p_address_id => p_address_id
124 ,p_object_version_number => p_object_version_number
125 ,p_party_id => p_party_id
126 );
127 end RAISE_CREATE_BUSINESS_EVENT;
128
129 -- --------------------------------------------------------------------------------------------------
130 -- |--------------------------< RAISE_UPDATE_BUSINESS_EVENT >---------------------------------------|
131 -- --------------------------------------------------------------------------------------------------
132
133 procedure RAISE_UPDATE_BUSINESS_EVENT
134 (p_effective_date date,
135 p_validate_county boolean,
136 p_address_id number,
137 p_object_version_number number,
138 p_date_from date,
139 p_date_to date,
140 p_address_type varchar2,
141 p_comments CLOB, -- Bug#13375642
142 p_address_line1 varchar2,
143 p_address_line2 varchar2,
144 p_address_line3 varchar2,
145 p_town_or_city varchar2,
146 p_region_1 varchar2,
147 p_region_2 varchar2,
148 p_region_3 varchar2,
149 p_postal_code varchar2,
150 p_country varchar2,
151 p_telephone_number_1 varchar2,
152 p_telephone_number_2 varchar2,
153 p_telephone_number_3 varchar2,
154 p_addr_attribute_category varchar2,
155 p_addr_attribute1 varchar2,
156 p_addr_attribute2 varchar2,
157 p_addr_attribute3 varchar2,
158 p_addr_attribute4 varchar2,
159 p_addr_attribute5 varchar2,
160 p_addr_attribute6 varchar2,
161 p_addr_attribute7 varchar2,
162 p_addr_attribute8 varchar2,
163 p_addr_attribute9 varchar2,
164 p_addr_attribute10 varchar2,
165 p_addr_attribute11 varchar2,
166 p_addr_attribute12 varchar2,
167 p_addr_attribute13 varchar2,
168 p_addr_attribute14 varchar2,
169 p_addr_attribute15 varchar2,
170 p_addr_attribute16 varchar2,
171 p_addr_attribute17 varchar2,
172 p_addr_attribute18 varchar2,
173 p_addr_attribute19 varchar2,
174 p_addr_attribute20 varchar2,
175 p_add_information13 varchar2,
176 p_add_information14 varchar2,
177 p_add_information15 varchar2,
178 p_add_information16 varchar2,
179 p_add_information17 varchar2,
180 p_add_information18 varchar2,
181 p_add_information19 varchar2,
182 p_add_information20 varchar2
183 )
184 is
185 begin
186 HR_PERSON_ADDRESS_BE2.update_person_address_a(
187 p_effective_date => p_effective_date
188 ,p_validate_county => p_validate_county
189 ,p_object_version_number => p_object_version_number
190 ,p_address_id => p_address_id
191 ,p_date_from => p_date_from
192 ,p_date_to => p_date_to
193 ,p_address_type => p_address_type
194 ,p_comments => p_comments
195 ,p_address_line1 => p_address_line1
196 ,p_address_line2 => p_address_line2
197 ,p_address_line3 => p_address_line3
198 ,p_town_or_city => p_town_or_city
199 ,p_region_1 => p_region_1
200 ,p_region_2 => p_region_2
201 ,p_region_3 => p_region_3
202 ,p_postal_code => p_postal_code
203 ,p_country => p_country
204 ,p_telephone_number_1 => p_telephone_number_1
205 ,p_telephone_number_2 => p_telephone_number_2
206 ,p_telephone_number_3 => p_telephone_number_3
207 ,p_addr_attribute_category => p_addr_attribute_category
208 ,p_addr_attribute1 => p_addr_attribute1
209 ,p_addr_attribute2 => p_addr_attribute2
210 ,p_addr_attribute3 => p_addr_attribute3
211 ,p_addr_attribute4 => p_addr_attribute4
212 ,p_addr_attribute5 => p_addr_attribute5
213 ,p_addr_attribute6 => p_addr_attribute6
214 ,p_addr_attribute7 => p_addr_attribute7
215 ,p_addr_attribute8 => p_addr_attribute8
216 ,p_addr_attribute9 => p_addr_attribute9
217 ,p_addr_attribute10 => p_addr_attribute10
218 ,p_addr_attribute11 => p_addr_attribute11
219 ,p_addr_attribute12 => p_addr_attribute12
220 ,p_addr_attribute13 => p_addr_attribute13
221 ,p_addr_attribute14 => p_addr_attribute14
222 ,p_addr_attribute15 => p_addr_attribute15
223 ,p_addr_attribute16 => p_addr_attribute16
224 ,p_addr_attribute17 => p_addr_attribute17
225 ,p_addr_attribute18 => p_addr_attribute18
226 ,p_addr_attribute19 => p_addr_attribute19
227 ,p_addr_attribute20 => p_addr_attribute20
228 ,p_add_information13 => p_add_information13
229 ,p_add_information14 => p_add_information14
230 ,p_add_information15 => p_add_information15
231 ,p_add_information16 => p_add_information16
232 ,p_add_information17 => p_add_information17
233 ,p_add_information18 => p_add_information18
234 ,p_add_information19 => p_add_information19
235 ,p_add_information20 => p_add_information20
236 );
237 end RAISE_UPDATE_BUSINESS_EVENT;
238
239 end PER_PERSON_ADDRESS_EVENT;