APPS.CSL_SERVICEL_WRAPPER_PKG SQL Statements

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

Line: 37

        /*** found item -> delete from array and return TRUE ***/
        p_pubitems_tbl.DELETE( l_index );

Line: 386

  procedures which 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
         ) IS
  l_pubitems_tbl  asg_apply.vc2_tbl_type;

Line: 630

  applied and needs to be deleted from the in-queue.
***/
PROCEDURE DELETE_RECORD
         (
           p_user_name     IN VARCHAR2,
           p_tranid        IN NUMBER,
           p_seqno         IN NUMBER,
           p_pk            IN VARCHAR2,
           p_object_name   IN VARCHAR2,
           p_pub_name      IN VARCHAR2,
           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: 650

    , v_message     => 'Entering ' || g_object_name || '.DELETE_RECORD'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 654

  asg_apply.delete_row(p_user_name,
                       p_tranid,
                       p_pub_name,
                       p_seqno,
                       x_return_status);

Line: 662

    fnd_msg_pub.Add_Exc_Msg( g_object_name, 'DELETE_RECORD', 'Unknown error');

Line: 673

    , v_message     => 'Leaving ' || g_object_name || '.DELETE_RECORD'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 682

    , v_message     => 'Exception occurred in DELETE_RECORD:' || fnd_global.local_chr(10) || sqlerrm
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line: 686

  fnd_msg_pub.Add_Exc_Msg( g_object_name, 'DELETE_RECORD', sqlerrm);

Line: 696

    , v_message     => 'Leaving ' || g_object_name || '.DELETE_RECORD'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 700

END DELETE_RECORD;

Line: 756

  /*** defer successful -> reject record except for updates ***/
  IF p_dml_type = 'I' THEN
    IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
      jtm_message_log_pkg.Log_Msg
      ( v_object_id   => p_pk
      , v_object_name => p_object_name
      , v_message     => 'Rejecting record'
      , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 892

  SELECT RESOURCE_ID
  FROM ASG_USER
  WHERE USER_ID = b_user_id;

Line: 917

 This procedure gets called when a user gets deleted
***/
PROCEDURE DELETE_ACCESS_RECORDS ( P_USER_ID IN NUMBER )
IS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 923

  SELECT RESOURCE_ID
  FROM ASG_USER
  WHERE USER_ID = b_user_id;

Line: 932

  CSL_USER_PKG.DELETE_USER( P_RESOURCE_ID   => r_user.RESOURCE_ID
                          , X_RETURN_STATUS => x_status);

Line: 938

 /*** if delete user returned error then raise exception ***/
 IF x_status <> FND_API.G_RET_STS_SUCCESS THEN
   ROLLBACK;

Line: 945

END DELETE_ACCESS_RECORDS;