[Home] [Help]
PACKAGE BODY: APPS.PAY_JP_PROCESS_CMI_SS
Source
1 package body pay_jp_process_cmi_ss as
2 /* $Header: pyjpcmis.pkb 120.4 2012/01/19 10:07:16 rpahune ship $ */
3 --
4 c_varchar2 varchar2(10) := 'VARCHAR2';
5 c_date varchar2(10) := 'DATE';
6 c_number varchar2(10) := 'NUMBER';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |----------------------------< calc_car_amount >----------------------------|
10 -- ----------------------------------------------------------------------------
11 procedure calc_car_amount
12 (
13 p_business_group_id in number,
14 p_assignment_id in number,
15 p_effective_date in date,
16 --
17 p_attribute_category in varchar2 default null,
18 p_attribute1 in varchar2 default null,
19 p_attribute2 in varchar2 default null,
20 p_attribute3 in varchar2 default null,
21 p_attribute4 in varchar2 default null,
22 p_attribute5 in varchar2 default null,
23 p_attribute6 in varchar2 default null,
24 p_attribute7 in varchar2 default null,
25 p_attribute8 in varchar2 default null,
26 p_attribute9 in varchar2 default null,
27 p_attribute10 in varchar2 default null,
28 p_attribute11 in varchar2 default null,
29 p_attribute12 in varchar2 default null,
30 p_attribute13 in varchar2 default null,
31 p_attribute14 in varchar2 default null,
32 p_attribute15 in varchar2 default null,
33 p_attribute16 in varchar2 default null,
34 p_attribute17 in varchar2 default null,
35 p_attribute18 in varchar2 default null,
36 p_attribute19 in varchar2 default null,
37 p_attribute20 in varchar2 default null,
38 --
39 p_means_code in varchar2 default null,
40 p_vehicle_info_id in number default null,
41 p_period_code in varchar2 default null,
42 p_distance in number default null,
43 p_fuel_cost_code in varchar2 default null,
44 p_amount in number default null,
45 p_parking_fees in number default null,
46 p_equivalent_cost in number default null,
47 p_pay_start_month in varchar2 default null,
48 p_pay_end_month in varchar2 default null,
49 p_si_start_month_code in varchar2 default null,
50 p_update_date in date default null,
51 p_update_reason_code in varchar2 default null,
52 p_comments in varchar2 default null,
53 --
54 p_new_car_amount out nocopy number,
55 p_val_returned out nocopy number,
56 --
57 p_error_message out nocopy long
58 --
59 ) is
60 --
61 l_formula_id number;
62 --
63 l_ev_rec_tbl pay_jp_entries_pkg.ev_rec_tbl;
64 l_attribute_tbl pay_jp_entries_pkg.attribute_tbl;
65 --
66 l_new_car_amount varchar2(255);
67 l_val_returned boolean;
68 --
69 begin
70 --
71 l_formula_id :=
72 to_number(per_jp_cma_utility_pkg.bg_cma_formula_id(p_business_group_id));
73 --
74 if l_formula_id is not null then
75 --
76 l_ev_rec_tbl(1).entry_value := p_means_code;
77 l_ev_rec_tbl(2).entry_value := fnd_number.number_to_canonical(p_vehicle_info_id);
78 l_ev_rec_tbl(3).entry_value := p_period_code;
79 l_ev_rec_tbl(4).entry_value := fnd_number.number_to_canonical(p_distance);
80 l_ev_rec_tbl(5).entry_value := p_fuel_cost_code;
81 l_ev_rec_tbl(6).entry_value := fnd_number.number_to_canonical(p_amount);
82 l_ev_rec_tbl(7).entry_value := fnd_number.number_to_canonical(p_parking_fees);
83 l_ev_rec_tbl(8).entry_value := fnd_number.number_to_canonical(p_equivalent_cost);
84 l_ev_rec_tbl(9).entry_value := p_pay_start_month;
85 l_ev_rec_tbl(10).entry_value := p_pay_end_month;
86 l_ev_rec_tbl(11).entry_value := p_si_start_month_code;
87 l_ev_rec_tbl(12).entry_value := fnd_date.date_to_canonical(p_update_date);
88 l_ev_rec_tbl(13).entry_value := p_update_reason_code;
89 l_ev_rec_tbl(14).entry_value := p_comments;
90 l_ev_rec_tbl(15).entry_value := null;
91 --
92 l_attribute_tbl.attribute_category := p_attribute_category;
93 l_attribute_tbl.attribute(1) := p_attribute1;
94 l_attribute_tbl.attribute(2) := p_attribute2;
95 l_attribute_tbl.attribute(3) := p_attribute3;
96 l_attribute_tbl.attribute(4) := p_attribute4;
97 l_attribute_tbl.attribute(5) := p_attribute5;
98 l_attribute_tbl.attribute(6) := p_attribute6;
99 l_attribute_tbl.attribute(7) := p_attribute7;
100 l_attribute_tbl.attribute(8) := p_attribute8;
101 l_attribute_tbl.attribute(9) := p_attribute9;
102 l_attribute_tbl.attribute(10) := p_attribute10;
103 l_attribute_tbl.attribute(11) := p_attribute11;
104 l_attribute_tbl.attribute(12) := p_attribute12;
105 l_attribute_tbl.attribute(13) := p_attribute13;
106 l_attribute_tbl.attribute(14) := p_attribute14;
107 l_attribute_tbl.attribute(15) := p_attribute15;
108 l_attribute_tbl.attribute(16) := p_attribute16;
109 l_attribute_tbl.attribute(17) := p_attribute17;
110 l_attribute_tbl.attribute(18) := p_attribute18;
111 l_attribute_tbl.attribute(19) := p_attribute19;
112 l_attribute_tbl.attribute(20) := p_attribute20;
113 --
114 per_jp_cma_utility_pkg.calc_car_amount
115 (
116 p_formula_id => l_formula_id,
117 p_business_group_id => p_business_group_id,
118 p_assignment_id => p_assignment_id,
119 p_effective_date => p_effective_date,
120 p_ev_rec_tbl => l_ev_rec_tbl,
121 p_attribute_tbl => l_attribute_tbl,
122 p_outputs => l_new_car_amount,
123 p_val_returned => l_val_returned
124 );
125 --
126 if l_val_returned then
127 p_new_car_amount := to_number(l_new_car_amount);
128 p_val_returned := 1;
129 else
130 p_new_car_amount := 0;
131 p_val_returned := 0;
132 end if;
133 --
134 else
135 p_new_car_amount := 0;
136 p_val_returned := 0;
137 end if;
138 --
139 exception
140 --
141 when others then
142 p_error_message :=
143 hr_java_conv_util_ss.get_formatted_error_message;
144 --
145 end calc_car_amount;
146 --
147 --
148 -- ----------------------------------------------------------------------------
149 -- |--------------------------< set_transaction_step >-------------------------|
150 -- ----------------------------------------------------------------------------
151 procedure set_transaction_step
152 (
153 p_item_type in varchar2,
154 p_item_key in varchar2,
155 p_activity_id in number,
156 p_login_person_id in number,
157 --
158 p_commutation_type in varchar2, -- 'TRAIN' or 'CAR'
159 p_action_type in varchar2, -- 'INSERT' or 'UPDATE' or 'DELETE'
160 p_effective_date in date default null,
161 p_date_track_option in varchar2 default null,
162 p_element_entry_id in number default null,
163 p_business_group_id in number default null,
164 p_assignment_id in number default null,
165 p_element_link_id in number default null,
166 p_entry_type in varchar2 default null,
167 p_object_version_number in number default null,
168 --
169 p_attribute_category in varchar2 default null,
170 p_attribute1 in varchar2 default null,
171 p_attribute2 in varchar2 default null,
172 p_attribute3 in varchar2 default null,
173 p_attribute4 in varchar2 default null,
174 p_attribute5 in varchar2 default null,
175 p_attribute6 in varchar2 default null,
176 p_attribute7 in varchar2 default null,
177 p_attribute8 in varchar2 default null,
178 p_attribute9 in varchar2 default null,
179 p_attribute10 in varchar2 default null,
180 p_attribute11 in varchar2 default null,
181 p_attribute12 in varchar2 default null,
182 p_attribute13 in varchar2 default null,
183 p_attribute14 in varchar2 default null,
184 p_attribute15 in varchar2 default null,
185 p_attribute16 in varchar2 default null,
186 p_attribute17 in varchar2 default null,
187 p_attribute18 in varchar2 default null,
188 p_attribute19 in varchar2 default null,
189 p_attribute20 in varchar2 default null,
190 --
191 p_input_value_id1 in number default null,
192 p_input_value_id2 in number default null,
193 p_input_value_id3 in number default null,
194 p_input_value_id4 in number default null,
195 p_input_value_id5 in number default null,
196 p_input_value_id6 in number default null,
197 p_input_value_id7 in number default null,
198 p_input_value_id8 in number default null,
199 p_input_value_id9 in number default null,
200 p_input_value_id10 in number default null,
201 p_input_value_id11 in number default null,
202 p_input_value_id12 in number default null,
203 p_input_value_id13 in number default null,
204 p_input_value_id14 in number default null,
205 p_input_value_id15 in number default null,
206 --
207 p_entry_value1 in varchar2 default null,
208 p_entry_value2 in varchar2 default null,
209 p_entry_value3 in varchar2 default null,
210 p_entry_value4 in varchar2 default null,
211 p_entry_value5 in varchar2 default null,
212 p_entry_value6 in varchar2 default null,
213 p_entry_value7 in varchar2 default null,
214 p_entry_value8 in varchar2 default null,
215 p_entry_value9 in varchar2 default null,
216 p_entry_value10 in varchar2 default null,
217 p_entry_value11 in varchar2 default null,
218 p_entry_value12 in varchar2 default null,
219 p_entry_value13 in varchar2 default null,
220 p_entry_value14 in varchar2 default null,
221 p_entry_value15 in varchar2 default null,
222 --
223 p_error_message out nocopy long
224 --
225 ) is
226 --
227 l_date_format varchar2(10);
228 l_api_name varchar2(100);
229 --
230 l_transaction_table hr_transaction_ss.transaction_table;
231 l_count number := 0;
232 --
233 l_transaction_step_id number;
234 l_review_item_name varchar2(50);
235 --
236 begin
237 --
238 l_date_format := hr_transaction_ss.g_date_format;
239 l_api_name := 'PAY_JP_PROCESS_CMI_SS.PROCESS_API';
240 --
241 l_review_item_name :=
242 wf_engine.GetActivityAttrText
243 (
244 itemtype => p_item_type,
245 itemkey => p_item_key,
246 actid => p_activity_id,
247 aname => 'HR_REVIEW_REGION_ITEM'
248 );
249 --
250 l_count := l_count + 1;
251 l_transaction_table(l_count).param_name := 'P_REVIEW_PROC_CALL';
252 l_transaction_table(l_count).param_value := l_review_item_name;
253 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
254 --
255 l_count := l_count + 1;
256 l_transaction_table(l_count).param_name := 'P_REVIEW_ACTID';
257 l_transaction_table(l_count).param_value := p_activity_id;
258 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
259 --
260 l_count := l_count + 1;
261 l_transaction_table(l_count).param_name := 'P_COMMUTATION_TYPE';
262 l_transaction_table(l_count).param_value := p_commutation_type;
263 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
264 --
265 l_count := l_count + 1;
266 l_transaction_table(l_count).param_name := 'P_ACTION_TYPE';
267 l_transaction_table(l_count).param_value := p_action_type;
268 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
269 --
270 l_count := l_count + 1;
271 l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
272 l_transaction_table(l_count).param_value := to_char(p_effective_date, l_date_format);
273 l_transaction_table(l_count).param_data_type := 'DATE';
274 --
275 l_count := l_count + 1;
276 l_transaction_table(l_count).param_name := 'P_DATE_TRACK_OPTION';
277 l_transaction_table(l_count).param_value := p_date_track_option;
278 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
279 --
280 l_count := l_count + 1;
281 l_transaction_table(l_count).param_name := 'P_ELEMENT_ENTRY_ID';
282 l_transaction_table(l_count).param_value := p_element_entry_id;
283 l_transaction_table(l_count).param_data_type := 'NUMBER';
284 --
285 l_count := l_count + 1;
286 l_transaction_table(l_count).param_name := 'P_BUSINESS_GROUP_ID';
287 l_transaction_table(l_count).param_value := p_business_group_id;
288 l_transaction_table(l_count).param_data_type := 'NUMBER';
289 --
290 l_count := l_count + 1;
291 l_transaction_table(l_count).param_name := 'P_ASSIGNMENT_ID';
292 l_transaction_table(l_count).param_value := p_assignment_id;
293 l_transaction_table(l_count).param_data_type := 'NUMBER';
294 --
295 l_count := l_count + 1;
296 l_transaction_table(l_count).param_name := 'P_ELEMENT_LINK_ID';
297 l_transaction_table(l_count).param_value := p_element_link_id;
298 l_transaction_table(l_count).param_data_type := 'NUMBER';
299 --
300 l_count := l_count + 1;
301 l_transaction_table(l_count).param_name := 'P_ENTRY_TYPE';
302 l_transaction_table(l_count).param_value := p_entry_type;
303 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
304 --
305 l_count := l_count + 1;
306 l_transaction_table(l_count).param_name := 'P_OBJECT_VERSION_NUMBER';
307 l_transaction_table(l_count).param_value := p_object_version_number;
308 l_transaction_table(l_count).param_data_type := 'NUMBER';
309 --
310 l_count := l_count + 1;
311 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_CATEGORY';
312 l_transaction_table(l_count).param_value := p_attribute_category;
313 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
314 --
315 l_count := l_count + 1;
316 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE1';
317 l_transaction_table(l_count).param_value := p_attribute1;
318 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
319 --
320 l_count := l_count + 1;
321 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE2';
322 l_transaction_table(l_count).param_value := p_attribute2;
323 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
324 --
325 l_count := l_count + 1;
326 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE3';
327 l_transaction_table(l_count).param_value := p_attribute3;
328 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
329 --
330 l_count := l_count + 1;
331 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE4';
332 l_transaction_table(l_count).param_value := p_attribute4;
333 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
334 --
335 l_count := l_count + 1;
336 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE5';
337 l_transaction_table(l_count).param_value := p_attribute5;
338 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
339 --
340 l_count := l_count + 1;
341 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE6';
342 l_transaction_table(l_count).param_value := p_attribute6;
343 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
344 --
345 l_count := l_count + 1;
346 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE7';
347 l_transaction_table(l_count).param_value := p_attribute7;
348 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
349 --
350 l_count := l_count + 1;
351 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE8';
352 l_transaction_table(l_count).param_value := p_attribute8;
353 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
354 --
355 l_count := l_count + 1;
356 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE9';
357 l_transaction_table(l_count).param_value := p_attribute9;
358 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
359 --
360 l_count := l_count + 1;
361 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE10';
362 l_transaction_table(l_count).param_value := p_attribute10;
363 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
364 --
365 l_count := l_count + 1;
366 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE11';
367 l_transaction_table(l_count).param_value := p_attribute11;
368 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
369 --
370 l_count := l_count + 1;
371 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE12';
372 l_transaction_table(l_count).param_value := p_attribute12;
373 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
374 --
375 l_count := l_count + 1;
376 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE13';
377 l_transaction_table(l_count).param_value := p_attribute13;
378 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
379 --
380 l_count := l_count + 1;
381 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE14';
382 l_transaction_table(l_count).param_value := p_attribute14;
383 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
384 --
385 l_count := l_count + 1;
386 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE15';
387 l_transaction_table(l_count).param_value := p_attribute15;
388 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
389 --
390 l_count := l_count + 1;
391 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE16';
392 l_transaction_table(l_count).param_value := p_attribute16;
393 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
394 --
395 l_count := l_count + 1;
396 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE17';
397 l_transaction_table(l_count).param_value := p_attribute17;
398 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
399 --
400 l_count := l_count + 1;
401 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE18';
402 l_transaction_table(l_count).param_value := p_attribute18;
403 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
404 --
405 l_count := l_count + 1;
406 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE19';
407 l_transaction_table(l_count).param_value := p_attribute19;
408 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
409 --
410 l_count := l_count + 1;
411 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE20';
412 l_transaction_table(l_count).param_value := p_attribute20;
413 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
414 --
415 l_count := l_count + 1;
416 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID1';
417 l_transaction_table(l_count).param_value := p_input_value_id1;
418 l_transaction_table(l_count).param_data_type := 'NUMBER';
419 --
420 l_count := l_count + 1;
421 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID2';
422 l_transaction_table(l_count).param_value := p_input_value_id2;
423 l_transaction_table(l_count).param_data_type := 'NUMBER';
424 --
425 l_count := l_count + 1;
426 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID3';
427 l_transaction_table(l_count).param_value := p_input_value_id3;
428 l_transaction_table(l_count).param_data_type := 'NUMBER';
429 --
430 l_count := l_count + 1;
431 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID4';
432 l_transaction_table(l_count).param_value := p_input_value_id4;
433 l_transaction_table(l_count).param_data_type := 'NUMBER';
434 --
435 l_count := l_count + 1;
436 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID5';
437 l_transaction_table(l_count).param_value := p_input_value_id5;
438 l_transaction_table(l_count).param_data_type := 'NUMBER';
439 --
440 l_count := l_count + 1;
441 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID6';
442 l_transaction_table(l_count).param_value := p_input_value_id6;
443 l_transaction_table(l_count).param_data_type := 'NUMBER';
444 --
445 l_count := l_count + 1;
446 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID7';
447 l_transaction_table(l_count).param_value := p_input_value_id7;
448 l_transaction_table(l_count).param_data_type := 'NUMBER';
449 --
450 l_count := l_count + 1;
451 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID8';
452 l_transaction_table(l_count).param_value := p_input_value_id8;
453 l_transaction_table(l_count).param_data_type := 'NUMBER';
454 --
455 l_count := l_count + 1;
456 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID9';
457 l_transaction_table(l_count).param_value := p_input_value_id9;
458 l_transaction_table(l_count).param_data_type := 'NUMBER';
459 --
460 l_count := l_count + 1;
461 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID10';
462 l_transaction_table(l_count).param_value := p_input_value_id10;
463 l_transaction_table(l_count).param_data_type := 'NUMBER';
464 --
465 l_count := l_count + 1;
466 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID11';
467 l_transaction_table(l_count).param_value := p_input_value_id11;
468 l_transaction_table(l_count).param_data_type := 'NUMBER';
469 --
470 l_count := l_count + 1;
471 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID12';
472 l_transaction_table(l_count).param_value := p_input_value_id12;
473 l_transaction_table(l_count).param_data_type := 'NUMBER';
474 --
475 l_count := l_count + 1;
476 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID13';
477 l_transaction_table(l_count).param_value := p_input_value_id13;
478 l_transaction_table(l_count).param_data_type := 'NUMBER';
479 --
480 l_count := l_count + 1;
481 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID14';
482 l_transaction_table(l_count).param_value := p_input_value_id14;
483 l_transaction_table(l_count).param_data_type := 'NUMBER';
484 --
485 l_count := l_count + 1;
486 l_transaction_table(l_count).param_name := 'P_INPUT_VALUE_ID15';
487 l_transaction_table(l_count).param_value := p_input_value_id15;
488 l_transaction_table(l_count).param_data_type := 'NUMBER';
489 --
490 l_count := l_count + 1;
491 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE1';
492 l_transaction_table(l_count).param_value := p_entry_value1;
493 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
494 --
495 l_count := l_count + 1;
496 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE2';
497 l_transaction_table(l_count).param_value := p_entry_value2;
498 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
499 --
500 l_count := l_count + 1;
501 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE3';
502 l_transaction_table(l_count).param_value := p_entry_value3;
503 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
504 --
505 l_count := l_count + 1;
506 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE4';
507 l_transaction_table(l_count).param_value := p_entry_value4;
508 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
509 --
510 l_count := l_count + 1;
511 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE5';
512 l_transaction_table(l_count).param_value := p_entry_value5;
513 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
514 --
515 l_count := l_count + 1;
516 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE6';
517 l_transaction_table(l_count).param_value := p_entry_value6;
518 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
519 --
520 l_count := l_count + 1;
521 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE7';
522 l_transaction_table(l_count).param_value := p_entry_value7;
523 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
524 --
525 l_count := l_count + 1;
526 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE8';
527 l_transaction_table(l_count).param_value := p_entry_value8;
528 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
529 --
530 l_count := l_count + 1;
531 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE9';
532 l_transaction_table(l_count).param_value := p_entry_value9;
533 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
534 --
535 l_count := l_count + 1;
536 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE10';
537 l_transaction_table(l_count).param_value := p_entry_value10;
538 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
539 --
540 l_count := l_count + 1;
541 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE11';
542 l_transaction_table(l_count).param_value := p_entry_value11;
543 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
544 --
545 l_count := l_count + 1;
546 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE12';
547 l_transaction_table(l_count).param_value := p_entry_value12;
548 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
549 --
550 l_count := l_count + 1;
551 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE13';
552 l_transaction_table(l_count).param_value := p_entry_value13;
553 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
554 --
555 l_count := l_count + 1;
556 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE14';
557 l_transaction_table(l_count).param_value := p_entry_value14;
558 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
559 --
560 l_count := l_count + 1;
561 l_transaction_table(l_count).param_name := 'P_ENTRY_VALUE15';
562 l_transaction_table(l_count).param_value := p_entry_value15;
563 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
564 --
565 hr_transaction_ss.save_transaction_step
566 (
567 p_item_type => p_item_type,
568 p_item_key => p_item_key,
569 p_actid => p_activity_id,
570 p_login_person_id => p_login_person_id,
571 p_transaction_step_id => l_transaction_step_id,
572 p_api_name => l_api_name,
573 p_transaction_data => l_transaction_table
574 );
575 --
576 exception
577 --
578 when others then
579 p_error_message :=
580 hr_java_conv_util_ss.get_formatted_error_message;
581 --
582 end set_transaction_step;
583 --
584 -- ----------------------------------------------------------------------------
585 -- |-----------------------< set_train_transaction_step >----------------------|
586 -- ----------------------------------------------------------------------------
587 procedure set_train_transaction_step
588 (
589 --
590 p_item_type in varchar2,
591 p_item_key in varchar2,
592 p_activity_id in number,
593 p_login_person_id in number,
594 --
595 p_action_type in varchar2,
596 p_effective_date in date default null,
597 p_date_track_option in varchar2 default null,
598 p_element_entry_id in number default null,
599 p_business_group_id in number default null,
600 p_assignment_id in number default null,
601 p_element_link_id in number default null,
602 p_entry_type in varchar2 default null,
603 p_object_version_number in number default null,
604 --
605 p_attribute_category in varchar2 default null,
606 p_attribute1 in varchar2 default null,
607 p_attribute2 in varchar2 default null,
608 p_attribute3 in varchar2 default null,
609 p_attribute4 in varchar2 default null,
610 p_attribute5 in varchar2 default null,
611 p_attribute6 in varchar2 default null,
612 p_attribute7 in varchar2 default null,
613 p_attribute8 in varchar2 default null,
614 p_attribute9 in varchar2 default null,
615 p_attribute10 in varchar2 default null,
616 p_attribute11 in varchar2 default null,
617 p_attribute12 in varchar2 default null,
618 p_attribute13 in varchar2 default null,
619 p_attribute14 in varchar2 default null,
620 p_attribute15 in varchar2 default null,
621 p_attribute16 in varchar2 default null,
622 p_attribute17 in varchar2 default null,
623 p_attribute18 in varchar2 default null,
624 p_attribute19 in varchar2 default null,
625 p_attribute20 in varchar2 default null,
626 --
627 p_input_value_id1 in number default null,
628 p_input_value_id2 in number default null,
629 p_input_value_id3 in number default null,
630 p_input_value_id4 in number default null,
631 p_input_value_id5 in number default null,
632 p_input_value_id6 in number default null,
633 p_input_value_id7 in number default null,
634 p_input_value_id8 in number default null,
635 p_input_value_id9 in number default null,
636 p_input_value_id10 in number default null,
637 p_input_value_id11 in number default null,
638 p_input_value_id12 in number default null,
639 p_input_value_id13 in number default null,
640 --
641 p_means_code in varchar2 default null,
642 p_departure_place in varchar2 default null,
643 p_arrival_place in varchar2 default null,
644 p_via in varchar2 default null,
645 p_period_code in varchar2 default null,
646 p_payment_option_code in varchar2 default null,
647 p_amount in number default null,
648 p_pay_start_month in varchar2 default null,
649 p_pay_end_month in varchar2 default null,
650 p_si_start_month_code in varchar2 default null,
651 p_update_date in date default null,
652 p_update_reason_code in varchar2 default null,
653 p_comments in varchar2 default null,
654 --
655 p_error_message out nocopy long
656 --
657 ) is
658 begin
659 --
660 set_transaction_step
661 (
662 --
663 p_item_type => p_item_type,
664 p_item_key => p_item_key,
665 p_activity_id => p_activity_id,
666 p_login_person_id => p_login_person_id,
667 --
668 p_commutation_type => 'TRAIN',
669 p_action_type => p_action_type,
670 p_effective_date => p_effective_date,
671 p_date_track_option => p_date_track_option,
672 p_element_entry_id => p_element_entry_id,
673 p_business_group_id => p_business_group_id,
674 p_assignment_id => p_assignment_id,
675 p_element_link_id => p_element_link_id,
676 p_entry_type => p_entry_type,
677 p_object_version_number => p_object_version_number,
678 --
679 p_attribute_category => p_attribute_category,
680 p_attribute1 => p_attribute1,
681 p_attribute2 => p_attribute2,
682 p_attribute3 => p_attribute3,
683 p_attribute4 => p_attribute4,
684 p_attribute5 => p_attribute5,
685 p_attribute6 => p_attribute6,
686 p_attribute7 => p_attribute7,
687 p_attribute8 => p_attribute8,
688 p_attribute9 => p_attribute9,
689 p_attribute10 => p_attribute10,
690 p_attribute11 => p_attribute11,
691 p_attribute12 => p_attribute12,
692 p_attribute13 => p_attribute13,
693 p_attribute14 => p_attribute14,
694 p_attribute15 => p_attribute15,
695 p_attribute16 => p_attribute16,
696 p_attribute17 => p_attribute17,
697 p_attribute18 => p_attribute18,
698 p_attribute19 => p_attribute19,
699 p_attribute20 => p_attribute20,
700 --
701 p_input_value_id1 => p_input_value_id1,
702 p_input_value_id2 => p_input_value_id2,
703 p_input_value_id3 => p_input_value_id3,
704 p_input_value_id4 => p_input_value_id4,
705 p_input_value_id5 => p_input_value_id5,
706 p_input_value_id6 => p_input_value_id6,
707 p_input_value_id7 => p_input_value_id7,
708 p_input_value_id8 => p_input_value_id8,
709 p_input_value_id9 => p_input_value_id9,
710 p_input_value_id10 => p_input_value_id10,
711 p_input_value_id11 => p_input_value_id11,
712 p_input_value_id12 => p_input_value_id12,
713 p_input_value_id13 => p_input_value_id13,
714 p_input_value_id14 => null,
715 p_input_value_id15 => null,
716 --
717 p_entry_value1 => p_means_code,
718 p_entry_value2 => p_departure_place,
719 p_entry_value3 => p_arrival_place,
720 p_entry_value4 => p_via,
721 p_entry_value5 => p_period_code,
722 p_entry_value6 => p_payment_option_code,
723 p_entry_value7 => fnd_number.number_to_canonical(p_amount),
724 p_entry_value8 => p_pay_start_month,
725 p_entry_value9 => p_pay_end_month,
726 p_entry_value10 => p_si_start_month_code,
727 p_entry_value11 => fnd_date.date_to_canonical(p_update_date),
728 p_entry_value12 => p_update_reason_code,
729 p_entry_value13 => p_comments,
730 p_entry_value14 => null,
731 p_entry_value15 => null,
732 --
733 p_error_message => p_error_message
734 --
735 );
736 --
737 end set_train_transaction_step;
738 --
739 -- ----------------------------------------------------------------------------
740 -- |------------------------< set_car_transaction_step >-----------------------|
741 -- ----------------------------------------------------------------------------
742 procedure set_car_transaction_step
743 (
744 --
745 p_item_type in varchar2,
746 p_item_key in varchar2,
747 p_activity_id in number,
748 p_login_person_id in number,
749 --
750 p_action_type in varchar2,
751 p_effective_date in date default null,
752 p_date_track_option in varchar2 default null,
753 p_element_entry_id in number default null,
754 p_business_group_id in number default null,
755 p_assignment_id in number default null,
756 p_element_link_id in number default null,
757 p_entry_type in varchar2 default null,
758 p_object_version_number in number default null,
759 --
760 p_attribute_category in varchar2 default null,
761 p_attribute1 in varchar2 default null,
762 p_attribute2 in varchar2 default null,
763 p_attribute3 in varchar2 default null,
764 p_attribute4 in varchar2 default null,
765 p_attribute5 in varchar2 default null,
766 p_attribute6 in varchar2 default null,
767 p_attribute7 in varchar2 default null,
768 p_attribute8 in varchar2 default null,
769 p_attribute9 in varchar2 default null,
770 p_attribute10 in varchar2 default null,
771 p_attribute11 in varchar2 default null,
772 p_attribute12 in varchar2 default null,
773 p_attribute13 in varchar2 default null,
774 p_attribute14 in varchar2 default null,
775 p_attribute15 in varchar2 default null,
776 p_attribute16 in varchar2 default null,
777 p_attribute17 in varchar2 default null,
778 p_attribute18 in varchar2 default null,
779 p_attribute19 in varchar2 default null,
780 p_attribute20 in varchar2 default null,
781 --
782 p_input_value_id1 in number default null,
783 p_input_value_id2 in number default null,
784 p_input_value_id3 in number default null,
785 p_input_value_id4 in number default null,
786 p_input_value_id5 in number default null,
787 p_input_value_id6 in number default null,
788 p_input_value_id7 in number default null,
789 p_input_value_id8 in number default null,
790 p_input_value_id9 in number default null,
791 p_input_value_id10 in number default null,
792 p_input_value_id11 in number default null,
793 p_input_value_id12 in number default null,
794 p_input_value_id13 in number default null,
795 p_input_value_id14 in number default null,
796 --
797 p_means_code in varchar2 default null,
798 p_vehicle_info_id in number default null,
799 p_period_code in varchar2 default null,
800 p_distance in number default null,
801 p_fuel_cost_code in varchar2 default null,
802 p_amount in number default null,
803 p_parking_fees in number default null,
804 p_equivalent_cost in number default null,
805 p_pay_start_month in varchar2 default null,
806 p_pay_end_month in varchar2 default null,
807 p_si_start_month_code in varchar2 default null,
808 p_update_date in date default null,
809 p_update_reason_code in varchar2 default null,
810 p_comments in varchar2 default null,
811 --
812 p_error_message out nocopy long
813 --
814 ) is
815 begin
816 --
817 set_transaction_step
818 (
819 p_item_type => p_item_type,
820 p_item_key => p_item_key,
821 p_activity_id => p_activity_id,
822 p_login_person_id => p_login_person_id,
823 --
824 p_commutation_type => 'CAR',
825 p_action_type => p_action_type,
826 p_effective_date => p_effective_date,
827 p_date_track_option => p_date_track_option,
828 p_element_entry_id => p_element_entry_id,
829 p_business_group_id => p_business_group_id,
830 p_assignment_id => p_assignment_id,
831 p_element_link_id => p_element_link_id,
832 p_entry_type => p_entry_type,
833 p_object_version_number => p_object_version_number,
834 --
835 p_attribute_category => p_attribute_category,
836 p_attribute1 => p_attribute1,
837 p_attribute2 => p_attribute2,
838 p_attribute3 => p_attribute3,
839 p_attribute4 => p_attribute4,
840 p_attribute5 => p_attribute5,
841 p_attribute6 => p_attribute6,
842 p_attribute7 => p_attribute7,
843 p_attribute8 => p_attribute8,
844 p_attribute9 => p_attribute9,
845 p_attribute10 => p_attribute10,
846 p_attribute11 => p_attribute11,
847 p_attribute12 => p_attribute12,
848 p_attribute13 => p_attribute13,
849 p_attribute14 => p_attribute14,
850 p_attribute15 => p_attribute15,
851 p_attribute16 => p_attribute16,
852 p_attribute17 => p_attribute17,
853 p_attribute18 => p_attribute18,
854 p_attribute19 => p_attribute19,
855 p_attribute20 => p_attribute20,
856 --
857 p_input_value_id1 => p_input_value_id1,
858 p_input_value_id2 => p_input_value_id2,
859 p_input_value_id3 => p_input_value_id3,
860 p_input_value_id4 => p_input_value_id4,
861 p_input_value_id5 => p_input_value_id5,
862 p_input_value_id6 => p_input_value_id6,
863 p_input_value_id7 => p_input_value_id7,
864 p_input_value_id8 => p_input_value_id8,
865 p_input_value_id9 => p_input_value_id9,
866 p_input_value_id10 => p_input_value_id10,
867 p_input_value_id11 => p_input_value_id11,
868 p_input_value_id12 => p_input_value_id12,
869 p_input_value_id13 => p_input_value_id13,
870 p_input_value_id14 => p_input_value_id14,
871 p_input_value_id15 => null,
872 --
873 p_entry_value1 => p_means_code,
874 p_entry_value2 => fnd_number.number_to_canonical(p_vehicle_info_id),
875 p_entry_value3 => p_period_code,
876 p_entry_value4 => fnd_number.number_to_canonical(p_distance),
877 p_entry_value5 => p_fuel_cost_code,
878 p_entry_value6 => fnd_number.number_to_canonical(p_amount),
879 p_entry_value7 => fnd_number.number_to_canonical(p_parking_fees),
880 p_entry_value8 => fnd_number.number_to_canonical(p_equivalent_cost),
881 p_entry_value9 => p_pay_start_month,
882 p_entry_value10 => p_pay_end_month,
883 p_entry_value11 => p_si_start_month_code,
884 p_entry_value12 => fnd_date.date_to_canonical(p_update_date),
885 p_entry_value13 => p_update_reason_code,
886 p_entry_value14 => p_comments,
887 p_entry_value15 => null,
888 --
889 p_error_message => p_error_message
890 --
891 );
892 --
893 end set_car_transaction_step;
894 --
895 -- ----------------------------------------------------------------------------
896 -- |---------------------------< create_train_entry >--------------------------|
897 -- ----------------------------------------------------------------------------
898 procedure create_train_entry
899 (
900 --
901 p_validate in number default 0,
902 --
903 p_effective_date in date,
904 p_business_group_id in number,
905 p_assignment_id in number,
906 p_element_link_id in number,
907 p_entry_type in varchar2,
908 --
909 p_attribute_category in varchar2 default null,
910 p_attribute1 in varchar2 default null,
911 p_attribute2 in varchar2 default null,
912 p_attribute3 in varchar2 default null,
913 p_attribute4 in varchar2 default null,
914 p_attribute5 in varchar2 default null,
915 p_attribute6 in varchar2 default null,
916 p_attribute7 in varchar2 default null,
917 p_attribute8 in varchar2 default null,
918 p_attribute9 in varchar2 default null,
919 p_attribute10 in varchar2 default null,
920 p_attribute11 in varchar2 default null,
921 p_attribute12 in varchar2 default null,
922 p_attribute13 in varchar2 default null,
923 p_attribute14 in varchar2 default null,
924 p_attribute15 in varchar2 default null,
925 p_attribute16 in varchar2 default null,
926 p_attribute17 in varchar2 default null,
927 p_attribute18 in varchar2 default null,
928 p_attribute19 in varchar2 default null,
929 p_attribute20 in varchar2 default null,
930 --
931 p_input_value_id1 in number default null,
932 p_input_value_id2 in number default null,
933 p_input_value_id3 in number default null,
934 p_input_value_id4 in number default null,
935 p_input_value_id5 in number default null,
936 p_input_value_id6 in number default null,
937 p_input_value_id7 in number default null,
938 p_input_value_id8 in number default null,
939 p_input_value_id9 in number default null,
940 p_input_value_id10 in number default null,
941 p_input_value_id11 in number default null,
942 p_input_value_id12 in number default null,
943 p_input_value_id13 in number default null,
944 --
945 p_means_code in varchar2 default null,
946 p_departure_place in varchar2 default null,
947 p_arrival_place in varchar2 default null,
948 p_via in varchar2 default null,
949 p_period_code in varchar2 default null,
950 p_payment_option_code in varchar2 default null,
951 p_amount in number default null,
952 p_pay_start_month in varchar2 default null,
953 p_pay_end_month in varchar2 default null,
954 p_si_start_month_code in varchar2 default null,
955 p_update_date in date default null,
956 p_update_reason_code in varchar2 default null,
957 p_comments in varchar2 default null,
958 --
959 p_error_message out nocopy long
960 --
961 )is
962 --
963 l_effective_start_date pay_element_entries_f.effective_start_date%type;
964 l_effective_end_date pay_element_entries_f.effective_end_date%type;
965 l_element_entry_id pay_element_entries_f.element_entry_id%type;
966 l_object_version_number pay_element_entries_f.object_version_number%type;
967 --
968 l_create_warning boolean;
969 --
970 begin
971 --
972 pay_element_entry_api.create_element_entry
973 (
974 --
975 p_validate => hr_java_conv_util_ss.get_boolean(p_validate),
976 --
977 p_effective_date => p_effective_date,
978 p_business_group_id => p_business_group_id,
979 p_assignment_id => p_assignment_id,
980 p_element_link_id => p_element_link_id,
981 p_entry_type => p_entry_type,
982 --
983 p_attribute_category => p_attribute_category,
984 p_attribute1 => p_attribute1,
985 p_attribute2 => p_attribute2,
986 p_attribute3 => p_attribute3,
987 p_attribute4 => p_attribute4,
988 p_attribute5 => p_attribute5,
989 p_attribute6 => p_attribute6,
990 p_attribute7 => p_attribute7,
991 p_attribute8 => p_attribute8,
992 p_attribute9 => p_attribute9,
993 p_attribute10 => p_attribute10,
994 p_attribute11 => p_attribute11,
995 p_attribute12 => p_attribute12,
996 p_attribute13 => p_attribute13,
997 p_attribute14 => p_attribute14,
998 p_attribute15 => p_attribute15,
999 p_attribute16 => p_attribute16,
1000 p_attribute17 => p_attribute17,
1001 p_attribute18 => p_attribute18,
1002 p_attribute19 => p_attribute19,
1003 p_attribute20 => p_attribute20,
1004 --
1005 p_input_value_id1 => p_input_value_id1 ,
1006 p_input_value_id2 => p_input_value_id2 ,
1007 p_input_value_id3 => p_input_value_id3 ,
1008 p_input_value_id4 => p_input_value_id4 ,
1009 p_input_value_id5 => p_input_value_id5 ,
1010 p_input_value_id6 => p_input_value_id6 ,
1011 p_input_value_id7 => p_input_value_id7 ,
1012 p_input_value_id8 => p_input_value_id8 ,
1013 p_input_value_id9 => p_input_value_id9 ,
1014 p_input_value_id10 => p_input_value_id10,
1015 p_input_value_id11 => p_input_value_id11,
1016 p_input_value_id12 => p_input_value_id12,
1017 p_input_value_id13 => p_input_value_id13,
1018 p_input_value_id14 => null,
1019 p_input_value_id15 => null,
1020 --
1021 p_entry_value1 => p_means_code,
1022 p_entry_value2 => p_departure_place,
1023 p_entry_value3 => p_arrival_place,
1024 p_entry_value4 => p_via,
1025 p_entry_value5 => p_period_code,
1026 p_entry_value6 => p_payment_option_code,
1027 p_entry_value7 => fnd_number.number_to_canonical(p_amount),
1028 p_entry_value8 => p_pay_start_month,
1029 p_entry_value9 => p_pay_end_month,
1030 p_entry_value10 => p_si_start_month_code,
1031 -- canonical date format is not acceptable for this api
1032 p_entry_value11 => fnd_date.date_to_displaydate(p_update_date),
1033 p_entry_value12 => p_update_reason_code,
1034 p_entry_value13 => p_comments,
1035 p_entry_value14 => null,
1036 p_entry_value15 => null,
1037 --
1038 p_effective_start_date => l_effective_start_date,
1039 p_effective_end_date => l_effective_end_date,
1040 p_element_entry_id => l_element_entry_id,
1041 p_object_version_number => l_object_version_number,
1042 --
1043 p_create_warning => l_create_warning
1044 --
1045 );
1046 --
1047 exception
1048 --
1049 when others then
1050 p_error_message :=
1051 hr_java_conv_util_ss.get_formatted_error_message;
1052 --
1053 end create_train_entry;
1054 --
1055 -- ----------------------------------------------------------------------------
1056 -- |---------------------------< update_train_entry >--------------------------|
1057 -- ----------------------------------------------------------------------------
1058 procedure update_train_entry
1059 (
1060 p_validate in number default 0,
1061 --
1062 p_datetrack_update_mode in varchar2,
1063 p_effective_date in date,
1064 p_business_group_id in number,
1065 p_element_entry_id in number,
1066 p_object_version_number in out nocopy number,
1067 --
1068 p_attribute_category in varchar2 default null,
1069 p_attribute1 in varchar2 default null,
1070 p_attribute2 in varchar2 default null,
1071 p_attribute3 in varchar2 default null,
1072 p_attribute4 in varchar2 default null,
1073 p_attribute5 in varchar2 default null,
1074 p_attribute6 in varchar2 default null,
1075 p_attribute7 in varchar2 default null,
1076 p_attribute8 in varchar2 default null,
1077 p_attribute9 in varchar2 default null,
1078 p_attribute10 in varchar2 default null,
1079 p_attribute11 in varchar2 default null,
1080 p_attribute12 in varchar2 default null,
1081 p_attribute13 in varchar2 default null,
1082 p_attribute14 in varchar2 default null,
1083 p_attribute15 in varchar2 default null,
1084 p_attribute16 in varchar2 default null,
1085 p_attribute17 in varchar2 default null,
1086 p_attribute18 in varchar2 default null,
1087 p_attribute19 in varchar2 default null,
1088 p_attribute20 in varchar2 default null,
1089 --
1090 p_input_value_id1 in number default null,
1091 p_input_value_id2 in number default null,
1092 p_input_value_id3 in number default null,
1093 p_input_value_id4 in number default null,
1094 p_input_value_id5 in number default null,
1095 p_input_value_id6 in number default null,
1096 p_input_value_id7 in number default null,
1097 p_input_value_id8 in number default null,
1098 p_input_value_id9 in number default null,
1099 p_input_value_id10 in number default null,
1100 p_input_value_id11 in number default null,
1101 p_input_value_id12 in number default null,
1102 p_input_value_id13 in number default null,
1103 --
1104 p_means_code in varchar2 default null,
1105 p_departure_place in varchar2 default null,
1106 p_arrival_place in varchar2 default null,
1107 p_via in varchar2 default null,
1108 p_period_code in varchar2 default null,
1109 p_payment_option_code in varchar2 default null,
1110 p_amount in number default null,
1111 p_pay_start_month in varchar2 default null,
1112 p_pay_end_month in varchar2 default null,
1113 p_si_start_month_code in varchar2 default null,
1114 p_update_date in date default null,
1115 p_update_reason_code in varchar2 default null,
1116 p_comments in varchar2 default null,
1117 --
1118 p_error_message out nocopy long
1119 --
1120 )is
1121 --
1122 l_effective_start_date pay_element_entries_f.effective_start_date%type;
1123 l_effective_end_date pay_element_entries_f.effective_end_date%type;
1124 --
1125 l_update_warning boolean;
1126 --
1127 begin
1128 --
1129 pay_element_entry_api.update_element_entry
1130 (
1131 --
1132 p_validate => hr_java_conv_util_ss.get_boolean(p_validate),
1133 --
1134 p_datetrack_update_mode => p_datetrack_update_mode,
1135 p_effective_date => p_effective_date,
1136 p_business_group_id => p_business_group_id,
1137 p_element_entry_id => p_element_entry_id,
1138 p_object_version_number => p_object_version_number,
1139 --
1140 p_attribute_category => p_attribute_category,
1141 p_attribute1 => p_attribute1,
1142 p_attribute2 => p_attribute2,
1143 p_attribute3 => p_attribute3,
1144 p_attribute4 => p_attribute4,
1145 p_attribute5 => p_attribute5,
1146 p_attribute6 => p_attribute6,
1147 p_attribute7 => p_attribute7,
1148 p_attribute8 => p_attribute8,
1149 p_attribute9 => p_attribute9,
1150 p_attribute10 => p_attribute10,
1151 p_attribute11 => p_attribute11,
1152 p_attribute12 => p_attribute12,
1153 p_attribute13 => p_attribute13,
1154 p_attribute14 => p_attribute14,
1155 p_attribute15 => p_attribute15,
1156 p_attribute16 => p_attribute16,
1157 p_attribute17 => p_attribute17,
1158 p_attribute18 => p_attribute18,
1159 p_attribute19 => p_attribute19,
1160 p_attribute20 => p_attribute20,
1161 --
1162 p_input_value_id1 => p_input_value_id1 ,
1163 p_input_value_id2 => p_input_value_id2 ,
1164 p_input_value_id3 => p_input_value_id3 ,
1165 p_input_value_id4 => p_input_value_id4 ,
1166 p_input_value_id5 => p_input_value_id5 ,
1167 p_input_value_id6 => p_input_value_id6 ,
1168 p_input_value_id7 => p_input_value_id7 ,
1169 p_input_value_id8 => p_input_value_id8 ,
1170 p_input_value_id9 => p_input_value_id9 ,
1171 p_input_value_id10 => p_input_value_id10,
1172 p_input_value_id11 => p_input_value_id11,
1173 p_input_value_id12 => p_input_value_id12,
1174 p_input_value_id13 => p_input_value_id13,
1175 p_input_value_id14 => null,
1176 p_input_value_id15 => null,
1177 --
1178 p_entry_value1 => p_means_code,
1179 p_entry_value2 => p_departure_place,
1180 p_entry_value3 => p_arrival_place,
1181 p_entry_value4 => p_via,
1182 p_entry_value5 => p_period_code,
1183 p_entry_value6 => p_payment_option_code,
1184 p_entry_value7 => fnd_number.number_to_canonical(p_amount),
1185 p_entry_value8 => p_pay_start_month,
1186 p_entry_value9 => p_pay_end_month,
1187 p_entry_value10 => p_si_start_month_code,
1188 -- canonical date format is not acceptable for this api
1189 p_entry_value11 => fnd_date.date_to_displaydate(p_update_date),
1190 p_entry_value12 => p_update_reason_code,
1191 p_entry_value13 => p_comments,
1192 p_entry_value14 => null,
1193 p_entry_value15 => null,
1194 --
1195 p_effective_start_date => l_effective_start_date,
1196 p_effective_end_date => l_effective_end_date,
1197 --
1198 p_update_warning => l_update_warning
1199 --
1200 );
1201 --
1202 exception
1203 --
1204 when others then
1205 p_error_message :=
1206 hr_java_conv_util_ss.get_formatted_error_message;
1207 --
1208 end update_train_entry;
1209 --
1210 -- ----------------------------------------------------------------------------
1211 -- |----------------------------< create_car_entry >---------------------------|
1212 -- ----------------------------------------------------------------------------
1213 procedure create_car_entry
1214 (
1215 --
1216 p_validate in number default 0,
1217 --
1218 p_effective_date in date,
1219 p_business_group_id in number,
1220 p_assignment_id in number,
1221 p_element_link_id in number,
1222 p_entry_type in varchar2,
1223 --
1224 p_attribute_category in varchar2 default null,
1225 p_attribute1 in varchar2 default null,
1226 p_attribute2 in varchar2 default null,
1227 p_attribute3 in varchar2 default null,
1228 p_attribute4 in varchar2 default null,
1229 p_attribute5 in varchar2 default null,
1230 p_attribute6 in varchar2 default null,
1231 p_attribute7 in varchar2 default null,
1232 p_attribute8 in varchar2 default null,
1233 p_attribute9 in varchar2 default null,
1234 p_attribute10 in varchar2 default null,
1235 p_attribute11 in varchar2 default null,
1236 p_attribute12 in varchar2 default null,
1237 p_attribute13 in varchar2 default null,
1238 p_attribute14 in varchar2 default null,
1239 p_attribute15 in varchar2 default null,
1240 p_attribute16 in varchar2 default null,
1241 p_attribute17 in varchar2 default null,
1242 p_attribute18 in varchar2 default null,
1243 p_attribute19 in varchar2 default null,
1244 p_attribute20 in varchar2 default null,
1245 --
1246 p_input_value_id1 in number default null,
1247 p_input_value_id2 in number default null,
1248 p_input_value_id3 in number default null,
1249 p_input_value_id4 in number default null,
1250 p_input_value_id5 in number default null,
1251 p_input_value_id6 in number default null,
1252 p_input_value_id7 in number default null,
1253 p_input_value_id8 in number default null,
1254 p_input_value_id9 in number default null,
1255 p_input_value_id10 in number default null,
1256 p_input_value_id11 in number default null,
1257 p_input_value_id12 in number default null,
1258 p_input_value_id13 in number default null,
1259 p_input_value_id14 in number default null,
1260 --
1261 p_means_code in varchar2 default null,
1262 p_vehicle_info_id in number default null,
1263 p_period_code in varchar2 default null,
1264 p_distance in number default null,
1265 p_fuel_cost_code in varchar2 default null,
1266 p_amount in number default null,
1267 p_parking_fees in number default null,
1268 p_equivalent_cost in number default null,
1269 p_pay_start_month in varchar2 default null,
1270 p_pay_end_month in varchar2 default null,
1271 p_si_start_month_code in varchar2 default null,
1272 p_update_date in date default null,
1273 p_update_reason_code in varchar2 default null,
1274 p_comments in varchar2 default null,
1275 --
1276 p_error_message out nocopy long
1277 --
1278 )is
1279 --
1280 l_effective_start_date pay_element_entries_f.effective_start_date%type;
1281 l_effective_end_date pay_element_entries_f.effective_end_date%type;
1282 l_element_entry_id pay_element_entries_f.element_entry_id%type;
1283 l_object_version_number pay_element_entries_f.object_version_number%type;
1284 --
1285 l_create_warning boolean;
1286 --
1287 begin
1288 --
1289 pay_element_entry_api.create_element_entry
1290 (
1291 --
1292 p_validate => hr_java_conv_util_ss.get_boolean(p_validate),
1293 --
1294 p_effective_date => p_effective_date,
1295 p_business_group_id => p_business_group_id,
1296 p_assignment_id => p_assignment_id,
1297 p_element_link_id => p_element_link_id,
1298 p_entry_type => p_entry_type,
1299 --
1300 p_attribute_category => p_attribute_category,
1301 p_attribute1 => p_attribute1,
1302 p_attribute2 => p_attribute2,
1303 p_attribute3 => p_attribute3,
1304 p_attribute4 => p_attribute4,
1305 p_attribute5 => p_attribute5,
1306 p_attribute6 => p_attribute6,
1307 p_attribute7 => p_attribute7,
1308 p_attribute8 => p_attribute8,
1309 p_attribute9 => p_attribute9,
1310 p_attribute10 => p_attribute10,
1311 p_attribute11 => p_attribute11,
1312 p_attribute12 => p_attribute12,
1313 p_attribute13 => p_attribute13,
1314 p_attribute14 => p_attribute14,
1315 p_attribute15 => p_attribute15,
1316 p_attribute16 => p_attribute16,
1317 p_attribute17 => p_attribute17,
1318 p_attribute18 => p_attribute18,
1319 p_attribute19 => p_attribute19,
1320 p_attribute20 => p_attribute20,
1321 --
1322 p_input_value_id1 => p_input_value_id1 ,
1323 p_input_value_id2 => p_input_value_id2 ,
1324 p_input_value_id3 => p_input_value_id3 ,
1325 p_input_value_id4 => p_input_value_id4 ,
1326 p_input_value_id5 => p_input_value_id5 ,
1327 p_input_value_id6 => p_input_value_id6 ,
1328 p_input_value_id7 => p_input_value_id7 ,
1329 p_input_value_id8 => p_input_value_id8 ,
1330 p_input_value_id9 => p_input_value_id9 ,
1331 p_input_value_id10 => p_input_value_id10,
1332 p_input_value_id11 => p_input_value_id11,
1333 p_input_value_id12 => p_input_value_id12,
1334 p_input_value_id13 => p_input_value_id13,
1335 p_input_value_id14 => p_input_value_id14,
1336 p_input_value_id15 => null,
1337 --
1338 p_entry_value1 => p_means_code,
1339 p_entry_value2 => fnd_number.number_to_canonical(p_vehicle_info_id),
1340 p_entry_value3 => p_period_code,
1341 p_entry_value4 => fnd_number.number_to_canonical(p_distance),
1342 p_entry_value5 => p_fuel_cost_code,
1343 p_entry_value6 => fnd_number.number_to_canonical(p_amount),
1344 p_entry_value7 => fnd_number.number_to_canonical(p_parking_fees),
1345 p_entry_value8 => fnd_number.number_to_canonical(p_equivalent_cost),
1346 p_entry_value9 => p_pay_start_month,
1347 p_entry_value10 => p_pay_end_month,
1348 p_entry_value11 => p_si_start_month_code,
1349 -- canonical date format is not acceptable for this api
1350 p_entry_value12 => fnd_date.date_to_displaydate(p_update_date),
1351 p_entry_value13 => p_update_reason_code,
1352 p_entry_value14 => p_comments,
1353 p_entry_value15 => null,
1354 --
1355 p_effective_start_date => l_effective_start_date,
1356 p_effective_end_date => l_effective_end_date,
1357 p_element_entry_id => l_element_entry_id,
1358 p_object_version_number => l_object_version_number,
1359 --
1360 p_create_warning => l_create_warning
1361 --
1362 );
1363 --
1364 exception
1365 --
1366 when others then
1367 p_error_message :=
1368 hr_java_conv_util_ss.get_formatted_error_message;
1369 --
1370 end create_car_entry;
1371 --
1372 -- ----------------------------------------------------------------------------
1373 -- |----------------------------< update_car_entry >---------------------------|
1374 -- ----------------------------------------------------------------------------
1375 procedure update_car_entry
1376 (
1377 --
1378 p_validate in number default 0,
1379 --
1380 p_datetrack_update_mode in varchar2,
1381 p_effective_date in date,
1382 p_business_group_id in number,
1383 p_element_entry_id in number,
1384 p_object_version_number in out nocopy number,
1385 --
1386 p_attribute_category in varchar2 default null,
1387 p_attribute1 in varchar2 default null,
1388 p_attribute2 in varchar2 default null,
1389 p_attribute3 in varchar2 default null,
1390 p_attribute4 in varchar2 default null,
1391 p_attribute5 in varchar2 default null,
1392 p_attribute6 in varchar2 default null,
1393 p_attribute7 in varchar2 default null,
1394 p_attribute8 in varchar2 default null,
1395 p_attribute9 in varchar2 default null,
1396 p_attribute10 in varchar2 default null,
1397 p_attribute11 in varchar2 default null,
1398 p_attribute12 in varchar2 default null,
1399 p_attribute13 in varchar2 default null,
1400 p_attribute14 in varchar2 default null,
1401 p_attribute15 in varchar2 default null,
1402 p_attribute16 in varchar2 default null,
1403 p_attribute17 in varchar2 default null,
1404 p_attribute18 in varchar2 default null,
1405 p_attribute19 in varchar2 default null,
1406 p_attribute20 in varchar2 default null,
1407 --
1408 p_input_value_id1 in number default null,
1409 p_input_value_id2 in number default null,
1410 p_input_value_id3 in number default null,
1411 p_input_value_id4 in number default null,
1412 p_input_value_id5 in number default null,
1413 p_input_value_id6 in number default null,
1414 p_input_value_id7 in number default null,
1415 p_input_value_id8 in number default null,
1416 p_input_value_id9 in number default null,
1417 p_input_value_id10 in number default null,
1418 p_input_value_id11 in number default null,
1419 p_input_value_id12 in number default null,
1420 p_input_value_id13 in number default null,
1421 p_input_value_id14 in number default null,
1422 --
1423 p_means_code in varchar2 default null,
1424 p_vehicle_info_id in number default null,
1425 p_period_code in varchar2 default null,
1426 p_distance in number default null,
1427 p_fuel_cost_code in varchar2 default null,
1428 p_amount in number default null,
1429 p_parking_fees in number default null,
1430 p_equivalent_cost in number default null,
1431 p_pay_start_month in varchar2 default null,
1432 p_pay_end_month in varchar2 default null,
1433 p_si_start_month_code in varchar2 default null,
1434 p_update_date in date default null,
1435 p_update_reason_code in varchar2 default null,
1436 p_comments in varchar2 default null,
1437 --
1438 p_error_message out nocopy long
1439 --
1440 )is
1441 --
1442 l_effective_start_date pay_element_entries_f.effective_start_date%type;
1443 l_effective_end_date pay_element_entries_f.effective_end_date%type;
1444 --
1445 l_update_warning boolean;
1446 --
1447 begin
1448 --
1449 pay_element_entry_api.update_element_entry
1450 (
1451 --
1452 p_validate => hr_java_conv_util_ss.get_boolean(p_validate),
1453 --
1454 p_datetrack_update_mode => p_datetrack_update_mode,
1455 p_effective_date => p_effective_date,
1456 p_business_group_id => p_business_group_id,
1457 p_element_entry_id => p_element_entry_id,
1458 p_object_version_number => p_object_version_number,
1459 --
1460 p_attribute_category => p_attribute_category,
1461 p_attribute1 => p_attribute1,
1462 p_attribute2 => p_attribute2,
1463 p_attribute3 => p_attribute3,
1464 p_attribute4 => p_attribute4,
1465 p_attribute5 => p_attribute5,
1466 p_attribute6 => p_attribute6,
1467 p_attribute7 => p_attribute7,
1468 p_attribute8 => p_attribute8,
1469 p_attribute9 => p_attribute9,
1470 p_attribute10 => p_attribute10,
1471 p_attribute11 => p_attribute11,
1472 p_attribute12 => p_attribute12,
1473 p_attribute13 => p_attribute13,
1474 p_attribute14 => p_attribute14,
1475 p_attribute15 => p_attribute15,
1476 p_attribute16 => p_attribute16,
1477 p_attribute17 => p_attribute17,
1478 p_attribute18 => p_attribute18,
1479 p_attribute19 => p_attribute19,
1480 p_attribute20 => p_attribute20,
1481 --
1482 p_input_value_id1 => p_input_value_id1 ,
1483 p_input_value_id2 => p_input_value_id2 ,
1484 p_input_value_id3 => p_input_value_id3 ,
1485 p_input_value_id4 => p_input_value_id4 ,
1486 p_input_value_id5 => p_input_value_id5 ,
1487 p_input_value_id6 => p_input_value_id6 ,
1488 p_input_value_id7 => p_input_value_id7 ,
1489 p_input_value_id8 => p_input_value_id8 ,
1490 p_input_value_id9 => p_input_value_id9 ,
1491 p_input_value_id10 => p_input_value_id10,
1492 p_input_value_id11 => p_input_value_id11,
1493 p_input_value_id12 => p_input_value_id12,
1494 p_input_value_id13 => p_input_value_id13,
1495 p_input_value_id14 => p_input_value_id14,
1496 p_input_value_id15 => null,
1497 --
1498 p_entry_value1 => p_means_code,
1499 p_entry_value2 => fnd_number.number_to_canonical(p_vehicle_info_id),
1500 p_entry_value3 => p_period_code,
1501 p_entry_value4 => fnd_number.number_to_canonical(p_distance),
1502 p_entry_value5 => p_fuel_cost_code,
1503 p_entry_value6 => fnd_number.number_to_canonical(p_amount),
1504 p_entry_value7 => fnd_number.number_to_canonical(p_parking_fees),
1505 p_entry_value8 => fnd_number.number_to_canonical(p_equivalent_cost),
1506 p_entry_value9 => p_pay_start_month,
1507 p_entry_value10 => p_pay_end_month,
1508 p_entry_value11 => p_si_start_month_code,
1509 -- canonical date format is not acceptable for this api
1510 p_entry_value12 => fnd_date.date_to_displaydate(p_update_date),
1511 p_entry_value13 => p_update_reason_code,
1512 p_entry_value14 => p_comments,
1513 p_entry_value15 => null,
1514 --
1515 p_effective_start_date => l_effective_start_date,
1516 p_effective_end_date => l_effective_end_date,
1517 --
1518 p_update_warning => l_update_warning
1519 --
1520 );
1521 --
1522 exception
1523 --
1524 when others then
1525 p_error_message :=
1526 hr_java_conv_util_ss.get_formatted_error_message;
1527 --
1528 end update_car_entry;
1529 --
1530 -- ----------------------------------------------------------------------------
1531 -- |------------------------------< delete_entry >-----------------------------|
1532 -- ----------------------------------------------------------------------------
1533 procedure delete_entry
1534 (
1535 --
1536 p_validate in number default 0,
1537 --
1538 p_datetrack_delete_mode in varchar2,
1539 p_effective_date in date,
1540 p_element_entry_id in number,
1541 p_object_version_number in out nocopy number,
1542 --
1543 p_error_message out nocopy long
1544 --
1545 )is
1546 --
1547 l_effective_start_date pay_element_entries_f.effective_start_date%type;
1548 l_effective_end_date pay_element_entries_f.effective_end_date%type;
1549 --
1550 l_warning boolean;
1551 --
1552 begin
1553 --
1554 pay_element_entry_api.delete_element_entry
1555 (
1556 --
1557 p_validate => hr_java_conv_util_ss.get_boolean(p_validate),
1558 --
1559 p_datetrack_delete_mode => p_datetrack_delete_mode,
1560 p_effective_date => p_effective_date,
1561 p_element_entry_id => p_element_entry_id,
1562 p_object_version_number => p_object_version_number,
1563 --
1564 p_effective_start_date => l_effective_start_date,
1565 p_effective_end_date => l_effective_end_date,
1566 --
1567 p_delete_warning => l_warning
1568 );
1569 --
1570 exception
1571 --
1572 when others then
1573 p_error_message :=
1574 hr_java_conv_util_ss.get_formatted_error_message;
1575 --
1576 end delete_entry;
1577 --
1578 -- ----------------------------------------------------------------------------
1579 -- |------------------------------< process_api >-----------------------------|
1580 -- ----------------------------------------------------------------------------
1581 procedure process_api
1582 (
1583 --
1584 p_validate in boolean default false,
1585 p_transaction_step_id in number default null,
1586 p_effective_date in varchar2 default null
1587 --
1588 ) is
1589 --
1590 l_tran_tab hr_transaction_ss.transaction_data;
1591 --
1592 -- for return values from out parameters
1593 l_element_entry_id pay_element_entries_f.element_entry_id%type;
1594 l_object_version_number pay_element_entries_f.object_version_number%type;
1595 l_effective_start_date pay_element_entries_f.effective_start_date%type;
1596 l_effective_end_date pay_element_entries_f.effective_end_date%type;
1597 --
1598 type tran_rec is record
1599 (
1600 commutation_type varchar2(30), -- 'TRAIN' or 'CAR'
1601 action_type varchar2(30), -- 'INSERT' or 'UPDATE' or 'DELETE'
1602 effective_date date,
1603 date_track_option varchar2(30),
1604 --
1605 element_entry_id pay_element_entries_f.element_entry_id%type,
1606 business_group_id pay_element_links_f.business_group_id%type,
1607 assignment_id pay_element_entries_f.assignment_id%type,
1608 element_link_id pay_element_entries_f.element_link_id%type,
1609 entry_type pay_element_entries_f.entry_type%type,
1610 object_version_number pay_element_entries_f.object_version_number%type,
1611 --
1612 attribute_category pay_element_entries_f.attribute_category%type,
1613 attribute1 pay_element_entries_f.attribute1%type,
1614 attribute2 pay_element_entries_f.attribute2%type,
1615 attribute3 pay_element_entries_f.attribute3%type,
1616 attribute4 pay_element_entries_f.attribute4%type,
1617 attribute5 pay_element_entries_f.attribute5%type,
1618 attribute6 pay_element_entries_f.attribute6%type,
1619 attribute7 pay_element_entries_f.attribute7%type,
1620 attribute8 pay_element_entries_f.attribute8%type,
1621 attribute9 pay_element_entries_f.attribute9%type,
1622 attribute10 pay_element_entries_f.attribute10%type,
1623 attribute11 pay_element_entries_f.attribute11%type,
1624 attribute12 pay_element_entries_f.attribute12%type,
1625 attribute13 pay_element_entries_f.attribute13%type,
1626 attribute14 pay_element_entries_f.attribute14%type,
1627 attribute15 pay_element_entries_f.attribute15%type,
1628 attribute16 pay_element_entries_f.attribute16%type,
1629 attribute17 pay_element_entries_f.attribute17%type,
1630 attribute18 pay_element_entries_f.attribute18%type,
1631 attribute19 pay_element_entries_f.attribute19%type,
1632 attribute20 pay_element_entries_f.attribute20%type,
1633 --
1634 input_value_id1 pay_element_entry_values_f.input_value_id%type,
1635 input_value_id2 pay_element_entry_values_f.input_value_id%type,
1636 input_value_id3 pay_element_entry_values_f.input_value_id%type,
1637 input_value_id4 pay_element_entry_values_f.input_value_id%type,
1638 input_value_id5 pay_element_entry_values_f.input_value_id%type,
1639 input_value_id6 pay_element_entry_values_f.input_value_id%type,
1640 input_value_id7 pay_element_entry_values_f.input_value_id%type,
1641 input_value_id8 pay_element_entry_values_f.input_value_id%type,
1642 input_value_id9 pay_element_entry_values_f.input_value_id%type,
1643 input_value_id10 pay_element_entry_values_f.input_value_id%type,
1644 input_value_id11 pay_element_entry_values_f.input_value_id%type,
1645 input_value_id12 pay_element_entry_values_f.input_value_id%type,
1646 input_value_id13 pay_element_entry_values_f.input_value_id%type,
1647 input_value_id14 pay_element_entry_values_f.input_value_id%type,
1648 input_value_id15 pay_element_entry_values_f.input_value_id%type,
1649 --
1650 entry_value1 pay_element_entry_values_f.screen_entry_value%type,
1651 entry_value2 pay_element_entry_values_f.screen_entry_value%type,
1652 entry_value3 pay_element_entry_values_f.screen_entry_value%type,
1653 entry_value4 pay_element_entry_values_f.screen_entry_value%type,
1654 entry_value5 pay_element_entry_values_f.screen_entry_value%type,
1655 entry_value6 pay_element_entry_values_f.screen_entry_value%type,
1656 entry_value7 pay_element_entry_values_f.screen_entry_value%type,
1657 entry_value8 pay_element_entry_values_f.screen_entry_value%type,
1658 entry_value9 pay_element_entry_values_f.screen_entry_value%type,
1659 entry_value10 pay_element_entry_values_f.screen_entry_value%type,
1660 entry_value11 pay_element_entry_values_f.screen_entry_value%type,
1661 entry_value12 pay_element_entry_values_f.screen_entry_value%type,
1662 entry_value13 pay_element_entry_values_f.screen_entry_value%type,
1663 entry_value14 pay_element_entry_values_f.screen_entry_value%type,
1664 entry_value15 pay_element_entry_values_f.screen_entry_value%type
1665 );
1666 --
1667 l_tran_rec tran_rec;
1668 --
1669 i number;
1670 l_warning boolean;
1671 --
1672 begin
1673 --
1674 -- get taransaction data
1675 hr_transaction_ss.get_transaction_data
1676 (
1677 p_transaction_step_id => p_transaction_step_id,
1678 p_transaction_data => l_tran_tab
1679 );
1680 --
1681 i := l_tran_tab.name.first;
1682 --
1683 loop
1684 exit when not(l_tran_tab.name.exists(i));
1685 if l_tran_tab.name(i) in ('P_REVIEW_PROC_CALL', 'P_REVIEW_ACTID') then
1686 null;
1687 elsif l_tran_tab.name(i) = 'P_COMMUTATION_TYPE' then
1688 l_tran_rec.commutation_type := l_tran_tab.varchar2_value(i);
1689 elsif l_tran_tab.name(i) = 'P_ACTION_TYPE' then
1690 l_tran_rec.action_type := l_tran_tab.varchar2_value(i);
1691 elsif l_tran_tab.name(i) = 'P_EFFECTIVE_DATE' then
1692 l_tran_rec.effective_date := l_tran_tab.date_value(i);
1693 elsif l_tran_tab.name(i) = 'P_DATE_TRACK_OPTION' then
1694 l_tran_rec.date_track_option := l_tran_tab.varchar2_value(i);
1695 elsif l_tran_tab.name(i) = 'P_ELEMENT_ENTRY_ID' then
1696 l_tran_rec.element_entry_id := l_tran_tab.number_value(i);
1697 elsif l_tran_tab.name(i) = 'P_BUSINESS_GROUP_ID' then
1698 l_tran_rec.business_group_id := l_tran_tab.number_value(i);
1699 elsif l_tran_tab.name(i) = 'P_ASSIGNMENT_ID' then
1700 l_tran_rec.assignment_id := l_tran_tab.number_value(i);
1701 elsif l_tran_tab.name(i) = 'P_ELEMENT_LINK_ID' then
1702 l_tran_rec.element_link_id := l_tran_tab.number_value(i);
1703 elsif l_tran_tab.name(i) = 'P_ENTRY_TYPE' then
1704 l_tran_rec.entry_type := l_tran_tab.varchar2_value(i);
1705 elsif l_tran_tab.name(i) = 'P_OBJECT_VERSION_NUMBER' then
1706 l_tran_rec.object_version_number := l_tran_tab.number_value(i);
1707 --
1708 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE_CATEGORY' then
1709 l_tran_rec.attribute_category := l_tran_tab.varchar2_value(i);
1710 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE1' then
1711 l_tran_rec.attribute1 := l_tran_tab.varchar2_value(i);
1712 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE2' then
1713 l_tran_rec.attribute2 := l_tran_tab.varchar2_value(i);
1714 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE3' then
1715 l_tran_rec.attribute3 := l_tran_tab.varchar2_value(i);
1716 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE4' then
1717 l_tran_rec.attribute4 := l_tran_tab.varchar2_value(i);
1718 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE5' then
1719 l_tran_rec.attribute5 := l_tran_tab.varchar2_value(i);
1720 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE6' then
1721 l_tran_rec.attribute6 := l_tran_tab.varchar2_value(i);
1722 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE7' then
1723 l_tran_rec.attribute7 := l_tran_tab.varchar2_value(i);
1724 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE8' then
1725 l_tran_rec.attribute8 := l_tran_tab.varchar2_value(i);
1726 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE9' then
1727 l_tran_rec.attribute9 := l_tran_tab.varchar2_value(i);
1728 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE10' then
1729 l_tran_rec.attribute10 := l_tran_tab.varchar2_value(i);
1730 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE11' then
1731 l_tran_rec.attribute11 := l_tran_tab.varchar2_value(i);
1732 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE12' then
1733 l_tran_rec.attribute12 := l_tran_tab.varchar2_value(i);
1734 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE13' then
1735 l_tran_rec.attribute13 := l_tran_tab.varchar2_value(i);
1736 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE14' then
1737 l_tran_rec.attribute14 := l_tran_tab.varchar2_value(i);
1738 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE15' then
1739 l_tran_rec.attribute15 := l_tran_tab.varchar2_value(i);
1740 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE16' then
1741 l_tran_rec.attribute16 := l_tran_tab.varchar2_value(i);
1742 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE17' then
1743 l_tran_rec.attribute17 := l_tran_tab.varchar2_value(i);
1744 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE18' then
1745 l_tran_rec.attribute18 := l_tran_tab.varchar2_value(i);
1746 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE19' then
1747 l_tran_rec.attribute19 := l_tran_tab.varchar2_value(i);
1748 elsif l_tran_tab.name(i) = 'P_ATTRIBUTE20' then
1749 l_tran_rec.attribute20 := l_tran_tab.varchar2_value(i);
1750 --
1751 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID1' then
1752 l_tran_rec.input_value_id1 := l_tran_tab.number_value(i);
1753 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID2' then
1754 l_tran_rec.input_value_id2 := l_tran_tab.number_value(i);
1755 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID3' then
1756 l_tran_rec.input_value_id3 := l_tran_tab.number_value(i);
1757 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID4' then
1758 l_tran_rec.input_value_id4 := l_tran_tab.number_value(i);
1759 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID5' then
1760 l_tran_rec.input_value_id5 := l_tran_tab.number_value(i);
1761 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID6' then
1762 l_tran_rec.input_value_id6 := l_tran_tab.number_value(i);
1763 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID7' then
1764 l_tran_rec.input_value_id7 := l_tran_tab.number_value(i);
1765 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID8' then
1766 l_tran_rec.input_value_id8 := l_tran_tab.number_value(i);
1767 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID9' then
1768 l_tran_rec.input_value_id9 := l_tran_tab.number_value(i);
1769 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID10' then
1770 l_tran_rec.input_value_id10 := l_tran_tab.number_value(i);
1771 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID11' then
1772 l_tran_rec.input_value_id11 := l_tran_tab.number_value(i);
1773 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID12' then
1774 l_tran_rec.input_value_id12 := l_tran_tab.number_value(i);
1775 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID13' then
1776 l_tran_rec.input_value_id13 := l_tran_tab.number_value(i);
1777 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID14' then
1778 l_tran_rec.input_value_id14 := l_tran_tab.number_value(i);
1779 elsif l_tran_tab.name(i) = 'P_INPUT_VALUE_ID15' then
1780 l_tran_rec.input_value_id15 := l_tran_tab.number_value(i);
1781 --
1782 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE1' then
1783 l_tran_rec.entry_value1 := l_tran_tab.varchar2_value(i);
1784 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE2' then
1785 l_tran_rec.entry_value2 := l_tran_tab.varchar2_value(i);
1786 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE3' then
1787 l_tran_rec.entry_value3 := l_tran_tab.varchar2_value(i);
1788 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE4' then
1789 l_tran_rec.entry_value4 := l_tran_tab.varchar2_value(i);
1790 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE5' then
1791 l_tran_rec.entry_value5 := l_tran_tab.varchar2_value(i);
1792 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE6' then
1793 l_tran_rec.entry_value6 := l_tran_tab.varchar2_value(i);
1794 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE7' then
1795 l_tran_rec.entry_value7 := l_tran_tab.varchar2_value(i);
1796 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE8' then
1797 l_tran_rec.entry_value8 := l_tran_tab.varchar2_value(i);
1798 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE9' then
1799 l_tran_rec.entry_value9 := l_tran_tab.varchar2_value(i);
1800 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE10' then
1801 l_tran_rec.entry_value10 := l_tran_tab.varchar2_value(i);
1802 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE11' then
1803 l_tran_rec.entry_value11 := l_tran_tab.varchar2_value(i);
1804 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE12' then
1805 l_tran_rec.entry_value12 := l_tran_tab.varchar2_value(i);
1806 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE13' then
1807 l_tran_rec.entry_value13 := l_tran_tab.varchar2_value(i);
1808 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE14' then
1809 l_tran_rec.entry_value14 := l_tran_tab.varchar2_value(i);
1810 elsif l_tran_tab.name(i) = 'P_ENTRY_VALUE15' then
1811 l_tran_rec.entry_value15 := l_tran_tab.varchar2_value(i);
1812 end if;
1813 i := i + 1;
1814 end loop;
1815 --
1816 -- for update date input values
1817 -- pay_element_entry_api.create_element_entry and update_element_entry don't accept canonical date format
1818 -- canonical date format must be converted to display date format
1819 -- if the api will be fixed in the future, following lines can be removed
1820 if l_tran_rec.commutation_type = 'TRAIN' and l_tran_rec.entry_value11 is not null then
1821 l_tran_rec.entry_value11 := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_tran_rec.entry_value11));
1822 elsif l_tran_rec.commutation_type = 'CAR' and l_tran_rec.entry_value12 is not null then
1823 l_tran_rec.entry_value12 := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_tran_rec.entry_value12));
1824 end if;
1825 --
1826 -- Some flex fields use the session values
1827 hr_util_misc_web.insert_session_row(l_tran_rec.effective_date);
1828 --
1829 if l_tran_rec.action_type = 'INSERT' then
1830 --
1831 pay_element_entry_api.create_element_entry
1832 (
1833 p_validate => p_validate,
1834 p_effective_date => l_tran_rec.effective_date,
1835 p_business_group_id => l_tran_rec.business_group_id,
1836 p_assignment_id => l_tran_rec.assignment_id,
1837 p_element_link_id => l_tran_rec.element_link_id,
1838 p_entry_type => l_tran_rec.entry_type,
1839 p_attribute_category => l_tran_rec.attribute_category,
1840 p_attribute1 => l_tran_rec.attribute1,
1841 p_attribute2 => l_tran_rec.attribute2,
1842 p_attribute3 => l_tran_rec.attribute3,
1843 p_attribute4 => l_tran_rec.attribute4,
1844 p_attribute5 => l_tran_rec.attribute5,
1845 p_attribute6 => l_tran_rec.attribute6,
1846 p_attribute7 => l_tran_rec.attribute7,
1847 p_attribute8 => l_tran_rec.attribute8,
1848 p_attribute9 => l_tran_rec.attribute9,
1849 p_attribute10 => l_tran_rec.attribute10,
1850 p_attribute11 => l_tran_rec.attribute11,
1851 p_attribute12 => l_tran_rec.attribute12,
1852 p_attribute13 => l_tran_rec.attribute13,
1853 p_attribute14 => l_tran_rec.attribute14,
1854 p_attribute15 => l_tran_rec.attribute15,
1855 p_attribute16 => l_tran_rec.attribute16,
1856 p_attribute17 => l_tran_rec.attribute17,
1857 p_attribute18 => l_tran_rec.attribute18,
1858 p_attribute19 => l_tran_rec.attribute19,
1859 p_attribute20 => l_tran_rec.attribute20,
1860 p_input_value_id1 => l_tran_rec.input_value_id1,
1861 p_input_value_id2 => l_tran_rec.input_value_id2,
1862 p_input_value_id3 => l_tran_rec.input_value_id3,
1863 p_input_value_id4 => l_tran_rec.input_value_id4,
1864 p_input_value_id5 => l_tran_rec.input_value_id5,
1865 p_input_value_id6 => l_tran_rec.input_value_id6,
1866 p_input_value_id7 => l_tran_rec.input_value_id7,
1867 p_input_value_id8 => l_tran_rec.input_value_id8,
1868 p_input_value_id9 => l_tran_rec.input_value_id9,
1869 p_input_value_id10 => l_tran_rec.input_value_id10,
1870 p_input_value_id11 => l_tran_rec.input_value_id11,
1871 p_input_value_id12 => l_tran_rec.input_value_id12,
1872 p_input_value_id13 => l_tran_rec.input_value_id13,
1873 p_input_value_id14 => l_tran_rec.input_value_id14,
1874 p_input_value_id15 => l_tran_rec.input_value_id15,
1875 p_entry_value1 => l_tran_rec.entry_value1,
1876 p_entry_value2 => l_tran_rec.entry_value2,
1877 p_entry_value3 => l_tran_rec.entry_value3,
1878 p_entry_value4 => l_tran_rec.entry_value4,
1879 p_entry_value5 => l_tran_rec.entry_value5,
1880 p_entry_value6 => l_tran_rec.entry_value6,
1881 p_entry_value7 => l_tran_rec.entry_value7,
1882 p_entry_value8 => l_tran_rec.entry_value8,
1883 p_entry_value9 => l_tran_rec.entry_value9,
1884 p_entry_value10 => l_tran_rec.entry_value10,
1885 p_entry_value11 => l_tran_rec.entry_value11,
1886 p_entry_value12 => l_tran_rec.entry_value12,
1887 p_entry_value13 => l_tran_rec.entry_value13,
1888 p_entry_value14 => l_tran_rec.entry_value14,
1889 p_entry_value15 => l_tran_rec.entry_value15,
1890 p_effective_start_date => l_effective_start_date,
1891 p_effective_end_date => l_effective_end_date,
1892 p_element_entry_id => l_element_entry_id,
1893 p_object_version_number => l_object_version_number,
1894 p_create_warning => l_warning
1895 );
1896 --
1897 elsif l_tran_rec.action_type = 'UPDATE' then
1898 --
1899 l_object_version_number := l_tran_rec.object_version_number;
1900 --
1901 pay_element_entry_api.update_element_entry
1902 (
1903 p_validate => p_validate,
1904 p_datetrack_update_mode => l_tran_rec.date_track_option,
1905 p_effective_date => l_tran_rec.effective_date,
1906 p_business_group_id => l_tran_rec.business_group_id,
1907 p_element_entry_id => l_tran_rec.element_entry_id,
1908 p_object_version_number => l_object_version_number,
1909 p_attribute_category => l_tran_rec.attribute_category,
1910 p_attribute1 => l_tran_rec.attribute1,
1911 p_attribute2 => l_tran_rec.attribute2,
1912 p_attribute3 => l_tran_rec.attribute3,
1913 p_attribute4 => l_tran_rec.attribute4,
1914 p_attribute5 => l_tran_rec.attribute5,
1915 p_attribute6 => l_tran_rec.attribute6,
1916 p_attribute7 => l_tran_rec.attribute7,
1917 p_attribute8 => l_tran_rec.attribute8,
1918 p_attribute9 => l_tran_rec.attribute9,
1919 p_attribute10 => l_tran_rec.attribute10,
1920 p_attribute11 => l_tran_rec.attribute11,
1921 p_attribute12 => l_tran_rec.attribute12,
1922 p_attribute13 => l_tran_rec.attribute13,
1923 p_attribute14 => l_tran_rec.attribute14,
1924 p_attribute15 => l_tran_rec.attribute15,
1925 p_attribute16 => l_tran_rec.attribute16,
1926 p_attribute17 => l_tran_rec.attribute17,
1927 p_attribute18 => l_tran_rec.attribute18,
1928 p_attribute19 => l_tran_rec.attribute19,
1929 p_attribute20 => l_tran_rec.attribute20,
1930 p_input_value_id1 => l_tran_rec.input_value_id1,
1931 p_input_value_id2 => l_tran_rec.input_value_id2,
1932 p_input_value_id3 => l_tran_rec.input_value_id3,
1933 p_input_value_id4 => l_tran_rec.input_value_id4,
1934 p_input_value_id5 => l_tran_rec.input_value_id5,
1935 p_input_value_id6 => l_tran_rec.input_value_id6,
1936 p_input_value_id7 => l_tran_rec.input_value_id7,
1937 p_input_value_id8 => l_tran_rec.input_value_id8,
1938 p_input_value_id9 => l_tran_rec.input_value_id9,
1939 p_input_value_id10 => l_tran_rec.input_value_id10,
1940 p_input_value_id11 => l_tran_rec.input_value_id11,
1941 p_input_value_id12 => l_tran_rec.input_value_id12,
1942 p_input_value_id13 => l_tran_rec.input_value_id13,
1943 p_input_value_id14 => l_tran_rec.input_value_id14,
1944 p_input_value_id15 => l_tran_rec.input_value_id15,
1945 p_entry_value1 => l_tran_rec.entry_value1,
1946 p_entry_value2 => l_tran_rec.entry_value2,
1947 p_entry_value3 => l_tran_rec.entry_value3,
1948 p_entry_value4 => l_tran_rec.entry_value4,
1949 p_entry_value5 => l_tran_rec.entry_value5,
1950 p_entry_value6 => l_tran_rec.entry_value6,
1951 p_entry_value7 => l_tran_rec.entry_value7,
1952 p_entry_value8 => l_tran_rec.entry_value8,
1953 p_entry_value9 => l_tran_rec.entry_value9,
1954 p_entry_value10 => l_tran_rec.entry_value10,
1955 p_entry_value11 => l_tran_rec.entry_value11,
1956 p_entry_value12 => l_tran_rec.entry_value12,
1957 p_entry_value13 => l_tran_rec.entry_value13,
1958 p_entry_value14 => l_tran_rec.entry_value14,
1959 p_entry_value15 => l_tran_rec.entry_value15,
1960 p_effective_start_date => l_effective_start_date,
1961 p_effective_end_date => l_effective_end_date,
1962 p_update_warning => l_warning
1963 );
1964 --
1965 elsif l_tran_rec.action_type = 'DELETE' then
1966 --
1967 l_object_version_number := l_tran_rec.object_version_number;
1968 --
1969 pay_element_entry_api.delete_element_entry
1970 (
1971 p_validate => p_validate,
1972 p_datetrack_delete_mode => l_tran_rec.date_track_option,
1973 p_effective_date => l_tran_rec.effective_date,
1974 p_element_entry_id => l_tran_rec.element_entry_id,
1975 p_object_version_number => l_object_version_number,
1976 p_effective_start_date => l_effective_start_date,
1977 p_effective_end_date => l_effective_end_date,
1978 p_delete_warning => l_warning
1979 );
1980 --
1981 end if;
1982 --
1983 end process_api;
1984 --
1985 procedure get_txn_value(
1986 p_transaction_step_id in number,
1987 p_name in varchar2,
1988 p_varchar2_value out nocopy varchar2,
1989 p_date_value out nocopy date,
1990 p_number_value out nocopy number)
1991 --
1992 is
1993 --
1994 cursor csr_txn_value
1995 is
1996 select name,
1997 datatype,
1998 varchar2_value,
1999 date_value,
2000 number_value
2001 from hr_api_transaction_values
2002 where transaction_step_id = p_transaction_step_id;
2003 --
2004 l_txn_value_tbl_cnt number := 0;
2005 --
2006 begin
2007 --
2008 p_varchar2_value := null;
2009 p_date_value := null;
2010 p_number_value := null;
2011 --
2012 if nvl(g_transaction_step_id,-1) <> p_transaction_step_id
2013 or g_txn_value_tbl.count = 0 then
2014 --
2015 g_txn_value_tbl.delete;
2016 --
2017 -- #2243411 bulk collect bug fix is available from 9.2
2018 open csr_txn_value;
2019 -- fetch csr_txn_value bulk collect into l_txn_value_tbl;
2020 loop
2021 --
2022 fetch csr_txn_value into g_txn_value_tbl(l_txn_value_tbl_cnt);
2023 exit when csr_txn_value%notfound;
2024 --
2025 l_txn_value_tbl_cnt := l_txn_value_tbl_cnt + 1;
2026 --
2027 end loop;
2028 --
2029 close csr_txn_value;
2030 --
2031 g_transaction_step_id := p_transaction_step_id;
2032 --
2033 end if;
2034 --
2035 if g_txn_value_tbl.count > 0 then
2036 --
2037 <<txn_value_loop>>
2038 for txn_value_cnt in g_txn_value_tbl.first..g_txn_value_tbl.last loop
2039 --
2040 if g_txn_value_tbl(txn_value_cnt).name = p_name then
2041 --
2042 if g_txn_value_tbl(txn_value_cnt).datatype = c_varchar2 then
2043 --
2044 p_varchar2_value := g_txn_value_tbl(txn_value_cnt).varchar2_value;
2045 --
2046 elsif g_txn_value_tbl(txn_value_cnt).datatype = c_date then
2047 --
2048 p_date_value := g_txn_value_tbl(txn_value_cnt).date_value;
2049 --
2050 elsif g_txn_value_tbl(txn_value_cnt).datatype = c_number then
2051 --
2052 p_number_value := g_txn_value_tbl(txn_value_cnt).number_value;
2053 --
2054 end if;
2055 --
2056 exit txn_value_loop;
2057 --
2058 end if;
2059 --
2060 end loop;
2061 --
2062 end if;
2063 --
2064 end get_txn_value;
2065 --
2066 function get_txn_value_char(
2067 p_transaction_step_id in number,
2068 p_name in varchar2)
2069 return varchar2
2070 is
2071 --
2072 l_value_char hr_api_transaction_values.varchar2_value%type;
2073 l_value_date hr_api_transaction_values.date_value%type;
2074 l_value_number hr_api_transaction_values.number_value%type;
2075 --
2076 begin
2077 --
2078 get_txn_value(
2079 p_transaction_step_id => p_transaction_step_id,
2080 p_name => p_name,
2081 p_varchar2_value => l_value_char,
2082 p_date_value => l_value_date,
2083 p_number_value => l_value_number);
2084 --
2085 return l_value_char;
2086 --
2087 end get_txn_value_char;
2088 --
2089 function get_txn_value_date(
2090 p_transaction_step_id in number,
2091 p_name in varchar2)
2092 return date
2093 is
2094 --
2095 l_value_char hr_api_transaction_values.varchar2_value%type;
2096 l_value_date hr_api_transaction_values.date_value%type;
2097 l_value_number hr_api_transaction_values.number_value%type;
2098 --
2099 begin
2100 --
2101 get_txn_value(
2102 p_transaction_step_id => p_transaction_step_id,
2103 p_name => p_name,
2104 p_varchar2_value => l_value_char,
2105 p_date_value => l_value_date,
2106 p_number_value => l_value_number);
2107 --
2108 return l_value_date;
2109 --
2110 end get_txn_value_date;
2111 --
2112 function get_txn_value_number(
2113 p_transaction_step_id in number,
2114 p_name in varchar2)
2115 return number
2116 is
2117 --
2118 l_value_char hr_api_transaction_values.varchar2_value%type;
2119 l_value_date hr_api_transaction_values.date_value%type;
2120 l_value_number hr_api_transaction_values.number_value%type;
2121 --
2122 begin
2123 --
2124 get_txn_value(
2125 p_transaction_step_id => p_transaction_step_id,
2126 p_name => p_name,
2127 p_varchar2_value => l_value_char,
2128 p_date_value => l_value_date,
2129 p_number_value => l_value_number);
2130 --
2131 return l_value_number;
2132 --
2133 end get_txn_value_number;
2134 --
2135 end pay_jp_process_cmi_ss;