APPS.CSM_BUS_PROCESS_TXNS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

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

Line 38: FROM jtm_con_request_data

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

Line 224: UPDATE jtm_con_request_data

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