eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HR_PERSON_ADDRESS_BK3

Source


1 package body HR_PERSON_ADDRESS_BK3 as
2 /* $Header: peaddapi.pkb 120.5.12020000.2 2013/02/14 14:11:48 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2013/08/13 18:46:34 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_PERS_ADDR_WITH_STYLE_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_VALIDATE_COUNTY in BOOLEAN
8 ,P_ADDRESS_ID in NUMBER
9 ,P_OBJECT_VERSION_NUMBER in NUMBER
10 ,P_DATE_FROM in DATE
11 ,P_DATE_TO in DATE
12 ,P_ADDRESS_TYPE in VARCHAR2
13 ,P_COMMENTS in CLOB
14 ,P_ADDRESS_LINE1 in VARCHAR2
15 ,P_ADDRESS_LINE2 in VARCHAR2
16 ,P_ADDRESS_LINE3 in VARCHAR2
17 ,P_TOWN_OR_CITY in VARCHAR2
18 ,P_REGION_1 in VARCHAR2
19 ,P_REGION_2 in VARCHAR2
20 ,P_REGION_3 in VARCHAR2
21 ,P_POSTAL_CODE in VARCHAR2
22 ,P_COUNTRY in VARCHAR2
23 ,P_TELEPHONE_NUMBER_1 in VARCHAR2
24 ,P_TELEPHONE_NUMBER_2 in VARCHAR2
25 ,P_TELEPHONE_NUMBER_3 in VARCHAR2
26 ,P_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2
27 ,P_ADDR_ATTRIBUTE1 in VARCHAR2
28 ,P_ADDR_ATTRIBUTE2 in VARCHAR2
29 ,P_ADDR_ATTRIBUTE3 in VARCHAR2
30 ,P_ADDR_ATTRIBUTE4 in VARCHAR2
31 ,P_ADDR_ATTRIBUTE5 in VARCHAR2
32 ,P_ADDR_ATTRIBUTE6 in VARCHAR2
33 ,P_ADDR_ATTRIBUTE7 in VARCHAR2
34 ,P_ADDR_ATTRIBUTE8 in VARCHAR2
35 ,P_ADDR_ATTRIBUTE9 in VARCHAR2
36 ,P_ADDR_ATTRIBUTE10 in VARCHAR2
37 ,P_ADDR_ATTRIBUTE11 in VARCHAR2
38 ,P_ADDR_ATTRIBUTE12 in VARCHAR2
39 ,P_ADDR_ATTRIBUTE13 in VARCHAR2
40 ,P_ADDR_ATTRIBUTE14 in VARCHAR2
41 ,P_ADDR_ATTRIBUTE15 in VARCHAR2
42 ,P_ADDR_ATTRIBUTE16 in VARCHAR2
43 ,P_ADDR_ATTRIBUTE17 in VARCHAR2
44 ,P_ADDR_ATTRIBUTE18 in VARCHAR2
45 ,P_ADDR_ATTRIBUTE19 in VARCHAR2
46 ,P_ADDR_ATTRIBUTE20 in VARCHAR2
47 ,P_ADD_INFORMATION13 in VARCHAR2
48 ,P_ADD_INFORMATION14 in VARCHAR2
49 ,P_ADD_INFORMATION15 in VARCHAR2
50 ,P_ADD_INFORMATION16 in VARCHAR2
51 ,P_ADD_INFORMATION17 in VARCHAR2
52 ,P_ADD_INFORMATION18 in VARCHAR2
53 ,P_ADD_INFORMATION19 in VARCHAR2
54 ,P_ADD_INFORMATION20 in VARCHAR2
55 ,P_STYLE in VARCHAR2
56 )is
57 l_commit_unit_number number;
58 l_legislation_code   varchar2(30);
59 begin
60 hr_utility.set_location('Entering: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_A', 10);
61 l_commit_unit_number := hr_api.return_commit_unit;
62 if hr_api.call_app_hooks then
63 hr_person_address_be3.UPDATE_PERS_ADDR_WITH_STYLE_A
64 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
65 ,P_VALIDATE_COUNTY => P_VALIDATE_COUNTY
66 ,P_ADDRESS_ID => P_ADDRESS_ID
67 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
68 ,P_DATE_FROM => P_DATE_FROM
69 ,P_DATE_TO => P_DATE_TO
70 ,P_ADDRESS_TYPE => P_ADDRESS_TYPE
71 ,P_COMMENTS => P_COMMENTS
72 ,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
73 ,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
74 ,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
75 ,P_TOWN_OR_CITY => P_TOWN_OR_CITY
76 ,P_REGION_1 => P_REGION_1
77 ,P_REGION_2 => P_REGION_2
78 ,P_REGION_3 => P_REGION_3
79 ,P_POSTAL_CODE => P_POSTAL_CODE
80 ,P_COUNTRY => P_COUNTRY
81 ,P_TELEPHONE_NUMBER_1 => P_TELEPHONE_NUMBER_1
82 ,P_TELEPHONE_NUMBER_2 => P_TELEPHONE_NUMBER_2
83 ,P_TELEPHONE_NUMBER_3 => P_TELEPHONE_NUMBER_3
84 ,P_ADDR_ATTRIBUTE_CATEGORY => P_ADDR_ATTRIBUTE_CATEGORY
85 ,P_ADDR_ATTRIBUTE1 => P_ADDR_ATTRIBUTE1
86 ,P_ADDR_ATTRIBUTE2 => P_ADDR_ATTRIBUTE2
87 ,P_ADDR_ATTRIBUTE3 => P_ADDR_ATTRIBUTE3
88 ,P_ADDR_ATTRIBUTE4 => P_ADDR_ATTRIBUTE4
89 ,P_ADDR_ATTRIBUTE5 => P_ADDR_ATTRIBUTE5
90 ,P_ADDR_ATTRIBUTE6 => P_ADDR_ATTRIBUTE6
91 ,P_ADDR_ATTRIBUTE7 => P_ADDR_ATTRIBUTE7
92 ,P_ADDR_ATTRIBUTE8 => P_ADDR_ATTRIBUTE8
93 ,P_ADDR_ATTRIBUTE9 => P_ADDR_ATTRIBUTE9
94 ,P_ADDR_ATTRIBUTE10 => P_ADDR_ATTRIBUTE10
95 ,P_ADDR_ATTRIBUTE11 => P_ADDR_ATTRIBUTE11
96 ,P_ADDR_ATTRIBUTE12 => P_ADDR_ATTRIBUTE12
97 ,P_ADDR_ATTRIBUTE13 => P_ADDR_ATTRIBUTE13
98 ,P_ADDR_ATTRIBUTE14 => P_ADDR_ATTRIBUTE14
99 ,P_ADDR_ATTRIBUTE15 => P_ADDR_ATTRIBUTE15
100 ,P_ADDR_ATTRIBUTE16 => P_ADDR_ATTRIBUTE16
101 ,P_ADDR_ATTRIBUTE17 => P_ADDR_ATTRIBUTE17
102 ,P_ADDR_ATTRIBUTE18 => P_ADDR_ATTRIBUTE18
103 ,P_ADDR_ATTRIBUTE19 => P_ADDR_ATTRIBUTE19
104 ,P_ADDR_ATTRIBUTE20 => P_ADDR_ATTRIBUTE20
105 ,P_ADD_INFORMATION13 => P_ADD_INFORMATION13
106 ,P_ADD_INFORMATION14 => P_ADD_INFORMATION14
107 ,P_ADD_INFORMATION15 => P_ADD_INFORMATION15
108 ,P_ADD_INFORMATION16 => P_ADD_INFORMATION16
109 ,P_ADD_INFORMATION17 => P_ADD_INFORMATION17
110 ,P_ADD_INFORMATION18 => P_ADD_INFORMATION18
111 ,P_ADD_INFORMATION19 => P_ADD_INFORMATION19
112 ,P_ADD_INFORMATION20 => P_ADD_INFORMATION20
113 ,P_STYLE => P_STYLE
114 );
115 end if;
116 if hr_api.call_leg_hooks then
117 l_legislation_code := PER_ADD_BUS.return_legislation_code(P_ADDRESS_ID => P_ADDRESS_ID
118 );
119 if l_legislation_code = 'US' then
120 PER_US_EXTRA_ADDRESS_RULES.UPDATE_TAX_RECORD
121 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
122 ,P_ADDRESS_ID => P_ADDRESS_ID
123 );
124 end if;
125 end if;
126 hr_multi_message.end_validation_set;
127 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PERS_ADDR_WITH_STYLE', 'AP');
128 hr_utility.set_location(' Leaving: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_A', 20);
129 end UPDATE_PERS_ADDR_WITH_STYLE_A;
130 procedure UPDATE_PERS_ADDR_WITH_STYLE_B
131 (P_EFFECTIVE_DATE in DATE
132 ,P_VALIDATE_COUNTY in BOOLEAN
133 ,P_ADDRESS_ID in NUMBER
134 ,P_OBJECT_VERSION_NUMBER in NUMBER
135 ,P_DATE_FROM in DATE
136 ,P_DATE_TO in DATE
137 ,P_ADDRESS_TYPE in VARCHAR2
138 ,P_COMMENTS in CLOB
139 ,P_ADDRESS_LINE1 in VARCHAR2
140 ,P_ADDRESS_LINE2 in VARCHAR2
141 ,P_ADDRESS_LINE3 in VARCHAR2
142 ,P_TOWN_OR_CITY in VARCHAR2
143 ,P_REGION_1 in VARCHAR2
144 ,P_REGION_2 in VARCHAR2
145 ,P_REGION_3 in VARCHAR2
146 ,P_POSTAL_CODE in VARCHAR2
147 ,P_COUNTRY in VARCHAR2
148 ,P_TELEPHONE_NUMBER_1 in VARCHAR2
149 ,P_TELEPHONE_NUMBER_2 in VARCHAR2
150 ,P_TELEPHONE_NUMBER_3 in VARCHAR2
151 ,P_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2
152 ,P_ADDR_ATTRIBUTE1 in VARCHAR2
153 ,P_ADDR_ATTRIBUTE2 in VARCHAR2
154 ,P_ADDR_ATTRIBUTE3 in VARCHAR2
155 ,P_ADDR_ATTRIBUTE4 in VARCHAR2
156 ,P_ADDR_ATTRIBUTE5 in VARCHAR2
157 ,P_ADDR_ATTRIBUTE6 in VARCHAR2
158 ,P_ADDR_ATTRIBUTE7 in VARCHAR2
159 ,P_ADDR_ATTRIBUTE8 in VARCHAR2
160 ,P_ADDR_ATTRIBUTE9 in VARCHAR2
161 ,P_ADDR_ATTRIBUTE10 in VARCHAR2
162 ,P_ADDR_ATTRIBUTE11 in VARCHAR2
163 ,P_ADDR_ATTRIBUTE12 in VARCHAR2
164 ,P_ADDR_ATTRIBUTE13 in VARCHAR2
165 ,P_ADDR_ATTRIBUTE14 in VARCHAR2
166 ,P_ADDR_ATTRIBUTE15 in VARCHAR2
167 ,P_ADDR_ATTRIBUTE16 in VARCHAR2
168 ,P_ADDR_ATTRIBUTE17 in VARCHAR2
169 ,P_ADDR_ATTRIBUTE18 in VARCHAR2
170 ,P_ADDR_ATTRIBUTE19 in VARCHAR2
171 ,P_ADDR_ATTRIBUTE20 in VARCHAR2
172 ,P_ADD_INFORMATION13 in VARCHAR2
173 ,P_ADD_INFORMATION14 in VARCHAR2
174 ,P_ADD_INFORMATION15 in VARCHAR2
175 ,P_ADD_INFORMATION16 in VARCHAR2
176 ,P_ADD_INFORMATION17 in VARCHAR2
177 ,P_ADD_INFORMATION18 in VARCHAR2
178 ,P_ADD_INFORMATION19 in VARCHAR2
179 ,P_ADD_INFORMATION20 in VARCHAR2
180 ,P_STYLE in VARCHAR2
181 ,P_PRIMARY_FLAG in VARCHAR2
182 )is
183 l_commit_unit_number number;
184 l_legislation_code   varchar2(30);
185 begin
186 hr_utility.set_location('Entering: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_B', 10);
187 l_commit_unit_number := hr_api.return_commit_unit;
188 if hr_api.call_leg_hooks then
189 l_legislation_code := PER_ADD_BUS.return_legislation_code(P_ADDRESS_ID => P_ADDRESS_ID
190 );
191 if l_legislation_code = 'AE' then
192 HR_AE_VALIDATE_PKG.UPDATE_ADDRESS_VALIDATE
193 (P_ADDRESS_ID => P_ADDRESS_ID
194 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
195 ,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
196 ,P_TOWN_OR_CITY => P_TOWN_OR_CITY
197 ,P_REGION_1 => P_REGION_1
198 );
199 elsif l_legislation_code = 'ES' then
200 PER_ES_ADDRESS.UPDATE_ES_ADDRESS_STYLE
201 (P_ADDRESS_ID => P_ADDRESS_ID
202 ,P_POSTAL_CODE => P_POSTAL_CODE
203 ,P_REGION_2 => P_REGION_2
204 ,P_STYLE => P_STYLE
205 );
206 elsif l_legislation_code = 'PL' then
207 PER_PL_ADDRESS.UPDATE_PL_ADDRESS_STYLE
208 (P_ADDRESS_ID => P_ADDRESS_ID
209 ,P_STYLE => P_STYLE
210 ,P_ADDRESS_TYPE => P_ADDRESS_TYPE
211 ,P_DATE_FROM => P_DATE_FROM
212 ,P_DATE_TO => P_DATE_TO
213 ,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
214 ,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
215 );
216 elsif l_legislation_code = 'RO' then
217 PER_RO_ADDRESS.UPDATE_RO_ADDRESS_STYLE
218 (P_ADDRESS_ID => P_ADDRESS_ID
219 ,P_STYLE => P_STYLE
220 ,P_ADDRESS_TYPE => P_ADDRESS_TYPE
221 ,P_DATE_FROM => P_DATE_FROM
222 ,P_DATE_TO => P_DATE_TO
223 ,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
224 ,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
225 ,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
226 );
227 elsif l_legislation_code = 'RU' then
228 HR_RU_ADDRESS_HOOK.UPDATE_RU_ADDRESS_WITH_STYLE
229 (P_STYLE => P_STYLE
230 ,P_ADDRESS_ID => P_ADDRESS_ID
231 ,P_ADD_INFORMATION13 => P_ADD_INFORMATION13
232 ,P_POSTAL_CODE => P_POSTAL_CODE
233 );
234 elsif l_legislation_code = 'US' then
235 PER_US_ADD_LEG_HOOK.UPDATE_US_ADDRESS
236 (P_STYLE => P_STYLE
237 ,P_PRIMARY_FLAG => P_PRIMARY_FLAG
238 ,P_ADDRESS_ID => P_ADDRESS_ID
239 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
240 );
241 end if;
242 end if;
243 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PERS_ADDR_WITH_STYLE', 'BP');
244 hr_utility.set_location(' Leaving: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_B', 20);
245 end UPDATE_PERS_ADDR_WITH_STYLE_B;
246 end HR_PERSON_ADDRESS_BK3;