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 1972: l_period_id hxc_recurring_periods.recurring_period_id%TYPE;

1968: l_proc VARCHAR2(72);
1969:
1970: l_param_rec hxc_ff_dict.r_param;
1971:
1972: l_period_id hxc_recurring_periods.recurring_period_id%TYPE;
1973: l_reference_period NUMBER(10);
1974: l_consider_zero_hours VARCHAR2(10);
1975:
1976: l_tc_id_1 hxc_time_categories.time_category_id%TYPE;

Line 2511: l_period_type hxc_recurring_periods.period_type%TYPE;

2507: group by ts.timecard_id ;
2508:
2509: l_submission_date DATE;
2510:
2511: l_period_type hxc_recurring_periods.period_type%TYPE;
2512: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
2513:
2514: l_return NUMBER;
2515:

Line 2512: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;

2508:
2509: l_submission_date DATE;
2510:
2511: l_period_type hxc_recurring_periods.period_type%TYPE;
2512: l_duration_in_days hxc_recurring_periods.duration_in_days%TYPE;
2513:
2514: l_return NUMBER;
2515:
2516: l_total_hrs NUMBER := 0;