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

Line 21: l_origin_table DBMS_SQL.VARCHAR2_TABLE;

17: Function isBasicTable(p_table_name IN VARCHAR2) RETURN Boolean IS
18: l_temp NUMBER;
19: l_temp2 NUMBER;
20:
21: l_origin_table DBMS_SQL.VARCHAR2_TABLE;
22:
23: l_origin_name VARCHAR2(100);
24: CURSOR cTableType IS
25: select count(1)

Line 89: l_groups DBMS_SQL.NUMBER_TABLE;

85: l_levels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
86: l_level BSC_METADATA_OPTIMIZER_PKG.clsLevels;
87: l_index1 NUMBER;
88: l_index2 NUMBER;
89: l_groups DBMS_SQL.NUMBER_TABLE;
90: BEGIN
91: posicion := 0;
92: IF (colDimensions.count =0 ) THEN
93: return posicion;

Line 137: arrPhantomLevels IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE) RETURN NUMBER IS

133: -- arrPhantomLevels(): array to return phantom drills
134: --****************************************************************************
135: Function GetPhantomLevels(pIndicator IN NUMBER,
136: Configuracion IN NUMBER,
137: arrPhantomLevels IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE) RETURN NUMBER IS
138: numPhantomLevels NUMBER;
139: l_stmt VARCHAR2(1000);
140:
141: l_level NUMBER;

Line 174: colConfiguraciones DBMS_SQL.NUMBER_TABLE ;

170: --****************************************************************************
171: PROCEDURE Corrections IS
172:
173: Indicator BSC_METADATA_OPTIMIZER_PKG.clsIndicator;
174: colConfiguraciones DBMS_SQL.NUMBER_TABLE ;
175: Configuracion NUMBER;
176: colDimensions BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels;
177: l_stmt VARCHAR2(1000);
178: numPhantomLevels NUMBER;

Line 179: arrPhantomLevels DBMS_SQL.NUMBER_TABLE;

175: Configuracion NUMBER;
176: colDimensions BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels;
177: l_stmt VARCHAR2(1000);
178: numPhantomLevels NUMBER;
179: arrPhantomLevels DBMS_SQL.NUMBER_TABLE;
180: i NUMBER;
181: strDriles VARCHAR2(1000);
182: strDrilesAnt VARCHAR2(1000);
183: levelPos NUMBER;

Line 389: arrIndicTables IN DBMS_SQL.VARCHAR2_TABLE,

385: -- 3 - Indicator table (lowest level)
386: -- 4 - Indicator table (summary level)
387: --****************************************************************************
388: Function GetIndicTableType(TableName IN VARCHAR2,
389: arrIndicTables IN DBMS_SQL.VARCHAR2_TABLE,
390: numIndicTables IN NUMBER) RETURN NUMBER IS
391: l_table_name VARCHAR2(100);
392: l_table_type NUMBER;
393: CURSOR c1(p1 VARCHAR2) IS

Line 436: PROCEDURE InsertOriginTables(arrTables IN DBMS_SQL.VARCHAR2_TABLE ,

432: -- Insert in the arry arrOriginTables() all the tables in the graph
433: -- where the tables in the array arrTables() come from, including
434: -- themself.
435: --****************************************************************************
436: PROCEDURE InsertOriginTables(arrTables IN DBMS_SQL.VARCHAR2_TABLE ,
437: arrOriginTables IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
438: ) IS
439:
440: arrTablesAux DBMS_SQL.VARCHAR2_TABLE;

Line 437: arrOriginTables IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

433: -- where the tables in the array arrTables() come from, including
434: -- themself.
435: --****************************************************************************
436: PROCEDURE InsertOriginTables(arrTables IN DBMS_SQL.VARCHAR2_TABLE ,
437: arrOriginTables IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
438: ) IS
439:
440: arrTablesAux DBMS_SQL.VARCHAR2_TABLE;
441: l_stmt VARCHAR2(2000) := null;

Line 440: arrTablesAux DBMS_SQL.VARCHAR2_TABLE;

436: PROCEDURE InsertOriginTables(arrTables IN DBMS_SQL.VARCHAR2_TABLE ,
437: arrOriginTables IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
438: ) IS
439:
440: arrTablesAux DBMS_SQL.VARCHAR2_TABLE;
441: l_stmt VARCHAR2(2000) := null;
442:
443: l_table VARCHAR2(100);
444: l_index NUMBER;

Line 448: l_varchar2_list dbms_sql.varchar2_table;

444: l_index NUMBER;
445: cv CurTyp ;
446:
447: strWhereInTables VARCHAR2(1000);
448: l_varchar2_list dbms_sql.varchar2_table;
449: BEGIN
450: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
451: BSC_MO_HELPER_PKG.writeTmp('Inside InsertOriginTables, arrTables.count = '||arrTables.count);
452: END IF;

Line 507: arrTables OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE, numTables OUT NOCOPY NUMBER,

503: -- Also initializes arrTables() with the tables being used directly
504: -- by the indicator and all related tables until the input tables.
505: --****************************************************************************
506: PROCEDURE InitarrTablesIndic(Indic IN NUMBER, Configuration IN NUMBER,
507: arrTables OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE, numTables OUT NOCOPY NUMBER,
508: arrIndicTables OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE, numIndicTables OUT NOCOPY NUMBER) IS
509:
510: l_STMT VARCHAR2(1000);
511: CURSOR C1 (p1 NUMBER, p2 NUMBER) IS

Line 508: arrIndicTables OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE, numIndicTables OUT NOCOPY NUMBER) IS

504: -- by the indicator and all related tables until the input tables.
505: --****************************************************************************
506: PROCEDURE InitarrTablesIndic(Indic IN NUMBER, Configuration IN NUMBER,
507: arrTables OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE, numTables OUT NOCOPY NUMBER,
508: arrIndicTables OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE, numIndicTables OUT NOCOPY NUMBER) IS
509:
510: l_STMT VARCHAR2(1000);
511: CURSOR C1 (p1 NUMBER, p2 NUMBER) IS
512: SELECT DISTINCT TABLE_NAME FROM BSC_KPI_DATA_TABLES_V

Line 605: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;

601: Tabla BSC_METADATA_OPTIMIZER_PKG.clsTable,
602: PeriodicityOrigin IN NUMBER,
603: p_projection OUT NOCOPY NUMBER,
604: p_gen_type OUT NOCOPY NUMBER) IS
605: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;
606: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;
607: l_index2 number;
608: l_temp number;
609: l_table_origin VARCHAR2(100);

Line 606: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;

602: PeriodicityOrigin IN NUMBER,
603: p_projection OUT NOCOPY NUMBER,
604: p_gen_type OUT NOCOPY NUMBER) IS
605: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;
606: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;
607: l_index2 number;
608: l_temp number;
609: l_table_origin VARCHAR2(100);
610:

Line 681: PROCEDURE add_dependant_tables(p_del_s_tables IN dbms_sql.varchar2_table, p_del_tables IN OUT NOCOPY dbms_sql.varchar2_table )is

677: raise;
678:
679: END;
680:
681: PROCEDURE add_dependant_tables(p_del_s_tables IN dbms_sql.varchar2_table, p_del_tables IN OUT NOCOPY dbms_sql.varchar2_table )is
682:
683: l_dummy varchar2(1000);
684:
685: cursor MissingSTables IS

Line 731: arrZeroCodeKeys DBMS_SQL.VARCHAR2_TABLE;

