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_TBL

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 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 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 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 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 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 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 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 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,