65: FROM MTL_UNIT_TRANSACTIONS
66: WHERE transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
67: AND organization_id = p_organization_id;
68:
69: -- bug 4951747 : removed trunc to leverage MTL_TRANSACTION_ACCOUNTS_N5 index
70: CURSOR c_mta IS
71: SELECT ROWID
72: FROM MTL_TRANSACTION_ACCOUNTS
73: WHERE transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
68:
69: -- bug 4951747 : removed trunc to leverage MTL_TRANSACTION_ACCOUNTS_N5 index
70: CURSOR c_mta IS
71: SELECT ROWID
72: FROM MTL_TRANSACTION_ACCOUNTS
73: WHERE transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
74: AND organization_id = p_organization_id;
75:
76: BEGIN
199: IF (l_debug = 1) THEN
200: inv_log_util.trace('Deleted :'||l_total_count||' rows from MUT', 'TXN_PURGE_WORKER', 9);
201: END IF;
202:
203: -- *************** Purge from MTL_TRANSACTION_ACCOUNTS ******************
204: l_total_count := 0;
205: OPEN c_mta;
206: LOOP
207: l_count := 0;
215: EXIT;
216: END IF;
217:
218: FORALL i IN rowid_list.first .. rowid_list.last
219: DELETE FROM MTL_TRANSACTION_ACCOUNTS
220: WHERE ROWID = rowid_list(i);
221:
222: l_count := SQL%ROWCOUNT;
223: COMMIT;