APPS.CSM_MTL_TXN_REASONS_EVENT_PKG SQL Statements

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

Line: 32

l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line: 38

SELECT csm_mtl_txn_reasons_acc_s.nextval, reason_id
FROM mtl_transaction_reasons
WHERE NVL(disable_date, SYSDATE) >= SYSDATE
AND  last_update_date >= nvl(p_lastrundate, last_update_date )
AND ( reason_id ) NOT IN (
      SELECT reason_id
      FROM csm_mtl_txn_reasons_acc
      );

Line: 49

SELECT access_id
FROM csm_mtl_txn_reasons_acc acc
,    mtl_transaction_reasons mtr
WHERE mtr.reason_id = acc.reason_id
AND   NVL(disable_date, SYSDATE) >= SYSDATE
AND   mtr.last_update_date  >= p_lastrundate;

Line: 58

SELECT access_id
FROM csm_mtl_txn_reasons_acc
WHERE reason_id IN
 (SELECT reason_id
  FROM mtl_transaction_reasons
  WHERE last_update_date >= nvl(p_lastrundate, last_update_date)
  AND NVL(disable_date, sysdate) < SYSDATE
  )
UNION
SELECT access_id
FROM csm_mtl_txn_reasons_acc
WHERE reason_id NOT IN
 (SELECT reason_id
  FROM mtl_transaction_reasons
 );

Line: 76

SELECT nvl(last_run_date, (sysdate - 365*50))
FROM jtm_con_request_data
WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';

Line: 97

 FETCH l_last_run_date_csr INTO l_prog_update_date;

Line: 101

   l_access_id_tbl.delete;

Line: 108

 CSM_UTIL_PKG.LOG('Entering deletes ', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

Line: 111

 OPEN l_del_mtl_txn_reasons_csr(l_prog_update_date);

Line: 129

     DELETE FROM csm_mtl_txn_reasons_acc WHERE access_id = l_access_id_tbl(i);

Line: 131

   l_access_id_tbl.delete;

Line: 132

 END IF; -- end of process deletes

Line: 134

 CSM_UTIL_PKG.LOG('Leaving deletes and entering updates', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

Line: 137

 OPEN l_upd_mtl_txn_reasons_csr(l_prog_update_date);

Line: 153

   l_access_id_tbl.delete;

Line: 154

 END IF; -- end of process updates

Line: 157

    l_reason_id_tbl.delete;

Line: 160

 CSM_UTIL_PKG.LOG('Leaving updates and entering inserts', 'CSM_MTL_TXN_REASONS_EVENT_PKG.Refresh_mtl_txn_reasons_acc',FND_LOG.LEVEL_PROCEDURE);

Line: 163

 OPEN l_ins_mtl_txn_reasons_csr(l_prog_update_date);

Line: 182

     INSERT INTO csm_mtl_txn_reasons_acc (access_id, reason_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
                                 VALUES (l_access_id_tbl(i), l_reason_id_tbl(i), fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);

Line: 185

   l_access_id_tbl.delete;

Line: 186

 END IF; -- end of process inserts

Line: 189

 UPDATE jtm_con_request_data
 SET last_run_date = l_run_date
 WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
 AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';