Search Results set_project_task_numbers

Overview

APPS.RCV_Project_PVT is a private (PVT) PL/SQL package in Oracle E-Business Suite that supports the Receiving (RCV) module's integration with Oracle Projects. Its primary business function is to resolve and cache the project number and task number associated with a given receiving transaction, so that downstream receiving and project-related processing can attribute material receipts to the correct project and task. The package is defined with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking user rather than the package owner, consistent with the standard EBS approach to private APIs invoked within a session context.

The package maintains global (session-level) state through three variables: a transaction identifier and the resolved project and task numbers. These globals act as a lightweight cache so that repeated calls within a session do not need to re-derive the project/task assignment. The header identifies this as version 115.1, dated 2004, underscoring that this is long-standing, stable receiving infrastructure rather than a recently introduced object.

Key Procedures and Functions

The package exposes a single documented procedure:

• SET_PROJECT_TASK_NUMBERS — Populates the package-level global variables that hold the project number and task number for a receiving transaction. It accepts the standard EBS API parameters (API version, initialization of the message list, and the transaction identifier) and derives the applicable project and task values for that transaction. This is the procedure most commonly sought when developers search for "set_project_task_numbers," as it is the entry point for resolving project/task context during receiving.

No other documented procedures or functions are present in the supplied metadata. Notably, the package does not expose a getter in the header excerpt; consumers read the exposed global variables after invoking the setter, which is an unusual but intentional design for sharing state across receiving logic.

Tables Accessed

The package reads from the following documented tables (accessed through APPS synonyms):

• RCV_TRANSACTIONS — the core receiving transaction record; the transaction identifier drives the lookup of associated project and task information.
• PO_DISTRIBUTIONS_ALL — purchase order distribution lines, which carry the project and task references used to attribute receipt activity to a project.
• PA_PROJECTS_ALL — the Oracle Projects master table, used to resolve the project number from the distribution's project identifier.
• PA_TASKS — the project task definitions, used to resolve the task number.

Together these tables allow the procedure to traverse from a receiving transaction, through its PO distribution, to the owning project and task. The package is read-only with respect to these tables.

Usage Notes

RCV_Project_PVT is a private package and is not intended for direct invocation by end users or external customizations. It is referenced by one other package within the receiving codebase, which is the expected consumer of SET_PROJECT_TASK_NUMBERS. Typical invocation occurs during receiving transaction processing — for example, when receipts are created, corrected, or matched against project-related purchase orders — so that project and task numbers are available for subsequent processing, reporting, and accounting.

Because the resulting values are held in package globals rather than returned via OUT parameters, callers must invoke SET_PROJECT_TASK_NUMBERS first and then read the global variables within the same session. Custom code should treat this package as internal and subject to change; reliance on its globals is discouraged. The object is consistent across EBS 12.1.1 and 12.2.2, and its presence in both releases reflects the continued dependency of receiving on Oracle Projects integration.