PACKAGE: APPS.JA_CN_JE_EXPORT_PKG

Source

1 PACKAGE JA_CN_JE_EXPORT_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNJOES.pls 120.1 2011/02/25 09:13:09 jiachi noship $
3 --+=======================================================================+
4 --|               Copyright (c) 2010 Oracle Corporation
5 --|                       Redwood Shores, CA, USA
6 --|                         All rights reserved.
7 --+=======================================================================
8 --| FILENAME
9 --|     JACNJOES.pls
10 --|
11 --| DESCRIPTION
12 --|
13 --|     This package contains the following PL/SQL tables/procedures/functions
14 --|     to export Journal which already post in the CNAO Itemized Journal table.
15 --|
16 --| PROCEDURE LIST
17 --|   		Add_Journal
18 --|
19 --| HISTORY
20 --|   18-Mar-2010     Wei Huang Created
21 --|
22 --+======================================================================*/
23   TYPE assoc_array_varchar1000_type IS TABLE OF VARCHAR2(1000) INDEX BY PLS_INTEGER;
24   prefix_a CONSTANT VARCHAR2(10) := 'A';
25 --==========================================================================
26 --  PROCEDURE NAME:
27 --
28 --    Add_Journal               Public
29 --
30 --  DESCRIPTION:
31 --
32 --      This procedure is to export Journal which already post in the
33 --      CNAO Itemized Journal 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 --     18-Mar-2010     Wei Huang Created
50 --
51 --===========================================================================
52 PROCEDURE 	Add_Journal
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_JE_EXPORT_PKG;