eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_TRN_SUP dependencies on HRI_OLTP_PMV_UTIL_PKG

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

50: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
51: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
52:
53: /* Get security clause for Manager based security */
54: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
55:
56: /* Get direct reports string */
57: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
58:

Line 95: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor

91:
92: END IF;
93:
94: /* Get the annualization factor for the different periods */
95: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor
96: (p_period_type => l_parameter_rec.page_period_type);
97:
98: /* Get current period turnover totals for supervisor from cursor */
99: hri_bpl_dbi_calc_period.calc_sup_turnover

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

386: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
387: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
388:
389: /* Get security clause for Manager based security */
390: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
391:
392: /* Get direct reports string */
393: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
394:

Line 417: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor

413:
414: END IF;
415:
416: /* Get the annualization factor for the different periods */
417: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor
418: (p_period_type => l_parameter_rec.page_period_type);
419:
420: /* Get current period turnover totals for supervisor from cursor */
421: hri_bpl_dbi_calc_period.calc_sup_turnover

Line 454: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

450: p_wcnt_chg_params => l_wcnt_chg_fact_params,
451: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP.GET_ACTUAL_DETAIL_SQL2');
452:
453: /* Set the default order by */
454: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
455: (p_order_by_clause => l_parameter_rec.order_by);
456:
457: /* Build SQL Query */
458: l_SQLText :=

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

642: p_parameter_rec => l_parameter_rec,
643: p_bind_tab => l_bind_tab);
644:
645: /* Get security clause for Manager based security */
646: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
647:
648: /* Get direct reports string */
649: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
650:

Line 697: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

693: 'pParamIds=Y';
694: END IF;
695:
696: /* Set the dynamic order by from the dimension metadata */
697: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
698: (p_order_by_clause => l_parameter_rec.order_by);
699:
700: /* Get SQL for workforce changes fact */
701: l_wcnt_chg_fact_params.bind_format := 'PMV';

Line 729: l_view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter

725: IF (l_parameter_rec.view_by = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X' OR
726: l_parameter_rec.view_by = 'HRI_LOW+HRI_LOW_BAND_X') THEN
727: l_outer_join := ' (+)';
728: /* Set the view by filter */
729: l_view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter
730: (p_parameter_rec => l_parameter_rec,
731: p_bind_tab => l_bind_tab,
732: p_view_by_alias => 'cl');
733: ELSE

Line 750: l_view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter

746: l_termination_count_filter :=
747: 'AND a.vby_id IN (''SEP_VOL'',''SEP_INV'')' || g_rtn;
748:
749: /* Set the view by filter */
750: l_view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter
751: (p_parameter_rec => l_parameter_rec,
752: p_bind_tab => l_bind_tab,
753: p_view_by_alias => 'cl');
754:

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

911:
912: BEGIN
913: --
914: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
915: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
916: --
917: -- Get the parameter information from the page parameter table
918: --
919: hri_oltp_pmv_util_param.get_parameters_from_table

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

1020: BEGIN
1021: --
1022: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1023: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1024: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
1025: --
1026: -- Get the parameter information from the page parameter table
1027: --
1028: hri_oltp_pmv_util_param.get_parameters_from_table

Line 1035: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor

1031: p_bind_tab => l_bind_tab);
1032: --
1033: -- Get the annualization factor
1034: --
1035: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor
1036: (p_period_type => l_parameter_rec.page_period_type);
1037: --
1038: -- Set the parameters for getting the inner SQL for termination
1039: --