Search Results prc_row_exists

Overview

PA_PRC_PROJECT_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified in the E-Business Suite Table and API Repository (ETRM) as a PUBLIC API. Its naming reflects its role within the Oracle Projects (PA) module, specifically the Project Resource Center (PRC) subsystem that supports project costing, multi-currency costing and customer event processing. The package encapsulates reusable, callable business logic that mediates access to a set of underlying PA_MC_* tables — the "Multi-Currency Costing" and customer event distribution structures used by Project Costing and Project Billing.

The publication status (PUB) and its registration as a documented public API indicate that the package is intended for supported external invocation by other Oracle EBS modules, extensions and custom code, rather than being an internal-only implementation detail. Its dependencies are limited to the SYS.STANDARD package, confirming that it is a lightweight utility/validation package that does not itself depend on other application packages. The ETRM records for release 12.2.2 confirm the package status as VALID.

Key Procedures and Functions

The ETRM metadata documents a single public subprogram for this package: PRC_ROW_EXISTS.

• PRC_ROW_EXISTS — A validation-style routine that determines whether a corresponding row exists in the Project Resource Center structures accessed by the package. Given the package name and the tables it references, this procedure serves as an existence check used by callers to confirm that a cost distribution line, customer event, or related multi-currency row is present before performing further processing. No parameter list is documented in the ETRM extract, and therefore none is asserted here; callers should consult the package specification in the target instance for the exact signature.

Tables Accessed

The documented table references (resolved through APPS synonyms) are:

• PA_MC_COST_DIST_LINES_ALL — Multi-currency cost distribution lines; the principal costing detail rows validated by PRC_ROW_EXISTS.
• PA_MC_CUST_EVENT_RDL_ALL — Customer event detail rows supporting billing/customer event processing in the PRC flow.
• PA_MC_CUST_RDL_ALL — Customer-level multi-currency rows that group or summarise billable customer event data.
• PA_MC_EVENTS — The header/event table that anchors customer event processing.
• PA_MC_EXP_ITEMS_ALL — Expenditure item rows associated with the multi-currency costing flow.

These tables form the core multi-currency costing and customer event data set within Oracle Projects. The package reads from them to evaluate existence of rows rather than to perform heavy transactional updates, consistent with its single documented subprogram.

Usage Notes

Because PA_PRC_PROJECT_PUB is registered as a PUBLIC API and is referenced by no other database packages, it is intended to be invoked directly by external callers rather than being called from within a package chain. Typical invocation points include:

• Custom PL/SQL extensions and interfaces that populate or reconcile multi-currency costing and customer event data, where an existence check prevents duplicate inserts or invalid foreign-key style references.
• Concurrent program logic or correction scripts operating on PA_MC_* tables within Project Costing.
• Oracle Projects forms logic that requires a lightweight validation of a PRC row before enabling further actions.

Developers should treat the package as a support/validation utility. Given the exceptionally limited documented surface, any custom code relying on it should be verified against the actual package specification in the target EBS instance (12.1.1 or 12.2.2), as the ETRM extract documents only one subprogram and no parameter metadata. Standard Oracle support and upgrade policies for public APIs apply.