APPS.JTF_FM_HISTORY_UTIL_PVT dependencies on JTF_FM_CONTENT_FAILURES

Line 244: -- Delete history records from jtf_fm_content_failures table for a given request ID.

240: -- PROCEDURE
241: -- DELETE_CONTENT_FAILURES
242: --
243: -- PURPOSE
244: -- Delete history records from jtf_fm_content_failures table for a given request ID.
245: --
246: -- PARAMETERS
247: -- p_request_id
248: -- Request ID for which the records should be deleted.

Line 258: FROM jtf_fm_content_failures

254: l_count NUMBER DEFAULT 0;
255: l_message VARCHAR2(4000);
256: BEGIN
257: DELETE
258: FROM jtf_fm_content_failures
259: WHERE request_id = p_request_id ;
260:
261: l_count := SQL%ROWCOUNT;
262:

Line 263: l_message := RPAD('JTF_FM_CONTENT_FAILURES table, records purged: ', 60, ' ') || l_count;

259: WHERE request_id = p_request_id ;
260:
261: l_count := SQL%ROWCOUNT;
262:
263: l_message := RPAD('JTF_FM_CONTENT_FAILURES table, records purged: ', 60, ' ') || l_count;
264: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
265:
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267: EXCEPTION

Line 426: FROM jtf_fm_content_failures

422: ;
423:
424: FORALL i IN 1 .. tab_request_id.COUNT
425: DELETE
426: FROM jtf_fm_content_failures
427: WHERE request_id = tab_request_id(i)
428: ;
429:
430: FORALL i IN 1 .. tab_request_id.COUNT