Search Results children_done

Overview

APPS.FA_ASSET_TRACE_PUB is the public interface package for the Oracle E-Business Suite Asset Trace utility, a diagnostic and troubleshooting facility used by the Oracle Assets (FA) module. Its primary business function is to execute a user-defined trace against asset-related data structures and report the results to a designated output (either a database table or a file). The package is owned by APPS and is classified as a PUB (public) API, meaning it is intended for invocation by other Oracle EBS components or, where appropriate, by custom code. It operates in conjunction with the private helper package FA_ASSET_TRACE_PVT, which performs the underlying trace initialization, primary processing, and output persistence, while the public package orchestrates the overall flow, manages concurrent request dependencies, and provides logging and temporary-header management services.

Key Procedures and Functions

Seven procedures are documented for this package:

• RUN_TRACE — The main entry point. It initializes global state via FA_ASSET_TRACE_PVT, writes an optional top section when a statement is supplied, invokes the primary trace routine, optionally loads system options, and saves the output. It returns a completion code and handles two predefined exceptions plus a catch-all OTHERS handler, logging failures accordingly.
• WAIT_FOR_REQ — Polls the status of one or more concurrent requests recorded in the package's global request table, blocking until each non-null, non-sentinel request identifier completes. This ensures trace output that depends on concurrent processing is not read prematurely.
• SET_TEMP_HEAD — Establishes temporary header information used to format trace sections.
• DO_TOP_SECTION — Emits the leading section of the trace report, typically containing the header passed by the caller and the driving SQL statement.
• START_QUEUE — Initializes an Advanced Queueing queue, leveraging the DBMS_AQADM dependency referenced by the package for asynchronous notification of trace events.
• ADD_SUBSCRIBER — Registers a subscriber on the queue created by START_QUEUE, enabling the package to publish trace results to interested consumers.
• LOG — Writes diagnostic messages, prefixed with the calling function name, to the logging destination. It is used in exception handlers to record ERROR_FOUND1 and OTHERS conditions.

Tables Accessed

The package references the APPS synonyms DBMS_AQADM, DBMS_LOCK, and PLITBLM. DBMS_AQADM is the Advanced Queueing administrative package, used by START_QUEUE and ADD_SUBSCRIBER to create and manage the trace queue. DBMS_LOCK provides the locking primitives used to serialize access to shared trace state or output. PLITBLM is an Oracle-provided utility package for manipulating PL/SQL index-by tables, which supports the package's global collections such as the options table (g_options_tbl) and the request table (g_req_tbl) used by WAIT_FOR_REQ. Any business-data access is delegated to FA_ASSET_TRACE_PVT.

Usage Notes

FA_ASSET_TRACE_PUB is typically invoked from the Oracle Assets Asset Trace concurrent program or from a Forms-based diagnostic screen, where an administrator specifies the trace options, exclusions, and driving statement. In custom code it may be called directly from PL/SQL, passing the option and exclusion tables along with the trace header and statement, and inspecting the returned completion code (0 for success, 2 on error). The package is referenced by two other packages, reflecting its role as a shared diagnostic service. The internal identifier "children_done" relates to the trace's traversal logic, which tracks completed dependent records as it walks asset hierarchies; callers should treat this as an internal implementation detail rather than a documented parameter.