[Home] [Help]
PACKAGE: APPS.XDO_DGF_TEST_RULES
Source
1 PACKAGE xdo_dgf_test_rules AUTHID CURRENT_USER AS
2 /* $Header: XDODGFTRS.pls 120.1 2008/01/19 00:54:40 bgkim noship $ */
3 -----------------------------------------------------------------------------------------
4 -- ************ FUNCTION is_enough_days *************************************************
5 -- returns 'Y' iff p_end_date - p_start_date >= p_number_of_days
6 -- otherwise returns 'N'
7 -- --------------------------------------------------------------------------------------
8 -- PARAMETERS: p_start_date, e.g. '01-MAR-2001'
9 -- p_end_date, e.g. '28-FEB-2003'
10 -- p_format_mask, e.g. 'DD-MON-YYYY'
11 -- p_number_of_days, e.g. '60', string must represent a number !!!
12 FUNCTION is_enough_days
13 ( p_start_date in varchar2,
14 p_end_date in varchar2,
15 p_format_mask in varchar2,
16 p_number_of_days in varchar2 := '30')
17 RETURN varchar2;
18
19 -----------------------------------------------------------------------------------------
20 -- ************ FUNCTION get_days *************************************************
21 -- returns p_end_date - p_start_date
22 -- otherwise returns 'N'
23 -- --------------------------------------------------------------------------------------
24 -- PARAMETERS: p_start_date, e.g. '01-MAR-2001'
25 -- p_end_date, e.g. '28-FEB-2003'
26 -- p_format_mask, e.g. 'DD-MON-YYYY'
27 FUNCTION get_days
28 ( p_start_date in varchar2,
29 p_end_date in varchar2,
30 p_format_mask in varchar2
31 )
32 RETURN number;
33
34
35 -----------------------------------------------------------------------------------------
36 -- ************ FUNCTION is_working_hours *************************************************
37 -- returns 'Y' iff
38 -- to_number(to_char(SYSDATE, 'HH24')) between 8 and 17
39 -- otherwise returns 'N'
40 -- --------------------------------------------------------------------------------------
41 function is_working_hours return varchar2;
42
43 END xdo_dgf_test_rules;