Search Results get_stylesheet_items

Overview

IBC_STYLESHEETS_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a GRP (group/utility) API within the Oracle iLearning and content management framework (the IBC schema prefix denotes the iLearning Content and Catalog modules). The package provides the programmatic interface for retrieving approved stylesheet definitions that govern the rendering and presentation of content items delivered through the iLearning and knowledge management stack. Stylesheets in this context are XSL-based presentation templates that control how structured learning content, content item versions, and associated metadata are displayed to end users.

The package is recorded as VALID in both Oracle EBS 12.1.1 and 12.2.2 environments, indicating it is a supported, compiled object within the product's standard delivery. Its core responsibility is to resolve which stylesheet should be applied when content is rendered, distinguishing between a system-approved default stylesheet and user-specified approved stylesheets, and to enumerate the individual stylesheet items that constitute a complete presentation definition.

Key Procedures and Functions

The package exposes five documented program units:

• GET_APPROVED_DEFAULT_STYLESHT — Retrieves the approved default stylesheet definition, returning the presentation template used when no explicit stylesheet has been associated with a content item.
• GET_APPRV_DEFAULT_STYLESHT_ID — Returns the identifier of the approved default stylesheet, allowing callers to resolve the default reference without loading the full definition.
• GET_APPROVED_STYLESHEET — Fetches a specific approved stylesheet, typically by identifier, for use in rendering a particular content item.
• GET_APPROVED_STYLESHT_RC — Retrieves an approved stylesheet and reports a return code, providing callers with an explicit status indicator for error handling and exception management.
• GET_STYLESHEET_ITEMS — Enumerates the constituent items of a stylesheet, returning the individual presentation elements or components that together form the complete template.

These program units follow the standard Oracle API design convention of separating data retrieval from status reporting, with the _RC variant supplying the diagnostic code needed by integration and batch callers.

Tables Accessed

The package operates against several underlying tables, referenced through APPS synonyms:

• IBC_STYLESHEETS — The master repository of stylesheet definitions, holding the presentation templates and their approval status.
• IBC_CONTENT_ITEMS — Stores the content items to which stylesheets are applied, providing the association between content and presentation.
• IBC_CITEM_VERSIONS_B and IBC_CITEM_VERSION_LABELS — Hold versioned content item data and their display labels, supplying the structured content rendered through the retrieved stylesheet.
• FND_LOBS — Stores the large object data for stylesheet definitions, since XSL templates and presentation assets are persisted as LOB content in the Oracle EBS file manager.
• PLITBLM — A PL/SQL internal table used for LOB manipulation, employed here to materialize and return stylesheet LOB content to callers.

The package additionally declares dependencies on FND_API, JTF_CLOB_TABLE, JTF_NUMBER_TABLE, and JTF_VARCHAR2_TABLE_100, indicating it uses standard Oracle Application Object Library error handling and JTF collection types for passing structured result sets.

Usage Notes

IBC_STYLESHEETS_GRP is typically invoked by iLearning presentation logic, content rendering servlets, and custom extensions that must resolve the correct presentation template before displaying learning content. Because it is referenced by no other packages, it acts as a leaf-level utility called directly by forms, OAF pages, JSP rendering layers, or custom PL/SQL code rather than serving as an internal building block for other APIs. The _RC variant should be preferred in integration code where explicit error status is required, and callers should account for FND_LOBS retrieval overhead when requesting full stylesheet definitions, particularly in high-volume rendering scenarios. No documented concurrent program invokes the package directly, so its use is generally synchronous and request-scoped.