DBA Data[Home] [Help]

APPS.ENI_DBI_OEX_T_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 196: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

192: ORDER BY
193: ' || l_order_by;
194:
195: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
196: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
197: x_custom_output.extend;
198:
199: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
200: l_custom_rec.attribute_value := l_cur_period;

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

197: x_custom_output.extend;
198:
199: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
200: l_custom_rec.attribute_value := l_cur_period;
201: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
202: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
203: x_custom_output.extend;
204: x_custom_output(1) := l_custom_rec;
205:

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

198:
199: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
200: l_custom_rec.attribute_value := l_cur_period;
201: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
202: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
203: x_custom_output.extend;
204: x_custom_output(1) := l_custom_rec;
205:
206: l_custom_rec.attribute_name := ':CATEGORY';

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

204: x_custom_output(1) := l_custom_rec;
205:
206: l_custom_rec.attribute_name := ':CATEGORY';
207: l_custom_rec.attribute_value := l_category;
208: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
209: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
210: x_custom_output.extend;
211: x_custom_output(2) := l_custom_rec;
212:

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

205:
206: l_custom_rec.attribute_name := ':CATEGORY';
207: l_custom_rec.attribute_value := l_category;
208: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
209: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
210: x_custom_output.extend;
211: x_custom_output(2) := l_custom_rec;
212:
213: --Bug 5083652 -- Start Code

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

214:
215: x_custom_output.extend;
216: l_custom_rec.attribute_name := ':PERIODTYPE';
217: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
218: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
219: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
220: x_custom_output(3) := l_custom_rec;
221:
222: x_custom_output.extend;

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

215: x_custom_output.extend;
216: l_custom_rec.attribute_name := ':PERIODTYPE';
217: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
218: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
219: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
220: x_custom_output(3) := l_custom_rec;
221:
222: x_custom_output.extend;
223: l_custom_rec.attribute_name := ':COMPARETYPE';

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

221:
222: x_custom_output.extend;
223: l_custom_rec.attribute_name := ':COMPARETYPE';
224: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
225: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
226: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
227: x_custom_output(4) := l_custom_rec;
228:
229:

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

222: x_custom_output.extend;
223: l_custom_rec.attribute_name := ':COMPARETYPE';
224: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
225: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
226: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
227: x_custom_output(4) := l_custom_rec;
228:
229:
230: x_custom_output.extend;

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

229:
230: x_custom_output.extend;
231: l_custom_rec.attribute_name := ':PERIODAND';
232: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
233: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
234: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
235: x_custom_output(5) := l_custom_rec;
236:
237: --Bug 5083652 -- End Code

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

230: x_custom_output.extend;
231: l_custom_rec.attribute_name := ':PERIODAND';
232: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
233: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
234: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
235: x_custom_output(5) := l_custom_rec;
236:
237: --Bug 5083652 -- End Code
238: