APPS.CSM_HTML5_PKG dependencies on CSM_QUERY_RESULTS_ACC

Line 886: select result into l_blob from csm_query_results_acc where instance_id = instId and query_id=5;

882:
883: BEGIN
884: SELECT to_number(PRF_VALUE) into instId FROM csm_html5_clients_info WHERE USER_NAME='APPLICATION' AND PRF_NAME='SCHEMA_REUSE';
885:
886: select result into l_blob from csm_query_results_acc where instance_id = instId and query_id=5;
887: p_result:=blob_to_clob(l_blob);
888: CSM_UTIL_PKG.LOG('Schema Reused from instance:'||instId, 'CSM_HTML5_PKG.query_schema_js', FND_LOG.LEVEL_PROCEDURE);
889: RETURN;
890: EXCEPTION

Line 904: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,

900: query_get_schema_js(p_result,ret,m);
901:
902: IF (ret=fnd_api.g_ret_sts_success) THEN
903: l_blob:=clob_to_blob(p_result);
904: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,
905: RESULT ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
906: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, asg_base.get_user_id(p_user_name), 5, instId, 1,
907: l_blob, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);
908:

Line 906: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, asg_base.get_user_id(p_user_name), 5, instId, 1,

902: IF (ret=fnd_api.g_ret_sts_success) THEN
903: l_blob:=clob_to_blob(p_result);
904: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,
905: RESULT ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
906: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, asg_base.get_user_id(p_user_name), 5, instId, 1,
907: l_blob, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);
908:
909: set_user_profile('APPLICATION','SCHEMA_REUSE',to_char(instId));
910: RETURN;

Line 1990: delete from csm_query_results_acc where instance_id not in ( select instance_id from csm_query_instances_acc where query_id between 1 and 99 );

1986: where creation_date < (sysdate-l_days)
1987: and query_id between 1 and 99
1988: and instance_id not in (select to_number(prf_value) from csm_html5_clients_info WHERE PRF_NAME='SCHEMA_REUSE' OR PRF_NAME like 'REUSABLE%' OR PRF_NAME LIKE 'USER_CREAT%')
1989: and not exists (select 1 from csm_html5_sync_info where instance_id=q_instance_id);
1990: delete from csm_query_results_acc where instance_id not in ( select instance_id from csm_query_instances_acc where query_id between 1 and 99 );
1991: END IF;
1992: CLOSE c_purge_days;
1993:
1994: