APPS.HRI_OLTP_PMV_ABS_CAT dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 27: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;

23: -- Trend Period Parameters
24: l_projection_periods NUMBER;
25: l_previous_periods NUMBER;
26: l_trend_sql VARCHAR2(10000);
27: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;
28:
29: -- dyanamic columns
30: l_period_abs_drtn_metric1 VARCHAR2(1000);
31: l_period_abs_drtn_metric2 VARCHAR2(1000);

Line 102: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

98: /* Set to bucket for Absence Category */
99: l_trend_sql_params.bucket_dim := 'HRI_ABSNC+HRI_ABSNC_CAT';
100:
101: /* Call the UI fact code centralization for the Trend */
102: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
103: (p_parameter_rec => l_parameter_rec,
104: p_bind_tab => l_bind_tab,
105: p_trend_sql_params => l_trend_sql_params,
106: p_calling_module => 'HRI_OLTP_PMV_ABS_CAT.GET_SQL_ABSCAT_T4');