727: l_stmt VARCHAR2(1000);
728: Indicator BSC_METADATA_OPTIMIZER_PKG.clsIndicator;
729: l_generation_type NUMBER := 0;
730: projection NUMBER := 0;
731: arrZeroCodeKeys DBMS_SQL.VARCHAR2_TABLE;
732: numZeroCodeKeys NUMBER := 0;
733: l_prj_method NUMBER := 0;
734: ZeroCodeOrigin VARCHAR2(300);
735: Periodo_Act NUMBER := 0;

Line 756: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;

752: l_index3 NUMBER := 0;
753: l_temp NUMBER := 0;
754: l_tempv varchar2(1000);
755:
756: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;
757: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;
758: Tabla_keyName BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
759: Tabla_Data BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
760:

Line 757: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;

753: l_temp NUMBER := 0;
754: l_tempv varchar2(1000);
755:
756: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;
757: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;
758: Tabla_keyName BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
759: Tabla_Data BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
760:
761: l_dump DBMS_SQL.VARCHAR2_TABLE;

Line 761: l_dump DBMS_SQL.VARCHAR2_TABLE;

757: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;
758: Tabla_keyName BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
759: Tabla_Data BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
760:
761: l_dump DBMS_SQL.VARCHAR2_TABLE;
762: l_dumpcount NUMBER := 0;
763:
764: -- Added 08/23/2005 for performance bug 4559323
765: l_tbl_delete dbms_sql.varchar2_table;

Line 765: l_tbl_delete dbms_sql.varchar2_table;

761: l_dump DBMS_SQL.VARCHAR2_TABLE;
762: l_dumpcount NUMBER := 0;
763:
764: -- Added 08/23/2005 for performance bug 4559323
765: l_tbl_delete dbms_sql.varchar2_table;
766: l_tblrels_table_name dbms_sql.varchar2_table;
767: l_tblrels_src_table_name dbms_sql.varchar2_table;
768: l_tblrels_relation_type dbms_sql.number_table;
769:

Line 766: l_tblrels_table_name dbms_sql.varchar2_table;

762: l_dumpcount NUMBER := 0;
763:
764: -- Added 08/23/2005 for performance bug 4559323
765: l_tbl_delete dbms_sql.varchar2_table;
766: l_tblrels_table_name dbms_sql.varchar2_table;
767: l_tblrels_src_table_name dbms_sql.varchar2_table;
768: l_tblrels_relation_type dbms_sql.number_table;
769:
770: TYPE tab_clsRels IS TABLE OF BSC_DB_TABLES_RELS%ROWTYPE index by binary_integer;

Line 767: l_tblrels_src_table_name dbms_sql.varchar2_table;

763:
764: -- Added 08/23/2005 for performance bug 4559323
765: l_tbl_delete dbms_sql.varchar2_table;
766: l_tblrels_table_name dbms_sql.varchar2_table;
767: l_tblrels_src_table_name dbms_sql.varchar2_table;
768: l_tblrels_relation_type dbms_sql.number_table;
769:
770: TYPE tab_clsRels IS TABLE OF BSC_DB_TABLES_RELS%ROWTYPE index by binary_integer;
771: l_rels_record BSC_DB_TABLES_RELS%ROWTYPE ;

Line 768: l_tblrels_relation_type dbms_sql.number_table;

764: -- Added 08/23/2005 for performance bug 4559323
765: l_tbl_delete dbms_sql.varchar2_table;
766: l_tblrels_table_name dbms_sql.varchar2_table;
767: l_tblrels_src_table_name dbms_sql.varchar2_table;
768: l_tblrels_relation_type dbms_sql.number_table;
769:
770: TYPE tab_clsRels IS TABLE OF BSC_DB_TABLES_RELS%ROWTYPE index by binary_integer;
771: l_rels_record BSC_DB_TABLES_RELS%ROWTYPE ;
772: l_tab_rels tab_clsRels;

Line 786: l_db_calc_1_delete dbms_sql.varchar2_table;

