APPS.OKI_DBI_SRM_RNWL_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 52: p_param IN bis_pmv_page_parameter_tbl

48: RETURN VARCHAR2;
49: */
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:

Line 395: p_param IN bis_pmv_page_parameter_tbl

391: RETURN l_sel_clause;
392: END get_table_sel_clause;
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:

Line 497: p_param IN bis_pmv_page_parameter_tbl

493:
494: END get_bookings_sql;
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:

Line 714: p_param IN bis_pmv_page_parameter_tbl

710: * x_custom_output -->contains the bind variables
711: */
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);

Line 744: p_param IN bis_pmv_page_parameter_tbl

740: */
741:
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);

Line 911: p_param IN bis_pmv_page_parameter_tbl

907: * x_custom_output -->contains the bind variables
908: */
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);

Line 946: p_param IN bis_pmv_page_parameter_tbl

942:
943: *******************************************************************************/
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:

Line 1282: p_param IN bis_pmv_page_parameter_tbl

1278: Description: Function to get Renewals Cancellations Summary Report DBI 6.0
1279: *******************************************************************************/
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:

Line 1535: p_param IN bis_pmv_page_parameter_tbl

1531: Description: Function to get Renewals Cancellations Summary Detail Report DBI 6.0
1532: *******************************************************************************/
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:

Line 1703: p_param IN bis_pmv_page_parameter_tbl

1699: * x_custom_output -->contains the bind variables
1700: */
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);

Line 1740: PROCEDURE get_bucket_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1736: Function: get_bucket_sql
1737: Description: Function to get Late Renewal Bookings Aging Report DBI 6.0
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);

Line 1969: PROCEDURE get_bkng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1965: Function: get_bkng_trend_sql (get_forecast_trend_sql)
1966: Description: Function for the Bookings Trend Forecast graph in DBI 6.0
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