APPS.CAC_VIEW_AVAIL_PVT SQL Statements

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

Line: 130

PROCEDURE UpdateList
( p_List          IN OUT  NOCOPY  AvlblTb  -- List Name
, p_StartRecord   IN      NUMBER   -- For this RS List section starts with record #
, p_FirstSlot     IN      NUMBER   -- First Slot to set to unavailable
, p_LastSlot      IN      NUMBER   -- Last Slot to set to unavailable
, p_free_busy     IN      VARCHAR2
)
IS
  l_slot_code NUMBER; -- 0: Unavailable, 1: Available, 2: Tentative

Line: 159

END UpdateList;

Line: 161

PROCEDURE UpdateList
( p_List          IN OUT  NOCOPY  AvlblTb  -- List Name
, p_StartRecord   IN      NUMBER   -- For this RS List section starts with record #
, p_FirstSlot     IN      NUMBER   -- First Slot to set to unavailable
, p_LastSlot      IN      NUMBER   -- Last Slot to set to unavailable
)
IS
  p BINARY_INTEGER;

Line: 170

  UpdateList
  ( p_List          => p_List
  , p_StartRecord   => p_StartRecord
  , p_FirstSlot     => p_FirstSlot
  , p_LastSlot      => p_LastSlot
  , p_free_busy     => NULL
  );

Line: 181

END UpdateList;

Line: 222

  )IS SELECT /*+ INDEX(jtsb JTF_TASK_STATUSES_B_U1) */
             jtb.source_object_id             ItemSourceID
      ,      jtb.source_object_type_code      ItemSourceCode
      ,      jtb.calendar_start_date          StartDate
      ,      jtb.calendar_end_date            EndDate
      ,      jtb.timezone_id                  TimezoneID
      FROM jtf_task_all_assignments      jta
      ,    jtf_tasks_b               jtb
      ,    jtf_task_statuses_b       jtsb
      WHERE jta.resource_id          = b_ResourceID        -- 101272224
      AND   jta.resource_type_code   = b_ResourceType      -- 'RS_EMPLOYEE'
      AND   jta.task_id              = jtb.task_id         -- join to tasks_b
      AND   jtb.task_status_id       = jtsb.task_status_id -- join to to task_status_b
      AND   jta.show_on_calendar     = 'Y'
      AND   jta.assignment_status_id <> 4 -- using status rejected for declined
      AND   NVL(jtsb.closed_flag,'N')<> 'Y'
      AND   (   jtb.calendar_start_date <= b_EndDate
            OR  jtb.calendar_start_date IS NULL
            )
      AND   (   jtb.calendar_end_date   >=  b_StartDate
            OR  jtb.calendar_end_date IS NULL
            );

Line: 389

          ** Update the availabity list section of this resource with the Slot
          ** Data
          *************************************************************************/
          UpdateList( x_AvailbltyList      -- List Name
                    , l_RSSectionStart     -- For this RS List section starts with record #
                    , l_FirstSlot          -- First Slot to set to unavailable
                    , l_LastSlot           -- Last Slot to set to unavailable
                    );

Line: 399

          ** Update the total availabity list with the Slot Data
          *************************************************************************/
          UpdateList( x_TotalAvailbltyList -- List Name
                    , 1                    -- start with record #
                    , l_FirstSlot          -- First Slot to set to unavailable
                    , l_LastSlot           -- Last Slot to set to unavailable
                    );

Line: 480

  )IS SELECT /*+ INDEX(jtsb JTF_TASK_STATUSES_B_U1) */
             jtb.source_object_id             ItemSourceID
      ,      jtb.source_object_type_code      ItemSourceCode
      ,      jtb.calendar_start_date          StartDate
      ,      jtb.calendar_end_date            EndDate
      ,      jtb.timezone_id                  TimezoneID
      ,      NVL(jta.free_busy_type,'BUSY')   FreeBusyType
      FROM jtf_task_all_assignments      jta
      ,    jtf_tasks_b               jtb
      ,    jtf_task_statuses_b       jtsb
      WHERE jta.resource_id          = b_ResourceID        -- 101272224
      AND   jta.resource_type_code   = b_ResourceType      -- 'RS_EMPLOYEE'
      AND   jta.task_id              = jtb.task_id         -- join to tasks_b
      AND   jtb.task_status_id       = jtsb.task_status_id -- join to to task_status_b
      AND   jta.show_on_calendar     = 'Y'
      AND   jta.assignment_status_id <> 4 -- using status rejected for declined
      AND   NVL(jtsb.closed_flag,'N')<> 'Y'
      AND   (   jtb.calendar_start_date <= b_EndDate
            OR  jtb.calendar_start_date IS NULL
            )
      AND   (   jtb.calendar_end_date   >=  b_StartDate
            OR  jtb.calendar_end_date IS NULL
            );

Line: 652

          ** Update the availabity list section of this resource with the Slot
          ** Data
          *************************************************************************/
          UpdateList( x_AvailbltyList      -- List Name
                    , l_RSSectionStart     -- For this RS List section starts with record #
                    , l_FirstSlot          -- First Slot to set to unavailable
                    , l_LastSlot           -- Last Slot to set to unavailable
                    , r_ResourceTask.FreeBusyType
                    );

Line: 663

          ** Update the total availabity list with the Slot Data
          *************************************************************************/
          UpdateList( x_TotalAvailbltyList -- List Name
                    , 1                    -- start with record #
                    , l_FirstSlot          -- First Slot to set to unavailable
                    , l_LastSlot           -- Last Slot to set to unavailable
                    , r_ResourceTask.FreeBusyType
                    );

Line: 727

  SELECT jta.resource_id
      ,  jta.resource_type_code
      ,  jtf_task_utl.get_owner(jta.resource_type_code, jta.resource_id) resource_name
    FROM jtf_task_all_assignments jta
   WHERE jta.task_id = b_task_id
     AND jta.show_on_calendar = 'Y'
     AND jta.assignment_status_id <> 4  -- using status rejected for declined
     AND jta.resource_type_code IN ('PN_LOCATIONS', 'RS_EMPLOYEE', 'RS_GROUP');