1 PACKAGE INV_CYC_SERIALS AUTHID CURRENT_USER AS
2 /* $Header: INVCYCMS.pls 120.1.12020000.2 2012/07/09 08:05:05 asugandh ship $ */
3
4 TYPE t_genref IS REF CURSOR;
5
6 PROCEDURE get_scheduled_serial_lov
7 (x_serials OUT NOCOPY t_genref ,
8 p_organization_id IN NUMBER ,
9 p_subinventory IN VARCHAR2 ,
10 p_locator_id IN NUMBER := NULL ,
11 p_inventory_item_id IN NUMBER ,
12 p_revision IN VARCHAR2 := NULL ,
13 p_lot_number IN VARCHAR2 := NULL ,
14 p_cycle_count_header_id IN NUMBER ,
15 p_parent_lpn_id IN NUMBER := NULL);
16
17 PROCEDURE get_serial_entry_lov
18 (x_serials OUT NOCOPY t_genref ,
19 p_organization_id IN NUMBER ,
20 p_subinventory IN VARCHAR2 ,
21 p_locator_id IN NUMBER := NULL ,
22 p_inventory_item_id IN NUMBER ,
23 p_revision IN VARCHAR2 := NULL ,
24 p_lot_number IN VARCHAR2 := NULL ,
25 p_cycle_count_header_id IN NUMBER ,
26 p_parent_lpn_id IN NUMBER := NULL);
27
28 PROCEDURE initialize_scheduled_serials
29 (p_organization_id IN NUMBER ,
30 p_subinventory IN VARCHAR2 ,
31 p_locator_id IN NUMBER := NULL ,
32 p_inventory_item_id IN NUMBER ,
33 p_revision IN VARCHAR2 := NULL ,
34 p_lot_number IN VARCHAR2 := NULL ,
35 p_cycle_count_header_id IN NUMBER ,
36 p_parent_lpn_id IN NUMBER := NULL);
37
38
39 -- Name: MARK_SERIAL
40 --
41 -- Input parameters:
42 -- p_organization_id Organization ID
43 -- p_subinventory Subinventory code
44 -- p_locator_id Locator ID
45 -- p_inventory_item_id Inventory Item ID
46 -- p_revision Revision
47 -- p_lot_number Lot Number
48 -- p_serial_number Serial Number
49 -- p_parent_lpn_id Parent LPN ID
50 -- p_cycle_count_header_id Cycle Count Header ID
51 --
52 -- Output parameters:
53 -- x_return_code This outputs the return status
54 -- of the API
55 -- 0 - Serial was successfully marked
56 -- 1 - Unscheduled entries are not allowed
57 -- The serial number given was not part of the
58 -- cycle count entry and we are not allowing
59 -- unscheduled multiple serial entries at this time
60 -- -1 - Others type of error occurred
61 --
62 -- Functions: This API is used for multiple serial cycle counting.
63 -- This marks the serial number's group mark ID so that
64 -- it is considered as currently counted, marked to be
65 -- processed in the future.
66 --
67 PROCEDURE mark_serial
68 (p_organization_id IN NUMBER ,
69 p_subinventory IN VARCHAR2 ,
70 p_locator_id IN NUMBER := NULL ,
71 p_inventory_item_id IN NUMBER ,
72 p_revision IN VARCHAR2 := NULL ,
73 p_lot_number IN VARCHAR2 := NULL ,
74 p_serial_number IN VARCHAR2 ,
75 p_parent_lpn_id IN NUMBER := NULL ,
76 p_cycle_count_header_id IN NUMBER ,
77 x_return_code OUT NOCOPY NUMBER);
78
79 -- Name: REMOVE_SERIAL
80 --
81 -- Input parameters:
82 -- p_organization_id Organization ID
83 -- p_subinventory Subinventory code
84 -- p_locator_id Locator ID
85 -- p_inventory_item_id Inventory Item ID
86 -- p_revision Revision
87 -- p_lot_number Lot Number
88 -- p_serial_number Serial Number
89 -- p_parent_lpn_id Parent LPN ID
90 -- p_cycle_count_header_id Cycle Count Header ID
91 --
92 -- Output parameters:
93 -- x_return_code This outputs the return status
94 -- of the API
95 -- 0 - Serial was successfully unmarked
96 -- 1 - The serial number given was not part of the
97 -- cycle count entry so nothing was removed or unmarked
98 -- -1 - Others type of error occurred
99 --
100 -- Functions: This API is used for multiple serial cycle counting.
101 -- This unmarks the serial number's group mark ID so that
102 -- it is not considered to be currently counted. It
103 -- removes the given serial number from consideration
104 -- for the multiple serial count entry
105 --
106 PROCEDURE remove_serial
107 (p_organization_id IN NUMBER ,
108 p_subinventory IN VARCHAR2 ,
109 p_locator_id IN NUMBER := NULL ,
110 p_inventory_item_id IN NUMBER ,
111 p_revision IN VARCHAR2 := NULL ,
112 p_lot_number IN VARCHAR2 := NULL ,
113 p_serial_number IN VARCHAR2 ,
114 p_parent_lpn_id IN NUMBER := NULL ,
115 p_cycle_count_header_id IN NUMBER ,
116 x_return_code OUT NOCOPY NUMBER);
117
118 PROCEDURE mark_all_present
119 (p_organization_id IN NUMBER ,
120 p_subinventory IN VARCHAR2 ,
121 p_locator_id IN NUMBER := NULL ,
122 p_inventory_item_id IN NUMBER ,
123 p_revision IN VARCHAR2 := NULL ,
124 p_lot_number IN VARCHAR2 := NULL ,
125 p_cycle_count_header_id IN NUMBER ,
126 p_parent_lpn_id IN NUMBER := NULL);
127
128 -- Bug 13481846
129 PROCEDURE mark_present_serials
130 (p_organization_id IN NUMBER ,
131 p_subinventory IN VARCHAR2 ,
132 p_locator_id IN NUMBER := NULL ,
133 p_inventory_item_id IN NUMBER ,
134 p_revision IN VARCHAR2 := NULL ,
135 p_lot_number IN VARCHAR2 := NULL ,
136 p_cycle_count_header_id IN NUMBER ,
137 p_parent_lpn_id IN NUMBER := NULL);
138 -- Name: GET_SERIAL_ENTRY_NUMBER
139 --
140 -- Input parameters:
141 -- p_organization_id Organization ID
142 -- p_subinventory Subinventory code
143 -- p_locator_id Locator ID
144 -- p_inventory_item_id Inventory Item ID
145 -- p_revision Revision
146 -- p_lot_number Lot Number
147 -- p_cycle_count_header_id Cycle Count Header ID
148 -- p_parent_lpn_id Parent LPN ID
149 --
150 -- Output parameters:
151 -- x_return_code This outputs the number of marked
152 -- serial numbers that have been entered
153 --
154 -- Functions: This API is used to get the number of marked
155 -- serial numbers that will be processed
156 --
157 PROCEDURE get_serial_entry_number
158 (p_organization_id IN NUMBER ,
159 p_subinventory IN VARCHAR2 ,
160 p_locator_id IN NUMBER := NULL ,
161 p_inventory_item_id IN NUMBER ,
162 p_revision IN VARCHAR2 := NULL ,
163 p_lot_number IN VARCHAR2 := NULL ,
164 p_cycle_count_header_id IN NUMBER ,
165 p_parent_lpn_id IN NUMBER := NULL ,
166 x_number OUT NOCOPY NUMBER);
167
168
169 -- Name: INSERT_SERIAL_NUMBER
170 -- Functions: This API is used to enter or update the serial numbers that are entered in
171 -- mtl_cc_serial_numbers.
172 --
173 PROCEDURE insert_serial_number
174 (p_serial_number IN VARCHAR2 ,
175 p_cycle_count_header_id IN NUMBER,
176 p_organization_id IN NUMBER ,
177 p_subinventory IN VARCHAR2 ,
178 p_locator_id IN NUMBER := NULL ,
179 p_inventory_item_id IN NUMBER ,
180 p_revision IN VARCHAR2 := NULL ,
181 p_lot_number IN VARCHAR2 := NULL ,
182 p_parent_lpn_id IN NUMBER := NULL
183 -- Adding for bug#9959346
184 , p_serial_attribute_category IN VARCHAR2 := NULL
185 , p_orgination_date IN DATE := NULL
186 , p_c_attribute1 IN VARCHAR2 := NULL
187 , p_c_attribute2 IN VARCHAR2 := NULL
188 , p_c_attribute3 IN VARCHAR2 := NULL
189 , p_c_attribute4 IN VARCHAR2 := NULL
190 , p_c_attribute5 IN VARCHAR2 := NULL
191 , p_c_attribute6 IN VARCHAR2 := NULL
192 , p_c_attribute7 IN VARCHAR2 := NULL
193 , p_c_attribute8 IN VARCHAR2 := NULL
194 , p_c_attribute9 IN VARCHAR2 := NULL
195 , p_c_attribute10 IN VARCHAR2 := NULL
196 , p_c_attribute11 IN VARCHAR2 := NULL
197 , p_c_attribute12 IN VARCHAR2 := NULL
198 , p_c_attribute13 IN VARCHAR2 := NULL
199 , p_c_attribute14 IN VARCHAR2 := NULL
200 , p_c_attribute15 IN VARCHAR2 := NULL
201 , p_c_attribute16 IN VARCHAR2 := NULL
202 , p_c_attribute17 IN VARCHAR2 := NULL
203 , p_c_attribute18 IN VARCHAR2 := NULL
204 , p_c_attribute19 IN VARCHAR2 := NULL
205 , p_c_attribute20 IN VARCHAR2 := NULL
206 , p_d_attribute1 IN DATE := NULL
207 , p_d_attribute2 IN DATE := NULL
208 , p_d_attribute3 IN DATE := NULL
209 , p_d_attribute4 IN DATE := NULL
210 , p_d_attribute5 IN DATE := NULL
211 , p_d_attribute6 IN DATE := NULL
212 , p_d_attribute7 IN DATE := NULL
213 , p_d_attribute8 IN DATE := NULL
214 , p_d_attribute9 IN DATE := NULL
215 , p_d_attribute10 IN DATE := NULL
216 , p_n_attribute1 IN NUMBER := NULL
217 , p_n_attribute2 IN NUMBER := NULL
218 , p_n_attribute3 IN NUMBER := NULL
219 , p_n_attribute4 IN NUMBER := NULL
220 , p_n_attribute5 IN NUMBER := NULL
221 , p_n_attribute6 IN NUMBER := NULL
222 , p_n_attribute7 IN NUMBER := NULL
223 , p_n_attribute8 IN NUMBER := NULL
224 , p_n_attribute9 IN NUMBER := NULL
225 , p_n_attribute10 IN NUMBER := NULL
226 , p_territory_code IN VARCHAR2 := NULL
227 , p_time_since_new IN NUMBER := NULL
228 , p_cycles_since_new IN NUMBER := NULL
229 , p_time_since_overhaul IN NUMBER := NULL
230 , p_cycles_since_overhaul IN NUMBER := NULL
231 , p_time_since_repair IN NUMBER := NULL
232 , p_cycles_since_repair IN NUMBER := NULL
233 , p_time_since_visit IN NUMBER := NULL
234 , p_cycles_since_visit IN NUMBER := NULL
235 , p_time_since_mark IN NUMBER := NULL
236 , p_cycles_since_mark IN NUMBER := NULL
237 , p_number_of_repairs IN NUMBER := NULL
238 , p_attribute_category IN VARCHAR2 := NULL
239 , p_attribute1 IN VARCHAR2 := NULL
240 , p_attribute2 IN VARCHAR2 := NULL
241 , p_attribute3 IN VARCHAR2 := NULL
242 , p_attribute4 IN VARCHAR2 := NULL
243 , p_attribute5 IN VARCHAR2 := NULL
244 , p_attribute6 IN VARCHAR2 := NULL
245 , p_attribute7 IN VARCHAR2 := NULL
246 , p_attribute8 IN VARCHAR2 := NULL
247 , p_attribute9 IN VARCHAR2 := NULL
248 , p_attribute10 IN VARCHAR2 := NULL
249 , p_attribute11 IN VARCHAR2 := NULL
250 , p_attribute12 IN VARCHAR2 := NULL
251 , p_attribute13 IN VARCHAR2 := NULL
252 , p_attribute14 IN VARCHAR2 := NULL
253 , p_attribute15 IN VARCHAR2 := NULL
254 );
255
256 /*Remove the serial numbers from mtl_cc_Serial_numbers and unmark the serials in mtl_serial_numbers
257 for serials that have been entered till now */
258 PROCEDURE remove_serial_number
259 (p_cycle_count_header_id IN NUMBER,
260 p_organization_id IN NUMBER ,
261 p_subinventory IN VARCHAR2 ,
262 p_locator_id IN NUMBER := NULL ,
263 p_inventory_item_id IN NUMBER ,
264 p_revision IN VARCHAR2 := NULL ,
265 p_lot_number IN VARCHAR2 := NULL ,
266 p_parent_lpn_id IN NUMBER := NULL
267 ) ;
268
269
270 END INV_CYC_SERIALS;