APPS.BIS_JAVASCRIPTLOV_PVT dependencies on BIS_UTILITIES_PVT

Line 135: l_where_clause := bis_utilities_pvt.perf_measure_where_clause(p_parameter1);

131:
132: l_lov_sql := 'select measure_id, measure_name from bisfv_performance_measures perfMeasuresList, BSC_SYS_DATASETS_B ds WHERE perfMeasuresList.dataset_id = ds.dataset_id AND perfMeasuresList.Obsolete = ''F'' AND ds.source = '||'''' || l_meas_src ||'''';
133: if p_lov_type = G_PERF_MEAS_S_LOV then
134: if p_parameter1 is not null then
135: l_where_clause := bis_utilities_pvt.perf_measure_where_clause(p_parameter1);
136: end if;
137: if l_where_clause is null then
138: l_lov_sql := l_lov_sql || ' AND upper(measure_name) like ' || 'replace('|| ':1' || ',' || '''''''''' || ',' || '''''''''''''' || ') ';
139: else

Line 190: l_where_clause := bis_utilities_pvt.target_level_where_clause(p_parameter1);

186:
187: /* p_lov_type = G_TARGET_LEVEL_S_LOV is no more used after bug #3448500 */
188: if p_lov_type = G_TARGET_LEVEL_S_LOV then
189: if p_parameter1 is not null then
190: l_where_clause := bis_utilities_pvt.target_level_where_clause(p_parameter1);
191: end if;
192:
193: if l_where_clause is null then
194: l_lov_sql := l_lov_sql || l_temp1 || ' like ' || 'replace('|| ':1' || ',' || '''''''''' || ',' || '''''''''''''' || ') ';