APPS.BSC_DIM_TPLATE dependencies on BSC_SYS_DIM_LEVELS_B

Line 687: -- 2828685 Synch the BSC_SYS_DIM_LEVELS_B

683: G_Pro_Tbl(3).rel_type := NULL;
684: G_Pro_Tbl(3).direct_rel := NULL;
685: G_Pro_Tbl(3).Level_View_Name := 'BSC_D_3_VL';
686:
687: -- 2828685 Synch the BSC_SYS_DIM_LEVELS_B
688:
689:
690: ----Define Dimension Columns
691: G_DC_Tbl(0).Dim_level_id := -1;

Line 855: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVELS_B, Dim_level_id=' ||

851:
852: For i_dimension In 0 .. (x_num_of_levels -1)
853: Loop
854:
855: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVELS_B, Dim_level_id=' ||
856: to_char(G_Pro_Tbl(i_dimension).Dim_level_id);
857: --2828685 ADD WHO COLUMNS
858: Insert Into BSC_SYS_DIM_LEVELS_B (
859: DIM_LEVEL_ID,

Line 858: Insert Into BSC_SYS_DIM_LEVELS_B (

854:
855: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVELS_B, Dim_level_id=' ||
856: to_char(G_Pro_Tbl(i_dimension).Dim_level_id);
857: --2828685 ADD WHO COLUMNS
858: Insert Into BSC_SYS_DIM_LEVELS_B (
859: DIM_LEVEL_ID,
860: LEVEL_TABLE_NAME,
861: TABLE_TYPE,
862: LEVEL_PK_COL,

Line 1022: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVELS_BY_GROUP, ' ||

1018: 'FEM_ALIAS.LOOKUP_TYPE = ''BSC_TPLATE_TAB_DIM_GROUP_NAME'' AND '||
1019: 'FEM_ALIAS.LOOKUP_CODE = '''||G_DF_Tbl(i_dem_family).Dim_group_id||'''';
1020: BSC_APPS.Execute_Immediate(l_sql);
1021:
1022: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVELS_BY_GROUP, ' ||
1023: ' Dim_group_id=' || to_char(G_DF_Tbl(i_dem_family).Dim_group_id) ||
1024: ', Dim_level_id=' || to_char(G_DF_Tbl(i_dem_family).Dim_level_id);
1025:
1026: Insert Into BSC_SYS_DIM_LEVELS_BY_GROUP (

Line 1026: Insert Into BSC_SYS_DIM_LEVELS_BY_GROUP (

1022: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVELS_BY_GROUP, ' ||
1023: ' Dim_group_id=' || to_char(G_DF_Tbl(i_dem_family).Dim_group_id) ||
1024: ', Dim_level_id=' || to_char(G_DF_Tbl(i_dem_family).Dim_level_id);
1025:
1026: Insert Into BSC_SYS_DIM_LEVELS_BY_GROUP (
1027: DIM_GROUP_ID,
1028: DIM_LEVEL_ID,
1029: DIM_LEVEL_INDEX,
1030: TOTAL_FLAG,