APPS.HRI_OLTP_PMV_ABS_CAT dependencies on HRI_OLTP_PMV_RANK_ABS

Line 21: l_abs_category_tab hri_oltp_pmv_rank_abs.abs_category_tab;

17:
18: -- Parameter values
19: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
20: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
21: l_abs_category_tab hri_oltp_pmv_rank_abs.abs_category_tab;
22:
23: -- Trend Period Parameters
24: l_projection_periods NUMBER;
25: l_previous_periods NUMBER;

Line 64: hri_oltp_pmv_rank_abs.set_top_categories

60: ,o_previous_periods => l_previous_periods
61: ,o_projection_periods => l_projection_periods);
62:
63: /* Get the top 4 Absence Categories for selection Mgr on effective date */
64: hri_oltp_pmv_rank_abs.set_top_categories
65: (p_supervisor_id => l_parameter_rec.peo_supervisor_id,
66: p_effective_from_date => l_parameter_rec.time_curr_start_date,
67: p_effective_to_date => l_parameter_rec.time_curr_end_date,
68: p_no_categories => 4,

Line 115: 'HRI_ABSNC+HRI_ABSNC_CAT='|| hri_oltp_pmv_rank_abs.get_category_code(1)||'&'||

111: l_drill_url1 :=
112: 'pFunctionName=HRI_P_ABS_SUP_DTL&' ||
113: 'VIEW_BY=VIEW_BY_NAME&' ||
114: 'VIEW_BY_NAME=VIEW_BY_ID&' ||
115: 'HRI_ABSNC+HRI_ABSNC_CAT='|| hri_oltp_pmv_rank_abs.get_category_code(1)||'&'||
116: ''' || ''' || 'AS_OF_DATE=HRI_P_CHAR2_GA&' ||
117: 'pParamIds=Y';
118: l_drill_url2 :=
119: 'pFunctionName=HRI_P_ABS_SUP_DTL&' ||

Line 122: 'HRI_ABSNC+HRI_ABSNC_CAT='|| hri_oltp_pmv_rank_abs.get_category_code(2)||'&'||

118: l_drill_url2 :=
119: 'pFunctionName=HRI_P_ABS_SUP_DTL&' ||
120: 'VIEW_BY=VIEW_BY_NAME&' ||
121: 'VIEW_BY_NAME=VIEW_BY_ID&' ||
122: 'HRI_ABSNC+HRI_ABSNC_CAT='|| hri_oltp_pmv_rank_abs.get_category_code(2)||'&'||
123: ''' || ''' || 'AS_OF_DATE=HRI_P_CHAR2_GA&' ||
124: 'pParamIds=Y';
125: l_drill_url3 :=
126: 'pFunctionName=HRI_P_ABS_SUP_DTL&' ||

Line 129: 'HRI_ABSNC+HRI_ABSNC_CAT='|| hri_oltp_pmv_rank_abs.get_category_code(3)||'&'||

125: l_drill_url3 :=
126: 'pFunctionName=HRI_P_ABS_SUP_DTL&' ||
127: 'VIEW_BY=VIEW_BY_NAME&' ||
128: 'VIEW_BY_NAME=VIEW_BY_ID&' ||
129: 'HRI_ABSNC+HRI_ABSNC_CAT='|| hri_oltp_pmv_rank_abs.get_category_code(3)||'&'||
130: ''' || ''' || 'AS_OF_DATE=HRI_P_CHAR2_GA&' ||
131: 'pParamIds=Y';
132: l_drill_url4 :=
133: 'pFunctionName=HRI_P_ABS_SUP_DTL&' ||

Line 136: 'HRI_ABSNC+HRI_ABSNC_CAT='|| hri_oltp_pmv_rank_abs.get_category_code(4)||'&'||

132: l_drill_url4 :=
133: 'pFunctionName=HRI_P_ABS_SUP_DTL&' ||
134: 'VIEW_BY=VIEW_BY_NAME&' ||
135: 'VIEW_BY_NAME=VIEW_BY_ID&' ||
136: 'HRI_ABSNC+HRI_ABSNC_CAT='|| hri_oltp_pmv_rank_abs.get_category_code(4)||'&'||
137: ''' || ''' || 'AS_OF_DATE=HRI_P_CHAR2_GA&' ||
138: 'pParamIds=Y';
139: */
140: