APPS.CSM_HTML5_PKG dependencies on DUAL

Line 60: select sys_context('CSM5_VAULT_NS', 'APPLICATION') into x from dual;

56: IS
57: X VARCHAR2(100);
58: BEGIN
59: begin
60: select sys_context('CSM5_VAULT_NS', 'APPLICATION') into x from dual;
61: IF(x='STARTED') THEN
62: return;
63: END IF;
64: exception

Line 940: SELECT csm_html5_sync_s.NEXTVAL INTO l_session_id FROM DUAL;

936: l_instance NUMBER:=CSM_QUERY_PKG.G_INST_IN_PROCESS;
937: l_cnt NUMBER:=0;
938: BEGIN
939:
940: SELECT csm_html5_sync_s.NEXTVAL INTO l_session_id FROM DUAL;
941:
942: INSERT INTO csm_html5_sync_info(SESSION_ID,USER_NAME,START_DATE,FULL_SYNC,STATUS,STATUS_DESC,SYNC_TYPE,Q_INSTANCE_ID)
943: VALUES(l_session_id,p_user_name,SYSDATE,p_full_sync,'IN_PROGRESS','Sync has started successfuly',p_mode,l_instance);
944:

Line 2147: l_query_string := 'SELECT ' || l_conflict_callout ||'(:1,:2,:3) from dual';

2143: IF (l_conflict_callout IS NOT NULL) THEN
2144: FOR ccr in c_conf_rows(p_user_name, p_upload_tranid, p_pubitem) LOOP
2145: l_sequence := ccr.sequence;
2146:
2147: l_query_string := 'SELECT ' || l_conflict_callout ||'(:1,:2,:3) from dual';
2148:
2149: CSM_UTIL_PKG.LOG('SQL Command: ' || replace(l_query_string,'''','''''') ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);
2150:
2151: BEGIN