APPS.HRI_OLTP_PMV_UTIL_PKG dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 76: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

72: END set_default_order_by;
73:
74: -- adds a filter on the viewby for "small" view bys
75: FUNCTION set_viewby_filter
76: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
77: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
78: p_view_by_alias IN VARCHAR2)
79: RETURN VARCHAR2 IS
80:

Line 77: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

73:
74: -- adds a filter on the viewby for "small" view bys
75: FUNCTION set_viewby_filter
76: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
77: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
78: p_view_by_alias IN VARCHAR2)
79: RETURN VARCHAR2 IS
80:
81: l_viewby_filter VARCHAR2(1000);

Line 123: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

119: -- debugging.
120: -- -------------------------------------------------------------------------
121: --
122: PROCEDURE substitute_bind_values
123: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
124: p_bind_format IN VARCHAR2,
125: p_sql IN OUT NOCOPY VARCHAR2)
126: IS
127: --

Line 159: FUNCTION chk_emp_dir_lnk(p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE

155: -- Link to HR Employee Directory
156: --
157: -- -------------------------------------------------------------------------
158: --
159: FUNCTION chk_emp_dir_lnk(p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE
160: ,p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE)
161:
162: RETURN NUMBER IS
163:

Line 160: ,p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE)

156: --
157: -- -------------------------------------------------------------------------
158: --
159: FUNCTION chk_emp_dir_lnk(p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE
160: ,p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE)
161:
162: RETURN NUMBER IS
163:
164: l_return_chk NUMBER;