APPS.GMD_SPREADSHEET_UPDATE dependencies on GME_RESERVATIONS_PVT

Line 766: gme_reservations_pvt.delete_reservation(p_reservation_id => l_del_rec.reservation_id

762: /* but was deleted from the spreadsheet. */
763: IF P_line_type <> 1 THEN
764: FOR l_del_rec IN Cur_get_del_lines (P_material_detail_id) LOOP
765: gmd_debug.put_line(' Material:'||P_material_detail_id||' trans:'||l_del_rec.reservation_id||' reserv qty:'||l_del_rec.reservation_quantity||' Lot:'||l_del_rec.lot_number);
766: gme_reservations_pvt.delete_reservation(p_reservation_id => l_del_rec.reservation_id
767: ,x_return_status => l_return_status);
768: IF X_return_status <> l_return_status THEN
769: gmd_debug.put_line('Delete allocation error:'||l_del_rec.reservation_id);
770: RAISE delete_alloc_err;

Line 819: gme_reservations_pvt.update_reservation (p_reservation_id => l_rec.reservation_id

815: OPEN Cur_get_qty (l_rec.reservation_id);
816: FETCH Cur_get_qty INTO l_reservation_qty;
817: CLOSE Cur_get_qty;
818: IF l_reservation_qty <> l_rec.qty THEN
819: gme_reservations_pvt.update_reservation (p_reservation_id => l_rec.reservation_id
820: ,p_revision => l_revision
821: ,p_subinventory => l_rec.subinventory_code
822: ,p_locator_id => l_rec.locator_id
823: ,p_lot_number => l_rec.lot_number

Line 836: gme_reservations_pvt.create_material_reservation (p_matl_dtl_rec => l_material_out

832: END IF;
833: END IF;
834: ELSE
835: /* Let us create the new reservation material line */
836: gme_reservations_pvt.create_material_reservation (p_matl_dtl_rec => l_material_out
837: ,p_resv_qty => l_rec.qty
838: ,p_sec_resv_qty => ABS(l_rec.secondary_qty)
839: ,p_resv_um => l_rec.detail_uom
840: ,p_subinventory => l_rec.subinventory_code