APPS.BIS_DIMS_AND_LEVELS_PKG dependencies on BIS_UTILITIES_PVT

Line 33: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);

29:
30: FOR i IN 1..p_params.count LOOP
31:
32: l_pname := p_params(i).parameter_name;
33: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);
34:
35: -- insert into tmp2 (seq, value) values (temp_seq.nextval, '(<---------------- pname ->'||l_pname||'<-pvalue->'||l_pvalue||'<------------------>)' ); commit;
36:
37:

Line 142: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);

138: l_where_clause VARCHAR2(1500) := NULL;
139: BEGIN
140: FOR i IN 1..p_params.count LOOP
141: l_pname := p_params(i).parameter_name;
142: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);
143: l_pid := p_params(i).parameter_id;
144: IF ( l_pname = 'LVLNM+LVLNM' ) THEN -- Filter according to KPI Indicator
145: IF (l_pvalue <> 'All') THEN
146: l_kpi_name_filter := ' AND bi.indicator_id = '||l_pid ;

Line 216: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);

212:
213: FOR i IN 1..p_params.count LOOP
214:
215: l_pname := p_params(i).parameter_name;
216: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);
217:
218: -- insert into tmp2 (seq, value) values (temp_seq.nextval, '(<---------------- pname ->'||l_pname||'<-pvalue->'||l_pvalue||'<------------------>)' ); commit;
219:
220: IF ( l_pname = 'LEVEL_NAME1' ) THEN

Line 368: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);

364:
365: FOR i IN 1..p_params.count LOOP
366:
367: l_pname := p_params(i).parameter_name;
368: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);
369:
370: -- insert into tmp2 (seq, value) values (temp_seq.nextval, '(<---------------- pname ->'||l_pname||'<-pvalue->'||l_pvalue||'<------------------>)' ); commit;
371:
372: IF ( l_pname = 'LEVEL_NAME1' ) THEN

Line 503: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);

499:
500: FOR i IN 1..p_params.count LOOP
501:
502: l_pname := p_params(i).parameter_name;
503: l_pvalue := BIS_UTILITIES_PVT.filter_quotes(p_params(i).parameter_value);
504:
505: -- insert into tmp2 (seq, value) values (temp_seq.nextval, '(<---------------- pname ->'||l_pname||'<-pvalue->'||l_pvalue||'<------------------>)' ); commit;
506:
507: IF ( l_pname = 'DIMENSION_NAME' ) THEN