eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_AU_ELEMENT_ENTRY_HOOK dependencies on PER_ABSENCE_ATTENDANCES

Line 38: l_batch_id per_absence_attendances.batch_id%type ;

34: ,p_creator_id in number) is
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;

Line 49: from per_absence_attendances aa

45:
46: cursor c_absence (p_absence_attendance_id number)
47: is
48: select aa.batch_id
49: from per_absence_attendances aa
50: where aa.absence_attendance_id = p_absence_attendance_id ;
51:
52: -- cursor to get input value
53:

Line 180: update per_absence_attendances

176: close c_input_value ;
177:
178: hr_utility.trace('AFTER l_Certificate_required :'||l_Certificate_required);
179:
180: update per_absence_attendances
181: set abs_information1 = l_Certificate_required
182: ,abs_information_category = 'AU_' || l_absence_category
183: where absence_attendance_id = p_creator_id ;
184:

Line 208: update per_absence_attendances

204: hr_utility.trace('l_Certificate_received :'||l_Certificate_received);
205:
206: -- now update the Descriptive Flexfield segments
207:
208: update per_absence_attendances
209: set abs_information_category = 'AU_' || l_absence_category
210: ,abs_information2 = l_certificate_received
211: where absence_attendance_id = p_creator_id ;
212:

Line 240: l_abs_information1 per_absence_attendances.abs_information1%type ;

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 ;
244: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;

Line 241: l_abs_information2 per_absence_attendances.abs_information2%type ;

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 ;
244: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;
245:

Line 242: l_abs_information3 per_absence_attendances.abs_information3%type ;

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 ;
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

Line 243: l_dff_context per_absence_attendances.abs_information_category%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 ;
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:

Line 251: from per_absence_attendances

247:
248: cursor c_get_dff_context(p_creator_id number)
249: is
250: select abs_information_category
251: from per_absence_attendances
252: where absence_attendance_id = p_creator_id;
253:
254: -- cursor to get DFF segment values of Absence Information
255:

Line 259: from per_absence_attendances

255:
256: cursor c_get_dff_segment_value(p_creator_id number)
257: is
258: select to_char(date_start,'YYYY/MM/DD HH24:MI:SS'),to_char(date_end,'YYYY/MM/DD HH24:MI:SS'),abs_information1, abs_information2, abs_information3
259: from per_absence_attendances
260: where absence_attendance_id = p_creator_id;
261:
262: -- cursor to get element_entry_value_id for input values of Absence Element
263: