DBA Data[Home] [Help]

APPS.ENI_DBI_PCM_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 128: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

124: l_org := -9999;
125: END IF;
126: END IF;
127:
128: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
129: x_custom_output := bis_query_attributes_tbl();
130:
131: IF (l_item_temp IS NULL)
132: THEN

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

264: -- Bug 5083568: Added the following Bind Values
265: x_custom_output.extend;
266: l_custom_rec.attribute_name := ':ITEM';
267: l_custom_rec.attribute_value := replace(l_item,'''');
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(1) := 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 := ':ITEM';
267: l_custom_rec.attribute_value := replace(l_item,'''');
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(1) := l_custom_rec;
271:
272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':ORG';

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 := ':ORG';
274: l_custom_rec.attribute_value := replace(l_org,'''');
275: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
276: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
277: x_custom_output(2) := l_custom_rec;
278:
279: x_custom_output.extend;

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

272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':ORG';
274: l_custom_rec.attribute_value := replace(l_org,'''');
275: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
276: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
277: x_custom_output(2) := l_custom_rec;
278:
279: x_custom_output.extend;
280: l_custom_rec.attribute_name := ':ITEM_TEMP';

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

278:
279: x_custom_output.extend;
280: l_custom_rec.attribute_name := ':ITEM_TEMP';
281: l_custom_rec.attribute_value := replace(l_item_temp,'''');
282: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
283: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
284: x_custom_output(3) := l_custom_rec;
285:
286: x_custom_output.extend;

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

279: x_custom_output.extend;
280: l_custom_rec.attribute_name := ':ITEM_TEMP';
281: l_custom_rec.attribute_value := replace(l_item_temp,'''');
282: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
283: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
284: x_custom_output(3) := l_custom_rec;
285:
286: x_custom_output.extend;
287: l_custom_rec.attribute_name := ':ORG_TEMP';

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

285:
286: x_custom_output.extend;
287: l_custom_rec.attribute_name := ':ORG_TEMP';
288: l_custom_rec.attribute_value := replace(l_org_temp,'''');
289: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
290: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
291: x_custom_output(4) := l_custom_rec;
292:
293: --Bug 5083652 -- Start Code

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

286: x_custom_output.extend;
287: l_custom_rec.attribute_name := ':ORG_TEMP';
288: l_custom_rec.attribute_value := replace(l_org_temp,'''');
289: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
290: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
291: x_custom_output(4) := l_custom_rec;
292:
293: --Bug 5083652 -- Start Code
294:

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

294:
295: x_custom_output.extend;
296: l_custom_rec.attribute_name := ':PERIODTYPE';
297: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
298: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
299: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
300: x_custom_output(5) := l_custom_rec;
301:
302: x_custom_output.extend;

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

295: x_custom_output.extend;
296: l_custom_rec.attribute_name := ':PERIODTYPE';
297: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
298: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
299: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
300: x_custom_output(5) := l_custom_rec;
301:
302: x_custom_output.extend;
303: l_custom_rec.attribute_name := ':COMPARETYPE';

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

301:
302: x_custom_output.extend;
303: l_custom_rec.attribute_name := ':COMPARETYPE';
304: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
305: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
306: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
307: x_custom_output(6) := l_custom_rec;
308:
309:

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

302: x_custom_output.extend;
303: l_custom_rec.attribute_name := ':COMPARETYPE';
304: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
305: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
306: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
307: x_custom_output(6) := l_custom_rec;
308:
309:
310: x_custom_output.extend;

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

309:
310: x_custom_output.extend;
311: l_custom_rec.attribute_name := ':PERIODAND';
312: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
313: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
314: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
315: x_custom_output(7) := l_custom_rec;
316:
317: x_custom_output.extend;

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

310: x_custom_output.extend;
311: l_custom_rec.attribute_name := ':PERIODAND';
312: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
313: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
314: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
315: x_custom_output(7) := l_custom_rec;
316:
317: x_custom_output.extend;
318: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';

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

316:
317: x_custom_output.extend;
318: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
319: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
320: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
321: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
322: x_custom_output(8) := l_custom_rec;
323:
324: --Bug 5083652 -- End Code

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

317: x_custom_output.extend;
318: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
319: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
320: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
321: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
322: x_custom_output(8) := l_custom_rec;
323:
324: --Bug 5083652 -- End Code
325: