eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.WMS_WAVEPLAN_TASKS_PVT

Source


4 TYPE transaction_temp_table_type IS TABLE OF wms_waveplan_tasks_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
1 PACKAGE wms_waveplan_tasks_pvt AUTHID CURRENT_USER AS
2 /* $Header: WMSVTKPS.pls 120.9.12020000.3 2013/03/25 13:39:27 pyerrams ship $ */
3 
5 TYPE task_type_id_table_type     IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE INDEX BY BINARY_INTEGER;
6 TYPE result_table_type           IS TABLE OF wms_waveplan_tasks_temp.result%TYPE INDEX BY BINARY_INTEGER;
7 TYPE message_table_type          IS TABLE OF wms_waveplan_tasks_temp.error%TYPE INDEX BY BINARY_INTEGER;
8 TYPE task_id_table_type          IS TABLE OF wms_waveplan_tasks_temp.task_id%TYPE INDEX BY BINARY_INTEGER;
9 TYPE time_per_task_table_type    IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10 TYPE time_uom_table_type         IS TABLE OF bom_resources.unit_of_measure%TYPE INDEX BY BINARY_INTEGER;
11 
12 TYPE lookup_meaning_table IS TABLE OF mfg_lookups.meaning%TYPE INDEX BY BINARY_INTEGER;
13 TYPE row_ids_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
14 TYPE lookup_meaning_table_type IS TABLE OF mfg_lookups.meaning%TYPE INDEX BY BINARY_INTEGER;
15 
16 
17 g_task_types                   lookup_meaning_table;
18 g_task_types_orig              lookup_meaning_table;
19 g_status_codes                 lookup_meaning_table;
20 g_status_codes_orig            lookup_meaning_table;
21 g_plan_task_types              lookup_meaning_table;
22 g_plan_task_types_orig         lookup_meaning_table;
23 g_plan_status_codes            lookup_meaning_table;
24 g_plan_status_codes_orig       lookup_meaning_table;
25 
26 g_task_type_pick	CONSTANT NUMBER := 1;
27 g_task_type_putaway	CONSTANT NUMBER := 2;
28 g_task_type_cycle_count CONSTANT NUMBER := 3;
29 g_task_type_replenish	CONSTANT NUMBER := 4;
30 g_task_type_mo_transfer CONSTANT NUMBER := 5;
31 g_task_type_mo_issue	CONSTANT NUMBER := 6;
32 g_task_type_staging_move	CONSTANT NUMBER := 7;
33 g_task_type_inspection		CONSTANT NUMBER := 8;
34 
35 g_is_api_call BOOLEAN := FALSE;--Bug 13594691
36 
37 
38 
39 --Procedures for labor estimations
40 PROCEDURE mark_rows(p_transaction_temp_id IN  wms_waveplan_tasks_pvt.transaction_temp_table_type,
41 	       p_task_type_id        IN  wms_waveplan_tasks_pvt.task_type_id_table_type,
42 	       x_return_status       OUT nocopy varchar2);
43 
44 PROCEDURE unmark_rows;
45 
46 PROCEDURE query_tasks
47  (p_add                         BOOLEAN  DEFAULT FALSE,
51   p_to_subinventory_code        VARCHAR2 DEFAULT NULL,
48   p_organization_id             NUMBER   DEFAULT NULL,
49   p_subinventory_code           VARCHAR2 DEFAULT NULL,
50   p_locator_id                  NUMBER   DEFAULT NULL,
52   p_to_locator_id               NUMBER   DEFAULT NULL,
53   p_inventory_item_id           NUMBER   DEFAULT NULL,
54   p_category_set_id             NUMBER   DEFAULT NULL,
55   p_item_category_id            NUMBER   DEFAULT NULL,
56   p_person_id                   NUMBER   DEFAULT NULL,
57   p_person_resource_id          NUMBER   DEFAULT NULL,
58   p_equipment_type_id           NUMBER   DEFAULT NULL,
59   p_machine_resource_id         NUMBER   DEFAULT NULL,
60   p_machine_instance            VARCHAR2 DEFAULT NULL,
61   p_user_task_type_id           NUMBER   DEFAULT NULL,
62   p_from_task_quantity          NUMBER   DEFAULT NULL,
63   p_to_task_quantity            NUMBER   DEFAULT NULL,
64   p_from_task_priority          NUMBER   DEFAULT NULL,
65   p_to_task_priority            NUMBER   DEFAULT NULL,
66   p_from_creation_date          DATE     DEFAULT NULL,
67   p_to_creation_date            DATE     DEFAULT NULL,
68   p_is_unreleased               BOOLEAN  DEFAULT FALSE,
69   p_is_pending                  BOOLEAN  DEFAULT FALSE,
70   p_is_queued                   BOOLEAN  DEFAULT FALSE,
71   p_is_dispatched               BOOLEAN  DEFAULT FALSE,
72   p_is_active                   BOOLEAN  DEFAULT FALSE,
73   p_is_loaded                   BOOLEAN  DEFAULT FALSE,
74   p_is_completed                BOOLEAN  DEFAULT FALSE,
75   p_include_inbound             BOOLEAN  DEFAULT FALSE,
76   p_include_outbound            BOOLEAN  DEFAULT FALSE,
77   p_include_crossdock           BOOLEAN  DEFAULT FALSE,
78   p_include_manufacturing       BOOLEAN  DEFAULT FALSE,
79   p_include_warehousing         BOOLEAN  DEFAULT FALSE,
80   p_from_po_header_id           NUMBER   DEFAULT NULL,
81   p_to_po_header_id             NUMBER   DEFAULT NULL,
82   p_from_purchase_order         VARCHAR2 DEFAULT NULL,
83   p_to_purchase_order           VARCHAR2 DEFAULT NULL,
84   p_from_rma_header_id          NUMBER   DEFAULT NULL,
85   p_to_rma_header_id            NUMBER   DEFAULT NULL,
86   p_from_rma                    VARCHAR2 DEFAULT NULL,
87   p_to_rma                      VARCHAR2 DEFAULT NULL,
88   p_from_requisition_header_id  NUMBER   DEFAULT NULL,
89   p_to_requisition_header_id    NUMBER   DEFAULT NULL,
90   p_from_requisition            VARCHAR2 DEFAULT NULL,
91   p_to_requisition              VARCHAR2 DEFAULT NULL,
92   p_from_shipment_number        VARCHAR2 DEFAULT NULL,
93   p_to_shipment_number          VARCHAR2 DEFAULT NULL,
94   p_include_sales_orders        BOOLEAN  DEFAULT TRUE,
95   p_include_internal_orders     BOOLEAN  DEFAULT TRUE,
96   p_from_sales_order_id         NUMBER   DEFAULT NULL,
97   p_to_sales_order_id           NUMBER   DEFAULT NULL,
98   p_from_pick_slip_number       NUMBER   DEFAULT NULL,
99   p_to_pick_slip_number         NUMBER   DEFAULT NULL,
100   p_customer_id                 NUMBER   DEFAULT NULL,
101   p_customer_category           VARCHAR2 DEFAULT NULL,
102   p_delivery_id                 NUMBER   DEFAULT NULL,
103   p_carrier_id                  NUMBER   DEFAULT NULL,
104   p_ship_method                 VARCHAR2 DEFAULT NULL,
105   p_shipment_priority           VARCHAR2 DEFAULT NULL,
106   p_trip_id                     NUMBER   DEFAULT NULL,
107   p_from_shipment_date          DATE     DEFAULT NULL,
108   p_to_shipment_date            DATE     DEFAULT NULL,
109   p_ship_to_state               VARCHAR2 DEFAULT NULL,
110   p_ship_to_country             VARCHAR2 DEFAULT NULL,
111   p_ship_to_postal_code         VARCHAR2 DEFAULT NULL,
112   p_from_number_of_order_lines  NUMBER   DEFAULT NULL,
113   p_to_number_of_order_lines    NUMBER   DEFAULT NULL,
114   p_manufacturing_type          VARCHAR2 DEFAULT NULL,
115   p_from_job                    VARCHAR2 DEFAULT NULL,
116   p_to_job                      VARCHAR2 DEFAULT NULL,
117   p_assembly_id                 NUMBER   DEFAULT NULL,
118   p_from_start_date             DATE     DEFAULT NULL,
119   p_to_start_date               DATE     DEFAULT NULL,
120   p_from_line                   VARCHAR2 DEFAULT NULL,
121   p_to_line                     VARCHAR2 DEFAULT NULL,
122   p_department_id               NUMBER   DEFAULT NULL,
123   p_include_replenishment       BOOLEAN  DEFAULT TRUE,
124   p_from_replenishment_mo       VARCHAR2 DEFAULT NULL,
125   p_to_replenishment_mo         VARCHAR2 DEFAULT NULL,
126   p_include_mo_transfer         BOOLEAN  DEFAULT TRUE,
127   p_include_mo_issue            BOOLEAN  DEFAULT TRUE,
128   p_from_transfer_issue_mo      VARCHAR2 DEFAULT NULL,
129   p_to_transfer_issue_mo        VARCHAR2 DEFAULT NULL,
130   p_include_lpn_putaway         BOOLEAN  DEFAULT TRUE,
131   p_include_staging_move        BOOLEAN  DEFAULT FALSE,
132   p_include_cycle_count         BOOLEAN  DEFAULT TRUE,
133   p_cycle_count_name            VARCHAR2 DEFAULT NULL,
134   x_record_count            OUT NOCOPY NUMBER,
135   x_return_status           OUT NOCOPY VARCHAR2,
136   x_msg_data                OUT NOCOPY VARCHAR2,
137   x_msg_count               OUT NOCOPY NUMBER,
138   p_query_independent_tasks  BOOLEAN DEFAULT TRUE,
139   p_query_planned_tasks      BOOLEAN DEFAULT TRUE,
140   p_is_pending_plan             BOOLEAN DEFAULT FALSE,
141   p_is_inprogress_plan             BOOLEAN DEFAULT FALSE,
142   p_is_completed_plan             BOOLEAN DEFAULT FALSE,
143   p_is_cancelled_plan             BOOLEAN DEFAULT FALSE,
144   p_is_aborted_plan             BOOLEAN DEFAULT FALSE,
145   p_activity_id                 NUMBER  DEFAULT NULL,
146   p_plan_type_id                 NUMBER  DEFAULT NULL,
147   p_op_plan_id                 NUMBER  DEFAULT NULL,
148    -- R12 : Additional Query Criteria
149    p_item_type_code                            VARCHAR2 DEFAULT NULL,
150    p_age_uom_code                              VARCHAR2 DEFAULT NULL,
154    p_time_till_shipment_uom_code               VARCHAR2 DEFAULT NULL,
151    p_age_min                                   NUMBER DEFAULT NULL,
152    p_age_max                                   NUMBER DEFAULT NULL,
153    p_order_type_id                             NUMBER DEFAULT NULL,
155    p_time_till_shipment                        NUMBER DEFAULT NULL,
156    p_time_till_appt_uom_code                   VARCHAR2 DEFAULT NULL,
157    p_time_till_appt                            NUMBER DEFAULT NULL,
158    p_summary_mode				NUMBER DEFAULT 0
159    -- R12 : Additional Query Criteria
160    , p_wave_header_id                            NUMBER DEFAULT NULL,
161    --Bug 13594691
162    p_is_api_call                           BOOLEAN DEFAULT FALSE
163    --ER13869750
164    ,p_is_picknone  BOOLEAN DEFAULT FALSE
165   );
166 
167 PROCEDURE update_task (
168       p_transaction_temp_id     IN              wms_waveplan_tasks_pvt.transaction_temp_table_type,
169       p_task_type_id            IN              wms_waveplan_tasks_pvt.task_type_id_table_type,
170       p_employee                IN              VARCHAR2,
171       p_employee_id             IN              NUMBER,
172       p_user_task_type          IN              VARCHAR2,
173       p_user_task_type_id       IN              NUMBER,
174       p_effective_start_date    IN              DATE,
175       p_effective_end_date      IN              DATE,
176       p_person_resource_id      IN              NUMBER,
177       p_person_resource_code    IN              VARCHAR2,
178       p_force_employee_change   IN              BOOLEAN,
179       p_to_status               IN              VARCHAR2,
180       p_to_status_id            IN              NUMBER,
181       p_update_priority_type    IN              VARCHAR2,
182       p_update_priority         IN              NUMBER,
183       p_clear_priority          IN              VARCHAR2,
184       x_result                  OUT NOCOPY      wms_waveplan_tasks_pvt.result_table_type,
185       x_message                 OUT NOCOPY      wms_waveplan_tasks_pvt.message_table_type,
186       x_task_id                 OUT NOCOPY      wms_waveplan_tasks_pvt.task_id_table_type,
187       x_return_status           OUT NOCOPY      VARCHAR2,
188       x_return_msg              OUT NOCOPY      VARCHAR2,
189       x_msg_count               OUT NOCOPY      NUMBER);
190 
191 PROCEDURE remove_tasks (p_transaction_temp_id   IN  wms_waveplan_tasks_pvt.transaction_temp_table_type,
192 			x_record_count          OUT NOCOPY NUMBER,
193 			x_return_status         OUT nocopy VARCHAR2,
194 			x_msg_data              OUT nocopy varchar2);
195 
196 PROCEDURE save_tasks(
197 		     p_task_action               VARCHAR2,
198 		     p_commit                    BOOLEAN,
199 		     p_user_id                   NUMBER,
200 		     p_login_id                  NUMBER,
201 		     x_save_count     OUT nocopy NUMBER,
202 		     x_return_status  OUT nocopy VARCHAR2,
203 		     x_msg_data       OUT nocopy VARCHAR2,
204 		     x_msg_count      OUT nocopy NUMBER);
205 
206 -- Record Type for the task status distribution data for the performance chart
207 TYPE cb_chart_status_rec_type is RECORD
208   (status		VARCHAR2(400) 	:= NULL,
209    task_count           NUMBER          := NULL );
210 
211 -- Record Type for the Task Summary information
212 TYPE wms_task_summary_rec_type IS RECORD
213   ( wms_task_type	NUMBER,
214     task_count		NUMBER   := 0);
215 
216 -- Table Type for the task summary information
217 TYPE wms_task_summary_tbl_type IS TABLE OF wms_task_summary_rec_type
218 	INDEX BY BINARY_INTEGER;
219 
220 g_wms_task_summary_tbl	wms_task_summary_tbl_type;
221 
222 -- Table type definition for an array of cb_chart_status_rec_type records.
223 TYPE cb_chart_status_tbl_type is TABLE OF cb_chart_status_rec_type
224   INDEX BY BINARY_INTEGER;
225 
226 
227 -- Procedure definition to get task status distribution
228 PROCEDURE get_status_dist(x_status_chart_data	OUT nocopy cb_chart_status_tbl_type,
229 			  x_status_data_count	OUT nocopy NUMBER,
230 			  x_return_status	OUT nocopy VARCHAR2,
231 			  x_msg_count	       	OUT nocopy NUMBER,
232 			  x_msg_data            OUT nocopy VARCHAR2,
233 			  p_task_type_id        IN         NUMBER DEFAULT NULL);
234 
235 
236 -- Record Type for the task type distribution data for the performance chart
237 TYPE cb_chart_type_rec_type is RECORD
238   (type		VARCHAR2(100) 	:= NULL,
239    task_count	NUMBER  	:= NULL);
240 
241 -- Table type definition for an array of cb_chart_type_rec_type records.
242 TYPE cb_chart_type_tbl_type is TABLE OF cb_chart_type_rec_type
243   INDEX BY BINARY_INTEGER;
244 
245 -- Procedure definition to get task type distribution
246 PROCEDURE get_type_dist(x_type_chart_data    OUT nocopy	 cb_chart_type_tbl_type,
247 			x_type_data_count    OUT nocopy  NUMBER,
248 			x_return_status	     OUT nocopy	 VARCHAR2,
249 			x_msg_count	     OUT nocopy	 NUMBER,
250 			x_msg_data     	     OUT nocopy	 VARCHAR2,
251 			p_task_type_id       IN          NUMBER DEFAULT NULL);
252 
253 PROCEDURE calculate_summary(p_calculate_time    IN  BOOLEAN  DEFAULT FALSE,
254 			    p_time_per_task     IN  wms_waveplan_tasks_pvt.time_per_task_table_type,
255 			    p_time_per_task_uom IN  wms_waveplan_tasks_pvt.time_uom_table_type,
256 			    p_time_uom_code     IN  VARCHAR2 DEFAULT NULL,
257 			    p_time_uom          IN  VARCHAR2 DEFAULT NULL,
258 			    p_calculate_volume  IN  BOOLEAN  DEFAULT FALSE,
259 			    p_volume_uom_code   IN  VARCHAR2 DEFAULT NULL,
260 			    p_volume_uom        IN  VARCHAR2 DEFAULT NULL,
261 			    p_calculate_weight  IN  BOOLEAN  DEFAULT FALSE,
262 			    p_weight_uom_code   IN  VARCHAR2 DEFAULT NULL,
263 			    p_weight_uom        IN  VARCHAR2 DEFAULT NULL,
264 			    x_total_tasks       OUT nocopy NUMBER,
265 			    x_total_time        OUT nocopy NUMBER,
269 			    x_msg_data          OUT nocopy VARCHAR2,
266 			    x_total_weight      OUT nocopy NUMBER,
267 			    x_total_volume      OUT nocopy NUMBER,
268 			    x_return_status     OUT nocopy VARCHAR2,
270 			    x_msg_count         OUT nocopy NUMBER);
271 
272 FUNCTION get_generic_select
273  (p_is_unreleased               BOOLEAN DEFAULT FALSE,
274   p_is_pending                  BOOLEAN DEFAULT FALSE,
275   p_is_queued                   BOOLEAN DEFAULT FALSE,
276   p_is_dispatched               BOOLEAN DEFAULT FALSE,
277   p_is_active                   BOOLEAN DEFAULT FALSE,
278   p_is_loaded                   BOOLEAN DEFAULT FALSE,
279   p_is_completed                BOOLEAN DEFAULT FALSE,
280   p_populate_merged_tasks       BOOLEAN DEFAULT FALSE,
281   p_is_picknone                 BOOLEAN DEFAULT FALSE)  --ER13869750
282   RETURN VARCHAR2;
283 
284 FUNCTION get_generic_from
285  (p_is_queued                   BOOLEAN DEFAULT FALSE,
286   p_is_dispatched               BOOLEAN DEFAULT FALSE,
287   p_is_active                   BOOLEAN DEFAULT FALSE,
288   p_is_loaded                   BOOLEAN DEFAULT FALSE,
289   p_is_completed                BOOLEAN DEFAULT FALSE,
290   p_item_category_id            NUMBER  DEFAULT NULL,
291   p_category_set_id             NUMBER  DEFAULT NULL,
292   p_populate_merged_tasks       BOOLEAN DEFAULT FALSE,
293   p_is_picknone                 BOOLEAN DEFAULT FALSE,    --ER13869750
294   p_is_pending                  BOOLEAN DEFAULT FALSE,    --ER13869750
295   p_is_unreleased               BOOLEAN DEFAULT FALSE)    --ER13869750
296   RETURN VARCHAR2;
297 
298 FUNCTION get_generic_where
299  (p_add                         BOOLEAN  DEFAULT FALSE,
300   p_organization_id             NUMBER   DEFAULT NULL,
301   p_subinventory_code           VARCHAR2 DEFAULT NULL,
302   p_locator_id                  NUMBER   DEFAULT NULL,
303   p_to_subinventory_code        VARCHAR2 DEFAULT NULL,
304   p_to_locator_id               NUMBER   DEFAULT NULL,
305   p_inventory_item_id           NUMBER   DEFAULT NULL,
306   p_category_set_id             NUMBER   DEFAULT NULL,
307   p_item_category_id            NUMBER   DEFAULT NULL,
308   p_person_id                   NUMBER   DEFAULT NULL,
309   p_person_resource_id          NUMBER   DEFAULT NULL,
310   p_equipment_type_id           NUMBER   DEFAULT NULL,
311   p_machine_resource_id         NUMBER   DEFAULT NULL,
312   p_machine_instance            VARCHAR2 DEFAULT NULL,
313   p_user_task_type_id           NUMBER   DEFAULT NULL,
314   p_from_task_quantity          NUMBER   DEFAULT NULL,
315   p_to_task_quantity            NUMBER   DEFAULT NULL,
316   p_from_task_priority          NUMBER   DEFAULT NULL,
317   p_to_task_priority            NUMBER   DEFAULT NULL,
318   p_from_creation_date          DATE     DEFAULT NULL,
319   p_to_creation_date            DATE     DEFAULT NULL,
320   p_include_cycle_count         BOOLEAN  DEFAULT FALSE,
321   p_is_unreleased               BOOLEAN  DEFAULT FALSE,
322   p_is_pending                  BOOLEAN  DEFAULT FALSE,
323   p_is_queued                   BOOLEAN  DEFAULT FALSE,
324   p_is_dispatched               BOOLEAN  DEFAULT FALSE,
325   p_is_active                   BOOLEAN  DEFAULT FALSE,
326   p_is_loaded                   BOOLEAN  DEFAULT FALSE,
327   p_is_completed                BOOLEAN  DEFAULT FALSE,
328   p_populate_merged_tasks       BOOLEAN  DEFAULT FALSE,
329   p_outbound_tasks_cycle        BOOLEAN  DEFAULT FALSE,      -- bug #4661615
330    -- R12 : Additional Query Criteria
331    p_item_type_code                            VARCHAR2 DEFAULT NULL,
332    p_age_uom_code                              VARCHAR2 DEFAULT NULL,
333    p_age_min                                   NUMBER DEFAULT NULL,
334    p_age_max                                   NUMBER DEFAULT NULL
335    -- R12 : Additional Query Criteria
336    ,p_is_picknone     BOOLEAN DEFAULT FALSE --ER13869750
337   )
338   RETURN VARCHAR2;
339 
340 PROCEDURE cancel_plans(x_return_status    OUT nocopy VARCHAR2,
341                        x_ret_code          OUT nocopy wms_waveplan_tasks_pvt.message_table_type,
342              p_transaction_temp_table wms_waveplan_tasks_pvt.transaction_temp_table_type);
343 
344    PROCEDURE cancel_task (
345       p_transaction_temp_id     IN              wms_waveplan_tasks_pvt.transaction_temp_table_type,
346       p_task_type_id            IN              wms_waveplan_tasks_pvt.task_type_id_table_type,
347       p_is_crossdock            IN              BOOLEAN DEFAULT FALSE, /* Bug 5623122 */
348       x_result                  OUT NOCOPY      wms_waveplan_tasks_pvt.result_table_type,
349       x_message                 OUT NOCOPY      wms_waveplan_tasks_pvt.message_table_type,
350       x_task_id                 OUT NOCOPY      wms_waveplan_tasks_pvt.task_id_table_type,
351       x_return_status           OUT NOCOPY      VARCHAR2,
352       x_return_msg              OUT NOCOPY      VARCHAR2,
353       x_msg_count               OUT NOCOPY      NUMBER
354    );
355 
356 
357 
358 FUNCTION get_final_query RETURN VARCHAR2;
359 
360 PROCEDURE set_status_codes;
361 
362 PROCEDURE set_task_type;
363 
364 --Change
365 PROCEDURE set_plan_task_types;
366 
367   PROCEDURE set_plan_status_codes;
368 PROCEDURE find_visible_columns;
369 
370 FUNCTION get_task_summary RETURN wms_task_summary_tbl_type;
371 
372 PROCEDURE set_task_summary(p_wms_task_summary_tbl wms_task_summary_tbl_type);
373 --This procedure is added for ER13869750
374 PROCEDURE query_picknone_bulk_tasks(
375     p_organization_id       NUMBER DEFAULT NULL,
376     p_subinventory_code     VARCHAR2 DEFAULT NULL,
377     p_locator_id            NUMBER DEFAULT NULL,
378     p_inventory_item_id     NUMBER DEFAULT NULL,
379     p_category_set_id       NUMBER DEFAULT NULL,
380     p_item_category_id      NUMBER DEFAULT NULL,
381     p_person_id             NUMBER DEFAULT NULL,
382     p_person_resource_id    NUMBER DEFAULT NULL,
383     p_equipment_type_id     NUMBER DEFAULT NULL,
384     p_machine_resource_id   NUMBER DEFAULT NULL,
385     p_machine_instance      VARCHAR2 DEFAULT NULL,
386     p_user_task_type_id     NUMBER DEFAULT NULL,
387     p_from_task_quantity    NUMBER DEFAULT NULL,
388     p_to_task_quantity      NUMBER DEFAULT NULL,
389     p_from_task_priority    NUMBER DEFAULT NULL,
390     p_to_task_priority      NUMBER DEFAULT NULL,
391     p_from_creation_date    DATE DEFAULT NULL,
392     p_to_creation_date      DATE DEFAULT NULL,
393     p_item_type_code        VARCHAR2 DEFAULT NULL,
394     p_age_uom_code          VARCHAR2 DEFAULT NULL,
395     p_age_min               NUMBER DEFAULT NULL,
396     p_age_max               NUMBER DEFAULT NULL,
397 	p_include_outbound      BOOLEAN DEFAULT FALSE,
398   	p_include_manufacturing BOOLEAN DEFAULT FALSE,
399     p_is_picknone           BOOLEAN DEFAULT FALSE ) ;
400 --This procedure is added for ER13869750
401 PROCEDURE remove_not_picknone_tasks(
402 	p_is_picknone           BOOLEAN DEFAULT FALSE ,
403     x_return_status         OUT nocopy VARCHAR2,
404     x_msg_data              OUT nocopy VARCHAR2);
405 
406 
407 END wms_waveplan_tasks_pvt;