APPS.CSM_CUSTMZ_VIEWS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 21: --cursor to get last run date from jtm_con_request_data

17: p_message OUT NOCOPY VARCHAR2) IS
18: PRAGMA AUTONOMOUS_TRANSACTION;
19: --CURSOR declarations
20:
21: --cursor to get last run date from jtm_con_request_data
22: CURSOR c_LastRundate IS
23: SELECT NVL(LAST_RUN_DATE, to_date('1','J')) LAST_RUN_DATE
24: FROM JTM_CON_REQUEST_DATA
25: WHERE package_name = g_cust_view_pkg_name

Line 24: FROM JTM_CON_REQUEST_DATA

20:
21: --cursor to get last run date from jtm_con_request_data
22: CURSOR c_LastRundate IS
23: SELECT NVL(LAST_RUN_DATE, to_date('1','J')) LAST_RUN_DATE
24: FROM JTM_CON_REQUEST_DATA
25: WHERE package_name = g_cust_view_pkg_name
26: AND procedure_name = g_cust_view_api_name;
27:
28: --Cursor for delete

Line 232: UPDATE jtm_con_request_data

228: CSM_UTIL_PKG.LOG('INSERTION Successful ',
229: 'CSM_CUSTMZ_VIEWS_EVENT_PKG.Refresh_Acc',FND_LOG.LEVEL_PROCEDURE);
230:
231:
232: UPDATE jtm_con_request_data
233: SET last_run_date = sysdate
234: WHERE package_name = g_cust_view_pkg_name
235: AND procedure_name = g_cust_view_api_name;
236: