DBA Data[Home] [Help]

APPS.CSM_AD_SRCH_REGION_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 35: FROM JTM_CON_REQUEST_DATA

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

Line 224: UPDATE JTM_CON_REQUEST_DATA

220:
221: CSM_UTIL_PKG.LOG('INSERTION Successful ',
222: 'CSM_AD_SEARCH_REGION_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
223:
224: UPDATE JTM_CON_REQUEST_DATA
225: SET LAST_RUN_DATE = SYSDATE
226: WHERE package_name = g_ad_sch_region_pkg_name
227: AND procedure_name = g_ad_sch_region_api_name;
228: