eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RESERVATION_FORM_PKG SQL Statements

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

Line: 428


PROCEDURE update_reservation
  (
     p_api_version_number          IN  NUMBER
   , p_init_msg_lst                IN  VARCHAR2 DEFAULT fnd_api.g_true
   , x_return_status               OUT NOCOPY VARCHAR2
   , x_msg_count                   OUT NOCOPY NUMBER
   , x_msg_data                    OUT NOCOPY VARCHAR2
   , p_from_reservation_id         IN  NUMBER
   , p_from_requirement_date       IN  DATE
   , p_from_organization_id        IN  NUMBER
   , p_from_inventory_item_id      IN  NUMBER
   , p_from_demand_type_id         IN  NUMBER
   , p_from_demand_name            IN  VARCHAR2
   , p_from_demand_header_id       IN  NUMBER
   , p_from_demand_line_id         IN  NUMBER
   , p_from_demand_delivery_id     IN  NUMBER   DEFAULT NULL
   , p_from_primary_uom_code       IN  VARCHAR2
   , p_from_primary_uom_id         IN  NUMBER
   , p_from_secondary_uom_code     IN  VARCHAR2
   , p_from_secondary_uom_id       IN  NUMBER
   , p_from_reservation_uom_code   IN  VARCHAR2
   , p_from_reservation_uom_id     IN  NUMBER
   , p_from_reservation_quantity   IN  NUMBER
   , p_from_primary_rsv_quantity   IN  NUMBER
   , p_from_secondary_rsv_quantity IN  NUMBER
   , p_from_autodetail_group_id    IN  NUMBER
   , p_from_external_source_code   IN  VARCHAR2
   , p_from_external_source_line   IN  NUMBER
   , p_from_supply_type_id         IN  NUMBER
   , p_from_supply_header_id       IN  NUMBER
   , p_from_supply_line_id         IN  NUMBER
   , p_from_supply_name            IN  VARCHAR2
   , p_from_supply_line_detail     IN  NUMBER
   , p_from_revision               IN  VARCHAR2
   , p_from_subinventory_code      IN  VARCHAR2
   , p_from_subinventory_id        IN  NUMBER
   , p_from_locator_id             IN  NUMBER
   , p_from_lot_number             IN  VARCHAR2
   , p_from_lot_number_id          IN  NUMBER
   , p_from_pick_slip_number       IN  NUMBER
   , p_from_lpn_id                 IN  NUMBER
   , p_from_project_id             IN  NUMBER Default Null
   , p_from_task_id                IN  NUMBER Default Null
   , p_From_Serial_Number_Tbl      In Inv_Reservation_Global.Serial_Number_Tbl_Type
   , p_from_ship_ready_flag        IN  NUMBER
   , p_From_CrossDock_Flag         In  Varchar2 Default Null
   , p_from_attribute_category     IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute1             IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute2             IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute3             IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute4             IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute5             IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute6             IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute7             IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute8             IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute9             IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute10            IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute11            IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute12            IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute13            IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute14            IN  VARCHAR2 DEFAULT NULL
   , p_from_attribute15            IN  VARCHAR2 DEFAULT NULL
   , p_to_requirement_date         IN  DATE
   , p_to_demand_type_id           IN  NUMBER
   , p_to_demand_name              IN  VARCHAR2
   , p_to_demand_header_id         IN  NUMBER
   , p_to_demand_line_id           IN  NUMBER
   , p_to_demand_delivery_id       IN  NUMBER   DEFAULT NULL
   , p_to_reservation_uom_code     IN  VARCHAR2
   , p_to_reservation_uom_id       IN  NUMBER
   , p_to_reservation_quantity     IN  NUMBER
   , p_to_primary_rsv_quantity     IN  NUMBER
   , p_to_secondary_rsv_quantity   IN  NUMBER
   , p_to_autodetail_group_id      IN  NUMBER
   , p_to_external_source_code     IN  VARCHAR2
   , p_to_external_source_line     IN  NUMBER
   , p_to_supply_type_id           IN  NUMBER
   , p_to_supply_header_id         IN  NUMBER
   , p_to_supply_line_id           IN  NUMBER
   , p_to_supply_name              IN  VARCHAR2
   , p_to_supply_line_detail       IN  NUMBER
   , p_to_revision                 IN  VARCHAR2
   , p_to_subinventory_code        IN  VARCHAR2
   , p_to_subinventory_id          IN  NUMBER
   , p_to_locator_id               IN  NUMBER
   , p_to_lot_number               IN  VARCHAR2
   , p_to_lot_number_id            IN  NUMBER
   , p_to_pick_slip_number         IN  NUMBER
   , p_to_lpn_id                   IN  NUMBER
   , p_to_project_id               IN  NUMBER Default Null
   , p_to_task_id                  IN  NUMBER Default Null
   , p_To_Serial_Number_Tbl        In  Inv_Reservation_Global.Serial_Number_Tbl_Type
   , p_to_ship_ready_flag          IN  NUMBER
   , p_To_CrossDock_Flag           In  Varchar2 Default Null
   , p_to_attribute_category       IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute1               IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute2               IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute3               IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute4               IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute5               IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute6               IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute7               IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute8               IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute9               IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute10              IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute11              IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute12              IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute13              IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute14              IN  VARCHAR2 DEFAULT NULL
   , p_to_attribute15              IN  VARCHAR2 DEFAULT NULL
   , p_validation_flag             IN  VARCHAR2 DEFAULT fnd_api.g_true
  ) IS
     l_api_version_number        CONSTANT NUMBER       := 1.0;

Line: 541


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

Line: 680


   inv_reservation_pvt.update_reservation
     (
        p_api_version_number        => 1.0
      , p_init_msg_lst              => p_init_msg_lst
      , x_return_status             => l_return_status
      , x_msg_count                 => x_msg_count
      , x_msg_data                  => x_msg_data
      , p_original_rsv_rec          => l_orig_rsv_rec
      , p_to_rsv_rec                => l_to_rsv_rec
      , p_original_serial_number    => p_from_serial_number_Tbl   -- R12 Changes: SU
      , p_to_serial_number          => p_To_serial_number_tbl     -- R12 Changes : SU
      , p_validation_flag           => p_validation_flag
      );

Line: 744


END update_reservation;

Line: 747


PROCEDURE delete_reservation
  (
     p_api_version_number        IN  NUMBER
   , p_init_msg_lst              IN  VARCHAR2 DEFAULT fnd_api.g_true
   , x_return_status             OUT NOCOPY VARCHAR2
   , x_msg_count                 OUT NOCOPY NUMBER
   , x_msg_data                  OUT NOCOPY VARCHAR2
   , p_reservation_id            IN  NUMBER
   , p_requirement_date          IN  DATE
   , p_organization_id           IN  NUMBER
   , p_inventory_item_id         IN  NUMBER
   , p_demand_type_id            IN  NUMBER
   , p_demand_name               IN  VARCHAR2
   , p_demand_header_id          IN  NUMBER
   , p_demand_line_id            IN  NUMBER
   , p_demand_delivery_id        IN  NUMBER   DEFAULT NULL
   , p_primary_uom_code          IN  VARCHAR2
   , p_primary_uom_id            IN  NUMBER
   , p_secondary_uom_code        IN  VARCHAR2
   , p_secondary_uom_id          IN  NUMBER
   , p_reservation_uom_code      IN  VARCHAR2
   , p_reservation_uom_id        IN  NUMBER
   , p_reservation_quantity      IN  NUMBER
   , p_primary_rsv_quantity      IN  NUMBER
   , p_secondary_rsv_quantity    IN  NUMBER
   , p_autodetail_group_id       IN  NUMBER
   , p_external_source_code      IN  VARCHAR2
   , p_external_source_line      IN  NUMBER
   , p_supply_type_id            IN  NUMBER
   , p_supply_header_id          IN  NUMBER
   , p_supply_line_id            IN  NUMBER
   , p_supply_name               IN  VARCHAR2
   , p_supply_line_detail        IN  NUMBER
   , p_revision                  IN  VARCHAR2
   , p_subinventory_code         IN  VARCHAR2
   , p_subinventory_id           IN  NUMBER
   , p_locator_id                IN  NUMBER
   , p_lot_number                IN  VARCHAR2
   , p_lot_number_id             IN  NUMBER
   , p_pick_slip_number          IN  NUMBER
   , p_lpn_id                    IN  NUMBER
   , p_Serial_Number_Tbl         In  Inv_Reservation_Global.Serial_Number_Tbl_Type
   , p_ship_ready_flag           IN  NUMBER
   , p_CrossDock_Flag            In  Varchar2 Default Null
   , p_attribute_category        IN  VARCHAR2 DEFAULT NULL
   , p_attribute1                IN  VARCHAR2 DEFAULT NULL
   , p_attribute2                IN  VARCHAR2 DEFAULT NULL
   , p_attribute3                IN  VARCHAR2 DEFAULT NULL
   , p_attribute4                IN  VARCHAR2 DEFAULT NULL
   , p_attribute5                IN  VARCHAR2 DEFAULT NULL
   , p_attribute6                IN  VARCHAR2 DEFAULT NULL
   , p_attribute7                IN  VARCHAR2 DEFAULT NULL
   , p_attribute8                IN  VARCHAR2 DEFAULT NULL
   , p_attribute9                IN  VARCHAR2 DEFAULT NULL
   , p_attribute10               IN  VARCHAR2 DEFAULT NULL
   , p_attribute11               IN  VARCHAR2 DEFAULT NULL
   , p_attribute12               IN  VARCHAR2 DEFAULT NULL
   , p_attribute13               IN  VARCHAR2 DEFAULT NULL
   , p_attribute14               IN  VARCHAR2 DEFAULT NULL
   , p_attribute15               IN  VARCHAR2 DEFAULT NULL
   , p_validation_flag           IN  VARCHAR2 DEFAULT 'T'  --Bug 2354735
  ) IS
     l_api_version_number        CONSTANT NUMBER       := 1.0;

Line: 810


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

Line: 882


   inv_reservation_pvt.delete_reservation
     (
        p_api_version_number        => 1.0
      , p_init_msg_lst              => p_init_msg_lst
      , x_return_status             => l_return_status
      , x_msg_count                 => x_msg_count
      , x_msg_data                  => x_msg_data
      , p_rsv_rec                   => l_rsv_rec
      , p_original_serial_number    => p_serial_number_Tbl -- R12 Changes : SU
      , p_validation_flag           => p_validation_flag   -- Bug 2354735
      );

Line: 944


END delete_reservation;

Line: 1617


	SELECT inventory_item_id, ordered_quantity, order_quantity_uom, ship_from_org_id,
               ship_tolerance_above
	INTO	l_line_rec_inventory_item_id,
		l_line_rec_ordered_quantity,
		l_line_rec_order_quantity_uom,
		l_line_rec_org_id,
                l_ship_tolerance_above
	FROM    oe_order_lines_all
	WHERE	line_id = p_demand_line_id ;

Line: 1642


     	select nvl(sum(primary_reservation_quantity),0)
        into l_primary_reserved_quantity
        from mtl_reservations
        where demand_source_type_id   = p_demand_type_id
        and   demand_source_header_id = p_demand_header_id
        and   demand_source_line_id   = p_demand_line_id
        and   reservation_id         <> p_reservation_id;

Line: 1653


        	select primary_uom_code
        	into l_primary_uom_code
        	from mtl_system_items
        	where organization_id   = l_line_rec_org_id
        	and   inventory_item_id = l_line_rec_inventory_item_id;

Line: 1801


   l_in_trohdr_rec.last_update_date := SYSDATE;

Line: 1802


   l_in_trohdr_rec.last_updated_by  := l_user_id;

Line: 1930


   l_in_trolin_tbl(1).last_update_date   := SYSDATE;

Line: 1931


   l_in_trolin_tbl(1).last_updated_by    := l_user_id;

Line: 2016


PROCEDURE delete_move_order
  (
     p_api_version_number            IN  NUMBER
   , p_init_msg_lst                  IN  VARCHAR2 DEFAULT fnd_api.g_false
   , p_move_order_header_id          IN  NUMBER
   , x_return_status                 OUT NOCOPY VARCHAR2
   , x_msg_count                     OUT NOCOPY NUMBER
   , x_msg_data                      OUT NOCOPY VARCHAR2
   ) is
     l_api_version_number   CONSTANT NUMBER       := 1.0;

Line: 2026


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

Line: 2054


   l_in_trohdr_rec.operation := inv_globals.g_opr_delete;

Line: 2118


END delete_move_order;