APPS.HRI_OLTP_PMV_ABS_DTL dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 20: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

16: /******************************************************************************/
17: /* Absence detail for Staff = Directs */
18: /******************************************************************************/
19: PROCEDURE get_abs_detail_directs
20: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
21: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
22: p_lnk_emp_name IN VARCHAR2,
23: p_lnk_mgr_name IN VARCHAR2,
24: x_custom_sql OUT NOCOPY VARCHAR2,

Line 21: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

17: /* Absence detail for Staff = Directs */
18: /******************************************************************************/
19: PROCEDURE get_abs_detail_directs
20: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
21: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
22: p_lnk_emp_name IN VARCHAR2,
23: p_lnk_mgr_name IN VARCHAR2,
24: x_custom_sql OUT NOCOPY VARCHAR2,
25: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

Line 173: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

169: /******************************************************************************/
170: /* Absence (Employee) Detail for Staff = All */
171: /******************************************************************************/
172: PROCEDURE get_abs_detail_all
173: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
174: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
175: p_lnk_emp_name IN VARCHAR2,
176: p_lnk_mgr_name IN VARCHAR2,
177: x_custom_sql OUT NOCOPY VARCHAR2,

Line 174: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

170: /* Absence (Employee) Detail for Staff = All */
171: /******************************************************************************/
172: PROCEDURE get_abs_detail_all
173: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
174: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
175: p_lnk_emp_name IN VARCHAR2,
176: p_lnk_mgr_name IN VARCHAR2,
177: x_custom_sql OUT NOCOPY VARCHAR2,
178: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

Line 318: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

314: x_custom_sql OUT NOCOPY VARCHAR2,
315: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
316:
317: /* Parameter values */
318: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
319: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
320:
321: /* Variables for dynamic part of SQL query */
322: l_lnk_profile_chk VARCHAR2(4000);

Line 319: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

315: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
316:
317: /* Parameter values */
318: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
319: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
320:
321: /* Variables for dynamic part of SQL query */
322: l_lnk_profile_chk VARCHAR2(4000);
323: l_lnk_emp_name VARCHAR2(4000);

Line 329: hri_oltp_pmv_util_param.get_parameters_from_table

325:
326: BEGIN
327:
328: /* Get common parameter values */
329: hri_oltp_pmv_util_param.get_parameters_from_table
330: (p_page_parameter_tbl => p_page_parameter_tbl,
331: p_parameter_rec => l_parameter_rec,
332: p_bind_tab => l_bind_tab);
333: