APPS.INV_TXN_PURGE_WORKER dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 59: FROM MTL_TRANSACTION_LOT_NUMBERS

55: AND organization_id = p_organization_id;
56:
57: CURSOR c_mtlt IS
58: SELECT ROWID
59: FROM MTL_TRANSACTION_LOT_NUMBERS
60: WHERE transaction_date >= l_min_date and transaction_date <= l_max_date + 1-(1/(24*3600))
61: AND organization_id = p_organization_id;
62:
63: CURSOR c_mut IS

Line 143: -- *************** Purge from MTL_TRANSACTION_LOT_NUMBERS ******************

139: IF (l_debug = 1) THEN
140: inv_log_util.trace('Deleted :'||l_total_count||' rows from MMTA', 'TXN_PURGE_WORKER', 9);
141: END IF;
142:
143: -- *************** Purge from MTL_TRANSACTION_LOT_NUMBERS ******************
144: l_total_count := 0;
145: OPEN c_mtlt;
146: LOOP
147: l_count := 0;

Line 159: DELETE FROM MTL_TRANSACTION_LOT_NUMBERS

155: EXIT;
156: END IF;
157:
158: FORALL i IN rowid_list.first .. rowid_list.last
159: DELETE FROM MTL_TRANSACTION_LOT_NUMBERS
160: WHERE ROWID = rowid_list(i);
161:
162: l_count := SQL%ROWCOUNT;
163: COMMIT;