APPS.FND_SOA_UTIL dependencies on FND_SOA_RESPONSE_METHOD

Line 58: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RESPONSE_METHOD - '||deleted_method_count);

54: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_REQUEST - '||deleted_requests_count);
55:
56: /* Purge Function to delete all method Data */
57: deleted_method_count := delete_method_by_date_range(v_strt_date,v_end_date);
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);

Line 131: DELETE FROM FND_SOA_RESPONSE_METHOD

127: BEGIN
128: LOOP
129: BEGIN
130:
131: DELETE FROM FND_SOA_RESPONSE_METHOD
132: WHERE message_id NOT IN
133: (SELECT message_id FROM FND_SOA_REQUEST)
134: AND rownum <= 20000;
135:

Line 153: 'Deleted '|| rowcount ||' rows from FND_SOA_RESPONSE_METHOD ');

149: END IF;
150: END;
151: END LOOP;
152: fnd_file.put_line(fnd_file.output,
153: 'Deleted '|| rowcount ||' rows from FND_SOA_RESPONSE_METHOD ');
154: RETURN rowcount;
155: END;
156:
157: