Results for “cint_compile_schedule”

14 results




Overview
Explore in AI Chat

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

Overview

The APPS.PA_CAPITALIZED_INTEREST package body supports the Capitalized Interest feature of Oracle Projects. Capitalized interest represents the cost of financing construction or capital projects during their acquisition or construction period, calculated by applying an interest rate to eligible expenditures and capitalizing that calculated amount into the project cost. The package provides the underlying PL/SQL logic used to compile capitalized interest calculations — that is, to resolve the applicable interest rate schedules, cost multipliers, and organization-specific rates that drive the automated calculation of capitalized interest amounts. Within Oracle EBS 12.1.1 and 12.2.2, this package is an internal Projects module component rather than a public API; ETRM classifies it as an OTHER API, indicating it is intended for internal invocation. Its status is VALID, and it is not referenced by any other database object, confirming it sits at the top of its dependency chain within the Capitalized Interest subsystem.

Key Procedures and Functions

The documented package exposes two procedures. No parameter lists are published in the ETRM metadata; only their names and roles are described here.

  • CINT_COMPILE_SCHEDULE — Compiles the capitalized interest schedule. This routine resolves the rate schedules and effective-dated rate revisions that govern how interest is applied across project periods. It reads the rate schedule definitions and rate schedule revisions to build the in-memory or staged schedule used by subsequent capitalized interest processing.
  • CINT_COMPILE_ORG_RATES — Compiles organization-specific capitalized interest rates. This routine resolves the rate multipliers and cost multipliers associated with organizations along the organization hierarchy, producing the organization-level rate data required to calculate interest for expenditures charged to those organizations.

Tables Accessed

The package body reads from the following tables (accessed through APPS synonyms):

  • PA_CINT_RATE_MULTIPLIERS — Stores the multipliers applied to base interest rates for capitalized interest calculation; read to derive the effective rate applied to eligible project costs.
  • PA_IND_COST_MULTIPLIERS — Stores indirect cost multipliers used in cost build-up; read to determine the cost base against which interest is applied.
  • PA_IND_RATE_SCH_REVISIONS — Stores effective-dated revisions to indirect rate schedules; read to obtain the correct rate revision applicable to a given period.
  • PER_ORG_STRUCTURE_ELEMENTS — The Human Resources organization hierarchy table; read to resolve organization relationships and roll rates up or down the reporting hierarchy.

Additionally, the package depends on standard Oracle utilities and internal packages including FND_CONCURRENT, FND_GLOBAL, FND_PROFILE, PA_COST_PLUS, and PA_DEBUG, reflecting its integration with concurrent processing, profile options, cost-plus calculations, and debug/logging facilities.

Usage Notes

This package is invoked internally by Oracle Projects during capitalized interest generation, typically driven from the Capitalized Interest concurrent program or from related cost-processing flows. Its use of FND_CONCURRENT and FND_PROFILE indicates it operates within a concurrent request context and observes profile-option settings for organization and ledger defaults. Because the package is not referenced by other database objects and is classified as OTHER, it should be treated as an internal implementation component. Custom integrations requiring capitalized interest functionality should use supported Oracle Projects APIs or concurrent programs rather than calling these procedures directly, as internal signatures may change between releases. The PA_DEBUG dependency allows diagnostic tracing to be enabled during troubleshooting of rate compilation or schedule generation issues.