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.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:19 (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 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 ,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 LONG
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 )is
182 l_commit_unit_number number;
183 l_legislation_code   varchar2(30);
184 begin
185 hr_utility.set_location('Entering: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_B', 10);
186 l_commit_unit_number := hr_api.return_commit_unit;
187 if hr_api.call_leg_hooks then
188 l_legislation_code := PER_ADD_BUS.return_legislation_code(P_ADDRESS_ID => P_ADDRESS_ID
189 );
190 if l_legislation_code = 'AE' then
191 HR_AE_VALIDATE_PKG.UPDATE_ADDRESS_VALIDATE
192 (P_ADDRESS_ID => P_ADDRESS_ID
193 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
194 ,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
195 ,P_TOWN_OR_CITY => P_TOWN_OR_CITY
196 ,P_REGION_1 => P_REGION_1
197 );
198 elsif l_legislation_code = 'ES' then
199 PER_ES_ADDRESS.UPDATE_ES_ADDRESS_STYLE
200 (P_ADDRESS_ID => P_ADDRESS_ID
201 ,P_POSTAL_CODE => P_POSTAL_CODE
202 ,P_REGION_2 => P_REGION_2
203 ,P_STYLE => P_STYLE
204 );
205 elsif l_legislation_code = 'PL' then
206 PER_PL_ADDRESS.UPDATE_PL_ADDRESS_STYLE
207 (P_ADDRESS_ID => P_ADDRESS_ID
208 ,P_STYLE => P_STYLE
209 ,P_ADDRESS_TYPE => P_ADDRESS_TYPE
210 ,P_DATE_FROM => P_DATE_FROM
211 ,P_DATE_TO => P_DATE_TO
212 ,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
213 ,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
214 );
215 elsif l_legislation_code = 'RU' then
216 HR_RU_ADDRESS_HOOK.UPDATE_RU_ADDRESS_WITH_STYLE
217 (P_STYLE => P_STYLE
218 ,P_ADDRESS_ID => P_ADDRESS_ID
219 ,P_ADD_INFORMATION13 => P_ADD_INFORMATION13
220 ,P_POSTAL_CODE => P_POSTAL_CODE
221 );
222 end if;
223 end if;
224 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PERS_ADDR_WITH_STYLE', 'BP');
225 hr_utility.set_location(' Leaving: HR_PERSON_ADDRESS_BK3.UPDATE_PERS_ADDR_WITH_STYLE_B', 20);
226 end UPDATE_PERS_ADDR_WITH_STYLE_B;
227 end HR_PERSON_ADDRESS_BK3;