APPS.CSM_HTML5_PKG dependencies on ASG_COMPLETE_REFRESH

Line 1338: UPDATE asg_complete_refresh set synch_completed='Y' WHERE user_name = p_user_name;

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
1342: END_SESSION(l_session_id,'SUCCESS_W');

Line 1583: UPDATE asg_complete_refresh set synch_completed='Y' WHERE user_name = p_user_name;

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:
1587: IF l_refresh_all THEN