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_BK2

Source


1 package body HR_PERSON_ADDRESS_BK2 as
2 /* $Header: peaddapi.pkb 120.2.12010000.1 2008/07/28 04:02:14 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:46:17 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_PERSON_ADDRESS_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 LONG
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 )is
56 l_commit_unit_number number;
57 l_legislation_code   varchar2(30);
58 begin
59 hr_utility.set_location('Entering: HR_PERSON_ADDRESS_BK2.UPDATE_PERSON_ADDRESS_A', 10);
60 l_commit_unit_number := hr_api.return_commit_unit;
61 if hr_api.call_app_hooks then
62 hr_person_address_be2.UPDATE_PERSON_ADDRESS_A
63 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
64 ,P_VALIDATE_COUNTY => P_VALIDATE_COUNTY
65 ,P_ADDRESS_ID => P_ADDRESS_ID
66 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
67 ,P_DATE_FROM => P_DATE_FROM
68 ,P_DATE_TO => P_DATE_TO
69 ,P_ADDRESS_TYPE => P_ADDRESS_TYPE
70 ,P_COMMENTS => P_COMMENTS
71 ,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
72 ,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
73 ,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
74 ,P_TOWN_OR_CITY => P_TOWN_OR_CITY
75 ,P_REGION_1 => P_REGION_1
76 ,P_REGION_2 => P_REGION_2
77 ,P_REGION_3 => P_REGION_3
78 ,P_POSTAL_CODE => P_POSTAL_CODE
79 ,P_COUNTRY => P_COUNTRY
80 ,P_TELEPHONE_NUMBER_1 => P_TELEPHONE_NUMBER_1
81 ,P_TELEPHONE_NUMBER_2 => P_TELEPHONE_NUMBER_2
82 ,P_TELEPHONE_NUMBER_3 => P_TELEPHONE_NUMBER_3
83 ,P_ADDR_ATTRIBUTE_CATEGORY => P_ADDR_ATTRIBUTE_CATEGORY
84 ,P_ADDR_ATTRIBUTE1 => P_ADDR_ATTRIBUTE1
85 ,P_ADDR_ATTRIBUTE2 => P_ADDR_ATTRIBUTE2
86 ,P_ADDR_ATTRIBUTE3 => P_ADDR_ATTRIBUTE3
87 ,P_ADDR_ATTRIBUTE4 => P_ADDR_ATTRIBUTE4
88 ,P_ADDR_ATTRIBUTE5 => P_ADDR_ATTRIBUTE5
89 ,P_ADDR_ATTRIBUTE6 => P_ADDR_ATTRIBUTE6
90 ,P_ADDR_ATTRIBUTE7 => P_ADDR_ATTRIBUTE7
91 ,P_ADDR_ATTRIBUTE8 => P_ADDR_ATTRIBUTE8
92 ,P_ADDR_ATTRIBUTE9 => P_ADDR_ATTRIBUTE9
93 ,P_ADDR_ATTRIBUTE10 => P_ADDR_ATTRIBUTE10
94 ,P_ADDR_ATTRIBUTE11 => P_ADDR_ATTRIBUTE11
95 ,P_ADDR_ATTRIBUTE12 => P_ADDR_ATTRIBUTE12
96 ,P_ADDR_ATTRIBUTE13 => P_ADDR_ATTRIBUTE13
97 ,P_ADDR_ATTRIBUTE14 => P_ADDR_ATTRIBUTE14
98 ,P_ADDR_ATTRIBUTE15 => P_ADDR_ATTRIBUTE15
99 ,P_ADDR_ATTRIBUTE16 => P_ADDR_ATTRIBUTE16
100 ,P_ADDR_ATTRIBUTE17 => P_ADDR_ATTRIBUTE17
101 ,P_ADDR_ATTRIBUTE18 => P_ADDR_ATTRIBUTE18
102 ,P_ADDR_ATTRIBUTE19 => P_ADDR_ATTRIBUTE19
103 ,P_ADDR_ATTRIBUTE20 => P_ADDR_ATTRIBUTE20
104 ,P_ADD_INFORMATION13 => P_ADD_INFORMATION13
105 ,P_ADD_INFORMATION14 => P_ADD_INFORMATION14
106 ,P_ADD_INFORMATION15 => P_ADD_INFORMATION15
107 ,P_ADD_INFORMATION16 => P_ADD_INFORMATION16
108 ,P_ADD_INFORMATION17 => P_ADD_INFORMATION17
109 ,P_ADD_INFORMATION18 => P_ADD_INFORMATION18
110 ,P_ADD_INFORMATION19 => P_ADD_INFORMATION19
111 ,P_ADD_INFORMATION20 => P_ADD_INFORMATION20
112 );
113 end if;
114 if hr_api.call_leg_hooks then
115 l_legislation_code := PER_ADD_BUS.return_legislation_code(P_ADDRESS_ID => P_ADDRESS_ID
116 );
117 if l_legislation_code = 'US' then
118 PER_US_EXTRA_ADDRESS_RULES.UPDATE_TAX_RECORD
119 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
120 ,P_ADDRESS_ID => P_ADDRESS_ID
121 );
122 end if;
123 end if;
124 hr_multi_message.end_validation_set;
125 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PERSON_ADDRESS', 'AP');
126 hr_utility.set_location(' Leaving: HR_PERSON_ADDRESS_BK2.UPDATE_PERSON_ADDRESS_A', 20);
127 end UPDATE_PERSON_ADDRESS_A;
128 procedure UPDATE_PERSON_ADDRESS_B
129 (P_EFFECTIVE_DATE in DATE
130 ,P_VALIDATE_COUNTY in BOOLEAN
131 ,P_ADDRESS_ID in NUMBER
132 ,P_OBJECT_VERSION_NUMBER in NUMBER
133 ,P_DATE_FROM in DATE
134 ,P_DATE_TO in DATE
135 ,P_ADDRESS_TYPE in VARCHAR2
136 ,P_COMMENTS in LONG
137 ,P_ADDRESS_LINE1 in VARCHAR2
138 ,P_ADDRESS_LINE2 in VARCHAR2
139 ,P_ADDRESS_LINE3 in VARCHAR2
140 ,P_TOWN_OR_CITY in VARCHAR2
141 ,P_REGION_1 in VARCHAR2
142 ,P_REGION_2 in VARCHAR2
143 ,P_REGION_3 in VARCHAR2
144 ,P_POSTAL_CODE in VARCHAR2
145 ,P_COUNTRY in VARCHAR2
146 ,P_TELEPHONE_NUMBER_1 in VARCHAR2
147 ,P_TELEPHONE_NUMBER_2 in VARCHAR2
148 ,P_TELEPHONE_NUMBER_3 in VARCHAR2
149 ,P_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2
150 ,P_ADDR_ATTRIBUTE1 in VARCHAR2
151 ,P_ADDR_ATTRIBUTE2 in VARCHAR2
152 ,P_ADDR_ATTRIBUTE3 in VARCHAR2
153 ,P_ADDR_ATTRIBUTE4 in VARCHAR2
154 ,P_ADDR_ATTRIBUTE5 in VARCHAR2
155 ,P_ADDR_ATTRIBUTE6 in VARCHAR2
156 ,P_ADDR_ATTRIBUTE7 in VARCHAR2
157 ,P_ADDR_ATTRIBUTE8 in VARCHAR2
158 ,P_ADDR_ATTRIBUTE9 in VARCHAR2
159 ,P_ADDR_ATTRIBUTE10 in VARCHAR2
160 ,P_ADDR_ATTRIBUTE11 in VARCHAR2
161 ,P_ADDR_ATTRIBUTE12 in VARCHAR2
162 ,P_ADDR_ATTRIBUTE13 in VARCHAR2
163 ,P_ADDR_ATTRIBUTE14 in VARCHAR2
164 ,P_ADDR_ATTRIBUTE15 in VARCHAR2
165 ,P_ADDR_ATTRIBUTE16 in VARCHAR2
166 ,P_ADDR_ATTRIBUTE17 in VARCHAR2
167 ,P_ADDR_ATTRIBUTE18 in VARCHAR2
168 ,P_ADDR_ATTRIBUTE19 in VARCHAR2
169 ,P_ADDR_ATTRIBUTE20 in VARCHAR2
170 ,P_ADD_INFORMATION13 in VARCHAR2
171 ,P_ADD_INFORMATION14 in VARCHAR2
172 ,P_ADD_INFORMATION15 in VARCHAR2
173 ,P_ADD_INFORMATION16 in VARCHAR2
174 ,P_ADD_INFORMATION17 in VARCHAR2
175 ,P_ADD_INFORMATION18 in VARCHAR2
176 ,P_ADD_INFORMATION19 in VARCHAR2
177 ,P_ADD_INFORMATION20 in VARCHAR2
178 )is
179 l_commit_unit_number number;
180 l_legislation_code   varchar2(30);
181 begin
182 hr_utility.set_location('Entering: HR_PERSON_ADDRESS_BK2.UPDATE_PERSON_ADDRESS_B', 10);
183 l_commit_unit_number := hr_api.return_commit_unit;
184 if hr_api.call_leg_hooks then
185 l_legislation_code := PER_ADD_BUS.return_legislation_code(P_ADDRESS_ID => P_ADDRESS_ID
186 );
187 if l_legislation_code = 'AE' then
188 HR_AE_VALIDATE_PKG.UPDATE_ADDRESS_VALIDATE
189 (P_ADDRESS_ID => P_ADDRESS_ID
190 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
191 ,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
192 ,P_TOWN_OR_CITY => P_TOWN_OR_CITY
193 ,P_REGION_1 => P_REGION_1
194 );
195 elsif l_legislation_code = 'AU' then
196 PER_AU_ADD_LEG_HOOK.CHECK_ADDRESS_UPD
197 (P_ADDRESS_ID => P_ADDRESS_ID
198 ,P_REGION_1 => P_REGION_1
199 ,P_COUNTRY => P_COUNTRY
200 );
201 elsif l_legislation_code = 'CN' then
202 PER_CN_ADD_LEG_HOOK.CHECK_ADDRESS_UPD
203 (P_ADDRESS_ID => P_ADDRESS_ID
204 ,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
205 ,P_TOWN_OR_CITY => P_TOWN_OR_CITY
206 ,P_COUNTRY => P_COUNTRY
207 ,P_POSTAL_CODE => P_POSTAL_CODE
208 );
209 elsif l_legislation_code = 'ES' then
210 PER_ES_ADDRESS.UPDATE_ES_ADDRESS
211 (P_ADDRESS_ID => P_ADDRESS_ID
212 ,P_POSTAL_CODE => P_POSTAL_CODE
213 ,P_REGION_2 => P_REGION_2
214 );
215 elsif l_legislation_code = 'PL' then
216 PER_PL_ADDRESS.UPDATE_PL_ADDRESS
217 (P_ADDRESS_ID => P_ADDRESS_ID
218 ,P_ADDRESS_TYPE => P_ADDRESS_TYPE
219 ,P_DATE_FROM => P_DATE_FROM
220 ,P_DATE_TO => P_DATE_TO
221 ,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
222 ,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
223 );
224 elsif l_legislation_code = 'RU' then
225 HR_RU_ADDRESS_HOOK.UPDATE_RU_ADDRESS
226 (P_ADDRESS_ID => P_ADDRESS_ID
227 ,P_ADD_INFORMATION13 => P_ADD_INFORMATION13
228 ,P_POSTAL_CODE => P_POSTAL_CODE
229 );
230 end if;
231 end if;
232 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PERSON_ADDRESS', 'BP');
233 hr_utility.set_location(' Leaving: HR_PERSON_ADDRESS_BK2.UPDATE_PERSON_ADDRESS_B', 20);
234 end UPDATE_PERSON_ADDRESS_B;
235 end HR_PERSON_ADDRESS_BK2;