APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT SQL Statements

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

Line: 6

PROCEDURE UPDATE_SEL_RT_NODE
  (P_RESOURCE_ID           IN IEU_UWQ_SEL_RT_NODES.RESOURCE_ID%TYPE
  ,P_SEL_ENUM_ID           IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE
  ,P_NODE_ID               IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE
  ,P_NODE_TYPE             IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
  ,P_NODE_LABEL            IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
  ,P_DATA_SOURCE           IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
  ,P_VIEW_NAME             IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
  ,P_MEDIA_TYPE_ID         IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
  ,P_SEL_ENUM_PID          IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
  ,P_NODE_PID              IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
  ,P_NODE_WEIGHT           IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
  ,P_WHERE_CLAUSE          IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
  ,P_HIDE_IF_EMPTY         IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
  ,P_REFRESH_VIEW_NAME     IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
  ,P_REFRESH_VIEW_SUM_COL  IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
  ,P_NODE_DEPTH	  	   IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE		-- Added for bug 4389449
  )
  AS
  l_node_id	NUMBER;

Line: 48

  SAVEPOINT start_update;

Line: 54

    UPDATE IEU_UWQ_SEL_RT_NODES
      SET
        LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
        LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
        NODE_LABEL = P_NODE_LABEL,
        DATA_SOURCE = P_DATA_SOURCE,
        VIEW_NAME = P_VIEW_NAME,
        REFRESH_VIEW_NAME = P_REFRESH_VIEW_NAME,
        REFRESH_VIEW_SUM_COL = P_REFRESH_VIEW_SUM_COL,
        NODE_PID = P_NODE_PID,
        NODE_WEIGHT = P_NODE_WEIGHT,
        WHERE_CLAUSE = P_WHERE_CLAUSE,
        HIDE_IF_EMPTY = P_HIDE_IF_EMPTY,
        COUNT = NULL,
        NOT_VALID = 'N',
	NODE_DEPTH = P_NODE_DEPTH			-- Added for bug 4389449
      WHERE
        (RESOURCE_ID = P_RESOURCE_ID) AND
        (SEL_ENUM_ID = P_SEL_ENUM_ID) AND
        (NODE_ID = l_node_id) AND
        (NODE_TYPE = P_NODE_TYPE) AND
        (NODE_PID = P_NODE_PID);

Line: 81

      INSERT INTO IEU_UWQ_SEL_RT_NODES
        ( SEL_RT_NODE_ID,
          CREATED_BY,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATE_LOGIN,
          RESOURCE_ID,
          SEL_ENUM_ID,
          NODE_ID,
          NODE_TYPE,
          NODE_LABEL,
          COUNT,
          DATA_SOURCE,
          VIEW_NAME,
          REFRESH_VIEW_NAME,
          REFRESH_VIEW_SUM_COL,
          MEDIA_TYPE_ID,
          SEL_ENUM_PID,
          NODE_PID,
          NODE_WEIGHT,
          WHERE_CLAUSE,
          HIDE_IF_EMPTY,
          NOT_VALID,
	  NODE_DEPTH)					-- Added for bug 4389449
        VALUES (
          IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL,
          FND_GLOBAL.USER_ID,
          SYSDATE,
          FND_GLOBAL.USER_ID,
          SYSDATE,
          FND_GLOBAL.LOGIN_ID,
          P_RESOURCE_ID,
          P_SEL_ENUM_ID,
          l_node_id,
          P_NODE_TYPE,
          P_NODE_LABEL,
          NULL,
          P_DATA_SOURCE,
          P_VIEW_NAME,
          P_REFRESH_VIEW_NAME,
          P_REFRESH_VIEW_SUM_COL,
          P_MEDIA_TYPE_ID,
          P_SEL_ENUM_PID,
          P_NODE_PID,
          P_NODE_WEIGHT,
          P_WHERE_CLAUSE,
          P_HIDE_IF_EMPTY,
          'N',
	  P_NODE_DEPTH);				-- Added for bug 4389449

Line: 136

      ROLLBACK TO start_update;

Line: 141

END UPDATE_SEL_RT_NODE;

Line: 167

  SELECT
    tl.media_type_name
  INTO
    l_node_label
  FROM
    IEU_UWQ_MEDIA_TYPES_TL tl
  WHERE
    (tl.media_type_id = IEU_CONSTS_PUB.G_MTID_BLENDED) AND
    (tl.language = userenv('LANG'));

Line: 177

  UPDATE_SEL_RT_NODE
    ( P_RESOURCE_ID,
      0,
      l_blended_node_id,          -- NODE_ID
      0,                          -- NODE_TYPE
      l_node_label,               -- NODE_LABEL
      'IEU_UWQ_BLENDED_DS',       -- DATA_SOURCE
      'IEU_UWQ_BLENDED_V',        -- VIEW_NAME
      NULL,                       -- MEDIA_TYPE_ID
      0,                          -- SEL_ENUM_PID
      0,                          -- NODE_PID
      nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value('IEU_QOR_BLENDED')), 6000),          -- NODE_WEIGHT
      '',                         -- WHERE_CLAUSE
      NULL,                        -- HIDE_IF_EMPTY
      'IEU_UWQ_BLENDED_V',        -- REFRESH_VIEW_NAME
      'QUEUE_COUNT',               -- REFRESH_VIEW_SUM_COL
      1				  -- NODE_DEPTH		-- Added for bug 4389449
    );

Line: 245

  SELECT
    tl.media_type_name,
    b.media_type_id
  INTO
    l_node_label,
    l_media_type_id
  FROM
    IEU_UWQ_MEDIA_TYPES_TL tl,
    IEU_UWQ_MEDIA_TYPES_B b
  WHERE
    (tl.media_type_id = b.media_type_id) AND
    (tl.language = userenv('LANG')) AND
    (b.media_type_id = p_media_type_id);

Line: 259

  Select meaning into l_p_node_label
    from fnd_lookup_values_vl
    where lookup_type = 'IEU_NODE_LABELS'
    and view_application_id = 696
    and lookup_code = P_P_LOOKUP_CODE;

Line: 265

  UPDATE_SEL_RT_NODE
    ( P_RESOURCE_ID,
      P_SEL_ENUM_ID,
      P_NODE_ID,             -- NODE_ID
      0,                     -- NODE_TYPE
      l_node_label,          -- NODE_LABEL
      P_DATA_SRC,            -- DATA_SOURCE
      P_VIEW_NAME,           -- VIEW_NAME
      l_media_type_id,       -- MEDIA_TYPE_ID
      P_SEL_ENUM_PID,        -- SEL_ENUM_PID
      l_media_node_id,       -- NODE_PID
      P_NODE_ID,             -- NODE_WEIGHT
      '',                    -- WHERE_CLAUSE
      P_HIDE_IF_EMPTY,       -- HIDE_IF_EMPTY
      P_VIEW_NAME,           -- REFRESH_VIEW_NAME
      'QUEUE_COUNT',          -- REFRESH_VIEW_SUM_COL
      P_NODE_DEPTH	     -- NODE_DEPTH		-- Added for bug 4389449
    );