APPS.HRI_OLTP_PMV_WRKFC_TRN_SUMMARY dependencies on HRI_OLTP_PMV_UTIL_PKG

Line 37: p_dynsql_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

33:
34: BEGIN
35:
36: /* Set the order by */
37: p_dynsql_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
38: (p_order_by_clause => p_parameter_rec.order_by);
39:
40: /* Get the profile value for the turnover calculation */
41: IF fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG' THEN

Line 92: p_dynsql_rec.viewby_condition := hri_oltp_pmv_util_pkg.set_viewby_filter

88: /* regardless of whether there is any headcount or turnover */
89: p_dynsql_rec.wrkfc_outer_join := '(+)';
90:
91: /* Filter if a view by parameter is set */
92: p_dynsql_rec.viewby_condition := hri_oltp_pmv_util_pkg.set_viewby_filter
93: (p_parameter_rec => p_parameter_rec,
94: p_bind_tab => p_bind_tab,
95: p_view_by_alias => 'vby');
96:

Line 186: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor

182: p_parameter_rec => l_parameter_rec,
183: p_bind_tab => l_bind_tab);
184:
185: /* Get the annualization factor for the different periods */
186: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor
187: (p_period_type => l_parameter_rec.page_period_type);
188:
189: /* Set the dynamic sql portion */
190: set_dynamic_sql(p_parameter_rec => l_parameter_rec,

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

191: p_bind_tab => l_bind_tab,
192: p_dynsql_rec => l_dynsql_rec);
193:
194: /* Get security clause for Manager based security */
195: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
196:
197: /* Get direct reports string */
198: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
199:

Line 298: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

294: ,DECODE(a.curr_total_sal_end, 0, 0,
295: 100 * a.curr_sal_end / a.curr_total_sal_end) HRI_P_MEASURE5
296: ,a.comp_sal_end HRI_P_MEASURE6
297: ,a.curr_avg_sal HRI_P_MEASURE7
298: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
299: (p_previous_col => 'a.comp_avg_sal',
300: p_current_col => 'a.curr_avg_sal') || '
301: HRI_P_MEASURE7_MP
302: ,a.comp_avg_sal HRI_P_MEASURE8

Line 314: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

310: ,a.curr_trn_tot HRI_P_MEASURE14
311: ,DECODE(a.curr_total_trn_tot, 0, 0,
312: 100 * a.curr_trn_tot / a.curr_total_trn_tot) HRI_P_MEASURE15
313: ,a.curr_total_hdc_end HRI_P_GRAND_TOTAL1
314: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
315: (p_previous_col => 'a.comp_total_hdc_end',
316: p_current_col => 'a.curr_total_hdc_end') || '
317: HRI_P_GRAND_TOTAL1_MP
318: ,100 HRI_P_GRAND_TOTAL2

Line 321: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

317: HRI_P_GRAND_TOTAL1_MP
318: ,100 HRI_P_GRAND_TOTAL2
319: ,a.comp_total_hdc_end HRI_P_GRAND_TOTAL3
320: ,a.curr_total_sal_end HRI_P_GRAND_TOTAL4
321: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
322: (p_previous_col => 'a.comp_total_sal_end',
323: p_current_col => 'a.curr_total_sal_end') || '
324: HRI_P_GRAND_TOTAL4_MP
325: ,100 HRI_P_GRAND_TOTAL5

Line 328: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

324: HRI_P_GRAND_TOTAL4_MP
325: ,100 HRI_P_GRAND_TOTAL5
326: ,a.comp_total_sal_end HRI_P_GRAND_TOTAL6
327: ,a.curr_total_avg_sal HRI_P_GRAND_TOTAL7
328: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
329: (p_previous_col => 'a.comp_total_avg_sal',
330: p_current_col => 'a.curr_total_avg_sal') || '
331: HRI_P_GRAND_TOTAL7_MP
332: ,a.comp_total_avg_sal HRI_P_GRAND_TOTAL8

Line 351: ' ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

347: FROM
348: (SELECT
349: tots.* ' || g_rtn ||
350: /* Headcount */
351: ' ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
352: (p_previous_col => 'tots.comp_hdc_end',
353: p_current_col => 'tots.curr_hdc_end') || '
354: hdc_change_pct' || g_rtn ||
355: /* Salary */

Line 356: ' ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

352: (p_previous_col => 'tots.comp_hdc_end',
353: p_current_col => 'tots.curr_hdc_end') || '
354: hdc_change_pct' || g_rtn ||
355: /* Salary */
356: ' ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
357: (p_previous_col => 'tots.comp_sal_end',
358: p_current_col => 'tots.curr_sal_end') || '
359: sal_change_pct' || g_rtn ||
360: /* Average Salary */