Search Results update_association_types

Overview

The APPS.IBC_ASSOCIATION_TYPES_PVT package is an internal, private API within the Oracle E-Business Suite Internet Business Components (IBC) module. Its designation as a private (PVT) package indicates that it is not intended for direct invocation by external application code, forms, or concurrent programs; rather, it functions as the backend implementation layer supporting a corresponding public package. Its primary business function is to manage the definition of association types used within the IBC content management framework, which governs how web content, regions, and reusable components are logically grouped and related to one another. Association types provide the metadata definitions that describe the nature of relationships between content entities, enabling the application to categorize and control how content is assembled and presented.

Key Procedures and Functions

The package exposes three documented procedures, each aligned with a standard lifecycle operation on association type definitions:

• CREATE_ASSOCIATION_TYPES — Inserts one or more new association type definitions into the underlying base table, establishing the foundational record that identifies a relationship category within the IBC content model.
• UPDATE_ASSOCIATION_TYPES — Modifies existing association type records, allowing attributes such as descriptive or classification information to be maintained without recreating the definition.
• DELETE_ASSOCIATION_TYPE — Removes a previously defined association type, typically subject to validation and referential integrity checks before the deletion is committed.

Consistent with the private API pattern, these procedures are expected to perform their data manipulation operations within a caller-managed transaction and rely on the FND_API utility package for error handling and message propagation. Parameter-level details are not exposed in the documented metadata and should not be assumed.

Tables Accessed

The package operates against a small set of documented dependencies:

• IBC_ASSOCIATION_TYPES_B — The base table storing association type definitions. All create, update, and delete operations are directed against this table, which serves as the authoritative source for association type records.
• PLITBLM — A standard Oracle EBS PL/SQL table type used as an in-memory collection structure. This indicates the package accepts or manipulates array-based (bulk) inputs rather than processing single rows individually, which is a common pattern in bulk-oriented APIs where multiple records are passed through a collection and applied together.

Read and write activity is therefore concentrated on the base table, with PLITBLM providing the transient data structure through which record sets are delivered to and processed by the procedures.

Usage Notes

As a PVT-classified package, IBC_ASSOCIATION_TYPES_PVT should not be called directly from custom code. It is invoked internally by its public counterpart package, IBC_ASSOCIATION_TYPES_PVT's external-facing wrapper set, and ultimately through the application's user interface layers or bulk-loading routines that manage content configuration. The reliance on the PLITBLM collection type suggests the package is designed to handle batched operations, where multiple association type records are created, updated, or deleted in a single call. The package further depends on the APPS.FND_API package, confirming adherence to the EBS API error-handling model. Organizations extending or troubleshooting IBC content configuration should target the public API surface; the private package represents an implementation detail that may change between releases. This is consistent with its presence in both Oracle EBS 12.1.1 and 12.2.2, where the IBC private API architecture remains stable.