APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_RECURRING_PERIODS

Line 8: g_rec_period_start_date hxc_recurring_periods.start_date%TYPE;

4: g_debug boolean := hr_utility.debug_enabled;
5: g_assignment_periods periods;
6: g_past_date_limit DATE;
7: g_future_date_limit DATE;
8: g_rec_period_start_date hxc_recurring_periods.start_date%TYPE;
9: g_period_type hxc_recurring_periods.period_type%TYPE;
10: g_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
11: g_num_past_entries NUMBER := 10; --hardcoded
12: g_num_future_entries NUMBER := 10; --hardcoded

Line 9: g_period_type hxc_recurring_periods.period_type%TYPE;

5: g_assignment_periods periods;
6: g_past_date_limit DATE;
7: g_future_date_limit DATE;
8: g_rec_period_start_date hxc_recurring_periods.start_date%TYPE;
9: g_period_type hxc_recurring_periods.period_type%TYPE;
10: g_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
11: g_num_past_entries NUMBER := 10; --hardcoded
12: g_num_future_entries NUMBER := 10; --hardcoded
13: g_separator VARCHAR2(1) := '|';

Line 10: g_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;

6: g_past_date_limit DATE;
7: g_future_date_limit DATE;
8: g_rec_period_start_date hxc_recurring_periods.start_date%TYPE;
9: g_period_type hxc_recurring_periods.period_type%TYPE;
10: g_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
11: g_num_past_entries NUMBER := 10; --hardcoded
12: g_num_future_entries NUMBER := 10; --hardcoded
13: g_separator VARCHAR2(1) := '|';
14: g_date_format VARCHAR2(20) := 'YYYY/MM/DD';

Line 1397: FROM hxc_recurring_periods rp,

1393: IS
1394: SELECT rp.period_type,
1395: rp.duration_in_days,
1396: rp.start_date
1397: FROM hxc_recurring_periods rp,
1398: per_time_period_types p
1399: WHERE p.period_type (+) = rp.period_type
1400: AND hxc_preference_evaluation.resource_preferences(
1401: p_resource_id,'TC_W_TCRD_PERIOD|1|') = rp.recurring_period_id;

Line 1409: from hxc_recurring_periods hrp

1405: is
1406: select hrp.period_type,
1407: hrp.duration_in_days,
1408: hrp.start_date
1409: from hxc_recurring_periods hrp
1410: where hrp.recurring_period_id = p_recurring_period_id;
1411:
1412: BEGIN
1413: