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.PER_ABT_PKG SQL Statements

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

Line: 26


PROCEDURE Insert_Row(X_Rowid                        IN OUT VARCHAR2,
                     X_Absence_Attendance_Type_Id          IN OUT NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Input_Value_Id                      NUMBER,
                     X_Date_Effective                      DATE,
                     X_Name                                VARCHAR2,
                     X_Absence_Category                    VARCHAR2,
                     X_Comments                            VARCHAR2,
                     X_Date_End                            IN OUT DATE,
                     X_Hours_Or_Days                       VARCHAR2,
                     X_Inc_Or_Dec_Flag                     VARCHAR2,
                     X_Attribute_Category                  VARCHAR2,
                     X_Attribute1                          VARCHAR2,
                     X_Attribute2                          VARCHAR2,
                     X_Attribute3                          VARCHAR2,
                     X_Attribute4                          VARCHAR2,
                     X_Attribute5                          VARCHAR2,
                     X_Attribute6                          VARCHAR2,
                     X_Attribute7                          VARCHAR2,
                     X_Attribute8                          VARCHAR2,
                     X_Attribute9                          VARCHAR2,
                     X_Attribute10                         VARCHAR2,
                     X_Attribute11                         VARCHAR2,
                     X_Attribute12                         VARCHAR2,
                     X_Attribute13                         VARCHAR2,
                     X_Attribute14                         VARCHAR2,
                     X_Attribute15                         VARCHAR2,
                     X_Attribute16                         VARCHAR2,
                     X_Attribute17                         VARCHAR2,
                     X_Attribute18                         VARCHAR2,
                     X_Attribute19                         VARCHAR2,
                     X_Attribute20                         VARCHAR2,
                     X_Element_Type_ID                     NUMBER,
                     X_Element_End_Date                    DATE,
                     X_END_OF_TIME                         DATE
 ) IS
   CURSOR C IS
     SELECT rowid FROM PER_ABSENCE_ATTENDANCE_TYPES
     WHERE absence_attendance_type_id = X_Absence_Attendance_Type_Id;

Line: 67


     SELECT per_absence_attendance_types_s.nextval
     FROM sys.dual;

Line: 96


  INSERT INTO PER_ABSENCE_ATTENDANCE_TYPES(
          absence_attendance_type_id,
          business_group_id,
          input_value_id,
          date_effective,
          name,
          absence_category,
          comments,
          date_end,
          hours_or_days,
          increasing_or_decreasing_flag,
          attribute_category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15,
          attribute16,
          attribute17,
          attribute18,
          attribute19,
          attribute20
         ) VALUES (
          X_Absence_Attendance_Type_Id,
          X_Business_Group_Id,
          X_Input_Value_Id,
          X_Date_Effective,
          X_Name,
          X_Absence_Category,
          X_Comments,
          X_Date_End,
          X_Hours_Or_Days,
          X_Inc_Or_Dec_Flag              ,
          X_Attribute_Category,
          X_Attribute1,
          X_Attribute2,
          X_Attribute3,
          X_Attribute4,
          X_Attribute5,
          X_Attribute6,
          X_Attribute7,
          X_Attribute8,
          X_Attribute9,
          X_Attribute10,
          X_Attribute11,
          X_Attribute12,
          X_Attribute13,
          X_Attribute14,
          X_Attribute15,
          X_Attribute16,
          X_Attribute17,
          X_Attribute18,
          X_Attribute19,
          X_Attribute20
  );

Line: 167


      hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Insert_Row');

Line: 175


END Insert_Row;

Line: 212


      SELECT *
      FROM   PER_ABSENCE_ATTENDANCE_TYPES
      WHERE  rowid = X_Rowid
      FOR UPDATE of Absence_Attendance_Type_Id NOWAIT;

Line: 361


PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Absence_Attendance_Type_Id          NUMBER,
                     X_Business_Group_Id                   NUMBER,
                     X_Input_Value_Id                      NUMBER,
                     X_Date_Effective                      DATE,
                     X_Name                                VARCHAR2,
                     X_Absence_Category                    VARCHAR2,
                     X_Comments                            VARCHAR2,
                     X_Date_End                            IN OUT DATE,
                     X_Hours_Or_Days                       VARCHAR2,
                     X_Inc_Or_Dec_Flag                     VARCHAR2,
                     X_Attribute_Category                  VARCHAR2,
                     X_Attribute1                          VARCHAR2,
                     X_Attribute2                          VARCHAR2,
                     X_Attribute3                          VARCHAR2,
                     X_Attribute4                          VARCHAR2,
                     X_Attribute5                          VARCHAR2,
                     X_Attribute6                          VARCHAR2,
                     X_Attribute7                          VARCHAR2,
                     X_Attribute8                          VARCHAR2,
                     X_Attribute9                          VARCHAR2,
                     X_Attribute10                         VARCHAR2,
                     X_Attribute11                         VARCHAR2,
                     X_Attribute12                         VARCHAR2,
                     X_Attribute13                         VARCHAR2,
                     X_Attribute14                         VARCHAR2,
                     X_Attribute15                         VARCHAR2,
                     X_Attribute16                         VARCHAR2,
                     X_Attribute17                         VARCHAR2,
                     X_Attribute18                         VARCHAR2,
                     X_Attribute19                         VARCHAR2,
                     X_Attribute20                         VARCHAR2,
                     X_Element_Type_ID                     NUMBER,
                     X_Element_End_Date                    DATE,
                     X_END_OF_TIME                         DATE,
                     X_old_absence_category                VARCHAR2,
                     X_Old_Name                            VARCHAR2
) IS
BEGIN
   -- check the uniqueness of the name
   --
   per_abt_pkg.check_unique_name(X_Rowid
                                ,X_Business_Group_Id
                                ,X_Name);

