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

Line 125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

121: l_err_msg := replace(FND_MESSAGE.GET_STRING('BIL','BIL_TX_CUR_CONV_MIS'),'''','''''');
122: l_period_set_name := NVL(FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR'), 'Accounting');
123: l_org_id := fnd_profile.value('ORG_ID');
124:
125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
126: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
127:
128: -- FND logging --
129: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)

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

632:
633: -- Parameters binding --
634:
635: l_bind_ctr := 1;
636: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
637: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
638: l_custom_rec.attribute_value := l_viewby;
639: x_custom_attr.Extend();
640: x_custom_attr(l_bind_ctr):=l_custom_rec;

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

633: -- Parameters binding --
634:
635: l_bind_ctr := 1;
636: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
637: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
638: l_custom_rec.attribute_value := l_viewby;
639: x_custom_attr.Extend();
640: x_custom_attr(l_bind_ctr):=l_custom_rec;
641: l_bind_ctr:=l_bind_ctr+1;

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

641: l_bind_ctr:=l_bind_ctr+1;
642:
643: l_custom_rec.attribute_name :=':l_from_date';
644: l_custom_rec.attribute_value :=TO_CHAR(l_from_date,'DD/MM/YYYY') ;
645: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
646: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
647: x_custom_attr.Extend();
648: x_custom_attr(l_bind_ctr):=l_custom_rec;
649: l_bind_ctr:=l_bind_ctr+1;

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

642:
643: l_custom_rec.attribute_name :=':l_from_date';
644: l_custom_rec.attribute_value :=TO_CHAR(l_from_date,'DD/MM/YYYY') ;
645: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
646: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
647: x_custom_attr.Extend();
648: x_custom_attr(l_bind_ctr):=l_custom_rec;
649: l_bind_ctr:=l_bind_ctr+1;
650:

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

649: l_bind_ctr:=l_bind_ctr+1;
650:
651: l_custom_rec.attribute_name :=':l_to_date';
652: l_custom_rec.attribute_value :=TO_CHAR(l_to_date,'dd/MM/yyyy') ;
653: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
654: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
655: x_custom_attr.Extend();
656: x_custom_attr(l_bind_ctr):=l_custom_rec;
657: l_bind_ctr:=l_bind_ctr+1;

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

650:
651: l_custom_rec.attribute_name :=':l_to_date';
652: l_custom_rec.attribute_value :=TO_CHAR(l_to_date,'dd/MM/yyyy') ;
653: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
654: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
655: x_custom_attr.Extend();
656: x_custom_attr(l_bind_ctr):=l_custom_rec;
657: l_bind_ctr:=l_bind_ctr+1;
658:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

683:
684: l_custom_rec.attribute_name :=':l_org_id';
685: l_custom_rec.attribute_value :=l_org_id;
686: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
687: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
688: x_custom_attr.Extend();
689: x_custom_attr(l_bind_ctr):=l_custom_rec;
690: l_bind_ctr:=l_bind_ctr+1;
691:

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

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

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

692:
693: l_custom_rec.attribute_name :=':l_viewby';
694: l_custom_rec.attribute_value := l_viewby;
695: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
696: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
697: x_custom_attr.Extend();
698: x_custom_attr(l_bind_ctr):=l_custom_rec;
699: l_bind_ctr:=l_bind_ctr+1;
700: