Search Results get_last_tranid

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.

Session identity accessors: GET_USER_NAME, GET_USER_ID, GET_RESOURCE_ID, GET_LANGUAGE, GET_APPLICATION_ID, and GET_RESP_ID return the identity and context of the user participating in the current synchronization session. These values are cached in package globals and re-read on demand.
Transaction tracking: GET_CURRENT_TRANID, GET_LAST_TRANID, GET_UPLOAD_TRANID, and SET_UPLOAD_TRANID manage the transaction identifiers that mark how far a client has synchronized with the server. GET_DML_TYPE exposes the DML operation type associated with a publication item.
Synchronization date handling: GET_LAST_SYNCH_DATE retrieves the date of the prior synchronization for a user, an essential input for incremental downloads.
Publication item state: SET_PUB_ITEMS persists the publication items being processed; IS_FIRST_SYNCH determines whether the session is the user's initial synchronization, which changes the volume of data delivered.
Initialization and diagnostics: INIT primes the package globals for a session, SET_COMPLETE_REFRESH flags a full re-download, INIT_DEBUG, RESET_ALL_GLOBALS, and PRINT_ALL_GLOBALS support debugging and global state housekeeping, and ALLOW_ATT_DOWNLOAD toggles attachment retrieval capability.

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.