DBA Data[Home] [Help]

APPS.HXC_FF_DICT dependencies on HXC_TIME_ENTRY_RULES

Line 60: IF ( hxc_time_entry_rules_utils_pkg.g_assignment_info.EXISTS ( p_resource_id ) )

56:
57: -- check the cache for the assignment id
58: -- (should always be there now)
59:
60: IF ( hxc_time_entry_rules_utils_pkg.g_assignment_info.EXISTS ( p_resource_id ) )
61: THEN
62:
63: -- set assignment id from cache
64:

Line 65: l_assignment_id := hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).assignment_id;

61: THEN
62:
63: -- set assignment id from cache
64:
65: l_assignment_id := hxc_time_entry_rules_utils_pkg.g_assignment_info(p_resource_id).assignment_id;
66:
67: ELSE
68:
69: OPEN csr_get_asg_id;

Line 272: , p_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype

268:
269:
270: PROCEDURE decode_formula_segments (
271: p_formula_name VARCHAR2
272: , p_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype
273: , p_param_rec IN OUT NOCOPY r_param
274: , p_period_value IN OUT NOCOPY NUMBER
275: , p_reference_value IN OUT NOCOPY NUMBER
276: , p_consider_zero_hours IN OUT NOCOPY VARCHAR2 )

Line 349: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := l_tc_id;

345:
346: ELSIF ( l_tc_name like 'OTL_INC_%' )
347: THEN
348:
349: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := l_tc_id;
350:
351: END IF;
352:
353: FETCH csr_get_time_category_id INTO l_tc_id, l_tc_name;

Line 827: , p_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype

823: , p_period_start_date DATE
824: , p_period_end_date DATE
825: , p_tc_period_start_date DATE
826: , p_tc_period_end_date DATE
827: , p_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype
828: , p_message_table IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE )
829: RETURN varchar2 IS
830:
831: l_proc VARCHAR2(72);

Line 841: l_period_tab hxc_time_entry_rules_utils_pkg.t_period;

837: l_timecard_hrs NUMBER := 0;
838: l_reference_period NUMBER(10);
839: l_consider_zero_hours VARCHAR2(10);
840: l_period_id NUMBER(15);
841: l_period_tab hxc_time_entry_rules_utils_pkg.t_period;
842:
843: l_period_start DATE;
844: l_period_start_date DATE;
845: l_period_end_date DATE;

Line 862: FUNCTION fix_periods ( p_period_tab hxc_time_entry_rules_utils_pkg.t_period )

858: AND asg.assignment_type in ('E','C');
859:
860:
861:
862: FUNCTION fix_periods ( p_period_tab hxc_time_entry_rules_utils_pkg.t_period )
863: RETURN hxc_time_entry_rules_utils_pkg.t_period IS
864:
865: l_period_tab hxc_time_entry_rules_utils_pkg.t_period;
866:

Line 863: RETURN hxc_time_entry_rules_utils_pkg.t_period IS

859:
860:
861:
862: FUNCTION fix_periods ( p_period_tab hxc_time_entry_rules_utils_pkg.t_period )
863: RETURN hxc_time_entry_rules_utils_pkg.t_period IS
864:
865: l_period_tab hxc_time_entry_rules_utils_pkg.t_period;
866:
867: BEGIN

Line 865: l_period_tab hxc_time_entry_rules_utils_pkg.t_period;

861:
862: FUNCTION fix_periods ( p_period_tab hxc_time_entry_rules_utils_pkg.t_period )
863: RETURN hxc_time_entry_rules_utils_pkg.t_period IS
864:
865: l_period_tab hxc_time_entry_rules_utils_pkg.t_period;
866:
867: BEGIN
868:
869: l_period_tab := p_period_tab;

Line 976: hxc_time_entry_rules_utils_pkg.calc_timecard_periods (

972: hr_utility.trace('Application approval period start is '||TO_CHAR(p_period_start_date, 'DD-MON-YY HH24:MI:SS'));
973: hr_utility.trace('Application approval period end is ' ||TO_CHAR(l_period_end_date, 'DD-MON-YY HH24:MI:SS'));
974: end if;
975:
976: hxc_time_entry_rules_utils_pkg.calc_timecard_periods (
977: p_timecard_period_start => p_tc_period_start_date
978: , p_timecard_period_end => p_tc_period_end_date
979: , p_period_start_date => p_period_start_date
980: , p_period_end_date => l_period_end_date

Line 990: /* NOTE: This code pulled from hxc_time_Entry_rules_utils_pkg */

986: if g_debug then
987: hr_utility.set_location('Processing '||l_proc, 50);
988: end if;
989:
990: /* NOTE: This code pulled from hxc_time_Entry_rules_utils_pkg */
991:
992:
993: OPEN hxc_time_entry_rules_utils_pkg.csr_get_period_info ( p_recurring_period_id => l_period_id );
994: FETCH hxc_time_entry_rules_utils_pkg.csr_get_period_info INTO l_period_type, l_duration_in_days, l_period_start;

Line 993: OPEN hxc_time_entry_rules_utils_pkg.csr_get_period_info ( p_recurring_period_id => l_period_id );

989:
990: /* NOTE: This code pulled from hxc_time_Entry_rules_utils_pkg */
991:
992:
993: OPEN hxc_time_entry_rules_utils_pkg.csr_get_period_info ( p_recurring_period_id => l_period_id );
994: FETCH hxc_time_entry_rules_utils_pkg.csr_get_period_info INTO l_period_type, l_duration_in_days, l_period_start;
995: CLOSE hxc_time_entry_rules_utils_pkg.csr_get_period_info;
996:
997: if g_debug then

Line 994: FETCH hxc_time_entry_rules_utils_pkg.csr_get_period_info INTO l_period_type, l_duration_in_days, l_period_start;

990: /* NOTE: This code pulled from hxc_time_Entry_rules_utils_pkg */
991:
992:
993: OPEN hxc_time_entry_rules_utils_pkg.csr_get_period_info ( p_recurring_period_id => l_period_id );
994: FETCH hxc_time_entry_rules_utils_pkg.csr_get_period_info INTO l_period_type, l_duration_in_days, l_period_start;
995: CLOSE hxc_time_entry_rules_utils_pkg.csr_get_period_info;
996:
997: if g_debug then
998: hr_utility.trace('');

Line 995: CLOSE hxc_time_entry_rules_utils_pkg.csr_get_period_info;

991:
992:
993: OPEN hxc_time_entry_rules_utils_pkg.csr_get_period_info ( p_recurring_period_id => l_period_id );
994: FETCH hxc_time_entry_rules_utils_pkg.csr_get_period_info INTO l_period_type, l_duration_in_days, l_period_start;
995: CLOSE hxc_time_entry_rules_utils_pkg.csr_get_period_info;
996:
997: if g_debug then
998: hr_utility.trace('');
999: hr_utility.trace('*********** Period Info ************');

Line 1056: hxc_time_entry_rules_utils_pkg.calc_timecard_periods (

1052:
1053: -- now build up table of time entry rule periods that the timecard
1054: -- may span
1055:
1056: hxc_time_entry_rules_utils_pkg.calc_timecard_periods (
1057: p_timecard_period_start => p_tc_period_start_date
1058: , p_timecard_period_end => p_tc_period_end_date
1059: , p_period_start_date => l_period_start_date
1060: , p_period_end_date => l_period_end_date

Line 1217: , p_param fnd_descr_flex_column_usages.end_user_column_name%TYPE ) RETURN hxc_time_entry_rules.attribute1%TYPE IS

1213: END execute_approval_formula;
1214:
1215: FUNCTION get_formula_segment_value (
1216: p_param_rec r_param
1217: , p_param fnd_descr_flex_column_usages.end_user_column_name%TYPE ) RETURN hxc_time_entry_rules.attribute1%TYPE IS
1218:
1219: l_proc varchar2(72) := g_package||'.get_formula_segment_value';
1220: l_param_value hxc_time_entry_rules.attribute1%TYPE;
1221:

Line 1220: l_param_value hxc_time_entry_rules.attribute1%TYPE;

1216: p_param_rec r_param
1217: , p_param fnd_descr_flex_column_usages.end_user_column_name%TYPE ) RETURN hxc_time_entry_rules.attribute1%TYPE IS
1218:
1219: l_proc varchar2(72) := g_package||'.get_formula_segment_value';
1220: l_param_value hxc_time_entry_rules.attribute1%TYPE;
1221:
1222: BEGIN
1223:
1224: IF ( p_param = p_param_rec.param1 )