eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENI_DBI_CAT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 344: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

340: GROUP BY '||l_group_by_clause||'
341: ORDER BY
342: '||l_order_by;
343:
344: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
345: x_custom_output := bis_query_attributes_tbl();
346: x_custom_output.extend;
347: l_custom_rec.attribute_name := ':STATUS_ID';
348: l_custom_rec.attribute_value := REPLACE(l_status,'''');

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

345: x_custom_output := bis_query_attributes_tbl();
346: x_custom_output.extend;
347: l_custom_rec.attribute_name := ':STATUS_ID';
348: l_custom_rec.attribute_value := REPLACE(l_status,'''');
349: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
350: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
351: x_custom_output(1) := l_custom_rec;
352:
353: x_custom_output.extend;

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

346: x_custom_output.extend;
347: l_custom_rec.attribute_name := ':STATUS_ID';
348: l_custom_rec.attribute_value := REPLACE(l_status,'''');
349: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
350: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
351: x_custom_output(1) := l_custom_rec;
352:
353: x_custom_output.extend;
354: l_custom_rec.attribute_name := ':PRIORITY_ID';

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

352:
353: x_custom_output.extend;
354: l_custom_rec.attribute_name := ':PRIORITY_ID';
355: l_custom_rec.attribute_value := l_priority;
356: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
357: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
358: x_custom_output(2) := l_custom_rec;
359:
360: x_custom_output.extend;

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

353: x_custom_output.extend;
354: l_custom_rec.attribute_name := ':PRIORITY_ID';
355: l_custom_rec.attribute_value := l_priority;
356: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
357: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
358: x_custom_output(2) := l_custom_rec;
359:
360: x_custom_output.extend;
361: l_custom_rec.attribute_name := ':TYPE_ID';

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

359:
360: x_custom_output.extend;
361: l_custom_rec.attribute_name := ':TYPE_ID';
362: l_custom_rec.attribute_value := REPLACE(l_type,'''');
363: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
364: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
365: x_custom_output(3) := l_custom_rec;
366:
367: x_custom_output.extend;

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

360: x_custom_output.extend;
361: l_custom_rec.attribute_name := ':TYPE_ID';
362: l_custom_rec.attribute_value := REPLACE(l_type,'''');
363: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
364: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
365: x_custom_output(3) := l_custom_rec;
366:
367: x_custom_output.extend;
368: l_custom_rec.attribute_name := ':REASON_ID';

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

366:
367: x_custom_output.extend;
368: l_custom_rec.attribute_name := ':REASON_ID';
369: l_custom_rec.attribute_value := l_reason;
370: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
371: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
372: x_custom_output(4) := l_custom_rec;
373:
374: x_custom_output.extend;

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

367: x_custom_output.extend;
368: l_custom_rec.attribute_name := ':REASON_ID';
369: l_custom_rec.attribute_value := l_reason;
370: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
371: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
372: x_custom_output(4) := l_custom_rec;
373:
374: x_custom_output.extend;
375: l_custom_rec.attribute_name := ':NVL_DATE';

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

373:
374: x_custom_output.extend;
375: l_custom_rec.attribute_name := ':NVL_DATE';
376: l_custom_rec.attribute_value := '31/12/3000';
377: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
378: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
379: x_custom_output(5) := l_custom_rec;
380:
381: x_custom_output.extend;

Line 378: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

374: x_custom_output.extend;
375: l_custom_rec.attribute_name := ':NVL_DATE';
376: l_custom_rec.attribute_value := '31/12/3000';
377: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
378: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
379: x_custom_output(5) := l_custom_rec;
380:
381: x_custom_output.extend;
382: l_custom_rec.attribute_name := ':ORGANIZATION_ID';

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

380:
381: x_custom_output.extend;
382: l_custom_rec.attribute_name := ':ORGANIZATION_ID';
383: l_custom_rec.attribute_value := REPLACE(l_org,'''');
384: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
385: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
386: x_custom_output(6) := l_custom_rec;
387:
388: x_custom_output.extend;

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

381: x_custom_output.extend;
382: l_custom_rec.attribute_name := ':ORGANIZATION_ID';
383: l_custom_rec.attribute_value := REPLACE(l_org,'''');
384: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
385: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
386: x_custom_output(6) := l_custom_rec;
387:
388: x_custom_output.extend;
389: l_custom_rec.attribute_name := ':ITEM_ID';

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

387:
388: x_custom_output.extend;
389: l_custom_rec.attribute_name := ':ITEM_ID';
390: l_custom_rec.attribute_value := l_item;
391: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
392: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
393: x_custom_output(7) := l_custom_rec;
394:
395: --Bug 5083652 -- Start Code

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

388: x_custom_output.extend;
389: l_custom_rec.attribute_name := ':ITEM_ID';
390: l_custom_rec.attribute_value := l_item;
391: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
392: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
393: x_custom_output(7) := l_custom_rec;
394:
395: --Bug 5083652 -- Start Code
396:

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

396:
397: x_custom_output.extend;
398: l_custom_rec.attribute_name := ':PERIODTYPE';
399: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
400: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
401: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
402: x_custom_output(8) := l_custom_rec;
403:
404: x_custom_output.extend;

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

397: x_custom_output.extend;
398: l_custom_rec.attribute_name := ':PERIODTYPE';
399: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
400: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
401: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
402: x_custom_output(8) := l_custom_rec;
403:
404: x_custom_output.extend;
405: l_custom_rec.attribute_name := ':COMPARETYPE';

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

403:
404: x_custom_output.extend;
405: l_custom_rec.attribute_name := ':COMPARETYPE';
406: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
409: x_custom_output(9) := l_custom_rec;
410:
411:

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

404: x_custom_output.extend;
405: l_custom_rec.attribute_name := ':COMPARETYPE';
406: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
409: x_custom_output(9) := l_custom_rec;
410:
411:
412: x_custom_output.extend;

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

411:
412: x_custom_output.extend;
413: l_custom_rec.attribute_name := ':PERIODAND';
414: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
415: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
416: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
417: x_custom_output(10) := l_custom_rec;
418:
419: x_custom_output.extend;

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

412: x_custom_output.extend;
413: l_custom_rec.attribute_name := ':PERIODAND';
414: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
415: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
416: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
417: x_custom_output(10) := l_custom_rec;
418:
419: x_custom_output.extend;
420: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';

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

418:
419: x_custom_output.extend;
420: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
421: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
422: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
423: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
424: x_custom_output(11) := l_custom_rec;
425:
426: --Bug 5083652 -- End Code

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

419: x_custom_output.extend;
420: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
421: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
422: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
423: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
424: x_custom_output(11) := l_custom_rec;
425:
426: --Bug 5083652 -- End Code
427: