144: and hold date is null. update_ic_loct_inv internally calls insert_ic_loct_inv
145: if there is no existing inventory*/
146: Update ic_lots_cpg
147: Set ic_hold_date = (select p_tran_rec.trans_date + ic_hold_days 148: from ic_item_cpg 149: where item_id = l_loct_inv.item_id
150: )
151: Where item_id = l_loct_inv.item_id and
152: lot_id = l_loct_inv.lot_id and