Search Results insert_ccientry

Overview

APPS.MTL_CCEOI_PROCESS_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Inventory module that supports the Cycle Count Entries Open Interface (CCEOI) processing flow. Its principal responsibility is to validate and process records staged in the cycle count interface tables, calculating adjustments and moving validated data into the application tables that drive cycle count entry and adjustment transactions. The package is declared with AUTHID CURRENT_USER and its header, dated June 2005 (INVVCCPS.pls 120.2), reflects an implementation compliant with the Oracle GSCC File.Sql.39 coding standard (Bug:4410902). As a private package it is intended for internal use by the Inventory cycle count programs rather than as a public integration API.

Key Procedures and Functions

The package exposes twenty documented procedures that collectively perform validation, adjustment calculation, and interface data movement:

• CALCULATE_ADJUSTMENT – Calculates the adjustments required for Step 4 of cycle count processing, accepting item, organization, LPN, subinventory, count quantity, revision, locator, lot, and serial information, along with system quantity values.
• VALIDATE_CHEADER, VALIDATE_COUNTLISTSEQ, VALIDATE_ITEMSKU, VALIDATE_UOMQUANTITY, VALIDATE_CDATE_COUNTER, VALIDATE_SECONDARYUOMQTY – A set of validation routines that confirm the cycle count header, count list sequence, item SKU, unit of measure quantity, count date/counter, and secondary UOM quantity before records are accepted.
• INSERT_CCENTRY, INSERT_CCIENTRY, INSERT_CCEOIERROR – Insert records into the application cycle count tables, the interface table, and the interface error table respectively. INSERT_CCIEntry carries the added NOCOPY hint on its x_return_status OUT parameter.
• UPDATE_CCENTRY, UPDATE_CCIEntry – Update existing entries in the cycle count and interface tables.
• DELETE_CCIEntry, DELETE_CCEOIERROR, DELETE_RESERVATION – Remove processed or erroneous interface rows and release associated reservations.
• SET_CCEXPORT, SET_CCEOIFLAGS – Manage export and processing flags associated with cycle count interface records.
• PROCESS_DATA – Orchestrates the overall processing of interface data through validation and insertion.
• CHECK_SERIAL_LOCATION, RESET_GLOBAL_VARS – Verify serial number locations and reset package-level global variables between processing runs.

Tables Accessed

The package reads and writes several cycle count and inventory tables via APPS synonyms. Interface staging tables include MTL_CC_ENTRIES_INTERFACE (and its sequence MTL_CC_ENTRIES_INTERFACE_S) and MTL_CC_INTERFACE_ERRORS (with MTL_CC_INTERFACE_ERRORS_S). Core cycle count records reside in MTL_CYCLE_COUNT_ENTRIES (and sequence MTL_CYCLE_COUNT_ENTRIES_S), MTL_CYCLE_COUNT_HEADERS, MTL_CYCLE_COUNT_ITEMS, and MTL_CYCLE_COUNT_CLASSES. Supporting master data is drawn from MTL_ITEM_LOCATIONS, MTL_LOT_NUMBERS, MTL_PARAMETERS, MTL_MATERIAL_TRANSACTIONS_S, MRP_PROJECT_PARAMETERS, and BOM_STANDARD_OPERATIONS. These tables supply item, locator, lot, organization parameter, and transaction context needed for validation and adjustment calculations.

Usage Notes

MTL_CCEOI_PROCESS_PVT is referenced by three other packages and is invoked internally during cycle count entry open interface processing, typically initiated from the Inventory cycle count forms and the associated concurrent programs that load and process staged interface records. Because it is classified as a private API, direct calls from custom code are not recommended; integrations should instead use the supported public cycle count interfaces that ultimately delegate to this package. The AUTHID CURRENT_USER declaration and NOCOPY OUT parameters reflect an implementation optimized for performance and standards compliance rather than for external API stability.