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_RKD

Source


1 package body PAY_ELE_RKD 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:12 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_DELETE
6 (P_EFFECTIVE_DATE in DATE
7 ,P_DATETRACK_MODE in VARCHAR2
8 ,P_VALIDATION_START_DATE in DATE
9 ,P_VALIDATION_END_DATE in DATE
10 ,P_ELEMENT_ENTRY_ID in NUMBER
11 ,P_EFFECTIVE_START_DATE in DATE
12 ,P_EFFECTIVE_END_DATE in DATE
13 ,P_EFFECTIVE_START_DATE_O in DATE
14 ,P_EFFECTIVE_END_DATE_O in DATE
15 ,P_COST_ALLOCATION_KEYFLEX_ID_O in NUMBER
16 ,P_ASSIGNMENT_ID_O in NUMBER
17 ,P_UPDATING_ACTION_ID_O in NUMBER
18 ,P_UPDATING_ACTION_TYPE_O in VARCHAR2
19 ,P_ELEMENT_LINK_ID_O in NUMBER
20 ,P_ORIGINAL_ENTRY_ID_O in NUMBER
21 ,P_CREATOR_TYPE_O in VARCHAR2
22 ,P_ENTRY_TYPE_O in VARCHAR2
23 ,P_COMMENT_ID_O in NUMBER
24 ,P_COMMENTS_O in VARCHAR2
25 ,P_CREATOR_ID_O in NUMBER
26 ,P_REASON_O in VARCHAR2
27 ,P_TARGET_ENTRY_ID_O in NUMBER
28 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
29 ,P_ATTRIBUTE1_O in VARCHAR2
30 ,P_ATTRIBUTE2_O in VARCHAR2
31 ,P_ATTRIBUTE3_O in VARCHAR2
32 ,P_ATTRIBUTE4_O in VARCHAR2
33 ,P_ATTRIBUTE5_O in VARCHAR2
34 ,P_ATTRIBUTE6_O in VARCHAR2
35 ,P_ATTRIBUTE7_O in VARCHAR2
36 ,P_ATTRIBUTE8_O in VARCHAR2
37 ,P_ATTRIBUTE9_O in VARCHAR2
38 ,P_ATTRIBUTE10_O in VARCHAR2
39 ,P_ATTRIBUTE11_O in VARCHAR2
40 ,P_ATTRIBUTE12_O in VARCHAR2
41 ,P_ATTRIBUTE13_O in VARCHAR2
42 ,P_ATTRIBUTE14_O in VARCHAR2
43 ,P_ATTRIBUTE15_O in VARCHAR2
44 ,P_ATTRIBUTE16_O in VARCHAR2
45 ,P_ATTRIBUTE17_O in VARCHAR2
46 ,P_ATTRIBUTE18_O in VARCHAR2
47 ,P_ATTRIBUTE19_O in VARCHAR2
48 ,P_ATTRIBUTE20_O in VARCHAR2
49 ,P_ENTRY_INFORMATION_CATEGORY_O in VARCHAR2
50 ,P_ENTRY_INFORMATION1_O in VARCHAR2
51 ,P_ENTRY_INFORMATION2_O in VARCHAR2
52 ,P_ENTRY_INFORMATION3_O in VARCHAR2
53 ,P_ENTRY_INFORMATION4_O in VARCHAR2
54 ,P_ENTRY_INFORMATION5_O in VARCHAR2
55 ,P_ENTRY_INFORMATION6_O in VARCHAR2
56 ,P_ENTRY_INFORMATION7_O in VARCHAR2
57 ,P_ENTRY_INFORMATION8_O in VARCHAR2
58 ,P_ENTRY_INFORMATION9_O in VARCHAR2
59 ,P_ENTRY_INFORMATION10_O in VARCHAR2
60 ,P_ENTRY_INFORMATION11_O in VARCHAR2
61 ,P_ENTRY_INFORMATION12_O in VARCHAR2
62 ,P_ENTRY_INFORMATION13_O in VARCHAR2
63 ,P_ENTRY_INFORMATION14_O in VARCHAR2
64 ,P_ENTRY_INFORMATION15_O in VARCHAR2
65 ,P_ENTRY_INFORMATION16_O in VARCHAR2
66 ,P_ENTRY_INFORMATION17_O in VARCHAR2
67 ,P_ENTRY_INFORMATION18_O in VARCHAR2
68 ,P_ENTRY_INFORMATION19_O in VARCHAR2
69 ,P_ENTRY_INFORMATION20_O in VARCHAR2
70 ,P_ENTRY_INFORMATION21_O in VARCHAR2
71 ,P_ENTRY_INFORMATION22_O in VARCHAR2
72 ,P_ENTRY_INFORMATION23_O in VARCHAR2
73 ,P_ENTRY_INFORMATION24_O in VARCHAR2
74 ,P_ENTRY_INFORMATION25_O in VARCHAR2
75 ,P_ENTRY_INFORMATION26_O in VARCHAR2
76 ,P_ENTRY_INFORMATION27_O in VARCHAR2
77 ,P_ENTRY_INFORMATION28_O in VARCHAR2
78 ,P_ENTRY_INFORMATION29_O in VARCHAR2
79 ,P_ENTRY_INFORMATION30_O in VARCHAR2
80 ,P_SUBPRIORITY_O in NUMBER
81 ,P_PERSONAL_PAYMENT_METHOD_ID_O in NUMBER
82 ,P_DATE_EARNED_O in DATE
83 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
84 ,P_SOURCE_ID_O in NUMBER
85 ,P_BALANCE_ADJ_COST_FLAG_O in VARCHAR2
86 ,P_ELEMENT_TYPE_ID_O in NUMBER
87 ,P_ALL_ENTRY_VALUES_NULL_O in VARCHAR2
88 )is
89 l_commit_unit_number number;
90 l_legislation_code   varchar2(30);
91 begin
92 hr_utility.set_location('Entering: PAY_ELE_RKD.AFTER_DELETE', 10);
93 l_commit_unit_number := hr_api.return_commit_unit;
94 if hr_api.call_app_hooks then
95 PAY_DYT_ELEMENT_ENTRIES_PKG.AFTER_DELETE
96 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
97 ,P_DATETRACK_MODE => P_DATETRACK_MODE
98 ,P_VALIDATION_START_DATE => P_VALIDATION_START_DATE
99 ,P_VALIDATION_END_DATE => P_VALIDATION_END_DATE
100 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
101 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
102 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
103 ,P_EFFECTIVE_START_DATE_O => P_EFFECTIVE_START_DATE_O
104 ,P_EFFECTIVE_END_DATE_O => P_EFFECTIVE_END_DATE_O
105 ,P_COST_ALLOCATION_KEYFLEX_ID_O => P_COST_ALLOCATION_KEYFLEX_ID_O
106 ,P_ASSIGNMENT_ID_O => P_ASSIGNMENT_ID_O
107 ,P_UPDATING_ACTION_ID_O => P_UPDATING_ACTION_ID_O
108 ,P_UPDATING_ACTION_TYPE_O => P_UPDATING_ACTION_TYPE_O
109 ,P_ELEMENT_LINK_ID_O => P_ELEMENT_LINK_ID_O
110 ,P_ORIGINAL_ENTRY_ID_O => P_ORIGINAL_ENTRY_ID_O
111 ,P_CREATOR_TYPE_O => P_CREATOR_TYPE_O
112 ,P_ENTRY_TYPE_O => P_ENTRY_TYPE_O
113 ,P_COMMENT_ID_O => P_COMMENT_ID_O
114 ,P_COMMENTS_O => P_COMMENTS_O
115 ,P_CREATOR_ID_O => P_CREATOR_ID_O
116 ,P_REASON_O => P_REASON_O
117 ,P_TARGET_ENTRY_ID_O => P_TARGET_ENTRY_ID_O
118 ,P_ATTRIBUTE_CATEGORY_O => P_ATTRIBUTE_CATEGORY_O
119 ,P_ATTRIBUTE1_O => P_ATTRIBUTE1_O
120 ,P_ATTRIBUTE2_O => P_ATTRIBUTE2_O
121 ,P_ATTRIBUTE3_O => P_ATTRIBUTE3_O
122 ,P_ATTRIBUTE4_O => P_ATTRIBUTE4_O
123 ,P_ATTRIBUTE5_O => P_ATTRIBUTE5_O
124 ,P_ATTRIBUTE6_O => P_ATTRIBUTE6_O
125 ,P_ATTRIBUTE7_O => P_ATTRIBUTE7_O
126 ,P_ATTRIBUTE8_O => P_ATTRIBUTE8_O
127 ,P_ATTRIBUTE9_O => P_ATTRIBUTE9_O
128 ,P_ATTRIBUTE10_O => P_ATTRIBUTE10_O
129 ,P_ATTRIBUTE11_O => P_ATTRIBUTE11_O
130 ,P_ATTRIBUTE12_O => P_ATTRIBUTE12_O
131 ,P_ATTRIBUTE13_O => P_ATTRIBUTE13_O
132 ,P_ATTRIBUTE14_O => P_ATTRIBUTE14_O
133 ,P_ATTRIBUTE15_O => P_ATTRIBUTE15_O
134 ,P_ATTRIBUTE16_O => P_ATTRIBUTE16_O
135 ,P_ATTRIBUTE17_O => P_ATTRIBUTE17_O
136 ,P_ATTRIBUTE18_O => P_ATTRIBUTE18_O
137 ,P_ATTRIBUTE19_O => P_ATTRIBUTE19_O
138 ,P_ATTRIBUTE20_O => P_ATTRIBUTE20_O
139 ,P_ENTRY_INFORMATION_CATEGORY_O => P_ENTRY_INFORMATION_CATEGORY_O
140 ,P_ENTRY_INFORMATION1_O => P_ENTRY_INFORMATION1_O
141 ,P_ENTRY_INFORMATION2_O => P_ENTRY_INFORMATION2_O
142 ,P_ENTRY_INFORMATION3_O => P_ENTRY_INFORMATION3_O
143 ,P_ENTRY_INFORMATION4_O => P_ENTRY_INFORMATION4_O
144 ,P_ENTRY_INFORMATION5_O => P_ENTRY_INFORMATION5_O
145 ,P_ENTRY_INFORMATION6_O => P_ENTRY_INFORMATION6_O
146 ,P_ENTRY_INFORMATION7_O => P_ENTRY_INFORMATION7_O
147 ,P_ENTRY_INFORMATION8_O => P_ENTRY_INFORMATION8_O
148 ,P_ENTRY_INFORMATION9_O => P_ENTRY_INFORMATION9_O
149 ,P_ENTRY_INFORMATION10_O => P_ENTRY_INFORMATION10_O
150 ,P_ENTRY_INFORMATION11_O => P_ENTRY_INFORMATION11_O
151 ,P_ENTRY_INFORMATION12_O => P_ENTRY_INFORMATION12_O
152 ,P_ENTRY_INFORMATION13_O => P_ENTRY_INFORMATION13_O
153 ,P_ENTRY_INFORMATION14_O => P_ENTRY_INFORMATION14_O
154 ,P_ENTRY_INFORMATION15_O => P_ENTRY_INFORMATION15_O
155 ,P_ENTRY_INFORMATION16_O => P_ENTRY_INFORMATION16_O
156 ,P_ENTRY_INFORMATION17_O => P_ENTRY_INFORMATION17_O
157 ,P_ENTRY_INFORMATION18_O => P_ENTRY_INFORMATION18_O
158 ,P_ENTRY_INFORMATION19_O => P_ENTRY_INFORMATION19_O
159 ,P_ENTRY_INFORMATION20_O => P_ENTRY_INFORMATION20_O
160 ,P_ENTRY_INFORMATION21_O => P_ENTRY_INFORMATION21_O
161 ,P_ENTRY_INFORMATION22_O => P_ENTRY_INFORMATION22_O
162 ,P_ENTRY_INFORMATION23_O => P_ENTRY_INFORMATION23_O
163 ,P_ENTRY_INFORMATION24_O => P_ENTRY_INFORMATION24_O
164 ,P_ENTRY_INFORMATION25_O => P_ENTRY_INFORMATION25_O
165 ,P_ENTRY_INFORMATION26_O => P_ENTRY_INFORMATION26_O
166 ,P_ENTRY_INFORMATION27_O => P_ENTRY_INFORMATION27_O
167 ,P_ENTRY_INFORMATION28_O => P_ENTRY_INFORMATION28_O
168 ,P_ENTRY_INFORMATION29_O => P_ENTRY_INFORMATION29_O
169 ,P_ENTRY_INFORMATION30_O => P_ENTRY_INFORMATION30_O
170 ,P_SUBPRIORITY_O => P_SUBPRIORITY_O
171 ,P_PERSONAL_PAYMENT_METHOD_ID_O => P_PERSONAL_PAYMENT_METHOD_ID_O
172 ,P_DATE_EARNED_O => P_DATE_EARNED_O
173 ,P_OBJECT_VERSION_NUMBER_O => P_OBJECT_VERSION_NUMBER_O
174 ,P_SOURCE_ID_O => P_SOURCE_ID_O
175 ,P_BALANCE_ADJ_COST_FLAG_O => P_BALANCE_ADJ_COST_FLAG_O
176 ,P_ELEMENT_TYPE_ID_O => P_ELEMENT_TYPE_ID_O
177 ,P_ALL_ENTRY_VALUES_NULL_O => P_ALL_ENTRY_VALUES_NULL_O
178 );
179 PSP_ENC_ASSIGNMENT_CHANGES.ELEMENT_ENTRIES_DELETES
180 (P_ASSIGNMENT_ID_O => P_ASSIGNMENT_ID_O
181 ,P_ELEMENT_LINK_ID_O => P_ELEMENT_LINK_ID_O
182 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
183 );
184 end if;
185 if hr_api.call_leg_hooks then
186 l_legislation_code := PER_ASG_BUS1.RETURN_LEGISLATION_CODE(P_ASSIGNMENT_ID => P_ASSIGNMENT_ID_O
187 );
188 if l_legislation_code = 'FR' then
189 PAY_FR_CPAM_PREPROCESSOR.CPAM_INFO_DELETE
190 (P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
191 ,P_ELEMENT_LINK_ID_O => P_ELEMENT_LINK_ID_O
192 ,P_EFFECTIVE_START_DATE_O => P_EFFECTIVE_START_DATE_O
193 ,P_ASSIGNMENT_ID_O => P_ASSIGNMENT_ID_O
194 ,P_DATETRACK_MODE => P_DATETRACK_MODE
195 );
196 elsif l_legislation_code = 'GB' then
197 PQP_GB_AD_EE.OPEN_CM_ELE_ENTRIES
198 (P_ASSIGNMENT_ID_O => P_ASSIGNMENT_ID_O
199 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
200 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
201 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
202 ,P_DATETRACK_MODE => P_DATETRACK_MODE
203 );
204 elsif l_legislation_code = 'IN' then
205 PER_IN_ENTRY_VALUE_LEG_HOOK.CHECK_ENTRY_VALUE_DEL
206 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
207 ,P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
208 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
209 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
210 ,P_ASSIGNMENT_ID_O => P_ASSIGNMENT_ID_O
211 ,P_ELEMENT_TYPE_ID_O => P_ELEMENT_TYPE_ID_O
212 );
213 elsif l_legislation_code = 'US' then
214 PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK
215 (P_ELEMENT_ENTRY_ID => P_ELEMENT_ENTRY_ID
216 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
217 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
218 ,P_ASSIGNMENT_ID_O => P_ASSIGNMENT_ID_O
219 ,P_ELEMENT_LINK_ID_O => P_ELEMENT_LINK_ID_O
220 ,P_ORIGINAL_ENTRY_ID_O => P_ORIGINAL_ENTRY_ID_O
221 ,P_CREATOR_TYPE_O => P_CREATOR_TYPE_O
222 ,P_ENTRY_TYPE_O => P_ENTRY_TYPE_O
223 ,P_ENTRY_INFORMATION_CATEGORY_O => P_ENTRY_INFORMATION_CATEGORY_O
224 );
225 end if;
226 end if;
227 hr_api.validate_commit_unit(l_commit_unit_number, 'PAY_ELEMENT_ENTRIES_F', 'AD');
228 hr_utility.set_location(' Leaving: PAY_ELE_RKD.AFTER_DELETE', 20);
229 end AFTER_DELETE;
230 end PAY_ELE_RKD;