Search Results create_line

Overview

APPS.PA_BASELINE_FUNDING_PKG is a server-side PL/SQL package in Oracle EBS Projects (PA) that manages the creation and maintenance of project funding baselines. It supports the baseline funding feature, in which approved funding amounts are versioned and compared against budget and agreement data for a project. The package serves projects that use budgetary controls and funding structures, particularly those using award (AR) budget types and multi-currency billing or cross-operating-unit funding configurations. Its responsibilities include creating draft budget versions, inserting funding lines, generating the budget baseline, and reconciling project agreement and change management baselines. The underlying logic checks operating unit setup through profile and installation options before allowing funding operations that cross organizational boundaries or share bill rate schedules.

The header identifies the package as owned by APPS and classified as OTHER. Its global variables include P_PA_DEBUG_MODE, derived from the PA_DEBUG_MODE profile option, and g_module_name, used to identify the package module in debug logging. The package returns status and error information through standard OUT parameters, keeping it consistent with EBS PL/SQL API conventions.

Key Procedures and Functions

• CREATE_DRAFT — Creates a draft budget version for a project given a project identifier, a start and end date, and a resource list identifier. It determines whether multi-currency billing, sharing of bill rate schedules across operating units, and funding across operating units are permitted for the operating unit, and returns the default exchange rate type and functional currency. It also returns the new budget version identifier along with error code and status. Internally it queries PA_BUDGET_VERSIONS for the maximum version using award budget type and working status.
• CREATE_LINE — Inserts or creates an individual funding line within a draft baseline, associating funding amounts with the project structure. The user's search term maps to this procedure, which is the entry point for adding a single line of baseline funding data.
• CREATE_BUDGET_BASELINE — Generates the budget baseline for a project, establishing the approved funding amounts that later baselines are measured against.
• PROJ_AGREEMENT_BASELINE — Builds the baseline associated with project agreements, aligning agreement values with the project's funding baseline.
• CHANGE_MANAGEMENT_BASELINE — Handles baselines in the context of change management, supporting comparisons when project changes are introduced.

Tables Accessed

• PA_BUDGET_VERSIONS — Stores budget version records; the package selects the maximum version for a project when creating a draft.
• PA_PROJECTS_ALL — Provides project attributes and operating unit context for baseline operations.
• PA_PROJECT_FUNDINGS — Holds project funding records written or referenced when lines and baselines are created.
• PA_PROJ_FP_OPTIONS — Supplies funding and billing option flags, including multi-currency billing and exchange rate type defaults.
• PA_RESOURCE_LIST_MEMBERS — Defines resource list membership used when creating draft versions.
• PA_TASKS — Supplies task structure against which funding lines may be associated.
• PA_IMPLEMENTATIONS — Provides installation-level information for operating unit validation.
• PLITBLM — Standard EBS PL/SQL table used for message handling.

Usage Notes

The package is typically invoked from the Oracle Projects Baseline Funding and Budgeting forms, and may also be called by concurrent programs that generate baselines in batch. The ETRM metadata records that it is referenced by three other packages, indicating reuse by related funding and agreement APIs. Debug output is controlled through the PA_DEBUG_MODE profile option. Because the package writes to funding and budget version tables, custom integrations should invoke the documented procedures rather than inserting directly, and should check the returned status, error code, and message count before committing.