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.PER_ADD_RKU

Source


1 package body PER_ADD_RKU as
2 /* $Header: peaddrhi.pkb 120.1.12010000.3 2008/08/06 08:53:04 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:53:47 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_UPDATE
6 (P_ADDRESS_ID in NUMBER
7 ,P_BUSINESS_GROUP_ID in NUMBER
8 ,P_PERSON_ID in NUMBER
9 ,P_DATE_FROM in DATE
10 ,P_ADDRESS_LINE1 in VARCHAR2
11 ,P_ADDRESS_LINE2 in VARCHAR2
12 ,P_ADDRESS_LINE3 in VARCHAR2
13 ,P_ADDRESS_TYPE in VARCHAR2
14 ,P_COMMENTS in LONG
15 ,P_COUNTRY in VARCHAR2
16 ,P_DATE_TO in DATE
17 ,P_POSTAL_CODE in VARCHAR2
18 ,P_REGION_1 in VARCHAR2
19 ,P_REGION_2 in VARCHAR2
20 ,P_REGION_3 in VARCHAR2
21 ,P_TELEPHONE_NUMBER_1 in VARCHAR2
22 ,P_TELEPHONE_NUMBER_2 in VARCHAR2
23 ,P_TELEPHONE_NUMBER_3 in VARCHAR2
24 ,P_TOWN_OR_CITY in VARCHAR2
25 ,P_REQUEST_ID in NUMBER
26 ,P_PROGRAM_APPLICATION_ID in NUMBER
27 ,P_PROGRAM_ID in NUMBER
28 ,P_PROGRAM_UPDATE_DATE in DATE
29 ,P_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2
30 ,P_ADDR_ATTRIBUTE1 in VARCHAR2
31 ,P_ADDR_ATTRIBUTE2 in VARCHAR2
32 ,P_ADDR_ATTRIBUTE3 in VARCHAR2
33 ,P_ADDR_ATTRIBUTE4 in VARCHAR2
34 ,P_ADDR_ATTRIBUTE5 in VARCHAR2
35 ,P_ADDR_ATTRIBUTE6 in VARCHAR2
36 ,P_ADDR_ATTRIBUTE7 in VARCHAR2
37 ,P_ADDR_ATTRIBUTE8 in VARCHAR2
38 ,P_ADDR_ATTRIBUTE9 in VARCHAR2
39 ,P_ADDR_ATTRIBUTE10 in VARCHAR2
40 ,P_ADDR_ATTRIBUTE11 in VARCHAR2
41 ,P_ADDR_ATTRIBUTE12 in VARCHAR2
42 ,P_ADDR_ATTRIBUTE13 in VARCHAR2
43 ,P_ADDR_ATTRIBUTE14 in VARCHAR2
44 ,P_ADDR_ATTRIBUTE15 in VARCHAR2
45 ,P_ADDR_ATTRIBUTE16 in VARCHAR2
46 ,P_ADDR_ATTRIBUTE17 in VARCHAR2
47 ,P_ADDR_ATTRIBUTE18 in VARCHAR2
48 ,P_ADDR_ATTRIBUTE19 in VARCHAR2
49 ,P_ADDR_ATTRIBUTE20 in VARCHAR2
50 ,P_ADD_INFORMATION13 in VARCHAR2
51 ,P_ADD_INFORMATION14 in VARCHAR2
52 ,P_ADD_INFORMATION15 in VARCHAR2
53 ,P_ADD_INFORMATION16 in VARCHAR2
54 ,P_ADD_INFORMATION17 in VARCHAR2
55 ,P_ADD_INFORMATION18 in VARCHAR2
56 ,P_ADD_INFORMATION19 in VARCHAR2
57 ,P_ADD_INFORMATION20 in VARCHAR2
58 ,P_OBJECT_VERSION_NUMBER in NUMBER
59 ,P_EFFECTIVE_DATE in DATE
60 ,P_PRFLAGVAL_OVERRIDE in BOOLEAN
61 ,P_VALIDATE_COUNTY in BOOLEAN
62 ,P_BUSINESS_GROUP_ID_O in NUMBER
63 ,P_PERSON_ID_O in NUMBER
64 ,P_DATE_FROM_O in DATE
65 ,P_PRIMARY_FLAG_O in VARCHAR2
66 ,P_STYLE_O in VARCHAR2
67 ,P_ADDRESS_LINE1_O in VARCHAR2
68 ,P_ADDRESS_LINE2_O in VARCHAR2
69 ,P_ADDRESS_LINE3_O in VARCHAR2
70 ,P_ADDRESS_TYPE_O in VARCHAR2
71 ,P_COMMENTS_O in LONG
72 ,P_COUNTRY_O in VARCHAR2
73 ,P_DATE_TO_O in DATE
74 ,P_POSTAL_CODE_O in VARCHAR2
75 ,P_REGION_1_O in VARCHAR2
76 ,P_REGION_2_O in VARCHAR2
77 ,P_REGION_3_O in VARCHAR2
78 ,P_TELEPHONE_NUMBER_1_O in VARCHAR2
79 ,P_TELEPHONE_NUMBER_2_O in VARCHAR2
80 ,P_TELEPHONE_NUMBER_3_O in VARCHAR2
81 ,P_TOWN_OR_CITY_O in VARCHAR2
82 ,P_REQUEST_ID_O in NUMBER
83 ,P_PROGRAM_APPLICATION_ID_O in NUMBER
84 ,P_PROGRAM_ID_O in NUMBER
85 ,P_PROGRAM_UPDATE_DATE_O in DATE
86 ,P_ADDR_ATTRIBUTE_CATEGORY_O in VARCHAR2
87 ,P_ADDR_ATTRIBUTE1_O in VARCHAR2
88 ,P_ADDR_ATTRIBUTE2_O in VARCHAR2
89 ,P_ADDR_ATTRIBUTE3_O in VARCHAR2
90 ,P_ADDR_ATTRIBUTE4_O in VARCHAR2
91 ,P_ADDR_ATTRIBUTE5_O in VARCHAR2
92 ,P_ADDR_ATTRIBUTE6_O in VARCHAR2
93 ,P_ADDR_ATTRIBUTE7_O in VARCHAR2
94 ,P_ADDR_ATTRIBUTE8_O in VARCHAR2
95 ,P_ADDR_ATTRIBUTE9_O in VARCHAR2
96 ,P_ADDR_ATTRIBUTE10_O in VARCHAR2
97 ,P_ADDR_ATTRIBUTE11_O in VARCHAR2
98 ,P_ADDR_ATTRIBUTE12_O in VARCHAR2
99 ,P_ADDR_ATTRIBUTE13_O in VARCHAR2
100 ,P_ADDR_ATTRIBUTE14_O in VARCHAR2
101 ,P_ADDR_ATTRIBUTE15_O in VARCHAR2
102 ,P_ADDR_ATTRIBUTE16_O in VARCHAR2
103 ,P_ADDR_ATTRIBUTE17_O in VARCHAR2
104 ,P_ADDR_ATTRIBUTE18_O in VARCHAR2
105 ,P_ADDR_ATTRIBUTE19_O in VARCHAR2
106 ,P_ADDR_ATTRIBUTE20_O in VARCHAR2
107 ,P_ADD_INFORMATION13_O in VARCHAR2
108 ,P_ADD_INFORMATION14_O in VARCHAR2
109 ,P_ADD_INFORMATION15_O in VARCHAR2
110 ,P_ADD_INFORMATION16_O in VARCHAR2
111 ,P_ADD_INFORMATION17_O in VARCHAR2
112 ,P_ADD_INFORMATION18_O in VARCHAR2
113 ,P_ADD_INFORMATION19_O in VARCHAR2
114 ,P_ADD_INFORMATION20_O in VARCHAR2
115 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
116 ,P_PARTY_ID_O in NUMBER
117 )is
118 l_commit_unit_number number;
119 l_legislation_code   varchar2(30);
120 begin
121 hr_utility.set_location('Entering: PER_ADD_RKU.AFTER_UPDATE', 10);
122 l_commit_unit_number := hr_api.return_commit_unit;
123 if hr_api.call_app_hooks then
124 PQP_Address_Synchronization.ADDR_DDF_UPD
125 (P_ADDRESS_ID => P_ADDRESS_ID
126 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
127 ,P_PERSON_ID => P_PERSON_ID
128 ,P_DATE_FROM => P_DATE_FROM
129 ,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
130 ,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
131 ,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
132 ,P_ADDRESS_TYPE => P_ADDRESS_TYPE
133 ,P_COUNTRY => P_COUNTRY
134 ,P_DATE_TO => P_DATE_TO
135 ,P_POSTAL_CODE => P_POSTAL_CODE
136 ,P_REGION_1 => P_REGION_1
137 ,P_REGION_2 => P_REGION_2
138 ,P_REGION_3 => P_REGION_3
139 ,P_TELEPHONE_NUMBER_1 => P_TELEPHONE_NUMBER_1
140 ,P_TELEPHONE_NUMBER_2 => P_TELEPHONE_NUMBER_2
141 ,P_TELEPHONE_NUMBER_3 => P_TELEPHONE_NUMBER_3
142 ,P_TOWN_OR_CITY => P_TOWN_OR_CITY
143 ,P_ADD_INFORMATION13 => P_ADD_INFORMATION13
144 ,P_ADD_INFORMATION14 => P_ADD_INFORMATION14
145 ,P_ADD_INFORMATION15 => P_ADD_INFORMATION15
146 ,P_ADD_INFORMATION16 => P_ADD_INFORMATION16
147 ,P_ADD_INFORMATION17 => P_ADD_INFORMATION17
148 ,P_ADD_INFORMATION18 => P_ADD_INFORMATION18
149 ,P_ADD_INFORMATION19 => P_ADD_INFORMATION19
150 ,P_ADD_INFORMATION20 => P_ADD_INFORMATION20
151 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
152 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
153 ,P_PRFLAGVAL_OVERRIDE => P_PRFLAGVAL_OVERRIDE
154 ,P_VALIDATE_COUNTY => P_VALIDATE_COUNTY
155 ,P_BUSINESS_GROUP_ID_O => P_BUSINESS_GROUP_ID_O
156 ,P_PERSON_ID_O => P_PERSON_ID_O
157 ,P_DATE_FROM_O => P_DATE_FROM_O
158 ,P_PRIMARY_FLAG_O => P_PRIMARY_FLAG_O
159 ,P_STYLE_O => P_STYLE_O
160 ,P_ADDRESS_LINE1_O => P_ADDRESS_LINE1_O
161 ,P_ADDRESS_LINE2_O => P_ADDRESS_LINE2_O
162 ,P_ADDRESS_LINE3_O => P_ADDRESS_LINE3_O
163 ,P_ADDRESS_TYPE_O => P_ADDRESS_TYPE_O
164 ,P_COUNTRY_O => P_COUNTRY_O
165 ,P_DATE_TO_O => P_DATE_TO_O
166 ,P_POSTAL_CODE_O => P_POSTAL_CODE_O
167 ,P_REGION_1_O => P_REGION_1_O
168 ,P_REGION_2_O => P_REGION_2_O
169 ,P_REGION_3_O => P_REGION_3_O
170 ,P_TELEPHONE_NUMBER_1_O => P_TELEPHONE_NUMBER_1_O
171 ,P_TELEPHONE_NUMBER_2_O => P_TELEPHONE_NUMBER_2_O
172 ,P_TELEPHONE_NUMBER_3_O => P_TELEPHONE_NUMBER_3_O
173 ,P_TOWN_OR_CITY_O => P_TOWN_OR_CITY_O
174 ,P_ADD_INFORMATION13_O => P_ADD_INFORMATION13_O
175 ,P_ADD_INFORMATION14_O => P_ADD_INFORMATION14_O
176 ,P_ADD_INFORMATION15_O => P_ADD_INFORMATION15_O
177 ,P_ADD_INFORMATION16_O => P_ADD_INFORMATION16_O
178 ,P_ADD_INFORMATION17_O => P_ADD_INFORMATION17_O
179 ,P_ADD_INFORMATION18_O => P_ADD_INFORMATION18_O
180 ,P_ADD_INFORMATION19_O => P_ADD_INFORMATION19_O
181 ,P_ADD_INFORMATION20_O => P_ADD_INFORMATION20_O
182 ,P_OBJECT_VERSION_NUMBER_O => P_OBJECT_VERSION_NUMBER_O
183 ,P_PARTY_ID_O => P_PARTY_ID_O
184 );
185 end if;
186 if hr_api.call_leg_hooks then
187 l_legislation_code := hr_api.return_legislation_code(p_business_group_id => P_BUSINESS_GROUP_ID);
188 if l_legislation_code = 'IN' then
189 PER_IN_ADD_LEG_HOOK.CHECK_PER_ADDRESS_UPD
190 (P_ADDRESS_ID => P_ADDRESS_ID
191 ,P_ADD_INFORMATION14 => P_ADD_INFORMATION14
192 ,P_ADD_INFORMATION15 => P_ADD_INFORMATION15
193 ,P_POSTAL_CODE => P_POSTAL_CODE
194 );
195 elsif l_legislation_code = 'KR' then
196 PER_KR_ADDRESS_UPDATE_HOOK_PKG.UPDATE_ADDRESS_LINE1_AU
197 (P_ADDRESS_ID => P_ADDRESS_ID
198 ,P_BUSINESS_GROUP_ID_O => P_BUSINESS_GROUP_ID_O
199 ,P_PERSON_ID_O => P_PERSON_ID_O
200 ,P_STYLE_O => P_STYLE_O
201 ,P_ADD_INFORMATION17 => P_ADD_INFORMATION17
202 );
203 end if;
204 end if;
205 hr_api.validate_commit_unit(l_commit_unit_number, 'PER_ADDRESSES', 'AU');
206 hr_utility.set_location(' Leaving: PER_ADD_RKU.AFTER_UPDATE', 20);
207 end AFTER_UPDATE;
208 end PER_ADD_RKU;