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_BK1

Source


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