1 PACKAGE GME_LPN_MOBILE_TXN AS
2 /* $Header: GMELMTXS.pls 120.1 2005/11/11 08:35 nsinghi noship $ */
3 /*===========================================================================+
4 | Copyright (c) 2005 Oracle Corporation, Redwood Shores, CA, USA |
5 | All rights reserved. |
6 |===========================================================================|
7 | |
8 | PL/SQL Package to support the (Java) GME Mobile Application. |
9 | Contains PL/SQL procedures used by mobile to transact material. |
10 | |
11 +===========================================================================+
12 | HISTORY |
13 | |
14 | Date Who What |
15 | ==== === ==== |
16 | 21-Jul-05 Navin Sinha First version |
17 | |
18 +===========================================================================*/
19
20 /* Transaction types for GME defined in MaterialTransaction.java */
21 g_txn_source_type NUMBER := 5;
22 g_ing_issue NUMBER := 35;
23 g_ing_return NUMBER := 43;
24 g_prod_completion NUMBER := 44;
25 g_prod_return NUMBER := 17;
26 g_byprod_completion NUMBER := 1002;
27 g_byprod_return NUMBER := 1003;
28
29
30 TYPE t_genref IS REF CURSOR;
31
32 /*
33 PROCEDURE NAVIN_DEBUG (p_message VARCHAR2);
34
35 FUNCTION IS_MMTT_RECORD_PRESENT (p_lpn_id IN NUMBER,
36 txn_header_id OUT NUMBER,
37 txn_temp_id OUT NUMBER)
38 RETURN BOOLEAN;
39 */
40
41 PROCEDURE Lpn_LoV
42 ( x_line_cursor OUT NOCOPY t_genref
43 , p_org_id IN NUMBER
44 , p_lpn_no IN VARCHAR2
45 );
46
47 PROCEDURE Update_MO_Line
48 (p_lpn_id IN NUMBER,
49 p_wms_process_flag IN NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE Create_Material_Txn(p_organization_id IN NUMBER,
53 p_batch_id IN NUMBER,
54 p_material_detail_id IN NUMBER,
55 p_item_id IN NUMBER,
56 p_revision IN VARCHAR2,
57 p_subinventory_code IN VARCHAR2,
58 p_locator_id IN NUMBER,
59 p_txn_qty IN NUMBER,
60 p_txn_uom_code IN VARCHAR2,
61 p_sec_txn_qty IN NUMBER,
62 p_sec_uom_code IN VARCHAR2,
63 p_primary_uom_code IN VARCHAR2,
64 p_txn_primary_qty IN NUMBER,
65 p_reason_id IN NUMBER,
66 p_txn_date IN DATE,
67 p_txn_type_id IN NUMBER,
68 p_phantom_type IN NUMBER,
69 p_user_id IN NUMBER,
70 p_login_id IN NUMBER,
71 p_dispense_id IN NUMBER,
72 -- p_phantom_line_id IN NUMBER,
73 p_lpn_id IN NUMBER,
74 x_txn_id OUT NOCOPY NUMBER,
75 x_txn_type_id OUT NOCOPY NUMBER,
76 x_txn_header_id OUT NOCOPY NUMBER,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_error_msg OUT NOCOPY VARCHAR2);
79
80 PROCEDURE Process_Interface_Txn( p_txn_header_id IN NUMBER,
81 p_user_id IN NUMBER,
82 p_login_id IN NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_error_msg OUT NOCOPY VARCHAR2);
85
86 PROCEDURE get_prod_count (p_batch_id IN NUMBER,
87 p_org_id IN NUMBER,
88 x_prod_count OUT NOCOPY NUMBER,
89 x_return_status OUT NOCOPY VARCHAR2);
90
91
92 PROCEDURE get_subinv_loc(p_batch_id IN NUMBER
93 , p_org_id IN NUMBER
94 , p_material_dtl_id IN NUMBER
95 , x_subinventory OUT NOCOPY VARCHAR2
96 , x_locator OUT NOCOPY VARCHAR2
97 , x_locator_id OUT NOCOPY NUMBER
98 , x_return_status OUT NOCOPY VARCHAR2
99 , x_msg_data OUT NOCOPY VARCHAR2);
100
101 END GME_LPN_MOBILE_TXN;