1 PACKAGE GMO_LABEL_MGMT_GRP AS
2 /* $Header: GMOGLBPS.pls 120.1 2005/09/21 14:01:42 skarimis noship $ */
3
4 /* Global Constants */
5
6 G_PKG_NAME CONSTANT varchar2(30) := 'GMO_LABEL_MGMT_GRP';
7
8
9 /* Record Type Decleration */
10 TYPE Context_rec IS RECORD (Name VARCHAR2(80), Value VARCHAR2(4000),DISPLAY_SEQUENCE number(2));
11 TYPE CONTEXT_TABLE is TABLE of CONTEXT_rec INDEX by Binary_INTEGER;
12
13
14 -- Start of comments
15 -- API name : PRINT_LABEL
16 -- Type : Group.
17 -- Function : To Initiate Label Print.
18 -- Pre-reqs : None.
19 -- Parameters :
20 -- IN : p_api_version IN NUMBER Required
21 -- p_init_msg_list IN VARCHAR2 Required
22 -- P_ENTITY_NAME IN VARCHAR2 Required
23 -- P_ENTITY_KEY IN VARCHAR2 Required
24 -- P_WMS_BUSINESS_FLOW_CODE IN NUMBER Required
25 -- P_LABEL_TYPE IN VARCHAR2 Required
26 -- P_TRANSACTION_ID IN VARCHAR2 Required
27 -- P_TRANSACTION_TYPE IN NUMBER Required
28 -- P_APPLICATION_SHORT_NAME IN VARCHAR2 Required
29 -- P_REQUESTER IN NUMBER Required
30 -- P_CONTEXT IN TABLE OF RECORD of type CONTEXT_TABLE
31 -- .
32 -- OUT : x_return_status OUT VARCHAR2(1)
33 -- x_msg_count OUT NUMBER
34 -- x_msg_data OUT VARCHAR2(2000)
35 -- . x_Label_ID OUT NUMBER
36 -- Version : Current version 1.0
37 -- Initial version 1.0
38 --
39 -- End of comments
40
41
42 PROCEDURE PRINT_LABEL (
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 P_ENTITY_NAME IN VARCHAR2,
49 P_ENTITY_KEY IN VARCHAR2,
50 P_WMS_BUSINESS_FLOW_CODE IN NUMBER,
51 P_LABEL_TYPE IN VARCHAR2,
52 P_TRANSACTION_ID IN VARCHAR2,
53 P_TRANSACTION_TYPE IN NUMBER,
54 P_APPLICATION_SHORT_NAME IN VARCHAR2,
55 P_REQUESTER IN NUMBER,
56 P_CONTEXT IN GMO_LABEL_MGMT_GRP.CONTEXT_TABLE,
57 x_Label_id OUT NOCOPY NUMBER);
58
59 -- Start of comments
60 -- API name : COMPLETE_LABEL_PRINT
61 -- Type : Group.
62 -- Function : To Complete label printing.
63 -- Pre-reqs : PRINT_LABEL should have been called earlier to this API.
64 -- Parameters :
65 -- IN : p_api_version IN NUMBER Required
66 -- p_init_msg_list IN VARCHAR2 Required
67 -- P_ENTITY_NAME IN VARCHAR2 Required
68 -- P_ENTITY_KEY IN VARCHAR2 Required
69 -- P_LABEL_ID IN NUMBER Required
70 -- P_ERECORD_ID IN NUMBER
71 -- P_ERECORD_STATUS IN VARCHAR2
72
73 -- OUT : x_return_status OUT VARCHAR2(1)
74 -- x_msg_count OUT NUMBER
75 -- x_msg_data OUT VARCHAR2(2000)
76 -- . x_Print_status OUT VARCHAR2
77 -- Version : Current version 1.0
78 -- Initial version 1.0
79 --
80 -- End of comments
81
82 PROCEDURE COMPLETE_LABEL_PRINT(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 P_LABEL_ID IN NUMBER,
89 P_ERECORD_ID IN NUMBER,
90 P_ERECORD_STATUS IN VARCHAR2,
91 x_print_status OUT NOCOPY VARCHAR2);
92
93 -- Start of comments
94 -- API name : CANCEL_LABEL_PRINT
95 -- Type : Group.
96 -- Function : To Cancel label printing.
97 -- Pre-reqs : PRINT_LABEL should have been called earlier to this API.
98 -- Parameters :
99 -- IN : p_api_version IN NUMBER Required
100 -- p_init_msg_list IN VARCHAR2 Required
101 -- P_ENTITY_NAME IN VARCHAR2 Required
102 -- P_ENTITY_KEY IN VARCHAR2 Required
103 -- P_LABEL_ID IN NUMBER Required
104
105 -- OUT : x_return_status OUT VARCHAR2(1)
106 -- x_msg_count OUT NUMBER
107 -- x_msg_data OUT VARCHAR2(2000)
108 -- Version : Current version 1.0
109 -- Initial version 1.0
110 --
111 -- End of comments
112
113
114 PROCEDURE CANCEL_LABEL_PRINT(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 P_LABEL_ID IN NUMBER
121 );
122
123 -- Start of comments
124 -- API name : AUTO_PRINT_ENABLED
125 -- Type : Group.
126 -- Function : Determines if auto matic label printing is enabled or not.
127 -- Pre-reqs : None.
128 -- Parameters :
129 -- IN : None
130
131 -- OUT : Boolean true or false
132 -- Version : None
133 --
134 -- End of comments
135
136 FUNCTION AUTO_PRINT_ENABLED return boolean;
137
138 -- Start of comments
139 -- API name : GET_PRINT_COUNT
140 -- Type : Group.
141 -- Function : Returns the no of labels printed for the given input parameters.
142 -- Pre-reqs : None.
143 -- Parameters :
144 -- IN : p_api_version IN NUMBER Required
145 -- p_init_msg_list IN VARCHAR2 Required
146 -- P_WMS_BUSINESS_FLOW_CODE IN NUMBER Required
147 -- P_LABEL_TYPE IN VARCHAR2 Required
148 -- P_TRANSACTION_ID IN VARCHAR2 Required
149 -- P_TRANSACTION_TYPE IN NUMBER Required
150 -- .
151 -- OUT : x_return_status OUT VARCHAR2(1)
152 -- x_msg_count OUT NUMBER
153 -- x_msg_data OUT VARCHAR2(2000)
154 -- . x_print_count OUT NUMBER
155 -- Version : Current version 1.0
156 -- Initial version 1.0
157 --
158 -- End of comments
159
160 PROCEDURE GET_PRINT_COUNT(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 P_WMS_BUSINESS_FLOW_CODE IN NUMBER,
167 P_LABEL_TYPE IN NUMBER,
168 P_TRANSACTION_ID IN VARCHAR2,
169 P_TRANSACTION_TYPE IN VARCHAR2,
170 x_print_count OUT NOCOPY NUMBER);
171
172 end GMO_LABEL_MGMT_GRP;