APPS.FND_SOA_UTIL dependencies on FND_LOG_MESSAGES

Line 50: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_LOG_MESSAGES - '||deleted_log_count);

46: end if;
47:
48: /* Purge Function to delete obsoleted Log Data */
49: deleted_log_count := delete_log_by_date_range(v_strt_date,v_end_date, v_direction);
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);

Line 279: DELETE from fnd_log_messages

275: BEGIN
276: LOOP
277: BEGIN
278:
279: DELETE from fnd_log_messages
280: where transaction_context_id in
281: (select transaction_context_id
282: from fnd_log_transaction_context
283: where transaction_type = 'SOA_INSTANCE'

Line 309: 'Deleted '|| rowcount ||' rows from FND_LOG_MESSAGES');

305: END IF;
306: END;
307: END LOOP;
308: fnd_file.put_line(fnd_file.output,
309: 'Deleted '|| rowcount ||' rows from FND_LOG_MESSAGES');
310: RETURN rowcount;
311: END;
312:
313: /* Purge Function to Delete Log Details by Message ID */

Line 323: from fnd_log_messages

319: LOOP
320: BEGIN
321:
322: DELETE
323: from fnd_log_messages
324: where transaction_context_id in
325: (select transaction_context_id
326: from fnd_log_transaction_context
327: where transaction_type = 'SOA_INSTANCE'