2343: /*---------------------------------------------------------------------------------*
2344: | Procedure Name : MOVE_REQUEST |
2345: | |
2346: | Purpose : Selects from jtf_fm_int_request_lines , and |
2347: | - Inserts into jtf_fm_processed table |
2348: | - Inserts into jtf_fm_content_failures table |
2349: | - Drops partition for jtf_fm_int_request_lines |
2350: | |
2351: *---------------------------------------------------------------------------------*/
2365: OPEN c_history;
2366: FETCH c_history INTO x_log_interaction;
2367: CLOSE c_history;
2368:
2369: INSERT INTO jtf_fm_processed
2370: (
2371: request_id ,
2372: job ,
2373: party_id ,