APPS.HRI_OLTP_PMV_UTIL_PKG dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 18: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

14: RETURN VARCHAR2;
15:
16: -- adds a filter on the viewby for "small" view bys
17: FUNCTION set_viewby_filter
18: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
19: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
20: p_view_by_alias IN VARCHAR2)
21: RETURN VARCHAR2;
22:

Line 19: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

15:
16: -- adds a filter on the viewby for "small" view bys
17: FUNCTION set_viewby_filter
18: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
19: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
20: p_view_by_alias IN VARCHAR2)
21: RETURN VARCHAR2;
22:
23: -- substitutes SQL values for PMV binds

Line 25: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

21: RETURN VARCHAR2;
22:
23: -- substitutes SQL values for PMV binds
24: PROCEDURE substitute_bind_values
25: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
26: p_bind_format IN VARCHAR2,
27: p_sql IN OUT NOCOPY VARCHAR2);
28:
29: -- Checks profile option Enable / Disable Link to HR Employee Directory

Line 30: FUNCTION chk_emp_dir_lnk(p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE

26: p_bind_format IN VARCHAR2,
27: p_sql IN OUT NOCOPY VARCHAR2);
28:
29: -- Checks profile option Enable / Disable Link to HR Employee Directory
30: FUNCTION chk_emp_dir_lnk(p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE
31: ,p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE)
32:
33: RETURN NUMBER;
34:

Line 31: ,p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE)

27: p_sql IN OUT NOCOPY VARCHAR2);
28:
29: -- Checks profile option Enable / Disable Link to HR Employee Directory
30: FUNCTION chk_emp_dir_lnk(p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE
31: ,p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE)
32:
33: RETURN NUMBER;
34:
35: -- Gets sql fragment for change %