[Home] [Help]
PACKAGE: APPS.GMF_GL_GET_BALANCES
Source
1 PACKAGE GMF_GL_GET_BALANCES AUTHID CURRENT_USER AS
2 /* $Header: gmfbalns.pls 120.3.12020000.2 2012/07/24 15:12:50 spabolu ship $ */
3
4 /** Anand thiyagarajan GL Expense Allocation Enhancement 26-04-2004 Start**/
5
6 TYPE gmf_segment_values_tbl IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
7
8 /*B12600219 - Added to support debug message printing*/
9 C_MODULE CONSTANT VARCHAR2(80) := 'gmf.plsql.gmf_gl_get_balances';
10 C_LOG_FILE CONSTANT NUMBER(1) := 1;
11 C_OUT_FILE CONSTANT NUMBER(1) := 2;
12 /*B12600219 - Added to support debug message printing*/
13
14 /** Anand thiyagarajan GL Expense Allocation Enhancement 26-04-2004 End**/
15 TYPE cur_gl_get_balances_rc IS REF CURSOR; /* Bug 14178149 */
16
17 PROCEDURE proc_gl_get_balances(
18 in_set_of_books in out NOCOPY number,
19 in_chart_of_accounts in out NOCOPY number,
20 in_period_year in out NOCOPY number,
21 in_period_num in out NOCOPY number,
22 in_account_type in out NOCOPY varchar2, /* (A)sset/(L)iability...... */
23 in_currency_code in out NOCOPY varchar2,
24 start_segments in varchar2, /* Segments 1-30 */
25 to_segments in out NOCOPY varchar2, /* Segments 1-30 */
26 in_actual_flag in out NOCOPY varchar2, /* (A)ctual/(B)udget/(E)ncumerance */
27 in_ytd_ptd in number, /* 0=PTD, 1=YTD */
28 amount out NOCOPY number,
29 segment_delimiter out NOCOPY varchar2,
30 row_to_fetch in out NOCOPY number,
31 error_status out NOCOPY number,
32 to_segments_ccid out NOCOPY number, /*Bug#12600219*/
33 cur_gl_get_balances in out NOCOPY GMF_GL_GET_BALANCES.cur_gl_get_balances_rc /* Bug 14178149 */
34 );
35
36 PROCEDURE initialize(
37 in_set_of_books_id IN NUMBER
38 );
39
40 END GMF_GL_GET_BALANCES;