248: -- PROCEDURE
249: -- DELETE_CONTENT_FAILURES
250: --
251: -- PURPOSE
252: -- Delete history records from jtf_fm_content_failures table for a given request ID.
253: --
254: -- PARAMETERS
255: -- p_request_id
256: -- Request ID for which the records should be deleted.
262: l_count NUMBER DEFAULT 0;
263: l_message VARCHAR2(4000);
264: BEGIN
265: DELETE
266: FROM jtf_fm_content_failures
267: WHERE request_id = p_request_id ;
268:
269: l_count := SQL%ROWCOUNT;
270:
267: WHERE request_id = p_request_id ;
268:
269: l_count := SQL%ROWCOUNT;
270:
271: l_message := RPAD('JTF_FM_CONTENT_FAILURES table, records purged: ', 60, ' ') || l_count;
272: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
273:
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: EXCEPTION
430: ;
431:
432: FORALL i IN 1 .. tab_request_id.COUNT
433: DELETE
434: FROM jtf_fm_content_failures
435: WHERE request_id = tab_request_id(i)
436: ;
437:
438: FORALL i IN 1 .. tab_request_id.COUNT