APPS.FND_SEARCH_EVENT SQL Statements

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

Line: 11

    UPDATE FND_SEARCHABLE_CHANGE_LOG
    set CRAWL_STATUS='Y'
    where object_name=obj_name;

Line: 38

         DELETE FROM FND_SEARCHABLE_CHANGE_LOG
         WHERE  OBJECT_NAME=obj_name
         AND CHANGE_TYPE IN ('INSERT','UPDATE')
         AND CRAWL_STATUS='Y';

Line: 42

      elsif (change_Type ='DELETE') then
         DELETE FROM FND_SEARCHABLE_CHANGE_LOG
         WHERE  OBJECT_NAME=obj_name
         AND CHANGE_TYPE ='DELETE'
         AND CRAWL_STATUS='Y';

Line: 48

         DELETE FROM FND_SEARCHABLE_CHANGE_LOG
         WHERE  OBJECT_NAME=obj_name
         AND CHANGE_TYPE ='ERROR'
         AND CRAWL_STATUS='Y';

Line: 79

         UPDATE FND_SEARCHABLE_CHANGE_LOG
         SET CRAWL_STATUS=NULL
         WHERE  OBJECT_NAME=obj_name
         AND CHANGE_TYPE IN ('INSERT','UPDATE')
         AND CRAWL_STATUS='Y';

Line: 84

      elsif (change_Type ='DELETE') then
         UPDATE FND_SEARCHABLE_CHANGE_LOG
         SET CRAWL_STATUS=NULL
         WHERE  OBJECT_NAME=obj_name
         AND CHANGE_TYPE ='DELETE'
         AND CRAWL_STATUS='Y';

Line: 91

         UPDATE FND_SEARCHABLE_CHANGE_LOG
         SET CRAWL_STATUS=NULL
         WHERE  OBJECT_NAME=obj_name
         AND CHANGE_TYPE ='ERROR'
         AND CRAWL_STATUS='Y';

Line: 160

        insert into fnd_searchable_change_log
        (
            EVENT_INSTANCE_ID,
            OBJECT_NAME,
            CHANGE_TYPE,
            ID_TYPE,
            ROW_FROM,
            ROW_TO,
            PK_NAME_1,
            PK_VALUE_1,
            PK_NAME_2,
            PK_VALUE_2,
            PK_NAME_3,
            PK_VALUE_3,
            PK_NAME_4,
            PK_VALUE_4,
            PK_NAME_5,
            PK_VALUE_5,
            CHANGE_DATE,
            CRAWL_STATUS,
            DATA_FEED_URL
            )values
        (
            FND_SEARCH_EVENTS_SEQ.nextVal,
            object_name,
            change_type ,
            id_type,
            row_id_from,
            row_id_to ,
            pk_name_1 ,
            pk_value_1,
            pk_name_2 ,
            pk_value_2 ,
            pk_name_3,
            pk_value_3,
            pk_name_4 ,
            pk_value_4 ,
            pk_name_5 ,
            pk_value_5 ,
            Sysdate,
            status,
            feed_url
        );