DBA Data[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;