DBA Data[Home] [Help]

APPS.CSM_AD_SRCH_RESULT_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 37: FROM JTM_CON_REQUEST_DATA

33:
34: /*** get the last run date of the concurent program ***/
35: CURSOR c_LastRundate IS
36: SELECT NVL(LAST_RUN_DATE, to_date('1','J')) LAST_RUN_DATE
37: FROM JTM_CON_REQUEST_DATA
38: WHERE package_name = g_ad_sch_result_pkg_name
39: AND procedure_name = g_ad_sch_result_api_name;
40:
41: CURSOR c_delete IS

Line 226: UPDATE JTM_CON_REQUEST_DATA

222:
223: CSM_UTIL_PKG.LOG('INSERTION Successful ',
224: 'CSM_AD_SRCH_RESULT_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
225:
226: UPDATE JTM_CON_REQUEST_DATA
227: SET LAST_RUN_DATE = SYSDATE
228: WHERE package_name = g_ad_sch_result_pkg_name
229: AND procedure_name = g_ad_sch_result_api_name;
230: