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

Line 301: l_indic_table DBMS_SQL.NUMBER_TABLE;

297: PeriodicityName VARCHAR2(100);
298: CalendarName VARCHAR2(100);
299: l_index1 NUMBER;
300: l_index2 NUMBER;
301: l_indic_table DBMS_SQL.NUMBER_TABLE;
302: l_fields DBMS_SQL.VARCHAR2_TABLE;
303: l_sumLevelChangedMsg VARCHAR2(1000);
304: BEGIN
305: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 302: l_fields DBMS_SQL.VARCHAR2_TABLE;

298: CalendarName VARCHAR2(100);
299: l_index1 NUMBER;
300: l_index2 NUMBER;
301: l_indic_table DBMS_SQL.NUMBER_TABLE;
302: l_fields DBMS_SQL.VARCHAR2_TABLE;
303: l_sumLevelChangedMsg VARCHAR2(1000);
304: BEGIN
305: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
306: bsc_mo_helper_pkg.writeTmp('Inside DocResult', FND_LOG.LEVEL_PROCEDURE);

Line 911: arrMvs DBMS_SQL.VARCHAR2_TABLE;

907: l_table BSC_METADATA_OPTIMIZER_PKG.clsTable;
908: l_index1 NUMBER;
909: dbObjectType VARCHAR2(106);
910: mvName VARCHAR2(100);
911: arrMvs DBMS_SQL.VARCHAR2_TABLE;
912: numMVs NUMBER := 0;
913: BEGIn
914: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
915: BSC_MO_HELPER_PKG.writeTmp('Inside WriteInputAndSystemTables', FND_LOG.LEVEL_PROCEDURE);

Line 987: PROCEDURE SetNeedCod0InOriTables(arrTablesCod0 IN DBMS_SQL.VARCHAR2_TABLE, numTablesCod0 IN NUMBER) IS

983: -- DESCRIPTION:
984: -- Mark the property NecesitaCod0 in the origin tables of the given
985: -- tables according to the the values already marked in the tables.
986: --****************************************************************************
987: PROCEDURE SetNeedCod0InOriTables(arrTablesCod0 IN DBMS_SQL.VARCHAR2_TABLE, numTablesCod0 IN NUMBER) IS
988: i NUMBER;
989: arrTablesOri DBMS_SQL.VARCHAR2_TABLE;
990: numTablesOri NUMBER;
991: TablaOri VARCHAR2(100);

Line 989: arrTablesOri DBMS_SQL.VARCHAR2_TABLE;

985: -- tables according to the the values already marked in the tables.
986: --****************************************************************************
987: PROCEDURE SetNeedCod0InOriTables(arrTablesCod0 IN DBMS_SQL.VARCHAR2_TABLE, numTablesCod0 IN NUMBER) IS
988: i NUMBER;
989: arrTablesOri DBMS_SQL.VARCHAR2_TABLE;
990: numTablesOri NUMBER;
991: TablaOri VARCHAR2(100);
992: keyColumn BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
993:

Line 1000: l_originTable DBMS_SQL.varchar2_table;

996: l_table_index_in_gTables NUMBER;
997: l_origin_index_in_gTables NUMBER;
998:
999: l_key_index NUMBER;
1000: l_originTable DBMS_SQL.varchar2_table;
1001: l_table_keys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
1002: l_origin_table_keys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
1003:
1004:

Line 1217: arrFilterDims DBMS_SQL.VARCHAR2_TABLE;

1213: Indicator NUMBER;
1214: Configuration NUMBER;
1215: TableName VARCHAR2(100);
1216: Filter_Condition VARCHAR2(4000);
1217: arrFilterDims DBMS_SQL.VARCHAR2_TABLE;
1218: numFilterDims NUMBER;
1219: TotalSign VARCHAR2(100);
1220: Level_Comb VARCHAR2(100);
1221: KeyColumn VARCHAR2(100);

Line 1223: arrTablesCod0 DBMS_SQL.VARCHAR2_TABLE;

1219: TotalSign VARCHAR2(100);
1220: Level_Comb VARCHAR2(100);
1221: KeyColumn VARCHAR2(100);
1222: i NUMBER;
1223: arrTablesCod0 DBMS_SQL.VARCHAR2_TABLE;
1224: numTablesCod0 NUMBER;
1225: Target_Flag NUMBER;
1226: l_temp NUMBER;
1227: l_temp2 NUMBER;

Line 1241: l_table_name_list dbms_sql.varchar2_table;

1237: l_edw_flag number;
1238: l_target_flag number;
1239:
1240:
1241: l_table_name_list dbms_sql.varchar2_table;
1242: l_table_type_list dbms_sql.varchar2_table;
1243: l_periodicity_id_list dbms_sql.number_table;
1244: l_edw_flag_list dbms_sql.number_table;
1245: l_target_flag_list dbms_sql.number_table;

