APPS.PAYPLNK dependencies on PER_ABSENCE_ATTENDANCES

Line 2870: l_error_table per_absence_attendances_pkg3.t_message_table;

2866: l_abs_hod_tbl hr_entry.varchar2_table;
2867: l_line_id_tbl hr_entry.number_table;
2868: l_status_tbl hr_entry.varchar2_table;
2869: l_message_tbl varchar2_table2;
2870: l_error_table per_absence_attendances_pkg3.t_message_table;
2871: l_warning_table per_absence_attendances_pkg3.t_message_table;
2872: l_error_num number;
2873: l_warning_num number;
2874: --(bug 372339).

Line 2871: l_warning_table per_absence_attendances_pkg3.t_message_table;

2867: l_line_id_tbl hr_entry.number_table;
2868: l_status_tbl hr_entry.varchar2_table;
2869: l_message_tbl varchar2_table2;
2870: l_error_table per_absence_attendances_pkg3.t_message_table;
2871: l_warning_table per_absence_attendances_pkg3.t_message_table;
2872: l_error_num number;
2873: l_warning_num number;
2874: --(bug 372339).
2875: l_health_plan_benefit boolean := TRUE;

Line 4186: -- per_absence_attendances_pkg3.insert_abs_for_bee(

4182: -- end if;
4183: -- -- End of 3156665
4184: -- end if;
4185:
4186: -- per_absence_attendances_pkg3.insert_abs_for_bee(
4187: -- p_session_date => g_line_record.effective_date,
4188: -- p_absence_att_type_id => l_abs_type_tbl(l),
4189: -- p_absence_attendance_id => l_absence_attendance_id,
4190: -- p_batch_id => p_batch_id,

Line 4199: -- per_absence_attendances_pkg3.insert_abs_for_bee(

4195: -- p_date_end => l_end_date,
4196: -- p_warning_table => l_warning_table,
4197: -- p_error_table => l_error_table);
4198:
4199: -- per_absence_attendances_pkg3.insert_abs_for_bee(
4200: -- p_session_date => g_line_record.effective_date,
4201: -- p_absence_att_type_id => l_abs_type_tbl(l),
4202: -- p_assignment_id => g_line_record.assignment_id,
4203: -- p_batch_id => p_batch_id,

Line 4217: per_absence_attendances_pkg3.insert_abs_for_bee(

4213: --
4214: -- This overloaded Absence API handles creation of both
4215: -- the absence and element entry.
4216: --
4217: per_absence_attendances_pkg3.insert_abs_for_bee(
4218: p_absence_att_type_id => l_abs_type_tbl(l),
4219: p_batch_id => p_batch_id,
4220: p_asg_act_id => p_asg_act_id,
4221: p_entry_values_count => c_entry_values,

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

4269:
4270: end if;
4271: end loop;
4272: --
4273: -- The per_absence_attendances_pkg3.insert_abs_for_bee procedure now creates both
4274: -- an absence record AND an absence element entry. Hence we should move to next
4275: -- batch line if an absence entry has been made.
4276: --
4277:

Line 5304: -- for absence null batch_id on per_absence_attendances

5300: ghr_history_api.post_update_process;
5301: end if;
5302:
5303: -- For MIX rollback - for non absence must set creator_id to null after update
5304: -- for absence null batch_id on per_absence_attendances
5305: -- for this element
5306:
5307: if (p_creator_type = 'A') then
5308: --

Line 5311: update per_absence_attendances

5307: if (p_creator_type = 'A') then
5308: --
5309: hr_utility.set_location('payplnk.update_element_entry',10);
5310: --
5311: update per_absence_attendances
5312: set batch_id = null
5313: where absence_attendance_id = p_creator_id;
5314: else
5315: --