APPS.CSM_COUNTER_READING_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

28: l_access_list asg_download.access_list;
29: l_user_list asg_download.user_list;
30: l_all_omfs_resource_list asg_download.user_list;
31: l_null_omfs_resource_list asg_download.user_list;
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_counter_value_id_tbl counter_value_tbl_typ;
34: l_counter_id_tbl counter_tbl_typ;
35:
36: --Cursor Declarations

Line 80: FROM jtm_con_request_data

76: --Cursor to get last run date
77: CURSOR l_last_run_date_csr
78: IS
79: SELECT nvl(last_run_date, (sysdate - 365*50))
80: FROM jtm_con_request_data
81: WHERE package_name = 'CSM_COUNTER_READING_EVENT_PKG'
82: AND procedure_name = 'REFRESH_ACC';
83:
84: BEGIN

Line 213: UPDATE jtm_con_request_data

209:
210: END IF; -- end of process inserts
211:
212: -- update last_run_date
213: UPDATE jtm_con_request_data
214: SET last_run_date = sysdate
215: WHERE package_name = 'CSM_COUNTER_READING_EVENT_PKG'
216: AND procedure_name= 'REFRESH_ACC';
217: