Search Results unreversed_costs_exist

Overview

PA_CAPITAL_PROJECT_UTILS is a PL/SQL utility package owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling user rather than the package owner. Within Oracle EBS 12.1.1 and 12.2.2, it supports the Capital Projects business flow — the process by which expenditure charged to a capital project is accumulated, capitalized, and interfaced to Oracle Assets as fixed asset additions. The package provides the validation and reversal logic that surrounds the creation, adjustment, and removal of capital events and their resulting asset lines.

The package is classified as OTHER in the ETRM metadata, indicating it is an internal utility rather than a published, supported public API. It is referenced by two other packages, confirming it acts as a shared library of capital-project helper routines. The header identifies the source as PAXCAUTS.pls, version 115.2.

Key Procedures and Functions

The package exposes ten documented procedures and functions:

• UNREVERSED_ASSETS_EXIST — returns a VARCHAR2 indicating whether assets tied to a given asset identifier remain in an unreversed state.
• UNREVERSED_COSTS_EXIST — returns a VARCHAR2 indicating whether expenditure items still exist that have not been reversed.
• REVERSE_EVENT_ALLOW — determines whether a capital event may be reversed for a given project and capital event.
• REVERSE_EVENT_UPD — performs the update that reverses a capital event and returns a numeric status. This routine is the primary consumer of the P_CAPITAL_EVENT_ID parameter referenced in the user's search.
• IS_ASSET_ADJ_ALLOWED — returns a numeric flag indicating whether an adjustment is permitted against a given fixed asset and book type.
• TAG_NUMBER_EXISTS — returns a VARCHAR2 confirming whether a supplied asset tag number already exists.
• ALLOW_ASSETTYPE_CHANGE — evaluates whether an asset type may be changed, considering the source type, target type, project asset identifier, capitalized flag, and capital event identifier.
• GET_DEPRECIATION_EXPENSE_CCID — a procedure that derives the depreciation expense code combination identifier for a project asset and returns it along with an error message code.
• CAN_DELETE_EVENT — returns a VARCHAR2 indicating whether a capital event can be deleted for a project and event.
• ISVALIDEXPCCID — validates that a supplied code combination identifier is a valid expense account.

Tables Accessed

The package reads and writes against capital-project and asset tables accessed through APPS synonyms:

• PA_PROJECT_ASSETS_ALL / PA_PROJECT_ASSETS — the primary store of project asset records subject to capitalization and asset-type changes.
• PA_PROJECT_ASSET_LINES_ALL / PA_PROJECT_ASSET_LINES — the asset line detail rows generated from capital events.
• PA_PROJECT_ASSET_LINE_DETAILS — lower-level breakdown of asset lines used during validation and reversal.
• PA_EXPENDITURE_ITEMS_ALL — source expenditures tested by UNREVERSED_COSTS_EXIST.
• FA_ADDITIONS — Oracle Assets additions table, interrogated for tag-number existence and adjustment eligibility.
• GL_CODE_COMBINATIONS — account validation and CCID derivation for depreciation expense.
• PA_IMPLEMENTATIONS — installation-level setup and configuration checks.
• DUAL and PLITBLM — used for scalar evaluation and character-table PL/SQL constructs (the package declares G_CCID_Tab of type PA_PLSQL_DATATYPES.Char1TabTyp).

Usage Notes

Because the package is not a documented public API, it is invoked indirectly. Oracle Capital Projects forms and concurrent programs — particularly asset generation, capital event reversal, and asset adjustment — call these routines through internal package dependencies. The two packages that reference it depend on its validation functions before permitting a reversal or deletion.

Customizations should treat this package as unsupported and non-upgrade-safe. Any solution requiring capital event reversal or asset-type change validation should rely on supported APIs where available, invoking these utilities only for read-only validation checks such as TAG_NUMBER_EXISTS or ISVALIDEXPCCID.