DBA Data[Home] [Help]

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

371:
372: p_custom_output.EXTEND();
373: l_custom_rec.attribute_name := ':l_period_type_id' ;
374: l_custom_rec.attribute_value:= l_period_type_id;
375: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
376: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
377:
378: p_custom_output.Extend();
379: p_custom_output(p_custom_output.count) := l_custom_rec;

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

372: p_custom_output.EXTEND();
373: l_custom_rec.attribute_name := ':l_period_type_id' ;
374: l_custom_rec.attribute_value:= l_period_type_id;
375: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
376: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
377:
378: p_custom_output.Extend();
379: p_custom_output(p_custom_output.count) := l_custom_rec;
380:

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

382:
383: IF ( l_account IS NOT NULL) THEN
384: l_custom_rec.attribute_name := ':l_account' ;
385: l_custom_rec.attribute_value:= l_account;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
388:
389: p_custom_output.Extend();
390: p_custom_output(p_custom_output.count) := l_custom_rec;

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

383: IF ( l_account IS NOT NULL) THEN
384: l_custom_rec.attribute_name := ':l_account' ;
385: l_custom_rec.attribute_value:= l_account;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
388:
389: p_custom_output.Extend();
390: p_custom_output(p_custom_output.count) := l_custom_rec;
391: END IF;

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

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

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

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

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

401: END IF;
402:
403: l_custom_rec.attribute_name := ':l_max_collect_date' ;
404: l_custom_rec.attribute_value:= l_max_collect_date;
405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
407:
408: p_custom_output.Extend();
409: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

402:
403: l_custom_rec.attribute_name := ':l_max_collect_date' ;
404: l_custom_rec.attribute_value:= l_max_collect_date;
405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
407:
408: p_custom_output.Extend();
409: p_custom_output(p_custom_output.count) := l_custom_rec;
410:

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

407:
408: p_custom_output.Extend();
409: p_custom_output(p_custom_output.count) := l_custom_rec;
410:
411: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
413: l_custom_rec.attribute_value := l_view_by;
414:
415: p_custom_output.EXTEND();

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

408: p_custom_output.Extend();
409: p_custom_output(p_custom_output.count) := l_custom_rec;
410:
411: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
413: l_custom_rec.attribute_value := l_view_by;
414:
415: p_custom_output.EXTEND();
416: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

416: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
417:
418: l_custom_rec.attribute_name := ':l_row_type' ;
419: l_custom_rec.attribute_value:= l_row_type;
420: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
421: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
422:
423: p_custom_output.Extend();
424: p_custom_output(p_custom_output.count) := l_custom_rec;

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

417:
418: l_custom_rec.attribute_name := ':l_row_type' ;
419: l_custom_rec.attribute_value:= l_row_type;
420: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
421: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
422:
423: p_custom_output.Extend();
424: p_custom_output(p_custom_output.count) := l_custom_rec;
425: