APPS.HXC_TCD_XML_PKG dependencies on HXC_PREFERENCE_EVALUATION

Line 137: l_rec_period := hxc_preference_evaluation.resource_preferences

133: EXECUTE IMMEDIATE l_EvalDateSql INTO l_pref_eval_date USING
134: l_period_start_date, p_person_ids(l_index).person_id, l_period_start_date,l_period_start_date,
135: p_person_ids(l_index).person_id, l_period_start_date,l_period_end_date;
136:
137: l_rec_period := hxc_preference_evaluation.resource_preferences
138: (p_person_ids(l_index).person_id,
139: 'TC_W_TCRD_PERIOD',
140: 1,
141: l_pref_eval_date, -99);

Line 322: l_pref_table hxc_preference_evaluation.t_pref_table;

318: FUNCTION get_timecard_end_date(p_person_id IN NUMBER, p_timecard_id IN NUMBER, p_period_end_date IN DATE default null)
319: RETURN DATE
320: IS
321: l_pref_end_date DATE;
322: l_pref_table hxc_preference_evaluation.t_pref_table;
323: l_start_date DATE;
324: l_end_date DATE;
325: l_index NUMBER;
326: l_tc_end_date DATE;

Line 342: hxc_preference_evaluation.resource_preferences(

338: IF p_period_end_date IS NOT NULL THEN
339: l_period_end_date := p_period_end_date;
340: END IF;
341:
342: hxc_preference_evaluation.resource_preferences(
343: p_resource_id => p_person_id
344: ,p_preference_code => 'TC_W_TCRD_PERIOD'
345: ,p_start_evaluation_date => g_tc_start_date
346: ,p_end_evaluation_date => l_period_end_date

Line 592: hxc_preference_evaluation.resource_preferences(temp.person_id,''TS_PER_APPLICATION_SET'',1,temp.start_date,-99)

588: END IF;
589:
590: l_sql := l_sql || ') temp, per_person_types ppt, per_person_type_usages_f ptu,hxc_application_sets_v hasv
591: WHERE hasv.application_set_id =
592: hxc_preference_evaluation.resource_preferences(temp.person_id,''TS_PER_APPLICATION_SET'',1,temp.start_date,-99)
593: AND ppt.person_type_id = ptu.person_type_id
594: AND ptu.person_id = temp.person_id
595: AND trunc(ptu.effective_start_date) <= trunc(temp.start_date)
596: AND trunc(effective_end_date) >= trunc(temp.start_date)';