Search Results download_init

Overview

The APPS.ASG_CONS_QPKG package is a definer's-rights PL/SQL package that implements the server-side callbacks registered with Oracle Lite for the Oracle E-Business Suite mobile and disconnected-client synchronization framework. Its central responsibility is managing the consolidation and refresh of publication data exchanged between the EBS database and remote Oracle Lite clients. The package coordinates upload and download lifecycle events, tracks synchronization state, performs complete-refresh handling, and supports conflict detection for published items.

Introduced in 2002 and maintained through the 11.5.x code line (the header reflects version 120.2, dated 2006), the package remains present in 12.1.1 and 12.2.2 for backward compatibility with mobile and lightweight client deployments. A significant portion of its logic concerns the ASG_COMPLETE_REFRESH mechanism, which governs when a client must receive a full rather than incremental refresh of a publication item. The SET_COMPLETE_REFRESH procedure—the subject of the user's search—is the routine that flags publication items requiring complete refresh by resetting the synch_completed indicator to 'N' in ASG_COMPLETE_REFRESH for items listed in c$pub_list_q. This forces the synchronization engine to re-send the full data set on the next download cycle.

Key Procedures and Functions

• UPLOAD_COMPLETE — Notifies the framework that a client upload has finished and that a new transaction exists.
• DOWNLOAD_INIT — The final initialization API that prepares data for a client download, accepting client, transaction, and priority parameters.
• DOWNLOAD_COMPLETE — Signals that all of a client's data has been transmitted.
• POPULATE_Q_REC_COUNT — Populates the record count for each publication item downloaded.
• SET_COMPLETE_REFRESH — Sets publication items in c$pub_list_q that have synch_completed marked in ASG_COMPLETE_REFRESH to 'N', triggering a complete refresh.
• SET_SYNCH_COMPLETED — Overloaded procedure that marks the synch_completed flag as 'Y' for a publication item, optionally scoped to a specific user.
• DELETE_ROW — Removes a qualifying row from synchronization bookkeeping.
• PROCESS_COMPREF_TABLE — Processes the complete-refresh table entries during synchronization.
• PROCESS_CUSTOM_PUB_ITEMS — Handles publication items defined through customer extensions.
• PROCESS_CONFLICTS — Drives the conflict-detection workflow for published data.
• IS_CONFLICT_DETECTION_NEEDED — Determines whether conflict detection must run.
• CONFLICT_PUB_ITEMS_EXIST — Tests for the presence of conflicting publication items.
• GET_CONF_PUB_ITEMS_LIST — Returns the list of publication items involved in conflicts.
• PROCESS_PUBITEM_CONFLICTS — Processes conflicts at the publication-item level.
• GET_PK_PREDICATE — Builds the primary-key predicate used to identify conflicting rows.
• SET_USER_HWM_TRANID — Sets the high-water-mark transaction identifier for a user.
• PROCESS_PURGE_SDQ — Processes the purge of the system dirty queue at synchronization time.
• VALIDATE_LOGIN — Validates a client login before synchronization proceeds.
• IS_PREVIOUS_SYNCH_SUCCESSFUL — Reports whether the prior synchronization completed successfully.
• FIND_LAST_SYNCH_DATE — Retrieves the date of the last successful synchronization.

Tables Accessed

• ASG_COMPLETE_REFRESH — Stores the synch_completed flag per publication item and user; the core table for complete-refresh control.
• ASG_PUB and ASG_PUB_ITEM — Define publications and their constituent items.
• ASG_AUTO_SYNC_TRANIDS — Tracks transaction identifiers for automatic synchronization.
• ASG_CONF_INFO — Holds conflict information used by the conflict-detection routines.
• ASG_PURGE_SDQ and ASG_SYSTEM_DIRTY_QUEUE — Support purge and dirty-queue processing during synchronization.
• ASG_USER — Provides user context for login validation and high-water-mark tracking.
• DBMS_SQL and PLITBLM — Oracle-supplied packages for dynamic SQL and index-by table support.

Usage Notes

ASG_CONS_QPKG is invoked indirectly by the Oracle Lite synchronization engine as callback registrations rather than through end-user forms or standard concurrent programs. It is referenced by one other package within the synchronization stack. Administrators rarely call these procedures manually; however, DBAs troubleshooting stale or stuck client synchronizations may query ASG_COMPLETE_REFRESH to inspect synch_completed flags set by SET_SYNCH_COMPLETED, or invoke SET_COMPLETE_REFRESH to force a full refresh for affected publication items. Because the package is AUTHID DEFINER, execution privileges are governed by the APPS schema.