APPS.WMS_CATCH_WEIGHT_PVT dependencies on MTL_RESERVATIONS

Line 1336: FROM mtl_reservations

1332: AND NVL(wlc.lot_number,'@@@') = NVL(p_lot_number,'@@@');
1333:
1334: CURSOR c_ds_lpn_rsvs IS
1335: SELECT reservation_id
1336: FROM mtl_reservations
1337: WHERE demand_source_type_id IN (2,8)
1338: AND lpn_id = p_lpn_id
1339: AND organization_id = p_organization_id
1340: AND inventory_item_id = p_inventory_item_id

Line 1397: FROM mtl_reservations

1393: AND msi.inventory_item_id = wdd2.inventory_item_id;
1394:
1395: CURSOR c_get_lpn_rsvs IS
1396: SELECT reservation_id
1397: FROM mtl_reservations
1398: WHERE demand_source_type_id IN (2,8)
1399: AND demand_source_line_id IN
1400: (SELECT * FROM TABLE(wms_catch_weight_pvt.wdd_src_line_id))
1401: AND lpn_id = p_lpn_id

Line 1475: FROM mtl_reservations

1471: , wms_catch_weight_pvt.get_uom_class(reservation_uom_code) rsv_uom_class
1472: , primary_reservation_quantity
1473: , detailed_quantity
1474: , wms_catch_weight_pvt.get_uom_class(secondary_uom_code) sec_uom_class
1475: FROM mtl_reservations
1476: WHERE reservation_id = p_rsv_id
1477: FOR UPDATE WAIT 5;
1478:
1479: l_mmtt_rsv_rec c_get_mmtt_rsv%ROWTYPE;

Line 1484: FROM mtl_reservations

1480:
1481: CURSOR c_get_rsv_dtl(p_rsv_id IN NUMBER) IS
1482: SELECT primary_reservation_quantity
1483: , detailed_quantity
1484: FROM mtl_reservations
1485: WHERE reservation_id = p_rsv_id
1486: FOR UPDATE WAIT 5;
1487:
1488: l_rsv_dtl_rec c_get_rsv_dtl%ROWTYPE;

Line 1843: FROM mtl_reservations

