DBA Data[Home] [Help]

APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_TIMECARD

Line 1: PACKAGE BODY hxc_timecard_utilities AS

1: PACKAGE BODY hxc_timecard_utilities AS
2: /* $Header: hxctcutil.pkb 120.25.12010000.2 2008/11/13 12:20:37 bbayragi ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: g_assignment_periods periods;

Line 16: g_package VARCHAR2(30) := 'hxc_timecard_utilities.';

12: g_num_future_entries NUMBER := 10; --hardcoded
13: g_separator VARCHAR2(1) := '|';
14: g_date_format VARCHAR2(20) := 'YYYY/MM/DD';
15: g_initialized VARCHAR2(20) := 'N';
16: g_package VARCHAR2(30) := 'hxc_timecard_utilities.';
17:
18: PROCEDURE get_period_by_duration(
19: p_rec_period_start_date IN DATE
20: ,p_duration_in_days IN NUMBER

Line 162: IF (p_period.exist_flag = hxc_timecard.c_existing_period_indicator) THEN

158: ELSE
159: l_return_index := p_return_periods.last + 1;
160: END IF;
161:
162: IF (p_period.exist_flag = hxc_timecard.c_existing_period_indicator) THEN
163:
164: --Remove the entry if its already found. We need to keep the existing period
165: --in the list, rather than a open period.
166: l_found_index := find_period_already_exist(p_return_periods,

Line 180: p_return_periods(l_return_index).exist_flag := hxc_timecard.c_archived_period_indicator;

176: p_return_periods(l_return_index).exist_flag := p_period.exist_flag;
177: p_return_periods(l_return_index).p_set_more_period := p_period.p_set_more_period;
178:
179: IF (check_period_archived(p_period.end_date)) THEN
180: p_return_periods(l_return_index).exist_flag := hxc_timecard.c_archived_period_indicator;
181: ELSE
182: p_return_periods(l_return_index).exist_flag := p_period.exist_flag;
183: END IF;
184:

Line 384: IF NVL(p_periods(l_index).exist_flag, 'N') <> hxc_timecard.c_existing_period_indicator AND NVL(p_periods(l_index).exist_flag, 'N') <> hxc_timecard.c_archived_period_indicator

380: || ' end=' || p_periods(l_index).end_date
381: || 'exists=' || NVL(p_periods(l_index).exist_flag, 'N'));
382: END IF;
383:
384: IF NVL(p_periods(l_index).exist_flag, 'N') <> hxc_timecard.c_existing_period_indicator AND NVL(p_periods(l_index).exist_flag, 'N') <> hxc_timecard.c_archived_period_indicator
385: THEN
386:
387:
388: IF not p_future and p_default_tc_period = 'EARLIEST' AND

Line 593: ,p_set_more_period => hxc_timecard.c_more_period_indicator

589: p_periods => l_periods
590: ,p_start_date => l_start_date
591: ,p_end_date => l_end_date
592: ,p_position => 'BEFORE'
593: ,p_set_more_period => hxc_timecard.c_more_period_indicator
594: );
595: ELSE
596: l_added := add_period(
597: p_periods => l_periods

Line 674: ,p_set_more_period =>hxc_timecard.c_more_period_indicator

670: ,p_start_date => l_start_date
671: ,p_end_date => l_end_date
672: ,p_future_date_limit => g_future_date_limit
673: ,p_assignment_end => g_assignment_periods(l_assignment_index).end_date
674: ,p_set_more_period =>hxc_timecard.c_more_period_indicator
675: );
676: ELSE
677: l_added := add_period(
678: p_periods => l_periods

Line 730: ,p_exists => hxc_timecard.c_archived_period_indicator

726: ,p_end_date => l_periods(l_period_index).end_date
727: ,p_last_period_end => l_last_period_end
728: ,p_past_date_limit => g_past_date_limit
729: ,p_future_date_limit => g_future_date_limit
730: ,p_exists => hxc_timecard.c_archived_period_indicator
731: ,p_show_existing_timecard => p_show_existing_timecard
732: ,p_set_more_period => l_periods(l_period_index).p_set_more_period
733: );
734:

Line 769: ,p_exists => hxc_timecard.c_existing_period_indicator

765: ,p_end_date => l_end_date
766: ,p_last_period_end => l_last_period_end
767: ,p_past_date_limit => g_past_date_limit
768: ,p_future_date_limit => g_future_date_limit
769: ,p_exists => hxc_timecard.c_existing_period_indicator
770: ,p_show_existing_timecard => p_show_existing_timecard
771: ,p_set_more_period => get_more_period_value(l_periods,l_start_date,l_end_date)
772: );
773: END IF;

Line 810: ,p_exists => hxc_timecard.c_archived_period_indicator

806: ,p_end_date => l_periods(l_period_index).end_date
807: ,p_last_period_end => l_last_period_end
808: ,p_past_date_limit => g_past_date_limit
809: ,p_future_date_limit => g_future_date_limit
810: ,p_exists => hxc_timecard.c_archived_period_indicator
811: ,p_show_existing_timecard => p_show_existing_timecard
812: ,p_set_more_period => l_periods(l_period_index).p_set_more_period
813: );
814: ELSE

Line 863: ((l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_existing_period_indicator) AND

859: l_period_index := l_assignment_processed_periods.first;
860: while l_period_index is not null
861: loop
862: if((l_assignment_processed_periods(l_period_index).exist_flag is null) or
863: ((l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_existing_period_indicator) AND
864: (l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_archived_period_indicator))
865: ) then
866: l_processed_periods(l_index) := l_assignment_processed_periods(l_period_index);
867: l_index := l_index+1;

Line 864: (l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_archived_period_indicator))

860: while l_period_index is not null
861: loop
862: if((l_assignment_processed_periods(l_period_index).exist_flag is null) or
863: ((l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_existing_period_indicator) AND
864: (l_assignment_processed_periods(l_period_index).exist_flag <> hxc_timecard.c_archived_period_indicator))
865: ) then
866: l_processed_periods(l_index) := l_assignment_processed_periods(l_period_index);
867: l_index := l_index+1;
868: end if;

Line 2445: END hxc_timecard_utilities;

2441: END LOOP; -- timecard
2442:
2443: END cla_summary_alias_translation;
2444:
2445: END hxc_timecard_utilities;