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

Line 429: l_origins DBMS_SQL.VARCHAR2_TABLE;

425: Function TableOriginExists(p_table_origins IN VARCHAR2,
426: p_table_name IN VARCHAR2) RETURN Boolean IS
427: l_table VARCHAR2(100);
428: l_count1 NUMBER;
429: l_origins DBMS_SQL.VARCHAR2_TABLE;
430: l_error VARCHAR2(1000);
431: BEGIN
432: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
433: BSC_MO_HELPER_PKG.writeTmp('Inside TableOriginExists, key_combinations = ', FND_LOG.LEVEL_PROCEDURE);

Line 489: p_BTTables IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_ClsTable) RETURN DBMS_SQL.NUMBER_TABLE IS

485: pPeriodicity IN NUMBER,
486: p_keys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
487: dataFieldGroup IN NUMBER,
488: p_impl_type IN NUMBER,
489: p_BTTables IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_ClsTable) RETURN DBMS_SQL.NUMBER_TABLE IS
490: l_table BSC_METADATA_OPTIMIZER_PKG.clsTable;
491: l_key BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
492: keysEqual Boolean;
493: i Integer;

Line 500: l_return_table DBMS_SQL.NUMBER_TABLE ;

496: l_index1 NUMBER;
497: l_index2 NUMBER;
498: l_temp NUMBER;
499: l_error VARCHAR2(1000);
500: l_return_table DBMS_SQL.NUMBER_TABLE ;
501: BEGIN
502: IF (p_BTTables.count = 0) THEN
503: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
504: BSC_MO_HELPER_PKG.writeTmp('Done with get_matching_tables, returning -1', FND_LOG.LEVEL_PROCEDURE);

Line 667: Tabla_Origin DBMS_SQL.VARCHAR2_TABLE;

663: PROCEDURE connect_i_to_b_tables IS
664: l_table BSC_METADATA_OPTIMIZER_PKG.clsTable;
665: TablaE BSC_METADATA_OPTIMIZER_PKG.clsTable;
666:
667: Tabla_Origin DBMS_SQL.VARCHAR2_TABLE;
668:
669: TablaE_Origin DBMS_SQL.VARCHAR2_TABLE;
670:
671: l_key BSC_METADATA_OPTIMIZER_PKG.clsKeyField;

Line 669: TablaE_Origin DBMS_SQL.VARCHAR2_TABLE;

665: TablaE BSC_METADATA_OPTIMIZER_PKG.clsTable;
666:
667: Tabla_Origin DBMS_SQL.VARCHAR2_TABLE;
668:
669: TablaE_Origin DBMS_SQL.VARCHAR2_TABLE;
670:
671: l_key BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
672: l_keyE BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
673: l_measure BSC_METADATA_OPTIMIZER_PKG.clsDataField;

Line 929: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;

925: --****************************************************************************
926: PROCEDURE connect_s_to_b_tables IS
927: l_table BSC_METADATA_OPTIMIZER_PKG.clsTable;
928: l_table_origin VARCHAR2(100);
929: Tabla_originTable DBMS_SQL.VARCHAR2_TABLE;
930: l_key BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
931: l_measure BSC_METADATA_OPTIMIZER_PKG.clsDataField;
932: l_origin_table VARCHAR2(300);
933: l_index1 NUMBER;

Line 1074: iMatchingTableIndex DBMS_SQL.number_table;

1070: l_table BSC_METADATA_OPTIMIZER_PKG.clsTable;
1071: uniqueField BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;
1072: l_key_combination BSC_METADATA_OPTIMIZER_PKG.clsDisaggField;
1073: l_key BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
1074: iMatchingTableIndex DBMS_SQL.number_table;
1075: l_datafield BSC_METADATA_OPTIMIZER_PKG.clsDataField;
1076: needNewTable Boolean;
1077: l_index1 NUMBER;
1078: l_index2 NUMBER;

Line 1339: l_per_origin DBMS_SQL.NUMBER_TABLE;

1335: l_index NUMBER;
1336: l_return boolean;
1337: l_index1 number;
1338: l_index2 number;
1339: l_per_origin DBMS_SQL.NUMBER_TABLE;
1340: l_dummy NUMBER;
1341: l_error varchar2(1000);
1342: BEGIN
1343: If p_key_comb_target.Periodicity <> p_key_comb_origin.Periodicity Then

Line 1417: iMatchingTableIndex DBMS_SQL.NUMBER_TABLE;

1413: uniqueField BSC_METADATA_OPTIMIZER_PKG.clsUniqueField;
1414: l_key_combination BSC_METADATA_OPTIMIZER_PKG.clsDisaggField;
1415: l_key BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
1416: toBeConsidered Boolean;
1417: iMatchingTableIndex DBMS_SQL.NUMBER_TABLE;
1418: l_origin_table VARCHAR2(300);
1419: l_measure_column BSC_METADATA_OPTIMIZER_PKG.clsDataField;
1420: needNewTable Boolean;
1421: l_unique_measures BSC_METADATA_OPTIMIZER_PKG.tab_clsUniqueField;

Line 1430: l_BTTables_origin DBMS_SQL.VARCHAR2_TABLE;

1426: l_index NUMBER;
1427: l_temp NUMBER;
1428:
1429: l_temp3 NUMBER;
1430: l_BTTables_origin DBMS_SQL.VARCHAR2_TABLE;
1431: l_tablename VARCHAR2(100);
1432: l_error VARCHAR2(1000);
1433: l_loop_ctr NUMBER:=0;
1434: bMeasureLogged boolean ;

Line 2017: Tabla_OriginTable DBMS_SQL.VARCHAR2_TABLE;

2013: l_field_index NUMBER;
2014: l_disagg_index NUMBER;
2015: l_index NUMBER;
2016:
2017: Tabla_OriginTable DBMS_SQL.VARCHAR2_TABLE;
2018:
2019: uniqueField_disAggKeys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
2020:
2021: l_stack varchar2(32000):= null;

Line 2233: Tabla_OriginTable DBMS_SQL.VARCHAR2_TABLE;

2229: l_index NUMBER := null;
2230: l_temp NUMBER;
2231: l_index2 NUMBER;
2232:
2233: Tabla_OriginTable DBMS_SQL.VARCHAR2_TABLE;
2234: l_tablename VARCHAR2(100) ;
2235: l_error VARCHAR2(1000);
2236:
2237: l_stack VARCHAR2(32000);