APPS.HR_ABSUTIL_SS SQL Statements

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

Line: 26

      select nvl(Information1,Information3)
      into lv_startDate
      from hr_api_transaction_steps
      where transaction_id=p_transaction_id;

Line: 67

      select nvl(Information2,Information4)
      into lv_EndDate
      from hr_api_transaction_steps
      where transaction_id=p_transaction_id;

Line: 111

      select Information5
      into lv_AbsenceTypeId
      from hr_api_transaction_steps
      where transaction_id=p_transaction_id;

Line: 123

        select name
        into lv_AbsenceType
        from PER_ABS_ATTENDANCE_TYPES_TL
        where ABSENCE_ATTENDANCE_TYPE_ID=lv_AbsenceTypeId
            and language = userenv('LANG');

Line: 175

        select Information6
        into lv_AbsenceCategory
        from hr_api_transaction_steps
        where transaction_id=p_transaction_id;

Line: 209

        select Information7
        into lv_AbsenceHoursDuration
        from hr_api_transaction_steps
        where transaction_id=p_transaction_id;

Line: 245

        select Information8
        into lv_AbsenceDaysDuration
        from hr_api_transaction_steps
        where transaction_id=p_transaction_id;

Line: 285

        select    hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS',
           decode(status,'RI','C',
                      'RIS','S',
                      'RO','Y',
                      'ROS','Y',
                      'YS','Y',
                      status))
        into lv_approvalStatus
        from hr_api_transactions
        where transaction_id=p_transaction_id;

Line: 330

        select  decode(status,'RI','C',
                      'RIS','S',
                      'RO','Y',
                      'ROS','Y',
                      'YS','Y',
                      status)
        into lv_approvalStatusCode
        from hr_api_transactions
        where transaction_id=p_transaction_id;

Line: 372

        select (SELECT meaning
                 from fnd_lookup_values
                 where lookup_type ='ABSENCE_STATUS'
                 and   fnd_lookup_values.lookup_code=Information9
                 and language = userenv('LANG')
                )
        into lv_AbsenceStatus
        from hr_api_transaction_steps
        where transaction_id=p_transaction_id;

Line: 399

function isUpdateAllowed(p_transaction_id in number,
                         p_absence_attendance_id in number,
                         p_transaction_status in varchar2) return varchar2

IS
c_proc  constant varchar2(30) := 'isUpdateAllowed';

Line: 405

lv_UpdateAllowed varchar2(30);

Line: 412

 decode (hat.status,'W', 'HrUpdateEnabled',
                           'S','HrUpdateEnabled',
                           'RI','HrUpdateEnabled',
                'HrUpdateDisabled')
*/
   -- need to revisit with the common code for handling update
   -- based on the current transaction owner

    -- for now this will only allow for transaction owner to update

     if(p_transaction_id is not null) then
    if(hr_transaction_swi.istxnowner(p_transaction_id,fnd_global.employee_id)
       and p_transaction_status in ('W','S','RI','RIS')) then
      lv_UpdateAllowed := 'HrUpdateEnabled';

Line: 427

      lv_UpdateAllowed := 'HrUpdateDisabled';

Line: 431

  return lv_UpdateAllowed;

Line: 442

end isUpdateAllowed;

Line: 533

     SELECT 'Y'
     INTO l_exists
     from fnd_attached_documents
     where entity_name=lv_entity_name
     and pk1_value=lv_pkey1
     AND ROWNUM = 1;

Line: 579

     select status,item_type,item_key
     into lv_status,lv_item_type,lv_item_key
     from hr_api_transactions
     where transaction_id=p_transaction_id;

Line: 590

            select item_type, item_key
            into lv_item_type,lv_item_key
            from wf_items
            where user_key=p_transaction_id
            and rownum<2;

Line: 606

         select notification_id
         into ln_notification_id
         FROM   WF_ITEM_ACTIVITY_STATUSES IAS
         WHERE  ias.item_type          = lv_item_type
         and    ias.item_key           = lv_item_key
         and    ias.activity_status    = 'NOTIFIED'
         and    ias.notification_id is not null
         and rownum<=1;

Line: 751

        select (SELECT meaning
                 from fnd_lookup_values
                 where lookup_type ='ABSENCE_STATUS'
                 and   fnd_lookup_values.lookup_code=Information9
                 and language = userenv('LANG')
                )
        into lv_AbsenceStatus
        from hr_api_transaction_steps
        where transaction_id=p_transaction_id;