Search Results csm_html5_ajax_s




Overview
Explore in AI Chat

Overview

APPS.CSM_HTML5_PKG is a large PL/SQL package body in the Oracle E-Business Suite Applications schema. It belongs to the HTML5/connected-service framework that was introduced to support the Oracle EBS HTML5-based user interface and its associated synchronization, caching, and telemetry mechanisms. In the context of EBS 12.1.1 and 12.2.2, the package acts as the server-side engine that mediates between browser-based HTML5 clients and the underlying EBS data model, handling user validation, schema exchange, incremental data synchronization, cache management, and secure key generation.

The package is classified as OTHER (non-API) in the ETRM documentation and is marked VALID. It exposes 47 documented procedures and functions and references a substantial set of CSM_, ASG_, and FND_ objects. It is not referenced by any database object, indicating it is a top-level entry point invoked primarily by external clients, concurrent programs, or intermediate PL/SQL wrappers such as CSM_SERVICEP_WRAPPER_PKG. The user search term "csm_html5_ajax_s" corresponds to one of the packaged objects (CSM_HTML5_AJAX_S) that this package references and manages.

Key Procedures and Functions

  • QUERY_VALIDATE_USER — authenticates and validates the HTML5 user identity before granting access to query or synchronization operations.
  • QUERY_SYNC_DATA_JS — produces the JavaScript payload required to synchronize data to the HTML5 client.
  • QUERY_GET_SCHEMA_JS and QUERY_SCHEMA_JS — generate the JavaScript representation of the schema (metadata/definitions) consumed by the HTML5 front end.
  • Q_INC_SYNC_CREF_JS and Q_INC_SYNC_DATA_JS — support incremental synchronization, emitting change-reference and data JavaScript fragments for delta updates.
  • HAS_UPGRADED_VERSION — determines whether a client has been upgraded to the expected version.
  • SET_APP_REVISION and GET_APP_REVISION — read and write the application revision marker used for version control of client data.
  • SET_COMP_REF and SET_INDX_REF — establish component and index reference values used during synchronization.
  • GET_MD5_HASH — computes an MD5 hash, used for integrity verification of transferred payloads.
  • GENERATE_RSA_KEYS — generates RSA key pairs for secure client/server communication.
  • MARK_PI_ALTERED, ENABLE_PI, DISABLE_PI — manage the state of personally identifiable information, marking alteration, enabling, or disabling processing.
  • PURGE_HTML5_DATA — removes stored HTML5 data according to purge policy.
  • NEXTINT — returns the next integer from a sequence-like counter.
  • ISHTML5USER — tests whether the current user is an HTML5 user.
  • SUBMIT_CON_QUERY — submits a concurrent query request.

Tables Accessed

The package reads and writes HTML5-specific tables via APPS synonyms, notably CSM_HTML5_AJAX_INFO and CSM_HTML5_AJAX_S (AJAX request/response stores), CSM_HTML5_CACHE, CSM_HTML5_INQ, CSM_HTML5_PARSED_DATA, CSM_HTML5_CLIENTS_INFO, CSM_HTML5_SYNC_DETAILS, CSM_HTML5_SYNC_INFO, CSM_HTML5_SYNC_S, and CSM_HTML5_UPLOAD_DATA. It also accesses ASG_ tables such as ASG_PUB_ITEM, ASG_PUB_ITEM_INDEX, ASG_USER, ASG_USER_PUB_RESPS, ASG_DEFERRED_TRANINFO, ASG_DELETE_QUEUE, ASG_PURGE_SDQ, ASG_SYSTEM_DIRTY_QUEUE, ASG_COMPLETE_REFRESH, ASG_CONF_INFO, and ASG_USERS_INQINFO/ASG_USERS_INQARCHIVE. These support publication, user information, deferred transactions, and queue processing. FND_ tables (FND_PROFILE, FND_USER_PKG, FND_RESPONSIBILITY, FND_ORACLE_USERID) supply profile and identity context.

Usage Notes

CSM_HTML5_PKG is typically invoked by the HTML5 client layer, by CSM_HTML5_PKG-dependent wrappers such as CSM_SERVICEP_WRAPPER_PKG and CSM_QUERY_PKG, and by concurrent programs performing synchronization or purge activities. Because it is not referenced by other database objects and is classified as non-API, direct custom calls are discouraged; integrations should rely on the documented procedures above, respecting FND_GLOBAL session context and profile settings. Deployments across 12.1.1 and 12.2.2 must ensure the referenced CSM_ and ASG_ schema objects and XDB/DBMS_XMLDOM privileges are available, since the package depends on XML, LOB, and hashing utilities.