DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_RESOLV_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 39: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

35: --Initialize p_custom_output
36: --
37:
38: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
39: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
40:
41: -- Get the parameters
42:
43: BIX_PMV_DBI_UTL_PKG.get_emc_page_params( p_page_parameter_tbl,

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

265:
266: p_custom_output.EXTEND();
267: l_custom_rec.attribute_name := ':l_period_type_id' ;
268: l_custom_rec.attribute_value:= l_period_type_id;
269: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
271:
272: p_custom_output.Extend();
273: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 270: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

266: p_custom_output.EXTEND();
267: l_custom_rec.attribute_name := ':l_period_type_id' ;
268: l_custom_rec.attribute_value:= l_period_type_id;
269: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
271:
272: p_custom_output.Extend();
273: p_custom_output(p_custom_output.count) := l_custom_rec;
274:

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_max_collect_date' ;
298: l_custom_rec.attribute_value:= l_max_collect_date;
299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_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.DATE_BIND;

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

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

301:
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;
304:
305: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
306: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
307: l_custom_rec.attribute_value := l_view_by;
308:
309: p_custom_output.EXTEND();

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

302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;
304:
305: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
306: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
307: l_custom_rec.attribute_value := l_view_by;
308:
309: p_custom_output.EXTEND();
310: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

310: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
311:
312: l_custom_rec.attribute_name := ':l_row_type' ;
313: l_custom_rec.attribute_value:= l_row_type;
314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
316:
317: p_custom_output.Extend();
318: p_custom_output(p_custom_output.count) := l_custom_rec;

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

311:
312: l_custom_rec.attribute_name := ':l_row_type' ;
313: l_custom_rec.attribute_value:= l_row_type;
314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
316:
317: p_custom_output.Extend();
318: p_custom_output(p_custom_output.count) := l_custom_rec;
319: