Search Results mark_dirty

Overview

ASG_CUSTOM_PUB is a public PL/SQL package in the APPS schema that supports the Oracle E-Business Suite "ASG" (Application Synchronization / Mobile Field Service style download) framework. Its principal business function is to register and maintain the definitions of "public items" — named data sets that are published for downstream download and synchronization to disconnected or remote clients — and to flag those items as changed so that the synchronization engine knows to re-propagate them. The package header declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer. Two public routines are documented: CUSTOMIZE_PUB_ITEM and an overloaded MARK_DIRTY. The package is heavily overloaded, and the multiple MARK_DIRTY signatures allow callers to signal dirty state at progressively finer granularity, from a whole item down to a single user and primary key combination.

Key Procedures and Functions

• CUSTOMIZE_PUB_ITEM — Registers or amends the definition of a public item. It accepts the public item name together with the base table name, the primary key columns, the data columns, and an optional additional filter, thereby describing how the item should be extracted for download. It follows the standard EBS API conventions: an API version number, an initialization flag, and standard message-count, return-status, and error-message OUT parameters.
• MARK_DIRTY — Signals that a public item, or a subset of it, has changed and must be re-synchronized. The routine is overloaded to accept different granularities of input. One signature takes an access-list, a user-id list, a DML list, and a timestamp; a second replaces the DML list with a single DML type character. A third narrows the scope to a single access id, user id, and DML operation. A fourth adds a primary-key value list so that dirty marking can be limited to specific rows. All forms return the standard API return status and accept an API version number, an initialization flag, the public item name, and a timestamp.

Tables Accessed

The package operates against the ASG download metadata. The asg_download schema provides the collection and record types (access_list, user_list, dml_list, pk_li) used as parameters to MARK_DIRTY. The dirty-marking routines ultimately maintain the download/change-tracking tables that record which published items are stale for which users, access points, and DML operations. No additional APPS synonym tables are documented in the ETRM metadata for this object, so the packaged types and the underlying ASG download tables form the documented data footprint.

Usage Notes

ASG_CUSTOM_PUB is a public (PUB) API intended to be called by other EBS components rather than interactively. It is typically invoked from the download/synchronization infrastructure and from custom code that needs to extend the set of downloadable public items or to flag changes after direct DML against a registered item's base table. Because the package records no inbound callers in the metadata (referenced by 0 other packages), it is best treated as an extension point. Callers should always pass a valid p_api_version_number, honor the p_init_msg_list FND_API convention, and inspect x_return_status and the message count/message before proceeding. The AUTHID CURRENT_USER setting means the invoking user must hold the appropriate privileges on the ASG tables and the item's base table.