Search Results x_created_by

Overview

FND_OAM_DOC_CATEGORY_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It provides the programmatic interface for maintaining records in the FND_OAM_DOC_CATEGORY table, which stores category definitions used by the Oracle Application Manager (OAM) documentation and help infrastructure. In EBS 12.1.1 and 12.2.2, this table underpins the organization and classification of online documentation content, allowing documentation categories to be keyed by a category key and a category type. The package exposes a small, conventional set of DML wrapper routines that seed and maintain this reference data, either through Oracle's standard seed-data loading mechanism or through direct invocation. The documented header comment indicates a last revision of 120.0 dated 2005/08/05, which is consistent with the package being stable, mature infrastructure code carried forward across releases rather than actively reworked application logic.

Key Procedures and Functions

• LOAD_ROW — The primary entry point for idempotent loading of a category row. It attempts to update an existing row identified by the category key and category type; if no matching row is found, it inserts a new one. This update-then-insert pattern makes LOAD_ROW suitable for repeatable seed or migration loads. It commits at the end of its execution.
• UPDATE_ROW — Modifies an existing FND_OAM_DOC_CATEGORY record. It first verifies the row exists by selecting the category key for the supplied key and type; if the row is absent, a NO_DATA_FOUND exception propagates to the caller. The update refreshes the category name and the standard WHO audit columns (created_by, creation_date, last_update_date, last_updated_by, last_update_login).
• INSERT_ROW — Creates a new FND_OAM_DOC_CATEGORY record with the supplied category key, category type and category name, together with the WHO audit columns. This routine is invoked by LOAD_ROW when the target row does not yet exist.

All three routines share the same attribute set — category key, category type, category name, and the audit columns created_by, last_updated_by and last_update_login — reflecting the narrow, single-table scope of the package. No parameter lists are enumerated here beyond those documented.

Tables Accessed

The package operates exclusively on FND_OAM_DOC_CATEGORY, accessed through the APPS synonym in the EBS database. UPDATE_ROW performs a SELECT against the table to confirm row existence before performing its UPDATE, and both INSERT_ROW and UPDATE_ROW write to the table. No other tables are referenced in the documented source, and the ETRM metadata confirms a single table dependency.

Usage Notes

FND_OAM_DOC_CATEGORY_PKG is not referenced by any other documented packages, which indicates it is a leaf-level data maintenance API rather than a shared library. It is typically invoked by Oracle's seed-data loaders or by custom code that needs to populate or refresh documentation category definitions, rather than by end-user forms or concurrent programs directly. The X_CREATED_BY parameter highlighted in the source is a WHO audit column passed through from the caller; when invoking these routines from custom code, callers are responsible for supplying a valid FND_USER identifier and login context so that audit columns remain meaningful. The explicit COMMIT inside LOAD_ROW means callers cannot freely combine it into a larger transaction without accounting for that behavior.