Search Results csc_action_assembler_pvt_w




Overview
Explore in AI Chat

Overview

APPS.CSC_ACTION_ASSEMBLER_PVT_W is a private PL/SQL wrapper package within the Oracle E-Business Suite Customer Care (CSC) application module. Its name follows the EBS convention for generated or JTF-based wrapper layers, denoted by the _PVT_W suffix, where PVT indicates a private implementation and W signals the wrapper role. The package is declared with AUTHID CURRENT_USER, meaning its unqualified database object references resolve under the privileges of the invoking schema rather than the package owner, APPS.

The package assembles action plans and their associated outcomes for a given customer account and contact context. It bridges caller-supplied table-based parameters with the internal representation used by csc_action_assembler_pvt, performing bulk data conversion and orchestration. The documented API classification is OTHER, reflecting that the package is not part of the standard public API surface but rather an internal plumbing layer used by forms, concurrent programs, or higher-level service components that present customer interaction outcomes to users.

Key Procedures and Functions

  • rosetta_table_copy_in_p1 — Converts or copies an inbound set of tabular parameters into the internal results table type used by csc_action_assembler_pvt. It handles the "in" direction of the wrapper's data marshalling, mapping three parallel JTF_VARCHAR2_TABLE columns into the internal structure.
  • rosetta_table_copy_out_p1 — The complementary "out" procedure, which maps the internal results table type back into three JTF_VARCHAR2_TABLE output parameters so callers receive data in the standard tabular format.
  • enable_plan_and_get_outcomes — The primary functional entry point named in the user's search. It accepts customer identity context (party, cust account, end user type, and application short name) along with inbound tabular parameters, and returns outcome data through three out parameters. This procedure enables an action plan and immediately retrieves the resulting set of outcomes for the caller.
  • get_outcomes — Retrieves outcomes for a specified action, keyed by an action identifier and application short name, and includes standard EBS API instrumentation parameters: API version number, init message list, and return status, message count, and message data outputs. The outcome tables are passed as in-out parameters.

Tables Accessed

The documentation records PLITBLM as the sole referenced table, accessed via APPS synonym. PLITBLM is the standard EBS concurrent manager table used for logging and managing concurrent request information. Its presence indicates that this package participates in or is invoked from concurrent processing contexts, where logging and request bookkeeping are required. The business data itself is carried through the JTF_VARCHAR2_TABLE parameters rather than through direct base-table access within this wrapper, which is consistent with its marshalling role.

Usage Notes

Because this is a wrapper package with AUTHID CURRENT_USER and no public API classification, it is not typically called directly by customers or integrators. It is invoked indirectly by the Customer Care forms and service components that manage action plans and outcomes. The ETRM metadata shows zero referencing packages, confirming that dependencies are runtime rather than declared static PL/SQL references. In both Oracle EBS 12.1.1 and 12.2.2, the wrapper remains unchanged in structure. Custom extensions that need outcome data should prefer the documented public API in csc_action_assembler_pvt, using enable_plan_and_get_outcomes through supported service interfaces rather than calling this private wrapper directly, as the API version parameter in get_outcomes signals that signature stability is not guaranteed across upgrades.