[Home] [Help]
71: REM | Alter_M_By_N_Tables.Added the cascading logic |
72: REM | to update RELATION_COL in BSC_SYS_DIM_LEVEL_RELS |
73: REM | 15-FEB-05 ppandey Enh #4016669, support ID, Value for Autogen DO |
74: REM | 16-FEB-2005 ashankar Bug#4184438 Added the Synch Up API |
75: REM | BSC_SYNC_MVLOGS.Sync_dim_table_mv_log |
76: REM | 11-Mar-05 ankgoel Enh#2690720 - AG Report enh |
77: REM | 30-Mar-05 ankgoel Support 'All' enable/disable for BSC dim objects|
78: REM | from Report Designer |
79: REM | 31-MAR-05 adrao Modified API check_sametype_dims to remove |
4695:
4696: /********************************************************
4697: Here we will synch up the MLOG tables for the current dimension object
4698: ********************************************************/
4699: IF NOT (BSC_SYNC_MVLOGS.Sync_dim_table_mv_log(p_Dim_Level_Rec_Old.Bsc_Level_Name,l_error_msg)) THEN
4700: RAISE e_mlog_exception;
4701: END IF;
4702: END IF;
4703: IF (l_master_table <> UPPER(p_Dim_Level_Rec_Old.Bsc_Level_Name)) THEN
5027: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5028: END IF;
5029:
5030: /********************************************************************
5031: Here we need to call the API BSC_SYNC_MVLOGS.Sync_dim_table_mv_log
5032: This API will synch up the data in MLOGS corresponding to the dimension
5033: object.
5034: We need to call this API in the following scenarios.
5035: 1.When Name and USER_CODE size are changed.
5036: 2.When parent col is added or removed from the child dimension object table.
5037: *******************************************************************/
5038: IF ((p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size)
5039: OR (p_Dim_Level_Rec.Bsc_Level_Disp_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_Disp_Key_Size)) THEN
5040: IF NOT (BSC_SYNC_MVLOGS.Sync_dim_table_mv_log(l_master_table,l_error_msg)) THEN
5041: RAISE e_mlog_exception;
5042: END IF;
5043: END IF;
5044: END LOOP;
5357:
5358: IF ((p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size)
5359: OR (p_Dim_Level_Rec.Bsc_Level_Disp_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_Disp_Key_Size)
5360: OR(UPPER(p_Dim_Level_Rec.Bsc_Pk_Col) <> UPPER(p_Dim_Level_Rec_Old.Bsc_Pk_Col))) THEN
5361: IF NOT (BSC_SYNC_MVLOGS.Sync_dim_table_mv_log(l_master_table,l_error_msg)) THEN
5362: RAISE e_mlog_exception;
5363: END IF;
5364: END IF;
5365: END LOOP;