Search Results query_sync_data_js

Overview

CSM_HTML5_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning that all unqualified object references resolve against the privileges of the calling user rather than the package owner. The package supports the CSM (Customer Support / Field Service) HTML5 Mobile Field Service application, a browser-based interface delivered in EBS 12.1.1 and 12.2.2 that allows field technicians to synchronize service data with the enterprise database while disconnected or intermittently connected.

Its primary responsibility is to serve as the server-side gateway between the HTML5 client tier and the underlying CSM data model. It authenticates users, returns JavaScript-formatted payloads describing schema and synchronization state, manages application and component revisions, and controls the lifecycle of publication items and indexes used by the synchronization engine. The package also provides cryptographic utilities and administrative routines used to enable or disable a user for HTML5 access, mark publication items as altered, and purge staged HTML5 data.

Key Procedures and Functions

Authentication and synchronization entry points form the core of the package. QUERY_VALIDATE_USER validates a supplied user name and password and returns results as a CLOB alongside standard return status and error message outputs. QUERY_SYNC_DATA_JS performs a full synchronization data request for a user, with an optional parameter permitting authentication to be bypassed for controlled scenarios. Q_INC_SYNC_CREF_JS and Q_INC_SYNC_DATA_JS provide incremental synchronization, the latter accepting a transaction identifier and a refresh-all flag so the client can request either delta or complete data.

Schema-related routines include QUERY_GET_SCHEMA_JS, which emits the schema description without user context, and QUERY_SCHEMA_JS, which produces the schema JavaScript payload for a specific user.

Revision management is handled by HAS_UPGRADED_VERSION, SET_APP_REVISION, and GET_APP_REVISION, which together let the client determine whether its deployed application version is current and record revision changes. SET_COMP_REF and SET_INDX_REF maintain references for components and indexes, each overloaded to accept either a reference alone or a user name paired with the reference. GET_MD5_HASH supplies hashing used for integrity comparison of synchronized artifacts, while GENERATE_RSA_KEYS supports key generation for secure client-server exchange.

Administrative procedures include MARK_PI_ALTERED, ENABLE_PI, DISABLE_PI, and PURGE_HTML5_DATA, which respectively flag a publication item as modified, activate or deactivate a publication item, and remove staged HTML5 data. NEXTINT provides sequence-style integer generation. ISHTML5USER reports whether a given user is provisioned for the HTML5 interface, and SUBMIT_CON_QUERY submits a concurrent query on behalf of the application. The documented package exposes 47 procedures and functions in total.

Tables Accessed

The package operates against the ASG synchronization framework tables through APPS synonyms, including ASG_PUB_ITEM and ASG_PUB_ITEM_INDEX for publication item definitions and their index entries, ASG_COMPLETE_REFRESH for full refresh control, ASG_CONF_INFO for configuration metadata, ASG_DEFERRED_TRANINFO for deferred transaction records, ASG_SEQUENCE_PARTITIONS for sequence partitioning, and ASG_SYSTEM_DIRTY_QUEUE for change tracking. User-oriented tables include ASG_USER, ASG_USERS_INQARCHIVE, ASG_USERS_INQINFO, and ASG_USER_PUB_RESPS, which govern user provisioning, inquiry archiving, inquiry information, and publication item responsibility assignments. ASG_DELETE_QUEUE and ASG_PURGE_SDQ support deletion and purge processing. The package additionally references CSM_HTML5_AJAX_INFO and CSM_HTML5_AJAX_S (referenced tables list truncated) for storing HTML5 AJAX request state.

Usage Notes

CSM_HTML5_PKG is invoked indirectly by the HTML5 Mobile Field Service client through the AJAX layer configured in CSM_HTML5_AJAX_INFO, rather than being called directly by end users. Concurrent programs and administrative utilities call the maintenance procedures such as ENABLE_PI, DISABLE_PI, MARK_PI_ALTERED, and PURGE_HTML5_DATA. Because the package is referenced by five other packages, customizations should avoid modifying signatures. The presence of the "process_upload" search term reflects client-side request handling that routes through this package's AJAX entry points; the package itself does not expose a procedure of that name in the documented metadata.