APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 24: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

20: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
21: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
22: l_dsql varchar2(2048);
23: l_pub_item varchar2(30) := 'CSF_M_TXN_BILLING_TYPES';
24: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
25: l_mark_dirty boolean;
26: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;
27: l_language cs_transaction_types_tl.language%TYPE;
28: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;

Line 43: FROM jtm_con_request_data

39:
40: CURSOR l_last_run_date_csr
41: IS
42: SELECT nvl(last_run_date, (sysdate - 365*50))
43: FROM jtm_con_request_data
44: WHERE package_name = 'CSM_TXN_BILL_TYPES_EVENT_PKG'
45: AND procedure_name = 'REFRESH_ACC';
46:
47: CURSOR l_deletes_cur

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

259: END LOOP;
260: --close the cursor
261: close l_inserts_cur;
262:
263: -- set the program update date in jtm_con_request_data to sysdate
264: UPDATE jtm_con_request_data
265: SET last_run_date = l_run_date
266: WHERE package_name = 'CSM_TXN_BILL_TYPES_EVENT_PKG'
267: AND procedure_name = 'REFRESH_ACC';

Line 264: UPDATE jtm_con_request_data

260: --close the cursor
261: close l_inserts_cur;
262:
263: -- set the program update date in jtm_con_request_data to sysdate
264: UPDATE jtm_con_request_data
265: SET last_run_date = l_run_date
266: WHERE package_name = 'CSM_TXN_BILL_TYPES_EVENT_PKG'
267: AND procedure_name = 'REFRESH_ACC';
268: