Search Results sync_template_attribute

Overview

The APPS.EGO_TEMPL_ATTRS_PUB package is a public PL/SQL API belonging to the Oracle E-Business Suite EGO (Electronic Ground Oracle / Product Information Management) schema. Its primary business function is to manage and synchronize template attribute definitions used by Oracle Product Information Management (PIM) and Inventory item templates. In Oracle EBS 12.1.1 and 12.2.2, templates define the set of descriptive flexfield attributes and attribute groups that control how item information is captured, validated, and displayed. This package provides the programmatic mechanism for keeping the EGO template attribute metadata aligned with the underlying descriptive flexfield structures and item template attribute records.

The package declares a set of global constants that map attribute data types (text, character, number, date, date-time) and validation codes (independent, none, table) together with display types such as attachment, checkbox, dynamic URL, hidden, radio, static URL, and text field. These constants allow callers to reference attribute behaviors symbolically rather than through hard-coded literals.

Key Procedures and Functions

The package exposes five documented entry points, classified as PUB (public API) and therefore safe for supported external invocation:

• SYNC_TEMPLATE — Synchronizes an entire template definition, coordinating the template's attribute groups and attribute usages with the current descriptive flexfield configuration. It is the primary orchestration routine.
• SYNC_TEMPLATE_ATTRIBUTE — Synchronizes a single named attribute belonging to a template, allowing targeted refresh rather than a full template synchronization.
• INSERT_TEMPLATE_ATTRIBUTE — Creates a new template attribute record, registering an attribute against a template so that it becomes available for item data capture.
• UPDATE_TEMPLATE_ATTRIBUTE — Modifies an existing template attribute record, for example to change its enabled flag, validation, or display behavior.

The source excerpt also defines the template_attribute_rec_type record type, which carries the attribute ID, attribute group ID, application column name, group name, template ID, enabled flag, attribute name, and attribute value.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms:

• EGO_TEMPL_ATTRIBUTES — the primary repository of template attribute definitions maintained by the insert, update, and sync routines.
• EGO_DATA_LEVEL_B — supplies data-level context for attributes.
• EGO_OBJ_AG_ASSOCS_B — links attribute groups to objects and templates.
• EGO_FND_DF_COL_USGS_EXT and EGO_FND_DSC_FLX_CTX_EXT — extended descriptive flexfield column usage and context definitions used to align EGO attributes with flexfield segments.
• FND_DESCR_FLEX_COLUMN_USAGES — the underlying Oracle Application Object Library descriptive flexfield column usage table.
• MTL_ITEM_TEMPL_ATTRIBUTES — the Inventory item template attribute table, reflecting the dual PIM/Inventory nature of templates.
• DUAL — used for single-row queries and lookups.

Usage Notes

EGO_TEMPL_ATTRS_PUB is typically invoked when template metadata must be reconciled with descriptive flexfield definitions, such as after flexfield changes or during item template setup. It is called from PIM and Inventory setup forms, from concurrent programs that maintain template consistency, and from custom code performing supported template attribute maintenance. Because it is classified as a public API and is referenced by one other package, it should be called through its documented procedures rather than by manipulating the underlying tables directly.