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_LIST_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 97: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

93: END IF;
94:
95:
96:
97: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
98: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
99:
100:
101: l_oppty_url1 :='''pFunctionName=ASN_OPPTYDETPG&addBreadCrumb=Y&ASNReqFrmOpptyId=''||ascd.LEAD_NUMBER '; -- ASN Opportunity page link

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

584:
585:
586: l_bind_ctr := 1;
587:
588: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
589: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
590: l_custom_rec.attribute_value := l_viewby;
591: x_custom_attr.Extend();
592: x_custom_attr(l_bind_ctr):=l_custom_rec;

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

585:
586: l_bind_ctr := 1;
587:
588: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
589: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
590: l_custom_rec.attribute_value := l_viewby;
591: x_custom_attr.Extend();
592: x_custom_attr(l_bind_ctr):=l_custom_rec;
593: l_bind_ctr:=l_bind_ctr+1;

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

595:
596:
597: l_custom_rec.attribute_name :=':l_from_date';
598: l_custom_rec.attribute_value := TO_CHAR(l_from_date,'dd/MM/yyyy') ;
599: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
600: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
601: x_custom_attr.Extend();
602: x_custom_attr(l_bind_ctr):=l_custom_rec;
603: l_bind_ctr:=l_bind_ctr+1;

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

596:
597: l_custom_rec.attribute_name :=':l_from_date';
598: l_custom_rec.attribute_value := TO_CHAR(l_from_date,'dd/MM/yyyy') ;
599: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
600: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
601: x_custom_attr.Extend();
602: x_custom_attr(l_bind_ctr):=l_custom_rec;
603: l_bind_ctr:=l_bind_ctr+1;
604:

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

603: l_bind_ctr:=l_bind_ctr+1;
604:
605: l_custom_rec.attribute_name :=':l_to_date';
606: l_custom_rec.attribute_value := TO_CHAR(l_to_date,'dd/MM/yyyy') ;
607: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
608: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
609: x_custom_attr.Extend();
610: x_custom_attr(l_bind_ctr):=l_custom_rec;
611: l_bind_ctr:=l_bind_ctr+1;

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

604:
605: l_custom_rec.attribute_name :=':l_to_date';
606: l_custom_rec.attribute_value := TO_CHAR(l_to_date,'dd/MM/yyyy') ;
607: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
608: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
609: x_custom_attr.Extend();
610: x_custom_attr(l_bind_ctr):=l_custom_rec;
611: l_bind_ctr:=l_bind_ctr+1;
612:

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

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

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

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

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

620: l_bind_ctr:=l_bind_ctr+1;
621:
622: l_custom_rec.attribute_name :=':l_item_id';
623: l_custom_rec.attribute_value := l_item_id;
624: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
625: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
626: x_custom_attr.Extend();
627: x_custom_attr(l_bind_ctr):=l_custom_rec;
628: l_bind_ctr:=l_bind_ctr+1;

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

621:
622: l_custom_rec.attribute_name :=':l_item_id';
623: l_custom_rec.attribute_value := l_item_id;
624: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
625: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
626: x_custom_attr.Extend();
627: x_custom_attr(l_bind_ctr):=l_custom_rec;
628: l_bind_ctr:=l_bind_ctr+1;
629:

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

629:
630:
631: l_custom_rec.attribute_name :=':l_credit_type_id';
632: l_custom_rec.attribute_value := l_credit_type_id;
633: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_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_credit_type_id';
632: l_custom_rec.attribute_value := l_credit_type_id;
633: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_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 643: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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

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

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

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

648:
649:
650: l_custom_rec.attribute_name :=':l_conversion_type';
651: l_custom_rec.attribute_value :=l_conversion_type;
652: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
653: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
654: x_custom_attr.Extend();
655: x_custom_attr(l_bind_ctr):=l_custom_rec;
656: l_bind_ctr:=l_bind_ctr+1;

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

649:
650: l_custom_rec.attribute_name :=':l_conversion_type';
651: l_custom_rec.attribute_value :=l_conversion_type;
652: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
653: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
654: x_custom_attr.Extend();
655: x_custom_attr(l_bind_ctr):=l_custom_rec;
656: l_bind_ctr:=l_bind_ctr+1;
657:

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

656: l_bind_ctr:=l_bind_ctr+1;
657:
658: l_custom_rec.attribute_name :=':l_win_probability_opr';
659: l_custom_rec.attribute_value :=l_win_probability_opr;
660: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
661: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
662: x_custom_attr.Extend();
663: x_custom_attr(l_bind_ctr):=l_custom_rec;
664: l_bind_ctr:=l_bind_ctr+1;

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

657:
658: l_custom_rec.attribute_name :=':l_win_probability_opr';
659: l_custom_rec.attribute_value :=l_win_probability_opr;
660: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
661: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
662: x_custom_attr.Extend();
663: x_custom_attr(l_bind_ctr):=l_custom_rec;
664: l_bind_ctr:=l_bind_ctr+1;
665:

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

664: l_bind_ctr:=l_bind_ctr+1;
665:
666: l_custom_rec.attribute_name :=':l_win_probability';
667: l_custom_rec.attribute_value := l_win_probability;
668: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
669: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
670: x_custom_attr.Extend();
671: x_custom_attr(l_bind_ctr):=l_custom_rec;
672: l_bind_ctr:=l_bind_ctr+1;

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

665:
666: l_custom_rec.attribute_name :=':l_win_probability';
667: l_custom_rec.attribute_value := l_win_probability;
668: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
669: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
670: x_custom_attr.Extend();
671: x_custom_attr(l_bind_ctr):=l_custom_rec;
672: l_bind_ctr:=l_bind_ctr+1;
673:

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

672: l_bind_ctr:=l_bind_ctr+1;
673:
674: l_custom_rec.attribute_name :=':l_total_opp_amt_opr';
675: l_custom_rec.attribute_value :=l_total_opp_amt_opr;
676: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
677: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
678: x_custom_attr.Extend();
679: x_custom_attr(l_bind_ctr):=l_custom_rec;
680: l_bind_ctr:=l_bind_ctr+1;

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

673:
674: l_custom_rec.attribute_name :=':l_total_opp_amt_opr';
675: l_custom_rec.attribute_value :=l_total_opp_amt_opr;
676: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
677: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
678: x_custom_attr.Extend();
679: x_custom_attr(l_bind_ctr):=l_custom_rec;
680: l_bind_ctr:=l_bind_ctr+1;
681:

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

680: l_bind_ctr:=l_bind_ctr+1;
681:
682: l_custom_rec.attribute_name :=':l_total_opp_amount';
683: l_custom_rec.attribute_value := l_total_opp_amount;
684: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
685: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
686: x_custom_attr.Extend();
687: x_custom_attr(l_bind_ctr):=l_custom_rec;
688: l_bind_ctr:=l_bind_ctr+1;

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

681:
682: l_custom_rec.attribute_name :=':l_total_opp_amount';
683: l_custom_rec.attribute_value := l_total_opp_amount;
684: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
685: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
686: x_custom_attr.Extend();
687: x_custom_attr(l_bind_ctr):=l_custom_rec;
688: l_bind_ctr:=l_bind_ctr+1;
689:

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

688: l_bind_ctr:=l_bind_ctr+1;
689:
690: l_custom_rec.attribute_name :=':l_to_period_name';
691: l_custom_rec.attribute_value :=l_to_period_name;
692: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
693: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
694: x_custom_attr.Extend();
695: x_custom_attr(l_bind_ctr):=l_custom_rec;
696: l_bind_ctr:=l_bind_ctr+1;

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

689:
690: l_custom_rec.attribute_name :=':l_to_period_name';
691: l_custom_rec.attribute_value :=l_to_period_name;
692: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
693: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
694: x_custom_attr.Extend();
695: x_custom_attr(l_bind_ctr):=l_custom_rec;
696: l_bind_ctr:=l_bind_ctr+1;
697:

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

696: l_bind_ctr:=l_bind_ctr+1;
697:
698: l_custom_rec.attribute_name :=':l_rpt_str';
699: l_custom_rec.attribute_value :=l_rpt_str;
700: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
701: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
702: x_custom_attr.Extend();
703: x_custom_attr(l_bind_ctr):=l_custom_rec;
704: l_bind_ctr:=l_bind_ctr+1;

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

697:
698: l_custom_rec.attribute_name :=':l_rpt_str';
699: l_custom_rec.attribute_value :=l_rpt_str;
700: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
701: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
702: x_custom_attr.Extend();
703: x_custom_attr(l_bind_ctr):=l_custom_rec;
704: l_bind_ctr:=l_bind_ctr+1;
705:

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

705:
706:
707: l_custom_rec.attribute_name :=':l_viewby';
708: l_custom_rec.attribute_value := l_viewby;
709: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
710: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
711: x_custom_attr.Extend();
712: x_custom_attr(l_bind_ctr):=l_custom_rec;
713: l_bind_ctr:=l_bind_ctr+1;

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

706:
707: l_custom_rec.attribute_name :=':l_viewby';
708: l_custom_rec.attribute_value := l_viewby;
709: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
710: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
711: x_custom_attr.Extend();
712: x_custom_attr(l_bind_ctr):=l_custom_rec;
713: l_bind_ctr:=l_bind_ctr+1;
714: