73: C_TABLE_NOT_EXIST CONSTANT NUMBER := 1;
74: C_COLUMN_NOT_EXIST CONSTANT NUMBER := 2;
75: C_UNKNOWN_ERROR CONSTANT NUMBER := -1;
76:
77: -- record type for BSC_SYS_DIM_LEVEL_COLS table
78: TYPE Proj_Dim_Cols_Rec_Type IS Record
79: ( Dim_level_id BSC_SYS_DIM_LEVEL_COLS.dim_level_id%TYPE
80: , Column_Name BSC_SYS_DIM_LEVEL_COLS.column_name%TYPE
81: , Column_Type BSC_SYS_DIM_LEVEL_COLS.column_type%TYPE
75: C_UNKNOWN_ERROR CONSTANT NUMBER := -1;
76:
77: -- record type for BSC_SYS_DIM_LEVEL_COLS table
78: TYPE Proj_Dim_Cols_Rec_Type IS Record
79: ( Dim_level_id BSC_SYS_DIM_LEVEL_COLS.dim_level_id%TYPE
80: , Column_Name BSC_SYS_DIM_LEVEL_COLS.column_name%TYPE
81: , Column_Type BSC_SYS_DIM_LEVEL_COLS.column_type%TYPE
82: );
83:
76:
77: -- record type for BSC_SYS_DIM_LEVEL_COLS table
78: TYPE Proj_Dim_Cols_Rec_Type IS Record
79: ( Dim_level_id BSC_SYS_DIM_LEVEL_COLS.dim_level_id%TYPE
80: , Column_Name BSC_SYS_DIM_LEVEL_COLS.column_name%TYPE
81: , Column_Type BSC_SYS_DIM_LEVEL_COLS.column_type%TYPE
82: );
83:
84: TYPE Proj_Dim_Cols_Tbl_Type IS TABLE OF Proj_Dim_Cols_Rec_Type INDEX BY BINARY_INTEGER;
77: -- record type for BSC_SYS_DIM_LEVEL_COLS table
78: TYPE Proj_Dim_Cols_Rec_Type IS Record
79: ( Dim_level_id BSC_SYS_DIM_LEVEL_COLS.dim_level_id%TYPE
80: , Column_Name BSC_SYS_DIM_LEVEL_COLS.column_name%TYPE
81: , Column_Type BSC_SYS_DIM_LEVEL_COLS.column_type%TYPE
82: );
83:
84: TYPE Proj_Dim_Cols_Tbl_Type IS TABLE OF Proj_Dim_Cols_Rec_Type INDEX BY BINARY_INTEGER;
85: