Search Results get_schedule_id

Overview

PA_FORECAST_COST is a PL/SQL package in the Oracle E-Business Suite Projects (PA) module that supplies the cost calculation engine used to forecast raw labor costs, burden costs, and project-level rates against expenditure data. It is classified as an OTHER API and is owned by the APPS schema. In the context of Oracle EBS 12.1.1 and 12.2.2, the package serves as an internal costing utility that resolves the correct hourly cost rate, cost multiplier, currency code, and effective date for a given combination of person, expenditure organization, and expenditure item date, and then derives raw and burdened cost amounts for forecasting and planning purposes.

The header revision ($Header: PARFRTCB.pls 120.4 2005/08/19) reflects its long-standing role in the Projects costing architecture. The body declares private exceptions for null functional currency codes, null raw cost, and null burden cost, and initializes an internal return status using FND_API.G_RET_STS_SUCCESS, indicating conformance to the standard EBS API error-handling convention.

Key Procedures and Functions

The ETRM metadata documents eight procedures/functions within the package body:

• GET_RAW_COST — Retrieves the raw labor cost rate and calculated raw cost for a person, expenditure organization, labor cost multiplier, and item date. The body shows it selecting HOURLY_COST_RATE from PA_COMPENSATION_DETAILS_ALL and the multiplier from PA_LABOR_COST_MULTIPLIERS, returning raw cost rate and raw cost along with standard API status and message outputs.
• GET_BURDEN_COST — Calculates burden cost components applied on top of raw cost, drawing on bill rate and cost distribution override information.
• GET_PROJ_RAW_BURDEN_COST — Derives combined raw and burdened project cost figures for forecasting.
• GET_SCHEDULE_ID — The procedure the user searched for; it returns the applicable schedule identifier used in cost rate or rate-schedule resolution logic.
• GET_PA_DATE — Resolves an effective Projects date, typically used to align rate lookups with the correct accounting or project period.
• GET_CURR_CODE — Determines the functional currency code applicable to the costing context.
• OVERRIDE_EXP_ORGANIZATION — Applies an override to the expenditure organization so that the correct organization-specific cost rates are used.
• REQUIREMENT_RAW_COST — Computes the raw cost associated with a requirement-line costing scenario.

Tables Accessed

The package reads from a defined set of APPS-synonym tables:

• PA_COMPENSATION_DETAILS_ALL — Source of the person's hourly cost rate, joined by person and organization within the active date range.
• PA_LABOR_COST_MULTIPLIERS — Provides the labor cost multiplier used to scale raw cost.
• PA_BILL_RATES — Supplies bill rate values for burden and rate resolution.
• PA_COST_DIST_OVERRIDES — Holds cost distribution overrides affecting where costs are charged.
• PA_EXPENDITURE_TYPES — Classifies expenditure type behavior during costing.
• PA_PERIODS — Used by GET_PA_DATE to resolve valid accounting period dates.
• PA_PROJECTS, PA_PROJECTS_ALL, PA_PROJECT_TYPES, PA_TASKS — Provide project, task, and project type context for project-level forecast costing.
• PA_IMPLEMENTATIONS_ALL and FND_CURRENCIES — Support currency and implementation-level configuration lookups.

Usage Notes

PA_FORECAST_COST is not referenced by any other documented package, indicating it is called directly from EBS forms, concurrent programs, or custom extensions rather than chained through other APIs. It is typically invoked when forecasting labor and burden costs for project planning, when computing rates for a specific person/organization/date combination, or when override organizations and schedules must be resolved. Custom code should call the individual procedures using the standard FND_API return status, message count, and message data outputs, respecting the IN OUT NOCOPY parameter conventions noted in the source header.