DBA Data[Home] [Help]

APPS.ENI_DBI_PMS_KPI_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 229: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

225: ' || l_where_clause;
226:
227:
228: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
229: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
230: x_custom_output.extend;
231:
232: l_custom_rec.attribute_name := ':ITEM+ENI_ITEM';
233: l_custom_rec.attribute_value := 5;

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

230: x_custom_output.extend;
231:
232: l_custom_rec.attribute_name := ':ITEM+ENI_ITEM';
233: l_custom_rec.attribute_value := 5;
234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
236: x_custom_output.extend;
237: x_custom_output(1) := l_custom_rec;
238:

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

231:
232: l_custom_rec.attribute_name := ':ITEM+ENI_ITEM';
233: l_custom_rec.attribute_value := 5;
234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
236: x_custom_output.extend;
237: x_custom_output(1) := l_custom_rec;
238:
239: -- Start Bug 5083911

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

239: -- Start Bug 5083911
240: x_custom_output.extend;
241: l_custom_rec.attribute_name := ':CATEGORY';
242: l_custom_rec.attribute_value :=replace(l_category,'''');
243: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
244: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
245: x_custom_output(2) := l_custom_rec;
246:
247: x_custom_output.extend;

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

240: x_custom_output.extend;
241: l_custom_rec.attribute_name := ':CATEGORY';
242: l_custom_rec.attribute_value :=replace(l_category,'''');
243: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
244: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
245: x_custom_output(2) := l_custom_rec;
246:
247: x_custom_output.extend;
248: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652

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

246:
247: x_custom_output.extend;
248: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652
249: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
250: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
251: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
252: x_custom_output(3) := l_custom_rec;
253:
254: -- End Bug 5083911

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

247: x_custom_output.extend;
248: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652
249: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
250: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
251: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
252: x_custom_output(3) := l_custom_rec;
253:
254: -- End Bug 5083911
255:

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

257:
258: x_custom_output.extend;
259: l_custom_rec.attribute_name := ':PERIODTYPE';
260: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
261: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
262: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
263: x_custom_output(8) := l_custom_rec;
264:
265: x_custom_output.extend;

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

258: x_custom_output.extend;
259: l_custom_rec.attribute_name := ':PERIODTYPE';
260: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
261: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
262: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
263: x_custom_output(8) := l_custom_rec;
264:
265: x_custom_output.extend;
266: l_custom_rec.attribute_name := ':COMPARETYPE';

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

264:
265: x_custom_output.extend;
266: l_custom_rec.attribute_name := ':COMPARETYPE';
267: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
268: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
269: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
270: x_custom_output(9) := l_custom_rec;
271:
272: x_custom_output.extend;

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

265: x_custom_output.extend;
266: l_custom_rec.attribute_name := ':COMPARETYPE';
267: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
268: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
269: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
270: x_custom_output(9) := l_custom_rec;
271:
272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';

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

271:
272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
274: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
275: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
276: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
277: x_custom_output(11) := l_custom_rec;
278:
279: --Bug 5083652 -- End Code

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

272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
274: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
275: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
276: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
277: x_custom_output(11) := l_custom_rec;
278:
279: --Bug 5083652 -- End Code
280: