1 PACKAGE GML_MOBILE_MOVE_ORDER AUTHID CURRENT_USER AS
2 /* $Header: GMLMOMBS.pls 120.0 2005/05/25 16:20:53 appldev noship $ */
3
4
5 TYPE t_genref IS REF CURSOR;
6
7 PROCEDURE Get_Allocation_Parameters(p_alloc_class IN VARCHAR2,
8 p_org_id IN NUMBER,
9 p_cust_id IN NUMBER,
10 p_ship_to_org_id IN NUMBER,
11 x_grade OUT NOCOPY VARCHAR2,
12 x_return_status OUT NOCOPY VARCHAR2);
13
14 PROCEDURE Save_Allocation(p_transaction_id IN NUMBER,
15 p_lot_id IN NUMBER,
16 p_location IN VARCHAR2,
17 p_allocated_qty IN NUMBER,
18 p_allocated_qty2 IN NUMBER,
19 p_grade IN VARCHAR2,
20 p_lot_no IN VARCHAR2,
21 p_lot_status IN VARCHAR2,
22 p_transaction_date IN DATE,
23 p_reason_code IN VARCHAR2,
24 p_item_id IN NUMBER,
25 p_line_id IN NUMBER,
26 p_warehouse_code IN VARCHAR2,
27 p_line_detail_id IN NUMBER,
28 p_transaction_um IN VARCHAR2,
29 p_transaction_um2 IN VARCHAR2,
30 p_mo_line_id IN NUMBER,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_error_msg OUT NOCOPY VARCHAR2);
33
34 PROCEDURE Auto_Allocate(p_allow_delete IN NUMBER,
35 p_mo_line_id IN NUMBER,
36 p_transaction_header_id IN NUMBER,
37 p_move_order_type IN NUMBER,
38 x_number_of_rows OUT NOCOPY NUMBER,
39 x_qc_grade OUT NOCOPY VARCHAR2,
40 x_detailed_qty OUT NOCOPY NUMBER,
41 x_qty_UM OUT NOCOPY VARCHAR2,
42 x_detailed_qty2 OUT NOCOPY NUMBER,
43 x_qty_UM2 OUT NOCOPY VARCHAR2,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_error_msg OUT NOCOPY VARCHAR2);
46
47
48
49 PROCEDURE Get_Sales_Order_LoV( x_so_mo_lov OUT NOCOPY t_genref,
50 p_org_id IN NUMBER,
51 p_so_no IN VARCHAR2);
52
53 PROCEDURE Get_Item_LoV( x_mo_item_lov OUT NOCOPY t_genref,
54 p_org_id IN NUMBER,
55 p_item_no IN VARCHAR2);
56
57
58 PROCEDURE Get_Location_Lov( x_location_lov OUT NOCOPY t_genref,
59 p_location IN VARCHAR2,
60 p_item_id IN NUMBER,
61 p_whse_code IN VARCHAR2,
62 p_lot_id IN NUMBER,
63 p_neg_inv_allowed IN INTEGER);
64
65 PROCEDURE Get_Lot_LoV( x_lot_lov OUT NOCOPY t_genref,
66 p_lot_no IN VARCHAR2,
67 p_item_id IN NUMBER,
68 p_whse_code IN VARCHAR2,
69 p_location IN VARCHAR2,
70 p_pref_grade IN VARCHAR2,
71 p_neg_inv_allowed IN INTEGER);
72
73 PROCEDURE Get_Sub_Lot_Lov( x_sub_lot_lov OUT NOCOPY t_genref,
74 p_item_id IN NUMBER,
75 p_whse_code IN VARCHAR2,
76 p_location IN VARCHAR2,
77 p_lot_no IN VARCHAR2,
78 p_sublot_no IN VARCHAR2,
79 p_neg_inv_allowed IN INTEGER);
80
81 PROCEDURE Get_Move_Order_LoV(x_pwmo_lov OUT NOCOPY t_genref,
82 p_organization_id IN NUMBER,
83 p_mo_req_number IN VARCHAR2);
84
85
86 PROCEDURE Get_Delivery_LoV(x_delivery OUT NOCOPY t_genref,
87 p_organization_id IN NUMBER,
88 p_deliv_num IN VARCHAR2);
89
90 PROCEDURE Get_Pickslip_LoV(x_pickslip OUT NOCOPY t_genref,
91 p_organization_id IN NUMBER,
92 p_pickslip_num IN VARCHAR2);
93
94
95 PROCEDURE Get_Stacked_Messages(x_message OUT NOCOPY VARCHAR2);
96
97 PROCEDURE Get_Reason_Code_Lov(x_reasonCodeLOV OUT NOCOPY t_genref,
98 p_reason_code IN VARCHAR2);
99
100 END GML_MOBILE_MOVE_ORDER;