98: );
99:
100: PROCEDURE SETUP_BIND_VARIABLES
101: (p_bind_variables in varchar2
102: ,x_bind_var_tbl out NOCOPY BISVIEWER.t_char
103: );
104:
105: PROCEDURE GET_ACTUAL_VALUE
106: (p_region_code IN VARCHAR2
120: );
121:
122: PROCEDURE GET_CALCULATED_VALUE
123: (p_formula in varchar2
124: ,p_measure_base_columns in BISVIEWER.t_char
125: ,p_measure_values in BISVIEWER.t_char
126: ,x_calculated_value out NOCOPY number
127: );
128:
121:
122: PROCEDURE GET_CALCULATED_VALUE
123: (p_formula in varchar2
124: ,p_measure_base_columns in BISVIEWER.t_char
125: ,p_measure_values in BISVIEWER.t_char
126: ,x_calculated_value out NOCOPY number
127: );
128:
129: PROCEDURE SORTBY_BASE_COLUMN_LENGTH
126: ,x_calculated_value out NOCOPY number
127: );
128:
129: PROCEDURE SORTBY_BASE_COLUMN_LENGTH
130: (p_table1 in OUT NOCOPY BISVIEWER.t_char
131: ,p_table2 in OUT NOCOPY BISVIEWER.t_char
132: ,p_table3 in OUT NOCOPY BISVIEWER.t_num
133: ,x_return_status OUT NOCOPY VARCHAR2
134: ,x_msg_count OUT NOCOPY NUMBER
127: );
128:
129: PROCEDURE SORTBY_BASE_COLUMN_LENGTH
130: (p_table1 in OUT NOCOPY BISVIEWER.t_char
131: ,p_table2 in OUT NOCOPY BISVIEWER.t_char
132: ,p_table3 in OUT NOCOPY BISVIEWER.t_num
133: ,x_return_status OUT NOCOPY VARCHAR2
134: ,x_msg_count OUT NOCOPY NUMBER
135: ,x_msg_data OUT NOCOPY VARCHAR2
128:
129: PROCEDURE SORTBY_BASE_COLUMN_LENGTH
130: (p_table1 in OUT NOCOPY BISVIEWER.t_char
131: ,p_table2 in OUT NOCOPY BISVIEWER.t_char
132: ,p_table3 in OUT NOCOPY BISVIEWER.t_num
133: ,x_return_status OUT NOCOPY VARCHAR2
134: ,x_msg_count OUT NOCOPY NUMBER
135: ,x_msg_data OUT NOCOPY VARCHAR2
136: );