1 PACKAGE INVCIINT as
2 /* $Header: INVICOIS.pls 120.1 2005/06/21 03:10:31 appldev ship $ */
3
4 PRAGMA RESTRICT_REFERENCES ( INVCIINT, WNDS, WNPS, RNDS, RNPS );
5
6 Error EXCEPTION;
7 Current_Error_Code Varchar2(9) := NULL;
8 Curr_Error Varchar2(9) := NULL;
9
10 PROCEDURE Load_Cust_Item(ERRBUF OUT NOCOPY VARCHAR2,
11 RETCODE OUT NOCOPY VARCHAR2,
12 ARGUMENT1 IN VARCHAR2,
13 ARGUMENT2 IN VARCHAR2);
14
15
16 FUNCTION Load_Cust_Items_Iface(
17 Abort_On_Error IN Varchar2 DEFAULT 'No',
18 Delete_Record IN Varchar2 DEFAULT 'Yes')
19 RETURN Number;
20
21
22 PROCEDURE Validate_Customer_Item(
23 Row_Id IN OUT NOCOPY Varchar2,
24 Process_Mode IN OUT NOCOPY Number,
25 Customer_Name IN OUT NOCOPY Varchar2,
26 Customer_Number IN OUT NOCOPY Varchar2,
27 Customer_Id IN OUT NOCOPY Number,
28 Customer_Category_Code IN OUT NOCOPY Varchar2,
29 Customer_Category IN OUT NOCOPY Varchar2,
30 Address1 IN OUT NOCOPY Varchar2,
31 Address2 IN OUT NOCOPY Varchar2,
32 Address3 IN OUT NOCOPY Varchar2,
33 Address4 IN OUT NOCOPY Varchar2,
34 City IN OUT NOCOPY Varchar2,
35 State IN OUT NOCOPY Varchar2,
36 County IN OUT NOCOPY Varchar2,
37 Country IN OUT NOCOPY Varchar2,
38 Postal_Code IN OUT NOCOPY Varchar2,
39 Address_Id IN OUT NOCOPY Number,
40 Customer_Item_Number IN OUT NOCOPY Varchar2,
41 Item_Definition_Level_Desc IN OUT NOCOPY Varchar2,
42 Item_Definition_Level IN OUT NOCOPY Number,
43 Customer_Item_Desc IN OUT NOCOPY Varchar2,
44 Model_Customer_Item_Number IN OUT NOCOPY Varchar2,
45 Model_Customer_Item_Id IN OUT NOCOPY Number,
46 Commodity_Code IN OUT NOCOPY Varchar2,
47 Commodity_Code_Id IN OUT NOCOPY Number,
48 Master_Container_Segment1 IN OUT NOCOPY Varchar2,
49 Master_Container_Segment2 IN OUT NOCOPY Varchar2,
50 Master_Container_Segment3 IN OUT NOCOPY Varchar2,
51 Master_Container_Segment4 IN OUT NOCOPY Varchar2,
52 Master_Container_Segment5 IN OUT NOCOPY Varchar2,
53 Master_Container_Segment6 IN OUT NOCOPY Varchar2,
54 Master_Container_Segment7 IN OUT NOCOPY Varchar2,
55 Master_Container_Segment8 IN OUT NOCOPY Varchar2,
56 Master_Container_Segment9 IN OUT NOCOPY Varchar2,
57 Master_Container_Segment10 IN OUT NOCOPY Varchar2,
58 Master_Container_Segment11 IN OUT NOCOPY Varchar2,
59 Master_Container_Segment12 IN OUT NOCOPY Varchar2,
60 Master_Container_Segment13 IN OUT NOCOPY Varchar2,
61 Master_Container_Segment14 IN OUT NOCOPY Varchar2,
62 Master_Container_Segment15 IN OUT NOCOPY Varchar2,
63 Master_Container_Segment16 IN OUT NOCOPY Varchar2,
64 Master_Container_Segment17 IN OUT NOCOPY Varchar2,
65 Master_Container_Segment18 IN OUT NOCOPY Varchar2,
66 Master_Container_Segment19 IN OUT NOCOPY Varchar2,
67 Master_Container_Segment20 IN OUT NOCOPY Varchar2,
68 Master_Container IN OUT NOCOPY Varchar2,
69 Master_Container_Item_Id IN OUT NOCOPY Number,
70 Container_Item_Org_Name IN OUT NOCOPY Varchar2,
71 Container_Item_Org_Code IN OUT NOCOPY Varchar2,
72 Container_Item_Org_Id IN OUT NOCOPY Number,
73 Detail_Container_Segment1 IN OUT NOCOPY Varchar2,
74 Detail_Container_Segment2 IN OUT NOCOPY Varchar2,
75 Detail_Container_Segment3 IN OUT NOCOPY Varchar2,
76 Detail_Container_Segment4 IN OUT NOCOPY Varchar2,
77 Detail_Container_Segment5 IN OUT NOCOPY Varchar2,
78 Detail_Container_Segment6 IN OUT NOCOPY Varchar2,
79 Detail_Container_Segment7 IN OUT NOCOPY Varchar2,
80 Detail_Container_Segment8 IN OUT NOCOPY Varchar2,
81 Detail_Container_Segment9 IN OUT NOCOPY Varchar2,
82 Detail_Container_Segment10 IN OUT NOCOPY Varchar2,
83 Detail_Container_Segment11 IN OUT NOCOPY Varchar2,
84 Detail_Container_Segment12 IN OUT NOCOPY Varchar2,
85 Detail_Container_Segment13 IN OUT NOCOPY Varchar2,
86 Detail_Container_Segment14 IN OUT NOCOPY Varchar2,
87 Detail_Container_Segment15 IN OUT NOCOPY Varchar2,
88 Detail_Container_Segment16 IN OUT NOCOPY Varchar2,
89 Detail_Container_Segment17 IN OUT NOCOPY Varchar2,
90 Detail_Container_Segment18 IN OUT NOCOPY Varchar2,
91 Detail_Container_Segment19 IN OUT NOCOPY Varchar2,
92 Detail_Container_Segment20 IN OUT NOCOPY Varchar2,
93 Detail_Container IN OUT NOCOPY Varchar2,
94 Detail_Container_Item_Id IN OUT NOCOPY Number,
95 Min_Fill_Percentage IN OUT NOCOPY Number,
96 Dep_Plan_Required_Flag IN OUT NOCOPY Varchar2,
97 Dep_Plan_Prior_Bld_Flag IN OUT NOCOPY Varchar2,
98 Inactive_Flag IN OUT NOCOPY Varchar2,
99 Attribute_Category IN OUT NOCOPY Varchar2,
100 Attribute1 IN OUT NOCOPY Varchar2,
101 Attribute2 IN OUT NOCOPY Varchar2,
102 Attribute3 IN OUT NOCOPY Varchar2,
103 Attribute4 IN OUT NOCOPY Varchar2,
104 Attribute5 IN OUT NOCOPY Varchar2,
105 Attribute6 IN OUT NOCOPY Varchar2,
106 Attribute7 IN OUT NOCOPY Varchar2,
107 Attribute8 IN OUT NOCOPY Varchar2,
108 Attribute9 IN OUT NOCOPY Varchar2,
109 Attribute10 IN OUT NOCOPY Varchar2,
110 Attribute11 IN OUT NOCOPY Varchar2,
111 Attribute12 IN OUT NOCOPY Varchar2,
112 Attribute13 IN OUT NOCOPY Varchar2,
113 Attribute14 IN OUT NOCOPY Varchar2,
114 Attribute15 IN OUT NOCOPY Varchar2,
115 Demand_Tolerance_Positive IN OUT NOCOPY Number,
116 Demand_Tolerance_Negative IN OUT NOCOPY Number,
117 Last_Update_Date IN OUT NOCOPY Date,
118 Last_Updated_By IN OUT NOCOPY Number,
119 Creation_Date IN OUT NOCOPY Date,
120 Created_By IN OUT NOCOPY Number,
121 Last_Update_Login IN OUT NOCOPY Number,
122 Request_Id IN Number,
123 Program_Application_Id IN Number,
124 Program_Id IN Number,
125 Program_Update_Date IN Date,
126 Delete_Record IN Varchar2 DEFAULT NULL
127 );
128
129 PROCEDURE Validate_Customer(
130 P_Customer_Id IN OUT NOCOPY Number,
131 P_Customer_Number IN Varchar2 DEFAULT NULL,
132 P_Customer_Name IN Varchar2 DEFAULT NULL
133 );
134
135 PROCEDURE Validate_Address(
136 P_Address_Id IN OUT NOCOPY Number,
137 P_Customer_Id IN Number DEFAULT NULL,
138 P_Address1 IN Varchar2 DEFAULT NULL,
139 P_Address2 IN Varchar2 DEFAULT NULL,
140 P_Address3 IN Varchar2 DEFAULT NULL,
141 P_Address4 IN Varchar2 DEFAULT NULL,
142 P_City IN Varchar2 DEFAULT NULL,
143 P_State IN Varchar2 DEFAULT NULL,
144 P_County IN Varchar2 DEFAULT NULL,
145 P_Country IN Varchar2 DEFAULT NULL,
146 P_Postal_Code IN Varchar2 DEFAULT NULL
147 );
148
149 PROCEDURE Validate_Address_Category(
150 P_Customer_Category_Code IN OUT NOCOPY Varchar2,
151 P_Customer_Category IN Varchar2 DEFAULT NULL
152 );
153
154 PROCEDURE Validate_CI_Def_Level(
155 P_Item_Definition_Level IN OUT NOCOPY Varchar2,
156 P_Item_Definition_Level_Desc IN Varchar2 DEFAULT NULL,
157 P_Customer_Id IN OUT NOCOPY Number,
158 P_Customer_Number IN OUT NOCOPY Varchar2,
159 P_Customer_Name IN OUT NOCOPY Varchar2,
160 P_Customer_Category_Code IN OUT NOCOPY Varchar2,
161 P_Customer_Category IN OUT NOCOPY Varchar2,
162 P_Address_Id IN OUT NOCOPY Number,
163 P_Address1 IN OUT NOCOPY Varchar2,
164 P_Address2 IN OUT NOCOPY Varchar2,
165 P_Address3 IN OUT NOCOPY Varchar2,
166 P_Address4 IN OUT NOCOPY Varchar2,
167 P_City IN OUT NOCOPY Varchar2,
168 P_State IN OUT NOCOPY Varchar2,
169 P_County IN OUT NOCOPY Varchar2,
170 P_Country IN OUT NOCOPY Varchar2,
171 P_Postal_Code IN OUT NOCOPY Varchar2
172 );
173
174 PROCEDURE Validate_Containers(
175 P_Container_Item_Id IN OUT NOCOPY Number,
176 P_Container_Item IN Varchar2 DEFAULT NULL,
177 P_Container_Item_Segment1 IN Varchar2 DEFAULT NULL,
178 P_Container_Item_Segment2 IN Varchar2 DEFAULT NULL,
179 P_Container_Item_Segment3 IN Varchar2 DEFAULT NULL,
180 P_Container_Item_Segment4 IN Varchar2 DEFAULT NULL,
181 P_Container_Item_Segment5 IN Varchar2 DEFAULT NULL,
182 P_Container_Item_Segment6 IN Varchar2 DEFAULT NULL,
183 P_Container_Item_Segment7 IN Varchar2 DEFAULT NULL,
184 P_Container_Item_Segment8 IN Varchar2 DEFAULT NULL,
185 P_Container_Item_Segment9 IN Varchar2 DEFAULT NULL,
186 P_Container_Item_Segment10 IN Varchar2 DEFAULT NULL,
187 P_Container_Item_Segment11 IN Varchar2 DEFAULT NULL,
188 P_Container_Item_Segment12 IN Varchar2 DEFAULT NULL,
189 P_Container_Item_Segment13 IN Varchar2 DEFAULT NULL,
190 P_Container_Item_Segment14 IN Varchar2 DEFAULT NULL,
191 P_Container_Item_Segment15 IN Varchar2 DEFAULT NULL,
192 P_Container_Item_Segment16 IN Varchar2 DEFAULT NULL,
193 P_Container_Item_Segment17 IN Varchar2 DEFAULT NULL,
194 P_Container_Item_Segment18 IN Varchar2 DEFAULT NULL,
195 P_Container_Item_Segment19 IN Varchar2 DEFAULT NULL,
196 P_Container_Item_Segment20 IN Varchar2 DEFAULT NULL,
197 P_Container_Organization_Id IN Number DEFAULT NULL
198 );
199
200 PROCEDURE Validate_Commodity_Code(
201 P_Commodity_Code_Id IN OUT NOCOPY Number,
202 P_Commodity_Code IN Varchar2 DEFAULT NULL
203 );
204
205 PROCEDURE Validate_Model(
206 P_Model_Customer_Item_Id IN OUT NOCOPY Number,
207 P_Model_Customer_Item IN Varchar2 DEFAULT NULL,
208 P_Customer_Id IN Number DEFAULT NULL,
209 P_Address_Id IN Number DEFAULT NULL,
210 P_Customer_Category_Code IN Varchar2 DEFAULT NULL,
211 P_Item_Definition_Level IN Varchar2 DEFAULT NULL,
212 P_Customer_Item_Number IN Varchar2 DEFAULT NULL
213 );
214
215 PROCEDURE Validate_Demand_Tolerance(
216 P_Demand_Tolerance IN Number DEFAULT NULL
217 );
218
219
220 PROCEDURE Validate_Fill_Percentage(
221 P_Min_Fill_Percentage IN Number DEFAULT NULL
222 );
223
224
225 PROCEDURE Validate_Departure_Plan_Flags(
226 P_Dep_Plan_Required_Flag IN OUT NOCOPY Varchar2,
227 P_Dep_Plan_Prior_Bld_Flag IN OUT NOCOPY Varchar2
228 );
229
230
231 /*===========================================================================+
232 +===========================================================================*/
233 /* These procedures are specific to the Customer Item XRefs Open Interface. */
234 /*===========================================================================+
235 +===========================================================================*/
236
237 PROCEDURE Load_Cust_Item_Xrefs(ERRBUF OUT NOCOPY VARCHAR2,
238 RETCODE OUT NOCOPY VARCHAR2,
239 ARGUMENT1 IN VARCHAR2,
240 ARGUMENT2 IN VARCHAR2);
241
242
243 FUNCTION Load_Cust_Item_XRefs_Iface(
244 Abort_On_Error IN Varchar2 DEFAULT 'No',
245 Delete_Record IN Varchar2 DEFAULT 'Yes'
246 ) RETURN NUMBER;
247
248
249 PROCEDURE Validate_CI_XRefs(
250 Row_Id IN OUT NOCOPY Varchar2,
251 Process_Mode IN OUT NOCOPY Varchar2,
252 Customer_Name IN OUT NOCOPY Varchar2,
253 Customer_Number IN OUT NOCOPY Varchar2,
254 Customer_Id IN OUT NOCOPY Number,
255 Customer_Category_Code IN OUT NOCOPY Varchar2,
256 Customer_Category IN OUT NOCOPY Varchar2,
257 Address1 IN OUT NOCOPY Varchar2,
258 Address2 IN OUT NOCOPY Varchar2,
259 Address3 IN OUT NOCOPY Varchar2,
260 Address4 IN OUT NOCOPY Varchar2,
261 City IN OUT NOCOPY Varchar2,
262 State IN OUT NOCOPY Varchar2,
263 County IN OUT NOCOPY Varchar2,
264 Country IN OUT NOCOPY Varchar2,
265 Postal_Code IN OUT NOCOPY Varchar2,
266 Address_Id IN OUT NOCOPY Number,
267 Customer_Item_Number IN OUT NOCOPY Varchar2,
268 Item_Definition_Level_Desc IN OUT NOCOPY Varchar2,
269 Item_Definition_Level IN OUT NOCOPY Varchar2,
270 Customer_Item_Id IN OUT NOCOPY Number,
271 Master_Organization_Name IN OUT NOCOPY Varchar2,
272 Master_Organization_Code IN OUT NOCOPY Varchar2,
273 Master_Organization_Id IN OUT NOCOPY Number,
274 Inventory_Item_Segment1 IN OUT NOCOPY Varchar2,
275 Inventory_Item_Segment2 IN OUT NOCOPY Varchar2,
276 Inventory_Item_Segment3 IN OUT NOCOPY Varchar2,
277 Inventory_Item_Segment4 IN OUT NOCOPY Varchar2,
278 Inventory_Item_Segment5 IN OUT NOCOPY Varchar2,
279 Inventory_Item_Segment6 IN OUT NOCOPY Varchar2,
280 Inventory_Item_Segment7 IN OUT NOCOPY Varchar2,
281 Inventory_Item_Segment8 IN OUT NOCOPY Varchar2,
282 Inventory_Item_Segment9 IN OUT NOCOPY Varchar2,
283 Inventory_Item_Segment10 IN OUT NOCOPY Varchar2,
284 Inventory_Item_Segment11 IN OUT NOCOPY Varchar2,
285 Inventory_Item_Segment12 IN OUT NOCOPY Varchar2,
286 Inventory_Item_Segment13 IN OUT NOCOPY Varchar2,
287 Inventory_Item_Segment14 IN OUT NOCOPY Varchar2,
288 Inventory_Item_Segment15 IN OUT NOCOPY Varchar2,
289 Inventory_Item_Segment16 IN OUT NOCOPY Varchar2,
290 Inventory_Item_Segment17 IN OUT NOCOPY Varchar2,
291 Inventory_Item_Segment18 IN OUT NOCOPY Varchar2,
292 Inventory_Item_Segment19 IN OUT NOCOPY Varchar2,
293 Inventory_Item_Segment20 IN OUT NOCOPY Varchar2,
294 Inventory_Item IN OUT NOCOPY Varchar2,
295 Inventory_Item_Id IN OUT NOCOPY Number,
296 Preference_Number IN OUT NOCOPY Number,
297 Inactive_Flag IN OUT NOCOPY Varchar2,
298 Attribute_Category IN OUT NOCOPY Varchar2,
299 Attribute1 IN OUT NOCOPY Varchar2,
300 Attribute2 IN OUT NOCOPY Varchar2,
301 Attribute3 IN OUT NOCOPY Varchar2,
302 Attribute4 IN OUT NOCOPY Varchar2,
303 Attribute5 IN OUT NOCOPY Varchar2,
304 Attribute6 IN OUT NOCOPY Varchar2,
305 Attribute7 IN OUT NOCOPY Varchar2,
306 Attribute8 IN OUT NOCOPY Varchar2,
307 Attribute9 IN OUT NOCOPY Varchar2,
308 Attribute10 IN OUT NOCOPY Varchar2,
309 Attribute11 IN OUT NOCOPY Varchar2,
310 Attribute12 IN OUT NOCOPY Varchar2,
311 Attribute13 IN OUT NOCOPY Varchar2,
312 Attribute14 IN OUT NOCOPY Varchar2,
313 Attribute15 IN OUT NOCOPY Varchar2,
314 Last_Update_Date IN OUT NOCOPY Date,
315 Last_Updated_By IN OUT NOCOPY Number,
316 Creation_Date IN OUT NOCOPY Date,
317 Created_By IN OUT NOCOPY Number,
318 Last_Update_Login IN OUT NOCOPY Number,
319 Request_Id IN Number,
320 Program_Application_Id IN Number,
321 Program_Id IN Number,
322 Program_Update_Date IN Date,
323 Delete_Record IN Varchar2 DEFAULT NULL
324 );
325
326
327 PROCEDURE Validate_Cust_Item(
328 P_Customer_Item_Id IN OUT NOCOPY Number,
329 P_Customer_Item_Number IN Varchar2 DEFAULT NULL,
330 P_Item_Definition_Level IN Varchar2 DEFAULT NULL,
331 P_Item_Definition_Level_Desc IN Varchar2 DEFAULT NULL,
332 P_Customer_Id IN Number DEFAULT NULL,
333 P_Customer_Number IN Varchar2 DEFAULT NULL,
334 P_Customer_Name IN Varchar2 DEFAULT NULL,
335 P_Customer_Category_Code IN Varchar2 DEFAULT NULL,
336 P_Customer_Category IN Varchar2 DEFAULT NULL,
337 P_Address_Id IN Number DEFAULT NULL,
338 P_Address1 IN Varchar2 DEFAULT NULL,
339 P_Address2 IN Varchar2 DEFAULT NULL,
340 P_Address3 IN Varchar2 DEFAULT NULL,
341 P_Address4 IN Varchar2 DEFAULT NULL,
342 P_City IN Varchar2 DEFAULT NULL,
343 P_State IN Varchar2 DEFAULT NULL,
344 P_County IN Varchar2 DEFAULT NULL,
345 P_Country IN Varchar2 DEFAULT NULL,
346 P_Postal_Code IN Varchar2 DEFAULT NULL
347 );
348
349 PROCEDURE Validate_Master_Organization(
350 P_Master_Organization_Id IN OUT NOCOPY Number,
354 );
351 P_Master_Organization_Code IN Varchar2 DEFAULT NULL,
352 P_Master_Organization_Name IN Varchar2 DEFAULT NULL
353
355
356 PROCEDURE Validate_Inventory_Item(
357 P_Inventory_Item_Id IN OUT NOCOPY Number,
358 P_Inventory_Item IN Varchar2 DEFAULT NULL,
359 P_Inventory_Item_Segment1 IN Varchar2 DEFAULT NULL,
360 P_Inventory_Item_Segment2 IN Varchar2 DEFAULT NULL,
361 P_Inventory_Item_Segment3 IN Varchar2 DEFAULT NULL,
362 P_Inventory_Item_Segment4 IN Varchar2 DEFAULT NULL,
363 P_Inventory_Item_Segment5 IN Varchar2 DEFAULT NULL,
364 P_Inventory_Item_Segment6 IN Varchar2 DEFAULT NULL,
365 P_Inventory_Item_Segment7 IN Varchar2 DEFAULT NULL,
366 P_Inventory_Item_Segment8 IN Varchar2 DEFAULT NULL,
367 P_Inventory_Item_Segment9 IN Varchar2 DEFAULT NULL,
368 P_Inventory_Item_Segment10 IN Varchar2 DEFAULT NULL,
369 P_Inventory_Item_Segment11 IN Varchar2 DEFAULT NULL,
370 P_Inventory_Item_Segment12 IN Varchar2 DEFAULT NULL,
371 P_Inventory_Item_Segment13 IN Varchar2 DEFAULT NULL,
372 P_Inventory_Item_Segment14 IN Varchar2 DEFAULT NULL,
373 P_Inventory_Item_Segment15 IN Varchar2 DEFAULT NULL,
374 P_Inventory_Item_Segment16 IN Varchar2 DEFAULT NULL,
375 P_Inventory_Item_Segment17 IN Varchar2 DEFAULT NULL,
376 P_Inventory_Item_Segment18 IN Varchar2 DEFAULT NULL,
377 P_Inventory_Item_Segment19 IN Varchar2 DEFAULT NULL,
378 P_Inventory_Item_Segment20 IN Varchar2 DEFAULT NULL,
379 P_Master_Organization_Id IN Number DEFAULT NULL
380 );
381
382
383 /*===========================================================================+
384 +===========================================================================*/
385 /* These procedures will be shared by both Customer Item Open Interfaces. */
386 /*===========================================================================+
387 +===========================================================================*/
388
389 PROCEDURE Validate_Inactive_Flag(
390 P_Inactive_Flag IN OUT NOCOPY Varchar2
391 );
392
393
394 PROCEDURE Validate_Concurrent_Program(
395 P_Request_Id IN Number DEFAULT NULL,
396 P_Program_Application_Id IN Number DEFAULT NULL,
397 P_Program_Id IN Number DEFAULT NULL,
398 P_Program_Update_Date IN Date DEFAULT NULL
399 );
400
401
402 PROCEDURE Check_Uniqueness(
403 P_Origin IN Varchar2 DEFAULT NULL,
404 P_Customer_Id IN Number DEFAULT NULL,
405 P_Customer_Item_Number IN Varchar2 DEFAULT NULL,
406 P_Item_Definition_Level IN Varchar2 DEFAULT NULL,
407 P_Customer_Category_Code IN Varchar2 DEFAULT NULL,
408 P_Address_Id IN Number DEFAULT NULL,
409 P_Customer_Item_Id IN Number DEFAULT NULL,
410 P_Inventory_Item_Id IN Number DEFAULT NULL,
411 P_Master_Organization_Id IN Number DEFAULT NULL,
412 P_Preference_Number IN Number DEFAULT NULL
413 );
414
415
416 PROCEDURE Check_Required_Columns(
417 P_Origin IN Varchar2 DEFAULT NULL,
418 P_Customer_Id IN Number DEFAULT NULL,
419 P_Customer_Item_Number IN Varchar2 DEFAULT NULL,
420 P_Item_Definition_Level IN Varchar2 DEFAULT NULL,
421 P_Customer_Category_Code IN Varchar2 DEFAULT NULL,
422 P_Address_Id IN Number DEFAULT NULL,
423 P_Inactive_Flag IN Varchar2 DEFAULT NULL,
424 P_Last_Updated_By IN Number DEFAULT NULL,
425 P_Last_Update_Date IN Date DEFAULT NULL,
426 P_Created_By IN Number DEFAULT NULL,
427 P_Creation_Date IN Date DEFAULT NULL,
428 P_Customer_Item_Id IN Number DEFAULT NULL,
429 P_Inventory_Item_Id IN Number DEFAULT NULL,
430 P_Master_Organization_Id IN Number DEFAULT NULL,
431 P_Preference_Number IN Number DEFAULT NULL
432 );
433
434
435 PROCEDURE Insert_Row(
436 P_Origin IN Varchar2 DEFAULT NULL,
437 P_Last_Update_Date IN Date DEFAULT NULL,
438 P_Last_Updated_By IN Number DEFAULT NULL,
439 P_Creation_Date IN Date DEFAULT NULL,
440 P_Created_By IN Number DEFAULT NULL,
441 P_Last_Update_Login IN Number DEFAULT NULL,
442 P_Customer_Id IN Number DEFAULT NULL,
443 P_Customer_Category_Code IN Varchar2 DEFAULT NULL,
444 P_Address_Id IN Number DEFAULT NULL,
445 P_Customer_Item_Number IN Varchar2 DEFAULT NULL,
446 P_Item_Definition_Level IN Varchar2 DEFAULT NULL,
447 P_Customer_Item_Desc IN Varchar2 DEFAULT NULL,
448 P_Model_Customer_Item_Id IN Number DEFAULT NULL,
449 P_Commodity_Code_Id IN Number DEFAULT NULL,
450 P_Master_Container_Item_Id IN Number DEFAULT NULL,
451 P_Container_Item_Org_Id IN Number DEFAULT NULL,
452 P_Detail_Container_Item_Id IN Number DEFAULT NULL,
453 P_Min_Fill_Percentage IN Number DEFAULT NULL,
454 P_Dep_Plan_Required_Flag IN Varchar2 DEFAULT NULL,
455 P_Dep_Plan_Prior_Bld_Flag IN Varchar2 DEFAULT NULL,
456 P_Inactive_Flag IN Varchar2 DEFAULT NULL,
457 P_Attribute_Category IN Varchar2 DEFAULT NULL,
458 P_Attribute1 IN Varchar2 DEFAULT NULL,
459 P_Attribute2 IN Varchar2 DEFAULT NULL,
460 P_Attribute3 IN Varchar2 DEFAULT NULL,
461 P_Attribute4 IN Varchar2 DEFAULT NULL,
462 P_Attribute5 IN Varchar2 DEFAULT NULL,
463 P_Attribute6 IN Varchar2 DEFAULT NULL,
464 P_Attribute7 IN Varchar2 DEFAULT NULL,
465 P_Attribute8 IN Varchar2 DEFAULT NULL,
466 P_Attribute9 IN Varchar2 DEFAULT NULL,
467 P_Attribute10 IN Varchar2 DEFAULT NULL,
468 P_Attribute11 IN Varchar2 DEFAULT NULL,
469 P_Attribute12 IN Varchar2 DEFAULT NULL,
473 P_Demand_Tolerance_Positive IN Number DEFAULT NULL,
470 P_Attribute13 IN Varchar2 DEFAULT NULL,
471 P_Attribute14 IN Varchar2 DEFAULT NULL,
472 P_Attribute15 IN Varchar2 DEFAULT NULL,
474 P_Demand_Tolerance_Negative IN Number DEFAULT NULL,
475 P_Request_Id IN Number DEFAULT NULL,
476 P_Program_Application_Id IN Number DEFAULT NULL,
477 P_Program_Id IN Number DEFAULT NULL,
478 P_Program_Update_Date IN Date DEFAULT NULL,
479 P_Customer_Item_Id IN Number DEFAULT NULL,
480 P_Inventory_Item_Id IN Number DEFAULT NULL,
481 P_Master_Organization_Id IN Number DEFAULT NULL,
482 P_Preference_Number IN Number DEFAULT NULL
483 );
484
485
486 PROCEDURE Delete_Row(
487 P_Origin IN Varchar2 DEFAULT NULL,
488 P_Delete_Record IN Varchar2 DEFAULT NULL,
489 P_Temp_RowId IN Varchar2 DEFAULT NULL );
490
491
492 PROCEDURE Manage_Error_Code(
496
493 P_Action IN Varchar2 DEFAULT 'IN',
494 Error_Code IN Varchar2 DEFAULT NULL,
495 Curr_Error OUT NOCOPY Varchar2 );
497 END INVCIINT;