APPS.PAYPLNK dependencies on PER_ABSENCE_ATTENDANCES

Line 2866: l_error_table per_absence_attendances_pkg3.t_message_table;

2862: l_abs_hod_tbl hr_entry.varchar2_table;
2863: l_line_id_tbl hr_entry.number_table;
2864: l_status_tbl hr_entry.varchar2_table;
2865: l_message_tbl varchar2_table2;
2866: l_error_table per_absence_attendances_pkg3.t_message_table;
2867: l_warning_table per_absence_attendances_pkg3.t_message_table;
2868: l_error_num number;
2869: l_warning_num number;
2870: --(bug 372339).

Line 2867: l_warning_table per_absence_attendances_pkg3.t_message_table;

2863: l_line_id_tbl hr_entry.number_table;
2864: l_status_tbl hr_entry.varchar2_table;
2865: l_message_tbl varchar2_table2;
2866: l_error_table per_absence_attendances_pkg3.t_message_table;
2867: l_warning_table per_absence_attendances_pkg3.t_message_table;
2868: l_error_num number;
2869: l_warning_num number;
2870: --(bug 372339).
2871: l_health_plan_benefit boolean := TRUE;

Line 4168: -- per_absence_attendances_pkg3.insert_abs_for_bee(

4164: -- end if;
4165: -- -- End of 3156665
4166: -- end if;
4167:
4168: -- per_absence_attendances_pkg3.insert_abs_for_bee(
4169: -- p_session_date => g_line_record.effective_date,
4170: -- p_absence_att_type_id => l_abs_type_tbl(l),
4171: -- p_absence_attendance_id => l_absence_attendance_id,
4172: -- p_batch_id => p_batch_id,

Line 4181: -- per_absence_attendances_pkg3.insert_abs_for_bee(

4177: -- p_date_end => l_end_date,
4178: -- p_warning_table => l_warning_table,
4179: -- p_error_table => l_error_table);
4180:
4181: -- per_absence_attendances_pkg3.insert_abs_for_bee(
4182: -- p_session_date => g_line_record.effective_date,
4183: -- p_absence_att_type_id => l_abs_type_tbl(l),
4184: -- p_assignment_id => g_line_record.assignment_id,
4185: -- p_batch_id => p_batch_id,

Line 4199: per_absence_attendances_pkg3.insert_abs_for_bee(

4195: --
4196: -- This overloaded Absence API handles creation of both
4197: -- the absence and element entry.
4198: --
4199: per_absence_attendances_pkg3.insert_abs_for_bee(
4200: p_absence_att_type_id => l_abs_type_tbl(l),
4201: p_batch_id => p_batch_id,
4202: p_asg_act_id => p_asg_act_id,
4203: p_entry_values_count => c_entry_values,

Line 4255: -- The per_absence_attendances_pkg3.insert_abs_for_bee procedure now creates both

4251:
4252: end if;
4253: end loop;
4254: --
4255: -- The per_absence_attendances_pkg3.insert_abs_for_bee procedure now creates both
4256: -- an absence record AND an absence element entry. Hence we should move to next
4257: -- batch line if an absence entry has been made.
4258: --
4259:

Line 5272: -- for absence null batch_id on per_absence_attendances

5268: ghr_history_api.post_update_process;
5269: end if;
5270:
5271: -- For MIX rollback - for non absence must set creator_id to null after update
5272: -- for absence null batch_id on per_absence_attendances
5273: -- for this element
5274:
5275: if (p_creator_type = 'A') then
5276: --

Line 5279: update per_absence_attendances

5275: if (p_creator_type = 'A') then
5276: --
5277: hr_utility.set_location('payplnk.update_element_entry',10);
5278: --
5279: update per_absence_attendances
5280: set batch_id = null
5281: where absence_attendance_id = p_creator_id;
5282: else
5283: --