Search Results default_rows




Overview
Explore in AI Chat

Overview

CNDISL_SLICE_ATTRIBUTES_PKG is an Oracle Applications (APPS) PL/SQL package that supports the Channel Revenue Management / Trade Management (CNDISL prefix) slicing and column-mapping infrastructure within Oracle E-Business Suite. The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking schema rather than the defining schema, and it is registered as an open API under the ETRM 12.2.2 classification "OTHER". Its purpose is to manage the association between source columns and destination columns used when a business object (such as a shipment or order line record) is sliced into a repository/table structure for analysis or aggregation.

The documented procedures expose the core operations required to seed, populate, insert, and remove slice attribute mappings. In the Oracle EBS 12.1.1 / 12.2.2 code line, this package forms part of the internal plumbing that translates user-defined column maps into physical column references held in the CN_COLUMN_MAPS and related tables.

Key Procedures and Functions

  • DEFAULT_ROWS — Seeds the default set of column-map identifiers used by the slicing process. It receives the source and destination column-map identifiers together with the temporary-table and rolled-up-table equivalents as IN OUT parameters, so the caller's variables are updated to reflect the default values assigned.
  • POPULATE_FIELDS — Populates descriptive column information (column names) for a given source column, destination column, or destination column map. It carries the source column identifier and destination column identifier as inputs and returns the corresponding column names as IN OUT parameters.
  • INSERT_ROW — Creates a new slice attribute record. Its parameter list carries the table map, column map, source column, group-by flag, destination column, aggregate function, column name, repository, table and the temporary and rolled-up table/column mapping identifiers, all of which are persisted into the column-map structures.
  • DELETE_ROW — Removes a slice attribute record. It takes the column-map and destination column identifiers for the primary, temporary, and rolled-up mappings, allowing the associated mapping rows to be deleted together.

Tables Accessed

According to the ETRM metadata, the package references the following objects through APPS synonyms:

  • CN_COLUMN_MAPS and CN_COLUMN_MAPS_S — the core repository of column mapping definitions. The procedures INSERT_ROW, DELETE_ROW, DEFAULT_ROWS, and POPULATE_FIELDS read and write these tables to maintain the source-to-destination column relationships.
  • CN_OBJECTS_S — the sequence/object registry used to obtain or validate identifiers for the mappings being created.
  • DUAL — used for single-row PL/SQL evaluation, typically for default or constant value assignment inside DEFAULT_ROWS.

Usage Notes

CNDISL_Slice_Attributes_PKG is an internal, non-public package. ETRM records it as being referenced by zero other packages, which indicates it is invoked directly by the Oracle Forms user interface or by concurrent/background code that builds the slicing setup rather than by other PL/SQL APIs. Typical invocation points are the Channel Revenue Management setup forms where column maps are defined, and any batch process that refreshes or copies mapping definitions. Because it is not exposed by dependent packages and is classified as OTHER, customizations should treat it as an unsupported internal API; the supported route for programmatic changes is to use the formally documented public interfaces. Custom code that does call it must respect the AUTHID CURRENT_USER context and the IN OUT parameter conventions documented above.