Search Results get_mkt_segments_w




Overview
Explore in AI Chat

Overview

APPS.AMS_IBA_SEGMENTS_PUB is a public PL/SQL package in the Oracle E-Business Suite Advanced Marketing (AMS) module. Its single documented routine, Get_Mkt_Segments_W, acts as a thin wrapper over AMS_MKT_SEGMENTS_PUB.Get_Mkt_Segments, providing a convenient entry point for retrieving the market segments associated with a given party or target segment. The _W suffix denotes a wrapper-style API, and the package is classified as PUB in the ETRM metadata, meaning it is exposed for external invocation rather than being restricted to internal use.

The package supports marketing segmentation and targeting functionality: identifying which market segments a party (customer, prospect, or contact) belongs to, or resolving a specific target market segment. Because the underlying package returns results as a nested table of the PL/SQL type AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp, this wrapper preserves the same OUT parameter mechanism for consumers that cannot handle function return values directly, such as certain Oracle Forms or Java/BC4J callers.

Key Procedures and Functions

The package body documents one procedure:

  • Get_Mkt_Segments_W — Retrieves the market segments for a party and/or a target segment. It accepts a party identifier and a target segment identifier as optional inputs and returns the matching party market segment rows through the OUT parameter x_PartyMktSegTabTyp. Internally it invokes AMS_MKT_SEGMENTS_PUB.Get_Mkt_Segments and assigns the function's result to the OUT parameter, delegating all query logic to the underlying public API. The header history date (01/16/00, "ryedator Create") and CVS version tag (115.1, 2000/03/07) indicate the package is an early-release AMS artifact that has remained stable with minimal revision.

The parameter convention (p_ party_id, p_target_segment_id, x_ output tab) follows standard Oracle EBS API naming and reflects a bulk-collection interface suitable for set-based processing in PL/SQL callers.

Tables Accessed

The package indirectly references the table AMS_PARTY_MARKET_SEGMENTS, as documented via APPS synonyms. This table stores the associations between parties and market segments, including the party_id and market_segment_id columns that the procedure treats as optional filter inputs. The actual row retrieval is performed inside AMS_MKT_SEGMENTS_PUB, but from a dependency and data-access standpoint this wrapper is tied to the same underlying data: market segmentation membership by party and target market segment. The OUT collection type carries the party market segment records back to the caller.

Usage Notes

Because the routine is a public wrapper, it is typically invoked from:

  • Oracle Forms-based Marketing setup or inquiry screens that need to display a party's market segment assignments.
  • Custom PL/SQL programs or concurrent programs that require market segmentation data for a party or campaign targeting logic.
  • Integration or downstream APIs calling through the public interface rather than referencing AMS_MKT_SEGMENTS_PUB directly.

Callers should pass either p_party_id, p_target_segment_id, or both as optional filters and must declare a variable of type AMS_MKT_SEGMENTS_PVT.PartyMktSegTabTyp to receive the OUT parameter. Since all logic is delegated to AMS_MKT_SEGMENTS_PUB.Get_Mkt_Segments, performance and error behavior (for example, NO_DATA_FOUND handling) are governed by that package. The ETRM metadata also records that this package is referenced by one other package, confirming it participates in a call hierarchy within AMS and should be treated as a stable, backward-compatible public interface in EBS 12.1.1 and 12.2.2.