Search Results fem_calendars_pkg




Overview
Explore in AI Chat

Overview

FEM_CALENDARS_PKG is the foundational calendar maintenance package within the Oracle Enterprise Taxation and Revenue Management (ETRM) application family, deployed in the APPS schema of Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to provide the low-level data manipulation routines required to create, maintain, and translate calendar definitions used throughout ETRM modules such as tax registration, period determination, and fiscal reporting. Calendars in ETRM define the recurrence patterns, period boundaries, and reporting hierarchies against which transactional and compliance data is validated.

The package body is documented as VALID in the ETRM repository and is classified as an OTHER API type rather than a public or private API. It operates as a companion to the base table FEM_CALENDARS_B and its translation table FEM_CALENDARS_TL, and it wraps its insert, update, and delete logic in calls to APP_EXCEPTION and FND_MESSAGE for consistent error handling and message resolution.

Key Procedures and Functions

The ETRM metadata documents six procedures within this package body:

  • INSERT_ROW — Inserts a new calendar definition record into the base table, establishing the calendar header and its associated attributes.
  • LOCK_ROW — Acquires a row-level lock on an existing calendar record to serialize concurrent modifications before an update or delete is performed.
  • UPDATE_ROW — Modifies the mutable attributes of an existing calendar definition, typically invoked after LOCK_ROW has secured the record.
  • DELETE_ROW — Removes a calendar definition from the base table, subject to referential integrity checks against dependent ETRM data.
  • ADD_LANGUAGE — Introduces a new language row into the translation table for an existing calendar, enabling multilingual calendar names and descriptions.
  • TRANSLATE_ROW — Updates the translated name or description of an existing calendar for a specific language, maintaining synchronization with FND_LANGUAGES.

These procedures form a coherent maintenance API for a translatable entity: INSERT_ROW and ADD_LANGUAGE handle creation, LOCK_ROW and UPDATE_ROW handle modification, and DELETE_ROW handles removal.

Tables Accessed

The package references three tables through APPS synonyms:

  • FEM_CALENDARS_B — the base table storing language-independent calendar attributes. INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW operate against this table.
  • FEM_CALENDARS_TL — the translation table storing language-specific names and descriptions. ADD_LANGUAGE and TRANSLATE_ROW write to this table, while INSERT_ROW typically seeds the base-language row.
  • FND_LANGUAGES — the Oracle Foundation language repository, consulted to validate language codes and default language handling during translation operations.

The dependency listing additionally shows references to APP_EXCEPTION, FND_MESSAGE, FND_LOAD_UTIL, and STANDARD, which supply exception raising, message lookup, and generic PL/SQL utilities such as date and string handling.

Usage Notes

FEM_CALENDARS_PKG is not referenced by any other database object according to the ETRM dependency report, and no other packages depend on it directly. However, the broader ETRM metadata indicates an API classification of OTHER, and it is documented as referenced by six other packages in related metadata, suggesting it is consumed primarily by administrative or setup code rather than by high-volume transactional flows.

Typical invocation paths include ETRM setup forms that maintain calendar definitions, concurrent programs that load or seed calendar data through FND_LOAD_UTIL, and custom extension code that programmatically manages calendars. Because the package performs direct DML on the base and translation tables without an independent commit strategy, callers are expected to manage transaction boundaries. Custom code should invoke LOCK_ROW before UPDATE_ROW to avoid concurrent modification conflicts, and should supply valid FND_LANGUAGES codes when calling ADD_LANGUAGE or TRANSLATE_ROW. Deployments spanning 12.1.1 and 12.2.2 should verify that the FEM_CALENDARS_TL structure and the FND_LANGUAGES view remain compatible, as the package body is schema-bound to APPS.