DBA Data[Home] [Help]

APPS.CSL_REQUIREMENTS_PKG SQL Statements

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

Line: 18

  SELECT reql.*
  FROM   CSL_CSP_REQUIREMENT_LNS_inq reql, CSL_CSP_REQUIREMENT_HDR_inq reqh
  WHERE  reql.tranid$$ = b_tranid
  AND    reql.clid$$cs = b_user_name
  AND    reql.requirement_header_id = reqh.requirement_header_id;
Line: 27

  This one is executed after all requirement lines with headers have been deleted from the inqueue.
  The requirement lines without header remain then.
***/
CURSOR c_requirements_no_headers ( b_user_name VARCHAR2, b_tranid NUMBER) is
  SELECT *
  FROM   CSL_CSP_REQUIREMENT_LNS_inq
  WHERE  tranid$$ = b_tranid
  AND    clid$$cs = b_user_name;
Line: 37

  This procedure is called by APPLY_CLIENT_CHANGES when an inserted record is to be processed.
  If p_get_inqueue_header = TRUE  => fetch requirement header from the requirement header inqueue.
  If p_get_inqueue_header = FALSE => fetch requirement header from Apps.
***/
PROCEDURE APPLY_INSERT
         (
           p_record              IN      c_requirements%ROWTYPE,
           p_user_name           IN      VARCHAR2,
           p_tranid              IN      NUMBER,
           p_get_inqueue_header  IN      BOOLEAN,
           p_error_msg           OUT NOCOPY     VARCHAR2,
           x_return_status       IN OUT NOCOPY  VARCHAR2
         ) IS

  l_header_rec   CSP_PARTS_REQUIREMENT.HEADER_REC_TYPE;
Line: 65

    SELECT *
    FROM   CSL_CSP_REQUIREMENT_HDR_inq
    WHERE  tranid$$ = b_tranid
    AND    clid$$cs = b_user_name
    AND    requirement_header_id = b_requirement_header_id;
Line: 75

    SELECT *
    FROM   CSP_REQUIREMENT_HEADERS
    WHERE  requirement_header_id = b_requirement_header_id;
Line: 87

    , v_message     => 'Entering ' || g_object_name || '.APPLY_INSERT'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
Line: 163

    , v_message     => 'Leaving ' || g_object_name || '.APPLY_INSERT'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
Line: 172

    , v_message     => 'Exception occurred in APPLY_INSERT:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
Line: 176

  fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
Line: 186

    , v_message     => 'Leaving ' || g_object_name || '.APPLY_INSERT'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
Line: 191

END APPLY_INSERT;
Line: 194

  This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.
***/
PROCEDURE APPLY_UPDATE
         (
           p_record        IN     c_requirements%ROWTYPE,
           p_error_msg     OUT NOCOPY    VARCHAR2,
           x_return_status IN OUT NOCOPY VARCHAR2
         ) IS
