1 PACKAGE inv_mo_backorder_pvt AS
2 /* $Header: INVMOBOS.pls 120.0 2005/05/25 05:45:54 appldev noship $ */
3
4
5 /**
6 * BackOrders the Source tied to a Move Order Line.
7 * <p>
8 * The API is responsible for Backordering the Source tied to the Move Order Line.
9 * Before Backordering the Soure, all the Allocations for the Move Order Line are
10 * deleted. For a WMS Organization, the Tasks should not be Active or Loaded.
11 * <p>
12 * The Backordered Source (either Sales Order or Job/Schedule) is available for
13 * Re-Release again.
14 * <p>
15 * The API commits at the end if there is no error.
16 * <p>
17 * @param p_line_id Move Order Line ID
18 * @param x_return_status Return Status of the API
19 * @param x_msg_count Message Count in Message Stack
20 * @param x_msg_data Message Data if Message Count is 1.
21 */
22 PROCEDURE backorder(
23 p_line_id IN NUMBER
24 , x_return_status OUT NOCOPY VARCHAR2
25 , x_msg_count OUT NOCOPY NUMBER
26 , x_msg_data OUT NOCOPY VARCHAR2
27 );
28
29 /**
30 * Deletes the Details tied to a Move Order Line.
31 * <p>
32 * The API is responsible for deleting an Allocation of a Move Order Line.
33 * <p>
34 * Before Deleting the Allocation, if the Allocation has a Reservation tied to it, it
35 * decrements the Reserved Qty and Detailed Qty in the Reservation. <br>
36 * For an ATO Item, if the profile WSH_RETAIN_ATO_RESERVATIONS is set to Y, then the
37 * Reservation Qty is not changed. Only the Detailed Qty is affected.
38 * <p>
39 * @param p_transaction_temp_id Transaction Temp ID
40 * @param p_move_order_line_id Move Order Line ID
41 * @param p_reservation_id Reservation ID
42 * @param p_transaction_quantity Transaction Qty
43 * @param p_primary_trx_qty Primary Transaction Qty
44 * @param x_return_status Return Status of the API
45 * @param x_msg_count Message Count in Message Stack
46 * @param x_msg_data Message Data if Message Count is 1.
47 */
48 PROCEDURE delete_details(
49 p_transaction_temp_id IN NUMBER
50 , p_move_order_line_id IN NUMBER
51 , p_reservation_id IN NUMBER
52 , p_transaction_quantity IN NUMBER
53 , p_primary_trx_qty IN NUMBER
54 , p_secondary_trx_qty IN NUMBER -- INVCONV
55 , x_return_status OUT NOCOPY VARCHAR2
56 , x_msg_count OUT NOCOPY NUMBER
57 , x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 END inv_mo_backorder_pvt;