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,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,