1 PACKAGE hri_oltp_disc_time AUTHID CURRENT_USER AS
2 /* $Header: hriodtim.pkh 115.1 2003/12/08 07:11:16 knarula noship $ */
3 --
4 /**************************************************************************
5 Description : For a given date, this function finds the start date of the
6 period in which the date lies.
7 The period can be 'YEAR','SEMIYEAR','QUARTERYEAR',
8 'BIMONTH','MONTH'.
9 Preconditions : None
10 In Parameters : p_start_date IN DATE
11 p_period IN VARCHAR2
12 Post Sucess : It returns the start date for the period
13 Post Failure : Returns p_start_date being sent as input
14 ***************************************************************************/
15 FUNCTION get_period_start_date(p_start_date IN DATE,
16 p_period IN VARCHAR2) RETURN DATE;
17 --
18 /**************************************************************************
19 Description : For a given date, this function finds the end date of the
20 period in which the date lies.
21 The period can be 'YEAR','SEMIYEAR','QUARTERYEAR',
22 'BIMONTH','MONTH'.
23 Preconditions : None
24 In Parameters : p_end_date IN DATE
25 p_period IN VARCHAR2
26 Post Sucess : It returns the end date for the period
27 Post Failure : Returns p_end_date being sent as input
28 ***************************************************************************/
29 FUNCTION get_period_end_date(p_end_date IN DATE,
30 p_period IN VARCHAR2) RETURN DATE;
31 --
32 END hri_oltp_disc_time;