DBA Data[Home] [Help]

APPS.FND_BC4J_CLEANUP_PKG dependencies on FND_PS_TXN

Line 8: SELECT rowid FROM fnd_ps_txn

4: PROCEDURE Delete_Transaction_Rows(p_older_than_date IN DATE) IS
5: h_counter NUMBER := 0;
6: h_commit_level NUMBER := 200;
7: CURSOR select_cursor IS
8: SELECT rowid FROM fnd_ps_txn
9: WHERE creation_date < p_older_than_date;
10: BEGIN
11: FOR rec IN select_cursor LOOP
12: DELETE FROM fnd_ps_txn

Line 12: DELETE FROM fnd_ps_txn

8: SELECT rowid FROM fnd_ps_txn
9: WHERE creation_date < p_older_than_date;
10: BEGIN
11: FOR rec IN select_cursor LOOP
12: DELETE FROM fnd_ps_txn
13: WHERE rowid = rec.rowid;
14:
15: h_counter := h_counter + 1;
16: IF (h_counter = h_commit_level) THEN