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