APPS.CSM_NOTES_EVENT_PKG SQL Statements

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

Line: 30

PROCEDURE INSERT_CSM_NOTES_ACC (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE,
								p_user_id	fnd_user.user_id%TYPE)
IS

BEGIN

   CSM_ACC_PKG.Insert_Acc
  ( P_PUBLICATION_ITEM_NAMES => g_notes_pubi_name
   ,P_ACC_TABLE_NAME         => g_notes_acc_table_name
   ,P_SEQ_NAME               => g_notes_seq_name
   ,P_PK1_NAME               => g_notes_pk1_name
   ,P_PK1_NUM_VALUE          => p_jtf_note_id
   ,P_USER_ID                => p_user_id
  );

Line: 48

      'CSM_NOTES_EVENT_PKG.INSERT_CSM_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);

Line: 51

END;-- end INSERT_CSM_NOTES_ACC;

Line: 53

PROCEDURE INSERT_CSM_OBJECT_MAPPINGS_ACC (p_access_id IN NUMBER,
                                          p_mapping_id jtf_object_mappings.mapping_id%TYPE
								         )
IS
 l_sysdate 	date;

Line: 61

	INSERT INTO csm_object_mappings_acc (access_id,
                                         mapping_id,
								         created_by,
								         creation_date,
								         last_updated_by,
								         last_update_date,
								         last_update_login
                 )
						VALUES (p_access_id,
                                p_mapping_id,
								fnd_global.user_id,
								l_sysdate,
								fnd_global.user_id,
								l_sysdate,
								fnd_global.login_id
        );

Line: 82

END;-- end INSERT_CSM_OBJECT_MAPPINGS_ACC;

Line: 101

SELECT	source_object_code,
		source_object_id
FROM 	jtf_notes_b jtn
WHERE 	jtn.jtf_note_id = c_jtf_note_id;

Line: 108

SELECT	acc.user_id,acc.counter
FROM 	csm_incidents_all_acc acc
WHERE 	acc.incident_id = c_source_object_id;

Line: 114

SELECT 	acc.user_id,acc.counter
FROM 	csm_tasks_acc acc
WHERE 	acc.task_id = c_source_object_id;

Line: 120

SELECT 	acc.user_id,acc.counter
FROM 	CSM_ITEM_INSTANCES_ACC acc
WHERE 	acc.INSTANCE_ID = c_source_object_id;

Line: 126

SELECT 	acc.user_id,acc.counter
FROM 	CSM_PARTIES_ACC acc
WHERE 	acc.PARTY_ID = c_source_object_id;

Line: 132

SELECT 	DISTINCT acc.user_id,acc.counter --distinct not removed as there is no primary key with contract service id
FROM 	      csm_contr_headers_acc acc
WHERE 	acc.contract_service_id = c_source_object_id;

Line: 138

SELECT 	acc.user_id,acc.counter
FROM 	      csm_debrief_headers_acc acc
WHERE 	acc.debrief_header_id = c_source_object_id;

Line: 186

	-- insert for all the affected users
	FOR i IN 1..l_userlist.COUNT
	LOOP
        l_user_found := true;

Line: 190

   		-- insert into csm_notes_acc table
	    insert_csm_notes_acc (l_jtf_note_id, l_userlist(i));

Line: 193

          update csm_notes_acc set counter=l_countlist(i) where jtf_note_id=l_jtf_note_id and user_id=l_userlist(i);

Line: 197

		l_userlist.DELETE;

Line: 228

SELECT 	 acc.user_id,
	   	 acc.access_id
FROM   	 csm_notes_acc acc
WHERE  	 acc.jtf_note_id = p_jtf_note_id;

Line: 243

   	  CSM_ACC_PKG.Update_Acc
        ( P_PUBLICATION_ITEM_NAMES => g_notes_pubi_name
         ,P_ACC_TABLE_NAME         => g_notes_acc_table_name
         ,P_USER_ID                => l_csm_notes_foreachuser_rec.user_id
         ,p_ACCESS_ID              => l_csm_notes_foreachuser_rec.access_id
        );

Line: 277

SELECT jtf_note_id
FROM jtf_notes_b
WHERE source_object_code = p_sourceobjectcode
AND   source_object_id = p_sourceobjectid;

Line: 290

    	-- insert into csm_notes_acc table
    	insert_csm_notes_acc (l_notes_by_task_rec.jtf_note_id, p_userid);

Line: 314

SELECT acc.jtf_note_id, acc.user_id
FROM jtf_notes_b notes, csm_notes_acc acc
WHERE notes.source_object_code = p_source_object_code
AND   notes.source_object_id = p_source_object_id
AND notes.jtf_note_id = acc.jtf_note_id
AND acc.user_id = p_user_id;

Line: 330

          CSM_ACC_PKG.Delete_Acc
          ( P_PUBLICATION_ITEM_NAMES => g_notes_pubi_name
           ,P_ACC_TABLE_NAME         => g_notes_acc_table_name
           ,P_PK1_NAME               => g_notes_pk1_name
           ,P_PK1_NUM_VALUE          => l_notes_by_task_rec.jtf_note_id
           ,P_USER_ID                => l_notes_by_task_rec.user_id
          );

Line: 364

SELECT CSM_OBJECT_MAPPINGS_ACC_S.NEXTVAL access_id, jom.mapping_id
FROM jtf_object_mappings jom
WHERE jom.source_object_code IN ('PARTY', 'TASK', 'SR', 'CP','OKS_COV_NOTE','SD')
AND NVL(end_date, SYSDATE) >= SYSDATE
AND NOT EXISTS
(SELECT 1
 FROM csm_object_mappings_acc acc
 WHERE acc.mapping_id = jom.mapping_id);

Line: 387

     INSERT_CSM_OBJECT_MAPPINGS_ACC(r_mappings_rec.access_id, r_mappings_rec.mapping_id);