APPS.HRI_OLTP_PMV_WMV_WF_SUP dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 22: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

18: l_security_clause VARCHAR2(4000);
19: l_custom_rec BIS_QUERY_ATTRIBUTES ;
20:
21: /* Parameter values */
22: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
23: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
24:
25: /* Dynamic SQL controls */
26: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

Line 23: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

19: l_custom_rec BIS_QUERY_ATTRIBUTES ;
20:
21: /* Parameter values */
22: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
23: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
24:
25: /* Dynamic SQL controls */
26: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
27: l_wrkfc_fact_sql VARCHAR2(10000);

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 101: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

97: l_security_clause VARCHAR2(4000);
98: l_custom_rec BIS_QUERY_ATTRIBUTES;
99:
100: /* Parameter values */
101: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
102: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
103:
104: /* Pre-calculations */
105: l_tot_gain NUMBER;

Line 102: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

98: l_custom_rec BIS_QUERY_ATTRIBUTES;
99:
100: /* Parameter values */
101: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
102: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
103:
104: /* Pre-calculations */
105: l_tot_gain NUMBER;
106: l_tot_gain_hire NUMBER;

Line 153: hri_oltp_pmv_util_param.get_parameters_from_table

149: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
150: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
151:
152: /* Get common parameter values */
153: hri_oltp_pmv_util_param.get_parameters_from_table
154: (p_page_parameter_tbl => p_page_parameter_tbl,
155: p_parameter_rec => l_parameter_rec,
156: p_bind_tab => l_bind_tab);
157: