APPS.JTF_FM_HISTORY_UTIL_PVT dependencies on JTF_FM_PROCESSED

Line 45: DELETE FROM JTF_FM_PROCESSED WHERE REQUEST_ID = p_request_id;

41: --------------------------------------------------------------------------------
42: PROCEDURE DELETE_REQUEST_HISTORY(p_request_id IN NUMBER)
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: --Clear partition record

Line 218: -- Delete history record from jtf_fm_processed table for a given request ID.

214: -- PROCEDURE
215: -- DELETE_PROCESSED
216: --
217: -- PURPOSE
218: -- Delete history record from jtf_fm_processed table for a given request ID.
219: --
220: -- PARAMETERS
221: -- p_request_id
222: -- Request ID for which the records should be deleted.

Line 232: FROM jtf_fm_processed

228: l_count NUMBER DEFAULT 0;
229: l_message VARCHAR2(4000);
230: BEGIN
231: DELETE
232: FROM jtf_fm_processed
233: WHERE request_id = p_request_id ;
234:
235: l_count := SQL%ROWCOUNT;
236:

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

233: WHERE request_id = p_request_id ;
234:
235: l_count := SQL%ROWCOUNT;
236:
237: l_message := RPAD('JTF_FM_PROCESSED table, records purged: ', 60, ' ') || l_count;
238: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
239:
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: EXCEPTION

Line 420: FND_FILE.PUT_LINE(FND_FILE.LOG, 'JTF_FM_PROCESSED table purged.');

416: TYPE typ_request_id IS TABLE OF jtf_fm_request_history_all.hist_req_id%TYPE;
417: tab_request_id typ_request_id;
418: BEGIN
419: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
420: FND_FILE.PUT_LINE(FND_FILE.LOG, 'JTF_FM_PROCESSED table purged.');
421: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting purging of other child tables....');
422:
423: OPEN c_history_id;
424: LOOP

Line 494: -- The worker program that will delete ther rows from JTF_FM_PROCESSED

490: -- PROCEDURE
491: -- PURGE_HISTORY_WKR
492: --
493: -- PURPOSE
494: -- The worker program that will delete ther rows from JTF_FM_PROCESSED
495: -- table based upon the ROWID (based upon LTU Processing).
496: --
497: -- PARAMETERS
498: -- x_batch_size

Line 516: l_table_name VARCHAR2(30) := 'JTF_FM_PROCESSED';

512: , x_argument4 IN VARCHAR2
513: ) IS
514: l_worker_id NUMBER;
515: l_product VARCHAR2(30) := 'JTF';
516: l_table_name VARCHAR2(30) := 'JTF_FM_PROCESSED';
517: l_update_name VARCHAR2(30);
518: l_status VARCHAR2(30);
519: l_industry VARCHAR2(30);
520: l_restatus BOOLEAN;

Line 574: FROM jtf_fm_processed jtp

570:
571: WHILE ( l_any_rows_to_process = TRUE )
572: LOOP
573: DELETE /*+ rowid(jfp) */
574: FROM jtf_fm_processed jtp
575: WHERE request_id IN ( SELECT /*+ index(jrh, jtf.jtf_fm_request_history_all_nu2) */ hist_req_id
576: FROM jtf_fm_request_history_all jrh
577: WHERE purge_flag = 'Y'
578: )