APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_RECURRING_PERIODS

Line 929: l_period_type hxc_recurring_periods.period_type%TYPE;

925: l_proc VARCHAR2(72);
926:
927: l_param_rec hxc_ff_dict.r_param;
928:
929: l_period_type hxc_recurring_periods.period_type%TYPE;
930: l_period_id hxc_recurring_periods.recurring_period_id%TYPE;
931: l_reference_period NUMBER(10);
932: l_consider_zero_hours VARCHAR2(10) := 'Y'; -- fault tolerant thus larger than 1 char
933:

Line 930: l_period_id hxc_recurring_periods.recurring_period_id%TYPE;

926:
927: l_param_rec hxc_ff_dict.r_param;
928:
929: l_period_type hxc_recurring_periods.period_type%TYPE;
930: l_period_id hxc_recurring_periods.recurring_period_id%TYPE;
931: l_reference_period NUMBER(10);
932: l_consider_zero_hours VARCHAR2(10) := 'Y'; -- fault tolerant thus larger than 1 char
933:
934: l_period_tab t_period;

Line 936: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;

932: l_consider_zero_hours VARCHAR2(10) := 'Y'; -- fault tolerant thus larger than 1 char
933:
934: l_period_tab t_period;
935:
936: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
937: l_period_start DATE;
938: l_period_start_date DATE;
939: l_period_end_date DATE;
940: l_ref_period_start DATE;

Line 1917: l_period_id hxc_recurring_periods.recurring_period_id%TYPE;

1913: l_proc VARCHAR2(72);
1914:
1915: l_param_rec hxc_ff_dict.r_param;
1916:
1917: l_period_id hxc_recurring_periods.recurring_period_id%TYPE;
1918: l_reference_period NUMBER(10);
1919: l_consider_zero_hours VARCHAR2(10);
1920:
1921: l_tc_id_1 hxc_time_categories.time_category_id%TYPE;

Line 2456: l_period_type hxc_recurring_periods.period_type%TYPE;

2452: group by ts.timecard_id ;
2453:
2454: l_submission_date DATE;
2455:
2456: l_period_type hxc_recurring_periods.period_type%TYPE;
2457: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
2458:
2459: l_return NUMBER;
2460:

Line 2457: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;

2453:
2454: l_submission_date DATE;
2455:
2456: l_period_type hxc_recurring_periods.period_type%TYPE;
2457: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
2458:
2459: l_return NUMBER;
2460:
2461: l_total_hrs NUMBER := 0;