Search Results pa_alloc_runs_s

Overview

PA_CAP_INT_PVT is a private PL/SQL package body in the APPS schema that supports the Capitalized Interest feature of Oracle Projects. Capitalized interest represents the cost of financing construction or capital projects during their execution, calculated on eligible expenditures and subsequently burdened or capitalized according to the burden schedule associated with the project. The package encapsulates the core logic required to generate capitalized interest transactions, evaluate eligibility of expenditure types, resolve project and task attributes, and manage the allocation run structures that drive interest distribution across projects and tasks.

Because the API classification is PVT, the package is not intended for direct invocation by external or customer code. It functions as an internal engine behind the public capital interest generation process, orchestrating reads and writes across allocation, budgeting, and rate tables. The "PVT" designation indicates that its signatures and behavior may change between releases without notice, and Oracle does not publish it as a supported extension point. The related package PA_CLIENT_EXTN_CAP_INT is the sanctioned client extension hook, allowing customers to influence capitalization outcomes without modifying the private body.

Key Procedures and Functions

The documented package exposes nine procedures and functions, each supporting a distinct facet of capitalized interest processing:

• GENERATE_CAP_INTEREST — The principal driver that calculates and creates capitalized interest for eligible projects, expenditures, and periods.
• PURGE_SOURCE_DETAIL — Removes source detail records associated with prior interest computations, supporting reprocessing and cleanup.
• EXCLUDE_EXPENDITURE_TYPE — Determines whether a given expenditure type is excluded from capitalized interest treatment.
• CDL_STATUS — Returns the status of the capitalized interest, capital, or cost distribution line relevant to the transaction under evaluation.
• TASK_CAPITAL_FLAG — Resolves the capitalization flag for a task, indicating whether the task is capitalizable.
• GL_PERIOD — Identifies the applicable general ledger period for a given capitalization calculation.
• PERIOD_END_DATE — Returns the end date of the relevant accounting period for interest computation purposes.
• PROJECT_ID — Resolves the project identifier associated with the capitalized interest transaction or source record.
• RATE_NAME — Retrieves the applicable interest rate name used in the capitalization rate calculation.

Tables Accessed

The package references the following tables via APPS synonyms, in addition to views and lookup objects used throughout the calculation:

• PA_CINT_RATE_INFO, PA_CINT_RATE_INFO_ALL, PA_CINT_RATE_MULTIPLIERS, PA_CINT_SOURCE_DETAILS — Store and resolve interest rates, multipliers, and the source detail records underpinning each calculation.
• PA_ALLOC_RUNS, PA_ALLOC_RUNS_ALL, PA_ALLOC_RUNS_S, PA_ALLOC_TXN_DETAILS, PA_ALLOC_TXN_DETAILS_S, PA_ALLOC_RULES_ALL, PA_ALLOC_EXCEPTIONS — Support allocation run creation, transaction detail generation, and rule/exception handling that distribute capitalized interest across projects and tasks.
• PA_BUDGET_ENTRY_METHODS, PA_BUDGET_VERSIONS — Define the budget and version context used when evaluating capitalization eligibility.
• GL_PERIOD_STATUSES — Provides open and closed period status information used to determine valid periods for capitalization.
• HR_ALL_ORGANIZATION_UNITS — Supplies organization information for expenditure items and interest rate context.

The presence of PA_ALLOC_RUNS_S and PA_ALLOC_RUNS_ALL confirms that the package participates directly in the allocation run lifecycle, which is why a search for "pa_alloc_runs_s" surfaces this object.

Usage Notes

PA_CAP_INT_PVT is invoked internally by the Capitalized Interest Generation concurrent program and supporting processes during the period-end close cycle. It is referenced by one other package within the APPS schema and is not referenced by any database object outside that relationship. Because it is a private package, direct calls from custom code are unsupported; integrators seeking to influence capitalized interest behavior should use PA_CLIENT_EXTN_CAP_INT and its extension points. When troubleshooting allocation run issues, DBAs typically trace execution of this package to inspect how capitalized interest transactions are written to PA_ALLOC_RUNS and PA_ALLOC_TXN_DETAILS.