DBA Data[Home] [Help]

APPS.GMI_SUMM_INV_DB_PVT dependencies on IC_LOTS_STS

Line 249: x_lots_sts OUT IC_LOTS_STS%ROWTYPE

245:
246: FUNCTION GET_LOT_ATTRIBUTES
247: (
248: p_lot_status IN VARCHAR2,
249: x_lots_sts OUT IC_LOTS_STS%ROWTYPE
250: )
251: RETURN BOOLEAN
252: IS
253: /* err_num NUMBER;*/

Line 259: FROM IC_LOTS_STS

255:
256: CURSOR Get_Lot_status(v_lot_status IN VARCHAR2)
257: IS
258: SELECT *
259: FROM IC_LOTS_STS
260: WHERE UPPER(lot_status) = UPPER(v_lot_status)
261: AND DELETE_MARK <> 1;
262:
263: