APPS.CSM_INVENTORY_PKG SQL Statements

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

Line: 17

  SELECT *
  FROM  csf_m_inventory_inq
  WHERE tranid$$ = b_tranid
  AND   clid$$cs = b_user_name;

Line: 25

  a fast sync. This procedure will insert the data that came from mobile into the backend tables using
  public APIs.
***/
PROCEDURE APPLY_CLIENT_CHANGES
         (
           p_user_name     IN VARCHAR2,
           p_tranid        IN NUMBER,
           p_debug_level   IN NUMBER,
           x_return_status IN OUT NOCOPY VARCHAR2
         ) IS

  l_process_status VARCHAR2(1);

Line: 47

    CSM_UTIL_PKG.DELETE_RECORD
      (
        p_user_name,
        p_tranid,
        r_inventory.seqno$$,
        r_inventory.gen_pk,
        g_object_name,
        g_pub_name,
        l_error_msg,
        l_process_status
      );

Line: 59

    /*** was delete successful? ***/
    IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
      /*** no -> rollback ***/
        CSM_UTIL_PKG.LOG
        ( 'Deleting from inqueue failed, rolling back to savepoint'
    || ' for PK ' || r_inventory.gen_pk ,'CSM_INVENTORY_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here