APPS.CSM_SR_TYPE_MAP_EVENT_PKG SQL Statements

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

Line: 31

l_prog_update_date 				jtm_con_request_data.last_run_date%TYPE;

Line: 40

SELECT 	CSM_SR_TYPE_MAPPING_ACC_S.nextval,
		usr.user_id,
		b.incident_type_id,
		b.responsibility_id
FROM 	CS_SR_TYPE_MAPPING b,
		ASG_USER           usr
WHERE	usr.responsibility_id = b.responsibility_id
AND     usr.user_id           = usr.owner_id
AND NOT EXISTS
    	(
		SELECT	1
     	FROM 	CSM_SR_TYPE_MAPPING_ACC acc
     	WHERE 	acc.incident_type_id 	= b.incident_type_id
     	AND		acc.responsibility_id	= b.responsibility_id
		AND		acc.user_id				= usr.user_id
    	);

Line: 59

SELECT 	access_id,user_id
FROM	CSM_SR_TYPE_MAPPING_ACC acc,
		CS_SR_TYPE_MAPPING b
WHERE 	acc.incident_type_id 	= b.incident_type_id
AND		acc.responsibility_id	= b.responsibility_id
AND		b.last_update_Date	   >= p_lastrundate;

Line: 69

SELECT 	access_id,user_id
FROM	CSM_SR_TYPE_MAPPING_ACC acc
WHERE	NOT EXISTS
		(SELECT 1
		  FROM	CS_SR_TYPE_MAPPING b
		  WHERE b.incident_type_id 	= acc.incident_type_id
		  AND	b.responsibility_id	= acc.responsibility_id
		 );

Line: 80

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

Line: 92

 FETCH 	l_last_run_date_csr INTO l_prog_update_date;

Line: 96

    l_map_access_list.delete;

Line: 102

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

Line: 122

     DELETE FROM CSM_SR_TYPE_MAPPING_ACC WHERE access_id = l_map_access_list(i) AND user_id = l_user_list(i) ;

Line: 124

   l_map_access_list.delete;

Line: 125

   l_user_list.delete;

Line: 126

 END IF; -- end of process deletes

Line: 128

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

Line: 132

 OPEN	csr_sr_type_map_upd(l_prog_update_date);

Line: 146

   l_map_access_list.delete;

Line: 147

   l_user_list.delete;

Line: 148

 END IF; -- end of process updates

Line: 151

    l_sr_type_id_tbl.delete;

Line: 155

    l_responsibility_id_tbl.delete;

Line: 158

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

Line: 176

     INSERT INTO	CSM_SR_TYPE_MAPPING_ACC
	 				(access_id,
					user_id,
	 				incident_type_id,
					responsibility_id,
					created_by,
					creation_date,
					last_updated_by,
					last_update_date,
					last_update_login)
            VALUES (l_map_access_list(i),
				    l_user_list(i),
					l_sr_type_id_tbl(i),
					l_responsibility_id_tbl(i),
					fnd_global.user_id,
					sysdate,
					fnd_global.user_id,
					sysdate,
					fnd_global.login_id);

Line: 196

   l_map_access_list.delete;

Line: 197

   l_user_list.delete;

Line: 198

 END IF; -- end of process inserts

Line: 201

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