DBA Data[Home] [Help]

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