DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_BACK_ACT_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 38: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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

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

269: -- insert Period Type ID bind variable
270:
271: l_custom_rec.attribute_name := ':l_period_type_id' ;
272: l_custom_rec.attribute_value:= l_period_type_id;
273: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
274: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
275:
276: p_custom_output.Extend();
277: p_custom_output(p_custom_output.count) := l_custom_rec;

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

270:
271: l_custom_rec.attribute_name := ':l_period_type_id' ;
272: l_custom_rec.attribute_value:= l_period_type_id;
273: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
274: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
275:
276: p_custom_output.Extend();
277: p_custom_output(p_custom_output.count) := l_custom_rec;
278:

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

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

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

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

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

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

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

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

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

299: END IF;
300:
301: l_custom_rec.attribute_name := ':l_max_collect_date' ;
302: l_custom_rec.attribute_value:= l_max_collect_date;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_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.DATE_BIND;

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

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

307: p_custom_output(p_custom_output.count) := l_custom_rec;
308:
309: l_custom_rec.attribute_name := ':l_application_id';
310: l_custom_rec.attribute_value:= l_application_id;
311: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
312: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
313:
314: p_custom_output.EXTEND;
315: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

308:
309: l_custom_rec.attribute_name := ':l_application_id';
310: l_custom_rec.attribute_value:= l_application_id;
311: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
312: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
313:
314: p_custom_output.EXTEND;
315: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
316:

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

313:
314: p_custom_output.EXTEND;
315: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
316:
317: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
319: l_custom_rec.attribute_value := l_view_by;
320:
321: p_custom_output.EXTEND();

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

314: p_custom_output.EXTEND;
315: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
316:
317: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
319: l_custom_rec.attribute_value := l_view_by;
320:
321: p_custom_output.EXTEND();
322: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

322: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
323:
324: l_custom_rec.attribute_name := ':l_row_type' ;
325: l_custom_rec.attribute_value:= l_row_type;
326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
328:
329: p_custom_output.Extend();
330: p_custom_output(p_custom_output.count) := l_custom_rec;

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

323:
324: l_custom_rec.attribute_name := ':l_row_type' ;
325: l_custom_rec.attribute_value:= l_row_type;
326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
328:
329: p_custom_output.Extend();
330: p_custom_output(p_custom_output.count) := l_custom_rec;
331: