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_HELPER_PKG dependencies on BSC_APPS

Line 306: SELECT BSC_APPS.Get_Tablespace_Clause_Tbl FROM DUAL;

302: l_stmt varchar2(1000);
303: l_return_value varchar2(1000);
304: cv CurTyp;
305: CURSOR cTableSpace IS
306: SELECT BSC_APPS.Get_Tablespace_Clause_Tbl FROM DUAL;
307: BEGIN
308:
309: OPEN cTableSpace;
310: FETCH cTableSpace INTO l_return_value;

Line 329: l_stmt := 'SELECT BSC_APPS.Get_Tablespace_Clause_Idx FROM DUAL';

325: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
326: bsc_mo_helper_pkg.writeTmp('Inside getTablespaceClauseIdx', FND_LOG.LEVEL_PROCEDURE);
327: END IF;
328:
329: l_stmt := 'SELECT BSC_APPS.Get_Tablespace_Clause_Idx FROM DUAL';
330:
331: OPEN cv FOR l_stmt;
332: FETCH cv INTO l_return_value;
333: CLOSE cv;

Line 350: SELECT BSC_APPS.Get_Storage_Clause FROM DUAL;

346: FUNCTION getStorageClause RETURN VARCHAR2 IS
347: l_stmt varchar2(1000);
348: l_return_value varchar2(1000);
349: CURSOR cStorage IS
350: SELECT BSC_APPS.Get_Storage_Clause FROM DUAL;
351:
352: BEGIN
353: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
354: bsc_mo_helper_pkg.writeTmp('Inside getStorageClause', FND_LOG.LEVEL_PROCEDURE);

Line 410: BSC_METADATA_OPTIMIZER_PKG.gInputTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_table_tbs_type);

406: PROCEDURE InitTablespaceNames IS
407: --Initialize the global variables with tablespace names
408: BEGIN
409:
410: BSC_METADATA_OPTIMIZER_PKG.gInputTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_table_tbs_type);
411: BSC_METADATA_OPTIMIZER_PKG.gInputIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type);
412: BSC_METADATA_OPTIMIZER_PKG.gBaseTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_table_tbs_type);
413: BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_index_tbs_type);
414: BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);

Line 411: BSC_METADATA_OPTIMIZER_PKG.gInputIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type);

407: --Initialize the global variables with tablespace names
408: BEGIN
409:
410: BSC_METADATA_OPTIMIZER_PKG.gInputTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_table_tbs_type);
411: BSC_METADATA_OPTIMIZER_PKG.gInputIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type);
412: BSC_METADATA_OPTIMIZER_PKG.gBaseTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_table_tbs_type);
413: BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_index_tbs_type);
414: BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);
415: BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);

Line 412: BSC_METADATA_OPTIMIZER_PKG.gBaseTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_table_tbs_type);

408: BEGIN
409:
410: BSC_METADATA_OPTIMIZER_PKG.gInputTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_table_tbs_type);
411: BSC_METADATA_OPTIMIZER_PKG.gInputIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type);
412: BSC_METADATA_OPTIMIZER_PKG.gBaseTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_table_tbs_type);
413: BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_index_tbs_type);
414: BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);
415: BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);
416: BSC_METADATA_OPTIMIZER_PKG.gOtherTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);

Line 413: BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_index_tbs_type);

409:
410: BSC_METADATA_OPTIMIZER_PKG.gInputTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_table_tbs_type);
411: BSC_METADATA_OPTIMIZER_PKG.gInputIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type);
412: BSC_METADATA_OPTIMIZER_PKG.gBaseTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_table_tbs_type);
413: BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_index_tbs_type);
414: BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);
415: BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);
416: BSC_METADATA_OPTIMIZER_PKG.gOtherTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
417: BSC_METADATA_OPTIMIZER_PKG.gOtherIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);

Line 414: BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);

410: BSC_METADATA_OPTIMIZER_PKG.gInputTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_table_tbs_type);
411: BSC_METADATA_OPTIMIZER_PKG.gInputIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type);
412: BSC_METADATA_OPTIMIZER_PKG.gBaseTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_table_tbs_type);
413: BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_index_tbs_type);
414: BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);
415: BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);
416: BSC_METADATA_OPTIMIZER_PKG.gOtherTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
417: BSC_METADATA_OPTIMIZER_PKG.gOtherIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
418: End ;

Line 415: BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);

411: BSC_METADATA_OPTIMIZER_PKG.gInputIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type);
412: BSC_METADATA_OPTIMIZER_PKG.gBaseTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_table_tbs_type);
413: BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_index_tbs_type);
414: BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);
415: BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);
416: BSC_METADATA_OPTIMIZER_PKG.gOtherTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
417: BSC_METADATA_OPTIMIZER_PKG.gOtherIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
418: End ;
419:

Line 416: BSC_METADATA_OPTIMIZER_PKG.gOtherTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);

412: BSC_METADATA_OPTIMIZER_PKG.gBaseTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_table_tbs_type);
413: BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_index_tbs_type);
414: BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);
415: BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);
416: BSC_METADATA_OPTIMIZER_PKG.gOtherTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
417: BSC_METADATA_OPTIMIZER_PKG.gOtherIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
418: End ;
419:
420:

Line 417: BSC_METADATA_OPTIMIZER_PKG.gOtherIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);

413: BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.base_index_tbs_type);
414: BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);
415: BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);
416: BSC_METADATA_OPTIMIZER_PKG.gOtherTableTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
417: BSC_METADATA_OPTIMIZER_PKG.gOtherIndexTbsName := BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
418: End ;
419:
420:
421: PROCEDURE write_this (

Line 3101: bsc_apps.Add_Value_Big_In_Cond(x_variable_id , x_value);

3097: PROCEDURE Add_Value_Big_In_Cond_Number(x_variable_id IN NUMBER, x_value IN NUMBER) IS
3098: l_stmt varchar2(300);
3099: l_error varchar2(2000);
3100: BEGIN
3101: bsc_apps.Add_Value_Big_In_Cond(x_variable_id , x_value);
3102:
3103: EXCEPTION WHEN OTHERS THEN
3104: l_error := sqlerrm;
3105: writeTmp( 'Exception in Add_Value_Big_In_Cond_Number :'||l_error, FND_LOG.LEVEL_UNEXPECTED, true);

Line 3147: bsc_apps.Add_Value_Big_In_Cond(x_variable_id , x_value);

3143: l_stmt varchar2(300);
3144: l_error varchar2(2000);
3145: BEGIN
3146:
3147: bsc_apps.Add_Value_Big_In_Cond(x_variable_id , x_value);
3148:
3149: EXCEPTION WHEN OTHERS THEN
3150: l_error := sqlerrm;
3151: writeTmp( 'Exception in Add_Value_Big_In_Cond_Varchar2 :'||l_error, FND_LOG.LEVEL_UNEXPECTED, true);

Line 4796: l_stmt := l_stmt ||BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);

4792: BSC_METADATA_OPTIMIZER_PKG.gStorageClause := getStorageClause;
4793: END IF;
4794: l_stmt := 'create table ' ||CopyTableName ||' TABLESPACE ';
4795: IF (TbsName IS NULL) THEN
4796: l_stmt := l_stmt ||BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
4797: ELSE
4798: l_stmt := l_stmt ||TbsName;
4799: END IF;
4800: l_stmt := l_stmt||' AS SELECT * FROM '||TableName||' '||p_where_clause;

Line 4909: l_stmt := l_stmt||' TABLESPACE '|| BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);

4905: l_stmt := 'CREATE INDEX ' || newIndexName;
4906: End If;
4907: l_stmt := l_stmt||' ON ' || CopyTableName || ' (' || LstColumns || ')';
4908: IF (TbsName IS NULL) THEN
4909: l_stmt := l_stmt||' TABLESPACE '|| BSC_APPS.get_tablespace_name(BSC_APPS.other_table_tbs_type);
4910: ELSE
4911: l_stmt := l_stmt||' TABLESPACE '|| TbsName;
4912: END IF;
4913: l_stmt := l_stmt|| ' ' || BSC_METADATA_OPTIMIZER_PKG.gStorageClause;

Line 5163: BSC_APPS.DO_DDL(x_statement=>x_statement ,

5159: BEGIN
5160: IF (BSC_METADATA_OPTIMIZER_PKG.gApplsysSchema IS NULL) THEN
5161: BSC_METADATA_OPTIMIZER_PKG.gApplsysSchema := BSC_MO_HELPER_PKG.getApplsysSchema;
5162: END IF;
5163: BSC_APPS.DO_DDL(x_statement=>x_statement ,
5164: x_statement_type => x_statement_type,
5165: x_object_name=> x_object_name);
5166:
5167: END Do_DDL;

Line 5182: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then

5178: BEGIN
5179: if ( bsc_metadata_optimizer_pkg.gAppsSchema is not null) then
5180: return bsc_metadata_optimizer_pkg.gAppsSchema;
5181: end if;
5182: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5183: bsc_apps.init_bsc_apps;
5184: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5185: end if;
5186: bsc_metadata_optimizer_pkg.gAppsSchema := bsc_apps.get_user_schema('APPS');

Line 5183: bsc_apps.init_bsc_apps;

5179: if ( bsc_metadata_optimizer_pkg.gAppsSchema is not null) then
5180: return bsc_metadata_optimizer_pkg.gAppsSchema;
5181: end if;
5182: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5183: bsc_apps.init_bsc_apps;
5184: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5185: end if;
5186: bsc_metadata_optimizer_pkg.gAppsSchema := bsc_apps.get_user_schema('APPS');
5187: return bsc_metadata_optimizer_pkg.gAppsSchema;

Line 5184: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;

5180: return bsc_metadata_optimizer_pkg.gAppsSchema;
5181: end if;
5182: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5183: bsc_apps.init_bsc_apps;
5184: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5185: end if;
5186: bsc_metadata_optimizer_pkg.gAppsSchema := bsc_apps.get_user_schema('APPS');
5187: return bsc_metadata_optimizer_pkg.gAppsSchema;
5188:

Line 5186: bsc_metadata_optimizer_pkg.gAppsSchema := bsc_apps.get_user_schema('APPS');

5182: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5183: bsc_apps.init_bsc_apps;
5184: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5185: end if;
5186: bsc_metadata_optimizer_pkg.gAppsSchema := bsc_apps.get_user_schema('APPS');
5187: return bsc_metadata_optimizer_pkg.gAppsSchema;
5188:
5189: END;
5190:

Line 5203: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then

5199: begin
5200: if (bsc_metadata_optimizer_pkg.gBSCSchema is not null) then
5201: return bsc_metadata_optimizer_pkg.gBSCSchema;
5202: end if;
5203: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5204: bsc_apps.init_bsc_apps;
5205: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5206: end if;
5207: bsc_metadata_optimizer_pkg.gBSCSchema:= bsc_apps.get_user_schema('BSC');

Line 5204: bsc_apps.init_bsc_apps;

5200: if (bsc_metadata_optimizer_pkg.gBSCSchema is not null) then
5201: return bsc_metadata_optimizer_pkg.gBSCSchema;
5202: end if;
5203: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5204: bsc_apps.init_bsc_apps;
5205: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5206: end if;
5207: bsc_metadata_optimizer_pkg.gBSCSchema:= bsc_apps.get_user_schema('BSC');
5208: return bsc_metadata_optimizer_pkg.gBSCSchema;

Line 5205: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;

5201: return bsc_metadata_optimizer_pkg.gBSCSchema;
5202: end if;
5203: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5204: bsc_apps.init_bsc_apps;
5205: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5206: end if;
5207: bsc_metadata_optimizer_pkg.gBSCSchema:= bsc_apps.get_user_schema('BSC');
5208: return bsc_metadata_optimizer_pkg.gBSCSchema;
5209:

Line 5207: bsc_metadata_optimizer_pkg.gBSCSchema:= bsc_apps.get_user_schema('BSC');

5203: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5204: bsc_apps.init_bsc_apps;
5205: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5206: end if;
5207: bsc_metadata_optimizer_pkg.gBSCSchema:= bsc_apps.get_user_schema('BSC');
5208: return bsc_metadata_optimizer_pkg.gBSCSchema;
5209:
5210: END;
5211:

Line 5225: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then

5221: if (bsc_metadata_optimizer_pkg.gApplsysSchema is not null) then
5222: return bsc_metadata_optimizer_pkg.gApplsysSchema;
5223: end if;
5224:
5225: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5226: bsc_apps.init_bsc_apps;
5227: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5228: end if;
5229: bsc_metadata_optimizer_pkg.gApplsysSchema := bsc_apps.get_user_schema('FND');

Line 5226: bsc_apps.init_bsc_apps;

5222: return bsc_metadata_optimizer_pkg.gApplsysSchema;
5223: end if;
5224:
5225: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5226: bsc_apps.init_bsc_apps;
5227: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5228: end if;
5229: bsc_metadata_optimizer_pkg.gApplsysSchema := bsc_apps.get_user_schema('FND');
5230: return bsc_metadata_optimizer_pkg.gApplsysSchema;

Line 5227: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;

5223: end if;
5224:
5225: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5226: bsc_apps.init_bsc_apps;
5227: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5228: end if;
5229: bsc_metadata_optimizer_pkg.gApplsysSchema := bsc_apps.get_user_schema('FND');
5230: return bsc_metadata_optimizer_pkg.gApplsysSchema;
5231: END;

Line 5229: bsc_metadata_optimizer_pkg.gApplsysSchema := bsc_apps.get_user_schema('FND');

5225: if ( bsc_metadata_optimizer_pkg.g_bsc_apps_initialized=false) then
5226: bsc_apps.init_bsc_apps;
5227: bsc_metadata_optimizer_pkg.g_bsc_apps_initialized := true;
5228: end if;
5229: bsc_metadata_optimizer_pkg.gApplsysSchema := bsc_apps.get_user_schema('FND');
5230: return bsc_metadata_optimizer_pkg.gApplsysSchema;
5231: END;
5232:
5233: --****************************************************************************

Line 5379: bsc_apps.Add_Value_Big_In_Cond(x_variable_id, x_value);

5375: --
5376: --============================================================================
5377: PROCEDURE Add_Value_Big_In_Cond_Varchar2(x_variable_id number, x_value number) IS
5378: BEGIN
5379: bsc_apps.Add_Value_Big_In_Cond(x_variable_id, x_value);
5380: End;
5381:
5382: --****************************************************************************
5383: -- InitInfoOldSystem