APPS.HRI_OLTP_PMV_WMV_BCKT_GRAPH dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 14: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

10: l_security_clause VARCHAR2(4000);
11: l_SQLText VARCHAR2(4000);
12:
13: /* Parameter values */
14: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
15: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
16:
17: /* Pre-calculations */
18: l_trend_table VARCHAR2(4000);

Line 15: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

11: l_SQLText VARCHAR2(4000);
12:
13: /* Parameter values */
14: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
15: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
16:
17: /* Pre-calculations */
18: l_trend_table VARCHAR2(4000);
19: l_projection_periods NUMBER;

Line 36: hri_oltp_pmv_util_param.get_parameters_from_table

32: /* Get security clause for Manager based security */
33: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
34:
35: /* Get common parameter values */
36: hri_oltp_pmv_util_param.get_parameters_from_table
37: (p_page_parameter_tbl => p_page_parameter_tbl
38: ,p_parameter_rec => l_parameter_rec
39: ,p_bind_tab => l_bind_tab);
40:

Line 122: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

118: l_security_clause VARCHAR2(4000);
119: l_SQLText VARCHAR2(4000);
120:
121: /* Parameter values */
122: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
123: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
124:
125: /* Pre-calculations */
126: l_trend_table VARCHAR2(4000);

Line 123: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

119: l_SQLText VARCHAR2(4000);
120:
121: /* Parameter values */
122: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
123: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
124:
125: /* Pre-calculations */
126: l_trend_table VARCHAR2(4000);
127: l_projection_periods NUMBER;

Line 144: hri_oltp_pmv_util_param.get_parameters_from_table

140: /* Get security clause for Manager based security */
141: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
142:
143: /* Get common parameter values */
144: hri_oltp_pmv_util_param.get_parameters_from_table
145: (p_page_parameter_tbl => p_page_parameter_tbl
146: ,p_parameter_rec => l_parameter_rec
147: ,p_bind_tab => l_bind_tab);
148: