207: Type Project_Tbl_Type IS TABLE OF Project_Rec_Type
208: INDEX BY BINARY_INTEGER;
209:
210:
211: -- record type for BSC_SYS_DIM_GROUPS_TL, BSC_SYS_DIM_LEVELS_BY_GROUP table
212:
213: Type Dfamily_Rec_Type Is Record (
214: Dim_group_id BSC_SYS_DIM_GROUPS_TL.dim_group_id%type,
215: Name BSC_SYS_DIM_GROUPS_TL.name%type,
214: Dim_group_id BSC_SYS_DIM_GROUPS_TL.dim_group_id%type,
215: Name BSC_SYS_DIM_GROUPS_TL.name%type,
216: Short_Name BSC_SYS_DIM_GROUPS_TL.short_name%type,
217: --
218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
215: Name BSC_SYS_DIM_GROUPS_TL.name%type,
216: Short_Name BSC_SYS_DIM_GROUPS_TL.short_name%type,
217: --
218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
216: Short_Name BSC_SYS_DIM_GROUPS_TL.short_name%type,
217: --
218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
217: --
218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type
228: );
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type
228: );
229:
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type
228: );
229:
230: Type Dfamily_Tbl_Type IS TABLE OF Dfamily_Rec_Type
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type
228: );
229:
230: Type Dfamily_Tbl_Type IS TABLE OF Dfamily_Rec_Type
231: INDEX BY BINARY_INTEGER;