APPS.FND_SOA_UTIL dependencies on FND_SOA_REQUEST

Line 54: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_REQUEST - '||deleted_requests_count);

50: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_LOG_MESSAGES - '||deleted_log_count);
51:
52: /* Purge Function to delete all requests Data */
53: deleted_requests_count := delete_requests_by_date_range(v_direction,v_strt_date,v_end_date);
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);

Line 89: DELETE FROM FND_SOA_REQUEST

85: BEGIN
86: LOOP
87: BEGIN
88:
89: DELETE FROM FND_SOA_REQUEST
90: WHERE message_id IN
91: (SELECT WR.message_id
92: FROM FND_SOA_REQUEST WR
93: WHERE (x_start_date IS NOT NULL and x_end_date IS NOT NULL)

Line 92: FROM FND_SOA_REQUEST WR

88:
89: DELETE FROM FND_SOA_REQUEST
90: WHERE message_id IN
91: (SELECT WR.message_id
92: FROM FND_SOA_REQUEST WR
93: WHERE (x_start_date IS NOT NULL and x_end_date IS NOT NULL)
94: AND x_start_date <= WR.request_timestamp
95: AND x_end_date >= WR.request_timestamp)
96: AND nvl(direction, 'INBOUND') = x_direction

Line 116: fnd_file.put_line(fnd_file.output,'Deleted '|| rowcount ||' rows from FND_SOA_REQUEST ');

112: RAISE;
113: END IF;
114: END;
115: END LOOP;
116: fnd_file.put_line(fnd_file.output,'Deleted '|| rowcount ||' rows from FND_SOA_REQUEST ');
117: RETURN rowcount;
118:
119: END;
120:

Line 133: (SELECT message_id FROM FND_SOA_REQUEST)

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:
136: temp_rowcount := SQL%ROWCOUNT;
137: COMMIT;

Line 170: (SELECT message_id FROM FND_SOA_REQUEST)

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:
173: temp_rowcount := SQL%ROWCOUNT;
174: COMMIT;

Line 208: (SELECT message_id FROM FND_SOA_REQUEST))

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:
211: temp_rowcount := SQL%ROWCOUNT;
212: COMMIT;

Line 244: (SELECT message_id FROM FND_SOA_REQUEST))

240: BEGIN
241:
242: DELETE FROM FND_SOA_RUNTIME_ERROR RE
243: WHERE (message_id NOT IN
244: (SELECT message_id FROM FND_SOA_REQUEST))
245: AND rownum <= 20000;
246:
247: temp_rowcount := SQL%ROWCOUNT;
248: COMMIT;

Line 286: from fnd_soa_request

282: from fnd_log_transaction_context
283: where transaction_type = 'SOA_INSTANCE'
284: and transaction_id in
285: (select message_id
286: from fnd_soa_request
287: where REQUEST_STATUS = 'SUCCESS'
288: and x_start_date <= REQUEST_TIMESTAMP
289: AND x_end_date >= REQUEST_TIMESTAMP
290: AND direction = x_direction))