44: WHERE INTERVAL <= CURRENT_ROUND;
45:
46: CURSOR X_TO_BE_RUN_REQUEST(x_interval_id NUMBER, x_interval NUMBER) IS
47: SELECT PACKAGE_NAME, PROCEDURE_NAME
48: FROM JTM_CON_REQUEST_DATA req
49: WHERE (req.INTERVAL_ID = x_interval_id
50: AND req.EXECUTE_FLAG = 'Y')
51: OR
52: (req.INTERVAL_ID = x_interval_id
129:
130:
131: END;
132:
133: UPDATE JTM_CON_REQUEST_DATA
134: SET LAST_TXC_START = l_api_start,
135: LAST_TXC_END = l_api_end,
136: COMPLETION_TEXT = l_api_status
137: WHERE PACKAGE_NAME = x_request.PACKAGE_NAME