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_METADATA_OPTIMIZER_PKG dependencies on DBMS_SQL

Line 63: g_dropAppsTables DBMS_SQL.VARCHAR2_TABLE;

59:
60: g_retcode NUMBER :=0;
61: g_errbuf VARCHAR2(4000) := null;
62: g_processID NUMBER := 0;
63: g_dropAppsTables DBMS_SQL.VARCHAR2_TABLE;
64: VERSION VARCHAR2(10) := '5.3';
65:
66: gIndent varchar2(512):='';
67: gSpacing varchar2(10) := ' ';

Line 79: gInstalled_Languages DBMS_SQL.VARCHAR2_TABLE;

75: -- AW
76: IMPL_TYPE constant VARCHAR2(20):= 'IMPLEMENTATION_TYPE';
77:
78: /* LANGUAGES */
79: gInstalled_Languages DBMS_SQL.VARCHAR2_TABLE;
80: gNumInstalled_Languages NUMBER := 0;
81: gNLSLang VARCHAR2(30);
82: gLangCode VARCHAR2(30);
83:

Line 85: gReservedFunctions DBMS_SQL.VARCHAR2_TABLE;

81: gNLSLang VARCHAR2(30);
82: gLangCode VARCHAR2(30);
83:
84: /* RESERVED FUNCTIONS */
85: gReservedFunctions DBMS_SQL.VARCHAR2_TABLE;
86: gNumReservedFunctions NUMBER := 0;
87:
88: /* RESERVED OPERATORS */
89: gReservedOperators DBMS_SQL.VARCHAR2_TABLE;

Line 89: gReservedOperators DBMS_SQL.VARCHAR2_TABLE;

85: gReservedFunctions DBMS_SQL.VARCHAR2_TABLE;
86: gNumReservedFunctions NUMBER := 0;
87:
88: /* RESERVED OPERATORS */
89: gReservedOperators DBMS_SQL.VARCHAR2_TABLE;
90: gNumReservedOperators NUMBER := 0;
91:
92:
93: /* RESERVED WORDS */

Line 94: gArrReservedWords DBMS_SQL.VARCHAR2_TABLE;

90: gNumReservedOperators NUMBER := 0;
91:
92:
93: /* RESERVED WORDS */
94: gArrReservedWords DBMS_SQL.VARCHAR2_TABLE;
95: gNumArrReservedWords NUMBER := 0;
96:
97: gSYSTEM_STAGE varchar2(270);
98: gStorageClause varchar2(2000);

Line 224: garrOldIndicators dbms_sql.number_table;

220: PROCEDURE Documentation(
221: Errbuf out NOCOPY Varchar2,
222: Retcode out NOCOPY Varchar2);
223:
224: garrOldIndicators dbms_sql.number_table;
225: gnumOldIndicators NUMBER := 0;
226:
227: Type clsOldBTables IS RECORD(
228: Name varchar2(100),

Line 238: gBackedUpBTables DBMS_SQL.VARCHAR2_TABLE;

234: NumIndicators NUMBER);
235:
236: TYPE tab_clsOldBTables is TABLE OF clsOldBTables INDEX BY BINARY_INTEGER;
237:
238: gBackedUpBTables DBMS_SQL.VARCHAR2_TABLE;
239: garrOldBTables tab_clsOldBTables; --array that contains the bases tables of the system before process
240: gnumOldBTables NUMBER := 0;
241:
242: garrIndics dbms_sql.number_table; --array with the indicators the process will apply on.

Line 242: garrIndics dbms_sql.number_table; --array with the indicators the process will apply on.

238: gBackedUpBTables DBMS_SQL.VARCHAR2_TABLE;
239: garrOldBTables tab_clsOldBTables; --array that contains the bases tables of the system before process
240: gnumOldBTables NUMBER := 0;
241:
242: garrIndics dbms_sql.number_table; --array with the indicators the process will apply on.
243: gnumIndics NUMBER := 0;
244:
245: garrIndics4 dbms_sql.number_table; --array with the indicators with non-structural changes
246: gnumIndics4 number := 0;

Line 245: garrIndics4 dbms_sql.number_table; --array with the indicators with non-structural changes

241:
242: garrIndics dbms_sql.number_table; --array with the indicators the process will apply on.
243: gnumIndics NUMBER := 0;
244:
245: garrIndics4 dbms_sql.number_table; --array with the indicators with non-structural changes
246: gnumIndics4 number := 0;
247:
248: garrTables dbms_sql.varchar2_table; --array with the tables of the database that will be re-created.
249: gnumTables number := 0;

Line 248: garrTables dbms_sql.varchar2_table; --array with the tables of the database that will be re-created.

244:
245: garrIndics4 dbms_sql.number_table; --array with the indicators with non-structural changes
246: gnumIndics4 number := 0;
247:
248: garrTables dbms_sql.varchar2_table; --array with the tables of the database that will be re-created.
249: gnumTables number := 0;
250:
251: EDW_MATERIALIZED_VIEW_EXT constant VARCHAR2(10):= '_MV_V';
252: EDW_UNION_VIEW_EXT constant VARCHAR2(10) := '_V';

Line 376: value DBMS_SQL.number_table);

372:
373: TYPE tab_tab_String IS TABLE OF tab_string INDEX BY BINARY_INTEGER;
374:
375: TYPE number_table IS RECORD(
376: value DBMS_SQL.number_table);
377:
378: --TYPE TwoDNumberTable IS TABLE OF number_table INDEX BY BINARY_INTEGER;
379:
380: TYPE clsOriginTable IS RECORD(

Line 522: garrTablesUpgrade DBMS_SQL.VARCHAR2_TABLE; --array with the T, base and input tables used by production indicators.

518: g_Current_Adv_Sum_Level VARCHAR2(100);
519: g_Sum_Level_Change NUMBER; --0- No change
520: --1- Upgrade to new architecture (from NULL to NOT NULL)
521: --2- Just changing the sum level (Example: from 2 to 3)
522: garrTablesUpgrade DBMS_SQL.VARCHAR2_TABLE; --array with the T, base and input tables used by production indicators.
523: --This array is used only when Sum level is changed from NULL to NOTNULL
524: gnumTablesUpgrade NUMBER;
525: garrTablesUpgradeT DBMS_SQL.VARCHAR2_TABLE;
526: gnumTablesUpgradeT NUMBER;

Line 525: garrTablesUpgradeT DBMS_SQL.VARCHAR2_TABLE;

521: --2- Just changing the sum level (Example: from 2 to 3)
522: garrTablesUpgrade DBMS_SQL.VARCHAR2_TABLE; --array with the T, base and input tables used by production indicators.
523: --This array is used only when Sum level is changed from NULL to NOTNULL
524: gnumTablesUpgrade NUMBER;
525: garrTablesUpgradeT DBMS_SQL.VARCHAR2_TABLE;
526: gnumTablesUpgradeT NUMBER;
527:
528: Type clsConfigKpiMV IS RECORD(
529: LevelComb VARCHAR2(1000), --Level combination ?110