DBA Data[Home] [Help]

APPS.ENI_DBI_PCB_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 306: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

302: order by '
303: ||l_order_by;
304: END IF; */
305:
306: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
307: x_custom_output := bis_query_attributes_tbl();
308:
309: --Start Bug 5083920
310: x_custom_output.extend;

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

309: --Start Bug 5083920
310: x_custom_output.extend;
311: l_custom_rec.attribute_name := ':ITEM';
312: l_custom_rec.attribute_value := replace(l_item,'''');
313: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
314: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
315: x_custom_output(1) := l_custom_rec;
316:
317: x_custom_output.extend;

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

310: x_custom_output.extend;
311: l_custom_rec.attribute_name := ':ITEM';
312: l_custom_rec.attribute_value := replace(l_item,'''');
313: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
314: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
315: x_custom_output(1) := l_custom_rec;
316:
317: x_custom_output.extend;
318: l_custom_rec.attribute_name := ':ORG';

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 := ':ORG';
319: l_custom_rec.attribute_value := replace(l_org,'''');
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(2) := l_custom_rec;
323:
324: x_custom_output.extend;

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 := ':ORG';
319: l_custom_rec.attribute_value := replace(l_org,'''');
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(2) := l_custom_rec;
323:
324: x_custom_output.extend;
325: l_custom_rec.attribute_name := ':LITEM';

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

323:
324: x_custom_output.extend;
325: l_custom_rec.attribute_name := ':LITEM';
326: l_custom_rec.attribute_value := replace(l_item_1,'''');
327: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
328: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
329: x_custom_output(3) := l_custom_rec;
330:
331: x_custom_output.extend;

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

324: x_custom_output.extend;
325: l_custom_rec.attribute_name := ':LITEM';
326: l_custom_rec.attribute_value := replace(l_item_1,'''');
327: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
328: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
329: x_custom_output(3) := l_custom_rec;
330:
331: x_custom_output.extend;
332: l_custom_rec.attribute_name := ':LORG';

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

330:
331: x_custom_output.extend;
332: l_custom_rec.attribute_name := ':LORG';
333: l_custom_rec.attribute_value := replace(l_org_1,'''');
334: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
335: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
336: x_custom_output(4) := l_custom_rec;
337:
338: --End Bug 5083920

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

331: x_custom_output.extend;
332: l_custom_rec.attribute_name := ':LORG';
333: l_custom_rec.attribute_value := replace(l_org_1,'''');
334: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
335: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
336: x_custom_output(4) := l_custom_rec;
337:
338: --End Bug 5083920
339: --Bug 5083652 -- Start Code

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

340:
341: x_custom_output.extend;
342: l_custom_rec.attribute_name := ':PERIODTYPE';
343: l_custom_rec.attribute_value := replace(l_period_type,'''');
344: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
345: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
346: x_custom_output(5) := l_custom_rec;
347:
348: x_custom_output.extend;

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

341: x_custom_output.extend;
342: l_custom_rec.attribute_name := ':PERIODTYPE';
343: l_custom_rec.attribute_value := replace(l_period_type,'''');
344: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
345: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
346: x_custom_output(5) := l_custom_rec;
347:
348: x_custom_output.extend;
349: l_custom_rec.attribute_name := ':COMPARETYPE';

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

347:
348: x_custom_output.extend;
349: l_custom_rec.attribute_name := ':COMPARETYPE';
350: l_custom_rec.attribute_value := replace(l_comp_type,'''');
351: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
352: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
353: x_custom_output(6) := l_custom_rec;
354:
355:

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

348: x_custom_output.extend;
349: l_custom_rec.attribute_name := ':COMPARETYPE';
350: l_custom_rec.attribute_value := replace(l_comp_type,'''');
351: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
352: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
353: x_custom_output(6) := l_custom_rec;
354:
355:
356: x_custom_output.extend;

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

355:
356: x_custom_output.extend;
357: l_custom_rec.attribute_name := ':PERIODAND';
358: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
359: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
360: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
361: x_custom_output(7) := l_custom_rec;
362:
363: x_custom_output.extend;

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

356: x_custom_output.extend;
357: l_custom_rec.attribute_name := ':PERIODAND';
358: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
359: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
360: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
361: x_custom_output(7) := l_custom_rec;
362:
363: x_custom_output.extend;
364: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';

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

362:
363: x_custom_output.extend;
364: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
365: l_custom_rec.attribute_value := replace(l_cur_period,'''');
366: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
367: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
368: x_custom_output(8) := l_custom_rec;
369:
370: --Bug 5083652 -- End Code

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

363: x_custom_output.extend;
364: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
365: l_custom_rec.attribute_value := replace(l_cur_period,'''');
366: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
367: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
368: x_custom_output(8) := l_custom_rec;
369:
370: --Bug 5083652 -- End Code
371: