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_DBGEN_UTILS dependencies on BSC_METADATA_OPTIMIZER_PKG

Line 243: BSC_METADATA_OPTIMIZER_PKG.InitReservedFunctions;

239: IF (g_initialized=false) THEN
240: init;
241: END IF;
242: l_expression := p_expression;
243: BSC_METADATA_OPTIMIZER_PKG.InitReservedFunctions;
244: --Replace the operators by ' '
245: i := BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.first;
246:
247: LOOP

Line 245: i := BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.first;

241: END IF;
242: l_expression := p_expression;
243: BSC_METADATA_OPTIMIZER_PKG.InitReservedFunctions;
244: --Replace the operators by ' '
245: i := BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.first;
246:
247: LOOP
248: l_expression := Replace(l_expression, BSC_METADATA_OPTIMIZER_PKG.gReservedOperators(i), ' ');
249: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.last;

Line 248: l_expression := Replace(l_expression, BSC_METADATA_OPTIMIZER_PKG.gReservedOperators(i), ' ');

244: --Replace the operators by ' '
245: i := BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.first;
246:
247: LOOP
248: l_expression := Replace(l_expression, BSC_METADATA_OPTIMIZER_PKG.gReservedOperators(i), ' ');
249: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.last;
250: i := BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.next(i);
251: END LOOP;
252: --Break down the expression which is separated by ' '

Line 249: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.last;

245: i := BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.first;
246:
247: LOOP
248: l_expression := Replace(l_expression, BSC_METADATA_OPTIMIZER_PKG.gReservedOperators(i), ' ');
249: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.last;
250: i := BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.next(i);
251: END LOOP;
252: --Break down the expression which is separated by ' '
253: i := BSC_MO_HELPER_PKG.DecomposeString(l_expression, ' ', l_measure_list_tmp );

Line 250: i := BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.next(i);

246:
247: LOOP
248: l_expression := Replace(l_expression, BSC_METADATA_OPTIMIZER_PKG.gReservedOperators(i), ' ');
249: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.last;
250: i := BSC_METADATA_OPTIMIZER_PKG.gReservedOperators.next(i);
251: END LOOP;
252: --Break down the expression which is separated by ' '
253: i := BSC_MO_HELPER_PKG.DecomposeString(l_expression, ' ', l_measure_list_tmp );
254: i:= l_measure_list_tmp .first;

Line 258: If BSC_MO_HELPER_PKG.FindIndexVARCHAR2(BSC_METADATA_OPTIMIZER_PKG.gReservedFunctions, l_measure_list_tmp (i)) = -1 Then

254: i:= l_measure_list_tmp .first;
255: LOOP
256: EXIT WHEN l_measure_list_tmp .count = 0;
257: If l_measure_list_tmp (i) IS NOT NULL Then
258: If BSC_MO_HELPER_PKG.FindIndexVARCHAR2(BSC_METADATA_OPTIMIZER_PKG.gReservedFunctions, l_measure_list_tmp (i)) = -1 Then
259: --The word campos(i) is not a reserved function
260: If UPPER(l_measure_list_tmp (i)) <> 'NULL' Then
261: --the word is not 'NULL'
262: If Not BSC_MO_HELPER_PKG.IsNumber(l_measure_list_tmp (i)) Then