APPS.JTM_CON_QUERY_REQUEST_PKG dependencies on JTM_CON_QUERY_REQUEST_DATA

Line 15: FROM jtm_con_query_request_data

11: SELECT con_query_id
12: , acc_table_name
13: , con_query
14: , last_run_date
15: FROM jtm_con_query_request_data
16: WHERE EXECUTE_FLAG='Y'
17: ORDER BY execution_order;
18:
19:

Line 1401: UPDATE jtm_con_query_request_data

1397: END IF;
1398:
1399: -- loop over query requests
1400: FOR r_query_request IN c_query_requests LOOP
1401: UPDATE jtm_con_query_request_data
1402: SET LAST_TXC_START = sysdate,
1403: LAST_TXC_END = null,
1404: STATUS = 'Running',
1405: COMPLETION_TEXT = 'Processing the query with id '

Line 1454: UPDATE jtm_con_query_request_data

1450: END IF;
1451: END;
1452:
1453: IF (l_status = G_ERROR) THEN
1454: UPDATE jtm_con_query_request_data
1455: SET LAST_TXC_END = sysdate,
1456: STATUS = l_status,
1457: COMPLETION_TEXT = l_message
1458: WHERE con_query_id = r_query_request.con_query_id;

Line 1460: UPDATE jtm_con_query_request_data

1456: STATUS = l_status,
1457: COMPLETION_TEXT = l_message
1458: WHERE con_query_id = r_query_request.con_query_id;
1459: ELSE
1460: UPDATE jtm_con_query_request_data
1461: SET LAST_TXC_END = sysdate,
1462: last_run_date = last_txc_start,
1463: STATUS = l_status,
1464: COMPLETION_TEXT = l_message