[Home] [Help]
PACKAGE BODY: APPS.INV_ITEM_API
Source
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ITEM_API';
1 PACKAGE BODY INV_ITEM_API AS
2 /* $Header: INVVIPIB.pls 120.9.12020000.5 2013/04/08 04:06:30 qixia ship $ */
3
5
6 -- =============================================================================
7 -- Package variables, constants and cursors
8 -- =============================================================================
9
10 -- Org Item_B cursor
11 --
12 CURSOR Item_csr
13 (
14 p_Item_ID IN NUMBER
15 , p_Org_ID IN NUMBER
16 , p_fetch_Master IN VARCHAR2 := g_TRUE
17 , p_fetch_Orgs IN VARCHAR2 := g_FALSE
18 )
19 RETURN Item_rec_type
20 IS
21 -- Use explicit list of columns (not a "select *") because
22 -- the cursor is to be fetched into Item-type record variable
23 -- defined with the specific list of columns.
24 --
25 SELECT
26 MSI.INVENTORY_ITEM_ID
27 , MSI.ORGANIZATION_ID
28 , MP1.MASTER_ORGANIZATION_ID
29 , MSI.DESCRIPTION
30 --, MSITL.LONG_DESCRIPTION
31 , NULL LONG_DESCRIPTION
32 , MSI.PRIMARY_UOM_CODE
33 , MSI.PRIMARY_UNIT_OF_MEASURE
34 , MSI.ITEM_TYPE
35 , MSI.INVENTORY_ITEM_STATUS_CODE
36 , MSI.ALLOWED_UNITS_LOOKUP_CODE
37 , MSI.ITEM_CATALOG_GROUP_ID
38 , MSI.CATALOG_STATUS_FLAG
39 , MSI.INVENTORY_ITEM_FLAG
40 , MSI.STOCK_ENABLED_FLAG
41 , MSI.MTL_TRANSACTIONS_ENABLED_FLAG
42 , MSI.CHECK_SHORTAGES_FLAG
43 , MSI.REVISION_QTY_CONTROL_CODE
44 , MSI.RESERVABLE_TYPE
45 , MSI.SHELF_LIFE_CODE
46 , MSI.SHELF_LIFE_DAYS
47 , MSI.CYCLE_COUNT_ENABLED_FLAG
48 , MSI.NEGATIVE_MEASUREMENT_ERROR
49 , MSI.POSITIVE_MEASUREMENT_ERROR
50 , MSI.LOT_CONTROL_CODE
51 , MSI.AUTO_LOT_ALPHA_PREFIX
52 , MSI.START_AUTO_LOT_NUMBER
53 , MSI.SERIAL_NUMBER_CONTROL_CODE
54 , MSI.AUTO_SERIAL_ALPHA_PREFIX
55 , MSI.START_AUTO_SERIAL_NUMBER
56 , MSI.LOCATION_CONTROL_CODE
57 , MSI.RESTRICT_SUBINVENTORIES_CODE
58 , MSI.RESTRICT_LOCATORS_CODE
59 , MSI.BOM_ENABLED_FLAG
60 , MSI.BOM_ITEM_TYPE
61 , MSI.BASE_ITEM_ID
62 , MSI.EFFECTIVITY_CONTROL
63 , MSI.ENG_ITEM_FLAG
64 , MSI.ENGINEERING_ECN_CODE
65 , MSI.ENGINEERING_ITEM_ID
66 , MSI.ENGINEERING_DATE
67 , MSI.PRODUCT_FAMILY_ITEM_ID
68 , MSI.AUTO_CREATED_CONFIG_FLAG
72 , MSI.INVENTORY_ASSET_FLAG
69 , MSI.MODEL_CONFIG_CLAUSE_NAME
70 , MSI.NEW_REVISION_CODE
71 , MSI.COSTING_ENABLED_FLAG
73 , MSI.DEFAULT_INCLUDE_IN_ROLLUP_FLAG
74 , MSI.COST_OF_SALES_ACCOUNT
75 , MSI.STD_LOT_SIZE
76 , MSI.PURCHASING_ITEM_FLAG
77 , MSI.PURCHASING_ENABLED_FLAG
78 , MSI.MUST_USE_APPROVED_VENDOR_FLAG
79 , MSI.ALLOW_ITEM_DESC_UPDATE_FLAG
80 , MSI.RFQ_REQUIRED_FLAG
81 , MSI.OUTSIDE_OPERATION_FLAG
82 , MSI.OUTSIDE_OPERATION_UOM_TYPE
83 , MSI.TAXABLE_FLAG
84 , MSI.PURCHASING_TAX_CODE
85 , MSI.RECEIPT_REQUIRED_FLAG
86 , MSI.INSPECTION_REQUIRED_FLAG
87 , MSI.BUYER_ID
88 , MSI.UNIT_OF_ISSUE
89 , MSI.RECEIVE_CLOSE_TOLERANCE
90 , MSI.INVOICE_CLOSE_TOLERANCE
91 , MSI.UN_NUMBER_ID
92 , MSI.HAZARD_CLASS_ID
93 , MSI.LIST_PRICE_PER_UNIT
94 , MSI.MARKET_PRICE
95 , MSI.PRICE_TOLERANCE_PERCENT
96 , MSI.ROUNDING_FACTOR
97 , MSI.ENCUMBRANCE_ACCOUNT
98 , MSI.EXPENSE_ACCOUNT
99 , MSI.ASSET_CATEGORY_ID
100 , MSI.RECEIPT_DAYS_EXCEPTION_CODE
101 , MSI.DAYS_EARLY_RECEIPT_ALLOWED
102 , MSI.DAYS_LATE_RECEIPT_ALLOWED
103 , MSI.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
104 , MSI.ALLOW_UNORDERED_RECEIPTS_FLAG
105 , MSI.ALLOW_EXPRESS_DELIVERY_FLAG
106 , MSI.QTY_RCV_EXCEPTION_CODE
107 , MSI.QTY_RCV_TOLERANCE
108 , MSI.RECEIVING_ROUTING_ID
109 , MSI.ENFORCE_SHIP_TO_LOCATION_CODE
110 , MSI.WEIGHT_UOM_CODE
111 , MSI.UNIT_WEIGHT
112 , MSI.VOLUME_UOM_CODE
113 , MSI.UNIT_VOLUME
114 , MSI.CONTAINER_ITEM_FLAG
115 , MSI.VEHICLE_ITEM_FLAG
116 , MSI.CONTAINER_TYPE_CODE
117 , MSI.INTERNAL_VOLUME
118 , MSI.MAXIMUM_LOAD_WEIGHT
119 , MSI.MINIMUM_FILL_PERCENT
120 , MSI.INVENTORY_PLANNING_CODE
121 , MSI.PLANNER_CODE
122 , MSI.PLANNING_MAKE_BUY_CODE
123 , MSI.MIN_MINMAX_QUANTITY
124 , MSI.MAX_MINMAX_QUANTITY
125 , MSI.MINIMUM_ORDER_QUANTITY
126 , MSI.MAXIMUM_ORDER_QUANTITY
127 , MSI.ORDER_COST
128 , MSI.CARRYING_COST
129 , MSI.SOURCE_TYPE
130 , MSI.SOURCE_ORGANIZATION_ID
131 , MSI.SOURCE_SUBINVENTORY
132 , MSI.MRP_SAFETY_STOCK_CODE
133 , MSI.SAFETY_STOCK_BUCKET_DAYS
134 , MSI.MRP_SAFETY_STOCK_PERCENT
135 , MSI.FIXED_ORDER_QUANTITY
136 , MSI.FIXED_DAYS_SUPPLY
137 , MSI.FIXED_LOT_MULTIPLIER
138 , MSI.MRP_PLANNING_CODE
139 , MSI.ATO_FORECAST_CONTROL
140 , MSI.PLANNING_EXCEPTION_SET
141 , MSI.END_ASSEMBLY_PEGGING_FLAG
142 , MSI.SHRINKAGE_RATE
143 , MSI.ROUNDING_CONTROL_TYPE
144 , MSI.ACCEPTABLE_EARLY_DAYS
145 , MSI.REPETITIVE_PLANNING_FLAG
146 , MSI.OVERRUN_PERCENTAGE
147 , MSI.ACCEPTABLE_RATE_INCREASE
148 , MSI.ACCEPTABLE_RATE_DECREASE
149 , MSI.MRP_CALCULATE_ATP_FLAG
150 , MSI.AUTO_REDUCE_MPS
151 , MSI.PLANNING_TIME_FENCE_CODE
152 , MSI.PLANNING_TIME_FENCE_DAYS
153 , MSI.DEMAND_TIME_FENCE_CODE
154 , MSI.DEMAND_TIME_FENCE_DAYS
155 , MSI.RELEASE_TIME_FENCE_CODE
156 , MSI.RELEASE_TIME_FENCE_DAYS
157 , MSI.PREPROCESSING_LEAD_TIME
158 , MSI.FULL_LEAD_TIME
159 , MSI.POSTPROCESSING_LEAD_TIME
160 , MSI.FIXED_LEAD_TIME
161 , MSI.VARIABLE_LEAD_TIME
162 , MSI.CUM_MANUFACTURING_LEAD_TIME
163 , MSI.CUMULATIVE_TOTAL_LEAD_TIME
164 , MSI.LEAD_TIME_LOT_SIZE
165 , MSI.BUILD_IN_WIP_FLAG
166 , MSI.WIP_SUPPLY_TYPE
167 , MSI.WIP_SUPPLY_SUBINVENTORY
168 , MSI.WIP_SUPPLY_LOCATOR_ID
169 , MSI.OVERCOMPLETION_TOLERANCE_TYPE
170 , MSI.OVERCOMPLETION_TOLERANCE_VALUE
171 , MSI.CUSTOMER_ORDER_FLAG
172 , MSI.CUSTOMER_ORDER_ENABLED_FLAG
173 , MSI.SHIPPABLE_ITEM_FLAG
174 , MSI.INTERNAL_ORDER_FLAG
175 , MSI.INTERNAL_ORDER_ENABLED_FLAG
176 , MSI.SO_TRANSACTIONS_FLAG
177 , MSI.PICK_COMPONENTS_FLAG
178 , MSI.ATP_FLAG
179 , MSI.REPLENISH_TO_ORDER_FLAG
180 , MSI.ATP_RULE_ID
181 , MSI.ATP_COMPONENTS_FLAG
182 , MSI.SHIP_MODEL_COMPLETE_FLAG
183 , MSI.PICKING_RULE_ID
184 , MSI.COLLATERAL_FLAG
185 , MSI.DEFAULT_SHIPPING_ORG
186 , MSI.RETURNABLE_FLAG
187 , MSI.RETURN_INSPECTION_REQUIREMENT
188 , MSI.OVER_SHIPMENT_TOLERANCE
189 , MSI.UNDER_SHIPMENT_TOLERANCE
190 , MSI.OVER_RETURN_TOLERANCE
191 , MSI.UNDER_RETURN_TOLERANCE
192 , MSI.INVOICEABLE_ITEM_FLAG
193 , MSI.INVOICE_ENABLED_FLAG
194 , MSI.ACCOUNTING_RULE_ID
195 , MSI.INVOICING_RULE_ID
196 , MSI.TAX_CODE
197 , MSI.SALES_ACCOUNT
198 , MSI.PAYMENT_TERMS_ID
199 , MSI.COVERAGE_SCHEDULE_ID
200 , MSI.SERVICE_DURATION
201 , MSI.SERVICE_DURATION_PERIOD_CODE
202 , MSI.SERVICEABLE_PRODUCT_FLAG
203 , MSI.SERVICE_STARTING_DELAY
204 , MSI.MATERIAL_BILLABLE_FLAG
205 , MSI.SERVICEABLE_COMPONENT_FLAG
206 , MSI.PREVENTIVE_MAINTENANCE_FLAG
207 , MSI.PRORATE_SERVICE_FLAG
208 , MSI.SERVICEABLE_ITEM_CLASS_ID
209 , MSI.BASE_WARRANTY_SERVICE_ID
210 , MSI.WARRANTY_VENDOR_ID
211 , MSI.MAX_WARRANTY_AMOUNT
212 , MSI.RESPONSE_TIME_PERIOD_CODE
213 , MSI.RESPONSE_TIME_VALUE
214 , MSI.PRIMARY_SPECIALIST_ID
215 , MSI.SECONDARY_SPECIALIST_ID
216 , MSI.WH_UPDATE_DATE
220 , MSI.EVENT_FLAG
217 , MSI.EQUIPMENT_TYPE
218 , MSI.RECOVERED_PART_DISP_CODE
219 , MSI.DEFECT_TRACKING_ON_FLAG
221 , MSI.ELECTRONIC_FLAG
222 , MSI.DOWNLOADABLE_FLAG
223 , MSI.VOL_DISCOUNT_EXEMPT_FLAG
224 , MSI.COUPON_EXEMPT_FLAG
225 , MSI.COMMS_NL_TRACKABLE_FLAG
226 , MSI.ASSET_CREATION_CODE
227 , MSI.COMMS_ACTIVATION_REQD_FLAG
228 , MSI.ORDERABLE_ON_WEB_FLAG
229 , MSI.BACK_ORDERABLE_FLAG
230 , MSI.WEB_STATUS
231 , MSI.INDIVISIBLE_FLAG
232 , MSI.DIMENSION_UOM_CODE
233 , MSI.UNIT_LENGTH
234 , MSI.UNIT_WIDTH
235 , MSI.UNIT_HEIGHT
236 , MSI.BULK_PICKED_FLAG
237 , MSI.LOT_STATUS_ENABLED
238 , MSI.DEFAULT_LOT_STATUS_ID
239 , MSI.SERIAL_STATUS_ENABLED
240 , MSI.DEFAULT_SERIAL_STATUS_ID
241 , MSI.LOT_SPLIT_ENABLED
242 , MSI.LOT_MERGE_ENABLED
243 , MSI.INVENTORY_CARRY_PENALTY
244 , MSI.OPERATION_SLACK_PENALTY
245 , MSI.FINANCING_ALLOWED_FLAG
246 , MSI.EAM_ITEM_TYPE
247 , MSI.EAM_ACTIVITY_TYPE_CODE
248 , MSI.EAM_ACTIVITY_CAUSE_CODE
249 , MSI.EAM_ACT_NOTIFICATION_FLAG
250 , MSI.EAM_ACT_SHUTDOWN_STATUS
251 , MSI.DUAL_UOM_CONTROL
252 , MSI.SECONDARY_UOM_CODE
253 , MSI.DUAL_UOM_DEVIATION_HIGH
254 , MSI.DUAL_UOM_DEVIATION_LOW
255 -- Derived attributes
256 --, MSI.SERVICE_ITEM_FLAG
257 --, MSI.VENDOR_WARRANTY_FLAG
258 --, MSI.USAGE_ITEM_FLAG
259 , MSI.CONTRACT_ITEM_TYPE_CODE
260 , MSI.SUBSCRIPTION_DEPEND_FLAG
261 , MSI.SERV_REQ_ENABLED_CODE
262 , MSI.SERV_BILLING_ENABLED_FLAG
263 , MSI.SERV_IMPORTANCE_LEVEL
264 , MSI.PLANNED_INV_POINT_FLAG
265 , MSI.LOT_TRANSLATE_ENABLED
266 , MSI.DEFAULT_SO_SOURCE_TYPE
267 , MSI.CREATE_SUPPLY_FLAG
268 , MSI.SUBSTITUTION_WINDOW_CODE
269 , MSI.SUBSTITUTION_WINDOW_DAYS
270 , MSI.IB_ITEM_INSTANCE_CLASS
271 , MSI.CONFIG_MODEL_TYPE
272 --Added as part of 11.5.9 ENH
273 , MSI.LOT_SUBSTITUTION_ENABLED
274 , MSI.MINIMUM_LICENSE_QUANTITY
275 , MSI.EAM_ACTIVITY_SOURCE_CODE
276 --Added as part of 11.5.10 ENH
277 , MSI.TRACKING_QUANTITY_IND
278 , MSI.ONT_PRICING_QTY_SOURCE
279 , MSI.SECONDARY_DEFAULT_IND
280 , MSI.OPTION_SPECIFIC_SOURCED
281 , MSI.CONFIG_ORGS
282 , MSI.CONFIG_MATCH
283 --, g_miss_CHAR ITEM_NUMBER
284 , MSI.SEGMENT1
285 , MSI.SEGMENT2
286 , MSI.SEGMENT3
287 , MSI.SEGMENT4
288 , MSI.SEGMENT5
289 , MSI.SEGMENT6
290 , MSI.SEGMENT7
291 , MSI.SEGMENT8
292 , MSI.SEGMENT9
293 , MSI.SEGMENT10
294 , MSI.SEGMENT11
295 , MSI.SEGMENT12
296 , MSI.SEGMENT13
297 , MSI.SEGMENT14
298 , MSI.SEGMENT15
299 , MSI.SEGMENT16
300 , MSI.SEGMENT17
301 , MSI.SEGMENT18
302 , MSI.SEGMENT19
303 , MSI.SEGMENT20
304 , MSI.SUMMARY_FLAG
305 , MSI.ENABLED_FLAG
306 , MSI.START_DATE_ACTIVE
307 , MSI.END_DATE_ACTIVE
308 , MSI.ATTRIBUTE_CATEGORY
309 , MSI.ATTRIBUTE1
310 , MSI.ATTRIBUTE2
311 , MSI.ATTRIBUTE3
312 , MSI.ATTRIBUTE4
313 , MSI.ATTRIBUTE5
314 , MSI.ATTRIBUTE6
315 , MSI.ATTRIBUTE7
316 , MSI.ATTRIBUTE8
317 , MSI.ATTRIBUTE9
318 , MSI.ATTRIBUTE10
319 , MSI.ATTRIBUTE11
320 , MSI.ATTRIBUTE12
321 , MSI.ATTRIBUTE13
322 , MSI.ATTRIBUTE14
323 , MSI.ATTRIBUTE15
324 , MSI.GLOBAL_ATTRIBUTE_CATEGORY
325 , MSI.GLOBAL_ATTRIBUTE1
326 , MSI.GLOBAL_ATTRIBUTE2
327 , MSI.GLOBAL_ATTRIBUTE3
328 , MSI.GLOBAL_ATTRIBUTE4
329 , MSI.GLOBAL_ATTRIBUTE5
330 , MSI.GLOBAL_ATTRIBUTE6
331 , MSI.GLOBAL_ATTRIBUTE7
332 , MSI.GLOBAL_ATTRIBUTE8
333 , MSI.GLOBAL_ATTRIBUTE9
334 , MSI.GLOBAL_ATTRIBUTE10
335 , MSI.GLOBAL_ATTRIBUTE11
336 , MSI.GLOBAL_ATTRIBUTE12
337 , MSI.GLOBAL_ATTRIBUTE13
338 , MSI.GLOBAL_ATTRIBUTE14
339 , MSI.GLOBAL_ATTRIBUTE15
340 , MSI.GLOBAL_ATTRIBUTE16
341 , MSI.GLOBAL_ATTRIBUTE17
342 , MSI.GLOBAL_ATTRIBUTE18
343 , MSI.GLOBAL_ATTRIBUTE19
344 , MSI.GLOBAL_ATTRIBUTE20
345 , MSI.CREATION_DATE
346 , MSI.CREATED_BY
347 , MSI.LAST_UPDATE_DATE
348 , MSI.LAST_UPDATED_BY
349 , MSI.LAST_UPDATE_LOGIN
350 , MSI.REQUEST_ID
351 , MSI.PROGRAM_APPLICATION_ID
352 , MSI.PROGRAM_ID
353 , MSI.PROGRAM_UPDATE_DATE
354 , MSI.LIFECYCLE_ID
355 , MSI.CURRENT_PHASE_ID
356 , MSI.VMI_MINIMUM_UNITS
357 , MSI.VMI_MINIMUM_DAYS
358 , MSI.VMI_MAXIMUM_UNITS
359 , MSI.VMI_MAXIMUM_DAYS
360 , MSI.VMI_FIXED_ORDER_QUANTITY
361 , MSI.SO_AUTHORIZATION_FLAG
362 , MSI.CONSIGNED_FLAG
363 , MSI.ASN_AUTOEXPIRE_FLAG
364 , MSI.VMI_FORECAST_TYPE
365 , MSI.FORECAST_HORIZON
366 , MSI.EXCLUDE_FROM_BUDGET_FLAG
367 , MSI.DAYS_TGT_INV_SUPPLY
368 , MSI.DAYS_TGT_INV_WINDOW
369 , MSI.DAYS_MAX_INV_SUPPLY
370 , MSI.DAYS_MAX_INV_WINDOW
371 , MSI.DRP_PLANNED_FLAG
372 , MSI.CRITICAL_COMPONENT_FLAG
373 , MSI.CONTINOUS_TRANSFER
374 , MSI.CONVERGENCE
375 , MSI.DIVERGENCE
376 /* Start Bug 3713912 */
380 MSI.CHILD_LOT_FLAG ,
377 , MSI.LOT_DIVISIBLE_FLAG ,
378 MSI.GRADE_CONTROL_FLAG ,
379 MSI.DEFAULT_GRADE ,
381 MSI.PARENT_CHILD_GENERATION_FLAG ,
382 MSI.CHILD_LOT_PREFIX ,
383 MSI.CHILD_LOT_STARTING_NUMBER ,
384 MSI.CHILD_LOT_VALIDATION_FLAG ,
385 MSI.COPY_LOT_ATTRIBUTE_FLAG ,
386 MSI.RECIPE_ENABLED_FLAG ,
387 MSI.PROCESS_QUALITY_ENABLED_FLAG ,
388 MSI.PROCESS_EXECUTION_ENABLED_FLAG ,
389 MSI.PROCESS_COSTING_ENABLED_FLAG ,
390 MSI.PROCESS_SUPPLY_SUBINVENTORY ,
391 MSI.PROCESS_SUPPLY_LOCATOR_ID,
392 MSI.PROCESS_YIELD_SUBINVENTORY ,
393 MSI.PROCESS_YIELD_LOCATOR_ID,
394 MSI.HAZARDOUS_MATERIAL_FLAG ,
395 MSI.CAS_NUMBER ,
396 MSI.RETEST_INTERVAL ,
397 MSI.EXPIRATION_ACTION_INTERVAL ,
398 MSI.EXPIRATION_ACTION_CODE ,
399 MSI.MATURITY_DAYS ,
400 MSI.HOLD_DAYS ,
401 MSI.ATTRIBUTE16 ,
402 MSI.ATTRIBUTE17 ,
403 MSI.ATTRIBUTE18 ,
404 MSI.ATTRIBUTE19 ,
405 MSI.ATTRIBUTE20 ,
406 MSI.ATTRIBUTE21 ,
407 MSI.ATTRIBUTE22 ,
408 MSI.ATTRIBUTE23 ,
409 MSI.ATTRIBUTE24 ,
410 MSI.ATTRIBUTE25 ,
411 MSI.ATTRIBUTE26 ,
412 MSI.ATTRIBUTE27 ,
413 MSI.ATTRIBUTE28 ,
414 MSI.ATTRIBUTE29 ,
415 MSI.ATTRIBUTE30
416 /* End Bug 3713912 */
417 --Added for R12 ENH
418 , MSI.CHARGE_PERIODICITY_CODE
419 , MSI.REPAIR_LEADTIME
420 , MSI.REPAIR_YIELD
421 , MSI.PREPOSITION_POINT
422 , MSI.REPAIR_PROGRAM
423 , MSI.SUBCONTRACTING_COMPONENT
424 , MSI.OUTSOURCED_ASSEMBLY
425 -- Fix for Bug#6644711
426 ,MSI.DEFAULT_MATERIAL_STATUS_ID
427 -- Serial_Tagging Enh -- bug 9913552
428 ,MSI.SERIAL_TAGGING_FLAG
429 FROM
430 MTL_SYSTEM_ITEMS_B MSI
431 , MTL_PARAMETERS MP1
432 WHERE
433 INVENTORY_ITEM_ID = p_Item_ID
434 AND MSI.ORGANIZATION_ID = MP1.ORGANIZATION_ID
435 AND ( ( p_fetch_Master = g_TRUE AND MSI.ORGANIZATION_ID = p_Org_ID ) OR
436 ( p_fetch_Orgs = g_TRUE AND
437 MSI.ORGANIZATION_ID IN
438 ( SELECT MP2.ORGANIZATION_ID
439 FROM MTL_PARAMETERS MP2
440 WHERE MP2.MASTER_ORGANIZATION_ID = p_Org_ID
441 AND MP2.ORGANIZATION_ID <> p_Org_ID
442 )
443 )
444 )
445 ORDER BY DECODE( MSI.ORGANIZATION_ID, MP1.MASTER_ORGANIZATION_ID, 1, 2 ) ASC
446 FOR UPDATE OF INVENTORY_ITEM_ID NOWAIT;
447 --
448 -- End of Org Item_B cursor
449
450
451 -- Org Item_TL cursor
452 --
453 CURSOR Item_TL_csr
454 (
455 p_Item_ID IN NUMBER
456 , p_Org_ID IN NUMBER
457 , p_fetch_Master IN VARCHAR2 := g_TRUE
458 , p_fetch_Orgs IN VARCHAR2 := g_FALSE
459 , p_restrict_Lang IN VARCHAR2 := g_FALSE
460 )
461 RETURN Item_TL_rec_type
462 IS
463 SELECT
464 INVENTORY_ITEM_ID
465 , ORGANIZATION_ID
466 , LANGUAGE
467 , SOURCE_LANG
468 , DESCRIPTION
469 , LONG_DESCRIPTION
470 , CREATION_DATE
471 , CREATED_BY
472 , LAST_UPDATE_DATE
473 , LAST_UPDATED_BY
474 , LAST_UPDATE_LOGIN
475 FROM
476 MTL_SYSTEM_ITEMS_TL
477 WHERE
478 INVENTORY_ITEM_ID = p_Item_ID
479 AND ( ( p_fetch_Master = g_TRUE AND ORGANIZATION_ID = p_Org_ID ) OR
480 ( p_fetch_Orgs = g_TRUE AND
481 ORGANIZATION_ID IN
482 ( SELECT ORGANIZATION_ID
483 FROM MTL_PARAMETERS
484 WHERE MASTER_ORGANIZATION_ID = p_Org_ID
485 AND ORGANIZATION_ID <> p_Org_ID
486 )
487 )
488 )
489 AND ( p_restrict_Lang = g_FALSE OR
490 userenv('LANG') IN ( LANGUAGE, SOURCE_LANG )
491 )
492 FOR UPDATE OF INVENTORY_ITEM_ID NOWAIT;
493 --
494 -- End of Org Item_TL cursor
495
496
497 -- Item attributes cursor
498 --
499 CURSOR Item_Attribute_csr
500 RETURN Item_Attribute_rec_type
501 IS
502 SELECT SUBSTR(ATTRIBUTE_NAME,18) Attribute_Code
503 , ATTRIBUTE_NAME
504 , USER_ATTRIBUTE_NAME_GUI
505 , ATTRIBUTE_GROUP_ID_GUI
506 , SEQUENCE_GUI
507 , DATA_TYPE
508 , VALIDATION_CODE
509 , MANDATORY_FLAG
510 , CONTROL_LEVEL
511 , LEVEL_UPDATEABLE_FLAG
512 , STATUS_CONTROL_CODE
513 , LAST_UPDATE_DATE
514 , LAST_UPDATED_BY
515 , CREATION_DATE
516 , CREATED_BY
517 , LAST_UPDATE_LOGIN
518 FROM
519 MTL_ITEM_ATTRIBUTES;
520 --
521 -- End of Item attributes cursor
522
523
524 -- =============================================================================
525 -- Procedures
526 -- =============================================================================
527
528 /*----------------------------- Update_Item_Row ------------------------------*/
529
530 PROCEDURE Update_Item_Row
531 (
532 p_Item_rec IN Item_rec_type
533 , p_update_Item_TL IN BOOLEAN
534 , p_Lang_Flag IN VARCHAR2
535 , x_return_status OUT NOCOPY VARCHAR2
536 )
537 IS
541 -- l_return_status VARCHAR2(1);
538 -- l_Item_ID NUMBER;
539 -- l_Org_ID NUMBER;
540
542
543 l_SERVICE_ITEM_FLAG VARCHAR2(1);
544 l_VENDOR_WARRANTY_FLAG VARCHAR2(1);
545 l_USAGE_ITEM_FLAG VARCHAR2(1);
546 l_Primary_Unit_of_Measure VARCHAR2(2000);
547 BEGIN
548
549 -- l_Item_ID := p_Item_rec.INVENTORY_ITEM_ID;
550 -- l_Org_ID := p_Item_rec.ORGANIZATION_ID;
551
552 -- Get derived attribute values.
553
554 -- Service Item, Warranty, Usage flag attributes are dependent on
555 -- and derived from Contract Item Type; supported for view only.
556
557 IF ( p_Item_rec.CONTRACT_ITEM_TYPE_CODE = 'SERVICE' ) THEN
558 l_SERVICE_ITEM_FLAG := 'Y';
559 l_VENDOR_WARRANTY_FLAG := 'N';
560 l_USAGE_ITEM_FLAG := NULL;
561 ELSIF ( p_Item_rec.CONTRACT_ITEM_TYPE_CODE = 'WARRANTY' ) THEN
562 l_SERVICE_ITEM_FLAG := 'Y';
563 l_VENDOR_WARRANTY_FLAG := 'Y';
564 l_USAGE_ITEM_FLAG := NULL;
565 ELSIF ( p_Item_rec.CONTRACT_ITEM_TYPE_CODE = 'USAGE' ) THEN
566 l_SERVICE_ITEM_FLAG := 'N';
567 l_VENDOR_WARRANTY_FLAG := 'N';
568 l_USAGE_ITEM_FLAG := 'Y';
569 ELSE
570 l_SERVICE_ITEM_FLAG := 'N';
571 l_VENDOR_WARRANTY_FLAG := 'N';
575 -------------------------------------------------------------------
572 l_USAGE_ITEM_FLAG := NULL;
573 END IF;
574
576 -- Update item row in the base table at Item_csr cursor position --
577 -------------------------------------------------------------------
578 -- Bug: 2801185 Primary_Unit_of_Measure lookup
579
580 SELECT unit_of_measure --5192495 Reverted the Bug 4465182 Select translated unit of measure value
581 INTO l_Primary_Unit_of_Measure
582 FROM mtl_units_of_measure_vl
583 WHERE uom_code = P_Item_Rec.PRIMARY_UOM_CODE;
584
585 UPDATE MTL_SYSTEM_ITEMS_B
586 SET
587 -- Update DESCRIPTION in the base table (MSI_B) only
588 -- if current language is the base language.
589 --
590 DESCRIPTION = DECODE( p_Lang_Flag,
591 'B', trim(p_Item_rec.DESCRIPTION),
592 DESCRIPTION )
593 , PRIMARY_UOM_CODE = p_Item_rec.PRIMARY_UOM_CODE
594 , PRIMARY_UNIT_OF_MEASURE = l_Primary_Unit_of_Measure --Bug: 2801185
595 , ITEM_TYPE = p_Item_rec.ITEM_TYPE
596 , INVENTORY_ITEM_STATUS_CODE = p_Item_rec.INVENTORY_ITEM_STATUS_CODE
597 , ALLOWED_UNITS_LOOKUP_CODE = p_Item_rec.ALLOWED_UNITS_LOOKUP_CODE
598 , ITEM_CATALOG_GROUP_ID = p_Item_rec.ITEM_CATALOG_GROUP_ID
599 , CATALOG_STATUS_FLAG = p_Item_rec.CATALOG_STATUS_FLAG
600 , INVENTORY_ITEM_FLAG = p_Item_rec.INVENTORY_ITEM_FLAG
601 , STOCK_ENABLED_FLAG = p_Item_rec.STOCK_ENABLED_FLAG
602 , MTL_TRANSACTIONS_ENABLED_FLAG = p_Item_rec.MTL_TRANSACTIONS_ENABLED_FLAG
603 , CHECK_SHORTAGES_FLAG = p_Item_rec.CHECK_SHORTAGES_FLAG
604 , REVISION_QTY_CONTROL_CODE = p_Item_rec.REVISION_QTY_CONTROL_CODE
605 , RESERVABLE_TYPE = p_Item_rec.RESERVABLE_TYPE
606 , SHELF_LIFE_CODE = case when p_Item_rec.LOT_CONTROL_CODE = 1 then 1 else p_Item_rec.SHELF_LIFE_CODE end
607 , SHELF_LIFE_DAYS = case when (p_Item_rec.LOT_CONTROL_CODE = 1) or (p_Item_rec.SHELF_LIFE_CODE = 1 or p_Item_rec.SHELF_LIFE_CODE is null) then 0 else p_Item_rec.SHELF_LIFE_DAYS end
608 , CYCLE_COUNT_ENABLED_FLAG = p_Item_rec.CYCLE_COUNT_ENABLED_FLAG
609 , NEGATIVE_MEASUREMENT_ERROR = p_Item_rec.NEGATIVE_MEASUREMENT_ERROR
610 , POSITIVE_MEASUREMENT_ERROR = p_Item_rec.POSITIVE_MEASUREMENT_ERROR
611 , LOT_CONTROL_CODE = p_Item_rec.LOT_CONTROL_CODE
612 , AUTO_LOT_ALPHA_PREFIX = p_Item_rec.AUTO_LOT_ALPHA_PREFIX
613 , START_AUTO_LOT_NUMBER = p_Item_rec.START_AUTO_LOT_NUMBER
614 , SERIAL_NUMBER_CONTROL_CODE = p_Item_rec.SERIAL_NUMBER_CONTROL_CODE
615 , AUTO_SERIAL_ALPHA_PREFIX = p_Item_rec.AUTO_SERIAL_ALPHA_PREFIX
616 , START_AUTO_SERIAL_NUMBER = p_Item_rec.START_AUTO_SERIAL_NUMBER
617 , LOCATION_CONTROL_CODE = p_Item_rec.LOCATION_CONTROL_CODE
618 , RESTRICT_SUBINVENTORIES_CODE = p_Item_rec.RESTRICT_SUBINVENTORIES_CODE
619 , RESTRICT_LOCATORS_CODE = p_Item_rec.RESTRICT_LOCATORS_CODE
620 , BOM_ENABLED_FLAG = p_Item_rec.BOM_ENABLED_FLAG
621 , BOM_ITEM_TYPE = p_Item_rec.BOM_ITEM_TYPE
622 , BASE_ITEM_ID = p_Item_rec.BASE_ITEM_ID
623 , EFFECTIVITY_CONTROL = p_Item_rec.EFFECTIVITY_CONTROL
624 , ENG_ITEM_FLAG = p_Item_rec.ENG_ITEM_FLAG
625 , ENGINEERING_ECN_CODE = p_Item_rec.ENGINEERING_ECN_CODE
626 , ENGINEERING_ITEM_ID = p_Item_rec.ENGINEERING_ITEM_ID
627 , ENGINEERING_DATE = p_Item_rec.ENGINEERING_DATE
628 , PRODUCT_FAMILY_ITEM_ID = p_Item_rec.PRODUCT_FAMILY_ITEM_ID
629 , AUTO_CREATED_CONFIG_FLAG = p_Item_rec.AUTO_CREATED_CONFIG_FLAG
630 , MODEL_CONFIG_CLAUSE_NAME = p_Item_rec.MODEL_CONFIG_CLAUSE_NAME
631 -- Attribute not in the form
632 , NEW_REVISION_CODE = p_Item_rec.NEW_REVISION_CODE
633 , COSTING_ENABLED_FLAG = p_Item_rec.COSTING_ENABLED_FLAG
634 , INVENTORY_ASSET_FLAG = p_Item_rec.INVENTORY_ASSET_FLAG
635 , DEFAULT_INCLUDE_IN_ROLLUP_FLAG = p_Item_rec.DEFAULT_INCLUDE_IN_ROLLUP_FLAG
636 , COST_OF_SALES_ACCOUNT = p_Item_rec.COST_OF_SALES_ACCOUNT
637 , STD_LOT_SIZE = p_Item_rec.STD_LOT_SIZE
638 , PURCHASING_ITEM_FLAG = p_Item_rec.PURCHASING_ITEM_FLAG
639 , PURCHASING_ENABLED_FLAG = p_Item_rec.PURCHASING_ENABLED_FLAG
640 , MUST_USE_APPROVED_VENDOR_FLAG = p_Item_rec.MUST_USE_APPROVED_VENDOR_FLAG
641 , ALLOW_ITEM_DESC_UPDATE_FLAG = p_Item_rec.ALLOW_ITEM_DESC_UPDATE_FLAG
642 , RFQ_REQUIRED_FLAG = p_Item_rec.RFQ_REQUIRED_FLAG
643 , OUTSIDE_OPERATION_FLAG = p_Item_rec.OUTSIDE_OPERATION_FLAG
644 , OUTSIDE_OPERATION_UOM_TYPE = p_Item_rec.OUTSIDE_OPERATION_UOM_TYPE
645 , TAXABLE_FLAG = p_Item_rec.TAXABLE_FLAG
646 , PURCHASING_TAX_CODE = p_Item_rec.PURCHASING_TAX_CODE
647 , RECEIPT_REQUIRED_FLAG = p_Item_rec.RECEIPT_REQUIRED_FLAG
648 , INSPECTION_REQUIRED_FLAG = p_Item_rec.INSPECTION_REQUIRED_FLAG
649 , BUYER_ID = p_Item_rec.BUYER_ID
650 , UNIT_OF_ISSUE = p_Item_rec.UNIT_OF_ISSUE
651 , RECEIVE_CLOSE_TOLERANCE = p_Item_rec.RECEIVE_CLOSE_TOLERANCE
652 , INVOICE_CLOSE_TOLERANCE = p_Item_rec.INVOICE_CLOSE_TOLERANCE
653 , UN_NUMBER_ID = p_Item_rec.UN_NUMBER_ID
654 , HAZARD_CLASS_ID = p_Item_rec.HAZARD_CLASS_ID
655 , LIST_PRICE_PER_UNIT = p_Item_rec.LIST_PRICE_PER_UNIT
656 , MARKET_PRICE = p_Item_rec.MARKET_PRICE
657 , PRICE_TOLERANCE_PERCENT = p_Item_rec.PRICE_TOLERANCE_PERCENT
658 , ROUNDING_FACTOR = p_Item_rec.ROUNDING_FACTOR
659 , ENCUMBRANCE_ACCOUNT = p_Item_rec.ENCUMBRANCE_ACCOUNT
660 , EXPENSE_ACCOUNT = p_Item_rec.EXPENSE_ACCOUNT
661 , ASSET_CATEGORY_ID = p_Item_rec.ASSET_CATEGORY_ID
665 , ALLOW_SUBSTITUTE_RECEIPTS_FLAG = p_Item_rec.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
662 , RECEIPT_DAYS_EXCEPTION_CODE = p_Item_rec.RECEIPT_DAYS_EXCEPTION_CODE
663 , DAYS_EARLY_RECEIPT_ALLOWED = p_Item_rec.DAYS_EARLY_RECEIPT_ALLOWED
664 , DAYS_LATE_RECEIPT_ALLOWED = p_Item_rec.DAYS_LATE_RECEIPT_ALLOWED
666 , ALLOW_UNORDERED_RECEIPTS_FLAG = p_Item_rec.ALLOW_UNORDERED_RECEIPTS_FLAG
667 , ALLOW_EXPRESS_DELIVERY_FLAG = p_Item_rec.ALLOW_EXPRESS_DELIVERY_FLAG
668 , QTY_RCV_EXCEPTION_CODE = p_Item_rec.QTY_RCV_EXCEPTION_CODE
669 , QTY_RCV_TOLERANCE = p_Item_rec.QTY_RCV_TOLERANCE
670 , RECEIVING_ROUTING_ID = p_Item_rec.RECEIVING_ROUTING_ID
671 , ENFORCE_SHIP_TO_LOCATION_CODE = p_Item_rec.ENFORCE_SHIP_TO_LOCATION_CODE
672 , WEIGHT_UOM_CODE = p_Item_rec.WEIGHT_UOM_CODE
673 , UNIT_WEIGHT = p_Item_rec.UNIT_WEIGHT
674 , VOLUME_UOM_CODE = p_Item_rec.VOLUME_UOM_CODE
675 , UNIT_VOLUME = p_Item_rec.UNIT_VOLUME
676 , CONTAINER_ITEM_FLAG = p_Item_rec.CONTAINER_ITEM_FLAG
677 , VEHICLE_ITEM_FLAG = p_Item_rec.VEHICLE_ITEM_FLAG
678 , CONTAINER_TYPE_CODE = p_Item_rec.CONTAINER_TYPE_CODE
679 , INTERNAL_VOLUME = p_Item_rec.INTERNAL_VOLUME
680 , MAXIMUM_LOAD_WEIGHT = p_Item_rec.MAXIMUM_LOAD_WEIGHT
681 , MINIMUM_FILL_PERCENT = p_Item_rec.MINIMUM_FILL_PERCENT
682 , INVENTORY_PLANNING_CODE = p_Item_rec.INVENTORY_PLANNING_CODE
683 , PLANNER_CODE = p_Item_rec.PLANNER_CODE
684 , PLANNING_MAKE_BUY_CODE = p_Item_rec.PLANNING_MAKE_BUY_CODE
685 , MIN_MINMAX_QUANTITY = p_Item_rec.MIN_MINMAX_QUANTITY
686 , MAX_MINMAX_QUANTITY = p_Item_rec.MAX_MINMAX_QUANTITY
687 , MINIMUM_ORDER_QUANTITY = p_Item_rec.MINIMUM_ORDER_QUANTITY
688 , MAXIMUM_ORDER_QUANTITY = p_Item_rec.MAXIMUM_ORDER_QUANTITY
689 , ORDER_COST = p_Item_rec.ORDER_COST
690 , CARRYING_COST = p_Item_rec.CARRYING_COST
691 , SOURCE_TYPE = p_Item_rec.SOURCE_TYPE
692 , SOURCE_ORGANIZATION_ID = case when (p_Item_rec.source_type is null) or (p_Item_rec.source_type = 2) then null else p_Item_rec.SOURCE_ORGANIZATION_ID end
693 , SOURCE_SUBINVENTORY = case when (p_Item_rec.source_type is null) or (p_Item_rec.source_type = 2) then null else p_Item_rec.SOURCE_SUBINVENTORY end
694 , MRP_SAFETY_STOCK_CODE = p_Item_rec.MRP_SAFETY_STOCK_CODE
695 , SAFETY_STOCK_BUCKET_DAYS = p_Item_rec.SAFETY_STOCK_BUCKET_DAYS
696 , MRP_SAFETY_STOCK_PERCENT = p_Item_rec.MRP_SAFETY_STOCK_PERCENT
697 , FIXED_ORDER_QUANTITY = p_Item_rec.FIXED_ORDER_QUANTITY
698 , FIXED_DAYS_SUPPLY = p_Item_rec.FIXED_DAYS_SUPPLY
699 , FIXED_LOT_MULTIPLIER = p_Item_rec.FIXED_LOT_MULTIPLIER
700 , MRP_PLANNING_CODE = p_Item_rec.MRP_PLANNING_CODE
701 , ATO_FORECAST_CONTROL = p_Item_rec.ATO_FORECAST_CONTROL
702 , PLANNING_EXCEPTION_SET = p_Item_rec.PLANNING_EXCEPTION_SET
703 , END_ASSEMBLY_PEGGING_FLAG = p_Item_rec.END_ASSEMBLY_PEGGING_FLAG
704 , SHRINKAGE_RATE = p_Item_rec.SHRINKAGE_RATE
705 , ROUNDING_CONTROL_TYPE = p_Item_rec.ROUNDING_CONTROL_TYPE
706 , ACCEPTABLE_EARLY_DAYS = p_Item_rec.ACCEPTABLE_EARLY_DAYS
707 , REPETITIVE_PLANNING_FLAG = p_Item_rec.REPETITIVE_PLANNING_FLAG
708 , OVERRUN_PERCENTAGE = p_Item_rec.OVERRUN_PERCENTAGE
709 , ACCEPTABLE_RATE_INCREASE = p_Item_rec.ACCEPTABLE_RATE_INCREASE
710 , ACCEPTABLE_RATE_DECREASE = p_Item_rec.ACCEPTABLE_RATE_DECREASE
711 , MRP_CALCULATE_ATP_FLAG = p_Item_rec.MRP_CALCULATE_ATP_FLAG
712 , AUTO_REDUCE_MPS = p_Item_rec.AUTO_REDUCE_MPS
713 , PLANNING_TIME_FENCE_CODE = p_Item_rec.PLANNING_TIME_FENCE_CODE
714 , PLANNING_TIME_FENCE_DAYS = p_Item_rec.PLANNING_TIME_FENCE_DAYS
715 , DEMAND_TIME_FENCE_CODE = p_Item_rec.DEMAND_TIME_FENCE_CODE
716 , DEMAND_TIME_FENCE_DAYS = p_Item_rec.DEMAND_TIME_FENCE_DAYS
717 , RELEASE_TIME_FENCE_CODE = p_Item_rec.RELEASE_TIME_FENCE_CODE
718 , RELEASE_TIME_FENCE_DAYS = p_Item_rec.RELEASE_TIME_FENCE_DAYS
719 , PREPROCESSING_LEAD_TIME = p_Item_rec.PREPROCESSING_LEAD_TIME
720 , FULL_LEAD_TIME = p_Item_rec.FULL_LEAD_TIME
721 , POSTPROCESSING_LEAD_TIME = p_Item_rec.POSTPROCESSING_LEAD_TIME
722 , FIXED_LEAD_TIME = p_Item_rec.FIXED_LEAD_TIME
723 , VARIABLE_LEAD_TIME = p_Item_rec.VARIABLE_LEAD_TIME
724 , CUM_MANUFACTURING_LEAD_TIME = p_Item_rec.CUM_MANUFACTURING_LEAD_TIME
725 , CUMULATIVE_TOTAL_LEAD_TIME = p_Item_rec.CUMULATIVE_TOTAL_LEAD_TIME
726 , LEAD_TIME_LOT_SIZE = p_Item_rec.LEAD_TIME_LOT_SIZE
727 , BUILD_IN_WIP_FLAG = p_Item_rec.BUILD_IN_WIP_FLAG
728 , WIP_SUPPLY_TYPE = p_Item_rec.WIP_SUPPLY_TYPE
729 , WIP_SUPPLY_SUBINVENTORY = p_Item_rec.WIP_SUPPLY_SUBINVENTORY
730 , WIP_SUPPLY_LOCATOR_ID = p_Item_rec.WIP_SUPPLY_LOCATOR_ID
731 , OVERCOMPLETION_TOLERANCE_TYPE = p_Item_rec.OVERCOMPLETION_TOLERANCE_TYPE
732 , OVERCOMPLETION_TOLERANCE_VALUE = p_Item_rec.OVERCOMPLETION_TOLERANCE_VALUE
733 , CUSTOMER_ORDER_FLAG = p_Item_rec.CUSTOMER_ORDER_FLAG
734 , CUSTOMER_ORDER_ENABLED_FLAG = p_Item_rec.CUSTOMER_ORDER_ENABLED_FLAG
735 , SHIPPABLE_ITEM_FLAG = p_Item_rec.SHIPPABLE_ITEM_FLAG
736 , INTERNAL_ORDER_FLAG = p_Item_rec.INTERNAL_ORDER_FLAG
737 , INTERNAL_ORDER_ENABLED_FLAG = p_Item_rec.INTERNAL_ORDER_ENABLED_FLAG
738 , SO_TRANSACTIONS_FLAG = p_Item_rec.SO_TRANSACTIONS_FLAG
739 , PICK_COMPONENTS_FLAG = p_Item_rec.PICK_COMPONENTS_FLAG
740 , ATP_FLAG = p_Item_rec.ATP_FLAG
741 , REPLENISH_TO_ORDER_FLAG = p_Item_rec.REPLENISH_TO_ORDER_FLAG
742 , ATP_RULE_ID = p_Item_rec.ATP_RULE_ID
746 , COLLATERAL_FLAG = p_Item_rec.COLLATERAL_FLAG
743 , ATP_COMPONENTS_FLAG = p_Item_rec.ATP_COMPONENTS_FLAG
744 , SHIP_MODEL_COMPLETE_FLAG = p_Item_rec.SHIP_MODEL_COMPLETE_FLAG
745 , PICKING_RULE_ID = p_Item_rec.PICKING_RULE_ID
747 , DEFAULT_SHIPPING_ORG = p_Item_rec.DEFAULT_SHIPPING_ORG
748 , RETURNABLE_FLAG = p_Item_rec.RETURNABLE_FLAG
749 , RETURN_INSPECTION_REQUIREMENT = p_Item_rec.RETURN_INSPECTION_REQUIREMENT
750 , OVER_SHIPMENT_TOLERANCE = p_Item_rec.OVER_SHIPMENT_TOLERANCE
751 , UNDER_SHIPMENT_TOLERANCE = p_Item_rec.UNDER_SHIPMENT_TOLERANCE
752 , OVER_RETURN_TOLERANCE = p_Item_rec.OVER_RETURN_TOLERANCE
753 , UNDER_RETURN_TOLERANCE = p_Item_rec.UNDER_RETURN_TOLERANCE
754 , INVOICEABLE_ITEM_FLAG = p_Item_rec.INVOICEABLE_ITEM_FLAG
755 , INVOICE_ENABLED_FLAG = p_Item_rec.INVOICE_ENABLED_FLAG
756 , ACCOUNTING_RULE_ID = p_Item_rec.ACCOUNTING_RULE_ID
757 , INVOICING_RULE_ID = p_Item_rec.INVOICING_RULE_ID
758 , TAX_CODE = p_Item_rec.TAX_CODE
759 , SALES_ACCOUNT = p_Item_rec.SALES_ACCOUNT
760 , PAYMENT_TERMS_ID = p_Item_rec.PAYMENT_TERMS_ID
761 , COVERAGE_SCHEDULE_ID = p_Item_rec.COVERAGE_SCHEDULE_ID
762 , SERVICE_DURATION = p_Item_rec.SERVICE_DURATION
763 , SERVICE_DURATION_PERIOD_CODE = p_Item_rec.SERVICE_DURATION_PERIOD_CODE
764 , SERVICEABLE_PRODUCT_FLAG = p_Item_rec.SERVICEABLE_PRODUCT_FLAG
765 , SERVICE_STARTING_DELAY = p_Item_rec.SERVICE_STARTING_DELAY
766 , MATERIAL_BILLABLE_FLAG = p_Item_rec.MATERIAL_BILLABLE_FLAG
767 , SERVICEABLE_COMPONENT_FLAG = p_Item_rec.SERVICEABLE_COMPONENT_FLAG
768 , PREVENTIVE_MAINTENANCE_FLAG = p_Item_rec.PREVENTIVE_MAINTENANCE_FLAG
769 , PRORATE_SERVICE_FLAG = p_Item_rec.PRORATE_SERVICE_FLAG
770 -- Attribute not in the form
771 , SERVICEABLE_ITEM_CLASS_ID = p_Item_rec.SERVICEABLE_ITEM_CLASS_ID
772 -- Attribute not in the form
773 , BASE_WARRANTY_SERVICE_ID = p_Item_rec.BASE_WARRANTY_SERVICE_ID
774 -- Attribute not in the form
775 , WARRANTY_VENDOR_ID = p_Item_rec.WARRANTY_VENDOR_ID
776 -- Attribute not in the form
777 , MAX_WARRANTY_AMOUNT = p_Item_rec.MAX_WARRANTY_AMOUNT
778 -- Attribute not in the form
779 , RESPONSE_TIME_PERIOD_CODE = p_Item_rec.RESPONSE_TIME_PERIOD_CODE
780 -- Attribute not in the form
781 , RESPONSE_TIME_VALUE = p_Item_rec.RESPONSE_TIME_VALUE
782 -- Attribute not in the form
783 , PRIMARY_SPECIALIST_ID = p_Item_rec.PRIMARY_SPECIALIST_ID
784 -- Attribute not in the form
785 , SECONDARY_SPECIALIST_ID = p_Item_rec.SECONDARY_SPECIALIST_ID
786 , WH_UPDATE_DATE = p_Item_rec.WH_UPDATE_DATE
787 , EQUIPMENT_TYPE = p_Item_rec.EQUIPMENT_TYPE
788 , RECOVERED_PART_DISP_CODE = p_Item_rec.RECOVERED_PART_DISP_CODE
789 , DEFECT_TRACKING_ON_FLAG = p_Item_rec.DEFECT_TRACKING_ON_FLAG
790 , EVENT_FLAG = p_Item_rec.EVENT_FLAG
791 , ELECTRONIC_FLAG = p_Item_rec.ELECTRONIC_FLAG
792 , DOWNLOADABLE_FLAG = p_Item_rec.DOWNLOADABLE_FLAG
793 , VOL_DISCOUNT_EXEMPT_FLAG = p_Item_rec.VOL_DISCOUNT_EXEMPT_FLAG
794 , COUPON_EXEMPT_FLAG = p_Item_rec.COUPON_EXEMPT_FLAG
795 , COMMS_NL_TRACKABLE_FLAG = p_Item_rec.COMMS_NL_TRACKABLE_FLAG
796 , ASSET_CREATION_CODE = p_Item_rec.ASSET_CREATION_CODE
797 , COMMS_ACTIVATION_REQD_FLAG = p_Item_rec.COMMS_ACTIVATION_REQD_FLAG
798 , ORDERABLE_ON_WEB_FLAG = p_Item_rec.ORDERABLE_ON_WEB_FLAG
799 , BACK_ORDERABLE_FLAG = p_Item_rec.BACK_ORDERABLE_FLAG
800 , WEB_STATUS = p_Item_rec.WEB_STATUS
801 , INDIVISIBLE_FLAG = p_Item_rec.INDIVISIBLE_FLAG
802 , DIMENSION_UOM_CODE = p_Item_rec.DIMENSION_UOM_CODE
803 , UNIT_LENGTH = p_Item_rec.UNIT_LENGTH
804 , UNIT_WIDTH = p_Item_rec.UNIT_WIDTH
805 , UNIT_HEIGHT = p_Item_rec.UNIT_HEIGHT
806 , BULK_PICKED_FLAG = p_Item_rec.BULK_PICKED_FLAG
807 , LOT_STATUS_ENABLED = Decode(p_Item_rec.LOT_CONTROL_CODE, 1, 'N', p_Item_rec.LOT_STATUS_ENABLED) --updated by bug 15876766
808 , DEFAULT_LOT_STATUS_ID = Decode(p_Item_rec.LOT_CONTROL_CODE, 1, NULL, p_Item_rec.DEFAULT_LOT_STATUS_ID)
809 , SERIAL_STATUS_ENABLED = p_Item_rec.SERIAL_STATUS_ENABLED
810 , DEFAULT_SERIAL_STATUS_ID = p_Item_rec.DEFAULT_SERIAL_STATUS_ID
811 , LOT_SPLIT_ENABLED = p_Item_rec.LOT_SPLIT_ENABLED
812 , LOT_MERGE_ENABLED = p_Item_rec.LOT_MERGE_ENABLED
813 , INVENTORY_CARRY_PENALTY = p_Item_rec.INVENTORY_CARRY_PENALTY
814 , OPERATION_SLACK_PENALTY = p_Item_rec.OPERATION_SLACK_PENALTY
815 , FINANCING_ALLOWED_FLAG = p_Item_rec.FINANCING_ALLOWED_FLAG
816 , EAM_ITEM_TYPE = p_Item_rec.EAM_ITEM_TYPE
817 , EAM_ACTIVITY_TYPE_CODE = p_Item_rec.EAM_ACTIVITY_TYPE_CODE
818 , EAM_ACTIVITY_CAUSE_CODE = p_Item_rec.EAM_ACTIVITY_CAUSE_CODE
819 , EAM_ACT_NOTIFICATION_FLAG = p_Item_rec.EAM_ACT_NOTIFICATION_FLAG
820 , EAM_ACT_SHUTDOWN_STATUS = p_Item_rec.EAM_ACT_SHUTDOWN_STATUS
821 , DUAL_UOM_CONTROL = p_Item_rec.DUAL_UOM_CONTROL
822 , SECONDARY_UOM_CODE = p_Item_rec.SECONDARY_UOM_CODE
823 , DUAL_UOM_DEVIATION_HIGH = p_Item_rec.DUAL_UOM_DEVIATION_HIGH
824 , DUAL_UOM_DEVIATION_LOW = p_Item_rec.DUAL_UOM_DEVIATION_LOW
825 -- Derived Service attributes
826 , SERVICE_ITEM_FLAG = l_SERVICE_ITEM_FLAG
827 , VENDOR_WARRANTY_FLAG = l_VENDOR_WARRANTY_FLAG
828 , USAGE_ITEM_FLAG = l_USAGE_ITEM_FLAG
829 --
830 , CONTRACT_ITEM_TYPE_CODE = p_Item_rec.CONTRACT_ITEM_TYPE_CODE
834 , SERV_IMPORTANCE_LEVEL = p_Item_rec.SERV_IMPORTANCE_LEVEL
831 , SUBSCRIPTION_DEPEND_FLAG = p_Item_rec.SUBSCRIPTION_DEPEND_FLAG
832 , SERV_REQ_ENABLED_CODE = p_Item_rec.SERV_REQ_ENABLED_CODE
833 , SERV_BILLING_ENABLED_FLAG = p_Item_rec.SERV_BILLING_ENABLED_FLAG
835 , PLANNED_INV_POINT_FLAG = p_Item_rec.PLANNED_INV_POINT_FLAG
836 , LOT_TRANSLATE_ENABLED = p_Item_rec.LOT_TRANSLATE_ENABLED
837 , DEFAULT_SO_SOURCE_TYPE = p_Item_rec.DEFAULT_SO_SOURCE_TYPE
838 , CREATE_SUPPLY_FLAG = p_Item_rec.CREATE_SUPPLY_FLAG
839 , SUBSTITUTION_WINDOW_CODE = p_Item_rec.SUBSTITUTION_WINDOW_CODE
840 , SUBSTITUTION_WINDOW_DAYS = p_Item_rec.SUBSTITUTION_WINDOW_DAYS
841 , IB_ITEM_INSTANCE_CLASS = p_Item_rec.IB_ITEM_INSTANCE_CLASS
842 , CONFIG_MODEL_TYPE = p_Item_rec.CONFIG_MODEL_TYPE
843 --ADDED as part of 11.5.9 ENH
844 , LOT_SUBSTITUTION_ENABLED = Decode(p_Item_rec.LOT_CONTROL_CODE, 1, NULL, p_Item_rec.LOT_SUBSTITUTION_ENABLED)
845 , MINIMUM_LICENSE_QUANTITY = p_Item_rec.MINIMUM_LICENSE_QUANTITY
846 , EAM_ACTIVITY_SOURCE_CODE = p_Item_rec.EAM_ACTIVITY_SOURCE_CODE
847 --ADDED as part of 11.5.10 ENH
848 , TRACKING_QUANTITY_IND = p_Item_rec.TRACKING_QUANTITY_IND
849 , ONT_PRICING_QTY_SOURCE = p_Item_rec.ONT_PRICING_QTY_SOURCE
850 , SECONDARY_DEFAULT_IND = p_Item_rec.SECONDARY_DEFAULT_IND
851 , OPTION_SPECIFIC_SOURCED = p_Item_rec.OPTION_SPECIFIC_SOURCED
852 , CONFIG_ORGS = p_Item_rec.CONFIG_ORGS
853 , CONFIG_MATCH = p_Item_rec.CONFIG_MATCH
854 , SEGMENT1 = p_Item_rec.SEGMENT1
855 , SEGMENT2 = p_Item_rec.SEGMENT2
856 , SEGMENT3 = p_Item_rec.SEGMENT3
857 , SEGMENT4 = p_Item_rec.SEGMENT4
858 , SEGMENT5 = p_Item_rec.SEGMENT5
859 , SEGMENT6 = p_Item_rec.SEGMENT6
860 , SEGMENT7 = p_Item_rec.SEGMENT7
861 , SEGMENT8 = p_Item_rec.SEGMENT8
862 , SEGMENT9 = p_Item_rec.SEGMENT9
863 , SEGMENT10 = p_Item_rec.SEGMENT10
864 , SEGMENT11 = p_Item_rec.SEGMENT11
865 , SEGMENT12 = p_Item_rec.SEGMENT12
866 , SEGMENT13 = p_Item_rec.SEGMENT13
867 , SEGMENT14 = p_Item_rec.SEGMENT14
868 , SEGMENT15 = p_Item_rec.SEGMENT15
869 , SEGMENT16 = p_Item_rec.SEGMENT16
870 , SEGMENT17 = p_Item_rec.SEGMENT17
871 , SEGMENT18 = p_Item_rec.SEGMENT18
872 , SEGMENT19 = p_Item_rec.SEGMENT19
873 , SEGMENT20 = p_Item_rec.SEGMENT20
874 , SUMMARY_FLAG = p_Item_rec.SUMMARY_FLAG
875 , ENABLED_FLAG = p_Item_rec.ENABLED_FLAG
876 , START_DATE_ACTIVE = p_Item_rec.START_DATE_ACTIVE
877 , END_DATE_ACTIVE = p_Item_rec.END_DATE_ACTIVE
878 , ATTRIBUTE_CATEGORY = p_Item_rec.ATTRIBUTE_CATEGORY
879 , ATTRIBUTE1 = p_Item_rec.ATTRIBUTE1
880 , ATTRIBUTE2 = p_Item_rec.ATTRIBUTE2
881 , ATTRIBUTE3 = p_Item_rec.ATTRIBUTE3
882 , ATTRIBUTE4 = p_Item_rec.ATTRIBUTE4
883 , ATTRIBUTE5 = p_Item_rec.ATTRIBUTE5
884 , ATTRIBUTE6 = p_Item_rec.ATTRIBUTE6
885 , ATTRIBUTE7 = p_Item_rec.ATTRIBUTE7
886 , ATTRIBUTE8 = p_Item_rec.ATTRIBUTE8
887 , ATTRIBUTE9 = p_Item_rec.ATTRIBUTE9
888 , ATTRIBUTE10 = p_Item_rec.ATTRIBUTE10
889 , ATTRIBUTE11 = p_Item_rec.ATTRIBUTE11
890 , ATTRIBUTE12 = p_Item_rec.ATTRIBUTE12
891 , ATTRIBUTE13 = p_Item_rec.ATTRIBUTE13
892 , ATTRIBUTE14 = p_Item_rec.ATTRIBUTE14
893 , ATTRIBUTE15 = p_Item_rec.ATTRIBUTE15
894 , GLOBAL_ATTRIBUTE_CATEGORY = p_Item_rec.GLOBAL_ATTRIBUTE_CATEGORY
895 , GLOBAL_ATTRIBUTE1 = p_Item_rec.GLOBAL_ATTRIBUTE1
896 , GLOBAL_ATTRIBUTE2 = p_Item_rec.GLOBAL_ATTRIBUTE2
897 , GLOBAL_ATTRIBUTE3 = p_Item_rec.GLOBAL_ATTRIBUTE3
898 , GLOBAL_ATTRIBUTE4 = p_Item_rec.GLOBAL_ATTRIBUTE4
899 , GLOBAL_ATTRIBUTE5 = p_Item_rec.GLOBAL_ATTRIBUTE5
900 , GLOBAL_ATTRIBUTE6 = p_Item_rec.GLOBAL_ATTRIBUTE6
901 , GLOBAL_ATTRIBUTE7 = p_Item_rec.GLOBAL_ATTRIBUTE7
902 , GLOBAL_ATTRIBUTE8 = p_Item_rec.GLOBAL_ATTRIBUTE8
903 , GLOBAL_ATTRIBUTE9 = p_Item_rec.GLOBAL_ATTRIBUTE9
904 , GLOBAL_ATTRIBUTE10 = p_Item_rec.GLOBAL_ATTRIBUTE10
905 , GLOBAL_ATTRIBUTE11 = p_Item_rec.GLOBAL_ATTRIBUTE11
906 , GLOBAL_ATTRIBUTE12 = p_Item_rec.GLOBAL_ATTRIBUTE12
907 , GLOBAL_ATTRIBUTE13 = p_Item_rec.GLOBAL_ATTRIBUTE13
908 , GLOBAL_ATTRIBUTE14 = p_Item_rec.GLOBAL_ATTRIBUTE14
909 , GLOBAL_ATTRIBUTE15 = p_Item_rec.GLOBAL_ATTRIBUTE15
910 , GLOBAL_ATTRIBUTE16 = p_Item_rec.GLOBAL_ATTRIBUTE16
911 , GLOBAL_ATTRIBUTE17 = p_Item_rec.GLOBAL_ATTRIBUTE17
912 , GLOBAL_ATTRIBUTE18 = p_Item_rec.GLOBAL_ATTRIBUTE18
913 , GLOBAL_ATTRIBUTE19 = p_Item_rec.GLOBAL_ATTRIBUTE19
914 , GLOBAL_ATTRIBUTE20 = p_Item_rec.GLOBAL_ATTRIBUTE20
915 -- Do not update CREATE info
916 -- , CREATION_DATE = p_Item_rec.CREATION_DATE
917 -- , CREATED_BY = p_Item_rec.CREATED_BY
918 --
919 , LAST_UPDATE_DATE = p_Item_rec.LAST_UPDATE_DATE
920 , LAST_UPDATED_BY = p_Item_rec.LAST_UPDATED_BY
924 , PROGRAM_ID = p_Item_rec.PROGRAM_ID
921 , LAST_UPDATE_LOGIN = p_Item_rec.LAST_UPDATE_LOGIN
922 , REQUEST_ID = p_Item_rec.REQUEST_ID
923 , PROGRAM_APPLICATION_ID = p_Item_rec.PROGRAM_APPLICATION_ID
925 , PROGRAM_UPDATE_DATE = p_Item_rec.PROGRAM_UPDATE_DATE
926 ,VMI_MINIMUM_UNITS = P_item_rec.VMI_MINIMUM_UNITS
927 ,VMI_MINIMUM_DAYS = P_item_rec.VMI_MINIMUM_DAYS
928 ,VMI_MAXIMUM_UNITS = P_item_rec.VMI_MAXIMUM_UNITS
929 ,VMI_MAXIMUM_DAYS = P_item_rec.VMI_MAXIMUM_DAYS
930 ,VMI_FIXED_ORDER_QUANTITY = P_item_rec.VMI_FIXED_ORDER_QUANTITY
931 ,SO_AUTHORIZATION_FLAG = P_item_rec.SO_AUTHORIZATION_FLAG
932 ,CONSIGNED_FLAG = P_item_rec.CONSIGNED_FLAG
933 ,ASN_AUTOEXPIRE_FLAG = P_item_rec.ASN_AUTOEXPIRE_FLAG
934 ,VMI_FORECAST_TYPE = P_item_rec.VMI_FORECAST_TYPE
935 ,FORECAST_HORIZON = P_item_rec.FORECAST_HORIZON
936 ,EXCLUDE_FROM_BUDGET_FLAG = P_item_rec.EXCLUDE_FROM_BUDGET_FLAG
937 ,DAYS_TGT_INV_SUPPLY = P_item_rec.DAYS_TGT_INV_SUPPLY
938 ,DAYS_TGT_INV_WINDOW = P_item_rec.DAYS_TGT_INV_WINDOW
939 ,DAYS_MAX_INV_SUPPLY = P_item_rec.DAYS_MAX_INV_SUPPLY
940 ,DAYS_MAX_INV_WINDOW = P_item_rec.DAYS_MAX_INV_WINDOW
941 ,DRP_PLANNED_FLAG = P_item_rec.DRP_PLANNED_FLAG
942 ,CRITICAL_COMPONENT_FLAG = P_item_rec.CRITICAL_COMPONENT_FLAG
943 ,CONTINOUS_TRANSFER = P_item_rec.CONTINOUS_TRANSFER
944 ,CONVERGENCE = P_item_rec.CONVERGENCE
945 ,DIVERGENCE = P_item_rec.DIVERGENCE
946 /* Start Bug 3713912 */
947 , LOT_DIVISIBLE_FLAG = Decode(p_Item_rec.LOT_CONTROL_CODE, 1, 'N', p_Item_rec.LOT_DIVISIBLE_FLAG) --updated by bug 15876766
948 , GRADE_CONTROL_FLAG = P_item_rec.GRADE_CONTROL_FLAG
949 , DEFAULT_GRADE = P_item_rec.DEFAULT_GRADE
950 , CHILD_LOT_FLAG = P_item_rec.CHILD_LOT_FLAG
951 , PARENT_CHILD_GENERATION_FLAG = P_item_rec.PARENT_CHILD_GENERATION_FLAG
952 , CHILD_LOT_PREFIX = P_item_rec.CHILD_LOT_PREFIX
953 , CHILD_LOT_STARTING_NUMBER = P_item_rec.CHILD_LOT_STARTING_NUMBER
954 , CHILD_LOT_VALIDATION_FLAG = P_item_rec.CHILD_LOT_VALIDATION_FLAG
955 , COPY_LOT_ATTRIBUTE_FLAG = P_item_rec.COPY_LOT_ATTRIBUTE_FLAG
956 , RECIPE_ENABLED_FLAG = P_item_rec.RECIPE_ENABLED_FLAG
957 , PROCESS_QUALITY_ENABLED_FLAG = P_item_rec.PROCESS_QUALITY_ENABLED_FLAG
958 , PROCESS_EXECUTION_ENABLED_FLAG = P_item_rec.PROCESS_EXECUTION_ENABLED_FLAG
959 , PROCESS_COSTING_ENABLED_FLAG = P_item_rec.PROCESS_COSTING_ENABLED_FLAG
960 , PROCESS_SUPPLY_SUBINVENTORY = P_item_rec.PROCESS_SUPPLY_SUBINVENTORY
961 , PROCESS_SUPPLY_LOCATOR_ID = P_item_rec.PROCESS_SUPPLY_LOCATOR_ID
962 , PROCESS_YIELD_SUBINVENTORY = P_item_rec.PROCESS_YIELD_SUBINVENTORY
963 , PROCESS_YIELD_LOCATOR_ID = P_item_rec.PROCESS_YIELD_LOCATOR_ID
964 , HAZARDOUS_MATERIAL_FLAG = P_item_rec.HAZARDOUS_MATERIAL_FLAG
965 , CAS_NUMBER = P_item_rec.CAS_NUMBER
966 , RETEST_INTERVAL = P_item_rec.RETEST_INTERVAL
967 , EXPIRATION_ACTION_INTERVAL = P_item_rec.EXPIRATION_ACTION_INTERVAL
968 , EXPIRATION_ACTION_CODE = P_item_rec.EXPIRATION_ACTION_CODE
969 , MATURITY_DAYS = P_item_rec.MATURITY_DAYS
970 , HOLD_DAYS = P_item_rec.HOLD_DAYS
971 , ATTRIBUTE16 = P_item_rec.ATTRIBUTE16
972 , ATTRIBUTE17 = P_item_rec.ATTRIBUTE17
973 , ATTRIBUTE18 = P_item_rec.ATTRIBUTE18
974 , ATTRIBUTE19 = P_item_rec.ATTRIBUTE19
975 , ATTRIBUTE20 = P_item_rec.ATTRIBUTE20
976 , ATTRIBUTE21 = P_item_rec.ATTRIBUTE21
977 , ATTRIBUTE22 = P_item_rec.ATTRIBUTE22
978 , ATTRIBUTE23 = P_item_rec.ATTRIBUTE23
979 , ATTRIBUTE24 = P_item_rec.ATTRIBUTE24
980 , ATTRIBUTE25 = P_item_rec.ATTRIBUTE25
981 , ATTRIBUTE26 = P_item_rec.ATTRIBUTE26
982 , ATTRIBUTE27 = P_item_rec.ATTRIBUTE27
983 , ATTRIBUTE28 = P_item_rec.ATTRIBUTE28
984 , ATTRIBUTE29 = P_item_rec.ATTRIBUTE29
985 , ATTRIBUTE30 = P_item_rec.ATTRIBUTE30
986 /* End Bug 3713912 */
987 --Added for R12 ENH
988 , CHARGE_PERIODICITY_CODE = p_Item_rec.CHARGE_PERIODICITY_CODE
989 , REPAIR_LEADTIME = p_Item_rec.REPAIR_LEADTIME
990 , REPAIR_YIELD = p_Item_rec.REPAIR_YIELD
991 , PREPOSITION_POINT = p_Item_rec.PREPOSITION_POINT
992 , REPAIR_PROGRAM = p_Item_rec.REPAIR_PROGRAM
993 , SUBCONTRACTING_COMPONENT = p_Item_rec.SUBCONTRACTING_COMPONENT
994 , OUTSOURCED_ASSEMBLY = p_Item_rec.OUTSOURCED_ASSEMBLY
995 -- Fix for Bug#6644711
996 , DEFAULT_MATERIAL_STATUS_ID = p_Item_rec.DEFAULT_MATERIAL_STATUS_ID
997 /* Bug 4224512 Updating the object version number - Anmurali */
998 , OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,1)+1
999 -- Serial_Tagging Enh -- bug 9913552
1000 , SERIAL_TAGGING_FLAG = p_Item_rec.SERIAL_TAGGING_FLAG
1001 WHERE
1002 CURRENT OF Item_csr;
1003
1004 /*
1005 WHERE
1006 INVENTORY_ITEM_ID = l_Item_ID
1007 AND ORGANIZATION_ID = l_Org_ID;
1008
1009 IF ( SQL%NOTFOUND ) THEN
1010 -- RAISE no_data_found;
1011 x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1012 FND_MESSAGE.Set_Name ('INV', 'INV_Update_Item_Row_notfound');
1013 FND_MSG_PUB.Add;
1014 RETURN;
1015 END IF;
1016 */
1017
1018 ------------------------------------------------------------
1022 IF ( p_update_Item_TL ) THEN
1019 -- Update item translation rows in the translations table --
1020 ------------------------------------------------------------
1021
1023
1024 BEGIN -- Update block
1025
1026 -- Do not validate Item and Org IDs since p_Item_rec is fetched
1027
1028 UPDATE MTL_SYSTEM_ITEMS_TL
1029 SET
1030 DESCRIPTION = NVL(trim(p_Item_rec.DESCRIPTION),DESCRIPTION) --Bug 4416173
1031 , LONG_DESCRIPTION = trim(p_Item_rec.LONG_DESCRIPTION)
1032 , LAST_UPDATE_DATE = p_Item_rec.LAST_UPDATE_DATE
1033 , LAST_UPDATED_BY = p_Item_rec.LAST_UPDATED_BY
1034 , LAST_UPDATE_LOGIN = p_Item_rec.LAST_UPDATE_LOGIN
1035 , SOURCE_LANG = userenv('LANG')
1036 WHERE
1037 INVENTORY_ITEM_ID = p_Item_rec.INVENTORY_ITEM_ID
1038 AND ORGANIZATION_ID = p_Item_rec.ORGANIZATION_ID
1039 -- AND userenv('LANG') IN ( LANGUAGE, SOURCE_LANG ); -- bug 14599786 for first issue
1040 AND userenv('LANG') IN ( SOURCE_LANG ); --LANGUAGE
1041
1042 END; -- Update block
1043
1044 END IF; -- Update translated item rows
1045 ---------------------------------------
1046
1047 x_return_status := FND_API.g_RET_STS_SUCCESS;
1048
1049 END Update_Item_Row;
1050
1051
1052 /*---------------------------- Update_Item_TL_Row ----------------------------*/
1053
1054 -- Currently not used
1055 /*
1056 PROCEDURE Update_Item_TL_Row
1057 (
1058 p_Item_TL_rec IN Item_TL_rec_type
1059 , x_return_status OUT VARCHAR2
1060 )
1061 IS
1062 BEGIN
1063
1064 -- Update translated item row at Item_TL_csr cursor position
1065 --
1066 UPDATE MTL_SYSTEM_ITEMS_TL
1067 SET
1068 DESCRIPTION = p_Item_TL_rec.DESCRIPTION
1069 , LONG_DESCRIPTION = p_Item_TL_rec.LONG_DESCRIPTION
1070 , LAST_UPDATE_DATE = p_Item_TL_rec.LAST_UPDATE_DATE
1071 , LAST_UPDATED_BY = p_Item_TL_rec.LAST_UPDATED_BY
1072 , LAST_UPDATE_LOGIN = p_Item_TL_rec.LAST_UPDATE_LOGIN
1073 --
1074 -- , SOURCE_LANG = p_Item_TL_rec.SOURCE_LANG
1075 --
1076 -- Always use current language when updating item translation rows
1077 , SOURCE_LANG = userenv('LANG')
1078 WHERE
1079 CURRENT OF Item_TL_csr;
1080
1081 x_return_status := FND_API.g_RET_STS_SUCCESS;
1082
1083 END Update_Item_TL_Row;
1084 */
1085
1086
1087 -- -------------------- To_Boolchar ---------------------
1088
1089 -- Currently not used
1090 /*
1091 FUNCTION To_Boolchar
1092 (
1093 p_bool IN BOOLEAN
1094 )
1095 RETURN VARCHAR2
1096 IS
1097 l_api_name CONSTANT VARCHAR2(30) := 'To_Boolchar';
1098 BEGIN
1099
1100 IF ( p_bool = TRUE ) THEN
1101 RETURN FND_API.g_TRUE;
1102 ELSIF ( p_bool = FALSE ) THEN
1103 RETURN FND_API.g_FALSE;
1104 ELSE
1105
1106 FND_MSG_PUB.Add_Exc_Msg
1107 ( p_pkg_name => G_PKG_NAME
1108 , p_procedure_name => l_api_name
1109 -- , p_error_text => 'Unrecognized parameter value : p_bool='
1110 );
1111 -- RETURN NULL;
1112
1113 RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1114
1115 END IF;
1116
1117 END To_Boolchar;
1118 */
1119
1120
1121 END INV_ITEM_API;