APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 20: (SELECT nvl(last_run_date, (sysdate - 365*50)) as DT FROM jtm_con_request_data

16: PRAGMA AUTONOMOUS_TRANSACTION;
17: CURSOR l_last_run_date_csr
18: IS
19: SELECT MAX(DT) FROM
20: (SELECT nvl(last_run_date, (sysdate - 365*50)) as DT FROM jtm_con_request_data
21: WHERE package_name = 'CSM_NOTIFICATION_EVENT_PKG'
22: AND procedure_name = 'DOWNLOAD_MULTIPLAT_NFN'
23: UNION ALL
24: select sysdate - fnd_profile.value('CSM_PURGE_INTERVAL') as DT from dual);

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

35: FETCH l_last_run_date_csr INTO l_upd_date;
36: CLOSE l_last_run_date_csr;
37:
38: CSM_UTIL_PKG.LOG('Entered DOWNLOAD_MULTIPLAT_NFN', 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN', FND_LOG.LEVEL_PROCEDURE);
39: -- set the program update date in jtm_con_request_data to sysdate
40:
41: FOR l_notf_rec IN ( SELECT DISTINCT wfn.notification_id ,au.USER_ID
42: FROM wf_notifications wfn,asg_user au
43: WHERE au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)

Line 55: UPDATE jtm_con_request_data

51: LOOP
52: INSERT_NOTIFICATIONS_ACC (l_notf_rec.notification_id, l_notf_rec.user_id);
53: END LOOP;
54:
55: UPDATE jtm_con_request_data
56: SET last_run_date = l_run_date
57: WHERE package_name = 'CSM_NOTIFICATION_EVENT_PKG'
58: AND procedure_name = 'DOWNLOAD_MULTIPLAT_NFN';
59:

Line 377: FROM jtm_con_request_data

373:
374: CURSOR l_upd_last_run_date_csr
375: IS
376: SELECT 1
377: FROM jtm_con_request_data
378: WHERE product_code = 'CSM'
379: AND package_name = 'CSM_NOTIFICATION_EVENT_PKG'
380: AND procedure_name = 'PURGE_NOTIFICATION_CONC'
381: FOR UPDATE OF last_run_date NOWAIT;

Line 498: UPDATE jtm_con_request_data

494: -- update last_run_date
495: OPEN l_upd_last_run_date_csr;
496: FETCH l_upd_last_run_date_csr INTO l_dummy;
497: IF l_upd_last_run_date_csr%FOUND THEN
498: UPDATE jtm_con_request_data
499: SET last_run_date = l_last_run_date
500: WHERE CURRENT OF l_upd_last_run_date_csr;
501: END IF;
502: CLOSE l_upd_last_run_date_csr;

Line 2337: FROM jtm_con_request_data

2333: l_wf_param wf_event_t;
2334: BEGIN
2335:
2336: SELECT NVL(LAST_RUN_DATE,TO_DATE(1,'J')) INTO l_last_run_date
2337: FROM jtm_con_request_data
2338: WHERE product_code = 'CSM'
2339: AND package_name = 'CSM_NOTIFICATION_EVENT_PKG'
2340: AND procedure_name = 'EMAIL_SYNC_ERRORS_CONC';
2341:

Line 2447: UPDATE jtm_con_request_data

2443:
2444: COMMIT; -- commit after every session is notified.
2445: END LOOP;
2446:
2447: UPDATE jtm_con_request_data
2448: SET LAST_RUN_DATE=sysdate
2449: WHERE product_code = 'CSM'
2450: AND package_name = 'CSM_NOTIFICATION_EVENT_PKG'
2451: AND procedure_name = 'EMAIL_SYNC_ERRORS_CONC';