[Home] [Help]
PACKAGE: APPS.GL_BALANCES_PKG
Source
1 PACKAGE GL_BALANCES_PKG AS
2 /* $Header: gliblncs.pls 120.4 2005/05/05 01:03:02 kvora ship $ */
3 --
4 -- Package
5 -- GL_BALANCES_PKG
6 -- Purpose
7 -- To create GL_BALANCES_PKG package.
8 --
9
10
11 --
12 -- Procedure
13 -- set_translated_flag
14 -- Purpose
15 -- History
16 -- 03-NOV-1994 E. Rumanang Created.
17 -- Arguments
18 -- x_ledger_id Ledger ID.
19 -- x_ccid Code combination ID.
20 -- x_currency Currency Code.
21 -- x_period_year Period Year.
22 -- x_period_num Period Number.
23 -- x_last_updated_by User id who last update the row.
24 --
25 PROCEDURE set_translated_flag( x_ledger_id NUMBER,
26 x_ccid NUMBER,
27 x_currency VARCHAR2,
28 x_period_year NUMBER,
29 x_period_num NUMBER,
30 x_last_updated_by NUMBER,
31 x_chart_of_accounts_id NUMBER,
32 x_period_name VARCHAR2,
33 x_usage_code VARCHAR2);
34
35
36
37
38 -- Procedure
39 -- gl_activity
40 -- Purpose
41 -- Given the parameter listed above and the procedure will return
42 -- the Period Net Cr and the Period Net Dr
43 -- or raise exception NO_DATA_FOUND
44 -- History
45 -- 3/16/95 Schirin Farzaneh Created
46 -- Arguments
47 -- PARAMETERS
48 -- PERIOD_FROM VARCHAR2
49 -- PERIOD_TO VARCHAR2
50 -- CODE_COMBINATION_ID NUMBER
51 -- LEDGER_ID NUMBER
52 -- RETURNS
53 -- PERIOD_NET_DR
54 -- PERIOD_NET_CR
55 -- exception NO_DATA_FOUND
56
57 PROCEDURE gl_get_period_range_activity
58 ( P_PERIOD_FROM IN VARCHAR2
59 ,P_PERIOD_TO IN VARCHAR2
60 ,P_CODE_COMBINATION_ID IN NUMBER
61 ,P_LEDGER_ID IN NUMBER
62 ,P_PERIOD_NET_DR OUT NOCOPY NUMBER
63 ,P_PERIOD_NET_CR OUT NOCOPY NUMBER);
64
65 END GL_BALANCES_PKG;