11: TYPE period_list is TABLE OF
12: period
13: INDEX BY BINARY_INTEGER;
14:
15: TYPE r_per_time_period_types IS RECORD
16: (
17: p_proc_period_type VARCHAR2(30),
18: number_per_fiscal_year per_time_period_types.number_per_fiscal_year%type
19: );
14:
15: TYPE r_per_time_period_types IS RECORD
16: (
17: p_proc_period_type VARCHAR2(30),
18: number_per_fiscal_year per_time_period_types.number_per_fiscal_year%type
19: );
20: TYPE t_per_time_period_types IS TABLE OF r_per_time_period_types INDEX BY BINARY_INTEGER;
21: g_per_time_period_types_ct t_per_time_period_types;
22:
16: (
17: p_proc_period_type VARCHAR2(30),
18: number_per_fiscal_year per_time_period_types.number_per_fiscal_year%type
19: );
20: TYPE t_per_time_period_types IS TABLE OF r_per_time_period_types INDEX BY BINARY_INTEGER;
21: g_per_time_period_types_ct t_per_time_period_types;
22:
23: FUNCTION get_period_list (p_current_date date,
24: p_recurring_period_type varchar2,
17: p_proc_period_type VARCHAR2(30),
18: number_per_fiscal_year per_time_period_types.number_per_fiscal_year%type
19: );
20: TYPE t_per_time_period_types IS TABLE OF r_per_time_period_types INDEX BY BINARY_INTEGER;
21: g_per_time_period_types_ct t_per_time_period_types;
22:
23: FUNCTION get_period_list (p_current_date date,
24: p_recurring_period_type varchar2,
25: p_duration_in_days number,