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

Line 115: l_groups DBMS_SQL.NUMBER_TABLE;

111: DimensionLevels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
112: Dril BSC_METADATA_OPTIMIZER_PKG.clsLevels;
113: i NUMBER;
114:
115: l_groups DBMS_SQL.NUMBER_TABLE;
116: l_group_id NUMBER;
117:
118: BEGIN
119: IF (p_dimension_families.count =0) THEN

Line 154: RETURN DBMS_SQL.VARCHAR2_TABLE IS

150:
151: FUNCTION get_n_parents(p_s_table IN VARCHAR2,
152: p_s_table_list BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable,
153: p_level_num IN NUMBER)
154: RETURN DBMS_SQL.VARCHAR2_TABLE IS
155: l_level NUMBER;
156: sourceTable VARCHAR2(100);
157: l_index NUMBER;
158: l_table_name VARCHAR2(400);

Line 159: l_n_parents DBMS_SQL.VARCHAR2_TABLE ;

155: l_level NUMBER;
156: sourceTable VARCHAR2(100);
157: l_index NUMBER;
158: l_table_name VARCHAR2(400);
159: l_n_parents DBMS_SQL.VARCHAR2_TABLE ;
160: BEGIN
161: l_n_parents(0) := p_s_table;
162: l_table_name := p_s_table;
163: FOR i IN 1..p_level_num LOOP

Line 186: p_join_level OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

182: --
183: PROCEDURE find_join_betweens_levels(p_key IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField,
184: p_zmv_key IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField,
185: p_dimensions IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
186: p_join_level OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
187: p_join_parent OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
188: p_join_parent_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)
189: IS
190: cursor cJoin (p_indicator NUMBER, p_dimset NUMBER, p_level_name VARCHAR2) IS

Line 187: p_join_parent OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

183: PROCEDURE find_join_betweens_levels(p_key IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField,
184: p_zmv_key IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField,
185: p_dimensions IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
186: p_join_level OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
187: p_join_parent OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
188: p_join_parent_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)
189: IS
190: cursor cJoin (p_indicator NUMBER, p_dimset NUMBER, p_level_name VARCHAR2) IS
191: select distinct levels.level_table_name child_level, parent_levels.level_table_name parent_level,

Line 188: p_join_parent_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)

184: p_zmv_key IN BSC_METADATA_OPTIMIZER_PKG.clsKeyField,
185: p_dimensions IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
186: p_join_level OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
187: p_join_parent OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
188: p_join_parent_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE)
189: IS
190: cursor cJoin (p_indicator NUMBER, p_dimset NUMBER, p_level_name VARCHAR2) IS
191: select distinct levels.level_table_name child_level, parent_levels.level_table_name parent_level,
192: relation_col parent_fk, level

Line 242: p_zero_code_states IN DBMS_SQL.NUMBER_TABLE,

238: END;
239:
240: PROCEDURE get_join_info(p_keys IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
241: p_zmv_keys IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
242: p_zero_code_states IN DBMS_SQL.NUMBER_TABLE,
243: p_dimensions IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
244: p_join_dimensions OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
245: p_join_parents OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
246: p_join_dimension_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

Line 244: p_join_dimensions OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

240: PROCEDURE get_join_info(p_keys IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
241: p_zmv_keys IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
242: p_zero_code_states IN DBMS_SQL.NUMBER_TABLE,
243: p_dimensions IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
244: p_join_dimensions OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
245: p_join_parents OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
246: p_join_dimension_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
247: p_zmv_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE) IS
248: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;

Line 245: p_join_parents OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

241: p_zmv_keys IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
242: p_zero_code_states IN DBMS_SQL.NUMBER_TABLE,
243: p_dimensions IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
244: p_join_dimensions OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
245: p_join_parents OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
246: p_join_dimension_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
247: p_zmv_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE) IS
248: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
249: l_join_parent DBMS_SQL.VARCHAR2_TABLE;

Line 246: p_join_dimension_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

242: p_zero_code_states IN DBMS_SQL.NUMBER_TABLE,
243: p_dimensions IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
244: p_join_dimensions OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
245: p_join_parents OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
246: p_join_dimension_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
247: p_zmv_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE) IS
248: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
249: l_join_parent DBMS_SQL.VARCHAR2_TABLE;
250: l_join_parent_fk DBMS_SQL.VARCHAR2_TABLE;

Line 247: p_zmv_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE) IS

243: p_dimensions IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels,
244: p_join_dimensions OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
245: p_join_parents OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
246: p_join_dimension_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
247: p_zmv_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE) IS
248: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
249: l_join_parent DBMS_SQL.VARCHAR2_TABLE;
250: l_join_parent_fk DBMS_SQL.VARCHAR2_TABLE;
251: l_stack varchar2(32000);

Line 248: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;

244: p_join_dimensions OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
245: p_join_parents OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
246: p_join_dimension_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
247: p_zmv_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE) IS
248: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
249: l_join_parent DBMS_SQL.VARCHAR2_TABLE;
250: l_join_parent_fk DBMS_SQL.VARCHAR2_TABLE;
251: l_stack varchar2(32000);
252: BEGIN

Line 249: l_join_parent DBMS_SQL.VARCHAR2_TABLE;

245: p_join_parents OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
246: p_join_dimension_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
247: p_zmv_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE) IS
248: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
249: l_join_parent DBMS_SQL.VARCHAR2_TABLE;
250: l_join_parent_fk DBMS_SQL.VARCHAR2_TABLE;
251: l_stack varchar2(32000);
252: BEGIN
253: FOR i IN p_keys.first..p_keys.last LOOP

Line 250: l_join_parent_fk DBMS_SQL.VARCHAR2_TABLE;

246: p_join_dimension_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
247: p_zmv_fk OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE) IS
248: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
249: l_join_parent DBMS_SQL.VARCHAR2_TABLE;
250: l_join_parent_fk DBMS_SQL.VARCHAR2_TABLE;
251: l_stack varchar2(32000);
252: BEGIN
253: FOR i IN p_keys.first..p_keys.last LOOP
254: bsc_mo_helper_pkg.writeTmp('p_keys('||i||')='||p_keys(i).keyName, FND_LOG.LEVEL_STATEMENT, false);

Line 307: p_zero_code_states IN DBMS_SQL.NUMBER_TABLE,

303: p_s_table_list IN OUT NOCOPY BSC_METADATA_OPTIMIZER_PKG.tab_clsBasicTable,
304: p_s_table IN VARCHAR2,
305: p_table_level IN NUMBER,
306: p_keys IN BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField,
307: p_zero_code_states IN DBMS_SQL.NUMBER_TABLE,
308: p_system_levels IN NUMBER,
309: p_sql_stmt IN OUT NOCOPY VARCHAR2)
310: RETURN BOOLEAN IS
311: l_nlevel_parents DBMS_SQL.VARCHAR2_TABLE;

Line 311: l_nlevel_parents DBMS_SQL.VARCHAR2_TABLE;

307: p_zero_code_states IN DBMS_SQL.NUMBER_TABLE,
308: p_system_levels IN NUMBER,
309: p_sql_stmt IN OUT NOCOPY VARCHAR2)
310: RETURN BOOLEAN IS
311: l_nlevel_parents DBMS_SQL.VARCHAR2_TABLE;
312: l_highest_table_with_zmv VARCHAR2(400);
313: l_zmv_keys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
314: b_zmv_exists boolean := false;
315: l_zmv VARCHAR2(400);

Line 338: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;

334: l_from_clause VARCHAR2(4000);
335: l_where_clause VARCHAR2(4000);
336: l_group_by_clause VARCHAR2(4000);
337: b_zero_code_key_exists boolean :=false;
338: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
339: l_join_dimensions_fk DBMS_SQL.VARCHAR2_TABLE;
340: l_join_parents DBMS_SQL.VARCHAR2_TABLE;
341: l_zmv_fk DBMS_SQL.VARCHAR2_TABLE;
342:

Line 339: l_join_dimensions_fk DBMS_SQL.VARCHAR2_TABLE;

335: l_where_clause VARCHAR2(4000);
336: l_group_by_clause VARCHAR2(4000);
337: b_zero_code_key_exists boolean :=false;
338: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
339: l_join_dimensions_fk DBMS_SQL.VARCHAR2_TABLE;
340: l_join_parents DBMS_SQL.VARCHAR2_TABLE;
341: l_zmv_fk DBMS_SQL.VARCHAR2_TABLE;
342:
343: BEGIN

Line 340: l_join_parents DBMS_SQL.VARCHAR2_TABLE;

336: l_group_by_clause VARCHAR2(4000);
337: b_zero_code_key_exists boolean :=false;
338: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
339: l_join_dimensions_fk DBMS_SQL.VARCHAR2_TABLE;
340: l_join_parents DBMS_SQL.VARCHAR2_TABLE;
341: l_zmv_fk DBMS_SQL.VARCHAR2_TABLE;
342:
343: BEGIN
344: IF (p_table_level<=p_system_levels) THEN

Line 341: l_zmv_fk DBMS_SQL.VARCHAR2_TABLE;

337: b_zero_code_key_exists boolean :=false;
338: l_join_dimensions DBMS_SQL.VARCHAR2_TABLE;
339: l_join_dimensions_fk DBMS_SQL.VARCHAR2_TABLE;
340: l_join_parents DBMS_SQL.VARCHAR2_TABLE;
341: l_zmv_fk DBMS_SQL.VARCHAR2_TABLE;
342:
343: BEGIN
344: IF (p_table_level<=p_system_levels) THEN
345: return false;

Line 489: arrCombinationsB DBMS_SQL.VARCHAR2_TABLE;

485: MVName VARCHAR2(100);
486: zmvName VARCHAR2(100);
487: keyColumn BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
488: Dato BSC_METADATA_OPTIMIZER_PKG.clsDataField;
489: arrCombinationsB DBMS_SQL.VARCHAR2_TABLE;
490: numCombinationsB NUMBER;
491: arrCombinationsA DBMS_SQL.VARCHAR2_TABLE;
492: numCombinationsA NUMBER;
493: i NUMBER;

Line 491: arrCombinationsA DBMS_SQL.VARCHAR2_TABLE;

487: keyColumn BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
488: Dato BSC_METADATA_OPTIMIZER_PKG.clsDataField;
489: arrCombinationsB DBMS_SQL.VARCHAR2_TABLE;
490: numCombinationsB NUMBER;
491: arrCombinationsA DBMS_SQL.VARCHAR2_TABLE;
492: numCombinationsA NUMBER;
493: i NUMBER;
494: anyKeyNeedZeroCode Boolean;
495: isTotalCombination Boolean;

Line 503: l_groups DBMS_SQL.NUMBER_TABLE;

499: state VARCHAR2(100);
500: New_clsConfigKpiMV BSC_METADATA_OPTIMIZER_PKG.clsConfigKpiMV;
501: STable_Keys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
502: STable_Data BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
503: l_groups DBMS_SQL.NUMBER_TABLE;
504: bForcedSQL boolean := false;
505:
506: -- added for bug 3944813
507:

Line 508: l_zero_code_states DBMS_SQL.NUMBER_TABLE;

504: bForcedSQL boolean := false;
505:
506: -- added for bug 3944813
507:
508: l_zero_code_states DBMS_SQL.NUMBER_TABLE;
509: l_select_key_clause VARCHAR2(4000);
510: l_from_clause VARCHAR2(4000);
511: l_where_clause VARCHAR2(4000);
512: l_stack varchar2(32000);

Line 755: l_parent_name DBMS_SQL.VARCHAR2_TABLE;

751: --***************************************************************************
752: Function IndexRelation1N(tablename IN VARCHAR2, masterTableName IN VARCHAR2 ) RETURN NUMBER IS
753: i NUMBER;
754: j NUMBER;
755: l_parent_name DBMS_SQL.VARCHAR2_TABLE;
756: l_dummy NUMBER;
757:
758: BEGIN
759: i := BSC_MO_HELPER_PKG.findindex(BSC_METADATA_OPTIMIZER_PKG.gMastertable, tablename);

Line 856: l_per_table DBMS_SQL.NUMBER_TABLE;

852: forTargetLevel IN Boolean) RETURN NUMBER IS
853: PERIODIC BSC_METADATA_OPTIMIZER_PKG.clsIndicPeriodicity;
854: l_return NUMBER := -1;
855: l_count NUMBER := -1;
856: l_per_table DBMS_SQL.NUMBER_TABLE;
857: l_dummy NUMBER;
858:
859: l_stack VARCHAR2(32000);
860:

Line 971: PROCEDURE init_measure_counts(l_list IN DBMS_SQL.number_table) IS

967: raise;
968: End;
969:
970:
971: PROCEDURE init_measure_counts(l_list IN DBMS_SQL.number_table) IS
972: l_dummy varchar2(1000);
973: l_stmt varchar2(4000) := 'SELECT kpi.indicator||''_''|| i.dim_set_id hash_index, COUNT(M.MEASURE_COL) NUM_DATA_COLUMNS
974: FROM BSC_SYS_MEASURES M, '||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I,
975: BSC_KPIS_VL kpi

Line 983: l_hash_index dbms_sql.varchar2_table;

979: AND NVL(M.SOURCE, ''BSC'') IN (''BSC'', ''PMF'')
980: AND NVL(M.SOURCE, ''BSC'') <> decode(kpi.short_name, null, ''PMF'', ''-1'')
981: GROUP BY kpi.indicator||''_''|| i.dim_set_id ';
982: numDataColumns number;
983: l_hash_index dbms_sql.varchar2_table;
984: l_num_measures dbms_sql.number_table;
985: cv CurTyp;
986: BEGIN
987: l_dummy := bsc_mo_helper_pkg.Get_New_Big_In_Cond_Number(4, 'INDICATOR');

Line 984: l_num_measures dbms_sql.number_table;

980: AND NVL(M.SOURCE, ''BSC'') <> decode(kpi.short_name, null, ''PMF'', ''-1'')
981: GROUP BY kpi.indicator||''_''|| i.dim_set_id ';
982: numDataColumns number;
983: l_hash_index dbms_sql.varchar2_table;
984: l_num_measures dbms_sql.number_table;
985: cv CurTyp;
986: BEGIN
987: l_dummy := bsc_mo_helper_pkg.Get_New_Big_In_Cond_Number(4, 'INDICATOR');
988: bsc_mo_helper_pkg.Add_Value_Bulk(4, l_list);

Line 1106: Function GetConfigurationsForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE IS

1102: -- PARAMETERS:
1103: -- Indic: indicator code
1104: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
1105: --*************************************************************************
1106: Function GetConfigurationsForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE IS
1107: colConfigurationes dbms_sql.number_table;
1108: colMeasures BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
1109: Configuration NUMBER;
1110: CURSOR cConfigs IS

Line 1107: colConfigurationes dbms_sql.number_table;

1103: -- Indic: indicator code
1104: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
1105: --*************************************************************************
1106: Function GetConfigurationsForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE IS
1107: colConfigurationes dbms_sql.number_table;
1108: colMeasures BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
1109: Configuration NUMBER;
1110: CURSOR cConfigs IS
1111: SELECT DISTINCT DIM_SET_ID

Line 1170: colConfigurationes dbms_sql.number_table;

1166: --***************************************************************************
1167:
1168: PROCEDURE ConfigureMasterSharedIndics IS
1169: Indicator BSC_METADATA_OPTIMIZER_PKG.clsIndicator;
1170: colConfigurationes dbms_sql.number_table;
1171: Configuration NUMBER;
1172: i NUMBER;
1173: j NUMBER;
1174:

Line 1399: l_origin_table DBMS_SQL.VARCHAR2_TABLE;

1395: tableOri VARCHAR2(1000);
1396: l_res boolean :=false;
1397: i NUMBER;
1398: l_index NUMBER;
1399: l_origin_table DBMS_SQL.VARCHAR2_TABLE;
1400: l_dummy NUMBER;
1401: BEGIN
1402: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1403: bsc_mo_helper_pkg.writeTmp('Inside OriginTableHasTarget, p_table = ');

