DBA Data[Home] [Help]

APPS.HRI_BPL_TREND_WRKFC_SQL dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 7: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,

3:
4: PROCEDURE get_sql
5: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
6: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
7: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
8: p_date_join_type IN VARCHAR2,
9: p_fact_sql OUT NOCOPY VARCHAR2,
10: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type,
11: p_use_snapshot OUT NOCOPY BOOLEAN);

Line 10: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type,

6: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
7: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
8: p_date_join_type IN VARCHAR2,
9: p_fact_sql OUT NOCOPY VARCHAR2,
10: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type,
11: p_use_snapshot OUT NOCOPY BOOLEAN);
12:
13: END hri_bpl_trend_wrkfc_sql;