[Home] [Help]
PACKAGE BODY: APPS.ENG_COPY_TABLE_ROWS_PKG
Source
1 PACKAGE BODY ENG_COPY_TABLE_ROWS_PKG AS
2 /* $Header: ENGPCTRB.pls 120.3.12010000.2 2009/03/26 18:55:57 vbrobbey ship $ */
3
4 PROCEDURE C_MTL_RTG_ITEM_REVISIONS (
5 X_inventory_item_id IN NUMBER,
6 X_organization_id IN NUMBER,
7 X_process_revision IN VARCHAR2,
8 X_last_update_date IN DATE,
9 X_last_updated_by IN NUMBER,
10 X_creation_date IN DATE,
11 X_created_by IN NUMBER,
12 X_last_update_login IN NUMBER,
13 X_effectivity_date IN DATE,
14 X_change_notice IN VARCHAR2,
15 X_implementation_date IN DATE)
16 IS
17 BEGIN
18
19 INSERT INTO MTL_RTG_ITEM_REVISIONS(
20 INVENTORY_ITEM_ID,
21 ORGANIZATION_ID,
22 PROCESS_REVISION,
23 LAST_UPDATE_DATE,
24 LAST_UPDATED_BY,
25 CREATION_DATE,
26 CREATED_BY,
27 LAST_UPDATE_LOGIN,
28 EFFECTIVITY_DATE,
29 CHANGE_NOTICE,
30 IMPLEMENTATION_DATE)
31 VALUES(
32 X_inventory_item_id,
33 X_organization_id,
34 X_process_revision,
35 X_last_update_date,
36 X_last_updated_by,
37 X_creation_date,
38 X_created_by,
39 X_last_update_login,
40 X_effectivity_date,
41 X_change_notice,
42 X_implementation_date);
43
44 EXCEPTION
45 WHEN OTHERS THEN
46 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_RTG_ITEM_REVISIONS',
47 stmt_num => 1000,
48 message_name => 'ENG_ENUBRT_ERROR',
49 token => SQLERRM);
50
51 END C_MTL_RTG_ITEM_REVISIONS;
52
53 PROCEDURE C_MTL_ITEM_REVISIONS (
54 X_inventory_item_id IN NUMBER,
55 X_organization_id IN NUMBER,
56 X_revision IN VARCHAR2,
57 X_last_update_date IN DATE,
58 X_last_updated_by IN NUMBER,
59 X_creation_date IN DATE,
60 X_created_by IN NUMBER,
61 X_last_update_login IN NUMBER,
62 X_effectivity_date IN DATE,
63 X_change_notice IN VARCHAR2,
64 X_implementation_date IN DATE)
65 IS
66 l_language_code VARCHAR2(3);
67 l_revision_id NUMBER;
68 BEGIN
69
70 INSERT INTO MTL_ITEM_REVISIONS_B(
71 INVENTORY_ITEM_ID,
72 ORGANIZATION_ID,
73 REVISION,
74 LAST_UPDATE_DATE,
75 LAST_UPDATED_BY,
76 CREATION_DATE,
77 CREATED_BY,
78 LAST_UPDATE_LOGIN,
79 EFFECTIVITY_DATE,
80 CHANGE_NOTICE,
81 IMPLEMENTATION_DATE,
82 REVISION_ID,
83 OBJECT_VERSION_NUMBER,
84 REVISION_LABEL) --Added for bug 3067402
85 values
86 (X_inventory_item_id,
87 X_organization_id,
88 X_revision,
89 X_last_update_date,
90 X_last_updated_by,
91 X_creation_date,
92 X_created_by,
93 X_last_update_login,
94 X_effectivity_date,
95 X_change_notice,
96 X_implementation_date,
97 mtl_item_revisions_b_s.NEXTVAL,
98 1,
99 X_revision) --Added for bug 3067402
100 RETURNING revision_id INTO l_revision_id;
101
102 SELECT userenv('LANG') INTO l_language_code FROM dual;
103 insert into MTL_ITEM_REVISIONS_TL (
104 inventory_item_id,
105 organization_id,
106 revision_id,
107 language,
108 source_lang,
109 last_update_date,
110 last_updated_by,
111 creation_date,
112 created_by,
113 last_update_login
114 )
115 SELECT X_inventory_item_id,
116 X_organization_id,
117 l_revision_id,
118 lang.language_code,
119 l_language_code,
120 X_last_update_date,
121 X_last_updated_by,
122 X_creation_date,
123 X_created_by,
124 X_last_update_login
125 FROM FND_LANGUAGES lang
126 WHERE lang.installed_flag in ('I', 'B')
127 and not exists
128 (select NULL
129 from MTL_ITEM_REVISIONS_TL T
130 where T.revision_id = l_revision_id
131 and T.LANGUAGE = lang.LANGUAGE_CODE);
132
133
134 EXCEPTION
135 WHEN OTHERS THEN
136 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_REVISIONS',
137 stmt_num => 1001,
138 message_name => 'ENG_ENUBRT_ERROR',
139 token => SQLERRM);
140
141 END C_MTL_ITEM_REVISIONS;
142
143 PROCEDURE C_MTL_SYSTEM_ITEMS (
144 X_org_id IN NUMBER,
145 X_master_org IN NUMBER,
146 X_eng_item_id IN NUMBER,
147 X_mfg_item_id IN NUMBER,
148 X_last_login_id IN NUMBER,
149 X_mfg_description IN VARCHAR2,
150 X_ecn_name IN VARCHAR2,
151 X_segment1 IN VARCHAR2,
152 X_segment2 IN VARCHAR2,
153 X_segment3 IN VARCHAR2,
154 X_segment4 IN VARCHAR2,
155 X_segment5 IN VARCHAR2,
156 X_segment6 IN VARCHAR2,
157 X_segment7 IN VARCHAR2,
158 X_segment8 IN VARCHAR2,
159 X_segment9 IN VARCHAR2,
160 X_segment10 IN VARCHAR2,
161 X_segment11 IN VARCHAR2,
162 X_segment12 IN VARCHAR2,
163 X_segment13 IN VARCHAR2,
164 X_segment14 IN VARCHAR2,
165 X_segment15 IN VARCHAR2,
166 X_segment16 IN VARCHAR2,
167 X_segment17 IN VARCHAR2,
168 X_segment18 IN VARCHAR2,
169 X_segment19 IN VARCHAR2,
170 X_segment20 IN VARCHAR2
171 )
172 IS
173
174 /* Bug 4466566 */
175 X_sales_account NUMBER;
176 X_cost_of_sales_account NUMBER;
177 X_expense_account NUMBER;
178 X_encumbrance_account NUMBER;
179 /* Bug 4466566 */
180
181 X_long_description VARCHAR2(4000); /* Bug 7591561 */
182
183 BEGIN
184
185 /* Bug 4466566 */
186 If (x_master_org <> X_org_id ) then
187 select
188 sales_account,
189 cost_of_sales_account,
190 expense_account,
191 encumbrance_account
192 into
193 X_sales_account,
194 X_cost_of_sales_account,
195 X_expense_account,
196 X_encumbrance_account
197 from mtl_parameters
198 where organization_id = X_master_org;
199 end if;
200 /* Bug 4466566 */
201
202 INSERT INTO MTL_SYSTEM_ITEMS(
203 ACCEPTABLE_EARLY_DAYS,
204 ACCEPTABLE_RATE_DECREASE,
205 ACCEPTABLE_RATE_INCREASE,
206 ACCOUNTING_RULE_ID,
207 ALLOWED_UNITS_LOOKUP_CODE,
208 ALLOW_EXPRESS_DELIVERY_FLAG,
209 ALLOW_ITEM_DESC_UPDATE_FLAG,
210 ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
211 ALLOW_UNORDERED_RECEIPTS_FLAG,
212 ASSET_CATEGORY_ID,
213 ATO_FORECAST_CONTROL,
214 ATP_COMPONENTS_FLAG,
215 ATP_FLAG,
216 ATP_RULE_ID,
217 ATTRIBUTE1,
218 ATTRIBUTE10,
219 ATTRIBUTE11,
220 ATTRIBUTE12,
221 ATTRIBUTE13,
222 ATTRIBUTE14,
223 ATTRIBUTE15,
224 ATTRIBUTE2,
225 ATTRIBUTE3,
226 ATTRIBUTE4,
227 ATTRIBUTE5,
228 ATTRIBUTE6,
229 ATTRIBUTE7,
230 ATTRIBUTE8,
231 ATTRIBUTE9,
232 ATTRIBUTE_CATEGORY,
233 AUTO_CREATED_CONFIG_FLAG,
234 AUTO_LOT_ALPHA_PREFIX,
235 AUTO_REDUCE_MPS,
236 AUTO_SERIAL_ALPHA_PREFIX,
237 BASE_ITEM_ID,
238 BASE_WARRANTY_SERVICE_ID,
239 BOM_ENABLED_FLAG,
240 BOM_ITEM_TYPE,
241 BUILD_IN_WIP_FLAG,
242 BUYER_ID,
243 CARRYING_COST,
244 CATALOG_STATUS_FLAG,
245 COLLATERAL_FLAG,
246 COSTING_ENABLED_FLAG,
247 COST_OF_SALES_ACCOUNT,
248 COVERAGE_SCHEDULE_ID,
249 CREATED_BY,
250 CREATION_DATE,
251 CUMULATIVE_TOTAL_LEAD_TIME,
252 CUM_MANUFACTURING_LEAD_TIME,
253 CUSTOMER_ORDER_ENABLED_FLAG,
254 CUSTOMER_ORDER_FLAG,
255 CYCLE_COUNT_ENABLED_FLAG,
256 DAYS_EARLY_RECEIPT_ALLOWED,
257 DAYS_LATE_RECEIPT_ALLOWED,
258 DEFAULT_INCLUDE_IN_ROLLUP_FLAG,
259 DEFAULT_SHIPPING_ORG,
260 DEMAND_TIME_FENCE_CODE,
261 DEMAND_TIME_FENCE_DAYS,
262 DESCRIPTION,
263 EFFECTIVITY_CONTROL,
264 ENABLED_FLAG,
265 ENCUMBRANCE_ACCOUNT,
266 END_ASSEMBLY_PEGGING_FLAG,
267 END_DATE_ACTIVE,
268 ENFORCE_SHIP_TO_LOCATION_CODE,
269 ENGINEERING_DATE,
270 ENGINEERING_ECN_CODE,
271 ENGINEERING_ITEM_ID,
272 ENG_ITEM_FLAG,
273 EXPENSE_ACCOUNT,
274 EXPENSE_BILLABLE_FLAG,
275 FIXED_DAYS_SUPPLY,
276 FIXED_LEAD_TIME,
277 FIXED_LOT_MULTIPLIER,
278 FIXED_ORDER_QUANTITY,
279 FULL_LEAD_TIME,
280 HAZARD_CLASS_ID,
281 INSPECTION_REQUIRED_FLAG,
282 INTERNAL_ORDER_ENABLED_FLAG,
283 INTERNAL_ORDER_FLAG,
284 INVENTORY_ASSET_FLAG,
285 INVENTORY_ITEM_FLAG,
286 INVENTORY_ITEM_ID,
287 INVENTORY_ITEM_STATUS_CODE,
288 INVENTORY_PLANNING_CODE,
289 INVOICEABLE_ITEM_FLAG,
290 INVOICE_CLOSE_TOLERANCE,
291 INVOICE_ENABLED_FLAG,
292 INVOICING_RULE_ID,
293 ITEM_CATALOG_GROUP_ID,
294 ITEM_TYPE,
295 LAST_UPDATED_BY,
296 LAST_UPDATE_DATE,
297 LAST_UPDATE_LOGIN,
298 LEAD_TIME_LOT_SIZE,
299 LIST_PRICE_PER_UNIT,
300 LOCATION_CONTROL_CODE,
301 LOT_CONTROL_CODE,
302 MARKET_PRICE,
303 MATERIAL_BILLABLE_FLAG,
304 MAXIMUM_ORDER_QUANTITY,
305 MAX_MINMAX_QUANTITY,
306 MAX_WARRANTY_AMOUNT,
307 MINIMUM_ORDER_QUANTITY,
308 MIN_MINMAX_QUANTITY,
309 MODEL_CONFIG_CLAUSE_NAME,
310 MRP_CALCULATE_ATP_FLAG,
311 MRP_PLANNING_CODE,
312 MRP_SAFETY_STOCK_CODE,
313 MRP_SAFETY_STOCK_PERCENT,
314 MTL_TRANSACTIONS_ENABLED_FLAG,
315 MUST_USE_APPROVED_VENDOR_FLAG,
316 NEGATIVE_MEASUREMENT_ERROR,
317 NEW_REVISION_CODE,
318 ORDER_COST,
319 ORGANIZATION_ID,
320 OUTSIDE_OPERATION_FLAG,
321 OUTSIDE_OPERATION_UOM_TYPE,
322 OVERRUN_PERCENTAGE,
323 PAYMENT_TERMS_ID,
324 PICKING_RULE_ID,
325 PICK_COMPONENTS_FLAG,
326 PLANNER_CODE,
327 PLANNING_EXCEPTION_SET,
328 PLANNING_MAKE_BUY_CODE,
329 PLANNING_TIME_FENCE_CODE,
330 PLANNING_TIME_FENCE_DAYS,
331 POSITIVE_MEASUREMENT_ERROR,
332 POSTPROCESSING_LEAD_TIME,
333 PREPROCESSING_LEAD_TIME,
334 PREVENTIVE_MAINTENANCE_FLAG,
335 PRICE_TOLERANCE_PERCENT,
336 PRIMARY_SPECIALIST_ID,
337 PRIMARY_UNIT_OF_MEASURE,
338 PRIMARY_UOM_CODE,
339 PROGRAM_APPLICATION_ID,
340 PROGRAM_ID,
341 PROGRAM_UPDATE_DATE,
342 PRORATE_SERVICE_FLAG,
343 PURCHASING_ENABLED_FLAG,
344 PURCHASING_ITEM_FLAG,
345 QTY_RCV_EXCEPTION_CODE,
346 QTY_RCV_TOLERANCE,
347 RECEIPT_DAYS_EXCEPTION_CODE,
348 RECEIPT_REQUIRED_FLAG,
349 RECEIVE_CLOSE_TOLERANCE,
350 RECEIVING_ROUTING_ID,
351 RELEASE_TIME_FENCE_CODE,
352 RELEASE_TIME_FENCE_DAYS,
353 REPETITIVE_PLANNING_FLAG,
354 REPLENISH_TO_ORDER_FLAG,
355 REQUEST_ID,
356 RESERVABLE_TYPE,
357 RESPONSE_TIME_PERIOD_CODE,
358 RESPONSE_TIME_VALUE,
359 RESTRICT_LOCATORS_CODE,
360 RESTRICT_SUBINVENTORIES_CODE,
361 RETURNABLE_FLAG,
362 RETURN_INSPECTION_REQUIREMENT,
363 REVISION_QTY_CONTROL_CODE,
364 RFQ_REQUIRED_FLAG,
365 ROUNDING_CONTROL_TYPE,
366 ROUNDING_FACTOR,
367 SAFETY_STOCK_BUCKET_DAYS,
368 SALES_ACCOUNT,
369 SECONDARY_SPECIALIST_ID,
370 SEGMENT1,
371 SEGMENT10,
372 SEGMENT11,
373 SEGMENT12,
374 SEGMENT13,
375 SEGMENT14,
376 SEGMENT15,
377 SEGMENT16,
378 SEGMENT17,
379 SEGMENT18,
380 SEGMENT19,
381 SEGMENT2,
382 SEGMENT20,
383 SEGMENT3,
384 SEGMENT4,
385 SEGMENT5,
386 SEGMENT6,
387 SEGMENT7,
388 SEGMENT8,
389 SEGMENT9,
390 SERIAL_NUMBER_CONTROL_CODE,
391 SERVICEABLE_COMPONENT_FLAG,
392 SERVICEABLE_ITEM_CLASS_ID,
393 SERVICEABLE_PRODUCT_FLAG,
394 SERVICE_DURATION,
395 SERVICE_DURATION_PERIOD_CODE,
396 SERVICE_ITEM_FLAG,
397 SERVICE_STARTING_DELAY,
398 SHELF_LIFE_CODE,
399 SHELF_LIFE_DAYS,
400 SHIPPABLE_ITEM_FLAG,
401 SHIP_MODEL_COMPLETE_FLAG,
402 SHRINKAGE_RATE,
403 SOURCE_ORGANIZATION_ID,
404 SOURCE_SUBINVENTORY,
405 SOURCE_TYPE,
406 SO_TRANSACTIONS_FLAG,
407 START_AUTO_LOT_NUMBER,
408 START_AUTO_SERIAL_NUMBER,
409 START_DATE_ACTIVE,
410 STD_LOT_SIZE,
411 STOCK_ENABLED_FLAG,
412 SUMMARY_FLAG,
413 TAXABLE_FLAG,
414 TAX_CODE,
415 TIME_BILLABLE_FLAG,
416 UNIT_OF_ISSUE,
417 UNIT_VOLUME,
418 UNIT_WEIGHT,
419 UN_NUMBER_ID,
420 VARIABLE_LEAD_TIME,
421 VENDOR_WARRANTY_FLAG,
422 VOLUME_UOM_CODE,
423 WARRANTY_VENDOR_ID,
424 WEIGHT_UOM_CODE,
425 WIP_SUPPLY_LOCATOR_ID,
426 WIP_SUPPLY_SUBINVENTORY,
427 WIP_SUPPLY_TYPE,
428 GLOBAL_ATTRIBUTE_CATEGORY,
429 GLOBAL_ATTRIBUTE1,
430 GLOBAL_ATTRIBUTE2,
431 GLOBAL_ATTRIBUTE3,
432 GLOBAL_ATTRIBUTE4,
433 GLOBAL_ATTRIBUTE5,
434 GLOBAL_ATTRIBUTE6,
435 GLOBAL_ATTRIBUTE7,
436 GLOBAL_ATTRIBUTE8,
437 GLOBAL_ATTRIBUTE9,
438 GLOBAL_ATTRIBUTE10,
439 DEFAULT_SO_SOURCE_TYPE,
440 CREATE_SUPPLY_FLAG,
441 WEB_STATUS ,
442 CHECK_SHORTAGES_FLAG,
443 PURCHASING_TAX_CODE,
444 CONTAINER_ITEM_FLAG,
445 VEHICLE_ITEM_FLAG,
446 CONTAINER_TYPE_CODE,
447 INTERNAL_VOLUME,
448 MAXIMUM_LOAD_WEIGHT,
449 MINIMUM_FILL_PERCENT,
450 OVERCOMPLETION_TOLERANCE_TYPE ,
451 OVERCOMPLETION_TOLERANCE_VALUE ,
452 CONTRACT_ITEM_TYPE_CODE ,
453 SUBSCRIPTION_DEPEND_FLAG ,
454 OVER_SHIPMENT_TOLERANCE,
455 UNDER_SHIPMENT_TOLERANCE,
456 OVER_RETURN_TOLERANCE ,
457 UNDER_RETURN_TOLERANCE ,
458 EQUIPMENT_TYPE ,
459 RECOVERED_PART_DISP_CODE ,
460 DEFECT_TRACKING_ON_FLAG ,
461 EVENT_FLAG ,
462 ELECTRONIC_FLAG ,
463 DOWNLOADABLE_FLAG,
464 VOL_DISCOUNT_EXEMPT_FLAG ,
465 COUPON_EXEMPT_FLAG ,
466 COMMS_NL_TRACKABLE_FLAG ,
467 ASSET_CREATION_CODE ,
468 COMMS_ACTIVATION_REQD_FLAG ,
469 ORDERABLE_ON_WEB_FLAG ,
470 BACK_ORDERABLE_FLAG ,
471 INDIVISIBLE_FLAG ,
472 DIMENSION_UOM_CODE ,
473 UNIT_LENGTH ,
474 UNIT_WIDTH ,
475 UNIT_HEIGHT ,
476 BULK_PICKED_FLAG ,
477 LOT_STATUS_ENABLED ,
478 DEFAULT_LOT_STATUS_ID ,
479 SERIAL_STATUS_ENABLED ,
480 DEFAULT_SERIAL_STATUS_ID ,
481 LOT_SPLIT_ENABLED ,
482 LOT_MERGE_ENABLED ,
483 INVENTORY_CARRY_PENALTY ,
484 OPERATION_SLACK_PENALTY ,
485 FINANCING_ALLOWED_FLAG ,
486 EAM_ITEM_TYPE ,
487 EAM_ACTIVITY_TYPE_CODE ,
488 EAM_ACTIVITY_CAUSE_CODE ,
489 EAM_ACT_NOTIFICATION_FLAG,
490 EAM_ACT_SHUTDOWN_STATUS ,
491 DUAL_UOM_CONTROL ,
492 SECONDARY_UOM_CODE,
493 DUAL_UOM_DEVIATION_HIGH ,
494 DUAL_UOM_DEVIATION_LOW ,
495 SERV_REQ_ENABLED_CODE ,
496 SERV_BILLING_ENABLED_FLAG ,
497 SERV_IMPORTANCE_LEVEL ,
498 PLANNED_INV_POINT_FLAG ,
499 LOT_TRANSLATE_ENABLED ,
500 SUBSTITUTION_WINDOW_CODE ,
501 SUBSTITUTION_WINDOW_DAYS ,
502 IB_ITEM_INSTANCE_CLASS ,
503 CONFIG_MODEL_TYPE ,
504 LOT_SUBSTITUTION_ENABLED ,
505 MINIMUM_LICENSE_QUANTITY ,
506 EAM_ACTIVITY_SOURCE_CODE ,
507 CURRENT_PHASE_ID ,
508 LIFECYCLE_ID ,
509 PRODUCT_FAMILY_ITEM_ID,
510 USAGE_ITEM_FLAG,
511 TRACKING_QUANTITY_IND,
512 ONT_PRICING_QTY_SOURCE,
513 CONSIGNED_FLAG,
514 ASN_AUTOEXPIRE_FLAG,
515 VMI_FORECAST_TYPE,
516 EXCLUDE_FROM_BUDGET_FLAG,
517 DRP_PLANNED_FLAG,
518 CRITICAL_COMPONENT_FLAG,
519 CONTINOUS_TRANSFER,
520 CONVERGENCE,
521 DIVERGENCE,
522 APPROVAL_STATUS
523 /* Start Bug 3713912 */
524 ,SECONDARY_DEFAULT_IND,
525 ATTRIBUTE16,
526 ATTRIBUTE17,
527 ATTRIBUTE18,
528 ATTRIBUTE19,
529 ATTRIBUTE20,
530 ATTRIBUTE21,
531 ATTRIBUTE22,
532 ATTRIBUTE23,
533 ATTRIBUTE24,
534 ATTRIBUTE25,
535 ATTRIBUTE26,
536 ATTRIBUTE27,
537 ATTRIBUTE28,
538 ATTRIBUTE29,
539 ATTRIBUTE30,
540 LOT_DIVISIBLE_FLAG,
541 GRADE_CONTROL_FLAG,
542 DEFAULT_GRADE,
543 CHILD_LOT_FLAG,
544 PARENT_CHILD_GENERATION_FLAG,
545 CHILD_LOT_PREFIX,
546 CHILD_LOT_STARTING_NUMBER,
547 CHILD_LOT_VALIDATION_FLAG,
548 COPY_LOT_ATTRIBUTE_FLAG,
549 RECIPE_ENABLED_FLAG,
550 PROCESS_COSTING_ENABLED_FLAG,
551 RETEST_INTERVAL,
552 EXPIRATION_ACTION_INTERVAL,
553 EXPIRATION_ACTION_CODE,
554 MATURITY_DAYS,
555 HOLD_DAYS,
556 PROCESS_QUALITY_ENABLED_FLAG,
557 PROCESS_EXECUTION_ENABLED_FLAG,
558 PROCESS_SUPPLY_SUBINVENTORY,
559 PROCESS_SUPPLY_LOCATOR_ID,
560 PROCESS_YIELD_SUBINVENTORY,
561 PROCESS_YIELD_LOCATOR_ID,
562 HAZARDOUS_MATERIAL_FLAG,
563 CAS_NUMBER
564 /* End Bug 3713912 */
565 )
566 SELECT
567 ACCEPTABLE_EARLY_DAYS,
568 ACCEPTABLE_RATE_DECREASE,
569 ACCEPTABLE_RATE_INCREASE,
570 ACCOUNTING_RULE_ID,
571 ALLOWED_UNITS_LOOKUP_CODE,
572 ALLOW_EXPRESS_DELIVERY_FLAG,
573 ALLOW_ITEM_DESC_UPDATE_FLAG,
574 ALLOW_SUBSTITUTE_RECEIPTS_FLAG,
575 ALLOW_UNORDERED_RECEIPTS_FLAG,
576 ASSET_CATEGORY_ID,
577 ATO_FORECAST_CONTROL,
578 ATP_COMPONENTS_FLAG,
579 ATP_FLAG,
580 ATP_RULE_ID,
581 ATTRIBUTE1,
582 ATTRIBUTE10,
583 ATTRIBUTE11,
584 ATTRIBUTE12,
585 ATTRIBUTE13,
586 ATTRIBUTE14,
587 ATTRIBUTE15,
588 ATTRIBUTE2,
589 ATTRIBUTE3,
590 ATTRIBUTE4,
591 ATTRIBUTE5,
592 ATTRIBUTE6,
593 ATTRIBUTE7,
594 ATTRIBUTE8,
595 ATTRIBUTE9,
596 ATTRIBUTE_CATEGORY,
597 AUTO_CREATED_CONFIG_FLAG,
598 AUTO_LOT_ALPHA_PREFIX,
599 AUTO_REDUCE_MPS,
600 AUTO_SERIAL_ALPHA_PREFIX,
601 BASE_ITEM_ID,
602 BASE_WARRANTY_SERVICE_ID,
603 BOM_ENABLED_FLAG,
604 BOM_ITEM_TYPE,
605 BUILD_IN_WIP_FLAG,
606 BUYER_ID,
607 CARRYING_COST,
608 CATALOG_STATUS_FLAG,
609 COLLATERAL_FLAG,
610 COSTING_ENABLED_FLAG,
611 decode(x_master_org,X_org_id,COST_OF_SALES_ACCOUNT,X_cost_of_sales_account), -- Bug 4466566
612 COVERAGE_SCHEDULE_ID,
613 to_number(Fnd_Profile.Value('USER_ID')),
614 SYSDATE,
615 CUMULATIVE_TOTAL_LEAD_TIME,
616 CUM_MANUFACTURING_LEAD_TIME,
617 CUSTOMER_ORDER_ENABLED_FLAG,
618 CUSTOMER_ORDER_FLAG,
619 CYCLE_COUNT_ENABLED_FLAG,
620 DAYS_EARLY_RECEIPT_ALLOWED,
621 DAYS_LATE_RECEIPT_ALLOWED,
622 DEFAULT_INCLUDE_IN_ROLLUP_FLAG,
623 DEFAULT_SHIPPING_ORG,
624 DEMAND_TIME_FENCE_CODE,
625 DEMAND_TIME_FENCE_DAYS,
626 X_mfg_description,
627 EFFECTIVITY_CONTROL,
628 ENABLED_FLAG,
629 decode(X_master_org,X_org_id,ENCUMBRANCE_ACCOUNT,X_ENCUMBRANCE_ACCOUNT), -- Bug 4466566
630 END_ASSEMBLY_PEGGING_FLAG,
631 END_DATE_ACTIVE,
632 ENFORCE_SHIP_TO_LOCATION_CODE,
633 SYSDATE,
634 X_ecn_name,
635 X_eng_item_id,
636 'N',
637 decode(X_master_org,X_org_id,EXPENSE_ACCOUNT,X_expense_account), -- Bug 4466566
638 EXPENSE_BILLABLE_FLAG,
639 FIXED_DAYS_SUPPLY,
640 FIXED_LEAD_TIME,
641 FIXED_LOT_MULTIPLIER,
642 FIXED_ORDER_QUANTITY,
643 FULL_LEAD_TIME,
644 HAZARD_CLASS_ID,
645 INSPECTION_REQUIRED_FLAG,
646 INTERNAL_ORDER_ENABLED_FLAG,
647 INTERNAL_ORDER_FLAG,
648 INVENTORY_ASSET_FLAG,
649 INVENTORY_ITEM_FLAG,
650 X_mfg_item_id,
651 INVENTORY_ITEM_STATUS_CODE,
652 INVENTORY_PLANNING_CODE,
653 INVOICEABLE_ITEM_FLAG,
654 INVOICE_CLOSE_TOLERANCE,
655 INVOICE_ENABLED_FLAG,
656 INVOICING_RULE_ID,
657 ITEM_CATALOG_GROUP_ID,
658 ITEM_TYPE,
659 to_number(Fnd_Profile.Value('USER_ID')),
660 SYSDATE,
661 to_number(Fnd_Profile.Value('LOGIN_ID')),
662 LEAD_TIME_LOT_SIZE,
663 LIST_PRICE_PER_UNIT,
664 LOCATION_CONTROL_CODE,
665 LOT_CONTROL_CODE,
666 MARKET_PRICE,
667 MATERIAL_BILLABLE_FLAG,
668 MAXIMUM_ORDER_QUANTITY,
669 MAX_MINMAX_QUANTITY,
670 MAX_WARRANTY_AMOUNT,
671 MINIMUM_ORDER_QUANTITY,
672 MIN_MINMAX_QUANTITY,
673 MODEL_CONFIG_CLAUSE_NAME,
674 MRP_CALCULATE_ATP_FLAG,
675 MRP_PLANNING_CODE,
676 MRP_SAFETY_STOCK_CODE,
677 MRP_SAFETY_STOCK_PERCENT,
678 MTL_TRANSACTIONS_ENABLED_FLAG,
679 MUST_USE_APPROVED_VENDOR_FLAG,
680 NEGATIVE_MEASUREMENT_ERROR,
681 NEW_REVISION_CODE,
682 ORDER_COST,
683 X_master_org,
684 OUTSIDE_OPERATION_FLAG,
685 OUTSIDE_OPERATION_UOM_TYPE,
686 OVERRUN_PERCENTAGE,
687 PAYMENT_TERMS_ID,
688 PICKING_RULE_ID,
689 PICK_COMPONENTS_FLAG,
690 decode(x_master_org,X_org_id,PLANNER_CODE,NULL), --Bug5916866
691 decode(x_master_org,X_org_id,PLANNING_EXCEPTION_SET,NULL), --Bug5916866
692 PLANNING_MAKE_BUY_CODE,
693 PLANNING_TIME_FENCE_CODE,
694 PLANNING_TIME_FENCE_DAYS,
695 POSITIVE_MEASUREMENT_ERROR,
696 POSTPROCESSING_LEAD_TIME,
697 PREPROCESSING_LEAD_TIME,
698 PREVENTIVE_MAINTENANCE_FLAG,
699 PRICE_TOLERANCE_PERCENT,
700 PRIMARY_SPECIALIST_ID,
701 PRIMARY_UNIT_OF_MEASURE,
702 PRIMARY_UOM_CODE,
703 PROGRAM_APPLICATION_ID,
704 PROGRAM_ID,
705 PROGRAM_UPDATE_DATE,
706 PRORATE_SERVICE_FLAG,
707 PURCHASING_ENABLED_FLAG,
708 PURCHASING_ITEM_FLAG,
709 QTY_RCV_EXCEPTION_CODE,
710 QTY_RCV_TOLERANCE,
711 RECEIPT_DAYS_EXCEPTION_CODE,
712 RECEIPT_REQUIRED_FLAG,
713 RECEIVE_CLOSE_TOLERANCE,
714 RECEIVING_ROUTING_ID,
715 RELEASE_TIME_FENCE_CODE,
716 RELEASE_TIME_FENCE_DAYS,
717 REPETITIVE_PLANNING_FLAG,
718 REPLENISH_TO_ORDER_FLAG,
719 REQUEST_ID,
720 RESERVABLE_TYPE,
721 RESPONSE_TIME_PERIOD_CODE,
722 RESPONSE_TIME_VALUE,
723 RESTRICT_LOCATORS_CODE,
724 RESTRICT_SUBINVENTORIES_CODE,
725 RETURNABLE_FLAG,
726 RETURN_INSPECTION_REQUIREMENT,
727 REVISION_QTY_CONTROL_CODE,
728 RFQ_REQUIRED_FLAG,
729 ROUNDING_CONTROL_TYPE,
730 ROUNDING_FACTOR,
731 SAFETY_STOCK_BUCKET_DAYS,
732 decode(x_master_org,X_org_id,SALES_ACCOUNT,X_sales_account), -- Bug 4466566
733 SECONDARY_SPECIALIST_ID,
734 X_segment1,
735 X_segment10,
736 X_segment11,
737 X_segment12,
738 X_segment13,
739 X_segment14,
740 X_segment15,
741 X_segment16,
742 X_segment17,
743 X_segment18,
744 X_segment19,
745 X_segment2,
746 X_segment20,
747 X_segment3,
748 X_segment4,
749 X_segment5,
750 X_segment6,
751 X_segment7,
752 X_segment8,
753 X_segment9,
754 SERIAL_NUMBER_CONTROL_CODE,
755 SERVICEABLE_COMPONENT_FLAG,
756 SERVICEABLE_ITEM_CLASS_ID,
757 SERVICEABLE_PRODUCT_FLAG,
758 SERVICE_DURATION,
759 SERVICE_DURATION_PERIOD_CODE,
760 SERVICE_ITEM_FLAG,
761 SERVICE_STARTING_DELAY,
762 SHELF_LIFE_CODE,
763 SHELF_LIFE_DAYS,
764 SHIPPABLE_ITEM_FLAG,
765 SHIP_MODEL_COMPLETE_FLAG,
766 SHRINKAGE_RATE,
767 SOURCE_ORGANIZATION_ID,
768 SOURCE_SUBINVENTORY,
769 SOURCE_TYPE,
770 SO_TRANSACTIONS_FLAG,
771 START_AUTO_LOT_NUMBER,
772 START_AUTO_SERIAL_NUMBER,
773 START_DATE_ACTIVE,
774 STD_LOT_SIZE,
775 STOCK_ENABLED_FLAG,
776 SUMMARY_FLAG,
777 TAXABLE_FLAG,
778 TAX_CODE,
779 TIME_BILLABLE_FLAG,
780 UNIT_OF_ISSUE,
781 UNIT_VOLUME,
782 UNIT_WEIGHT,
783 UN_NUMBER_ID,
784 VARIABLE_LEAD_TIME,
785 VENDOR_WARRANTY_FLAG,
786 VOLUME_UOM_CODE,
787 WARRANTY_VENDOR_ID,
788 WEIGHT_UOM_CODE,
789 decode(x_master_org,X_org_id,WIP_SUPPLY_LOCATOR_ID,NULL), --Bug5916866
790 decode(x_master_org,X_org_id,WIP_SUPPLY_SUBINVENTORY,NULL), --Bug5916866
791 WIP_SUPPLY_TYPE,
792 GLOBAL_ATTRIBUTE_CATEGORY,
793 GLOBAL_ATTRIBUTE1,
794 GLOBAL_ATTRIBUTE2,
795 GLOBAL_ATTRIBUTE3,
796 GLOBAL_ATTRIBUTE4,
797 GLOBAL_ATTRIBUTE5,
798 GLOBAL_ATTRIBUTE6,
799 GLOBAL_ATTRIBUTE7,
800 GLOBAL_ATTRIBUTE8,
801 GLOBAL_ATTRIBUTE9,
802 GLOBAL_ATTRIBUTE10,
803 DEFAULT_SO_SOURCE_TYPE,
804 CREATE_SUPPLY_FLAG ,
805 WEB_STATUS ,
806 CHECK_SHORTAGES_FLAG,
807 PURCHASING_TAX_CODE,
808 CONTAINER_ITEM_FLAG,
809 VEHICLE_ITEM_FLAG,
810 CONTAINER_TYPE_CODE,
811 INTERNAL_VOLUME,
812 MAXIMUM_LOAD_WEIGHT,
813 MINIMUM_FILL_PERCENT,
814 OVERCOMPLETION_TOLERANCE_TYPE ,
815 OVERCOMPLETION_TOLERANCE_VALUE ,
816 CONTRACT_ITEM_TYPE_CODE ,
817 SUBSCRIPTION_DEPEND_FLAG ,
818 OVER_SHIPMENT_TOLERANCE,
819 UNDER_SHIPMENT_TOLERANCE,
820 OVER_RETURN_TOLERANCE ,
821 UNDER_RETURN_TOLERANCE ,
822 EQUIPMENT_TYPE ,
823 RECOVERED_PART_DISP_CODE ,
824 DEFECT_TRACKING_ON_FLAG ,
825 EVENT_FLAG ,
826 ELECTRONIC_FLAG ,
827 DOWNLOADABLE_FLAG,
828 VOL_DISCOUNT_EXEMPT_FLAG ,
829 COUPON_EXEMPT_FLAG ,
830 COMMS_NL_TRACKABLE_FLAG ,
831 ASSET_CREATION_CODE ,
832 COMMS_ACTIVATION_REQD_FLAG ,
833 ORDERABLE_ON_WEB_FLAG ,
834 BACK_ORDERABLE_FLAG ,
835 INDIVISIBLE_FLAG ,
836 DIMENSION_UOM_CODE ,
837 UNIT_LENGTH ,
838 UNIT_WIDTH ,
839 UNIT_HEIGHT ,
840 BULK_PICKED_FLAG ,
841 LOT_STATUS_ENABLED ,
842 DEFAULT_LOT_STATUS_ID ,
843 SERIAL_STATUS_ENABLED ,
844 DEFAULT_SERIAL_STATUS_ID ,
845 LOT_SPLIT_ENABLED ,
846 LOT_MERGE_ENABLED ,
847 INVENTORY_CARRY_PENALTY ,
848 OPERATION_SLACK_PENALTY ,
849 FINANCING_ALLOWED_FLAG ,
850 EAM_ITEM_TYPE ,
851 EAM_ACTIVITY_TYPE_CODE ,
852 EAM_ACTIVITY_CAUSE_CODE ,
853 EAM_ACT_NOTIFICATION_FLAG,
854 EAM_ACT_SHUTDOWN_STATUS ,
855 DUAL_UOM_CONTROL ,
856 SECONDARY_UOM_CODE,
857 DUAL_UOM_DEVIATION_HIGH ,
858 DUAL_UOM_DEVIATION_LOW ,
859 SERV_REQ_ENABLED_CODE ,
860 SERV_BILLING_ENABLED_FLAG ,
861 SERV_IMPORTANCE_LEVEL ,
862 PLANNED_INV_POINT_FLAG ,
863 LOT_TRANSLATE_ENABLED ,
864 SUBSTITUTION_WINDOW_CODE ,
865 SUBSTITUTION_WINDOW_DAYS ,
866 IB_ITEM_INSTANCE_CLASS ,
867 CONFIG_MODEL_TYPE ,
868 LOT_SUBSTITUTION_ENABLED ,
869 MINIMUM_LICENSE_QUANTITY ,
870 EAM_ACTIVITY_SOURCE_CODE ,
871 CURRENT_PHASE_ID ,
872 LIFECYCLE_ID ,
873 PRODUCT_FAMILY_ITEM_ID,
874 USAGE_ITEM_FLAG,
875 TRACKING_QUANTITY_IND,
876 ONT_PRICING_QTY_SOURCE,
877 CONSIGNED_FLAG,
878 ASN_AUTOEXPIRE_FLAG,
879 VMI_FORECAST_TYPE,
880 EXCLUDE_FROM_BUDGET_FLAG,
881 DRP_PLANNED_FLAG,
882 CRITICAL_COMPONENT_FLAG,
883 CONTINOUS_TRANSFER,
884 CONVERGENCE,
885 DIVERGENCE,
886 APPROVAL_STATUS
887 /* Start Bug 3713912 */
888 ,SECONDARY_DEFAULT_IND,
889 ATTRIBUTE16,
890 ATTRIBUTE17,
891 ATTRIBUTE18,
892 ATTRIBUTE19,
893 ATTRIBUTE20,
894 ATTRIBUTE21,
895 ATTRIBUTE22,
896 ATTRIBUTE23,
897 ATTRIBUTE24,
898 ATTRIBUTE25,
899 ATTRIBUTE26,
900 ATTRIBUTE27,
901 ATTRIBUTE28,
902 ATTRIBUTE29,
903 ATTRIBUTE30,
904 LOT_DIVISIBLE_FLAG,
905 GRADE_CONTROL_FLAG,
906 DEFAULT_GRADE,
907 CHILD_LOT_FLAG,
908 PARENT_CHILD_GENERATION_FLAG,
909 CHILD_LOT_PREFIX,
910 CHILD_LOT_STARTING_NUMBER,
911 CHILD_LOT_VALIDATION_FLAG,
912 COPY_LOT_ATTRIBUTE_FLAG,
913 RECIPE_ENABLED_FLAG,
914 PROCESS_COSTING_ENABLED_FLAG,
915 RETEST_INTERVAL,
916 EXPIRATION_ACTION_INTERVAL,
917 EXPIRATION_ACTION_CODE,
918 MATURITY_DAYS,
919 HOLD_DAYS,
920 PROCESS_QUALITY_ENABLED_FLAG,
921 PROCESS_EXECUTION_ENABLED_FLAG,
922 PROCESS_SUPPLY_SUBINVENTORY,
923 PROCESS_SUPPLY_LOCATOR_ID,
924 PROCESS_YIELD_SUBINVENTORY,
925 PROCESS_YIELD_LOCATOR_ID,
926 HAZARDOUS_MATERIAL_FLAG,
927 CAS_NUMBER
928 /* End Bug 3713912 */
929
930 FROM MTL_SYSTEM_ITEMS
931 WHERE INVENTORY_ITEM_ID = X_eng_item_id
932 AND ORGANIZATION_ID = X_org_id;
933
934 /* Select Statement to fetch Long_Descrition -Bug 7591561 */
935 SELECT long_description
936 INTO X_long_description
937 FROM MTL_SYSTEM_ITEMS_TL
938 WHERE INVENTORY_ITEM_ID = X_eng_item_id
939 AND ORGANIZATION_ID = X_org_id
940 AND LANGUAGE=userenv('LANG');
941 /* End Bug 7591561 */
942
943 insert into MTL_SYSTEM_ITEMS_TL (
944 INVENTORY_ITEM_ID,
945 ORGANIZATION_ID,
946 LANGUAGE,
947 SOURCE_LANG,
948 DESCRIPTION,
949 LAST_UPDATE_DATE,
950 LAST_UPDATED_BY,
951 CREATION_DATE,
952 CREATED_BY,
953 LAST_UPDATE_LOGIN,
954 long_description /* Bug 7591561 */
955
956 ) select
957 X_mfg_item_id,
958 X_master_org,
959 L.LANGUAGE_CODE,
960 userenv('LANG'),
961 X_mfg_description,
962 sysdate,
963 to_number(Fnd_Profile.Value('USER_ID')),
964 sysdate,
965 to_number(Fnd_Profile.Value('USER_ID')),
966 to_number(Fnd_Profile.Value('LOGIN_ID')),
967 X_long_description /* Bug 7591561 */
968
969 from FND_LANGUAGES L
970 where L.INSTALLED_FLAG in ('I', 'B')
971 and not exists
972 ( select NULL
973 from MTL_SYSTEM_ITEMS_TL T
974 where T.INVENTORY_ITEM_ID = X_mfg_item_id
975 and T.ORGANIZATION_ID = X_master_org
976 and T.LANGUAGE = L.LANGUAGE_CODE );
977 EXCEPTION
978 WHEN OTHERS THEN
979 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SYSTEM_ITEMS',
980 stmt_num => 1002,
981 message_name => 'ENG_ENUBRT_ERROR',
982 token => SQLERRM);
983
984 END C_MTL_SYSTEM_ITEMS;
985
986 PROCEDURE C_MTL_ITEM_CATEGORIES (
987 X_org_id IN NUMBER,
988 X_master_org IN NUMBER,
989 X_eng_item_id IN NUMBER,
990 X_mfg_item_id IN NUMBER,
991 X_last_login_id IN NUMBER,
992 X_mfg_description IN VARCHAR2,
993 X_ecn_name IN VARCHAR2
994 )
995 IS
996 BEGIN
997 INSERT INTO MTL_ITEM_CATEGORIES(
998 CATEGORY_ID,
999 CATEGORY_SET_ID,
1000 CREATED_BY,
1001 CREATION_DATE,
1002 INVENTORY_ITEM_ID,
1003 LAST_UPDATED_BY,
1004 LAST_UPDATE_DATE,
1005 LAST_UPDATE_LOGIN,
1006 ORGANIZATION_ID,
1007 PROGRAM_APPLICATION_ID,
1008 PROGRAM_ID,
1009 PROGRAM_UPDATE_DATE,
1010 REQUEST_ID)
1011 SELECT
1012 CATEGORY_ID,
1013 CATEGORY_SET_ID,
1014 to_number(Fnd_Profile.Value('USER_ID')),
1015 SYSDATE,
1016 X_mfg_item_id,
1017 to_number(Fnd_Profile.Value('USER_ID')),
1018 SYSDATE,
1019 to_number(Fnd_Profile.Value('LOGIN_ID')),
1020 X_master_org,
1021 PROGRAM_APPLICATION_ID,
1022 PROGRAM_ID,
1023 PROGRAM_UPDATE_DATE,
1024 REQUEST_ID
1025 FROM MTL_ITEM_CATEGORIES
1026 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1027 AND ORGANIZATION_ID = X_org_id;
1028
1029 EXCEPTION
1030 WHEN OTHERS THEN
1031 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_CATEGORIES',
1032 stmt_num => 1003,
1033 message_name => 'ENG_ENUBRT_ERROR',
1034 token => SQLERRM);
1035
1036 END C_MTL_ITEM_CATEGORIES;
1037
1038 PROCEDURE C_MTL_DESCR_ELEMENT_VALUES (
1039 X_org_id IN NUMBER,
1040 X_master_org IN NUMBER,
1041 X_eng_item_id IN NUMBER,
1042 X_mfg_item_id IN NUMBER,
1043 X_last_login_id IN NUMBER,
1044 X_mfg_description IN VARCHAR2,
1045 X_ecn_name IN VARCHAR2
1046 )
1047 IS
1048 BEGIN
1049
1050 INSERT INTO MTL_DESCR_ELEMENT_VALUES(
1051 CREATED_BY,
1052 CREATION_DATE,
1053 DEFAULT_ELEMENT_FLAG,
1054 ELEMENT_NAME,
1055 ELEMENT_SEQUENCE,
1056 ELEMENT_VALUE,
1057 INVENTORY_ITEM_ID,
1058 LAST_UPDATED_BY,
1059 LAST_UPDATE_DATE,
1060 LAST_UPDATE_LOGIN,
1061 PROGRAM_APPLICATION_ID,
1062 PROGRAM_ID,
1063 PROGRAM_UPDATE_DATE,
1064 REQUEST_ID)
1065 SELECT
1066 to_number(Fnd_Profile.Value('USER_ID')),
1067 SYSDATE,
1068 DEFAULT_ELEMENT_FLAG,
1069 ELEMENT_NAME,
1070 ELEMENT_SEQUENCE,
1071 ELEMENT_VALUE,
1072 X_mfg_item_id,
1073 to_number(Fnd_Profile.Value('USER_ID')),
1074 SYSDATE,
1075 to_number(Fnd_Profile.Value('LOGIN_ID')),
1076 PROGRAM_APPLICATION_ID,
1077 PROGRAM_ID,
1078 PROGRAM_UPDATE_DATE,
1079 REQUEST_ID
1080 FROM MTL_DESCR_ELEMENT_VALUES
1081 WHERE INVENTORY_ITEM_ID = X_eng_item_id;
1082
1083 EXCEPTION
1084 WHEN OTHERS THEN
1085 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_DESCR_ELEMENT_VALUES',
1086 stmt_num => 1004,
1087 message_name => 'ENG_ENUBRT_ERROR',
1088 token => SQLERRM);
1089
1090 END C_MTL_DESCR_ELEMENT_VALUES;
1091
1092 PROCEDURE C_MTL_RELATED_ITEMS (
1093 X_org_id IN NUMBER,
1094 X_master_org IN NUMBER,
1095 X_eng_item_id IN NUMBER,
1096 X_mfg_item_id IN NUMBER,
1097 X_last_login_id IN NUMBER,
1098 X_mfg_description IN VARCHAR2,
1099 X_ecn_name IN VARCHAR2
1100 )
1101 IS
1102 BEGIN
1103
1104 INSERT INTO MTL_RELATED_ITEMS(
1105 CREATED_BY,
1106 CREATION_DATE,
1107 INVENTORY_ITEM_ID,
1108 LAST_UPDATED_BY,
1109 LAST_UPDATE_DATE,
1110 LAST_UPDATE_LOGIN,
1111 ORGANIZATION_ID,
1112 PROGRAM_APPLICATION_ID,
1113 PROGRAM_ID,
1114 PROGRAM_UPDATE_DATE,
1115 RECIPROCAL_FLAG,
1116 RELATED_ITEM_ID,
1117 RELATIONSHIP_TYPE_ID,
1118 REQUEST_ID)
1119 SELECT
1120 to_number(Fnd_Profile.Value('USER_ID')),
1121 SYSDATE,
1122 X_mfg_item_id,
1123 to_number(Fnd_Profile.Value('USER_ID')),
1124 SYSDATE,
1125 to_number(Fnd_Profile.Value('LOGIN_ID')),
1126 X_master_org,
1127 PROGRAM_APPLICATION_ID,
1128 PROGRAM_ID,
1129 PROGRAM_UPDATE_DATE,
1130 RECIPROCAL_FLAG,
1131 RELATED_ITEM_ID,
1132 RELATIONSHIP_TYPE_ID,
1133 REQUEST_ID
1134 FROM MTL_RELATED_ITEMS
1135 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1136 AND ORGANIZATION_ID = X_org_id;
1137
1138 EXCEPTION
1139 WHEN OTHERS THEN
1140 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_RELATED_ITEMS',
1141 stmt_num => 1005,
1142 message_name => 'ENG_ENUBRT_ERROR',
1143 token => SQLERRM);
1144
1145 END C_MTL_RELATED_ITEMS;
1146
1147 PROCEDURE C_CST_ITEM_COSTS (
1148 X_org_id IN NUMBER,
1149 X_master_org IN NUMBER,
1150 X_eng_item_id IN NUMBER,
1151 X_mfg_item_id IN NUMBER,
1152 X_last_login_id IN NUMBER,
1153 X_mfg_description IN VARCHAR2,
1154 X_ecn_name IN VARCHAR2
1155 )
1156 IS
1157 BEGIN
1158
1159 INSERT INTO CST_ITEM_COSTS(
1160 ATTRIBUTE1,
1161 ATTRIBUTE10,
1162 ATTRIBUTE11,
1163 ATTRIBUTE12,
1164 ATTRIBUTE13,
1165 ATTRIBUTE14,
1166 ATTRIBUTE15,
1167 ATTRIBUTE2,
1168 ATTRIBUTE3,
1169 ATTRIBUTE4,
1170 ATTRIBUTE5,
1171 ATTRIBUTE6,
1172 ATTRIBUTE7,
1173 ATTRIBUTE8,
1174 ATTRIBUTE9,
1175 ATTRIBUTE_CATEGORY,
1176 BASED_ON_ROLLUP_FLAG,
1177 BURDEN_COST,
1178 COST_TYPE_ID,
1179 COST_UPDATE_ID,
1180 CREATED_BY,
1181 CREATION_DATE,
1182 DEFAULTED_FLAG,
1183 INVENTORY_ASSET_FLAG,
1184 INVENTORY_ITEM_ID,
1185 ITEM_COST,
1186 LAST_UPDATED_BY,
1187 LAST_UPDATE_DATE,
1188 LAST_UPDATE_LOGIN,
1189 LOT_SIZE,
1190 MATERIAL_COST,
1191 MATERIAL_OVERHEAD_COST,
1192 ORGANIZATION_ID,
1193 OUTSIDE_PROCESSING_COST,
1194 OVERHEAD_COST,
1195 PL_ITEM_COST,
1196 PL_MATERIAL,
1197 PL_MATERIAL_OVERHEAD,
1198 PL_OUTSIDE_PROCESSING,
1199 PL_OVERHEAD,
1200 PL_RESOURCE,
1201 PROGRAM_APPLICATION_ID,
1202 PROGRAM_ID,
1203 PROGRAM_UPDATE_DATE,
1204 REQUEST_ID,
1205 RESOURCE_COST,
1206 SHRINKAGE_RATE,
1207 TL_ITEM_COST,
1208 TL_MATERIAL,
1209 TL_MATERIAL_OVERHEAD,
1210 TL_OUTSIDE_PROCESSING,
1211 TL_OVERHEAD,
1212 TL_RESOURCE,
1213 UNBURDENED_COST)
1214 SELECT
1215 ATTRIBUTE1,
1216 ATTRIBUTE10,
1217 ATTRIBUTE11,
1218 ATTRIBUTE12,
1219 ATTRIBUTE13,
1220 ATTRIBUTE14,
1221 ATTRIBUTE15,
1222 ATTRIBUTE2,
1223 ATTRIBUTE3,
1224 ATTRIBUTE4,
1225 ATTRIBUTE5,
1226 ATTRIBUTE6,
1227 ATTRIBUTE7,
1228 ATTRIBUTE8,
1229 ATTRIBUTE9,
1230 ATTRIBUTE_CATEGORY,
1231 BASED_ON_ROLLUP_FLAG,
1232 BURDEN_COST,
1233 COST_TYPE_ID,
1234 COST_UPDATE_ID,
1235 to_number(Fnd_Profile.Value('USER_ID')),
1236 SYSDATE,
1237 DEFAULTED_FLAG,
1238 INVENTORY_ASSET_FLAG,
1239 X_mfg_item_id,
1240 ITEM_COST,
1241 to_number(Fnd_Profile.Value('USER_ID')),
1242 SYSDATE,
1243 to_number(Fnd_Profile.Value('LOGIN_ID')),
1244 LOT_SIZE,
1245 MATERIAL_COST,
1246 MATERIAL_OVERHEAD_COST,
1247 X_master_org,
1248 OUTSIDE_PROCESSING_COST,
1249 OVERHEAD_COST,
1250 PL_ITEM_COST,
1251 PL_MATERIAL,
1252 PL_MATERIAL_OVERHEAD,
1253 PL_OUTSIDE_PROCESSING,
1254 PL_OVERHEAD,
1255 PL_RESOURCE,
1256 PROGRAM_APPLICATION_ID,
1257 PROGRAM_ID,
1258 PROGRAM_UPDATE_DATE,
1259 REQUEST_ID,
1260 RESOURCE_COST,
1261 SHRINKAGE_RATE,
1262 TL_ITEM_COST,
1263 TL_MATERIAL,
1264 TL_MATERIAL_OVERHEAD,
1265 TL_OUTSIDE_PROCESSING,
1266 TL_OVERHEAD,
1267 TL_RESOURCE,
1268 UNBURDENED_COST
1269 FROM CST_ITEM_COSTS
1270 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1271 AND ORGANIZATION_ID = X_org_id;
1272
1273 EXCEPTION
1274 WHEN OTHERS THEN
1275 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_ITEM_COSTS',
1276 stmt_num => 1006,
1277 message_name => 'ENG_ENUBRT_ERROR',
1278 token => SQLERRM);
1279
1280 END C_CST_ITEM_COSTS;
1281
1282 PROCEDURE C_CST_ITEM_COST_DETAILS (
1283 X_org_id IN NUMBER,
1284 X_master_org IN NUMBER,
1285 X_eng_item_id IN NUMBER,
1286 X_mfg_item_id IN NUMBER,
1287 X_last_login_id IN NUMBER,
1288 X_mfg_description IN VARCHAR2,
1289 X_ecn_name IN VARCHAR2
1290 )
1291 IS
1292 BEGIN
1293
1294 INSERT INTO CST_ITEM_COST_DETAILS(
1295 ACTIVITY_CONTEXT,
1296 ACTIVITY_ID,
1297 ACTIVITY_UNITS,
1298 ATTRIBUTE1,
1299 ATTRIBUTE10,
1300 ATTRIBUTE11,
1301 ATTRIBUTE12,
1302 ATTRIBUTE13,
1303 ATTRIBUTE14,
1304 ATTRIBUTE15,
1305 ATTRIBUTE2,
1306 ATTRIBUTE3,
1307 ATTRIBUTE4,
1308 ATTRIBUTE5,
1309 ATTRIBUTE6,
1310 ATTRIBUTE7,
1311 ATTRIBUTE8,
1312 ATTRIBUTE9,
1313 ATTRIBUTE_CATEGORY,
1314 BASIS_FACTOR,
1315 BASIS_RESOURCE_ID,
1316 BASIS_TYPE,
1317 COST_ELEMENT_ID,
1318 COST_TYPE_ID,
1319 CREATED_BY,
1320 CREATION_DATE,
1321 DEPARTMENT_ID,
1322 INVENTORY_ITEM_ID,
1323 ITEM_COST,
1324 ITEM_UNITS,
1325 LAST_UPDATED_BY,
1326 LAST_UPDATE_DATE,
1327 LAST_UPDATE_LOGIN,
1328 LEVEL_TYPE,
1329 NET_YIELD_OR_SHRINKAGE_FACTOR,
1330 OPERATION_SEQUENCE_ID,
1331 OPERATION_SEQ_NUM,
1332 ORGANIZATION_ID,
1333 PROGRAM_APPLICATION_ID,
1334 PROGRAM_ID,
1335 PROGRAM_UPDATE_DATE,
1336 REQUEST_ID,
1337 RESOURCE_ID,
1338 RESOURCE_RATE,
1339 RESOURCE_SEQ_NUM,
1340 ROLLUP_SOURCE_TYPE,
1341 USAGE_RATE_OR_AMOUNT)
1342 SELECT
1343 ACTIVITY_CONTEXT,
1344 ACTIVITY_ID,
1345 ACTIVITY_UNITS,
1346 ATTRIBUTE1,
1347 ATTRIBUTE10,
1348 ATTRIBUTE11,
1349 ATTRIBUTE12,
1350 ATTRIBUTE13,
1351 ATTRIBUTE14,
1352 ATTRIBUTE15,
1353 ATTRIBUTE2,
1354 ATTRIBUTE3,
1355 ATTRIBUTE4,
1356 ATTRIBUTE5,
1357 ATTRIBUTE6,
1358 ATTRIBUTE7,
1359 ATTRIBUTE8,
1360 ATTRIBUTE9,
1361 ATTRIBUTE_CATEGORY,
1362 BASIS_FACTOR,
1363 BASIS_RESOURCE_ID,
1364 BASIS_TYPE,
1365 COST_ELEMENT_ID,
1366 COST_TYPE_ID,
1367 to_number(Fnd_Profile.Value('USER_ID')),
1368 SYSDATE,
1369 DEPARTMENT_ID,
1370 X_mfg_item_id,
1371 ITEM_COST,
1372 ITEM_UNITS,
1373 to_number(Fnd_Profile.Value('USER_ID')),
1374 SYSDATE,
1375 to_number(Fnd_Profile.Value('LOGIN_ID')),
1376 LEVEL_TYPE,
1377 NET_YIELD_OR_SHRINKAGE_FACTOR,
1378 OPERATION_SEQUENCE_ID,
1379 OPERATION_SEQ_NUM,
1380 X_master_org,
1381 PROGRAM_APPLICATION_ID,
1382 PROGRAM_ID,
1383 PROGRAM_UPDATE_DATE,
1384 REQUEST_ID,
1385 RESOURCE_ID,
1386 RESOURCE_RATE,
1387 RESOURCE_SEQ_NUM,
1388 ROLLUP_SOURCE_TYPE,
1389 USAGE_RATE_OR_AMOUNT
1390 FROM CST_ITEM_COST_DETAILS
1391 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1392 AND ORGANIZATION_ID = X_org_id;
1393
1394 EXCEPTION
1395 WHEN OTHERS THEN
1396 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_ITEM_COST_DETAILS',
1397 stmt_num => 1007,
1398 message_name => 'ENG_ENUBRT_ERROR',
1399 token => SQLERRM);
1400
1401 END C_CST_ITEM_COST_DETAILS;
1402
1403 PROCEDURE C_MTL_ITEM_SUB_INVENTORIES (
1404 X_org_id IN NUMBER,
1405 X_master_org IN NUMBER,
1406 X_eng_item_id IN NUMBER,
1407 X_mfg_item_id IN NUMBER,
1408 X_last_login_id IN NUMBER,
1409 X_mfg_description IN VARCHAR2,
1410 X_ecn_name IN VARCHAR2
1411 )
1412 IS
1413 BEGIN
1414
1415 INSERT INTO MTL_ITEM_SUB_INVENTORIES(
1416 ATTRIBUTE1,
1417 ATTRIBUTE10,
1418 ATTRIBUTE11,
1419 ATTRIBUTE12,
1420 ATTRIBUTE13,
1421 ATTRIBUTE14,
1422 ATTRIBUTE15,
1423 ATTRIBUTE2,
1424 ATTRIBUTE3,
1425 ATTRIBUTE4,
1426 ATTRIBUTE5,
1427 ATTRIBUTE6,
1428 ATTRIBUTE7,
1429 ATTRIBUTE8,
1430 ATTRIBUTE9,
1431 ATTRIBUTE_CATEGORY,
1432 CREATED_BY,
1433 CREATION_DATE,
1434 ENCUMBRANCE_ACCOUNT,
1435 FIXED_LOT_MULTIPLE,
1436 INVENTORY_ITEM_ID,
1437 INVENTORY_PLANNING_CODE,
1438 LAST_UPDATED_BY,
1439 LAST_UPDATE_DATE,
1440 LAST_UPDATE_LOGIN,
1441 MAXIMUM_ORDER_QUANTITY,
1442 MAX_MINMAX_QUANTITY,
1443 MINIMUM_ORDER_QUANTITY,
1444 MIN_MINMAX_QUANTITY,
1445 ORGANIZATION_ID,
1446 PICKING_ORDER,
1447 POSTPROCESSING_LEAD_TIME,
1448 PREPROCESSING_LEAD_TIME,
1449 PRIMARY_SUBINVENTORY_FLAG,
1450 PROCESSING_LEAD_TIME,
1451 PROGRAM_APPLICATION_ID,
1452 PROGRAM_ID,
1453 PROGRAM_UPDATE_DATE,
1454 REQUEST_ID,
1455 SECONDARY_INVENTORY,
1456 SOURCE_ORGANIZATION_ID,
1457 SOURCE_SUBINVENTORY,
1458 SOURCE_TYPE)
1459 SELECT
1460 ATTRIBUTE1,
1461 ATTRIBUTE10,
1462 ATTRIBUTE11,
1463 ATTRIBUTE12,
1464 ATTRIBUTE13,
1465 ATTRIBUTE14,
1466 ATTRIBUTE15,
1467 ATTRIBUTE2,
1468 ATTRIBUTE3,
1469 ATTRIBUTE4,
1470 ATTRIBUTE5,
1471 ATTRIBUTE6,
1472 ATTRIBUTE7,
1473 ATTRIBUTE8,
1474 ATTRIBUTE9,
1475 ATTRIBUTE_CATEGORY,
1476 to_number(Fnd_Profile.Value('USER_ID')),
1477 SYSDATE,
1478 ENCUMBRANCE_ACCOUNT,
1479 FIXED_LOT_MULTIPLE,
1480 X_mfg_item_id,
1481 INVENTORY_PLANNING_CODE,
1482 to_number(Fnd_Profile.Value('USER_ID')),
1483 SYSDATE,
1484 to_number(Fnd_Profile.Value('LOGIN_ID')),
1485 MAXIMUM_ORDER_QUANTITY,
1486 MAX_MINMAX_QUANTITY,
1487 MINIMUM_ORDER_QUANTITY,
1488 MIN_MINMAX_QUANTITY,
1489 X_master_org,
1490 PICKING_ORDER,
1491 POSTPROCESSING_LEAD_TIME,
1492 PREPROCESSING_LEAD_TIME,
1493 PRIMARY_SUBINVENTORY_FLAG,
1494 PROCESSING_LEAD_TIME,
1495 PROGRAM_APPLICATION_ID,
1496 PROGRAM_ID,
1497 PROGRAM_UPDATE_DATE,
1498 REQUEST_ID,
1499 SECONDARY_INVENTORY,
1500 SOURCE_ORGANIZATION_ID,
1501 SOURCE_SUBINVENTORY,
1502 SOURCE_TYPE
1503 FROM MTL_ITEM_SUB_INVENTORIES
1504 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1505 AND ORGANIZATION_ID = X_master_org;-- Bug:3264573 X_org_id;
1506
1507 EXCEPTION
1508 WHEN OTHERS THEN
1509 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_SUB_INVENTORIES',
1510 stmt_num => 1008,
1511 message_name => 'ENG_ENUBRT_ERROR',
1512 token => SQLERRM);
1513
1514 END C_MTL_ITEM_SUB_INVENTORIES;
1515
1516 PROCEDURE C_MTL_SECONDARY_LOCATORS (
1517 X_org_id IN NUMBER,
1518 X_master_org IN NUMBER,
1519 X_eng_item_id IN NUMBER,
1520 X_mfg_item_id IN NUMBER,
1521 X_last_login_id IN NUMBER,
1522 X_mfg_description IN VARCHAR2,
1523 X_ecn_name IN VARCHAR2
1524 )
1525 IS
1526 BEGIN
1527
1528 INSERT INTO MTL_SECONDARY_LOCATORS(
1529 CREATED_BY,
1530 CREATION_DATE,
1531 INVENTORY_ITEM_ID,
1532 LAST_UPDATED_BY,
1533 LAST_UPDATE_DATE,
1534 LAST_UPDATE_LOGIN,
1535 ORGANIZATION_ID,
1536 PICKING_ORDER,
1537 PRIMARY_LOCATOR_FLAG,
1538 PROGRAM_APPLICATION_ID,
1539 PROGRAM_ID,
1540 SECONDARY_LOCATOR,
1541 SUBINVENTORY_CODE,
1542 STATUS_ID,
1543 MAXIMUM_QUANTITY)
1544 SELECT
1545 to_number(Fnd_Profile.Value('USER_ID')),
1546 SYSDATE,
1547 X_mfg_item_id,
1548 to_number(Fnd_Profile.Value('USER_ID')),
1549 SYSDATE,
1550 to_number(Fnd_Profile.Value('LOGIN_ID')),
1551 X_master_org,
1552 PICKING_ORDER,
1553 PRIMARY_LOCATOR_FLAG,
1554 PROGRAM_APPLICATION_ID,
1555 PROGRAM_ID,
1556 SECONDARY_LOCATOR,-- Bug:3264573 All the new missing columns added
1557 SUBINVENTORY_CODE,
1558 STATUS_ID,
1559 MAXIMUM_QUANTITY
1560 FROM MTL_SECONDARY_LOCATORS
1561 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1562 AND ORGANIZATION_ID = X_master_org; --Bug:3264573 X_org_id;
1563
1564 EXCEPTION
1565 WHEN OTHERS THEN
1566 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SECONDARY_LOCATORS',
1567 stmt_num => 1009,
1568 message_name => 'ENG_ENUBRT_ERROR',
1569 token => SQLERRM);
1570
1571 END C_MTL_SECONDARY_LOCATORS;
1572
1573 PROCEDURE C_MTL_CROSS_REFERENCES (
1574 X_org_id IN NUMBER,
1575 X_master_org IN NUMBER,
1576 X_eng_item_id IN NUMBER,
1577 X_mfg_item_id IN NUMBER,
1578 X_last_login_id IN NUMBER,
1579 X_mfg_description IN VARCHAR2,
1580 X_ecn_name IN VARCHAR2
1581 )
1582 IS
1583 /* Bug : 4466566 We have to use the MTL_CROSS_REFERENCES_PKG.INSERT_ROW API for inserting data */
1584 CURSOR CUR_MTL_CROSS_REF IS
1585 SELECT
1586 SOURCE_SYSTEM_ID,
1587 START_DATE_ACTIVE,
1588 END_DATE_ACTIVE,
1589 OBJECT_VERSION_NUMBER,
1590 UOM_CODE,
1591 REVISION_ID,
1592 EPC_GTIN_SERIAL,
1593 INVENTORY_ITEM_ID,
1594 ORGANIZATION_ID,
1595 CROSS_REFERENCE_TYPE,
1596 CROSS_REFERENCE,
1597 ORG_INDEPENDENT_FLAG,
1598 REQUEST_ID,
1599 ATTRIBUTE1,
1600 ATTRIBUTE2,
1601 ATTRIBUTE3,
1602 ATTRIBUTE4,
1603 ATTRIBUTE5,
1604 ATTRIBUTE6,
1605 ATTRIBUTE7,
1606 ATTRIBUTE8,
1607 ATTRIBUTE9,
1608 ATTRIBUTE10,
1609 ATTRIBUTE11,
1610 ATTRIBUTE12,
1611 ATTRIBUTE13,
1612 ATTRIBUTE14,
1613 ATTRIBUTE15,
1614 ATTRIBUTE_CATEGORY,
1615 DESCRIPTION,
1616 CREATION_DATE,
1617 CREATED_BY,
1618 LAST_UPDATE_DATE,
1619 LAST_UPDATED_BY,
1620 LAST_UPDATE_LOGIN,
1621 PROGRAM_APPLICATION_ID,
1622 PROGRAM_ID,
1623 PROGRAM_UPDATE_DATE
1624 FROM MTL_CROSS_REFERENCES_VL
1625 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1626 AND ORGANIZATION_ID = X_org_id;
1627
1628 cross_ref_cursor CUR_MTL_CROSS_REF%ROWTYPE;
1629 x_cross_ref_id NUMBER;
1630 BEGIN
1631 FOR cross_ref_cursor in CUR_MTL_CROSS_REF LOOP
1632 MTL_CROSS_REFERENCES_PKG.INSERT_ROW (
1633 P_SOURCE_SYSTEM_ID => cross_ref_cursor.SOURCE_SYSTEM_ID
1634 ,P_START_DATE_ACTIVE => cross_ref_cursor.START_DATE_ACTIVE
1635 ,P_END_DATE_ACTIVE => cross_ref_cursor.END_DATE_ACTIVE
1636 ,P_OBJECT_VERSION_NUMBER => cross_ref_cursor.OBJECT_VERSION_NUMBER
1637 ,P_UOM_CODE => cross_ref_cursor.UOM_CODE
1638 ,P_REVISION_ID => cross_ref_cursor.REVISION_ID
1639 ,P_EPC_GTIN_SERIAL => cross_ref_cursor.EPC_GTIN_SERIAL
1640 ,P_INVENTORY_ITEM_ID => cross_ref_cursor.INVENTORY_ITEM_ID
1641 ,P_ORGANIZATION_ID => cross_ref_cursor.ORGANIZATION_ID
1642 ,P_CROSS_REFERENCE_TYPE => cross_ref_cursor.CROSS_REFERENCE_TYPE
1643 ,P_CROSS_REFERENCE => cross_ref_cursor.CROSS_REFERENCE
1644 ,P_ORG_INDEPENDENT_FLAG => cross_ref_cursor.ORG_INDEPENDENT_FLAG
1645 ,P_REQUEST_ID => cross_ref_cursor.REQUEST_ID
1646 ,P_ATTRIBUTE1 => cross_ref_cursor.ATTRIBUTE1
1647 ,P_ATTRIBUTE2 => cross_ref_cursor.ATTRIBUTE2
1648 ,P_ATTRIBUTE3 => cross_ref_cursor.ATTRIBUTE3
1649 ,P_ATTRIBUTE4 => cross_ref_cursor.ATTRIBUTE4
1650 ,P_ATTRIBUTE5 => cross_ref_cursor.ATTRIBUTE5
1651 ,P_ATTRIBUTE6 => cross_ref_cursor.ATTRIBUTE6
1652 ,P_ATTRIBUTE7 => cross_ref_cursor.ATTRIBUTE7
1653 ,P_ATTRIBUTE8 => cross_ref_cursor.ATTRIBUTE8
1654 ,P_ATTRIBUTE9 => cross_ref_cursor.ATTRIBUTE9
1655 ,P_ATTRIBUTE10 => cross_ref_cursor.ATTRIBUTE10
1656 ,P_ATTRIBUTE11 => cross_ref_cursor.ATTRIBUTE11
1657 ,P_ATTRIBUTE12 => cross_ref_cursor.ATTRIBUTE12
1658 ,P_ATTRIBUTE13 => cross_ref_cursor.ATTRIBUTE13
1659 ,P_ATTRIBUTE14 => cross_ref_cursor.ATTRIBUTE14
1660 ,P_ATTRIBUTE15 => cross_ref_cursor.ATTRIBUTE15
1661 ,P_ATTRIBUTE_CATEGORY => cross_ref_cursor.ATTRIBUTE_CATEGORY
1662 ,P_DESCRIPTION => cross_ref_cursor.DESCRIPTION
1663 ,P_CREATION_DATE => cross_ref_cursor.CREATION_DATE
1664 ,P_CREATED_BY => cross_ref_cursor.CREATED_BY
1665 ,P_LAST_UPDATE_DATE => cross_ref_cursor.LAST_UPDATE_DATE
1666 ,P_LAST_UPDATED_BY => cross_ref_cursor.LAST_UPDATED_BY
1667 ,P_LAST_UPDATE_LOGIN => cross_ref_cursor.LAST_UPDATE_LOGIN
1668 ,P_PROGRAM_APPLICATION_ID => cross_ref_cursor.PROGRAM_APPLICATION_ID
1669 ,P_PROGRAM_ID => cross_ref_cursor.PROGRAM_ID
1670 ,P_PROGRAM_UPDATE_DATE => cross_ref_cursor.PROGRAM_UPDATE_DATE
1671 ,X_CROSS_REFERENCE_ID => x_cross_ref_id
1672 );
1673 END LOOP;
1674 /* End Bug : 4466566 */
1675 END C_MTL_CROSS_REFERENCES;
1676
1677 PROCEDURE C_MTL_PENDING_ITEM_STATUS (
1678 X_org_id IN NUMBER,
1679 X_master_org IN NUMBER,
1680 X_eng_item_id IN NUMBER,
1681 X_mfg_item_id IN NUMBER,
1682 X_last_login_id IN NUMBER,
1683 X_mfg_description IN VARCHAR2,
1684 X_ecn_name IN VARCHAR2
1685 )
1686 IS
1687 BEGIN
1688
1689 INSERT INTO MTL_PENDING_ITEM_STATUS(
1690 CREATED_BY,
1691 CREATION_DATE,
1692 EFFECTIVE_DATE,
1693 IMPLEMENTED_DATE,
1694 INVENTORY_ITEM_ID,
1695 LAST_UPDATED_BY,
1696 LAST_UPDATE_DATE,
1697 LAST_UPDATE_LOGIN,
1698 ORGANIZATION_ID,
1699 PENDING_FLAG,
1700 PROGRAM_APPLICATION_ID,
1701 PROGRAM_ID,
1702 PROGRAM_UPDATE_DATE,
1703 REQUEST_ID,
1704 STATUS_CODE)
1705 SELECT
1706 to_number(Fnd_Profile.Value('USER_ID')),
1707 SYSDATE,
1708 EFFECTIVE_DATE,
1709 IMPLEMENTED_DATE,
1710 X_mfg_item_id,
1711 to_number(Fnd_Profile.Value('USER_ID')),
1712 SYSDATE,
1713 to_number(Fnd_Profile.Value('LOGIN_ID')),
1714 X_master_org,
1715 PENDING_FLAG,
1716 PROGRAM_APPLICATION_ID,
1717 PROGRAM_ID,
1718 PROGRAM_UPDATE_DATE,
1719 REQUEST_ID,
1720 STATUS_CODE
1721 FROM MTL_PENDING_ITEM_STATUS
1722 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1723 AND ORGANIZATION_ID = X_org_id;
1724
1725 EXCEPTION
1726 WHEN OTHERS THEN
1727 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_PENDING_ITEM_STATUS',
1728 stmt_num => 1011,
1729 message_name => 'ENG_ENUBRT_ERROR',
1730 token => SQLERRM);
1731
1732 END C_MTL_PENDING_ITEM_STATUS;
1733
1734 PROCEDURE C_CST_STANDARD_COSTS (
1735 X_org_id IN NUMBER,
1736 X_master_org IN NUMBER,
1737 X_eng_item_id IN NUMBER,
1738 X_mfg_item_id IN NUMBER,
1739 X_last_login_id IN NUMBER,
1740 X_mfg_description IN VARCHAR2,
1741 X_ecn_name IN VARCHAR2
1742 )
1743 IS
1744 BEGIN
1745
1746 INSERT INTO CST_STANDARD_COSTS(
1747 COST_UPDATE_ID,
1748 CREATED_BY,
1749 CREATION_DATE,
1750 INTRANSIT_ADJUSTMENT_QUANTITY,
1751 INTRANSIT_ADJUSTMENT_VALUE,
1752 INVENTORY_ADJUSTMENT_QUANTITY,
1753 INVENTORY_ADJUSTMENT_VALUE,
1754 INVENTORY_ITEM_ID,
1755 LAST_COST_UPDATE_ID,
1756 LAST_UPDATED_BY,
1757 LAST_UPDATE_DATE,
1758 LAST_UPDATE_LOGIN,
1759 ORGANIZATION_ID,
1760 PROGRAM_APPLICATION_ID,
1761 PROGRAM_ID,
1762 PROGRAM_UPDATE_DATE,
1763 REQUEST_ID,
1764 STANDARD_COST,
1765 STANDARD_COST_REVISION_DATE,
1766 WIP_ADJUSTMENT_QUANTITY,
1767 WIP_ADJUSTMENT_VALUE)
1768 SELECT
1769 COST_UPDATE_ID,
1770 to_number(Fnd_Profile.Value('USER_ID')),
1771 SYSDATE,
1772 INTRANSIT_ADJUSTMENT_QUANTITY,
1773 INTRANSIT_ADJUSTMENT_VALUE,
1774 INVENTORY_ADJUSTMENT_QUANTITY,
1775 INVENTORY_ADJUSTMENT_VALUE,
1776 X_mfg_item_id,
1777 LAST_COST_UPDATE_ID,
1778 to_number(Fnd_Profile.Value('USER_ID')),
1779 SYSDATE,
1780 to_number(Fnd_Profile.Value('LOGIN_ID')),
1781 X_master_org,
1782 PROGRAM_APPLICATION_ID,
1783 PROGRAM_ID,
1784 PROGRAM_UPDATE_DATE,
1785 REQUEST_ID,
1786 STANDARD_COST,
1787 STANDARD_COST_REVISION_DATE,
1788 WIP_ADJUSTMENT_QUANTITY,
1789 WIP_ADJUSTMENT_VALUE
1790 FROM CST_STANDARD_COSTS
1791 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1792 AND ORGANIZATION_ID = X_org_id;
1793
1794 EXCEPTION
1795 WHEN OTHERS THEN
1796 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_STANDARD_COSTS',
1797 stmt_num => 1012,
1798 message_name => 'ENG_ENUBRT_ERROR',
1799 token => SQLERRM);
1800
1801 END C_CST_STANDARD_COSTS;
1802
1803 PROCEDURE C_CST_ELEMENTAL_COSTS (
1804 X_org_id IN NUMBER,
1805 X_master_org IN NUMBER,
1806 X_eng_item_id IN NUMBER,
1807 X_mfg_item_id IN NUMBER,
1808 X_last_login_id IN NUMBER,
1809 X_mfg_description IN VARCHAR2,
1810 X_ecn_name IN VARCHAR2
1811 )
1812 IS
1813 BEGIN
1814
1815 INSERT INTO CST_ELEMENTAL_COSTS(
1816 COST_ELEMENT_ID,
1817 COST_UPDATE_ID,
1818 CREATED_BY,
1819 CREATION_DATE,
1820 INVENTORY_ITEM_ID,
1821 LAST_UPDATED_BY,
1822 LAST_UPDATE_DATE,
1823 LAST_UPDATE_LOGIN,
1824 ORGANIZATION_ID,
1825 PROGRAM_APPLICATION_ID,
1826 PROGRAM_ID,
1827 PROGRAM_UPDATE_DATE,
1828 REQUEST_ID,
1829 STANDARD_COST)
1830 SELECT
1831 COST_ELEMENT_ID,
1832 COST_UPDATE_ID,
1833 to_number(Fnd_Profile.Value('USER_ID')),
1834 SYSDATE,
1835 X_mfg_item_id,
1836 to_number(Fnd_Profile.Value('USER_ID')),
1837 SYSDATE,
1838 to_number(Fnd_Profile.Value('LOGIN_ID')),
1839 X_master_org,
1840 PROGRAM_APPLICATION_ID,
1841 PROGRAM_ID,
1842 PROGRAM_UPDATE_DATE,
1843 REQUEST_ID,
1844 STANDARD_COST
1845 FROM CST_ELEMENTAL_COSTS
1846 WHERE INVENTORY_ITEM_ID = X_eng_item_id
1847 AND ORGANIZATION_ID = X_org_id;
1848
1849 EXCEPTION
1850 WHEN OTHERS THEN
1851 ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_ELEMENTAL_COSTS',
1852 stmt_num => 1013,
1853 message_name => 'ENG_ENUBRT_ERROR',
1854 token => SQLERRM);
1855
1856 END C_CST_ELEMENTAL_COSTS;
1857
1858 END ENG_COPY_TABLE_ROWS_PKG;
1859