DBA Data[Home] [Help]

APPS.OPI_DBI_INV_MGMT_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 136: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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:

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

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:

Line 145: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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,

Line 460: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

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

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:

Line 472: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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,

Line 614: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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:

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

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:

Line 623: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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,

Line 822: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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:

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

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:

Line 831: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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,

Line 1057: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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:

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

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:

Line 1066: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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,