APPS.PER_ABS_ATTENDANCE_REASONS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

PROCEDURE Insert_Row(X_Rowid                        IN OUT VARCHAR2,
                     X_Abs_Attendance_Reason_Id            IN OUT NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Absence_Attendance_Type_Id          NUMBER,
                     X_Name                                VARCHAR2,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER,
                     X_Last_Update_Login                   NUMBER,
                     X_Created_By                          NUMBER,
                     X_Creation_Date                       DATE
 ) IS
--
   CURSOR C IS
      SELECT rowid
      FROM PER_ABS_ATTENDANCE_REASONS
      WHERE abs_attendance_reason_id = X_Abs_Attendance_Reason_Id;

Line: 39

      SELECT per_abs_attendance_reasons_s.nextval
      FROM sys.dual;

Line: 53

  INSERT INTO PER_ABS_ATTENDANCE_REASONS(
          abs_attendance_reason_id,
          business_group_id,
          absence_attendance_type_id,
          name,
          last_update_date,
          last_updated_by,
          last_update_login,
          created_by,
          creation_date
         ) VALUES (
          X_Abs_Attendance_Reason_Id,
          X_Business_Group_Id,
          X_Absence_Attendance_Type_Id,
          X_Name,
          X_Last_Update_Date,
          X_Last_Updated_By,
          X_Last_Update_Login,
          X_Created_By,
          X_Creation_Date
  );

Line: 82

END Insert_Row;

Line: 91

      SELECT *
      FROM   PER_ABS_ATTENDANCE_REASONS
      WHERE  rowid = X_Rowid
      FOR UPDATE of Abs_Attendance_Reason_Id NOWAIT;

Line: 128

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Abs_Attendance_Reason_Id            NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Absence_Attendance_Type_Id          NUMBER,
                     X_Name                                VARCHAR2,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER,
                     X_Last_Update_Login                   NUMBER
) IS
BEGIN
   --
   check_unique_reason(X_Rowid
                      ,X_Name
                      ,X_Absence_Attendance_Type_Id);

Line: 143

  UPDATE PER_ABS_ATTENDANCE_REASONS
  SET
    abs_attendance_reason_id                  =    X_Abs_Attendance_Reason_Id,
    business_group_id                         =    X_Business_Group_Id,
    absence_attendance_type_id                =    X_Absence_Attendance_Type_Id,
    name                                      =    X_Name,
    last_update_date                          =    X_Last_Update_Date,
    last_updated_by                           =    X_Last_Updated_By,
    last_update_login                         =    X_Last_Update_Login
  WHERE rowid = X_rowid;

Line: 158

END Update_Row;

Line: 160

PROCEDURE Delete_Row(X_Rowid VARCHAR2
                    ,X_abs_attendance_reason_id NUMBER) IS
BEGIN
  --
  abr_del_validation(X_abs_attendance_reason_id);

Line: 166

  DELETE FROM PER_ABS_ATTENDANCE_REASONS
  WHERE  rowid = X_Rowid;

Line: 172

END Delete_Row;

Line: 177

   select meaning
   from   hr_lookups
   where  lookup_code = X_CODE
   and    lookup_type = 'ABSENCE_REASON';

Line: 192

   select ''
   from   per_absence_attendances
   where  ABS_ATTENDANCE_REASON_ID =p_abs_attendance_reason_id;

Line: 215

   select ''
   from   per_abs_attendance_reasons
   where  absence_attendance_type_id = p_absence_attendance_type_id
   and    name = p_name
   and   (p_rowid is null
      or (p_rowid is not null
      and rowid = chartorowid(p_rowid)));