DBA Data[Home] [Help]

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

289: END IF;
290:
291: p_custom_sql := l_sqltext;
292:
293: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
295: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
296:
297: p_custom_output.EXTEND();

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

290:
291: p_custom_sql := l_sqltext;
292:
293: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
295: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
296:
297: p_custom_output.EXTEND();
298: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

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

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

300: IF ( l_account IS NOT NULL) THEN
301: l_custom_rec.attribute_name := ':l_account' ;
302: l_custom_rec.attribute_value:= l_account;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
305:
306: p_custom_output.Extend();
307: p_custom_output(p_custom_output.count) := l_custom_rec;
308: END IF;

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

309:
310: IF ( l_classification IS NOT NULL) THEN
311: l_custom_rec.attribute_name := ':l_classification' ;
312: l_custom_rec.attribute_value:= l_classification;
313: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
314: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
315:
316: p_custom_output.Extend();
317: p_custom_output(p_custom_output.count) := l_custom_rec;

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

310: IF ( l_classification IS NOT NULL) THEN
311: l_custom_rec.attribute_name := ':l_classification' ;
312: l_custom_rec.attribute_value:= l_classification;
313: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
314: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
315:
316: p_custom_output.Extend();
317: p_custom_output(p_custom_output.count) := l_custom_rec;
318: END IF;

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

318: END IF;
319:
320: l_custom_rec.attribute_name := ':l_row_type' ;
321: l_custom_rec.attribute_value:= l_row_type;
322: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
323: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
324:
325: p_custom_output.Extend();
326: p_custom_output(p_custom_output.count) := l_custom_rec;

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

319:
320: l_custom_rec.attribute_name := ':l_row_type' ;
321: l_custom_rec.attribute_value:= l_row_type;
322: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
323: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
324:
325: p_custom_output.Extend();
326: p_custom_output(p_custom_output.count) := l_custom_rec;
327: