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.BIM_SGMT_INTL_UI_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 130: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

126: END GET_ADMIN_STATUS;
127:
128: PROCEDURE GET_SGMT_VALUE_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
129: x_custom_sql OUT NOCOPY VARCHAR2,
130: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
131: IS
132: l_sqltext VARCHAR2 (20000);
133: l_as_of_date DATE;
134: l_period_type VARCHAR2 (2000);

Line 142: l_custom_rec BIS_QUERY_ATTRIBUTES;

138: l_curr VARCHAR2(50);
139: l_view_by VARCHAR2 (4000);
140: l_where VARCHAR2 (2000);
141: l_groupby VARCHAR2 (200);
142: l_custom_rec BIS_QUERY_ATTRIBUTES;
143: l_active_cust_col VARCHAR2(30);
144: l_start_date VARCHAR2(30);
145: l_curr_suffix VARCHAR2(2);
146: l_url_metric VARCHAR2(10);

Line 157: x_custom_output := bis_query_attributes_tbl ();

153: l_from VARCHAR2(200);
154: l_col VARCHAR2(200);
155:
156: BEGIN
157: x_custom_output := bis_query_attributes_tbl ();
158: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
159: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
160: l_as_of_date ,
161: l_period_type,

Line 409: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

405:
406:
407: PROCEDURE GET_SGMT_REVENUE_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
408: x_custom_sql OUT NOCOPY VARCHAR2,
409: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
410: IS
411: l_sqltext VARCHAR2 (20000);
412: iflag NUMBER;
413: l_period_type_hc NUMBER;

Line 426: l_custom_rec BIS_QUERY_ATTRIBUTES;

422: l_where VARCHAR2 (20000); -- static where clause
423: l_groupby VARCHAR2 (2000); -- to build group by clause
424: l_pc_from VARCHAR2 (20000); -- from clause to handle product category
425: l_pc_where VARCHAR2 (20000); -- where clause to handle product category
426: l_custom_rec BIS_QUERY_ATTRIBUTES;
427: l_object_type VARCHAR2(30);
428: l_url_link VARCHAR2(200);
429: l_url_camp1 VARCHAR2(3000);
430: l_url_camp2 VARCHAR2(3000);

Line 439: x_custom_output := bis_query_attributes_tbl ();

435: l_url_viewbyid VARCHAR2(100);
436: l_from VARCHAR2(100);
437:
438: BEGIN
439: x_custom_output := bis_query_attributes_tbl ();
440: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
441: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
442: l_as_of_date ,
443: l_period_type,

Line 542: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

538: END GET_SGMT_REVENUE_SQL;
539:
540: PROCEDURE GET_ACTIVE_CUST_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
541: x_custom_sql OUT NOCOPY VARCHAR2,
542: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
543: IS
544: l_sqltext VARCHAR2 (20000);
545: iflag NUMBER;
546: l_period_type_hc NUMBER;

Line 559: l_custom_rec BIS_QUERY_ATTRIBUTES;

555: l_where VARCHAR2 (20000); -- static where clause
556: l_groupby VARCHAR2 (2000); -- to build group by clause
557: l_pc_from VARCHAR2 (20000); -- from clause to handle product category
558: l_pc_where VARCHAR2 (20000); -- where clause to handle product category
559: l_custom_rec BIS_QUERY_ATTRIBUTES;
560: l_object_type VARCHAR2(30);
561: l_url_link VARCHAR2(200);
562: l_url_camp1 VARCHAR2(3000);
563: l_url_camp2 VARCHAR2(3000);

Line 573: x_custom_output := bis_query_attributes_tbl ();

569: l_url_viewbyid VARCHAR2(100);
570: l_from VARCHAR2(100);
571:
572: BEGIN
573: x_custom_output := bis_query_attributes_tbl ();
574: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
575: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
576: l_as_of_date ,
577: l_period_type,

Line 687: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

683:
684:
685: PROCEDURE GET_SGMT_SIZE_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
686: x_custom_sql OUT NOCOPY VARCHAR2,
687: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
688: IS
689: l_sqltext VARCHAR2 (20000);
690: iflag NUMBER;
691: l_period_type_hc NUMBER;

Line 704: l_custom_rec BIS_QUERY_ATTRIBUTES;

700: l_where VARCHAR2 (20000); -- static where clause
701: l_groupby VARCHAR2 (2000); -- to build group by clause
702: l_pc_from VARCHAR2 (20000); -- from clause to handle product category
703: l_pc_where VARCHAR2 (20000); -- where clause to handle product category
704: l_custom_rec BIS_QUERY_ATTRIBUTES;
705: l_object_type VARCHAR2(30);
706: l_url_link VARCHAR2(200);
707: l_url_camp1 VARCHAR2(3000);
708: l_url_camp2 VARCHAR2(3000);

Line 717: x_custom_output := bis_query_attributes_tbl ();

713: l_url_viewbyid VARCHAR2(100);
714: l_from VARCHAR2(100);
715:
716: BEGIN
717: x_custom_output := bis_query_attributes_tbl ();
718: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
719: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
720: l_as_of_date ,
721: l_period_type,

Line 810: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

