PACKAGE: APPS.HRI_OLTP_PMV_QUERY_TREND

Source

1 PACKAGE hri_oltp_pmv_query_trend AS
2 /* $Header: hriopqtd.pkh 120.2 2005/09/20 05:02:45 cbridge noship $ */
3 
4 TYPE trend_sql_params_type IS RECORD
5  (bind_format      VARCHAR2(30) := 'PMV',
6   include_hdc      VARCHAR2(30) := 'N',
7   include_hdc_trn  VARCHAR2(30) := 'N',
8   include_pasg_cnt VARCHAR2(30) := 'N',
9   include_pasg_pow VARCHAR2(30) := 'N',
10   include_extn_cnt VARCHAR2(30) := 'N',
11   include_extn_pow VARCHAR2(30) := 'N',
12   include_sal      VARCHAR2(30) := 'N',
13   include_sep      VARCHAR2(30) := 'N',
14   include_sep_vol  VARCHAR2(30) := 'N',
15   include_sep_inv  VARCHAR2(30) := 'N',
16   include_abs_drtn_days    VARCHAR2(30) := 'N',
17   include_abs_drtn_hrs     VARCHAR2(30) := 'N',
18   include_abs_in_period    VARCHAR2(30) := 'N',
19   include_abs_ntfctn_period VARCHAR2(30) := 'N',
20   bucket_dim       VARCHAR2(30) := '',
21   past_trend       VARCHAR2(30) := 'Y',
22   future_trend     VARCHAR2(30) := 'N');
23 
24 TYPE trend_measure_cols_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
25 
26 FUNCTION get_sql
27  (p_parameter_rec     IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
28   p_bind_tab          IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
29   p_trend_sql_params  IN trend_sql_params_type,
30   p_calling_module    IN VARCHAR2)
31 RETURN VARCHAR2;
32 
33 END hri_oltp_pmv_query_trend;