APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on MTL_ITEM_REVISIONS_B

Line 1212: FROM mtl_item_revisions_b

1208: p_inventory_item_id IN NUMBER
1209: )
1210: IS
1211: SELECT revision
1212: FROM mtl_item_revisions_b
1213: WHERE
1214: organization_id = p_organization_id AND
1215: inventory_item_id = p_inventory_item_id;
1216:

Line 1392: INV_EBI_UTIL.debug_line('STEP 110: START update mtl_item_revisions_b');

1388:
1389: FETCH c_effectivity_date INTO l_revision;
1390: CLOSE c_effectivity_date;
1391:
1392: INV_EBI_UTIL.debug_line('STEP 110: START update mtl_item_revisions_b');
1393:
1394: UPDATE mtl_item_revisions_b
1395: SET
1396: implementation_date = sysdate,

Line 1394: UPDATE mtl_item_revisions_b

1390: CLOSE c_effectivity_date;
1391:
1392: INV_EBI_UTIL.debug_line('STEP 110: START update mtl_item_revisions_b');
1393:
1394: UPDATE mtl_item_revisions_b
1395: SET
1396: implementation_date = sysdate,
1397: effectivity_date = sysdate,
1398: creation_date = sysdate,

Line 1407: INV_EBI_UTIL.debug_line('STEP 120: END update mtl_item_revisions_b');

1403: inventory_item_id = l_item_output_obj.inventory_item_id AND
1404: organization_id = l_item_output_obj.organization_id AND
1405: revision = l_revision;
1406:
1407: INV_EBI_UTIL.debug_line('STEP 120: END update mtl_item_revisions_b');
1408: END IF;
1409:
1410: ELSE
1411: x_update_item_tbl.EXTEND(1);