1 PACKAGE JA_CN_UPDATE_BANK_SEQ_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNUBSS.pls 120.0.12020000.2 2013/02/06 09:05:12 chongwan noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNUBSS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is used to fetch a sequence number |
13 --| for Journal export program |
14 --| |
15 --| PUBLIC PROCEDURE LIST |
16 --| FUNCTION Fetch_JL_Seq |
17 --| |
18 --| HISTORY |
19 --| 15-Oct-2012 Jar Wang Created |
20 --+======================================================================*/
21
22 --==========================================================================
23 -- PROCEDURE NAME:
24 -- Fetch_JL_Seq Public
25 --
26 -- DESCRIPTION:
27 -- This procedure is used to fetch a sequence number under the
28 -- Legal Entity and ledger, Period Name for Journal Export program
29 --
30 -- PARAMETERS:
31 -- In: p_legal_entity_ID legal entity ID
32 -- p_bsv balance segment value
33 -- p_ledger_id ledger ID
34 -- p_period_name period_name
35 --
36 -- DESIGN REFERENCES:
37 -- CNAO_Journal_Voucher_Number_TD.doc
38 --
39 -- CHANGE HISTORY:
40 -- 05-Oct-2012 Jar Wang Created
41 --===========================================================================
42 FUNCTION Fetch_JL_Seq(p_legal_entity_ID IN NUMBER,
43 p_bsv IN VARCHAR2,
44 p_ledger_id in number,
45 p_period_name IN VARCHAR2) RETURN NUMBER;
46
47 END JA_CN_UPDATE_BANK_SEQ_PKG;
48