136: Type Period_Tbl_Type IS TABLE OF Period_Rec_Type
137: INDEX BY BINARY_INTEGER;
138:
139:
140: -- record type for BSC_KPI_DIM_LEVELS_B, BSC_KPI_DIM_LEVELS_TL table
141: Type Drill_Rec_Type Is Record (
142: Dim_level_index BSC_KPI_DIM_LEVELS_B.Dim_level_index%type,
143: Table_Name BSC_KPI_DIM_LEVELS_B.level_table_Name%type,
144: Filter_Val BSC_KPI_DIM_LEVELS_B.filter_value%type,
138:
139:
140: -- record type for BSC_KPI_DIM_LEVELS_B, BSC_KPI_DIM_LEVELS_TL table
141: Type Drill_Rec_Type Is Record (
142: Dim_level_index BSC_KPI_DIM_LEVELS_B.Dim_level_index%type,
143: Table_Name BSC_KPI_DIM_LEVELS_B.level_table_Name%type,
144: Filter_Val BSC_KPI_DIM_LEVELS_B.filter_value%type,
145: Default_val BSC_KPI_DIM_LEVELS_B.default_value%type,
146: Default_type BSC_KPI_DIM_LEVELS_B.Default_type%type,
139:
140: -- record type for BSC_KPI_DIM_LEVELS_B, BSC_KPI_DIM_LEVELS_TL table
141: Type Drill_Rec_Type Is Record (
142: Dim_level_index BSC_KPI_DIM_LEVELS_B.Dim_level_index%type,
143: Table_Name BSC_KPI_DIM_LEVELS_B.level_table_Name%type,
144: Filter_Val BSC_KPI_DIM_LEVELS_B.filter_value%type,
145: Default_val BSC_KPI_DIM_LEVELS_B.default_value%type,
146: Default_type BSC_KPI_DIM_LEVELS_B.Default_type%type,
147: Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%type,
140: -- record type for BSC_KPI_DIM_LEVELS_B, BSC_KPI_DIM_LEVELS_TL table
141: Type Drill_Rec_Type Is Record (
142: Dim_level_index BSC_KPI_DIM_LEVELS_B.Dim_level_index%type,
143: Table_Name BSC_KPI_DIM_LEVELS_B.level_table_Name%type,
144: Filter_Val BSC_KPI_DIM_LEVELS_B.filter_value%type,
145: Default_val BSC_KPI_DIM_LEVELS_B.default_value%type,
146: Default_type BSC_KPI_DIM_LEVELS_B.Default_type%type,
147: Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%type,
148: Comp_Order BSC_KPI_DIM_LEVELS_B.Comp_order_by%type,
141: Type Drill_Rec_Type Is Record (
142: Dim_level_index BSC_KPI_DIM_LEVELS_B.Dim_level_index%type,
143: Table_Name BSC_KPI_DIM_LEVELS_B.level_table_Name%type,
144: Filter_Val BSC_KPI_DIM_LEVELS_B.filter_value%type,
145: Default_val BSC_KPI_DIM_LEVELS_B.default_value%type,
146: Default_type BSC_KPI_DIM_LEVELS_B.Default_type%type,
147: Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%type,
148: Comp_Order BSC_KPI_DIM_LEVELS_B.Comp_order_by%type,
149: Level_pk_col BSC_KPI_DIM_LEVELS_B.Level_pk_col%type,
142: Dim_level_index BSC_KPI_DIM_LEVELS_B.Dim_level_index%type,
143: Table_Name BSC_KPI_DIM_LEVELS_B.level_table_Name%type,
144: Filter_Val BSC_KPI_DIM_LEVELS_B.filter_value%type,
145: Default_val BSC_KPI_DIM_LEVELS_B.default_value%type,
146: Default_type BSC_KPI_DIM_LEVELS_B.Default_type%type,
147: Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%type,
148: Comp_Order BSC_KPI_DIM_LEVELS_B.Comp_order_by%type,
149: Level_pk_col BSC_KPI_DIM_LEVELS_B.Level_pk_col%type,
150: Parent BSC_KPI_DIM_LEVELS_B.parent_level_index%type,
143: Table_Name BSC_KPI_DIM_LEVELS_B.level_table_Name%type,
144: Filter_Val BSC_KPI_DIM_LEVELS_B.filter_value%type,
145: Default_val BSC_KPI_DIM_LEVELS_B.default_value%type,
146: Default_type BSC_KPI_DIM_LEVELS_B.Default_type%type,
147: Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%type,
148: Comp_Order BSC_KPI_DIM_LEVELS_B.Comp_order_by%type,
149: Level_pk_col BSC_KPI_DIM_LEVELS_B.Level_pk_col%type,
150: Parent BSC_KPI_DIM_LEVELS_B.parent_level_index%type,
151: Parent_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%type,
144: Filter_Val BSC_KPI_DIM_LEVELS_B.filter_value%type,
145: Default_val BSC_KPI_DIM_LEVELS_B.default_value%type,
146: Default_type BSC_KPI_DIM_LEVELS_B.Default_type%type,
147: Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%type,
148: Comp_Order BSC_KPI_DIM_LEVELS_B.Comp_order_by%type,
149: Level_pk_col BSC_KPI_DIM_LEVELS_B.Level_pk_col%type,
150: Parent BSC_KPI_DIM_LEVELS_B.parent_level_index%type,
151: Parent_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%type,
152: Table_Rel BSC_KPI_DIM_LEVELS_B.table_relation%type,
145: Default_val BSC_KPI_DIM_LEVELS_B.default_value%type,
146: Default_type BSC_KPI_DIM_LEVELS_B.Default_type%type,
147: Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%type,
148: Comp_Order BSC_KPI_DIM_LEVELS_B.Comp_order_by%type,
149: Level_pk_col BSC_KPI_DIM_LEVELS_B.Level_pk_col%type,
150: Parent BSC_KPI_DIM_LEVELS_B.parent_level_index%type,
151: Parent_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%type,
152: Table_Rel BSC_KPI_DIM_LEVELS_B.table_relation%type,
153: Parent2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%type,
146: Default_type BSC_KPI_DIM_LEVELS_B.Default_type%type,
147: Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%type,
148: Comp_Order BSC_KPI_DIM_LEVELS_B.Comp_order_by%type,
149: Level_pk_col BSC_KPI_DIM_LEVELS_B.Level_pk_col%type,
150: Parent BSC_KPI_DIM_LEVELS_B.parent_level_index%type,
151: Parent_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%type,
152: Table_Rel BSC_KPI_DIM_LEVELS_B.table_relation%type,
153: Parent2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%type,
154: Parent_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%type,
147: Value_Order BSC_KPI_DIM_LEVELS_B.value_order_by%type,
148: Comp_Order BSC_KPI_DIM_LEVELS_B.Comp_order_by%type,
149: Level_pk_col BSC_KPI_DIM_LEVELS_B.Level_pk_col%type,
150: Parent BSC_KPI_DIM_LEVELS_B.parent_level_index%type,
151: Parent_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%type,
152: Table_Rel BSC_KPI_DIM_LEVELS_B.table_relation%type,
153: Parent2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%type,
154: Parent_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%type,
155: Status BSC_KPI_DIM_LEVELS_B.status%type,
148: Comp_Order BSC_KPI_DIM_LEVELS_B.Comp_order_by%type,
149: Level_pk_col BSC_KPI_DIM_LEVELS_B.Level_pk_col%type,
150: Parent BSC_KPI_DIM_LEVELS_B.parent_level_index%type,
151: Parent_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%type,
152: Table_Rel BSC_KPI_DIM_LEVELS_B.table_relation%type,
153: Parent2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%type,
154: Parent_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%type,
155: Status BSC_KPI_DIM_LEVELS_B.status%type,
156: Position BSC_KPI_DIM_LEVELS_B.position%type,
149: Level_pk_col BSC_KPI_DIM_LEVELS_B.Level_pk_col%type,
150: Parent BSC_KPI_DIM_LEVELS_B.parent_level_index%type,
151: Parent_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%type,
152: Table_Rel BSC_KPI_DIM_LEVELS_B.table_relation%type,
153: Parent2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%type,
154: Parent_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%type,
155: Status BSC_KPI_DIM_LEVELS_B.status%type,
156: Position BSC_KPI_DIM_LEVELS_B.position%type,
157: Total0 BSC_KPI_DIM_LEVELS_B.total0%type,
150: Parent BSC_KPI_DIM_LEVELS_B.parent_level_index%type,
151: Parent_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%type,
152: Table_Rel BSC_KPI_DIM_LEVELS_B.table_relation%type,
153: Parent2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%type,
154: Parent_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%type,
155: Status BSC_KPI_DIM_LEVELS_B.status%type,
156: Position BSC_KPI_DIM_LEVELS_B.position%type,
157: Total0 BSC_KPI_DIM_LEVELS_B.total0%type,
158: Ev0 BSC_KPI_DIM_LEVELS_B.user_level0%type,
151: Parent_Rel BSC_KPI_DIM_LEVELS_B.parent_level_rel%type,
152: Table_Rel BSC_KPI_DIM_LEVELS_B.table_relation%type,
153: Parent2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%type,
154: Parent_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%type,
155: Status BSC_KPI_DIM_LEVELS_B.status%type,
156: Position BSC_KPI_DIM_LEVELS_B.position%type,
157: Total0 BSC_KPI_DIM_LEVELS_B.total0%type,
158: Ev0 BSC_KPI_DIM_LEVELS_B.user_level0%type,
159: Ev1d BSC_KPI_DIM_LEVELS_B.user_level1_default%type,
152: Table_Rel BSC_KPI_DIM_LEVELS_B.table_relation%type,
153: Parent2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%type,
154: Parent_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%type,
155: Status BSC_KPI_DIM_LEVELS_B.status%type,
156: Position BSC_KPI_DIM_LEVELS_B.position%type,
157: Total0 BSC_KPI_DIM_LEVELS_B.total0%type,
158: Ev0 BSC_KPI_DIM_LEVELS_B.user_level0%type,
159: Ev1d BSC_KPI_DIM_LEVELS_B.user_level1_default%type,
160: --
153: Parent2 BSC_KPI_DIM_LEVELS_B.parent_level_index2%type,
154: Parent_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%type,
155: Status BSC_KPI_DIM_LEVELS_B.status%type,
156: Position BSC_KPI_DIM_LEVELS_B.position%type,
157: Total0 BSC_KPI_DIM_LEVELS_B.total0%type,
158: Ev0 BSC_KPI_DIM_LEVELS_B.user_level0%type,
159: Ev1d BSC_KPI_DIM_LEVELS_B.user_level1_default%type,
160: --
161: Name BSC_KPI_DIM_LEVELS_TL.name%type,
154: Parent_Rel2 BSC_KPI_DIM_LEVELS_B.parent_level_rel2%type,
155: Status BSC_KPI_DIM_LEVELS_B.status%type,
156: Position BSC_KPI_DIM_LEVELS_B.position%type,
157: Total0 BSC_KPI_DIM_LEVELS_B.total0%type,
158: Ev0 BSC_KPI_DIM_LEVELS_B.user_level0%type,
159: Ev1d BSC_KPI_DIM_LEVELS_B.user_level1_default%type,
160: --
161: Name BSC_KPI_DIM_LEVELS_TL.name%type,
162: Help BSC_KPI_DIM_LEVELS_TL.help%type,
155: Status BSC_KPI_DIM_LEVELS_B.status%type,
156: Position BSC_KPI_DIM_LEVELS_B.position%type,
157: Total0 BSC_KPI_DIM_LEVELS_B.total0%type,
158: Ev0 BSC_KPI_DIM_LEVELS_B.user_level0%type,
159: Ev1d BSC_KPI_DIM_LEVELS_B.user_level1_default%type,
160: --
161: Name BSC_KPI_DIM_LEVELS_TL.name%type,
162: Help BSC_KPI_DIM_LEVELS_TL.help%type,
163: Total BSC_KPI_DIM_LEVELS_TL.total_disp_name%type,