APPS.CSM_AD_SEARCH_REGION_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_FIELD_TYPE    IN VARCHAR2,
                      X_BASE_VO       IN VARCHAR2,
                      X_PARAMETERS    IN VARCHAR2,
                      X_VO_TEXT_COL   IN VARCHAR2,
                      X_VO_VALUE_COL  IN VARCHAR2,
                      X_DISPLAY_SEQ   IN NUMBER,
                      X_ORIGINAL_SEQ  IN NUMBER,
                      X_IS_REMOVED    IN VARCHAR2,
                      X_DB_TYPE       IN VARCHAR2,
                      X_OPERATION     IN VARCHAR2,
                      X_OWNER         IN VARCHAR2
                      )

IS

BEGIN

 INSERT INTO CSM_AD_SEARCH_REGION_VIEW
                     (ID,
                      SEARCH_TYPE_ID,
                      LEVEL_ID,
                      LEVEL_VALUE,
                      NAME,
                      COLUMN_NAME,
                      FIELD_TYPE,
                      BASE_VO,
                      PARAMETERS,
                      VO_TEXT_COL,
                      VO_VALUE_COL,
                      DISPLAY_SEQ,
                      ORIGINAL_SEQ,
                      IS_REMOVED,
                      CREATION_DATE,
                      CREATED_BY,
                      LAST_UPDATE_DATE,
                      LAST_UPDATED_BY,
                      DB_TYPE,
                      OPERATION
                      )
                      VALUES
                      ( CSM_AD_SEARCH_REGION_VIEW_S.NEXTVAL,
                        X_SEARCH_TYPE_ID,
                        X_LEVEL_ID,
                        X_LEVEL_VALUE,
                        X_NAME,
                        X_COLUMN_NAME,
                        X_FIELD_TYPE,
                        X_BASE_VO,
                        X_PARAMETERS,
                        X_VO_TEXT_COL,
                        X_VO_VALUE_COL,
                        X_DISPLAY_SEQ,
                        X_ORIGINAL_SEQ,
                        X_IS_REMOVED,
                        SYSDATE,
                        DECODE(X_OWNER,'SEED',1,0),
                        SYSDATE,
                        DECODE(X_OWNER,'SEED',1,0),
                        X_DB_TYPE,
                        X_OPERATION
                        );

Line: 70

END INSERT_ROW;

Line: 72

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_FIELD_TYPE    IN VARCHAR2,
                     X_BASE_VO       IN VARCHAR2,
                     X_PARAMETERS    IN VARCHAR2,
                     X_VO_TEXT_COL   IN VARCHAR2,
                     X_VO_VALUE_COL  IN VARCHAR2,
                     X_DISPLAY_SEQ   IN NUMBER,
                     X_ORIGINAL_SEQ  IN NUMBER,
                     X_IS_REMOVED    IN VARCHAR2,
                     X_DB_TYPE       IN VARCHAR2,
                     X_OPERATION     IN VARCHAR2,
                     X_OWNER         IN VARCHAR2
                     )
IS

BEGIN


 UPDATE CSM_AD_SEARCH_REGION_VIEW
   SET
      NAME             =  X_NAME,
      FIELD_TYPE       =  X_FIELD_TYPE,
      BASE_VO          =  X_BASE_VO,
      PARAMETERS       =  X_PARAMETERS,
      VO_TEXT_COL      =  X_VO_TEXT_COL,
      VO_VALUE_COL     =  X_VO_VALUE_COL,
      DISPLAY_SEQ      =  X_DISPLAY_SEQ,
      ORIGINAL_SEQ     =  X_ORIGINAL_SEQ,
      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: 114

END UPDATE_ROW;

Line: 140

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

Line: 159

   INSERT_ROW (
                 X_SEARCH_TYPE_ID,
                 X_LEVEL_ID,
                 X_LEVEL_VALUE,
                 X_NAME,
                 X_COLUMN_NAME,
                 X_FIELD_TYPE,
                 X_BASE_VO,
                 X_PARAMETERS,
                 X_VO_TEXT_COL,
                 X_VO_VALUE_COL,
                 X_DISPLAY_SEQ,
                 X_ORIGINAL_SEQ,
                 X_IS_REMOVED,
                 X_DB_TYPE,
                 X_OPERATION,
                 X_OWNER
                 );

Line: 180

  UPDATE_ROW (
               X_SEARCH_TYPE_ID,
               X_LEVEL_ID,
               X_LEVEL_VALUE,
               X_NAME,
               X_COLUMN_NAME,
               X_FIELD_TYPE,
               X_BASE_VO,
               X_PARAMETERS,
               X_VO_TEXT_COL,
               X_VO_VALUE_COL,
               X_DISPLAY_SEQ,
               X_ORIGINAL_SEQ,
               X_IS_REMOVED,
               X_DB_TYPE,
               X_OPERATION,
               X_OWNER
                 );