Search Results rcv_inspection_grp
Overview
The APPS.RCV_INSPECTION_GRP package body is a receiving-side PL/SQL API in Oracle E-Business Suite that supports the inspection and disposition processing of received goods. In the Oracle Receiving module, receipts frequently require an inspection step before they can be accepted into inventory or routed onward. RCV_INSPECTION_GRP provides the programmatic plumbing that records inspection outcomes and drives the resulting receiving transactions, translating a quality or receiving decision into the appropriate entries in the receiving transaction interface and transaction tables. The package is classified as a GRP (group) API, indicating that it aggregates related logic and delegates to lower-level APIs such as FND_API, RCV_TRX_INTERFACE_INSERT_PKG, and related receiving packages rather than exposing a single self-contained interface. It resides in the APPS schema and is marked VALID as of the documented ETRM 12.2.2 metadata, with dependencies consistent with the 12.1.1 release as well.
Key Procedures and Functions
The documented metadata identifies a single entry point, INSERT_INSPECTION, which is the primary procedure exposed by this package.
- INSERT_INSPECTION — The core procedure responsible for creating the inspection record and initiating the associated receiving transaction flow. It accepts the receiving context (such as shipment header and line information) along with inspection details through formal parameters, and orchestrates the downstream writes. Because the metadata does not enumerate the parameter list, the exact signature is not reproduced here; the procedure is intended to apply the inspection result and persist the corresponding transaction.
Although only one procedure is documented, the group nature of the package implies supporting internal logic that prepares interface rows and invokes the transaction interface insertion package. Only INSERT_INSPECTION should be treated as a published interface.
Tables Accessed
The package reads and writes a documented set of receiving, purchasing, and inventory tables, summarized below:
- RCV_SHIPMENT_HEADERS / RCV_SHIPMENT_LINES — provide the receipt and shipment context within which the inspection occurs.
- RCV_TRANSACTIONS / RCV_TRANSACTIONS_INTERFACE — capture the resulting receiving transaction, with the interface table acting as the staging point consumed by the receiving transaction processor.
- RCV_SUPPLY — supplies availability and sourcing information used during disposition.
- PO_LINES_ALL / PO_LINE_LOCATIONS_ALL / PO_REQUISITION_HEADERS_ALL — supply purchasing document, line, and shipment context linked to the receipt.
- MTL_SYSTEM_ITEMS / MTL_CUSTOMER_ITEMS — resolve item attributes and customer-item relationships relevant to the inspected goods.
- OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL — support sales-order-linked receiving and inspection scenarios.
Usage Notes
RCV_INSPECTION_GRP is an internal receiving API rather than a directly invoked user interface. It is typically called from the Receiving forms and concurrent programs that manage inspection and disposition, and it is referenced by three other database packages, indicating it participates in a broader receiving API call chain. Custom code should invoke INSERT_INSPECTION only within a properly initialized EBS API context (FND global initialization), as it relies on FND_API and FND_MSG_PUB for error handling and message publication. Given that the package is not referenced by external database objects and its interface is not formally published, developers should prefer higher-level receiving APIs and treat this package as a supporting implementation detail. Any modifications should be validated against both 12.1.1 and 12.2.2, where the documented dependencies remain consistent.
-
PACKAGE BODY: APPS.RCV_INSPECTION_GRP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:RCV_INSPECTION_GRP, status:VALID,
-
PACKAGE: APPS.RCV_INSPECTION_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:RCV_INSPECTION_GRP, status:VALID,
-
PACKAGE: APPS.RCV_INSPECTION_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:RCV_INSPECTION_GRP, status:VALID,
-
PACKAGE BODY: APPS.RCV_INSPECTION_GRP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:RCV_INSPECTION_GRP, status:VALID,
-
PACKAGE: APPS.RCV_TRX_INTERFACE_INSERT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:RCV_TRX_INTERFACE_INSERT_PKG, status:VALID,
-
PACKAGE: APPS.RCV_TRX_INTERFACE_INSERT_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:RCV_TRX_INTERFACE_INSERT_PKG, status:VALID,
-
PACKAGE BODY: APPS.QA_SKIPLOT_RES_ENGINE
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SKIPLOT_RES_ENGINE, status:VALID,
-
PACKAGE BODY: APPS.QA_SAMPLING_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SAMPLING_PKG, status:VALID,
-
PACKAGE BODY: APPS.QA_SKIPLOT_RES_ENGINE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SKIPLOT_RES_ENGINE, status:VALID,
-
PACKAGE BODY: APPS.QA_SAMPLING_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SAMPLING_PKG, status:VALID,
-
SYNONYM: APPS.RCV_SUPPLY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_SUPPLY, status:VALID,
-
SYNONYM: APPS.RCV_SUPPLY
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_SUPPLY, status:VALID,
-
PACKAGE BODY: APPS.QLTDACTB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QLTDACTB, status:VALID,
-
PACKAGE BODY: APPS.QLTDACTB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QLTDACTB, status:VALID,
-
PACKAGE: APPS.PO_UOM_S
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_UOM_S, status:VALID,
-
SYNONYM: APPS.MTL_CUSTOMER_ITEMS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:MTL_CUSTOMER_ITEMS, status:VALID,
-
PACKAGE: APPS.PO_UOM_S
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_UOM_S, status:VALID,
-
SYNONYM: APPS.MTL_CUSTOMER_ITEMS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:MTL_CUSTOMER_ITEMS, status:VALID,
-
PACKAGE: APPS.RCV_INSPECTION_GRP
12.1.1
-
PACKAGE: APPS.RCV_INSPECTION_GRP
12.2.2
-
PACKAGE BODY: APPS.RCV_INSPECTION_GRP
12.2.2
-
PACKAGE BODY: APPS.RCV_INSPECTION_GRP
12.1.1
-
SYNONYM: APPS.PO_REQUISITION_HEADERS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_REQUISITION_HEADERS_ALL, status:VALID,
-
SYNONYM: APPS.RCV_TRANSACTIONS_INTERFACE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_TRANSACTIONS_INTERFACE, status:VALID,
-
SYNONYM: APPS.PO_REQUISITION_HEADERS_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_REQUISITION_HEADERS_ALL, status:VALID,
-
SYNONYM: APPS.RCV_TRANSACTIONS_INTERFACE
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_TRANSACTIONS_INTERFACE, status:VALID,
-
SYNONYM: APPS.RCV_SHIPMENT_HEADERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_SHIPMENT_HEADERS, status:VALID,
-
SYNONYM: APPS.RCV_SHIPMENT_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_SHIPMENT_LINES, status:VALID,
-
SYNONYM: APPS.RCV_SHIPMENT_HEADERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_SHIPMENT_HEADERS, status:VALID,
-
SYNONYM: APPS.RCV_SHIPMENT_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_SHIPMENT_LINES, status:VALID,
-
APPS.QA_SAMPLING_PKG dependencies on RCV_INSPECTION_GRP
12.1.1
-
APPS.QA_SKIPLOT_RES_ENGINE dependencies on RCV_INSPECTION_GRP
12.2.2
-
APPS.RCV_INSPECTION_GRP dependencies on RCV_INSPECTION_GRP
12.1.1
-
APPS.QLTDACTB dependencies on RCV_INSPECTION_GRP
12.2.2
-
APPS.QA_SKIPLOT_RES_ENGINE dependencies on RCV_INSPECTION_GRP
12.1.1
-
APPS.QLTDACTB dependencies on RCV_INSPECTION_GRP
12.1.1
-
APPS.RCV_INSPECTION_GRP dependencies on RCV_INSPECTION_GRP
12.2.2
-
APPS.QA_SAMPLING_PKG dependencies on RCV_INSPECTION_GRP
12.2.2
-
SYNONYM: APPS.RCV_TRANSACTIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_TRANSACTIONS, status:VALID,
-
SYNONYM: APPS.RCV_TRANSACTIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_TRANSACTIONS, status:VALID,
-
SYNONYM: APPS.OE_ORDER_HEADERS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_ORDER_HEADERS_ALL, status:VALID,
-
SYNONYM: APPS.PO_LINE_LOCATIONS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_LINE_LOCATIONS_ALL, status:VALID,
-
SYNONYM: APPS.PO_LINES_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_LINES_ALL, status:VALID,
-
SYNONYM: APPS.PO_LINE_LOCATIONS_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_LINE_LOCATIONS_ALL, status:VALID,
-
SYNONYM: APPS.OE_ORDER_HEADERS_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_ORDER_HEADERS_ALL, status:VALID,
-
SYNONYM: APPS.PO_LINES_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_LINES_ALL, status:VALID,
-
SYNONYM: APPS.OE_ORDER_LINES_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_ORDER_LINES_ALL, status:VALID,
-
SYNONYM: APPS.OE_ORDER_LINES_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_ORDER_LINES_ALL, status:VALID,
-
SYNONYM: APPS.MTL_SYSTEM_ITEMS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:MTL_SYSTEM_ITEMS, status:VALID,
-
SYNONYM: APPS.MTL_SYSTEM_ITEMS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:MTL_SYSTEM_ITEMS, status:VALID,