APPS.CSM_CURRENCY_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 29: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

25: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
26: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
27: l_dsql varchar2(2048);
28: l_pub_item varchar2(30) := 'CSF_M_CURRENCIES';
29: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
30: l_sqlerrno VARCHAR2(20);
31: l_sqlerrmsg varchar2(2000);
32:
33: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)

Line 36: FROM jtm_con_request_data

32:
33: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
34: IS
35: SELECT nvl(last_run_date, (sysdate - 365*50))
36: FROM jtm_con_request_data
37: WHERE package_name = 'CSM_CURRENCY_EVENT_PKG'
38: AND procedure_name = 'REFRESH_ACC';
39:
40:

Line 222: UPDATE jtm_con_request_data

218: --close the cursor
219: close l_inserts_cur;
220:
221: -- set the program update date in asg_pub_item to sysdate
222: UPDATE jtm_con_request_data
223: SET last_run_date = l_run_date
224: WHERE package_name = 'CSM_CURRENCY_EVENT_PKG'
225: AND procedure_name = 'REFRESH_ACC';
226: