Search Results add_value_big_in_cond

Overview

APPS.BSC_APPS is a shared PL/SQL utility package used throughout the Oracle Balanced Scorecard (BSC) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It centralizes the calls that BSC modules must make into the APPS foundation layer, providing a single point of contact for environment detection, dynamic DDL execution, lookup and message retrieval, profile-style property access, and user/schema resolution.

The package header (BSCAPPSS.pls, version 120.1, dated 2006/02/14) explains its dual-role design: it must be installed in both the Enterprise (APPS) and Personal versions of BSC. In the Personal version, dummy stub packages replace FND_INSTALLATION and AD_DDL so that BSC code can be compiled and run outside a full EBS installation. Environment awareness is established through the mandatory initialization procedure INIT_BSC_APPS, which must be called before any other routine; it populates global variables indicating whether the session is running in the APPS or Personal environment.

The package is classified as OTHER in the ETRM repository, is owned by APPS, and is referenced by 76 other packages, confirming its role as a low-level dependency rather than an end-user API.

Key Procedures and Functions

The documented routines fall into several functional groups:

• DDL execution: DO_DDL, DO_DDL_AT, DO_DDL_VB, EXECUTE_DDL, EXECUTE_DDL_STMTS_AT, and EXECUTE_IMMEDIATE provide controlled execution of dynamic SQL and DDL. The overloaded DO_DDL_AT was added in April 2004 under Bug 3541933 and is the variant that performs autonomous-transaction DDL against the APPS schema, working in conjunction with the Autonomous_Statements record type and its associated table type.
• Environment setup: APPS_INITIALIZE_VB and INIT_BSC_APPS establish application context.
• Utility retrieval: GET_LOOKUP_VALUE (added February 2002 for the HTML UI), GET_MESSAGE, GET_PROPERTY_VALUE, and SET_PROPERTY_VALUE handle lookups, message text, and configuration properties.
• Schema and storage helpers: GET_USER_SCHEMA (overloaded, added August 2003 under Bug 3008243), GET_STORAGE_CLAUSE, GET_TABLESPACE_CLAUSE_TBL, and GET_TABLESPACE_CLAUSE_IDX.
• Sequencing and validation: GET_NEW_BIG_IN_COND_NUMBER, GET_NEW_BIG_IN_COND_VARCHAR2, GET_NEW_BIG_IN_COND_VARCHAR2NU, ADD_VALUE_BIG_IN_COND, CHECKERROR, and GET_REQUEST_STATUS_VB.

Tables Accessed

The package reads and writes a defined set of APPS synonyms. Configuration and security context come from FND_USER, FND_RESPONSIBILITY, PER_ALL_PEOPLE_F, and FND_ORACLE_USERID. Diagnostic output is written to BSC_MESSAGE_LOGS. DDL management relies on AD_DDL. Metadata inspection uses ALL_TABLES, ALL_INDEXES, USER_TABLES, USER_INDEXES, USER_OBJECTS, and USER_VIEWS. PLITBLM supports PL/SQL table handling where no database table exists, V$PARAMETER supplies instance parameter values, and UTL_FILE is used for file-level operations.

Usage Notes

BSC_APPS is not intended for direct end-user invocation. It is called from BSC forms, concurrent programs, and other BSC PL/SQL packages (76 known dependents). Any custom code that calls these routines must first invoke INIT_BSC_APPS to set environment globals. Dynamic DDL should be routed through the DO_DDL* family, particularly DO_DDL_AT when autonomous commits are required, so that auditing through AD_DDL and BSC_MESSAGE_LOGS remains intact. Because the package exists in both Enterprise and Personal editions, portability between the two is preserved only when callers avoid Enterprise-specific dependencies.