[Home] [Help]
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: SELECT request, hist_req_id
317: INTO l_bind, l_request_id
318: FROM jtf_fm_request_history_all
319: WHERE hist_req_id = request_id;
320:
321: l_amount := DBMS_LOB.GETLENGTH(l_bind);
322:
785: , l_rec_tab(97).col_name
786: , l_rec_tab(98).col_name
787: , l_rec_tab(99).col_name
788: , l_rec_tab(100).col_name
789: FROM jtf_fm_request_history_all
790: WHERE hist_req_id = l_request_id;
791:
792: l_col_insert := '';
793:
953: UPDATE jtf_fm_status_all c
954: SET c.request_status = 'IN_PROCESS'
955: WHERE c.request_id = l_request_id;
956:
957: UPDATE jtf_fm_request_history_all c
958: SET c.outcome_code = 'IN_PROCESS'
959: WHERE c.hist_req_id = l_request_id;
960: */
961:
1002: | jtf_fm_int_request_lines table and sets the email status to |
1003: | the passed email status PL/SQL table. |
1004: | - Updates jtf_fm_int_request_header - for request status |
1005: | - Updates jtf_fm_status_all - for request status |
1006: | - Updates jtf_fm_request_history_all - for outcome code |
1007: | - Updates jtf_fm_email_stat - for email details |
1008: | |
1009: *---------------------------------------------------------------------------------*/
1010: PROCEDURE update_lines_status_bulk ( line_ids IN JTF_VARCHAR2_TABLE_100
1067: c.LAST_UPDATE_DATE = SYSDATE,
1068: c.jobs_processed = l_count
1069: WHERE c.request_id = l_request_id;
1070:
1071: UPDATE jtf_fm_request_history_all
1072: SET outcome_code = 'READYTOLOG',
1073: total_jobs = l_count,
1074: process_dt_tm = SYSDATE,
1075: processed_dt_tm = SYSDATE,
1216: | |
1217: | Purpose : - Updates jtf_fm_int_request_batches - for batch status |
1218: | - Updates jtf_fm_int_request_header - for request status |
1219: | - Updates jtf_fm_status_all - for request status |
1220: | - Updates jtf_fm_request_history_all - for outcome code |
1221: | - Updates jtf_fm_email_stat - for email details |
1222: | |
1223: *---------------------------------------------------------------------------------*/
1224: PROCEDURE update_instance_status( p_request_id IN NUMBER
1282: c.LAST_UPDATE_DATE = SYSDATE,
1283: c.jobs_processed = l_count
1284: WHERE c.request_id = l_request_id;
1285:
1286: UPDATE jtf_fm_request_history_all
1287: SET outcome_code = 'READYTOLOG',
1288: total_jobs = l_count,
1289: process_dt_tm = SYSDATE,
1290: processed_dt_tm = SYSDATE,
1437: | |
1438: | Purpose : Selects from jtf_fm_int_request_lines , and |
1439: | - Updates jtf_fm_int_request_header - for request status |
1440: | - Updates jtf_fm_status_all - for request status |
1441: | - Updates jtf_fm_request_history_all - for outcome code |
1442: | |
1443: *---------------------------------------------------------------------------------*/
1444: PROCEDURE get_next_request( p_server_id IN NUMBER
1445: , p_instance_id IN NUMBER
1701: WHERE c.request_id = l_header_request_id
1702: AND c.request_status <> 'READYTOLOG'
1703: ;
1704:
1705: UPDATE jtf_fm_request_history_all c
1706: SET c.outcome_code = 'IN_PROCESS'
1707: WHERE c.hist_req_id = l_header_request_id
1708: AND c.outcome_code <> 'READYTOLOG'
1709: ;
2744: THEN
2745: SELECT partition_id, request_id
2746: INTO l_partition_id, l_request_id
2747: FROM ( SELECT part.partition_id, part.request_id
2748: FROM jtf_fm_partition_x_request part, jtf_fm_request_history_all history
2749: WHERE part.request_id IS NOT NULL
2750: AND part.request_id = history.hist_req_id
2751: AND history.outcome_code NOT IN ('IN_PROGRESS', 'PAUSED')
2752: ORDER BY request_id ASC )