1 PACKAGE INV_CYC_SERIALS AS
2 /* $Header: INVCYCMS.pls 120.0 2005/05/25 06:28:28 appldev noship $ */
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
129 -- Name: GET_SERIAL_ENTRY_NUMBER
130 --
131 -- Input parameters:
132 -- p_organization_id Organization ID
133 -- p_subinventory Subinventory code
134 -- p_locator_id Locator ID
135 -- p_inventory_item_id Inventory Item ID
136 -- p_revision Revision
137 -- p_lot_number Lot Number
138 -- p_cycle_count_header_id Cycle Count Header ID
139 -- p_parent_lpn_id Parent LPN ID
140 --
141 -- Output parameters:
142 -- x_return_code This outputs the number of marked
143 -- serial numbers that have been entered
144 --
145 -- Functions: This API is used to get the number of marked
146 -- serial numbers that will be processed
147 --
148 PROCEDURE get_serial_entry_number
149 (p_organization_id IN NUMBER ,
150 p_subinventory IN VARCHAR2 ,
151 p_locator_id IN NUMBER := NULL ,
152 p_inventory_item_id IN NUMBER ,
153 p_revision IN VARCHAR2 := NULL ,
154 p_lot_number IN VARCHAR2 := NULL ,
155 p_cycle_count_header_id IN NUMBER ,
156 p_parent_lpn_id IN NUMBER := NULL ,
157 x_number OUT NOCOPY NUMBER);
158
159
160 -- Name: INSERT_SERIAL_NUMBER
161 -- Functions: This API is used to enter or update the serial numbers that are entered in
162 -- mtl_cc_serial_numbers.
163 --
164 PROCEDURE insert_serial_number
165 (p_serial_number IN VARCHAR2 ,
166 p_cycle_count_header_id IN NUMBER,
167 p_organization_id IN NUMBER ,
168 p_subinventory IN VARCHAR2 ,
169 p_locator_id IN NUMBER := NULL ,
170 p_inventory_item_id IN NUMBER ,
171 p_revision IN VARCHAR2 := NULL ,
172 p_lot_number IN VARCHAR2 := NULL ,
173 p_parent_lpn_id IN NUMBER := NULL
174 );
175
176 /*Remove the serial numbers from mtl_cc_Serial_numbers and unmark the serials in mtl_serial_numbers
177 for serials that have been entered till now */
178 PROCEDURE remove_serial_number
179 (p_cycle_count_header_id IN NUMBER,
180 p_organization_id IN NUMBER ,
181 p_subinventory IN VARCHAR2 ,
182 p_locator_id IN NUMBER := NULL ,
183 p_inventory_item_id IN NUMBER ,
184 p_revision IN VARCHAR2 := NULL ,
185 p_lot_number IN VARCHAR2 := NULL ,
186 p_parent_lpn_id IN NUMBER := NULL
187 ) ;
188
189
190 END INV_CYC_SERIALS;