Search Results prp_comp_style_ctntvers




Overview
Explore in AI Chat

Overview

The PRP_COMP_STYLE_CTNTVERS table is a core data object within the Oracle E-Business Suite Proposals (PRP) module, present in both the 12.1.1 and 12.2.2 releases. It functions as a junction table that manages the versioned, multilingual associations between a component style and its corresponding physical document content. In essence, it links a defined style template for a proposal component to the actual file (e.g., a Word document, PDF, or HTML template) that embodies that style for a specific language and version. This structure is critical for enabling the generation of multi-language proposals where the formatting and boilerplate content are consistently applied across different components.

Key Information Stored

The table's primary purpose is to maintain unique, versioned style-content links. Its key columns, as defined by its primary and unique keys, are:

The unique key constraint (UK1) on COMPONENT_STYLE_ID, LANGUAGE, and VERSION_NUMBER ensures that only one content version exists per style-language combination.

Common Use Cases and Queries

This table is central to operations involving proposal template management and document generation. A common administrative task is to retrieve all available content versions for a specific component style to review or roll back changes. For example:

SELECT pcscv.language, pcscv.version_number, fl.meaning AS language_name
FROM prp.prp_comp_style_ctntvers pcscv,
    fnd_languages fl
WHERE pcscv.component_style_id = :style_id
AND pcscv.language = fl.language_code
ORDER BY pcscv.language, pcscv.version_number DESC;

During the runtime generation of a proposal, the system queries this table to locate the correct template file based on the selected component style and the user's session language. Troubleshooting missing templates often involves verifying that a record exists for the required language and that the FILE_ID points to a valid LOB. Data fixes may require inserting new version records or updating the FILE_ID pointer.

Related Objects

The table has defined foreign key relationships with several key EBS objects, as documented:

  • PRP_COMPONENT_STYLES_B: The parent table for the style definition (join on COMPONENT_STYLE_ID).
  • FND_LANGUAGES: Validates the LANGUAGE column.
  • FND_LOBS: Stores the physical document content (join on FILE_ID).
  • PRP_COMPONENTS_B: References the base component (join on COMPONENT_ID).
  • IBC_CITEM_VERSIONS_TL: Integrates with the Content Manager for advanced content storage (join on CITEM_VERSION_ID and LANGUAGE).
  • PRP_PROP_STYLE_CTNTVERS: This table is referenced as a parent, indicating proposal-level style content versions link to these component-level versions (foreign key from PRP_PROP_STYLE_CTNTVERS.OBJECT_ID).
  • PRP_STYLE_CTNTVER_TOKENS: Child table that likely stores replaceable tokens or variables within the content file (foreign key on COMP_STYLE_CTNTVER_ID).