[Home] [Help]
PACKAGE: APPS.JA_CN_UPDATE_JL_SEQ_PKG
Source
1 PACKAGE JA_CN_UPDATE_JL_SEQ_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNVJSS.pls 120.0.12000000.1 2007/08/13 14:09:56 qzhao noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNVJSS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is used to fetch a sequence number |
13 --| for Journal Itemization program |
14 --| |
15 --| PUBLIC PROCEDURE LIST |
16 --| FUNCTION Fetch_JL_Seq |
17 --| |
18 --| HISTORY |
19 --| 03/13/2006 Jackey Li Created |
20 -- 04/28/2007 Qingjun Zhao Add column Ledger_id to table |
21 -- ja_cn_journal_numbering |
22 --+======================================================================*/
23
24 --==========================================================================
25 -- PROCEDURE NAME:
26 -- Fetch_JL_Seq Public
27 --
28 -- DESCRIPTION:
29 -- This procedure is used to fetch a sequence number under the
30 -- Legal Entity and ledger, Period Name for Journal Itemization program
31 --
32 -- PARAMETERS:
33 -- In: p_legal_entity_ID legal entity ID
34 -- p_ledger_id ledger ID
35 -- p_period_name period_name
36 --
37 -- DESIGN REFERENCES:
38 -- CNAO_Update_Journal_Sequence_PKG_TD.doc
39 --
40 -- CHANGE HISTORY:
41 -- 03/13/2006 Jackey Li Created
42 -- 04/28/2007 Qingjun Zhao Add column Ledger_id to table
43 -- ja_cn_journal_numbering
44 --===========================================================================
45 FUNCTION Fetch_JL_Seq(p_legal_entity_ID IN NUMBER
46 ,p_ledger_id in number
47 ,p_period_name IN VARCHAR2) RETURN NUMBER;
48
49 END JA_CN_UPDATE_JL_SEQ_PKG;