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 2221: l_rules_evl := hxc_preference_evaluation.resource_preferences(

2217: if g_debug then
2218: hr_utility.set_location('Processing '||l_proc, 20);
2219: end if;
2220:
2221: l_rules_evl := hxc_preference_evaluation.resource_preferences(
2222: p_resource_id => l_timecard_info_rec.resource_id
2223: ,p_pref_code => 'TC_W_RULES_EVALUATION'
2224: ,p_attribute_n => 1
2225: ,p_evaluation_date => l_submission_date );

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

2231: , p_messages => p_messages );
2232:
2233: END IF;
2234:
2235: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
2236: p_preference_code => 'TS_PER_TIME_ENTRY_RULES',
2237: p_start_evaluation_date => l_timecard_info_rec.start_date,
2238: p_end_evaluation_date => l_timecard_info_rec.end_date,
2239: p_sorted_pref_table => l_pref_table,

Line 3219: l_prefs hxc_preference_evaluation.t_pref_table;

3215: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3216: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3217: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3218:
3219: l_prefs hxc_preference_evaluation.t_pref_table;
3220:
3221: Begin
3222: g_debug := hr_utility.debug_enabled;
3223:

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

3229: hr_utility.trace('start_date ' || l_timecard_info_rec.start_date);
3230: end if;
3231: -- Start 2944785
3232: /*
3233: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
3234: p_preference_code => 'TS_PER_ELP_RULES',
3235: p_start_evaluation_date => l_timecard_info_rec.start_date,
3236: p_end_evaluation_date => l_timecard_info_rec.end_date,
3237: p_sorted_pref_table => l_prefs );

Line 3326: l_prefs hxc_preference_evaluation.t_pref_table;

3322: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3323: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3324: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3325:
3326: l_prefs hxc_preference_evaluation.t_pref_table;
3327:
3328: FUNCTION chk_bb_late (
3329: p_stop_time DATE,
3330: p_st_late_hrs NUMBER,

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

5358: n := p_messages.next(n);
5359: end loop;
5360: /* Start 2944785
5361: -- GPM v115.55 / v115.56
5362: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
5363: p_preference_code => 'TS_PER_AUDIT_REQUIREMENTS',
5364: p_start_evaluation_date => l_timecard_info_rec.start_date,
5365: p_end_evaluation_date => l_timecard_info_rec.end_date,
5366: p_sorted_pref_table => l_prefs );