PACKAGE: APPS.FV_GTAS_TBAL_TRX_PKG

Source

1 PACKAGE FV_GTAS_TBAL_TRX_PKG AUTHID CURRENT_USER AS
2 /* $Header: FVGTATBS.pls 120.4.12020000.3 2013/01/03 13:42:55 snama noship $ */
3 
4 P_LEDGER_ID       Gl_ledgers_public_v.ledger_id%TYPE;
5 P_CHART_OF_ACCOUNTS_ID   Gl_Code_Combinations.chart_of_accounts_id%TYPE;
6 P_FLEX_LOW     VARCHAR2(2000);
7 P_FLEX_HIGH    VARCHAR2(2000);
8 P_AID_LOW      VARCHAR2(3);
9 P_AID_HIGH     VARCHAR2(3);
10 P_MAIN_ACCT_LOW VARCHAR2(4);
11 P_MAIN_ACCT_HIGH VARCHAR2(4);
12 P_TAS           fv_treasury_symbols.treasury_symbol%TYPE;
13 P_CURRENCY      Varchar2(10);
14 P_PERIOD        Varchar2(20);
15 
16 FUNCTION beforereport
17 RETURN BOOLEAN;
18 
19 PROCEDURE build_segs_where_clause (p_flex_low IN VARCHAR2,
20                                    p_flex_high IN VARCHAR2,
21                                    p_sob_id IN NUMBER,
22                                    p_segs_where_clause OUT NOCOPY VARCHAR2);
23 
24 PROCEDURE TRIAL_BALANCE_MAIN
25              (P_LEDGER_ID       Gl_ledgers_public_v.ledger_id%TYPE,
26               P_CHART_OF_ACCOUNTS_ID
27 Gl_Code_Combinations.chart_of_accounts_id%TYPE,
28               P_FLEX_LOW     IN VARCHAR2,
29               P_FLEX_HIGH     IN VARCHAR2,
30               P_PERIOD        Varchar2,
31               P_AID_LOW      IN VARCHAR2,
32               P_AID_HIGH     IN VARCHAR2,
33               P_MAIN_ACCT_LOW IN VARCHAR2,
34               P_MAIN_ACCT_HIGH IN VARCHAR2,
35               P_TAS          IN VARCHAR2
36               );
37 --------------------------------------------------------------------------------
38 END FV_GTAS_TBAL_TRX_PKG;