806: END GET_SGMT_SIZE_SQL;
807:
808: PROCEDURE GET_SGMT_AVG_TXN_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
809: x_custom_sql OUT NOCOPY VARCHAR2,
810: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
811: IS
812: l_sqltext VARCHAR2 (20000);
813: iflag NUMBER;
814: l_period_type_hc NUMBER;

Line 827: l_custom_rec BIS_QUERY_ATTRIBUTES;

823: l_where VARCHAR2 (20000); -- static where clause
824: l_groupby VARCHAR2 (2000); -- to build group by clause
825: l_pc_from VARCHAR2 (20000); -- from clause to handle product category
826: l_pc_where VARCHAR2 (20000); -- where clause to handle product category
827: l_custom_rec BIS_QUERY_ATTRIBUTES;
828: l_object_type VARCHAR2(30);
829: l_url_link VARCHAR2(200);
830: l_url_camp1 VARCHAR2(3000);
831: l_url_camp2 VARCHAR2(3000);

Line 840: x_custom_output := bis_query_attributes_tbl ();

836: l_url_viewbyid VARCHAR2(100);
837: l_from VARCHAR2(100);
838:
839: BEGIN
840: x_custom_output := bis_query_attributes_tbl ();
841: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
842: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
843: l_as_of_date ,
844: l_period_type,

Line 947: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

943: END GET_SGMT_AVG_TXN_SQL;
944:
945: PROCEDURE GET_CAMP_EFF_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
946: x_custom_sql OUT NOCOPY VARCHAR2,
947: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
948: IS
949: l_sqltext VARCHAR2 (20000);
950: l_as_of_date DATE;
951: l_period_type VARCHAR2 (2000);

Line 962: l_custom_rec BIS_QUERY_ATTRIBUTES;

958: l_where VARCHAR2 (20000); -- static where clause
959: l_groupby VARCHAR2 (2000); -- to build group by clause
960: l_pc_from VARCHAR2 (20000); -- from clause to handle product category
961: l_pc_where VARCHAR2 (20000); -- where clause to handle product category
962: l_custom_rec BIS_QUERY_ATTRIBUTES;
963: l_object_type VARCHAR2(30);
964: l_url_link VARCHAR2(200);
965:
966: l_start_date VARCHAR2(30);

Line 988: x_custom_output := bis_query_attributes_tbl ();

984:
985:
986:
987: BEGIN
988: x_custom_output := bis_query_attributes_tbl ();
989: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
990: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
991: l_as_of_date ,
992: l_period_type,

Line 1630: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1626: END GET_CAMP_EFF_SQL;
1627:
1628: PROCEDURE GET_CAMP_ACT_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
1629: x_custom_sql OUT NOCOPY VARCHAR2,
1630: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1631: IS
1632: l_sqltext VARCHAR2 (20000);
1633: iflag NUMBER;
1634: l_period_type_hc NUMBER;

Line 1647: l_custom_rec BIS_QUERY_ATTRIBUTES;

1643: l_where VARCHAR2 (20000); -- static where clause
1644: l_groupby VARCHAR2 (2000); -- to build group by clause
1645: l_pc_from VARCHAR2 (20000); -- from clause to handle product category
1646: l_pc_where VARCHAR2 (20000); -- where clause to handle product category
1647: l_custom_rec BIS_QUERY_ATTRIBUTES;
1648: l_object_type VARCHAR2(30);
1649: l_url_link VARCHAR2(200);
1650: l_url_camp1 VARCHAR2(3000);
1651: l_url_camp2 VARCHAR2(3000);

Line 1673: x_custom_output := bis_query_attributes_tbl ();

1669: l_where_outer VARCHAR2(500);
1670:
1671:
1672: BEGIN
1673: x_custom_output := bis_query_attributes_tbl ();
1674: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1675: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
1676: l_as_of_date ,
1677: l_period_type,

Line 1840: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1836: END GET_CAMP_ACT_SQL;
1837:
1838: PROCEDURE GET_CAMP_TREND_SQL(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
1839: x_custom_sql OUT NOCOPY VARCHAR2,
1840: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1841: IS
1842: l_sqltext VARCHAR2 (20000);
1843: l_as_of_date DATE;
1844: l_period_type VARCHAR2 (2000);

Line 1854: l_custom_rec BIS_QUERY_ATTRIBUTES;

1850: l_select_filter VARCHAR2 (20000); -- to build select filter part
1851: l_where VARCHAR2 (20000); -- static where clause
1852: l_groupby VARCHAR2 (2000); -- to build group by clause
1853: l_from VARCHAR2 (20000); -- from clause
1854: l_custom_rec BIS_QUERY_ATTRIBUTES;
1855: l_object_type VARCHAR2(30);
1856:
1857: l_start_date VARCHAR2(30);
1858: l_curr_suffix VARCHAR2(2);

Line 1869: x_custom_output := bis_query_attributes_tbl ();

1865: l_col_where VARCHAR2(500);
1866:
1867:
1868: BEGIN
1869: x_custom_output := bis_query_attributes_tbl ();
1870: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1871: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
1872: l_as_of_date ,
1873: l_period_type,