DBA Data[Home] [Help]

APPS.CSM_HTML5_PKG dependencies on JTM_CON_REQUEST_DATA

Line 1960: FROM jtm_con_request_data

1956:
1957: CURSOR l_upd_last_run_date_csr
1958: IS
1959: SELECT 1
1960: FROM jtm_con_request_data
1961: WHERE product_code = 'CSM'
1962: AND package_name = 'CSM_HTML5_PKG'
1963: AND procedure_name = 'PURGE_HTML5_DATA'
1964: FOR UPDATE OF last_run_date NOWAIT;

Line 1999: UPDATE jtm_con_request_data

1995: -- update last_run_date
1996: OPEN l_upd_last_run_date_csr;
1997: FETCH l_upd_last_run_date_csr INTO l_dummy;
1998: IF l_upd_last_run_date_csr%FOUND THEN
1999: UPDATE jtm_con_request_data
2000: SET last_run_date = l_last_run_date
2001: WHERE CURRENT OF l_upd_last_run_date_csr;
2002: END IF;
2003: CLOSE l_upd_last_run_date_csr;