Search Results bsc_apps

Overview

APPS.BSC_APPS is a VALID package body in the APPS schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Balanced Scorecard (BSC) product family, the module within Oracle EBS that provides scorecard, KPI, and strategy-management functionality. Functionally, BSC_APPS is best characterized as an internal infrastructure and utility library rather than a single business API: the ETRM record classifies its API classification as OTHER, and its documented procedure inventory consists almost entirely of helpers for dynamic DDL execution, tablespace and storage clause derivation, concurrent request submission and status checks, message and lookup retrieval, and property (profile-style) value management.

The package depends on the FND foundation layer (FND_API, FND_FILE, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, FND_REQUEST, FND_CONCURRENT, FND_INSTALLATION, FND_ORACLE_USERID, FND_RESPONSIBILITY, FND_USER, FND_USER_RESP_GROUPS) together with the DDL and data-dictionary facilities AD_DDL through APPS, AD_TSPACE_UTIL, UTL_FILE, and the USER_/ALL_ dictionary views. It is referenced by 76 other database objects, confirming its role as a shared low-level dependency across the Balanced Scorecard schema components. It is not referenced by any higher-level object outside that set.

Key Procedures and Functions

APPS_INITIALIZE_VB — initialization entry point that prepares the package session state, typically setting up the FND global context (user, responsibility, application) required by the remaining routines.
DO_DDL, DO_DDL_AT, DO_DDL_VB, EXECUTE_DDL, EXECUTE_DDL_STMTS_AT, EXECUTE_IMMEDIATE, CHECKERROR — the dynamic DDL subsystem. DO_DDL and its variants and the EXECUTE_DDL* routines build and run DDL or anonymous PL/SQL statements, including at a remote/alternative location, while CHECKERROR centralizes error detection and message construction for these operations.
GET_TABLESPACE_CLAUSE_TBL, GET_TABLESPACE_CLAUSE_IDX, GET_STORAGE_CLAUSE — return the tablespace and storage clauses used when generating tables and indexes, drawing on AD_TSPACE_UTIL and V$PARAMETER.
GET_REQUEST_STATUS_VB — returns the status of a submitted concurrent request, used to synchronize package logic with concurrent processing.
GET_LOOKUP_VALUE, GET_MESSAGE — retrieve lookup meanings and formatted messages from BSC_LOOKUPS / BSC_MESSAGES and the FND message dictionary.
GET_PROPERTY_VALUE, SET_PROPERTY_VALUE — read and write configurable property values maintained by the package.
GET_NEW_BIG_IN_COND_NUMBER, GET_NEW_BIG_IN_COND_VARCHAR2, GET_NEW_BIG_IN_COND_VARCHAR2NU, ADD_VALUE_BIG_IN_COND — construct and extend large IN-list conditions, workarounds for Oracle's 1,000-element IN-list limit used when generating dynamic SQL predicates.

Tables Accessed

The package reads and writes BSC_MESSAGE_LOGS (persisted message and error history) and references the FND security and identity tables FND_USER, FND_RESPONSIBILITY, FND_USER_RESP_GROUPS, FND_ORACLE_USERID, and PER_ALL_PEOPLE_F for user/responsibility and Oracle-schema identity resolution. DDL support objects include AD_DDL and the data-dictionary views ALL_TABLES, ALL_INDEXES, USER_TABLES, USER_INDEXES, USER_OBJECTS, USER_VIEWS, plus PLITBLM (large PL/SQL table storage), UTL_FILE (file generation), and V$PARAMETER (database parameter inspection).

Usage Notes

BSC_APPS is not intended for direct end-user invocation. It is called by Balanced Scorecard packages, concurrent programs, and internal setup/maintenance routines — any of the 76 dependent objects — to perform dynamic DDL, build IN-list predicates, resolve user context, log messages, and query concurrent request status. Customizations should call the harness APIs (for example, BSC_MESSAGE) rather than these internals, because the DDL and IN-list routines are implementation helpers whose behavior is tied to the installed schema and tablespace configuration.

PACKAGE BODY: APPS.BSC_APPS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_APPS, status:VALID,
PACKAGE BODY: APPS.BSC_BIS_PMDLDR_DELDATA 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_BIS_PMDLDR_DELDATA, status:VALID,
PACKAGE BODY: APPS.BSC_TAB_VIEW_KPI_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_TAB_VIEW_KPI_PKG, status:VALID,
SYNONYM: PUBLIC.USER_INDEXES 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:USER_INDEXES, status:VALID,
PACKAGE BODY: APPS.BSC_PERIODS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_PERIODS_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_SYS_DIMTABLES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_SYS_DIMTABLES_PKG, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_VAL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_VAL, status:VALID,
PACKAGE BODY: APPS.BSC_AOP_TPLATE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_AOP_TPLATE, status:VALID,
PACKAGE BODY: APPS.BSC_MESSAGE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_MESSAGE, status:VALID,
PACKAGE BODY: APPS.BSC_SYS_PERIODICITIES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_SYS_PERIODICITIES_PKG, status:VALID,
PACKAGE BODY: APPS.BSC_SYS_IMAGES_MAP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_SYS_IMAGES_MAP_PKG, status:VALID,
SYNONYM: APPS.BSC_MESSAGE_LOGS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BSC_MESSAGE_LOGS, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_LOG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_LOG, status:VALID,
PACKAGE BODY: APPS.BSC_BSC_XTD_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_BSC_XTD_PKG, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_SUM 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_SUM, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_LOCK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_LOCK, status:VALID,
PACKAGE BODY: APPS.BSC_SCORECARD_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_SCORECARD_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_DB_MEASURE_COLS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DB_MEASURE_COLS_PKG, status:VALID,
PACKAGE BODY: APPS.BSC_PMD_OPT_DOC_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_PMD_OPT_DOC_UTIL, status:VALID,
PACKAGE BODY: APPS.BSC_KPI_GROUP_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_KPI_GROUP_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_CUSTOM_VIEW_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_CUSTOM_VIEW_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_LAUNCH_PAD_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_LAUNCH_PAD_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_DIM_TPLATE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DIM_TPLATE, status:VALID,
PACKAGE BODY: APPS.BSC_DIMENSION_GROUPS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DIMENSION_GROUPS_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_DIMENSION_EDIT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DIMENSION_EDIT, status:VALID,
PACKAGE BODY: APPS.BSC_CUSTOM_VIEW_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_CUSTOM_VIEW_PVT, status:VALID,
PACKAGE BODY: APPS.BSC_SECURITY 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_SECURITY, status:VALID,
PACKAGE BODY: APPS.BSC_BIS_LOCKS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_BIS_LOCKS_PVT, status:VALID,
PACKAGE BODY: APPS.BSC_BIA_WRAPPER 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_BIA_WRAPPER, status:VALID,
PACKAGE BODY: APPS.BSC_OLAP_MAIN 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_OLAP_MAIN, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_CALC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_CALC, status:VALID,
PACKAGE BODY: APPS.BSC_DIMENSION_LEVELS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DIMENSION_LEVELS_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_DIM_FILTERS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DIM_FILTERS_PVT, status:VALID,
PACKAGE: APPS.BSC_APPS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:BSC_APPS, status:VALID,
PACKAGE BODY: APPS.BSC_DBGEN_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DBGEN_UTILS, status:VALID,
PACKAGE BODY: APPS.BSC_DBGEN_METADATA_READER 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DBGEN_METADATA_READER, status:VALID,
PACKAGE BODY: APPS.BSC_IM_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_IM_UTILS, status:VALID,
PACKAGE BODY: APPS.BSC_LAUNCH_PAD_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_LAUNCH_PAD_PVT, status:VALID,
PACKAGE BODY: APPS.BSC_DBGEN_BSC_READER 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DBGEN_BSC_READER, status:VALID,
PACKAGE BODY: APPS.BSC_BIS_LOCKS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_BIS_LOCKS_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_BASE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_BASE, status:VALID,
PACKAGE BODY: APPS.BSC_MO_DOC_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_MO_DOC_PKG, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_COLOR 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_COLOR, status:VALID,
PACKAGE BODY: APPS.BSC_TEMPLATE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_TEMPLATE, status:VALID,
PACKAGE BODY: APPS.BSC_LOCKS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_LOCKS_PVT, status:VALID,
PACKAGE BODY: APPS.BSC_DIMENSION_SETS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DIMENSION_SETS_PUB, status:VALID,
PACKAGE BODY: APPS.BSC_DIMENSION_LEVELS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_DIMENSION_LEVELS_PVT, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_INC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_INC, status:VALID,
VIEW: APPS.BSC_DB_COLOR_MEASURES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BSC.BSC_DB_COLOR_MEASURES_V, object_name:BSC_DB_COLOR_MEASURES_V, status:VALID,
PACKAGE BODY: APPS.BSC_UPDATE_BASE_V2 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BSC_UPDATE_BASE_V2, status:VALID,