Search Results fem_cctr_orgs_pkg




Overview
Explore in AI Chat

Overview

The APPS.FEM_CCTR_ORGS_PKG package body is a foundational data-maintenance API within the Oracle E-Business Suite Enterprise Territory and Resource Management (ETRM) module. Its primary business function is to manage the definition, translation, and lifecycle of company cost center organizations — organizational constructs that map cost centers to value sets and dimension groups used in territory and resource assignment processing. ETRM relies on these cost center organization records to determine how resources, territories, and organizational hierarchies are qualified and evaluated during territory and quota computations. The package provides the canonical insert, update, delete, and translation maintenance operations for the underlying base and translation tables, ensuring that all writes conform to the standard EBS multi-language and concurrency-control conventions.

Key Procedures and Functions

The package exposes six documented procedures that together form the complete maintenance interface for cost center organization data:

  • INSERT_ROW — Creates a new cost center organization record. It inserts the base-language row into the base table and then propagates the descriptive attributes (name, description) into the translation table via a language-aware select, as illustrated in the documented source excerpt.
  • LOCK_ROW — Acquires a row-level lock on an existing cost center organization record, typically invoked within the standard SELECT ... FOR UPDATE pattern to enforce concurrency control before an update.
  • UPDATE_ROW — Modifies the attributes of an existing cost center organization, including its enabled, personal, and read-only flags, display code, and descriptive fields.
  • DELETE_ROW — Removes a cost center organization record, handling both the base and translation table rows.
  • ADD_LANGUAGE — Inserts translation rows for a newly installed or enabled language, ensuring the record becomes available across all active EBS languages.
  • TRANSLATE_ROW — Updates the translatable name and description fields in the translation table for a specified language, supporting the multi-language requirement of ETRM.

Tables Accessed

The package performs all of its DML against three documented tables, accessed through APPS synonyms:

  • FEM_CCTR_ORGS_B — The base table holding language-independent cost center organization attributes, including company cost center organization ID, value set ID, dimension group ID, display code, and the enabled, personal, and read-only flags. This is the primary target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW.
  • FEM_CCTR_ORGS_TL — The translation table storing the language-specific organization name and description. It is populated on insert via the language-aware select and maintained by ADD_LANGUAGE and TRANSLATE_ROW.
  • FND_LANGUAGES — The standard EBS language repository, referenced to identify installed and enabled languages when populating translation rows and when materializing base rows across the language set.

Usage Notes

FEM_CCTR_ORGS_PKG is classified as an OTHER API within ETRM and is referenced by four other packages, indicating that it sits beneath higher-level ETRM maintenance logic rather than being called directly by end users. In practice, it is invoked by the ETRM setup forms and administrative user interfaces that capture company cost center organizations, and by concurrent programs or batch processes that load or migrate cost center organization definitions. Custom integrations that need to create, update, or translate cost center organizations should call these procedures rather than issuing direct DML, because the API enforces the paired base-and-translation inserts, concurrency locking, and language propagation required for data integrity. Records created through this package become available to territory and resource assignment processing, so the enabled and read-only flags set here directly influence downstream recruitment and qualification behavior.