DBA Data[Home] [Help]

APPS.FND_BC4J_CLEANUP_PKG dependencies on FND_PCOLL_CONTROL

Line 42: SELECT rowid FROM fnd_pcoll_control

38: PROCEDURE Delete_Control_Rows(p_older_than_date IN DATE) IS
39: h_counter NUMBER := 0;
40: h_commit_level NUMBER := 200;
41: CURSOR select_cursor IS
42: SELECT rowid FROM fnd_pcoll_control
43: WHERE updatedate < p_older_than_date;
44: BEGIN
45: FOR rec IN select_cursor LOOP
46: DELETE FROM fnd_pcoll_control

Line 46: DELETE FROM fnd_pcoll_control

42: SELECT rowid FROM fnd_pcoll_control
43: WHERE updatedate < p_older_than_date;
44: BEGIN
45: FOR rec IN select_cursor LOOP
46: DELETE FROM fnd_pcoll_control
47: WHERE rowid = rec.rowid;
48:
49: h_counter := h_counter + 1;
50: IF (h_counter = h_commit_level) THEN