DBA Data[Home] [Help]

APPS.BSC_DIM_TPLATE dependencies on BSC_SYS_DIM_LEVELS_BY_GROUP

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,