APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIMECARD_UTILITIES

Line 1550: ,p_assignment_periods IN hxc_timecard_utilities.periods

1546: ,p_day IN hxc_time_building_blocks.start_time%TYPE
1547: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
1548: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1549: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1550: ,p_assignment_periods IN hxc_timecard_utilities.periods
1551: ,p_period_start OUT NOCOPY hxc_time_building_blocks.start_time%TYPE
1552: ,p_period_end OUT NOCOPY hxc_time_building_blocks.stop_time%TYPE
1553: )
1554: IS

Line 1558: l_app_period hxc_timecard_utilities.time_period;

1554: IS
1555: l_period_start_date date;
1556: l_period_end_date date;
1557: l_override_allowed boolean;
1558: l_app_period hxc_timecard_utilities.time_period;
1559: l_valid_periods hxc_timecard_utilities.periods;
1560:
1561:
1562: l_call_proc varchar2(2000);

Line 1559: l_valid_periods hxc_timecard_utilities.periods;

1555: l_period_start_date date;
1556: l_period_end_date date;
1557: l_override_allowed boolean;
1558: l_app_period hxc_timecard_utilities.time_period;
1559: l_valid_periods hxc_timecard_utilities.periods;
1560:
1561:
1562: l_call_proc varchar2(2000);
1563: l_cursor number;

Line 1644: hxc_timecard_utilities.find_current_period(

1640: l_rec_period_type,
1641: l_duration_in_days;
1642: close csr_get_rec_period_info;
1643:
1644: hxc_timecard_utilities.find_current_period(
1645: p_rec_period_start_date => l_rec_start_date
1646: ,p_period_type => l_rec_period_type
1647: ,p_duration_in_days => l_duration_in_days
1648: ,p_current_date => p_day

Line 1672: hxc_timecard_utilities.process_assignments(

1668: l_app_period.end_date := l_period_end_date;
1669:
1670: l_valid_periods.delete;
1671:
1672: hxc_timecard_utilities.process_assignments(
1673: p_period => l_app_period
1674: ,p_assignment_periods => p_assignment_periods
1675: ,p_return_periods => l_valid_periods
1676: );

Line 2502: (p_assignment_periods in hxc_timecard_utilities.periods,

2498: --
2499: END get_approval_style_id;
2500:
2501: Function dayHasActiveAssignment
2502: (p_assignment_periods in hxc_timecard_utilities.periods,
2503: p_day_start in date) return boolean is
2504: l_asg_index binary_integer;
2505: l_found boolean;
2506: Begin

Line 2639: l_assignment_periods hxc_timecard_utilities.periods;

2635: l_new_detail_blocks hxc_block_table_type := hxc_block_table_type ();
2636: l_new_detail_attributes hxc_attribute_table_type := hxc_attribute_table_type ();
2637:
2638: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
2639: l_assignment_periods hxc_timecard_utilities.periods;
2640:
2641:
2642: CURSOR c_approval_comp(
2643: p_approval_style hxc_approval_styles.approval_style_id%TYPE

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

2790: END IF;
2791: close csr_get_apps;
2792:
2793: l_assignment_periods
2794: := hxc_timecard_utilities.get_assignment_periods(l_tc_resource_id);
2795:
2796:
2797: g_trace := '70';
2798:

Line 3274: ,p_assignment_periods IN hxc_timecard_utilities.periods

3270:
3271:
3272: FUNCTION has_valid_assign(
3273: p_day IN DATE
3274: ,p_assignment_periods IN hxc_timecard_utilities.periods
3275: )
3276: RETURN BOOLEAN
3277: IS
3278: i pls_integer;

Line 3342: l_assignment_periods hxc_timecard_utilities.periods;

3338: p_resource_id number)
3339: RETURN VARCHAR2 IS
3340:
3341:
3342: l_assignment_periods hxc_timecard_utilities.periods;
3343: l_day DATE;
3344: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_submitted_days';
3345: --
3346: BEGIN

Line 3354: l_assignment_periods := hxc_timecard_utilities.get_assignment_periods(p_resource_id);

3350: end if;
3351: --
3352: BEGIN
3353: --added by jxtan to fix mid period hiring
3354: l_assignment_periods := hxc_timecard_utilities.get_assignment_periods(p_resource_id);
3355:
3356: l_day := p_period_start_date;
3357: LOOP
3358: EXIT WHEN l_day > p_period_end_date;