APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 242: --cursor to get last run date from jtm_con_request_data

238: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc
239: WHERE hzc.cust_account_id = acc.cust_account_id
240: AND hzc.LAST_UPDATE_DATE > c_last_run_date;
241:
242: --cursor to get last run date from jtm_con_request_data
243: CURSOR csr_last_run_date
244: IS
245: SELECT nvl(last_run_date, (sysdate - 365*50) )
246: FROM jtm_con_request_data

Line 246: FROM jtm_con_request_data

242: --cursor to get last run date from jtm_con_request_data
243: CURSOR csr_last_run_date
244: IS
245: SELECT nvl(last_run_date, (sysdate - 365*50) )
246: FROM jtm_con_request_data
247: WHERE package_name = 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG'
248: AND procedure_name = 'CUST_ACCOUNTS_UPD';
249:
250: --variable declarations

Line 257: l_last_run_date JTM_CON_REQUEST_DATA.LAST_RUN_DATE%TYPE;

253: l_sqlerrmsg varchar2(2000);
254: l_markdirty BOOLEAN;
255: l_accessid_lst asg_download.access_list;
256: l_userid_lst asg_download.user_list;
257: l_last_run_date JTM_CON_REQUEST_DATA.LAST_RUN_DATE%TYPE;
258:
259: BEGIN
260: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);
261:

Line 294: UPDATE jtm_con_request_data

290:
291: CUST_ACCT_SITES_UPD(l_last_run_date);
292:
293:
294: UPDATE jtm_con_request_data
295: SET last_run_date = sysdate
296: WHERE package_name = 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG'
297: AND procedure_name = 'CUST_ACCOUNTS_UPD';
298: