1 PACKAGE hri_oltp_pmv_util_pkg AS
2 /* $Header: hrioputl.pkh 120.1 2005/08/08 04:03 jtitmas noship $ */
3
4 -- returns the common AK_QUERY PLSQL clause for MGR security
5 FUNCTION get_security_clause(p_security_type VARCHAR2) -- [MGR, ORG]
6 RETURN VARCHAR2;
7
8 -- returns the annualization factor for a period
9 FUNCTION calc_anl_factor(p_period_type IN VARCHAR2)
10 RETURN NUMBER;
11
12 -- sets the order by clause
13 FUNCTION set_default_order_by(p_order_by_clause IN VARCHAR2)
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
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
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 %
36 FUNCTION get_change_percent_sql(p_previous_col IN VARCHAR2,
37 p_current_col IN VARCHAR2)
38 RETURN VARCHAR2;
39
40 END hri_oltp_pmv_util_pkg;