230: Type Dfamily_Tbl_Type IS TABLE OF Dfamily_Rec_Type
231: INDEX BY BINARY_INTEGER;
232:
233:
234: -- record type for BSC_SYS_MEASURES table
235:
236: Type Proj_Field_Rec_Type Is Record (
237: Measure_id BSC_SYS_MEASURES.Measure_id%type,
238: Measure_col BSC_SYS_MEASURES.Measure_col%type,
233:
234: -- record type for BSC_SYS_MEASURES table
235:
236: Type Proj_Field_Rec_Type Is Record (
237: Measure_id BSC_SYS_MEASURES.Measure_id%type,
238: Measure_col BSC_SYS_MEASURES.Measure_col%type,
239: Operation BSC_SYS_MEASURES.operation%type,
240: Type BSC_SYS_MEASURES.type%type,
241: Min_Actual BSC_SYS_MEASURES.min_actual_value%type,
234: -- record type for BSC_SYS_MEASURES table
235:
236: Type Proj_Field_Rec_Type Is Record (
237: Measure_id BSC_SYS_MEASURES.Measure_id%type,
238: Measure_col BSC_SYS_MEASURES.Measure_col%type,
239: Operation BSC_SYS_MEASURES.operation%type,
240: Type BSC_SYS_MEASURES.type%type,
241: Min_Actual BSC_SYS_MEASURES.min_actual_value%type,
242: Max_Actual BSC_SYS_MEASURES.max_actual_value%type,
235:
236: Type Proj_Field_Rec_Type Is Record (
237: Measure_id BSC_SYS_MEASURES.Measure_id%type,
238: Measure_col BSC_SYS_MEASURES.Measure_col%type,
239: Operation BSC_SYS_MEASURES.operation%type,
240: Type BSC_SYS_MEASURES.type%type,
241: Min_Actual BSC_SYS_MEASURES.min_actual_value%type,
242: Max_Actual BSC_SYS_MEASURES.max_actual_value%type,
243: Min_Plan BSC_SYS_MEASURES.min_budget_value%type,
236: Type Proj_Field_Rec_Type Is Record (
237: Measure_id BSC_SYS_MEASURES.Measure_id%type,
238: Measure_col BSC_SYS_MEASURES.Measure_col%type,
239: Operation BSC_SYS_MEASURES.operation%type,
240: Type BSC_SYS_MEASURES.type%type,
241: Min_Actual BSC_SYS_MEASURES.min_actual_value%type,
242: Max_Actual BSC_SYS_MEASURES.max_actual_value%type,
243: Min_Plan BSC_SYS_MEASURES.min_budget_value%type,
244: Max_Plan BSC_SYS_MEASURES.max_budget_value%type,
237: Measure_id BSC_SYS_MEASURES.Measure_id%type,
238: Measure_col BSC_SYS_MEASURES.Measure_col%type,
239: Operation BSC_SYS_MEASURES.operation%type,
240: Type BSC_SYS_MEASURES.type%type,
241: Min_Actual BSC_SYS_MEASURES.min_actual_value%type,
242: Max_Actual BSC_SYS_MEASURES.max_actual_value%type,
243: Min_Plan BSC_SYS_MEASURES.min_budget_value%type,
244: Max_Plan BSC_SYS_MEASURES.max_budget_value%type,
245: Style BSC_SYS_MEASURES.random_style%type,
238: Measure_col BSC_SYS_MEASURES.Measure_col%type,
239: Operation BSC_SYS_MEASURES.operation%type,
240: Type BSC_SYS_MEASURES.type%type,
241: Min_Actual BSC_SYS_MEASURES.min_actual_value%type,
242: Max_Actual BSC_SYS_MEASURES.max_actual_value%type,
243: Min_Plan BSC_SYS_MEASURES.min_budget_value%type,
244: Max_Plan BSC_SYS_MEASURES.max_budget_value%type,
245: Style BSC_SYS_MEASURES.random_style%type,
246: Insert_Var Boolean := FALSE
239: Operation BSC_SYS_MEASURES.operation%type,
240: Type BSC_SYS_MEASURES.type%type,
241: Min_Actual BSC_SYS_MEASURES.min_actual_value%type,
242: Max_Actual BSC_SYS_MEASURES.max_actual_value%type,
243: Min_Plan BSC_SYS_MEASURES.min_budget_value%type,
244: Max_Plan BSC_SYS_MEASURES.max_budget_value%type,
245: Style BSC_SYS_MEASURES.random_style%type,
246: Insert_Var Boolean := FALSE
247: );
240: Type BSC_SYS_MEASURES.type%type,
241: Min_Actual BSC_SYS_MEASURES.min_actual_value%type,
242: Max_Actual BSC_SYS_MEASURES.max_actual_value%type,
243: Min_Plan BSC_SYS_MEASURES.min_budget_value%type,
244: Max_Plan BSC_SYS_MEASURES.max_budget_value%type,
245: Style BSC_SYS_MEASURES.random_style%type,
246: Insert_Var Boolean := FALSE
247: );
248:
241: Min_Actual BSC_SYS_MEASURES.min_actual_value%type,
242: Max_Actual BSC_SYS_MEASURES.max_actual_value%type,
243: Min_Plan BSC_SYS_MEASURES.min_budget_value%type,
244: Max_Plan BSC_SYS_MEASURES.max_budget_value%type,
245: Style BSC_SYS_MEASURES.random_style%type,
246: Insert_Var Boolean := FALSE
247: );
248:
249: Type Proj_Field_Tbl_Type IS TABLE OF Proj_Field_Rec_Type