1 PACKAGE hri_bpl_time AUTHID CURRENT_USER AS
2 /* $Header: hribtime.pkh 115.1 2003/12/08 07:11:11 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 : Returns the start date of the period
13 Post Failure : Raise error no_data_found
14 ***************************************************************************/
15 FUNCTION get_period_start_date(p_start_date IN DATE,
16 p_period IN VARCHAR2)
17 RETURN DATE;
18 --
19 /**************************************************************************
20 Description : For a given date, this function finds the end date of the
21 period in which the date lies.
22 The period can be 'YEAR','SEMIYEAR','QUARTERYEAR',
23 'BIMONTH','MONTH'.
24 Preconditions : None
25 In Parameters : p_end_date IN DATE
26 p_period IN VARCHAR2
27 Post Sucess : Returns the end date fo the period
28 Post Failure : Raise error no_data_found
29 ***************************************************************************/
30 FUNCTION get_period_end_date (p_end_date IN DATE,
31 p_period IN VARCHAR2)
32 RETURN DATE;
33 --
34 END hri_bpl_time;
[Home] [Help]