APPS.ENI_DBI_UCC_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 246: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

242: end if;
243:
244: x_custom_sql := l_sql_stmt;
245:
246: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
247: x_custom_output := bis_query_attributes_tbl();
248:
249: x_custom_output.extend;
250: l_custom_rec.attribute_name := ':l_item';

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

248:
249: x_custom_output.extend;
250: l_custom_rec.attribute_name := ':l_item';
251: l_custom_rec.attribute_value := replace(l_item,'''');
252: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
253: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
254: x_custom_output(1) := l_custom_rec;
255:
256: x_custom_output.extend;

Line 253: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

249: x_custom_output.extend;
250: l_custom_rec.attribute_name := ':l_item';
251: l_custom_rec.attribute_value := replace(l_item,'''');
252: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
253: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
254: x_custom_output(1) := l_custom_rec;
255:
256: x_custom_output.extend;
257: l_custom_rec.attribute_name := ':l_org';

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

255:
256: x_custom_output.extend;
257: l_custom_rec.attribute_name := ':l_org';
258: l_custom_rec.attribute_value := replace(l_org,'''');
259: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
260: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
261: x_custom_output(2) := l_custom_rec;
262:
263: x_custom_output.extend;

Line 260: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

256: x_custom_output.extend;
257: l_custom_rec.attribute_name := ':l_org';
258: l_custom_rec.attribute_value := replace(l_org,'''');
259: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
260: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
261: x_custom_output(2) := l_custom_rec;
262:
263: x_custom_output.extend;
264: l_custom_rec.attribute_name := ':l_period_type';

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

262:
263: x_custom_output.extend;
264: l_custom_rec.attribute_name := ':l_period_type';
265: l_custom_rec.attribute_value := replace(l_period_type,'''');
266: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
267: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
268: x_custom_output(3) := l_custom_rec;
269:
270: x_custom_output.extend;

Line 267: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

263: x_custom_output.extend;
264: l_custom_rec.attribute_name := ':l_period_type';
265: l_custom_rec.attribute_value := replace(l_period_type,'''');
266: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
267: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
268: x_custom_output(3) := l_custom_rec;
269:
270: x_custom_output.extend;
271: l_custom_rec.attribute_name := ':l_comp_type';

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

269:
270: x_custom_output.extend;
271: l_custom_rec.attribute_name := ':l_comp_type';
272: l_custom_rec.attribute_value := replace(l_comp_type,'''');
273: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
274: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
275: x_custom_output(4) := l_custom_rec;
276:
277:

Line 274: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

270: x_custom_output.extend;
271: l_custom_rec.attribute_name := ':l_comp_type';
272: l_custom_rec.attribute_value := replace(l_comp_type,'''');
273: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
274: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
275: x_custom_output(4) := l_custom_rec;
276:
277:
278: END get_sql;