Search Results purge_old_recommendations

Overview

APPS.CSP_ASL_PUB is a public API package body in Oracle E-Business Suite that supports the management of recommended inventory stocking levels within the Advanced Supply Chain Planning (ASCP) and inventory optimization flow. Its source file is identified internally as cspgrecb.pls (version 115.8), and the package is classified as PUB, indicating it is intended to be callable from external code rather than being restricted to internal use. The package provides a programmatic entry point for loading recommended minimum and maximum stocking quantities against a specific inventory item and organization combination, replacing or supplementing manual maintenance of those values.

The package operates in the context of the CSP schema family, whose tables store usage history and recommendation data consumed by planning engines. Behavioral expectations follow the standard EBS PL/SQL API conventions: a version number argument, a message list initialization flag, a commit flag, and a validation level, together with OUT parameters for return status, message count, and message data.

Key Procedures and Functions

The ETRM metadata documents two procedures on this package.

• IMPORT_RECOMENDED_QUANTITIES — The principal procedure of the package. It accepts an item identifier along with up to twenty item segment values, an organization identifier plus organization name and code, a subinventory code, and recommended maximum and minimum quantities. It returns the standard API status indicators. Internally it resolves the organization through two explicit cursors against MTL_PARAMETERS (by organization code) and HR_ALL_ORGANIZATION_UNITS (by organization name), and it defines a cursor named get_delimiter that retrieves the concatenated segment delimiter from the FND_ID_F flexible-format definition. This delimiter cursor is the object most often sought by developers researching this package, because the delimiter is required to correctly parse or assemble the concatenated item key when segment values are not passed individually.
• PURGE_OLD_RECOMMENDATIONS — A maintenance procedure that removes obsolete recommendation records, allowing the recommendation tables to be pruned of stale entries rather than accumulating indefinitely.

Note that the procedure name is spelled IMPORT_RECOMENDED_QUANTITIES with a single "m" in "recomended"; this spelling is fixed in the shipped code and must be matched exactly by any calling program.

Tables Accessed

• CSP_USAGE_HEADERS and CSP_USAGE_HEADERS_S1 — the usage history tables that underpin recommendations. The package reads and writes recommendation-related data here and uses the _S1 index during purge and lookup activity.
• MTL_PARAMETERS — queried through the csp_inv_org_code cursor to translate an organization code into an ORGANIZATION_ID.
• HR_ALL_ORGANIZATION_UNITS — queried through the csp_inv_org_name cursor to translate an organization name into an ORGANIZATION_ID.
• FND_ID_F — read by the get_delimiter cursor to obtain CONCATENATED_SEGMENT_DELIMITER.
• DUAL — referenced for scalar and utility queries.

Usage Notes

The package is normally invoked programmatically rather than from a standard form. Typical callers include concurrent programs and custom PL/SQL that load planning recommendations in bulk, pass FND_API.G_FALSE for the commit flag while iterating, and issue a single commit at the end. Because the metadata records no dependent packages referencing it, callers should treat it as a leaf-level API and supply their own error handling around the returned status and message data. When calling IMPORT_RECOMENDED_QUANTITIES, developers commonly query FND_ID_F directly to obtain the segment delimiter so that concatenated item keys can be split consistently with the package's own parsing logic.