APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIMECARD_UTILITIES

Line 1729: ,p_assignment_periods IN hxc_timecard_utilities.periods

1725: ,p_day IN hxc_time_building_blocks.start_time%TYPE
1726: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
1727: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1728: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1729: ,p_assignment_periods IN hxc_timecard_utilities.periods
1730: ,p_period_start OUT NOCOPY hxc_time_building_blocks.start_time%TYPE
1731: ,p_period_end OUT NOCOPY hxc_time_building_blocks.stop_time%TYPE
1732: )
1733: IS

Line 1737: l_app_period hxc_timecard_utilities.time_period;

1733: IS
1734: l_period_start_date date;
1735: l_period_end_date date;
1736: l_override_allowed boolean;
1737: l_app_period hxc_timecard_utilities.time_period;
1738: l_valid_periods hxc_timecard_utilities.periods;
1739:
1740:
1741: l_call_proc varchar2(2000);

Line 1738: l_valid_periods hxc_timecard_utilities.periods;

1734: l_period_start_date date;
1735: l_period_end_date date;
1736: l_override_allowed boolean;
1737: l_app_period hxc_timecard_utilities.time_period;
1738: l_valid_periods hxc_timecard_utilities.periods;
1739:
1740:
1741: l_call_proc varchar2(2000);
1742: l_cursor number;

Line 1823: hxc_timecard_utilities.find_current_period(

1819: l_rec_period_type,
1820: l_duration_in_days;
1821: close csr_get_rec_period_info;
1822:
1823: hxc_timecard_utilities.find_current_period(
1824: p_rec_period_start_date => l_rec_start_date
1825: ,p_period_type => l_rec_period_type
1826: ,p_duration_in_days => l_duration_in_days
1827: ,p_current_date => p_day

Line 1851: hxc_timecard_utilities.process_assignments(

1847: l_app_period.end_date := l_period_end_date;
1848:
1849: l_valid_periods.delete;
1850:
1851: hxc_timecard_utilities.process_assignments(
1852: p_period => l_app_period
1853: ,p_assignment_periods => p_assignment_periods
1854: ,p_return_periods => l_valid_periods
1855: );

Line 2850: (p_assignment_periods in hxc_timecard_utilities.periods,

2846: --
2847: END get_approval_style_id;
2848:
2849: Function dayHasActiveAssignment
2850: (p_assignment_periods in hxc_timecard_utilities.periods,
2851: p_day_start in date) return boolean is
2852: l_asg_index binary_integer;
2853: l_found boolean;
2854: Begin

Line 2987: l_assignment_periods hxc_timecard_utilities.periods;

2983: l_new_detail_blocks hxc_block_table_type := hxc_block_table_type ();
2984: l_new_detail_attributes hxc_attribute_table_type := hxc_attribute_table_type ();
2985:
2986: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
2987: l_assignment_periods hxc_timecard_utilities.periods;
2988:
2989:
2990: CURSOR c_approval_comp(
2991: p_approval_style hxc_approval_styles.approval_style_id%TYPE

Line 3274: := hxc_timecard_utilities.get_assignment_periods(l_tc_resource_id);

3270: END IF;
3271: close csr_get_apps;
3272:
3273: l_assignment_periods
3274: := hxc_timecard_utilities.get_assignment_periods(l_tc_resource_id);
3275:
3276:
3277: g_trace := '70';
3278:

Line 3905: ,p_assignment_periods IN hxc_timecard_utilities.periods

3901:
3902:
3903: FUNCTION has_valid_assign(
3904: p_day IN DATE
3905: ,p_assignment_periods IN hxc_timecard_utilities.periods
3906: )
3907: RETURN BOOLEAN
3908: IS
3909: i pls_integer;

Line 3973: l_assignment_periods hxc_timecard_utilities.periods;

3969: p_resource_id number)
3970: RETURN VARCHAR2 IS
3971:
3972:
3973: l_assignment_periods hxc_timecard_utilities.periods;
3974: l_day DATE;
3975: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_submitted_days';
3976: --
3977: BEGIN

Line 3986: l_assignment_periods := hxc_timecard_utilities.get_assignment_periods(p_resource_id,p_period_start_date);

3982: --
3983: BEGIN
3984: --added by jxtan to fix mid period hiring
3985: -- Modified for Bug 12387815
3986: l_assignment_periods := hxc_timecard_utilities.get_assignment_periods(p_resource_id,p_period_start_date);
3987:
3988: l_day := p_period_start_date;
3989: LOOP
3990: EXIT WHEN l_day > p_period_end_date;