DBA Data[Home] [Help]

APPS.BEN_WHATIF_ELIG dependencies on PER_ABSENCE_ATTENDANCES

Line 64: rowid, per_absence_attendances.*

60: ) is
61: --
62: cursor c_abs_att is
63: select
64: rowid, per_absence_attendances.*
65: from per_absence_attendances
66: where person_id = p_person_id and
67: absence_attendance_type_id = p_absence_attendance_type_id and
68: abs_attendance_reason_id =

Line 65: from per_absence_attendances

61: --
62: cursor c_abs_att is
63: select
64: rowid, per_absence_attendances.*
65: from per_absence_attendances
66: where person_id = p_person_id and
67: absence_attendance_type_id = p_absence_attendance_type_id and
68: abs_attendance_reason_id =
69: nvl(p_abs_attendance_reason_id, abs_attendance_reason_id) and

Line 112: PER_ABSENCE_ATTENDANCES_PKG.Insert_Row(

108: Close c_abs_att;
109: --
110: -- Absence Attendence Record is Not found so create one.
111: --
112: PER_ABSENCE_ATTENDANCES_PKG.Insert_Row(
113: X_Rowid => l_Rowid,
114: X_Absence_Attendance_Id => per_abs_att_rec.Absence_Attendance_Id,
115: X_Business_Group_Id => p_Business_Group_Id,
116: X_Absence_Attendance_Type_Id => per_abs_att_rec.Absence_Attendance_Type_Id,

Line 208: PER_ABSENCE_ATTENDANCES_PKG.Update_Row(

204: --
205: -- Call the API -
206: -- ???? Do we need to update all the Per Absence Attendences.
207: --
208: PER_ABSENCE_ATTENDANCES_PKG.Update_Row(
209: X_Rowid => rowidtochar(per_abs_att_rec.Rowid),
210: X_Absence_Attendance_Id => per_abs_att_rec.Absence_Attendance_Id,
211: X_Business_Group_Id => per_abs_att_rec.Business_Group_Id,
212: X_Absence_Attendance_Type_Id => per_abs_att_rec.Absence_Attendance_Type_Id,