Results for “non_labor”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_PLAN_REVENUE is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite (validated across 12.1.1 and 12.2.2). It belongs to the Oracle Projects (PA) module and supports revenue planning within the project financial planning (FP) framework. The package is responsible for resolving, deriving, and returning the billing and revenue rates that drive planned versus actual revenue calculations for project resources, resource classes, and planning scenarios.
In the project financial planning flow, planned revenue must be computed by applying the appropriate bill rate or revenue rate to planned quantities and amounts. Those rates can originate from several sources: standard bill rate schedules, employee or job rate overrides, resource-specific rates, or default rates. PA_PLAN_REVENUE centralizes the logic used to determine which rate applies for a given planning context, abstracting the underlying complexity from higher-level planning, budgeting, and forecasting programs. It is classified as an "OTHER" API rather than a public published interface, meaning it is intended primarily for internal use by other Oracle Projects packages and is not formally documented as a customer-callable API.
Key Procedures and Functions
The package exposes seven documented procedures and functions, each returning rate information for a distinct planning context:
- GET_PLANNING_RATES — Generic entry point for retrieving planning rates applicable to a planning scenario.
- GET_PLAN_ACTUAL_RATES — Returns rates used when comparing planned figures against actual project performance.
- GET_PLAN_ACTUAL_REV_RATES — Returns revenue-specific rates for the planned-versus-actual comparison.
- GET_PLAN_RES_CLASS_RATES — Derives rates at the resource class level, applying resource-class-based rate rules.
- GET_PLAN_PLAN_RATES — Returns rates for purely planned (forward-looking) scenarios.
- GET_PLAN_PLAN_REV_RATES — Returns the revenue rate components for planned scenarios.
- GET_PLAN_DEFAULT_RATES — Provides fallback default rates when no specific schedule or override is found.
The structure of these routines reflects a matrix of planning basis (plan or actual) against rate dimension (general, revenue, resource class), with defaults applied as a last resort.
Tables Accessed
The package reads from a defined set of APPS synonyms:
- PA_BILL_RATES_ALL and PA_STD_BILL_RATE_SCHEDULES_ALL — source the standard bill/revenue rate schedules.
- PA_EMP_BILL_RATE_OVERRIDES and PA_JOB_BILL_RATE_OVERRIDES — supply employee- and job-level rate overrides.
- PA_RESOURCE_LISTS_ALL_BG — defines resource list memberships used for rate assignment.
- PA_EXPENDITURE_TYPES, PA_BUDGET_VERSIONS, PA_PROJ_FP_OPTIONS, and PA_IMPLEMENTATIONS_ALL — provide planning, budgeting, and configuration context.
- PER_ORG_STRUCTURE_ELEMENTS — resolves organization hierarchy for rate determination.
- DUAL and PLITBLM — support PL/SQL utility operations.
Usage Notes
PA_PLAN_REVENUE is not typically invoked directly through a form or concurrent program; instead it is consumed programmatically. Documented callers include PA_FIN_PLAN_UTILS2, PA_FP_CALC_PLAN_PKG, PA_FP_GEN_BUDGET_AMT_PUB, PA_FP_GEN_FCST_AMT_PVT, and PA_PROGRESS_UTILS. These packages drive financial plan calculation, budget amount generation, and forecast amount generation. Custom extensions that need consistent rate resolution within the FP framework should call the same routines rather than reimplementing rate logic, since the package encapsulates override precedence, schedule selection, and default fallback behavior. Because it is classified as a non-public API, its signatures may change between patch levels, and customers should validate behavior against their specific release before relying on it in bespoke code.
-
Lookup Type: RETENTION_LEVEL 12.1.1
Retention Level
-
Lookup Type: RETENTION_LEVEL 12.2.2
Retention Level
-
View: PA_PROJ_RETN_EXP_V 12.2.2
Stores retention expenditure rules
APPS.PA_PROJ_RETN_EXP_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ PA_AGREEMENTS_ALL·Explore PA module →
-
View: PA_PROJ_RETN_EXP_V 12.1.1
Stores retention expenditure rules
APPS.PA_PROJ_RETN_EXP_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ PA_AGREEMENTS_ALL·Explore PA module →