APPS.BIX_PMV_DBI_UTL_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 47: FUNCTION get_dnis_where_clause(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl) RETURN VARCHAR2;

43: FUNCTION get_mv (
44: p_mv_set IN VARCHAR2
45: , p_version IN VARCHAR2 /*Retained for extensibility*/) RETURN VARCHAR2;
46:
47: FUNCTION get_dnis_where_clause(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl) RETURN VARCHAR2;
48:
49: FUNCTION get_agent_group_where_clause(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
50: p_mv_set IN VARCHAR2
51: ) RETURN VARCHAR2;

Line 49: FUNCTION get_agent_group_where_clause(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

45: , p_version IN VARCHAR2 /*Retained for extensibility*/) RETURN VARCHAR2;
46:
47: FUNCTION get_dnis_where_clause(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl) RETURN VARCHAR2;
48:
49: FUNCTION get_agent_group_where_clause(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
50: p_mv_set IN VARCHAR2
51: ) RETURN VARCHAR2;
52: FUNCTION get_outcome_filter_clause RETURN VARCHAR2;
53:

Line 55: p_param IN bis_pmv_page_parameter_tbl

51: ) RETURN VARCHAR2;
52: FUNCTION get_outcome_filter_clause RETURN VARCHAR2;
53:
54: PROCEDURE process_parameters (
55: p_param IN bis_pmv_page_parameter_tbl
56: , p_trend IN VARCHAR2
57: , p_func_area IN VARCHAR2
58: , p_version IN VARCHAR2
59: , p_mv_set IN VARCHAR2 --ITM/OTM/ECM

Line 214: FUNCTION get_dnis_where_clause(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl) RETURN VARCHAR2

210: /* -----------------------------------------------------------------------------
211: get_dnis_where_clause:Determines if DNIS is selected and creates a where clause
212: accordingly
213: ----------------------------------------------------------------------------- */
214: FUNCTION get_dnis_where_clause(p_page_parameter_tbl IN bis_pmv_page_parameter_tbl) RETURN VARCHAR2
215: IS
216: l_dnis varchar2(3000);
217: l_where_clause varchar2(1000);
218: BEGIN

Line 248: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,

244: get_agent_group_where_clause:Determines if agent group is selected and creates a where clause
245: accordingly
246: ----------------------------------------------------------------------------- */
247: FUNCTION get_agent_group_where_clause(
248: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
249: p_mv_set IN varchar2
250: ) RETURN VARCHAR2
251: IS
252: l_agent_group varchar2(3000);

Line 1695: PROCEDURE get_emc_page_params (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1691:
1692: /*-------------------------------------------------------------------------------------------------------
1693: ---------------------------------------------------------------------------------------------------------*/
1694:
1695: PROCEDURE get_emc_page_params (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1696: l_as_of_date OUT NOCOPY DATE,
1697: l_period_type OUT NOCOPY VARCHAR2,
1698: l_record_type_id OUT NOCOPY NUMBER,
1699: l_comp_type OUT NOCOPY VARCHAR2,

Line 1802: PROCEDURE get_ai_page_params (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1798: THEN
1799: RETURN 'BIX_PMV_WEEK_FROM=ALL&BIX_PMV_WEEK_TO=ALL&BIX_PMV_SEQUENTIAL=TIME_COMPARISON_TYPE+SEQUENTIAL&AS_OF_DATE='||TO_CHAR(TRUNC(sysdate),'DD-MON-YYYY');
1800: END get_default_params;
1801:
1802: PROCEDURE get_ai_page_params (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1803: l_as_of_date OUT NOCOPY DATE,
1804: l_period_type OUT NOCOPY VARCHAR2,
1805: l_record_type_id OUT NOCOPY NUMBER,
1806: l_comp_type OUT NOCOPY VARCHAR2,

Line 1890: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

1886: RETURN 'FII_TIME_WEEK_FROM=All&FII_TIME_WEEK_TO=All&SEQUENTIAL=TIME_COMPARISON_TYPE+SEQUENTIAL&AS_OF_DATE='||TO_CHAR(TRUNC(sysdate),'DD-MON-YYYY');
1887: END get_ai_default_page_params;
1888:
1889: PROCEDURE GET_AO_PAGE_PARAMS
1890: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1891: l_as_of_date OUT NOCOPY DATE,
1892: l_period_type OUT NOCOPY VARCHAR2,
1893: l_record_type_id OUT NOCOPY NUMBER,
1894: l_comp_type OUT NOCOPY VARCHAR2,