APPS.CSM_AD_SEARCH_TITLE_VIEW_PKG SQL Statements

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

Line: 3

PROCEDURE INSERT_ROW (
                      X_SEARCH_TYPE    IN VARCHAR2,
                      X_LEVEL_ID       IN NUMBER,
                      X_LEVEL_VALUE    IN NUMBER,
                      X_SEARCH_TITLE   IN VARCHAR2,
                      X_VO_NAME        IN VARCHAR2,
                      X_SEARCH_TYPE_ID IN NUMBER,
                      X_OWNER          IN VARCHAR2
                      )
IS

BEGIN

  INSERT INTO CSM_AD_SEARCH_TITLE_VIEW
                           (ID,
                            SEARCH_TYPE,
                            LEVEL_ID,
                            LEVEL_VALUE,
                            SEARCH_TITLE,
                            VO_NAME,
                            CREATION_DATE,
                            CREATED_BY,
                            LAST_UPDATE_DATE,
                            LAST_UPDATED_BY,
                            SEARCH_TYPE_ID)
                          VALUES
                          ( CSM_AD_SEARCH_TITLE_VIEW_S.NEXTVAL,
                            X_SEARCH_TYPE,
                            X_LEVEL_ID,
                            X_LEVEL_VALUE,
                            X_SEARCH_TITLE,
                            X_VO_NAME,
                            SYSDATE,
                            DECODE(X_OWNER,'SEED',1,0),
                            SYSDATE,
                            DECODE(X_OWNER,'SEED',1,0),
                            X_SEARCH_TYPE_ID
                            );

Line: 44

END INSERT_ROW;

Line: 46

PROCEDURE UPDATE_ROW (
                     X_SEARCH_TYPE    IN VARCHAR2,
                     X_LEVEL_ID       IN NUMBER,
                     X_LEVEL_VALUE    IN NUMBER,
                     X_SEARCH_TITLE   IN VARCHAR2,
                     X_VO_NAME        IN VARCHAR2,
                     X_SEARCH_TYPE_ID IN NUMBER,
                     X_OWNER          IN VARCHAR2
                     )

IS

BEGIN


  UPDATE CSM_AD_SEARCH_TITLE_VIEW
   SET
      SEARCH_TITLE     =  X_SEARCH_TITLE,
      VO_NAME          =  X_VO_NAME,
      SEARCH_TYPE_ID   =  X_SEARCH_TYPE_ID,
      LAST_UPDATE_DATE =  SYSDATE,
      LAST_UPDATED_BY  =  DECODE(X_OWNER,'SEED',1,0)
   WHERE SEARCH_TYPE   =  X_SEARCH_TYPE;

Line: 71

END UPDATE_ROW;

Line: 86

   SELECT 1
   FROM  CSM_AD_SEARCH_TITLE_VIEW
   WHERE SEARCH_TYPE=X_SEARCH_TYPE;

Line: 101

   INSERT_ROW (
                 X_SEARCH_TYPE,
                 X_LEVEL_ID,
                 X_LEVEL_VALUE,
                 X_SEARCH_TITLE,
                 X_VO_NAME,
                 X_SEARCH_TYPE_ID,
                 X_OWNER
                 );

Line: 114

   UPDATE_ROW (
                X_SEARCH_TYPE,
                X_LEVEL_ID,
                X_LEVEL_VALUE,
                X_SEARCH_TITLE,
                X_VO_NAME,
                X_SEARCH_TYPE_ID,
                X_OWNER
                 );