Results for “pa_cost_rate_pub”

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

Overview

APPS.PA_COST_RATE_PUB is a public PL/SQL API package within the Oracle Projects (PA) application, delivered under the APPS schema with a status of VALID across Oracle E-Business Suite 12.1.1 and 12.2.2. The package exposes cost and rate retrieval logic that supports labor costing, burdening, and compensation-driven rate determination for project expenditures. Its classification as a PUB package indicates that Oracle supports direct invocation of its documented entry points and treats their signatures as stable interfaces for extension, integration, and custom development. Internally it resolves effective-dated rates by combining employee assignment data, organization hierarchies, compensation rule sets, and standard bill rate schedules, so that transactions, adjustments, and costing processes can obtain the correct labor rate at the correct point in time.

Key Procedures and Functions

The package exposes five documented entry points. Each is a public interface and should be called only with the parameters defined in the Oracle Projects documentation; parameter lists are intentionally not restated here.

• GET_LABOR_RATE — Returns the applicable labor rate for a given employee, organization, and date context, drawing on bill rate schedules and compensation data.
• GET_ORGN_LEVEL_COSTING_INFO — Retrieves organization-level costing information, used when rates or costing attributes are driven by the expenditure organization rather than the individual.
• GETEMPCOSTRATE — Resolves the cost rate for an employee, typically in the context of a specific assignment, project, or task.
• GETEMPCOSTRATEINFO — Returns supplementary employee cost rate information that accompanies the primary rate result, supporting downstream validation and rate explanation.
• GET_ORGN_LVL_CST_INFO_SET — Retrieves a set of organization-level costing records, allowing batch-style resolution across multiple organizations or rule sets.

Tables Accessed

The package reads from and, where applicable, references a focused set of Projects and HR tables through APPS synonyms.

• PA_COMPENSATION_DETAILS_ALL / PA_COMPENSATION_DETAILS and PA_COMPENSATION_RULE_SETS — source employee compensation amounts and the rule sets that determine how those amounts map to cost rates.
• PA_BILL_RATES_ALL and PA_STD_BILL_RATE_SCHEDULES / PA_STD_BILL_RATE_SCHEDULES_ALL — standard and project-specific rate schedules used in rate derivation.
• PA_ORG_LABOR_SCH_RULE — links organizations to labor schedules, driving organization-level rate selection.
• PA_PROJECTS_ALL, PA_TASKS, PA_IMPLEMENTATIONS_ALL — project and task context plus implementation-level costing options that modify rate behavior.
• PA_EXPENDITURES_ALL and PA_EXPENDITURE_ITEMS_ALL — expenditure detail used when rates are validated or applied against actual transactions.
• PER_ALL_PEOPLE_F and PER_JOBS — employee and job attributes that qualify rate eligibility.
• HR_ORGANIZATION_UNITS and GL_SETS_OF_BOOKS — organization and ledger context, with PA_PLSQL_DATATYPES supplying shared PL/SQL type definitions.

Usage Notes

PA_COST_RATE_PUB is referenced by five other packages, including PA_ADJUSTMENTS, PA_COST, PA_COST1, PA_COST_RATE_PUB itself, and PA_UTILS, confirming its role as a shared rate-resolution utility within the Projects costing stack. Typical invocation occurs during cost distribution, expenditure adjustment processing, and any concurrent program that must determine or re-derive labor rates. Custom extensions and interfaces that need a supported, upgrade-safe method of obtaining employee or organization cost rates should call the documented procedures rather than querying the underlying compensation and bill rate tables directly. Because the package relies on effective-dated compensation and schedule data, callers should always supply the correct transaction date context. Oracle ETRM records the object as VALID and publishes its dependent code, so integrators can review the referenced packages when building derivative logic.