132: p_filter_where => l_filter_where);
133:
134: -- prepare output for bind variables
135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
136: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
137:
138: -- set the basic bind variables for the status SQL
139: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
140:
140:
141: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
142: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
143: l_custom_rec.attribute_value := l_aggregation_level_flag;
144: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
145: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
146: x_custom_output.extend;
147: x_custom_output(x_custom_output.count) := l_custom_rec;
148:
141: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
142: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
143: l_custom_rec.attribute_value := l_aggregation_level_flag;
144: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
145: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
146: x_custom_output.extend;
147: x_custom_output(x_custom_output.count) := l_custom_rec;
148:
149: -- make the nested pattern ITD since inv. value is reported as a balance,
456:
457:
458: -- Prepare PMV bind variables
459: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
460: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
461:
462: -- get all the basic binds used by POA queries
463: -- Do this before adding any of our binds, since the procedure
464: -- reinitializes the output table
467:
468: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
469: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
470: l_custom_rec.attribute_value := l_aggregation_level_flag;
471: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
472: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
473: x_custom_output.extend;
474: x_custom_output(x_custom_output.count) := l_custom_rec;
475:
468: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
469: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
470: l_custom_rec.attribute_value := l_aggregation_level_flag;
471: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
472: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
473: x_custom_output.extend;
474: x_custom_output(x_custom_output.count) := l_custom_rec;
475:
476: -- make the nested pattern ITD since inv. value is reported as a balance,
610: p_filter_where => l_filter_where);
611:
612: -- prepare output for bind variables
613: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
614: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
615:
616: -- set the basic bind variables for the status SQL
617: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
618:
618:
619: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
620: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
621: l_custom_rec.attribute_value := l_aggregation_level_flag;
622: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
623: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
624: x_custom_output.extend;
625: x_custom_output(x_custom_output.count) := l_custom_rec;
626:
619: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
620: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
621: l_custom_rec.attribute_value := l_aggregation_level_flag;
622: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
623: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
624: x_custom_output.extend;
625: x_custom_output(x_custom_output.count) := l_custom_rec;
626:
627: -- make the nested pattern ITD since inv. value is reported as a balance,
818: p_filter_where => l_filter_where);
819:
820: -- prepare output for bind variables
821: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
822: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
823:
824: -- set the basic bind variables for the status SQL
825: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
826:
826:
827: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
828: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
829: l_custom_rec.attribute_value := l_aggregation_level_flag;
830: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
831: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
832: x_custom_output.extend;
833: x_custom_output(x_custom_output.count) := l_custom_rec;
834:
827: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
828: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
829: l_custom_rec.attribute_value := l_aggregation_level_flag;
830: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
831: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
832: x_custom_output.extend;
833: x_custom_output(x_custom_output.count) := l_custom_rec;
834:
835: -- make the nested pattern ITD since inv. value is reported as a balance,
1053:
1054:
1055: -- prepare output for bind variables
1056: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1057: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1058:
1059: -- set the basic bind variables for the status SQL
1060: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1061:
1061:
1062: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
1063: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
1064: l_custom_rec.attribute_value := l_aggregation_level_flag;
1065: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1066: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1067: x_custom_output.extend;
1068: x_custom_output(x_custom_output.count) := l_custom_rec;
1069:
1062: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
1063: l_custom_rec.attribute_name := ':OPI_AGGREGATION_LEVEL_FLAG';
1064: l_custom_rec.attribute_value := l_aggregation_level_flag;
1065: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1066: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1067: x_custom_output.extend;
1068: x_custom_output(x_custom_output.count) := l_custom_rec;
1069:
1070: -- make the nested pattern ITD since inv. value is reported as a balance,