Search Results funding_status_code




Overview
Explore in AI Chat

Overview

APPS.FEM_FUNDSTATUS_PKG is the table-handler package for the Funding Status setup entity in Oracle E-Business Suite. Funding status codes classify a funding source or award record according to its current standing—for example, whether funds are active, suspended, terminated, or pending—and these classifications are consumed by the Enterprise Performance Foundation (FEM) and related funds-utilization components. The package body encapsulates the standard Oracle EBS translatable-entity pattern: a non-translated base table (FEM_FUNDSTATUS_B) holds language-independent control columns, while a translation table (FEM_FUNDSTATUS_TL) holds the language-dependent name and description. In Oracle EBS 12.1.1 and 12.2.2 this package sits beneath the related validation package FEM_FUNDSTATUS_VALID_PKG and is part of the APPS schema, classified as an "OTHER" API in the ETRM repository. The columns it manages—ENABLED_FLAG, PERSONAL_FLAG, READ_ONLY_FLAG, and OBJECT_VERSION_NUMBER—follow the standard Oracle Application Object Library (AOOL) conventions for extensible lookup-style entities, including seed-data protection and optimistic locking.

Key Procedures and Functions

The package exposes six documented procedures. INSERT_ROW creates a new funding status: it inserts the base-row attributes into FEM_FUNDSTATUS_B, then seeds one FEM_FUNDSTATUS_TL row for every installed or base language returned by FND_LANGUAGES, using SOURCE_LANG = USERENV('LANG'). It returns X_ROWID and raises NO_DATA_FOUND via the internal cursor if the base-row verification fails.

  • LOCK_ROW — acquires a row-level lock and returns the X_ROWID for a given FUNDING_STATUS_CODE, used to guarantee exclusive access before an update.
  • UPDATE_ROW — modifies the base-table columns (enabled, personal, read-only flags, object version number) and the caller's language translation row.
  • DELETE_ROW — removes the base row and its associated translation rows.
  • ADD_LANGUAGE — inserts missing FEM_FUNDSTATUS_TL rows for a newly installed language, copying values from the source-language row.
  • TRANSLATE_ROW — updates the FUNDING_STATUS_NAME and DESCRIPTION for a specific language, writing the appropriate SOURCE_LANG value for translation maintenance.

Tables Accessed

  • FEM_FUNDSTATUS_B — the base table; INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW read and write FUNDING_STATUS_CODE together with the ENABLED_FLAG, PERSONAL_FLAG, READ_ONLY_FLAG, OBJECT_VERSION_NUMBER, and standard WHO audit columns.
  • FEM_FUNDSTATUS_TL — the translation table; holds FUNDING_STATUS_NAME and DESCRIPTION per LANGUAGE, keyed by FUNDING_STATUS_CODE and maintained by INSERT_ROW, ADD_LANGUAGE, and TRANSLATE_ROW.
  • FND_LANGUAGES — read during INSERT_ROW to enumerate languages with INSTALLED_FLAG in ('I','B') so that a translation row exists for each active language.

Usage Notes

The package is invoked indirectly by the Funding Status maintenance form and by concurrent programs that seed or migrate funding status definitions, rather than being called directly from end-user screens. The FEM_FUNDSTATUS_VALID_PKG layer performs validation before delegating inserts, updates, and deletes to this package. Because it is referenced by three other packages, customizations should treat FEM_FUNDSTATUS_PKG as a dependent object: direct modifications are unsupported, and any extension should wrap the documented procedures while preserving the OBJECT_VERSION_NUMBER for optimistic locking and honoring the READ_ONLY_FLAG to avoid altering seeded rows. The standard sequence is LOCK_ROW (for an existing code), UPDATE_ROW or DELETE_ROW, and TRANSLATE_ROW for language-specific text; ADD_LANGUAGE is reserved for post-installation language additions. The package name itself confirms the searched object, "funding_status_code," is the primary key of both tables and the discriminator used throughout.