APPS.OPI_DBI_SCRAP_REASON_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 90: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

86: p_generate_viewby => 'Y',
87: p_in_join_tables => NULL);
88: -- prepare output for bind variables
89: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
90: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
91: -- set the basic bind variables for the status SQL
92: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
93:
94: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV

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

93:
94: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
95: l_custom_rec.attribute_name := ':OPI_TRX_REASON_FLAG';
96: l_custom_rec.attribute_value := l_aggregation_level_flag;
97: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
98: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
99: x_custom_output.extend;
100: x_custom_output(x_custom_output.count) := l_custom_rec;
101: commit;

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

94: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
95: l_custom_rec.attribute_name := ':OPI_TRX_REASON_FLAG';
96: l_custom_rec.attribute_value := l_aggregation_level_flag;
97: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
98: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
99: x_custom_output.extend;
100: x_custom_output(x_custom_output.count) := l_custom_rec;
101: commit;
102: x_custom_sql := l_query;