1 PACKAGE WSH_WVX_PVT AUTHID CURRENT_USER as
2 /* $Header: WSHUTWXS.pls 115.10 99/08/11 19:23:12 porting ship $ */
3
4 -- WSH_WVX_PVT
5 -- Purpose
6 -- Extension of Weight/Volume API (WSH_WV_PVT)
7 -- History
8 -- 06-JAN-1998 wrudge Created
9 --
10
11 FUNCTION x_order_net_wt_in_delivery(
12 order_number IN NUMBER,
13 order_type_id IN NUMBER,
14 delivery_id IN NUMBER,
15 weight_uom IN VARCHAR2)
16 RETURN NUMBER;
17
18
19 PROCEDURE ato_weight_volume(
20 source IN VARCHAR2,
21 ato_line_id IN NUMBER,
22 quantity IN NUMBER,
23 weight_uom IN VARCHAR2,
24 weight OUT NUMBER,
25 volume_uom IN VARCHAR2,
26 volume OUT NUMBER,
27 status IN OUT NUMBER);
28
29
30 FUNCTION x_containers_load_check(
31 delivery_id IN NUMBER,
32 pack_mode IN VARCHAR2 DEFAULT 'ALL',
33 status IN OUT NUMBER)
34 RETURN BOOLEAN;
35
36 PROCEDURE container_net_volume(
37 delivery_id IN NUMBER,
38 organization_id IN NUMBER,
39 container_id IN NUMBER,
40 sequence_number IN NUMBER,
41 master_uom IN VARCHAR2,
42 pack_mode IN VARCHAR2,
43 volume OUT NUMBER);
44
45 PROCEDURE container_fill_percent(
46 delivery_id IN NUMBER,
47 organization_id IN NUMBER,
48 container_id IN NUMBER,
49 container_item_id IN NUMBER,
50 sequence_number IN NUMBER,
51 container_qty IN NUMBER,
52 pack_mode IN VARCHAR2,
53 fill_percent OUT NUMBER);
54
55 PROCEDURE set_messages(message_string IN VARCHAR2,
56 message_count IN OUT NUMBER,
57 message_text1 IN OUT VARCHAR2,
58 message_text2 IN OUT VARCHAR2,
59 message_text3 IN OUT VARCHAR2,
60 message_text4 IN OUT VARCHAR2);
61
62 PROCEDURE containers_net_weight(X_container_id IN NUMBER,
63 X_organization_id IN NUMBER,
64 X_pack_mode IN VARCHAR2,
65 X_master_uom IN VARCHAR2,
66 X_net_weight IN OUT NUMBER);
67
68 PROCEDURE containers_tare_weight(X_container_id IN NUMBER,
69 X_master_uom IN VARCHAR2,
70 X_tare_weight IN OUT NUMBER,
71 x_org_id IN NUMBER);
72
73 PROCEDURE containers_tare_weight_self(
74 X_container_id IN NUMBER,
75 X_org_id IN NUMBER,
76 X_master_uom IN VARCHAR2,
77 X_tare_weight IN OUT NUMBER);
78
79 PROCEDURE del_containers_tare_weight(
80 X_del_id IN NUMBER,
81 X_org_id IN NUMBER,
82 X_master_uom IN VARCHAR2,
83 X_tare_weight IN OUT NUMBER);
84
85 PROCEDURE auto_calc_cont(x_del_id IN NUMBER,
86 x_org_id IN NUMBER,
87 x_pack_mode IN VARCHAR2,
88 x_fill_base IN VARCHAR2);
89
90
91 END WSH_WVX_PVT;