APPS.CSM_USER_PKG SQL Statements

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

Line: 10

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

Line: 18

  an inserted record is to be processed.
***/
PROCEDURE APPLY_INSERT
         (
           p_record        IN c_user_inq%ROWTYPE,
           p_error_msg     OUT NOCOPY    VARCHAR2,
           x_return_status IN OUT NOCOPY VARCHAR2
         ) IS

BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 29

END APPLY_INSERT;

Line: 34

  an updated record is to be processed.
***/
PROCEDURE APPLY_UPDATE
         (
           p_record        IN c_USER_inq%ROWTYPE,
           p_error_msg     OUT NOCOPY    VARCHAR2,
           x_return_status IN OUT NOCOPY VARCHAR2
         )
IS
l_resp_app VARCHAR2(5);

Line: 48

  ( g_object_name || '.APPLY_UPDATE entered',
    g_object_name || '.APPLY_UPDATE',
    FND_LOG.LEVEL_PROCEDURE);

Line: 52

  UPDATE ASG_USER
  SET  MIGRATION_COMPLETED = p_record.MIGRATION_COMPLETED,
       MIGRATION_COMPLETED_DATE = p_record.MIGRATION_COMPLETED_DATE,
       MIGRATION_COMPLETION_VERSION = p_record.MIGRATION_COMPLETION_VERSION
  WHERE USER_ID=p_record.USER_ID;

Line: 59

    SELECT APPLICATION_SHORT_NAME INTO l_resp_app FROM fnd_application WHERE APPLICATION_ID=868; --CSL

Line: 72

  ( 'Leaving '|| g_object_name || '.APPLY_UPDATE',
    g_object_name || '.APPLY_UPDATE',
    FND_LOG.LEVEL_PROCEDURE);

Line: 78

     CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
       || ' for PK ' || p_record.user_id,
       g_object_name || '.APPLY_UPDATE',
       FND_LOG.LEVEL_EXCEPTION );

Line: 85

END APPLY_UPDATE;

Line: 106

    APPLY_UPDATE
      (
        p_record,
        p_error_msg,
        x_return_status
      );

Line: 116

      ( 'Delete and Insert are not supported for this entity'
        || ' for PK ' || p_record.user_id ,
        g_object_name || '.APPLY_RECORD',
        FND_LOG.LEVEL_ERROR);

Line: 192

      /*** If Yes -> delete record from inqueue ***/
      CSM_UTIL_PKG.DELETE_RECORD
        (
          p_user_name,
          p_tranid,
          r_USER.seqno$$,
          r_USER.user_id,
          g_object_name,
          g_pub_name,
          l_error_msg,
          l_process_status
        );

Line: 205

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

Line: 219

      /*** Record was not processed successfully or delete failed
      -> defer and reject record ***/
      CSM_UTIL_PKG.LOG
      ( 'Record not processed successfully, deferring and rejecting record'
        || ' for PK ' || r_USER.user_id ,
        g_object_name || '.APPLY_CLIENT_CHANGES',
        FND_LOG.LEVEL_ERROR); -- put PK column here