Results for “load_target”

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

Overview

FND_HELP is an Oracle E-Business Suite (EBS) PL/SQL package body owned by the APPS schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. The package provides the server-side foundation for the EBS Help subsystem, which delivers context-sensitive application help, help search, and document retrieval to end users. Functionally, FND_HELP is responsible for resolving, loading, and returning help content stored in the EBS database, including external URL targets and internal help documents. It abstracts the complexity of language handling, file/LOB storage, and session context so that forms, personalizations, and other framework components can request help information through a consistent programmatic interface. The ETRM classification for this package is OTHER, indicating that it is a framework utility package rather than a public business API intended for direct customer extension. The package body references several core EBS infrastructure objects, including FND_GLOBAL, FND_MESSAGE, FND_PROFILE, FND_IMUTL, FND_LANGUAGES, FND_LOBS, and FND_HELP_DOCUMENTS/FND_HELP_TARGETS, confirming its role as an internal service layer within the Applications Technology stack.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions in APPS.FND_HELP. Their purposes are as follows:

• GET_URL — Resolves and returns the URL associated with a given help target, allowing callers to navigate to external or internal help destinations.
• GET — Retrieves the help content or help record corresponding to the requested topic or identifier.
• HELP_SEARCH — Executes a search against the stored help documents and returns matching results for the help search interface.
• LOAD_DOC — Loads a help document from the repository, typically materializing content from FND_HELP_DOCUMENTS and FND_LOBS.
• LOAD_TARGET — Loads help target metadata so that the correct target definition is available to the caller.
• CULL_ROW — Performs row-level filtering or selection logic used during help content assembly.
• DELETE_DOC — Removes a help document from the repository.

No parameter lists are published in the provided ETRM excerpt; the descriptions above are limited to the documented naming and inferred purpose.

Tables Accessed

The package body reads from and writes to the following documented objects, primarily through APPS synonyms:

• FND_HELP_DOCUMENTS — Stores the help document records that LOAD_DOC and DELETE_DOC operate against.
• FND_HELP_TARGETS — Holds help target definitions used by GET_URL and LOAD_TARGET.
• FND_LANGUAGES / FND_LANGUAGES_VL — Provides language and translation context so help content is returned in the appropriate language.
• FND_LOBS — Stores large object content, enabling LOAD_DOC to retrieve document bodies.
• DBMS_SESSION, DBMS_SQL, DUAL, UTL_I18N — Infrastructure dependencies supporting session context, dynamic SQL, dual-row queries, and internationalization.

Usage Notes

FND_HELP is normally invoked indirectly by the EBS Help framework rather than by end users or custom code. Forms-based help, the Help menu, and context-sensitive help triggers route requests through this package to obtain URLs, documents, and search results. It is also used by concurrent or maintenance processes that load, refresh, or delete help content. Because ETRM classifies the package as OTHER and it is not referenced by any database object, direct invocation from custom code is discouraged; developers should rely on supported Help framework entry points. The package depends on FND_GLOBAL, FND_PROFILE, and FND_MESSAGE, meaning correct operation requires a valid application session and profile context.