APPS.OPI_DBI_CURR_PROD_DEL_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 129: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

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

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

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

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