1 PACKAGE JA_CN_COA_EXP_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNCAES.pls 120.0.12000000.1 2007/08/13 14:09:10 qzhao noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNCAES.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is used for Chart of Accout Export, including |
13 --| Natural Account and 4 Subsidiary Account of "Project", |
14 --| "Third Party", "Cost Center" and "Personnel", in the CNAO Project.|
15 --| |
16 --| PROCEDURE LIST |
17 --| PROCEDURE Coa_Export |
18 --| |
19 --| HISTORY |
20 --| 03/03/2006 Andrew Liu Created |
21 --+======================================================================*/
22
23 --==========================================================================
24 -- PROCEDURE NAME:
25 -- Coa_Export Public
26 --
27 -- DESCRIPTION:
28 -- This procedure calls COA Export programs according to
29 -- the specified account type.
30 --
31 -- PARAMETERS:
32 -- Out: errbuf NOCOPY VARCHAR2
33 -- Out: retcode NOCOPY VARCHAR2
34 -- In: P_COA_ID NUMBER chart of accounts ID
35 -- In: P_LEDGER_ID NUMBER ID of Ledger
36 -- In: P_LE_ID NUMBER ID of Legal Entity
37 -- In: P_ACCOUNT_TYPE VARCHAR2 Type of the account
38 -- In: P_XML_TEMPLATE_LANGUAGE VARCHAR2 template language of NA exception report
39 -- In: P_XML_TEMPLATE_TERRITORY VARCHAR2 template territory of NA exception report
40 -- In: P_XML_OUTPUT_FORMAT VARCHAR2 output format of NA exception report
41 --
42 -- DESIGN REFERENCES:
43 -- None
44 --
45 -- CHANGE HISTORY:
46 -- 03/03/2006 Andrew Liu Created
47 --===========================================================================
48 PROCEDURE Coa_Export( errbuf OUT NOCOPY VARCHAR2
49 ,retcode OUT NOCOPY VARCHAR2
50 ,P_COA_ID IN NUMBER
51 ,P_LEDGER_ID IN NUMBER
52 ,P_LE_ID IN NUMBER
53 ,P_ACCOUNT_TYPE IN VARCHAR2
54 ,P_XML_TEMPLATE_LANGUAGE IN VARCHAR2
55 ,P_XML_TEMPLATE_TERRITORY IN VARCHAR2
56 ,P_XML_OUTPUT_FORMAT IN VARCHAR2
57 );
58
59
60 --PROCEDURE Get_Acc_Subs_View( P_LEDGER_ID IN number );
61
62 END JA_CN_COA_EXP_PKG;
63