Search Results get_assignment_schedule

Overview

PA_FORECAST_ITEMS_UTILS is a utility package in the Oracle EBS Projects (PA) module, owned by the APPS schema and classified as an "OTHER" API in the ETRM registry. Its primary business function is to support the forecasting infrastructure used within Oracle Project Resource Management and Project Billing forecasting flows. The package provides reusable helper routines for generating unique forecast item identifiers, managing concurrency through user-defined locks, resolving project and resource defaults, and retrieving assignment and resource schedules. Although not a public, externally supported API, it is a load-bearing internal utility that is invoked by at least six other packages within the PA schema.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, which is typical for internal PL/SQL utilities that depend on APPS synonyms and session context.

Key Procedures and Functions

• GET_NEXT_FORECAST_ITEM_ID — Returns the unique identifier for a new forecast item, typically sourced from a sequence, ensuring each forecast record receives a distinct primary key.
• SET_USER_LOCK — Acquires a user lock keyed by a source identifier and lock purpose, used to serialize access to forecast data during concurrent updates.
• RELEASE_USER_LOCK — Releases the user lock previously acquired via SET_USER_LOCK. This is the routine most commonly searched for by developers diagnosing lock contention or orphaned locks in forecasting sessions.
• ALLOCATE_UNIQUE — Wraps DBMS_LOCK.ALLOCATE_UNIQUE to obtain a lock handle for a given lock name, underpinning the user lock mechanism.
• LOG_MESSAGE — Writes a diagnostic text message to the standard logging mechanism for the package.
• GET_RESOURCE_ASGN_SCHEDULES — Returns a schedule table for a resource across a date range, populated into a PA_FORECAST_GLOB collection type.
• GET_ASSIGNMENT_SCHEDULE — Returns the schedule for a specific assignment across a date range and processing mode.
• GET_PERIOD_SET_NAME, GET_PA_PERIOD_NAME, GET_WEEK_DATES_RANGE_FC — Resolve accounting period set names, PA period names, and weekly date ranges used in forecast calculations.
• GET_WORK_TYPE_DETAILS, GET_RESOURCE_ID, GET_RESOURCE_TYPE — Return descriptive attributes about work types and resources needed when building forecast records.
• GET_FORECASTOPTIONS, CHECK_TPAMOUNTTYPE — Retrieve forecasting options configuration and validate time-phased amount types.
• GET_ASSIGNMENT_DEFAULT, GET_PROJECT_DEFAULT, GET_PROJECT_ROLE_DEFAULT — Return default values for assignments, projects, and project roles, supporting form defaulting logic.

Tables Accessed

The package reads and writes a focused set of PA and GL tables via APPS synonyms. Forecast item persistence occurs in PA_FORECAST_ITEMS_S. Configuration and setup data come from PA_FORECASTING_OPTIONS_ALL, PA_IMPLEMENTATIONS_ALL, PA_PROJECTS_ALL, PA_PROJECT_ASSIGNMENTS, PA_PROJECT_ROLE_TYPES_B, PA_PROJECT_STATUSES, PA_RESOURCES, PA_RESOURCES_DENORM, PA_RESOURCE_TXN_ATTRIBUTES, PA_RESOURCE_TYPES, and PA_SCHEDULES. Period resolution depends on PA_PERIODS_ALL, GL_PERIODS, and GL_DATE_PERIOD_MAP.

Usage Notes

PA_FORECAST_ITEMS_UTILS is invoked by other PA packages (six referenced callers) and by forecasting forms and concurrent programs. Developers typically encounter it indirectly — for example, when tracing a "release_user_lock" call during forecast generation or when troubleshooting a forecast item that retains an unexpired DBMS_LOCK handle. Because the package is not a formally published API, direct custom calls should be treated cautiously; parameter contracts may change between releases. In 12.1.1 and 12.2.2, the routines remain internal helpers supporting the forecast item lifecycle.