eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PMV_ACTUAL_PVT dependencies on BISVIEWER

Line 148: l_attr_codes BISVIEWER.t_char;

144: l_target_alias VARCHAR2(50);
145: l_has_target VARCHAR2(1);
146: l_cursor integer;
147: l_desc_tab dbms_sql.desc_tab;
148: l_attr_codes BISVIEWER.t_char;
149: l_attr_values BISVIEWER.t_char;
150: l_actual_value varchar2(2000);
151: l_compareto_value varchar2(2000);
152: l_actual_val_cnt number := 0;

Line 149: l_attr_values BISVIEWER.t_char;

145: l_has_target VARCHAR2(1);
146: l_cursor integer;
147: l_desc_tab dbms_sql.desc_tab;
148: l_attr_codes BISVIEWER.t_char;
149: l_attr_values BISVIEWER.t_char;
150: l_actual_value varchar2(2000);
151: l_compareto_value varchar2(2000);
152: l_actual_val_cnt number := 0;
153: l_compareto_val_cnt number:=0;

Line 159: l_bind_var_tbl BISVIEWER.t_char;

155: ignore integer;
156: l_row_found integer := 0;
157: l_bind_variables varchar2(32000);
158: l_plsql_bind_variables varchar2(32000);
159: l_bind_var_tbl BISVIEWER.t_char;
160: l_bind_indexes varchar2(32000);
161: --l_bind_index_tbl BISVIEWER.t_char;
162:
163: l_startIndex NUMBER;

Line 161: --l_bind_index_tbl BISVIEWER.t_char;

157: l_bind_variables varchar2(32000);
158: l_plsql_bind_variables varchar2(32000);
159: l_bind_var_tbl BISVIEWER.t_char;
160: l_bind_indexes varchar2(32000);
161: --l_bind_index_tbl BISVIEWER.t_char;
162:
163: l_startIndex NUMBER;
164: l_endIndex NUMBER;
165: l_bind_var VARCHAR2(32000);

Line 176: l_base_columns BISVIEWER.t_char;

172: --l_temp_actual_formula varchar2(2000);
173: l_compareto_formula varchar2(2000);
174: --l_temp_compareto_formula varchar2(2000);
175: l_sql varchar2(2000);
176: l_base_columns BISVIEWER.t_char;
177: l_actual_attr_codes BISVIEWER.t_char;
178: l_compareto_attr_codes BISVIEWER.t_char;
179: l_actual_base_columns BISVIEWER.t_char;
180: l_compareto_base_columns BISVIEWER.t_char;

Line 177: l_actual_attr_codes BISVIEWER.t_char;

173: l_compareto_formula varchar2(2000);
174: --l_temp_compareto_formula varchar2(2000);
175: l_sql varchar2(2000);
176: l_base_columns BISVIEWER.t_char;
177: l_actual_attr_codes BISVIEWER.t_char;
178: l_compareto_attr_codes BISVIEWER.t_char;
179: l_actual_base_columns BISVIEWER.t_char;
180: l_compareto_base_columns BISVIEWER.t_char;
181: l_sorted_actual_base_columns BISVIEWER.t_char;

Line 178: l_compareto_attr_codes BISVIEWER.t_char;

174: --l_temp_compareto_formula varchar2(2000);
175: l_sql varchar2(2000);
176: l_base_columns BISVIEWER.t_char;
177: l_actual_attr_codes BISVIEWER.t_char;
178: l_compareto_attr_codes BISVIEWER.t_char;
179: l_actual_base_columns BISVIEWER.t_char;
180: l_compareto_base_columns BISVIEWER.t_char;
181: l_sorted_actual_base_columns BISVIEWER.t_char;
182: l_sorted_compare_base_columns BISVIEWER.t_char;

Line 179: l_actual_base_columns BISVIEWER.t_char;

175: l_sql varchar2(2000);
176: l_base_columns BISVIEWER.t_char;
177: l_actual_attr_codes BISVIEWER.t_char;
178: l_compareto_attr_codes BISVIEWER.t_char;
179: l_actual_base_columns BISVIEWER.t_char;
180: l_compareto_base_columns BISVIEWER.t_char;
181: l_sorted_actual_base_columns BISVIEWER.t_char;
182: l_sorted_compare_base_columns BISVIEWER.t_char;
183: l_actual_values BISVIEWER.t_char;

Line 180: l_compareto_base_columns BISVIEWER.t_char;

176: l_base_columns BISVIEWER.t_char;
177: l_actual_attr_codes BISVIEWER.t_char;
178: l_compareto_attr_codes BISVIEWER.t_char;
179: l_actual_base_columns BISVIEWER.t_char;
180: l_compareto_base_columns BISVIEWER.t_char;
181: l_sorted_actual_base_columns BISVIEWER.t_char;
182: l_sorted_compare_base_columns BISVIEWER.t_char;
183: l_actual_values BISVIEWER.t_char;
184: l_compareto_values BISVIEWER.t_char;

Line 181: l_sorted_actual_base_columns BISVIEWER.t_char;

177: l_actual_attr_codes BISVIEWER.t_char;
178: l_compareto_attr_codes BISVIEWER.t_char;
179: l_actual_base_columns BISVIEWER.t_char;
180: l_compareto_base_columns BISVIEWER.t_char;
181: l_sorted_actual_base_columns BISVIEWER.t_char;
182: l_sorted_compare_base_columns BISVIEWER.t_char;
183: l_actual_values BISVIEWER.t_char;
184: l_compareto_values BISVIEWER.t_char;
185: l_calculate_actual boolean := false;

Line 182: l_sorted_compare_base_columns BISVIEWER.t_char;

178: l_compareto_attr_codes BISVIEWER.t_char;
179: l_actual_base_columns BISVIEWER.t_char;
180: l_compareto_base_columns BISVIEWER.t_char;
181: l_sorted_actual_base_columns BISVIEWER.t_char;
182: l_sorted_compare_base_columns BISVIEWER.t_char;
183: l_actual_values BISVIEWER.t_char;
184: l_compareto_values BISVIEWER.t_char;
185: l_calculate_actual boolean := false;
186: l_calculate_compareto boolean := false;

Line 183: l_actual_values BISVIEWER.t_char;

179: l_actual_base_columns BISVIEWER.t_char;
180: l_compareto_base_columns BISVIEWER.t_char;
181: l_sorted_actual_base_columns BISVIEWER.t_char;
182: l_sorted_compare_base_columns BISVIEWER.t_char;
183: l_actual_values BISVIEWER.t_char;
184: l_compareto_values BISVIEWER.t_char;
185: l_calculate_actual boolean := false;
186: l_calculate_compareto boolean := false;
187: l_actual_count number;

Line 184: l_compareto_values BISVIEWER.t_char;

180: l_compareto_base_columns BISVIEWER.t_char;
181: l_sorted_actual_base_columns BISVIEWER.t_char;
182: l_sorted_compare_base_columns BISVIEWER.t_char;
183: l_actual_values BISVIEWER.t_char;
184: l_compareto_values BISVIEWER.t_char;
185: l_calculate_actual boolean := false;
186: l_calculate_compareto boolean := false;
187: l_actual_count number;
188: l_compareto_count number;

Line 189: l_actual_col_index BISVIEWER.t_num;

185: l_calculate_actual boolean := false;
186: l_calculate_compareto boolean := false;
187: l_actual_count number;
188: l_compareto_count number;
189: l_actual_col_index BISVIEWER.t_num;
190: l_compareto_col_index BISVIEWER.t_num;
191:
192: l_temp_viewby_value varchar2(32000);
193: l_debug_msg varchar2(32000);

Line 190: l_compareto_col_index BISVIEWER.t_num;

186: l_calculate_compareto boolean := false;
187: l_actual_count number;
188: l_compareto_count number;
189: l_actual_col_index BISVIEWER.t_num;
190: l_compareto_col_index BISVIEWER.t_num;
191:
192: l_temp_viewby_value varchar2(32000);
193: l_debug_msg varchar2(32000);
194: l_plsql_function varchar2(2000);

Line 576: l_attr_codes BISVIEWER.t_char;

572: l_target_alias VARCHAR2(50);
573: l_has_target VARCHAR2(1);
574: l_cursor integer;
575: l_desc_tab dbms_sql.desc_tab;
576: l_attr_codes BISVIEWER.t_char;
577: l_attr_values BISVIEWER.t_char;
578: l_actual_value varchar2(2000);
579: l_compareto_value varchar2(2000);
580: l_actual_val_cnt number := 0;

Line 577: l_attr_values BISVIEWER.t_char;

573: l_has_target VARCHAR2(1);
574: l_cursor integer;
575: l_desc_tab dbms_sql.desc_tab;
576: l_attr_codes BISVIEWER.t_char;
577: l_attr_values BISVIEWER.t_char;
578: l_actual_value varchar2(2000);
579: l_compareto_value varchar2(2000);
580: l_actual_val_cnt number := 0;
581: l_compareto_val_cnt number:=0;

Line 589: l_bind_var_tbl BISVIEWER.t_char;

585: ignore integer;
586: l_row_found integer := 0;
587: l_bind_variables varchar2(32000);
588: l_plsql_bind_variables varchar2(32000);
589: l_bind_var_tbl BISVIEWER.t_char;
590: l_bind_indexes varchar2(32000);
591: --l_bind_index_tbl BISVIEWER.t_char;
592: l_startIndex NUMBER;
593: l_endIndex NUMBER;

Line 591: --l_bind_index_tbl BISVIEWER.t_char;

587: l_bind_variables varchar2(32000);
588: l_plsql_bind_variables varchar2(32000);
589: l_bind_var_tbl BISVIEWER.t_char;
590: l_bind_indexes varchar2(32000);
591: --l_bind_index_tbl BISVIEWER.t_char;
592: l_startIndex NUMBER;
593: l_endIndex NUMBER;
594: l_bind_var VARCHAR2(32000);
595: l_tab_index NUMBER := 1;

Line 659: l_base_columns BISVIEWER.t_char;

655: --l_temp_actual_formula varchar2(2000);
656: l_compareto_formula varchar2(2000);
657: --l_temp_compareto_formula varchar2(2000);
658: l_sql varchar2(2000);
659: l_base_columns BISVIEWER.t_char;
660: l_actual_attr_codes BISVIEWER.t_char;
661: l_compareto_attr_codes BISVIEWER.t_char;
662: l_actual_base_columns BISVIEWER.t_char;
663: l_compareto_base_columns BISVIEWER.t_char;

Line 660: l_actual_attr_codes BISVIEWER.t_char;

656: l_compareto_formula varchar2(2000);
657: --l_temp_compareto_formula varchar2(2000);
658: l_sql varchar2(2000);
659: l_base_columns BISVIEWER.t_char;
660: l_actual_attr_codes BISVIEWER.t_char;
661: l_compareto_attr_codes BISVIEWER.t_char;
662: l_actual_base_columns BISVIEWER.t_char;
663: l_compareto_base_columns BISVIEWER.t_char;
664: l_sorted_actual_base_columns BISVIEWER.t_char;

Line 661: l_compareto_attr_codes BISVIEWER.t_char;

657: --l_temp_compareto_formula varchar2(2000);
658: l_sql varchar2(2000);
659: l_base_columns BISVIEWER.t_char;
660: l_actual_attr_codes BISVIEWER.t_char;
661: l_compareto_attr_codes BISVIEWER.t_char;
662: l_actual_base_columns BISVIEWER.t_char;
663: l_compareto_base_columns BISVIEWER.t_char;
664: l_sorted_actual_base_columns BISVIEWER.t_char;
665: l_sorted_compare_base_columns BISVIEWER.t_char;

Line 662: l_actual_base_columns BISVIEWER.t_char;

658: l_sql varchar2(2000);
659: l_base_columns BISVIEWER.t_char;
660: l_actual_attr_codes BISVIEWER.t_char;
661: l_compareto_attr_codes BISVIEWER.t_char;
662: l_actual_base_columns BISVIEWER.t_char;
663: l_compareto_base_columns BISVIEWER.t_char;
664: l_sorted_actual_base_columns BISVIEWER.t_char;
665: l_sorted_compare_base_columns BISVIEWER.t_char;
666: l_actual_values BISVIEWER.t_char;

Line 663: l_compareto_base_columns BISVIEWER.t_char;

659: l_base_columns BISVIEWER.t_char;
660: l_actual_attr_codes BISVIEWER.t_char;
661: l_compareto_attr_codes BISVIEWER.t_char;
662: l_actual_base_columns BISVIEWER.t_char;
663: l_compareto_base_columns BISVIEWER.t_char;
664: l_sorted_actual_base_columns BISVIEWER.t_char;
665: l_sorted_compare_base_columns BISVIEWER.t_char;
666: l_actual_values BISVIEWER.t_char;
667: l_compareto_values BISVIEWER.t_char;

Line 664: l_sorted_actual_base_columns BISVIEWER.t_char;

660: l_actual_attr_codes BISVIEWER.t_char;
661: l_compareto_attr_codes BISVIEWER.t_char;
662: l_actual_base_columns BISVIEWER.t_char;
663: l_compareto_base_columns BISVIEWER.t_char;
664: l_sorted_actual_base_columns BISVIEWER.t_char;
665: l_sorted_compare_base_columns BISVIEWER.t_char;
666: l_actual_values BISVIEWER.t_char;
667: l_compareto_values BISVIEWER.t_char;
668: l_calculate_actual boolean := false;

Line 665: l_sorted_compare_base_columns BISVIEWER.t_char;

661: l_compareto_attr_codes BISVIEWER.t_char;
662: l_actual_base_columns BISVIEWER.t_char;
663: l_compareto_base_columns BISVIEWER.t_char;
664: l_sorted_actual_base_columns BISVIEWER.t_char;
665: l_sorted_compare_base_columns BISVIEWER.t_char;
666: l_actual_values BISVIEWER.t_char;
667: l_compareto_values BISVIEWER.t_char;
668: l_calculate_actual boolean := false;
669: l_calculate_compareto boolean := false;

Line 666: l_actual_values BISVIEWER.t_char;

662: l_actual_base_columns BISVIEWER.t_char;
663: l_compareto_base_columns BISVIEWER.t_char;
664: l_sorted_actual_base_columns BISVIEWER.t_char;
665: l_sorted_compare_base_columns BISVIEWER.t_char;
666: l_actual_values BISVIEWER.t_char;
667: l_compareto_values BISVIEWER.t_char;
668: l_calculate_actual boolean := false;
669: l_calculate_compareto boolean := false;
670: l_actual_count number;

Line 667: l_compareto_values BISVIEWER.t_char;

663: l_compareto_base_columns BISVIEWER.t_char;
664: l_sorted_actual_base_columns BISVIEWER.t_char;
665: l_sorted_compare_base_columns BISVIEWER.t_char;
666: l_actual_values BISVIEWER.t_char;
667: l_compareto_values BISVIEWER.t_char;
668: l_calculate_actual boolean := false;
669: l_calculate_compareto boolean := false;
670: l_actual_count number;
671: l_compareto_count number;

Line 672: l_actual_col_index BISVIEWER.t_num;

668: l_calculate_actual boolean := false;
669: l_calculate_compareto boolean := false;
670: l_actual_count number;
671: l_compareto_count number;
672: l_actual_col_index BISVIEWER.t_num;
673: l_compareto_col_index BISVIEWER.t_num;
674: l_viewby_value varchar2(2000);
675: l_viewbyid_value varchar2(2000);
676: l_temp_viewby_value varchar2(32000);

Line 673: l_compareto_col_index BISVIEWER.t_num;

669: l_calculate_compareto boolean := false;
670: l_actual_count number;
671: l_compareto_count number;
672: l_actual_col_index BISVIEWER.t_num;
673: l_compareto_col_index BISVIEWER.t_num;
674: l_viewby_value varchar2(2000);
675: l_viewbyid_value varchar2(2000);
676: l_temp_viewby_value varchar2(32000);
677: l_debug_msg varchar2(32000);

Line 1653: x_bind_var_tbl out NOCOPY BISVIEWER.t_char)

1649: END STORE_PARAMETERS;
1650:
1651: PROCEDURE SETUP_BIND_VARIABLES
1652: (p_bind_variables in varchar2,
1653: x_bind_var_tbl out NOCOPY BISVIEWER.t_char)
1654: is
1655: l_startIndex NUMBER;
1656: l_endIndex NUMBER;
1657: l_bind_var VARCHAR2(32000);

Line 1756: l_bind_var_tbl BISVIEWER.t_char;

1752: ignore integer;
1753: l_row_found integer := 0;
1754: l_bind_variables varchar2(32000);
1755: l_plsql_bind_variables varchar2(32000);
1756: l_bind_var_tbl BISVIEWER.t_char;
1757: l_bind_indexes varchar2(32000);
1758: l_bind_var VARCHAR2(32000);
1759: l_tab_index NUMBER := 1;
1760: l_bind_col VARCHAR2(2000);

Line 1778: l_measure_attr_codes BISVIEWER.t_char;

1774: l_ranking_attr varchar2(2000);
1775: l_ranking_dim varchar2(2000);
1776: l_count number := 0;
1777:
1778: l_measure_attr_codes BISVIEWER.t_char;
1779: l_measure_base_columns BISVIEWER.t_char;
1780: l_selected_attr_codes BISVIEWER.t_char;
1781: l_selected_base_columns BISVIEWER.t_char;
1782: l_selected_base_columns2 BISVIEWER.t_char;

Line 1779: l_measure_base_columns BISVIEWER.t_char;

