DBA Data[Home] [Help]

APPS.JTF_FM_HISTORY_UTIL_PVT dependencies on JTF_FM_EMAIL_STATS

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

282: -- PROCEDURE
283: -- DELETE_EMAIL_STATS
284: --
285: -- PURPOSE
286: -- Delete history record from jtf_fm_email_stats table for a given request ID.
287: --
288: -- PARAMETERS
289: -- p_request_id
290: -- Request ID for which the records should be deleted.

Line 300: FROM jtf_fm_email_stats

296: l_count NUMBER DEFAULT 0;
297: l_message VARCHAR2(4000);
298: BEGIN
299: DELETE
300: FROM jtf_fm_email_stats
301: WHERE request_id = p_request_id ;
302:
303: l_count := SQL%ROWCOUNT;
304:

Line 440: FROM jtf_fm_email_stats

436: ;
437:
438: FORALL i IN 1 .. tab_request_id.COUNT
439: DELETE
440: FROM jtf_fm_email_stats
441: WHERE request_id = tab_request_id(i)
442: ;
443:
444: EXIT WHEN c_history_id%NOTFOUND;