APPS.HRI_OLTP_PMV_WMV_TRN_SUMMRY dependencies on HRI_OLTP_PMV_UTIL_PKG

Line 104: p_dynsql_rec.view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter

100: /* regardless of whether there is any headcount or turnover */
101: p_dynsql_rec.wrkfc_outer_join := ' (+)';
102:
103: /* Set the view by filter if these parameters have been set */
104: p_dynsql_rec.view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter
105: (p_parameter_rec => p_parameter_rec,
106: p_bind_tab => p_bind_tab,
107: p_view_by_alias => 'vby');
108:

Line 180: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor

176: p_parameter_rec => l_parameter_rec,
177: p_bind_tab => l_bind_tab);
178:
179: /* Get the annualization factor for the different periods */
180: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor
181: (p_period_type => l_parameter_rec.page_period_type);
182:
183: /* Set the dynamic sql portion */
184: set_dynamic_sql(p_parameter_rec => l_parameter_rec,

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

185: p_bind_tab => l_bind_tab,
186: p_dynsql_rec => l_dynsql_rec);
187:
188: /* Get security clause for Manager based security */
189: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
190:
191: /* Get direct reports string */
192: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
193:

Line 238: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

234: p_bind_tab => l_bind_tab,
235: p_wrkfc_params => l_wrkfc_params);
236:
237: /* Set the dynamic order by from the dimension metadata */
238: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
239: (p_order_by_clause => l_parameter_rec.order_by);
240:
241:
242: /* Format the AK_SQL for the report UI */