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

Source


1 package body PE_AEI_RKI as
2 /* $Header: peaeirhi.pkb 115.8 2002/12/03 15:36:45 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 AFTER_INSERT
6 (P_ASSIGNMENT_EXTRA_INFO_ID in NUMBER
7 ,P_ASSIGNMENT_ID in NUMBER
8 ,P_INFORMATION_TYPE in VARCHAR2
9 ,P_REQUEST_ID in NUMBER
10 ,P_PROGRAM_APPLICATION_ID in NUMBER
11 ,P_PROGRAM_ID in NUMBER
12 ,P_PROGRAM_UPDATE_DATE in DATE
13 ,P_AEI_ATTRIBUTE_CATEGORY in VARCHAR2
14 ,P_AEI_ATTRIBUTE1 in VARCHAR2
15 ,P_AEI_ATTRIBUTE2 in VARCHAR2
16 ,P_AEI_ATTRIBUTE3 in VARCHAR2
17 ,P_AEI_ATTRIBUTE4 in VARCHAR2
18 ,P_AEI_ATTRIBUTE5 in VARCHAR2
19 ,P_AEI_ATTRIBUTE6 in VARCHAR2
20 ,P_AEI_ATTRIBUTE7 in VARCHAR2
21 ,P_AEI_ATTRIBUTE8 in VARCHAR2
22 ,P_AEI_ATTRIBUTE9 in VARCHAR2
23 ,P_AEI_ATTRIBUTE10 in VARCHAR2
24 ,P_AEI_ATTRIBUTE11 in VARCHAR2
25 ,P_AEI_ATTRIBUTE12 in VARCHAR2
26 ,P_AEI_ATTRIBUTE13 in VARCHAR2
27 ,P_AEI_ATTRIBUTE14 in VARCHAR2
28 ,P_AEI_ATTRIBUTE15 in VARCHAR2
29 ,P_AEI_ATTRIBUTE16 in VARCHAR2
30 ,P_AEI_ATTRIBUTE17 in VARCHAR2
31 ,P_AEI_ATTRIBUTE18 in VARCHAR2
32 ,P_AEI_ATTRIBUTE19 in VARCHAR2
33 ,P_AEI_ATTRIBUTE20 in VARCHAR2
34 ,P_AEI_INFORMATION_CATEGORY in VARCHAR2
35 ,P_AEI_INFORMATION1 in VARCHAR2
36 ,P_AEI_INFORMATION2 in VARCHAR2
37 ,P_AEI_INFORMATION3 in VARCHAR2
38 ,P_AEI_INFORMATION4 in VARCHAR2
39 ,P_AEI_INFORMATION5 in VARCHAR2
40 ,P_AEI_INFORMATION6 in VARCHAR2
41 ,P_AEI_INFORMATION7 in VARCHAR2
42 ,P_AEI_INFORMATION8 in VARCHAR2
43 ,P_AEI_INFORMATION9 in VARCHAR2
44 ,P_AEI_INFORMATION10 in VARCHAR2
45 ,P_AEI_INFORMATION11 in VARCHAR2
46 ,P_AEI_INFORMATION12 in VARCHAR2
47 ,P_AEI_INFORMATION13 in VARCHAR2
48 ,P_AEI_INFORMATION14 in VARCHAR2
49 ,P_AEI_INFORMATION15 in VARCHAR2
50 ,P_AEI_INFORMATION16 in VARCHAR2
51 ,P_AEI_INFORMATION17 in VARCHAR2
52 ,P_AEI_INFORMATION18 in VARCHAR2
53 ,P_AEI_INFORMATION19 in VARCHAR2
54 ,P_AEI_INFORMATION20 in VARCHAR2
55 ,P_AEI_INFORMATION21 in VARCHAR2
56 ,P_AEI_INFORMATION22 in VARCHAR2
57 ,P_AEI_INFORMATION23 in VARCHAR2
58 ,P_AEI_INFORMATION24 in VARCHAR2
59 ,P_AEI_INFORMATION25 in VARCHAR2
60 ,P_AEI_INFORMATION26 in VARCHAR2
61 ,P_AEI_INFORMATION27 in VARCHAR2
62 ,P_AEI_INFORMATION28 in VARCHAR2
63 ,P_AEI_INFORMATION29 in VARCHAR2
64 ,P_AEI_INFORMATION30 in VARCHAR2
65 )is
66 l_commit_unit_number number;
67 l_legislation_code   varchar2(30);
68 begin
69 hr_utility.set_location('Entering: PE_AEI_RKI.AFTER_INSERT', 10);
70 l_commit_unit_number := hr_api.return_commit_unit;
71 if hr_api.call_leg_hooks then
72 l_legislation_code := PER_ASG_BUS1.return_legislation_code(P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
73 );
74 if l_legislation_code = 'KR' then
75 PER_KR_EXTRA_AEI_RULES.CHK_INFORMATION_TYPE_UNIQUE
76 (P_ASSIGNMENT_EXTRA_INFO_ID => P_ASSIGNMENT_EXTRA_INFO_ID
77 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
78 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
79 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
80 );
81 PER_KR_EXTRA_AEI_RULES.CHK_INSERT_UPDATE
82 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
83 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
84 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
85 ,P_AEI_INFORMATION3 => P_AEI_INFORMATION3
86 ,P_AEI_INFORMATION12 => P_AEI_INFORMATION12
87 ,P_AEI_INFORMATION13 => P_AEI_INFORMATION13
88 );
89 PER_KR_EXTRA_AEI_RULES.CHK_TAXATION_PERIOD_UNIQUE
90 (P_ASSIGNMENT_EXTRA_INFO_ID => P_ASSIGNMENT_EXTRA_INFO_ID
91 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
92 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
93 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
94 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
95 ,P_AEI_INFORMATION3 => P_AEI_INFORMATION3
96 ,P_AEI_INFORMATION4 => P_AEI_INFORMATION4
97 ,P_AEI_INFORMATION5 => P_AEI_INFORMATION5
98 ,P_AEI_INFORMATION7 => P_AEI_INFORMATION7
99 ,P_AEI_INFORMATION8 => P_AEI_INFORMATION8
100 );
101 PER_KR_EXTRA_AEI_RULES.CHK_MED_INSERT_UPDATE
102 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
103 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
104 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
105 );
106 PER_KR_EXTRA_AEI_RULES.CHK_NTAX_EARN_UNIQUE
107 (P_ASSIGNMENT_EXTRA_INFO_ID => P_ASSIGNMENT_EXTRA_INFO_ID
108 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
109 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
110 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
111 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
112 ,P_AEI_INFORMATION4 => P_AEI_INFORMATION4
113 );
114 PER_KR_EXTRA_AEI_RULES.CHK_DPNT_EDUC_INSERT_UPDATE
115 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
116 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
117 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
118 ,P_AEI_INFORMATION6 => P_AEI_INFORMATION6
119 ,P_AEI_INFORMATION7 => P_AEI_INFORMATION7
120 );
121 PER_KR_EXTRA_AEI_RULES.ELIGIBLE_FOR_MED_EXEM_AGED
122 (P_AEI_INFORMATION7 => P_AEI_INFORMATION7
123 ,P_AEI_INFORMATION8 => P_AEI_INFORMATION8
124 ,P_AEI_INFORMATION9 => P_AEI_INFORMATION9
125 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
126 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
127 );
128 PER_KR_EXTRA_AEI_RULES.DUP_RECORDS
129 (P_AEI_INFORMATION1 => P_AEI_INFORMATION1
130 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
131 ,P_ASSIGNMENT_EXTRA_INFO_ID => P_ASSIGNMENT_EXTRA_INFO_ID
132 ,P_AEI_INFORMATION6 => P_AEI_INFORMATION6
133 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
134 ,P_AEI_INFORMATION4 => P_AEI_INFORMATION4
135 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
136 );
137 PER_KR_EXTRA_AEI_RULES.HOUSING_SUB_SAVING_LIMIT
138 (P_AEI_INFORMATION1 => P_AEI_INFORMATION1
139 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
140 ,P_AEI_INFORMATION5 => P_AEI_INFORMATION5
141 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
142 );
143 PER_KR_EXTRA_AEI_RULES.CHK_DON_INSERT_UPDATE
144 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
145 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
146 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
147 ,P_AEI_INFORMATION12 => P_AEI_INFORMATION12
148 );
149 PER_KR_EXTRA_AEI_RULES.HOU_RENT_CONTRACT_DATES
150 (P_AEI_INFORMATION1 => P_AEI_INFORMATION1
151 ,P_ASSIGNMENT_EXTRA_INFO_ID => P_ASSIGNMENT_EXTRA_INFO_ID
152 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
153 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
154 ,P_AEI_INFORMATION3 => P_AEI_INFORMATION3
155 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
156 );
157 PER_KR_EXTRA_AEI_RULES.CHK_INVALID_DONATION
158 (P_AEI_INFORMATION1 => P_AEI_INFORMATION1
159 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
160 ,P_AEI_INFORMATION5 => P_AEI_INFORMATION5
161 ,P_AEI_INFORMATION12 => P_AEI_INFORMATION12
162 ,P_AEI_INFORMATION13 => P_AEI_INFORMATION13
163 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
164 );
165 PER_KR_EXTRA_AEI_RULES.CHK_TAX_REDUCTION_DATE
166 (P_AEI_INFORMATION1 => P_AEI_INFORMATION1
167 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
168 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
169 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
170 );
171 PER_KR_EXTRA_AEI_RULES.CHK_FW_TAX_REDUCTION_DATE
172 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
173 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
174 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
175 ,P_AEI_INFORMATION3 => P_AEI_INFORMATION3
176 );
177 elsif l_legislation_code = 'NL' then
178 PQP_NL_ABP_FUNCTIONS.CHK_DUP_ASG_INFO_ROW_INS
179 (P_ASSIGNMENT_EXTRA_INFO_ID => P_ASSIGNMENT_EXTRA_INFO_ID
180 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
181 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
182 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
183 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
184 ,P_AEI_INFORMATION3 => P_AEI_INFORMATION3
185 ,P_AEI_INFORMATION4 => P_AEI_INFORMATION4
186 ,P_AEI_INFORMATION5 => P_AEI_INFORMATION5
187 ,P_AEI_INFORMATION6 => P_AEI_INFORMATION6
188 ,P_AEI_INFORMATION7 => P_AEI_INFORMATION7
189 ,P_AEI_INFORMATION8 => P_AEI_INFORMATION8
190 ,P_AEI_INFORMATION9 => P_AEI_INFORMATION9
191 ,P_AEI_INFORMATION10 => P_AEI_INFORMATION10
192 ,P_AEI_INFORMATION11 => P_AEI_INFORMATION11
193 ,P_AEI_INFORMATION12 => P_AEI_INFORMATION12
194 ,P_AEI_INFORMATION13 => P_AEI_INFORMATION13
195 ,P_AEI_INFORMATION14 => P_AEI_INFORMATION14
196 ,P_AEI_INFORMATION15 => P_AEI_INFORMATION15
197 ,P_AEI_INFORMATION16 => P_AEI_INFORMATION16
198 ,P_AEI_INFORMATION20 => P_AEI_INFORMATION20
199 ,P_AEI_INFORMATION21 => P_AEI_INFORMATION21
200 ,P_AEI_INFORMATION22 => P_AEI_INFORMATION22
201 );
202 elsif l_legislation_code = 'SG' then
203 HR_SG_AEI_LEG_HOOK.CHK_IR8S_C_VALID
204 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
205 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
206 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
207 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
208 ,P_AEI_INFORMATION3 => P_AEI_INFORMATION3
209 ,P_AEI_INFORMATION4 => P_AEI_INFORMATION4
210 ,P_AEI_INFORMATION5 => P_AEI_INFORMATION5
211 ,P_AEI_INFORMATION6 => P_AEI_INFORMATION6
212 ,P_AEI_INFORMATION7 => P_AEI_INFORMATION7
213 ,P_AEI_INFORMATION8 => P_AEI_INFORMATION8
214 ,P_AEI_INFORMATION9 => P_AEI_INFORMATION9
215 ,P_AEI_INFORMATION10 => P_AEI_INFORMATION10
216 ,P_AEI_INFORMATION11 => P_AEI_INFORMATION11
217 );
218 HR_SG_AEI_LEG_HOOK.CHK_MULTI_CSN_VALID
219 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
220 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
221 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
222 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
223 ,P_AEI_INFORMATION3 => P_AEI_INFORMATION3
224 );
225 elsif l_legislation_code = 'US' then
226 PER_US_VALIDATE_AEI.CHK_FOR_DUPLICATE_ROWS
227 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
228 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
229 ,P_AEI_INFORMATION1 => P_AEI_INFORMATION1
230 ,P_AEI_INFORMATION2 => P_AEI_INFORMATION2
231 ,P_AEI_INFORMATION3 => P_AEI_INFORMATION3
232 );
233 GHR_SS_ASG_EIT.INS_PA_HISTORY_PROC
234 (P_ASSIGNMENT_EXTRA_INFO_ID => P_ASSIGNMENT_EXTRA_INFO_ID
235 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
236 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
237 );
238 end if;
239 end if;
240 hr_api.validate_commit_unit(l_commit_unit_number, 'PER_ASSIGNMENT_EXTRA_INFO', 'AI');
241 hr_utility.set_location(' Leaving: PE_AEI_RKI.AFTER_INSERT', 20);
242 end AFTER_INSERT;
243 end PE_AEI_RKI;