534: p_inventory_item_id IN NUMBER
535: )
536: IS
537: SELECT revision
538: FROM mtl_item_revisions_b
539: WHERE
540: organization_id = p_organization_id AND
541: inventory_item_id = p_inventory_item_id;
542:
684: p_inventory_item_id => l_item_output.inventory_item_id
685: );
686: FETCH c_effectivity_date INTO l_revision;
687: CLOSE c_effectivity_date;
688: INV_EBI_UTIL.debug_line('STEP: 60 START update mtl_item_revisions_b');
689: UPDATE mtl_item_revisions_b
690: SET
691: implementation_date = sysdate,
692: effectivity_date = sysdate,
685: );
686: FETCH c_effectivity_date INTO l_revision;
687: CLOSE c_effectivity_date;
688: INV_EBI_UTIL.debug_line('STEP: 60 START update mtl_item_revisions_b');
689: UPDATE mtl_item_revisions_b
690: SET
691: implementation_date = sysdate,
692: effectivity_date = sysdate,
693: creation_date = sysdate,
697: WHERE
698: inventory_item_id = l_item_output.inventory_item_id AND
699: organization_id = l_item_output.organization_id AND
700: revision = l_revision;
701: INV_EBI_UTIL.debug_line('STEP: 70 END update mtl_item_revisions_b');
702: END IF;
703:
704: ELSE
705: