Search Results get_plan_name

Overview

CSD_REPAIR_TASK_UTIL is a utility PL/SQL package owned by the APPS schema and classified as a UTIL (utility) API within Oracle E-Business Suite. Its documented source header identifies an origin in the Depot Repair module family (csdvrtus.pls, version 120.1, dated 2005/08/09), and it operates against the Quality Management data model. The package provides shared helper logic for the Depot Repair repair-task and quality-collection workflows, specifically the conversion of delimited strings into numeric identifier arrays and the translation of quality plan identifiers into their display names. Rather than exposing business transactions, it centralizes low-level data manipulation that other Depot Repair forms and programs call when they need to resolve plan references or unpack concatenated collection identifiers. The declared package global g_txn_number (initialized to 2005) and the number_array_type associative array type indicate the utility was designed for internal ID-array processing rather than as a public integration API.

Key Procedures and Functions

The package documents three program units:

• STRING_TO_ARRAY — A procedure that parses a delimited input string and populates a numeric array of identifiers. Its IN OUT NOCOPY string parameter and OUT NOCOPY numeric array are designed so that callers can pass a concatenated list of IDs and receive the exploded, individually usable values.
• GET_PLAN_NAME — A function that accepts a plan ID and returns the corresponding plan name as a VARCHAR2. This is the unit most relevant to the search term "get_plan_name"; it is the documented mechanism for resolving a stored quality plan identifier to its user-facing name without requiring the caller to query QA_PLANS directly.
• GET_PLANIDS_FOR_CIDS — A procedure that accepts an array of local collection IDs and returns every plan ID for which data was collected against those collection IDs. The documented comment confirms it returns all such plan IDs, making it the bridge between collected quality results and their parent plans.

No parameter lists beyond those shown in the source excerpt are documented, and none are inferred here.

Tables Accessed

The package references three tables through APPS synonyms:

• QA_PLANS — The quality plan definition table, read to resolve a plan ID to its name in GET_PLAN_NAME and to validate plan references returned by GET_PLANIDS_FOR_CIDS.
• QA_RESULTS — The quality results/collection table, used to associate collection IDs with the plan IDs under which results were gathered.
• PLITBLM — The standard Oracle EBS PL/SQL table-to-array conversion helper, used to bridge SQL result sets into the package's numeric associative arrays.

Usage Notes

CSD_REPAIR_TASK_UTIL is a UTIL-class package with no downstream package dependencies (referenced by 0 other packages), so it is invoked directly by Depot Repair forms, concurrent programs, or custom extensions rather than being wrapped by a higher-level API. Typical invocation occurs when a Depot Repair screen must display the quality plan name for a selected repair task or when a program needs to unpack a concatenated collection-ID string before processing results. Custom code may call GET_PLAN_NAME independently to resolve plan names, but such use should treat the package as unsupported by Oracle's public API surface. The package is compatible with both EBS 12.1.1 and 12.2.2, with no documented online-patching considerations beyond standard file version tracking.