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.

APPS.HRI_OLTP_PMV_WMV_SAL_SUP_PVT dependencies on HRI_OLTP_PMV_UTIL_PKG

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

37: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
38: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
39:
40: /* Get security clause for Manager based security */
41: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
42:
43: /* Get common parameter values */
44: hri_oltp_pmv_util_param.get_parameters_from_table
45: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 58: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

54: -- 'VIEW_BY=HRI_PERSON+HRI_PER_USRDR_H&' ||
55: -- 'pParamIds=Y';
56:
57: /* Set order by */
58: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
59: (p_order_by_clause => l_parameter_rec.order_by);
60:
61: /* Force view by to country */
62: l_parameter_rec.view_by := 'GEOGRAPHY+COUNTRY';

Line 82: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

78: tab.order_by HRI_P_ORDER_BY_1
79: ,ctr.value HRI_P_MEASURE1
80: ,tab.wmv_curr HRI_P_WMV_SUM_MV
81: ,tab.wmv_prev HRI_P_WMV_SUM_PREV_MV
82: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
83: (p_previous_col => 'tab.wmv_prev',
84: p_current_col => 'tab.wmv_curr') || '
85: HRI_P_WMV_CHNG_PCT_SUM_MV
86: ,tab.sal_curr HRI_P_MEASURE2

Line 90: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

86: ,tab.sal_curr HRI_P_MEASURE2
87: ,tab.sal_prev HRI_P_MEASURE3
88: ,tab.avg_sal HRI_P_MEASURE4
89: ,NVL(tab.avg_sal_prev,0) HRI_P_MEASURE5
90: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
91: (p_previous_col => 'tab.avg_sal_prev',
92: p_current_col => 'tab.avg_sal') || '
93: HRI_P_MEASURE6
94: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

Line 94: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

90: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
91: (p_previous_col => 'tab.avg_sal_prev',
92: p_current_col => 'tab.avg_sal') || '
93: HRI_P_MEASURE6
94: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
95: (p_previous_col =>
96: 'DECODE(tab.tot_wmv_prev, 0, to_number(null), tab.tot_sal_prev / tab.tot_wmv_prev)',
97: p_current_col =>
98: 'DECODE(tab.tot_wmv_curr, 0, to_number(null), tab.tot_sal_curr / tab.tot_wmv_curr)') || '

Line 104: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

100: ,DECODE(tab.tot_wmv_curr,
101: 0, to_number(null),
102: tab.tot_sal_curr/tab.tot_wmv_curr)
103: HRI_P_GRAND_TOTAL2
104: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
105: (p_previous_col => 'tab.tot_wmv_prev',
106: p_current_col => 'tab.tot_wmv_curr') || '
107: HRI_P_GRAND_TOTAL3
108: ,tab.country_code HRI_P_GEO_CTY_CN

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

194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
195: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
196:
197: /* Get security clause for Manager based security */
198: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
199:
200: /* Get common parameter values */
201: hri_oltp_pmv_util_param.get_parameters_from_table
202: (p_page_parameter_tbl => p_page_parameter_tbl,

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

354: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
355: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
356:
357: /* Get security clause for Manager based security */
358: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
359:
360: /* Get common parameter values */
361: hri_oltp_pmv_util_param.get_parameters_from_table
362: (p_page_parameter_tbl => p_page_parameter_tbl,

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

529: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
530: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
531:
532: /* Get security clause for Manager based security */
533: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
534:
535: /* Get common parameter values */
536: hri_oltp_pmv_util_param.get_parameters_from_table
537: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 562: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

558: tab.order_by HRI_P_ORDER_BY_1
559: ,jfn.value HRI_P_JOB_FAMILY_CN
560: ,tab.wmv_curr HRI_P_WMV_SUM_MV
561: ,tab.sal_curr HRI_P_SAL_ANL_CUR_PARAM_SUM_MV
562: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
563: (p_previous_col => 'tab.sal_prev',
564: p_current_col => 'tab.sal_curr') || '
565: HRI_P_MEASURE5
566: ,tab.avg_sal_curr HRI_P_MEASURE1

Line 567: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

563: (p_previous_col => 'tab.sal_prev',
564: p_current_col => 'tab.sal_curr') || '
565: HRI_P_MEASURE5
566: ,tab.avg_sal_curr HRI_P_MEASURE1
567: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
568: (p_previous_col => 'tab.avg_sal_prev',
569: p_current_col => 'tab.avg_sal_curr') || '
570: HRI_P_MEASURE2
571: ,tab.avg_sal_prev HRI_P_MEASURE3

Line 575: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

571: ,tab.avg_sal_prev HRI_P_MEASURE3
572: ,tab.tot_sal_prev HRI_P_MEASURE4
573: ,tab.tot_wmv_curr HRI_P_GRAND_TOTAL1
574: ,tab.tot_sal_curr HRI_P_GRAND_TOTAL2
575: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
576: (p_previous_col => 'tab.tot_sal_prev',
577: p_current_col => 'tab.tot_sal_curr') || '
578: HRI_P_GRAND_TOTAL7
579: ,DECODE(tab.tot_wmv_curr, 0, to_number(null),

Line 582: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

578: HRI_P_GRAND_TOTAL7
579: ,DECODE(tab.tot_wmv_curr, 0, to_number(null),
580: tab.tot_sal_curr / tab.tot_wmv_curr)
581: HRI_P_GRAND_TOTAL3
582: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
583: (p_previous_col =>
584: 'DECODE(tab.tot_wmv_prev, 0, 0, tab.tot_sal_prev/tab.tot_wmv_prev)',
585: p_current_col =>
586: 'DECODE(SUM(tab.wmv_curr) over(), 0, to_number(null),

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

677: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
678: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
679:
680: /* Get security clause for Manager based security */
681: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
682:
683: /* Get common parameter values */
684: hri_oltp_pmv_util_param.get_parameters_from_table
685: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 724: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

720: tab.order_by HRI_P_ORDER_BY_1
721: ,jfm.value HRI_P_JOB_LVL2_CN
722: ,tab.wmv_curr HRI_P_WMV_SUM_MV
723: ,tab.sal_curr HRI_P_SAL_ANL_CUR_PARAM_SUM_MV
724: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
725: (p_previous_col => 'tab.sal_prev',
726: p_current_col => 'tab.sal_curr') || '
727: HRI_P_MEASURE5
728: ,tab.avg_sal_curr HRI_P_MEASURE1

Line 729: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

725: (p_previous_col => 'tab.sal_prev',
726: p_current_col => 'tab.sal_curr') || '
727: HRI_P_MEASURE5
728: ,tab.avg_sal_curr HRI_P_MEASURE1
729: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
730: (p_previous_col => 'tab.avg_sal_prev',
731: p_current_col => 'tab.avg_sal_curr') || '
732: HRI_P_MEASURE2
733: ,tab.avg_sal_prev HRI_P_MEASURE3

Line 737: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

733: ,tab.avg_sal_prev HRI_P_MEASURE3
734: ,tab.tot_sal_prev HRI_P_MEASURE4
735: ,tab.tot_wmv_curr HRI_P_GRAND_TOTAL1
736: ,tab.tot_sal_curr HRI_P_GRAND_TOTAL2
737: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
738: (p_previous_col => 'tab.tot_sal_prev',
739: p_current_col => 'tab.tot_sal_curr') || '
740: HRI_P_GRAND_TOTAL7
741: ,DECODE(tab.tot_wmv_curr, 0, to_number(null),

Line 744: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

740: HRI_P_GRAND_TOTAL7
741: ,DECODE(tab.tot_wmv_curr, 0, to_number(null),
742: tab.tot_sal_curr / tab.tot_wmv_curr)
743: HRI_P_GRAND_TOTAL3
744: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
745: (p_previous_col =>
746: 'DECODE(tab.tot_wmv_prev, 0, to_number(null), tab.tot_sal_prev/tab.tot_wmv_prev)',
747: p_current_col =>
748: 'DECODE(SUM(tab.wmv_curr) over(), 0, to_number(null),