1 PACKAGE PO_PERIODS_SV AUTHID CURRENT_USER as
2 -- $Header: POXCOPES.pls 120.1 2011/11/03 23:38:02 ajunnikr ship $
3
4 -----------------------------------------------------------------------------
5 -- Public procedures.
6 -----------------------------------------------------------------------------
7
8 PROCEDURE get_period_info(p_roll_logic IN VARCHAR2,
9 p_set_of_books_id IN NUMBER,
10 p_date_tbl IN po_tbl_date,
11 x_period_name_tbl OUT NOCOPY po_tbl_varchar30,
12 x_period_year_tbl OUT NOCOPY po_tbl_number,
13 x_period_num_tbl OUT NOCOPY po_tbl_number,
14 x_quarter_num_tbl OUT NOCOPY po_tbl_number,
15 x_invalid_period_flag OUT NOCOPY VARCHAR2);
16
17 PROCEDURE get_period_name(x_sob_id IN NUMBER,
18 x_gl_date IN DATE,
19 x_gl_period OUT NOCOPY VARCHAR2);
20
21 PROCEDURE build_GL_Encumbered_Date(l_sob_id IN NUMBER,
22 x_gl_date IN OUT NOCOPY DATE,
23 x_gl_period OUT NOCOPY VARCHAR2);
24
25 -- GL Date Project#Start: Derive proper GL date, when the profile
26 -- PO: Validate GL Period: Redefault has been set to Redefault.
27 PROCEDURE get_gl_date(x_sob_id IN NUMBER,
28 x_gl_date IN OUT NOCOPY po_tbl_date);
29 -- GL Date Project#End
30
31 END PO_PERIODS_SV;
32
[Home] [Help]