APPS.CSM_DBOARD_SRCH_COLS_EVENT_PKG SQL Statements

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

Line: 19

 g_access_list.DELETE;

Line: 33

  SELECT NVL(LAST_RUN_DATE, to_date('1','J')) LAST_RUN_DATE
  FROM   JTM_CON_REQUEST_DATA
  WHERE  package_name =  g_dboard_sch_cols_pkg_name
  AND    procedure_name = g_dboard_sch_cols_api_name;

Line: 38

CURSOR c_delete IS
 SELECT ACC.ACCESS_ID,
        ACC.COLUMN_NAME
 FROM   CSM_DASHBOARD_SEARCH_COLS_ACC ACC
 WHERE  NOT EXISTS (SELECT 1 FROM  CSM_DASHBOARD_SEARCH_COLS B
                    WHERE  B.COLUMN_NAME=ACC.COLUMN_NAME);

Line: 45

CURSOR c_update(b_lastrundate DATE) IS
 SELECT  ACC.ACCESS_ID,
         ACC.COLUMN_NAME
 FROM    CSM_DASHBOARD_SEARCH_COLS_ACC ACC
 WHERE   EXISTS (SELECT 1 FROM  CSM_DASHBOARD_SEARCH_COLS B
                 WHERE  B.COLUMN_NAME=ACC.COLUMN_NAME
				 AND    B.LAST_UPDATE_DATE > b_lastrundate);

Line: 54

CURSOR c_insert IS
 SELECT 1 ACCESS_ID,
        B.COLUMN_NAME
 FROM   CSM_DASHBOARD_SEARCH_COLS B
 WHERE  NOT EXISTS (SELECT 1 FROM  CSM_DASHBOARD_SEARCH_COLS_ACC ACC
                    WHERE  ACC.COLUMN_NAME=B.COLUMN_NAME);

Line: 62

 SELECT CSM_DASHBOARD_SRCH_COLS_ACC_S.NEXTVAL
 FROM   DUAL;

Line: 66

 SELECT au.USER_ID
 FROM   ASG_USER au
 WHERE  au.user_id=au.owner_id;

Line: 111

  OPEN  c_delete;

Line: 112

  FETCH c_delete BULK COLLECT INTO l_tab;

Line: 113

  CLOSE c_delete;

Line: 115

  CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
                             'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 123

     DELETE FROM CSM_DASHBOARD_SEARCH_COLS_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;

Line: 131

  l_tab.DELETE;

Line: 135

  OPEN  c_update(l_lastrundate.Last_run_date);

Line: 136

  FETCH c_update BULK COLLECT INTO l_tab;

Line: 137

  CLOSE c_update;

Line: 139

  CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
                             'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 147

    UPDATE CSM_DASHBOARD_SEARCH_COLS_ACC
     	SET
         LAST_UPDATE_DATE=SYSDATE,
         LAST_UPDATED_BY=1,
         LAST_UPDATE_LOGIN=1
     	WHERE  ACCESS_ID=l_tab(I).ACCESS_ID;

Line: 157

  CSM_UTIL_PKG.LOG('UPDATE Successful ',
                             'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 159

  l_tab.DELETE;

Line: 162

  OPEN c_insert;

Line: 163

  FETCH c_insert BULK COLLECT INTO l_tab;

Line: 164

  CLOSE c_insert;

Line: 166

  CSM_UTIL_PKG.LOG('Entering INSERT to add ' || l_tab.count||' records',
                            'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 175

     INSERT INTO CSM_DASHBOARD_SEARCH_COLS_ACC
     ( ACCESS_ID,
       COLUMN_NAME,
       CREATED_BY,
       CREATION_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATE_LOGIN
     )
     VALUES
     ( l_access_id,
       l_tab(I).COLUMN_NAME,
       1,
       SYSDATE,
       1,
       SYSDATE,
       1
     );

Line: 202

  CSM_UTIL_PKG.LOG('INSERTION Successful ',
                             'CSM_DBOARD_SRCH_COLS_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 205

  UPDATE JTM_CON_REQUEST_DATA
  SET LAST_RUN_DATE = SYSDATE
  WHERE  package_name =  g_dboard_sch_cols_pkg_name
  AND    procedure_name = g_dboard_sch_cols_api_name;