APPS.BIL_BI_UTIL_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 192: PROCEDURE GET_CURR_START_DATE (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

188: --
189: -- Purpose:
190: -- used by the reports to obtain the start date of the current period
191: -- **********************************************************************
192: PROCEDURE GET_CURR_START_DATE (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
193: p_as_of_date IN DATE,
194: p_period_type IN VARCHAR2,
195: x_curr_start_date OUT NOCOPY DATE)
196: AS

Line 502: PROCEDURE GET_LATEST_SNAP_DATE(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

498: -- used by the reports that display pipeline and/or open opportunity
499: -- to retrieve the date of the last snapshot. This date will be used
500: -- instead of the as_of_date in the front end query.
501: -- **********************************************************************
502: PROCEDURE GET_LATEST_SNAP_DATE(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
503: ,p_as_of_date IN DATE
504: ,p_period_type IN VARCHAR2
505: ,x_snapshot_date OUT NOCOPY DATE )
506: AS

Line 623: PROCEDURE GET_PAGE_PARAMS (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

619: END IF;
620: END;
621:
622:
623: PROCEDURE GET_PAGE_PARAMS (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
624: p_region_id IN VARCHAR2,
625: x_as_of_date OUT NOCOPY DATE,
626: x_comp_type OUT NOCOPY VARCHAR2,
627: x_conv_rate_selected OUT NOCOPY VARCHAR2,

Line 1272: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1268: -- year - fii_time_ent_year
1269: -- **********************************************************************
1270: PROCEDURE GET_TREND_PARAMS( p_comp_type IN VARCHAR2,
1271: p_curr_as_of_date IN DATE,
1272: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1273: p_page_period_type IN VARCHAR2,
1274: x_column_name OUT NOCOPY VARCHAR2,
1275: x_curr_eff_end_date OUT NOCOPY DATE,
1276: x_curr_start_date OUT NOCOPY DATE,

Line 1465: FUNCTION isUserCurrency (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

1461: -- the drill across URL to FII and ISC if user currency is selected.
1462: --
1463: -- **********************************************************************
1464:
1465: FUNCTION isUserCurrency (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
1466: RETURN BOOLEAN AS
1467:
1468: l_currency VARCHAR2(100);
1469: l_isUserCurrency BOOLEAN;

Line 1933: FUNCTION GET_LBL_SGFST (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL) RETURN VARCHAR2

1929: -- FUNCTION GET_LABEL_SGR
1930: -- Purpose: to change the column headng dynamically when Sales Group/Sales Rep is selected from SG LOV on report
1931: -- **********************************************************************************
1932:
1933: FUNCTION GET_LBL_SGFST (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL) RETURN VARCHAR2
1934: AS
1935:
1936: l_salesgroup_id VARCHAR2(100);
1937: l_resource_id VARCHAR2(100);

Line 2012: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

2008: p_prev_date IN DATE,
2009: p_period_type IN VARCHAR2,
2010: p_coll_st_date IN DATE,
2011: p_coll_end_date IN DATE,
2012: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
2013: x_snap_date OUT NOCOPY DATE,
2014: x_prev_snap_date OUT NOCOPY DATE
2015: )
2016:

Line 2137: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

2133: p_asof_date IN DATE,
2134: p_period_type IN VARCHAR2,
2135: p_compare_to IN VARCHAR2,
2136: p_prev_date IN DATE,
2137: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
2138: x_pipe_mv OUT NOCOPY VARCHAR2,
2139: x_snapshot_date OUT NOCOPY DATE,
2140: x_prev_snap_date OUT NOCOPY DATE
2141: )

Line 2501: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

2497: PROCEDURE GET_PIPE_TREND_SOURCE (p_as_of_date IN DATE,
2498: p_prev_date IN DATE,
2499: p_trend_type IN VARCHAR2,
2500: p_period_type IN VARCHAR2,
2501: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
2502: x_pipe_mv OUT NOCOPY VARCHAR2,
2503: x_snap_date OUT NOCOPY DATE,
2504: x_prev_snap_date OUT NOCOPY DATE)
2505: AS