APPS.CSM_PO_LOCATIONS_EVENT_PKG SQL Statements

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

Line: 38

   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_location_id
      ,P_PK2_NAME               => g_pk2_name1
      ,P_PK2_NUM_VALUE          => p_site_use_id
      ,P_USER_ID                => p_user_id
     );

Line: 84

    CSM_ACC_PKG.Update_Acc
       ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
        ,P_ACC_TABLE_NAME         => g_acc_table_name1
        ,P_ACCESS_ID              => l_access_id
        ,P_USER_ID                => p_user_id
        );

Line: 116

SELECT PLA.LOCATION_ID,
       hps.party_site_id,
       csu.site_use_id,
       cas.status,
       rcr.resource_id,
       jtrs.user_id
FROM   po_location_associations_all pla,
       hz_cust_site_uses_all        csu,
       hz_cust_acct_sites_all       cas,
       csp_rs_cust_relations        rcr,
       hz_party_sites               hps,
       jtf_rs_resource_extns        jtrs
WHERE  csu.site_use_id       = pla.site_use_id
AND    csu.site_use_code     = 'SHIP_TO'
AND    csu.cust_acct_site_id = cas.cust_acct_site_id
AND    cas.cust_account_id   = rcr.customer_id
AND    cas.party_site_id     = hps.party_site_id
AND    cas.cust_acct_site_id = p_cust_acct_site_id
AND    jtrs.resource_id      = rcr.resource_id;

Line: 138

SELECT 1
FROM csm_po_loc_ass_all_acc
WHERE location_id = p_location_id
AND site_use_id = p_site_use_id
AND user_id = p_user_id;

Line: 172

            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          => r_cust_acc_site_upd_rec.location_id
              ,P_PK2_NAME               => g_pk2_name1
              ,P_PK2_NUM_VALUE          => r_cust_acc_site_upd_rec.site_use_id
              ,P_USER_ID                => r_cust_acc_site_upd_rec.user_id
             );