DBA Data[Home] [Help]

APPS.BSC_DIM_TPLATE dependencies on BSC_SYS_DIM_LEVEL_COLS

Line 915: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVEL_COLS, Dim_level_id=' ||

911: 'FEM_DIM.LANGUAGE = FEM_ALL.LANGUAGE AND '||
912: 'FEM_COMP.LANGUAGE = FEM_ALL.LANGUAGE';
913: BSC_APPS.Execute_Immediate(l_sql);
914:
915: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVEL_COLS, Dim_level_id=' ||
916: to_char(G_Pro_Tbl(i_dimension).Dim_level_id);
917:
918:
919: For i_dimension_col In 0 .. (x_num_of_columns -1) LOOP

Line 921: Insert Into BSC_SYS_DIM_LEVEL_COLS (

917:
918:
919: For i_dimension_col In 0 .. (x_num_of_columns -1) LOOP
920: IF G_DC_Tbl(i_dimension_col).Dim_level_id = -1 THEN
921: Insert Into BSC_SYS_DIM_LEVEL_COLS (
922: DIM_LEVEL_ID,
923: COLUMN_NAME,
924: COLUMN_TYPE)
925: Values (

Line 932: Insert Into BSC_SYS_DIM_LEVEL_COLS (

928: G_DC_Tbl(i_dimension_col).Column_Type
929: );
930: ELSE
931: IF G_DC_Tbl(i_dimension_col).Dim_level_id = G_Pro_Tbl(i_dimension).Dim_level_id THEN
932: Insert Into BSC_SYS_DIM_LEVEL_COLS (
933: DIM_LEVEL_ID,
934: COLUMN_NAME,
935: COLUMN_TYPE)
936: Values (