[Home] [Help]
PACKAGE: APPS.HXC_PERIOD_EVALUATION
Source
1 package hxc_period_evaluation AUTHID CURRENT_USER as
2 /* $Header: hxcperevl.pkh 115.3 2003/12/12 03:01:22 sonarasi noship $ */
3 FUNCTION make_date(p_day varchar2,
4 p_month_year varchar2) RETURN DATE;
5
6 TYPE period is RECORD
7 (START_DATE DATE
8 ,END_DATE DATE
9 );
10
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 );
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,
26 p_rec_period_start_date date,
27 p_max_date_in_futur date,
28 p_max_date_in_past date)
29 return period_list;
30 /*
31 FUNCTION get_period_list (p_current_date date,
32 p_resource_id number,
33 p_max_date_in_futur date,
34 p_max_date_in_past date)
35 return period_list;
36 */
37 PROCEDURE get_period_details (p_proc_period_type IN VARCHAR2,
38 p_base_period_type OUT NOCOPY VARCHAR2,
39 p_multiple OUT NOCOPY NUMBER);
40
41 procedure period_start_stop(p_current_date date,
42 p_rec_period_start_date date,
43 l_period_start in out nocopy date,
44 l_period_end in out nocopy date,
45 l_base_period_type varchar2);
46
47 PROCEDURE period_start_stop(p_current_date date,
48 p_rec_period_start_date date,
49 l_period_start in out nocopy date,
50 l_period_end in out nocopy date,
51 l_base_period_type varchar2,
52 p_multiple number);
53
54 end hxc_period_evaluation;