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