DBA Data[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;