Search Results get_alert_name




Overview
Explore in AI Chat

Overview

CSC_ACTION_ASSEMBLER_PVT is a private (PVT) PL/SQL package owned by APPS within the Oracle E-Business Suite Customer Care / TeleService and Service Contracts (CSC) schema. It functions as an internal assembly engine that evaluates service entitlement conditions and translates the resulting outcomes into actionable results — alerts, scripts, and related UI artifacts that a customer service representative can act upon. The package is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking session rather than the definer, which is consistent with its role as a building block called by higher-level public APIs rather than directly by end users. Its header comments date the package lineage to the 11.5.x code line (cscvrens.pls 115.14), and the object continues to ship in EBS 12.1.1 and 12.2.2 in essentially unchanged form.

Key Procedures and Functions

  • ENABLE_PLAN — Enables a service plan for a given party/customer account combination and returns a table of generated condition identifiers. It forms the entry point for activating entitlement-covered service plans.
  • ENABLE_PLAN_AND_GET_OUTCOMES — A combined convenience routine that enables a plan and immediately evaluates it, returning a results table. It accepts an application short name and a message table for error/information propagation.
  • GET_OUTCOMES — Retrieves the outcomes for an already-evaluated condition. It follows the standard EBS API error-handling convention, returning x_return_status, x_msg_count, and x_msg_data, and accepts an in/out results table. This is the central evaluation routine of the package.
  • GET_ALERT_NAME — Parses an input string in the context of an application short name and returns the resolved alert name.
  • GET_SCRIPT_NAME — The function implicated in the user's search. It parses an input string and returns the associated script name, allowing the TeleService framework to launch a guided script in response to an evaluated condition.
  • DETACH_STRING — A utility function used internally to split or parse delimited strings consumed by the alert- and script-name resolution logic above.

Tables Accessed

The package references (via APPS synonyms) OKC_CONDITION_HEADERS_B, CSC_CUST_PLANS, CSC_PLAN_HEADERS_B, CSC_PLAN_LINES, and PLITBLM. OKC_CONDITION_HEADERS_B holds the entitlement condition definitions that the assembler evaluates; the CSC plan tables store the customer plan instances and their line-level detail that participate in that evaluation. PLITBLM is the standard EBS temporary/line-table structure used during string and result processing. Condition identifiers returned by ENABLE_PLAN and passed into GET_OUTCOMES originate from OKC condition headers, linking the entitlement model to the returned script and alert outcomes.

Usage Notes

As a PVT-classified package, CSC_ACTION_ASSEMBLER_PVT is not intended for direct invocation by customer extensions. It is called by the TeleService/Customer Care forms and by one other documented APPS package, which orchestrates condition evaluation and then uses GET_OUTCOMES to drive the display of alerts and scripts to the service agent. Custom code should prefer the public OKC condition-evaluation APIs (such as OKC_CONDITION_EVAL_PUB, whose OUTCOME_TAB_TYPE the package reuses). Because the package relies on APPS synonym resolution and session-level privileges, any wrapper must be deployed in the APPS schema or granted equivalent access to the underlying tables.