DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_ART_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 273: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

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

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

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

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

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

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

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

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

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

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

290: IF ( l_classification IS NOT NULL) THEN
291: l_custom_rec.attribute_name := ':l_classification' ;
292: l_custom_rec.attribute_value:= l_classification;
293: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
294: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
295:
296: p_custom_output.Extend();
297: p_custom_output(p_custom_output.count) := l_custom_rec;
298: END IF;

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

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

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

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