Search Results detach_string




Overview
Explore in AI Chat

Overview

APPS.CSC_ACTION_ASSEMBLER_PVT is a private (PVT) PL/SQL package body within the Oracle EBS Customer Care / TeleService (CSC) schema. It serves as an internal action-assembly engine that supports the customer plan and service-entitlement infrastructure owned by the CSC and OKC (Service Contracts) product families. The package header version identifiers (cscvrenb.pls 115.22) confirm it belongs to the CSC "VRENB" source family, which governs the relationship between customer plan headers, plan lines, and underlying OKC condition records.

Functionally, the package translates a customer's plan configuration into the corresponding set of condition identifiers, alert names, and script names that downstream service-request and action-processing logic consumes. It bridges the CSC plan model (CSC_CUST_PLANS, CSC_PLAN_HEADERS_B, CSC_PLAN_LINES) with the OKC condition model (OKC_CONDITION_HEADERS_B). Because the "detach_string" token appears in search context, the package's DETACH_STRING utility is a notable public surface used for parsing or splitting delimited attribute strings held on action records.

Key Procedures and Functions

  • ENABLE_PLAN — Identifies eligible customer plans for a given party and optionally customer account, filters them by end-user type and an active date range, and returns the collection of OKC condition identifiers associated with those plans. It is the core assembly routine for turning an enabled plan into actionable condition rows.
  • ENABLE_PLAN_AND_GET_OUTCOMES — Extends plan enablement by returning not only the condition identifiers but also the resulting outcome set, allowing callers to drive follow-on action logic in a single call.
  • GET_OUTCOMES — Retrieves the outcome records associated with an action or condition context. Used to determine the result state after plan processing.
  • GET_ALERT_NAME — Resolves the alert name configured for a given action, supplying the human-readable label displayed when an alert is raised.
  • GET_SCRIPT_NAME — Resolves the script name tied to an action, used when the action must launch an associated script or workflow step.
  • DETACH_STRING — Utility routine that extracts or splits a delimited string, typically to separate multiple action attribute values held in a single column. This is the routine most commonly searched for, as it is reused when parsing concatenated attribute payloads.

Tables Accessed

  • CSC_CUST_PLANS — Stores the customer plan instance, including party_id, cust_account_id, plan_status_code, and plan_id. Filtered to statuses APPLIED, ENABLED, and TRANSFERED.
  • CSC_PLAN_HEADERS_B — Holds plan header definition, including end_user_type and start/end date active, used to validate the plan against the requested end-user type and current date.
  • CSC_PLAN_LINES — Maps a plan to its condition_id values, providing the join between plans and conditions.
  • OKC_CONDITION_HEADERS_B — The base condition header table; the package reads the condition id that ultimately feeds the output condition_id table.
  • PLITBLM — The standard PL/SQL integer table type, used internally for bulk collections and index handling.

Usage Notes

CSC_ACTION_ASSEMBLER_PVT is a private API and is not intended to be called directly by customers or integrators; it is invoked by the CSC forms and service-request flows, and is referenced by one other package within the APPS schema. Because it is classified PVT, all signatures are considered unstable and subject to change between point releases, so custom code should avoid a direct dependency. When invoked, it is typically called during plan enablement from the TeleService agent UI or from a concurrent program that regenerates entitlements. The DETACH_STRING and GET_OUTCOMES routines are the most frequently reused entry points, appearing in action-assembly logic that must decode stored attribute strings before an alert or script is dispatched.