[Home] [Help]
PACKAGE: APPS.HRI_BPL_TREND_WRKFC_SQL
Source
1 PACKAGE hri_bpl_trend_wrkfc_sql AS
2 /* $Header: hribtwrk.pkh 120.0 2005/05/29 07:05:56 appldev noship $ */
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);
12
13 END hri_bpl_trend_wrkfc_sql;