1 PACKAGE MTL_CCEOI_PROCESS_PVT AS
2 /* $Header: INVVCCPS.pls 120.2 2005/06/22 09:52:32 appldev ship $ */
3 --
4 -- Calculates adjustments for Step 4
5 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data x_errorcode OUT
6 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
7 PROCEDURE Calculate_Adjustment(
8 p_api_version IN NUMBER ,
9 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12 x_return_status OUT NOCOPY VARCHAR2 ,
13 x_msg_count OUT NOCOPY NUMBER ,
14 x_msg_data OUT NOCOPY VARCHAR2 ,
15 x_errorcode OUT NOCOPY NUMBER ,
16 p_inventory_item_id IN NUMBER ,
17 p_organization_id IN NUMBER ,
18 p_lpn_id IN NUMBER DEFAULT NULL,
19 p_subinventory IN VARCHAR2 ,
20 p_count_quantity IN NUMBER ,
21 p_revision IN VARCHAR2 DEFAULT NULL,
22 p_locator_id IN NUMBER DEFAULT NULL,
23 p_lot_number IN VARCHAR2 DEFAULT NULL,
24 p_serial_number IN VARCHAR2 DEFAULT NULL,
25 p_serial_number_control_code IN NUMBER ,
26 p_serial_count_option IN NUMBER ,
27 p_system_quantity IN NUMBER DEFAULT NULL,
28 p_secondary_system_quantity IN NUMBER DEFAULT NULL) -- INVCONV
29 ;
30 --
31 -- Deletes entries in the interface tables
32 PROCEDURE Delete_CCIEntry(
33 p_cc_entry_interface_id IN NUMBER )
34 ;
35 --
36 -- Delete records from the cycle count interface error table
37 PROCEDURE Delete_CCEOIError(
38 p_cc_entry_interface_id IN NUMBER )
39 ;
40 --
41 -- Insert the record into the application tables
42 PROCEDURE Insert_CCEntry(
43 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
44 ;
45 --
46 -- Insert the given record into MTL_CC_ENTRIES_INTERFACE
47 --Added NOCOPY hint to x_return_status OUT
48 --parameter to comply with GSCC File.Sql.39 standard. Bug:4410902
49 PROCEDURE Insert_CCIEntry(
50 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
51 x_return_status OUT NOCOPY VARCHAR2 )
52 ;
53 --
54 -- Insert record into Cycle Count Interface error table
55 PROCEDURE Insert_CCEOIError(
56 p_cc_entry_interface_id IN NUMBER ,
57 p_error_column_name IN VARCHAR2 ,
58 p_error_table_name IN VARCHAR2 ,
59 p_message_name IN VARCHAR2 )
60 ;
61 --
62 -- Set the export flag in the table MTL_CYCLE_COUNT_ENTRIES
63 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
64 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
65 PROCEDURE Set_CCExport(
66 p_api_version IN NUMBER ,
67 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
69 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
70 x_return_status OUT NOCOPY VARCHAR2 ,
71 x_msg_count OUT NOCOPY NUMBER ,
72 x_msg_data OUT NOCOPY VARCHAR2 ,
73 p_cycle_count_entry_id IN NUMBER ,
74 p_export_flag IN NUMBER )
75 ;
76 --
77 -- Set the Flags in the interface table.
78 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
79 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
80 PROCEDURE Set_CCEOIFlags(
81 p_api_version IN NUMBER ,
82 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
84 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
85 x_return_status OUT NOCOPY VARCHAR2 ,
86 x_msg_count OUT NOCOPY NUMBER ,
87 x_msg_data OUT NOCOPY VARCHAR2 ,
88 p_cc_entry_interface_id IN NUMBER ,
89 p_flags IN VARCHAR2 )
90 ;
91 --
92 -- Validates the cycle count header
93 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
94 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
95 PROCEDURE Validate_CHeader(
96 p_api_version IN NUMBER ,
97 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
100 x_return_status OUT NOCOPY VARCHAR2 ,
101 x_msg_count OUT NOCOPY NUMBER ,
102 x_msg_data OUT NOCOPY VARCHAR2 ,
103 x_errorcode OUT NOCOPY NUMBER ,
104 p_cycle_count_header_id IN NUMBER ,
105 p_cycle_count_header_name IN VARCHAR2 DEFAULT NULL)
106 ;
107 --
108 -- Validate the count list sequence of the cycle count entry
109 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
110 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
111 PROCEDURE Validate_CountListSeq(
112 p_api_version IN NUMBER ,
113 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
116 x_return_status OUT NOCOPY VARCHAR2 ,
117 x_msg_count OUT NOCOPY NUMBER ,
118 x_msg_data OUT NOCOPY VARCHAR2 ,
119 x_errorcode OUT NOCOPY NUMBER ,
120 p_cycle_count_header_id IN NUMBER ,
121 p_cycle_count_entry_id IN NUMBER ,
122 p_count_list_sequence IN NUMBER ,
123 p_organization_id IN NUMBER )
124 ;
125 --
126 -- validate item and sku information
127 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
128 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
129 PROCEDURE Validate_ItemSKU(
130 p_api_version IN NUMBER ,
131 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
134 x_return_status OUT NOCOPY VARCHAR2 ,
135 x_msg_count OUT NOCOPY NUMBER ,
136 x_msg_data OUT NOCOPY VARCHAR2 ,
137 x_errorcode OUT NOCOPY NUMBER ,
138 p_cycle_count_header_id IN NUMBER ,
139 p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.Inv_Item_rec_type ,
140 p_sku_rec IN MTL_CCEOI_VAR_PVT.Inv_SKU_Rec_Type ,
141 p_subinventory IN VARCHAR2 ,
142 p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
143 p_organization_id IN number,
144 p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
145 ;
146 --
147 -- Validate the UOM and quantity information
148 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
149 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
150 PROCEDURE Validate_UOMQuantity(
151 p_api_version IN NUMBER ,
152 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
153 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
154 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
155 x_return_status OUT NOCOPY VARCHAR2 ,
156 x_msg_count OUT NOCOPY NUMBER ,
157 x_msg_data OUT NOCOPY VARCHAR2 ,
158 x_errorcode OUT NOCOPY NUMBER ,
159 p_primary_uom_quantity IN NUMBER DEFAULT NULL,
160 p_count_uom IN VARCHAR2 DEFAULT NULL,
161 p_count_unit_of_measure IN VARCHAR2 DEFAULT NULL,
162 p_organization_id IN NUMBER ,
163 p_lpn_id IN NUMBER DEFAULT NULL,
164 p_inventory_item_id IN NUMBER ,
165 p_count_quantity IN NUMBER ,
166 p_serial_number IN VARCHAR2 DEFAULT NULL,
167 p_subinventory IN VARCHAR2,
168 p_revision IN VARCHAR2 DEFAULT NULL,
169 p_lot_number IN VARCHAR2 ,
170 p_system_quantity IN NUMBER,
171 p_secondary_system_quantity IN NUMBER) -- INVCONV
172 ;
173 --
174 -- Validate count date and counter
175 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
176 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
177 PROCEDURE Validate_CDate_Counter(
178 p_api_version IN NUMBER ,
179 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
182 x_return_status OUT NOCOPY VARCHAR2 ,
183 x_msg_count OUT NOCOPY NUMBER ,
184 x_msg_data OUT NOCOPY VARCHAR2 ,
185 x_errorcode OUT NOCOPY NUMBER ,
186 p_employee_id IN NUMBER ,
187 p_employee_name IN VARCHAR2 DEFAULT NULL,
188 p_count_date IN DATE )
189 ;
190 --
191 -- Processed the interface record
192 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
193 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
194 PROCEDURE Process_Data(
195 p_api_version IN NUMBER ,
196 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
197 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
199 x_return_status OUT NOCOPY VARCHAR2 ,
200 x_msg_count OUT NOCOPY NUMBER ,
201 x_msg_data OUT NOCOPY VARCHAR2 ,
202 x_errorcode OUT NOCOPY NUMBER ,
203 p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
205 ;
206 --
207 -- updates CC entry record information
208 PROCEDURE Update_CCEntry(
209 p_cycle_count_entry_id IN NUMBER );
210
211 -- updates interface record information
212 --Added NOCOPY hint to x_return_status OUT
213 --parameter to comply with GSCC File.Sql.39 standard. Bug:4410902
214 PROCEDURE Update_CCIEntry(
215 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
216 x_return_status OUT NOCOPY VARCHAR2 );
217 --
218 FUNCTION check_serial_location(P_issue_receipt IN VARCHAR2,
219 p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE ) return BOOLEAN;
220
221 -- resets all global variables to null to prevent their accidental reuse
222 -- on next call of the public api in the same session
223 PROCEDURE Reset_Global_Vars;
224
225 PROCEDURE DELETE_RESERVATION (
226 p_subinventory IN VARCHAR2 ,
227 p_lot_number IN VARCHAR2 ,
228 p_revision IN VARCHAR2 );
229
230 -- BEGIN INVCONV
231 PROCEDURE validate_secondaryuomqty (
232 p_api_version IN NUMBER
233 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
234 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
235 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
236 , x_return_status OUT NOCOPY VARCHAR2
237 , x_msg_count OUT NOCOPY NUMBER
238 , x_msg_data OUT NOCOPY VARCHAR2
239 , x_errorcode OUT NOCOPY NUMBER
240 , p_organization_id IN NUMBER
241 , p_inventory_item_id IN NUMBER
242 , p_lpn_id IN NUMBER DEFAULT NULL
243 , p_serial_number IN VARCHAR2 DEFAULT NULL
244 , p_subinventory IN VARCHAR2
245 , p_revision IN VARCHAR2 DEFAULT NULL
246 , p_lot_number IN VARCHAR2
247 , p_secondary_uom IN VARCHAR2
248 , p_secondary_unit_of_measure IN VARCHAR2
249 , p_secondary_count_quantity IN NUMBER
250 , p_secondary_system_quantity IN NUMBER
251 , p_tracking_quantity_ind IN VARCHAR2
252 , p_secondary_default_ind IN VARCHAR2);
253 -- END INVCONV
254
255 END MTL_CCEOI_PROCESS_PVT;