APPS.CSM_HTML5_PKG dependencies on CSM_HTML5_CACHE

Line 199: INSERT INTO CSM_HTML5_CACHE(USER_NAME,PI_NAME,DATA,REC_CNT,SESSION_ID) VALUES(P_U,PI,P_D,P_CNT,G_SESSION_ID);

195: RETURN ;
196: END IF;
197:
198: IF P_D IS NOT NULL THEN
199: INSERT INTO CSM_HTML5_CACHE(USER_NAME,PI_NAME,DATA,REC_CNT,SESSION_ID) VALUES(P_U,PI,P_D,P_CNT,G_SESSION_ID);
200: END IF;
201: COMMIT;
202: EXCEPTION
203: WHEN OTHERS THEN --unique index violation can happen for DDL cache when processed concurrently and it is insignificant

Line 216: DELETE FROM CSM_HTML5_CACHE WHERE PI_NAME=PI;

212: IS
213: PRAGMA AUTONOMOUS_TRANSACTION;
214: BEGIN
215: IF P_U IS NULL THEN --always
216: DELETE FROM CSM_HTML5_CACHE WHERE PI_NAME=PI;
217: ELSE
218: DELETE FROM CSM_HTML5_CACHE WHERE PI_NAME=PI AND USER_NAME=P_U;
219: END IF;
220:

Line 218: DELETE FROM CSM_HTML5_CACHE WHERE PI_NAME=PI AND USER_NAME=P_U;

214: BEGIN
215: IF P_U IS NULL THEN --always
216: DELETE FROM CSM_HTML5_CACHE WHERE PI_NAME=PI;
217: ELSE
218: DELETE FROM CSM_HTML5_CACHE WHERE PI_NAME=PI AND USER_NAME=P_U;
219: END IF;
220:
221: COMMIT;
222: END DELETE_CACHE;

Line 232: SELECT DATA,REC_CNT INTO X_DATA,X_CNT FROM CSM_HTML5_CACHE WHERE USER_NAME=P_U AND PI_NAME=PI;

228: IF(PI = 'CSM_SEQUENCES' AND P_U <> 'CSM_CACHE_PVT') THEN
229: RETURN FALSE;
230: END IF;
231:
232: SELECT DATA,REC_CNT INTO X_DATA,X_CNT FROM CSM_HTML5_CACHE WHERE USER_NAME=P_U AND PI_NAME=PI;
233: CSM_UTIL_PKG.LOG(pi||' hit in '||p_u||' cache', 'CSM_HTML5_PKG.GET_CACHED', FND_LOG.LEVEL_PROCEDURE);
234: RETURN TRUE;
235: EXCEPTION
236: WHEN OTHERS THEN

Line 244: DELETE FROM CSM_HTML5_CACHE B WHERE EXISTS(SELECT 1 FROM ASG_SYSTEM_DIRTY_QUEUE

240: PROCEDURE REMOVE_DIRTY_CACHE
241: IS
242: PRAGMA AUTONOMOUS_TRANSACTION;
243: BEGIN
244: DELETE FROM CSM_HTML5_CACHE B WHERE EXISTS(SELECT 1 FROM ASG_SYSTEM_DIRTY_QUEUE
245: WHERE CLIENT_ID=B.USER_NAME
246: AND PUB_ITEM=B.PI_NAME);
247: COMMIT;
248: END REMOVE_DIRTY_CACHE;

Line 609: DELETE FROM CSM_HTML5_CACHE WHERE USER_NAME='APPLICATION' AND PI_NAME=(SELECT ITEM_ID FROM ASG_PUB_ITEM_INDEX WHERE INDEX_ID=p_idx) ;

605: LOOP
606: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(rec.USER_NAME,'INDXREF',p_idx);
607: END LOOP;
608:
609: DELETE FROM CSM_HTML5_CACHE WHERE USER_NAME='APPLICATION' AND PI_NAME=(SELECT ITEM_ID FROM ASG_PUB_ITEM_INDEX WHERE INDEX_ID=p_idx) ;
610: END set_indx_ref;
611:
612: PROCEDURE set_indx_ref(p_user_name IN VARCHAR2,p_idx IN VARCHAR2)
613: IS

Line 624: DELETE FROM CSM_HTML5_CACHE WHERE USER_NAME='APPLICATION' AND PI_NAME=(SELECT ITEM_ID FROM ASG_PUB_ITEM_INDEX WHERE INDEX_ID=p_idx) ;

620: LOOP
621: INSERT INTO CSM_HTML5_CLIENTS_INFO(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(rec.USER_NAME,'INDXREF',p_idx);
622: END LOOP;
623:
624: DELETE FROM CSM_HTML5_CACHE WHERE USER_NAME='APPLICATION' AND PI_NAME=(SELECT ITEM_ID FROM ASG_PUB_ITEM_INDEX WHERE INDEX_ID=p_idx) ;
625: END set_indx_ref;
626:
627: PROCEDURE remove_indx_ref(p_USER_NAME IN VARCHAR2)
628: IS

Line 3694: DELETE FROM CSM_HTML5_CACHE WHERE USER_NAME=(SELECT USER_NAME

3690: IS BEGIN
3691: DELETE FROM csm_html5_clients_info WHERE USER_NAME=(SELECT USER_NAME
3692: FROM ASG_USER WHERE USER_ID=p_user_id) AND PRF_NAME NOT IN ('REVISION','FORCE_UPDATE'); --if any user has name as APPLICATION
3693:
3694: DELETE FROM CSM_HTML5_CACHE WHERE USER_NAME=(SELECT USER_NAME
3695: FROM ASG_USER WHERE USER_ID=p_user_id);
3696:
3697: CSM_HTML5_PKG.DELETE_USER_VAULT(p_user_id);
3698: END DROP_USER;