APPS.CSM_MTL_UNIT_TXN_ACC_PKG SQL Statements

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

Line: 12

g_old_user_id           NUMBER; -- variable containing old user_id; populated in Pre_Update hook

Line: 19

PROCEDURE Insert_MTL_Unit_Trans(   p_user_id         NUMBER,
                                   p_transaction_id      NUMBER
                              )
IS
CURSOR c_mtl_unit_trans(b_transaction_id      NUMBER)
IS
   SELECT TRANSACTION_ID, SERIAL_NUMBER
   FROM MTL_UNIT_TRANSACTIONS
   WHERE TRANSACTION_ID = b_transaction_id;

Line: 32

  , message     => p_transaction_id || 'Entering Insert_MTL_Unit_Trans Procedure'
  , log_level    => FND_LOG.LEVEL_STATEMENT);

Line: 36

     l_transaction_id_lst.DELETE;

Line: 39

     l_serial_lst.DELETE;

Line: 50

      /*** Call common package to insert record into ACC table ***/
      CSM_ACC_PKG.Insert_Acc
      ( p_publication_item_names => g_publication_item_name
       ,p_acc_table_name         => g_acc_table_name
       ,p_seq_name               => g_tasks_seq_name
       ,p_user_id                => p_user_id
       ,p_pk1_name               => g_pk1_name
       ,p_pk1_num_value          => l_transaction_id_lst(i)
       ,p_pk2_name               => g_pk2_name
       ,p_pk2_char_value         => l_serial_lst(i)
      );

Line: 64

     l_transaction_id_lst.DELETE;

Line: 67

     l_serial_lst.DELETE;

Line: 71

  , message     => 'Leaving Insert_MTL_Unit_Trans Procedure after processing tran id:' || p_transaction_id
  , log_level    => FND_LOG.LEVEL_STATEMENT);

Line: 74

END Insert_MTL_Unit_Trans;

Line: 77

PROCEDURE Update_MTL_Unit_Trans( p_user_id         NUMBER,
                                 p_transaction_id      NUMBER
                              )
IS
BEGIN
/*** Not necassery because it will be an insert or delete updates will not be done from the csp_inv_loc_ass package ***/
  /*** get debug level ***/
  RETURN;

Line: 85

END Update_MTL_Unit_Trans;

Line: 88

PROCEDURE Delete_MTL_Unit_Trans( p_user_id         NUMBER,
                                 p_transaction_id      NUMBER
	                       )
IS
CURSOR c_mtl_unit_trans(b_transaction_id NUMBER, b_user_id NUMBER)
IS
   SELECT TRANSACTION_ID, SERIAL_NUMBER
   FROM   CSM_MTL_UNIT_TXN_ACC
   WHERE  TRANSACTION_ID = b_transaction_id
   AND    USER_ID        = b_user_id;

Line: 103

  , message     => ' Entering Delete_MTL_trans_lot_num for Tran id : ' || p_transaction_id
  , log_level    => FND_LOG.LEVEL_STATEMENT);

Line: 107

     l_transaction_id_lst.DELETE;

Line: 110

     l_serial_lst.DELETE;

Line: 120

      /*** Call common package to insert record into ACC table ***/
      CSM_ACC_PKG.Delete_Acc
      ( p_publication_item_names => g_publication_item_name
       ,p_acc_table_name         => g_acc_table_name
       ,p_user_id                => p_user_id
       ,p_pk1_name               => g_pk1_name
       ,p_pk1_num_value          => l_transaction_id_lst(i)
       ,p_pk2_name               => g_pk2_name
       ,p_pk2_char_value         => l_serial_lst(i)
      );

Line: 134

     l_transaction_id_lst.DELETE;

Line: 137

     l_serial_lst.DELETE;

Line: 141

  , message     => ' Leaving Delete_MTL_trans_lot_num for Tran id : ' || p_transaction_id
  , log_level    => FND_LOG.LEVEL_STATEMENT);

Line: 144

END Delete_MTL_Unit_Trans;

Line: 146

/*Delete all records for non-existing user ( e.g user was deleted )*/
PROCEDURE DELETE_ALL_ACC_RECORDS( p_user_id IN NUMBER
                                , x_return_status OUT NOCOPY VARCHAR2 )
IS
BEGIN
  CSM_UTIL_PKG.LOG
    ( module => g_table_name
    , message     => 'Entering DELETE_ALL_ACC_RECORDS'
    , log_level    => FND_LOG.LEVEL_STATEMENT);

Line: 157

  DELETE CSM_MTL_UNIT_TXN_ACC
  WHERE  user_id = p_user_id;

Line: 164

    , message     => 'Leaving DELETE_ALL_ACC_RECORDS'
    , log_level    => FND_LOG.LEVEL_STATEMENT);

Line: 173

  , message     => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm
  , log_level    => FND_LOG.LEVEL_ERROR);

Line: 176

END DELETE_ALL_ACC_RECORDS;