1 PACKAGE wms_consolidation_pub AS
2 /* $Header: WMSCONSS.pls 120.4.12010000.1 2008/07/28 18:32:35 appldev ship $ */
3
4 TYPE t_genref IS REF CURSOR;
5
6
7 PROCEDURE get_values_for_loc(p_sub IN VARCHAR2,
8 p_loc_id IN NUMBER,
9 p_org_id IN NUMBER,
10 p_comp_cons_dels_inq_mode IN VARCHAR2,
11 x_total_no_of_dels OUT NOCOPY NUMBER,
12 x_total_no_of_cons_dels OUT NOCOPY NUMBER,
13 x_total_no_of_lpns OUT NOCOPY NUMBER,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2);
17
18
19
20 PROCEDURE get_consolidation_inq_loc(x_loc IN OUT NOCOPY VARCHAR2,
21 p_sub IN VARCHAR2,
22 p_org_id IN NUMBER,
23 p_comp_cons_dels_inq_mode IN VARCHAR2,
24 x_total_no_of_dels OUT NOCOPY NUMBER,
25 x_total_no_of_cons_dels OUT NOCOPY NUMBER,
26 x_total_no_of_lpns OUT NOCOPY NUMBER,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 x_loc_available OUT NOCOPY VARCHAR2,
31 x_loc_count OUT NOCOPY NUMBER);
32
33
34 PROCEDURE get_consolidation_inq_lpn_lov(x_lpn_lov OUT NOCOPY t_genref,
35 p_org_id IN NUMBER,
36 p_lpn IN VARCHAR2);
37
38
39 PROCEDURE get_consolidation_inq_del_lov(x_deliveryLOV OUT NOCOPY t_genref,
40 p_organization_id IN NUMBER,
41 p_delivery_name IN VARCHAR2,
42 p_lpn_id IN NUMBER);
43
44
45 PROCEDURE get_cons_inq_orders_lov(x_order_lov OUT NOCOPY t_genref,
46 p_org_id IN NUMBER,
47 p_order IN VARCHAR2,
48 p_delivery_id IN NUMBER,
49 p_lpn_id IN NUMBER);
50
51
52 PROCEDURE get_consolidation_inq_sub_lov(x_sub_lov OUT NOCOPY t_genref,
53 p_sub IN VARCHAR2,
54 p_org_id IN NUMBER);
55
56
57 PROCEDURE get_consolidation_inq_loc_lov(x_loc_lov OUT NOCOPY t_genref,
58 p_sub IN VARCHAR2,
59 p_loc IN VARCHAR2,
60 p_org_id IN NUMBER,
61 p_comp_cons_dels_inq_mode IN VARCHAR2);
62
63 PROCEDURE get_consolidation_inq_loc_lov(x_loc_lov OUT NOCOPY t_genref,
64 p_sub IN VARCHAR2,
65 p_loc IN VARCHAR2,
66 p_org_id IN NUMBER,
67 p_comp_cons_dels_inq_mode IN VARCHAR2,
68 p_alias IN VARCHAR2);
69
70
71 PROCEDURE get_values_for_lpn(p_lpn_id IN NUMBER,
72 p_org_id IN NUMBER,
73 x_sub IN OUT NOCOPY VARCHAR2,
74 x_loc IN OUT NOCOPY VARCHAR2,
75 x_delivery_id IN OUT NOCOPY NUMBER,
76 x_order_number IN OUT NOCOPY VARCHAR2,
77 p_inquiry_mode IN NUMBER,
78 p_comp_cons_dels_inq_mode IN VARCHAR2,
79 x_delivery_status OUT NOCOPY VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 x_lpn OUT NOCOPY VARCHAR2,
84 x_project OUT NOCOPY VARCHAR2,
85 x_task OUT NOCOPY VARCHAR2);
86
87
88
89 PROCEDURE get_consolidation_inq_lpn(x_loc IN OUT NOCOPY VARCHAR2,
90 x_sub IN OUT NOCOPY VARCHAR2,
91 p_org_id IN NUMBER,
92 x_delivery_id IN OUT NOCOPY NUMBER,
93 x_order_number IN OUT NOCOPY VARCHAR2,
94 p_inquiry_mode IN NUMBER,
95 p_comp_cons_dels_inq_mode IN VARCHAR2,
96 x_lpn_vector OUT NOCOPY VARCHAR2,
97 x_delivery_status OUT NOCOPY VARCHAR2,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 x_lpn IN OUT NOCOPY VARCHAR2,
102 x_lpn_available OUT NOCOPY VARCHAR2,
103 x_project OUT NOCOPY VARCHAR2,
104 x_task OUT NOCOPY VARCHAR2);
105
106
107 PROCEDURE get_query_by_del_lpn(x_delivery_id IN OUT NOCOPY NUMBER,
108 p_org_id IN NUMBER,
109 x_order_number OUT NOCOPY VARCHAR2,
110 x_loc OUT NOCOPY VARCHAR2,
111 x_sub OUT NOCOPY VARCHAR2,
112 x_lpn_vector OUT NOCOPY VARCHAR2,
113 x_delivery_status OUT NOCOPY VARCHAR2,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 x_lpn OUT NOCOPY VARCHAR2,
118 x_lpn_available OUT NOCOPY VARCHAR2,
119 x_tot_lines_for_del OUT NOCOPY NUMBER,
120 x_tot_comp_lines_for_del OUT NOCOPY NUMBER,
121 x_tot_locs_for_del OUT NOCOPY NUMBER,
122 x_project OUT NOCOPY VARCHAR2,
123 x_task OUT NOCOPY VARCHAR2);
124
125
126 PROCEDURE get_empty_cons_loc_lov(x_loc_lov OUT NOCOPY t_genref,
127 p_sub IN VARCHAR2,
128 p_loc IN VARCHAR2,
129 p_org_id IN NUMBER,
130 p_alias IN VARCHAR2);
131
132 PROCEDURE get_empty_cons_loc_lov(x_loc_lov OUT NOCOPY t_genref,
133 p_sub IN VARCHAR2,
134 p_loc IN VARCHAR2,
135 p_org_id IN NUMBER);
136
137 PROCEDURE get_empty_cons_loc(p_sub IN VARCHAR2,
138 p_org_id IN NUMBER,
139 x_loc OUT NOCOPY VARCHAR2,
140 x_loc_count OUT NOCOPY NUMBER,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2);
144
145
146 PROCEDURE lpn_mass_move (p_org_id IN NUMBER,
147 p_from_sub IN VARCHAR2,
148 p_from_loc_id IN NUMBER,
149 p_to_sub IN VARCHAR2,
150 p_to_loc_id IN NUMBER,
151 p_to_loc_type IN NUMBER,
152 p_transfer_lpn_id IN NUMBER,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2);
156
157
158 PROCEDURE get_lpn_mass_move_sub_lov(x_sub_lov OUT NOCOPY t_genref,
159 p_sub IN VARCHAR2,
160 p_org_id IN NUMBER);
161
162
163 PROCEDURE get_lpn_mass_move_locs_lov(x_loc_lov OUT NOCOPY t_genref,
164 p_org_id IN NUMBER,
165 p_sub IN VARCHAR2,
166 p_loc IN VARCHAR2,
167 p_from_sub IN VARCHAR2,
168 p_from_loc IN VARCHAR2);
169
170 PROCEDURE get_lpn_mass_move_locs_lov(x_loc_lov OUT NOCOPY t_genref,
171 p_org_id IN NUMBER,
172 p_sub IN VARCHAR2,
173 p_loc IN VARCHAR2,
174 p_from_sub IN VARCHAR2,
175 p_from_loc IN VARCHAR2,
176 p_alias IN VARCHAR2);
177
178 PROCEDURE get_lpn_mass_move_lpn_lov(x_lpn_lov OUT NOCOPY t_genref,
179 p_org_id IN NUMBER,
180 p_lpn IN VARCHAR2,
181 p_from_loc_id IN VARCHAR2);
182
183 FUNCTION is_delivery_consolidated(p_delivery_id IN NUMBER,
184 p_org_id IN NUMBER,
185 p_sub IN VARCHAR2 DEFAULT NULL, -- added default for packing workbench query (patchset J)
186 p_loc_id IN NUMBER DEFAULT NULL) -- added default for packing workbench query (patchset J)
187 RETURN VARCHAR2;
188
189
190 PROCEDURE create_staging_move
191 (p_org_id IN NUMBER
192 , p_user_id IN NUMBER
193 , p_emp_id IN NUMBER
194 , p_eqp_ins IN VARCHAR2
195 , p_lpn_id IN NUMBER
196 , x_return_status OUT nocopy VARCHAR2
197 , x_msg_count OUT NOCOPY NUMBER
198 , x_msg_data OUT NOCOPY VARCHAR2
199 , p_calling_mode IN VARCHAR2
200 , p_temp_id OUT NOCOPY NUMBER
201 );
202
203
204 PROCEDURE mydebug(msg in varchar2);
205
206 END wms_consolidation_pub;