Search Results csp_planning_utils_pkg




Overview
Explore in AI Chat

Overview

The APPS.CSP_PLANNING_UTILS_PKG package body is a utility package within the Oracle E-Business Suite component commonly associated with CSP (returned goods / RMA-linked planning). Its documented role is to centralize helper logic that supports concurrent request submission and the resolution of run-function URLs and messages for planning-related activities. In release 12.1.1 and 12.2.2 the package is compiled in the APPS schema and carries a VALID status, indicating it is available for use by dependent forms, concurrent programs, and other PL/SQL units.

The package is classified as OTHER API, meaning it is not an Open Interface or public integration API; it is intended primarily for internal application use rather than for external callers. The dependency metadata confirms that it reads configuration and reference data from planning parameters and from standard Oracle Application Object Library (FND) tables, and that it may issue concurrent requests and resolve application messages on behalf of the calling form or program.

Key Procedures and Functions

ETRM documentation records four callable units in this package body. Parameter lists are not published and are not reproduced here.

  • SUBMIT_CONC_REQUEST — Submits a concurrent request programmatically on behalf of the caller. It depends on FND_REQUEST, which is the standard mechanism for queuing concurrent programs. This routine is typically used when a planning action must launch a background process rather than run interactively.
  • GET_RUN_FUNCTION_URL — Returns a URL for a run-function (a form function configured in FND_FORM_FUNCTIONS). This supports navigation from a planning form to another EBS form or function using the standard run-function URL construct.
  • GET_MESSAGE — Retrieves a message text using FND_MESSAGE. This provides localized, application-standard message retrieval for validation and error reporting in planning utilities.
  • SET_CONTEXT — Establishes the FND_GLOBAL session context (application, responsibility, user) required before dependent utility calls, ensuring the correct security and language environment.

Tables Accessed

The package references the following objects through APPS synonyms:

  • CSP_PLANNING_PARAMETERS — Planning configuration parameters used to drive utility behavior.
  • FND_FORM_FUNCTIONS — Form function definitions resolved by GET_RUN_FUNCTION_URL.
  • FND_LANGUAGES and FND_RESPONSIBILITY_TL — Language and translated responsibility data supporting message and URL resolution.
  • FND_USER — User information used during context setup.
  • DUAL — Used for single-row PL/SQL and SQL expressions.

It also invokes the FND_GLOBAL, FND_MESSAGE, FND_REQUEST, and FND_RUN_FUNCTION packages, and references SYS.STANDARD.

Usage Notes

CSP_PLANNING_UTILS_PKG is not referenced by any other database object, so its callers are forms and concurrent programs rather than other PL/SQL packages. It is typically invoked when a planning form needs to launch a concurrent program, build a run-function navigation URL, fetch a translated message, or initialize the FND context. Because it is classified as OTHER API, customizations should call it cautiously and expect no stability guarantee across patches. Always invoke SET_CONTEXT before dependent routines so that FND_GLOBAL-based responsibilities, users, and languages resolve correctly.