1 PACKAGE gl_je_header_security AS
2 /* $Header: gluhdsvs.pls 120.3 2003/04/24 01:38:16 djogg noship $ */
3
4 --
5 -- PUBLIC FUNCTIONS
6 --
7
8 -- Procedure
9 -- check_header_valid_lsv
10 -- Purpose
11 -- Return 'Y' if all the ledger segment values (balancing and managment)
12 -- are valid for the given header and a date or 'N' otherwise.
13 -- If no date is provided, the date is ignored.
14 -- Returned value meanings
15 -- 'N' - invalid segment values
16 -- 'Y' - valid segment values
17 -- History
18 -- 06/21/01 O Monnier Created
19 -- Arguments
20 -- x_je_header_id The journal to be checked
21 -- x_edate The date used to check the access
22 -- Example
23 -- gl_je_header_security.check_header_valid_lsv( 12345, SYSDATE );
24 -- Notes
25 --
26 FUNCTION check_header_valid_lsv ( x_je_header_id IN NUMBER,
27 x_edate IN DATE) RETURN VARCHAR2;
28
29 -- Procedure
30 -- check_header_write_all
31 -- Purpose
32 -- Check both the valid ledger segment values and whether the user has
33 -- write access to the header. The valid ledger segment values are
34 -- checked first, then if they are valid, we check the access of the
35 -- user to the header.
36 --
37 -- Returned value meanings
38 -- 'Z' - invalid segment values for the ledger
39 -- 'N' - valid segment values, no write access
40 -- 'Y' - valid segment values, write access
41 -- If no date is provided, the date is ignored.
42 -- History
43 -- 06/21/01 O Monnier Created
44 -- Arguments
45 -- x_access_set_id The access set id to be used
46 -- x_je_header_id The journal to be checked
47 -- x_edate The date used to check the validity
48 -- Example
49 -- gl_je_header_security.check_header_write_all( 12345, SYSDATE );
50 -- Notes
51 --
52 FUNCTION check_header_write_all ( x_access_set_id IN NUMBER,
53 x_je_header_id IN NUMBER,
54 x_edate IN DATE) RETURN VARCHAR2;
55
56 END gl_je_header_security;