APPS.OPI_DBI_RES_EFF_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 115: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

111: 'N');
112:
113: -- prepare output for bind variables
114: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
115: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
116:
117: -- set the basic bind variables for the status SQL
118: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
119:

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

119:
120: -- Passing OPI_RESOURCE_LEVEL_FLAG to PMV
121: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
122: l_custom_rec.attribute_value := l_resource_level_flag;
123: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
124: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
125: x_custom_output.extend;
126: x_custom_output(x_custom_output.count) := l_custom_rec;
127:

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

120: -- Passing OPI_RESOURCE_LEVEL_FLAG to PMV
121: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
122: l_custom_rec.attribute_value := l_resource_level_flag;
123: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
124: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
125: x_custom_output.extend;
126: x_custom_output(x_custom_output.count) := l_custom_rec;
127:
128: x_custom_sql := l_query;

Line 323: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

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

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

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

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