Search Results inv_project




Overview
Explore in AI Chat

Overview

APPS.INV_PROJECT is a PL/SQL package body in the Oracle E-Business Suite Applications schema that provides the project and task validation, resolution, and defaulting logic used across Oracle Inventory and related supply chain modules. Its central business purpose is to bridge transactional inventory activity with Oracle Projects, ensuring that project and task references entered on material transactions, move orders, requisitions, receiving, and locator definitions are validated against the appropriate project accounting flexfield structures and organization parameters.

The package is classified as an OTHER API and is documented as VALID in ETRM 12.2.2. It is a heavily depended-upon object: it is referenced by 64 other packages, indicating that it serves as foundational infrastructure for project-related inventory processing rather than an end-user-facing interface. It is not itself referenced by any database object, confirming its role as a top-level utility package.

Key Procedures and Functions

The package exposes 27 documented procedures and functions, several of which are public entry points and others internal helpers. The principal public routines include:

Supporting routines such as ORG_PROJECT_PARAMETERS and the remaining helpers complement this set and are invoked internally to enforce consistent validation.

Tables Accessed

The package reads and writes a documented set of base tables through APPS synonyms. These include MTL_ITEM_LOCATIONS, MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_ONHAND_QUANTITIES_DETAIL, MTL_PARAMETERS, MTL_TRANSACTIONS_INTERFACE, MTL_TXN_REQUEST_LINES, PO_REQ_DISTRIBUTIONS_ALL, RCV_TRANSACTIONS, and WMS_LICENSE_PLATE_NUMBERS. It also references flexfield definition tables FND_FLEX_VALUE_SETS, FND_ID_FLEX_SEGMENTS, and FND_ID_FLEX_STRUCTURES to validate project accounting segments. Project and task views referenced include MTL_PROJECT_V, MTL_TASK_V, PJM_PROJECTS_ALL_V, PJM_TASKS_V, and PA_ORGANIZATIONS_EXPEND_V, along with ORG_ORGANIZATION_DEFINITIONS and PJM_PROJECT_LOCATOR.

Usage Notes

INV_PROJECT is typically invoked indirectly through Inventory forms, move order and requisition processing, receiving flows, and concurrent programs that need to default or validate project and task references. Custom code should call the documented public routines rather than accessing the underlying tables directly, preserving the validation and session-context behavior established by SET_SESSION_PARAMETERS and SET_ORG_CLIENT_INFO.