[Home] [Help]
PACKAGE BODY: APPS.INV_ITEM_API
Source
1 PACKAGE BODY INV_ITEM_API AS
2 /* $Header: INVVIPIB.pls 120.7.12010000.2 2008/11/20 00:22:30 akbharga ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ITEM_API';
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
69 , MSI.MODEL_CONFIG_CLAUSE_NAME
70 , MSI.NEW_REVISION_CODE
71 , MSI.COSTING_ENABLED_FLAG
72 , MSI.INVENTORY_ASSET_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
217 , MSI.EQUIPMENT_TYPE
218 , MSI.RECOVERED_PART_DISP_CODE
219 , MSI.DEFECT_TRACKING_ON_FLAG
220 , MSI.EVENT_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 */
377 , MSI.LOT_DIVISIBLE_FLAG ,
378 MSI.GRADE_CONTROL_FLAG ,
379 MSI.DEFAULT_GRADE ,
380 MSI.CHILD_LOT_FLAG ,
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 FROM
428 MTL_SYSTEM_ITEMS_B MSI
429 , MTL_PARAMETERS MP1
430 WHERE
431 INVENTORY_ITEM_ID = p_Item_ID
432 AND MSI.ORGANIZATION_ID = MP1.ORGANIZATION_ID
433 AND ( ( p_fetch_Master = g_TRUE AND MSI.ORGANIZATION_ID = p_Org_ID ) OR
434 ( p_fetch_Orgs = g_TRUE AND
435 MSI.ORGANIZATION_ID IN
436 ( SELECT MP2.ORGANIZATION_ID
437 FROM MTL_PARAMETERS MP2
438 WHERE MP2.MASTER_ORGANIZATION_ID = p_Org_ID
439 AND MP2.ORGANIZATION_ID <> p_Org_ID
440 )
441 )
442 )
443 ORDER BY DECODE( MSI.ORGANIZATION_ID, MP1.MASTER_ORGANIZATION_ID, 1, 2 ) ASC
444 FOR UPDATE OF INVENTORY_ITEM_ID NOWAIT;
445 --
446 -- End of Org Item_B cursor
447
448
452 (
449 -- Org Item_TL cursor
450 --
451 CURSOR Item_TL_csr
453 p_Item_ID IN NUMBER
454 , p_Org_ID IN NUMBER
455 , p_fetch_Master IN VARCHAR2 := g_TRUE
456 , p_fetch_Orgs IN VARCHAR2 := g_FALSE
457 , p_restrict_Lang IN VARCHAR2 := g_FALSE
458 )
459 RETURN Item_TL_rec_type
460 IS
461 SELECT
462 INVENTORY_ITEM_ID
463 , ORGANIZATION_ID
464 , LANGUAGE
465 , SOURCE_LANG
466 , DESCRIPTION
467 , LONG_DESCRIPTION
468 , CREATION_DATE
469 , CREATED_BY
470 , LAST_UPDATE_DATE
471 , LAST_UPDATED_BY
472 , LAST_UPDATE_LOGIN
473 FROM
474 MTL_SYSTEM_ITEMS_TL
475 WHERE
476 INVENTORY_ITEM_ID = p_Item_ID
477 AND ( ( p_fetch_Master = g_TRUE AND ORGANIZATION_ID = p_Org_ID ) OR
478 ( p_fetch_Orgs = g_TRUE AND
479 ORGANIZATION_ID IN
480 ( SELECT ORGANIZATION_ID
481 FROM MTL_PARAMETERS
482 WHERE MASTER_ORGANIZATION_ID = p_Org_ID
483 AND ORGANIZATION_ID <> p_Org_ID
484 )
485 )
486 )
487 AND ( p_restrict_Lang = g_FALSE OR
488 userenv('LANG') IN ( LANGUAGE, SOURCE_LANG )
489 )
490 FOR UPDATE OF INVENTORY_ITEM_ID NOWAIT;
491 --
492 -- End of Org Item_TL cursor
493
494
495 -- Item attributes cursor
496 --
497 CURSOR Item_Attribute_csr
498 RETURN Item_Attribute_rec_type
499 IS
500 SELECT SUBSTR(ATTRIBUTE_NAME,18) Attribute_Code
501 , ATTRIBUTE_NAME
502 , USER_ATTRIBUTE_NAME_GUI
503 , ATTRIBUTE_GROUP_ID_GUI
504 , SEQUENCE_GUI
505 , DATA_TYPE
506 , VALIDATION_CODE
507 , MANDATORY_FLAG
508 , CONTROL_LEVEL
509 , LEVEL_UPDATEABLE_FLAG
510 , STATUS_CONTROL_CODE
511 , LAST_UPDATE_DATE
512 , LAST_UPDATED_BY
513 , CREATION_DATE
514 , CREATED_BY
515 , LAST_UPDATE_LOGIN
516 FROM
517 MTL_ITEM_ATTRIBUTES;
518 --
519 -- End of Item attributes cursor
520
521
522 -- =============================================================================
523 -- Procedures
524 -- =============================================================================
525
526 /*----------------------------- Update_Item_Row ------------------------------*/
527
528 PROCEDURE Update_Item_Row
529 (
530 p_Item_rec IN Item_rec_type
531 , p_update_Item_TL IN BOOLEAN
532 , p_Lang_Flag IN VARCHAR2
533 , x_return_status OUT NOCOPY VARCHAR2
534 )
535 IS
536 -- l_Item_ID NUMBER;
537 -- l_Org_ID NUMBER;
538
539 -- l_return_status VARCHAR2(1);
540
541 l_SERVICE_ITEM_FLAG VARCHAR2(1);
542 l_VENDOR_WARRANTY_FLAG VARCHAR2(1);
543 l_USAGE_ITEM_FLAG VARCHAR2(1);
544 l_Primary_Unit_of_Measure VARCHAR2(2000);
545 BEGIN
546
547 -- l_Item_ID := p_Item_rec.INVENTORY_ITEM_ID;
548 -- l_Org_ID := p_Item_rec.ORGANIZATION_ID;
549
550 -- Get derived attribute values.
551
552 -- Service Item, Warranty, Usage flag attributes are dependent on
553 -- and derived from Contract Item Type; supported for view only.
554
555 IF ( p_Item_rec.CONTRACT_ITEM_TYPE_CODE = 'SERVICE' ) THEN
556 l_SERVICE_ITEM_FLAG := 'Y';
557 l_VENDOR_WARRANTY_FLAG := 'N';
558 l_USAGE_ITEM_FLAG := NULL;
559 ELSIF ( p_Item_rec.CONTRACT_ITEM_TYPE_CODE = 'WARRANTY' ) THEN
560 l_SERVICE_ITEM_FLAG := 'Y';
561 l_VENDOR_WARRANTY_FLAG := 'Y';
562 l_USAGE_ITEM_FLAG := NULL;
563 ELSIF ( p_Item_rec.CONTRACT_ITEM_TYPE_CODE = 'USAGE' ) THEN
564 l_SERVICE_ITEM_FLAG := 'N';
565 l_VENDOR_WARRANTY_FLAG := 'N';
566 l_USAGE_ITEM_FLAG := 'Y';
567 ELSE
568 l_SERVICE_ITEM_FLAG := 'N';
569 l_VENDOR_WARRANTY_FLAG := 'N';
570 l_USAGE_ITEM_FLAG := NULL;
571 END IF;
572
573 -------------------------------------------------------------------
574 -- Update item row in the base table at Item_csr cursor position --
575 -------------------------------------------------------------------
576 -- Bug: 2801185 Primary_Unit_of_Measure lookup
577
578 SELECT unit_of_measure --5192495 Reverted the Bug 4465182 Select translated unit of measure value
579 INTO l_Primary_Unit_of_Measure
580 FROM mtl_units_of_measure_vl
581 WHERE uom_code = P_Item_Rec.PRIMARY_UOM_CODE;
582
583 UPDATE MTL_SYSTEM_ITEMS_B
584 SET
585 -- Update DESCRIPTION in the base table (MSI_B) only
586 -- if current language is the base language.
587 --
588 DESCRIPTION = DECODE( p_Lang_Flag,
589 'B', trim(p_Item_rec.DESCRIPTION),
590 DESCRIPTION )
591 , PRIMARY_UOM_CODE = p_Item_rec.PRIMARY_UOM_CODE
592 , PRIMARY_UNIT_OF_MEASURE = l_Primary_Unit_of_Measure --Bug: 2801185
593 , ITEM_TYPE = p_Item_rec.ITEM_TYPE
594 , INVENTORY_ITEM_STATUS_CODE = p_Item_rec.INVENTORY_ITEM_STATUS_CODE
595 , ALLOWED_UNITS_LOOKUP_CODE = p_Item_rec.ALLOWED_UNITS_LOOKUP_CODE
596 , ITEM_CATALOG_GROUP_ID = p_Item_rec.ITEM_CATALOG_GROUP_ID
597 , CATALOG_STATUS_FLAG = p_Item_rec.CATALOG_STATUS_FLAG
601 , CHECK_SHORTAGES_FLAG = p_Item_rec.CHECK_SHORTAGES_FLAG
598 , INVENTORY_ITEM_FLAG = p_Item_rec.INVENTORY_ITEM_FLAG
599 , STOCK_ENABLED_FLAG = p_Item_rec.STOCK_ENABLED_FLAG
600 , MTL_TRANSACTIONS_ENABLED_FLAG = p_Item_rec.MTL_TRANSACTIONS_ENABLED_FLAG
602 , REVISION_QTY_CONTROL_CODE = p_Item_rec.REVISION_QTY_CONTROL_CODE
603 , RESERVABLE_TYPE = p_Item_rec.RESERVABLE_TYPE
604 , SHELF_LIFE_CODE = p_Item_rec.SHELF_LIFE_CODE
605 , SHELF_LIFE_DAYS = p_Item_rec.SHELF_LIFE_DAYS
606 , CYCLE_COUNT_ENABLED_FLAG = p_Item_rec.CYCLE_COUNT_ENABLED_FLAG
607 , NEGATIVE_MEASUREMENT_ERROR = p_Item_rec.NEGATIVE_MEASUREMENT_ERROR
608 , POSITIVE_MEASUREMENT_ERROR = p_Item_rec.POSITIVE_MEASUREMENT_ERROR
609 , LOT_CONTROL_CODE = p_Item_rec.LOT_CONTROL_CODE
610 , AUTO_LOT_ALPHA_PREFIX = p_Item_rec.AUTO_LOT_ALPHA_PREFIX
611 , START_AUTO_LOT_NUMBER = p_Item_rec.START_AUTO_LOT_NUMBER
612 , SERIAL_NUMBER_CONTROL_CODE = p_Item_rec.SERIAL_NUMBER_CONTROL_CODE
613 , AUTO_SERIAL_ALPHA_PREFIX = p_Item_rec.AUTO_SERIAL_ALPHA_PREFIX
614 , START_AUTO_SERIAL_NUMBER = p_Item_rec.START_AUTO_SERIAL_NUMBER
615 , LOCATION_CONTROL_CODE = p_Item_rec.LOCATION_CONTROL_CODE
616 , RESTRICT_SUBINVENTORIES_CODE = p_Item_rec.RESTRICT_SUBINVENTORIES_CODE
617 , RESTRICT_LOCATORS_CODE = p_Item_rec.RESTRICT_LOCATORS_CODE
618 , BOM_ENABLED_FLAG = p_Item_rec.BOM_ENABLED_FLAG
619 , BOM_ITEM_TYPE = p_Item_rec.BOM_ITEM_TYPE
620 , BASE_ITEM_ID = p_Item_rec.BASE_ITEM_ID
621 , EFFECTIVITY_CONTROL = p_Item_rec.EFFECTIVITY_CONTROL
622 , ENG_ITEM_FLAG = p_Item_rec.ENG_ITEM_FLAG
623 , ENGINEERING_ECN_CODE = p_Item_rec.ENGINEERING_ECN_CODE
624 , ENGINEERING_ITEM_ID = p_Item_rec.ENGINEERING_ITEM_ID
625 , ENGINEERING_DATE = p_Item_rec.ENGINEERING_DATE
626 , PRODUCT_FAMILY_ITEM_ID = p_Item_rec.PRODUCT_FAMILY_ITEM_ID
627 , AUTO_CREATED_CONFIG_FLAG = p_Item_rec.AUTO_CREATED_CONFIG_FLAG
628 , MODEL_CONFIG_CLAUSE_NAME = p_Item_rec.MODEL_CONFIG_CLAUSE_NAME
629 -- Attribute not in the form
630 , NEW_REVISION_CODE = p_Item_rec.NEW_REVISION_CODE
631 , COSTING_ENABLED_FLAG = p_Item_rec.COSTING_ENABLED_FLAG
632 , INVENTORY_ASSET_FLAG = p_Item_rec.INVENTORY_ASSET_FLAG
633 , DEFAULT_INCLUDE_IN_ROLLUP_FLAG = p_Item_rec.DEFAULT_INCLUDE_IN_ROLLUP_FLAG
634 , COST_OF_SALES_ACCOUNT = p_Item_rec.COST_OF_SALES_ACCOUNT
635 , STD_LOT_SIZE = p_Item_rec.STD_LOT_SIZE
636 , PURCHASING_ITEM_FLAG = p_Item_rec.PURCHASING_ITEM_FLAG
637 , PURCHASING_ENABLED_FLAG = p_Item_rec.PURCHASING_ENABLED_FLAG
638 , MUST_USE_APPROVED_VENDOR_FLAG = p_Item_rec.MUST_USE_APPROVED_VENDOR_FLAG
639 , ALLOW_ITEM_DESC_UPDATE_FLAG = p_Item_rec.ALLOW_ITEM_DESC_UPDATE_FLAG
640 , RFQ_REQUIRED_FLAG = p_Item_rec.RFQ_REQUIRED_FLAG
641 , OUTSIDE_OPERATION_FLAG = p_Item_rec.OUTSIDE_OPERATION_FLAG
642 , OUTSIDE_OPERATION_UOM_TYPE = p_Item_rec.OUTSIDE_OPERATION_UOM_TYPE
643 , TAXABLE_FLAG = p_Item_rec.TAXABLE_FLAG
644 , PURCHASING_TAX_CODE = p_Item_rec.PURCHASING_TAX_CODE
645 , RECEIPT_REQUIRED_FLAG = p_Item_rec.RECEIPT_REQUIRED_FLAG
646 , INSPECTION_REQUIRED_FLAG = p_Item_rec.INSPECTION_REQUIRED_FLAG
647 , BUYER_ID = p_Item_rec.BUYER_ID
648 , UNIT_OF_ISSUE = p_Item_rec.UNIT_OF_ISSUE
649 , RECEIVE_CLOSE_TOLERANCE = p_Item_rec.RECEIVE_CLOSE_TOLERANCE
650 , INVOICE_CLOSE_TOLERANCE = p_Item_rec.INVOICE_CLOSE_TOLERANCE
651 , UN_NUMBER_ID = p_Item_rec.UN_NUMBER_ID
652 , HAZARD_CLASS_ID = p_Item_rec.HAZARD_CLASS_ID
653 , LIST_PRICE_PER_UNIT = p_Item_rec.LIST_PRICE_PER_UNIT
654 , MARKET_PRICE = p_Item_rec.MARKET_PRICE
655 , PRICE_TOLERANCE_PERCENT = p_Item_rec.PRICE_TOLERANCE_PERCENT
656 , ROUNDING_FACTOR = p_Item_rec.ROUNDING_FACTOR
657 , ENCUMBRANCE_ACCOUNT = p_Item_rec.ENCUMBRANCE_ACCOUNT
658 , EXPENSE_ACCOUNT = p_Item_rec.EXPENSE_ACCOUNT
659 , ASSET_CATEGORY_ID = p_Item_rec.ASSET_CATEGORY_ID
660 , RECEIPT_DAYS_EXCEPTION_CODE = p_Item_rec.RECEIPT_DAYS_EXCEPTION_CODE
661 , DAYS_EARLY_RECEIPT_ALLOWED = p_Item_rec.DAYS_EARLY_RECEIPT_ALLOWED
662 , DAYS_LATE_RECEIPT_ALLOWED = p_Item_rec.DAYS_LATE_RECEIPT_ALLOWED
663 , ALLOW_SUBSTITUTE_RECEIPTS_FLAG = p_Item_rec.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
664 , ALLOW_UNORDERED_RECEIPTS_FLAG = p_Item_rec.ALLOW_UNORDERED_RECEIPTS_FLAG
665 , ALLOW_EXPRESS_DELIVERY_FLAG = p_Item_rec.ALLOW_EXPRESS_DELIVERY_FLAG
666 , QTY_RCV_EXCEPTION_CODE = p_Item_rec.QTY_RCV_EXCEPTION_CODE
667 , QTY_RCV_TOLERANCE = p_Item_rec.QTY_RCV_TOLERANCE
668 , RECEIVING_ROUTING_ID = p_Item_rec.RECEIVING_ROUTING_ID
669 , ENFORCE_SHIP_TO_LOCATION_CODE = p_Item_rec.ENFORCE_SHIP_TO_LOCATION_CODE
670 , WEIGHT_UOM_CODE = p_Item_rec.WEIGHT_UOM_CODE
671 , UNIT_WEIGHT = p_Item_rec.UNIT_WEIGHT
672 , VOLUME_UOM_CODE = p_Item_rec.VOLUME_UOM_CODE
673 , UNIT_VOLUME = p_Item_rec.UNIT_VOLUME
674 , CONTAINER_ITEM_FLAG = p_Item_rec.CONTAINER_ITEM_FLAG
675 , VEHICLE_ITEM_FLAG = p_Item_rec.VEHICLE_ITEM_FLAG
676 , CONTAINER_TYPE_CODE = p_Item_rec.CONTAINER_TYPE_CODE
677 , INTERNAL_VOLUME = p_Item_rec.INTERNAL_VOLUME
678 , MAXIMUM_LOAD_WEIGHT = p_Item_rec.MAXIMUM_LOAD_WEIGHT
682 , PLANNING_MAKE_BUY_CODE = p_Item_rec.PLANNING_MAKE_BUY_CODE
679 , MINIMUM_FILL_PERCENT = p_Item_rec.MINIMUM_FILL_PERCENT
680 , INVENTORY_PLANNING_CODE = p_Item_rec.INVENTORY_PLANNING_CODE
681 , PLANNER_CODE = p_Item_rec.PLANNER_CODE
683 , MIN_MINMAX_QUANTITY = p_Item_rec.MIN_MINMAX_QUANTITY
684 , MAX_MINMAX_QUANTITY = p_Item_rec.MAX_MINMAX_QUANTITY
685 , MINIMUM_ORDER_QUANTITY = p_Item_rec.MINIMUM_ORDER_QUANTITY
686 , MAXIMUM_ORDER_QUANTITY = p_Item_rec.MAXIMUM_ORDER_QUANTITY
687 , ORDER_COST = p_Item_rec.ORDER_COST
688 , CARRYING_COST = p_Item_rec.CARRYING_COST
689 , SOURCE_TYPE = p_Item_rec.SOURCE_TYPE
690 , SOURCE_ORGANIZATION_ID = p_Item_rec.SOURCE_ORGANIZATION_ID
691 , SOURCE_SUBINVENTORY = p_Item_rec.SOURCE_SUBINVENTORY
692 , MRP_SAFETY_STOCK_CODE = p_Item_rec.MRP_SAFETY_STOCK_CODE
693 , SAFETY_STOCK_BUCKET_DAYS = p_Item_rec.SAFETY_STOCK_BUCKET_DAYS
694 , MRP_SAFETY_STOCK_PERCENT = p_Item_rec.MRP_SAFETY_STOCK_PERCENT
695 , FIXED_ORDER_QUANTITY = p_Item_rec.FIXED_ORDER_QUANTITY
696 , FIXED_DAYS_SUPPLY = p_Item_rec.FIXED_DAYS_SUPPLY
697 , FIXED_LOT_MULTIPLIER = p_Item_rec.FIXED_LOT_MULTIPLIER
698 , MRP_PLANNING_CODE = p_Item_rec.MRP_PLANNING_CODE
699 , ATO_FORECAST_CONTROL = p_Item_rec.ATO_FORECAST_CONTROL
700 , PLANNING_EXCEPTION_SET = p_Item_rec.PLANNING_EXCEPTION_SET
701 , END_ASSEMBLY_PEGGING_FLAG = p_Item_rec.END_ASSEMBLY_PEGGING_FLAG
702 , SHRINKAGE_RATE = p_Item_rec.SHRINKAGE_RATE
703 , ROUNDING_CONTROL_TYPE = p_Item_rec.ROUNDING_CONTROL_TYPE
704 , ACCEPTABLE_EARLY_DAYS = p_Item_rec.ACCEPTABLE_EARLY_DAYS
705 , REPETITIVE_PLANNING_FLAG = p_Item_rec.REPETITIVE_PLANNING_FLAG
706 , OVERRUN_PERCENTAGE = p_Item_rec.OVERRUN_PERCENTAGE
707 , ACCEPTABLE_RATE_INCREASE = p_Item_rec.ACCEPTABLE_RATE_INCREASE
708 , ACCEPTABLE_RATE_DECREASE = p_Item_rec.ACCEPTABLE_RATE_DECREASE
709 , MRP_CALCULATE_ATP_FLAG = p_Item_rec.MRP_CALCULATE_ATP_FLAG
710 , AUTO_REDUCE_MPS = p_Item_rec.AUTO_REDUCE_MPS
711 , PLANNING_TIME_FENCE_CODE = p_Item_rec.PLANNING_TIME_FENCE_CODE
712 , PLANNING_TIME_FENCE_DAYS = p_Item_rec.PLANNING_TIME_FENCE_DAYS
713 , DEMAND_TIME_FENCE_CODE = p_Item_rec.DEMAND_TIME_FENCE_CODE
714 , DEMAND_TIME_FENCE_DAYS = p_Item_rec.DEMAND_TIME_FENCE_DAYS
715 , RELEASE_TIME_FENCE_CODE = p_Item_rec.RELEASE_TIME_FENCE_CODE
716 , RELEASE_TIME_FENCE_DAYS = p_Item_rec.RELEASE_TIME_FENCE_DAYS
717 , PREPROCESSING_LEAD_TIME = p_Item_rec.PREPROCESSING_LEAD_TIME
718 , FULL_LEAD_TIME = p_Item_rec.FULL_LEAD_TIME
719 , POSTPROCESSING_LEAD_TIME = p_Item_rec.POSTPROCESSING_LEAD_TIME
720 , FIXED_LEAD_TIME = p_Item_rec.FIXED_LEAD_TIME
721 , VARIABLE_LEAD_TIME = p_Item_rec.VARIABLE_LEAD_TIME
722 , CUM_MANUFACTURING_LEAD_TIME = p_Item_rec.CUM_MANUFACTURING_LEAD_TIME
723 , CUMULATIVE_TOTAL_LEAD_TIME = p_Item_rec.CUMULATIVE_TOTAL_LEAD_TIME
724 , LEAD_TIME_LOT_SIZE = p_Item_rec.LEAD_TIME_LOT_SIZE
725 , BUILD_IN_WIP_FLAG = p_Item_rec.BUILD_IN_WIP_FLAG
726 , WIP_SUPPLY_TYPE = p_Item_rec.WIP_SUPPLY_TYPE
727 , WIP_SUPPLY_SUBINVENTORY = p_Item_rec.WIP_SUPPLY_SUBINVENTORY
728 , WIP_SUPPLY_LOCATOR_ID = p_Item_rec.WIP_SUPPLY_LOCATOR_ID
729 , OVERCOMPLETION_TOLERANCE_TYPE = p_Item_rec.OVERCOMPLETION_TOLERANCE_TYPE
730 , OVERCOMPLETION_TOLERANCE_VALUE = p_Item_rec.OVERCOMPLETION_TOLERANCE_VALUE
731 , CUSTOMER_ORDER_FLAG = p_Item_rec.CUSTOMER_ORDER_FLAG
732 , CUSTOMER_ORDER_ENABLED_FLAG = p_Item_rec.CUSTOMER_ORDER_ENABLED_FLAG
733 , SHIPPABLE_ITEM_FLAG = p_Item_rec.SHIPPABLE_ITEM_FLAG
734 , INTERNAL_ORDER_FLAG = p_Item_rec.INTERNAL_ORDER_FLAG
735 , INTERNAL_ORDER_ENABLED_FLAG = p_Item_rec.INTERNAL_ORDER_ENABLED_FLAG
736 , SO_TRANSACTIONS_FLAG = p_Item_rec.SO_TRANSACTIONS_FLAG
737 , PICK_COMPONENTS_FLAG = p_Item_rec.PICK_COMPONENTS_FLAG
738 , ATP_FLAG = p_Item_rec.ATP_FLAG
739 , REPLENISH_TO_ORDER_FLAG = p_Item_rec.REPLENISH_TO_ORDER_FLAG
740 , ATP_RULE_ID = p_Item_rec.ATP_RULE_ID
741 , ATP_COMPONENTS_FLAG = p_Item_rec.ATP_COMPONENTS_FLAG
742 , SHIP_MODEL_COMPLETE_FLAG = p_Item_rec.SHIP_MODEL_COMPLETE_FLAG
743 , PICKING_RULE_ID = p_Item_rec.PICKING_RULE_ID
744 , COLLATERAL_FLAG = p_Item_rec.COLLATERAL_FLAG
745 , DEFAULT_SHIPPING_ORG = p_Item_rec.DEFAULT_SHIPPING_ORG
746 , RETURNABLE_FLAG = p_Item_rec.RETURNABLE_FLAG
747 , RETURN_INSPECTION_REQUIREMENT = p_Item_rec.RETURN_INSPECTION_REQUIREMENT
748 , OVER_SHIPMENT_TOLERANCE = p_Item_rec.OVER_SHIPMENT_TOLERANCE
749 , UNDER_SHIPMENT_TOLERANCE = p_Item_rec.UNDER_SHIPMENT_TOLERANCE
750 , OVER_RETURN_TOLERANCE = p_Item_rec.OVER_RETURN_TOLERANCE
751 , UNDER_RETURN_TOLERANCE = p_Item_rec.UNDER_RETURN_TOLERANCE
752 , INVOICEABLE_ITEM_FLAG = p_Item_rec.INVOICEABLE_ITEM_FLAG
753 , INVOICE_ENABLED_FLAG = p_Item_rec.INVOICE_ENABLED_FLAG
754 , ACCOUNTING_RULE_ID = p_Item_rec.ACCOUNTING_RULE_ID
755 , INVOICING_RULE_ID = p_Item_rec.INVOICING_RULE_ID
756 , TAX_CODE = p_Item_rec.TAX_CODE
760 , SERVICE_DURATION = p_Item_rec.SERVICE_DURATION
757 , SALES_ACCOUNT = p_Item_rec.SALES_ACCOUNT
758 , PAYMENT_TERMS_ID = p_Item_rec.PAYMENT_TERMS_ID
759 , COVERAGE_SCHEDULE_ID = p_Item_rec.COVERAGE_SCHEDULE_ID
761 , SERVICE_DURATION_PERIOD_CODE = p_Item_rec.SERVICE_DURATION_PERIOD_CODE
762 , SERVICEABLE_PRODUCT_FLAG = p_Item_rec.SERVICEABLE_PRODUCT_FLAG
763 , SERVICE_STARTING_DELAY = p_Item_rec.SERVICE_STARTING_DELAY
764 , MATERIAL_BILLABLE_FLAG = p_Item_rec.MATERIAL_BILLABLE_FLAG
765 , SERVICEABLE_COMPONENT_FLAG = p_Item_rec.SERVICEABLE_COMPONENT_FLAG
766 , PREVENTIVE_MAINTENANCE_FLAG = p_Item_rec.PREVENTIVE_MAINTENANCE_FLAG
767 , PRORATE_SERVICE_FLAG = p_Item_rec.PRORATE_SERVICE_FLAG
768 -- Attribute not in the form
769 , SERVICEABLE_ITEM_CLASS_ID = p_Item_rec.SERVICEABLE_ITEM_CLASS_ID
770 -- Attribute not in the form
771 , BASE_WARRANTY_SERVICE_ID = p_Item_rec.BASE_WARRANTY_SERVICE_ID
772 -- Attribute not in the form
773 , WARRANTY_VENDOR_ID = p_Item_rec.WARRANTY_VENDOR_ID
774 -- Attribute not in the form
775 , MAX_WARRANTY_AMOUNT = p_Item_rec.MAX_WARRANTY_AMOUNT
776 -- Attribute not in the form
777 , RESPONSE_TIME_PERIOD_CODE = p_Item_rec.RESPONSE_TIME_PERIOD_CODE
778 -- Attribute not in the form
779 , RESPONSE_TIME_VALUE = p_Item_rec.RESPONSE_TIME_VALUE
780 -- Attribute not in the form
781 , PRIMARY_SPECIALIST_ID = p_Item_rec.PRIMARY_SPECIALIST_ID
782 -- Attribute not in the form
783 , SECONDARY_SPECIALIST_ID = p_Item_rec.SECONDARY_SPECIALIST_ID
784 , WH_UPDATE_DATE = p_Item_rec.WH_UPDATE_DATE
785 , EQUIPMENT_TYPE = p_Item_rec.EQUIPMENT_TYPE
786 , RECOVERED_PART_DISP_CODE = p_Item_rec.RECOVERED_PART_DISP_CODE
787 , DEFECT_TRACKING_ON_FLAG = p_Item_rec.DEFECT_TRACKING_ON_FLAG
788 , EVENT_FLAG = p_Item_rec.EVENT_FLAG
789 , ELECTRONIC_FLAG = p_Item_rec.ELECTRONIC_FLAG
790 , DOWNLOADABLE_FLAG = p_Item_rec.DOWNLOADABLE_FLAG
791 , VOL_DISCOUNT_EXEMPT_FLAG = p_Item_rec.VOL_DISCOUNT_EXEMPT_FLAG
792 , COUPON_EXEMPT_FLAG = p_Item_rec.COUPON_EXEMPT_FLAG
793 , COMMS_NL_TRACKABLE_FLAG = p_Item_rec.COMMS_NL_TRACKABLE_FLAG
794 , ASSET_CREATION_CODE = p_Item_rec.ASSET_CREATION_CODE
795 , COMMS_ACTIVATION_REQD_FLAG = p_Item_rec.COMMS_ACTIVATION_REQD_FLAG
796 , ORDERABLE_ON_WEB_FLAG = p_Item_rec.ORDERABLE_ON_WEB_FLAG
797 , BACK_ORDERABLE_FLAG = p_Item_rec.BACK_ORDERABLE_FLAG
798 , WEB_STATUS = p_Item_rec.WEB_STATUS
799 , INDIVISIBLE_FLAG = p_Item_rec.INDIVISIBLE_FLAG
800 , DIMENSION_UOM_CODE = p_Item_rec.DIMENSION_UOM_CODE
801 , UNIT_LENGTH = p_Item_rec.UNIT_LENGTH
802 , UNIT_WIDTH = p_Item_rec.UNIT_WIDTH
803 , UNIT_HEIGHT = p_Item_rec.UNIT_HEIGHT
804 , BULK_PICKED_FLAG = p_Item_rec.BULK_PICKED_FLAG
805 , LOT_STATUS_ENABLED = p_Item_rec.LOT_STATUS_ENABLED
806 , DEFAULT_LOT_STATUS_ID = p_Item_rec.DEFAULT_LOT_STATUS_ID
807 , SERIAL_STATUS_ENABLED = p_Item_rec.SERIAL_STATUS_ENABLED
808 , DEFAULT_SERIAL_STATUS_ID = p_Item_rec.DEFAULT_SERIAL_STATUS_ID
809 , LOT_SPLIT_ENABLED = p_Item_rec.LOT_SPLIT_ENABLED
810 , LOT_MERGE_ENABLED = p_Item_rec.LOT_MERGE_ENABLED
811 , INVENTORY_CARRY_PENALTY = p_Item_rec.INVENTORY_CARRY_PENALTY
812 , OPERATION_SLACK_PENALTY = p_Item_rec.OPERATION_SLACK_PENALTY
813 , FINANCING_ALLOWED_FLAG = p_Item_rec.FINANCING_ALLOWED_FLAG
814 , EAM_ITEM_TYPE = p_Item_rec.EAM_ITEM_TYPE
815 , EAM_ACTIVITY_TYPE_CODE = p_Item_rec.EAM_ACTIVITY_TYPE_CODE
816 , EAM_ACTIVITY_CAUSE_CODE = p_Item_rec.EAM_ACTIVITY_CAUSE_CODE
817 , EAM_ACT_NOTIFICATION_FLAG = p_Item_rec.EAM_ACT_NOTIFICATION_FLAG
818 , EAM_ACT_SHUTDOWN_STATUS = p_Item_rec.EAM_ACT_SHUTDOWN_STATUS
819 , DUAL_UOM_CONTROL = p_Item_rec.DUAL_UOM_CONTROL
820 , SECONDARY_UOM_CODE = p_Item_rec.SECONDARY_UOM_CODE
821 , DUAL_UOM_DEVIATION_HIGH = p_Item_rec.DUAL_UOM_DEVIATION_HIGH
822 , DUAL_UOM_DEVIATION_LOW = p_Item_rec.DUAL_UOM_DEVIATION_LOW
823 -- Derived Service attributes
824 , SERVICE_ITEM_FLAG = l_SERVICE_ITEM_FLAG
825 , VENDOR_WARRANTY_FLAG = l_VENDOR_WARRANTY_FLAG
826 , USAGE_ITEM_FLAG = l_USAGE_ITEM_FLAG
827 --
828 , CONTRACT_ITEM_TYPE_CODE = p_Item_rec.CONTRACT_ITEM_TYPE_CODE
829 , SUBSCRIPTION_DEPEND_FLAG = p_Item_rec.SUBSCRIPTION_DEPEND_FLAG
830 , SERV_REQ_ENABLED_CODE = p_Item_rec.SERV_REQ_ENABLED_CODE
831 , SERV_BILLING_ENABLED_FLAG = p_Item_rec.SERV_BILLING_ENABLED_FLAG
832 , SERV_IMPORTANCE_LEVEL = p_Item_rec.SERV_IMPORTANCE_LEVEL
833 , PLANNED_INV_POINT_FLAG = p_Item_rec.PLANNED_INV_POINT_FLAG
834 , LOT_TRANSLATE_ENABLED = p_Item_rec.LOT_TRANSLATE_ENABLED
835 , DEFAULT_SO_SOURCE_TYPE = p_Item_rec.DEFAULT_SO_SOURCE_TYPE
836 , CREATE_SUPPLY_FLAG = p_Item_rec.CREATE_SUPPLY_FLAG
837 , SUBSTITUTION_WINDOW_CODE = p_Item_rec.SUBSTITUTION_WINDOW_CODE
838 , SUBSTITUTION_WINDOW_DAYS = p_Item_rec.SUBSTITUTION_WINDOW_DAYS
842 , LOT_SUBSTITUTION_ENABLED = p_Item_rec.LOT_SUBSTITUTION_ENABLED
839 , IB_ITEM_INSTANCE_CLASS = p_Item_rec.IB_ITEM_INSTANCE_CLASS
840 , CONFIG_MODEL_TYPE = p_Item_rec.CONFIG_MODEL_TYPE
841 --ADDED as part of 11.5.9 ENH
843 , MINIMUM_LICENSE_QUANTITY = p_Item_rec.MINIMUM_LICENSE_QUANTITY
844 , EAM_ACTIVITY_SOURCE_CODE = p_Item_rec.EAM_ACTIVITY_SOURCE_CODE
845 --ADDED as part of 11.5.10 ENH
846 , TRACKING_QUANTITY_IND = p_Item_rec.TRACKING_QUANTITY_IND
847 , ONT_PRICING_QTY_SOURCE = p_Item_rec.ONT_PRICING_QTY_SOURCE
848 , SECONDARY_DEFAULT_IND = p_Item_rec.SECONDARY_DEFAULT_IND
849 , OPTION_SPECIFIC_SOURCED = p_Item_rec.OPTION_SPECIFIC_SOURCED
850 , CONFIG_ORGS = p_Item_rec.CONFIG_ORGS
851 , CONFIG_MATCH = p_Item_rec.CONFIG_MATCH
852 , SEGMENT1 = p_Item_rec.SEGMENT1
853 , SEGMENT2 = p_Item_rec.SEGMENT2
854 , SEGMENT3 = p_Item_rec.SEGMENT3
855 , SEGMENT4 = p_Item_rec.SEGMENT4
856 , SEGMENT5 = p_Item_rec.SEGMENT5
857 , SEGMENT6 = p_Item_rec.SEGMENT6
858 , SEGMENT7 = p_Item_rec.SEGMENT7
859 , SEGMENT8 = p_Item_rec.SEGMENT8
860 , SEGMENT9 = p_Item_rec.SEGMENT9
861 , SEGMENT10 = p_Item_rec.SEGMENT10
862 , SEGMENT11 = p_Item_rec.SEGMENT11
863 , SEGMENT12 = p_Item_rec.SEGMENT12
864 , SEGMENT13 = p_Item_rec.SEGMENT13
865 , SEGMENT14 = p_Item_rec.SEGMENT14
866 , SEGMENT15 = p_Item_rec.SEGMENT15
867 , SEGMENT16 = p_Item_rec.SEGMENT16
868 , SEGMENT17 = p_Item_rec.SEGMENT17
869 , SEGMENT18 = p_Item_rec.SEGMENT18
870 , SEGMENT19 = p_Item_rec.SEGMENT19
871 , SEGMENT20 = p_Item_rec.SEGMENT20
872 , SUMMARY_FLAG = p_Item_rec.SUMMARY_FLAG
873 , ENABLED_FLAG = p_Item_rec.ENABLED_FLAG
874 , START_DATE_ACTIVE = p_Item_rec.START_DATE_ACTIVE
875 , END_DATE_ACTIVE = p_Item_rec.END_DATE_ACTIVE
876 , ATTRIBUTE_CATEGORY = p_Item_rec.ATTRIBUTE_CATEGORY
877 , ATTRIBUTE1 = p_Item_rec.ATTRIBUTE1
878 , ATTRIBUTE2 = p_Item_rec.ATTRIBUTE2
879 , ATTRIBUTE3 = p_Item_rec.ATTRIBUTE3
880 , ATTRIBUTE4 = p_Item_rec.ATTRIBUTE4
881 , ATTRIBUTE5 = p_Item_rec.ATTRIBUTE5
882 , ATTRIBUTE6 = p_Item_rec.ATTRIBUTE6
883 , ATTRIBUTE7 = p_Item_rec.ATTRIBUTE7
884 , ATTRIBUTE8 = p_Item_rec.ATTRIBUTE8
885 , ATTRIBUTE9 = p_Item_rec.ATTRIBUTE9
886 , ATTRIBUTE10 = p_Item_rec.ATTRIBUTE10
887 , ATTRIBUTE11 = p_Item_rec.ATTRIBUTE11
888 , ATTRIBUTE12 = p_Item_rec.ATTRIBUTE12
889 , ATTRIBUTE13 = p_Item_rec.ATTRIBUTE13
890 , ATTRIBUTE14 = p_Item_rec.ATTRIBUTE14
891 , ATTRIBUTE15 = p_Item_rec.ATTRIBUTE15
892 , GLOBAL_ATTRIBUTE_CATEGORY = p_Item_rec.GLOBAL_ATTRIBUTE_CATEGORY
893 , GLOBAL_ATTRIBUTE1 = p_Item_rec.GLOBAL_ATTRIBUTE1
894 , GLOBAL_ATTRIBUTE2 = p_Item_rec.GLOBAL_ATTRIBUTE2
895 , GLOBAL_ATTRIBUTE3 = p_Item_rec.GLOBAL_ATTRIBUTE3
896 , GLOBAL_ATTRIBUTE4 = p_Item_rec.GLOBAL_ATTRIBUTE4
897 , GLOBAL_ATTRIBUTE5 = p_Item_rec.GLOBAL_ATTRIBUTE5
898 , GLOBAL_ATTRIBUTE6 = p_Item_rec.GLOBAL_ATTRIBUTE6
899 , GLOBAL_ATTRIBUTE7 = p_Item_rec.GLOBAL_ATTRIBUTE7
900 , GLOBAL_ATTRIBUTE8 = p_Item_rec.GLOBAL_ATTRIBUTE8
901 , GLOBAL_ATTRIBUTE9 = p_Item_rec.GLOBAL_ATTRIBUTE9
902 , GLOBAL_ATTRIBUTE10 = p_Item_rec.GLOBAL_ATTRIBUTE10
903 , GLOBAL_ATTRIBUTE11 = p_Item_rec.GLOBAL_ATTRIBUTE11
904 , GLOBAL_ATTRIBUTE12 = p_Item_rec.GLOBAL_ATTRIBUTE12
905 , GLOBAL_ATTRIBUTE13 = p_Item_rec.GLOBAL_ATTRIBUTE13
906 , GLOBAL_ATTRIBUTE14 = p_Item_rec.GLOBAL_ATTRIBUTE14
907 , GLOBAL_ATTRIBUTE15 = p_Item_rec.GLOBAL_ATTRIBUTE15
908 , GLOBAL_ATTRIBUTE16 = p_Item_rec.GLOBAL_ATTRIBUTE16
909 , GLOBAL_ATTRIBUTE17 = p_Item_rec.GLOBAL_ATTRIBUTE17
910 , GLOBAL_ATTRIBUTE18 = p_Item_rec.GLOBAL_ATTRIBUTE18
911 , GLOBAL_ATTRIBUTE19 = p_Item_rec.GLOBAL_ATTRIBUTE19
912 , GLOBAL_ATTRIBUTE20 = p_Item_rec.GLOBAL_ATTRIBUTE20
913 -- Do not update CREATE info
914 -- , CREATION_DATE = p_Item_rec.CREATION_DATE
915 -- , CREATED_BY = p_Item_rec.CREATED_BY
916 --
917 , LAST_UPDATE_DATE = p_Item_rec.LAST_UPDATE_DATE
918 , LAST_UPDATED_BY = p_Item_rec.LAST_UPDATED_BY
919 , LAST_UPDATE_LOGIN = p_Item_rec.LAST_UPDATE_LOGIN
920 , REQUEST_ID = p_Item_rec.REQUEST_ID
921 , PROGRAM_APPLICATION_ID = p_Item_rec.PROGRAM_APPLICATION_ID
922 , PROGRAM_ID = p_Item_rec.PROGRAM_ID
923 , PROGRAM_UPDATE_DATE = p_Item_rec.PROGRAM_UPDATE_DATE
927 ,VMI_MAXIMUM_DAYS = P_item_rec.VMI_MAXIMUM_DAYS
924 ,VMI_MINIMUM_UNITS = P_item_rec.VMI_MINIMUM_UNITS
925 ,VMI_MINIMUM_DAYS = P_item_rec.VMI_MINIMUM_DAYS
926 ,VMI_MAXIMUM_UNITS = P_item_rec.VMI_MAXIMUM_UNITS
928 ,VMI_FIXED_ORDER_QUANTITY = P_item_rec.VMI_FIXED_ORDER_QUANTITY
929 ,SO_AUTHORIZATION_FLAG = P_item_rec.SO_AUTHORIZATION_FLAG
930 ,CONSIGNED_FLAG = P_item_rec.CONSIGNED_FLAG
931 ,ASN_AUTOEXPIRE_FLAG = P_item_rec.ASN_AUTOEXPIRE_FLAG
932 ,VMI_FORECAST_TYPE = P_item_rec.VMI_FORECAST_TYPE
933 ,FORECAST_HORIZON = P_item_rec.FORECAST_HORIZON
934 ,EXCLUDE_FROM_BUDGET_FLAG = P_item_rec.EXCLUDE_FROM_BUDGET_FLAG
935 ,DAYS_TGT_INV_SUPPLY = P_item_rec.DAYS_TGT_INV_SUPPLY
936 ,DAYS_TGT_INV_WINDOW = P_item_rec.DAYS_TGT_INV_WINDOW
937 ,DAYS_MAX_INV_SUPPLY = P_item_rec.DAYS_MAX_INV_SUPPLY
938 ,DAYS_MAX_INV_WINDOW = P_item_rec.DAYS_MAX_INV_WINDOW
939 ,DRP_PLANNED_FLAG = P_item_rec.DRP_PLANNED_FLAG
940 ,CRITICAL_COMPONENT_FLAG = P_item_rec.CRITICAL_COMPONENT_FLAG
941 ,CONTINOUS_TRANSFER = P_item_rec.CONTINOUS_TRANSFER
942 ,CONVERGENCE = P_item_rec.CONVERGENCE
943 ,DIVERGENCE = P_item_rec.DIVERGENCE
944 /* Start Bug 3713912 */
945 , LOT_DIVISIBLE_FLAG = P_item_rec.LOT_DIVISIBLE_FLAG
946 , GRADE_CONTROL_FLAG = P_item_rec.GRADE_CONTROL_FLAG
947 , DEFAULT_GRADE = P_item_rec.DEFAULT_GRADE
948 , CHILD_LOT_FLAG = P_item_rec.CHILD_LOT_FLAG
949 , PARENT_CHILD_GENERATION_FLAG = P_item_rec.PARENT_CHILD_GENERATION_FLAG
950 , CHILD_LOT_PREFIX = P_item_rec.CHILD_LOT_PREFIX
951 , CHILD_LOT_STARTING_NUMBER = P_item_rec.CHILD_LOT_STARTING_NUMBER
952 , CHILD_LOT_VALIDATION_FLAG = P_item_rec.CHILD_LOT_VALIDATION_FLAG
953 , COPY_LOT_ATTRIBUTE_FLAG = P_item_rec.COPY_LOT_ATTRIBUTE_FLAG
954 , RECIPE_ENABLED_FLAG = P_item_rec.RECIPE_ENABLED_FLAG
955 , PROCESS_QUALITY_ENABLED_FLAG = P_item_rec.PROCESS_QUALITY_ENABLED_FLAG
956 , PROCESS_EXECUTION_ENABLED_FLAG = P_item_rec.PROCESS_EXECUTION_ENABLED_FLAG
957 , PROCESS_COSTING_ENABLED_FLAG = P_item_rec.PROCESS_COSTING_ENABLED_FLAG
958 , PROCESS_SUPPLY_SUBINVENTORY = P_item_rec.PROCESS_SUPPLY_SUBINVENTORY
959 , PROCESS_SUPPLY_LOCATOR_ID = P_item_rec.PROCESS_SUPPLY_LOCATOR_ID
960 , PROCESS_YIELD_SUBINVENTORY = P_item_rec.PROCESS_YIELD_SUBINVENTORY
961 , PROCESS_YIELD_LOCATOR_ID = P_item_rec.PROCESS_YIELD_LOCATOR_ID
962 , HAZARDOUS_MATERIAL_FLAG = P_item_rec.HAZARDOUS_MATERIAL_FLAG
963 , CAS_NUMBER = P_item_rec.CAS_NUMBER
964 , RETEST_INTERVAL = P_item_rec.RETEST_INTERVAL
965 , EXPIRATION_ACTION_INTERVAL = P_item_rec.EXPIRATION_ACTION_INTERVAL
966 , EXPIRATION_ACTION_CODE = P_item_rec.EXPIRATION_ACTION_CODE
967 , MATURITY_DAYS = P_item_rec.MATURITY_DAYS
968 , HOLD_DAYS = P_item_rec.HOLD_DAYS
969 , ATTRIBUTE16 = P_item_rec.ATTRIBUTE16
970 , ATTRIBUTE17 = P_item_rec.ATTRIBUTE17
971 , ATTRIBUTE18 = P_item_rec.ATTRIBUTE18
972 , ATTRIBUTE19 = P_item_rec.ATTRIBUTE19
973 , ATTRIBUTE20 = P_item_rec.ATTRIBUTE20
974 , ATTRIBUTE21 = P_item_rec.ATTRIBUTE21
975 , ATTRIBUTE22 = P_item_rec.ATTRIBUTE22
976 , ATTRIBUTE23 = P_item_rec.ATTRIBUTE23
977 , ATTRIBUTE24 = P_item_rec.ATTRIBUTE24
978 , ATTRIBUTE25 = P_item_rec.ATTRIBUTE25
979 , ATTRIBUTE26 = P_item_rec.ATTRIBUTE26
980 , ATTRIBUTE27 = P_item_rec.ATTRIBUTE27
981 , ATTRIBUTE28 = P_item_rec.ATTRIBUTE28
982 , ATTRIBUTE29 = P_item_rec.ATTRIBUTE29
983 , ATTRIBUTE30 = P_item_rec.ATTRIBUTE30
984 /* End Bug 3713912 */
985 --Added for R12 ENH
986 , CHARGE_PERIODICITY_CODE = p_Item_rec.CHARGE_PERIODICITY_CODE
987 , REPAIR_LEADTIME = p_Item_rec.REPAIR_LEADTIME
988 , REPAIR_YIELD = p_Item_rec.REPAIR_YIELD
989 , PREPOSITION_POINT = p_Item_rec.PREPOSITION_POINT
990 , REPAIR_PROGRAM = p_Item_rec.REPAIR_PROGRAM
991 , SUBCONTRACTING_COMPONENT = p_Item_rec.SUBCONTRACTING_COMPONENT
992 , OUTSOURCED_ASSEMBLY = p_Item_rec.OUTSOURCED_ASSEMBLY
993 -- Fix for Bug#6644711
994 , DEFAULT_MATERIAL_STATUS_ID = p_Item_rec.DEFAULT_MATERIAL_STATUS_ID
995 /* Bug 4224512 Updating the object version number - Anmurali */
996 , OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,1)+1
997 WHERE
998 CURRENT OF Item_csr;
999
1000 /*
1001 WHERE
1002 INVENTORY_ITEM_ID = l_Item_ID
1003 AND ORGANIZATION_ID = l_Org_ID;
1004
1005 IF ( SQL%NOTFOUND ) THEN
1006 -- RAISE no_data_found;
1007 x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1008 FND_MESSAGE.Set_Name ('INV', 'INV_Update_Item_Row_notfound');
1009 FND_MSG_PUB.Add;
1010 RETURN;
1011 END IF;
1012 */
1013
1014 ------------------------------------------------------------
1015 -- Update item translation rows in the translations table --
1016 ------------------------------------------------------------
1017
1018 IF ( p_update_Item_TL ) THEN
1019
1020 BEGIN -- Update block
1021
1022 -- Do not validate Item and Org IDs since p_Item_rec is fetched
1023
1024 UPDATE MTL_SYSTEM_ITEMS_TL
1025 SET
1026 DESCRIPTION = NVL(trim(p_Item_rec.DESCRIPTION),DESCRIPTION) --Bug 4416173
1027 , LONG_DESCRIPTION = trim(p_Item_rec.LONG_DESCRIPTION)
1028 , LAST_UPDATE_DATE = p_Item_rec.LAST_UPDATE_DATE
1029 , LAST_UPDATED_BY = p_Item_rec.LAST_UPDATED_BY
1030 , LAST_UPDATE_LOGIN = p_Item_rec.LAST_UPDATE_LOGIN
1031 , SOURCE_LANG = userenv('LANG')
1032 WHERE
1033 INVENTORY_ITEM_ID = p_Item_rec.INVENTORY_ITEM_ID
1034 AND ORGANIZATION_ID = p_Item_rec.ORGANIZATION_ID
1035 AND userenv('LANG') IN ( LANGUAGE, SOURCE_LANG );
1036
1037 END; -- Update block
1038
1039 END IF; -- Update translated item rows
1040 ---------------------------------------
1041
1042 x_return_status := FND_API.g_RET_STS_SUCCESS;
1043
1044 END Update_Item_Row;
1045
1046
1047 /*---------------------------- Update_Item_TL_Row ----------------------------*/
1048
1049 -- Currently not used
1050 /*
1051 PROCEDURE Update_Item_TL_Row
1052 (
1053 p_Item_TL_rec IN Item_TL_rec_type
1054 , x_return_status OUT VARCHAR2
1055 )
1056 IS
1057 BEGIN
1058
1059 -- Update translated item row at Item_TL_csr cursor position
1060 --
1061 UPDATE MTL_SYSTEM_ITEMS_TL
1062 SET
1063 DESCRIPTION = p_Item_TL_rec.DESCRIPTION
1064 , LONG_DESCRIPTION = p_Item_TL_rec.LONG_DESCRIPTION
1065 , LAST_UPDATE_DATE = p_Item_TL_rec.LAST_UPDATE_DATE
1066 , LAST_UPDATED_BY = p_Item_TL_rec.LAST_UPDATED_BY
1067 , LAST_UPDATE_LOGIN = p_Item_TL_rec.LAST_UPDATE_LOGIN
1068 --
1069 -- , SOURCE_LANG = p_Item_TL_rec.SOURCE_LANG
1070 --
1071 -- Always use current language when updating item translation rows
1072 , SOURCE_LANG = userenv('LANG')
1073 WHERE
1074 CURRENT OF Item_TL_csr;
1075
1076 x_return_status := FND_API.g_RET_STS_SUCCESS;
1077
1078 END Update_Item_TL_Row;
1079 */
1080
1081
1082 -- -------------------- To_Boolchar ---------------------
1083
1084 -- Currently not used
1085 /*
1086 FUNCTION To_Boolchar
1087 (
1088 p_bool IN BOOLEAN
1089 )
1090 RETURN VARCHAR2
1091 IS
1092 l_api_name CONSTANT VARCHAR2(30) := 'To_Boolchar';
1093 BEGIN
1094
1095 IF ( p_bool = TRUE ) THEN
1096 RETURN FND_API.g_TRUE;
1097 ELSIF ( p_bool = FALSE ) THEN
1098 RETURN FND_API.g_FALSE;
1099 ELSE
1100
1101 FND_MSG_PUB.Add_Exc_Msg
1102 ( p_pkg_name => G_PKG_NAME
1103 , p_procedure_name => l_api_name
1104 -- , p_error_text => 'Unrecognized parameter value : p_bool='
1105 );
1106 -- RETURN NULL;
1107
1108 RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
1109
1110 END IF;
1111
1112 END To_Boolchar;
1113 */
1114
1115
1116 END INV_ITEM_API;