DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_ODONE_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 22: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

18: l_previous_as_of_date DATE;
19: l_period_type_id NUMBER;
20: l_time_id_column VARCHAR2(1000);
21: l_goal NUMBER;
22: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
23: l_classification VARCHAR2(32000);
24: l_where_clause VARCHAR2(32000);
25: l_view_by varchar2(1000);
26: l_row_type varchar2(10) := 'AC';

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

266: END IF;
267:
268: p_custom_sql := l_sqltext;
269:
270: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
271: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
272: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
273:
274: p_custom_output.EXTEND();

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

267:
268: p_custom_sql := l_sqltext;
269:
270: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
271: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
272: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
273:
274: p_custom_output.EXTEND();
275: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

276:
277: IF ( l_account IS NOT NULL) THEN
278: l_custom_rec.attribute_name := ':l_account' ;
279: l_custom_rec.attribute_value:= l_account;
280: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
282:
283: p_custom_output.Extend();
284: p_custom_output(p_custom_output.count) := l_custom_rec;

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

277: IF ( l_account IS NOT NULL) THEN
278: l_custom_rec.attribute_name := ':l_account' ;
279: l_custom_rec.attribute_value:= l_account;
280: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
282:
283: p_custom_output.Extend();
284: p_custom_output(p_custom_output.count) := l_custom_rec;
285: END IF;

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

286:
287: IF ( l_classification IS NOT NULL) THEN
288: l_custom_rec.attribute_name := ':l_classification' ;
289: l_custom_rec.attribute_value:= l_classification;
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_classification IS NOT NULL) THEN
288: l_custom_rec.attribute_name := ':l_classification' ;
289: l_custom_rec.attribute_value:= l_classification;
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 299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

295: END IF;
296:
297: l_custom_rec.attribute_name := ':l_row_type' ;
298: l_custom_rec.attribute_value:= l_row_type;
299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
301:
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;

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

296:
297: l_custom_rec.attribute_name := ':l_row_type' ;
298: l_custom_rec.attribute_value:= l_row_type;
299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
301:
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;
304: