APPS.HRI_OLTP_PMV_TRN_BCKT_GRAPH dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 17: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

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

Line 18: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

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

Line 39: hri_oltp_pmv_util_param.get_parameters_from_table

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

Line 121: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

117: l_custom_rec BIS_QUERY_ATTRIBUTES;
118: l_security_clause VARCHAR2(4000);
119:
120: /* Parameter values */
121: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
122: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
123:
124: /* Dynamic SQL Controls */
125: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

Line 122: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

118: l_security_clause VARCHAR2(4000);
119:
120: /* Parameter values */
121: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
122: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
123:
124: /* Dynamic SQL Controls */
125: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
126: l_wcnt_chg_fact_sql VARCHAR2(10000);

Line 138: hri_oltp_pmv_util_param.get_parameters_from_table

134: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
136:
137: /* Get common parameter values */
138: hri_oltp_pmv_util_param.get_parameters_from_table
139: (p_page_parameter_tbl => p_page_parameter_tbl,
140: p_parameter_rec => l_parameter_rec,
141: p_bind_tab => l_bind_tab);
142:

Line 243: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

239: l_SQLText VARCHAR2(32767) ;
240: l_custom_rec BIS_QUERY_ATTRIBUTES;
241:
242: /* Parameter values */
243: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
244: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
245:
246: l_security_clause VARCHAR2(4000);
247:

Line 244: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

240: l_custom_rec BIS_QUERY_ATTRIBUTES;
241:
242: /* Parameter values */
243: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
244: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
245:
246: l_security_clause VARCHAR2(4000);
247:
248: l_drill_url1 VARCHAR2(1000);

Line 260: hri_oltp_pmv_util_param.get_parameters_from_table

256: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
257: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
258:
259: /* Get common parameter values */
260: hri_oltp_pmv_util_param.get_parameters_from_table
261: (p_page_parameter_tbl => p_page_parameter_tbl,
262: p_parameter_rec => l_parameter_rec,
263: p_bind_tab => l_bind_tab);
264: