Search Results amv_number_varray_type

Overview

AMV_CHANNEL_PVT is a private PL/SQL package in the Oracle E-Business Suite database, owned by APPS and declared with AUTHID CURRENT_USER. It is the internal implementation package for the Oracle Marketing channel (or "list") subsystem, providing the low-level programmatic interface through which channels are created, maintained, and queried. A channel in this context is a targetable group of customers or prospects defined by matching criteria, content types, perspectives, item types, keywords, and authors, and used by marketing campaigns and iStore personalization features.

The package is classified as a private (PVT) API, meaning it is not intended as a public integration surface. It exposes the channel object to the public API layer and is referenced by seven other packages within the application. The object carries a single header revision (amvvchas.pls 120.1, dated 2005/06/22), indicating a stable interface that has changed little across the 12.1.1 and 12.2.2 releases.

The package declares several shared PL/SQL types used across the channel tables: AMV_CHAR_VARRAY_TYPE and AMV_NUMBER_VARRAY_TYPE for bulk parameter passing, amv_return_obj_type for paginated result metadata, amv_request_obj_type for describing paged requests, and AMV_CHANNEL_OBJ_TYPE, a record that mirrors the AMV_C_CHANNELS_B row structure including channel identity, owner, approver, effective dates, approval flags, match-criteria flags, notification intervals, and the standard descriptive flexfield attribute columns.

Key Procedures and Functions

• ADD_CHANNEL — the base channel creation routine, inserting the primary channel row and associated detail records.
• ADD_PUBLICCHANNEL, ADD_PROTECTEDCHANNEL, ADD_PRIVATECHANNEL, ADD_GROUPCHANNEL — specialized creation entry points that apply the access-level and ownership semantics appropriate to each channel visibility type.
• DELETE_CHANNEL and UPDATE_CHANNEL — remove or modify an existing channel and its dependent child rows.
• GET_CHANNEL — retrieves a channel definition, populating the AMV_CHANNEL_OBJ_TYPE record structure.
• SET_CHANNELCONTENTTYPES / GET_CHANNELCONTENTTYPES, SET_CHANNELPERSPECTIVES / GET_CHANNELPERSPECTIVES, SET_CHANNELITEMTYPES / GET_CHANNELITEMTYPES, SET_CHANNELKEYWORDS / GET_CHANNELKEYWORDS, SET_CHANNELAUTHORS / GET_CHANNELAUTHORS — paired setter and getter procedures for the individual match criteria collections that define which content is delivered to a channel.
• GET_ITEMSPERCHANNEL — returns the items currently matched to a given channel.
• SET_CHANNELAPPROVALSTATUS — advances or records the approval state of a channel within its approval workflow.

Tables Accessed

All table access is performed through APPS synonyms. The package reads and writes AMV_C_CHANNELS_B and its _S and _TL companions for the base channel entity and translated name and description. Criteria collections are persisted in AMV_C_CONTENT_TYPES, AMV_C_CHL_PERSPECTIVES, AMV_C_ITEM_TYPES, AMV_C_KEYWORDS, and AMV_C_AUTHORS, each with a corresponding _S table. AMV_C_AUTHORS_S, AMV_C_CHANNELS_B_S, AMV_C_CHL_PERSPECTIVES_S, AMV_C_CONTENT_TYPES_S, AMV_C_ITEM_TYPES_S, and AMV_C_KEYWORDS_S store the corresponding criteria records. AMV_C_CATEGORIES_TL supplies translated category names, and AMV_C_CHL_ITEM_MATCH holds the evaluated item-to-channel matching results.

Usage Notes

Because AMV_CHANNEL_PVT is a private package, it is not documented for direct customer invocation. It is called by the channel maintenance forms and by the concurrent processes that evaluate channel membership and generate item matches. Custom code that needs to create or modify channels should call the public AMV_CHANNEL_API or equivalent published interfaces rather than this package, since the private signature may change without notice.