DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_SLPERF_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 27: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

23: l_where_clause VARCHAR2(32000);
24: l_view_by varchar2(1000);
25: l_row_type varchar2(10) := 'AC';
26:
27: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
28:
29: BEGIN
30: --
31: --Initialize p_custom_output

Line 280: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

276: END IF;
277:
278: p_custom_sql := l_sqltext;
279:
280: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
281: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
282: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
283:
284: p_custom_output.EXTEND;

Line 281: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

277:
278: p_custom_sql := l_sqltext;
279:
280: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
281: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
282: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
283:
284: p_custom_output.EXTEND;
285: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

Line 290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

286:
287: IF ( l_account IS NOT NULL) THEN
288: l_custom_rec.attribute_name := ':l_account' ;
289: l_custom_rec.attribute_value:= l_account;
290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
292:
293: p_custom_output.Extend();
294: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

287: IF ( l_account IS NOT NULL) THEN
288: l_custom_rec.attribute_name := ':l_account' ;
289: l_custom_rec.attribute_value:= l_account;
290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
292:
293: p_custom_output.Extend();
294: p_custom_output(p_custom_output.count) := l_custom_rec;
295: END IF;

Line 300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

296:
297: IF ( l_classification IS NOT NULL) THEN
298: l_custom_rec.attribute_name := ':l_classification' ;
299: l_custom_rec.attribute_value:= l_classification;
300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
302:
303: p_custom_output.Extend();
304: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

297: IF ( l_classification IS NOT NULL) THEN
298: l_custom_rec.attribute_name := ':l_classification' ;
299: l_custom_rec.attribute_value:= l_classification;
300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
302:
303: p_custom_output.Extend();
304: p_custom_output(p_custom_output.count) := l_custom_rec;
305: END IF;

Line 309: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

305: END IF;
306:
307: l_custom_rec.attribute_name := ':l_row_type' ;
308: l_custom_rec.attribute_value:= l_row_type;
309: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
311:
312: p_custom_output.Extend();
313: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

306:
307: l_custom_rec.attribute_name := ':l_row_type' ;
308: l_custom_rec.attribute_value:= l_row_type;
309: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
311:
312: p_custom_output.Extend();
313: p_custom_output(p_custom_output.count) := l_custom_rec;
314: