APPS.JTF_FM_INT_REQUEST_PKG dependencies on JTF_FM_STATUS_ALL

Line 953: UPDATE jtf_fm_status_all c

949: SET c.request_status = 'AVAILABLE'
950: WHERE c.request_id = l_request_id ;
951:
952: /* -- Moved to get_next_request procedure
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

Line 1005: | - Updates jtf_fm_status_all - for request status |

1001: | Purpose : For a given set of lines id, this procedure updates the |
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: *---------------------------------------------------------------------------------*/

Line 1065: UPDATE jtf_fm_status_all c

1061: l_disabled_flag ,
1062: l_count ;
1063: CLOSE c_details;
1064:
1065: UPDATE jtf_fm_status_all c
1066: SET c.request_status = 'READYTOLOG',
1067: c.LAST_UPDATE_DATE = SYSDATE,
1068: c.jobs_processed = l_count
1069: WHERE c.request_id = l_request_id;

Line 1219: | - Updates jtf_fm_status_all - for request status |

1215: | Procedure Name : UPDATE_INSTANCE_STATUS |
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: *---------------------------------------------------------------------------------*/

Line 1280: UPDATE jtf_fm_status_all c

1276: l_disabled_flag ,
1277: l_count ;
1278: CLOSE c_lines;
1279:
1280: UPDATE jtf_fm_status_all c
1281: SET c.request_status = 'READYTOLOG',
1282: c.LAST_UPDATE_DATE = SYSDATE,
1283: c.jobs_processed = l_count
1284: WHERE c.request_id = l_request_id;

Line 1440: | - Updates jtf_fm_status_all - for request status |

1436: | Procedure Name : GET_NEXT_REQUEST |
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

Line 1699: UPDATE jtf_fm_status_all c

1695: SET request_status = 'INPROGRESS'
1696: WHERE request_id = p_request_id
1697: AND request_status = 'AVAILABLE';
1698:
1699: UPDATE jtf_fm_status_all c
1700: SET c.request_status = 'IN_PROCESS'
1701: WHERE c.request_id = l_header_request_id
1702: AND c.request_status <> 'READYTOLOG'
1703: ;