Search Results get_content_item_data

Overview

AMS_CPageUtility_PVT is a private PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle Marketing content page and content item infrastructure. It belongs to the Application Management System (AMS) module and works together with the Internet Business Components (IBC) content repository. The package encapsulates utility logic for creating, approving, updating, and managing content items, content pages, deliverables, rich content, sections, images, and display templates used in marketing and promotional content authoring.

The package header declares several private constants that reveal its design intent. The reusable flag (g_reusable_flag) was originally used to create content items for each section as reusable items; a later change moved IBC toward using parent_item_id instead. Locking is deliberately disabled (g_lock_flag_value and g_using_locking set to false) because IBC lock and unlock operations only take effect when the transaction is committed, which is not the desired behavior. The wd_restricted_flag controls whether an item is available at runtime; items intended for public read access set this flag to false, while administrator-only directory items set it to true.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions. The core deliverable-oriented procedures include:

• CREATE_CITEM_FOR_DELV — creates a content item for a deliverable of type Content Page, returning the new content item ID. It accepts content type code, default display template ID, deliverable ID, and association type code, which is recorded in the IBC_ASSOCIATIONS table.
• APPROVE_CITEM_FOR_DELV — approves the content item associated with a deliverable.
• UPDATE_CITEM_FOR_DELV — updates the content item for a deliverable.
• MANAGE_RICH_CONTENT — manages rich content associated with a content item.
• MANAGE_TOC_SECTION — manages table-of-contents sections.
• UPDATE_QUESTIONS_SECTION — updates the questions section of a content page.
• GET_RICH_CONTENT_DATA, GET_CONTENT_ITEM_DATA, GET_CONTENT_ITEM_ATTRS — retrieval routines that return rich content, content item, and content item attribute data respectively.
• CREATE_CP_IMAGE and UPDATE_CP_IMAGE — create and update content page images.
• UPDATE_CONTENT_ITEM — the procedure most directly relevant to the search term, updating an existing content item record.
• CREATE_DISPLAY_TEMPLATE — creates a display template for content pages.
• CREATE_BASIC_QUESTIONS_ITEM — creates a basic questions item, typically for interactive forms or surveys.
• GENERATE_SELECT_SQL — builds dynamic selection SQL, likely for list source population.
• CREATE_SUBMIT_SECTION and UPDATE_SUBMIT_SECTION — create and update submit sections.
• ERASE_BLOB — removes binary large object data, typically from FND_LOBS.

Tables Accessed

The package reads and writes several core IBC and AMS tables through APPS synonyms. IBC_CITEM_VERSIONS_B and IBC_CITEM_VERSIONS_TL store the base and translated content item version rows. IBC_ASSOCIATIONS links content items to deliverables. IBC_STYLESHEETS supports display template rendering. AMS_CPAG_QUESTIONS_B stores questions section data. AMS_LIST_SRC_FIELDS, AMS_LIST_SRC_TYPES, and the AMS_LIST_SRC_TYPE_USAGES and _S tables support list source generation used by GENERATE_SELECT_SQL. FND_LOBS is accessed for BLOB storage and cleanup via DBMS_LOB. DUAL and PLITBLM appear as utility references.

Usage Notes

As a PVT (private) API, this package is not intended for direct customer invocation; it is called internally by other AMS components, IBC content authoring forms, and concurrent programs that manage marketing content pages. In Oracle EBS 12.1.1 and 12.2.2, no other packages reference it in the documented dependency map, indicating it is invoked from form-level or AOL-level code rather than from a public PL/SQL API chain. Customizations that need update_content_item behavior should call the supported public APIs or the underlying IBC APIs rather than this private package, since its signatures and behavior may change between patches.