Search Results import_recomended_quantities

Overview

CSP_ASL_PUB is a public API package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the CSP (Service Procurement / Complex Maintenance, Repair and Overhaul) product family and is classified as a public (PUB) interface, indicating that its procedures are intended for external invocation by other application modules, concurrent programs, or custom extensions rather than being restricted to internal use. From a functional standpoint, the package supports the management of recommended spare parts quantities and the lifecycle maintenance of recommendation records generated by Oracle's service supply chain and spare parts planning processes.

The package relies on the FND_API foundation package and the SYS.STANDARD package, confirming that it follows Oracle's standard API conventions, including the use of standardized return status and message handling mechanisms. Its status is recorded as VALID in the ETRM metadata for 12.2.2, meaning it compiles cleanly and its dependencies resolve without error.

Key Procedures and Functions

The ETRM documentation identifies two documented program units within CSP_ASL_PUB:

• IMPORT_RECOMENDED_QUANTITIES — Loads recommended spare part quantities into the CSP recommendation repository. This procedure is the inbound mechanism by which externally computed or externally supplied recommended quantity data is validated and persisted for downstream consumption by service procurement and spare parts planning logic.
• PURGE_OLD_RECOMMENDATIONS — Removes obsolete or superseded recommendation records from the recommendation tables. This procedure supports data lifecycle hygiene, preventing stale recommendations from accumulating and being erroneously consumed by replenishment or sourcing processes.

Both units are public API entry points. No parameter lists are documented in the ETRM metadata, and none should be assumed; refer to the live package specification in the target instance for exact signatures.

Tables Accessed

The package accesses the following tables through APPS synonyms:

• CSP_USAGE_HEADERS — The primary header table for usage/recommendation data. The package reads and writes here to persist imported recommended quantities and to identify records eligible for purge.
• CSP_USAGE_HEADERS_S1 — A secondary or interface/staging structure associated with CSP_USAGE_HEADERS, used in the import and purge processing paths.
• HR_ALL_ORGANIZATION_UNITS — Supplies organizational context, ensuring recommendations are scoped to the correct inventory organization or business unit.
• MTL_PARAMETERS — Provides inventory organization parameters, used to validate that the target organization is a valid inventory master organization before import or purge operations proceed.
• DUAL — Used for standard single-row SQL evaluation within the package logic.

Usage Notes

CSP_ASL_PUB is typically invoked from concurrent programs, from Oracle Forms-based service procurement flows, or from custom PL/SQL that needs to programmatically load or clean up recommended quantities. Because it is designated PUB and is referenced by no other packages in the documented dependency set, it functions as a top-level integration point rather than an internal helper. Callers should invoke IMPORT_RECOMENDED_QUANTITIES when an external planning engine, legacy system, or spreadsheet-based upload produces recommended spare part quantities, and schedule PURGE_OLD_RECOMMENDATIONS periodically to retire stale recommendation data. As with all FND_API-based public APIs, commit and rollback behavior should be managed by the calling program, and the API's return status must be checked to confirm success before committing.