DBA Data[Home] [Help]

APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 20: FROM JTM_CON_REQUEST_DATA

16: PRAGMA AUTONOMOUS_TRANSACTION;
17: /*** get the last run date of the concurent program ***/
18: CURSOR c_LastRundate IS
19: SELECT NVL(LAST_RUN_DATE, to_date('1','J')) LAST_RUN_DATE
20: FROM JTM_CON_REQUEST_DATA
21: WHERE package_name = g_notes_type_map_pkg_name
22: AND procedure_name = g_notes_type_map_api_name;
23:
24: --DELETE--

Line 170: UPDATE JTM_CON_REQUEST_DATA

166:
167: CSM_UTIL_PKG.LOG('INSERTION Successful ',
168: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
169:
170: UPDATE JTM_CON_REQUEST_DATA
171: SET LAST_RUN_DATE = SYSDATE
172: WHERE package_name = g_notes_type_map_pkg_name
173: AND procedure_name = g_notes_type_map_api_name;
174: