DBA Data[Home] [Help]

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