49: , x_Measure_instance OUT NOCOPY BIS_MEASURE_PUB.Measure_Instance_type
50: );
51:
52: Procedure Form_dim_level_value_tbl
53: ( p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
55: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
50: );
51:
52: Procedure Form_dim_level_value_tbl
53: ( p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
55: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51:
52: Procedure Form_dim_level_value_tbl
53: ( p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
55: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: Procedure Form_dim_level_value_tbl
53: ( p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
55: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
60: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
53: ( p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
55: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
60: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
55: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
60: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
62: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
55: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
60: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
62: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
60: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
62: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
64: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
60: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
62: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
64: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
60: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
62: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
64: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
66: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
60: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
62: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
64: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
66: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
67: , x_dim_level_value_tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
60: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
62: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
64: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
66: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
67: , x_dim_level_value_tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
68: );
61: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
62: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
64: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
66: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
67: , x_dim_level_value_tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
68: );
69:
62: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
64: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
66: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
67: , x_dim_level_value_tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
68: );
69:
70: -- For enhencement #1270297, 1270301.