72:
73:
74: -- record type for BSC_KPIS_B, BSC_KPIS_TL table
75: -- Options : the number of records in BSC_KPI_PROPERTIESfor an indicator
76: -- Detail_Flag : value 'NO' means only inserting records into BSC_KPI_PERIODICITIES
77: -- table for a indicator
78: -- Period_Shown : the number of records in BSC_KPI_PERIODICITIES,
79: -- and BSC_KPI_DATA_TABLES tables
80: -- for an indicator
74: -- record type for BSC_KPIS_B, BSC_KPIS_TL table
75: -- Options : the number of records in BSC_KPI_PROPERTIESfor an indicator
76: -- Detail_Flag : value 'NO' means only inserting records into BSC_KPI_PERIODICITIES
77: -- table for a indicator
78: -- Period_Shown : the number of records in BSC_KPI_PERIODICITIES,
79: -- and BSC_KPI_DATA_TABLES tables
80: -- for an indicator
81: -- System_C : For Tab system only. The Tab number which the indicator
82: -- belong to
122:
123: TYPE Cal_Tbl_Type IS TABLE OF Cal_Rec_Type
124: INDEX BY BINARY_INTEGER;
125:
126: -- record type for BSC_KPI_PERIODICITIES table
127: Type Period_Rec_Type Is Record (
128: Order_r BSC_KPI_PERIODICITIES.display_order%type,
129: Period_Type BSC_KPI_PERIODICITIES.periodicity_id%type,
130: Prev_Year BSC_KPI_PERIODICITIES.previous_years%type,
124: INDEX BY BINARY_INTEGER;
125:
126: -- record type for BSC_KPI_PERIODICITIES table
127: Type Period_Rec_Type Is Record (
128: Order_r BSC_KPI_PERIODICITIES.display_order%type,
129: Period_Type BSC_KPI_PERIODICITIES.periodicity_id%type,
130: Prev_Year BSC_KPI_PERIODICITIES.previous_years%type,
131: Num_Years BSC_KPI_PERIODICITIES.num_of_years%type,
132: Viewport_flag BSC_KPI_PERIODICITIES.viewport_flag%type,
125:
126: -- record type for BSC_KPI_PERIODICITIES table
127: Type Period_Rec_Type Is Record (
128: Order_r BSC_KPI_PERIODICITIES.display_order%type,
129: Period_Type BSC_KPI_PERIODICITIES.periodicity_id%type,
130: Prev_Year BSC_KPI_PERIODICITIES.previous_years%type,
131: Num_Years BSC_KPI_PERIODICITIES.num_of_years%type,
132: Viewport_flag BSC_KPI_PERIODICITIES.viewport_flag%type,
133: Viewport_Size BSC_KPI_PERIODICITIES.viewport_default_size%type
126: -- record type for BSC_KPI_PERIODICITIES table
127: Type Period_Rec_Type Is Record (
128: Order_r BSC_KPI_PERIODICITIES.display_order%type,
129: Period_Type BSC_KPI_PERIODICITIES.periodicity_id%type,
130: Prev_Year BSC_KPI_PERIODICITIES.previous_years%type,
131: Num_Years BSC_KPI_PERIODICITIES.num_of_years%type,
132: Viewport_flag BSC_KPI_PERIODICITIES.viewport_flag%type,
133: Viewport_Size BSC_KPI_PERIODICITIES.viewport_default_size%type
134: );
127: Type Period_Rec_Type Is Record (
128: Order_r BSC_KPI_PERIODICITIES.display_order%type,
129: Period_Type BSC_KPI_PERIODICITIES.periodicity_id%type,
130: Prev_Year BSC_KPI_PERIODICITIES.previous_years%type,
131: Num_Years BSC_KPI_PERIODICITIES.num_of_years%type,
132: Viewport_flag BSC_KPI_PERIODICITIES.viewport_flag%type,
133: Viewport_Size BSC_KPI_PERIODICITIES.viewport_default_size%type
134: );
135:
128: Order_r BSC_KPI_PERIODICITIES.display_order%type,
129: Period_Type BSC_KPI_PERIODICITIES.periodicity_id%type,
130: Prev_Year BSC_KPI_PERIODICITIES.previous_years%type,
131: Num_Years BSC_KPI_PERIODICITIES.num_of_years%type,
132: Viewport_flag BSC_KPI_PERIODICITIES.viewport_flag%type,
133: Viewport_Size BSC_KPI_PERIODICITIES.viewport_default_size%type
134: );
135:
136: Type Period_Tbl_Type IS TABLE OF Period_Rec_Type
129: Period_Type BSC_KPI_PERIODICITIES.periodicity_id%type,
130: Prev_Year BSC_KPI_PERIODICITIES.previous_years%type,
131: Num_Years BSC_KPI_PERIODICITIES.num_of_years%type,
132: Viewport_flag BSC_KPI_PERIODICITIES.viewport_flag%type,
133: Viewport_Size BSC_KPI_PERIODICITIES.viewport_default_size%type
134: );
135:
136: Type Period_Tbl_Type IS TABLE OF Period_Rec_Type
137: INDEX BY BINARY_INTEGER;