APPS.FND_SOA_UTIL dependencies on FND_SOA_BODY_PIECE

Line 66: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_BODY_PIECE - '||deleted_att_count);

62: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_ATTACHMENT - '||deleted_att_count);
63:
64: /* Purge Function to delete all attachment body Data */
65: deleted_att_count := delete_body_by_date_range(v_strt_date,v_end_date);
66: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_BODY_PIECE - '||deleted_att_count);
67:
68: /* Purge Function to delete all Error Data */
69: deleted_error_count := delete_error_by_date_range(v_strt_date,v_end_date);
70: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RUNTIME_ERROR - '||deleted_error_count);

Line 206: FROM FND_SOA_BODY_PIECE WP

202: LOOP
203: BEGIN
204:
205: DELETE
206: FROM FND_SOA_BODY_PIECE WP
207: WHERE (message_id NOT IN
208: (SELECT message_id FROM FND_SOA_REQUEST))
209: AND rownum <= 20000;
210:

Line 228: 'Deleted '|| rowcount ||' rows from FND_SOA_BODY_PIECE');

224: END IF;
225: END;
226: END LOOP;
227: fnd_file.put_line(fnd_file.output,
228: 'Deleted '|| rowcount ||' rows from FND_SOA_BODY_PIECE');
229: RETURN rowcount;
230: END;
231:
232: /* Purge function to delete all Error Data */