[Home] [Help]
2172: WHERE EXISTS (SELECT 1 FROM csm_auto_sync_nfn b WHERE b.NOTIFICATION_ID=cl.NOTIFICATION_ID and user_id=p_user_id);
2173:
2174: delete from csm_auto_sync_nfn where user_id=p_user_id;
2175:
2176: delete from CSM_SYNC_ERROR_NFN_INFO where client_id=csm_util_pkg.get_user_name(p_user_id);
2177:
2178: END PURGE_USER;
2179:
2180: --Subscription to event "oracle.apps.asg.sync.failure"
2269:
2270: l_notification_id := invoke_WF_NotifyProcess(l_user_list(I),l_wf_param);
2271:
2272: IF l_notification_id <> -1 THEN
2273: INSERT INTO CSM_SYNC_ERROR_NFN_INFO(NOTIFICATION_ID,RECIPIENT_NAME, SYNC_SESSION_ID ,CLIENT_ID)
2274: VALUES(l_notification_id,l_user_list(I),l_session_id,l_client_id);
2275:
2276: DOWNLOAD_NOTIFICATION(l_notification_id,l_sql_err_msg); --download notification to client
2277: ELSE
2347: AND trim(CLIENT_ID) IS NOT NULL
2348: AND CLIENT_ID = AU.USER_NAME
2349: AND START_TIME > AU.CREATION_DATE
2350: AND START_TIME > :1
2351: AND NOT EXISTS(SELECT 1 FROM CSM_SYNC_ERROR_NFN_INFO
2352: WHERE SYNC_SESSION_ID=HIST.SESSION_ID) ORDER BY CLIENT_ID,SESSION_ID' USING l_last_run_date;
2353:
2354: LOOP
2355: FETCH cur INTO l_session_id ,l_client_id,l_dev_type,l_err_msg,l_sync_date;
2422: l_notification_id := invoke_WF_NotifyProcess(l_user_list(I),l_wf_param);
2423:
2424: IF l_notification_id <> -1 THEN
2425:
2426: INSERT INTO CSM_SYNC_ERROR_NFN_INFO(NOTIFICATION_ID,RECIPIENT_NAME, SYNC_SESSION_ID ,CLIENT_ID)
2427: VALUES(l_notification_id,l_user_list(I),l_session_id,l_client_id);
2428:
2429: DOWNLOAD_NOTIFICATION(l_notification_id,l_sql_err_msg); --download notification to client
2430: ELSE