APPS.HRI_OLTP_PMV_WMV_TRN_CTR dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 25: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;

21: -- Trend Period Parameters
22: l_projection_periods NUMBER;
23: l_previous_periods NUMBER;
24: l_trend_sql VARCHAR2(10000);
25: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;
26:
27: -- Annualization factor for period type parameter
28: l_calc_anl_factor NUMBER;
29:

Line 68: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

64: l_trend_sql_params.bind_format := 'PMV';
65: l_trend_sql_params.include_hdc := 'Y';
66: l_trend_sql_params.include_sep := 'Y';
67: l_trend_sql_params.bucket_dim := 'GEOGRAPHY+COUNTRY';
68: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
69: (p_parameter_rec => l_parameter_rec,
70: p_bind_tab => l_bind_tab,
71: p_trend_sql_params => l_trend_sql_params,
72: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_CTR.GET_SQL_CTR_T4');