DBA Data[Home] [Help]

APPS.ENI_DBI_COC_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 452: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

448: ' ||l_order_by ;
449:
450:
451:
452: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
453: x_custom_output := bis_query_attributes_tbl();
454:
455:
456:

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

456:
457: x_custom_output.extend;
458: l_custom_rec.attribute_name := ':ITEM';
459: l_custom_rec.attribute_value := l_item;
460: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
461: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
462: x_custom_output(1) := l_custom_rec;
463:
464:

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

457: x_custom_output.extend;
458: l_custom_rec.attribute_name := ':ITEM';
459: l_custom_rec.attribute_value := l_item;
460: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
461: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
462: x_custom_output(1) := l_custom_rec;
463:
464:
465: x_custom_output.extend;

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

464:
465: x_custom_output.extend;
466: l_custom_rec.attribute_name := ':ORG';
467: l_custom_rec.attribute_value := replace(l_org,'''');
468: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
469: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
470: x_custom_output(2) := l_custom_rec;
471:
472: x_custom_output.extend;

Line 469: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

465: x_custom_output.extend;
466: l_custom_rec.attribute_name := ':ORG';
467: l_custom_rec.attribute_value := replace(l_org,'''');
468: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
469: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
470: x_custom_output(2) := l_custom_rec;
471:
472: x_custom_output.extend;
473: l_custom_rec.attribute_name := ':REASON';

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

471:
472: x_custom_output.extend;
473: l_custom_rec.attribute_name := ':REASON';
474: l_custom_rec.attribute_value := l_reason;
475: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
476: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
477: x_custom_output(3) := l_custom_rec;
478:
479: x_custom_output.extend;

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

472: x_custom_output.extend;
473: l_custom_rec.attribute_name := ':REASON';
474: l_custom_rec.attribute_value := l_reason;
475: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
476: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
477: x_custom_output(3) := l_custom_rec;
478:
479: x_custom_output.extend;
480: l_custom_rec.attribute_name := ':PRIORITY';

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

478:
479: x_custom_output.extend;
480: l_custom_rec.attribute_name := ':PRIORITY';
481: l_custom_rec.attribute_value := l_priority;
482: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
483: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
484: x_custom_output(4) := l_custom_rec;
485:
486: x_custom_output.extend;

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

479: x_custom_output.extend;
480: l_custom_rec.attribute_name := ':PRIORITY';
481: l_custom_rec.attribute_value := l_priority;
482: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
483: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
484: x_custom_output(4) := l_custom_rec;
485:
486: x_custom_output.extend;
487: l_custom_rec.attribute_name := ':STATUS';

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

485:
486: x_custom_output.extend;
487: l_custom_rec.attribute_name := ':STATUS';
488: l_custom_rec.attribute_value := replace(l_status,'''');
489: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
490: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
491: x_custom_output(5) := l_custom_rec;
492:
493: x_custom_output.extend;

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

486: x_custom_output.extend;
487: l_custom_rec.attribute_name := ':STATUS';
488: l_custom_rec.attribute_value := replace(l_status,'''');
489: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
490: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
491: x_custom_output(5) := l_custom_rec;
492:
493: x_custom_output.extend;
494: l_custom_rec.attribute_name := ':TYPE';

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

492:
493: x_custom_output.extend;
494: l_custom_rec.attribute_name := ':TYPE';
495: l_custom_rec.attribute_value := replace(l_type,'''');
496: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
497: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
498: x_custom_output(6) := l_custom_rec;
499:
500: --Bug 5083894 - Start Code

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

493: x_custom_output.extend;
494: l_custom_rec.attribute_name := ':TYPE';
495: l_custom_rec.attribute_value := replace(l_type,'''');
496: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
497: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
498: x_custom_output(6) := l_custom_rec;
499:
500: --Bug 5083894 - Start Code
501:

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

501:
502: x_custom_output.extend;
503: l_custom_rec.attribute_name := ':PERIOD';
504: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
505: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
506: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
507: x_custom_output(7) := l_custom_rec;
508:
509: --Bug 5083894 - End Code

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

502: x_custom_output.extend;
503: l_custom_rec.attribute_name := ':PERIOD';
504: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
505: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
506: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
507: x_custom_output(7) := l_custom_rec;
508:
509: --Bug 5083894 - End Code
510:

Line 511: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

507: x_custom_output(7) := l_custom_rec;
508:
509: --Bug 5083894 - End Code
510:
511: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
512: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
513:
514:
515:

Line 512: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

508:
509: --Bug 5083894 - End Code
510:
511: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
512: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
513:
514:
515:
516: END GET_SQL;