APPS.CSL_MTL_TRANS_LOT_NUM_ACC_PKG SQL Statements

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

Line: 11

g_old_resource_id       NUMBER; -- variable containing old resource_id; populated in Pre_Update hook

Line: 14

PROCEDURE Insert_MTL_trans_lot_num(
                                      p_resource_id         NUMBER,
                                      p_transaction_id      NUMBER,
                                      p_inventory_item_id   NUMBER,
                                      p_organization_id     NUMBER
	                     )
IS

CURSOR c_transaction_lot_number(
                                  b_transaction_id NUMBER,
                                  b_inventory_item_id NUMBER,
                                  b_organization_id NUMBER
		  ) IS
       SELECT TRANSACTION_ID, LOT_NUMBER
       FROM MTL_TRANSACTION_LOT_NUMBERS
       WHERE TRANSACTION_ID = b_transaction_id
       AND INVENTORY_ITEM_ID = b_inventory_item_id
       AND ORGANIZATION_ID = b_organization_id;

Line: 43

    , v_message     => 'Entering Insert_MTL_trans_lot_num'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 56

      , v_message     => 'Insert_MTL_trans_lot_num could not find lot number transactions for transaction :' || p_transaction_id ||
                         ' , ' || p_inventory_item_id || ' for resource id ' || p_resource_id
      , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 68

        , v_message     => 'Inserting ACC record :' || p_transaction_id || ' , ' || p_inventory_item_id ||
                           ' for resource id ' || p_resource_id
        , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 75

      /*** Call common package to insert record into ACC table ***/
      JTM_HOOK_UTIL_PKG.Insert_Acc
      ( p_publication_item_names => g_publication_item_name
       ,p_acc_table_name         => g_acc_table_name
       ,p_resource_id            => p_resource_id
       ,p_pk1_name               => g_pk1_name
       ,p_pk1_num_value          => r_transaction_lot_number.TRANSACTION_ID
       ,p_pk2_name               => g_pk2_name
       ,p_pk2_char_value         => r_transaction_lot_number.LOT_NUMBER
      );

Line: 89

END Insert_MTL_trans_lot_num;

Line: 92

PROCEDURE Update_MTL_trans_lot_num(
                                      p_resource_id         NUMBER,
                                      p_transaction_id      NUMBER,
                                      p_inventory_item_id   NUMBER,
                                      p_organization_id     NUMBER
		      )
IS
CURSOR c_transaction_lot_number(
                                  b_transaction_id NUMBER,
                                  b_inventory_item_id NUMBER,
                                  b_organization_id NUMBER
		  ) IS
       SELECT TRANSACTION_ID, LOT_NUMBER
       FROM MTL_TRANSACTION_LOT_NUMBERS
       WHERE TRANSACTION_ID = b_transaction_id
       AND INVENTORY_ITEM_ID = b_inventory_item_id
       AND ORGANIZATION_ID = b_organization_id;

Line: 123

    , v_message     => 'Entering Update_MTL_trans_lot_num'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 136

      , v_message     => 'Update_MTL_trans_lot_num could not find lot number transactions for transaction :' || p_transaction_id ||
                         ' , ' || p_inventory_item_id || ' for resource id ' || p_resource_id
      , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 147

        , v_message     => 'Update ACC record :' || p_transaction_id || ' , ' || p_inventory_item_id ||
                           ' for resource id ' || p_resource_id
        , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 154

      /*** Call common package to insert record into ACC table ***/
      l_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id
                 ( P_ACC_TABLE_NAME => g_acc_table_name
                  ,p_pk1_name       => g_pk1_name
                  ,p_pk1_num_value  => r_transaction_lot_number.TRANSACTION_ID
                  ,p_pk2_name       => g_pk2_name
                  ,p_pk2_char_value => r_transaction_lot_number.LOT_NUMBER
                  ,P_RESOURCE_ID    => p_resource_id);

Line: 165

      /*** Record is not yet in ACC tables. Insert has to be done ***/
        JTM_HOOK_UTIL_PKG.Insert_Acc
                         ( p_publication_item_names => g_publication_item_name
                         ,p_acc_table_name          => g_acc_table_name
                         ,p_pk1_name                => g_pk1_name
                         ,p_pk1_num_value           => r_transaction_lot_number.TRANSACTION_ID
                         ,p_pk2_name                => g_pk2_name
                         ,p_pk2_char_value          => r_transaction_lot_number.LOT_NUMBER
                         ,p_resource_id             => p_resource_id
                         );

Line: 176

      /*** Record is already in ACC. Only an update is required for re-sending ***/
        JTM_HOOK_UTIL_PKG.Update_Acc
                         ( p_publication_item_names => g_publication_item_name
                         ,p_acc_table_name          => g_acc_table_name
                         ,p_resource_id             => p_resource_id
	          ,p_access_id               => l_acc_id
                         );

Line: 196

    , v_message     => 'Leaving Update_MTL_trans_lot_num'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 201

END Update_MTL_trans_lot_num;

Line: 204

PROCEDURE Delete_MTL_trans_lot_num(
                                      p_resource_id         NUMBER,
                                      p_transaction_id      NUMBER,
                                      p_inventory_item_id   NUMBER,
                                      p_organization_id     NUMBER
	                     )
IS

CURSOR c_transaction_lot_number(
                                  b_transaction_id NUMBER,
                                  b_inventory_item_id NUMBER,
                                  b_organization_id NUMBER
		  ) IS
       SELECT TRANSACTION_ID, LOT_NUMBER
       FROM MTL_TRANSACTION_LOT_NUMBERS
       WHERE TRANSACTION_ID = b_transaction_id
       AND INVENTORY_ITEM_ID = b_inventory_item_id
       AND ORGANIZATION_ID = b_organization_id;

Line: 234

    , v_message     => 'Entering Delete_MTL_trans_lot_num'
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 247

      , v_message     => 'Delete_MTL_trans_lot_num could not find lot number transactions for transaction :' || p_transaction_id ||
                         ' , ' || p_inventory_item_id || ' for resource id ' || p_resource_id
      , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line: 266

      /*** Call common package to insert record into ACC table ***/
      JTM_HOOK_UTIL_PKG.Delete_Acc
      ( p_publication_item_names => g_publication_item_name
       ,p_acc_table_name         => g_acc_table_name
       ,p_resource_id            => p_resource_id
       ,p_pk1_name               => g_pk1_name
       ,p_pk1_num_value          => r_transaction_lot_number.TRANSACTION_ID
       ,p_pk2_name               => g_pk2_name
       ,p_pk2_char_value         => r_transaction_lot_number.LOT_NUMBER
      );

Line: 280

END Delete_MTL_trans_lot_num;

Line: 282

/*Delete all records for non-existing user ( e.g user was deleted )*/
PROCEDURE DELETE_ALL_ACC_RECORDS( p_resource_id IN NUMBER
                                , x_return_status OUT NOCOPY VARCHAR2 )
IS
BEGIN
  /*** get debug level ***/
  g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line: 293

    , 'Entering DELETE_ALL_ACC_RECORDS'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
    );

Line: 298

  DELETE JTM_MTL_TRANS_LOT_NUM_ACC
  WHERE  RESOURCE_ID = p_resource_id;

Line: 307

    , 'Leaving DELETE_ALL_ACC_RECORDS'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
    );

Line: 319

    , v_message     => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm
    , v_level_id    => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line: 323

END DELETE_ALL_ACC_RECORDS;