APPS.CSM_TASK_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 122: FROM jtm_con_request_data

118:
119: CURSOR l_upd_last_run_date_csr
120: IS
121: SELECT 1
122: FROM jtm_con_request_data
123: WHERE product_code = 'CSM'
124: AND package_name = 'CSM_TASK_EVENT_PKG'
125: AND procedure_name = 'PURGE_TASKS_CONC'
126: FOR UPDATE OF last_run_date NOWAIT

Line 205: UPDATE jtm_con_request_data

201: END LOOP;
202: CLOSE l_purge_tasks_csr;
203:
204: -- update last_run_date
205: UPDATE jtm_con_request_data
206: SET last_run_date = l_last_run_date
207: WHERE product_code = 'CSM'
208: AND package_name = 'CSM_TASK_EVENT_PKG'
209: AND procedure_name = 'PURGE_TASKS_CONC';

Line 251: FROM jtm_con_request_data

247:
248: CURSOR l_upd_last_run_date_csr
249: IS
250: SELECT last_run_date
251: FROM jtm_con_request_data
252: WHERE product_code = 'CSM'
253: AND package_name = 'CSM_TASK_EVENT_PKG'
254: AND procedure_name = 'CHECK_ESCALATION_TASKS_CONC'
255: FOR UPDATE OF last_run_date NOWAIT;

Line 286: UPDATE jtm_con_request_data

282: x_return_status=>l_return_status);
283: END LOOP;
284:
285: -- update last_run_date
286: UPDATE jtm_con_request_data
287: SET last_run_date = l_last_run_date
288: WHERE CURRENT OF l_upd_last_run_date_csr;
289: END IF;
290: CLOSE l_upd_last_run_date_csr;