APPS.FND_BC4J_CLEANUP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

PROCEDURE Delete_Transaction_Rows(p_older_than_date IN DATE) IS
    h_counter		NUMBER := 0;

Line: 7

    CURSOR select_cursor IS
	SELECT rowid FROM fnd_ps_txn
	WHERE creation_date < p_older_than_date;

Line: 11

    FOR rec IN select_cursor LOOP
 	DELETE FROM fnd_ps_txn
	WHERE rowid = rec.rowid;

Line: 33

		'FND_BC4J_CLEANUP.Delete_Transaction_Rows');

Line: 35

END Delete_Transaction_Rows;

Line: 38

PROCEDURE Delete_Control_Rows(p_older_than_date IN DATE) IS
    h_counter		NUMBER := 0;

Line: 41

    CURSOR select_cursor IS
	SELECT rowid FROM fnd_pcoll_control
	WHERE updatedate < p_older_than_date;

Line: 45

    FOR rec IN select_cursor LOOP
 	DELETE FROM fnd_pcoll_control
	WHERE rowid = rec.rowid;

Line: 67

		'FND_BC4J_CLEANUP.Delete_Control_Rows');

Line: 69

END Delete_Control_Rows;