Search Results manage_dlv

Overview

OKE_AMG_GRP is a PL/SQL package in the APPS schema that belongs to the Oracle E-Business Suite Project Contracts (OKE) module, specifically the deliverables and shipping integration area. Its API classification is GRP, categorizing it as a group or wrapper package whose procedures orchestrate lower-level APIs rather than performing atomic data manipulation directly. The package is documented as being referenced by four other packages, indicating it sits in the middle tier of the OKE deliverable management call stack.

The business function of OK_AMG_GRP is to manage deliverable actions — the operational steps through which a project deliverable moves toward fulfillment. The package declares rich PL/SQL record types that model the data required to plan, ship, and procure deliverables: dlv_rec_type captures deliverable identity, item, inventory organization, quantity, unit of measure, price, and project context; dlv_ship_action_rec_type captures shipping attributes such as ship-from and ship-to organizations and locations, inspection requirements, promised and expected shipment dates, volume and weight measures, and readiness flags; and dlv_req_action_rec_type captures requisition-oriented attributes including vendor and vendor site, need-by date, expenditure type and organization, category, and requisition line type.

Key Procedures and Functions

The package exposes three documented procedures, all serving the deliverable action lifecycle:

• MANAGE_DLV — The entry point for processing a deliverable. It accepts an API version and initialization message parameters and performs the core deliverable maintenance operation against the OKE deliverable entities.
• MANAGE_DLV_ACTION — Manages an individual deliverable action, invoking the appropriate lower-level logic driven by the record structure passed in (shipping or requisition oriented). This is the procedure that translates the dlv_ship_action_rec_type and dlv_req_action_rec_type structures into actual action records.
• INITIATE_DLV_ACTION — Initiates a deliverable action, effectively kicking off planning, shipping, or procurement for a deliverable. This aligns with the initiate_planning_flag, initiate_shipping_flag, and initiate_procure_flag attributes present in the record types.

The exact parameter signatures beyond the documented p_api_version and p_init_msg inputs are not enumerated in the available metadata, and no parameter lists are inferred here.

Tables Accessed

The package reads and writes a defined set of tables via APPS synonyms. The OKE deliverable tables — OKE_DELIVERABLES_B, OKE_DELIVERABLES_TL, OKE_DELIVERABLE_ACTIONS, and OKE_K_DELIVERABLES_S — hold the primary deliverable and action data. PA_PROJECTS_ALL supplies project context. Procurement and inventory integration is supported by MTL_CATEGORIES_B, MTL_PARAMETERS, MTL_UNITS_OF_MEASURE, and PO_LINE_TYPES. Currency conversion uses FND_CURRENCIES and GL_DAILY_CONVERSION_TYPES. Shipping parameters come from WSH_SHIPPING_PARAMETERS, and DUAL is used for single-row lookups or validation.

Usage Notes

OKE_AMG_GRP is normally invoked from the OKE Deliverables and Shipping user interface in the Project Contracts module, and from concurrent programs that plan or release deliverable shipments. Because it is a GRP classification package, custom code should generally prefer calling it rather than the underlying APIs, since it encapsulates the sequencing of deliverable, action, and integration logic. The header revision (120.1, dated 2005) indicates the package has been stable across 12.1.1 and 12.2.2 releases.