APPS.IBW_BI_PAGE_INT_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 165: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

161: l_from_3 :='' ;
162: l_where_3 :='' ;
163: l_group_by_3 :='' ;
164:
165: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
166:
167: --------------------------------------------------------------------------------------------------------------
168: /********************Metrics in Page Interest Report*********************/
169: /* IBW_VAL1 : Page Views */

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

595: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
596:
597: l_custom_rec.attribute_name := ':l_grouping_id' ;
598: l_custom_rec.attribute_value:= l_grouping_id;
599: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
600: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
601: x_custom_output.EXTEND;
602: x_custom_output(1) := l_custom_rec;
603:

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

596:
597: l_custom_rec.attribute_name := ':l_grouping_id' ;
598: l_custom_rec.attribute_value:= l_grouping_id;
599: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
600: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
601: x_custom_output.EXTEND;
602: x_custom_output(1) := l_custom_rec;
603:
604:

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

603:
604:
605: l_custom_rec.attribute_name := ':l_grouping_id_inner' ;
606: l_custom_rec.attribute_value:= l_grouping_id_inner;
607: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
608: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
609: x_custom_output.EXTEND;
610: x_custom_output(2) := l_custom_rec;
611:

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

604:
605: l_custom_rec.attribute_name := ':l_grouping_id_inner' ;
606: l_custom_rec.attribute_value:= l_grouping_id_inner;
607: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
608: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
609: x_custom_output.EXTEND;
610: x_custom_output(2) := l_custom_rec;
611:
612:

Line 713: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

709: l_from := '';
710: l_where := '';
711: l_select_col_name := '';
712: l_custom_sql := '';
713: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
714:
715:
716: l_from := ' IBW_PAGE_SA_TIME_MV PAGE_SA_MV, ' ||
717: ' FII_TIME_RPT_STRUCT_V CAL ';