APPS.CSM_PROBCODE_MAPPING_EVENT_PKG SQL Statements

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

Line: 25

l_prog_update_date				jtm_con_request_data.last_run_date%TYPE;

Line: 36

SELECT 	csm_probcode_mapping_acc_s.nextval,
		b.problem_map_detail_id
FROM 	CS_SR_PROB_CODE_MAPPING_DETAIL b
WHERE 	NOT EXISTS
    	(
		SELECT	1
     	FROM 	CSM_PROBCODE_MAPPING_ACC acc
     	WHERE 	acc.problem_map_detail_id = b.problem_map_detail_id
    	);

Line: 49

SELECT 	access_id
FROM 	CSM_PROBCODE_MAPPING_ACC		acc,
     	CS_SR_PROB_CODE_MAPPING_DETAIL 	b
WHERE 	acc.problem_map_detail_id 		 = b.problem_map_detail_id
AND 	b.last_update_date >= p_lastrundate;

Line: 58

SELECT 	access_id
FROM	CSM_PROBCODE_MAPPING_ACC acc
WHERE	NOT EXISTS
		(SELECT 1
		  FROM	CS_SR_PROB_CODE_MAPPING_DETAIL b
		  WHERE b.problem_map_detail_id 	=  acc.problem_map_detail_id
		 );

Line: 68

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

Line: 83

 FETCH  l_last_run_date_csr INTO l_prog_update_date;

Line: 87

   l_map_access_list.delete;

Line: 94

 CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_STATEMENT);

Line: 115

     DELETE FROM csm_probcode_mapping_acc WHERE access_id = l_map_access_list(i);

Line: 117

   l_map_access_list.delete;

Line: 118

 END IF; -- end of process deletes

Line: 120

 CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);

Line: 123

 OPEN 	csr_probcode_map_upd(l_prog_update_date);

Line: 139

   l_map_access_list.delete;

Line: 140

 END IF; -- end of process updates

Line: 143

    l_problem_map_detail_id_tbl.delete;

Line: 146

 CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_PROBCODE_MAPPING_EVENT_PKG.Refresh_probcode_mapping_acc',FND_LOG.LEVEL_PROCEDURE);

Line: 166

     INSERT INTO csm_probcode_mapping_acc
	 			(access_id,
				 problem_map_detail_id,
				 created_by, creation_date,
				 last_updated_by,
				 last_update_date,
				 last_update_login)
                 VALUES
				 (l_map_access_list(i),
				 l_problem_map_detail_id_tbl(i),
				 fnd_global.user_id,
				 l_run_date,
				 fnd_global.user_id,
				 l_run_date,
				 fnd_global.login_id);

Line: 182

   l_map_access_list.delete;

Line: 183

 END IF; -- end of process inserts

Line: 186

 UPDATE	jtm_con_request_data
 SET 	last_run_date 	= l_run_date
 WHERE 	package_name 	= 'CSM_PROBCODE_MAPPING_EVENT_PKG'
 AND 	procedure_name 	= 'REFRESH_PROBCODE_MAPPING_ACC';