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_ELEMENT_ENTRY_BK1

Source


1 package body PAY_ELEMENT_ENTRY_BK1 as
2 /* $Header: pyeleapi.pkb 120.5.12010000.2 2008/10/01 06:13:22 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:53:58 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_ELEMENT_ENTRY_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_BUSINESS_GROUP_ID in NUMBER
8 ,P_ORIGINAL_ENTRY_ID in NUMBER
9 ,P_ASSIGNMENT_ID in NUMBER
10 ,P_ELEMENT_LINK_ID in NUMBER
11 ,P_ENTRY_TYPE in VARCHAR2
12 ,P_CREATOR_TYPE in VARCHAR2
13 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
14 ,P_UPDATING_ACTION_ID in NUMBER
15 ,P_UPDATING_ACTION_TYPE in VARCHAR2
16 ,P_COMMENT_ID in NUMBER
17 ,P_REASON in VARCHAR2
18 ,P_TARGET_ENTRY_ID in NUMBER
19 ,P_SUBPRIORITY in NUMBER
20 ,P_DATE_EARNED in DATE
21 ,P_PERSONAL_PAYMENT_METHOD_ID in NUMBER
22 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
23 ,P_ATTRIBUTE1 in VARCHAR2
24 ,P_ATTRIBUTE2 in VARCHAR2
25 ,P_ATTRIBUTE3 in VARCHAR2
26 ,P_ATTRIBUTE4 in VARCHAR2
27 ,P_ATTRIBUTE5 in VARCHAR2
28 ,P_ATTRIBUTE6 in VARCHAR2
29 ,P_ATTRIBUTE7 in VARCHAR2
30 ,P_ATTRIBUTE8 in VARCHAR2
31 ,P_ATTRIBUTE9 in VARCHAR2
32 ,P_ATTRIBUTE10 in VARCHAR2
33 ,P_ATTRIBUTE11 in VARCHAR2
34 ,P_ATTRIBUTE12 in VARCHAR2
35 ,P_ATTRIBUTE13 in VARCHAR2
36 ,P_ATTRIBUTE14 in VARCHAR2
37 ,P_ATTRIBUTE15 in VARCHAR2
38 ,P_ATTRIBUTE16 in VARCHAR2
39 ,P_ATTRIBUTE17 in VARCHAR2
40 ,P_ATTRIBUTE18 in VARCHAR2
41 ,P_ATTRIBUTE19 in VARCHAR2
42 ,P_ATTRIBUTE20 in VARCHAR2
43 ,P_INPUT_VALUE_ID1 in NUMBER
44 ,P_INPUT_VALUE_ID2 in NUMBER
45 ,P_INPUT_VALUE_ID3 in NUMBER
46 ,P_INPUT_VALUE_ID4 in NUMBER
47 ,P_INPUT_VALUE_ID5 in NUMBER
48 ,P_INPUT_VALUE_ID6 in NUMBER
49 ,P_INPUT_VALUE_ID7 in NUMBER
50 ,P_INPUT_VALUE_ID8 in NUMBER
51 ,P_INPUT_VALUE_ID9 in NUMBER
52 ,P_INPUT_VALUE_ID10 in NUMBER
53 ,P_INPUT_VALUE_ID11 in NUMBER
54 ,P_INPUT_VALUE_ID12 in NUMBER
55 ,P_INPUT_VALUE_ID13 in NUMBER
56 ,P_INPUT_VALUE_ID14 in NUMBER
57 ,P_INPUT_VALUE_ID15 in NUMBER
58 ,P_ENTRY_VALUE1 in VARCHAR2
59 ,P_ENTRY_VALUE2 in VARCHAR2
60 ,P_ENTRY_VALUE3 in VARCHAR2
61 ,P_ENTRY_VALUE4 in VARCHAR2
62 ,P_ENTRY_VALUE5 in VARCHAR2
63 ,P_ENTRY_VALUE6 in VARCHAR2
64 ,P_ENTRY_VALUE7 in VARCHAR2
65 ,P_ENTRY_VALUE8 in VARCHAR2
66 ,P_ENTRY_VALUE9 in VARCHAR2
67 ,P_ENTRY_VALUE10 in VARCHAR2
68 ,P_ENTRY_VALUE11 in VARCHAR2
69 ,P_ENTRY_VALUE12 in VARCHAR2
70 ,P_ENTRY_VALUE13 in VARCHAR2
71 ,P_ENTRY_VALUE14 in VARCHAR2
72 ,P_ENTRY_VALUE15 in VARCHAR2
73 ,P_ENTRY_INFORMATION_CATEGORY in VARCHAR2
74 ,P_ENTRY_INFORMATION1 in VARCHAR2
75 ,P_ENTRY_INFORMATION2 in VARCHAR2
76 ,P_ENTRY_INFORMATION3 in VARCHAR2
77 ,P_ENTRY_INFORMATION4 in VARCHAR2
78 ,P_ENTRY_INFORMATION5 in VARCHAR2
79 ,P_ENTRY_INFORMATION6 in VARCHAR2
80 ,P_ENTRY_INFORMATION7 in VARCHAR2
81 ,P_ENTRY_INFORMATION8 in VARCHAR2
82 ,P_ENTRY_INFORMATION9 in VARCHAR2
83 ,P_ENTRY_INFORMATION10 in VARCHAR2
84 ,P_ENTRY_INFORMATION11 in VARCHAR2
85 ,P_ENTRY_INFORMATION12 in VARCHAR2
86 ,P_ENTRY_INFORMATION13 in VARCHAR2
87 ,P_ENTRY_INFORMATION14 in VARCHAR2
88 ,P_ENTRY_INFORMATION15 in VARCHAR2
89 ,P_ENTRY_INFORMATION16 in VARCHAR2
90 ,P_ENTRY_INFORMATION17 in VARCHAR2
91 ,P_ENTRY_INFORMATION18 in VARCHAR2
92 ,P_ENTRY_INFORMATION19 in VARCHAR2
93 ,P_ENTRY_INFORMATION20 in VARCHAR2
94 ,P_ENTRY_INFORMATION21 in VARCHAR2
95 ,P_ENTRY_INFORMATION22 in VARCHAR2
96 ,P_ENTRY_INFORMATION23 in VARCHAR2
97 ,P_ENTRY_INFORMATION24 in VARCHAR2
98 ,P_ENTRY_INFORMATION25 in VARCHAR2
99 ,P_ENTRY_INFORMATION26 in VARCHAR2
100 ,P_ENTRY_INFORMATION27 in VARCHAR2
101 ,P_ENTRY_INFORMATION28 in VARCHAR2
102 ,P_ENTRY_INFORMATION29 in VARCHAR2
103 ,P_ENTRY_INFORMATION30 in VARCHAR2
104 ,P_OVERRIDE_USER_ENT_CHK in VARCHAR2
105 ,P_EFFECTIVE_START_DATE in DATE
106 ,P_EFFECTIVE_END_DATE in DATE
107 ,P_ELEMENT_ENTRY_ID in NUMBER
108 ,P_OBJECT_VERSION_NUMBER in NUMBER
109 ,P_CREATE_WARNING in BOOLEAN
110 )is
111 l_commit_unit_number number;
112 l_legislation_code   varchar2(30);
113 begin
114 hr_utility.set_location('Entering: PAY_ELEMENT_ENTRY_BK1.CREATE_ELEMENT_ENTRY_A', 10);
115 l_commit_unit_number := hr_api.return_commit_unit;
116 if hr_api.call_leg_hooks then
117 l_legislation_code := hr_api.return_legislation_code(p_business_group_id => P_BUSINESS_GROUP_ID);
118 if l_legislation_code = 'NO' then
119 HR_NO_VALIDATE_PKG.CREATE_ELE_ENTRY_AP
120 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
121 );
122 end if;
123 end if;
124 hr_multi_message.end_validation_set;
125 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_ELEMENT_ENTRY', 'AP');
126 hr_utility.set_location(' Leaving: PAY_ELEMENT_ENTRY_BK1.CREATE_ELEMENT_ENTRY_A', 20);
127 end CREATE_ELEMENT_ENTRY_A;
128 procedure CREATE_ELEMENT_ENTRY_B
129 (P_EFFECTIVE_DATE in DATE
130 ,P_BUSINESS_GROUP_ID in NUMBER
131 ,P_ORIGINAL_ENTRY_ID in NUMBER
132 ,P_ASSIGNMENT_ID in NUMBER
133 ,P_ELEMENT_LINK_ID in NUMBER
134 ,P_ENTRY_TYPE in VARCHAR2
135 ,P_CREATOR_TYPE in VARCHAR2
136 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
137 ,P_UPDATING_ACTION_ID in NUMBER
138 ,P_UPDATING_ACTION_TYPE in VARCHAR2
139 ,P_COMMENT_ID in NUMBER
140 ,P_REASON in VARCHAR2
141 ,P_TARGET_ENTRY_ID in NUMBER
142 ,P_SUBPRIORITY in NUMBER
143 ,P_DATE_EARNED in DATE
144 ,P_PERSONAL_PAYMENT_METHOD_ID in NUMBER
145 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
146 ,P_ATTRIBUTE1 in VARCHAR2
147 ,P_ATTRIBUTE2 in VARCHAR2
148 ,P_ATTRIBUTE3 in VARCHAR2
149 ,P_ATTRIBUTE4 in VARCHAR2
150 ,P_ATTRIBUTE5 in VARCHAR2
151 ,P_ATTRIBUTE6 in VARCHAR2
152 ,P_ATTRIBUTE7 in VARCHAR2
153 ,P_ATTRIBUTE8 in VARCHAR2
154 ,P_ATTRIBUTE9 in VARCHAR2
155 ,P_ATTRIBUTE10 in VARCHAR2
156 ,P_ATTRIBUTE11 in VARCHAR2
157 ,P_ATTRIBUTE12 in VARCHAR2
158 ,P_ATTRIBUTE13 in VARCHAR2
159 ,P_ATTRIBUTE14 in VARCHAR2
160 ,P_ATTRIBUTE15 in VARCHAR2
161 ,P_ATTRIBUTE16 in VARCHAR2
162 ,P_ATTRIBUTE17 in VARCHAR2
163 ,P_ATTRIBUTE18 in VARCHAR2
164 ,P_ATTRIBUTE19 in VARCHAR2
165 ,P_ATTRIBUTE20 in VARCHAR2
166 ,P_INPUT_VALUE_ID1 in NUMBER
167 ,P_INPUT_VALUE_ID2 in NUMBER
168 ,P_INPUT_VALUE_ID3 in NUMBER
169 ,P_INPUT_VALUE_ID4 in NUMBER
170 ,P_INPUT_VALUE_ID5 in NUMBER
171 ,P_INPUT_VALUE_ID6 in NUMBER
172 ,P_INPUT_VALUE_ID7 in NUMBER
173 ,P_INPUT_VALUE_ID8 in NUMBER
174 ,P_INPUT_VALUE_ID9 in NUMBER
175 ,P_INPUT_VALUE_ID10 in NUMBER
176 ,P_INPUT_VALUE_ID11 in NUMBER
177 ,P_INPUT_VALUE_ID12 in NUMBER
178 ,P_INPUT_VALUE_ID13 in NUMBER
179 ,P_INPUT_VALUE_ID14 in NUMBER
180 ,P_INPUT_VALUE_ID15 in NUMBER
181 ,P_ENTRY_VALUE1 in VARCHAR2
182 ,P_ENTRY_VALUE2 in VARCHAR2
183 ,P_ENTRY_VALUE3 in VARCHAR2
184 ,P_ENTRY_VALUE4 in VARCHAR2
185 ,P_ENTRY_VALUE5 in VARCHAR2
186 ,P_ENTRY_VALUE6 in VARCHAR2
187 ,P_ENTRY_VALUE7 in VARCHAR2
188 ,P_ENTRY_VALUE8 in VARCHAR2
189 ,P_ENTRY_VALUE9 in VARCHAR2
190 ,P_ENTRY_VALUE10 in VARCHAR2
191 ,P_ENTRY_VALUE11 in VARCHAR2
192 ,P_ENTRY_VALUE12 in VARCHAR2
193 ,P_ENTRY_VALUE13 in VARCHAR2
194 ,P_ENTRY_VALUE14 in VARCHAR2
195 ,P_ENTRY_VALUE15 in VARCHAR2
196 ,P_ENTRY_INFORMATION_CATEGORY in VARCHAR2
197 ,P_ENTRY_INFORMATION1 in VARCHAR2
198 ,P_ENTRY_INFORMATION2 in VARCHAR2
199 ,P_ENTRY_INFORMATION3 in VARCHAR2
200 ,P_ENTRY_INFORMATION4 in VARCHAR2
201 ,P_ENTRY_INFORMATION5 in VARCHAR2
202 ,P_ENTRY_INFORMATION6 in VARCHAR2
203 ,P_ENTRY_INFORMATION7 in VARCHAR2
204 ,P_ENTRY_INFORMATION8 in VARCHAR2
205 ,P_ENTRY_INFORMATION9 in VARCHAR2
206 ,P_ENTRY_INFORMATION10 in VARCHAR2
207 ,P_ENTRY_INFORMATION11 in VARCHAR2
208 ,P_ENTRY_INFORMATION12 in VARCHAR2
209 ,P_ENTRY_INFORMATION13 in VARCHAR2
210 ,P_ENTRY_INFORMATION14 in VARCHAR2
211 ,P_ENTRY_INFORMATION15 in VARCHAR2
212 ,P_ENTRY_INFORMATION16 in VARCHAR2
213 ,P_ENTRY_INFORMATION17 in VARCHAR2
214 ,P_ENTRY_INFORMATION18 in VARCHAR2
215 ,P_ENTRY_INFORMATION19 in VARCHAR2
216 ,P_ENTRY_INFORMATION20 in VARCHAR2
217 ,P_ENTRY_INFORMATION21 in VARCHAR2
218 ,P_ENTRY_INFORMATION22 in VARCHAR2
219 ,P_ENTRY_INFORMATION23 in VARCHAR2
220 ,P_ENTRY_INFORMATION24 in VARCHAR2
221 ,P_ENTRY_INFORMATION25 in VARCHAR2
222 ,P_ENTRY_INFORMATION26 in VARCHAR2
223 ,P_ENTRY_INFORMATION27 in VARCHAR2
224 ,P_ENTRY_INFORMATION28 in VARCHAR2
225 ,P_ENTRY_INFORMATION29 in VARCHAR2
226 ,P_ENTRY_INFORMATION30 in VARCHAR2
227 ,P_OVERRIDE_USER_ENT_CHK in VARCHAR2
228 )is
229 l_commit_unit_number number;
230 l_legislation_code   varchar2(30);
231 begin
232 hr_utility.set_location('Entering: PAY_ELEMENT_ENTRY_BK1.CREATE_ELEMENT_ENTRY_B', 10);
233 l_commit_unit_number := hr_api.return_commit_unit;
234 if hr_api.call_leg_hooks then
235 l_legislation_code := hr_api.return_legislation_code(p_business_group_id => P_BUSINESS_GROUP_ID);
236 if l_legislation_code = 'DE' then
237 HR_DE_VALIDATE_PKG.CREATE_ELEMENT_ENTRY_VALIDATE
238 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
239 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
240 ,P_ENTRY_INFORMATION_CATEGORY => P_ENTRY_INFORMATION_CATEGORY
241 ,P_ENTRY_INFORMATION1 => P_ENTRY_INFORMATION1
242 );
243 elsif l_legislation_code = 'NO' then
244 HR_NO_VALIDATE_PKG.CREATE_ELE_ENTRY_BP
245 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
246 );
247 end if;
248 end if;
249 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_ELEMENT_ENTRY', 'BP');
250 hr_utility.set_location(' Leaving: PAY_ELEMENT_ENTRY_BK1.CREATE_ELEMENT_ENTRY_B', 20);
251 end CREATE_ELEMENT_ENTRY_B;
252 end PAY_ELEMENT_ENTRY_BK1;