PACKAGE: APPS.XDO_DGF_TEST_RULES

Source

1 PACKAGE xdo_dgf_test_rules  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;