APPS.GMD_SAMPLES_GRP dependencies on GMD_CHANGE_LOTS
Line 2266: INSERT INTO GMD_CHANGE_LOTS
2262:
2263:
2264: IF (p_update_change_disp_rec.LOT_NUMBER IS NOT NULL) THEN
2265: -- just one lot updated 2266: INSERT INTO GMD_CHANGE_LOTS 2267: (
2268: CHANGE_DISP_ID
2269: ,LOT_NUMBER
2270: ,FROM_LOT_STATUS_ID
Line 2298: INSERT INTO GMD_CHANGE_LOTS
2294: LOOP
2295: FETCH cur_get_lot into l_lot_number ;
2296: EXIT WHEN cur_get_lot%NOTFOUND ; -- exit when last row is fetched
2297: 2298: INSERT INTO GMD_CHANGE_LOTS 2299: (
2300: CHANGE_DISP_ID
2301: ,LOT_NUMBER
2302: ,FROM_LOT_STATUS_ID