APPS.CSM_AD_SIMPLE_SEARCH_VIEW_PKG SQL Statements

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

Line: 3

PROCEDURE INSERT_ROW (
                      X_SEARCH_TYPE_ID   IN NUMBER,
                      X_LEVEL_ID      IN NUMBER,
                      X_LEVEL_VALUE   IN NUMBER,
                      X_NAME          IN VARCHAR2,
                      X_COLUMN_NAME   IN VARCHAR2,
                      X_DISPLAY_SEQ   IN NUMBER,
                      X_ORIGINAL_SEQ  IN NUMBER,
                      X_GROUP_TYPE    IN VARCHAR2,
                      X_IS_REMOVED    IN VARCHAR2,
                      X_DB_TYPE       IN VARCHAR2,
                      X_OPERATION     IN VARCHAR2,
                      X_OWNER         IN VARCHAR2
                      )
IS

BEGIN

  INSERT INTO CSM_AD_SIMPLE_SEARCH_VIEW
                           (ID,
                            SEARCH_TYPE_ID,
                            LEVEL_ID,
                            LEVEL_VALUE,
                            NAME,
                            COLUMN_NAME,
                            DISPLAY_SEQ,
                            ORIGINAL_SEQ,
                            GROUP_TYPE,
                            IS_REMOVED,
                            DB_TYPE,
                            OPERATION,
                            CREATION_DATE,
                            CREATED_BY,
                            LAST_UPDATE_DATE,
                            LAST_UPDATED_BY)
                          VALUES
                          ( CSM_AD_SIMPLE_SEARCH_VIEW_S.NEXTVAL,
                            X_SEARCH_TYPE_ID,
                            X_LEVEL_ID,
                            X_LEVEL_VALUE,
                            X_NAME,
                            X_COLUMN_NAME,
                            X_DISPLAY_SEQ,
                            X_ORIGINAL_SEQ,
                            X_GROUP_TYPE,
                            X_IS_REMOVED,
                            X_DB_TYPE,
                            X_OPERATION,
                            SYSDATE,
                            DECODE(X_OWNER,'SEED',1,0),
                            SYSDATE,
                            DECODE(X_OWNER,'SEED',1,0)
                            );

Line: 59

END INSERT_ROW;

Line: 61

PROCEDURE UPDATE_ROW (
                     X_SEARCH_TYPE_ID   IN NUMBER,
                     X_LEVEL_ID      IN NUMBER,
                     X_LEVEL_VALUE   IN NUMBER,
                     X_NAME          IN VARCHAR2,
                     X_COLUMN_NAME   IN VARCHAR2,
                     X_DISPLAY_SEQ   IN NUMBER,
                     X_ORIGINAL_SEQ  IN NUMBER,
                     X_GROUP_TYPE    IN VARCHAR2,
                     X_IS_REMOVED    IN VARCHAR2,
                     X_DB_TYPE       IN VARCHAR2,
                     X_OPERATION     IN VARCHAR2,
                     X_OWNER         IN VARCHAR2
                     )


IS

BEGIN


 UPDATE CSM_AD_SIMPLE_SEARCH_VIEW
   SET
      NAME             =  X_NAME,
      DISPLAY_SEQ      =  X_DISPLAY_SEQ,
      ORIGINAL_SEQ     =  X_ORIGINAL_SEQ,
      GROUP_TYPE       =  X_GROUP_TYPE,
      IS_REMOVED       =  X_IS_REMOVED,
      DB_TYPE          =  X_DB_TYPE,
      OPERATION        =  X_OPERATION,
      LAST_UPDATE_DATE =  SYSDATE,
      LAST_UPDATED_BY  =  DECODE(X_OWNER,'SEED',1,0)
   WHERE COLUMN_NAME   =  X_COLUMN_NAME
   AND SEARCH_TYPE_ID     = X_SEARCH_TYPE_ID ;

Line: 97

END UPDATE_ROW;

Line: 118

   SELECT 1
   FROM  CSM_AD_SIMPLE_SEARCH_VIEW
   WHERE COLUMN_NAME =X_COLUMN_NAME
   AND   SEARCH_TYPE_ID=X_SEARCH_TYPE_ID;

Line: 137

   INSERT_ROW (
                  X_SEARCH_TYPE_ID,
                 X_LEVEL_ID,
                 X_LEVEL_VALUE,
                 X_NAME,
                 X_COLUMN_NAME,
                 X_DISPLAY_SEQ,
                 X_ORIGINAL_SEQ,
                 X_GROUP_TYPE,
                 X_IS_REMOVED,
                 X_DB_TYPE,
                 X_OPERATION,
                 X_OWNER
                 );

Line: 154

   UPDATE_ROW (
                X_SEARCH_TYPE_ID,
                X_LEVEL_ID,
                X_LEVEL_VALUE,
                X_NAME,
                X_COLUMN_NAME,
                X_DISPLAY_SEQ,
                X_ORIGINAL_SEQ,
                X_GROUP_TYPE,
                X_IS_REMOVED,
                X_DB_TYPE,
                X_OPERATION,
                X_OWNER
               );