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 BSC_MO_INDICATOR_PKG

Line 525: OR (p_BTTables(i).isProductionTable=false AND BSC_MO_INDICATOR_PKG.DataFieldExists(p_BTTables(i).Data, p_measure_col) )

521: -- BSC AW
522: OR (p_BTTables(i).impl_type <> p_impl_type)
523: --BSC Autogen
524: -- If new table(not production table), column shouldnt already exist
525: OR (p_BTTables(i).isProductionTable=false AND BSC_MO_INDICATOR_PKG.DataFieldExists(p_BTTables(i).Data, p_measure_col) )
526: Then
527: toBeConsidered := False;
528: End If;
529: Else

Line 540: If Not BSC_MO_INDICATOR_PKG.keyFieldExists(p_keys, l_key.keyName) Then

536: l_index1 := p_BTTables(i).keys.first;
537: LOOP
538: EXIT WHEN p_BTTables(i).keys.count=0;
539: l_key := p_BTTables(i).keys(l_index1);
540: If Not BSC_MO_INDICATOR_PKG.keyFieldExists(p_keys, l_key.keyName) Then
541: keysEqual := False;
542: Exit ;
543: Else
544: l_temp := BSC_MO_HELPER_PKG.findIndex(p_keys, l_key.keyName);

Line 556: IF BSC_MO_INDICATOR_PKG.DataFieldExists(p_BTTables(i).Data, p_measure_col)=true AND

552: END LOOP;
553: If keysEqual Then -- see if this is a production table, and if so, if the column exists
554: IF (p_BTTables(i).isProductionTable) THEN
555: -- we can add a production table as a match ONLY if the column NAME doesnt exist
556: IF BSC_MO_INDICATOR_PKG.DataFieldExists(p_BTTables(i).Data, p_measure_col)=true AND
557: BSC_MO_INDICATOR_PKG.DataFieldExistsforSource(p_BTTables(i).Data, p_measure_col, p_measure_source)=false THEN
558: null;
559: ELSE
560: l_return_table(l_return_table.count) := i;

Line 557: BSC_MO_INDICATOR_PKG.DataFieldExistsforSource(p_BTTables(i).Data, p_measure_col, p_measure_source)=false THEN

553: If keysEqual Then -- see if this is a production table, and if so, if the column exists
554: IF (p_BTTables(i).isProductionTable) THEN
555: -- we can add a production table as a match ONLY if the column NAME doesnt exist
556: IF BSC_MO_INDICATOR_PKG.DataFieldExists(p_BTTables(i).Data, p_measure_col)=true AND
557: BSC_MO_INDICATOR_PKG.DataFieldExistsforSource(p_BTTables(i).Data, p_measure_col, p_measure_source)=false THEN
558: null;
559: ELSE
560: l_return_table(l_return_table.count) := i;
561: bsc_mo_helper_pkg.writeTmp('Adding table '||p_BTTables(i).name);

Line 871: IF BSC_MO_INDICATOR_PKG.DataFieldExistsForSource(L_Table.Data, fieldName, p_source) AND

867: l_index1 := p_tables.first;
868:
869: LOOP
870: L_Table := p_tables(l_index1);
871: IF BSC_MO_INDICATOR_PKG.DataFieldExistsForSource(L_Table.Data, fieldName, p_source) AND
872: L_Table.impl_type = p_impl_type AND
873: nvl(l_table.measureGroup, -1) = nvl(p_measure_group, -1) THEN
874: If L_Table.Periodicity = pPeriodicity THEN
875: If L_Table.keys.Count = keys.Count THEN

Line 881: If Not BSC_MO_INDICATOR_PKG.keyFieldExists(keys, l_key.keyName) Then

877: l_index2 := L_Table.keys.first;
878: LOOP
879: EXIT WHEN L_Table.keys.count = 0;
880: l_key := L_Table.keys(l_index2);
881: If Not BSC_MO_INDICATOR_PKG.keyFieldExists(keys, l_key.keyName) Then
882: keysEqual := False;
883: Else
884: l_temp := BSC_MO_HELPER_PKG.findIndex(keys, l_key.keyName);
885: If UPPER(l_key.FilterViewName) <> UPPER(keys(l_temp).FilterViewName) Then

Line 1221: If Not BSC_MO_INDICATOR_PKG.keyFieldExists(keysB, l_keyA.keyName) Then

1217: IF (keysA.count> 0) THEN
1218: l_index1 := keysA.first;
1219: LOOP
1220: l_keyA := keysA(l_index1);
1221: If Not BSC_MO_INDICATOR_PKG.keyFieldExists(keysB, l_keyA.keyName) Then
1222: keysEqual := False;
1223: Exit;
1224: End If;
1225: EXIT WHEN l_index1 = keysA.last;

Line 1376: If BSC_MO_INDICATOR_PKG.IndexRelation1N(BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_index1).Name,

