Search Results mtl_cc_entries_interface_s1

Overview

APPS.MTL_CCEOI_ACTION_PUB is a public PL/SQL package body in the Oracle E-Business Suite inventory module that serves as an action-layer API for cycle count entry processing and count request import. The package name incorporates the "CCEOI" prefix, an abbreviation used by Oracle for Cycle Count Entry Open Interface, signalling its role in moving cycle count data between external or staging sources and the core Oracle Inventory tables. It is classified as a public (PUB) API, meaning it is designed to be called by other products, concurrent programs, forms, and custom extensions rather than being an internal helper.

The package delegates substantial processing to its private counterpart MTL_CCEOI_ACTION_PVT and to sibling packages such as MTL_CCEOI_PROCESS_PVT and MTL_CCEOI_VAR_PVT, supporting a layered architecture in which the public body exposes a stable interface while the private packages contain the business rules. The dependency list also shows reliance on the standard Oracle APIs FND_API, FND_MSG_PUB, FND_MESSAGE, FND_PROFILE, FND_FILE, and INV_VALIDATE, confirming compliance with the EBS API programming standards for message handling, error stacking, and profile-driven option retrieval.

Key Procedures and Functions

• IMPORT_COUNTREQUEST — Imports cycle count requests into the Oracle Inventory cycle count interface structures. This procedure is the primary entry point for loading externally sourced count requests (typically from handheld devices, warehouse management systems, or legacy systems) so that they may be validated and processed into the live cycle count schema.
• ACTS — An action dispatcher procedure, consistent with the naming convention used across EBS public APIs, where a single entry point routes a caller-supplied action code to the appropriate internal handler using MTL_CCEOI_ACTION_PVT. Callers invoke ACTS rather than calling individual handlers so that API versioning and message propagation remain consistent.

Both procedures are implemented in the public specification and delegate substantive processing to MTL_CCEOI_ACTION_PVT, MTL_CCEOI_PROCESS_PVT, and MTL_CCEOI_VAR_PVT.

Tables Accessed

• MTL_CC_ENTRIES_INTERFACE — The primary open interface table for cycle count entry records; the package inserts, updates, or reads rows here before validation promotes them into the base tables.
• MTL_CC_ENTRIES_INTERFACE_S1 — The sequence used to generate unique interface identifiers for new rows in MTL_CC_ENTRIES_INTERFACE.
• MTL_CYCLE_COUNT_ENTRIES — Stores the validated count entry lines associated with a cycle count.
• MTL_CYCLE_COUNT_HEADERS — Holds the parent cycle count definition, including scheduling and approval attributes referenced during import.
• MTL_MATERIAL_TRANSACTIONS_S — The transaction sequence used when count adjustments are ultimately written through the material transaction interface.
• WMS_LICENSE_PLATE_NUMBERS — Read when the installation includes Warehouse Management System licensing, allowing LPN-aware count processing.
• DUAL and PLITBLM — Utility references for single-row selection and PL/SQL table operations.

Usage Notes

MTL_CCEOI_ACTION_PUB is invoked in three principal scenarios. First, from EBS cycle count entry forms that submit count data to the interface for validation. Second, from concurrent programs, particularly the Cycle Count Open Interface import program, which loads staged records via IMPORT_COUNTREQUEST. Third, from custom PL/SQL that requires programmatic submission of count requests, where the caller should use ACTS with the appropriate FND_API initialization and message-handling conventions (FND_MSG_PUB.initialize, FND_API.g_return_status, and error stacking). Because the package is classified as a public API but is not referenced by any database object, dependencies flow outward from the package; callers must therefore observe the standard EBS API error-checking protocol. Its dependency on WMS_INSTALL indicates that WMS-aware logic is conditionally executed only where the WMS product is installed.