Search Results g_current_login_id

Overview

APPS.BIS_BIA_DIM_MAP_UTIL is a utility package body belonging to the Oracle Business Intelligence System (BIS) schema family, which underpins the Oracle EBS Daily Business Intelligence and related analytical reporting infrastructure. Its documented purpose is to maintain the dimensional mapping relationships between geographic areas and countries within the territory hierarchy used by BIS reporting. The package encapsulates the write operations required to create and remove area-to-country associations, encapsulating the underlying DML against the BIS_TERRITORY_HIERARCHIES table. It is classified in ETRM as a UTIL-type API, indicating that it provides supporting data manipulation rather than a business-facing concurrent program or a validation-heavy public interface. As documented, validation logic is intentionally absent from the package, because all input verification is performed on the front-end user interface before these procedures are invoked.

Key Procedures and Functions

• ADD_AREA_COUNTRY_ASSOCIATION — Inserts a new parent-child relationship into the territory hierarchy, associating a country with a parent area. The procedure records the parent territory as type AREA and the child territory as type COUNTRY, stamps the row with the active date range, and populates the standard WHO audit columns. It commits the transaction upon success and re-raises any exception through a WHEN OTHERS handler, exposing errors to the calling layer.
• DEL_AREA_COUNTRY_ASSO — The companion deletion routine that removes an existing area-to-country association from the territory hierarchy. Together with the add procedure, it forms the complete maintenance interface for the area-country mapping maintained by this utility.

The source header also records a commented-out function, GET_COUNTRIES_BY_AREA, which was disabled for performance reasons (Bug#5203008) and is not part of the active interface.

Tables Accessed

The sole documented table is BIS_TERRITORY_HIERARCHIES, accessed through an APPS synonym. This table stores the hierarchical territory relationships consumed by BIS dimensional reporting. ADD_AREA_COUNTRY_ASSOCIATION performs an INSERT against it, setting PARENT_TERRITORY_CODE to the area and CHILD_TERRITORY_CODE to the country, with corresponding type indicators and active date bounds. The disabled function referenced two views, BIS_AREAS_V and BIS_COUNTRIES_V, but these are not part of the current active code path.

Usage Notes

The package is invoked directly from the BIS administrative user interface when a user adds or removes a country from an area. Because the procedures commit and rely on the caller for validation, custom code that reuses them must replicate the front-end validation to avoid orphaned or duplicate hierarchy rows. The package initializes two package-level global variables at load time — g_current_user_id and g_current_login_id — sourced from FND_GLOBAL.User_id and FND_GLOBAL.Login_id respectively. The identifier g_current_login_id therefore appears in this package both as an internal audit-stamping variable and as the value written to the LAST_UPDATE_LOGIN column of BIS_TERRITORY_HIERARCHIES, which is the typical reason a search for that term resolves to this object. The package is referenced by zero other packages per the ETRM metadata, confirming its role as a leaf-level utility driven by the application layer.