Line 1441: Function TableAlreadyVisited(p_table IN BSC_METADATA_OPTIMIZER_PKG.clsTable, arrVisitedTables in dbms_sql.varchar2_table,

1437: --
1438: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
1439: --***************************************************************************
1440:
1441: Function TableAlreadyVisited(p_table IN BSC_METADATA_OPTIMIZER_PKG.clsTable, arrVisitedTables in dbms_sql.varchar2_table,
1442: numVisitedTables in number) return Boolean is
1443: OriTable VARCHAR2(1000);
1444: i NUMBER;
1445: l_origin_table DBMS_SQL.VARCHAR2_TABLE;

Line 1445: l_origin_table DBMS_SQL.VARCHAR2_TABLE;

1441: Function TableAlreadyVisited(p_table IN BSC_METADATA_OPTIMIZER_PKG.clsTable, arrVisitedTables in dbms_sql.varchar2_table,
1442: numVisitedTables in number) return Boolean is
1443: OriTable VARCHAR2(1000);
1444: i NUMBER;
1445: l_origin_table DBMS_SQL.VARCHAR2_TABLE;
1446: l_dummy NUMBER;
1447: BEGIN
1448:
1449: l_dummy := BSC_MO_HELPER_PKG.decomposestring(p_table.originTable, ',', l_origin_table);

Line 1480: arrVisitedTables dbms_sql.varchar2_table;

1476: -- Configuration: configuration
1477: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
1478: --***************************************************************************
1479: PROCEDURE ConnectTargetTables(Indicator IN BSC_METADATA_OPTIMIZER_PKG.clsIndicator, Configuration IN NUMBER) IS
1480: arrVisitedTables dbms_sql.varchar2_table;
1481: numVisitedTables NUMBER;
1482: anyTableVisited Boolean;
1483: l_table BSC_METADATA_OPTIMIZER_PKG.clsTable;
1484: targetTable varchar2(100);

Line 1636: l_groups DBMS_SQL.NUMBER_TABLE;

1632: DimensionLevels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
1633: i NUMBER;
1634: j NUMBER;
1635: l_res NUMBER := -1;
1636: l_groups DBMS_SQL.NUMBER_TABLE;
1637: group_id NUMBER;
1638:
1639: BEGIN
1640:

Line 2410: arrOrdenDrilesActual dbms_sql.number_table;

2406: --***************************************************************************
2407: Function order_level_string(p_level_string IN VARCHAR2,
2408: p_dimension_families IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) return VARCHAR2
2409: IS
2410: arrOrdenDrilesActual dbms_sql.number_table;
2411: arrOrdenDriles dbms_sql.number_table;
2412: arrConfDriles dbms_sql.varchar2_table;
2413: numDriles NUMBER;
2414: i NUMBER;

Line 2411: arrOrdenDriles dbms_sql.number_table;

2407: Function order_level_string(p_level_string IN VARCHAR2,
2408: p_dimension_families IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) return VARCHAR2
2409: IS
2410: arrOrdenDrilesActual dbms_sql.number_table;
2411: arrOrdenDriles dbms_sql.number_table;
2412: arrConfDriles dbms_sql.varchar2_table;
2413: numDriles NUMBER;
2414: i NUMBER;
2415: j NUMBER;

Line 2412: arrConfDriles dbms_sql.varchar2_table;

2408: p_dimension_families IN BSC_METADATA_OPTIMIZER_PKG.tab_tab_clsLevels) return VARCHAR2
2409: IS
2410: arrOrdenDrilesActual dbms_sql.number_table;
2411: arrOrdenDriles dbms_sql.number_table;
2412: arrConfDriles dbms_sql.varchar2_table;
2413: numDriles NUMBER;
2414: i NUMBER;
2415: j NUMBER;
2416: temp NUMBER;

Line 2420: l_groups DBMS_SQL.NUMBER_TABLE;

2416: temp NUMBER;
2417: l_ordered_level_string varchar2(1000);
2418: tempC varchar2(1000);
2419: DimLevels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
2420: l_groups DBMS_SQL.NUMBER_TABLE;
2421: l_group_id NUMBER;
2422:
2423: BEGIN
2424:

Line 2658: PROCEDURE CalcCartesianProduct(p_cartesian_product IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

2654: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
2655: --***************************************************************************
2656:
2657:
2658: PROCEDURE CalcCartesianProduct(p_cartesian_product IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
2659: p_num_dimensions IN Integer,
2660: dimensionSizes IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE) IS
2661:
2662: l_num_tables NUMBER;

Line 2660: dimensionSizes IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE) IS

2656:
2657:
2658: PROCEDURE CalcCartesianProduct(p_cartesian_product IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
2659: p_num_dimensions IN Integer,
2660: dimensionSizes IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE) IS
2661:
2662: l_num_tables NUMBER;
2663: iTimes NUMBER;
2664: l_repeat_count NUMBER;

Line 2798: p_cartesian_product DBMS_SQL.NUMBER_TABLE;

2794: Basic_keys BSC_METADATA_OPTIMIZER_PKG.tab_clsKeyField;
2795: Basic_data BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
2796:
2797: CampoLlave BSC_METADATA_OPTIMIZER_PKG.clsKeyField;
2798: p_cartesian_product DBMS_SQL.NUMBER_TABLE;
2799:
2800: NumDimensions NUMBER;
2801: NumLevels NUMBER;
2802: dimensionSizes dbms_sql.number_table;

Line 2802: dimensionSizes dbms_sql.number_table;

2798: p_cartesian_product DBMS_SQL.NUMBER_TABLE;
2799:
2800: NumDimensions NUMBER;
2801: NumLevels NUMBER;
2802: dimensionSizes dbms_sql.number_table;
2803: idimension NUMBER;
2804: i NUMBER;
2805: j NUMBER;
2806:

Line 2823: l_groups DBMS_SQL.NUMBER_TABLE;

2819: TableNameStart varchar2(1000);
2820: l_temp NUMBER;
2821: l_tempv VARCHAR2(100);
2822:
2823: l_groups DBMS_SQL.NUMBER_TABLE;
2824: l_group_id NUMBER;
2825: l_drillCombination BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
2826: l_drillCombination2 BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
2827:

Line 2829: l_drillTable DBMS_SQL.VARCHAR2_TABLE;

2825: l_drillCombination BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
2826: l_drillCombination2 BSC_METADATA_OPTIMIZER_PKG.tab_clsLevelCombinations;
2827:
2828: l_drillString VARCHAR2(4000);
2829: l_drillTable DBMS_SQL.VARCHAR2_TABLE;
2830:
2831: l_level_groups DBMS_SQL.NUMBER_TABLE;
2832: l_level_group_id NUMBER;
2833: l_dimLevels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;

Line 2831: l_level_groups DBMS_SQL.NUMBER_TABLE;

2827:
2828: l_drillString VARCHAR2(4000);
2829: l_drillTable DBMS_SQL.VARCHAR2_TABLE;
2830:
2831: l_level_groups DBMS_SQL.NUMBER_TABLE;
2832: l_level_group_id NUMBER;
2833: l_dimLevels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
2834:
2835: BEGIN

Line 3054: baseColumns IN dbms_sql.varchar2_table , numBaseColumns IN NUMBER) IS

3050: --
3051: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
3052: --***************************************************************************
3053: PROCEDURE AddInternalColumnInDB(internalColumn IN VARCHAR2, InternalColumnType NUMBER,
3054: baseColumns IN dbms_sql.varchar2_table , numBaseColumns IN NUMBER) IS
3055: l_measure BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV;
3056: i NUMBER;
3057: prjMethod NUMBER;
3058: l_temp number;

Line 3366: Function GetFieldExpresion(CamposExpresion IN OUT NOCOPY dbms_sql.varchar2_table, Expresion IN VARCHAR2) return NUMBER IS

3362: -- CamposExpresion(): array to be populated
3363: -- Expresion: expression
3364: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
3365: --****************************************************************************
3366: Function GetFieldExpresion(CamposExpresion IN OUT NOCOPY dbms_sql.varchar2_table, Expresion IN VARCHAR2) return NUMBER IS
3367: i NUMBER;
3368:
3369: NumCamposExpresion VARCHAR2(1000);
3370: Campos dbms_sql.varchar2_table;

Line 3370: Campos dbms_sql.varchar2_table;

3366: Function GetFieldExpresion(CamposExpresion IN OUT NOCOPY dbms_sql.varchar2_table, Expresion IN VARCHAR2) return NUMBER IS
3367: i NUMBER;
3368:
3369: NumCamposExpresion VARCHAR2(1000);
3370: Campos dbms_sql.varchar2_table;
3371: NumCampos NUMBER;
3372: cExpresion VARCHAR2(1000);
3373: BEGIN
3374:

Line 3454: l_measure_names_list dbms_sql.varchar2_table;

3450: RETURN BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField IS
3451:
3452: l_stmt VARCHAR2(1000);
3453: l_measure_name varchar2(1000);
3454: l_measure_names_list dbms_sql.varchar2_table;
3455: l_num_measures NUMBER;
3456: FuncAgreg varchar2(1000);
3457: l_measure_column BSC_METADATA_OPTIMIZER_PKG.clsDataField;
3458: l_col_measure_columns BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;

Line 3471: baseColumn dbms_sql.varchar2_table;

3467: FuncAgregSingleColumn VARCHAR2(1000);
3468: pAvgLSingleColumn VARCHAR2(1000);
3469: AvgLTotalColumn VARCHAR2(1000);
3470: AvgLCounterColumn VARCHAR2(1000);
3471: baseColumn dbms_sql.varchar2_table;
3472:
3473: l_stmt2 VARCHAR2(10000):= 'SELECT M.MEASURE_COL, NVL(M.OPERATION, ''SUM'') AS OPER,
3474: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :1) AS PFORMULASOURCE,
3475: NVL(BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :2 ),''N'') AS PAVGL,

Line 3740: Function GetStrCombinationsMN(combo IN dbms_sql.varchar2_table)

3736: -- combo: set of strings.
3737: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
3738: --***************************************************************************
3739:
3740: Function GetStrCombinationsMN(combo IN dbms_sql.varchar2_table)
3741: return dbms_sql.varchar2_table IS
3742: StringCombination dbms_sql.varchar2_table;
3743: StringCombination1 dbms_sql.varchar2_table;
3744:

Line 3741: return dbms_sql.varchar2_table IS

3737: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
3738: --***************************************************************************
3739:
3740: Function GetStrCombinationsMN(combo IN dbms_sql.varchar2_table)
3741: return dbms_sql.varchar2_table IS
3742: StringCombination dbms_sql.varchar2_table;
3743: StringCombination1 dbms_sql.varchar2_table;
3744:
3745: Combination dbms_sql.varchar2_table;