1839: IF l_sub_reservable = 1 THEN --{
1840: BEGIN
1841: SELECT NVL(SUM(primary_reservation_quantity),0)
1842: INTO l_lpn_rsv_pri_qty
1843: FROM mtl_reservations
1844: WHERE demand_source_type_id IN (2,8)
1845: AND lpn_id = p_lpn_id
1846: AND organization_id = p_organization_id
1847: AND inventory_item_id = p_inventory_item_id

Line 1912: UPDATE mtl_reservations

1908: IF (l_debug = 1) THEN
1909: print_debug('l_lpn_rsv_pri_qty > l_pri_qty_to_reduce', 4);
1910: END IF;
1911: -- Update reservations: reduce qty
1912: UPDATE mtl_reservations
1913: SET primary_reservation_quantity =
1914: (primary_reservation_quantity -
1915: ROUND(((primary_reservation_quantity * l_pri_qty_to_reduce)/l_lpn_rsv_pri_qty),5)
1916: )

Line 1962: UPDATE mtl_reservations

1958: IF (l_debug = 1) THEN
1959: print_debug('DS: l_pri_qty_to_incr > 0; ' || l_pri_qty_to_incr, 4);
1960: END IF;
1961: -- Update reservations: increase qty
1962: UPDATE mtl_reservations
1963: SET primary_reservation_quantity =
1964: (primary_reservation_quantity +
1965: ROUND(((primary_reservation_quantity * l_pri_qty_to_incr)/l_lpn_rsv_pri_qty),5)
1966: )

Line 2267: FROM mtl_reservations

2263: -- Start with LPN reservations
2264: BEGIN
2265: SELECT NVL(SUM(primary_reservation_quantity),0)
2266: INTO l_lpn_rsv_pri_qty
2267: FROM mtl_reservations
2268: WHERE demand_source_type_id IN (2,8)
2269: AND demand_source_line_id IN
2270: (SELECT * FROM TABLE(wms_catch_weight_pvt.wdd_src_line_id))
2271: AND lpn_id = p_lpn_id

Line 2345: UPDATE mtl_reservations

2341: IF (l_debug = 1) THEN
2342: print_debug('l_lpn_rsv_pri_qty > l_pri_qty_to_reduce', 4);
2343: END IF;
2344: -- Update reservations: reduce qty
2345: UPDATE mtl_reservations
2346: SET primary_reservation_quantity =
2347: (primary_reservation_quantity -
2348: ROUND(((primary_reservation_quantity * l_pri_qty_to_reduce)/l_lpn_rsv_pri_qty),5)
2349: )

Line 2399: UPDATE mtl_reservations

2395: IF (l_debug = 1) THEN
2396: print_debug('l_pri_qty_to_incr > 0 ::' || l_pri_qty_to_incr, 4);
2397: END IF;
2398: -- Update reservations: increase qty
2399: UPDATE mtl_reservations
2400: SET primary_reservation_quantity =
2401: (primary_reservation_quantity +
2402: ROUND(((primary_reservation_quantity * l_pri_qty_to_incr)/l_lpn_rsv_pri_qty),5)
2403: )

Line 2461: FROM mtl_reservations

2457:
2458: BEGIN
2459: SELECT NVL(SUM(primary_reservation_quantity),0)
2460: INTO l_nonlpn_rsv_pri_qty
2461: FROM mtl_reservations
2462: WHERE demand_source_type_id IN (2,8)
2463: AND demand_source_line_id IN
2464: (SELECT * FROM TABLE(wms_catch_weight_pvt.wdd_src_line_id))
2465: AND organization_id = p_organization_id

Line 2492: UPDATE mtl_reservations

2488: IF l_rem_pri_qty_decr > 0 THEN --{
2489: IF (l_debug = 1) THEN
2490: print_debug('Decrementing non-LPN reservations', 4);
2491: END IF;
2492: UPDATE mtl_reservations
2493: SET primary_reservation_quantity =
2494: (primary_reservation_quantity -
2495: ROUND(((primary_reservation_quantity * l_rem_pri_qty_decr)/l_nonlpn_rsv_pri_qty),5)
2496: )

Line 2545: UPDATE mtl_reservations

2541: IF l_rem_pri_qty_incr > 0 THEN --{
2542: IF (l_debug = 1) THEN
2543: print_debug('Incrementing non-LPN reservations', 4);
2544: END IF;
2545: UPDATE mtl_reservations
2546: SET primary_reservation_quantity =
2547: (primary_reservation_quantity +
2548: ROUND(((primary_reservation_quantity * l_rem_pri_qty_incr)/l_nonlpn_rsv_pri_qty),5)
2549: )

Line 2887: UPDATE mtl_reservations

2883: print_debug('l_tot_rsv_qty: ' || l_tot_rsv_qty, 4);
2884: print_debug('Updating reservation_quantity on MR', 4);
2885: END IF;
2886:
2887: UPDATE mtl_reservations
2888: SET reservation_quantity = l_tot_rsv_qty
2889: WHERE reservation_id = t_rsv_id(i);
2890: END IF; --} end if MR uom is primary, or diff uom class than secondary
2891:

Line 2896: UPDATE mtl_reservations

2892: IF (l_debug = 1) THEN
2893: print_debug('Updating pri rsv qty and dtl qty on MR', 4);
2894: END IF;
2895:
2896: UPDATE mtl_reservations
2897: SET primary_reservation_quantity = l_tot_rsv_pri_qty
2898: , detailed_quantity = l_tot_rsv_pri_qty
2899: WHERE reservation_id = t_rsv_id(i);
2900: END IF; --} end if l_tot_rsv_pri_qty > 0

Line 3248: UPDATE mtl_reservations

3244: IF (l_debug = 1) THEN
3245: print_debug('Updating dtl qty on MR', 4);
3246: END IF;
3247:
3248: UPDATE mtl_reservations
3249: SET detailed_quantity = LEAST(primary_reservation_quantity,l_tot_rsv_pri_qty)
3250: WHERE reservation_id = t_rsv_id(k);
3251: END IF;
3252: