APPS.CSM_RESCODE_MAPPING_EVENT_PKG SQL Statements

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

Line: 29

l_prog_update_date 				jtm_con_request_data.last_run_date%TYPE;

Line: 36

SELECT 	csm_rescode_mapping_acc_s.nextval,
		b.resolution_map_detail_id
FROM 	CS_SR_RES_CODE_MAPPING_DETAIL b
WHERE 	NOT EXISTS
    	(
		SELECT	1
     	FROM 	CSM_RESCODE_MAPPING_ACC acc
     	WHERE 	acc.resolution_map_detail_id = b.resolution_map_detail_id
    	);

Line: 48

SELECT 	access_id
FROM	CSM_RESCODE_MAPPING_ACC acc,
		CS_SR_RES_CODE_MAPPING_DETAIL b
WHERE 	b.resolution_map_detail_id 	=  acc.resolution_map_detail_id
AND		b.last_update_Date			>= p_lastrundate;

Line: 56

SELECT 	access_id
FROM	CSM_RESCODE_MAPPING_ACC acc
WHERE	NOT EXISTS
		(SELECT 1
		  FROM	CS_SR_RES_CODE_MAPPING_DETAIL b
		  WHERE b.resolution_map_detail_id 	=  acc.resolution_map_detail_id
		 );

Line: 66

SELECT 	nvl(last_run_date, (sysdate - 365*50))
FROM 	jtm_con_request_data
WHERE 	package_name   = 'CSM_RESCODE_MAPPING_EVENT_PKG'
AND 	procedure_name = 'REFRESH_ACC';

Line: 78

 FETCH 	l_last_run_date_csr INTO l_prog_update_date;

Line: 82

    l_map_access_list.delete;

Line: 89

 CSM_UTIL_PKG.LOG('Entering delete ', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_STATEMENT);

Line: 111

     DELETE FROM csm_rescode_mapping_acc WHERE access_id = l_map_access_list(i);

Line: 113

   l_map_access_list.delete;

Line: 114

 END IF; -- end of process deletes

Line: 116

 CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 120

 OPEN	csr_rescode_map_upd(l_prog_update_date);

Line: 136

   l_map_access_list.delete;

Line: 137

 END IF; -- end of process updates

Line: 140

    l_resol_map_id_tbl.delete;

Line: 143

 CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_RESCODE_MAPPING_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 163

     INSERT INTO	CSM_RESCODE_MAPPING_ACC
	 				(access_id,
	 				resolution_map_detail_id,
					created_by,
					creation_date,
					last_updated_by,
					last_update_date,
					last_update_login)
            VALUES (l_map_access_list(i),
					l_resol_map_id_tbl(i),
					fnd_global.user_id,
					sysdate,
					fnd_global.user_id,
					sysdate,
					fnd_global.login_id);

Line: 179

   l_map_access_list.delete;

Line: 180

 END IF; -- end of process inserts

Line: 183

 UPDATE	jtm_con_request_data
 SET 	last_run_date = sysdate
 WHERE 	package_name  = 'CSM_RESCODE_MAPPING_EVENT_PKG'
 AND 	procedure_name= 'REFRESH_ACC';