Results for “jtf_amv_items_pkg”
30 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.JTF_AMV_ITEMS_PKG is the implementation package body for the JTF_AMV_ITEMS package, a component of the Oracle E-Business Suite Applications Technology layer that supports the Application Media Viewer (AMV) framework. The AMV framework stores and renders media items — such as help text, graphics, and other rich content — that are displayed to users within EBS forms, HTML pages, and self-service applications. In Oracle EBS 12.1.1 and 12.2.2, this package body provides the PL/SQL logic behind item creation, maintenance, translation, and seed data loading for the JTF_AMV_ITEMS tables.
The package follows the standard EBS "table handler" or "seed data loader" pattern implemented on top of FND_API and FND_LOAD_UTIL. It encapsulates row-level data manipulation against the base and translation tables of the AMV Items entity, exposing a consistent API that can be called from concurrent programs, forms, or Oracle Application Framework (OAF) pages. The object is VALID with status recorded in ETRM, and it is classified as an OTHER API rather than a public business API.
Key Procedures and Functions
The documented API exposes eight procedures and functions:
- LOAD_ROW — Loads a single media item row, typically used with FND_LOAD_UTIL to seed or migrate AMV item definitions across environments.
- LOAD_SEED_ROW — Specialized variant of LOAD_ROW tailored to seed data loading, using FND_LOAD_UTIL conventions for seed row insertion and comparison.
- TRANSLATE_ROW — Creates or updates translation rows in JTF_AMV_ITEMS_TL for a given language, supporting the multilingual content model of the AMV framework.
- INSERT_ROW — Performs the core insert of a new media item into the base and translation tables, applying WHO columns and standard validation.
- LOCK_ROW — Locks an existing row for update, enforcing concurrency control before changes are applied.
- UPDATE_ROW — Applies modifications to an existing media item, updating base and translated attributes as required.
- DELETE_ROW — Removes a media item from the AMV tables, including its translation rows.
- ADD_LANGUAGE — Inserts additional language rows for an existing item, used when enabling new languages for AMV content.
Tables Accessed
The package reads and writes the following tables through APPS synonyms:
- JTF_AMV_ITEMS_B — Base table holding language-independent media item attributes such as item identifiers and classification.
- JTF_AMV_ITEMS_TL — Translation table holding language-specific content (titles, descriptions) for each media item.
- FND_LANGUAGES — Oracle Applications language repository, consulted to validate language codes and drive translation loading.
Dependency metadata also shows direct references to FND_API for the standard API error/status model, FND_LOAD_UTIL for seed loading, FND_MESSAGE for translatable messages, and APP_EXCEPTION for error plumbing.
Usage Notes
This package is typically invoked in three contexts. First, during installation or patching, seed data loaders call LOAD_SEED_ROW and TRANSLATE_ROW to populate standard AMV items and their translations. Second, during country or language extensions, ADD_LANGUAGE and TRANSLATE_ROW are used to enable content in additional languages. Third, custom or upgrade code may call INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW directly to maintain AMV items, or LOAD_ROW to migrate definitions between environments. Because ETRM classifies the API as OTHER and does not document its parameters, custom callers should inspect the package specification before use; the package body is not referenced by any database object, confirming it is exclusively an entry-point for external callers.
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: APPS.FND_LANGUAGES 12.2.2
-
SYNONYM: APPS.FND_LANGUAGES 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1