Line: 428


     hrdyndbi.delete_absence_dict(X_ABSENCE_ATTENDANCE_TYPE_ID);

Line: 431


  UPDATE PER_ABSENCE_ATTENDANCE_TYPES
  SET
    absence_attendance_type_id                =    X_Absence_Attendance_Type_Id,
    business_group_id                         =    X_Business_Group_Id,
    input_value_id                            =    X_Input_Value_Id,
    date_effective                            =    X_Date_Effective,
    name                                      =    X_Name,
    absence_category                          =    X_Absence_Category,
    comments                                  =    X_Comments,
    date_end                                  =    X_Date_End,
    hours_or_days                             =    X_Hours_Or_Days,
    increasing_or_decreasing_flag          =    X_Inc_Or_Dec_Flag              ,
    attribute_category                        =    X_Attribute_Category,
    attribute1                                =    X_Attribute1,
    attribute2                                =    X_Attribute2,
    attribute3                                =    X_Attribute3,
    attribute4                                =    X_Attribute4,
    attribute5                                =    X_Attribute5,
    attribute6                                =    X_Attribute6,
    attribute7                                =    X_Attribute7,
    attribute8                                =    X_Attribute8,
    attribute9                                =    X_Attribute9,
    attribute10                               =    X_Attribute10,
    attribute11                               =    X_Attribute11,
    attribute12                               =    X_Attribute12,
    attribute13                               =    X_Attribute13,
    attribute14                               =    X_Attribute14,
    attribute15                               =    X_Attribute15,
    attribute16                               =    X_Attribute16,
    attribute17                               =    X_Attribute17,
    attribute18                               =    X_Attribute18,
    attribute19                               =    X_Attribute19,
    attribute20                               =    X_Attribute20
  WHERE rowid = X_rowid;

Line: 468


      hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Update_Row');

Line: 477


END Update_Row;

Line: 479


PROCEDURE Delete_Row(X_Rowid VARCHAR2
                    ,X_Absence_attendance_type_id NUMBER) IS
BEGIN
  --
hr_utility.set_location('per_abt_pkg.delete_row',1);

Line: 486


hr_utility.set_location('per_abt_pkg.delete_row',2);

Line: 487


  hrdyndbi.delete_absence_dict(X_Absence_attendance_type_id);

Line: 489


hr_utility.set_location('per_abt_pkg.delete_row',3);

Line: 490


  DELETE FROM PER_ABSENCE_ATTENDANCE_TYPES
  WHERE  rowid = X_Rowid;

Line: 495


      hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Delete_Row');

Line: 499


END Delete_Row;

Line: 507


   select ''
   from per_absence_attendance_types
   where upper(p_name) = upper(name)
   and   business_group_id + 0 = p_business_group_id
   and   (rowidtochar(rowid) <> p_rowid or p_rowid is null);

Line: 534


   select ''
   from   pay_element_types_f
   where  element_type_id = p_element_type_id
   and    p_date_effective between
          effective_start_date and effective_end_date;

Line: 542


   select ''
   from   per_absence_attendances
   where  absence_attendance_type_id = p_absence_attendance_type_id
   and    date_start < p_date_effective;

Line: 586


   select ipv.name
   ,      ipv.uom
   ,      ipv.input_value_id
   from   pay_input_values ipv
   ,      hr_lookups lkp
   where  ipv.element_type_id = p_element_type_id
   and    ipv.uom = lkp.lookup_code
   and    lkp.lookup_type = 'UNITS'
   and    lkp.lookup_code in
          ('ND','H_HH','H_DECIMAL1','H_DECIMAL2','H_DECIMAL3')
   and    p_date_effective between
          ipv.effective_start_date and ipv.effective_end_date;

Line: 603


    select ''
    from per_absence_attendance_types abt
    where abt.input_value_id = l_input_value_id
    and   p_rowid is not null
    and   chartorowid(p_rowid) <> abt.rowid;

Line: 612


   select max(effective_end_date)
   from   pay_element_types_f
   where  element_type_id = p_element_type_id;

Line: 662


   select lookup_code
   from   hr_lookups
   where  lookup_type = 'HOURS_OR_DAYS'
   and    lookup_code = 'H'
   and    p_value_uom in
         ('H_HH','H_DECIMAL1','H_DECIMAL2','H_DECIMAL3');

Line: 713


   select ''
   from   pay_input_values
   where  element_type_id = p_element_type_id
   and    input_value_id  <> p_input_value_id
   and  ((hot_default_flag = 'N'
      and mandatory_flag = 'Y')
     or  (hot_default_flag = 'Y'
      and default_value is null));

Line: 743


   select ''
   from   per_absence_attendances
   where  absence_attendance_type_id = p_absence_attendance_type_id;

Line: 793


   select ''
   from per_absence_attendances
   where absence_attendance_type_id = p_absence_attendance_type_id;

Line: 798


   select ''
   from per_abs_attendance_reasons
   where absence_attendance_type_id = p_absence_attendance_type_id;