[Home] [Help]
PACKAGE: APPS.INV_ITEM_API
Source
1 PACKAGE INV_ITEM_API AS
2 /* $Header: INVVIPIS.pls 120.3.12010000.2 2008/11/20 00:25:30 akbharga ship $ */
3
4 -- =============================================================================
5 -- Global types
6 -- =============================================================================
7
8 -- For the Item record type use explicit list of columns,
9 -- not MTL_SYSTEM_ITEMS_B%ROWTYPE, because
10 -- (1) record elements must be initialized to pre-defined constants
11 -- representing missing values;
12 -- (2) need to include value based attributes absent from the entity table.
13
14 TYPE Item_rec_type IS RECORD
15 (
16 INVENTORY_ITEM_ID NUMBER
17 , ORGANIZATION_ID NUMBER
18 , MASTER_ORGANIZATION_ID NUMBER
19 , DESCRIPTION VARCHAR2(240)
20 , LONG_DESCRIPTION VARCHAR2(4000)
21 , PRIMARY_UOM_CODE VARCHAR2(3)
22 , PRIMARY_UNIT_OF_MEASURE VARCHAR2(25)
23 , ITEM_TYPE VARCHAR2(30)
24 , INVENTORY_ITEM_STATUS_CODE VARCHAR2(10)
25 , ALLOWED_UNITS_LOOKUP_CODE NUMBER
26 , ITEM_CATALOG_GROUP_ID NUMBER
27 , CATALOG_STATUS_FLAG VARCHAR2(1)
28 , INVENTORY_ITEM_FLAG VARCHAR2(1)
29 , STOCK_ENABLED_FLAG VARCHAR2(1)
30 , MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2(1)
31 , CHECK_SHORTAGES_FLAG VARCHAR2(1)
32 , REVISION_QTY_CONTROL_CODE NUMBER
33 , RESERVABLE_TYPE NUMBER
34 , SHELF_LIFE_CODE NUMBER
35 , SHELF_LIFE_DAYS NUMBER
36 , CYCLE_COUNT_ENABLED_FLAG VARCHAR2(1)
37 , NEGATIVE_MEASUREMENT_ERROR NUMBER
38 , POSITIVE_MEASUREMENT_ERROR NUMBER
39 , LOT_CONTROL_CODE NUMBER
40 , AUTO_LOT_ALPHA_PREFIX VARCHAR2(30)
41 , START_AUTO_LOT_NUMBER VARCHAR2(30)
42 , SERIAL_NUMBER_CONTROL_CODE NUMBER
43 , AUTO_SERIAL_ALPHA_PREFIX VARCHAR2(30)
44 , START_AUTO_SERIAL_NUMBER VARCHAR2(30)
45 , LOCATION_CONTROL_CODE NUMBER
46 , RESTRICT_SUBINVENTORIES_CODE NUMBER
47 , RESTRICT_LOCATORS_CODE NUMBER
48 , BOM_ENABLED_FLAG VARCHAR2(1)
49 , BOM_ITEM_TYPE NUMBER
50 , BASE_ITEM_ID NUMBER
51 , EFFECTIVITY_CONTROL NUMBER
52 , ENG_ITEM_FLAG VARCHAR2(1)
53 , ENGINEERING_ECN_CODE VARCHAR2(50)
54 , ENGINEERING_ITEM_ID NUMBER
55 , ENGINEERING_DATE DATE
56 , PRODUCT_FAMILY_ITEM_ID NUMBER
57 , AUTO_CREATED_CONFIG_FLAG VARCHAR2(1)
58 , MODEL_CONFIG_CLAUSE_NAME VARCHAR2(10)
59 -- Attribute not in the form
60 , NEW_REVISION_CODE VARCHAR2(30)
61 , COSTING_ENABLED_FLAG VARCHAR2(1)
62 , INVENTORY_ASSET_FLAG VARCHAR2(1)
63 , DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2(1)
64 , COST_OF_SALES_ACCOUNT NUMBER
65 , STD_LOT_SIZE NUMBER
66 , PURCHASING_ITEM_FLAG VARCHAR2(1)
67 , PURCHASING_ENABLED_FLAG VARCHAR2(1)
68 , MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2(1)
69 , ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2(1)
70 , RFQ_REQUIRED_FLAG VARCHAR2(1)
71 , OUTSIDE_OPERATION_FLAG VARCHAR2(1)
72 , OUTSIDE_OPERATION_UOM_TYPE VARCHAR2(25)
73 , TAXABLE_FLAG VARCHAR2(1)
74 , PURCHASING_TAX_CODE VARCHAR2(50)
75 , RECEIPT_REQUIRED_FLAG VARCHAR2(1)
76 , INSPECTION_REQUIRED_FLAG VARCHAR2(1)
77 , BUYER_ID NUMBER
78 , UNIT_OF_ISSUE VARCHAR2(25)
79 , RECEIVE_CLOSE_TOLERANCE NUMBER
80 , INVOICE_CLOSE_TOLERANCE NUMBER
81 , UN_NUMBER_ID NUMBER
82 , HAZARD_CLASS_ID NUMBER
83 , LIST_PRICE_PER_UNIT NUMBER
84 , MARKET_PRICE NUMBER
85 , PRICE_TOLERANCE_PERCENT NUMBER
86 , ROUNDING_FACTOR NUMBER
87 , ENCUMBRANCE_ACCOUNT NUMBER
88 , EXPENSE_ACCOUNT NUMBER
89 , ASSET_CATEGORY_ID NUMBER
90 , RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25)
91 , DAYS_EARLY_RECEIPT_ALLOWED NUMBER
92 , DAYS_LATE_RECEIPT_ALLOWED NUMBER
93 , ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1)
94 , ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1)
95 , ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2(1)
96 , QTY_RCV_EXCEPTION_CODE VARCHAR2(25)
97 , QTY_RCV_TOLERANCE NUMBER
98 , RECEIVING_ROUTING_ID NUMBER
99 , ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25)
100 , WEIGHT_UOM_CODE VARCHAR2(3)
101 , UNIT_WEIGHT NUMBER
102 , VOLUME_UOM_CODE VARCHAR2(3)
103 , UNIT_VOLUME NUMBER
104 , CONTAINER_ITEM_FLAG VARCHAR2(1)
105 , VEHICLE_ITEM_FLAG VARCHAR2(1)
106 , CONTAINER_TYPE_CODE VARCHAR2(30)
107 , INTERNAL_VOLUME NUMBER
108 , MAXIMUM_LOAD_WEIGHT NUMBER
109 , MINIMUM_FILL_PERCENT NUMBER
110 , INVENTORY_PLANNING_CODE NUMBER
111 , PLANNER_CODE VARCHAR2(10)
112 , PLANNING_MAKE_BUY_CODE NUMBER
113 , MIN_MINMAX_QUANTITY NUMBER
114 , MAX_MINMAX_QUANTITY NUMBER
115 , MINIMUM_ORDER_QUANTITY NUMBER
116 , MAXIMUM_ORDER_QUANTITY NUMBER
117 , ORDER_COST NUMBER
118 , CARRYING_COST NUMBER
119 , SOURCE_TYPE NUMBER
120 , SOURCE_ORGANIZATION_ID NUMBER
121 , SOURCE_SUBINVENTORY VARCHAR2(10)
122 , MRP_SAFETY_STOCK_CODE NUMBER
123 , SAFETY_STOCK_BUCKET_DAYS NUMBER
124 , MRP_SAFETY_STOCK_PERCENT NUMBER
125 , FIXED_ORDER_QUANTITY NUMBER
126 , FIXED_DAYS_SUPPLY NUMBER
127 , FIXED_LOT_MULTIPLIER NUMBER
128 , MRP_PLANNING_CODE NUMBER
129 , ATO_FORECAST_CONTROL NUMBER
130 , PLANNING_EXCEPTION_SET VARCHAR2(10)
131 , END_ASSEMBLY_PEGGING_FLAG VARCHAR2(1)
132 , SHRINKAGE_RATE NUMBER
133 , ROUNDING_CONTROL_TYPE NUMBER
134 , ACCEPTABLE_EARLY_DAYS NUMBER
135 , REPETITIVE_PLANNING_FLAG VARCHAR2(1)
136 , OVERRUN_PERCENTAGE NUMBER
137 , ACCEPTABLE_RATE_INCREASE NUMBER
138 , ACCEPTABLE_RATE_DECREASE NUMBER
139 , MRP_CALCULATE_ATP_FLAG VARCHAR2(1)
140 , AUTO_REDUCE_MPS NUMBER
141 , PLANNING_TIME_FENCE_CODE NUMBER
142 , PLANNING_TIME_FENCE_DAYS NUMBER
143 , DEMAND_TIME_FENCE_CODE NUMBER
144 , DEMAND_TIME_FENCE_DAYS NUMBER
145 , RELEASE_TIME_FENCE_CODE NUMBER
146 , RELEASE_TIME_FENCE_DAYS NUMBER
147 , PREPROCESSING_LEAD_TIME NUMBER
148 , FULL_LEAD_TIME NUMBER
149 , POSTPROCESSING_LEAD_TIME NUMBER
150 , FIXED_LEAD_TIME NUMBER
151 , VARIABLE_LEAD_TIME NUMBER
152 , CUM_MANUFACTURING_LEAD_TIME NUMBER
153 , CUMULATIVE_TOTAL_LEAD_TIME NUMBER
154 , LEAD_TIME_LOT_SIZE NUMBER
155 , BUILD_IN_WIP_FLAG VARCHAR2(1)
156 , WIP_SUPPLY_TYPE NUMBER
157 , WIP_SUPPLY_SUBINVENTORY VARCHAR2(10)
158 , WIP_SUPPLY_LOCATOR_ID NUMBER
159 , OVERCOMPLETION_TOLERANCE_TYPE NUMBER
160 , OVERCOMPLETION_TOLERANCE_VALUE NUMBER
161 , CUSTOMER_ORDER_FLAG VARCHAR2(1)
162 , CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2(1)
163 , SHIPPABLE_ITEM_FLAG VARCHAR2(1)
164 , INTERNAL_ORDER_FLAG VARCHAR2(1)
165 , INTERNAL_ORDER_ENABLED_FLAG VARCHAR2(1)
166 , SO_TRANSACTIONS_FLAG VARCHAR2(1)
167 , PICK_COMPONENTS_FLAG VARCHAR2(1)
168 , ATP_FLAG VARCHAR2(1)
169 , REPLENISH_TO_ORDER_FLAG VARCHAR2(1)
170 , ATP_RULE_ID NUMBER
171 , ATP_COMPONENTS_FLAG VARCHAR2(1)
172 , SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1)
173 , PICKING_RULE_ID NUMBER
174 , COLLATERAL_FLAG VARCHAR2(1)
175 , DEFAULT_SHIPPING_ORG NUMBER
176 , RETURNABLE_FLAG VARCHAR2(1)
177 , RETURN_INSPECTION_REQUIREMENT NUMBER
178 , OVER_SHIPMENT_TOLERANCE NUMBER
179 , UNDER_SHIPMENT_TOLERANCE NUMBER
180 , OVER_RETURN_TOLERANCE NUMBER
181 , UNDER_RETURN_TOLERANCE NUMBER
182 , INVOICEABLE_ITEM_FLAG VARCHAR2(1)
183 , INVOICE_ENABLED_FLAG VARCHAR2(1)
184 , ACCOUNTING_RULE_ID NUMBER
185 , INVOICING_RULE_ID NUMBER
186 , TAX_CODE VARCHAR2(50)
187 , SALES_ACCOUNT NUMBER
188 , PAYMENT_TERMS_ID NUMBER
189 , COVERAGE_SCHEDULE_ID NUMBER
190 , SERVICE_DURATION NUMBER
191 , SERVICE_DURATION_PERIOD_CODE VARCHAR2(10)
192 , SERVICEABLE_PRODUCT_FLAG VARCHAR2(1)
193 , SERVICE_STARTING_DELAY NUMBER
194 , MATERIAL_BILLABLE_FLAG VARCHAR2(30)
195 , SERVICEABLE_COMPONENT_FLAG VARCHAR2(1)
196 , PREVENTIVE_MAINTENANCE_FLAG VARCHAR2(1)
197 , PRORATE_SERVICE_FLAG VARCHAR2(1)
198 -- Attribute not in the form
199 , SERVICEABLE_ITEM_CLASS_ID NUMBER
200 -- Attribute not in the form
201 , BASE_WARRANTY_SERVICE_ID NUMBER
202 -- Attribute not in the form
203 , WARRANTY_VENDOR_ID NUMBER
204 -- Attribute not in the form
205 , MAX_WARRANTY_AMOUNT NUMBER
206 -- Attribute not in the form
207 , RESPONSE_TIME_PERIOD_CODE VARCHAR2(30)
208 -- Attribute not in the form
209 , RESPONSE_TIME_VALUE NUMBER
210 -- Attribute not in the form
211 , PRIMARY_SPECIALIST_ID NUMBER
212 -- Attribute not in the form
213 , SECONDARY_SPECIALIST_ID NUMBER
214 , WH_UPDATE_DATE DATE
215 , EQUIPMENT_TYPE NUMBER
216 , RECOVERED_PART_DISP_CODE VARCHAR2(30)
217 , DEFECT_TRACKING_ON_FLAG VARCHAR2(1)
218 , EVENT_FLAG VARCHAR2(1)
219 , ELECTRONIC_FLAG VARCHAR2(1)
220 , DOWNLOADABLE_FLAG VARCHAR2(1)
221 , VOL_DISCOUNT_EXEMPT_FLAG VARCHAR2(1)
222 , COUPON_EXEMPT_FLAG VARCHAR2(1)
223 , COMMS_NL_TRACKABLE_FLAG VARCHAR2(1)
224 , ASSET_CREATION_CODE VARCHAR2(30)
225 , COMMS_ACTIVATION_REQD_FLAG VARCHAR2(1)
226 , ORDERABLE_ON_WEB_FLAG VARCHAR2(1)
227 , BACK_ORDERABLE_FLAG VARCHAR2(1)
228 , WEB_STATUS VARCHAR2(30)
229 , INDIVISIBLE_FLAG VARCHAR2(1)
230 , DIMENSION_UOM_CODE VARCHAR2(3)
231 , UNIT_LENGTH NUMBER
232 , UNIT_WIDTH NUMBER
233 , UNIT_HEIGHT NUMBER
234 , BULK_PICKED_FLAG VARCHAR2(1)
235 , LOT_STATUS_ENABLED VARCHAR2(1)
236 , DEFAULT_LOT_STATUS_ID NUMBER
237 , SERIAL_STATUS_ENABLED VARCHAR2(1)
238 , DEFAULT_SERIAL_STATUS_ID NUMBER
239 , LOT_SPLIT_ENABLED VARCHAR2(1)
240 , LOT_MERGE_ENABLED VARCHAR2(1)
241 , INVENTORY_CARRY_PENALTY NUMBER
242 , OPERATION_SLACK_PENALTY NUMBER
243 , FINANCING_ALLOWED_FLAG VARCHAR2(1)
244 , EAM_ITEM_TYPE NUMBER
245 , EAM_ACTIVITY_TYPE_CODE VARCHAR2(30)
246 , EAM_ACTIVITY_CAUSE_CODE VARCHAR2(30)
247 , EAM_ACT_NOTIFICATION_FLAG VARCHAR2(1)
248 , EAM_ACT_SHUTDOWN_STATUS VARCHAR2(30)
249 , DUAL_UOM_CONTROL NUMBER
250 , SECONDARY_UOM_CODE VARCHAR2(3)
251 , DUAL_UOM_DEVIATION_HIGH NUMBER
252 , DUAL_UOM_DEVIATION_LOW NUMBER
253 -- Derived attributes
254 --, SERVICE_ITEM_FLAG VARCHAR2(1)
255 --, VENDOR_WARRANTY_FLAG VARCHAR2(1)
256 --, USAGE_ITEM_FLAG VARCHAR2(1)
257 , CONTRACT_ITEM_TYPE_CODE VARCHAR2(30)
258 , SUBSCRIPTION_DEPEND_FLAG VARCHAR2(1)
259 , SERV_REQ_ENABLED_CODE VARCHAR2(30)
260 , SERV_BILLING_ENABLED_FLAG VARCHAR2(1)
261 , SERV_IMPORTANCE_LEVEL NUMBER
262 , PLANNED_INV_POINT_FLAG VARCHAR2(1)
263 , LOT_TRANSLATE_ENABLED VARCHAR2(1)
264 , DEFAULT_SO_SOURCE_TYPE VARCHAR2(30)
265 , CREATE_SUPPLY_FLAG VARCHAR2(1)
266 , SUBSTITUTION_WINDOW_CODE NUMBER
267 , SUBSTITUTION_WINDOW_DAYS NUMBER
268 , IB_ITEM_INSTANCE_CLASS VARCHAR2(30)
269 , CONFIG_MODEL_TYPE VARCHAR2(30)
270 --Added for 11.5.9 Enh
271 , LOT_SUBSTITUTION_ENABLED VARCHAR2(1)
272 , MINIMUM_LICENSE_QUANTITY NUMBER
273 , EAM_ACTIVITY_SOURCE_CODE VARCHAR2(30)
274 --Added for 11.5.10 Enh
275 , TRACKING_QUANTITY_IND VARCHAR2(30)
276 , ONT_PRICING_QTY_SOURCE VARCHAR2(30)
277 , SECONDARY_DEFAULT_IND VARCHAR2(30)
278 , OPTION_SPECIFIC_SOURCED NUMBER
279 , CONFIG_ORGS VARCHAR2(30)
280 , CONFIG_MATCH VARCHAR2(30)
281 --, ITEM_NUMBER VARCHAR2(2000)
282 , SEGMENT1 VARCHAR2(40)
283 , SEGMENT2 VARCHAR2(40)
284 , SEGMENT3 VARCHAR2(40)
285 , SEGMENT4 VARCHAR2(40)
289 , SEGMENT8 VARCHAR2(40)
286 , SEGMENT5 VARCHAR2(40)
287 , SEGMENT6 VARCHAR2(40)
288 , SEGMENT7 VARCHAR2(40)
290 , SEGMENT9 VARCHAR2(40)
291 , SEGMENT10 VARCHAR2(40)
292 , SEGMENT11 VARCHAR2(40)
293 , SEGMENT12 VARCHAR2(40)
294 , SEGMENT13 VARCHAR2(40)
295 , SEGMENT14 VARCHAR2(40)
296 , SEGMENT15 VARCHAR2(40)
297 , SEGMENT16 VARCHAR2(40)
298 , SEGMENT17 VARCHAR2(40)
299 , SEGMENT18 VARCHAR2(40)
300 , SEGMENT19 VARCHAR2(40)
301 , SEGMENT20 VARCHAR2(40)
302 , SUMMARY_FLAG VARCHAR2(1)
303 , ENABLED_FLAG VARCHAR2(1)
304 , START_DATE_ACTIVE DATE
305 , END_DATE_ACTIVE DATE
306 , ATTRIBUTE_CATEGORY VARCHAR2(30)
307 , ATTRIBUTE1 VARCHAR2(240)
308 , ATTRIBUTE2 VARCHAR2(240)
309 , ATTRIBUTE3 VARCHAR2(240)
310 , ATTRIBUTE4 VARCHAR2(240)
311 , ATTRIBUTE5 VARCHAR2(240)
312 , ATTRIBUTE6 VARCHAR2(240)
313 , ATTRIBUTE7 VARCHAR2(240)
314 , ATTRIBUTE8 VARCHAR2(240)
315 , ATTRIBUTE9 VARCHAR2(240)
316 , ATTRIBUTE10 VARCHAR2(240)
317 , ATTRIBUTE11 VARCHAR2(240)
318 , ATTRIBUTE12 VARCHAR2(240)
319 , ATTRIBUTE13 VARCHAR2(240)
320 , ATTRIBUTE14 VARCHAR2(240)
321 , ATTRIBUTE15 VARCHAR2(240)
322 , GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(150)
323 , GLOBAL_ATTRIBUTE1 VARCHAR2(150)
324 , GLOBAL_ATTRIBUTE2 VARCHAR2(150)
325 , GLOBAL_ATTRIBUTE3 VARCHAR2(150)
326 , GLOBAL_ATTRIBUTE4 VARCHAR2(150)
327 , GLOBAL_ATTRIBUTE5 VARCHAR2(150)
328 , GLOBAL_ATTRIBUTE6 VARCHAR2(150)
329 , GLOBAL_ATTRIBUTE7 VARCHAR2(150)
330 , GLOBAL_ATTRIBUTE8 VARCHAR2(150)
331 , GLOBAL_ATTRIBUTE9 VARCHAR2(150)
332 , GLOBAL_ATTRIBUTE10 VARCHAR2(150)
333 , GLOBAL_ATTRIBUTE11 VARCHAR2(150)
334 , GLOBAL_ATTRIBUTE12 VARCHAR2(150)
335 , GLOBAL_ATTRIBUTE13 VARCHAR2(150)
336 , GLOBAL_ATTRIBUTE14 VARCHAR2(150)
337 , GLOBAL_ATTRIBUTE15 VARCHAR2(150)
338 , GLOBAL_ATTRIBUTE16 VARCHAR2(150)
339 , GLOBAL_ATTRIBUTE17 VARCHAR2(150)
340 , GLOBAL_ATTRIBUTE18 VARCHAR2(150)
341 , GLOBAL_ATTRIBUTE19 VARCHAR2(150)
342 , GLOBAL_ATTRIBUTE20 VARCHAR2(150)
343 , CREATION_DATE DATE
344 , CREATED_BY NUMBER
345 , LAST_UPDATE_DATE DATE
346 , LAST_UPDATED_BY NUMBER
347 , LAST_UPDATE_LOGIN NUMBER
348 , REQUEST_ID NUMBER
349 , PROGRAM_APPLICATION_ID NUMBER
350 , PROGRAM_ID NUMBER
351 , PROGRAM_UPDATE_DATE DATE
352 , LIFECYCLE_ID NUMBER
353 , CURRENT_PHASE_ID NUMBER
354 , VMI_MINIMUM_UNITS NUMBER
355 , VMI_MINIMUM_DAYS NUMBER
356 , VMI_MAXIMUM_UNITS NUMBER
357 , VMI_MAXIMUM_DAYS NUMBER
358 , VMI_FIXED_ORDER_QUANTITY NUMBER
359 , SO_AUTHORIZATION_FLAG NUMBER
360 , CONSIGNED_FLAG NUMBER
361 , ASN_AUTOEXPIRE_FLAG NUMBER
362 , VMI_FORECAST_TYPE NUMBER
363 , FORECAST_HORIZON NUMBER
364 , EXCLUDE_FROM_BUDGET_FLAG NUMBER
365 , DAYS_TGT_INV_SUPPLY NUMBER
366 , DAYS_TGT_INV_WINDOW NUMBER
367 , DAYS_MAX_INV_SUPPLY NUMBER
368 , DAYS_MAX_INV_WINDOW NUMBER
369 , DRP_PLANNED_FLAG NUMBER
370 , CRITICAL_COMPONENT_FLAG NUMBER
371 , CONTINOUS_TRANSFER NUMBER
372 , CONVERGENCE NUMBER
373 , DIVERGENCE NUMBER
374 /* Start Bug 3713912 */
375 , LOT_DIVISIBLE_FLAG VARCHAR2(1) ,
376 GRADE_CONTROL_FLAG VARCHAR2(1) ,
377 DEFAULT_GRADE VARCHAR2(150),
378 CHILD_LOT_FLAG VARCHAR2(1) ,
379 PARENT_CHILD_GENERATION_FLAG VARCHAR2(1) ,
380 CHILD_LOT_PREFIX VARCHAR2(30),
381 CHILD_LOT_STARTING_NUMBER NUMBER ,
382 CHILD_LOT_VALIDATION_FLAG VARCHAR2(1) ,
383 COPY_LOT_ATTRIBUTE_FLAG VARCHAR2(1),
384 RECIPE_ENABLED_FLAG VARCHAR2(1) ,
385 PROCESS_QUALITY_ENABLED_FLAG VARCHAR2(1) ,
386 PROCESS_EXECUTION_ENABLED_FLAG VARCHAR2(1) ,
387 PROCESS_COSTING_ENABLED_FLAG VARCHAR2(1) ,
388 PROCESS_SUPPLY_SUBINVENTORY VARCHAR2(10) ,
389 PROCESS_SUPPLY_LOCATOR_ID NUMBER ,
390 PROCESS_YIELD_SUBINVENTORY VARCHAR2(10) ,
391 PROCESS_YIELD_LOCATOR_ID NUMBER ,
392 HAZARDOUS_MATERIAL_FLAG VARCHAR2(1),
396 EXPIRATION_ACTION_CODE VARCHAR2(32) ,
393 CAS_NUMBER VARCHAR2(30) ,
394 RETEST_INTERVAL NUMBER ,
395 EXPIRATION_ACTION_INTERVAL NUMBER ,
397 MATURITY_DAYS NUMBER ,
398 HOLD_DAYS NUMBER ,
399 ATTRIBUTE16 VARCHAR2(240),
400 ATTRIBUTE17 VARCHAR2(240),
401 ATTRIBUTE18 VARCHAR2(240),
402 ATTRIBUTE19 VARCHAR2(240),
403 ATTRIBUTE20 VARCHAR2(240),
404 ATTRIBUTE21 VARCHAR2(240),
405 ATTRIBUTE22 VARCHAR2(240),
406 ATTRIBUTE23 VARCHAR2(240),
407 ATTRIBUTE24 VARCHAR2(240),
408 ATTRIBUTE25 VARCHAR2(240),
409 ATTRIBUTE26 VARCHAR2(240),
410 ATTRIBUTE27 VARCHAR2(240),
411 ATTRIBUTE28 VARCHAR2(240),
412 ATTRIBUTE29 VARCHAR2(240),
413 ATTRIBUTE30 VARCHAR2(240)
414 /* End Bug 3713912 */
415 --Added for R12 ENH.
416 , CHARGE_PERIODICITY_CODE VARCHAR2(3)
417 , REPAIR_LEADTIME NUMBER
418 , REPAIR_YIELD NUMBER
419 , PREPOSITION_POINT VARCHAR2(1)
420 , REPAIR_PROGRAM NUMBER
421 , SUBCONTRACTING_COMPONENT NUMBER
422 , OUTSOURCED_ASSEMBLY NUMBER
423 -- Fix for Bug#6644711
424 , DEFAULT_MATERIAL_STATUS_ID NUMBER
425 );
426
427 TYPE Item_TL_rec_type IS RECORD
428 (
429 INVENTORY_ITEM_ID NUMBER
430 , ORGANIZATION_ID NUMBER
431 , LANGUAGE VARCHAR2(4)
432 , SOURCE_LANG VARCHAR2(4)
433 , DESCRIPTION VARCHAR2(240)
434 , LONG_DESCRIPTION VARCHAR2(4000)
435 , CREATION_DATE DATE
436 , CREATED_BY NUMBER
437 , LAST_UPDATE_DATE DATE
438 , LAST_UPDATED_BY NUMBER
439 , LAST_UPDATE_LOGIN NUMBER
440 );
441
442 TYPE Item_Attribute_rec_type IS RECORD
443 (
444 Attribute_Code VARCHAR2(50)
445 , ATTRIBUTE_NAME VARCHAR2(50)
446 , USER_ATTRIBUTE_NAME_GUI VARCHAR2(30)
447 , ATTRIBUTE_GROUP_ID_GUI NUMBER
448 , SEQUENCE_GUI NUMBER
449 , DATA_TYPE VARCHAR2(8)
450 , VALIDATION_CODE NUMBER
451 , MANDATORY_FLAG VARCHAR2(1)
452 , CONTROL_LEVEL NUMBER
453 , LEVEL_UPDATEABLE_FLAG VARCHAR2(1)
454 , STATUS_CONTROL_CODE NUMBER
455 , LAST_UPDATE_DATE DATE
456 , LAST_UPDATED_BY NUMBER
457 , CREATION_DATE DATE
458 , CREATED_BY NUMBER
459 , LAST_UPDATE_LOGIN NUMBER
460 );
461
462 TYPE Item_Attribute_tbl_type IS TABLE OF Item_Attribute_rec_type
463 INDEX BY BINARY_INTEGER;
464
465
466 /*----------------------------------------------------------------------------*/
467 /*------------------ Variables representing missing values -------------------*/
468 /*----------------------------------------------------------------------------*/
469
470 -- Item_rec_type elements default to NULL.
471 -- g_miss_Item_rec need not be used anymore.
472 --
473 --g_miss_Item_rec Item_rec_type;
474
475 g_miss_Item_Attr_rec Item_Attribute_rec_type;
476 g_miss_Item_Attr_tbl Item_Attribute_tbl_type;
477
478
479 -- =============================================================================
480 -- Global variables and constants
481 -- =============================================================================
482
483 g_TRUE CONSTANT VARCHAR2(1) := FND_API.g_TRUE;
484 g_FALSE CONSTANT VARCHAR2(1) := FND_API.g_FALSE;
485
486 -- Item key flexfield structure
487 --g_Item_KFF_Struct_Number CONSTANT VARCHAR2(30) := '101';
488
489
493
490 -- =============================================================================
491 -- Global cursor specs
492 -- =============================================================================
494 -- Item_B cursor
495 --
496 CURSOR Item_csr
497 (
498 p_Item_ID IN NUMBER
499 , p_Org_ID IN NUMBER
500 , p_fetch_Master IN VARCHAR2 := g_TRUE
501 , p_fetch_Orgs IN VARCHAR2 := g_FALSE
502 )
503 RETURN Item_rec_type ;
504
505
506 -- Org Item_TL cursor
507 --
508 CURSOR Item_TL_csr
509 (
510 p_Item_ID IN NUMBER
511 , p_Org_ID IN NUMBER
512 , p_fetch_Master IN VARCHAR2 := g_TRUE
513 , p_fetch_Orgs IN VARCHAR2 := g_FALSE
514 , p_restrict_Lang IN VARCHAR2 := g_FALSE
515 )
516 RETURN Item_TL_rec_type ;
517
518
519 -- Item Attributes cursor
520 --
521 CURSOR Item_Attribute_csr
522 RETURN Item_Attribute_rec_type ;
523
524
525 -- =============================================================================
526 -- Procedure specs
527 -- =============================================================================
528
529 /*----------------------------- Update_Item_Row ------------------------------*/
530
531 PROCEDURE Update_Item_Row
532 (
533 p_Item_rec IN Item_rec_type
534 , p_update_Item_TL IN BOOLEAN
535 , p_Lang_Flag IN VARCHAR2
536 , x_return_status OUT NOCOPY VARCHAR2
537 );
538
539
540 /*---------------------------- Update_Item_TL_Row ----------------------------*/
541
542 -- Currently not used
543 /*
544 PROCEDURE Update_Item_TL_Row
545 (
546 p_Item_TL_rec IN Item_TL_rec_type
547 , x_return_status OUT VARCHAR2
548 );
549 */
550
551 -- -------------------- To_Boolchar ---------------------
552
553 -- Currently not used
554 /*
555 FUNCTION To_Boolchar
556 (
557 p_bool IN BOOLEAN
558 )
562
559 RETURN VARCHAR2;
560 */
561
563 END INV_ITEM_API;