30: and trunc(lines.creation_date) between l_date_from and l_date_to;
31:
32: Cursor Default_transactions (p_line_id VARCHAR2) is
33: SELECT trans_id 34: FROM ic_tran_pnd itp 35: WHERE doc_type = 'OMSO'
36: AND trans_qty = 0
37: AND lot_id = 0
38: AND delete_mark = 0
Line 79: update ic_Tran_pnd
75: LOOP
76: --
77: -- Logically delete the transactions.
78: -- 79: update ic_Tran_pnd 80: set delete_mark=1
81: where trans_id= c1rec.trans_id;
82:
83: