21: l_exp_url varchar2(1000);
22: l_req_url varchar2(1000);
23: l_custom_rec BIS_QUERY_ATTRIBUTES;
24: l_bind_ctr NUMBER;
25: l_code_table BISVIEWER.t_char;
26: l_meaning_table BISVIEWER.t_char;
27: l_type_where VARCHAR2(1000);
28: l_types VARCHAR(1000);
29: l_mean_types VARCHAR2(1000);
22: l_req_url varchar2(1000);
23: l_custom_rec BIS_QUERY_ATTRIBUTES;
24: l_bind_ctr NUMBER;
25: l_code_table BISVIEWER.t_char;
26: l_meaning_table BISVIEWER.t_char;
27: l_type_where VARCHAR2(1000);
28: l_types VARCHAR(1000);
29: l_mean_types VARCHAR2(1000);
30: l_msg_types BISVIEWER.t_char;
26: l_meaning_table BISVIEWER.t_char;
27: l_type_where VARCHAR2(1000);
28: l_types VARCHAR(1000);
29: l_mean_types VARCHAR2(1000);
30: l_msg_types BISVIEWER.t_char;
31: l_notif_count BISVIEWER.t_num;
32: l_more_msg_types BISVIEWER.t_char;
33: l_more_notif_count BISVIEWER.t_num;
34: l_found boolean;
27: l_type_where VARCHAR2(1000);
28: l_types VARCHAR(1000);
29: l_mean_types VARCHAR2(1000);
30: l_msg_types BISVIEWER.t_char;
31: l_notif_count BISVIEWER.t_num;
32: l_more_msg_types BISVIEWER.t_char;
33: l_more_notif_count BISVIEWER.t_num;
34: l_found boolean;
35: l_first boolean;
28: l_types VARCHAR(1000);
29: l_mean_types VARCHAR2(1000);
30: l_msg_types BISVIEWER.t_char;
31: l_notif_count BISVIEWER.t_num;
32: l_more_msg_types BISVIEWER.t_char;
33: l_more_notif_count BISVIEWER.t_num;
34: l_found boolean;
35: l_first boolean;
36: l_len NUMBER;
29: l_mean_types VARCHAR2(1000);
30: l_msg_types BISVIEWER.t_char;
31: l_notif_count BISVIEWER.t_num;
32: l_more_msg_types BISVIEWER.t_char;
33: l_more_notif_count BISVIEWER.t_num;
34: l_found boolean;
35: l_first boolean;
36: l_len NUMBER;
37:
185: l_type_where varchar2(250);
186: l_orderby VARCHAR2(250);
187: l_custom_rec BIS_QUERY_ATTRIBUTES;
188: l_bind_ctr NUMBER;
189: l_code_table BISVIEWER.t_char;
190: l_types VARCHAR2(250);
191: l_select_clause VARCHAR2(2000);
192: l_from_clause VARCHAR2(200);
193: l_notif_where_clause VARCHAR2(200);