APPS.HRI_OLTP_PMV_ABS_WMV_PVT dependencies on HRI_BPL_UTILIZATION

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

121:
122: /* formulate the dynmaic column selection based on Absence Duration
123: unit of measure paramter selection Default Days */
124:
125: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
126: l_dynmc_drtn_curr := 'curr_abs_drtn_days';
127: l_dynmc_drtn_comp := 'comp_abs_drtn_days';
128: l_abs_fact_params.include_abs_drtn_days := 'Y';
129: l_curr_tot_abs_drtn:= l_curr_tot_abs_drtn_days;

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

127: l_dynmc_drtn_comp := 'comp_abs_drtn_days';
128: l_abs_fact_params.include_abs_drtn_days := 'Y';
129: l_curr_tot_abs_drtn:= l_curr_tot_abs_drtn_days;
130: l_comp_tot_abs_drtn:= l_comp_tot_abs_drtn_days;
131: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
132: l_dynmc_drtn_curr := 'curr_abs_drtn_hrs';
133: l_dynmc_drtn_comp := 'comp_abs_drtn_hrs';
134: l_abs_fact_params.include_abs_drtn_hrs := 'Y';
135: l_curr_tot_abs_drtn:= l_curr_tot_abs_drtn_hrs;

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

406:
407: /* formulate the dynmaic column selection based on Absence Duration
408: unit of measure paramter selection Default Days */
409:
410: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
411: l_dynmc_drtn_curr := 'curr_abs_drtn_days';
412: l_dynmc_drtn_comp := 'comp_abs_drtn_days';
413: l_abs_fact_params.include_abs_drtn_days := 'Y';
414: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN

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

410: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
411: l_dynmc_drtn_curr := 'curr_abs_drtn_days';
412: l_dynmc_drtn_comp := 'comp_abs_drtn_days';
413: l_abs_fact_params.include_abs_drtn_days := 'Y';
414: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
415: l_dynmc_drtn_curr := 'curr_abs_drtn_hrs';
416: l_dynmc_drtn_comp := 'comp_abs_drtn_hrs';
417: l_abs_fact_params.include_abs_drtn_hrs := 'Y';
418: ELSE -- functional decision (JC) default to days