APPS.INV_QUANTITY_TREE_GRP SQL Statements

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

Line: 353

PROCEDURE update_quantities
  (  p_api_version_number    IN  NUMBER
   , p_init_msg_lst          IN  VARCHAR2 DEFAULT fnd_api.g_false
   , x_return_status         OUT NOCOPY VARCHAR2
   , x_msg_count             OUT NOCOPY NUMBER
   , x_msg_data              OUT NOCOPY VARCHAR2
   , p_tree_id               IN  INTEGER
   , p_revision              IN  VARCHAR2 DEFAULT NULL
   , p_lot_number            IN  VARCHAR2 DEFAULT NULL
   , p_subinventory_code     IN  VARCHAR2 DEFAULT NULL
   , p_locator_id            IN  NUMBER   DEFAULT NULL
   , p_primary_quantity      IN  NUMBER
   , p_quantity_type         IN  INTEGER
   , x_qoh                   OUT NOCOPY NUMBER
   , x_rqoh                  OUT NOCOPY NUMBER
   , x_qr                    OUT NOCOPY NUMBER
   , x_qs                    OUT NOCOPY NUMBER
   , x_att                   OUT NOCOPY NUMBER
   , x_atr                   OUT NOCOPY NUMBER
   , p_transfer_subinventory_code IN  VARCHAR2 DEFAULT NULL
   , p_cost_group_id	     IN  NUMBER   DEFAULT NULL
   , p_containerized	     IN  NUMBER   DEFAULT inv_quantity_tree_pvt.g_containerized_false
   , p_lpn_id	  	     IN  NUMBER   DEFAULT NULL
   , p_transfer_locator_id   IN  NUMBER   DEFAULT NULL
   )  IS

l_sqoh   NUMBER;

Line: 390

update_quantities
  (  p_api_version_number    => p_api_version_number
   , p_init_msg_lst          => p_init_msg_lst
   , x_return_status         => x_return_status
   , x_msg_count             => x_msg_count
   , x_msg_data              => x_msg_data
   , p_tree_id               => p_tree_id
   , p_revision              => p_revision
   , p_lot_number            => p_lot_number
   , p_subinventory_code     => p_subinventory_code
   , p_locator_id            => p_locator_id
   , p_primary_quantity      => p_primary_quantity
   , p_secondary_quantity    => l_secondary_quantity     -- invConv change
   , p_quantity_type         => p_quantity_type
   , x_qoh                   => x_qoh
   , x_rqoh                  => x_rqoh
   , x_qr                    => x_qr
   , x_qs                    => x_qs
   , x_att                   => x_att
   , x_atr                   => x_atr
   , x_sqoh                   => l_sqoh                -- invConv change
   , x_srqoh                  => l_srqoh               -- invConv change
   , x_sqr                    => l_sqr                 -- invConv change
   , x_sqs                    => l_sqs                 -- invConv change
   , x_satt                   => l_satt                -- invConv change
   , x_satr                   => l_satr                -- invConv change
   , p_transfer_subinventory_code => p_transfer_subinventory_code
   , p_cost_group_id	     => p_cost_group_id
   , p_containerized	     => p_containerized
   , p_lpn_id	  	     => p_lpn_id
   , p_transfer_locator_id   => p_transfer_locator_id
   );

Line: 424

END update_quantities;

Line: 427

PROCEDURE update_quantities
  (  p_api_version_number    IN  NUMBER
   , p_init_msg_lst          IN  VARCHAR2 DEFAULT fnd_api.g_false
   , x_return_status         OUT NOCOPY VARCHAR2
   , x_msg_count             OUT NOCOPY NUMBER
   , x_msg_data              OUT NOCOPY VARCHAR2
   , p_tree_id               IN  INTEGER
   , p_revision              IN  VARCHAR2 DEFAULT NULL
   , p_lot_number            IN  VARCHAR2 DEFAULT NULL
   , p_subinventory_code     IN  VARCHAR2 DEFAULT NULL
   , p_locator_id            IN  NUMBER   DEFAULT NULL
   , p_primary_quantity      IN  NUMBER
   , p_secondary_quantity    IN  NUMBER                     -- invConv change
   , p_quantity_type         IN  INTEGER
   , x_qoh                   OUT NOCOPY NUMBER
   , x_rqoh                  OUT NOCOPY NUMBER
   , x_qr                    OUT NOCOPY NUMBER
   , x_qs                    OUT NOCOPY NUMBER
   , x_att                   OUT NOCOPY NUMBER
   , x_atr                   OUT NOCOPY NUMBER
   , x_sqoh                  OUT NOCOPY NUMBER               -- invConv change
   , x_srqoh                 OUT NOCOPY NUMBER               -- invConv change
   , x_sqr                   OUT NOCOPY NUMBER               -- invConv change
   , x_sqs                   OUT NOCOPY NUMBER               -- invConv change
   , x_satt                  OUT NOCOPY NUMBER               -- invConv change
   , x_satr                  OUT NOCOPY NUMBER               -- invConv change
   , p_transfer_subinventory_code IN  VARCHAR2 DEFAULT NULL
   , p_cost_group_id	     IN  NUMBER   DEFAULT NULL
   , p_containerized	     IN  NUMBER   DEFAULT inv_quantity_tree_pvt.g_containerized_false
   , p_lpn_id	  	     IN  NUMBER   DEFAULT NULL
   , p_transfer_locator_id   IN  NUMBER   DEFAULT NULL
   )  IS
      l_api_version_number        CONSTANT NUMBER       := 1.0;

Line: 460

      l_api_name                  CONSTANT VARCHAR2(30) := 'Update_Quantities';

Line: 477

   inv_quantity_tree_pvt.update_quantities
     (
        p_api_version_number  => 1.0
      , p_init_msg_lst        => fnd_api.g_false
      , x_return_status       => l_return_status
      , x_msg_count           => x_msg_count
      , x_msg_data            => x_msg_data
      , p_tree_id             => p_tree_id
      , p_revision            => p_revision
      , p_lot_number          => p_lot_number
      , p_subinventory_code   => p_subinventory_code
      , p_locator_id          => p_locator_id
      , p_primary_quantity    => p_primary_quantity
      , p_secondary_quantity  => p_secondary_quantity  -- invConv change
      , p_quantity_type       => p_quantity_type
      , x_qoh                 => x_qoh
      , x_rqoh                => x_rqoh
      , x_qr                  => x_qr
      , x_qs                  => x_qs
      , x_att                 => x_att
      , x_atr                 => x_atr
      , x_sqoh                 => x_sqoh               -- invConv change
      , x_srqoh                => x_srqoh              -- invConv change
      , x_sqr                  => x_sqr                -- invConv change
      , x_sqs                  => x_sqs                -- invConv change
      , x_satt                 => x_satt               -- invConv change
      , x_satr                 => x_satr               -- invConv change
      , p_transfer_subinventory_code => p_subinventory_code
      , p_cost_group_id       => p_cost_group_id
      , p_containerized       => p_containerized
      , p_lpn_id              => p_lpn_id
      , p_transfer_locator_id => p_transfer_locator_id
     );

Line: 558

END update_quantities;