Search Results iex_strategy_template_groups_s

Overview

IEX_STRATEGY_TEMPLATES_PKG is a stored PL/SQL package body owned by the APPS schema within Oracle E-Business Suite, specifically in the Advanced Collections (IEX/ETRM) product family. It provides the persistence and translation logic for Strategy Templates, one of the core configuration building blocks used by Collections Management and related scoring and workflow features. A strategy template defines the reusable rule set that drives delinquency-driven actions, collector assignment, and prioritization of delinquent customers and transactions.

The package body is validated and, according to the documented metadata, exposes three procedures. It is not referenced by any other database object, meaning it is invoked directly from the application layer (typically Oracle Forms or concurrent programs) rather than being nested inside another PL/SQL API. The object classifies as OTHER in ETRM's API taxonomy, so it is intended as an internal runtime package rather than a published, supported integration API.

Key Procedures and Functions

• ADD_LANGUAGE — Handles insertion of translated (multi-language) rows for strategy template data, working with the translatable entities used by the package. It supports the standard EBS translation pattern in which a base row is accompanied by language-specific seeded rows in the corresponding _TL table.
• TRANSLATE_ROW — Performs the actual row-level translation of a strategy template record for a specified language, ensuring the translated description or name columns are written consistently with the master row and the installed languages.
• COPY_STRATEGY_GROUP — Copies a strategy template group, including its associated template memberships and work/temp cross-reference data, so that an existing group configuration can be duplicated for reuse without manual re-entry.

Together these procedures cover the two main maintenance tasks the package supports: propagating translations across the strategy template schema and cloning an existing strategy group definition.

Tables Accessed

The documented dependency list confirms that the package reads and writes the full strategy template table family. IEX_STRATEGY_TEMPLATES_B holds the base (non-translatable) columns, IEX_STRATEGY_TEMPLATES_TL holds the translated columns, and IEX_STRATEGY_TEMPLATES_VL and IEX_STRATEGY_TEMPLATES_S provide the language and sequence/primary-key views and sequences that these operations require. IEX_STRATEGY_TEMPLATE_GROUPS and IEX_STRATEGY_TEMPLATE_GROUPS_S are the group header table and its sequence, which are the primary objects targeted by COPY_STRATEGY_GROUP.

IEX_STRATEGY_WORK_TEMP_XREF and its IEX_STRATEGY_WORK_TEMP_XREF_S sequence maintain cross-references between strategy templates and temporary work items, and are touched when groups are copied. FND_LANGUAGES supplies the installed language set, FND_GLOBAL and FND_PROFILE provide the session environment (organization, user, language context), and IEX_DEBUG_PUB is used for diagnostic logging. DUAL supports simple procedural SELECTs.

Usage Notes

Because no other database object references IEX_STRATEGY_TEMPLATES_PKG, invocation is driven from the application UI or from administrative setup. ADD_LANGUAGE and TRANSLATE_ROW are typically called during language installation or when a translated strategy template description must be maintained, aligning with the standard Oracle seeding and Run Translation processes. COPY_STRATEGY_GROUP is invoked from the Strategy Templates setup windows when an administrator chooses to replicate an existing group rather than build one from scratch.

The package should be treated as internal to Advanced Collections. Custom code that needs the same behavior is advised to call these procedures rather than manipulating the underlying tables directly, since the procedures enforce the required inserts into the _TL, _B, and cross-reference tables in the correct order. All execution occurs under the APPS schema, with FND_GLOBAL/FND_PROFILE establishing the language and security context.