APPS.CSM_DEBRIEF_PARTS_PKG SQL Statements

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

Line: 17

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

Line: 23

  This procedure is called by APPLY_CLIENT_CHANGES when an inserted record is to be processed.
***/
PROCEDURE APPLY_INSERT
         (
           p_record        IN c_debrief_parts%ROWTYPE,
           p_error_msg     out nocopy    VARCHAR2,
           x_return_status IN out nocopy VARCHAR2
         ) IS

cursor c_deb_head
       ( b_task_assignment_id number
       )
is
select debrief_header_id
,      task_assignment_id
,      debrief_number
from   csf_debrief_headers
where  task_assignment_id = b_task_assignment_id;

Line: 46

select source_object_type_code
from   jtf_tasks_b jtb
,      jtf_task_assignments jta
where  jtb.task_id = jta.task_id
and    jta.task_assignment_id = b_task_assignment_id;

Line: 60

SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
       tst.closed_flag, tst.completed_flag
FROM csf_debrief_headers dh, jtf_task_assignments tas,
     jtf_task_statuses_b tst
WHERE dh.task_assignment_id = tas.task_assignment_id
AND tas.assignment_status_id = tst.task_status_id
AND dh.debrief_header_id = p_debrief_header_id;

Line: 79

SELECT ttb.line_order_category_code
FROM   CS_TXN_BILLING_TYPES   tbt
,      CS_TRANSACTION_TYPES_B ttb
WHERE  tbt.TRANSACTION_TYPE_ID = ttb.TRANSACTION_TYPE_ID
AND    tbt.BILLING_TYPE  = 'M'
AND    tbt.TXN_BILLING_TYPE_ID = p_txn_billing_type_id;

Line: 91

SELECT ttb.line_order_category_code
FROM   CS_TRANSACTION_TYPES_B ttb
WHERE ttb.transaction_type_id = p_transaction_type_id;

Line: 117

l_spare_update_status      csf_debrief_lines.spare_update_status%TYPE;

Line: 126

    CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
               || ' ROOT ERROR: ' || p_error_msg
               || ' for PK ' ||
p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

Line: 160

l_deb_rec.last_update_date   := l_date;

Line: 161

l_deb_rec.last_updated_by    :=  NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1

Line: 164

l_deb_rec.last_update_login  := FND_GLOBAL.LOGIN_ID;

Line: 190

      CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
               || ' ROOT ERROR: csf_debrief_pub.create_debrief'
               || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

Line: 265

    CSM_UTIL_PKG.log('Error in CSF_DEBRIEF_PARTS_PKG.APPLY_INSERT: '
      || 'Root cause csp_transactions_pub.transact_material failed: '
      || 'for Debrief Line Id: ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

Line: 269

    l_spare_update_status := 'FAILED';

Line: 271

    l_spare_update_status := 'SUCCEEDED';

Line: 274

l_spare_update_status := NULL;

Line: 295

l_line_rec.last_update_date         := l_date;

Line: 296

l_line_rec.last_updated_by          :=  NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1

Line: 299

l_line_rec.last_update_login        := FND_GLOBAL.LOGIN_ID;

Line: 300

l_line_rec.spare_update_status      := l_spare_update_status;

Line: 363

    CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
               || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'
               || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

Line: 382

          csf_debrief_update_pkg.form_Call (1.0, l_debrief_header_id );

Line: 390

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

Line: 396

     CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
               || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION );

Line: 399

END APPLY_INSERT;

Line: 418

    APPLY_INSERT
      (
        p_record,
        p_error_msg,
        x_return_status
      );

Line: 427

        ( 'Delete and Update is not supported for this entity'
      || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

Line: 458

  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: 492

      /*** Yes -> delete record from inqueue ***/

      CSM_UTIL_PKG.DELETE_RECORD
        (
          p_user_name,
          p_tranid,
          r_debrief_parts.seqno$$,
          r_debrief_parts.debrief_line_id,
          g_object_name,
          g_pub_name,
          l_error_msg,
          l_process_status
        );

Line: 506

      /*** 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_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line: 518

      /*** 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_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here