DBA Data[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;