DBA Data[Home] [Help]

APPS.HXC_FF_DICT dependencies on HXC_TIME_ENTRY_RULES_UTILS_PKG

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 350: hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id := l_tc_id;

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

Line 828: , p_rule_rec hxc_time_entry_rules_utils_pkg.csr_get_rules%rowtype

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

Line 842: l_period_tab hxc_time_entry_rules_utils_pkg.t_period;

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

Line 863: FUNCTION fix_periods ( p_period_tab hxc_time_entry_rules_utils_pkg.t_period )

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

Line 864: RETURN hxc_time_entry_rules_utils_pkg.t_period IS

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

Line 866: l_period_tab hxc_time_entry_rules_utils_pkg.t_period;

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

Line 977: hxc_time_entry_rules_utils_pkg.calc_timecard_periods (

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

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

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

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

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

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

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

Line 996: CLOSE hxc_time_entry_rules_utils_pkg.csr_get_period_info;

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

Line 1057: hxc_time_entry_rules_utils_pkg.calc_timecard_periods (

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