APPS.HRI_OLTP_PMV_QUERY_TREND dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 46: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

42: /* This procedure decides whether to call workforce, terminations or */
43: /* both (turnover), gets the sql for the accessing the required info */
44: /* and returns this along with a list of the measure columns used */
45: PROCEDURE get_fact_sql
46: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
47: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
48: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
49: p_fact_sql OUT NOCOPY VARCHAR2,
50: p_measure_columns OUT NOCOPY trend_measure_cols_type)

Line 47: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

43: /* both (turnover), gets the sql for the accessing the required info */
44: /* and returns this along with a list of the measure columns used */
45: PROCEDURE get_fact_sql
46: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
47: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
48: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
49: p_fact_sql OUT NOCOPY VARCHAR2,
50: p_measure_columns OUT NOCOPY trend_measure_cols_type)
51:

Line 164: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

160: -- p_trend_sql_params : For passing the tredn parameters
161: -- -------------------------------------------------------------------------
162: --
163: FUNCTION get_sql
164: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
165: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
166: p_trend_sql_params IN trend_sql_params_type,
167: p_calling_module IN VARCHAR2)
168: RETURN VARCHAR2 IS

Line 165: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

161: -- -------------------------------------------------------------------------
162: --
163: FUNCTION get_sql
164: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
165: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
166: p_trend_sql_params IN trend_sql_params_type,
167: p_calling_module IN VARCHAR2)
168: RETURN VARCHAR2 IS
169: --