APPS.OPI_DBI_RES_UTL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 108: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

104: 'N');
105:
106: -- prepare output for bind variables
107: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
108: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
109:
110: -- set the basic bind variables for the status SQL
111: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
112:

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

112:
113: -- Passing OPI_RESOURCE_LEVEL_FLAG to PMV
114: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
115: l_custom_rec.attribute_value := l_resource_level_flag;
116: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
117: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
118: x_custom_output.extend;
119: x_custom_output(x_custom_output.count) := l_custom_rec;
120:

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

113: -- Passing OPI_RESOURCE_LEVEL_FLAG to PMV
114: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
115: l_custom_rec.attribute_value := l_resource_level_flag;
116: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
117: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
118: x_custom_output.extend;
119: x_custom_output(x_custom_output.count) := l_custom_rec;
120:
121: x_custom_sql := l_query;

Line 324: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

320:
321:
322: -- Prepare PMV bind variables
323: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
324: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
325:
326: -- get all the basic binds used by POA queries
327: -- Do this before adding any of our binds, since the procedure
328: -- reinitializes the output table

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

331:
332: -- put the custom OPI binds in
333: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
334: l_custom_rec.attribute_value := l_resource_level_flag;
335: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
337: x_custom_output.extend;
338: x_custom_output(x_custom_output.count) := l_custom_rec;
339:

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

332: -- put the custom OPI binds in
333: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
334: l_custom_rec.attribute_value := l_resource_level_flag;
335: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
337: x_custom_output.extend;
338: x_custom_output(x_custom_output.count) := l_custom_rec;
339:
340: x_custom_sql := l_query;