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