eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_BPL_TREND_WRKFC_ABS_SQL dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 51: p_trend_sql_params IN hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE,

47: --
48: PROCEDURE get_sql
49: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
50: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
51: p_trend_sql_params IN hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE,
52: p_fact_sql OUT NOCOPY VARCHAR2,
53: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)
54: IS
55: --

Line 53: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)

49: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
50: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
51: p_trend_sql_params IN hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE,
52: p_fact_sql OUT NOCOPY VARCHAR2,
53: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)
54: IS
55: --
56: -- Stores the trend SQL for absence
57: --

Line 59: l_abs_measure_cols hri_oltp_pmv_query_trend.trend_measure_cols_type;

55: --
56: -- Stores the trend SQL for absence
57: --
58: l_absence_sql VARCHAR2(32767);
59: l_abs_measure_cols hri_oltp_pmv_query_trend.trend_measure_cols_type;
60: --
61: -- Stores the trend SQL for headcount
62: --
63: l_headcount_sql VARCHAR2(32767);

Line 64: l_hdc_measure_cols hri_oltp_pmv_query_trend.trend_measure_cols_type;

60: --
61: -- Stores the trend SQL for headcount
62: --
63: l_headcount_sql VARCHAR2(32767);
64: l_hdc_measure_cols hri_oltp_pmv_query_trend.trend_measure_cols_type;
65: --
66: -- Stores the trend SQL for headcount at period start
67: --
68: l_headcount_start_sql VARCHAR2(32767);

Line 69: l_hdc_start_cols hri_oltp_pmv_query_trend.trend_measure_cols_type;

65: --
66: -- Stores the trend SQL for headcount at period start
67: --
68: l_headcount_start_sql VARCHAR2(32767);
69: l_hdc_start_cols hri_oltp_pmv_query_trend.trend_measure_cols_type;
70: --
71: -- Stores the absence SQL
72: --
73: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;

Line 76: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;

72: --
73: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;
74: l_sql_select VARCHAR2(10000);
75: --
76: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;
77: l_index PLS_INTEGER := 0;
78: l_trn_calc_mth VARCHAR2(30);
79: l_use_snapshot BOOLEAN;
80: --