APPS.CSM_IB_TXN_SUB_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(3000);
23: l_pub_item varchar2(30) := 'CSF_M_TXN_SUB_TYPES';
24: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
25: l_mark_dirty boolean;
26: l_access_id CSM_IB_TXN_TYPES_ACC.ACCESS_ID%TYPE;
27: l_language cs_transaction_types_tl.language%TYPE;
28: l_sub_type_id csi_ib_txn_types.sub_type_id%TYPE;

Line 42: FROM jtm_con_request_data

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

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

322: END LOOP;
323: --close the cursor
324: close l_inserts_cur;
325:
326: -- set the program update date in jtm_con_request_data to sysdate
327: UPDATE jtm_con_request_data
328: SET last_run_date = l_run_date
329: WHERE package_name = 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG'
330: AND procedure_name = 'REFRESH_ACC';

Line 327: UPDATE jtm_con_request_data

323: --close the cursor
324: close l_inserts_cur;
325:
326: -- set the program update date in jtm_con_request_data to sysdate
327: UPDATE jtm_con_request_data
328: SET last_run_date = l_run_date
329: WHERE package_name = 'CSM_IB_TXN_SUB_TYPES_EVENT_PKG'
330: AND procedure_name = 'REFRESH_ACC';
331: