Search Results asg_base




Overview
Explore in AI Chat

Overview

ASG_BASE is the foundational PL/SQL package body in the Oracle E-Business Suite Application Synchronization (ASG) module, which underlies the delivery and synchronization of application data between the EBS server and disconnected or mobile clients. As its header comment states, the package "contains functions to retrieve information during a synch session." It maintains the runtime session state for a synchronization operation, exposing global variables and accessor routines that other packages in the ASG layer consume.

Because the ASG synchronization framework was designed to support mobile and disconnected deployments, ASG_BASE abstracts session-level context such as the current user, responsibility, language, application, and the various transaction identifiers and publication items involved in a sync cycle. It was created on 29-MAR-2002 and accumulated multiple revisions, including support for multiple responsibilities (2005), attachment download, device switch handling, and logging enhancements. The package is owned by APPS and is referenced by 245 other packages, making it one of the most widely depended-upon objects in the ASG dependency graph.

Key Procedures and Functions

The 39 documented procedures and functions fall into several logical groups.

Tables Accessed

ASG_BASE operates against a small set of references, primarily through APPS synonyms.

  • ASG_USER — stores per-user synchronization metadata, notably the last synchronization date consumed by GET_LAST_SYNCH_DATE.
  • DBMS_LOB — invoked for large object handling, used principally by the attachment download functionality.
  • DBMS_SQL — used for dynamic SQL execution where query shapes must be constructed at runtime, such as online queries.
  • PLITBLM — indexed table type utility used for passing and manipulating collections in the package's APIs.

Usage Notes

ASG_BASE is a server-side session manager, not an end-user API. It is invoked indirectly through the ASG synchronization infrastructure, most visibly during the client-to-server sync handshake initiated by Oracle Lite or equivalent mobile clients, where INIT establishes globals and the getter functions populate the session context for downstream generation of publication items. Concurrent programs that perform publication refresh also benefit from these accessors.

The specific search term "sql_string_tbl" does not appear in the documented ASG_BASE metadata; that identifier is a generic PL/SQL associative-array type often declared in packages (including PLITBLM-style utilities) for passing string collections, and its mention here reflects the collection-handling machinery the package relies upon rather than a documented public declaration. Customizations should avoid modifying ASG_BASE directly and instead use supported extension points, since changes to this package cascade across the 245 dependent packages.