[Home] [Help]
654: BEGIN
655: FOR rec IN (SELECT USER_NAME FROM ASG_USER au WHERE ENABLED='Y' AND MULTI_PLATFORM='Y'
656: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO
657: WHERE USER_NAME=au.USER_NAME AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pi)
658: AND NOT EXISTS(SELECT 1 FROM ASG_PURGE_SDQ WHERE USER_NAME =au.USER_NAME AND pub_name = 'SERVICEP' AND TRANSACTION_ID IS NULL)
659: )
660: LOOP
661: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(rec.USER_NAME,'COMPREF',p_pi);
662: END LOOP;
1333: p_result:=l_final;
1334:
1335: IF M THEN
1336: /* M:=asg_download.purgeSdq(p_user_name); -- Replaced with delete at PI processing*/
1337: UPDATE asg_purge_sdq set TRANSACTION_ID=NVL(l_session_id,1) WHERE user_name = p_user_name; --first sync over
1338: UPDATE asg_complete_refresh set synch_completed='Y' WHERE user_name = p_user_name;
1339: remove_comp_ref(p_user_name);
1340: DELETE FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name AND PRF_NAME='APP_REVISION';
1341: IF l_warning THEN
1578: l_session_id:=CREATE_SESSION(p_user_name,'DOWNLOAD');
1579:
1580: IF IS_FIRST_SYNC(p_user_name) THEN
1581: CSM_UTIL_PKG.LOG(p_user_name||' has been dropped and recreated. Kicking off Full Refresh', 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1582: UPDATE asg_purge_sdq set TRANSACTION_ID=NVL(l_session_id,1) WHERE user_name = p_user_name; --first sync over
1583: UPDATE asg_complete_refresh set synch_completed='Y' WHERE user_name = p_user_name;
1584: l_refresh_all:=TRUE;
1585: END IF;
1586:
3701: IS
3702: l_t NUMBER;
3703: BEGIN
3704: SELECT 1 INTO l_t
3705: FROM asg_purge_sdq
3706: WHERE user_name = p_user_name
3707: AND pub_name = 'SERVICEP'
3708: AND TRANSACTION_ID IS NULL;
3709: RETURN TRUE;