APPS.HRI_OLTP_PMV_WMV_SUP dependencies on HRI_OLTP_PMV_UTIL_PKG

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

115: 'pParamIds=Y';
116:
117:
118: /* Get security clause for Manager based security */
119: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
120:
121: /* Set direct reports string */
122: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
123:

Line 144: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

140: l_tot_loss := l_tot_loss_term + l_tot_loss_transfer;
141: l_tot_net := l_tot_gain - l_tot_loss;
142:
143: /* Set the dynamic order by from the dimension metadata */
144: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
145: (p_order_by_clause => l_parameter_rec.order_by);
146:
147: /* Get SQL for workforce fact */
148: l_wrkfc_fact_params.bind_format := 'PMV';

Line 197: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

193: /* Current WMV value */
194: ',tots.current_wmv_end HRI_P_MEASURE2 ' || g_rtn ||
195: /* Net change in WMV value */
196: ',tots.wmv_net HRI_P_WMV_CHNG_NET_SUM_MV
197: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
198: (p_previous_col => 'tots.previous_wmv_end',
199: p_current_col => 'tots.current_wmv_end') || '
200: HRI_P_WMV_CHNG_PCT_SUM_MV
201: ,tots.comp_total_hdc_end HRI_P_WMV_SUM_PREV_MV

Line 212: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql

208: ,:HRI_TOT_LOSS_TERM HRI_P_GRAND_TOTAL7
209: ,:HRI_TOT_LOSS_TRANSFER HRI_P_GRAND_TOTAL8
210: ,tots.curr_total_hdc_start HRI_P_GRAND_TOTAL2
211: ,:HRI_TOT_NET_GAIN_LOSS HRI_P_GRAND_TOTAL3
212: ,' || hri_oltp_pmv_util_pkg.get_change_percent_sql
213: (p_previous_col => 'tots.comp_total_hdc_end',
214: p_current_col => 'tots.curr_total_hdc_end') || '
215: HRI_P_GRAND_TOTAL4
216: ,tots.comp_total_hdc_end HRI_P_GRAND_TOTAL9 ' || g_rtn ||

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

338: BEGIN
339: --
340: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
341: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
342: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
343: --
344: -- Get the parameter information from the page parameter table
345: --
346: hri_oltp_pmv_util_param.get_parameters_from_table

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

424: p_parameter_rec => l_parameter_rec,
425: p_bind_tab => l_bind_tab);
426:
427: /* Get security clause for Manager based security */
428: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
429:
430: /* Set the dynamic order by from the dimension metadata */
431: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
432: (p_order_by_clause => l_parameter_rec.order_by);

Line 431: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

427: /* Get security clause for Manager based security */
428: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
429:
430: /* Set the dynamic order by from the dimension metadata */
431: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
432: (p_order_by_clause => l_parameter_rec.order_by);
433:
434: /* Get SQL for workforce fact */
435: l_wrkfc_fact_params.bind_format := 'PMV';

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

510: p_parameter_rec => l_parameter_rec,
511: p_bind_tab => l_bind_tab);
512:
513: /* Get security clause for Manager based security */
514: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
515:
516: /* Set the dynamic order by from the dimension metadata */
517: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
518: (p_order_by_clause => l_parameter_rec.order_by);

Line 517: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

513: /* Get security clause for Manager based security */
514: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
515:
516: /* Set the dynamic order by from the dimension metadata */
517: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
518: (p_order_by_clause => l_parameter_rec.order_by);
519:
520: /* Get SQL for workforce fact */
521: l_wrkfc_fact_params.bind_format := 'PMV';