DBA Data[Home] [Help]

APPS.CSM_NEW_MESSAGES_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 212: FROM JTM_CON_REQUEST_DATA

208: PRAGMA AUTONOMOUS_TRANSACTION;
209: /*** get the last run date of the concurent program ***/
210: CURSOR c_LastRundate IS
211: SELECT NVL(LAST_RUN_DATE, to_date('1','J')) LAST_RUN_DATE
212: FROM JTM_CON_REQUEST_DATA
213: WHERE package_name = g_new_msg_pkg_name
214: AND procedure_name = g_new_msg_api_name;
215:
216: --UPDATE--

Line 482: UPDATE JTM_CON_REQUEST_DATA

478:
479: CSM_UTIL_PKG.LOG('INSERTION Successful ',
480: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
481:
482: UPDATE JTM_CON_REQUEST_DATA
483: SET LAST_RUN_DATE = SYSDATE
484: WHERE package_name = g_new_msg_pkg_name
485: AND procedure_name = g_new_msg_api_name;
486: