[Home] [Help]
PACKAGE: APPS.GMI_MSCA_PUB
Source
1 PACKAGE gmi_msca_pub AS
2 /* $Header: GMIPMSCS.pls 120.0 2005/05/25 16:01:02 appldev noship $ */
3
4 -- PL/SQL package to support Java MSCA for GMI
5 /*===========================================================================+
6 | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |
7 | All rights reserved. |
8 |===========================================================================|
9 | |
10 | PL/SQL Package to support the (Java) GMI Mobile Application. Various |
11 | procedures perform lookups. |
12 | |
13 | |
14 | Author: Olivier Daboval, OPM Development UK, August 2004 |
15 | |
16 +===========================================================================+
17 | HISTORY |
18 | |
19 | Date Who What |
20 | ==== === ==== |
21 | 10Sep04 odaboval First version following TDD Review |
22 | 11Oct04 odaboval Corrected phase to pls from plb in dbdrv |
23 | |
24 +===========================================================================*/
25
26
27
28 TYPE t_genref IS REF CURSOR;
29
30 FUNCTION get_opm_uom_code(x_apps_unit_meas_lookup_code IN VARCHAR2) RETURN VARCHAR2;
31
32 PROCEDURE item_no_lov
33 ( x_itemNo_cursor OUT NOCOPY t_genref
34 , p_item_no IN VARCHAR2
35 , p_item_desc IN VARCHAR2
36 );
37
38 PROCEDURE loct_lov
39 ( x_loct_cursor OUT NOCOPY t_genref
40 , p_loct IN VARCHAR2
41 , p_whse_code IN VARCHAR2
42 );
43
44 PROCEDURE lot_lov
45 ( x_lot_cursor OUT NOCOPY t_genref
46 , p_lot IN VARCHAR2
47 , p_sublot IN VARCHAR2
48 , p_item_no IN VARCHAR2
49 , p_whse_code IN VARCHAR2
50 , p_location IN VARCHAR2
51 );
52
53 PROCEDURE orgn_lov
54 ( x_orgn_cursor OUT NOCOPY t_genref
55 , p_orgn IN VARCHAR2
56 , p_user_id IN NUMBER
57 );
58
59 PROCEDURE reason_lov
60 ( x_reason_cursor OUT NOCOPY t_genref
61 , p_reason IN VARCHAR2
62 , p_doc_type IN VARCHAR2
63 );
64
65 PROCEDURE sublot_lov
66 ( x_sublot_cursor OUT NOCOPY t_genref
67 , p_sublot IN VARCHAR2
68 , p_lot IN VARCHAR2
69 , p_item_no IN VARCHAR2
70 );
71
72 PROCEDURE uom_lov
73 ( x_uom_cursor OUT NOCOPY t_genref
74 , p_uom IN VARCHAR2
75 , p_item_no IN VARCHAR2
76 );
77
78 PROCEDURE whse_lov
79 ( x_subInv_cursor OUT NOCOPY t_genref
80 , p_whse_code IN VARCHAR2
81 , p_orgn_code IN VARCHAR2
82 , p_user_id IN NUMBER
83 );
84
85 PROCEDURE to_whse_lov
86 ( x_subInv_cursor OUT NOCOPY t_genref
87 , p_whse_code IN VARCHAR2
88 , p_from_whse_code IN VARCHAR2
89 , p_orgn_code IN VARCHAR2
90 , p_user_id IN NUMBER
91 );
92
93 PROCEDURE to_loct_lov
94 ( x_loct_cursor OUT NOCOPY t_genref
95 , p_loct IN VARCHAR2
96 , p_whse_code IN VARCHAR2
97 , p_from_whse IN VARCHAR2
98 , p_from_loct IN VARCHAR2
99 );
100
101 PROCEDURE Create_Transaction
102 ( p_user_name IN VARCHAR2
103 , p_doc_type IN VARCHAR2
104 , p_item_no IN VARCHAR2
105 , p_whse_code IN VARCHAR2
106 , p_orgn_code IN VARCHAR2
107 , p_co_code IN VARCHAR2
108 , p_location IN VARCHAR2
109 , p_lot_no IN VARCHAR2
110 , p_sublot_no IN VARCHAR2
111 , p_qc_grade IN VARCHAR2
112 , p_lot_status IN VARCHAR2
113 , p_reason_code IN VARCHAR2
114 , p_trans_qty1 IN NUMBER
115 , p_trans_UOM1 IN VARCHAR2
116 , p_trans_qty2 IN NUMBER
117 , p_trans_UOM2 IN VARCHAR2
118 , p_to_whse_code IN VARCHAR2
119 , p_to_location IN VARCHAR2
120 , x_return_value OUT NOCOPY NUMBER
121 , x_message OUT NOCOPY VARCHAR2);
122
123 PROCEDURE get_lot_status
124 ( p_item_id IN NUMBER
125 , p_whse_code IN VARCHAR2
126 , p_location IN VARCHAR2
127 , p_lot_id IN NUMBER
128 , p_lot_status IN VARCHAR2
129 , x_lot_status OUT NOCOPY VARCHAR2
130 );
131
132 END gmi_msca_pub;