Search Results cst_pl_import




Overview
Explore in AI Chat

Overview

CST_PL_IMPORT is a PL/SQL package owned by the APPS schema that supports the import of price list and cost detail information into Oracle E-Business Suite. Its name and its dependency footprint indicate that it functions as a batch-oriented loader for item cost and price list data that originates outside the standard costing and pricing flows. The package bridges Oracle Advanced Pricing structures (QP_LIST_LINES, QP_PRICING_ATTRIBUTES) with Oracle Cost Management interfaces (CST_ITEM_CST_DTLS_INTERFACE, CST_LISTS_S), allowing externally sourced price list lines to be validated and staged before they are consumed by the cost processor. It is classified in the ETRM repository as an "OTHER" API rather than a formally published public interface, which means it is intended primarily for internal or controlled use by Oracle concurrent programs rather than for unrestricted third-party invocation. The package is a VALID object in the APPS schema and depends only on the standard SYS.STANDARD package and a set of APPS synonyms, and it is not referenced by any other package, confirming that it sits near the top of its own call hierarchy.

Key Procedures and Functions

  • START_PROCESS — The principal entry point for the import run. It initiates processing of the pending price list or cost detail records, coordinating the validation and staging logic against the interface tables. This is the routine a concurrent program or calling session would invoke to begin an import execution.
  • GET_GROUP_ID — Returns the group identifier associated with the current or requested import run. The group ID ties a batch of interface rows to a specific processing instance, allowing the loader to isolate records belonging to one submission from other concurrent or historical runs. This is consistent with the standard EBS pattern of grouping interface records for controlled, restartable batch processing.

No parameter lists are documented in the source metadata, and none are asserted here.

Tables Accessed

  • CST_ITEM_CST_DTLS_INTERFACE — The cost detail interface table that receives imported item cost records prior to validation and transfer.
  • CST_LISTS_S — The cost list definition table, used to resolve or create the price/cost list to which imported lines belong.
  • QP_LIST_LINES and QP_PRICING_ATTRIBUTES — Oracle Advanced Pricing tables holding price list lines and their attribute values, supplying or receiving the pricing content of the import.
  • MTL_SYSTEM_ITEMS_B, MTL_ITEM_CATEGORIES, and MTL_PARAMETERS — Inventory master and setup tables used to validate items, resolve category assignments, and read organization-level inventory parameters.
  • FND_CONCURRENT_REQUESTS — Used to correlate the run with its concurrent request, supporting the group ID mechanism and status reporting.
  • DUAL — Used for scalar evaluations and control-flow queries.

Usage Notes

CST_PL_IMPORT is characteristically invoked by a concurrent program rather than from a form. The presence of START_PROCESS and GET_GROUP_ID, together with the reference to FND_CONCURRENT_REQUESTS, matches the standard EBS interface-loader pattern in which a concurrent manager submission triggers processing of rows grouped by a run identifier. In Oracle EBS 12.1.1 and 12.2.2 the package behaves identically from a database perspective, with 12.2's online patching merely affecting when the APPS edition is active. Because the package is classified as OTHER and is referenced by no other package, customizations should call it cautiously and only within the supported concurrent program framework; direct calls bypass validation and error handling that the standard submission performs. Organizations importing price list or cost data through supported channels should prefer the delivered concurrent program that wraps this package, reserving direct invocation for diagnostic or controlled migration scenarios where the group ID lifecycle is fully managed by the caller.