APPS.HRI_OLTP_PMV_ABS_CAT dependencies on HRI_BPL_UTILIZATION

Line 75: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN

71: /* Set the trend sql context for the code centralization call */
72: l_trend_sql_params.bind_format := 'PMV';
73:
74: /* Set metric base on absence UOM parameter, default to DAYS */
75: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
76: l_trend_sql_params.include_abs_drtn_days := 'Y';
77:
78: l_period_abs_drtn_metric1 := 'qry.period_abs_drtn_days_absCat1';
79: l_period_abs_drtn_metric2 := 'qry.period_abs_drtn_days_absCat2';

Line 83: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN

79: l_period_abs_drtn_metric2 := 'qry.period_abs_drtn_days_absCat2';
80: l_period_abs_drtn_metric3 := 'qry.period_abs_drtn_days_absCat3';
81: l_period_abs_drtn_metric4 := 'qry.period_abs_drtn_days_absCat4';
82:
83: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
84: l_trend_sql_params.include_abs_drtn_hrs := 'Y';
85: l_period_abs_drtn_metric1 := 'qry.period_abs_drtn_hrs_absCat1';
86: l_period_abs_drtn_metric2 := 'qry.period_abs_drtn_hrs_absCat2';
87: l_period_abs_drtn_metric3 := 'qry.period_abs_drtn_hrs_absCat3';

Line 267: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN

263:
264: /* formulate the dynmaic column selection based on Absence Duration
265: unit of measure paramter selection Default Days */
266:
267: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
268: l_dynmc_drtn_curr := 'curr_abs_drtn_days';
269: l_abs_fact_params.include_abs_drtn_days := 'Y';
270: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
271: l_dynmc_drtn_curr := 'curr_abs_drtn_hrs';

Line 270: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN

266:
267: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
268: l_dynmc_drtn_curr := 'curr_abs_drtn_days';
269: l_abs_fact_params.include_abs_drtn_days := 'Y';
270: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
271: l_dynmc_drtn_curr := 'curr_abs_drtn_hrs';
272: l_abs_fact_params.include_abs_drtn_hrs := 'Y';
273: ELSE -- functional decision (JC) default to days
274: l_dynmc_drtn_curr := 'curr_abs_drtn_days';