APPS.HRI_OLTP_PMV_WMV_SAL_SUP dependencies on HRI_OLTP_PMV_UTIL_PKG

Line 38: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

34: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
35: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
36:
37: /* Get security clause for Manager based security */
38: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
39:
40: /* Set direct reports string */
41: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
42:

Line 67: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

63: 'HRI_P_SUPH_RO_CA=HRI_P_SUPH_RO_CA&' ||
64: 'pParamIds=Y';
65:
66: /* substitute for VIEWBY in order by clause */
67: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
68: (p_order_by_clause => l_parameter_rec.order_by);
69:
70: /* Get SQL for workforce fact */
71: l_wrkfc_fact_params.bind_format := 'PMV';

Line 93: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

89: ''1'', ''' || l_drill_url3 || ''',
90: ''' || l_drill_url1 || ''') HRI_P_DRILL_URL1
91: ,tab.curr_hdc HRI_P_WMV_SUM_MV
92: ,tab.curr_sal HRI_P_SAL_ANL_CUR_PARAM_SUM_MV
93: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
94: (p_previous_col => 'tab.comp_sal',
95: p_current_col => 'tab.curr_sal') || '
96: HRI_P_MEASURE5
97: ,tab.curr_avg_sal HRI_P_MEASURE1

Line 98: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

94: (p_previous_col => 'tab.comp_sal',
95: p_current_col => 'tab.curr_sal') || '
96: HRI_P_MEASURE5
97: ,tab.curr_avg_sal HRI_P_MEASURE1
98: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
99: (p_previous_col => 'tab.comp_avg_sal',
100: p_current_col => 'tab.curr_avg_sal') || '
101: HRI_P_MEASURE2
102: ,tab.comp_avg_sal HRI_P_MEASURE3

Line 106: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

102: ,tab.comp_avg_sal HRI_P_MEASURE3
103: ,tab.comp_total_sal HRI_P_MEASURE4
104: ,tab.curr_total_hdc HRI_P_GRAND_TOTAL1
105: ,tab.curr_total_sal HRI_P_GRAND_TOTAL2
106: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
107: (p_previous_col => 'tab.comp_total_sal',
108: p_current_col => 'tab.curr_total_sal') || '
109: HRI_P_GRAND_TOTAL7
110: ,tab.curr_total_avg_sal HRI_P_GRAND_TOTAL3

Line 112: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

108: p_current_col => 'tab.curr_total_sal') || '
109: HRI_P_GRAND_TOTAL7
110: ,tab.curr_total_avg_sal HRI_P_GRAND_TOTAL3
111: ,tab.comp_total_avg_sal HRI_P_GRAND_TOTAL5
112: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
113: (p_previous_col => 'tab.comp_total_avg_sal',
114: p_current_col => 'tab.curr_total_avg_sal') || '
115: HRI_P_GRAND_TOTAL4
116: ,tab.comp_total_sal HRI_P_GRAND_TOTAL6

Line 222: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

218: BEGIN
219: --
220: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
221: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
222: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
223: --
224: -- Get the parameter information from the page parameter table
225: --
226: hri_oltp_pmv_util_param.get_parameters_from_table