APPS.BSC_MO_UI_PKG dependencies on DBMS_SQL

Line 31: arrNewTables dbms_sql.varchar2_table;

27: --****************************************************************************/
28:
29: PROCEDURE InsertRelatedTables(numTables IN NUMBER) IS
30:
31: arrNewTables dbms_sql.varchar2_table;
32: numNewTables number := 0;
33: strWhereInNewTables varchar2(1000);
34: strWhereNotInNewTables varchar2(1000);
35: l_stmt varchar2(1000);

Line 202: arrMeasuresCols DBMS_SQL.VARCHAR2_TABLE;

198: strWhereInIndics Varchar2(1000);
199: strWhereNotInIndics Varchar2(1000);
200: strWhereInMeasures Varchar2(1000);
201: i NUMBER := 0;
202: arrMeasuresCols DBMS_SQL.VARCHAR2_TABLE;
203: numMeasures NUMBER;
204: arrRelatedMeasuresIds DBMS_SQL.NUMBER_TABLE;
205:
206: --measureCol Varchar2(1000);

Line 204: arrRelatedMeasuresIds DBMS_SQL.NUMBER_TABLE;

200: strWhereInMeasures Varchar2(1000);
201: i NUMBER := 0;
202: arrMeasuresCols DBMS_SQL.VARCHAR2_TABLE;
203: numMeasures NUMBER;
204: arrRelatedMeasuresIds DBMS_SQL.NUMBER_TABLE;
205:
206: --measureCol Varchar2(1000);
207: Operands DBMS_SQL.VARCHAR2_TABLE;
208: NumOperands NUMBER;

Line 207: Operands DBMS_SQL.VARCHAR2_TABLE;

203: numMeasures NUMBER;
204: arrRelatedMeasuresIds DBMS_SQL.NUMBER_TABLE;
205:
206: --measureCol Varchar2(1000);
207: Operands DBMS_SQL.VARCHAR2_TABLE;
208: NumOperands NUMBER;
209:
210: l_measureID NUMBER;
211: l_measureCol VARCHAR2(500);

Line 734: l_groupids DBMS_SQL.NUMBER_TABLE;

730:
731: PROCEDURE insert_dimension_set (--pReturnArray IN OUT tab_clsIndicatorLevels,
732: pIndicator IN NUMBER, p_set IN NUMBER,
733: p_levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels ) IS
734: l_groupids DBMS_SQL.NUMBER_TABLE;
735: l_dim_index NUMBER;
736:
737: l_level_index NUMBER :=0 ;
738: l_stmt VARCHAR2(300) := ' INSERT INTO BSC_TMP_OPT_UI_LEVELS (INDICATOR, DIM_SET_ID, DIM_DISPLAY_ORDER, LEVEL_DISPLAY_ORDER, LEVEL_TABLE_NAME, LEVEL_DISPLAY_NAME) '||

Line 773: colConfigurations DBMS_SQL.NUMBER_TABLE;

769: PROCEDURE GetLevelsForIndicator(pIndicator IN NUMBER) IS -- RETURN tab_clsIndicatorLevels IS
770: l_stmt VARCHAR2(1000);
771: l_count NUMBER;
772: l_levels BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels ;
773: colConfigurations DBMS_SQL.NUMBER_TABLE;
774: l_config_index NUMBER;
775: l_insert_count NUMBER := 0;
776: cv CurTyp;
777: BEGIN