Results for “fd_reserve”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FV_DRILLDOWN_PUB_PKG is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Federal Financials / Subledger Accounting drilldown infrastructure, and its header revision identifier (fvsladrb.pls 120.4, dated 2011/05/13) confirms it is shipped as a standard Oracle-delivered object rather than a customer extension. The package serves a single, well-defined business purpose: it exposes a public API through which Subledger Accounting (SLA) can return the contextual information required to open the appropriate source transaction form from an accounting entry. In practice, when a user reviews a subledger journal entry and requests to drill down to the originating transaction, SLA invokes this package, which resolves the application, ledger, legal entity, event, and transaction identifiers and passes back the Oracle Application Object Library function name needed to launch the correct form.

The package is classified under the ETRM API classification OTHER, indicating it is an internal Oracle API rather than a documented extension point intended for customer modification.

Key Procedures and Functions

The package exposes one documented procedure, DRILLDOWN. Its role is to provide a public API for SLA to return the appropriate information via OUT parameters so that the correct transaction form can be opened for the transaction being examined.

  • DRILLDOWN — Accepts a set of context identifiers describing the subledger application, ledger, legal entity, event entity, event class, and event type, together with a set of generic source transaction identifiers (integer and character, numbered 1 through 4) and generic security identifiers. It also accepts a valuation method identifier, a user interface type, and the name of an Oracle Application Object Library function. The user interface type parameter determines the interface mode and accepts the values FORM, HTML, or NONE. The procedure resolves the supplied context and returns, through its OUT parameters, the information and function name required to open the appropriate transaction form.

Tables Accessed

No tables are documented as being referenced through APPS synonyms for this package in the ETRM metadata. Structurally, the package operates against SLA and subledger context data, but the documented record does not enumerate underlying base tables, and no direct table references are asserted here. Consumers should treat the package as a context-resolution and form-launch service rather than as a data maintenance routine.

Usage Notes

FV_DRILLDOWN_PUB_PKG.DRILLDOWN is invoked programmatically by Subledger Accounting when a user initiates a drilldown action from an accounting entry to its source transaction. It is not a concurrent program and is not exposed as a standalone form; it is called from within the SLA drilldown flow and returns the AOL function name that the calling layer uses to open the target transaction form.

The package is referenced by zero other packages according to the ETRM metadata, and its API classification of OTHER signals that Oracle does not document it as a supported customization interface. Custom code should avoid calling DRILLDOWN directly unless the required context identifiers—application, ledger, legal entity, event class, event type, and the generic source and security identifiers—can be supplied reliably. The user interface type parameter should be set to FORM, HTML, or NONE to match the intended rendering mode.

Regarding the search term "rpr_ba_reserve," no such procedure, function, or documented element exists within FV_DRILLDOWN_PUB_PKG. The only documented routine is DRILLDOWN. The term "reserve" does not correspond to any documented parameter or object in this package, and it should not be assumed to be part of this API. Users searching for that string should verify the object name and the owning package before further investigation.