782: TYPE tab_clsDBTablesCols IS TABLE OF BSC_DB_TABLES_COLS%ROWTYPE index by binary_integer;
783: l_db_tables_cols_record BSC_DB_TABLES_COLS%ROWTYPE ;
784: l_tab_db_tables_cols tab_clsDBTablesCols;
785:
786: l_db_calc_1_delete dbms_sql.varchar2_table;
787:
788: l_db_cols_1_delete_table_name dbms_sql.varchar2_table;
789: l_db_cols_1_delete_field_name dbms_sql.varchar2_table;
790:

Line 788: l_db_cols_1_delete_table_name dbms_sql.varchar2_table;

784: l_tab_db_tables_cols tab_clsDBTablesCols;
785:
786: l_db_calc_1_delete dbms_sql.varchar2_table;
787:
788: l_db_cols_1_delete_table_name dbms_sql.varchar2_table;
789: l_db_cols_1_delete_field_name dbms_sql.varchar2_table;
790:
791: l_calc4 number := 4;
792: l_calc5 number := 5;

Line 789: l_db_cols_1_delete_field_name dbms_sql.varchar2_table;

785:
786: l_db_calc_1_delete dbms_sql.varchar2_table;
787:
788: l_db_cols_1_delete_table_name dbms_sql.varchar2_table;
789: l_db_cols_1_delete_field_name dbms_sql.varchar2_table;
790:
791: l_calc4 number := 4;
792: l_calc5 number := 5;
793: l_colP varchar2(1) := 'P';

Line 796: l_dep_tables dbms_sql.varchar2_table;

792: l_calc5 number := 5;
793: l_colP varchar2(1) := 'P';
794: l_colA varchar2(1) := 'A';
795:
796: l_dep_tables dbms_sql.varchar2_table;
797: l_del_s_tables dbms_sql.varchar2_table;
798: BEGIN
799: --
800: IF (BSC_METADATA_OPTIMIZER_PKG.gTables.count =0) THEN

Line 797: l_del_s_tables dbms_sql.varchar2_table;

793: l_colP varchar2(1) := 'P';
794: l_colA varchar2(1) := 'A';
795:
796: l_dep_tables dbms_sql.varchar2_table;
797: l_del_s_tables dbms_sql.varchar2_table;
798: BEGIN
799: --
800: IF (BSC_METADATA_OPTIMIZER_PKG.gTables.count =0) THEN
801: return;

Line 1325: arrTables DBMS_SQL.VARCHAR2_TABLE;

1321: --
1322: --****************************************************************************
1323:
1324: PROCEDURE ReConfigureUploadFieldsIndic(Indic IN NUMBER) IS
1325: arrTables DBMS_SQL.VARCHAR2_TABLE;
1326: numTables NUMBER;
1327: arrIndicTables DBMS_SQL.VARCHAR2_TABLE;
1328: numIndicTables NUMBER;
1329: colDatos BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;

Line 1327: arrIndicTables DBMS_SQL.VARCHAR2_TABLE;

1323:
1324: PROCEDURE ReConfigureUploadFieldsIndic(Indic IN NUMBER) IS
1325: arrTables DBMS_SQL.VARCHAR2_TABLE;
1326: numTables NUMBER;
1327: arrIndicTables DBMS_SQL.VARCHAR2_TABLE;
1328: numIndicTables NUMBER;
1329: colDatos BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
1330: l_measure BSC_METADATA_OPTIMIZER_PKG.clsDataField;
1331: i NUMBER;

Line 1336: colConfiguraciones DBMS_SQL.NUMBER_TABLE;

1332: l_table_origin VARCHAR2(100);
1333: l_table_type NUMBER;
1334: l_stmt VARCHAR2(1000);
1335:
1336: colConfiguraciones DBMS_SQL.NUMBER_TABLE;
1337: Configuracion Number;
1338: newColumnFlag Boolean;
1339: ZeroCodeOrigin VARCHAR2(1000);
1340: l_source VARCHAR2(1000);