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.BIL_TX_OPTY_AGE_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 117: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

113:
114:
115:
116:
117: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
118: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
119:
120:
121:

Line 511: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

507:
508:
509: l_bind_ctr := 1;
510:
511: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
512: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
513: l_custom_rec.attribute_value := l_viewby;
514: x_custom_attr.Extend();
515: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 512: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

508:
509: l_bind_ctr := 1;
510:
511: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
512: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
513: l_custom_rec.attribute_value := l_viewby;
514: x_custom_attr.Extend();
515: x_custom_attr(l_bind_ctr):=l_custom_rec;
516: l_bind_ctr:=l_bind_ctr+1;

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

518:
519: IF REPLACE (l_opty_name, '%',NULL) IS NOT NULL THEN
520: l_custom_rec.attribute_name :=':l_opty_name';
521: l_custom_rec.attribute_value := l_opty_name;
522: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
523: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
524: x_custom_attr.Extend();
525: x_custom_attr(l_bind_ctr):=l_custom_rec;
526: l_bind_ctr:=l_bind_ctr+1;

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

519: IF REPLACE (l_opty_name, '%',NULL) IS NOT NULL THEN
520: l_custom_rec.attribute_name :=':l_opty_name';
521: l_custom_rec.attribute_value := l_opty_name;
522: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
523: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
524: x_custom_attr.Extend();
525: x_custom_attr(l_bind_ctr):=l_custom_rec;
526: l_bind_ctr:=l_bind_ctr+1;
527: END IF;

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

526: l_bind_ctr:=l_bind_ctr+1;
527: END IF;
528: l_custom_rec.attribute_name :=':l_period_set_name';
529: l_custom_rec.attribute_value :=l_period_set_name;
530: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
531: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
532: x_custom_attr.Extend();
533: x_custom_attr(l_bind_ctr):=l_custom_rec;
534: l_bind_ctr:=l_bind_ctr+1;

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

527: END IF;
528: l_custom_rec.attribute_name :=':l_period_set_name';
529: l_custom_rec.attribute_value :=l_period_set_name;
530: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
531: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
532: x_custom_attr.Extend();
533: x_custom_attr(l_bind_ctr):=l_custom_rec;
534: l_bind_ctr:=l_bind_ctr+1;
535:

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

537:
538: IF l_convsersion_type IS NOT NULL THEN
539: l_custom_rec.attribute_name :=':l_convsersion_type';
540: l_custom_rec.attribute_value :=l_convsersion_type;
541: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
542: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
543: x_custom_attr.Extend();
544: x_custom_attr(l_bind_ctr):=l_custom_rec;
545: l_bind_ctr:=l_bind_ctr+1;

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

538: IF l_convsersion_type IS NOT NULL THEN
539: l_custom_rec.attribute_name :=':l_convsersion_type';
540: l_custom_rec.attribute_value :=l_convsersion_type;
541: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
542: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
543: x_custom_attr.Extend();
544: x_custom_attr(l_bind_ctr):=l_custom_rec;
545: l_bind_ctr:=l_bind_ctr+1;
546: END IF;

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

547:
548: IF l_opty_number IS NOT NULL THEN
549: l_custom_rec.attribute_name :=':l_opty_number';
550: l_custom_rec.attribute_value := l_opty_number;
551: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
552: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
553: x_custom_attr.Extend();
554: x_custom_attr(l_bind_ctr):=l_custom_rec;
555: l_bind_ctr:=l_bind_ctr+1;

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

548: IF l_opty_number IS NOT NULL THEN
549: l_custom_rec.attribute_name :=':l_opty_number';
550: l_custom_rec.attribute_value := l_opty_number;
551: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
552: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
553: x_custom_attr.Extend();
554: x_custom_attr(l_bind_ctr):=l_custom_rec;
555: l_bind_ctr:=l_bind_ctr+1;
556: END IF;

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

557:
558:
559: l_custom_rec.attribute_name :=':l_to_period_name';
560: l_custom_rec.attribute_value := l_to_period_name;
561: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
562: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
563: x_custom_attr.Extend();
564: x_custom_attr(l_bind_ctr):=l_custom_rec;
565: l_bind_ctr:=l_bind_ctr+1;

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

558:
559: l_custom_rec.attribute_name :=':l_to_period_name';
560: l_custom_rec.attribute_value := l_to_period_name;
561: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
562: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
563: x_custom_attr.Extend();
564: x_custom_attr(l_bind_ctr):=l_custom_rec;
565: l_bind_ctr:=l_bind_ctr+1;
566:

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

567:
568: IF l_item_id IS NOT NULL THEN
569: l_custom_rec.attribute_name :=':l_item_id';
570: l_custom_rec.attribute_value := l_item_id;
571: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
572: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
573: x_custom_attr.Extend();
574: x_custom_attr(l_bind_ctr):=l_custom_rec;
575: l_bind_ctr:=l_bind_ctr+1;

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

568: IF l_item_id IS NOT NULL THEN
569: l_custom_rec.attribute_name :=':l_item_id';
570: l_custom_rec.attribute_value := l_item_id;
571: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
572: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
573: x_custom_attr.Extend();
574: x_custom_attr(l_bind_ctr):=l_custom_rec;
575: l_bind_ctr:=l_bind_ctr+1;
576: END IF;

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

578:
579: IF l_product_category IS NOT NULL THEN
580: l_custom_rec.attribute_name :=':l_product_category';
581: l_custom_rec.attribute_value := l_product_category;
582: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
583: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
584: x_custom_attr.Extend();
585: x_custom_attr(l_bind_ctr):=l_custom_rec;
586: l_bind_ctr:=l_bind_ctr+1;

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

579: IF l_product_category IS NOT NULL THEN
580: l_custom_rec.attribute_name :=':l_product_category';
581: l_custom_rec.attribute_value := l_product_category;
582: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
583: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
584: x_custom_attr.Extend();
585: x_custom_attr(l_bind_ctr):=l_custom_rec;
586: l_bind_ctr:=l_bind_ctr+1;
587: END IF;

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

587: END IF;
588:
589: l_custom_rec.attribute_name :=':l_period_type';
590: l_custom_rec.attribute_value := l_period_type;
591: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
592: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
593: x_custom_attr.Extend();
594: x_custom_attr(l_bind_ctr):=l_custom_rec;
595: l_bind_ctr:=l_bind_ctr+1;

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

588:
589: l_custom_rec.attribute_name :=':l_period_type';
590: l_custom_rec.attribute_value := l_period_type;
591: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
592: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
593: x_custom_attr.Extend();
594: x_custom_attr(l_bind_ctr):=l_custom_rec;
595: l_bind_ctr:=l_bind_ctr+1;
596:

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

596:
597:
598: l_custom_rec.attribute_name :=':l_win_probability_opr';
599: l_custom_rec.attribute_value :=l_win_probability_opr;
600: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
601: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
602: x_custom_attr.Extend();
603: x_custom_attr(l_bind_ctr):=l_custom_rec;
604: l_bind_ctr:=l_bind_ctr+1;

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

597:
598: l_custom_rec.attribute_name :=':l_win_probability_opr';
599: l_custom_rec.attribute_value :=l_win_probability_opr;
600: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
601: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
602: x_custom_attr.Extend();
603: x_custom_attr(l_bind_ctr):=l_custom_rec;
604: l_bind_ctr:=l_bind_ctr+1;
605:

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

604: l_bind_ctr:=l_bind_ctr+1;
605:
606: l_custom_rec.attribute_name :=':l_win_probability';
607: l_custom_rec.attribute_value := l_win_probability;
608: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
609: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
610: x_custom_attr.Extend();
611: x_custom_attr(l_bind_ctr):=l_custom_rec;
612: l_bind_ctr:=l_bind_ctr+1;

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

605:
606: l_custom_rec.attribute_name :=':l_win_probability';
607: l_custom_rec.attribute_value := l_win_probability;
608: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
609: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
610: x_custom_attr.Extend();
611: x_custom_attr(l_bind_ctr):=l_custom_rec;
612: l_bind_ctr:=l_bind_ctr+1;
613:

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

613:
614:
615: l_custom_rec.attribute_name :=':l_credit_type_id';
616: l_custom_rec.attribute_value := l_credit_type_id;
617: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
618: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
619: x_custom_attr.Extend();
620: x_custom_attr(l_bind_ctr):=l_custom_rec;
621: l_bind_ctr:=l_bind_ctr+1;

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

614:
615: l_custom_rec.attribute_name :=':l_credit_type_id';
616: l_custom_rec.attribute_value := l_credit_type_id;
617: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
618: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
619: x_custom_attr.Extend();
620: x_custom_attr(l_bind_ctr):=l_custom_rec;
621: l_bind_ctr:=l_bind_ctr+1;
622:

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

621: l_bind_ctr:=l_bind_ctr+1;
622:
623: l_custom_rec.attribute_name :=':l_from_date';
624: l_custom_rec.attribute_value := TO_CHAR(l_from_date,'dd/MM/yyyy') ;
625: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
626: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
627: x_custom_attr.Extend();
628: x_custom_attr(l_bind_ctr):=l_custom_rec;
629: l_bind_ctr:=l_bind_ctr+1;

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

622:
623: l_custom_rec.attribute_name :=':l_from_date';
624: l_custom_rec.attribute_value := TO_CHAR(l_from_date,'dd/MM/yyyy') ;
625: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
626: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
627: x_custom_attr.Extend();
628: x_custom_attr(l_bind_ctr):=l_custom_rec;
629: l_bind_ctr:=l_bind_ctr+1;
630:

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

629: l_bind_ctr:=l_bind_ctr+1;
630:
631: l_custom_rec.attribute_name :=':l_to_date';
632: l_custom_rec.attribute_value := TO_CHAR(l_to_date,'dd/MM/yyyy') ;
633: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
634: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
635: x_custom_attr.Extend();
636: x_custom_attr(l_bind_ctr):=l_custom_rec;
637: l_bind_ctr:=l_bind_ctr+1;

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

630:
631: l_custom_rec.attribute_name :=':l_to_date';
632: l_custom_rec.attribute_value := TO_CHAR(l_to_date,'dd/MM/yyyy') ;
633: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
634: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
635: x_custom_attr.Extend();
636: x_custom_attr(l_bind_ctr):=l_custom_rec;
637: l_bind_ctr:=l_bind_ctr+1;
638:

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

638:
639:
640: l_custom_rec.attribute_name :=':l_rpt_str';
641: l_custom_rec.attribute_value :=l_rpt_str;
642: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
643: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
644: x_custom_attr.Extend();
645: x_custom_attr(l_bind_ctr):=l_custom_rec;
646: l_bind_ctr:=l_bind_ctr+1;

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

639:
640: l_custom_rec.attribute_name :=':l_rpt_str';
641: l_custom_rec.attribute_value :=l_rpt_str;
642: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
643: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
644: x_custom_attr.Extend();
645: x_custom_attr(l_bind_ctr):=l_custom_rec;
646: l_bind_ctr:=l_bind_ctr+1;
647: