APPS.CSM_MTL_SEC_INV_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 138: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

134: PRAGMA AUTONOMOUS_TRANSACTION;
135: l_sqlerrno varchar2(20);
136: l_sqlerrmsg varchar2(2000);
137: l_mark_dirty boolean;
138: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
139: l_run_date date;
140:
141: CURSOR l_last_run_date_csr
142: IS

Line 144: FROM jtm_con_request_data

140:
141: CURSOR l_last_run_date_csr
142: IS
143: SELECT nvl(last_run_date, (sysdate - 365*50))
144: FROM jtm_con_request_data
145: WHERE package_name = 'CSM_MTL_SEC_INV_EVENT_PKG'
146: AND procedure_name = 'REFRESH_ACC';
147:
148: CURSOR l_upd_mtl_sec_inv_csr(p_last_upd_date IN date)

Line 178: -- set the program update date in jtm_con_request_data to sysdate

174: ASG_DOWNLOAD.UPD,
175: l_run_date);
176: END LOOP;
177:
178: -- set the program update date in jtm_con_request_data to sysdate
179: UPDATE jtm_con_request_data
180: SET last_run_date = l_run_date
181: WHERE package_name = 'CSM_MTL_SEC_INV_EVENT_PKG'
182: AND procedure_name = 'REFRESH_ACC';

Line 179: UPDATE jtm_con_request_data

175: l_run_date);
176: END LOOP;
177:
178: -- set the program update date in jtm_con_request_data to sysdate
179: UPDATE jtm_con_request_data
180: SET last_run_date = l_run_date
181: WHERE package_name = 'CSM_MTL_SEC_INV_EVENT_PKG'
182: AND procedure_name = 'REFRESH_ACC';
183: