Search Results upload_member_header_interface

Overview

FEM_WEBADI_MEMBER_UTILS_PVT is a private (PVT) PL/SQL package in the APPS schema that supports the WebADI-based member maintenance infrastructure within Oracle Enterprise Performance Foundation (also marketed as Enterprise Planning and Budgeting / ETRM components in the 12.1.1 and 12.2.2 releases). Its role is to provide the server-side utility layer that underpins the upload of dimension member metadata from WebADI (Web Applications Desktop Integrator) spreadsheets into the FEM member interface tables. The package bridges the BNE WebADI framework — integrators, interfaces, layouts, blocks and columns — with the FEM dimension, dimension group and dimension attribute metadata tables, resolving the column mappings and sequence assignments that govern how a member header spreadsheet row is translated into an interface record. The header comment dates the package to release 120.0 (2006), consistent with the 11.5.10 / 12.0 lineage that was carried forward essentially unchanged into EBS 12.1.1 and 12.2.2. Because the package is classified PVT, it is not an advertised public API and should not be called directly by customer code.

Key Procedures and Functions

• POPULATE_MEM_WEBADI_METADATA — Populates the in-memory dimension metadata structures used throughout the package. The declared global record type g_global_val_rec_type holds dimension id, dimension varchar label, interface member base and TL table names, interface attribute table name, member base table name, member display code and name columns, calendar display code, and member name and description values. The boolean flag g_is_context_info_present prevents redundant re-execution of this routine once the metadata has been cached.
• UPLOAD_MEMBER_HEADER_INTERFACE — The procedure associated with the user's search term. It handles the upload of the member header portion of a WebADI member interface, using the cached dimension metadata and the column mapping information to write member header rows into the FEM member interface tables.
• NAME — A utility function that returns the name associated with a member or interface context, used to resolve display labels for the mapping logic.
• DELETE_FEM_WEBADI_SEED — Removes seeded WebADI metadata rows for the FEM integrator, allowing the seeding routine to be re-run cleanly during patching or setup resets.

The package also declares collection types g_changed_intf_col_tbl and g_changed_dt_intf_col_tbl (both FND_TABLE_OF_VARCHAR2_30) for tracking changed interface columns, and g_sequences_tbl (FND_TABLE_OF_NUMBER) holding mapping sequence values. The constant G_LIMIT_BULK_NUMROWS := 100 bounds bulk fetch/insert operations.

Tables Accessed

• BNE_INTEGRATORS_B / _TL, BNE_INTERFACES_B / _TL — Define the WebADI integrator and interface that target FEM member uploads.
• BNE_INTERFACE_COLS_B / _TL — Supply the interface column definitions used to build the spreadsheet layout and drive mapping.
• BNE_LAYOUTS_B / _TL, BNE_LAYOUT_BLOCKS_B / _TL, BNE_LAYOUT_COLS — Provide the layout, block and column structure for the member header WebADI template.
• FEM_DIMENSIONS_B / _TL, FEM_DIMENSION_GRPS_B, FEM_DIM_ATTRIBUTES_B — Provide the dimension, dimension group and dimension attribute metadata used to resolve a spreadsheet member row to the correct FEM interface column and attribute.

Usage Notes

The package is invoked internally by the FEM WebADI member upload flows and by the seeding/deletion routines that maintain the FEM WebADI integrator definition; it is also called indirectly from related FEM WebADI private packages. It is not referenced by any other packaged API according to the ETRM metadata, and it is not exposed to the Oracle Forms layer or to concurrent programs as a public entry point. Custom code should use the supported FEM public APIs for member maintenance rather than calling this package directly.