BEGIN
  IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
    jtm_message_log_pkg.Log_Msg
    ( v_object_id   => p_record.requirement_line_id -- put PK column here
    , v_object_name => g_object_name
    , v_message     => 'Entering ' || g_object_name || '.APPLY_UPDATE'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
Line: 226

    , v_message     => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
Line: 235

    , v_message     => 'Exception occurred in APPLY_UPDATE:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
Line: 239

  fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
Line: 249

    , v_message     => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
Line: 254

END APPLY_UPDATE;
Line: 291

    APPLY_INSERT
      (
        p_record,
        p_user_name,
        p_tranid,
        p_get_inqueue_header,
        p_error_msg,
        x_return_status
      );
Line: 302

    APPLY_UPDATE
      (
       p_record,
       p_error_msg,
       x_return_status
     );
Line: 314

        , v_message     => 'Delete is not supported for this entity'
        , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
Line: 381

   This procedure is called by PROCESS_REQS and deletes all requirement headers from the inqueue,
   for a given user and transaction.
***/
PROCEDURE DELETE_REQ_HEADERS_FROM_INQ
         (
           p_user_name     IN      VARCHAR2,
           p_tranid        IN      NUMBER,
           x_return_status IN OUT NOCOPY  VARCHAR2
         ) IS

  l_error_msg VARCHAR2(4000);
Line: 395

    This one is to be executed after all requirement lines with headers have been deleted from the inqueue.
  ***/
  CURSOR c_get_req_headers_from_inq ( b_user_name VARCHAR2, b_tranid NUMBER) is
    SELECT *
    FROM   CSL_CSP_REQUIREMENT_HDR_inq
    WHERE  tranid$$ = b_tranid
    AND    clid$$cs = b_user_name;
Line: 409

    , v_message     => 'Entering ' || g_object_name || '.DELETE_REQ_HEADERS_FROM_INQ'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
Line: 417

    CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
      (
        p_user_name,
        p_tranid,
        r_get_req_headers_from_inq.seqno$$,
        r_get_req_headers_from_inq.requirement_header_id, -- put PK column here
        g_object_name,
        g_pub_name2,
        l_error_msg,
        x_return_status
      );
Line: 429

    /*** was delete successful? ***/
    IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
      /*** no -> rollback ***/
      IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
        jtm_message_log_pkg.Log_Msg
        ( v_object_id   => r_get_req_headers_from_inq.requirement_header_id -- put PK column here
        , v_object_name => g_object_name
        , v_message     => 'Deleting from inqueue failed, rolling back to savepoint'
        , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
Line: 443

      /*** Record was not processed successfully or delete failed -> defer and reject record ***/
      IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
        jtm_message_log_pkg.Log_Msg
        ( v_object_id   => r_get_req_headers_from_inq.requirement_header_id -- put PK column here
        , v_object_name => g_object_name
        , v_message     => 'Record not processed successfully, deferring and rejecting record'
        , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
Line: 483

    , v_message     => 'Leaving ' || g_object_name || '.DELETE_REQ_HEADERS_FROM_INQ'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
Line: 493

    , v_message     => 'Exception occurred in DELETE_REQ_HEADERS_FROM_INQ:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
Line: 498

END DELETE_REQ_HEADERS_FROM_INQ;
Line: 541

      /*** Yes -> delete record from inqueue ***/
      IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
        jtm_message_log_pkg.Log_Msg
        ( v_object_id   => r_requirements.requirement_line_id -- put PK column here
        , v_object_name => g_object_name
        , v_message     => 'Record successfully processed, deleting from inqueue'
        , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
Line: 551

      CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
        (
          p_user_name,
          p_tranid,
          r_requirements.seqno$$,
          r_requirements.requirement_line_id, -- put PK column here
          g_object_name,
          g_pub_name,
          l_error_msg,
          x_return_status
        );
Line: 563

      /*** was delete successful? ***/
      IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
        /*** no -> rollback ***/
        IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
          jtm_message_log_pkg.Log_Msg
          ( v_object_id   => r_requirements.requirement_line_id -- put PK column here
          , v_object_name => g_object_name
          , v_message     => 'Deleting from inqueue failed, rolling back to savepoint'
          , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
Line: 578

      /*** Record was not processed successfully or delete failed -> defer and reject record ***/
      IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
        jtm_message_log_pkg.Log_Msg
        ( v_object_id   => r_requirements.requirement_line_id -- put PK column here
        , v_object_name => g_object_name
        , v_message     => 'Record not processed successfully, deferring and rejecting record'
        , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
Line: 615

  DELETE_REQ_HEADERS_FROM_INQ(p_user_name, p_tranid, x_return_status);
Line: 679

      /*** Yes -> delete record from inqueue ***/
      IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
        jtm_message_log_pkg.Log_Msg
        ( v_object_id   => r_requirements.requirement_line_id -- put PK column here
        , v_object_name => g_object_name
        , v_message     => 'Record successfully processed, deleting from inqueue'
        , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
Line: 688

      CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
        (
          p_user_name,
          p_tranid,
          r_requirements.seqno$$,
          r_requirements.requirement_line_id, -- put PK column here
          g_object_name,
          g_pub_name,
          l_error_msg,
          x_return_status
        );
Line: 700

      /*** was delete successful? ***/
      IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
        /*** no -> rollback ***/
        IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
          jtm_message_log_pkg.Log_Msg
          ( v_object_id   => r_requirements.requirement_line_id -- put PK column here
          , v_object_name => g_object_name
          , v_message     => 'Deleting from inqueue failed, rolling back to savepoint'
          , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
Line: 715

      /*** Record was not processed successfully or delete failed -> defer and reject record ***/
      IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
        jtm_message_log_pkg.Log_Msg
        ( v_object_id   => r_requirements.requirement_line_id -- put PK column here
        , v_object_name => g_object_name
        , v_message     => 'Record not processed successfully, deferring and rejecting record'
        , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
Line: 776

  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);