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

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

172: -- PROCEDURE
173: -- DELETE_REQUEST_CONTENT
174: --
175: -- PURPOSE
176: -- Delete history record from jtf_fm_request_contents table for a given request ID.
177: --
178: -- PARAMETERS
179: -- p_request_id
180: -- Request ID for which the records should be deleted.

Line 190: FROM jtf_fm_request_contents

186: l_message VARCHAR2(4000);
187: l_count NUMBER DEFAULT 0;
188: BEGIN
189: DELETE
190: FROM jtf_fm_request_contents
191: WHERE request_id = p_request_id ;
192:
193: l_count := SQL%ROWCOUNT;
194:

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

191: WHERE request_id = p_request_id ;
192:
193: l_count := SQL%ROWCOUNT;
194:
195: l_message := RPAD('JTF_FM_REQUEST_CONTENTS table, records purged: ', 60, ' ') || l_count;
196: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
197:
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199: EXCEPTION

Line 420: FROM jtf_fm_request_contents

416: LOOP
417: FETCH c_history_id BULK COLLECT INTO tab_request_id LIMIT 1000;
418: FORALL i IN 1 .. tab_request_id.COUNT
419: DELETE
420: FROM jtf_fm_request_contents
421: WHERE request_id = tab_request_id(i)
422: ;
423:
424: FORALL i IN 1 .. tab_request_id.COUNT