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_UPDATE dependencies on BSC_OLAP_MAIN

Line 553: --LOCKING: Note I review code and the table created in BSC_OLAP_MAIN.create_tmp_col_type_table

549: END IF;
550: END IF;
551:
552: -- create temp table to hold CODE COLUMN TYPE
553: --LOCKING: Note I review code and the table created in BSC_OLAP_MAIN.create_tmp_col_type_table
554: -- is created with the name BSC_TMP_COL_TYPE_. So no problem with many sessions
555: -- dropping and creting this table
556: --Bug 3899523
557: --check if the temp table for col datatype has already been created

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

555: -- dropping and creting this table
556: --Bug 3899523
557: --check if the temp table for col datatype has already been created
558: --if false drop the table and create it again
559: if(BSC_OLAP_MAIN.b_table_col_type_created=false)then
560: BSC_OLAP_MAIN.drop_tmp_col_type_table;
561: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_message)) then
562: BSC_OLAP_MAIN.b_table_col_type_created := true;
563: else

Line 560: BSC_OLAP_MAIN.drop_tmp_col_type_table;

556: --Bug 3899523
557: --check if the temp table for col datatype has already been created
558: --if false drop the table and create it again
559: if(BSC_OLAP_MAIN.b_table_col_type_created=false)then
560: BSC_OLAP_MAIN.drop_tmp_col_type_table;
561: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_message)) then
562: BSC_OLAP_MAIN.b_table_col_type_created := true;
563: else
564: --Raise exception;

Line 561: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_message)) then

557: --check if the temp table for col datatype has already been created
558: --if false drop the table and create it again
559: if(BSC_OLAP_MAIN.b_table_col_type_created=false)then
560: BSC_OLAP_MAIN.drop_tmp_col_type_table;
561: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_message)) then
562: BSC_OLAP_MAIN.b_table_col_type_created := true;
563: else
564: --Raise exception;
565: RAISE e_tmp_tbl_create_error;

Line 562: BSC_OLAP_MAIN.b_table_col_type_created := true;

558: --if false drop the table and create it again
559: if(BSC_OLAP_MAIN.b_table_col_type_created=false)then
560: BSC_OLAP_MAIN.drop_tmp_col_type_table;
561: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_message)) then
562: BSC_OLAP_MAIN.b_table_col_type_created := true;
563: else
564: --Raise exception;
565: RAISE e_tmp_tbl_create_error;
566: end if;

Line 813: --LOCKING: Note I review code and the table created in BSC_OLAP_MAIN.create_tmp_col_type_table

809: -- Delete records in the temporal table used for big 'in' conditions
810: BSC_APPS.Init_Big_In_Cond_Table;
811:
812: --Delete the temp table created for storing CODE Column type
813: --LOCKING: Note I review code and the table created in BSC_OLAP_MAIN.create_tmp_col_type_table
814: -- is created with the name BSC_TMP_COL_TYPE_. So no problem with many sessions
815: -- dropping and creting this table
816: --Bug 3899523
817: if(BSC_OLAP_MAIN.b_table_col_type_created) then

Line 817: if(BSC_OLAP_MAIN.b_table_col_type_created) then

813: --LOCKING: Note I review code and the table created in BSC_OLAP_MAIN.create_tmp_col_type_table
814: -- is created with the name BSC_TMP_COL_TYPE_. So no problem with many sessions
815: -- dropping and creting this table
816: --Bug 3899523
817: if(BSC_OLAP_MAIN.b_table_col_type_created) then
818: BSC_OLAP_MAIN.drop_tmp_col_type_table;
819: end if;
820:
821: --Enable parallel: need to disable parallel here since I am getting ORA-12838 error when concurrent manager

Line 818: BSC_OLAP_MAIN.drop_tmp_col_type_table;

814: -- is created with the name BSC_TMP_COL_TYPE_. So no problem with many sessions
815: -- dropping and creting this table
816: --Bug 3899523
817: if(BSC_OLAP_MAIN.b_table_col_type_created) then
818: BSC_OLAP_MAIN.drop_tmp_col_type_table;
819: end if;
820:
821: --Enable parallel: need to disable parallel here since I am getting ORA-12838 error when concurrent manager
822: -- is closing the concurrent program.

Line 902: BSC_MESSAGE.Add(x_message => 'BSC_OLAP_MAIN.create_tmp_col_type_table '||h_error_message,

898: -- Delete records in the temporal table used for big 'in' conditions
899: BSC_APPS.Init_Big_In_Cond_Table;
900:
901: BSC_MESSAGE.flush;
902: BSC_MESSAGE.Add(x_message => 'BSC_OLAP_MAIN.create_tmp_col_type_table '||h_error_message,
903: x_source => 'BSC_UPDATE.Execute_Update_Process',
904: x_mode => 'I');
905: COMMIT;
906: