DBA Data[Home] [Help]

APPS.ENI_DBI_PDA_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 380: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

376: avg4_cnt
377: ORDER BY
378: ' || l_order_by;
379:
380: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
381: x_custom_output := bis_query_attributes_tbl();
382:
383: x_custom_output.extend;
384: l_custom_rec.attribute_name := ':ITEM';

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

382:
383: x_custom_output.extend;
384: l_custom_rec.attribute_name := ':ITEM';
385: l_custom_rec.attribute_value := l_item;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
388: x_custom_output(1) := l_custom_rec;
389:
390: x_custom_output.extend;

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

383: x_custom_output.extend;
384: l_custom_rec.attribute_name := ':ITEM';
385: l_custom_rec.attribute_value := l_item;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
388: x_custom_output(1) := l_custom_rec;
389:
390: x_custom_output.extend;
391: l_custom_rec.attribute_name := ':ORG';

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

389:
390: x_custom_output.extend;
391: l_custom_rec.attribute_name := ':ORG';
392: l_custom_rec.attribute_value :=replace(l_org,'''');
393: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
394: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
395: x_custom_output(2) := l_custom_rec;
396:
397: x_custom_output.extend;

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

390: x_custom_output.extend;
391: l_custom_rec.attribute_name := ':ORG';
392: l_custom_rec.attribute_value :=replace(l_org,'''');
393: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
394: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
395: x_custom_output(2) := l_custom_rec;
396:
397: x_custom_output.extend;
398: l_custom_rec.attribute_name := ':REASON';

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 := ':REASON';
399: l_custom_rec.attribute_value := l_reason;
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(3) := 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 := ':REASON';
399: l_custom_rec.attribute_value := l_reason;
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(3) := l_custom_rec;
403:
404: x_custom_output.extend;
405: l_custom_rec.attribute_name := ':PRIORITY';

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 := ':PRIORITY';
406: l_custom_rec.attribute_value := l_priority;
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(4) := l_custom_rec;
410:
411: x_custom_output.extend;

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 := ':PRIORITY';
406: l_custom_rec.attribute_value := l_priority;
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(4) := l_custom_rec;
410:
411: x_custom_output.extend;
412: l_custom_rec.attribute_name := ':TYPE';

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

410:
411: x_custom_output.extend;
412: l_custom_rec.attribute_name := ':TYPE';
413: l_custom_rec.attribute_value := replace(l_type,'''');
414: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
415: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
416: x_custom_output(5) := l_custom_rec;
417:
418:

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

411: x_custom_output.extend;
412: l_custom_rec.attribute_name := ':TYPE';
413: l_custom_rec.attribute_value := replace(l_type,'''');
414: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
415: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
416: x_custom_output(5) := l_custom_rec;
417:
418:
419: x_custom_output.extend;

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 := ':STATUS';
421: l_custom_rec.attribute_value := replace(l_status,'''');
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(6) := l_custom_rec;
425:
426:

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 := ':STATUS';
421: l_custom_rec.attribute_value := replace(l_status,'''');
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(6) := l_custom_rec;
425:
426:
427: EXCEPTION