Search Results get_rep_period_dates

Overview

APPS.PA_RATE_PVT_PKG is the private rate-calculation engine within the Oracle E-Business Suite Projects (PA) module. Its header comment describes it as the "consolidated procedure and function to calculate the raw cost, burdened cost and raw revenue on the basis of passed parameters." In practice it is the internal workhorse invoked by the public rate APIs to resolve cost and revenue rates for a given project, task, assignment, or role on a specific rate calculation date. Callers pass a calling mode (ACTUAL, ROLE, or ASSIGNMENT), a rate calculation date, an item identifier, project id, and a quantity expressed in hours, together with numerous optional parameters carrying labor cost multipliers, bill rate multipliers, expenditure and billing job groups, rate schedule identifiers, organization context, and distribution rules. The package returns computed raw cost, burdened cost, and revenue amounts and rates. Because it is classified as OTHER rather than a public API and is referenced by nine other packages, it functions as a shared internal service consumed throughout rate and revenue processing, including forecasting.

Key Procedures and Functions

The documented entry points cover rate retrieval, revenue computation, and period derivation:

• GET_ITEM_AMOUNT — Returns the calculated amount for a specified item based on the input rate, quantity, and calculation context; supports the raw cost, burdened cost, and raw revenue computations described in the package header.
• CALC_EVENT_BASED_REVENUE — Computes event-based revenue, in which revenue recognition is driven by the occurrence of qualifying project events rather than by cost or quantity incurred.
• CALC_COST_BASED_REVENUE — Computes cost-based revenue, deriving the revenue amount from burdened or raw cost according to the applicable revenue generation method.
• GET_REVENUE_GENERATION_METHOD — Returns the revenue generation method configured for the project, determining whether revenue is calculated on a cost basis, an event basis, or otherwise.
• GET_INITIAL_BILL_RATE — Retrieves the initial bill rate applicable to the given billing context before multipliers or schedule adjustments are applied.
• CALC_RATE_AMOUNT — Applies the recognized rate against the supplied quantity to produce a rate amount, forming the basis for the cost and revenue figures returned by the package.
• GET_REP_PERIOD_DATES — Returns the reporting period start and end dates, giving callers the date boundaries of the GL or PA reporting period that contains the relevant date. This function is the target of the search term "get_rep_period_dates" and is normally used to anchor rate and revenue calculations to a reporting period.

Tables Accessed

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

• GL_PERIODS, GL_DATE_PERIOD_MAP, GL_PERIOD_STATUSES — Supply calendar definitions, map dates to periods, and confirm period status; these are the principal tables behind GET_REP_PERIOD_DATES.
• PA_PERIODS — Provides Project Accounting period definitions used to derive reporting period boundaries.
• PA_PROJECTS, PA_PROJECTS_ALL, PA_PROJECT_TYPES_ALL — Provide project, project type, and related descriptive attributes that drive rate and revenue rules.
• PA_PROJECT_ASSIGNMENTS — Supplies assignment-level context, including assignments and forecast job groupings.
• PA_BILL_RATES_ALL — The source of bill rate schedules and rates used for revenue and billing calculations.
• PA_EXPENDITURE_ITEMS_ALL — Provides expenditure item detail that feeds cost-based revenue calculations.
• PA_FORECASTING_OPTIONS, PA_FORECASTING_OPTIONS_ALL, PA_FORECAST_ITEMS — Support forecasting-related rate and revenue calculations where forecast job identifiers are passed.
• PA_IMPLEMENTATIONS, PA_IMPLEMENTATIONS_ALL — Provide installation-level control settings that govern calculation behavior.

Usage Notes

PA_RATE_PVT_PKG is an internal, private package rather than a directly callable public API. It is normally invoked indirectly by the public rate APIs and by the nine other packages that reference it, which pass the calling mode and the full parameter set described in the header. Oracle Forms and concurrent programs in the Projects module reach this package through those calling layers. Custom code should avoid invoking the private package directly; the supported approach is to call the corresponding public rate and revenue APIs, which handle the required parameter population, validation, and defaulting. The package is version-sensitive: the checked-in header identifies script version 120.10 (dated 25 March 2011), and behavior may differ between EBS 12.1.1 and 12.2.2. All schema references use APPS synonyms, so grants and synonym validity must be confirmed when troubleshooting. GET_REP_PERIOD_DATES in particular relies on GL and PA period data, so period status and calendar configuration should be verified before relying on its returned dates.