APPS.CSM_SR_CONTACT_EVENT_PKG SQL Statements

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

Line: 21

SELECT access_id, user_id
FROM csm_sr_contacts_acc
WHERE sr_contact_point_id = p_sr_contact_point_id;

Line: 44

            CSM_ACC_PKG.Update_Acc
                ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name
                 ,P_ACC_TABLE_NAME         => g_srcntacts_acc_table_name
                 ,P_USER_ID                => l_user_rec.user_id
                 ,P_ACCESS_ID              => l_user_rec.access_id
                );

Line: 76

    CSM_ACC_PKG.Insert_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name
      ,P_ACC_TABLE_NAME         => g_srcntacts_acc_table_name
      ,P_SEQ_NAME               => g_srcntacts_seq_name
      ,P_PK1_NAME               => g_srcntacts_pk1_name
      ,P_PK1_NUM_VALUE          => p_sr_contact_point_id
      ,P_USER_ID                => p_user_id
     );

Line: 106

SELECT acc.incident_id,
       acc.user_id
FROM cs_hz_sr_contact_points srcp,
     csm_incidents_all_acc acc
WHERE srcp.sr_contact_point_id = p_sr_contact_point_id
AND acc.incident_id = srcp.incident_id
AND NOT EXISTS
(SELECT 1
 FROM csm_sr_contacts_acc cont_acc
 WHERE cont_acc.sr_contact_point_id = srcp.sr_contact_point_id
 AND cont_acc.user_id = acc.user_id)
;

Line: 153

   CSM_ACC_PKG.Delete_Acc
    ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name
     ,P_ACC_TABLE_NAME         => g_srcntacts_acc_table_name
     ,P_PK1_NAME               => g_srcntacts_pk1_name
     ,P_PK1_NUM_VALUE          => p_sr_contact_point_id
     ,P_USER_ID                => p_user_id
    );

Line: 182

SELECT acc.incident_id,
       acc.user_id
FROM cs_hz_sr_contact_points srcp,
     csm_incidents_all_acc acc
WHERE srcp.sr_contact_point_id = p_sr_contact_point_id
AND acc.incident_id = srcp.incident_id
AND EXISTS
(SELECT 1
 FROM csm_sr_contacts_acc cont_acc
 WHERE cont_acc.sr_contact_point_id = srcp.sr_contact_point_id
 AND cont_acc.user_id = acc.user_id)
;

Line: 229

SELECT acc.user_id,
       acc.access_id
FROM csm_sr_contacts_acc acc,
     cs_hz_sr_contact_points pts
WHERE acc.sr_contact_point_id = pts.sr_contact_point_id
AND pts.contact_point_id = p_contact_point_id;

Line: 249

            CSM_ACC_PKG.Update_Acc
                ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name
                 ,P_ACC_TABLE_NAME         => g_srcntacts_acc_table_name
                 ,P_USER_ID                => l_user_rec.user_id
                 ,P_ACCESS_ID              => l_user_rec.access_id
                );