1 PACKAGE gl_recurring_valid_periods_pkg AS
2 /* $Header: glirjvps.pls 120.4 2005/05/05 01:20:45 kvora ship $ */
3 --
4 -- Package
5 -- gl_recurring_valid_periods_pkg
6 -- Purpose
7 -- To retrieve the information from the gl_recurring_valid_periods_v view.
8 -- History
9 -- 07/10/96 W Ho Created
10
11 --
12 -- Procedure
13 -- get_next_period
14 -- Purpose
15 -- To get the next open period and return it in x_next_period.
16 -- History
17 -- 07/10/96 W Ho Created
18 -- Arguments
19 -- x_ledger_id Ledger id
20 -- x_recurring_batch_id Recurring batch id
21 -- x_period Last executed period
22 -- x_next_period Next open period
23 -- Example
24 -- gl_recurring_valid_periods_pkg.get_next_period(
25 -- :block.ledger_id,
26 -- :block.recurring_batch_id,
27 -- :block.period,
28 -- :block.next_period );
29 -- Notes
30 --
31 PROCEDURE get_next_period(
32 x_ledger_id NUMBER,
33 x_recurring_batch_id NUMBER,
34 x_period VARCHAR2,
35 x_next_period IN OUT NOCOPY VARCHAR2 );
36
37
38 END gl_recurring_valid_periods_pkg;