Search Results mfg_partnum_status_check

Overview

APPS.CLN_SYNC_ITEM_PKG is a PL/SQL package owned by the APPS schema that supports item synchronization and cost interface processing within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package is classified under the ETRM as an "OTHER" API type, indicating that it is not a formally published public API but rather an internal processing unit used by Oracle's item and costing synchronization flows. Its name and dependencies suggest it plays a role in synchronizing item master and item cost information between EBS and external or downstream systems, including collaborative planning and cost collection interfaces.

The package is marked VALID in the ETRM and is documented with thirteen procedures and functions. It references SYS.STANDARD and demonstrates a self-referential dependency, meaning some of its own subprograms call one another. No other APPS packages are documented as referencing it, so its invocation is typically driven by concurrent programs, forms, or Oracle's internal synchronization logic rather than by third-party PL/SQL callers.

Key Procedures and Functions

The documented subprograms cover three broad areas: transaction control, event and message handling, and item status validation.

• SET_SAVEPOINT_SYNC_RN — Establishes a savepoint used by the synchronization routine, enabling partial rollback of work performed during a sync cycle.
• ROLLBACK_CHANGES_RN — Rolls back changes to the savepoint set earlier, typically invoked when validation or processing fails.
• CATGRY_RESOL_RN — Resolves item category information, likely mapping source categories to the target category hierarchy.
• RAISE_UPDATE_EVENT — Raises a business event signifying that an item update occurred, supporting event-driven integration.
• RAISE_ADD_MSG_EVENT — Raises an event to publish an add or message notification.
• INSERT_DATA — Performs the core insertion of synchronized item data into the relevant interface or staging tables.
• ERROR_HANDLER — Centralized error handling routine that logs or propagates errors during processing.
• XGM_CHECK_STATUS — Checks processing status, likely against a cross-group or interface control record.
• ITEM_IMPORT_STATUS_HANDLER — Manages the item import status, updating records as items move through the import lifecycle.
• SETUP_CST_INTERFACE_TABLE — Prepares the costing interface table for population.
• UPDATE_COLLB_STATUS — Updates collaboration status on the synchronized items.
• MFG_PARTNUM_STATUS_CHECK — Validates manufacturer part number status before processing.
• UPDATE_COLLB_STATUS_RN — The routine variant of collaboration status update, called by the main flow.

Tables Accessed

The package reads and writes a mix of item, costing, and collaboration tables through APPS synonyms:

• CLN_SYNCITEM_S, CLN_GENERIC_S, CLN_CST_DTLS_TEMP — Collaboration staging and temporary tables holding synchronized item and cost detail data.
• CST_ITEM_CST_DTLS_INTERFACE, CST_LISTS_S — Costing interface tables where item cost details are loaded.
• MTL_ITEM_CATEGORIES_INTERFACE, MTL_ITEM_REVISIONS, MTL_ITEM_REVISIONS_INTERFACE, MTL_MANUFACTURERS, MTL_PARAMETERS — Item master supporting tables for category assignment, revisions, manufacturer parts, and organization parameters.
• ECX_DOCLOGS, ECX_TP_HEADERS — EDI/e-commerce document log and trading partner header tables used for event messaging.
• FND_CONCURRENT_REQUESTS, HR_ALL_ORGANIZATION_UNITS, BOM_RESOURCES — Concurrent request tracking, organization unit lookup, and resource definitions.

Usage Notes

Because CLN_SYNC_ITEM_PKG is not referenced by other APPS packages and is not a published API, it is normally invoked by Oracle's internal synchronization concurrent programs or by forms that trigger item and cost synchronization. Custom code should not call these private procedures directly; instead, the standard item import and cost interface concurrent programs should be used. All operations should be executed within a transaction where the savepoint and rollback routines manage atomicity across the staging and interface tables.