157:
158: begin
159:
160:
161: select meaning into l_label from fnd_lookups where lookup_type='BIV_VIEW_BY'
162: and lookup_code=biv_core_pkg.g_view_by;
163:
164: return l_label;
165: end base_column_label;
188: q6_str varchar2(2000);
189: x_session number;
190: x_sev_count number;
191: l_ttl_recs number;
192: l_ttl_meaning fnd_lookups.meaning % type;
193: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
194:
195: begin
196: x_session:=biv_core_pkg.get_session_id;
563: q3_str varchar2(2000);
564: q4_str varchar2(4000);
565: x_sev_count number;
566: l_ttl_recs number;
567: l_ttl_meaning fnd_lookups.meaning % type;
568: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
569:
570: begin
571: x_session:=biv_core_pkg.get_session_id;
865: l_new_param_str varchar2(200);
866: x_session varchar2(50);
867: x_sev_count number;
868: l_ttl_recs number;
869: l_ttl_meaning fnd_lookups.meaning % type;
870: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
871:
872: begin
873: x_session:=biv_core_pkg.get_session_id;