1 PACKAGE gl_rje_access_pkg AUTHID CURRENT_USER AS
2 /* $Header: glirecas.pls 120.4 2005/05/05 01:19:32 kvora ship $ */
3
4 --
5 -- Package
6 -- gl_rje_access_pkg
7 -- Purpose
8 -- To contain validation routines for gl_rje_access_pkg
9 -- History
10 -- 10-23-02 J Wu Created
11
12 --
13 -- PUBLIC CONSTANTS
14 --
15 DEFAULT_NUM_FORMULAS_TO_CHECK CONSTANT NUMBER := 5;
16
17
18 --
19 -- Function
20 -- validate_calc_effective_date
21 -- Purpose
22 -- Checks certain number of formulas, see if the given calculation
23 -- effective date falls in a never opened period for the ledgers
24 -- in these formulas.
25 -- History
26 -- 10-23-02 J Wu Created
27 -- Arguments
28 -- x_batch_id batch id
29 -- x_selected_ced the calculation effective date
30 -- Returns
31 -- TRUE if the calculation effective date does not fall in any of the
32 -- ledgers being checked. FALSE otherwise.
33 -- Notes
34 --
35 FUNCTION validate_calc_effective_date (x_batch_id NUMBER,
36 x_selected_ced DATE) RETURN BOOLEAN;
37
38
39 --
40 -- Function
41 -- allow_average_usage
42 -- Purpose
43 -- Check for "certain number of formulas" in the batch whether the ledgers
44 -- are all consolidation ledgers. Only if so will average usage be allowed.
45 -- History
46 -- 10-23-02 J Wu Created
47 -- Arguments
48 -- x_batch_id batch id
49 -- Returns
50 -- TRUE if average usage is allowed. FALSE otherwise.
51 -- Notes
52 --
53
54 FUNCTION allow_average_usage(x_batch_id NUMBER) RETURN BOOLEAN;
55
56
57 --
58 -- Function
59 -- set_random_ledger_id
60 -- Purpose
61 -- Select a random header ledger for the recurring batch.
62 --
63 -- History
64 -- 10-23-02 J Wu Created
65 -- Arguments
66 -- x_allocation_batch_id batch id
67 -- Notes
68 --
69 FUNCTION set_random_ledger_id (x_allocation_batch_id NUMBER) RETURN NUMBER;
70
71 END gl_rje_access_pkg;