APPS.FND_SOA_UTIL dependencies on FND_SOA_ATTACHMENT

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

58: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RESPONSE_METHOD - '||deleted_method_count);
59:
60: /* Purge Function to delete all attachment Data */
61: deleted_att_count := delete_att_by_date_range(v_strt_date,v_end_date);
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);

Line 168: DELETE FROM FND_SOA_ATTACHMENT WA

164: BEGIN
165: LOOP
166: BEGIN
167:
168: DELETE FROM FND_SOA_ATTACHMENT WA
169: WHERE message_id NOT IN
170: (SELECT message_id FROM FND_SOA_REQUEST)
171: AND rownum <= 20000;
172:

Line 189: 'Deleted '|| rowcount ||' rows from FND_SOA_ATTACHMENT');

185: END IF;
186: END;
187: END LOOP;
188: fnd_file.put_line(fnd_file.output,
189: 'Deleted '|| rowcount ||' rows from FND_SOA_ATTACHMENT');
190: RETURN rowcount;
191: END;
192:
193: