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

Source


1 package body PAY_ELE_RKI as
2 /* $Header: pyelerhi.pkb 120.1 2005/05/30 05:19:19 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2013/08/13 18:47:10 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_INSERT
6 (P_EFFECTIVE_DATE in DATE
7 ,P_VALIDATION_START_DATE in DATE
8 ,P_VALIDATION_END_DATE in DATE
9 ,P_ELEMENT_ENTRY_ID in NUMBER
10 ,P_EFFECTIVE_START_DATE in DATE
11 ,P_EFFECTIVE_END_DATE in DATE
12 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
13 ,P_ASSIGNMENT_ID in NUMBER
14 ,P_UPDATING_ACTION_ID in NUMBER
15 ,P_UPDATING_ACTION_TYPE in VARCHAR2
16 ,P_ELEMENT_LINK_ID in NUMBER
17 ,P_ORIGINAL_ENTRY_ID in NUMBER
18 ,P_CREATOR_TYPE in VARCHAR2
19 ,P_ENTRY_TYPE in VARCHAR2
20 ,P_COMMENT_ID in NUMBER
21 ,P_COMMENTS in VARCHAR2
22 ,P_CREATOR_ID in NUMBER
23 ,P_REASON in VARCHAR2
24 ,P_TARGET_ENTRY_ID in NUMBER
25 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
26 ,P_ATTRIBUTE1 in VARCHAR2
27 ,P_ATTRIBUTE2 in VARCHAR2
28 ,P_ATTRIBUTE3 in VARCHAR2
29 ,P_ATTRIBUTE4 in VARCHAR2
30 ,P_ATTRIBUTE5 in VARCHAR2
31 ,P_ATTRIBUTE6 in VARCHAR2
32 ,P_ATTRIBUTE7 in VARCHAR2
33 ,P_ATTRIBUTE8 in VARCHAR2
34 ,P_ATTRIBUTE9 in VARCHAR2
35 ,P_ATTRIBUTE10 in VARCHAR2
36 ,P_ATTRIBUTE11 in VARCHAR2
37 ,P_ATTRIBUTE12 in VARCHAR2
38 ,P_ATTRIBUTE13 in VARCHAR2
39 ,P_ATTRIBUTE14 in VARCHAR2
40 ,P_ATTRIBUTE15 in VARCHAR2
41 ,P_ATTRIBUTE16 in VARCHAR2
42 ,P_ATTRIBUTE17 in VARCHAR2
43 ,P_ATTRIBUTE18 in VARCHAR2
44 ,P_ATTRIBUTE19 in VARCHAR2
45 ,P_ATTRIBUTE20 in VARCHAR2
46 ,P_ENTRY_INFORMATION_CATEGORY in VARCHAR2
47 ,P_ENTRY_INFORMATION1 in VARCHAR2
48 ,P_ENTRY_INFORMATION2 in VARCHAR2
49 ,P_ENTRY_INFORMATION3 in VARCHAR2
50 ,P_ENTRY_INFORMATION4 in VARCHAR2
51 ,P_ENTRY_INFORMATION5 in VARCHAR2
52 ,P_ENTRY_INFORMATION6 in VARCHAR2
53 ,P_ENTRY_INFORMATION7 in VARCHAR2
54 ,P_ENTRY_INFORMATION8 in VARCHAR2
55 ,P_ENTRY_INFORMATION9 in VARCHAR2
56 ,P_ENTRY_INFORMATION10 in VARCHAR2
57 ,P_ENTRY_INFORMATION11 in VARCHAR2
61 ,P_ENTRY_INFORMATION15 in VARCHAR2
58 ,P_ENTRY_INFORMATION12 in VARCHAR2
59 ,P_ENTRY_INFORMATION13 in VARCHAR2
60 ,P_ENTRY_INFORMATION14 in VARCHAR2
62 ,P_ENTRY_INFORMATION16 in VARCHAR2
63 ,P_ENTRY_INFORMATION17 in VARCHAR2
64 ,P_ENTRY_INFORMATION18 in VARCHAR2
65 ,P_ENTRY_INFORMATION19 in VARCHAR2
66 ,P_ENTRY_INFORMATION20 in VARCHAR2
67 ,P_ENTRY_INFORMATION21 in VARCHAR2
68 ,P_ENTRY_INFORMATION22 in VARCHAR2
69 ,P_ENTRY_INFORMATION23 in VARCHAR2
70 ,P_ENTRY_INFORMATION24 in VARCHAR2
71 ,P_ENTRY_INFORMATION25 in VARCHAR2
72 ,P_ENTRY_INFORMATION26 in VARCHAR2
73 ,P_ENTRY_INFORMATION27 in VARCHAR2
74 ,P_ENTRY_INFORMATION28 in VARCHAR2
75 ,P_ENTRY_INFORMATION29 in VARCHAR2
76 ,P_ENTRY_INFORMATION30 in VARCHAR2
77 ,P_SUBPRIORITY in NUMBER
78 ,P_PERSONAL_PAYMENT_METHOD_ID in NUMBER
79 ,P_DATE_EARNED in DATE
80 ,P_OBJECT_VERSION_NUMBER in NUMBER
81 ,P_SOURCE_ID in NUMBER
82 ,P_BALANCE_ADJ_COST_FLAG in VARCHAR2
83 ,P_ELEMENT_TYPE_ID in NUMBER
84 ,P_ALL_ENTRY_VALUES_NULL in VARCHAR2
85 )is
86 l_commit_unit_number number;
87 l_legislation_code   varchar2(30);
88 begin
89 hr_utility.set_location('Entering: PAY_ELE_RKI.AFTER_INSERT', 10);
90 l_commit_unit_number := hr_api.return_commit_unit;
91 if hr_api.call_app_hooks then
92 PAY_DYT_ELEMENT_ENTRIES_PKG.AFTER_INSERT
93 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
94 ,P_VALIDATION_START_DATE => P_VALIDATION_START_DATE
95 ,P_VALIDATION_END_DATE => P_VALIDATION_END_DATE
96 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
97 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
98 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
99 ,P_COST_ALLOCATION_KEYFLEX_ID => P_COST_ALLOCATION_KEYFLEX_ID
100 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
101 ,P_UPDATING_ACTION_ID => P_UPDATING_ACTION_ID
102 ,P_UPDATING_ACTION_TYPE => P_UPDATING_ACTION_TYPE
103 ,P_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID
104 ,P_ORIGINAL_ENTRY_ID => P_ORIGINAL_ENTRY_ID
105 ,P_CREATOR_TYPE => P_CREATOR_TYPE
106 ,P_ENTRY_TYPE => P_ENTRY_TYPE
107 ,P_COMMENT_ID => P_COMMENT_ID
108 ,P_COMMENTS => P_COMMENTS
109 ,P_CREATOR_ID => P_CREATOR_ID
110 ,P_REASON => P_REASON
111 ,P_TARGET_ENTRY_ID => P_TARGET_ENTRY_ID
112 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
113 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
114 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
115 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
116 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
117 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
118 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
119 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
120 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
121 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
122 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
123 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
124 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
125 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
126 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
127 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
128 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
129 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
130 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
131 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
132 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
133 ,P_ENTRY_INFORMATION_CATEGORY => P_ENTRY_INFORMATION_CATEGORY
134 ,P_ENTRY_INFORMATION1 => P_ENTRY_INFORMATION1
135 ,P_ENTRY_INFORMATION2 => P_ENTRY_INFORMATION2
136 ,P_ENTRY_INFORMATION3 => P_ENTRY_INFORMATION3
137 ,P_ENTRY_INFORMATION4 => P_ENTRY_INFORMATION4
138 ,P_ENTRY_INFORMATION5 => P_ENTRY_INFORMATION5
139 ,P_ENTRY_INFORMATION6 => P_ENTRY_INFORMATION6
140 ,P_ENTRY_INFORMATION7 => P_ENTRY_INFORMATION7
141 ,P_ENTRY_INFORMATION8 => P_ENTRY_INFORMATION8
142 ,P_ENTRY_INFORMATION9 => P_ENTRY_INFORMATION9
143 ,P_ENTRY_INFORMATION10 => P_ENTRY_INFORMATION10
144 ,P_ENTRY_INFORMATION11 => P_ENTRY_INFORMATION11
145 ,P_ENTRY_INFORMATION12 => P_ENTRY_INFORMATION12
146 ,P_ENTRY_INFORMATION13 => P_ENTRY_INFORMATION13
147 ,P_ENTRY_INFORMATION14 => P_ENTRY_INFORMATION14
148 ,P_ENTRY_INFORMATION15 => P_ENTRY_INFORMATION15
149 ,P_ENTRY_INFORMATION16 => P_ENTRY_INFORMATION16
150 ,P_ENTRY_INFORMATION17 => P_ENTRY_INFORMATION17
151 ,P_ENTRY_INFORMATION18 => P_ENTRY_INFORMATION18
152 ,P_ENTRY_INFORMATION19 => P_ENTRY_INFORMATION19
153 ,P_ENTRY_INFORMATION20 => P_ENTRY_INFORMATION20
154 ,P_ENTRY_INFORMATION21 => P_ENTRY_INFORMATION21
155 ,P_ENTRY_INFORMATION22 => P_ENTRY_INFORMATION22
156 ,P_ENTRY_INFORMATION23 => P_ENTRY_INFORMATION23
157 ,P_ENTRY_INFORMATION24 => P_ENTRY_INFORMATION24
158 ,P_ENTRY_INFORMATION25 => P_ENTRY_INFORMATION25
159 ,P_ENTRY_INFORMATION26 => P_ENTRY_INFORMATION26
160 ,P_ENTRY_INFORMATION27 => P_ENTRY_INFORMATION27
161 ,P_ENTRY_INFORMATION28 => P_ENTRY_INFORMATION28
162 ,P_ENTRY_INFORMATION29 => P_ENTRY_INFORMATION29
163 ,P_ENTRY_INFORMATION30 => P_ENTRY_INFORMATION30
164 ,P_SUBPRIORITY => P_SUBPRIORITY
165 ,P_PERSONAL_PAYMENT_METHOD_ID => P_PERSONAL_PAYMENT_METHOD_ID
166 ,P_DATE_EARNED => P_DATE_EARNED
167 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
168 ,P_SOURCE_ID => P_SOURCE_ID
169 ,P_BALANCE_ADJ_COST_FLAG => P_BALANCE_ADJ_COST_FLAG
170 ,P_ELEMENT_TYPE_ID => P_ELEMENT_TYPE_ID
171 ,P_ALL_ENTRY_VALUES_NULL => P_ALL_ENTRY_VALUES_NULL
172 );
173 PSP_ENC_ASSIGNMENT_CHANGES.ELEMENT_ENTRIES_INSERTS
174 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
175 ,P_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID
176 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
177 );
178 end if;
179 if hr_api.call_leg_hooks then
180 l_legislation_code := PER_ASG_BUS1.RETURN_LEGISLATION_CODE(P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
181 );
182 if l_legislation_code = 'AU' then
183 HR_AU_ELEMENT_ENTRY_HOOK.INSERT_ABSENCE_DEV_DESC_FLEX
184 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
185 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
186 ,P_CREATOR_TYPE => P_CREATOR_TYPE
187 ,P_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID
188 ,P_CREATOR_ID => P_CREATOR_ID
189 );
190 HR_AU_ELEMENT_ENTRY_HOOK.UPDATE_ELEMENT_ENTRY_VALUES
194 ,P_CREATOR_ID => P_CREATOR_ID
191 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
192 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
193 ,P_CREATOR_TYPE => P_CREATOR_TYPE
195 );
196 elsif l_legislation_code = 'CN' then
197 PAY_CN_ENTRY_VALUE_LEG_HOOK.CHECK_ENTRY_VALUE
198 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
199 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
200 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
201 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
202 ,P_ENTRY_INFORMATION2 => P_ENTRY_INFORMATION2
203 ,P_ENTRY_INFORMATION3 => P_ENTRY_INFORMATION3
204 ,P_ENTRY_INFORMATION4 => P_ENTRY_INFORMATION4
205 ,P_ENTRY_INFORMATION5 => P_ENTRY_INFORMATION5
206 ,P_ENTRY_INFORMATION6 => P_ENTRY_INFORMATION6
207 ,P_ENTRY_INFORMATION7 => P_ENTRY_INFORMATION7
208 ,P_ENTRY_INFORMATION8 => P_ENTRY_INFORMATION8
209 ,P_ENTRY_INFORMATION9 => P_ENTRY_INFORMATION9
210 );
211 elsif l_legislation_code = 'FR' then
212 PAY_FR_CPAM_PREPROCESSOR.CPAM_INFO_CREATE
213 (P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
214 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
215 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
216 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
217 ,P_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID
218 ,P_ENTRY_TYPE => P_ENTRY_TYPE
219 ,P_DATE_EARNED => P_DATE_EARNED
220 );
221 elsif l_legislation_code = 'GB' then
222 PQP_GB_AD_EE.CREATE_TERM_ELE_ENTRIES
223 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
224 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
225 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
226 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
227 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
228 ,P_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID
229 ,P_ELEMENT_TYPE_ID => P_ELEMENT_TYPE_ID
230 );
231 PQP_GB_AD_EE.UPDATE_PSI_ASS_DFF_COL
232 (P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
233 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
234 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
235 ,P_ELEMENT_TYPE_ID => P_ELEMENT_TYPE_ID
236 );
237 PQP_GB_AD_EE.AI_VAL_REF_COURT_ORDER
238 (P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
239 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
240 ,P_ELEMENT_TYPE_ID => P_ELEMENT_TYPE_ID
241 );
242 elsif l_legislation_code = 'IE' then
243 PAY_IE_PAYE_PKG.insert_element_entry
244 (P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
245 );
246 elsif l_legislation_code = 'IN' then
247 PER_IN_ENTRY_VALUE_LEG_HOOK.CHECK_80CCE_ENTRY
248 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
249 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
250 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
251 ,P_ELEMENT_TYPE_ID => P_ELEMENT_TYPE_ID
252 );
253 PER_IN_ENTRY_VALUE_LEG_HOOK.CHECK_ENTRY_VALUE
254 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
255 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
256 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
257 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
258 );
259 elsif l_legislation_code = 'US' then
260 PAY_US_ELEM_ENT_CHK_LEG_HOOK.CHK_ELEM_ENTRY
261 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
262 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
263 ,P_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID
264 );
265 GHR_BEN_VALIDATION.validate_create_element
266 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
267 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
268 ,P_VALIDATION_START_DATE => P_VALIDATION_START_DATE
269 ,P_VALIDATION_END_DATE => P_VALIDATION_END_DATE
270 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
271 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
272 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
273 ,P_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID
274 ,P_ELEMENT_TYPE_ID => P_ELEMENT_TYPE_ID
275 );
276 PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK
277 (P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
278 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
279 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
280 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
281 ,P_ELEMENT_LINK_ID => P_ELEMENT_LINK_ID
282 ,P_ORIGINAL_ENTRY_ID => P_ORIGINAL_ENTRY_ID
283 ,P_CREATOR_TYPE => P_CREATOR_TYPE
284 ,P_ENTRY_TYPE => P_ENTRY_TYPE
285 ,P_ENTRY_INFORMATION_CATEGORY => P_ENTRY_INFORMATION_CATEGORY
286 );
287 end if;
288 end if;
289 hr_api.validate_commit_unit(l_commit_unit_number, 'PAY_ELEMENT_ENTRIES_F', 'AI');
290 hr_utility.set_location(' Leaving: PAY_ELE_RKI.AFTER_INSERT', 20);
291 end AFTER_INSERT;
292 end PAY_ELE_RKI;