APPS.OPI_DBI_ONTIME_PROD_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 130: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

126: p_generate_viewby => 'Y',
127: p_in_join_tables => NULL);
128: -- prepare output for bind variables
129: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
130: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
131: -- set the basic bind variables for the status SQL
132: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
133:
134: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV

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

133:
134: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
135: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
136: l_custom_rec.attribute_value := l_aggregation_level_flag;
137: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
138: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
139: x_custom_output.extend;
140: x_custom_output(x_custom_output.count) := l_custom_rec;
141: commit;

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

134: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
135: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
136: l_custom_rec.attribute_value := l_aggregation_level_flag;
137: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
138: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
139: x_custom_output.extend;
140: x_custom_output(x_custom_output.count) := l_custom_rec;
141: commit;
142: x_custom_sql := l_query;