1775: l_ranking_dim varchar2(2000);
1776: l_count number := 0;
1777:
1778: l_measure_attr_codes BISVIEWER.t_char;
1779: l_measure_base_columns BISVIEWER.t_char;
1780: l_selected_attr_codes BISVIEWER.t_char;
1781: l_selected_base_columns BISVIEWER.t_char;
1782: l_selected_base_columns2 BISVIEWER.t_char;
1783: l_selected_measure_values BISVIEWER.t_char;

Line 1780: l_selected_attr_codes BISVIEWER.t_char;

1776: l_count number := 0;
1777:
1778: l_measure_attr_codes BISVIEWER.t_char;
1779: l_measure_base_columns BISVIEWER.t_char;
1780: l_selected_attr_codes BISVIEWER.t_char;
1781: l_selected_base_columns BISVIEWER.t_char;
1782: l_selected_base_columns2 BISVIEWER.t_char;
1783: l_selected_measure_values BISVIEWER.t_char;
1784: l_selected_gt_values BISVIEWER.t_char;

Line 1781: l_selected_base_columns BISVIEWER.t_char;

1777:
1778: l_measure_attr_codes BISVIEWER.t_char;
1779: l_measure_base_columns BISVIEWER.t_char;
1780: l_selected_attr_codes BISVIEWER.t_char;
1781: l_selected_base_columns BISVIEWER.t_char;
1782: l_selected_base_columns2 BISVIEWER.t_char;
1783: l_selected_measure_values BISVIEWER.t_char;
1784: l_selected_gt_values BISVIEWER.t_char;
1785: l_selected_col_index BISVIEWER.t_num;

Line 1782: l_selected_base_columns2 BISVIEWER.t_char;

1778: l_measure_attr_codes BISVIEWER.t_char;
1779: l_measure_base_columns BISVIEWER.t_char;
1780: l_selected_attr_codes BISVIEWER.t_char;
1781: l_selected_base_columns BISVIEWER.t_char;
1782: l_selected_base_columns2 BISVIEWER.t_char;
1783: l_selected_measure_values BISVIEWER.t_char;
1784: l_selected_gt_values BISVIEWER.t_char;
1785: l_selected_col_index BISVIEWER.t_num;
1786: l_selected_gt_index BISVIEWER.t_num;

Line 1783: l_selected_measure_values BISVIEWER.t_char;

1779: l_measure_base_columns BISVIEWER.t_char;
1780: l_selected_attr_codes BISVIEWER.t_char;
1781: l_selected_base_columns BISVIEWER.t_char;
1782: l_selected_base_columns2 BISVIEWER.t_char;
1783: l_selected_measure_values BISVIEWER.t_char;
1784: l_selected_gt_values BISVIEWER.t_char;
1785: l_selected_col_index BISVIEWER.t_num;
1786: l_selected_gt_index BISVIEWER.t_num;
1787: l_gt_index BISVIEWER.t_num;

Line 1784: l_selected_gt_values BISVIEWER.t_char;

1780: l_selected_attr_codes BISVIEWER.t_char;
1781: l_selected_base_columns BISVIEWER.t_char;
1782: l_selected_base_columns2 BISVIEWER.t_char;
1783: l_selected_measure_values BISVIEWER.t_char;
1784: l_selected_gt_values BISVIEWER.t_char;
1785: l_selected_col_index BISVIEWER.t_num;
1786: l_selected_gt_index BISVIEWER.t_num;
1787: l_gt_index BISVIEWER.t_num;
1788: l_gt_attr_code varchar2(2000);

Line 1785: l_selected_col_index BISVIEWER.t_num;

1781: l_selected_base_columns BISVIEWER.t_char;
1782: l_selected_base_columns2 BISVIEWER.t_char;
1783: l_selected_measure_values BISVIEWER.t_char;
1784: l_selected_gt_values BISVIEWER.t_char;
1785: l_selected_col_index BISVIEWER.t_num;
1786: l_selected_gt_index BISVIEWER.t_num;
1787: l_gt_index BISVIEWER.t_num;
1788: l_gt_attr_code varchar2(2000);
1789: l_measure_value varchar2(2000);

Line 1786: l_selected_gt_index BISVIEWER.t_num;

1782: l_selected_base_columns2 BISVIEWER.t_char;
1783: l_selected_measure_values BISVIEWER.t_char;
1784: l_selected_gt_values BISVIEWER.t_char;
1785: l_selected_col_index BISVIEWER.t_num;
1786: l_selected_gt_index BISVIEWER.t_num;
1787: l_gt_index BISVIEWER.t_num;
1788: l_gt_attr_code varchar2(2000);
1789: l_measure_value varchar2(2000);
1790: l_gt_value varchar2(2000);

Line 1787: l_gt_index BISVIEWER.t_num;

1783: l_selected_measure_values BISVIEWER.t_char;
1784: l_selected_gt_values BISVIEWER.t_char;
1785: l_selected_col_index BISVIEWER.t_num;
1786: l_selected_gt_index BISVIEWER.t_num;
1787: l_gt_index BISVIEWER.t_num;
1788: l_gt_attr_code varchar2(2000);
1789: l_measure_value varchar2(2000);
1790: l_gt_value varchar2(2000);
1791: l_viewby_id varchar2(2000);

Line 2250: ,p_measure_base_columns in BISVIEWER.t_char

2246: END GET_ACTUAL_VALUE;
2247:
2248: PROCEDURE GET_CALCULATED_VALUE
2249: (p_formula in varchar2
2250: ,p_measure_base_columns in BISVIEWER.t_char
2251: ,p_measure_values in BISVIEWER.t_char
2252: ,x_calculated_value out NOCOPY number
2253: ) IS
2254: l_formula varchar2(32000) := p_formula;

Line 2251: ,p_measure_values in BISVIEWER.t_char

2247:
2248: PROCEDURE GET_CALCULATED_VALUE
2249: (p_formula in varchar2
2250: ,p_measure_base_columns in BISVIEWER.t_char
2251: ,p_measure_values in BISVIEWER.t_char
2252: ,x_calculated_value out NOCOPY number
2253: ) IS
2254: l_formula varchar2(32000) := p_formula;
2255: l_sql varchar2(32000);

Line 2257: l_bind_values BISVIEWER.t_char;

2253: ) IS
2254: l_formula varchar2(32000) := p_formula;
2255: l_sql varchar2(32000);
2256: l_bind_count number := 0;
2257: l_bind_values BISVIEWER.t_char;
2258: l_bind_col varchar2(2000);
2259: l_cursor integer;
2260: ignore integer;
2261: BEGIN

Line 2318: (p_table1 in OUT NOCOPY BISVIEWER.t_char

2314: dbms_sql.close_cursor(l_cursor);
2315: END GET_CALCULATED_VALUE;
2316:
2317: PROCEDURE SORTBY_BASE_COLUMN_LENGTH
2318: (p_table1 in OUT NOCOPY BISVIEWER.t_char
2319: ,p_table2 in OUT NOCOPY BISVIEWER.t_char
2320: ,p_table3 in OUT NOCOPY BISVIEWER.t_num
2321: ,x_return_status OUT NOCOPY VARCHAR2
2322: ,x_msg_count OUT NOCOPY NUMBER

Line 2319: ,p_table2 in OUT NOCOPY BISVIEWER.t_char

2315: END GET_CALCULATED_VALUE;
2316:
2317: PROCEDURE SORTBY_BASE_COLUMN_LENGTH
2318: (p_table1 in OUT NOCOPY BISVIEWER.t_char
2319: ,p_table2 in OUT NOCOPY BISVIEWER.t_char
2320: ,p_table3 in OUT NOCOPY BISVIEWER.t_num
2321: ,x_return_status OUT NOCOPY VARCHAR2
2322: ,x_msg_count OUT NOCOPY NUMBER
2323: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2320: ,p_table3 in OUT NOCOPY BISVIEWER.t_num

2316:
2317: PROCEDURE SORTBY_BASE_COLUMN_LENGTH
2318: (p_table1 in OUT NOCOPY BISVIEWER.t_char
2319: ,p_table2 in OUT NOCOPY BISVIEWER.t_char
2320: ,p_table3 in OUT NOCOPY BISVIEWER.t_num
2321: ,x_return_status OUT NOCOPY VARCHAR2
2322: ,x_msg_count OUT NOCOPY NUMBER
2323: ,x_msg_data OUT NOCOPY VARCHAR2
2324: )

Line 2327: l_length_tbl BISVIEWER.t_num;

2323: ,x_msg_data OUT NOCOPY VARCHAR2
2324: )
2325: IS
2326: l_count NUMBER;
2327: l_length_tbl BISVIEWER.t_num;
2328: l_temp1 VARCHAR2(32000);
2329: l_temp2 VARCHAR2(32000);
2330: l_temp3 NUMBER;
2331: l_temp_length NUMBER;