Search Results conc_request




Overview
Explore in AI Chat

Overview

APPS.CST_PL_IMPORT is an Oracle E-Business Suite cost management package that supports the import and validation of cost data into the Costing application. Its name reflects its role as the import handler for cost lists (price lists) that are subsequently used in cost rollups and item cost calculations. In the ETRM 12.2.2 classification the package is registered as an "OTHER" API, indicating that it is an internal component rather than a formally published open interface. The header comment in the source (120.3, dated 2006) shows the package has been stable across the 11i and R12 code lines and is present in both 12.1.1 and 12.2.2 environments.

The principal entry point, START_PROCESS, is a concurrent-program style driver. It accepts a large set of parameters that describe the selection of items and categories to process, the price effective date, rollup basis, quantity-price multiplier, conversion type and date, and default material sub-element. This signature confirms that the procedure is intended to be launched from a concurrent program definition rather than called interactively.

Key Procedures and Functions

  • START_PROCESS — The main processing procedure. It exposes OUT parameters for the concurrent manager's error buffer and return code, and IN parameters that control item range (all items, a specific item, or a category), category set and structure, organization, effective date, rollup basis, QP multiplier, conversion attributes, and material sub-element defaults. Internally it prepares QP_PREQ_GRP record and table types (line, qualifier, attribute, detail and related-line collections) and passes them to the pricing engine to resolve price list lines before writing cost detail interface rows.
  • GET_GROUP_ID — A helper function that returns the group identifier associated with the current import run. It allows callers and downstream routines to correlate the rows inserted by START_PROCESS with a single logical batch.

Tables Accessed

  • CST_ITEM_CST_DTLS_INTERFACE — the primary target of the import; item cost detail rows are staged here for the cost processor.
  • CST_LISTS_S — the cost list (price list) header source that defines which list is being imported.
  • FND_CONCURRENT_REQUESTS — queried to establish the concurrent request context, request id and group association for the run.
  • MTL_ITEM_CATEGORIES and MTL_SYSTEM_ITEMS_B — used to resolve item and category selections when the range parameter indicates all items, a specific item, or a category.
  • MTL_PARAMETERS — supplies organization-level costing parameters such as the default material sub-element.
  • QP_LIST_LINES and QP_PRICING_ATTRIBUTES — the pricing structures read to obtain list line prices and qualifiers applied during import.
  • DUAL — used for scalar lookups and status checks.

Usage Notes

The user's search term "conc_request" aligns with the package's design: START_PROCESS is built for invocation from a concurrent program. The parameters ERRBUF and RETCODE follow the standard concurrent program convention, and the FND_CONCURRENT_REQUESTS reference confirms that the request context is read at runtime. In practice the package is triggered by the cost list import concurrent program within the Cost Management responsibility, or may be called from custom code that replicates the same parameter list. Because the API is classified as OTHER and is not a published open interface, direct calls should be treated as version-sensitive; signature or behaviour changes between 12.1.1 and 12.2.2 are possible, and the package is referenced by no other packages, so it sits at a leaf of the dependency tree.