[Home] [Help]
PACKAGE: APPS.JA_CN_APAB_EXPORT_PKG
Source
1 PACKAGE JA_CN_APAB_EXPORT_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNPBES.pls 120.1 2011/02/11 10:22:00 choli noship $
3 --+=======================================================================+
4 --| Copyright (c) 2010 Oracle Corporation
5 --| Redwood Shores, CA, USA
6 --| All rights reserved.
7 --+=======================================================================
8 --| FILENAME
9 --| JACNPBES.pls
10 --|
11 --| DESCRIPTION
12 --|
13 --| This package contains the following PL/SQL tables/procedures/functions
14 --| to export Accounting Period Amount and Balance which already post in
15 --| the CNAO Itemized balance table.
16 --|
17 --| PROCEDURE LIST
18 --| Add_Account_Amount_Balance
19 --|
20 --| HISTORY
21 --| 04-Mar-2010 Wei Huang Created
22 --|
23 --+======================================================================*/
24 prefix_a CONSTANT VARCHAR2(10) := 'A';
25 --==========================================================================
26 -- PROCEDURE NAME:
27 --
28 -- Add_Account_Amount_Balance Public
29 --
30 -- DESCRIPTION:
31 --
32 -- This procedure is to export Accounting Period Amount and Balance
33 -- which already post in the CNAO Itemized balance table.
34 --
35 -- PARAMETERS:
36 -- In: pn_legal_entity_id LEGAL_ENTITY_ID
37 -- pn_ledger_id Ledger ID
38 -- pv_accounting_year Accounting Year
39 -- pn_coa_id Chart of Accounts ID
40 -- pv_period_from Period From
41 -- pv_period_to Period To
42 --
43 -- Out:
44 --
45 -- DESIGN REFERENCES:
46 --
47 --
48 -- CHANGE HISTORY:
49 -- 01-Mar-2010 Wei Huang Created
50 --
51 --===========================================================================
52 PROCEDURE Add_Account_Amount_Balance
53 (pn_legal_entity_id IN NUMBER
54 ,pn_ledger_id IN NUMBER
55 ,pv_accounting_year IN VARCHAR2
56 ,pn_coa_id IN NUMBER
57 ,pv_period_from IN VARCHAR2
58 ,pv_period_to IN VARCHAR2
59 );
60
61 END JA_CN_APAB_EXPORT_PKG;