APPS.AP_WEB_DB_PAGE_SETTING_PKG SQL Statements

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

Line: 25

                      p_selectedTab IN VARCHAR2,
                      p_sortedColumn IN VARCHAR2,
                      p_sortOrderCode IN VARCHAR2
) IS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 32

  SELECT *
  FROM   OIE_CURRENT_PAGE_SETTING
  WHERE  user_id = p_userId
     AND page_Name = p_pageName
     AND object_Name = p_objectName
     AND object_Type_code = p_objectTypeCode
  FOR UPDATE OF USER_ID NOWAIT;

Line: 50

      INSERT INTO OIE_CURRENT_PAGE_SETTING(
        USER_ID,
        PAGE_NAME,
        OBJECT_NAME,
        OBJECT_TYPE_CODE,
        HIDE_FLAG,
        SELECTED_TAB,
        SORTED_COLUMN,
        SORT_ORDER_CODE,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY)
      VALUES (
        p_userId,
        p_pageName,
        p_objectName,
        p_objectTypeCode,
        p_hideFlag,
        p_selectedTab,
        p_sortedColumn,
        p_sortOrderCode,
        SYSDATE,
        nvl(fnd_global.user_id, -1),
        fnd_global.conc_login_id,
        SYSDATE,
        nvl(fnd_global.user_id, -1));

Line: 81

    UPDATE OIE_CURRENT_PAGE_SETTING
    SET hide_flag = p_hideFlag,
        selected_tab = p_selectedTab,
        sorted_column = p_sortedColumn,
        sort_order_code = p_sortOrderCode
    WHERE CURRENT OF settingCursor;