APPS.CSM_PARTY_SITE_EVENT_PKG SQL Statements

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

Line: 12

procedure insert_party_sites_acc (p_party_site_id hz_party_sites.party_site_id%type,
								p_party_id	hz_parties.party_id%type,
  								p_user_id	fnd_user.user_id%type)
is
 l_sysdate 	date;

Line: 20

	insert into csm_party_sites_acc (party_site_id,
									party_id,
									 user_id,
									created_by,
									creation_date,
									last_updated_by,
									last_update_date,
									last_update_login
									)
							values (p_party_site_id,
							        p_party_id,
									p_user_id,
									fnd_global.user_id,
									l_sysdate,
									fnd_global.user_id,
									l_sysdate,
									fnd_global.login_id
									);

Line: 43

end insert_party_sites_acc;

Line: 58

select party_id
from hz_party_sites
where party_site_id = p_party_site_id;

Line: 70

 CSM_ACC_PKG.Insert_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
      ,P_ACC_TABLE_NAME         => g_acc_table_name1
      ,P_SEQ_NAME               => g_acc_sequence_name1
      ,P_PK1_NAME               => g_pk1_name1
      ,P_PK1_NUM_VALUE          => p_party_site_id
      ,P_PK2_NAME               => g_pk2_name1
      ,P_PK2_NUM_VALUE          => l_party_id
      ,P_USER_ID                => p_user_id
     );

Line: 114

select party_id
FROM   hz_party_sites ps
WHERE  party_site_id = p_party_site_id
AND NOT EXISTS
      ( SELECT 1
        FROM   CSM_INCIDENTS_ALL_ACC acc,
               CS_INCIDENTS_ALL_B  B
        Where  B.Incident_Id          = Acc.Incident_Id
        AND    B.INCIDENT_LOCATION_TYPE ='HZ_PARTY_SITE'
        AND    ACC.USER_ID            = C_USER_ID
        AND    ps.party_site_id       = b.incident_location_id);

Line: 136

    CSM_ACC_PKG.Delete_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
      ,P_ACC_TABLE_NAME         => g_acc_table_name1
      ,P_PK1_NAME               => g_pk1_name1
      ,P_PK1_NUM_VALUE          => p_party_site_id
      ,P_PK2_NAME               => g_pk2_name1
      ,P_PK2_NUM_VALUE          => l_party_id
      ,P_USER_ID                => p_user_id
     );

Line: 180

SELECT acc.access_id, acc.user_id
FROM csm_party_sites_acc acc
WHERE party_site_id = p_party_site_id;

Line: 190

    CSM_ACC_PKG.Update_Acc
        ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
         ,P_ACC_TABLE_NAME         => g_acc_table_name1
         ,P_USER_ID                => r_party_site_acc_rec.user_id
         ,P_ACCESS_ID              => r_party_site_acc_rec.access_id
        );

Line: 222

SELECT acc.access_id,
       acc.user_id
FROM hz_party_sites ps,
     csm_party_sites_acc acc
WHERE ps.location_id = p_location_id
AND acc.party_site_id = ps.party_site_id;

Line: 241

        CSM_ACC_PKG.Update_Acc
             ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
              ,P_ACC_TABLE_NAME         => g_acc_table_name1
              ,P_USER_ID                => r_party_site_rec.user_id
              ,P_ACCESS_ID              => r_party_site_rec.access_id
              );

Line: 275

SELECT access_id, user_id
FROM csm_party_sites_acc
WHERE party_site_id = p_party_site_id;

Line: 292

        CSM_ACC_PKG.Update_Acc
                ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
                 ,P_ACC_TABLE_NAME         => g_acc_table_name1
                 ,P_USER_ID                => r_party_site_rec.user_id
                 ,P_ACCESS_ID              => r_party_site_rec.access_id
                );