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.

[Home] [Help]

APPS.OKI_DBI_SRM_RNWL_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 54: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

50:
51: PROCEDURE get_table_sql (
52: p_param IN bis_pmv_page_parameter_tbl
53: , x_custom_sql OUT NOCOPY VARCHAR2
54: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
55: IS
56:
57: l_query VARCHAR2 (32767);
58: l_view_by VARCHAR2 (120);

Line 397: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

393:
394: PROCEDURE get_bookings_sql (
395: p_param IN bis_pmv_page_parameter_tbl
396: , x_custom_sql OUT NOCOPY VARCHAR2
397: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
398: IS
399:
400: l_query VARCHAR2 (32767);
401: l_view_by VARCHAR2 (120);

Line 499: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

495:
496: PROCEDURE get_top_bookings_sql (
497: p_param IN bis_pmv_page_parameter_tbl
498: , x_custom_sql OUT NOCOPY VARCHAR2
499: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
500: IS
501:
502: l_query VARCHAR2 (32767);
503: l_view_by VARCHAR2 (120);

Line 716: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

712:
713: PROCEDURE get_bkngs_by_cust_sql (
714: p_param IN bis_pmv_page_parameter_tbl
715: , x_custom_sql OUT NOCOPY VARCHAR2
716: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
717: IS
718: l_query VARCHAR2 (32767);
719: BEGIN
720: l_query := 'Hello';

Line 746: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

742:
743: PROCEDURE get_renewal_forecast_sql (
744: p_param IN bis_pmv_page_parameter_tbl
745: , x_custom_sql OUT NOCOPY VARCHAR2
746: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
747: IS
748: l_query VARCHAR2 (32767);
749: l_view_by VARCHAR2 (120);
750: l_view_by_col VARCHAR2 (120);

Line 913: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

909:
910: PROCEDURE get_exp_bkngs_by_cust_sql (
911: p_param IN bis_pmv_page_parameter_tbl
912: , x_custom_sql OUT NOCOPY VARCHAR2
913: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
914: IS
915: l_query VARCHAR2 (32767);
916: BEGIN
917: l_query := 'Hello';

Line 948: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

944:
945: PROCEDURE get_late_rnwl_table_sql (
946: p_param IN bis_pmv_page_parameter_tbl
947: , x_custom_sql OUT NOCOPY VARCHAR2
948: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
949: IS
950:
951: l_query VARCHAR2 (32767);
952: l_view_by VARCHAR2 (120);

Line 1284: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

1280:
1281: PROCEDURE get_cncl_table_sql (
1282: p_param IN bis_pmv_page_parameter_tbl
1283: , x_custom_sql OUT NOCOPY VARCHAR2
1284: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
1285: IS
1286:
1287: l_query VARCHAR2 (32767);
1288: l_view_by VARCHAR2 (120);

Line 1537: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

1533:
1534: PROCEDURE get_cancellations_sql (
1535: p_param IN bis_pmv_page_parameter_tbl
1536: , x_custom_sql OUT NOCOPY VARCHAR2
1537: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
1538: IS
1539:
1540: l_query VARCHAR2 (32767);
1541: l_view_by VARCHAR2 (120);

Line 1705: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)

1701:
1702: PROCEDURE get_cancln_by_cust_sql (
1703: p_param IN bis_pmv_page_parameter_tbl
1704: , x_custom_sql OUT NOCOPY VARCHAR2
1705: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
1706: IS
1707: l_query VARCHAR2 (32767);
1708: BEGIN
1709: l_query := 'Hello';

Line 1742: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1738: *******************************************************************************/
1739:
1740: PROCEDURE get_bucket_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1741: x_custom_sql OUT NOCOPY VARCHAR2,
1742: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1743:
1744: l_query VARCHAR2 (32767);
1745: l_view_by VARCHAR2 (120);
1746: l_view_by_col VARCHAR2 (120);

Line 1971: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1967: *******************************************************************************/
1968:
1969: PROCEDURE get_bkng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1970: x_custom_sql OUT NOCOPY VARCHAR2,
1971: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1972:
1973: -- Variables associated with the parameter portlet
1974: l_query VARCHAR2 (32767);
1975: l_view_by VARCHAR2 (120);