APPS.HRI_OLTP_PMV_ABS_WMV_PVT dependencies on HRI_OLTP_PMV_UTIL_PKG

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

57: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
58: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
59:
60: /* Get security clause for Manager based security */
61: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
62:
63: /* Get common parameter values */
64: hri_oltp_pmv_util_param.get_parameters_from_table
65: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 73: l_dynsql_order_by := hri_oltp_pmv_util_pkg.set_default_order_by

69: /* Get direct reports string */
70: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
71:
72: /* Set the order by */
73: l_dynsql_order_by := hri_oltp_pmv_util_pkg.set_default_order_by
74: (p_order_by_clause => l_parameter_rec.order_by);
75:
76: /* Drill URL's for Manager and Direct Reports */
77: l_drill_mgr_sup :='pFunctionName=HRI_P_ABS_WMV_PVT&' ||

Line 188: ,'|| hri_oltp_pmv_util_pkg.get_change_percent_sql

184: /* Average Notification */ || g_rtn ||'
185: ,NVL(curr_abs_avg_ntfctn_period,0) HRI_P_MEASURE6
186: ,NVL(comp_abs_avg_ntfctn_period,0) HRI_P_MEASURE7'|| g_rtn
187: /* Change - Average Notification */ || g_rtn ||'
188: ,'|| hri_oltp_pmv_util_pkg.get_change_percent_sql
189: (p_previous_col => 'comp_abs_avg_ntfctn_period',
190: p_current_col => 'curr_abs_avg_ntfctn_period') || '
191: HRI_P_MEASURE6_MP'|| g_rtn
192: /* Total Absence Duration */ || g_rtn ||'

Line 196: ,'|| hri_oltp_pmv_util_pkg.get_change_percent_sql

192: /* Total Absence Duration */ || g_rtn ||'
193: ,NVL(babs.curr_abs_drtn,0) HRI_P_MEASURE8
194: ,NVL(babs.comp_abs_drtn,0) HRI_P_MEASURE9'|| g_rtn
195: /* Change - Total Absence Duration */ || g_rtn ||'
196: ,'|| hri_oltp_pmv_util_pkg.get_change_percent_sql
197: (p_previous_col => 'babs.comp_abs_drtn',
198: p_current_col => 'babs.curr_abs_drtn') || '
199: HRI_P_MEASURE8_MP'|| g_rtn
200: /* Average Absence Duration */ || g_rtn ||'

Line 221: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

217: HRI_P_GRAND_TOTAL6
218: ,NVL(babs.comp_tot_avg_abs_ntfctn_period,0)
219: HRI_P_GRAND_TOTAL7'|| g_rtn
220: /* Change Total - Average Notification */ || g_rtn ||'
221: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
222: (p_previous_col => 'babs.comp_tot_avg_abs_ntfctn_period',
223: p_current_col => 'babs.curr_tot_avg_abs_ntfctn_period') || '
224: HRI_P_GRAND_TOTAL6_MP'|| g_rtn
225: /* Total Absence Duration */ || g_rtn ||'

Line 229: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

225: /* Total Absence Duration */ || g_rtn ||'
226: ,NVL(babs.curr_tot_abs_drtn,0) HRI_P_GRAND_TOTAL8
227: ,NVL(babs.comp_tot_abs_drtn,0) HRI_P_GRAND_TOTAL9'|| g_rtn
228: /* Change Total - Total Absence Duration */ || g_rtn ||'
229: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
230: (p_previous_col => 'babs.comp_tot_abs_drtn',
231: p_current_col => 'babs.curr_tot_abs_drtn') || '
232: HRI_P_GRAND_TOTAL8_MP'|| g_rtn
233: /* Total Average Absence Duration */ || g_rtn ||'

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

392: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
393: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
394:
395: /* Get security clause for Manager based security */
396: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
397:
398: /* Get common parameter values */
399: hri_oltp_pmv_util_param.get_parameters_from_table
400: (p_page_parameter_tbl => p_page_parameter_tbl,