APPS.GMD_SAMPLES_GRP dependencies on GMD_CHANGE_LOTS
Line 2084: INSERT INTO GMD_CHANGE_LOTS
2080:
2081:
2082: IF (p_update_change_disp_rec.LOT_NUMBER IS NOT NULL) THEN
2083: -- just one lot updated 2084: INSERT INTO GMD_CHANGE_LOTS 2085: (
2086: CHANGE_DISP_ID
2087: ,LOT_NUMBER
2088: ,FROM_LOT_STATUS_ID
Line 2116: INSERT INTO GMD_CHANGE_LOTS
2112: LOOP
2113: FETCH cur_get_lot into l_lot_number ;
2114: EXIT WHEN cur_get_lot%NOTFOUND ; -- exit when last row is fetched
2115: 2116: INSERT INTO GMD_CHANGE_LOTS 2117: (
2118: CHANGE_DISP_ID
2119: ,LOT_NUMBER
2120: ,FROM_LOT_STATUS_ID