APPS.JTF_FM_HISTORY_UTIL_PVT dependencies on JTF_FM_REQUEST_HISTORY

Line 47: DELETE FROM JTF_FM_REQUEST_HISTORY WHERE HIST_REQ_ID = p_request_id;

43: IS
44: BEGIN
45: DELETE FROM JTF_FM_PROCESSED WHERE REQUEST_ID = p_request_id;
46: DELETE FROM JTF_FM_REQUEST_CONTENTS WHERE REQUEST_ID = p_request_id;
47: DELETE FROM JTF_FM_REQUEST_HISTORY WHERE HIST_REQ_ID = p_request_id;
48:
49: COMMIT WORK;
50:
51: END DELETE_REQUEST_HISTORY;

Line 72: FROM jtf_fm_request_history_all

68: )
69: IS
70: CURSOR c_headers IS
71: SELECT hist_req_id request_id, ROWID, submit_dt_tm last_update_date
72: FROM jtf_fm_request_history_all
73: WHERE TRUNC(submit_dt_tm) <= TRUNC(SYSDATE) - p_data_age
74: ORDER BY hist_req_id ASC;
75: l_return_status VARCHAR2(1);
76: l_message VARCHAR2(4000);

Line 312: -- Delete history record from jtf_fm_request_history table for a given ROWID.

308: -- PROCEDURE
309: -- DELETE_REQUEST_HISTORY
310: --
311: -- PURPOSE
312: -- Delete history record from jtf_fm_request_history table for a given ROWID.
313: --
314: -- PARAMETERS
315: -- p_request_id
316: -- Request ID for which the records should be deleted.

Line 326: FROM jtf_fm_request_history

322: l_count NUMBER DEFAULT 0;
323: l_message VARCHAR2(4000);
324: BEGIN
325: DELETE
326: FROM jtf_fm_request_history
327: WHERE ROWID = p_rowid;
328:
329: l_count := SQL%ROWCOUNT;
330:

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

327: WHERE ROWID = p_rowid;
328:
329: l_count := SQL%ROWCOUNT;
330:
331: l_message := RPAD('JTF_FM_REQUEST_HISTORY table, records purged: ', 60, ' ') || l_count;
332: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
333:
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335: EXCEPTION

Line 372: UPDATE jtf_fm_request_history_all

368: l_children_done BOOLEAN;
369: BEGIN
370:
371: -- updating the purge_flag
372: UPDATE jtf_fm_request_history_all
373: SET purge_flag = 'Y'
374: WHERE TRUNC(last_update_date) <= TRUNC(SYSDATE) - p_data_age
375: ;
376:

Line 405: FROM jtf_fm_request_history_all

401: THEN
402: DECLARE
403: CURSOR c_history_id IS
404: SELECT hist_req_id
405: FROM jtf_fm_request_history_all
406: WHERE purge_flag = 'Y'
407: ORDER BY hist_req_id ASC;
408: TYPE typ_request_id IS TABLE OF jtf_fm_request_history_all.hist_req_id%TYPE;
409: tab_request_id typ_request_id;

Line 408: TYPE typ_request_id IS TABLE OF jtf_fm_request_history_all.hist_req_id%TYPE;

404: SELECT hist_req_id
405: FROM jtf_fm_request_history_all
406: WHERE purge_flag = 'Y'
407: ORDER BY hist_req_id ASC;
408: TYPE typ_request_id IS TABLE OF jtf_fm_request_history_all.hist_req_id%TYPE;
409: tab_request_id typ_request_id;
410: BEGIN
411: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'JTF_FM_PROCESSED table purged.');

Line 443: FROM jtf_fm_request_history_all

439: CLOSE c_history_id;
440:
441:
442: DELETE
443: FROM jtf_fm_request_history_all
444: WHERE purge_flag = 'Y';
445:
446: l_count := SQL%ROWCOUNT;
447:

Line 567: WHERE request_id IN ( SELECT /*+ index(jrh, jtf.jtf_fm_request_history_all_nu2) */ hist_req_id

563: WHILE ( l_any_rows_to_process = TRUE )
564: LOOP
565: DELETE /*+ rowid(jfp) */
566: FROM jtf_fm_processed jtp
567: WHERE request_id IN ( SELECT /*+ index(jrh, jtf.jtf_fm_request_history_all_nu2) */ hist_req_id
568: FROM jtf_fm_request_history_all jrh
569: WHERE purge_flag = 'Y'
570: )
571: AND ROWID BETWEEN l_start_rowid AND l_end_rowid

Line 568: FROM jtf_fm_request_history_all jrh

564: LOOP
565: DELETE /*+ rowid(jfp) */
566: FROM jtf_fm_processed jtp
567: WHERE request_id IN ( SELECT /*+ index(jrh, jtf.jtf_fm_request_history_all_nu2) */ hist_req_id
568: FROM jtf_fm_request_history_all jrh
569: WHERE purge_flag = 'Y'
570: )
571: AND ROWID BETWEEN l_start_rowid AND l_end_rowid
572: ;