DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_PREFERENCE_EVALUATION

Line 1642: l_app_periods := hxc_preference_evaluation.resource_preferences(

1638: -- Attempt to find the approval period preference value
1639:
1640: BEGIN
1641:
1642: l_app_periods := hxc_preference_evaluation.resource_preferences(
1643: p_resource_id => p_resource_id,
1644: p_pref_code => 'TS_PER_APPROVAL_PERIODS',
1645: p_attribute_n => 1,
1646: p_evaluation_date => trunc(p_day_start_time));

Line 1664: l_app_periods := hxc_preference_evaluation.resource_preferences(

1660: EXIT WHEN l_pref_found;
1661: l_day_check := trunc(p_timecard_start_time) + l_day_count;
1662: BEGIN
1663:
1664: l_app_periods := hxc_preference_evaluation.resource_preferences(
1665: p_resource_id => p_resource_id,
1666: p_pref_code => 'TS_PER_APPROVAL_PERIODS',
1667: p_attribute_n => 1,
1668: p_evaluation_date => l_day_check);

Line 3145: l_pref_table hxc_preference_evaluation.t_pref_table;

3141: l_dummy NUMBER;
3142:
3143: -- Bug 10164135
3144: -- New variables.
3145: l_pref_table hxc_preference_evaluation.t_pref_table;
3146: l_elp_rule NUMBER := 0;
3147:
3148: l_processed_app_start hxc_time_building_blocks.start_time%TYPE;
3149: l_processed_app_stop hxc_time_building_blocks.stop_time%TYPE;

Line 3214: hxc_preference_evaluation.resource_preferences(p_resource_id => l_tc_resource_id,

3210:
3211:
3212: -- Bug 10164135
3213: -- Picking up the ELP time entry rule.
3214: hxc_preference_evaluation.resource_preferences(p_resource_id => l_tc_resource_id,
3215: p_start_evaluation_date => l_tc_start_time,
3216: p_end_evaluation_date => TRUNC(l_tc_stop_time),
3217: p_pref_table => l_pref_table);
3218:

Line 3241: l_app_set := hxc_preference_evaluation.resource_preferences

3237: fetch csr_get_app_set_from_tc into l_app_set;
3238: if((csr_get_app_set_from_tc%notfound)OR(l_app_set is null)) then
3239: close csr_get_app_set_from_tc;
3240: g_trace := '45';
3241: l_app_set := hxc_preference_evaluation.resource_preferences
3242: (p_resource_id => l_tc_resource_id,
3243: p_pref_code => 'TS_PER_APPLICATION_SET',
3244: p_attribute_n => 1);
3245: else