1 PACKAGE WMS_TASK_UTILS_PVT as
2 /* $Header: WMSTSKUS.pls 120.1.12000000.1 2007/01/16 06:57:50 appldev ship $ */
3
4 subtype mmtt_type is mtl_material_transactions_temp%ROWTYPE;
5 TYPE MMTT_TB IS TABLE OF mmtt_type INDEX BY BINARY_INTEGER;
6
7
8 subtype mtlt_type is mtl_transaction_lots_temp%ROWTYPE;
9 TYPE MTLT_TB IS TABLE OF mtlt_type INDEX BY BINARY_INTEGER;
10
11 subtype msnt_type is mtl_serial_numbers_temp%ROWTYPE;
12 TYPE MSNT_TB IS TABLE OF msnt_type INDEX BY BINARY_INTEGER;
13
14
15 subtype mmt_type is mtl_material_transactions%ROWTYPE;
16
17
18 subtype mtln_type is mtl_transaction_lot_numbers%ROWTYPE;
19
20
21 subtype mut_type is mtl_unit_transactions%ROWTYPE;
22
23 g_qty_not_avail EXCEPTION;
24
25 PROCEDURE unload_task
26 (
27 x_ret_value OUT NOCOPY NUMBER
28 , x_message OUT NOCOPY VARCHAR2
29 , p_temp_id IN NUMBER );
30
31 PROCEDURE mydebug(msg in varchar2) ;
32
33
34 FUNCTION can_drop(p_lpn_id IN NUMBER)
35 return VARCHAR2;
36
37
38 PROCEDURE Is_task_processed
39 (
40 x_processed OUT NOCOPY VARCHAR2
41 , p_header_id IN NUMBER);
42
43
44
45 PROCEDURE generate_next_task
46 (
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 x_ret_code OUT NOCOPY VARCHAR2,
51 p_old_header_id IN NUMBER,
52 p_mo_line_id IN NUMBER,
53 p_old_sub_CODE IN VARCHAR2,
54 p_old_loc_id IN NUMBER,
55 p_wms_task_type IN NUMBER
56 );
57
58 PROCEDURE get_temp_tables
59 ( p_set_id IN NUMBER ,
60 x_mmtt OUT NOCOPY mmtt_tb,
61 x_mtlt OUT NOCOPY mtlt_tb,
62 x_msnt OUT NOCOPY msnt_tb
63 );
64
65
66
67 PROCEDURE cancel_task
68 (
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_emp_id IN NUMBER,
73 p_temp_id IN NUMBER,
74 p_previous_task_status IN NUMBER := -1/*added for 3602199*/);
75
76 /*****************************************************************/
77 --This function is called from the currentTasksFListener on pressing
78 --the Unload button,
79 --returns Y if you can continue with the unload,
80 --returns E,U if an error occurred in this api
81 --returns N if you cannot unload and puts the appropriate error in the stack
82 --returns M if you cannot unload because lpn has multiple allocations
83 /*****************************************************************/
84
85 FUNCTION can_unload(p_temp_id IN NUMBER)
86 return VARCHAR2;
87
88 /* over loaded the procedure can_unload to resolve the JDBC error */
89 PROCEDURE can_unload(x_can_unload out NOCOPY VARCHAR2, p_temp_id IN NUMBER);
90
91 END wms_TASK_UTILS_pvt;