DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_ERPT_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 394: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

390:
391: IF ( l_account IS NOT NULL) THEN
392: l_custom_rec.attribute_name := ':l_account' ;
393: l_custom_rec.attribute_value:= l_account;
394: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
395: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
396:
397: p_custom_output.Extend();
398: p_custom_output(p_custom_output.count) := l_custom_rec;

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

391: IF ( l_account IS NOT NULL) THEN
392: l_custom_rec.attribute_name := ':l_account' ;
393: l_custom_rec.attribute_value:= l_account;
394: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
395: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
396:
397: p_custom_output.Extend();
398: p_custom_output(p_custom_output.count) := l_custom_rec;
399: END IF;

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

400:
401: IF ( l_classification IS NOT NULL) THEN
402: l_custom_rec.attribute_name := ':l_classification' ;
403: l_custom_rec.attribute_value:= l_classification;
404: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
405: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
406:
407: p_custom_output.Extend();
408: p_custom_output(p_custom_output.count) := l_custom_rec;

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

401: IF ( l_classification IS NOT NULL) THEN
402: l_custom_rec.attribute_name := ':l_classification' ;
403: l_custom_rec.attribute_value:= l_classification;
404: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
405: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
406:
407: p_custom_output.Extend();
408: p_custom_output(p_custom_output.count) := l_custom_rec;
409: END IF;

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

409: END IF;
410:
411: l_custom_rec.attribute_name := ':l_application_id';
412: l_custom_rec.attribute_value:= l_application_id;
413: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
414: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
415:
416: p_custom_output.EXTEND;
417: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

410:
411: l_custom_rec.attribute_name := ':l_application_id';
412: l_custom_rec.attribute_value:= l_application_id;
413: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
414: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
415:
416: p_custom_output.EXTEND;
417: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
418:

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

415:
416: p_custom_output.EXTEND;
417: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
418:
419: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
420: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
421: l_custom_rec.attribute_value := l_view_by;
422:
423: p_custom_output.EXTEND();

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

416: p_custom_output.EXTEND;
417: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
418:
419: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
420: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
421: l_custom_rec.attribute_value := l_view_by;
422:
423: p_custom_output.EXTEND();
424: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

424: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
425:
426: l_custom_rec.attribute_name := ':l_row_type' ;
427: l_custom_rec.attribute_value:= l_row_type;
428: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
429: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
430:
431: p_custom_output.Extend();
432: p_custom_output(p_custom_output.count) := l_custom_rec;

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

425:
426: l_custom_rec.attribute_name := ':l_row_type' ;
427: l_custom_rec.attribute_value:= l_row_type;
428: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
429: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
430:
431: p_custom_output.Extend();
432: p_custom_output(p_custom_output.count) := l_custom_rec;
433: