[Home] [Help]
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
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: