Search Results switch_context_back

Overview

CTO_MSUTIL_PUB is a public PL/SQL package owned by APPS within Oracle E-Business Suite. Its source file, CTOMSUTS.pls, is delivered under the Oracle Manufacturing product family and carries a header dated 28-April-2006. The package provides utility modules that support Configure-to-Order (CTO) processing within Oracle Manufacturing. Its stated responsibilities are threefold: populate the temporary staging tables BOM_CTO_ORDER_LINES and BOM_CTO_SRC_ORGS used for intermediate CTO processing; update those tables with the configuration item identifier; and copy sourcing rule assignments from a model item to its corresponding configuration item. A fourth capability, retrieving the master organizations in which configuration items will be enabled, was added in September 2005 as part of the ATG performance fix project for Release 12. The package therefore acts as the orchestration layer between model definition, sourcing rule propagation, and organization enablement during configuration item creation.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions. GET_OTHER_ORGS retrieves the set of organizations relevant to a given model line, returning them through a strongly typed Org_list collection. POPULATE_SRC_ORGS and POPULATE_SRC_ORGS_UPG populate the sourcing organization staging structures; the UPG variant is the upgrade-oriented counterpart that targets the BOM_CTO_ORDER_LINES_UPG staging table. GET_ALL_ITEM_ORGS returns organization information across items, while GET_MASTER_ORGS identifies the master organizations where configuration items are to be enabled.

The INSERT_VAL_INTO_BCSO and INSERT_ALL_INTO_BCSO procedures insert records into the BOM_CTO_SRC_ORGS staging table, supporting single-value and bulk loading respectively. QUERY_SOURCING_ORG_MS queries sourcing organization data for a model. INITIALIZE_ASSIGNMENT_SET prepares the internal assignment set structures used when sourcing rule assignments are transferred, drawing on the MRP_ASSIGNMENT_SETS definition. CREATE_SOURCING_RULES and CREATE_TYPE3_SOURCING_RULES generate the sourcing rules that will be applied to configuration items, with the TYPE3 variant handling the type-3 sourcing rule form. SET_BOM_BATCH_ID establishes the batch identifier used to group staging rows, defaulting to zero as noted in the package globals. SYNCUP_ITEM_MEDIA_INDEX synchronizes item media index data. SWITCH_TO_OE_CONTEXT and SWITCH_CONTEXT_BACK toggle the session context into and out of the Order Entry regime, and RAISE_EVENT_FOR_SEIBEL raises the business event consumed by the Siebel integration. The package also declares the NUMTAB, SOURCING_INFO, and Org_list types used throughout its interfaces.

Tables Accessed

The package reads and writes a defined set of CTO and planning tables through APPS synonyms. BOM_CTO_MODEL_ORGS and its sequence BOM_CTO_MODEL_ORGS_S1 hold the model-to-organization relationships. BOM_CTO_ORDER_LINES and BOM_CTO_ORDER_LINES_UPG serve as the temporary staging tables populated during intermediate CTO processing. BOM_CTO_SRC_ORGS_B stores the sourcing organization results of that staging activity. BOM_PARAMETERS and MTL_PARAMETERS supply manufacturing and item master defaults. FINANCIALS_SYSTEM_PARAMS_ALL provides ledger context. MRP_ASSIGNMENT_SETS, MRP_SOURCING_RULES, MRP_SR_ASSIGNMENTS, MRP_SR_ASSIGNMENTS_S, MRP_SR_RECEIPT_ORG, and MRP_SR_SOURCE_ORG form the sourcing rule model from which assignments are copied. MTL_SYSTEM_ITEMS is the item master consulted for configuration and model item attributes.

Usage Notes

CTO_MSUTIL_PUB is an API-classification public package, referenced by fourteen other packages within the EBS codebase. It is not intended for direct end-user invocation; rather, it is called from CTO-related concurrent programs, configuration item generation flows, and the ATG performance path introduced for Release 12. Custom code that invokes these procedures should follow the collection-based signatures, observe the x_return_status, x_msg_count, and x_msg_data error-handling convention, and avoid direct manipulation of the BOM_CTO_* staging tables, since batch grouping is controlled through SET_BOM_BATCH_ID. The context-switching procedures must be paired so that session state is restored after Order Entry processing completes.