Line 3742: StringCombination dbms_sql.varchar2_table;

3738: --***************************************************************************
3739:
3740: Function GetStrCombinationsMN(combo IN dbms_sql.varchar2_table)
3741: return dbms_sql.varchar2_table IS
3742: StringCombination dbms_sql.varchar2_table;
3743: StringCombination1 dbms_sql.varchar2_table;
3744:
3745: Combination dbms_sql.varchar2_table;
3746: Combination1 dbms_sql.varchar2_table;

Line 3743: StringCombination1 dbms_sql.varchar2_table;

3739:
3740: Function GetStrCombinationsMN(combo IN dbms_sql.varchar2_table)
3741: return dbms_sql.varchar2_table IS
3742: StringCombination dbms_sql.varchar2_table;
3743: StringCombination1 dbms_sql.varchar2_table;
3744:
3745: Combination dbms_sql.varchar2_table;
3746: Combination1 dbms_sql.varchar2_table;
3747:

Line 3745: Combination dbms_sql.varchar2_table;

3741: return dbms_sql.varchar2_table IS
3742: StringCombination dbms_sql.varchar2_table;
3743: StringCombination1 dbms_sql.varchar2_table;
3744:
3745: Combination dbms_sql.varchar2_table;
3746: Combination1 dbms_sql.varchar2_table;
3747:
3748: str varchar2(1000);
3749: str1 varchar2(1000);

Line 3746: Combination1 dbms_sql.varchar2_table;

3742: StringCombination dbms_sql.varchar2_table;
3743: StringCombination1 dbms_sql.varchar2_table;
3744:
3745: Combination dbms_sql.varchar2_table;
3746: Combination1 dbms_sql.varchar2_table;
3747:
3748: str varchar2(1000);
3749: str1 varchar2(1000);
3750: combo1 dbms_sql.varchar2_table;

Line 3750: combo1 dbms_sql.varchar2_table;

3746: Combination1 dbms_sql.varchar2_table;
3747:
3748: str varchar2(1000);
3749: str1 varchar2(1000);
3750: combo1 dbms_sql.varchar2_table;
3751: i NUMBER;
3752: j NUMBER;
3753: Rel1NExists Boolean;
3754:

Line 3874: colRelsMN dbms_sql.varchar2_table; --collection of objects of class clsCadena

3870: idril NUMBER;
3871: jDril NUMBER;
3872: numDriles NUMBER;
3873:
3874: colRelsMN dbms_sql.varchar2_table; --collection of objects of class clsCadena
3875: RelMN varchar2(1000);
3876:
3877: conjCombinacsMN dbms_sql.varchar2_table;
3878: CombinacMN dbms_sql.varchar2_table;

Line 3877: conjCombinacsMN dbms_sql.varchar2_table;

3873:
3874: colRelsMN dbms_sql.varchar2_table; --collection of objects of class clsCadena
3875: RelMN varchar2(1000);
3876:
3877: conjCombinacsMN dbms_sql.varchar2_table;
3878: CombinacMN dbms_sql.varchar2_table;
3879: ElementoCombinacMN varchar2(1000);
3880: indexDrilComparar NUMBER;
3881:

Line 3878: CombinacMN dbms_sql.varchar2_table;

3874: colRelsMN dbms_sql.varchar2_table; --collection of objects of class clsCadena
3875: RelMN varchar2(1000);
3876:
3877: conjCombinacsMN dbms_sql.varchar2_table;
3878: CombinacMN dbms_sql.varchar2_table;
3879: ElementoCombinacMN varchar2(1000);
3880: indexDrilComparar NUMBER;
3881:
3882: l_ct1 NUMBER ;

Line 3888: l_groups DBMS_SQL.NUMBER_TABLE;

3884: l_ct3 NUMBER;
3885:
3886: l_temp_rel VARCHAR2(100);
3887:
3888: l_groups DBMS_SQL.NUMBER_TABLE;
3889: DimLevels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
3890: l_level_group_id NUMBER;
3891: l_comb_group_id NUMBER := 0;
3892:

Line 3895: l_varchar_table DBMS_SQL.varchar2_table;

3891: l_comb_group_id NUMBER := 0;
3892:
3893: l_dummy NUMBER := 0;
3894:
3895: l_varchar_table DBMS_SQL.varchar2_table;
3896: l_stack VARCHAR2(32000);
3897:
3898: BEGIN
3899:

Line 4135: l_groups DBMS_SQL.NUMBER_TABLE;

4131: l_levels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
4132: l_level BSC_METADATA_OPTIMIZER_PKG.clsLevels;
4133: l_ct NUMBER := 0;
4134: l_ct2 NUMBER := 0;
4135: l_groups DBMS_SQL.NUMBER_TABLE;
4136: l_dummy NUMBER;
4137: l_varchar_table DBMS_SQL.VARCHAR2_TABLE;
4138: BEGIN
4139: IF (tabtabDrills.count =0 ) THEN

Line 4137: l_varchar_table DBMS_SQL.VARCHAR2_TABLE;

4133: l_ct NUMBER := 0;
4134: l_ct2 NUMBER := 0;
4135: l_groups DBMS_SQL.NUMBER_TABLE;
4136: l_dummy NUMBER;
4137: l_varchar_table DBMS_SQL.VARCHAR2_TABLE;
4138: BEGIN
4139: IF (tabtabDrills.count =0 ) THEN
4140: return -1;
4141: END IF;

Line 4217: cdril_parents1N DBMS_SQL.VARCHAR2_TABLE;

4213: l_ct Number;
4214: cv CurTyp;
4215:
4216: l_group_id NUMBER := 0;
4217: cdril_parents1N DBMS_SQL.VARCHAR2_TABLE;
4218: cdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;
4219: tdril_parents1N DBMS_SQL.VARCHAR2_TABLE;
4220: tdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;
4221:

Line 4218: cdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;

4214: cv CurTyp;
4215:
4216: l_group_id NUMBER := 0;
4217: cdril_parents1N DBMS_SQL.VARCHAR2_TABLE;
4218: cdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;
4219: tdril_parents1N DBMS_SQL.VARCHAR2_TABLE;
4220: tdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;
4221:
4222:

Line 4219: tdril_parents1N DBMS_SQL.VARCHAR2_TABLE;

4215:
4216: l_group_id NUMBER := 0;
4217: cdril_parents1N DBMS_SQL.VARCHAR2_TABLE;
4218: cdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;
4219: tdril_parents1N DBMS_SQL.VARCHAR2_TABLE;
4220: tdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;
4221:
4222:
4223: BEGIN

Line 4220: tdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;

4216: l_group_id NUMBER := 0;
4217: cdril_parents1N DBMS_SQL.VARCHAR2_TABLE;
4218: cdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;
4219: tdril_parents1N DBMS_SQL.VARCHAR2_TABLE;
4220: tdril_parentsMN DBMS_SQL.VARCHAR2_TABLE;
4221:
4222:
4223: BEGIN
4224: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 4655: Function GetColConfigForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE IS

4651: -- PARAMETERS:
4652: -- Indic: indicator code
4653: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
4654: --***************************************************************************
4655: Function GetColConfigForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE IS
4656: colConfigurations dbms_sql.number_table;
4657: colMeasures BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
4658: Configuration NUMBER;
4659: DimSet NUMBER;

Line 4656: colConfigurations dbms_sql.number_table;

4652: -- Indic: indicator code
4653: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
4654: --***************************************************************************
4655: Function GetColConfigForIndic(Indic IN NUMBER) return DBMS_SQL.NUMBER_TABLE IS
4656: colConfigurations dbms_sql.number_table;
4657: colMeasures BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
4658: Configuration NUMBER;
4659: DimSet NUMBER;
4660: CURSOR cConfigs IS

Line 4695: colConfigurations dbms_sql.number_table;

4691: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
4692: --***************************************************************************
4693: PROCEDURE IndicatorTables IS
4694: Indicator BSC_METADATA_OPTIMIZER_PKG.clsIndicator;
4695: colConfigurations dbms_sql.number_table;
4696: l_Configuration Number;
4697: l_stmt VARCHAR2(1000);
4698: l_count number := 0;
4699: l_configs Number := 0;

Line 4700: l_list dbms_sql.number_table;

4696: l_Configuration Number;
4697: l_stmt VARCHAR2(1000);
4698: l_count number := 0;
4699: l_configs Number := 0;
4700: l_list dbms_sql.number_table;
4701: BEGIN
4702: bsc_mo_helper_pkg.writeTmp( 'Inside IndicatorTables, # = '||BSC_METADATA_OPTIMIZER_PKG.gIndicators.count, fnd_log.level_statement, true);
4703: IF BSC_METADATA_OPTIMIZER_PKG.gIndicators.count >0 THEN
4704: l_count := BSC_METADATA_OPTIMIZER_PKG.gIndicators.first;