eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MO_HELPER_PKG dependencies on DBMS_SQL

Line 4: g_stack dbms_sql.varchar2_table;

1: Package BSC_MO_HELPER_PKG AS
2: /* $Header: BSCMOHPS.pls 120.9.12000000.2 2007/04/24 05:32:27 amitgupt ship $ */
3:
4: g_stack dbms_sql.varchar2_table;
5: g_stack_index number :=0;
6: g_stack_length number :=0;
7:
8:

Line 20: Function GetFieldExpression(FieldExpresion IN OUT NOCOPY dbms_sql.varchar2_table, Expresion IN VARCHAR2)

16: FUNCTION getStorageClause RETURN VARCHAR2 ;
17:
18: PROCEDURE MarkIndicsForNonStrucChanges;
19: --Procedure MarkIndicsAndTables;
20: Function GetFieldExpression(FieldExpresion IN OUT NOCOPY dbms_sql.varchar2_table, Expresion IN VARCHAR2)
21: return NUMBER;
22: FUNCTION get_time RETURN VARCHAR2;
23:
24: PROCEDURE addStack(pStack IN OUT NOCOPY VARCHAR2, pMsg IN VARCHAR2);

Line 50: Function searchStringExists(arrStr dbms_sql.varchar2_table, Num number, str varchar2) return boolean;

46:
47: PROCEDURE InitInfoOldSystem;
48:
49:
50: Function searchStringExists(arrStr dbms_sql.varchar2_table, Num number, str varchar2) return boolean;
51: PROCEDURE deletePreviousRunTables;
52: Function DBObjectExists(ObjectName IN VARCHAR2)return boolean ;
53:
54: Procedure CheckAllIndicsHaveSystem;

Line 62: Function FindIndexVARCHAR2(arrStr IN dbms_sql.varchar2_table, str IN VARCHAR2) return NUMBER;

58:
59:
60: FUNCTION IsNumber (str IN VARCHAR2) RETURN BOOLEAN ;
61:
62: Function FindIndexVARCHAR2(arrStr IN dbms_sql.varchar2_table, str IN VARCHAR2) return NUMBER;
63: Function FindIndex(arrNum IN dbms_sql.NUMBER_TABLE, num IN NUMBER) RETURN NUMBER;
64: Function FindIndex(arrstr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, findThis in varchar2) return NUMBER ;
65: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, findThis in varchar2) return NUMBER;
66: Function FindKeyIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, keyName in varchar2) return NUMBER;

Line 63: Function FindIndex(arrNum IN dbms_sql.NUMBER_TABLE, num IN NUMBER) RETURN NUMBER;

59:
60: FUNCTION IsNumber (str IN VARCHAR2) RETURN BOOLEAN ;
61:
62: Function FindIndexVARCHAR2(arrStr IN dbms_sql.varchar2_table, str IN VARCHAR2) return NUMBER;
63: Function FindIndex(arrNum IN dbms_sql.NUMBER_TABLE, num IN NUMBER) RETURN NUMBER;
64: Function FindIndex(arrstr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField, findThis in varchar2) return NUMBER ;
65: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, findThis in varchar2) return NUMBER;
66: Function FindKeyIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsMasterTable, keyName in varchar2) return NUMBER;
67: Function FindIndex(arrStr IN BSC_METADATA_OPTIMIZER_PKG.tab_clsTable, findThis in varchar2) return NUMBER;

Line 90: FUNCTION decomposeString(p_string IN VARCHAR2, p_separator IN VARCHAR2, p_return_array OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)

86: Procedure backup_b_table(p_table IN VARCHAR2);
87: --PROCEDURE InitReservedFunctions;
88: PROCEDURE InitLOV ;
89:
90: FUNCTION decomposeString(p_string IN VARCHAR2, p_separator IN VARCHAR2, p_return_array OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)
91: return NUMBER ;
92: FUNCTION decomposeStringtoNumber(p_string IN VARCHAR2, p_separator IN VARCHAR2) return DBMS_SQL.NUMBER_TABLE;
93: Function searchNumberExists(arrStr dbms_sql.number_table, Num number, l_findThis NUMBER)
94: return Boolean;

Line 92: FUNCTION decomposeStringtoNumber(p_string IN VARCHAR2, p_separator IN VARCHAR2) return DBMS_SQL.NUMBER_TABLE;

88: PROCEDURE InitLOV ;
89:
90: FUNCTION decomposeString(p_string IN VARCHAR2, p_separator IN VARCHAR2, p_return_array OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)
91: return NUMBER ;
92: FUNCTION decomposeStringtoNumber(p_string IN VARCHAR2, p_separator IN VARCHAR2) return DBMS_SQL.NUMBER_TABLE;
93: Function searchNumberExists(arrStr dbms_sql.number_table, Num number, l_findThis NUMBER)
94: return Boolean;
95:
96: Function table_column_exists(p_table IN VARCHAR2, p_Column IN VARCHAR2) RETURN boolean;

Line 93: Function searchNumberExists(arrStr dbms_sql.number_table, Num number, l_findThis NUMBER)

89:
90: FUNCTION decomposeString(p_string IN VARCHAR2, p_separator IN VARCHAR2, p_return_array OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)
91: return NUMBER ;
92: FUNCTION decomposeStringtoNumber(p_string IN VARCHAR2, p_separator IN VARCHAR2) return DBMS_SQL.NUMBER_TABLE;
93: Function searchNumberExists(arrStr dbms_sql.number_table, Num number, l_findThis NUMBER)
94: return Boolean;
95:
96: Function table_column_exists(p_table IN VARCHAR2, p_Column IN VARCHAR2) RETURN boolean;
97: PROCEDURE InitializeYear ;

Line 127: PROCEDURE write_this (pTable IN DBMS_SQL.VARCHAR2_TABLE,

123: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);
124: PROCEDURE write_this (pTable IN BSC_METADATA_OPTIMIZER_PKG.clsConfigKpiMV ,
125: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false);
126:
127: PROCEDURE write_this (pTable IN DBMS_SQL.VARCHAR2_TABLE,
128: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
129: pForce IN boolean default false);
130: PROCEDURE write_this (pTable IN DBMS_SQL.NUMBER_TABLE,
131: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

Line 130: PROCEDURE write_this (pTable IN DBMS_SQL.NUMBER_TABLE,

126:
127: PROCEDURE write_this (pTable IN DBMS_SQL.VARCHAR2_TABLE,
128: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
129: pForce IN boolean default false);
130: PROCEDURE write_this (pTable IN DBMS_SQL.NUMBER_TABLE,
131: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
132: pForce IN boolean default false);
133: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.clsAuxillaryField, ind IN NUMBER default null, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);
134: --PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsAuxillaryField, pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT);

Line 359: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;

355:
356: FUNCTION get_tab_clsLevels (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
357: FUNCTION get_tab_clsLevelCombinations (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
358:
359: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;
360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;
361:
362:
363: /*PROCEDURE insertBasicTable( pTable BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,

Line 360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;

356: FUNCTION get_tab_clsLevels (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
357: FUNCTION get_tab_clsLevelCombinations (Coll IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations, group_id IN NUMBER) RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
358:
359: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) RETURN DBMS_SQL.NUMBER_TABLE ;
360: FUNCTION getGroupIds (levels IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevelCombinations) RETURN DBMS_SQL.NUMBER_TABLE;
361:
362:
363: /*PROCEDURE insertBasicTable( pTable BSC_METADATA_OPTIMIZER_PKG.clsBasicTable,
364: pKeys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,

Line 368: FUNCTION consolidateString (pTable IN DBMS_SQL.VARCHAR2_TABLE, pSeparator IN VARCHAR2) RETURN VARCHAR2;

364: pKeys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
365: pData BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField);
366: */
367:
368: FUNCTION consolidateString (pTable IN DBMS_SQL.VARCHAR2_TABLE, pSeparator IN VARCHAR2) RETURN VARCHAR2;
369:
370: FUNCTION getDecomposedString(p_string IN VARCHAR2, p_separator IN VARCHAR2) RETURN
371: DBMS_SQL.VARCHAR2_TABLE ;
372:

Line 371: DBMS_SQL.VARCHAR2_TABLE ;

367:
368: FUNCTION consolidateString (pTable IN DBMS_SQL.VARCHAR2_TABLE, pSeparator IN VARCHAR2) RETURN VARCHAR2;
369:
370: FUNCTION getDecomposedString(p_string IN VARCHAR2, p_separator IN VARCHAR2) RETURN
371: DBMS_SQL.VARCHAR2_TABLE ;
372:
373: PROCEDURE add_tabrec_clsLevels(
374: pInput IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
375: pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels,

Line 439: PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.VARCHAR2_TABLE) ;

435: Function Get_New_Big_In_Cond_Varchar2( x_variable_id in number, x_column_name in varchar2) return VARCHAR2 ;
436: Function Get_New_Big_In_Cond_Number( x_variable_id IN NUMBER, x_column_name IN VARCHAR2) return VARCHAR2 ;
437: PROCEDURE Add_Value_Big_In_Cond_Varchar2(x_variable_id IN NUMBER, x_value IN VARCHAR2) ;
438: PROCEDURE Add_Value_Big_In_Cond_Number(x_variable_id IN NUMBER, x_value IN NUMBER);
439: PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.VARCHAR2_TABLE) ;
440: PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.NUMBER_TABLE);
441:
442: PROCEDURE InsertRelatedTables(arrTables in dbms_Sql.varchar2_table, numTables in number) ;
443:

Line 440: PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.NUMBER_TABLE);

436: Function Get_New_Big_In_Cond_Number( x_variable_id IN NUMBER, x_column_name IN VARCHAR2) return VARCHAR2 ;
437: PROCEDURE Add_Value_Big_In_Cond_Varchar2(x_variable_id IN NUMBER, x_value IN VARCHAR2) ;
438: PROCEDURE Add_Value_Big_In_Cond_Number(x_variable_id IN NUMBER, x_value IN NUMBER);
439: PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.VARCHAR2_TABLE) ;
440: PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.NUMBER_TABLE);
441:
442: PROCEDURE InsertRelatedTables(arrTables in dbms_Sql.varchar2_table, numTables in number) ;
443:
444:

Line 442: PROCEDURE InsertRelatedTables(arrTables in dbms_Sql.varchar2_table, numTables in number) ;

438: PROCEDURE Add_Value_Big_In_Cond_Number(x_variable_id IN NUMBER, x_value IN NUMBER);
439: PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.VARCHAR2_TABLE) ;
440: PROCEDURE Add_Value_Bulk(x_variable_id IN NUMBER, x_value IN DBMS_SQL.NUMBER_TABLE);
441:
442: PROCEDURE InsertRelatedTables(arrTables in dbms_Sql.varchar2_table, numTables in number) ;
443:
444:
445: PROCEDURE write_this(pTable IN BSC_METADATA_OPTIMIZER_PKG.tab_clsDisAggField, ind IN NUMBER default null,
446: pSeverity IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT, pForce IN boolean default false) ;

Line 460: PROCEDURE implement_aws(p_objectives in dbms_Sql.varchar2_table) ;

456:
457: PROCEDURE drop_unused_columns(p_drop_tables_sql IN VARCHAR2);
458:
459: PROCEDURE load_reporting_calendars ;
460: PROCEDURE implement_aws(p_objectives in dbms_Sql.varchar2_table) ;
461:
462:
463: FUNCTION validate_dimension_views return BOOLEAN;
464: FUNCTION generate_index_name(p_table_name IN VARCHAR2,