Search Results pa_cost_base_cost_codes_pkg

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

Overview

The APPS.PA_COST_BASE_COST_CODES_PKG package is a PL/SQL validation utility within the Oracle Projects (PA) module of Oracle E-Business Suite. Its principal business function is to enforce uniqueness constraints on cost base cost code definitions, ensuring that a given combination of project cost structure, cost base, cost base type, and related identifier does not duplicate an existing configuration record. Cost bases and cost codes underpin project cost collection and burdening logic, so maintaining uniqueness across these definitions is essential for accurate cost distribution, indirect cost allocation, and downstream accounting entries. The package header carries a source control identifier (PAXCICIS.pls) and a 2005 revision tag, indicating it is a long-standing, stable component of the Projects foundation layer rather than a frequently modified API. In ETRM classifications the package is documented as API classification OTHER, meaning it is an internal validation helper rather than a public, callable business API.

Key Procedures and Functions

The package exposes a single documented procedure:

• CHECK_UNIQUE — Validates that a cost base cost code definition does not already exist for the supplied configuration keys. It accepts inputs describing the cost structure, cost base, cost base type, and an identifying code, and returns a status value through an IN OUT NOCOPY parameter, allowing the caller to test the outcome without an exception-driven flow. The procedure serves as a guard routine that callers invoke before inserting or updating cost base cost code records.

No other procedures or functions are documented in the package specification.

Tables Accessed

The package operates against a single documented table, referenced through an APPS synonym:

• PA_COST_BASE_COST_CODES — Stores the defined cost base cost codes for project cost bases. CHECK_UNIQUE queries this table to determine whether a matching record already exists for the supplied structure, base, base type, and code combination. The package does not, per the documented metadata, perform inserts or updates on this table; its role is read-only validation, leaving persistence to the calling form or program.

Usage Notes

Because PA_COST_BASE_COST_CODES_PKG is classified as OTHER rather than a public API, it is typically invoked indirectly by Oracle Projects setup forms and internal maintenance logic whenever cost base cost codes are created or modified. The Oracle Projects setup user interface for cost bases and cost codes calls such validation routines to prevent duplicate definitions before committing a record. The procedure may also be invoked from custom extensions, conversion scripts, or interface programs that populate PA_COST_BASE_COST_CODES, where calling CHECK_UNIQUE first avoids unique-constraint violations and produces cleaner error handling. The package is not referenced by any other documented package, confirming it sits at the leaf of the dependency tree and is called directly by forms or external code rather than by peer packages. Because it uses an IN OUT NOCOPY status parameter, callers should initialise the status variable and inspect it after the call rather than relying exclusively on exceptions. Standard support considerations apply: modifications to the package body should be avoided in favour of Oracle-provided extensions, and any custom invocation should be re-tested during upgrades between 12.1.1 and 12.2.2 due to possible table or index changes.