APPS.HR_AU_ELEMENT_ENTRY_HOOK dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 39: l_certificate_required pay_element_entry_values_f.screen_entry_value%type ;

35:
36:
37: l_procedure_name varchar2(61) := 'hr_au_element_entry_hook.insert_absence_dev_desc_flex' ;
38: l_batch_id per_absence_attendances.batch_id%type ;
39: l_certificate_required pay_element_entry_values_f.screen_entry_value%type ;
40: l_certificate_received pay_element_entry_values_f.screen_entry_value%type ;
41: l_absence_category per_absence_attendance_types.absence_category%type;
42: l_element_name pay_element_types_f.element_name%type;
43:

Line 40: l_certificate_received pay_element_entry_values_f.screen_entry_value%type ;

36:
37: l_procedure_name varchar2(61) := 'hr_au_element_entry_hook.insert_absence_dev_desc_flex' ;
38: l_batch_id per_absence_attendances.batch_id%type ;
39: l_certificate_required pay_element_entry_values_f.screen_entry_value%type ;
40: l_certificate_received pay_element_entry_values_f.screen_entry_value%type ;
41: l_absence_category per_absence_attendance_types.absence_category%type;
42: l_element_name pay_element_types_f.element_name%type;
43:
44: -- cursor to get the batch ID for the absence

Line 60: ,pay_element_entry_values_f eev

56: ,p_input_name varchar2)
57: is
58: select eev.screen_entry_value
59: from pay_input_values_f iv
60: ,pay_element_entry_values_f eev
61: where eev.element_entry_id = p_element_entry_id
62: and p_effective_date between eev.effective_start_date
63: and eev.effective_end_date
64: and iv.input_value_id = eev.input_value_id

Line 238: l_start_date pay_element_entry_values_f.screen_entry_value%type;

234: ,p_creator_type in varchar2
235: ,p_creator_id in number) is
236:
237: l_procedure_name varchar2(61) := 'hr_au_element_entry_hook.update_element_entry_values' ;
238: l_start_date pay_element_entry_values_f.screen_entry_value%type;
239: l_end_date pay_element_entry_values_f.screen_entry_value%type;
240: l_abs_information1 per_absence_attendances.abs_information1%type ;
241: l_abs_information2 per_absence_attendances.abs_information2%type ;
242: l_abs_information3 per_absence_attendances.abs_information3%type ;

Line 239: l_end_date pay_element_entry_values_f.screen_entry_value%type;

235: ,p_creator_id in number) is
236:
237: l_procedure_name varchar2(61) := 'hr_au_element_entry_hook.update_element_entry_values' ;
238: l_start_date pay_element_entry_values_f.screen_entry_value%type;
239: l_end_date pay_element_entry_values_f.screen_entry_value%type;
240: l_abs_information1 per_absence_attendances.abs_information1%type ;
241: l_abs_information2 per_absence_attendances.abs_information2%type ;
242: l_abs_information3 per_absence_attendances.abs_information3%type ;
243: l_dff_context per_absence_attendances.abs_information_category%type ;

Line 244: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;

240: l_abs_information1 per_absence_attendances.abs_information1%type ;
241: l_abs_information2 per_absence_attendances.abs_information2%type ;
242: l_abs_information3 per_absence_attendances.abs_information3%type ;
243: l_dff_context per_absence_attendances.abs_information_category%type ;
244: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;
245:
246: -- cursor to get DFF context value of Absence Information
247:
248: cursor c_get_dff_context(p_creator_id number)

Line 268: from pay_element_entry_values_f peev,pay_input_values_f piv

264: cursor get_element_entry_value_id(p_element_entry_id number
265: ,p_input_name varchar2)
266: is
267: select peev.element_entry_value_id
268: from pay_element_entry_values_f peev,pay_input_values_f piv
269: where peev.element_entry_id = p_element_entry_id
270: and piv.name = p_input_name
271: and peev.input_value_id = piv.input_value_id;
272:

Line 305: update pay_element_entry_values_f

301: close get_element_entry_value_id;
302:
303: hr_utility.trace('Updating Start Date entry value as l_start_date :'||l_start_date);
304:
305: update pay_element_entry_values_f
306: set screen_entry_value = l_start_date
307: where element_entry_value_id = l_element_entry_value_id;
308:
309: open get_element_entry_value_id(p_element_entry_id,'End Date');

Line 315: update pay_element_entry_values_f

311: close get_element_entry_value_id;
312:
313: hr_utility.trace('Updating End Date entry value as l_end_date :'||l_end_date);
314:
315: update pay_element_entry_values_f
316: set screen_entry_value = l_end_date
317: where element_entry_value_id = l_element_entry_value_id;
318:
319: open get_element_entry_value_id(p_element_entry_id,'Pay Date');

Line 325: update pay_element_entry_values_f

321: close get_element_entry_value_id;
322:
323: hr_utility.trace('Updating Pay Date entry value as abs_information1 :'||l_abs_information1);
324:
325: update pay_element_entry_values_f
326: set screen_entry_value = l_abs_information1
327: where element_entry_value_id = l_element_entry_value_id;
328:
329: open get_element_entry_value_id(p_element_entry_id,'Advance Defer');

Line 335: update pay_element_entry_values_f

331: close get_element_entry_value_id;
332:
333: hr_utility.trace('Updating Start Advance Defer value as abs_information2 :'||l_abs_information2);
334:
335: update pay_element_entry_values_f
336: set screen_entry_value = l_abs_information2
337: where element_entry_value_id = l_element_entry_value_id;
338:
339: open get_element_entry_value_id(p_element_entry_id,'Advance Override');

Line 345: update pay_element_entry_values_f

341: close get_element_entry_value_id;
342:
343: hr_utility.trace('Updating Advance Override entry value as abs_information3 :'||l_abs_information3);
344:
345: update pay_element_entry_values_f
346: set screen_entry_value = l_abs_information3
347: where element_entry_value_id = l_element_entry_value_id;
348:
349: END IF; -- l_dff_context.