APPS.CSM_QUERY_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

27: l_sqlerrno VARCHAR2(20);
28: l_sqlerrmsg VARCHAR2(2000);
29: l_mark_dirty boolean;
30: g_pub_item VARCHAR2(30) := 'CSM_QUERY';
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
32: l_access_list asg_download.access_list;
33: l_user_list asg_download.user_list;
34: l_query_id_list QUERY_LIST;
35: l_variable_id_list VARIABLE_LIST;

Line 161: FROM jtm_con_request_data

157:
158: CURSOR l_last_run_date_csr
159: IS
160: SELECT nvl(last_run_date, (sysdate - 365*50))
161: FROM jtm_con_request_data
162: WHERE package_name = 'CSM_QUERY_EVENT_PKG'
163: AND procedure_name = 'REFRESH_ACC';
164:
165: BEGIN

Line 505: UPDATE jtm_con_request_data

501: AND SAVED_QUERY ='Y'
502: AND DELETE_FLAG ='Y';
503:
504: -- update last_run_date
505: UPDATE jtm_con_request_data
506: SET last_run_date = l_run_date
507: WHERE package_name = 'CSM_QUERY_EVENT_PKG'
508: AND procedure_name = 'REFRESH_ACC';
509: