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