Search Results load_ieu_wp_sections_b

Overview

The APPS.IEU_SEED_DATA_LOADER_PKG package is a seed data loading utility within the Oracle E-Business Suite Interaction Center / Universal Work Queue (IEU) module. Its principal business function is to populate the IEU configuration tables that define how the Universal Work Queue, media type mappings, client-side plugins, server-side plugins, select enumerators, resource category enumerations, work panel sections, and work panel action mappings are registered and behave at runtime. These configuration records are seeded data rather than transactional data, and the package exists to provide a controlled, repeatable mechanism for inserting or updating them.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the defining schema. The header comment references the Loader Control file ieuuwq.lct and ieuenum.lct, confirming that the package is invoked by the Oracle Applications Data Loader (the standard loader mechanism that reads .lct definitions and drives PL/SQL seed loaders). The package is classified as an API of type OTHER and, per the documented metadata, is referenced by zero other packages, indicating it is a terminal load utility rather than a shared library routine.

Key Procedures and Functions

The documented public procedures each follow a consistent pattern of accepting an upload mode plus the identifying and descriptive attributes of a single configuration record:

• Load_IEU_UWQ_SVR_MPS_MMAPS — loads server media processing system media type map records.
• Load_IEU_UWQ_SEL_ENUMERATORS — appears in two overloaded forms, one driven from the ieuuwq.lct definition and a broader form driven from ieuenum.lct, loading select enumerator definitions along with associated work queue profile options, action processor definitions, and resource category configuration.
• Load_IEU_UWQ_CLI_MED_PLUGINS — loads client media plugins, associating a client plugin implementation class with a media type and application.
• Load_IEU_UWQ_SVR_MPS_PLUGINS — loads server media processing system plugins, associating a server plugin class with a server type and application.
• Load_IEU_UWQ_NODE_DS — loads work queue node data source definitions.
• Load_IEU_UWQ_RES_CAT_ENM_MAPS — loads resource category to enumerator mapping records.
• Load_IEU_CLI_PROV_PLUGINS — loads client provider plugin registrations, the procedure associated with the search term load_ieu_cli_prov_plugins.
• Load_IEU_CLI_PROV_MED_MAPS — loads client provider to media type map records.
• Load_IEU_WP_SECTIONS_B — loads work panel section base-table records.
• Load_WORK_PANEL_ACTION_PARAMS — loads work panel action parameter definitions.
• Load_NON_MEDIA_ACTIONS — loads non-media action definitions.
• Load_WP_ACTION_MAPS — loads work panel action mapping records.

Parameter lists are not reproduced here; each procedure follows the loader convention of an upload mode plus record attributes and an owner identifier.

Tables Accessed

The package writes to the IEU configuration tables through APPS synonyms. It targets IEU_CLI_PROV_PLUGINS and IEU_CLI_PROV_PLUGIN_MED_MAPS for client provider plugin and media mapping data; IEU_UWQ_CLI_MED_PLUGINS, IEU_UWQ_SVR_MPS_PLUGINS, and IEU_UWQ_SVR_MPS_MMAPS for client and server media processing configuration; IEU_UWQ_SEL_ENUMERATORS and IEU_UWQ_RES_CAT_ENM_MAPS for enumerator and resource category mapping data; IEU_UWQ_NODE_DS for node data sources; IEU_UWQ_MACTION_DEFS_B and IEU_UWQ_NONMEDIA_ACTIONS for action definitions; and IEU_WP_ACTION_MAPS, IEU_WP_ACTION_PARAMS, and IEU_WP_ACT_PARAM_SETS_B for work panel action configuration. Reference lookups against FND_APPLICATION resolve application identifiers, and FND_LANGUAGES supports language-dependent seeding.

Usage Notes

The package is normally invoked by the Oracle Applications Data Loader during installation, patching, or upgrade of the IEU module, rather than interactively. The upload mode parameter determines whether records are created or refreshed. Direct invocation from custom code is uncommon but possible when administrators need to reload a specific seed record; in such cases the caller must supply valid identifiers and comply with the package's AUTHID CURRENT_USER privilege model. Because the package has no dependent packages referencing it, changes to its behavior are isolated to the seed loading process itself.