DBA Data[Home] [Help]

APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_PREFERENCE_EVALUATION

Line 1127: l_pref_table hxc_preference_evaluation.t_pref_table;

1123: FUNCTION evaluate_abs_pref(p_resource_id IN NUMBER,
1124: p_eval_date IN DATE)
1125: return varchar2 is
1126:
1127: l_pref_table hxc_preference_evaluation.t_pref_table;
1128: l_abs_integ_enabled varchar2(5);
1129: l_exclude_hours varchar2(1) := 'N';
1130:
1131: BEGIN

Line 1135: hxc_preference_evaluation.resource_preferences

1131: BEGIN
1132:
1133: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
1134: -- Absence Integration Profile is ON
1135: hxc_preference_evaluation.resource_preferences
1136: (p_resource_id => p_resource_id,
1137: p_pref_code_list => 'TS_ABS_PREFERENCES',
1138: p_pref_table => l_pref_table,
1139: p_evaluation_date => trunc(p_eval_date)