Search Results bis_varchar_tbl
Overview
APPS.BIS_UTILITIES_PUB is a public Oracle EBS PL/SQL utility package belonging to the Business Intelligence System (BIS) product family, which underpins the Oracle Balanced Scorecard and related BIS reporting infrastructure. Its role is to provide reusable, stateless helper logic for report generation, security resolution, and dynamic SQL construction across the BIS suite. The package specification declares a rich set of global constants (for example G_ERROR, G_WARNING, G_VALUE_SEPARATOR, G_SEED_OWNER, and the debug profile BIS_PMF_DEBUG) and composite data types, including Error_Rec_Type, Error_Tbl_Type, Report_Parameter_Rec_Type, and the collection type BIS_VARCHAR_TBL, which is a table of VARCHAR2(32000) indexed by BINARY_INTEGER. That specific type, the object the user searched for, is representative of the package's design: BIS_UTILITIES_PUB supplies generic, high-capacity PL/SQL structures and routines so that downstream BIS code does not have to redefine them.
Key Procedures and Functions
The package exposes 64 documented procedures and functions, grouped by purpose.
- Security and identity resolution: RETRIEVE_USER, RESOLVE_ROLE_NAME, RESOLVE_FUNCTION_NAME, RESOLVE_FULL_FUNCTION_NAME, and RESOLVE_FULL_ACTIVITY_NAME translate internal IDs and names into display-ready values for the current session.
- Organization and segment retrieval: RETRIEVE_ORGANIZATION and RETRIEVE_SEGMENT return organizational and key flexfield segment information used in reporting contexts.
- Dynamic WHERE-clause builders: RETRIEVE_WHERE_CLAUSE, RETRIEVE_ORG_WHERE_CLAUSE, RETRIEVE_TIME_WHERE_CLAUSE, and RETRIEVE_DIMX_WHERE_CLAUSE construct predicate fragments that callers concatenate into their reporting SQL.
- Predicate helpers: VALUE_MISSING, VALUE_NOT_MISSING, VALUE_NULL, and VALUE_NOT_NULL evaluate whether a supplied value is present or null, returning Boolean-style results for conditional logic.
- Presentation utilities: BUILD_HTML_BANNER, BUILD_REPORT_HEADER, GET_REPORT_TITLE, GET_IMAGES_SERVER, and GET_NLS_LANGUAGE assemble the HTML scaffolding and localization attributes for BIS report output.
Parameter lists are intentionally not reproduced here; consumers should inspect the package specification for exact signatures.
Tables Accessed
The package reads a defined set of APPS-synonym application tables and views. FND_USER supplies user identity data for RETRIEVE_USER. FND_FORM_FUNCTIONS, FND_FORM_FUNCTIONS_TL, FND_MENUS, AK_REGIONS, WF_ACTIVITIES, and WF_ACTIVITIES_TL provide the function, menu, region, and workflow activity metadata used by the RESOLVE_* routines. HR_ALL_ORGANIZATION_UNITS supports RETRIEVE_ORGANIZATION. BSC_SYS_INIT holds BIS system initialization and configuration parameters. PLITBLM and UTL_RAW support low-level string and raw-buffer manipulation within the utility routines, and V$INSTANCE provides instance-level context.
Usage Notes
BIS_UTILITIES_PUB is classified as a PUB (public) API and is referenced by 127 other packages, making it a foundational dependency rather than an entry point invoked directly by end users. It is typically called from BIS concurrent programs, Balanced Scorecard report generators, and Oracle Forms-based setup screens that require consistent organization security predicates, function-name resolution, or report header construction. Because the routines are utility-oriented and side-effect free with respect to their inputs, they are safe to invoke repeatedly within a reporting session. Custom code should call the public API rather than reference the package body, and should treat the BIS_VARCHAR_TBL collection and other declared types as the canonical shared structures for BIS development on both 12.1.1 and 12.2.2.