62: -- Used by accrual_period_basis and ann_leave_accrual_daily_basis
63: -- functions.
64:
65: type t_asg_work_day_info_rec is record
66: (effective_start_date per_all_assignments_f.effective_start_date%type
67: ,effective_end_date per_all_assignments_f.effective_end_date%type
68: ,normal_hours per_all_assignments_f.normal_hours%type
69: ,frequency per_all_assignments_f.frequency%type) ;
70:
63: -- functions.
64:
65: type t_asg_work_day_info_rec is record
66: (effective_start_date per_all_assignments_f.effective_start_date%type
67: ,effective_end_date per_all_assignments_f.effective_end_date%type
68: ,normal_hours per_all_assignments_f.normal_hours%type
69: ,frequency per_all_assignments_f.frequency%type) ;
70:
71: type t_asg_work_day_info_tab
64:
65: type t_asg_work_day_info_rec is record
66: (effective_start_date per_all_assignments_f.effective_start_date%type
67: ,effective_end_date per_all_assignments_f.effective_end_date%type
68: ,normal_hours per_all_assignments_f.normal_hours%type
69: ,frequency per_all_assignments_f.frequency%type) ;
70:
71: type t_asg_work_day_info_tab
72: is table of t_asg_work_day_info_rec
65: type t_asg_work_day_info_rec is record
66: (effective_start_date per_all_assignments_f.effective_start_date%type
67: ,effective_end_date per_all_assignments_f.effective_end_date%type
68: ,normal_hours per_all_assignments_f.normal_hours%type
69: ,frequency per_all_assignments_f.frequency%type) ;
70:
71: type t_asg_work_day_info_tab
72: is table of t_asg_work_day_info_rec
73: index by binary_integer ;
677: l_mm_dd varchar2(10);
678: l_start_date date ;
679: l_end_date date ;
680: l_period_accrual number ;
681: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
682: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;
683: e_accrual_function_failure exception ;
684:
685: -- cursor to get number of periods per year
789: function asg_working_hours(p_effective_date date
790: ,p_frequency varchar2) return number is
791:
792: l_procedure_name varchar2(61) := ' asg_working_hours' ;
793: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
794: l_counter integer := 1 ;
795: l_hours_notfound_flag boolean := true ;
796:
797: begin