DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WRKFC_TRN_SUMMARY dependencies on HRI_BPL_DBI_CALC_PERIOD

Line 206: hri_bpl_dbi_calc_period.calc_sup_turnover

202: /* pivot report - bug 4211177 */
203: IF (l_parameter_rec.bis_region_code = 'HRI_P_WRKFC_TRN_SUMMARY') THEN
204:
205: /* Get current period turnover totals for supervisor from cursor */
206: hri_bpl_dbi_calc_period.calc_sup_turnover
207: (p_supervisor_id => l_parameter_rec.peo_supervisor_id,
208: p_from_date => l_parameter_rec.time_curr_start_date,
209: p_to_date => l_parameter_rec.time_curr_end_date,
210: p_period_type => l_parameter_rec.page_period_type,

Line 218: hri_bpl_dbi_calc_period.calc_sup_turnover

214: p_total_trn_vol => l_curr_term_vol,
215: p_total_trn_invol => l_curr_term_invol);
216:
217: /* Get previous period turnover totals for supervisor from cursor */
218: hri_bpl_dbi_calc_period.calc_sup_turnover
219: (p_supervisor_id => l_parameter_rec.peo_supervisor_id,
220: p_from_date => l_parameter_rec.time_comp_start_date,
221: p_to_date => l_parameter_rec.time_comp_end_date,
222: p_period_type => l_parameter_rec.page_period_type,

Line 232: hri_bpl_dbi_calc_period.calc_sup_term_pvt

228:
229: ELSE
230:
231: /* Get current period turnover totals for supervisor from cursor */
232: hri_bpl_dbi_calc_period.calc_sup_term_pvt
233: (p_supervisor_id => l_parameter_rec.peo_supervisor_id,
234: p_from_date => l_parameter_rec.time_curr_start_date,
235: p_to_date => l_parameter_rec.time_curr_end_date,
236: p_bind_tab => l_bind_tab,

Line 242: hri_bpl_dbi_calc_period.calc_sup_term_pvt

238: p_total_term_invol => l_curr_term_invol,
239: p_total_term => l_curr_term);
240:
241: /* Get previous period turnover totals for supervisor from cursor */
242: hri_bpl_dbi_calc_period.calc_sup_term_pvt
243: (p_supervisor_id => l_parameter_rec.peo_supervisor_id,
244: p_from_date => l_parameter_rec.time_comp_start_date,
245: p_to_date => l_parameter_rec.time_comp_end_date,
246: p_bind_tab => l_bind_tab,