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: COMMIT WORK;

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

206: -- PROCEDURE
207: -- DELETE_PROCESSED
208: --
209: -- PURPOSE
210: -- Delete history record from jtf_fm_processed table for a given request ID.
211: --
212: -- PARAMETERS
213: -- p_request_id
214: -- Request ID for which the records should be deleted.

Line 224: FROM jtf_fm_processed

220: l_count NUMBER DEFAULT 0;
221: l_message VARCHAR2(4000);
222: BEGIN
223: DELETE
224: FROM jtf_fm_processed
225: WHERE request_id = p_request_id ;
226:
227: l_count := SQL%ROWCOUNT;
228:

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

225: WHERE request_id = p_request_id ;
226:
227: l_count := SQL%ROWCOUNT;
228:
229: l_message := RPAD('JTF_FM_PROCESSED table, records purged: ', 60, ' ') || l_count;
230: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
231:
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233: EXCEPTION

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

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.');
413: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting purging of other child tables....');
414:
415: OPEN c_history_id;
416: LOOP

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

482: -- PROCEDURE
483: -- PURGE_HISTORY_WKR
484: --
485: -- PURPOSE
486: -- The worker program that will delete ther rows from JTF_FM_PROCESSED
487: -- table based upon the ROWID (based upon LTU Processing).
488: --
489: -- PARAMETERS
490: -- x_batch_size

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

504: , x_argument4 IN VARCHAR2
505: ) IS
506: l_worker_id NUMBER;
507: l_product VARCHAR2(30) := 'JTF';
508: l_table_name VARCHAR2(30) := 'JTF_FM_PROCESSED';
509: l_update_name VARCHAR2(30);
510: l_status VARCHAR2(30);
511: l_industry VARCHAR2(30);
512: l_restatus BOOLEAN;

Line 566: FROM jtf_fm_processed jtp

562:
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: )