1372: END IF;
1373: IF (l_index2 = -1) THEN -- metadata bad
1374: BSC_MO_HELPER_PKG.writeTmp('Bad dimension metadata for key='||l_key_target.keyName, FND_LOG.LEVEL_EXCEPTION, true);
1375: END IF;
1376: If BSC_MO_INDICATOR_PKG.IndexRelation1N(BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_index1).Name,
1377: BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_index2).Name) >= 0 Then
1378: If Not BSC_MO_INDICATOR_PKG.keyFieldExists(l_changed_levels, l_key_origin.keyName) Then
1379: isDerivable := True;
1380: changedDrill := bsc_mo_helper_pkg.new_clsKeyField;

Line 1378: If Not BSC_MO_INDICATOR_PKG.keyFieldExists(l_changed_levels, l_key_origin.keyName) Then

1374: BSC_MO_HELPER_PKG.writeTmp('Bad dimension metadata for key='||l_key_target.keyName, FND_LOG.LEVEL_EXCEPTION, true);
1375: END IF;
1376: If BSC_MO_INDICATOR_PKG.IndexRelation1N(BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_index1).Name,
1377: BSC_METADATA_OPTIMIZER_PKG.gMasterTable(l_index2).Name) >= 0 Then
1378: If Not BSC_MO_INDICATOR_PKG.keyFieldExists(l_changed_levels, l_key_origin.keyName) Then
1379: isDerivable := True;
1380: changedDrill := bsc_mo_helper_pkg.new_clsKeyField;
1381: changedDrill.keyName := l_key_origin.keyName;
1382: l_changed_levels(l_changed_levels.count) := changedDrill;

Line 1671: NOT BSC_MO_INDICATOR_PKG.DataFieldExists(l_BTTables(iMatchingTableIndex(l_loop_ctr)).Data, l_measure_column.fieldName)) THEN

1667: --Note: removed the name of the table as prefix of the column
1668: --I do not see that the same column could be in two origin tables.
1669: l_measure_column.Origin := l_measure_column.aggFunction || '(' || l_measure_column.fieldName || ')';
1670: IF (l_BTTables(iMatchingTableIndex(l_loop_ctr)).isProductionTable AND
1671: NOT BSC_MO_INDICATOR_PKG.DataFieldExists(l_BTTables(iMatchingTableIndex(l_loop_ctr)).Data, l_measure_column.fieldName)) THEN
1672: l_BTTables(iMatchingTableIndex(l_loop_ctr)).isProductionTableAltered := true;
1673: l_measure_column.changeType := 'NEW';
1674: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1675: BSC_MO_HELPER_PKG.writeTmp('ChangeType for '||l_measure_column.fieldName ||' = NEW', FND_LOG.LEVEL_STATEMENT);

Line 1680: IF( NOT BSC_MO_INDICATOR_PKG.DataFieldExists(l_BTTables(iMatchingTableIndex(l_loop_ctr)).Data, l_measure_column.fieldName))THEN

1676: END IF;
1677: END IF;
1678: --Note: other properties for internal columns are not used in input, base, temporal tables
1679: -- If the field does not exist already in the table, then add it.
1680: IF( NOT BSC_MO_INDICATOR_PKG.DataFieldExists(l_BTTables(iMatchingTableIndex(l_loop_ctr)).Data, l_measure_column.fieldName))THEN
1681: l_BTTables(iMatchingTableIndex(l_loop_ctr)).Data(l_BTTables(iMatchingTableIndex(l_loop_ctr)).Data.count) := l_measure_column;
1682: BSC_MO_HELPER_PKG.writeTmp('18. Add origin table '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT);
1683: --TablasOri
1684: --Add to the list the name of the origin table

Line 1826: l_key.Origin := BSC_MO_INDICATOR_PKG.getKeyOrigin(Desag1.keys, l_key.keyName);

1822: IF (l_key_combination.keys.count>0) THEN
1823: FOR l IN l_key_combination.keys.first..l_key_combination.keys.last
1824: LOOP
1825: l_key := l_key_combination.keys(l);
1826: l_key.Origin := BSC_MO_INDICATOR_PKG.getKeyOrigin(Desag1.keys, l_key.keyName);
1827: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1828: bsc_mo_helper_pkg.writeTmp('Changing table = '||l_tableName ||', field '||uniqueField.fieldName
1829: ||', code = '||l_key_combination.code||'''s origin to '||l_key.Origin);
1830: END IF;

Line 1919: If Not BSC_MO_INDICATOR_PKG.KeyfieldExists(p_keys, l_key.keyName) Then

1915: FOR j IN l_key_combination.keys.first..l_key_combination.keys.last
1916: LOOP
1917: l_stack := l_stack || g_newline||'Loop2 begin';
1918: l_key := l_key_combination.keys(j);
1919: If Not BSC_MO_INDICATOR_PKG.KeyfieldExists(p_keys, l_key.keyName) Then
1920: keysEqual := False;
1921: Exit ;
1922: Else
1923: l_temp := BSC_MO_HELPER_PKG.findIndex(p_keys, l_key.keyName);