35: --2440739
36: c_default_appl NUMBER := -1; --2465354
37:
38: Procedure Delete_Performance_Measure
39: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
40: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
41: ,x_return_status OUT NOCOPY VARCHAR2
42: ,x_msg_count OUT NOCOPY VARCHAR2
43: ,x_msg_data OUT NOCOPY VARCHAR2
36: c_default_appl NUMBER := -1; --2465354
37:
38: Procedure Delete_Performance_Measure
39: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
40: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
41: ,x_return_status OUT NOCOPY VARCHAR2
42: ,x_msg_count OUT NOCOPY VARCHAR2
43: ,x_msg_data OUT NOCOPY VARCHAR2
44: );
43: ,x_msg_data OUT NOCOPY VARCHAR2
44: );
45:
46: Procedure Update_Performance_Measure
47: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
48: ,p_Measure_Short_Name IN VARCHAR2
49: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
50: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
45:
46: Procedure Update_Performance_Measure
47: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
48: ,p_Measure_Short_Name IN VARCHAR2
49: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
50: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
46: Procedure Update_Performance_Measure
47: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
48: ,p_Measure_Short_Name IN VARCHAR2
49: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
50: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
47: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
48: ,p_Measure_Short_Name IN VARCHAR2
49: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
50: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
48: ,p_Measure_Short_Name IN VARCHAR2
49: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
50: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
49: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
50: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
57: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
50: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
57: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
51: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
52: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
57: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: -- Fix for 1850860 starts here
52: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
53: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
57: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: -- Fix for 1850860 starts here
60: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
53: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
54: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
57: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: -- Fix for 1850860 starts here
60: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
54: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
55: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
56: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
57: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: -- Fix for 1850860 starts here
60: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
56: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
57: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: -- Fix for 1850860 starts here
60: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
64: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
57: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
58: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: -- Fix for 1850860 starts here
60: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
64: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: -- Fix for 1850860 ends here
58: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
59: -- Fix for 1850860 starts here
60: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
64: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: -- Fix for 1850860 ends here
66: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
59: -- Fix for 1850860 starts here
60: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
64: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: -- Fix for 1850860 ends here
66: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
67: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
60: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
61: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
64: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: -- Fix for 1850860 ends here
66: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
67: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
68: ,p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
64: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
65: -- Fix for 1850860 ends here
66: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
67: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
68: ,p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
69: ,p_application_id IN NUMBER := c_default_appl -- 2465354
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,x_msg_count OUT NOCOPY VARCHAR2
72: ,x_msg_data OUT NOCOPY VARCHAR2
73: );
74:
75:
76: Procedure Create_Performance_Measure
77: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
78: ,p_Measure_Short_Name IN VARCHAR2
79: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
80: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
75:
76: Procedure Create_Performance_Measure
77: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
78: ,p_Measure_Short_Name IN VARCHAR2
79: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
80: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
82: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
76: Procedure Create_Performance_Measure
77: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
78: ,p_Measure_Short_Name IN VARCHAR2
79: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
80: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
82: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
84: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
77: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
78: ,p_Measure_Short_Name IN VARCHAR2
79: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
80: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
82: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
84: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
78: ,p_Measure_Short_Name IN VARCHAR2
79: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
80: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
82: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
84: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
79: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
80: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
82: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
84: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
87: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
80: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
82: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
84: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
87: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
88: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
81: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
82: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
84: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
87: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
88: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
89: --Fix for 1850860 starts here
82: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
83: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
84: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
87: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
88: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
89: --Fix for 1850860 starts here
90: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
83: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
84: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
87: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
88: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
89: --Fix for 1850860 starts here
90: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
91: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
84: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
85: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
86: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
87: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
88: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
89: --Fix for 1850860 starts here
90: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
91: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
92: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
86: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
87: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
88: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
89: --Fix for 1850860 starts here
90: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
91: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
92: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
93: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
94: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
87: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
88: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
89: --Fix for 1850860 starts here
90: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
91: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
92: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
93: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
94: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
95: -- Fix for 1850860 ends here
88: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
89: --Fix for 1850860 starts here
90: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
91: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
92: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
93: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
94: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
95: -- Fix for 1850860 ends here
96: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
89: --Fix for 1850860 starts here
90: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
91: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
92: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
93: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
94: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
95: -- Fix for 1850860 ends here
96: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
97: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
90: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
91: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
92: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
93: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
94: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
95: -- Fix for 1850860 ends here
96: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
97: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
98: ,p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
94: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
95: -- Fix for 1850860 ends here
96: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
97: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
98: ,p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
99: ,p_application_id IN NUMBER := c_default_appl --2465354
100: ,x_return_status OUT NOCOPY VARCHAR2
101: ,x_msg_count OUT NOCOPY VARCHAR2
102: ,x_msg_data OUT NOCOPY VARCHAR2
104: --
105: Procedure Delete_target_levels
106: (P_TARGET_LEVEL_ID IN NUMBER
107: ,p_force_delete IN NUMBER := 0 --gbhaloti #3148615
108: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
109: ,x_return_status OUT NOCOPY VARCHAR2
110: ,x_msg_count OUT NOCOPY VARCHAR2
111: ,x_msg_data OUT NOCOPY VARCHAR2
112: );
112: );
113:
114: Procedure Update_target_levels
115: (P_TARGET_LEVEL_ID IN NUMBER
116: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
117: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
118: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
119: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
120: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
113:
114: Procedure Update_target_levels
115: (P_TARGET_LEVEL_ID IN NUMBER
116: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
117: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
118: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
119: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
120: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
121: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
114: Procedure Update_target_levels
115: (P_TARGET_LEVEL_ID IN NUMBER
116: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
117: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
118: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
119: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
120: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
121: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
115: (P_TARGET_LEVEL_ID IN NUMBER
116: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
117: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
118: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
119: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
120: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
121: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
123: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
116: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
117: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
118: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
119: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
120: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
121: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
123: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
117: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
118: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
119: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
120: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
121: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
123: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
125: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
118: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
119: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
120: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
121: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
123: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
125: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
119: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
120: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
121: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
123: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
125: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
127: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
120: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
121: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
123: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
125: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
127: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
128: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
121: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
123: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
125: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
127: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
128: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
129: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
122: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
123: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
125: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
127: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
128: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
129: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
130: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
123: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
125: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
127: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
128: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
129: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
130: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
131: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
124: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
125: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
127: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
128: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
129: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
130: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
131: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
132: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
125: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
127: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
128: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
129: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
130: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
131: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
132: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
133: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
126: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
127: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
128: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
129: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
130: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
131: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
132: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
133: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
134: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
127: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
128: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
129: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
130: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
131: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
132: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
133: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
134: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
135: ,p_SOURCE IN VARCHAR2
128: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
129: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
130: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
131: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
132: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
133: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
134: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
135: ,p_SOURCE IN VARCHAR2
136: ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
129: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
130: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
131: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
132: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
133: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
134: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
135: ,p_SOURCE IN VARCHAR2
136: ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
137: ,x_return_status OUT NOCOPY VARCHAR2
130: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
131: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
132: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
133: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
134: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
135: ,p_SOURCE IN VARCHAR2
136: ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
137: ,x_return_status OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY VARCHAR2
139: ,x_msg_data OUT NOCOPY VARCHAR2
140: );
141: --
142: Procedure Create_target_levels
143: (P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
144: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
145: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
146: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
147: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
141: --
142: Procedure Create_target_levels
143: (P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
144: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
145: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
146: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
147: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
148: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
149: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
142: Procedure Create_target_levels
143: (P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
144: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
145: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
146: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
147: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
148: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
149: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
143: (P_TARGET_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
144: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
145: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
146: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
147: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
148: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
149: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
151: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
144: ,P_TARGET_LEVEL_SHORT_NAME IN VARCHAR2
145: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
146: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
147: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
148: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
149: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
151: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
145: ,P_TARGET_LEVEL_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
146: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
147: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
148: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
149: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
151: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
153: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
146: ,P_DESCRIPTION IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
147: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
148: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
149: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
151: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
153: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
147: ,P_MEASURE_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
148: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
149: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
151: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
153: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
155: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
148: ,P_DIMENSION1_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
149: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
151: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
153: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
155: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
156: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
149: ,P_DIMENSION2_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
151: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
153: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
155: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
156: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
157: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
150: ,P_DIMENSION3_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
151: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
153: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
155: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
156: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
157: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
158: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
151: ,P_DIMENSION4_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
153: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
155: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
156: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
157: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
158: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
159: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
152: ,P_DIMENSION5_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
153: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
155: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
156: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
157: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
158: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
159: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
160: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
153: ,P_DIMENSION6_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
155: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
156: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
157: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
158: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
159: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
160: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
161: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
154: ,P_DIMENSION7_LEVEL_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
155: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
156: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
157: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
158: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
159: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
160: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
161: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
162: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
155: ,P_WORKFLOW_ITEM_TYPE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
156: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
157: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
158: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
159: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
160: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
161: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
162: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
163: ,p_SOURCE IN VARCHAR2
156: ,P_WORKFLOW_PROCESS_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
157: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
158: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
159: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
160: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
161: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
162: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
163: ,p_SOURCE IN VARCHAR2
164: ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
157: ,P_DEFAULT_NOTIFY_RESP_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
158: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
159: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
160: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
161: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
162: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
163: ,p_SOURCE IN VARCHAR2
164: ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
165: ,x_return_status OUT NOCOPY VARCHAR2
158: ,P_DEFAULT_NOT_RESP_SHORT_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
159: ,P_COMPUTING_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
160: ,P_COMPUTING_FUNCTION_NAME IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
161: ,P_REPORT_FUNCTION_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
162: ,P_UNIT_OF_MEASURE IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
163: ,p_SOURCE IN VARCHAR2
164: ,p_IS_SEED_USER IN VARCHAR2 := 'N' --2465354
165: ,x_return_status OUT NOCOPY VARCHAR2
166: ,x_msg_count OUT NOCOPY VARCHAR2
167: ,x_msg_data OUT NOCOPY VARCHAR2
168: );
169: --
170: Procedure Create_Measure_Security
171: (P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
172: ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
173: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
174: ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
175: ,P_Is_Seed_User IN VARCHAR2 := 'N' --2465354
168: );
169: --
170: Procedure Create_Measure_Security
171: (P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
172: ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
173: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
174: ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
175: ,P_Is_Seed_User IN VARCHAR2 := 'N' --2465354
176: ,x_return_status OUT NOCOPY VARCHAR2
169: --
170: Procedure Create_Measure_Security
171: (P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
172: ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
173: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
174: ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
175: ,P_Is_Seed_User IN VARCHAR2 := 'N' --2465354
176: ,x_return_status OUT NOCOPY VARCHAR2
177: ,x_msg_count OUT NOCOPY VARCHAR2
170: Procedure Create_Measure_Security
171: (P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
172: ,P_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
173: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
174: ,P_Responsibility_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
175: ,P_Is_Seed_User IN VARCHAR2 := 'N' --2465354
176: ,x_return_status OUT NOCOPY VARCHAR2
177: ,x_msg_count OUT NOCOPY VARCHAR2
178: ,x_msg_data OUT NOCOPY VARCHAR2
178: ,x_msg_data OUT NOCOPY VARCHAR2
179: );
180: --
181: Procedure Delete_Measure_Security
182: (P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
183: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
184: ,x_return_status OUT NOCOPY VARCHAR2
185: ,x_msg_count OUT NOCOPY VARCHAR2
186: ,x_msg_data OUT NOCOPY VARCHAR2
179: );
180: --
181: Procedure Delete_Measure_Security
182: (P_Target_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
183: ,P_Responsibility_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
184: ,x_return_status OUT NOCOPY VARCHAR2
185: ,x_msg_count OUT NOCOPY VARCHAR2
186: ,x_msg_data OUT NOCOPY VARCHAR2
187: );
186: ,x_msg_data OUT NOCOPY VARCHAR2
187: );
188: --
189: PROCEDURE CREATE_TARGET
190: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
191: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
192: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
193: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
194: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
188: --
189: PROCEDURE CREATE_TARGET
190: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
191: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
192: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
193: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
194: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
195: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
196: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
189: PROCEDURE CREATE_TARGET
190: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
191: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
192: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
193: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
194: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
195: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
196: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
190: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
191: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
192: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
193: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
194: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
195: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
196: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
191: ,p_is_dbimeasure IN NUMBER := 0 --gbhaloti #3148615
192: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
193: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
194: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
195: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
196: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
192: ,p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
193: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
194: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
195: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
196: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
193: ,p_Target_Level_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
194: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
195: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
196: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
194: ,p_Target_Level_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
195: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
196: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
195: ,p_plan_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
196: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
196: ,p_plan_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
204: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
197: ,p_dim1_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
204: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
205: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
198: ,p_dim1_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
204: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
205: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
206: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
199: ,p_dim2_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
204: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
205: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
206: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
207: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
200: ,p_dim2_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
204: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
205: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
206: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
207: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
208: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
201: ,p_dim3_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
204: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
205: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
206: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
207: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
208: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
209: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
202: ,p_dim3_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
204: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
205: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
206: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
207: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
208: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
209: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
210: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
203: ,p_dim4_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
204: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
205: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
206: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
207: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
208: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
209: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
210: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
211: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
204: ,p_dim4_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
205: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
206: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
207: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
208: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
209: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
210: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
211: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
212: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
205: ,p_dim5_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
206: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
207: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
208: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
209: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
210: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
211: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
212: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
213: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
206: ,p_dim5_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
207: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
208: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
209: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
210: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
211: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
212: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
213: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
207: ,p_dim6_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
208: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
209: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
210: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
211: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
212: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
213: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
215: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
208: ,p_dim6_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
209: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
210: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
211: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
212: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
213: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
215: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
216: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
209: ,p_dim7_level_value_id IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
210: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
211: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
212: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
213: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
215: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
216: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
210: ,p_dim7_level_value_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
211: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
212: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
213: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
215: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
216: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
218: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
211: ,p_target IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
212: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
213: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
215: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
216: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
218: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
219: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
212: ,p_range1_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
213: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
215: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
216: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
218: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
219: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
213: ,p_range1_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
215: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
216: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
218: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
219: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
221: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
214: ,p_range2_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
215: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
216: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
218: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
219: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
221: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
215: ,p_range2_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
216: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
218: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
219: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
221: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
223: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
216: ,p_range3_low IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
218: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
219: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
221: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
223: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
224: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
217: ,p_range3_high IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
218: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
219: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
221: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
223: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
224: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
218: ,p_notify_resp1_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
219: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
221: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
223: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
224: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
226: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
219: ,p_notify_resp1_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
220: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
221: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
223: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
224: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
226: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
227: ,x_return_status OUT NOCOPY VARCHAR2
220: ,p_notify_resp1_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
221: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
223: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
224: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
226: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
227: ,x_return_status OUT NOCOPY VARCHAR2
228: ,x_msg_count OUt NOCOPY NUMBER
221: ,p_notify_resp2_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
222: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
223: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
224: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
226: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
227: ,x_return_status OUT NOCOPY VARCHAR2
228: ,x_msg_count OUt NOCOPY NUMBER
229: ,x_msg_data OUT NOCOPY VARCHAR2
222: ,p_notify_resp2_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
223: ,p_notify_resp2_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
224: ,p_notify_resp3_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
225: ,p_notify_resp3_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
226: ,p_notify_resp3_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
227: ,x_return_status OUT NOCOPY VARCHAR2
228: ,x_msg_count OUt NOCOPY NUMBER
229: ,x_msg_data OUT NOCOPY VARCHAR2
230: );
231: --
232:
233: --
234: PROCEDURE DELETE_TARGET
235: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
236: ,p_Target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
237: ,p_target_level_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
238: ,x_return_Status OUT NOCOPY VARCHAR2
239: ,x_msg_count OUT NOCOPY NUMBER
232:
233: --
234: PROCEDURE DELETE_TARGET
235: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
236: ,p_Target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
237: ,p_target_level_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
238: ,x_return_Status OUT NOCOPY VARCHAR2
239: ,x_msg_count OUT NOCOPY NUMBER
240: ,x_msg_Data OUT NOCOPY VARCHAR2
233: --
234: PROCEDURE DELETE_TARGET
235: (p_target_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
236: ,p_Target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
237: ,p_target_level_short_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
238: ,x_return_Status OUT NOCOPY VARCHAR2
239: ,x_msg_count OUT NOCOPY NUMBER
240: ,x_msg_Data OUT NOCOPY VARCHAR2
241: );
240: ,x_msg_Data OUT NOCOPY VARCHAR2
241: );
242: --
243: PROCEDURE GET_TIME_LEVEL_ID
244: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
245: ,p_target_level_id IN NUMBER
246: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
247: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
248: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
242: --
243: PROCEDURE GET_TIME_LEVEL_ID
244: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
245: ,p_target_level_id IN NUMBER
246: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
247: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
248: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
249: ,x_Sequence_no OUT NOCOPY NUMBER
250: ,x_dim_level_id OUT NOCOPY NUMBER
243: PROCEDURE GET_TIME_LEVEL_ID
244: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
245: ,p_target_level_id IN NUMBER
246: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
247: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
248: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
249: ,x_Sequence_no OUT NOCOPY NUMBER
250: ,x_dim_level_id OUT NOCOPY NUMBER
251: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
244: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
245: ,p_target_level_id IN NUMBER
246: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
247: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
248: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
249: ,x_Sequence_no OUT NOCOPY NUMBER
250: ,x_dim_level_id OUT NOCOPY NUMBER
251: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
252: ,x_dim_level_name OUT NOCOPY VARCHAR2
250: ,x_dim_level_id OUT NOCOPY NUMBER
251: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
252: ,x_dim_level_name OUT NOCOPY VARCHAR2
253: ,x_return_status OUT NOCOPY VARCHAR2
254: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
255: );
256: --
257: PROCEDURE GET_TIME_LEVEL_ID
258: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
254: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
255: );
256: --
257: PROCEDURE GET_TIME_LEVEL_ID
258: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
259: ,p_target_level_id IN NUMBER
260: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
261: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
262: ,x_Sequence_no OUT NOCOPY NUMBER
256: --
257: PROCEDURE GET_TIME_LEVEL_ID
258: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
259: ,p_target_level_id IN NUMBER
260: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
261: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
262: ,x_Sequence_no OUT NOCOPY NUMBER
263: ,x_dim_level_id OUT NOCOPY NUMBER
264: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
257: PROCEDURE GET_TIME_LEVEL_ID
258: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
259: ,p_target_level_id IN NUMBER
260: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
261: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
262: ,x_Sequence_no OUT NOCOPY NUMBER
263: ,x_dim_level_id OUT NOCOPY NUMBER
264: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
265: ,x_dim_level_name OUT NOCOPY VARCHAR2
266: ,x_return_status OUT NOCOPY VARCHAR2
267: );
268: --
269: PROCEDURE GET_ORG_LEVEL_ID
270: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
271: ,p_target_level_id IN NUMBER
272: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
273: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
274: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
268: --
269: PROCEDURE GET_ORG_LEVEL_ID
270: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
271: ,p_target_level_id IN NUMBER
272: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
273: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
274: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
275: ,x_Sequence_no OUT NOCOPY NUMBER
276: ,x_dim_level_id OUT NOCOPY NUMBER
269: PROCEDURE GET_ORG_LEVEL_ID
270: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
271: ,p_target_level_id IN NUMBER
272: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
273: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
274: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
275: ,x_Sequence_no OUT NOCOPY NUMBER
276: ,x_dim_level_id OUT NOCOPY NUMBER
277: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
270: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
271: ,p_target_level_id IN NUMBER
272: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
273: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
274: ,p_source IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
275: ,x_Sequence_no OUT NOCOPY NUMBER
276: ,x_dim_level_id OUT NOCOPY NUMBER
277: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
278: ,x_dim_level_name OUT NOCOPY VARCHAR2
276: ,x_dim_level_id OUT NOCOPY NUMBER
277: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
278: ,x_dim_level_name OUT NOCOPY VARCHAR2
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
281: );
282: --
283: PROCEDURE GET_ORG_LEVEL_ID
284: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
280: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
281: );
282: --
283: PROCEDURE GET_ORG_LEVEL_ID
284: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
285: ,p_target_level_id IN NUMBER
286: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
287: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
288: ,x_sequence_no OUT NOCOPY NUMBER
282: --
283: PROCEDURE GET_ORG_LEVEL_ID
284: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
285: ,p_target_level_id IN NUMBER
286: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
287: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
288: ,x_sequence_no OUT NOCOPY NUMBER
289: ,x_dim_level_id OUT NOCOPY NUMBER
290: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
283: PROCEDURE GET_ORG_LEVEL_ID
284: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM
285: ,p_target_level_id IN NUMBER
286: ,p_perf_measure_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
287: ,p_target_level_short_name IN VARCHAR2 DEFAULT BIS_UTILITIES_PUB.G_NULL_CHAR
288: ,x_sequence_no OUT NOCOPY NUMBER
289: ,x_dim_level_id OUT NOCOPY NUMBER
290: ,x_dim_level_short_name OUT NOCOPY VARCHAR2
291: ,x_dim_level_name OUT NOCOPY VARCHAR2
292: ,x_return_status OUT NOCOPY VARCHAR2
293: );
294: --
295: PROCEDURE ADD_TO_FND_MSG_STACK
296: (p_error_tbl IN BIS_UTILITIES_PUB.ERROR_TBL_TYPE
297: ,x_msg_count OUT NOCOPY NUMBER
298: ,x_msg_data OUT NOCOPY VARCHAR2
299: ,x_return_status OUT NOCOPY VARCHAR2
300: );
421: ,x_org_sequence_number OUT NOCOPY NUMBER
422: );
423: PROCEDURE UPDATE_MEASURE_SECURITY
424: (
425: p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
426: p_responsibilities IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY VARCHAR2,
429: x_msg_data OUT NOCOPY VARCHAR2
422: );
423: PROCEDURE UPDATE_MEASURE_SECURITY
424: (
425: p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
426: p_responsibilities IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY VARCHAR2,
429: x_msg_data OUT NOCOPY VARCHAR2
430: );
429: x_msg_data OUT NOCOPY VARCHAR2
430: );
431: PROCEDURE GET_TARGET_LEVEL_NAMES
432: (
433: p_target_level_id IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
434: x_measure_name OUT NOCOPY VARCHAR2,
435: x_dim_names OUT NOCOPY VARCHAR2,
436: x_return_status OUT NOCOPY VARCHAR2,
437: x_msg_count OUT NOCOPY VARCHAR2,
448:
449: -- Fix for 2126074 starts here
450:
451: Procedure Retrieve_Performance_Measure
452: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
453: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
454: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
455: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
449: -- Fix for 2126074 starts here
450:
451: Procedure Retrieve_Performance_Measure
452: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
453: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
454: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
455: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
457: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
450:
451: Procedure Retrieve_Performance_Measure
452: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
453: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
454: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
455: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
457: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
458: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
451: Procedure Retrieve_Performance_Measure
452: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
453: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
454: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
455: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
457: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
458: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
459: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
452: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
453: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
454: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
455: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
457: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
458: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
459: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
460: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
453: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
454: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
455: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
457: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
458: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
459: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
460: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
461: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
454: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
455: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
457: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
458: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
459: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
460: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
461: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
462: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
455: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
457: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
458: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
459: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
460: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
461: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
462: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
463: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
456: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
457: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
458: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
459: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
460: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
461: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
462: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
463: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
464: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
457: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
458: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
459: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
460: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
461: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
462: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
463: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
464: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
465: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
458: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
459: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
460: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
461: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
462: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
463: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
464: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
465: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
466: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
459: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
460: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
461: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
462: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
463: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
464: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
465: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
466: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
467: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
460: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
461: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
462: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
463: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
464: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
465: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
466: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
467: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
468: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
461: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
462: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
463: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
464: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
465: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
466: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
467: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
468: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
469: ,x_return_status OUT NOCOPY VARCHAR2
462: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
463: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
464: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
465: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
466: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
467: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
468: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
469: ,x_return_status OUT NOCOPY VARCHAR2
470: ,x_msg_count OUT NOCOPY VARCHAR2
463: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
464: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
465: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
466: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
467: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
468: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
469: ,x_return_status OUT NOCOPY VARCHAR2
470: ,x_msg_count OUT NOCOPY VARCHAR2
471: ,x_msg_data OUT NOCOPY VARCHAR2
464: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
465: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
466: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
467: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
468: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
469: ,x_return_status OUT NOCOPY VARCHAR2
470: ,x_msg_count OUT NOCOPY VARCHAR2
471: ,x_msg_data OUT NOCOPY VARCHAR2
472: ,x_Measure_ID OUT NOCOPY NUMBER
494: -- Fix for 2126074 ends here
495:
496: -- overloaded with enable_link param for bug 2440739
497: Procedure Retrieve_Performance_Measure
498: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
499: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
500: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
501: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
495:
496: -- overloaded with enable_link param for bug 2440739
497: Procedure Retrieve_Performance_Measure
498: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
499: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
500: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
501: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
503: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
496: -- overloaded with enable_link param for bug 2440739
497: Procedure Retrieve_Performance_Measure
498: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
499: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
500: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
501: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
503: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
504: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
497: Procedure Retrieve_Performance_Measure
498: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
499: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
500: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
501: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
503: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
504: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
505: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
498: (p_Measure_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
499: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
500: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
501: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
503: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
504: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
505: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
506: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
499: ,p_Measure_Short_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
500: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
501: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
503: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
504: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
505: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
506: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
507: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
500: ,p_Measure_Name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
501: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
503: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
504: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
505: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
506: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
507: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
508: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
501: ,p_Description IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
503: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
504: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
505: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
506: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
507: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
508: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
509: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
502: ,p_Dimension1_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
503: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
504: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
505: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
506: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
507: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
508: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
509: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
510: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
503: ,p_Dimension2_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
504: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
505: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
506: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
507: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
508: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
509: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
510: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
511: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
504: ,p_Dimension3_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
505: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
506: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
507: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
508: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
509: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
510: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
511: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
512: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
505: ,p_Dimension4_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
506: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
507: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
508: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
509: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
510: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
511: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
512: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
513: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
506: ,p_Dimension5_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
507: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
508: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
509: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
510: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
511: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
512: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
513: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
514: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
507: ,p_Dimension6_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
508: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
509: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
510: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
511: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
512: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
513: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
514: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
515: ,p_enable_link IN VARCHAR2 := c_hide_url
508: ,p_Dimension7_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
509: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
510: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
511: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
512: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
513: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
514: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
515: ,p_enable_link IN VARCHAR2 := c_hide_url
516: ,x_return_status OUT NOCOPY VARCHAR2
509: ,p_Unit_Of_Measure_Class IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
510: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
511: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
512: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
513: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
514: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
515: ,p_enable_link IN VARCHAR2 := c_hide_url
516: ,x_return_status OUT NOCOPY VARCHAR2
517: ,x_msg_count OUT NOCOPY VARCHAR2
510: ,p_actual_data_source_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
511: ,p_actual_data_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
512: ,p_function_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
513: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
514: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
515: ,p_enable_link IN VARCHAR2 := c_hide_url
516: ,x_return_status OUT NOCOPY VARCHAR2
517: ,x_msg_count OUT NOCOPY VARCHAR2
518: ,x_msg_data OUT NOCOPY VARCHAR2