DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on BSC_SIMULATION_VIEW_PVT

Line 9630: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array

9626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9627: END IF;
9628: END IF;
9629:
9630: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
9631: (
9632: p_copy_Ak_Tables => FND_API.G_TRUE
9633: ,x_Table_Number => l_Table_Number
9634: ,x_kpi_metadata_tables => l_kpi_metadata_tables

Line 9640: IF l_kpi_metadata_tables(h_i).table_type <> BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND

9636:
9637: BSC_APPS.Write_Line_Log('Migrating Sim Data [p_Trg_indicator =' ||p_Trg_indicator||']' , BSC_APPS.OUTPUT_FILE);
9638:
9639: FOR h_i IN 1..l_Table_Number LOOP
9640: IF l_kpi_metadata_tables(h_i).table_type <> BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND
9641: l_kpi_metadata_tables(h_i).table_type <> BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE THEN
9642: l_table_name := l_kpi_metadata_tables(h_i).table_name;
9643: l_column_name:= l_kpi_metadata_tables(h_i).table_column;
9644:

Line 9641: l_kpi_metadata_tables(h_i).table_type <> BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE THEN

9637: BSC_APPS.Write_Line_Log('Migrating Sim Data [p_Trg_indicator =' ||p_Trg_indicator||']' , BSC_APPS.OUTPUT_FILE);
9638:
9639: FOR h_i IN 1..l_Table_Number LOOP
9640: IF l_kpi_metadata_tables(h_i).table_type <> BSC_SIMULATION_VIEW_PVT.C_AK_TABLE AND
9641: l_kpi_metadata_tables(h_i).table_type <> BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE THEN
9642: l_table_name := l_kpi_metadata_tables(h_i).table_name;
9643: l_column_name:= l_kpi_metadata_tables(h_i).table_column;
9644:
9645: l_key_name := 'TAB_VIEW_ID';

Line 9646: IF( l_column_name = BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE )THEN

9642: l_table_name := l_kpi_metadata_tables(h_i).table_name;
9643: l_column_name:= l_kpi_metadata_tables(h_i).table_column;
9644:
9645: l_key_name := 'TAB_VIEW_ID';
9646: IF( l_column_name = BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE )THEN
9647: l_key_name := 'SOURCE_CODE';
9648: ELSIF (l_column_name = BSC_SIMULATION_VIEW_PVT.C_INDICATOR) THEN
9649: l_key_name := 'INDICATOR';
9650: END IF;

Line 9648: ELSIF (l_column_name = BSC_SIMULATION_VIEW_PVT.C_INDICATOR) THEN

9644:
9645: l_key_name := 'TAB_VIEW_ID';
9646: IF( l_column_name = BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE )THEN
9647: l_key_name := 'SOURCE_CODE';
9648: ELSIF (l_column_name = BSC_SIMULATION_VIEW_PVT.C_INDICATOR) THEN
9649: l_key_name := 'INDICATOR';
9650: END IF;
9651:
9652:

Line 9760: l_kpi_metadata_tables(h_i).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN

9756: FROM dual;
9757:
9758: FOR h_i IN 1..l_Table_Number LOOP
9759: IF(l_kpi_metadata_tables(h_i).duplicate_data = bsc_utility.YES AND
9760: l_kpi_metadata_tables(h_i).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN
9761: BSC_SIMULATION_VIEW_PVT.Copy_Ak_Record_Table (
9762: p_table_name => l_kpi_metadata_tables(h_i).table_name
9763: ,p_table_type => l_kpi_metadata_tables(h_i).table_type
9764: ,p_table_column => l_kpi_metadata_tables(h_i).table_column

Line 9761: BSC_SIMULATION_VIEW_PVT.Copy_Ak_Record_Table (

9757:
9758: FOR h_i IN 1..l_Table_Number LOOP
9759: IF(l_kpi_metadata_tables(h_i).duplicate_data = bsc_utility.YES AND
9760: l_kpi_metadata_tables(h_i).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN
9761: BSC_SIMULATION_VIEW_PVT.Copy_Ak_Record_Table (
9762: p_table_name => l_kpi_metadata_tables(h_i).table_name
9763: ,p_table_type => l_kpi_metadata_tables(h_i).table_type
9764: ,p_table_column => l_kpi_metadata_tables(h_i).table_column
9765: ,p_Src_kpi => p_Src_indicator

Line 9789: l_kpi_metadata_tables(h_i).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN

9785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9786: END IF;
9787: END IF;
9788: ELSIF(l_kpi_metadata_tables(h_i).duplicate_data = bsc_utility.YES AND
9789: l_kpi_metadata_tables(h_i).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN
9790: BSC_SIMULATION_VIEW_PVT.Copy_Ak_Record_Table (
9791: p_table_name => l_kpi_metadata_tables(h_i).table_name
9792: ,p_table_type => l_kpi_metadata_tables(h_i).table_type
9793: ,p_table_column => l_kpi_metadata_tables(h_i).table_column

Line 9790: BSC_SIMULATION_VIEW_PVT.Copy_Ak_Record_Table (

9786: END IF;
9787: END IF;
9788: ELSIF(l_kpi_metadata_tables(h_i).duplicate_data = bsc_utility.YES AND
9789: l_kpi_metadata_tables(h_i).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN
9790: BSC_SIMULATION_VIEW_PVT.Copy_Ak_Record_Table (
9791: p_table_name => l_kpi_metadata_tables(h_i).table_name
9792: ,p_table_type => l_kpi_metadata_tables(h_i).table_type
9793: ,p_table_column => l_kpi_metadata_tables(h_i).table_column
9794: ,p_Src_kpi => p_Src_indicator