DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_PREFERENCE_EVALUATION

Line 857: l_pref_table hxc_preference_evaluation.t_pref_table;

853:
854: l_alter_session VARCHAR2(1000);
855: l_run_id number;
856:
857: l_pref_table hxc_preference_evaluation.t_pref_table;
858:
859: p_master_pref_table hxc_preference_evaluation.t_pref_table;
860:
861: cursor gaz_time_sql is

Line 859: p_master_pref_table hxc_preference_evaluation.t_pref_table;

855: l_run_id number;
856:
857: l_pref_table hxc_preference_evaluation.t_pref_table;
858:
859: p_master_pref_table hxc_preference_evaluation.t_pref_table;
860:
861: cursor gaz_time_sql is
862: select time_category_id
863: from hxc_time_Categories

Line 2166: l_rules_evl := hxc_preference_evaluation.resource_preferences(

2162: if g_debug then
2163: hr_utility.set_location('Processing '||l_proc, 20);
2164: end if;
2165:
2166: l_rules_evl := hxc_preference_evaluation.resource_preferences(
2167: p_resource_id => l_timecard_info_rec.resource_id
2168: ,p_pref_code => 'TC_W_RULES_EVALUATION'
2169: ,p_attribute_n => 1
2170: ,p_evaluation_date => l_submission_date );

Line 2180: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

2176: , p_messages => p_messages );
2177:
2178: END IF;
2179:
2180: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
2181: p_preference_code => 'TS_PER_TIME_ENTRY_RULES',
2182: p_start_evaluation_date => l_timecard_info_rec.start_date,
2183: p_end_evaluation_date => l_timecard_info_rec.end_date,
2184: p_sorted_pref_table => l_pref_table,

Line 3164: l_prefs hxc_preference_evaluation.t_pref_table;

3160: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3161: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3162: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3163:
3164: l_prefs hxc_preference_evaluation.t_pref_table;
3165:
3166: Begin
3167: g_debug := hr_utility.debug_enabled;
3168:

Line 3178: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

3174: hr_utility.trace('start_date ' || l_timecard_info_rec.start_date);
3175: end if;
3176: -- Start 2944785
3177: /*
3178: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
3179: p_preference_code => 'TS_PER_ELP_RULES',
3180: p_start_evaluation_date => l_timecard_info_rec.start_date,
3181: p_end_evaluation_date => l_timecard_info_rec.end_date,
3182: p_sorted_pref_table => l_prefs );

Line 3271: l_prefs hxc_preference_evaluation.t_pref_table;

3267: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3268: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3269: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3270:
3271: l_prefs hxc_preference_evaluation.t_pref_table;
3272:
3273: FUNCTION chk_bb_late (
3274: p_stop_time DATE,
3275: p_st_late_hrs NUMBER,

Line 5265: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

5261: n := p_messages.next(n);
5262: end loop;
5263: /* Start 2944785
5264: -- GPM v115.55 / v115.56
5265: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
5266: p_preference_code => 'TS_PER_AUDIT_REQUIREMENTS',
5267: p_start_evaluation_date => l_timecard_info_rec.start_date,
5268: p_end_evaluation_date => l_timecard_info_rec.end_date,
5269: p_sorted_pref_table => l_prefs );