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

Line 655: get_sg_prod_rev_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

651: END IF;
652:
653: -- Binding Section
654:
655: get_sg_prod_rev_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
656: get_sg_prod_rev_output := BIS_QUERY_ATTRIBUTES_TBL();
657: get_sg_prod_rev_sql := sqlstmt;
658:
659: get_sg_prod_rev_output.EXTEND;

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

658:
659: get_sg_prod_rev_output.EXTEND;
660: get_sg_prod_rev_rec.attribute_name := ':RECORD_TYPE_ID';
661: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_record_type_id);
662: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
663: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
664: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
665: get_sg_prod_rev_output.EXTEND;
666:

Line 663: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

659: get_sg_prod_rev_output.EXTEND;
660: get_sg_prod_rev_rec.attribute_name := ':RECORD_TYPE_ID';
661: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_record_type_id);
662: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
663: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
664: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
665: get_sg_prod_rev_output.EXTEND;
666:
667: get_sg_prod_rev_rec.attribute_name := ':VIEW_BY';

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

665: get_sg_prod_rev_output.EXTEND;
666:
667: get_sg_prod_rev_rec.attribute_name := ':VIEW_BY';
668: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_view_by);
669: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
670: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
671: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
672: get_sg_prod_rev_output.EXTEND;
673:

Line 670: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

666:
667: get_sg_prod_rev_rec.attribute_name := ':VIEW_BY';
668: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_view_by);
669: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
670: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
671: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
672: get_sg_prod_rev_output.EXTEND;
673:
674: get_sg_prod_rev_rec.attribute_name := ':FII_SG_SG';

Line 676: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

672: get_sg_prod_rev_output.EXTEND;
673:
674: get_sg_prod_rev_rec.attribute_name := ':FII_SG_SG';
675: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_sg_sg);
676: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
677: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
678: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
679: get_sg_prod_rev_output.EXTEND;
680:

Line 677: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

673:
674: get_sg_prod_rev_rec.attribute_name := ':FII_SG_SG';
675: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_sg_sg);
676: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
677: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
678: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
679: get_sg_prod_rev_output.EXTEND;
680:
681: get_sg_prod_rev_rec.attribute_name := ':FII_SG_RES';

Line 683: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

679: get_sg_prod_rev_output.EXTEND;
680:
681: get_sg_prod_rev_rec.attribute_name := ':FII_SG_RES';
682: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_sg_res);
683: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
684: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
685: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
686: get_sg_prod_rev_output.EXTEND;
687:

Line 684: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

680:
681: get_sg_prod_rev_rec.attribute_name := ':FII_SG_RES';
682: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_sg_res);
683: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
684: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
685: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
686: get_sg_prod_rev_output.EXTEND;
687:
688: get_sg_prod_rev_rec.attribute_name := ':FII_ITEM_CAT_FLAG';

Line 690: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

686: get_sg_prod_rev_output.EXTEND;
687:
688: get_sg_prod_rev_rec.attribute_name := ':FII_ITEM_CAT_FLAG';
689: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_item_cat_flag);
690: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
691: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
692: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
693: get_sg_prod_rev_output.EXTEND;
694:

Line 691: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

687:
688: get_sg_prod_rev_rec.attribute_name := ':FII_ITEM_CAT_FLAG';
689: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_item_cat_flag);
690: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
691: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
692: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
693: get_sg_prod_rev_output.EXTEND;
694:
695: get_sg_prod_rev_rec.attribute_name := ':FII_CUST';

Line 697: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

693: get_sg_prod_rev_output.EXTEND;
694:
695: get_sg_prod_rev_rec.attribute_name := ':FII_CUST';
696: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_cust_flag);
697: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
698: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
699: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
700: get_sg_prod_rev_output.EXTEND;
701:

Line 698: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

694:
695: get_sg_prod_rev_rec.attribute_name := ':FII_CUST';
696: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_cust_flag);
697: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
698: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
699: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
700: get_sg_prod_rev_output.EXTEND;
701:
702: get_sg_prod_rev_rec.attribute_name := ':FII_RECORD_ID';

Line 704: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

700: get_sg_prod_rev_output.EXTEND;
701:
702: get_sg_prod_rev_rec.attribute_name := ':FII_RECORD_ID';
703: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_record_id);
704: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
705: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
706: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
707: get_sg_prod_rev_output.EXTEND;
708:

Line 705: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

701:
702: get_sg_prod_rev_rec.attribute_name := ':FII_RECORD_ID';
703: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_record_id);
704: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
705: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
706: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
707: get_sg_prod_rev_output.EXTEND;
708:
709: get_sg_prod_rev_rec.attribute_name := ':FII_ONE_PERIOD_BACK';

Line 711: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

707: get_sg_prod_rev_output.EXTEND;
708:
709: get_sg_prod_rev_rec.attribute_name := ':FII_ONE_PERIOD_BACK';
710: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_one_period_back,'DD-MM-YYYY');
711: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
712: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
713: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
714: get_sg_prod_rev_output.EXTEND;
715:

Line 712: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

708:
709: get_sg_prod_rev_rec.attribute_name := ':FII_ONE_PERIOD_BACK';
710: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_one_period_back,'DD-MM-YYYY');
711: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
712: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
713: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
714: get_sg_prod_rev_output.EXTEND;
715:
716: get_sg_prod_rev_rec.attribute_name := ':FII_TWO_PERIOD_BACK';

Line 718: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

714: get_sg_prod_rev_output.EXTEND;
715:
716: get_sg_prod_rev_rec.attribute_name := ':FII_TWO_PERIOD_BACK';
717: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_two_period_back,'DD-MM-YYYY');
718: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
719: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
720: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
721: get_sg_prod_rev_output.EXTEND;
722:

Line 719: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

715:
716: get_sg_prod_rev_rec.attribute_name := ':FII_TWO_PERIOD_BACK';
717: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_two_period_back,'DD-MM-YYYY');
718: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
719: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
720: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
721: get_sg_prod_rev_output.EXTEND;
722:
723: get_sg_prod_rev_rec.attribute_name := ':FII_THREE_PERIOD_BACK';

Line 725: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

721: get_sg_prod_rev_output.EXTEND;
722:
723: get_sg_prod_rev_rec.attribute_name := ':FII_THREE_PERIOD_BACK';
724: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_three_period_back,'DD-MM-YYYY');
725: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
726: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
727: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
728: get_sg_prod_rev_output.EXTEND;
729:

Line 726: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

722:
723: get_sg_prod_rev_rec.attribute_name := ':FII_THREE_PERIOD_BACK';
724: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_three_period_back,'DD-MM-YYYY');
725: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
726: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
727: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
728: get_sg_prod_rev_output.EXTEND;
729:
730: get_sg_prod_rev_rec.attribute_name := ':FII_SORT';

Line 732: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

728: get_sg_prod_rev_output.EXTEND;
729:
730: get_sg_prod_rev_rec.attribute_name := ':FII_SORT';
731: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_sort);
732: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
733: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
734: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
735: get_sg_prod_rev_output.EXTEND;
736:

Line 733: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

729:
730: get_sg_prod_rev_rec.attribute_name := ':FII_SORT';
731: get_sg_prod_rev_rec.attribute_value := TO_CHAR(l_sort);
732: get_sg_prod_rev_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
733: get_sg_prod_rev_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
734: get_sg_prod_rev_output(get_sg_prod_rev_output.COUNT) := get_sg_prod_rev_rec;
735: get_sg_prod_rev_output.EXTEND;
736:
737: END get_sg_prod_rev;