1 package WSM_RESERVATIONS_PVT as
2 /* $Header: WSMVRSVS.pls 120.0 2005/06/29 22:00:15 mprathap noship $ */
3
4 Procedure modify_reservations_wlt ( p_txn_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
5 p_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
6 p_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
7 p_rep_job_index IN NUMBER,
8 p_sj_also_rj_index IN NUMBER,
9 x_return_status OUT NOCOPY VARCHAR2,
10 x_msg_count OUT NOCOPY NUMBER,
11 x_msg_data OUT NOCOPY VARCHAR2) ;
12
13 Procedure modify_reservations_move ( p_wip_entity_id IN NUMBER,
14 P_inventory_item_id IN NUMBER,
15 P_org_id IN NUMBER,
16 P_txn_type IN NUMBER,
17 P_net_qty IN NUMBER,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2);
21
22 Procedure modify_reservations_jobupdate (p_wip_entity_id IN NUMBER,
23 P_old_net_qty IN NUMBER ,
24 P_new_net_qty IN NUMBER,
25 P_inventory_item_id IN NUMBER,
26 P_org_id IN NUMBER,
27 P_status_type IN NUMBER,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2);
31
32 Function check_reservation_quantity (p_wip_entity_id IN NUMBER,
33 P_org_id IN NUMBER,
34 P_inventory_item_id IN NUMBER
35 )
36 Return NUMBER ;
37
38 Function check_reservation_exists (p_wip_entity_id IN NUMBER,
39 P_org_id IN NUMBER,
40 P_inventory_item_id IN NUMBER
41 )
42 Return BOOLEAN ;
43 end WSM_RESERVATIONS_PVT;