APPS.BSC_MIGRATION dependencies on BSC_OLAP_MAIN

Line 5485: if(BSC_OLAP_MAIN.b_table_col_type_created=false)then

5481: -- create temp table to hold CODE COLUMN TYPE
5482: --Bug 3919106
5483: --check if the temp table for col datatype has already been created
5484: --if false drop the table and create it again
5485: if(BSC_OLAP_MAIN.b_table_col_type_created=false)then
5486: BSC_OLAP_MAIN.drop_tmp_col_type_table;
5487: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_msg)) then
5488: BSC_OLAP_MAIN.b_table_col_type_created := true;
5489: else

Line 5486: BSC_OLAP_MAIN.drop_tmp_col_type_table;

5482: --Bug 3919106
5483: --check if the temp table for col datatype has already been created
5484: --if false drop the table and create it again
5485: if(BSC_OLAP_MAIN.b_table_col_type_created=false)then
5486: BSC_OLAP_MAIN.drop_tmp_col_type_table;
5487: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_msg)) then
5488: BSC_OLAP_MAIN.b_table_col_type_created := true;
5489: else
5490: --Raise exception;

Line 5487: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_msg)) then

5483: --check if the temp table for col datatype has already been created
5484: --if false drop the table and create it again
5485: if(BSC_OLAP_MAIN.b_table_col_type_created=false)then
5486: BSC_OLAP_MAIN.drop_tmp_col_type_table;
5487: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_msg)) then
5488: BSC_OLAP_MAIN.b_table_col_type_created := true;
5489: else
5490: --Raise exception;
5491: BSC_MESSAGE.Add(x_message => h_error_msg,

Line 5488: BSC_OLAP_MAIN.b_table_col_type_created := true;

5484: --if false drop the table and create it again
5485: if(BSC_OLAP_MAIN.b_table_col_type_created=false)then
5486: BSC_OLAP_MAIN.drop_tmp_col_type_table;
5487: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_msg)) then
5488: BSC_OLAP_MAIN.b_table_col_type_created := true;
5489: else
5490: --Raise exception;
5491: BSC_MESSAGE.Add(x_message => h_error_msg,
5492: x_source => 'BSC_MIGRATION.Migrate_System');

Line 6050: if(BSC_OLAP_MAIN.b_table_col_type_created) then

6046: -- Delete records in the temporal table used for big 'in' conditions
6047: BSC_APPS.Init_Big_In_Cond_Table;
6048:
6049: --Bug 3919106
6050: if(BSC_OLAP_MAIN.b_table_col_type_created) then
6051: BSC_OLAP_MAIN.drop_tmp_col_type_table;
6052: end if;
6053:
6054: EXCEPTION

Line 6051: BSC_OLAP_MAIN.drop_tmp_col_type_table;

6047: BSC_APPS.Init_Big_In_Cond_Table;
6048:
6049: --Bug 3919106
6050: if(BSC_OLAP_MAIN.b_table_col_type_created) then
6051: BSC_OLAP_MAIN.drop_tmp_col_type_table;
6052: end if;
6053:
6054: EXCEPTION
6055: WHEN e_load_rpt_cal THEN