1 package JA_CN_ITEMIZATION_INTERFACE AS
2 --$Header: JACNITIS.pls 120.1 2007/12/03 04:19:44 qzhao noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNITIS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is used to import the legacy data user input in |
13 --| interface table. It will validate the journal lines user input |
14 --| and make the data enable to import to table ja_cn_journal_lines. |
15 --| After import these data, call CNAO post program. |
16 --| |
17 --| PROCEDURE LIST |
18 --| |
19 --| PROCEDURE Import_Itemization_Data PUBLIC |
20 --| |
21 --| HISTORY |
22 --| 01/08/2007 yanbo liu Created |
23 --| |
24 --+======================================================================*/
25 l_module_prefix VARCHAR2(100) :='JA_CN_ITEMIZATION_INTERFACE';
26 --TYPE SEGMENTS_TBL IS TABLE OF ja_cn_item_interface.segment1%TYPE;
27 l_Company_Column_Name varchar2(25);
28 l_Account_Column_Name varchar2(25);
29 l_Cost_CRT_Column_Name varchar2(25);
30 l_coa number(15);
31 --==========================================================================
32 -- PROCEDURE NAME:
33 -- Invoice_Category Public
34 --
35 -- DESCRIPTION:
36 -- This procedure is the main program of itemization interface program.
37 -- It will process the data in interface table and import them into
38 -- table ja_cn_journal_lines. At last post journals to ja_cn_account_balances.
39 --
40 -- PARAMETERS:
41 -- P_LEDGER_ID ledger id
42 -- P_LEGAL_ENTITY_ID legal entity id
43 -- P_PERIOD_FROM begin period
44 -- P_PERIOD_TO end period
45 --
46 -- DESIGN REFERENCES:
47 -- None
48 --
49 -- CHANGE HISTORY:
50 --
51 --===========================================================================
52
53
54 PROCEDURE Import_Itemization_Data(Errbuf OUT NOCOPY VARCHAR2,
55 Retcode OUT NOCOPY VARCHAR2,
56 P_LEGAL_ENTITY_ID IN NUMBER,
57 P_LEDGER_ID IN NUMBER,
58 P_PERIOD_FROM IN VARCHAR2,
59 P_PERIOD_TO IN VARCHAR2
60 );
61
62 end JA_CN_ITEMIZATION_INTERFACE;
63
64
65