1 PACKAGE WSH_WV_PVT AUTHID CURRENT_USER as
2 /* $Header: WSHUTWVS.pls 115.6 99/07/16 08:24:20 porting ship $ */
3
4 -- WSH_WV_PVT
5 -- Purpose
6 -- Weight/Volume API for Departure Planning Workbench and Ship Confirm
7 -- History
8 -- 12-AUG-1996 wrudge Created
9 --
10
11 PROCEDURE departure_weight_volume(
12 source IN VARCHAR2,
13 departure_id IN NUMBER,
14 organization_id IN NUMBER,
15 wv_flag IN VARCHAR2,
16 update_flag IN VARCHAR2,
17 menu_flag IN VARCHAR2,
18 dpw_pack_flag IN VARCHAR2,
19 x_sc_wv_mode IN VARCHAR2 DEFAULT 'ALL',
20 master_weight_uom IN VARCHAR2,
21 net_weight IN OUT NUMBER,
22 tare_weight IN OUT NUMBER,
23 master_volume_uom IN VARCHAR2,
24 volume IN OUT NUMBER,
25 status IN OUT NUMBER);
26
27 PROCEDURE dep_weight_volume(
28 source IN VARCHAR2,
29 departure_id IN NUMBER,
30 organization_id IN NUMBER,
31 wv_flag IN VARCHAR2,
32 update_flag IN VARCHAR2,
33 menu_flag IN VARCHAR2,
34 dpw_pack_flag IN VARCHAR2,
35 x_sc_wv_mode IN VARCHAR2 DEFAULT 'ALL',
36 master_weight_uom IN VARCHAR2,
37 net_weight IN OUT NUMBER,
38 tare_weight IN OUT NUMBER,
39 master_volume_uom IN VARCHAR2,
40 volume IN OUT NUMBER,
41 status IN OUT NUMBER);
42
43 PROCEDURE dep_loose_weight_volume(
44 source IN VARCHAR2,
45 departure_id IN NUMBER,
46 organization_id IN NUMBER,
47 x_sc_wv_mode IN VARCHAR2 DEFAULT 'ALL',
48 master_weight_uom IN VARCHAR2,
49 weight IN OUT NUMBER,
50 master_volume_uom IN VARCHAR2,
51 volume IN OUT NUMBER,
52 status IN OUT NUMBER);
53
54 PROCEDURE dep_fill_percentage(
55 departure_id IN NUMBER,
56 organization_id IN NUMBER,
57 vehicle_id IN NUMBER,
58 vehicle_max_weight IN NUMBER,
59 gross_weight IN NUMBER,
60 vehicle_max_volume IN NUMBER,
61 volume IN NUMBER,
62 vehicle_min_fill IN NUMBER,
63 actual_fill IN OUT NUMBER,
64 status IN OUT NUMBER);
65
66 PROCEDURE del_weight_volume(
67 source IN VARCHAR2,
68 del_id IN NUMBER,
69 organization_id IN NUMBER,
70 update_flag IN VARCHAR2,
71 menu_flag IN VARCHAR2,
72 dpw_pack_flag IN VARCHAR2,
73 x_sc_wv_mode IN VARCHAR2 DEFAULT 'ALL',
74 master_weight_uom IN VARCHAR2,
75 gross_weight IN OUT NUMBER,
76 master_volume_uom IN VARCHAR2,
77 volume IN OUT NUMBER,
78 status IN OUT NUMBER);
79
80 PROCEDURE del_volume(
81 source IN VARCHAR2,
82 delivery_id IN NUMBER,
83 organization_id IN NUMBER,
84 x_sc_wv_mode IN VARCHAR2 DEFAULT 'ALL',
85 master_uom IN VARCHAR2,
86 volume IN OUT NUMBER,
87 status IN OUT NUMBER);
88
89 PROCEDURE del_weight(
90 source IN VARCHAR2,
91 delivery_id IN NUMBER,
92 organization_id IN NUMBER,
93 menu_flag IN VARCHAR2,
94 x_sc_wv_mode IN VARCHAR2 DEFAULT 'ALL',
95 master_uom IN VARCHAR2,
96 gross_weight IN OUT NUMBER,
97 status IN OUT NUMBER);
98
99 FUNCTION validate_packed_qty(
100 delivery_id IN NUMBER,
101 pack_mode IN VARCHAR2 DEFAULT 'ALL',
102 status IN OUT NUMBER)
103 RETURN BOOLEAN;
104
105 FUNCTION containers_load_check(
106 delivery_id IN NUMBER,
107 pack_mode IN VARCHAR2 DEFAULT 'ALL',
108 status IN OUT NUMBER)
109 RETURN BOOLEAN;
110
111 FUNCTION containers_weight_check(
112 delivery_id IN NUMBER,
113 organization_id IN NUMBER,
114 status IN OUT NUMBER)
115 RETURN BOOLEAN;
116
117 PROCEDURE containers_weight(
118 delivery_id IN NUMBER,
119 organization_id IN NUMBER,
120 sequence_number IN NUMBER,
121 menu_flag IN VARCHAR2,
122 x_sc_wv_mode IN VARCHAR2 DEFAULT 'ALL',
123 master_uom IN VARCHAR2,
124 weight IN OUT NUMBER,
125 status IN OUT NUMBER);
126
127 PROCEDURE unpacked_items_weight(
128 delivery_id IN NUMBER,
129 organization_id IN NUMBER,
130 x_sc_wv_mode IN VARCHAR2 DEFAULT 'ALL',
131 master_uom IN VARCHAR2,
132 weight IN OUT NUMBER,
133 status IN OUT NUMBER);
134
135 PROCEDURE del_autopack(
136 del_id IN NUMBER,
137 organization_id IN NUMBER,
138 status IN OUT NUMBER);
139
140 PROCEDURE del_packcont(
141 del_id IN NUMBER,
142 organization_id IN NUMBER,
143 cont_item_id IN NUMBER,
144 raw_qty IN NUMBER,
145 min_fill IN NUMBER, -- range 0.00-1.00 (not 0-100)
146 parent_seq IN NUMBER,
147 load_seq_number IN NUMBER,
148 weight_uom_code IN VARCHAR2,
149 status IN OUT NUMBER);
150
151 FUNCTION order_net_weight_in_delivery(
152 order_number IN NUMBER,
153 order_type_id IN NUMBER,
154 delivery_id IN NUMBER,
155 weight_uom IN VARCHAR2)
156 RETURN NUMBER;
157
158 FUNCTION convert_uom(from_uom IN VARCHAR2,
159 to_uom IN VARCHAR2,
160 quantity IN NUMBER,
161 item_id IN NUMBER DEFAULT NULL)
162 RETURN NUMBER;
163 pragma restrict_references (convert_uom, WNDS);
164
165 END WSH_WV_PVT;