APPS.JTF_FM_HISTORY_UTIL_PVT dependencies on JTF_FM_REQUEST_CONTENTS

Line 46: DELETE FROM JTF_FM_REQUEST_CONTENTS WHERE REQUEST_ID = p_request_id;

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
50: UPDATE JTF_FM_PARTITION_X_REQUEST SET REQUEST_ID=NULL WHERE REQUEST_ID = p_request_id;

Line 184: -- Delete history record from jtf_fm_request_contents table for a given request ID.

180: -- PROCEDURE
181: -- DELETE_REQUEST_CONTENT
182: --
183: -- PURPOSE
184: -- Delete history record from jtf_fm_request_contents table for a given request ID.
185: --
186: -- PARAMETERS
187: -- p_request_id
188: -- Request ID for which the records should be deleted.

Line 198: FROM jtf_fm_request_contents

194: l_message VARCHAR2(4000);
195: l_count NUMBER DEFAULT 0;
196: BEGIN
197: DELETE
198: FROM jtf_fm_request_contents
199: WHERE request_id = p_request_id ;
200:
201: l_count := SQL%ROWCOUNT;
202:

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

199: WHERE request_id = p_request_id ;
200:
201: l_count := SQL%ROWCOUNT;
202:
203: l_message := RPAD('JTF_FM_REQUEST_CONTENTS table, records purged: ', 60, ' ') || l_count;
204: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
205:
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207: EXCEPTION

Line 428: FROM jtf_fm_request_contents

424: LOOP
425: FETCH c_history_id BULK COLLECT INTO tab_request_id LIMIT 1000;
426: FORALL i IN 1 .. tab_request_id.COUNT
427: DELETE
428: FROM jtf_fm_request_contents
429: WHERE request_id = tab_request_id(i)
430: ;
431:
432: FORALL i IN 1 .. tab_request_id.COUNT