Line 1242: l_table_type_list dbms_sql.varchar2_table;

1238: l_target_flag number;
1239:
1240:
1241: l_table_name_list dbms_sql.varchar2_table;
1242: l_table_type_list dbms_sql.varchar2_table;
1243: l_periodicity_id_list dbms_sql.number_table;
1244: l_edw_flag_list dbms_sql.number_table;
1245: l_target_flag_list dbms_sql.number_table;
1246:

Line 1243: l_periodicity_id_list dbms_sql.number_table;

1239:
1240:
1241: l_table_name_list dbms_sql.varchar2_table;
1242: l_table_type_list dbms_sql.varchar2_table;
1243: l_periodicity_id_list dbms_sql.number_table;
1244: l_edw_flag_list dbms_sql.number_table;
1245: l_target_flag_list dbms_sql.number_table;
1246:
1247: cv Curtyp;

Line 1244: l_edw_flag_list dbms_sql.number_table;

1240:
1241: l_table_name_list dbms_sql.varchar2_table;
1242: l_table_type_list dbms_sql.varchar2_table;
1243: l_periodicity_id_list dbms_sql.number_table;
1244: l_edw_flag_list dbms_sql.number_table;
1245: l_target_flag_list dbms_sql.number_table;
1246:
1247: cv Curtyp;
1248:

Line 1245: l_target_flag_list dbms_sql.number_table;

1241: l_table_name_list dbms_sql.varchar2_table;
1242: l_table_type_list dbms_sql.varchar2_table;
1243: l_periodicity_id_list dbms_sql.number_table;
1244: l_edw_flag_list dbms_sql.number_table;
1245: l_target_flag_list dbms_sql.number_table;
1246:
1247: cv Curtyp;
1248:
1249: CURSOR c2(p1 VARCHAR2) IS

Line 1285: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;

1281:
1282:
1283: Table_Keys bsc_metadata_optimizer_pkg.tab_clsKeyField;
1284: Table_Data bsc_metadata_optimizer_pkg.tab_clsDataField;
1285: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;
1286: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;
1287:
1288: l_ind_list DBMS_SQL.NUMBER_TABLE;
1289: l_table_index NUMBER;

Line 1286: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;

1282:
1283: Table_Keys bsc_metadata_optimizer_pkg.tab_clsKeyField;
1284: Table_Data bsc_metadata_optimizer_pkg.tab_clsDataField;
1285: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;
1286: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;
1287:
1288: l_ind_list DBMS_SQL.NUMBER_TABLE;
1289: l_table_index NUMBER;
1290: l_key_index NUMBER;

Line 1288: l_ind_list DBMS_SQL.NUMBER_TABLE;

1284: Table_Data bsc_metadata_optimizer_pkg.tab_clsDataField;
1285: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;
1286: Tabla_originTable1 DBMS_SQL.VARCHAR2_TABLE;
1287:
1288: l_ind_list DBMS_SQL.NUMBER_TABLE;
1289: l_table_index NUMBER;
1290: l_key_index NUMBER;
1291:
1292: BEGIN

Line 1589: l_parents_relcol DBMS_SQL.varchar2_table;

1585: i NUMBER;
1586: l_temp NUMBER;
1587: l_return number := -1;
1588:
1589: l_parents_relcol DBMS_SQL.varchar2_table;
1590: BEGIN
1591:
1592: l_temp := BSC_MO_HELPER_PKG.findIndex( BSC_METADATA_OPTIMIZER_PKG.gMasterTable, dimTable);
1593: l_parents_relcol := BSC_MO_HELPER_PKG.getDecomposedString(BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_temp).parent_rel_col, ',');

Line 1634: l_auxillaryFields DBMS_SQL.varchar2_table;

1630: --****************************************************************************
1631: Function FindAuxillaryIndex(dimTable IN VARCHAR2, CampoAuxiliar IN VARCHAR2) RETURN NUMBER IS
1632: i NUMBER;
1633: l_temp NUMBER;
1634: l_auxillaryFields DBMS_SQL.varchar2_table;
1635: BEGIN
1636:
1637: l_temp := BSC_MO_HELPER_PKG.findIndex( BSC_METADATA_OPTIMIZER_PKG.gMasterTable, dimTable);
1638:

Line 1882: l_parents DBMS_SQL.varchar2_table;

1878: TableName VARCHAR2(100);
1879: l_value VARCHAR2(1000);
1880: cv CurTyp;
1881: l_msg VARCHAR2(1000);
1882: l_parents DBMS_SQL.varchar2_table;
1883: l_COLUMN_NAME VARCHAR2(30);
1884: l_DATA_TYPE VARCHAR2(30);
1885: l_DATA_LENGTH NUMBER;
1886: l_DATA_PRECISION NUMBER;