APPS.CSM_MTL_TXN_REASONS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

28: l_null_palm_omfs_resource_list asg_download.user_list;
29: l_run_date date;
30: l_sqlerrno VARCHAR2(20);
31: l_sqlerrmsg varchar2(2000);
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
34: l_mark_dirty boolean;
35:
36: CURSOR l_ins_mtl_txn_reasons_csr(p_lastrundate IN date)

Line 77: FROM jtm_con_request_data

73:
74: CURSOR l_last_run_date_csr
75: IS
76: SELECT nvl(last_run_date, (sysdate - 365*50))
77: FROM jtm_con_request_data
78: WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
79: AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';
80:
81: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_txn_reasons_acc.access_id%TYPE INDEX BY BINARY_INTEGER;

Line 189: UPDATE jtm_con_request_data

185: l_access_id_tbl.delete;
186: END IF; -- end of process inserts
187:
188: -- update last_run_date
189: UPDATE jtm_con_request_data
190: SET last_run_date = l_run_date
191: WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
192: AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';
193: