APPS.OPI_DBI_RES_VAR_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 121: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

117: 'N');
118:
119: -- prepare output for bind variables
120: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
121: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
122:
123: -- set the basic bind variables for the status SQL
124: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
125:

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

125:
126: -- Passing OPI_RESOURCE_LEVEL_FLAG to PMV
127: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
128: l_custom_rec.attribute_value := l_resource_level_flag;
129: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
130: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
131: x_custom_output.extend;
132: x_custom_output(x_custom_output.count) := l_custom_rec;
133:

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

126: -- Passing OPI_RESOURCE_LEVEL_FLAG to PMV
127: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
128: l_custom_rec.attribute_value := l_resource_level_flag;
129: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
130: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
131: x_custom_output.extend;
132: x_custom_output(x_custom_output.count) := l_custom_rec;
133:
134: x_custom_sql := l_query;

Line 385: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

381:
382:
383: -- Prepare PMV bind variables
384: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
385: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
386:
387: -- get all the basic binds used by POA queries
388: -- Do this before adding any of our binds, since the procedure
389: -- reinitializes the output table

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

392:
393: -- put the custom OPI binds in
394: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
395: l_custom_rec.attribute_value := l_resource_level_flag;
396: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
398: x_custom_output.extend;
399: x_custom_output(x_custom_output.count) := l_custom_rec;
400:

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

393: -- put the custom OPI binds in
394: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';
395: l_custom_rec.attribute_value := l_resource_level_flag;
396: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
398: x_custom_output.extend;
399: x_custom_output(x_custom_output.count) := l_custom_rec;
400:
401: x_custom_sql := l_query;