Search Results get_upload_tranid

Overview

ASG_BASE is the foundational PL/SQL package for the Oracle E-Business Suite asynchronous synchronization (ASG) framework, sometimes described as the "Field Service" or lightweight client sync layer. Declared with AUTHID DEFINER and first created in March 2002, the package centralizes the session-level context, global state, and data-type definitions used by all synchronization routines. Its stated purpose, per the package header, is to "contain functions to retrieve information during a synch session." In practice ASG_BASE acts as the shared backbone that higher-level sync packages call to determine who the user is, which responsibility and application they are operating under, what language they use, and where the last synchronization left off.

The package also defines the public-item data structures and maintains the internal tables that track which publication items are downloaded and uploaded during a sync session. Because it is referenced by 245 other packages, its global variables and record types effectively function as a shared interface contract across the ASG module.

Key Procedures and Functions

The package exposes roughly thirty-nine documented procedures and functions, which fall into several functional groups:

• Session context getters: GET_USER_NAME, GET_RESOURCE_ID, GET_USER_ID, GET_LANGUAGE, GET_APPLICATION_ID, and GET_RESP_ID return the identity, resource, language, application, and responsibility of the current user. These populate the global variables g_user_name, g_resource_id, g_user_id, g_language, g_application_id, and g_resp_id.
• Transaction identifiers: GET_CURRENT_TRANID, GET_LAST_TRANID, GET_UPLOAD_TRANID, and SET_UPLOAD_TRANID manage the transaction IDs that bracket a synchronization run for logging and change tracking.
• Session state and initialization: INIT initializes the sync session (including the last synchronization date), IS_FIRST_SYNCH reports whether this is the first synchronization, and RESET_ALL_GLOBALS clears the global variables between runs.
• Publication item control: SET_PUB_ITEMS and the pub_item_tbl_type/g_pub_item_tbl structures define which publication items participate in a session, including per-item name, component reference, record count, and online-query flag. SET_COMPLETE_REFRESH and GET_DML_TYPE support refresh and change-type handling.
• Diagnostics: INIT_DEBUG and PRINT_ALL_GLOBALS provide debugging and state-dump utilities, and ALLOW_ATT_DOWNLOAD controls whether attachments may be downloaded.

Tables Accessed

The package references the ASG_USER table via its APPS synonym, which supplies user and resource attributes during session initialization. Several calls route through standard database and Oracle-supplied packages, including DBMS_LOB (used for large-object and attachment handling), DBMS_SQL (dynamic SQL), and PLITBLM (the PL/SQL table-to-indexed-table utility). The remainder of the package's state is held in package-level global variables and PL/SQL tables rather than persisted tables, which is characteristic of its role as a session context holder rather than a data-modifying package.

Usage Notes

ASG_BASE is not intended for direct end-user invocation. It is called programmatically by the ASG synchronization packages and forms during a sync session. Typical flow begins with INIT (optionally with debugging enabled via INIT_DEBUG), followed by calls to the various GET_* functions to establish session context, then SET_PUB_ITEMS and SET_COMPLETE_REFRESH to configure the download/upload scope. On completion, RESET_ALL_GLOBALS clears state. Because 245 packages depend on it, custom code extending the ASG framework should treat the global variables and pub_item_tbl_type as read-only shared structures and avoid modifying them outside the documented procedures.