DBA Data[Home] [Help]

APPS.JTF_FM_HISTORY_UTIL_PVT dependencies on JTF_FM_EMAIL_STATS

Line 278: -- Delete history record from jtf_fm_email_stats table for a given request ID.

274: -- PROCEDURE
275: -- DELETE_EMAIL_STATS
276: --
277: -- PURPOSE
278: -- Delete history record from jtf_fm_email_stats table for a given request ID.
279: --
280: -- PARAMETERS
281: -- p_request_id
282: -- Request ID for which the records should be deleted.

Line 292: FROM jtf_fm_email_stats

288: l_count NUMBER DEFAULT 0;
289: l_message VARCHAR2(4000);
290: BEGIN
291: DELETE
292: FROM jtf_fm_email_stats
293: WHERE request_id = p_request_id ;
294:
295: l_count := SQL%ROWCOUNT;
296:

Line 432: FROM jtf_fm_email_stats

428: ;
429:
430: FORALL i IN 1 .. tab_request_id.COUNT
431: DELETE
432: FROM jtf_fm_email_stats
433: WHERE request_id = tab_request_id(i)
434: ;
435:
436: EXIT WHEN c_history_id%NOTFOUND;